Interested to Buy Any Domain ? << Click Here >> for more details...
how do see how much space is used and free in a tablespace
- 2 Answers
- 7793 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / anil kumar prajapati
olumn "Tablespace" format a13
column "Used MB" format 99,999,999
column "Free MB" format 99,999,999
column "Total MB" format 99,999,999
select
fs.tablespace_name "Tablespace",
(df.totalspace - fs.freespace) "Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
(select
tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes) / 1048576) FreeSpace
from
dba_free_space
group by
tablespace_name
) fs
where
df.tablespace_name = fs.tablespace_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is the diffrence between core dba and apps dba?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the steps you will take to improve performance of a poor performing query?
What types of replication are supported in sql server? : sql server DBA
what is grd?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How to start SQL Server in minimal configuration mode?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is asm?
how does an oracle clusterware manage crs resources?
