How many types of log file in Oracle ?
Answers were Sorted based on User's Feedback
Answer / naveen
Archive logs
redo logs
Online Redo logs
Offline redo logs
-------------
Alert logs -> check the oracle system logs
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / naveen
The off line redo logs may be in 2 states
1. Active
2. Inactive.
Is This Answer Correct ? | 0 Yes | 2 No |
What is the tablespace? difference between Offline redolog files and online redolog files? Datafiles? Resizing table space how wil do?
what is the Tcode to See Global Logged in Users list?
how can we create a particular tables buffer which are mostly used/ And where we can see them ?
how do you solve oracle archive struck?
How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?
how to check the TRANS directory size and what is its default value?
a backroungd job is running...it should have finished in 30min but it is runing for long one day...if you check the process in sm50 it is running and if you check the pid in task manager it is running....it is not hanged and job log does not have error...what will you do to troubleshoot it and how will you convince the particular job owner for killing and rescheduling ?
How to solve if more swaps are occurred?
What is Unit Testing in SAP?
how to find if there are an expensive sql statements running.if yes,what to do?
dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?
What is the difference between pfile and spfile?