Store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace application specific data in respective tablespaces.Place all these tablespaces in saperate disks.Try to implement raid-0 (striping) for better performance.
What is self-referential integrity constraint in Oracle?
Explain the different type of Integrity Constraints supported by ORACLE?
Tell me how to define Data Block size?
What are Schema Objects in Oracle?
What are the type of Synonyms in Oracle?
What are the advantages of Views in Oracle?
What is a Public Synonyms in Oracle?
What is a Private Synonyms in Oracle?
What are the Characteristics of Data Files in Oracle?
What is high watermark in oracle?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
