Modern Oracle DBA

We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...

Top Command Analysis Top command is used to show the Linux process This command shows the summary information of the system and the list of process which are currently managed by the kernel Top command we need to check two session summery session and task session Summery session System Time, Up time and user session Load average Tasks CPU usage Memory Usage System Time, Up time and user session top - 11:59:39 up 225 days, 22:31, 136 users, System time: 11:59:39 Up time: up 225 days, 22hrs:31min User session: 136 users connected. Load average Load average is the system load calculated over given period 1,5 and 15 minutes Load average have 3 sessions Load average: 4.43, 4.14, 4.03 Load average over last 1 minutes is 4.43 Load average over last 5 minutes is 4.14 Load average over last 15 minutes is 4.03 The high load average that system is overloaded many processes are waiting for CPU time Tasks Tasks session showing how many processes runni...

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_SES...

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...

Before jumping into actual patching, it helps to understand the technology stack behind Oracle E-Business Suite (EBS) 12.2 patching. This includes the tools used for each component. This post gives a quick background on Application Technology patches, with a focus on the WebLogic Server (BSU) patching process. What Are Application Technology Patches? Application Technology patches cover the middle-tier components of EBS 12.2 and are applied using different utilities depending on the component: Component Home Patching Tool Oracle HTTP Server (OHS) OHS Home OPatch Oracle WebLogic Server FMW Home BSU (Smart Update) Oracle Forms (10.1.2 ORACLE_HOME) Forms Home OPatch These patches can be applied directly on the Run edition , after which adop fs_clone is executed to sync the file system. Alternatively, they can be applied through the standard Patch edition cycle as part of an adop patching session. Applying Middle Tier ETCC Patches As part of routine maintenance, two key patch categories...

  Awr report is automatic workload repository It’s introduced in oracle database 10G This report stores data in sysaux tablespace AWR report background process is MMON(Manageability monitor) and MMNL. AWR report collects, process and maintenance performance statists. It can’t give any recommendations. It’s retain the stats for 8-days by default. How to generate AER report cd $ORACLE_HOME/rdbms/admin Report Name SQL Scripts AWR Report awrrpt.sql Automatic DB Diagnostics Monitor report addmrpt.sql ASH Report ashrpt.sql AWR Diff periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql   AWR report Analysis We can’t analysis the all details in AWR report because It’s contains much data I...