Re: How to determine oracle user size?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 19 Feb 2009 05:42:33 -0800 (PST)
Message-ID: <b2172ec5-9ba4-45c1-847a-3c6eb1015ea3_at_t13g2000yqc.googlegroups.com>



On Feb 18, 9:15 pm, Ming伯 <l..._at_tech-trans.com> wrote:
> Hi
>
> Any SQL statement can find the Oracle user/owner size when more than
> one user in a Oracle instance? Thx!
>
> Ming

Ming, are you asking how to calculate how much storage space a user's object use, in which case Ram provided the answer, or how much memory each user session is using?

For the second item see the v$sesstat and v$statname.

HTH -- Mark D Powell -- Received on Thu Feb 19 2009 - 07:42:33 CST

Original text of this message