| Is there a way to set these HOST related metric settings? [message #651540] |
Thu, 19 May 2016 20:40  |
 |
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
Dear all,
I've hit Bug 20878834 : JAVA.LANG.NULLPOINTEREXCEPTION WHEN CLICKING THE LOAD LINK OF HOST CPU
Quote:
Problem Description
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
When Clicking the LOAD link of HOST CPU, the java.lang.NullPointerException
error occurs.
Environment Information
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
Reproduced the problem in 11.2.0.4
EM:
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Agent Version is 10.2.0.4.5
OMS Version is 10.2.0.4.5
that is to say If I want to set host related metrics like
Disk Device Busy (%) and Memory Utilization (%), I'm not able to set through Enterprise Manager.
https://docs.oracle.com/cd/E11882_01/server.112/e25494/monitoring.htm#ADMIN11253 has shown how to set metric through pl/sql.
I realize that from http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_server_alert.htm#ARPLS67996
there's only a list of metric that is supported
Quote:
Table 130-3 List of Supported Metrics
AVG_FILE_READ_TIME
So my question is If I were to set threshold for Disk Device Busy (%) and Memory Utilization (%) from http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_server_alert.htm#ARPLS67996
what metric_name should I use?
I also have another question.
In 11.2.0.4 window server 2008
I've just set memory utilization through OEM to warning threshold 90 and critical threshold 95, but I could not see the changes in dba_thresolds why is this so?
SELECT DISTINCT metrics_name
FROM dba_thresholds
ORDER BY metrics_name;
results
SYS@192.168.56.3/nowatzki>SELECT DISTINCT metrics_name FROM dba_thresholds ORDER
BY metrics_name;
METRICS_NAME
----------------------------------------------------------------
Average Users Waiting Counts
Blocked User Session Count
Current Open Cursors Count
Database Time Spent Waiting (%)
Logons Per Sec
Session Limit %
Tablespace Bytes Space Usage
Tablespace Space Usage
8 rows selected.
why is memory utilization not inside dba_thresolds?
many thanks in advance!
[Updated on: Thu, 19 May 2016 21:17] Report message to a moderator |
|
|
|
|
|
| Re: Is there a way to set these HOST related metric settings? [message #651542 is a reply to message #651541] |
Thu, 19 May 2016 21:26  |
|
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
firstly I have found a way to set host related metrics in OEM, just click the hostname hyperlink and are you in host/machine mode not in database instance mode. so whatever metric settings u set it will be related to host.
okay agree with you, but then can we set host related metric through pl/sql? that's my first question
In 11.2.0.4 windows server 2008
I've just set Disk Device Busy (%) to warning threshold 90 and critical threshold to 95 through oem
still I cold not see any thing being reflected in dba_thresholds
SYS@192.168.56.3/nowatzki>SELECT DISTINCT metrics_name FROM dba_thresholds ORDER
BY metrics_name;
METRICS_NAME
----------------------------------------------------------------
Average Users Waiting Counts
Blocked User Session Count
Current Open Cursors Count
Database Time Spent Waiting (%)
Logons Per Sec
Session Limit %
Tablespace Bytes Space Usage
Tablespace Space Usage
8 rows selected.
my second question: why is it not being reflected in dba_thresholds?
many thanks in advance!
[Updated on: Thu, 19 May 2016 22:48] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
