how will u see whether the dabase is in archive log mode or not?
Answer Posted / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is transparent data encryption? : sql server DBA
Explain materialized views and how they are used.
What is fill factor? : sql server DBA
what is the use of ocr?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is replication? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
which background process invoke at the time of upgradation tell me???
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How would you go about verifying the network name that the local_listener is currently using?
What are the different types of indexes available in sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What are the different sql server versions you have worked on? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?