What is meant by redo log buffer ?
Answers were Sorted based on User's Feedback
Answer / guest
Redo log buffer is mermory where oracle server store all
the latest transaction which is made by the user.If RLB is
going to fill one third log writer writes the data from
redo log buffer to log file.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / deva
This buffer contains the information about the changes of
datablocks in the database buffer. While the redo log
buffer is filled during data modifications. The log writer
process wirtes information about the nmodifications to the
redo log files. These files are used after eg a system
crash in order to restore the database(database recovery)
| Is This Answer Correct ? | 4 Yes | 0 No |
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What would you use to improve performance on an insert statement that places millions of rows into that table?
What is a snapshot log?
Is oracle the best database?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Give the advantages and disadvantages of clusters.
What is a sub query and what are the different types of subqueries?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
How do I find my oracle client driver version?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,