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?
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 email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
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;
SVRMGR> alter system set timed_statistics=true;
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.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
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
guys rmajali is working with 7.2.3... forget about alter system and alter session
The only way you can do it is change the parameter in the init.ora and bounce the database.
Click Here to Expand Forum to Full Width