Re: which instance gets more traffic

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

Yo Kris,

Compare the various values from V$SYSSTAT from both instances (assuming they were brought down/up at the same time). Things to look for: Cumulative/Current logons, Commits, CPU used, db_block_gets, physical reads/writes, table scans, sorts, etc...

Does this help?

-- 
John Kanagaraj
http://www.geocities.com/john_sharmila

Disclaimer : The opinions expressed above are my own and do 
not reflect those of MFI or its associates