Timed statistics

[rmajali]

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?

[rohitsn]

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

[padmam]

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

[kmesser]

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?

[pando]

guys rmajali is working with 7.2.3... forget about alter system and alter session

[marist89]

The only way you can do it is change the parameter in the init.ora and bounce the database.