Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SGA components Shared poolDatabase buffer[…]
Read moreAuthor: mfadmin
Cache,”A cache is a temporary area in memory created for a quick fetch of information that might otherwise take longer to retrieve. For example, the cache’s mentioned in the preceding list contain pre-computed information. Instead of a user having to compute values every time
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Cache,”A cache is a temporary[…]
Read moreparsing,”Each time you execute a SQL statement, a lot happens in the background. This background activity is called parsing. Parsing can be quite expensive.During parsing, some of these things happen:The statement syntax is checked to make sure you typed everything correctly.The objects you’re referring to are checked. For example, if you’re trying access a table called emp
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.parsing,”Each time you execute a[…]
Read moreProcesses,”Again, Oracle processes only exist when the instance is running. The running instance has some core mandatory processes, whereas others are optional
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Processes,”Again, Oracle processes only exist[…]
Read moreFiles and structures,”Files associated with the database exist all the time — as long as a database is created. If you just install Oracle, no database files exist. The files show up as soon as you create a database. As with memory and process, some files are required whereas others are optional. Files contain your actual database objects: the things you create as well as the objects required to run the database. The logical structures are such things as tables, indexes
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Files and structures,”Files associated with[…]
Read moreFacts about instances,”You can set up multiple instances to access the same set of files or one database.An instance can only access one database.A database can exist without an instance
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Facts about instances,”You can set[…]
Read moreRAC,”RAC(Real application cluster) uses Oracle’s clustering software to manage a highly available environment. If you need additional hardware resources (such as memory or CPU), or experience hardware failure, you simply add another node (server) to the grid. (Truthfully, it’s more complicated than that
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.RAC,”RAC(Real application cluster) uses Oracle’s[…]
Read moreOLTP: Online Transactional Processing
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.OLTP: Online Transactional Processing Used[…]
Read moreDSS(Decision Support System)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DSS(Decision Support System) Used for[…]
Read moreOLAP(Online Analytical Processing),”Used for analyzing data. Typically, OLAP is used for business intelligence or data mining
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.OLAP(Online Analytical Processing),”Used for analyzing[…]
Read more