Oracle DBA Support

Search This Blog

Manually Run ADDM in 2 snapshots using script

April 03, 2025

Get link
Facebook
X
Pinterest
Email
Other Apps

Manually Run ADDM in 2 snapshots using script

For Standalone DB

@?/rdbms/admin/addmrpt.sql

For RAC DB

@?/rdbms/admin/addmrpti.sql

ADDM Oracle Performance Tuning

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Kill user session in Oracle Database

Kill user session in Oracle Database select 'alter system kill session '''||sid||','||serial#|| ''' immediate;' from v$session where osuser='&username';

How to use log miner in Oracle Database

How to use log miner in Oracle Database SELECT * FROM V$ARCHIVED_LOG WHERE FIRST_CHANGE# <= 12435785206731 AND NEXT_CHANGE# >= 12435785206731; EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => 'arch file', - OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.START_LOGMNR( - OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID, SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS where XIDUSN=49 and XIDSLT=25 and XIDSQN=22415431; EXECUTE DBMS_LOGMNR.END_LOGMNR();

How to get Oracle database directories details

Get Oracle Database directories details SQL> desc dba_directories; Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(128) DIRECTORY_NAME NOT NULL VARCHAR2(128) DIRECTORY_PATH VARCHAR2(4000) ORIGIN_CON_ID NUMBER set linesize 190 col owner for a30 col ...

Powered by Blogger

Manually Run ADDM in 2 snapshots using script

Manually Run ADDM in 2 snapshots using script

Comments

Post a Comment