Timed statistics
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Timed statistics

  1. #1
    Join Date
    May 2001
    Posts
    10
    I am working as a DBA on Oracle 7.2.3 on Unix. How can I change the parameter timed_statistics parameter dynamically?I have tried alter system set option but its giving illegal set option. Or is it not possible to change the parameter dynamically in Oracle 7.2.3?

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    No u cannot change the parameter timed_statistics dynamically.In order to change the parameter enter it in init.ora parameter file and shutdown and bounce back the database.
    This parameter can be changed dynamically in Oracle 8 and 8i.
    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Hi, 5th Aug 2001 13:06 hrs chennai

    Try it out like this and get back to this thread.

    If it returns error please paste the error code for follow up.

    You can dynamically set the command

    alter system set timed_statistics = true.

    Execute this as the user SYS.

    SVRMGR> connect / as sysdba;
    Connected.
    SVRMGR> alter system set timed_statistics=true;
    Statement processed.

    I also want you try it out setting in the init.ora in case if it failed to be set dynamically and try whether you can work on it.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  4. #4
    Join Date
    Aug 2000
    Posts
    462
    I have no idea if it works in your version, but in 8i you can also set it at the session level:

    alter session set timed_statistics = true;


    Would this help?

    Oracle DBA and Developer

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    guys rmajali is working with 7.2.3... forget about alter system and alter session

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The only way you can do it is change the parameter in the init.ora and bounce the database.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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