Re: How to determine oracle user size?

On Feb 19, 7:05 am, Ming伯 <l...@xxxxxxxxxxxxxx> wrote:
On 2月19日, 下午12時47分, Ram <krishna...@xxxxxxxxx> wrote:





On Feb 19, 7:15 am, Ming伯 <l...@xxxxxxxxxxxxxx> wrote:

Hi

Any SQL statement can find theOracleuser/ownersizewhen more than
oneuserin aOracleinstance? Thx!

Ming

Hi,

select sum(bytes/1024/1024)"size" from dba_segments where
owner='&owner';

Regards

RAM

RAM,

I executed the your sql statement but no result acquired. Any idea?

Ming

I note that simply cutting and pasting the command gives no results,
but subsequently entering / it asks for the username, which must be
entered in caps, unless you've created a user in mixed case (as some
non-Oracle tools or special use of quotes can do). You'll also get an
ORA-942 error if you don't have access to dba_segments, perhaps the
reasone for the SYSDBA comment by Paulie.

Whether this accurately conveys the size of the user is debatable, you
need to specify for what purpose. For example, the command says one
of my users is 45525.6875, EM says 45,527.1MB, while exporting the
user is only 34G. That users tablespace is 46,200MB. Do I need to
freak out that I'm about to run out of space? I hope it is obvious
that there is insufficient information here to answer such a
question. (And in fact, EM tells me I can get gigabytes back if I
shrink certain objects, but then I don't get it back. Looking at it
this way, anyways, which brings up the important points, that it is
difficult to evaluate free space in blocks exactly, not trivial to
evaluate free space in tablespaces, and users may not control how much
space they are really using.).

jg
--
@home.com is bogus.
http://www.datacenterknowledge.com/the-gallery-of-exploding-servers/
.

Relevant Pages

  • Weird disk problem
    ... Using QTParted I discovered the second disk has a lot of free space. ... I can not use it to allocate a new partition, ... But fdisk doesn't recofnize the space at all. ... Command: p ...
    (Fedora)
  • Re: Move Home to 2nd drive
    ... Prior to the upgrade the 1st ... drive had 2.2Gb free space on it. ... Any quick/easy command line suggestions on how to do this? ... sudo mv /home /home.bak ...
    (Ubuntu)
  • Re: SDI Manager
    ... Packs the file by removing free space and moves the binary large object ... of type BOOT to first BLOB position. ... pack is used with some type of boot scenarios for BLOB sort and alignment ... > This command removes all unused space from the file. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Hard Drive showing 0 bytes available
    ... Boot into normal mode. ... I also recommend that you run this command: ... In Safe mode, it shows 0 bytes for both total space and free space, you ...
    (microsoft.public.windowsxp.general)
  • Re: checktable with repair_rebuild
    ... Microsoft SQL Server Storage Engine ... > how much space you need in tempdb. ... Could anyone tell me how much free space is needed to run DBCC ... >> any command that I can use to use Tempdb for the rebuild process instead ...
    (microsoft.public.sqlserver.server)