-
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?
-
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
-
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
-
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.
Jeff Hunter
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
|