Oracle® Mail Administrator's Guide 10g Release 1 (10.1.1) Part Number B14491-03 |
|
|
View PDF |
The DBMS_STATS package generates metrics for all Oracle Mail servers. Statistics are transferred between the statistics table and data dictionary, and can be used only when they are stored in the data dictionary. The statistics table enables users to export or import statistics from one database to another. Oracle Mail includes statistics that are collected from a mature system, because there is not enough statistical data when the system is first installed. Users can choose to import these statistics into their systems prior to using their own statistics.
Oracle Mail generates statistical information for each of the various Oracle Mail servers. This information, called metrics, can be used to monitor the health of the Oracle Mail system, and can be viewed using either the Oracle Enterprise Manager 10g Grid Control Console or the oesmon
command-line utility.
This appendix includes the following topics:
Table H-1 lists metrics common to all Oracle Mail servers.
Table H-1 Metrics Common to All Oracle Mail Servers
Metric | Description |
---|---|
.DUMP.DBconnection.dump |
|
.DUMP.OIDstatus.Connection |
|
.DUMP.threads.dump |
|
.esqudb.expand_count |
|
.esqudb.pending_request |
|
.esqudb.queue_size |
|
.esqudb.requests_OK |
|
.esqudb.requests_timedout |
|
.esquldap.expand_count |
|
.esquldap.pending_request |
|
.esquldap.queue_size |
|
.esquldap.requests_OK |
|
.esquldap.requests_timedout |
|
.um.admin.os_pid |
Operating system process ID |
.um.admin.uptime |
Time since the server has been up |
.um.admin.log.discard |
Number of discarded log messages |
.um.admin.log.total |
Number of total log messages |
Table H-2 lists POP server metrics.
Table H-2 POP Server Metrics
Metric | Description |
---|---|
.ES_SPS.socket.currload |
Current number of client connections |
.ES_SPS.socket.sockmax |
Maximum number of client connections allowed |
.ES_SPS.thread.currthreads |
Number of threads the server is currently using |
.ES_SPS.thread.thrmax |
Maximum number of threads the server creates |
.ESPROTO.uptime |
Time since the server has been up |
.ESPROTO.COMMAND.total |
Total number of executed commands |
.ESPROTO.COMMAND.PO3_COMMAND.totalcalls |
Total number of calls for that command |
.ESPROTO.COMMAND.PO3_COMMAND.success |
Total number of successful calls for that command |
.ESPROTO.COMMAND.PO3_COMMAND.fail |
Total number of failed calls for that command |
.ESPROTO.USERS.LOGIN.userid |
A value of 1 or more indicates that the user is still logged in. Otherwise, it is 0. |
.ESPROTO.connections.lost |
Total number of client connections that have disconnected |
.ESPROTO.connections.timeout |
Total number of client connections that have timed out |
.ESPROTO.connections.total |
Total number of client connections |
.ESPROTO.receive.bytes |
Total number of bytes received by the server |
.ESPROTO.transmit.bytes |
Total number of bytes sent by the server |
Table H-3 lists IMAP server metrics.
Table H-3 IMAP Server Metrics
Metric | Description |
---|---|
.ESPROTO.uptime |
Time since the server has been up |
.ESPROTO.COMMAND.total |
Total number of executed commands |
.ESPROTO.COMMAND.PO3_COMMAND.totalcalls |
Total number of calls for that command |
.ESPROTO.COMMAND.PO3_COMMAND.success |
Total number of successful calls for that command |
.ESPROTO.COMMAND.PO3_COMMAND.fail |
Total number of failed calls for that command |
.ESPROTO.USERS.LOGIN.userid |
A value of 1 or more indicates that the user is still logged in. Otherwise, it is 0. |
.ESPROTO.connections.lost |
Total number of client connections that have disconnected |
.ESPROTO.connections.timeout |
Total number of client connections that have timed out |
.ESPROTO.connections.total |
Total number of client connections |
.ESPROTO.receive.bytes |
Total number of bytes received by the server |
.ESPROTO.transmit.bytes |
Total number of bytes sent by the server |
.ES_SPS.socket.currload |
Current number of client connections |
.ES_SPS.socket.sockmax |
Maximum number of client connections allowed |
.ES_SPS.thread.currthreads |
Number of threads the server is currently using |
.ES_SPS.thread.thrmax |
Maximum number of threads the server creates |
Table H-4 lists SMTP Inbound server metrics.
Table H-4 SMTP Inbound Server Metrics
Metric | Description |
---|---|
.ES_SPS.socket.currload |
Current number of client connections |
.ES_SPS.socket.sockmax |
Maximum number of client connections allowed |
.ES_SPS.thread.currthreads |
Number of threads the server is currently using |
.ES_SPS.thread.thrmax |
Maximum number of threads the server creates |
.MTA.uptime |
Time string describing when this MTA came up |
.MTA.connections.in.current |
Current number of inbound SMTP Connections |
.MTA.connections.in.total |
Total number of inbound SMTP connections |
.MTA.msgs.deferred.current |
Current number of messages deferred |
.MTA.msgs.deferred.total |
Total number of messages deferred |
.MTA.receive.kbytes |
Total number of kilobytes received |
.MTA.receive.messages |
Total number of messages received |
.MTA.receive.recipients |
Total number of recipients received |
.MTA.receive.time |
Total time receiving data |
.MTA.spam.connects |
Number of rejected connections |
.MTA.spam.env.domains |
Number of rejected domains given in EHLO/HELO commands |
.MTA.spam.env.recipients |
Number of rejected recipients given in |
.MTA.spam.env.senders |
Number of rejected senders which appeared on mail from command |
.MTA.spam.floods |
Number of floods from various hosts |
.MTA.spam.msg.headers |
Number of data command failures due to rejected message headers |
.MTA.transmit.bytes |
Total number of bytes transmitted |
.MTA.transmit.bytes_local |
Total number of bytes transmitted to local entities |
.MTA.transmit.messages |
Total number of messages transmitted |
.MTA.transmit.messages_local |
Total number of messages transmitted to local entities |
.MTA.transmit.recipients |
Total number of recipients transmitted |
.MTA.transmit.recipients_local |
Total number of recipients transmitted to local entities |
Table H-5 lists SMTP Outbound server metrics.
Table H-5 SMTP Outbound Server Metrics
Metric | Description |
---|---|
.MTA.uptime |
Time string describing when this MTA came up |
.MTA.connections.broken |
Number of broken connections encountered by the MTA |
.MTA.connections.failed |
Number of failed connections from the MTA to another MTA |
.MTA.connections.rejected |
Number of rejected connections |
.MTA.connections.rejected_reason |
Description of the reason for the most recent rejection |
.MTA.connections.out.current |
Current number of outbound SMTP connections |
.MTA.connections.out.current_foreign |
Current number of outbound SMTP connections to message transfer agents in foreign domains |
.MTA.connections.out.current_native |
Current number of outbound SMTP connections to message transfer agents in native domains |
.MTA.connections.out.total |
Total number of outbound SMTP connections |
.MTA.connections.out.total_foreign |
Total number of outbound SMTP connections to foreign domains |
.MTA.connections.out.total_native |
Total number of outbound SMTP connections to message transfer agents in native domains |
.MTA.dl.receive.count |
Number of messages sent to distribution lists |
.MTA.msgs.deferred.current |
Current number of messages deferred |
.MTA.msgs.deferred.total |
Total number of messages deferred |
.MTA.msgs.deferred.totaltime |
Total time inserting data into the database |
.MTA.ndr.inbound |
Total number of non delivery reports generated by inbound mail |
.MTA.ndr.loop |
Total number of messages not delivered due to mail loops |
.MTA.ndr.outbound |
Total number of non delivery reports generated by outbound mail |
.MTA.queued.out.kbytes |
Kilobytes queued awaiting to be sent out to the Internet |
.MTA.queued.out.messages |
Messages queued awaiting to be sent out to the Internet |
.MTA.transmit.bytes |
Total number of bytes transmitted |
.MTA.transmit.bytes_foreign |
Total number of bytes transmitted to foreign domain MTAs |
.MTA.transmit.bytes_local |
Total number of bytes transmitted to local entities |
.MTA.transmit.messages |
Total number of messages transmitted |
.MTA.transmit.messages_foreign |
Total number of messages transmitted to foreign domain MTAs |
.MTA.transmit.messages_local |
Total number of messages transmitted to local entities |
.MTA.transmit.messages_native |
Total number of messages transmitted to native domain MTAs |
.MTA.transmit.messages_relay |
Total number of messages transmitted during relay operations |
.MTA.transmit.recipients |
Total number of recipients transmitted |
.MTA.transmit.recipients_foreign |
Total number of recipients transmitted to foreign domain |
.MTA.transmit.recipients_local |
Total number of recipients transmitted to local entities |
.MTA.transmit.recipients_native |
Total number of recipients transmitted to native domain MTAs |
.MTA.transmit.time |
Total time transmitting data |
.MTA.transmit.time_foreign |
Total time transmitting data to foreign domain MTAs |
.MTA.transmit.time_native |
Total time transmitting data to native domain MTAs |
.MTA.transmit.time.local |
Total time spent transmitting data to local entities |
.MTA.transmit.time.relay |
Total time transmitting data during relay operations |
Table H-6 lists Housekeeper server metrics.
Table H-6 Housekeeper Server Metrics
Metric | Description |
---|---|
.GC.processed.expirables |
Number of message instances expired by a particular Housekeeper instance |
.GC.processed.prunables |
Number of message instances removed from the system trash folder by a particular Housekeeper instance |
.GC.processed.queued_prunables |
Number of message references removed from the system trash queue by a particular Housekeeper instance |
.GC.processed.collectables |
Number of unreferenced messages removed from the system by a particular Housekeeper instance |
.GC.processed.tertiary_storables |
Number of messages moved to tertiary storage by a particular Housekeeper instance |
.GC.pending.expirables |
Number of message instances awaiting expiration remaining in the system |
.GC.pending.prunables |
Number of message instances remaining in the system trash folder |
.GC.pending.queued_prunables |
Number of message references remaining in the system trash queue |
.GC.pending.collectables |
Number of identified unreferenced messages remaining in the system |
.GC.pending.tertiary_storables |
Number of messages remaining in the system that are eligible for tertiary storage |
Table H-7 lists List Server metrics.
Table H-7 List Server Metrics
Metric | Description |
---|---|
.SLIST.connections.busy |
Number of busy database connections |
.SLIST.connections.total |
Total number of database connections |
.SLIST.process.current_mails |
Number of mails being processed currently by the list server |
.SLIST.process.current_user_threads |
Number of threads in the list server that are delivering mails to users |
.SLIST.process.total_mails |
Total number of mails processed by the list server since startup |
.SLIST.queue.pending |
Number of e-mails waiting to be processed by the list server |
Table H-8 lists NNTP Inbound server metrics.
Table H-8 NNTP Inbound Server Metrics
Metric | Description |
---|---|
.ES_SPS.socket.currload |
Current number of client connections |
.ES_SPS.socket.sockmax |
Maximum number of client connections allowed |
.ES_SPS.thread.currthreads |
Number of threads the server is currently using |
.ES_SPS.thread.thrmax |
Maximum number of threads the server creates |
.es.nntp.in.clients.flood.conns |
Number of times the server has detected connection floods from a single client |
.es.nntp.in.art.cache.hit |
Article cache hits |
.es.nntp.in.art.cache.miss |
Article cache misses |
.es.nntp.in.art.clients.article |
Number of |
.es.nntp.in.clients.current |
Number of connected clients |
.es.nntp.in.clients.group |
Number of |
.es.nntp.in.clients.list |
Number of |
.es.nntp.in.clients.post |
Number of |
.es.nntp.in.clients.total |
Number of clients serviced so far |
Table H-9 lists NNTP Outbound server metrics.
Table H-9 NNTP Outbound Server Metrics
Metric | Description |
---|---|
.es.nntp.out.threads |
Number of live feed threads, may be zero |
.es.nntp.out.conn.cache.hit |
Connection cache hits |
.es.nntp.out.conn.cache.miss |
Connection cache misses |
.es.nntp.out.traffic.errors |
Feed errors |
.es.nntp.out.traffic.messages |
Feed messages |
.es.nntp.out.traffic.rejects |
Feed rejects |
Table H-10 lists Virus Scrubber server metrics.
Table H-10 Virus Scrubber Server Metrics
Metric | Description |
---|---|
.VSCRUB.processed.prescan |
Number of messages pre-scanned by the server |
.VSCRUB.processed.scan |
Number of messages scanned by external virus scanning software using this server |
.VSCRUB.processed.infected |
Number of messages deemed infected by the virus scanning software |
.VSCRUB.processed.repaired |
Number of messages deemed infected by the virus scanning software but able to repair and restore |
.VSCRUB.pending.scan |
Number of messages isolated by pre-scanning but yet to be scanned by external virus scanning software |
.VSCRUB.threads.count |
Number of active virus scanner threads at the moment |