Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Java pool It stores all[…]
Read moreCategory: Database
Redo Log files,”Redo log files store the information from the log buffer. They’re written to by the Log Writer (LGWR). Again, you can’t read these binary files without the help of the database software. Redo log files don’t record select statements. If you forget what you selected
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Redo Log files,”Redo log files[…]
Read moreDatabase,”A database is a set of files, located on disk
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Database,”A database is a set[…]
Read moreStreams pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Streams pool is used exclusively[…]
Read moreHow many groups are appropriate?,”The most common configuration we come across is three. You want enough that the first group in the list can be copied off and saved before the LGWR comes back around to use it. If it hasn’t been copied off, the LGWR has to wait until that operation is complete. This can severely impact your system. Thankfully
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.How many groups are appropriate?,”The[…]
Read moreDatabase Instance
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Database Instance a set of[…]
Read moreHow many members are appropriate?,”It depends on how paranoid you are. Two members on two disks seems to be pretty common. However, it isn’t uncommon to see three members on three disks. More than that and you’re just plain crazy. Well, not really. It’s just that the more members you have
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.How many members are appropriate?,”It[…]
Read moreSystem Global Area (SGA),”shared poolShared sql area, private sql areaData dictionary cache, Reserved poolServer Result cache
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.System Global Area (SGA),”shared poolShared[…]
Read moreArchive log files,”Archive log files are simply copies of redo log files. They’re no different from redo log files except that they get a new name when they’re created. Most archive log files have the extension .ARC, .ARCH
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Archive log files,”Archive log files[…]
Read moreBackground Process,”PMON, SMON, DBWn, LGWR, CKPT
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Background Process,”PMON, SMON, DBWn, LGWR,[…]
Read more