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;

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

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

2 Answers   TCS,

---

What is dcl? : sql server DBA

0 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---