|
||||
|
We all know that CGS (when 10g CRS uses, its OCSSD), (When used third party clusterware, CM) will provide Cluster group service which manages nodes integrity and restart them when there is node level (hardware,network,OS, scheduling) issues happens. So it means the CGS will manage the node level issues and also manages the cluster […] In general you will need to set the SQL trace or events (10046,10053) and run the problematic query and can obtain the sql execution statistics to trace files. or […] Q1. Can we get old statistics restored for an object for example for a index or a table ? Yes we can get the old statistics restored from Oracle version 10g onwards.However, if you use ANALYZE for statistics collection in 10g, automatic saving is not possible. Q2. If so, where do the statistics history stored […] 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 / […]
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 […] Q: is it my possible to make my query to change from “select ‘what is my name’ from dual” to “select ‘you’r Geek DBA’ from dual” during execution. A: this feature is called “query equivalence”. query equivalence is declared using the dbms_advanced_rewrite.declare_rewrite_equivalence procedure, and uses the syntax: dbms_advanced_rewrite.declare_rewrite_equivalence(declaration_name,source_statement,target_statement); |
||||
Oracle 23c New Features for DBA's
Follow Me!!!