Normal system backups, referred to as either Hot or Cold backups, are used to protect from media failure. A Cold backup, that is, one done with the database in a shutdown state, provides a complete co...
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...
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...
