E
Server Statistics

The DBMS_STATS package generates statistics for the entire Oracle Email table or index. 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 Email 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.

This appendix contains the following topics:

• POP Statistics
• IMAP Statistics
• SMTP In Statistics
• SMTP Out Statistics
• Housekeeping Statistics
• List Server Statistics
• NNTP In Statistics
• NNTP Out Statistics
• Virus Scrubber

POP Statistics

Table E-1 describes the POP server statistics:

Table E-1 POP Server Statistics

Statistic	Description
.um.admin.os_pid	Operating system process ID
.um.admin.uptime	Amount of time the server has been up
.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	Amount of time 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

IMAP Statistics

Table E-2 describes the IMAP server statistics:

Table E-2 IMAP Server Statistics

Statistic	Description
.um.admin.os_pid	Operating system process ID
.um.admin.uptime	Amount of time the server has been up
.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.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

SMTP In Statistics

Table E-3 describes the SMTP In server statistics:

Table E-3 SMTP In Server Statistics

Statistic	Description
.um.admin.os_pid	Operating system process ID
.um.admin.uptime	Amount of time the server has been up
.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.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_loca	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

SMTP Out Statistics

Table E-4 describes the SMTP Out server statistics:

Table E-4 SMTP Out Server Statistics

Statistic	Description
.um.admin.os_pid	Operating system process ID
.um.admin.uptime	Amount of time the server has been up
.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.rejection_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.delivered.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 message transfer agents
.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 message transfer agents
.MTA.transmit.messages_local	Total number of messages transmitted to local entities
.MTA.transmit.messages_native	Total number of messages transmitted to native domain message transfer agents
.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 message transfer agents
.MTA.transmit.time	Total time transmitting data
.MTA.transmit.time_foreign	Total time transmitting data to foreign domain message transfer agents
.MTA.transmit.time_native	Total time transmitting data to native domain message transfer agents
.MTA.transmit.time.local	Total time spent transmitting data to local entities
.MTA.transmit.time.relay	Total time transmitting data during relay operations

Housekeeping Statistics

Table E-5 describes the Housekeeping server statistics:

Table E-5 Housekeeping Server Statistics

Statistic	Description
.GC.processed.expirables	Number of message instances expired by a particular housekeeping process
.GC.processed.prunables	Number of message instances removed from the system trash folder by a particular housekeeping process
.GC.processed.queued_prunables	Number of message references removed from the system trash queue by a particular housekeeping process
.GC.processed.collectables	Number of unreferenced messages removed from the system by a particular housekeeping process
.GC.processed.tertiary_storables	Number of messages moved to tertiary storage by a particular housekeeping process
.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

List Server Statistics

Table E-6 describes the list server statistics:

Table E-6 List Server Statistics

Statistic	Description
.SLIST.connections.busy	Number of busy database connections
.SLIST.connections.total	Total number of database connections
.SLIST.process.current_mail_threads	Number threads running in the server processing mails
.SLIST.process.current_mails	Number of mails being processed in the server
.SLIST.process.current_user_threads	Number of threads running in the server that are delivering mails to users
.SLIST.process.total_mails	Total number of mails that have been processed by the server since startup
.SLIST.queue.pending	Number of e-mails waiting to be processed by the list server
.um.admin.os_pid	Operating system process ID
.um.admin.uptime	Amount time the server has been up

NNTP In Statistics

Table E-7 describes the NNTP In server statistics:

Table E-7 NNTP In Server Statistics

Statistic	Description
.es.nntp.in.art.cache.hit	Article cache hits
.es.nntp.in.art.cache.miss	Article cache misses
.es.nntp.in.clients.article	Number of ARTICLE commands from clients
.es.nntp.in.clients.current	Number of connected clients
.es.nntp.in.clients.group	Number of GROUP commands from clients
.es.nntp.in.clients.list	Number of LIST commands from clients
.es.nntp.in.clients.post	Number of POST commands from clients
.es.nntp.in.clients.total	Number of clients serviced so far
.ES_SPS.socket.currload	Current client load
.ES_SPS.socket.sockmax	Maximum number of clients allowed
.ES_SPS.thread.currthreads	Number of service threads
.ES_SPS.thread.thrmax	Maximum number of service threads
.um.admin.os_pid	Process PID
.um.admin.uptime	Process uptime
.um.admin.log.discard	Number of discarded log messages
.um.admin.log.total	Number of total log messages

NNTP Out Statistics

Table E-8 describes the NNTP Out server statistics:

Table E-8 NNTP Out Server Statistics

Statistics	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
.um.admin.os_pid	Process PID
.um.admin.uptime	Process uptime
.um.admin.log.discard	Number of discarded log messages
.um.admin.log.total	Number of total log messages

Virus Scrubber

Table E-9 describes the virus scrubber statistics:

Table E-9 Virus Scrubber Statistics

Statistics	Description
.VSCRUB.processed.prescan	Number of messages pre-scanned by the process
.VSCRUB.processed.scan	Number of messages scanned by external virus scanning software using this process
.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