What is an Oracle Instance? Where it is present and How does it perform?
Latest Answer: Oracle Instance is a memory component of Oracle server which is a combination of memory structure and background processes..It is a means to access data in a database i.e., it is a path way to access data. ...
What is meant by excessive log in hot backup?
Where will the transactions be stored during Hot Backup?
During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions
When we trace the control file how many datafiles are created?
Latest Answer: No data files are created when we trace a control file. Tracing will create a word format of control file with all the information of data base (datafiles, log switching etc). ...
How to convert dictionary managed tablespace to locally managed tablespace?
Latest Answer: You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');where ts_dm is the name of tablespace that need to be converted to locally managed tablespace. ...
How many redo log group are there in Oracle 10g database? What are they?
Latest Answer: At Least 2 groups. To protect against a failure involving the redo log itself, Oracle Database allows a multiplexed redo log, meaning that two or more identical copies of the redo log can be automatically maintained in separate locations. For the most ...
Can we create tablespace without segments if yes then how?
Latest Answer: For what reason you want to create tablespace without segments. Answer is no ...
What are Synonyms and Sequence?
Latest Answer: Synonym - Giving alias of the existing database object. The need of synonym is to access the other schema objects easily.. (for Eg.. If you want to access gl_list table from GL schema object, you usually query with GL.gl_list, If we create synonym gl_list_s ...
How to configure the LANFree backup using TSM in TBM AIX Platform?
What is cache hit ratio in Oracle 9i?
View page << Previous 1 [2] 3 4 5 6 7 8 9 Next >>
Go Top
