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

Thread: DBMS_STATS install?

  1. 02-25-2003, 12:33 PM #1
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134

    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.
    Reply With Quote Reply With Quote
  2. 02-25-2003, 12:41 PM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    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!
    Reply With Quote Reply With Quote
  3. 02-25-2003, 12:41 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I think that you need to run the $ORACLE_HOME/rdbms/admin/dbmsstat.sql as sys.
    Reply With Quote Reply With Quote
  4. 02-25-2003, 01:00 PM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
  5. 02-25-2003, 01:06 PM #5
    Sweetie
    Sweetie is offline Member
    Join Date
    Oct 2000
    Posts
    139
    hi

    please read $ORACLE_HOME/rdbms/admin/spdoc.txt
    Reply With Quote Reply With Quote
  6. 02-25-2003, 02:56 PM #6
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    This is on NT, so it appears that the files are different.
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  7. 02-25-2003, 03:10 PM #7
    Sweetie
    Sweetie is offline Member
    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
    Reply With Quote Reply With Quote
  8. 02-25-2003, 03:46 PM #8
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
  9. 02-25-2003, 05:17 PM #9
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.
    Reply With Quote Reply With Quote
  10. 02-26-2003, 11:04 AM #10
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width