DBMS_STATS install?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: DBMS_STATS install?

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131

    DBMS_STATS install?

    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
    I remember when this place was cool.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    simply run as sys

    SQL> @?/rdbms/admin/dbmsstat.sql

    i hope you know how to use it and hope im not wrong
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    I think that you need to run the $ORACLE_HOME/rdbms/admin/dbmsstat.sql as sys.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

  5. #5
    Join Date
    Oct 2000
    Posts
    139
    hi

    please read $ORACLE_HOME/rdbms/admin/spdoc.txt

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    This is on NT, so it appears that the files are different.
    I remember when this place was cool.

  7. #7
    Join Date
    Oct 2000
    Posts
    139
    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

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    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
    Last edited by gandolf989; 02-25-2003 at 05:20 PM.

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    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
    You da man Gandolf, I just installed it, helps to log on as SYS.
    Now if I can figure out how to use it I'll be swingin'.

    MH
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width