Rob L. writes: Thanks for the script, works very nice, especially to see peak log writing times. However, is there a limit to how many rows from v$log_history it can get. I have one instance that keeps returning an Oracle error:

SQL> @log_switch
Session altered.
ERROR:
ORA-01722: invalid number

The author responds: I did not run into this error when running this script on a database with 1018 records in v$log_history. I could reproduce this error by replacing the format '99' with '9', so I think that there is a period when you've had more than 100 switches in an hour. Change the '99' into '999' and I think you will be freed from this error.

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy