Answer / guest

We can see the size of a datafile by querying given 2 views
dba_data_files and v$datafile



Regards
Abhinav Phadnis

Answer / ramesh

v$datafile and v$tablespace Views

select v.FILE#,t.NAME,v.TS#,v.BLOCKS,v.BLOCK_SIZE from
v$datafile d,v$tablespace t where v.v.TS# =t.TS#

Cheers,
Ramesh

Answer / suman

we can see the size of datafile that is we have two views
1. dba_data_files
2. v$datafile

what is incremental checkpoint?

1 Answers   CTS,

---

what is a user-defined lock?

1 Answers   Oracle,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

1 Answers   HSBC,

---

How to start SQL Server in minimal configuration mode?

2 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

What view would you use to look at the size of a data file?

3 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

Which autogrowth database setting is good? : sql server DBA

1 Answers  

---