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 reentered.
To disable all events, [...]
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
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
v$lock l,
v$session s,
v$rollname r
WHERE
l.sid = s.sid(+) AND
trunc(l.id1/65536) = r.usn AND
l.type = ‘TX’ [...]
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
[...]
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 files)
• System state dumps
• Process state dumps
On-Error Dump Events
On-error [...]
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> list archivelog from time [...]