Answer / guest

It is dba_free_space which gives u the info about free
space in any tablespace

Regards
Abhinav

Answer / shruthi

It is sm$ts_free.......

Answer / rajesh naidu

SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

AND THE VIEW IS DESC DBA_FREE_SPACE;

Give the reasoning behind using an index.

2 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

how can you record information about current session?

0 Answers   Oracle,

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---