anybody know how i can figure out how many archive logs i can generate in 1 day or 1 hr?
"High Salaries = Happiness = Project Success."
Do you want to count them, or find out how much throughput your system has?
David Knight OCP DBA 8i, 9i, 10g
v$log_history
Jeff Hunter marist89@yahoo.com http://marist89.blogspot.com/ "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
I saw a script somebody had written which told me how many average archive logs were written for 1 day. thanks 4 ur help
you dont need a script fot that, it is recorded in control file therefore V$ views
Just check creation time for archive log files using shell commands.
Forum Rules
Reply With Quote
Bookmarks