what is the meaning of this query Alter database force
logging.

Answer Posted / gouse

Oracle does not give the DBA a lot of control over redo
generation. If the instance crashes, then all the changes
within SGA will be lost. Oracle will then use the redo
entries in the online redo files to bring the database to a
consistent state. The cost of maintaining the redolog
records is an expensive operation involving latch management
operations (CPU) and frequent write access to the redolog
files (I/O). You can avoid redo logging for certain
operations using the NOLOGGING feature.

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi. I wish to appear for OCA exam. Can anyone pls guide me on the syllabus n fee structure of the exam. I know that there are 2 tracks : developer and dba. What is the difference between the two? All suggestions are welcome. Thanks.

2410


hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?

2083


How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.

2269


I completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.

2276


being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me

1731






hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

1739


Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

2153


hai, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.

1655


I would like to know about Oracle Online Course certification (Finance)

2652


HI, I have completed my M.com and MBA and currently working in IT sector in HR Recruitment. i just want to do Oracle HRMS functional course. And is there is any study center in Coimbatore from where i can do this certification.

1918


Hi , I am planning to take up OCA certification.Can you please provide me with the path for Oracle DBA certi.If any one of you have dumps for same,please mail them to sajagporwal123@gmail.com.Please give me any tips if possible.

1490


im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions

2185


Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?

1026


i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

2188


Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.

1976