- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to get exact percentage of Oracle data files b...
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
Forums
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
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
тАО03-13-2004 04:58 PM
тАО03-13-2004 04:58 PM
How to get exact percentage of Oracle data files became full ?
I would to like to know that any direct method or direct query is available in Oracle Data base, to find out the how much percentage of Oracle data files is fulled ?
The tablespaces of that data fiels has unlimited max_extents and on data files the auto_extend feature is on.
(I think generally we will get these details from DBA_EXTENTS and DBA_SEGMENTS and DBA_FREE_SPACE tables.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2004 06:02 PM
тАО03-13-2004 06:02 PM
Re: How to get exact percentage of Oracle data files became full ?
They have a hard limit of 100 extents.
You should either defragment the database or manually increase max_extents
As stupid as that sounds same thing happened to us.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2004 12:20 AM
тАО03-14-2004 12:20 AM
Re: How to get exact percentage of Oracle data files became full ?
I find that ixora is often good starting point for these queries. That is queries that surely have been solved before.
http://www.ixora.com.au/
search for DBA_FREE_SPACE gives a likely solution:
http://www.evdbt.com/chk_spc.sh
and
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:112012348062
and many more...
This forum also has prior solution. Just use 'search' for DBA_FREE_SPACE or Oracle AND free and tablespace or some such query:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=328266
Enjoy,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2004 06:24 PM
тАО03-14-2004 06:24 PM
Re: How to get exact percentage of Oracle data files became full ?
select file_id,a.total,b.free,(a.total-b.free) used from
(select file_id,sum(bytes) from dba_data_files group by file_id) a,
(select file_id,sum(bytes) from dba_free_space group by file_id) b
where a.file_id = b.file_id group by file_id;
This will give you total/free/used space on the datafiles. Not sure if this is what you are looking for though.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2004 01:23 AM
тАО03-16-2004 01:23 AM
Re: How to get exact percentage of Oracle data files became full ?
set timing off
set time off
set linesize 160 pagesize 100
set verify off
set feedback off
set colsep ' | '
col FILE_NAME format A75
col TABLESPACE_NAME format A25
select
a.file_name,
a.tablespace_name,
round(a.total/(1024*1024)) as "TOTAL (Mo)",
round(b.free/(1024*1024)) as "FREE (Mo)",
round((a.total-b.free)/(1024*1024)) as "USED (Mo)",
round(((a.total-b.free)/total)*100, 2) as "% OCCUPATION"
from
(select file_id,file_name,tablespace_name,sum(bytes) total
from dba_data_files
group by file_id,file_name,tablespace_name) a,
(select file_id,sum(bytes) free
from dba_free_space
group by file_id) b
where
a.file_id = b.file_id
order by
a.tablespace_name
/