What view would you use to look at the size of a data file?
Answer Posted / guest
We can see the size of a datafile by querying given 2 views
dba_data_files and v$datafile
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What happens on checkpoint? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is grd?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Which autogrowth database setting is good? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
internal architecture
What is a system database and what is a user database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How would you extract DDL of a table without using a GUI tool?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can a session indicate its interest in receiving alerts?