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
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.
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 .?
How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.
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.
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..
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.
I would like to know about Oracle Online Course certification (Finance)
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.
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.
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?
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?
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.