Oracle DBA Support

Search This Blog

how to get invalid objects in Oracle Database

September 28, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

Get invalid objects in Oracle Database

select count(*) from dba_objects where status='INVALID';

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

how to get invalid objects in Oracle Database

Get invalid objects in Oracle Database

Comments

Post a Comment