Oracle DBA Tweets .... Learning is Fun-tastic

Oracle DBA Tweets .... Learning is Fun-tastic .... You must stop talking about the problem and start talking about the solution, start speaking words of victory. We should never stop working on ourselves. Always be positive and keep smiling..have a great day friends :) Source: Internet

August 25, 2017

CPU consumptions by ACTIVE sessions

-- -- Show CPU Usage for Active Sessions -- SET PAUSE ON SET PAUSE ' Press Return to Continue ' SET PAGESIZE 60 SET L...

Getting Session Details | sid.sql

col sid format 99999 col username format a10 col osuser format a10 col program format a25 col process format 9999999 col spid format 9...

June 22, 2014

Tablespace Utilization Script for Tablespace Space Used % more than 80 %

Oracle Tablespace Utilization Script (including AUTOEXTEND) for generating report of more than 80 % used tablespaces (IN GB) 1. Check the...

How to generate Multiple AWR reports

Multiple AWR report generation script The following script can be used for AWR reports generation, for specific intervals between the req...

How to check AWR interval and retention Settings

AWR interval and retention Settings The following query can be used to check the current settings for the AWR interval and AWR retention....

Database health checks in Oracle

Performing Database health checks, when there is an issue reported by Application users. 1. Check the Database details 2. Monitor the co...

How to check RMAN backup job status in Oracle using v$rman_backup_job_details

RMAN backup job details for 'n' number of days:- ========================================= Monitoring RMAN backup status usin...

View web version

Powered by Blogger.