Scribd
Upload
24 views1 page

Backup Query

Uploaded by

aribrabbani2
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
24 views1 page

Backup Query

Uploaded by

aribrabbani2
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

webadmin.

backup_list col- backup_log id chk backup_table recrd there or not


# Session max:

SELECT
RESOURCE_NAME,
CURRENT_UTILIZATION,
MAX_UTILIZATION,
LIMIT_VALUE
FROM
V$RESOURCE_LIMIT
WHERE
RESOURCE_NAME = 'sessions';

# Trace File Location:

SELECT * FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

# Flush shared pool:

alter system flush shared_pool;

DELETE TRACE:
# find . -name "*.bz2" -mtime +2 -exec rm {} \;

# tail -100f alert_aribdb.log

#command to reduce its size to 500m: journalctl --vacuum-size=500M

# DATAGUARD GAP :

SELECT a.thread#, b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-


a.applied_seq
2 ARC_DIFF FROM (SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time)
last_app_timestamp
FROM gv$archived_log WHERE applied = 'YES' GROUP BY thread#) a, (SELECT thread#,
MAX (sequence#)
3 4 last_seq FROM gv$archived_log GROUP BY thread#) b WHERE a.thread# =
b.thread#

You might also like