-
-
-
-
-
-
-
Is it possible to configure primary server and stand by server on different OS?
Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.
-
-
-
What is the view name where i can get the space in MB for tables or views?
select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name
-
What are the Advantages of Using DBCA
These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide varying levels of detail. You can provide a minimum of input and allow Oracle to make decisions for you, eliminating the need to spend time deciding how best to set parameters or structure the database....
-
-
-
-
-
Oracle Reserved Memory and Unreserved Memory
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
-
-
-
-
Oracle DBA Interview Questions
Ans