Home » RDBMS Server » Performance Tuning » Statspack for 9i on 8.1.6
Statspack for 9i on 8.1.6 [message #119562] Fri, 13 May 2005 07:00 Go to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
I have production db 8.1.6.3.0 and I install STATSPACK with scripts taht I found in ?\rdbms\admin\ directory (statscre.sql,stats%). Also use statsrep.sql for creating report from snapshots. But I'm not complete satisfied with result (dont have sprepsql.sql, number of executions in LoadProfile etc...)
So I want to use newer version of statspack like in 9i with spcreate.sql script for creation and spreport.sql,sprepsql.sql, Execute/Parse ratio for report. Is it possible to use those scripts for creation and reporting in my 8.1.6.3.0 db?

THX in advance

[Updated on: Fri, 13 May 2005 07:07]

Report message to a moderator

Re: Statspack for 9i on 8.1.6 [message #120530 is a reply to message #119562] Fri, 20 May 2005 06:07 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
I'm not sure if Oracle 8i's statpack would be compatible with 9i or not. It would be quite easy to test on a development box. Unfortunately I don't have any 8i databases, so I cannot test it for you. If you do, please let us know the results.

Best regards.

Frank
Previous Topic: Ploblem connect oracle by Vb application
Next Topic: activating Online Index Build
Goto Forum:
  


Current Time: Tue Mar 19 00:34:47 CDT 2024