What view would you use to look at the size of a data file?
- 3 Answers
- 7430 Views
- I also Faced
- E-Mail Answers
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is a user-defined lock?
What is replication? : sql server DBA
what are the types of connection load-balancing?
Can you redefine a table online?
how can you enable flashback feature?
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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you schedule a job in database?
What is the default port no on which sql server listens? : sql server DBA
what functionality does oracle provide to secure sensitive information?
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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain about your sql server dba experience? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
