Explain SQL execution plan
List analyzed tables with not-analyzed indexes
List all indexes for a given table
Analyze all table and index partitions individually
Disaply Table Locks & Latches
List Active Database Transactions
Report Free Memory available in SGA
Calculate Database Hit Ratio
Quick Database Performance Review (incl. major indicators)
Free SGA Memory usage
Explain Plan Template
PIN all Database Packages
Database Block Buffer usage
Latch Contention
Cost of current Open Cursors
Calculate Session Hit Ratio
Calculate Session Details
SQL Test of Database Locks
Tune Multi-threaded Contention
Monitor Database Locks & Details
Monitor all Database DEADLOCKS
Monitor what users are doing in Rollback Segments
Monitor Key Statistics for Open Cursors
Monitor SQL AREA
List Analyzed tables with non-analyzed indices
Tune I/O with FILE_MULTIBLOCK_READ_COUNT
MORE
BACK TO SCRIPTS INDEX
About Us | Membership Details | Contact us | Privacy | Disclaimer | Site Map Copyright © 2002-2005 OracleSource.net. All Rights Reserved. OracleSource.net is not affiliated with Oracle Corporation.
Partner Sites: MCSE Study Guides | Free Oracle 10g Training | Free Cisco Braindumps | Cisco CCNA Practice Tests, Mock Tests | Free Comptia A+ Sample Questions | Free MCSE Exam Simulators | Free Interview Questions | Free MCSE Torrents | Free Java Interview Questions | Free .net Interview Questions | Free Certification Tutorials | Cheap Travel Deals | Discount Vouchers | Free Financial Advice | Designer Perfumes | Calvin Klein Pefumes | Electronics | Diamond & Jewelry | Video Games Designer Handbags
