| SPool to a text file. [message #63706] |
Fri, 29 October 2004 11:12  |
Tariq
Messages: 11
Registered: July 2003
|
Junior Member |
|
|
Hi there,
currently we are spooling the Output of couple of select statements to a file to monitor some thresholds on some oracle objects (tablespaces, max extents....).
Since we need to run this every 10 min, my concern is this going to degrade some database performance. Also i'm not sure if this is the right way to do it.
Appreciate any thoughts on this.
Btw: we are running Solaris 8/ oracle 817
Thanks,
--tariq
|
|
|
|
| Re: Spool to a text file. [message #63707 is a reply to message #63706] |
Fri, 29 October 2004 13:28  |
Edward Stoever
Messages: 58
Registered: August 2002
|
Member |
|
|
Why would you do this? Isn't a statspack snap better? (you get more data, likely more relevant data than your custom queries). Why every 10 minutes? Isn't that rather frequent?
Edward Stoever -- www.database-expert.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
