What are workspaces? Workspaces are different working environments that you can create within Toad®. A workspace allows you to have a preferred look and feel for one or more groups of Toad components...
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...
Introduction
An Execution Plan is composed by the steps that the optimizer does in order to process a SQL statement. Oracle Optimizer always tries to find out the best execution plan for a SQL stateme...
