Modern Oracle DBA

What is ASH report? Active session history Sampled active session for into memory buffer every second (V$ACTIVE_SESSION_HISTORY) Collect active session data only Writing to disk by AWR snapshots (DBA_HIST_ACTIVE_SESS_HISTORY) Part of oracle 10g database   How ASH work? If example oracle standard program used to run in 5-second now which taking mort hen 10-min need to check that particular sql query why taking 10-min. For AWR report never show this type of performance issue. Awr report showing only top SQL We can find this kind of issues in ASH report. Using ASH report can perform detailed analysis V$ACTIVE_SESSION_HISTORY view and DBA_HIST_ACTIVE_SESS_HISTORY view   V$ACTIVE_SESSION_HISTORY displays sampled session activity in the database. It contains snapshots of active database sessions taken once a second. For V$Activite_session_history table holed data for only one hour Whatever data in v$activie_session_history will write DBA_HIST_ACTIVE_SESS_HISTORY

Sometime after upgrade, cloning and patching front end login page is not opening showing blank page or showing “ java.lang.StringIndexOutOfBoundsException ” error. This issue was occurring due to cache is not cleared after upgrade/Cloning JSP Compilation steps Step 1: Shutdown the application services Step 2: Take backup for the _Page(class file) folders $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> a $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> $ mkdir _pages $ ls -lrt Step 3: Run the below command $ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 99 Step 4: Start the application and clear browser cache. After completed the JSP compilation home page not coming please clear the image and style sheet cache also Cabo Images and style sheets can be corrupted or out of sync in the cabo caches, you may need to clear the related directories after backup: Step1: Shutdown the services