Answer / ramesh

System Tablespace is Created when a New oracle Database is
created.
It,s Not-> while Creation of Tablespace
However ,Ensure No user objects created in System Tablespace

Cheers,
Ramesh

Answer / deepak

system tablespace

Answer / nagarani k

system and sysaux tablespaces are automatically created in
oracle 10gR2 when database created

Answer / guest

It is SYSTEM tablespace which get automatically get created
whenever we create any tablespace


Regards
Abhinav Phadnis

Answer / md azhar alvi

At the time of database creation SYSTEM.DBF AND SYSAUX.DBF tablespaces are created.

SYSTEM.DBF contains the data dictionary views and objects which in owned by sysdba.

in oracle 11g if we are omitting the creation of sysaux.dbf tablespace oracle will automatically create the sysaux.dbf tablespace.

sysaux.dbf contain repository values of oracle tools.

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

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

1 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

Name two files used for network connection to a database.

5 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

wat is global index and local indes

1 Answers   Oracle,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---