Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Database and System Throughput
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: c-glenn.travis_at_wcom.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Apr 25 2001 - 16:06:40 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |