- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Check each oracle user account on disk usage
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2003 09:50 PM
тАО01-22-2003 09:50 PM
Any idea to check the disk usage consumed by each user account ?
I am thinking of checking the dba_segment view "select owner, segment_type, sum(bytes) from dba_segments group by owner, segment_type;"
However, it will not display those users without database object created .....therefore I start thinking of correlate the dba_segment view with dba_users view....
Any idea to correlate them ?
Thanks,
Chris,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2003 11:40 PM
тАО01-22-2003 11:40 PM
Solutioncan you try the script below, to see if you are getting the desired output?
select decode(lag(username) over (partition by username order by segment_type), username, null, username) Owner, segment_type, sum(bytes)
from dba_segments, dba_users
where username=owner(+)
group by username,owner,segment_type;
hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2003 11:42 PM
тАО01-22-2003 11:42 PM
Re: Check each oracle user account on disk usage
a better formatted one would be:
column MB format 9,999.99
select decode(lag(username) over (partition by username order by segment_type), username, null, username) Owner, segment_type, sum(bytes)/1024/1024 MB
from dba_segments, dba_users
where username=owner(+)
group by username,owner,segment_type;
and will display the size in MB instead of bytes
Hope this helps!
Best Regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 01:19 PM
тАО01-23-2003 01:19 PM
Re: Check each oracle user account on disk usage
select username,nvl(used_space,'0') from
(select owner,sum(bytes) used_space from
dba_segments group by owner) b, dba_users a
where a.username = b.owner(+);
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 05:11 PM
тАО01-23-2003 05:11 PM
Re: Check each oracle user account on disk usage
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x4177ef70e827d711abdc0090277a778c,00.html
I believe one or more of them might be useful.
P
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com