Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Redo Log files,”Redo log files[…]
Read moreTag: db
Database,”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 moreServer and Initialization parameter files,”PFILEs and SPFILEs have information about how your running database is configured. This is where you configure the following settings:Memory sizeDatabase and instance nameArchiving parametersProcessesOver 1,900 other parametersWhenever you start your database
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Server and Initialization parameter files,”PFILEs[…]
Read more