NetXMS Wiki

Difference between revisions of "Subagent:Oracle"

Subagent:Oracle (view source)

Revision as of 23:56, 25 November 2012

6,822 bytes removed ,  23:56, 25 November 2012
no edit summary
Line 95: Line 95:
! Parameter !! Argument(s) !! Data Type !! Description
! Parameter !! Argument(s) !! Data Type !! Description
|-
|-
| Oracle.Cursors.Count(*) || Database ID || Integer || Number of opened cursors (system-wide)
| Oracle.CriticalStats.AutoArchivingOff(*) || Database ID || Integer || Archive logs enabled but auto archiving is off
|-
|-
| Oracle.Sessions.Count(*) || Database ID || Integer || Number of sessions opened
| Oracle.CriticalStats.DatafilesNeedMediaRecovery(*) || Database ID || Integer || Number of data files that need media recovery
|-
|-
| Oracle.DBInfo.IsReachable(*) || Database ID || String || YES if the database is reachable, NO otherwise
| Oracle.CriticalStats.DFOffCount(*) || Database ID || Integer || Number of offline data files
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.DBInfo.Name(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.CriticalStats.FailedJobs(*) || Database ID || Integer || Number of failed jobs
| style="border:none;padding:0.097cm;"| Database id
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.CriticalStats.FullSegmentsCount(*) || Database ID || Integer || Number of segments that cannot extend
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.CriticalStats.RBSegsNotOnlineCount(*) || Database ID || Integer || Number of rollback segments not online
| style="border:none;padding:0.097cm;"| Database name
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.DBInfo.CreateDate(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.CriticalStats.TSOffCount(*) || Database ID || Integer || Number of offline tablespaces
| style="border:none;padding:0.097cm;"| Database id
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.Cursors.Count(*) || Database ID || Integer || Number of opened cursors (system-wide)
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.DBInfo.IsReachable(*) || Database ID || String || YES if the database is reachable, NO otherwise
| style="border:none;padding:0.097cm;"| Database creation date
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.DBInfo.LogMode(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.DBInfo.Name(*) || Database ID || String || Database name
| style="border:none;padding:0.097cm;"| Database id
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.DBInfo.CreateDate(*) || Database ID || String || Database creation date
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.DBInfo.LogMode(*) || Database ID || String || Database log mode (e.g. noarchive)
| style="border:none;padding:0.097cm;"| Database log mode (e.g. noarchive)
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.DBInfo.OpenMode(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.DBInfo.OpenMode(*) || Database ID || String || Database open mode (e.g. read-only)
| style="border:none;padding:0.097cm;"| Database id
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.Instance.ArchiverStatus(*) || Database ID || String|| Archiver status (e.g. stopped)
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.Instance.ShutdownPending(*) || Database ID || String|| Indicates whether a shutdown action is pending at the moment
| style="border:none;padding:0.097cm;"| Database open mode (e.g. read-only)
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.TableSpaces.Status(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.Instance.Status(*) || Database ID || String|| Instance status (e.g. open, mounted)
| style="border:none;padding:0.097cm;"| Database id, tablespace name
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.Instance.Version(*) || Database ID || String|| Version of Oracle DBMS
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.Sessions.Count(*) || Database ID || Integer || Number of sessions opened
| style="border:none;padding:0.097cm;"| Status for specific tablespace (e.g. offline)
 
|}
 
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.TableSpaces.Type(*)'''
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Input''
| Oracle.TableSpaces.Status(*) || Database ID, Tablespace Name || String || Status for specific tablespace (e.g. offline)
| style="border:none;padding:0.097cm;"| Database id, tablespace name
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| Oracle.TableSpaces.Type(*) || Database ID, Tablespace Name || String || Type for specific tablespace (e.g. temporary)
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
 
|-
|-
| style="border:none;padding:0.097cm;"| ''Description''
| Oracle.TableSpaces.UsedPct(*) || Database ID, Tablespace Name || Integer || Percentage of space used for specific tablespace
| style="border:none;padding:0.097cm;"| Type for specific tablespace (e.g. temporary)
 
|}
|}


{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.TableSpaces.UsedPct(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id, tablespace name
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Percentage of space used for specific tablespace
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.Instance.Version(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Version of Oracle DBMS
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.Instance.Status(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Instance status (e.g. open, mounted)
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.Instance.ArchiverStatus(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Archiver status (e.g. stopped)
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.Instance.ShutdownPending(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Indicates whether a shutdown action is pending at the moment
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.TSOffCount(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of offline tablespaces
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.DFOffCount(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of offline datafiles
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.FullSegmentsCount(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT64
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of segments that cannot extend
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.RBSegsNotOnlineCount(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT64
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of rollback segments not online
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.AutoArchivingOff(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_STRING
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Archive logs enabled but auto archiving is off.
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.DatafilesNeedMediaRecovery(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT64
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of datafiles that need media recovery
|}
{| style="border-spacing:0;"
| colspan="2"  style="border:none;padding:0.097cm;"| '''Oracle.CriticalStats.FailedJobs(*)'''
|-
| style="border:none;padding:0.097cm;"| ''Input''
| style="border:none;padding:0.097cm;"| Database id
|-
| style="border:none;padding:0.097cm;"| ''Return type''
| style="border:none;padding:0.097cm;"| DCI_DT_INT64
|-
| style="border:none;padding:0.097cm;"| ''Description''
| style="border:none;padding:0.097cm;"| Number of failed jobs.
|}


{| style="border-spacing:0;"
{| style="border-spacing:0;"
Victor
AutoPatrol, Bureaucrats, Administrators
683

edits

Retrieved from "https://wiki.netxms.org/wiki/Special:MobileDiff/713"