A
Server Statistics

The DBMS_STATS package generates statistics for the entire Oracle Email 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. 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 chapter contains the following topics:

POP3 Statistics

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

Table A-1

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.currthre ads	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.Con nection	Internal Information
.DUMP.Threads.dump	Internal Information
.ESPROTO.uptime	The amount of time the server has been up
.ESPROTO.COMMAND.to tal	total number of commands executed
.ESPROTO.COMMAND.<P O3_COMMAND>.success	where PO3_COMMAND is one of the commands defined by the POP3 protocol
.ESPROTO.COMMAND.<P O3_ COMMAND>.totalcalls	The total number of calls for that command
.ESPROTO.COMMAND.<P O3_COMMAND>.fail	The total number of failed calls for that command
.ESPROTO.USERS.LOGI N.<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.connection s.lost	The total number of client connections that have disconnected
.ESPROTO.connection s.timeout	The total number of client connections that have timed out.
.ESPROTO.connection s.total	The total number of client connections
.ESPROTO.receive.by tes	The total number of bytes received by the server
.ESPROTO.transmit.b ytes	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

Table A-2

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.currthre ads	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.Con nection	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.messag es	The total number of messages received
.MTA.receive.recipi ents	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.messa ges	The total number of messages transmitted
.MTA.transmit.messa ges_loca	The total number of messages transmitted to local entities
.MTA.transmit.recip ients	The total number of recipients transmitted
.MTA.transmit.recip ients_local	The total number of recipients transmitted to local entities

SMTP In Statistics

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

Table A-3

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.currthre ads	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.Con nection	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.messag es	The total number of messages received
.MTA.receive.recipi ents	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.messa ges	The total number of messages transmitted
.MTA.transmit.messa ges_loca	The total number of messages transmitted to local entities
.MTA.transmit.recip ients	The total number of recipients transmitted
.MTA.transmit.recip ients_local	The total number of recipients transmitted to local entities
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.currthre ads	The number of threads the server is currently using

SMTP Out Statistics

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

Table A-4

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.Con nection	Internal Information
.MTA.uptime	Time string describing when this MTA came up
.MTA.connections.br oken	The number of broken connections encountered by the MTA
.MTA.connections.fa iled	The number of failed connections from the MTA to another MTA
.MTA.connections.re jected	The number of rejected connections
.MTA.connections.re jection_reason	Description of reason for most recent rejection
.MTA.connections.ou t.current	The current number of outbound SMTP connections
.MTA.connections.ou t.current_foreign	The current number of outbound SMTP connections to MTAs in foreign domains
.MTA.connections.ou t.current_native	The current number of outbound SMTP connections to MTAs in native domains
.MTA.connections.ou t.total	The total number of outbound SMTP connections
.MTA.connections.ou t.total_foreign	The total number of outbound SMTP connections to foreign domains
.MTA.connections.ou t.total_native	The total number of outbound SMTP connections to MTAs in native domains
.MTA.dl.receive.cou nt	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 .totaltime	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.kby tes	The kilo bytes queued awaiting to be sent out to the Internet
.MTA.queued.out.mes sages	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.messa ges	The total number of messages transmitted
.MTA.transmit.messa ges_foreign	The total number of messages transmitted to foreign domain MTA's
.MTA.transmit.messa ges_local	The total number of messages transmitted to local entities
.MTA.transmit.messa ges_native	The total number of messages transmitted to native domain MTA's
.MTA.transmit.messa ges_relay	The total number of messages transmitted during relay operations
.MTA.transmit.recip ients	The total number of recipients transmitted
.MTA.transmit.recip ients_foreign	The total number of recipients transmitted to foreign domain MTA's
.MTA.transmit.recip ients_local	The total number of recipients transmitted to local entities
.MTA.transmit.recip ients_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:

Table A-5

Statistic	Description
.GC.processed.expir ables	The number of message instances expired by a particular housekeeping process
.GC.processed.pruna bles	The number of message instances removed from the system trash folder by a particular housekeeping process
.GC.processed.queue d_prunables	The number of message references removed from the system trash queue by a particular housekeeping process
.GC.processed.colle ctables	The number of unreferenced messages removed from the system by a particular housekeeping process
.GC.processed.terti ary_storables	The number of messages moved to tertiary storage by a particular housekeeping process
.GC.pending.expirab les	The number of message instances awaiting expiration remaining in the system
.GC.pending.prunabl es	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.collect ables	The number of identified unreferenced messages remaining in the system
.GC.pending.tertiar y_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:

Table A-6

Statistic	Description
.DUMP.OIDStatus.Con nection	Internal information.
.SLIST.connections. busy	The number of busy database connections
.SLIST.connections. total	The total number of database connections
.SLIST.process.curr ent_mail_threads	The number threads running in the server processing mails
.SLIST.process.curr ent_mails	The number of mails being processed in the server
.SLIST.process.curr ent_user_threads	The number of threads running in the server that are delivering mails to users
.SLIST.process.tota l_mails	The total number of mails that have been processed by the server since startup
.SLIST.queue.pendin g	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