Logo F2FInterview

Memory Management Interview Questions

Q   |   QA

Yes.
The advantages over file system files.
I/O will be improved because Oracle is bye-passing the kernnel which writing into disk.
Disk Corruption will be very less.

The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is in a valid state to USE.
The Control file is not accessible, the database does not function properly.

By using dictionary view's called v$rollstat,dba_rollback_segs.

This can be monitored in DB_data_files.

Due to syntax errors.

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: