Printable View
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,
Hi vijay,
Thanks for replying me back.
It's oracle 10g only. how it works. pls can u tell me.
Regards,
Rita
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?
If someone in your company is "creating new tool" to monitor the database, then they are re-inventing the wheel.Quote:
Originally Posted by Ritasam87
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).
:rolleyes:
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"