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 | SEO Sitemap | 2 | 3 | 4 | 5 | 5 | 6 Copyright © 2002-2007 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 | Discount Technology Books & Software | Free .net Interview Questions | Free Certification Tutorials | Cheap Travel Deals | Discount Vouchers | Free Financial Advice | Designer Perfumes | Calvin Klein Pefumes | Electronics | Designer Authentic Watches | Cheap Video Games | Designer Handbags | Send Fresh Flowers Online | Men's Authentic Colognes | Designer Sunglasses | Discount Baby Products Website Design, Developed & SEO by InternetWiz