Cycles Redo Log Files
Redo Log Info
Extract TS Information
Archive Log List
CKPT Checkpoint Process
dbw0 Database Writer
Writing Dirty Buffers
Oracle Process Monitor
Database Buffer Cache
Oracle Shared Pool
Redo Log File Sizes
Oracle SPOOL Command - Exercise
Spooling Some Output
Run the SPOOL command to create an output file.
You will receive ten points for this exercise.
The exercise is auto-scored; when you have completed the exercise, click the
button to receive full credit.
Go ahead and spool some output, just to be sure that you know how. If you are running Oracle, you can complete this exercise, and if not, you can see what would happen by reading through the commands, and looking at the results. Start Server Manager, connect to your database, and issue the following series of commands:
SPOOL output SELECT owner, table_name FROM all_tables ORDER BY owner, table_name; SPOOL OFF
You should find the results in a file named output .log in your current working directory.
The .log extension will be used because it is the default and you did not specify anything else.