Well, I searched, I read and I conquered but I still can’t figure out how to install this darn thing. Even the ILT 8i book tells you what it can do, but does NOT tell you how to install it.
Anyone?
Thanks,
MH
Printable View
Well, I searched, I read and I conquered but I still can’t figure out how to install this darn thing. Even the ILT 8i book tells you what it can do, but does NOT tell you how to install it.
Anyone?
Thanks,
MH
simply run as sys
SQL> @?/rdbms/admin/dbmsstat.sql
i hope you know how to use it :) and hope im not wrong
I think that you need to run the $ORACLE_HOME/rdbms/admin/dbmsstat.sql as sys.
Thanks guys, I just found out that we have our own in house way of doing this. I have to create a statpack tablespace first. I still can not find any documentation on installing this package, even my Quest knowledge expert failed. There is pleanty of info on how to use it but...
Thanks again
MH
hi
please read $ORACLE_HOME/rdbms/admin/spdoc.txt
This is on NT, so it appears that the files are different.
Hi
I think you have not tried
D:\oracle\ora81\RDBMS\ADMIN>dir spdoc.txt
Volume in drive D is xp_vol2
Volume Serial Number is 6493-A231
Directory of D:\oracle\ora81\RDBMS\ADMIN
15/06/2000 14:53 47,820 spdoc.txt
1 File(s) 47,820 bytes
0 Dir(s) 4,582,051,840 bytes free
D:\oracle\ora92\rdbms\admin>dir spdoc.txt
Volume in drive D is xp_vol2
Volume Serial Number is 6493-A231
Directory of D:\oracle\ora92\rdbms\admin
17/04/2002 18:09 86,176 spdoc.txt
1 File(s) 86,176 bytes
0 Dir(s) 4,582,051,840 bytes free
As you can see this document is present in Oracle 8.1.7 and 9.0.2.1 for Windows
Thanks for the reply sweetie, unfortunately I broke the cardinal rule of all posts.
OS= NT
Oracle Ver=8.1.6.
That .TXT file does not exist, neither does the spcreate script. There is however a statspack.sql script.
MH
The name of the stats pack script changed between 8.1.6 and 8.1.7.
Read the Metalink Note:149113.1 and try this:
Code:SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\rdbms\admin\statscre
You da man Gandolf, I just installed it, helps to log on as SYS.Quote:
Originally posted by gandolf989
The name of the stats pack script changed between 8.1.6 and 8.1.7.
Read the Metalink Note:149113.1 and try this:
Code:SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\rdbms\admin\statscre
Now if I can figure out how to use it I'll be swingin'.
MH