RE: which instance gets more traffic

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Mon, 6 Nov 2000 14:35:29 -0600
Message-Id: <10672.121243@fatcity.com>

What type of operating system? You might try iostat on UNIX (unless you're using completely mixed RAID5)to determine which disks are getting the heaviest hits. Also try v$sysstat. This will give you an overview of statistics that you can use to do further research. Running utlbstat and utlestat against both instances for the same period will also get you some usage data.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Kris Austin [mailto:kaustin_at_advance.net] Sent: Monday, November 06, 2000 12:22 PM To: Multiple recipients of list ORACLE-L Subject: which instance gets more traffic

hi.

if you have more than one instance on a box, is there a quick way to see which instance uses the most system resources?

thanks,
kris

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kris Austin
  INET: kaustin_at_advance.net

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-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). Received on Mon Nov 06 2000 - 14:35:29 CST