Re: CPU usage per schema

From: <yong321_at_yahoo.com>
Date: 5 Feb 2007 17:00:19 -0800
Message-ID: <1170723619.212720.289590@m58g2000cwm.googlegroups.com>

On Feb 6, 12:07 am, "Valentin Minzatu" <valentinminz..._at_yahoo.com> wrote:
> Did you try to find out from v$sql or v$sqlarea which are the users
> executing the top CPU consuming queries showed by the statspack run?

v$sql(xxx) views have the user that initially parsed the cursor. Whoever executes the cursor can be different. But if you're absolutely sure nobody runs somebody else's cursor, that's fine.

Yong Huang Received on Mon Feb 05 2007 - 19:00:19 CST