The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
Google UNIX.COM


UNIX for Advanced & Expert Users Advanced UNIX and Linux questions go here. Expert-to-Expert.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Statspack Script user__user3110 Shell Programming and Scripting 1 05-26-2008 12:18 AM
help me in sending parameters from sqlplus script to unix shell script Hara Shell Programming and Scripting 2 01-29-2008 12:31 PM
Shell Script: want to insert values in database when update script runs ring Shell Programming and Scripting 1 10-25-2007 12:06 AM
how to convert unix .ksh script to windows .batch script 2.5lt V8 Shell Programming and Scripting 1 11-28-2006 09:52 AM
check in unix shell script so that no one is able to run the script manually adi_bang76 Shell Programming and Scripting 1 11-16-2006 07:43 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 05-25-2008
Registered User
 

Join Date: Apr 2008
Posts: 14
Statspack Script

Hi Dear ALL,

As we all know what is STATSPACK and how to take STATSPACK report of a database.

I need a script(any language) which analysis the STATSPACK and gives overall report/recommendations.

urgent please help me..
Thanks
Reply With Quote
Forum Sponsor
  #2  
Old 05-27-2008
sysgate's Avatar
Unix based
 

Join Date: Nov 2006
Location: /root
Posts: 1,200
Does that helps ? I'd say that it will depends on what do you want to parse, if you know the final results, it's easy to build a parser script.
Reply With Quote
  #3  
Old 05-27-2008
Registered User
 

Join Date: Apr 2008
Posts: 14
hi

i need over all script which analysis the statspack report and gives recommendations.
Reply With Quote
  #4  
Old 05-28-2008
sysgate's Avatar
Unix based
 

Join Date: Nov 2006
Location: /root
Posts: 1,200
Then my answer will be the same, it depends on what do you want and what are your definitions for good or bad - you can't recommend just like that : "increase the buffer size" - you have to rely on a baseline. Consider looking into Oracle Tuning Pack - it does recommendations, it's paid though.
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 01:58 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0