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

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

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

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---