What view would you use to look at the size of a data file?
Answer Posted / suman
we can see the size of datafile that is we have two views
1. dba_data_files
2. v$datafile
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you record information about current session?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what are the differences of where and if in SAS?
how does an oracle clusterware manage crs resources?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the role of dip user in our database?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is replication? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?