Advanced users can use the SQL Editor to build SQL statements. Statements can be built quickly and easily using drag and drop from the objects palette and with Toad Insight's auto-complete features. T...
The flash recovery area, which allows you to centralize storage of all recovery-related files, is new in Oracle 10g. The flash recovery area is an area of disk that is defined for use for recovery-rel...
Adding an ASM Disk Group ASM disk groups are the foundation of ASM. It is where your data will be stored. ASM disk groups can be allocated to raw disk, cooked disk. To add a ASM disk group you first...
DB2 allows stored procedures to be developed in a variety of ways. Stored Procedures can be based on a programming language such as C, C++, Java, or SQL PL. Stored Procedure creation and registration ...
Hi my name is Debbie Peabody and I’m beginning a Blog series on Automation. I have talked a lot about Automation but there are still many examples of real world scenarios that might help you out with ...
A sort area in memory is used to sort records before they are written out to disk. Increasing the size of this memory by increasing the value of the initialization parameters SORT_AREA_SIZE or PGA_AGG...
How to Identify a Buffer Cache Chain Latch Problem Internally, Oracle uses various types of structures to control access to elements of the databases including latches and various types of enqueuein...
Adding Logfiles To add a redo log, the following command is used: ALTER DATABASE database name ADD LOGFILE THREAD y GROUP n (file specification, file specification) SIZE x; or: ALTER DATABASE dat...
Sometimes, data blocks are read in the database, and are infrequently reused. Often in a database we also have data blocks that are of frequent use (hot blocks). It is for these types of database bloc...
Processing SQL Statements The first time a select query is executed inside the Oracle engine, the statement will generally need to proceed through 4 different stages in order to return results back to...
The Parallel Query Option (PQO) is best used for systems where large, intense queries are being performed or where large amounts of data are being loaded, indexed and queried, such as in data warehous...
Just as the architecture of the database buffer cache has changed dramatically from release to release, so too have the effectiveness of the tools Oracle supplies to assist with tuning the database bu...
