I have been tasked with gathering statistics which will detail the throughput on our Database Servers. In addition to 'performance' metrics, I am looking for scripts/commands in both the database and on unix (solaris) which will show me my system's potential. Things like 'io per hour', 'transactions per second/minute', 'active sessions per x', things which will document how much the system (database and unix) is doing. Obviously this is for future growth concerns. I am soliciting this list to see if anyone can point me to the appropriate commands (unix) and scripts (tables) in Oracle to gather this information. FYI: I have run utlbstat and will run utlestat to get numbers this utlity provides. On unix, I am running sar (5 second intervals). Is there anywhere else I can gather throughput information? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
