|
||||
|
Hello, This is the second part of the series of Performance Troubleshooting, Whilst the first one is from AWR/Statspack tables. And what if , if you don’t have both in your environment, That made me to write up this second post. Those who does not know about the metrics tables a short notes here, After […] Hello, Very long back, Karlarao has written a wonderful script which delivers a exhaustive report for database performance. The script extracts the data from AWR repository tables. Where in I have took liberty to tweak the same script for those who does not have AWR licensing and having statspack only. Here is the script […] Ever, interested in looking for statistics staleness for each table including how much percent they stale are. The following query helps you to get you the details. This query filter out the staleness for those tables which having more than or equal to 10%, you can adjust accordingly. However, you will need to […] If you are working a production support DBA and very often you will need to check the statistics of the table and how much change what changed in each columns etc. I have figured out two ways for it and seems very useful. Option 1:- 11gR1 has a package to show differences and comparison of […] The situation is, and you just logged 🙂 1. DB Response is slow 2. Top/OEM/Graphs show your database host CPU is pegged to 100%, and (no other things running apart from db) 3. Unfortunately you do not have Active Session History, to fire a magical script , 5 minutes back, 10 minutes back, 4. […] Does any knows about flushing the PGA? Actually it can, not quite sure of release memory or not as it depends on high water mark (as like you try to shrink the datafile and it fails) similarly the following procedure also may not work if a memory chunk sitting at the edge of high water […] Not strange though, but well possible to get into trap of permission issue from 11gr2 GI since the user separation (GI Owner, RDBMS Owner) and the additional groups (asmadmin, asmoper etc) has created lots of mess around, especially when you are not good in selecting the right groups/owners in the installation. I have been told […] Well , we have got an issue that one of the node is not starting up , its a two node GRID Infrastructure and the logs shown as below in crs alert_rac01.log CRSD not started – unable to locate OCR in gipcd.log 2014-09-10 06:23:00.186: [ GIPC][1117619840] gipcCheckInitialization: possible incompatible non-threaded init from [prom.c […] Convert Single Instance (ASM) to RAC Instance (ASM) to different Server Assuming you have already the following environment setup and ready 1. 11gr2 Clusterware is already installed on your target machine (XYZ) 2. Target xyz is configured with +DATA as diskgroup 2. Source ABC is having single instance in ASM […] Whilst adding a node failing with following errors in the addnode.log INFO: /u01/app/11.2.0.4/grid/oui/bin/../bin/lsnodes: struct size 0 INFO: Vendor clusterware is not detected. INFO: Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured. SEVERE: Error ocurred while retrieving node numbers of the existing nodes. Please check if […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!