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
What is meant by Shared pool fragmentation.
My platform is Enterprise Linux (RHEL AS4) How to find BLOCK SIZE.
Migration and Changing are two distinctly different types of problems that can exist when a row is too large to fit into a single data block.Row Changing:: Row changing occurs when a row is too large to
Latest Answer: RAM means Random access memory, which is used as a temporary memory space to load Operating system kernel, driver modules and services needed on the system. Whenever you switch off the system all the RAM memory contents are lost. Hard disks are for permanent ...
Latest Answer: The difference is Application server provides some features:Multi-threading, persistence, security & Transperant, which supports various protocols.Where as, Web-server doesn't supports that features. Applications server includes in Web-server.Application ...
Latest Answer: All the changes to the init.ora file is recorded in the alert.log file. So,go to the alert log file in bdump directory and delete the unnecessary parameters from the file and copy that file to the desired location and restart the database. ...
Latest Answer: Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks) ...
Latest Answer: when a user updated a particular table (for example 100 rows)...the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback ...
Latest Answer: there are main two causes for reparsing1)the objects which the query is refrencing has been modified 2) or the parsed version of sql text has been aged out of the library cache. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
