-
Monitoring oracle database
Hi All,
I have doubt...
please help me in this...
In our company... they are creating new tool for monitoring all the oracle databases.... please tell me... what and all have to monitor....
like tablespace, connectivity, listener dail and monthly...
Regards,
Rita
-
it is hard to list here ... If the databases are 10g why don't use Oracle Grid Control to monitor every thing?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
monitoring oracle database
Hi vijay,
Thanks for replying me back.
It's oracle 10g only. how it works. pls can u tell me.
Regards,
Rita
-
Monitoring oracle database
Hi all,
But i want to list just 10 atleast. Please can anyone help me in this.
Regards,
Rita
-
...is there a DBA involved in the project?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Re-inventing the wheel
Originally Posted by Ritasam87
Hi All,
I have doubt...
please help me in this...
In our company... they are creating new tool for monitoring all the oracle databases.... please tell me... what and all have to monitor....
like tablespace, connectivity, listener dail and monthly...
Regards,
Rita
If someone in your company is "creating new tool" to monitor the database, then they are re-inventing the wheel.
Oracle supplies the Enterprise Manager dbconsole and the Grid Control software which can be configured to monitor the database(s)/listener(s) and server(s).
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Dude,
As our friend told you have Oracle Enterprise Manager dbconsole to monitor all stuffs
But as a growing DBA you can write your own monitoring script by using Perl/sh or any scripting lang for gaining indepth knowledge.
I can help with few things.
1) Tablespace growth check, if the space reaches limit automatically increase size
2) Database instance connectivity check
3) ORA error message check in alert log file.
4) Tablespace online and offline check.
5) Any session holding locks for 30 mins.
6) Montior trace file ans remove it older than 7 days.
7) Space availabilty for next backup.
8) Monitor Temp tablespace usage.
9) Backup related script.
10)Database statistics from statspack.
11) Start and stop all DB servers.
12) etc,etc ................
if you want we can disucss on few scripts also.
Thanks
VJ
"Sky is limit"
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
|