Events and the SPFILE
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Using the ALTER SYSTEM SET EVENT command always results in a static change; specifying the SCOPE=MEMORY clause is not allowed. The events use the syntax described earlier, but only the concatenated form is allowed if there are multiple events. To disable or alter a single event in a list, the whole list has to be [...]
Read More..>>How to remove oracle in unix/linux
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
First,pls stop all the orace services,then remove the following directories 1)Remove $ORACLE_HOME 2)Remove $ORACLE_BASE/oraInventory 3)Remove /tmp/OraInstall* 4)Remove /usr/local/bin/dbhome 5)Remove /usr/local/bin/oraenv 6)Remove /usr/local/bin/coraenv 7) Remove /etc/oratab
Read More..>>Oracle dba’s scripts
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
1.Description: This script will display the active user and the rollback segment being used in the database. Code: column rr heading ‘RB Segment’ format a18 column us heading ‘Username’ format a15 column os heading ‘OS User’ format a10 column te heading ‘Terminal’ format a10 SELECT r.name rr, nvl(s.username,’no transaction’) us, s.osuser os, s.terminal te FROM [...]
Read More..>>Gets and pins in oracle
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Within the shared pool, there are 2 types of data structures used for concurrency control: locks (gets) and pins. A lock has a higher level than a pin and must be acquired before attempting to pin an object. Locks can be thought of as parse locks while pins can be thought of as short-term locks [...]
Read More..>>Understand events of oracle
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
Four Event Categories 1. Dump diagnostic information on request 2. Dump diagnostic information when an error occurs 3. Change database behavior 4. Produce trace diagnostics as the database runs Immediate Dump Events Immediate dump events dump diagnostic information to a trace file. Common immediate dumps are: • File headers (control file, redo log files, data [...]
Read More..>>Oracle DBA Interview Questions
Posted on May 8, 2008 - Filed Under Other | Leave a Comment
1. How many memory layers are in the shared pool? The shared pool consists of the library cache and the dictionary cache. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? RC_BACKUP_REDOLOG or 1) backup set RMAN> list archivelog all | from … until….. e.g RMAN> [...]
Read More..>>