Oracle DBA – Tips and Techniques

Knowledge Is Power - Share IT!

Comments Posts

My Blogs
About
Oracle GoldenGate
Oracle Virtual Machine
Documents and Whitepapers
Presentations
Recovery Scenarios
Unix for the DBA
Notes

That’s Me

Oracle Certified Professional

7.3, 8i, 9i,10g, 11g

11i Apps DBA OCP

10g RAC OCE

Certified GoldenGate Implementation Specialist

10g OCM

11g OCM

Feedback

2,409,840 hits

Thanks A MILLION for your support!

Please send me your valuable feedback and suggestions

Administration

Register
Log in
Entries RSS
Comments RSS
WordPress.org
[Un]Subscribe to Posts

DBUPGDIAG script to check integrity of database before 11g upgrade

August 20th, 2009 | Tags: 11g upgrade, dbupgdiag | Category: Scripts | Leave a comment

Script – Check RMAN Backup Status

July 28th, 2009 | Tags: backup report, backup status, rman | Category: Administration, Backup and Recovery, Scripts | One comment

Script – Sessions with high physical reads

July 9th, 2009 | Tags: i/o, physical reads, top sessions, v$session, v$sess_io | Category: Performance Tuning, Scripts | Leave a comment

Script – Monitor Flashback Logs

July 9th, 2009 | Tags: fkashback area usage, flashback, flashback database, flashback log, monitor, reclaimable space, v$recovery_file_dest | Category: Monitoring | Leave a comment

Script – Database structure and file location

July 7th, 2009 | Tags: controlfile, database layout, database structure, datafile, redo log file | Category: Scripts | Leave a comment

Script – Tablespace free space and fragmentation

July 7th, 2009 | Tags: dba_free_space, extents, fragmentation, free space, tablespace | Category: Scripts | One comment

Data Guard Switchover Unix shell script

July 6th, 2009 | Tags: data guard switchover, switchover | Category: High Availability, Scripts, Unix | Leave a comment

Script – Latch Contention (top 5 latches)

July 6th, 2009 | Tags: latch, misses, sleeps, v$latch | Category: Performance Tuning, Scripts | Leave a comment

Script – Top SQL (Physical Reads)

July 6th, 2009 | Tags: disk reads, physical reads, top sql | Category: Performance Tuning, Scripts | Leave a comment

Script – Top SQL (Buffer Gets)

July 6th, 2009 | Tags: buffer gets, logical reads, top sql | Category: Performance Tuning, Scripts | Leave a comment

Script – Segments with highest I/O activity

July 6th, 2009 | Tags: physical reads, physical writes, top segments, v$segment_statistics | Category: Administration, Performance Tuning, Scripts | Leave a comment

Script – List status of all submitted DBMS jobs

July 3rd, 2009 | Tags: broken, dbms_job, job., status | Category: Scripts | Leave a comment

Script – What Wait Events Are Sessions Waiting On

July 2nd, 2009 | Tags: wait, wait event, wait_class | Category: Performance Tuning, Scripts | Leave a comment

Script – Sessions Waiting On A Particular Wait Event

July 2nd, 2009 | Tags: v$session_wait, wait event, wait interface | Category: Performance Tuning, Scripts | Leave a comment

Script – Datafiles with highest I/O activity

July 1st, 2009 | Tags: datafile I/O, phyrds, phywrts, read, writes | Category: Performance Tuning, Scripts | Leave a comment

Script – Find SQL being executed by a OS Process ID (PID)

July 1st, 2009 | Tags: os process id, pid, sql, sql text, v$sql | Category: Scripts | One comment

Script – List SQL being executed by a particular SID

July 1st, 2009 | Tags: current SQL, sql text, v$sql | Category: Scripts | Leave a comment

Script – Monitor sessions with high Physical Reads

July 1st, 2009 | Tags: high I/O, physical reads, v$sess_io | Category: Scripts | Leave a comment

Script – Query the RMAN catalog to list backup completion status

July 1st, 2009 | Tags: backup status, query catalog, rman, rman catalog | Category: Scripts | Leave a comment

Script – List all recent DDL modifications

July 1st, 2009 | Tags: ddl, last_ddl, modification, recent ddl | Category: Scripts | Leave a comment

Older Entries »

That’s Us

24x7 Remote/Onsite DBA Support

Performance Auditing

Security Auditing

High Availability Solutions

Disaster Recovery

Database Upgrades & Migrations

Data Migration using GoldenGate

More about our services ...

Search

Scripts
Oracle GoldenGate