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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the commands used in dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you process messages in order asynchronously?
Why does Oracle not permit the use of PCTUSED with indexes?
What is fill factor? : sql server DBA
how can you connect from 10g user to 11g user??
What are the steps you will take to improve performance of a poor performing query?
what are the types of connection load-balancing?