Home » RDBMS Server » Server Administration » space allocated to user
space allocated to user [message #153034] Wed, 28 December 2005 09:13 Go to next message
gjayasekar
Messages: 45
Registered: October 2005
Member
Hi,


I want to Know space allocated to user and space used by user

Thanks

Jai

Report message to a moderator

Re: space allocated to user [message #153077 is a reply to message #153034] Wed, 28 December 2005 22:12 Go to previous message
wwllzpz
Messages: 11
Registered: December 2005
Location: shanghai china
Junior Member
you can execute following sql

Select tablespace_name,
DECODE(MAX_BYTES, -1, 'Unlimited', MAX_BYTES/1024) "Quota",
BYTES/1024 "Used Space",
DECODE(MAX_BYTES, -1, 0, ROUND((BYTES/MAX_BYTES)*100, 2)) "Percent Used"
FROM dba_ts_quotas
WHERE USERNAME=:uname;

the sql return how many space allocated to user .

Report message to a moderator

Previous Topic: NLS_DATE_FORMAT
Next Topic: view what is stored in a datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:33:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.