-
-
-
It is possible to use raw devices as data files and what is the advantages over file. system files ?
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.
-
Materialized View Refresh
Hi All,I have a Materialized views Group, on this group I have 57 MVs these are all created on Master data (OLAP) log files and we have dependency schedule to run this jobs. Load dependency is like (MD tabs Then Log files MVs) this is not a problem with us.For 57 views to get updated (refreshed) in 4 hours in these views one view is taking nearly 2 hours to update. We are updating this group...
-
Enterprise Linux OS Block Size
My platform is Enterprise Linux (RHEL AS4) How to find BLOCK SIZE.
-
What is a logical backup?
Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.
-
-
-
-
-
-
What is the use of PARFILE option in EXP command ?
Name of the parameter file to be passed for export.
-
-
Oracle Memory Management Interview Questions
Ans