Review Questions


1.

System trace files can be found in the directory identified by which initialization parameter?

system trace files can be found in the directory identified by the background_dump_dest parameter.

2.

What Oracle tool can the DBA use to monitor the size of a tablespace and notify the DBA when the tablespace is running out of space?

oem s event manager tool can be used to monitor space conditions in database tablespaces.

3.

True or false: The alert log file records both successful and unsuccessful logins to the database.

false, the alert log file records database startup and shutdown, but not user logins.

4.

The alert log file can be found in the directory identified by which initialization parameter?

the alert log file can be found in the directory identified by the background_dump_dest parameter.

5.

What does the Oracle utility TKPROF do?

the oracle utility tkprof formats a user trace file containing sql statement statistics into a readable format.

Answers

1.

System trace files can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter.

2.

OEM’s Event Manager tool can be used to monitor space conditions in database tablespaces.

3.

False, the alert log file records database startup and shutdown, but not user logins.

4.

The alert log file can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter.

5.

The Oracle utility TKPROF formats a user trace file containing SQL statement statistics into a readable format.




Oracle9i DBA JumpStart
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors: Bob Bryla

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net