The log_archive_duplex_dest parameter allows you to define not one but two archived redo log storage locations. You can define it as a can or must succeed operation by setting the log_archive_min_succ...
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...
DBWn – Database Writer Note that Oracle changed the naming format of the DBWR process to DBWn as of Oracle8, where n can be a number from 0 through 9. If you use multiple DB writer processes, you shou...
Oracle V11.1 Description v────────────────────────────┐ >──STORAGE─(──┬─INIITAL──size_clause─────┬┴─)──> ├─NEXT──size_clause────────┤ ├─MINEXTENTS──integer──────┤ ...
Here is a report that uses pivot grids. For this report I export the data to a specific area on another worksheet. I define the pivot grid to take the data from that area. In this use case you can ...
Watch as Toad for IBM DB2 expert, Jeff Podlasek, demonstrates the DB2 LUW enhancements introduced in version 5.2....
See how to use Toad for SQL Server to improve your SQL Server productivity....
Watch as Toad for IBM DB2 expert, Jeff Podlasek, demonstrates the DB2 z/OS enhancements introduced in version 5.2....
Single result sets exported to Excel may not be enough for your needs. You might have a project where the end user wants multiple results in a single page. And of course you would like to make it attr...
Stored procedures can be written in a variety of languages, including C, C++, Java, and SQL PL. SQL PL is a language specifically designed for DB2 and offers a rich set of features that can make it su...
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 ...
In this SQL Optimizer for SAP ASE video, we demonstrate how to use the SQL formatter to transform SQL code into a more readable format....
