| DB Health checks [message #667019] |
Tue, 05 December 2017 05:49  |
dba4oracle
Messages: 100
Registered: June 2010
|
Senior Member |
|
|
Hi Guys,
I want to do proactive db health check so catch any issue which may come in future
I am using many sql scripts for daily monitoring ,but want to cross check if i am missing anything
Please share what is critical db metrics to be monitored and logged,and which can be used for comparision if any issue arises
also i like to create monthly db dashboard which reflect db health status ,by which i can show to non-dba's ,which depicts database is in good shape
please share your views and related scripts
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: DB Health checks [message #667045 is a reply to message #667040] |
Tue, 05 December 2017 23:00  |
dba4oracle
Messages: 100
Registered: June 2010
|
Senior Member |
|
|
Below is list of checks:
DB SESSION DETAILS(count group by app server).,REDO LOG GENERATION Trend for a day,status of db,datafiles,tempfile,listener ,backup etc,error in alert log,hit ratio,top io queries(10),top cpu queries(10),db cpu response,hard/soft parse percentage,sga usage,undo usage,long running sessions, queries having high parsing
|
|
|
|
|
|
|
|
|
|
|
|
| Re: DB Health checks [message #667063 is a reply to message #667062] |
Wed, 06 December 2017 04:04 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Cone on, man. What are the scripts? What is their output? Post the code and the reports, then perhaps you will get some advice on whether they are meaningful or inadequate.
|
|
|
|
|
|
|
|
| Re: DB Health checks [message #667072 is a reply to message #667071] |
Wed, 06 December 2017 06:06 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Ah. So you have no scripts.
You could present what you think are "best practices" for your site, based on your knowledge of your environment. I do not believe that there are any "best practices" that apply to all sites. If there were, Oracle would implement them out-of-the-box for everyone.
|
|
|
|
|
|
|
|
| Re: DB Health checks [message #667099 is a reply to message #667097] |
Thu, 07 December 2017 03:03 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
All right, I'll try to explain once more: I don't know what matters to your clients. You do.
However, if you really want to do something without considering what is needed, all I can suggest is that you use the dbms_hm package (hey, "hm" stands for "health monitor"!) to run the supplied checks:
orclx> SELECT name FROM v$hm_check;
NAME
------------------------------
HM Test Check
DB Structure Integrity Check
CF Block Integrity Check
Data Block Integrity Check
Redo Integrity Check
Logical Block Check
Transaction Integrity Check
Undo Segment Integrity Check
No Mount CF Check
Mount CF Check
CF Member Check
All Datafiles Check
Single Datafile Check
Tablespace Check Check
Log Group Check
Log Group Member Check
Archived Log Check
Redo Revalidation Check
IO Revalidation Check
Block IO Revalidation Check
Failover Check
Txn Revalidation Check
Failure Simulation Check
Dictionary Integrity Check
ASM Mount Check
ASM Allocation Check
ASM Disk Visibility Check
ASM File Busy Check
ASM Toomanyoff Check
ASM Insufficient Disks Check
ASM Insufficient Mem Check
ASM DGFDM Check No DG Name
ASM DG Force Dismount Check
ASM Sync IO Fail Check
34 rows selected.
orclx> |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
