RE: Tablespace Monitor
- From: "Dwyer, Brian" <Brian.Dwyer@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 12 Dec 2008 10:41:55 -0000
***************************************************************************
Internet email is not to be treated as a secure means of communication.
North Yorkshire Police monitors all internet email activity and content.
This communication is intended for the addressee(s) only.
Please notify the sender if received in error. Unauthorised use or
disclosure of the content may be unlawful. Opinions expressed in this
document may not be official policy. Thank you for your co-operation.
***************************************************************************
Mamta
The simplest way to do it is via Enterprise manager Console.
The best way to do it is to automate the process, set up some sql
scripts to query the database on a daily basis and inform you if they go
above a set target i.e 85%
Remember to build in logic for tablespaces with auto extend on them.
Brian
________________________________
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta
Sent: 11 December 2008 03:52
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Tablespace Monitor
Hello DBA's
How do you monitor you tablespace?
What are the steps to be taken?
Please let me know.
Regards
Mamta
Other related posts: