A
Server Statistics

The DBMS_STATS package generates statistics for the entire Oracle9iAS Unified Messaging table or index. Statistics are transferred between 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. Oracle9iAS Unified Messaging 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 chapter contains the following topics:

POP3 Statistics

The following is a list of POP3 server statistics and their descriptions:

Statistic	Description
.um.admin.os_pid	The operating system process id
.um.admin.uptime	The amount of time the server has been up
.ES_SPS.socket.currload	The current number of client connections
.ES_SPS.socket.sockmax	The maximum number of client connections allowed
.ES_SPS.thread.currthreads	The number of threads the server is currently using
.ES_SPS.thread.thrmax	The maximum number of threads the server creates.
.DUMP.DBconnections.dump	Internal Information
.DUMP.OIDStatus.Connection	Internal Information
.DUMP.Threads.dump	Internal Information
.ESPROTO.uptime	The amount of time the server has been up
.ESPROTO.COMMAND.total	total number of commands executed
.ESPROTO.COMMAND.<PO3_ COMMAND>.success	where PO3_COMMAND is one of the commands defined by the POP3 protocol
.ESPROTO.COMMAND.<PO3_ COMMAND>.totalcalls	The total number of calls for that command
.ESPROTO.COMMAND.<PO3_ COMMAND>.fail	The total number of failed calls for that command
.ESPROTO.USERS.LOGIN.<userid>	Where userid is the user who has used the server since the server was started. A value of 1 indicates that user is still logged in.Otherwise, it is 0.
.ESPROTO.connections.lost	The total number of client connections that have disconnected
.ESPROTO.connections.timeout	The total number of client connections that have timed out.
.ESPROTO.connections.total	The total number of client connections
.ESPROTO.receive.bytes	The total number of bytes received by the server
.ESPROTO.transmit.bytes	The total number of bytes sent by the server

IMAP4 Statistics

The following is a list of IMAP4 server statistics and their descriptions:

Statistic	Description
.um.admin.os_pid	The operating system process id
.um.admin.uptime	The amount of time the server has been up
.ES_SPS.socket.currload	The current number of client connections
.ES_SPS.socket.sockmax	The maximum number of client connections allowed
.ES_SPS.thread.currthreads	The number of threads the server is currently using
.ES_SPS.thread.thrmax	The maximum number of threads the server can create.
.DUMP.DBconnections.dump	Internal Information
.DUMP.OIDStatus.Connection	Internal Information
.DUMP.Threads.dump	Internal Information
.ESPROTO.uptime	The amount of time the server has been up
.ESPROTO.COMMAND.total	The total number of commands executed
.ESPROTO.COMMAND.<IMAP_ COMMAND>.success	Where IMAP_COMMAND is one of the commands defined by the IMAP protocol (RFC2060). A value of 1 means that command has succeeded. A value of 0 means the command has failed
.ESPROTO.COMMAND.<IMAP_ COMMAND>.totalcalls	The total number of failed calls for that command
.ESPROTO.COMMAND.<IMAP_ COMMAND>.fail	The total number of failed calls for that IMAP command
.ESPROTO.USERS.LOGIN.<userid>	where userid is the user who has used the server since the server was started. A value of 1 indicates that user is still logged in, 0 otherwise.
.ESPROTO.connections.lost	The total number of client connections that have disconnected
.ESPROTO.connections.timeout	The total number of client connections that have timed out.
.ESPROTO.connections.lost	The total number of client connections that have disconnected
.ESPROTO.connections.timeout	The total number of client connections that have timed out.
.ESPROTO.connections.total	The total number of client connections
.ESPROTO.receive.bytes	The total number of bytes received by the server
.ESPROTO.transmit.bytes	The total number of bytes sent by the server

SMTP In Statistics

The following is a list of SMTP In server statistics and their descriptions:

Statistic	Description
.um.admin.os_pid	The operating system process id
.um.admin.uptime	The amount of time the server has been up
.ES_SPS.socket.currload	The current number of client connections
.ES_SPS.socket.sockmax	The maximum number of client connections allowed
.ES_SPS.thread.currthreads	The number of threads the server is currently using
.ES_SPS.thread.thrmax	The maximum number of threads the server creates
.DUMP.DBconnections.dump	Internal Information
.DUMP.OIDStatus.Connection	Internal Information
.DUMP.Threads.dump	Internal Information
.MTA.uptime	Time string describing when this MTA came up
.MTA.connections.in.current	The current number of inbound SMTP Connections
.MTA.connections.in.total	The total number of inbound SMTP connections
.MTA.msgs.deferred.current	The current number of messages deferred
.MTA.msgs.deferred.total	The total number of messages deferred
.MTA.receive.kbytes	The total number of kilobytes received
.MTA.receive.messages	The total number of messages received
.MTA.receive.recipients	The total number of recipients received
.MTA.receive.time	The total time receiving data (ms)
.MTA.transmit.bytes	The total number of bytes transmitted
.MTA.transmit.bytes_local	The total number of bytes transmitted to local entities
.MTA.transmit.messages	The total number of messages transmitted
.MTA.transmit.messages_loca	The total number of messages transmitted to local entities
.MTA.transmit.recipients	The total number of recipients transmitted
.MTA.transmit.recipients_ local	The total number of recipients transmitted to local entities

SMTP Out Statistics

The following is a list of SMTP Out server statistics and their descriptions:

Statistic	Description
.um.admin.os_pid	The operating system process id
.um.admin.uptime	The amount of time the server has been up
.DUMP.OIDStatus.Connection	Internal Information
.MTA.uptime	Time string describing when this MTA came up
.MTA.connections.broken	The number of broken connections encountered by the MTA
.MTA.connections.failed	The number of failed connections from the MTA to another MTA
.MTA.connections.rejected	The number of rejected connections
.MTA.connections.rejection_ reason	Description of reason for most recent rejection
.MTA.connections.out.current	The current number of outbound SMTP connections
.MTA.connections.out.current _foreign	The current number of outbound SMTP connections to MTAs in foreign domains
.MTA.connections.out.current _native	The current number of outbound SMTP connections to MTAs in native domains
.MTA.connections.out.total	The total number of outbound SMTP connections
.MTA.connections.out.total_ foreign	The total number of outbound SMTP connections to foreign domains
.MTA.connections.out.total_ native	The total number of outbound SMTP connections to MTAs in native domains
.MTA.dl.receive.count	The number of messages sent to distribution lists
.MTA.msgs.deferred.current	The current number of messages deferred
.MTA.msgs.deferred.total	The total number of messages deferred
.MTA.msgs.delivered.totaltim e	The total time inserting data into db (ms)
.MTA.ndr.inbound	The total number of non delivery reports generated by inbound mail
.MTA.ndr.loop	The total number of messages not delivered due to mail loops
.MTA.ndr.outbound	The total number of non delivery reports generated by outbound mail
.MTA.queued.out.kbytes	The kilo bytes queued awaiting to be sent out to the Internet
.MTA.queued.out.messages	The messages queued awaiting to be sent out to the Internet
.MTA.transmit.bytes	The total number of bytes transmitted
.MTA.transmit.bytes_foreign	The total number of bytes transmitted to foreign domain MTA's
.MTA.transmit.bytes_local	The total number of bytes transmitted to local entities
.MTA.transmit.messages	The total number of messages transmitted
.MTA.transmit.messages_ foreign	The total number of messages transmitted to foreign domain MTA's
.MTA.transmit.messages_local	The total number of messages transmitted to local entities
.MTA.transmit.messages_ native	The total number of messages transmitted to native domain MTA's
.MTA.transmit.messages_relay	The total number of messages transmitted during relay operations
.MTA.transmit.recipients	The total number of recipients transmitted
.MTA.transmit.recipients_ foreign	The total number of recipients transmitted to foreign domain MTA's
.MTA.transmit.recipients_ local	The total number of recipients transmitted to local entities
.MTA.transmit.recipients_ native	The total number of recipients transmitted to native domain MTA's
.MTA.transmit.time	The total time transmitting data (ms)
.MTA.transmit.time_foreign	The total time transmitting data to foreign domain MTA's (ms)
.MTA.transmit.time_native	The total time transmitting data to native domain MTA's (ms)
.MTA.transmit.time.local	The total time spent transmitting data to local entities (ms)
.MTA.transmit.time.relay	The total time transmitting data during relay operations (ms)

Housekeeping Statistics

The following is a list of housekeeping server statistics and their descriptions:

Statistic	Description
.GC.processed.expi rables	The number of message instances expired by a particular housekeeping process
.GC.processed.prun ables	The number of message instances removed from the system trash folder by a particular housekeeping process
.GC.processed.queu ed_prunables	The number of message references removed from the system trash queue by a particular housekeeping process
.GC.processed.coll ectables	The number of unreferenced messages removed from the system by a particular housekeeping process
.GC.processed.tert iary_storables	The number of messages moved to tertiary storage by a particular housekeeping process
.GC.pending.expira bles	The number of message instances awaiting expiration remaining in the system
.GC.pending.prunab les	The number of message instances remaining in the system trash folder
.GC.pending.queued _prunables	The number of message references remaining in the system trash queue.
.GC.pending.collec tables	The number of identified unreferenced messages remaining in the system
.GC.pending.tertia ry_storables	The number of messages eligible for tertiary storage remaining in the system

List Server Statistics

The following is a list of list server statistics and their descriptions:

Statistic	Description
.DUMP.OIDStatus.Connection	Internal information.
.SLIST.connections.busy	The number of busy database connections
.SLIST.connections.total	The total number of database connections
.SLIST.process.current_mail_ threads	The number threads running in the server processing mails
.SLIST.process.current_mails	The number of mails being processed in the server
.SLIST.process.current_user_ threads	The number of threads running in the server that are delivering mails to users
.SLIST.process.total_mails	The total number of mails that have been processed by the server since startup
.SLIST.queue.pending	The number of mails waiting to be processed by the list server
.um.admin.os_pid	The operating system process ID
.um.admin.uptime	The amount time the server has been up

A Server Statistics