Introduction You’ve probably been reminded very often that force logging is important in a Data Guard configuration and have also been warned about the dramatic consequences that might happen in a dat...
Some days ago Michael Abbey invited me to a dinner (René Antunez Oracle ACE, also was there) in his apartment in Ottawa. He is such an admirable person, he is also an Oracle ACE and he likes to share ...
In Version 12.1 Toad for Oracle added source control integration for Git, a popular distributed version control provider. Git is free software, distributed under the GNU general public license. Toad i...
This video demonstrates how to quickly and easily visually build a query using Toad Data Point query builder interface. How to get the most out of Toad Data Point Toad Data Point, is a powerfu...
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...
