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: if ur pfile and spfile both lost then u can do one thing that check alert log file and check necessary parameter for pfile and take that necessary parameter from there and create pfile from that and u can start your 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. ...
Latest Answer: Segments The level of logical database storage above an extent is called a segment. A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace. For example, each table's ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
