Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.A database stores data and[…]
Read moreCategory: Database
PMON,”It monitors all the other background processes. When a server or dispatcher process terminates abnormally, it performs process recover.Cleans up the database buffer cache and freeing resources that were allocated for client process. It releases the resources held by failed user process, rolls back the transaction that caused the process to fail, and releases the row and table level locks held by the failed user process. PMON rolls back the transaction that caused the process to fail
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.PMON,”It monitors all the other[…]
Read moreSurrogate Key
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Surrogate Key a primary key[…]
Read moreSMON
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SMON Is in charge of[…]
Read moreTable names are written how?,”All capital letters ex. STUDENT, COURSE
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Table names are written how?,”All[…]
Read moreTempfile,”a tempfile is a special type of database file. Physically, it’s just like a regular data file, but it only holds temporary information. For example
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Tempfile,”a tempfile is a special[…]
Read moreParity
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Parity Parity is a mathematical[…]
Read moreLarge pool,”is an optional memory area in the SGA. It is intended for memory allocations that are larger than is appropriate to store in the shared pool. Eg
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Large pool,”is an optional memory[…]
Read moreControl Files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Control Files Control files contain[…]
Read moreDiskspaces,”Raw devices, – unformatted disk partitionsAutomatic storage management, – File System
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Diskspaces,”Raw devices, – unformatted disk[…]
Read more