RE: any intro statspack docs online?

2003-06-10 Thread Johnson, Michael 



Search 
MetaLink ... Burleson has a good book "High PerformanceTuning with 
Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also 
hassome good information.. Look in your 
$ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or 
st*.txt document in there to show you how to set up and use. 
Also, I think Tim Gorman's site has some statspack 
stuffin his downloadable library section.

http://www.evdbt.com/

HTH, 
Mike



  -Original Message-From: Yechiel Adar 
  [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  any intro statspack docs online?
  I know it is late but:
  
  Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation 
  and recommendations.
  
  Yechiel AdarMehish
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, May 22, 2003 5:41 
    PM
    Subject: any intro statspack docs 
online?
Ive read the otn stuff and the niemic articles from Oracle 
mag.anything else? any articles that give a brief intro that 
includes installation? Id prefer not to dig into the Burleson book. Im 
really looking for something brief.Not too familiar with tuning wait 
events, but I 'think' we have some contention problems, and before I create 
an elaborate routine, Id like to get some metrics. any quick start 
guide? 










Licensing is based 
on customers honesty 
basically.

The versions you 
can download are fully functional with all the 
options.

Visit 
our web site at http://www.quantsystems.nl/

-Original 
Message-From: Joe Joe 
[mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 
AMTo: Multiple recipients 
of list ORACLE-LSubject: 
oracle trialware - features ??


Folks, Does "Oracle Enterprise 
Edition - Trialware" have all the features as that of 
alicensedone ? Is RMAN fully functional on a trial version of 
9iR2 ? What makes the difference between these two ? If 
there is no difference, how does ORACLE prevent people from using it for 
PRODUCTION ? Read an interesting article about oracle licensing at 
http://www.vnunet.com/Analysis/1113993 
and just thought of sharing it with u 
guys.



Share your comments 
Gurus.



Cheers,

Joe.
Get 
advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos 
Mail

RE: any intro statspack docs online?

2003-06-10 Thread Farnsworth, Dave 



check 
these links

http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html

http://www.oracle.com/oramag/oracle/00-Sep/o50tun.html

http://www.oracle.com/oramag/oracle/00-Nov/o60tun.html

http://www.oracle.com/oramag/oracle/00-Nov/o60tun_ol.html

Dave

  -Original Message-From: Johnson, Michael 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10, 
  2003 12:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: any intro statspack docs 
  online?
  Search MetaLink ... Burleson has a good book "High 
  PerformanceTuning with Statspack" .. Tom Kytes Book "Oneon One" 
  in Chapter 10 also hassome good information.. Look 
  in your $ORACLE_HOME/rdbms/admin and depending on you version their is a 
  sp*.doc or st*.txt document in there to show you how to set up and 
  use. Also, I think Tim Gorman's site has some 
  statspack stuffin his downloadable library 
  section.
  
  http://www.evdbt.com/
  
  HTH, 
  Mike
  
  
  
-Original Message-From: Yechiel Adar 
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
    any intro statspack docs online?
I know it is late but:

Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with 
explanation and recommendations.

Yechiel AdarMehish

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Thursday, May 22, 2003 5:41 
  PM
  Subject: any intro statspack docs 
  online?
  Ive read the otn stuff and the niemic articles from Oracle 
  mag.anything else? any articles that give a brief intro that 
  includes installation? Id prefer not to dig into the Burleson book. Im 
  really looking for something brief.Not too familiar with tuning 
  wait events, but I 'think' we have some contention problems, and before I 
  create an elaborate routine, Id like to get some metrics. any 
  quick start guide? 
  
  

  
  
  
  
  

  
  Licensing is 
  based on customers honesty 
  basically.
  
  The versions you 
  can download are fully functional with all the 
  options.
  
  Visit 
  our web site at http://www.quantsystems.nl/
  
  -Original 
  Message-From: Joe 
  Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 
  AMTo: Multiple 
  recipients of list ORACLE-LSubject: oracle trialware - features 
  ??
  
  
  Folks, Does "Oracle 
  Enterprise Edition - Trialware" have all the features as that of 
  alicensedone ? Is RMAN fully functional on a trial version of 
  9iR2 ? What makes the difference between these two ? If 
  there is no difference, how does ORACLE prevent people from using it for 
  PRODUCTION ? Read an interesting article about oracle licensing at 
  http://www.vnunet.com/Analysis/1113993 
  and just thought of sharing it with u 
  guys.
  
  
  
  Share your comments 
  Gurus.
  
  
  
  Cheers,
  
  Joe.
  Get 
  advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos 
  Mail

Re: any intro statspack docs online?

2003-06-09 Thread Yechiel Adar 



I know it is late but:

Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation 
and recommendations.

Yechiel AdarMehish

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, May 22, 2003 5:41 
PM
  Subject: any intro statspack docs 
  online?
  Ive read the otn stuff and the niemic articles from Oracle 
  mag.anything else? any articles that give a brief intro that includes 
  installation? Id prefer not to dig into the Burleson book. Im really looking 
  for something brief.Not too familiar with tuning wait events, but I 
  'think' we have some contention problems, and before I create an elaborate 
  routine, Id like to get some metrics. any quick start guide? 
  
  

  
  
  
  
  

  
  Licensing is based on 
  customers honesty 
  basically.
  
  The versions you can 
  download are fully functional with all the 
  options.
  
  Visit 
  our web site at http://www.quantsystems.nl/
  
  -Original 
  Message-From: Joe Joe 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: oracle 
  trialware - features ??
  
  
  Folks, Does "Oracle Enterprise 
  Edition - Trialware" have all the features as that of alicensedone 
  ? Is RMAN fully functional on a trial version of 9iR2 ? What makes the 
  difference between these two ? If there is no difference, how does 
  ORACLE prevent people from using it for PRODUCTION ? Read an 
  interesting article about oracle licensing at http://www.vnunet.com/Analysis/1113993 
  and just thought of sharing it with u 
  guys.
  
  
  
  Share your comments 
  Gurus.
  
  
  
  Cheers,
  
  Joe.
  Get 
  advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos 
  Mail