Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.OLTP: Online Transactional Processing Used[…]
Read moreLatest Posts
RAC,”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[…]
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 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 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 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 moreCache,”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 moreSGA components
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SGA components Shared poolDatabase buffer[…]
Read moreSGA(System Global Area)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SGA(System Global Area) a group[…]
Read moreMemory,”The memory components of Oracle (or any software, for that matter) are what inhabit the RAM on the computer. These structures only exist when the software is running. For example, they instantiate when you start an instance. Some of the structures are required for a running database; others are optional. You can also modify some to change the behavior of the database
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Memory,”The memory components of Oracle[…]
Read more