Statspack Analyzer :: HomeForum Name Topics Posts Last Post General General Board & Announcements Moderator: Philip 1 1 on Jul 20, 2011, 5:42amSQL Statistics Statspack Analyzer Comments You can talk about anything here Moderator: Philip 15 44 on Apr 15, 2011, 6:42pmsteps to analize stats... 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 10 on Sept 10, 2008, 6:12ammikerault 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 50 on Dec 21, 2009, 10:16amPhilip 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. 12 24 on Oct 14, 2008, 12:28amrajasekaran18 hI - Cpu is hitting More 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 17 on Feb 17, 2009, 4:43pmFeedback 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 12 on Oct 28, 2008, 11:28pmwowposter Feedback for High Cach... Load Profile (9 sub-boards) Oracle gurus, please help us improve the Statspack Analyzer by providing feedback to these rules in the forum. 11 23 on Mar 10, 2009, 7:55ammikerault Rollback per transacti... 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 25 on Sept 25, 2008, 5:33pmstevencallan Feedback for High SQL ...
Info Center Forum Statistics 0 Members, 1 Guest. Most users online was 37, Jun 21, 2008, 8:06pm
Active Users In The Past 24 Hours
Login Login with your social network or forum account:
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://s2.images.proboards.com/menu/home.gif "[Home]")
![[New Topics]](http://s2.images.proboards.com/menu/topics.png "[New Topics]")
![[Help]](http://s2.images.proboards.com/menu/help.gif "[Help]")
![[Search]](http://s2.images.proboards.com/menu/search.gif "[Search]")
![[Login]](http://s2.images.proboards.com/menu/login.gif "[Login]")
![[Register]](http://s2.images.proboards.com/menu/register.gif "[Register]")
![[ ]](http://s2.images.proboards.com/off.gif)
