|
||||
|
Happy Reading!!! Hope you already aware of tracing sessions with different methods 11g onwards, you can trace a session (other session) with in the alter system command itself , no worries of finding pid etc etc. for example like below SQL> alter session set events ‘sql_trace {process : pid = <pid>, pname = <pname>, […]
How to purge a single statement from shared pool? Additional info. (Thanks to my friend colleague for updating about the version its possible and the event) For 10g. The enhanced DBMS_SHARED_POOL package with the PURGE procedure is included in the 10.2.0.4 patchset release. 10.2.0.2 and 10.2.0.3 customers can download and install RDBMS patch […]
Which background daemon writes to OCR disk? or the voting disk? CRSD? Answer No CRSD just read the OCR to know about its resources. Its OCSSD under the following conditions , Oracle cluster synchronization service daemon (OCSSD) is responsible for Writing to OCR registry. a. New Node Addition /Deletion b. New Service Addition / […]
Just an excerpt from the Documentation/Note as a ready reference who reads this post. Oracle Wait events can be divided into two categories , that is idle (IDLE) to wait for events and non-idle (NON-IDLE) . 1) Idle wait event represents ORACLE is waiting on some work at the time of diagnosis […] Want to know new features in 12c, 18c, 19c, 20c ??? Follow this More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/ More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/ More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/ Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/ […]
Why you need to increase the cache size of sys.audsess$ sequence in RAC? Answer:- Background:- In oracle database every session must have an AUDSID (v$session.audsid) when the session spawns/created in database, this number is derived from a sequence called sys.audsess$ where the cache option set to 20 and noorder. When you have an database […] All, Please find the structured 11gR2 GI Clusterware log locations and its relevancy. Directory structured (Source: Oracle Documentation) Log Locations […] Hello, Today I have got a call containing couple of questions on streams replication in a standby environment especially when the streams is on downstream capture database. Here are the questions & my answers to it. Environment:- Primary or Source: -10GR2 RAC with 2 node Standby: Physical Standby Streams: Downstreams capture database in different server […]
This is about to understand the startup sequence of Grid Infrastructure daemons and its resources in 11gR2 RAC.
In 11g RAC aka Grid Infrastructure we all know there are additional background daemons and agents, and the Oracle documentation is not so clear nor the other blog.
For example:- I have found below […] Dear All, Prior to 11g, in order to purge the audit trails we have to write a custom script and run in a cron or control M scheduler job or a DBMS_SCHEDULER, where in From 11g 11.1.0.7 onwards Oracle provides a package DBMS_AUDIT_MGMT to manage the audit trails. Additionally, This package can also be […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!