Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Control Files Control files contain[…]
Read moreAuthor: mfadmin
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 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 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 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 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 moreLogical Structures,”Tablespaces, Segments, Extents
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Logical Structures,”Tablespaces, Segments, Extents Oracle[…]
Read morePhysical Structures,”Data Files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Physical Structures,”Data Files OS blocks”
Read moreTablespaces,”Tablespaces are the first level of logical organization of your physical storage. Each tablespace is responsible for organizing one or more data files. Typically, each tablespace might start attached to one data file, but as the database grows and your files become large
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Tablespaces,”Tablespaces are the first level[…]
Read moreSegments,”Segments are the next logical storage structure next to tablespaces. Segments are objects in the database that require physical storage and include the following:TablesIndexesMaterialized viewsPartitionsWhenever you create a segment
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Segments,”Segments are the next logical[…]
Read more