|
||||
|
Here is the script and snippet of Average Active Sessions plotted by Hour in Oracle database. This is similar to Oracle Log switch history. This helps DBA to understand the hourly metric of AAS and determine any spikes of the active sessions for the problematic period or gather some particular trend of AAS. […] Update: 17 nov. AWS announced the cloudwatch metrics now stores until 15 months read this. Oh AWS world its ever chaning….. https://aws.amazon.com/about-aws/whats-new/2016/11/cloudwatch-extends-metrics-retention-and-new-user-interface/ all aware, AWS CloudWatch metrics only hold for two weeks in console and beyond that you cannot analyse what happened unlike our other monitoring tools. For those who are new to RDS […] Another nice performance tool from Oracle which process real time sessions and shows in nice output. Here it is
A very simple elegant, light weight tool to monitor the performance of the database, Just copy the executable from the note 1500864.1 and set your environment and run the command to monitor […] Hi, When you need to run something like a check of parameter in all databases in a server and if you have more databases, manually doing will be cumbersome. Here is the script that helps to connect to all databases in a server by reading /etc/oratab (linux) and then change a parameter streams pool to […] Sometimes You may require to check the dependencies for the resources for example to stop a ASM you will need to find what are the dependent resources in CRS or to change a vip what are the dependent resources associated with it to bring them down and perform your activity like chaning vip etc. To […] The question is tricky, I have asked accessed not modified/changed. If so modified/changed dba_tab_modifications can give you a clue. For both of this questions, the below query will help. Table is in use or not? This question may arise from App team that they have released a new module which may not require certain tables […] Hi, Suppose you have been asked about how much reads/writes happening and what are the wait events that occured for a object(table) in a given period or overall. so then read on…. We have different ways to get the Table level statistics like waits/reads/logical reads/physical reads /writes etc.
1) In Oracle 8i […] OMS (Enterprise Manager) is generating huge quatity of logs. Logs generated by the Grid Infrastructure are spread across modules. There are logs for http Apache module, log for Infrastructure, agents logs and traces, opmn logs etc. Here are the location of logs that use a lot of disk space: 1) Agent Log and Trace Files: […] Hello All, Sometimes we were been asked to provide the object or a table growth, Here is some nice script, which is useful to find the table growth per day for a given table; select obj.owner, obj.object_name, to_char(sn.BEGIN_INTERVAL_TIME,’RRRR-MON-DD’) start_day, sum(a.db_block_changes_delta) block_increase from dba_hist_seg_stat a, dba_hist_snapshot sn, dba_objects obj where sn.snap_id = a.snap_id and obj.object_id = […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!