Statspack Analyzer :: HomeForum Name Topics Posts Last Post General General Board & Announcements Moderator: Philip 0 0 Statspack Analyzer Comments You can talk about anything here Moderator: Philip 7 27 on May 27, 2008, 9:45ammikerault1 Comparison between SSD... Statspack Analyzer Rules List Buffer Pool Advisory Oracle gurus, please help us improve our Statspack Analyzer by providing comments to the V 2.0 rules in these forums. 1 5 on Jun 1, 2008, 10:47ammikerault1 Buffer Pool Advisory Init.ora (20 sub-boards) Oracle gurus, please help us improve our Statspack Analyzer by giving us feedback on the rules in these forums. 21 47 on Jun 2, 2008, 9:47ambscalzo Feedback for Not Using... Instance Activity (10 sub-boards) Oracle gurus, please help us improve our Statspack Analyzer by providing comments on the rules posted in these forums. 11 23 on Jul 22, 2008, 7:19ammikerault Feedback for Table Fet... Instance Efficiency (7 sub-boards) Oracle gurus, please help us improve our Statspack Analyzer by proving feedback on the rules listed in these forums. 8 15 on Mar 24, 2008, 11:46amPhilip Feedback for Shared Po... Latch Activity (5 sub-boards) Oracle gurus, please help us improve the Statpack Analyzer by providing feedback on the rules in these forums. 6 11 on Mar 24, 2008, 10:11amPhilip Feedback for High Redo... Load Profile (9 sub-boards) Oracle gurus, please help us improve the Statspack Analyzer by providing feedback to these rules in the forum. 10 19 on Mar 24, 2008, 9:39amPhilip Feedback for High Buff... PGA Memory Oracle gurus, please help us improve Statspack Analyzer by providing feedback on the rule in this forum. 1 2 on Mar 20, 2008, 4:44pmPhilip Feedback for PGA Memor... Shared Pool Oracle gurus, please help us improve the Statspack Analyzer by providing feedback on this rule in our forum. 1 2 on Mar 20, 2008, 4:56pmPhilip Feedback for Shared Po... Wait Events (10 sub-boards) Oracle gurus, please help us improve the Statspack Analyzer by providing feedback on the rules in these forums. 11 24 on Jun 1, 2008, 10:43ammikerault1 Feedback for High DB F...
Info Center Forum Statistics 0 Members, 2 Guests. Most users online was 37, Jun 21, 2008, 8:06pm
Active Users In The Past 24 Hours
Forum Jump -------------------- » Home -------------------- » General -------------------- - General Board & Announcements - Statspack Analyzer Comments -------------------- » Statspack Analyzer Rules List -------------------- - Buffer Pool Advisory - Init.ora --- Not Using Big Blocks --- DB Cache Size Too Low --- Db_File_Multiblock Read --- DB Keep Cache Size --- Hash Area Size --- Hash Join Enabled --- MTS Servers --- MTS Servers #2 --- Optimizer_index_caching --- Optimizer_index_cost_adj --- Optimizer_mode --- Parallel_Automatic_Tuning --- Pga_Aggregate_Target --- Pga_Aggregate_Target_2 --- Query_Rewrite_Enabled --- Shared_Pool_Size --- Shared_Pool_Size_2 --- Sort_Area_Size --- Old init_dot_ora Params --- Sort_Area_Size_2 - Instance Activity --- SQL *Net Roundtrips to/from Client --- DB Block Changes per Trans Too High --- Physical Writes Are Too High --- Physical Reads Are Too High --- Table Scans - (short tables) --- Table Scans - (long tables) --- Workarea Executions - onepass --- Sorts (disk) --- Table Fetch Continued Row --- Consistent Gets - Examination - Instance Efficiency --- Buffer Hit Ratio --- Library Hit Ratio --- In-memory Sorts --- Latch Hit Ratio --- Buffer Nowait LRU Contention --- Hot Blocks in Buffer Cache --- Shared Pool Memory Usage - Latch Activity --- High Cache Buffer Chains Miss rule --- High Cache Buffer Lru Chains Miss rule --- High Library Cache Miss --- High Redo Allocation --- High Redo Copy - Load Profile --- Excessive Soft Parses --- Excessive Hard Parses --- High Logical I/O --- High Physical Reads --- Excessive Rollbacks per Transaction --- Slow Physical Writes --- Buffer Contention - LRU --- Buffer Contention - Chains --- High Buffer Contention SGA - PGA Memory - Shared Pool - Wait Events --- High Free Buffer Wait Time --- High Latch Free Wait Time --- High Log Buffer Space Wait Time --- High Log File Switch Completion Wait --- High Log File Sync Wait Time --- High SQL *Net Message From Client --- High DB File Sequential Read Wait --- High DB File Scattered Read Wait --- High Enqueue Wait Time --- High Buffer Wait Time
![[Home]](http://s3.images.proboards.com/menu/home.gif)
![[Help]](http://s3.images.proboards.com/menu/help.gif)
![[Search]](http://s3.images.proboards.com/menu/search.gif)
![[Login]](http://s3.images.proboards.com/menu/login.gif)
![[Register]](http://s3.images.proboards.com/menu/register.gif)
![[ ]](http://s3.images.proboards.com/off.gif)
