Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
- 3rd side (hint)
The NT Performance Monitor is very good for viewing which kind of information?
|
i/o and cpu info
|
|
|
You can gather a tremendous amount of information about the Oracle processes by querying the internal performance tables using the
|
V$ views
|
|
|
Contains information about virtual connections that are created through the dispatcher and server processes
|
V$CIRCUIT
|
|
|
Contains miscellaneous system statistics
|
V$SYSSTAT
|
|
|
Contains information about multithreaded message lines
|
V$QUEUE
|
|
|
What is the name of the V$ view that contains I/O information for each session?
|
V$SESS_IO
|
|
|
To enable the audit trail, first you must run the administration SQL script
|
CATAUDIT.SQL
|
This script is located in the directory Orant\\Rdbms80\\Admin
|
|
When you are done auditing and want to remove the audit trail views when they are no longer needed, use the administrative SQL script
|
CATNOAUD.SQL
|
|
|
What command is used to turn off auditing on a specified function or user?
|
noaudit
|
|
|
With the audit command there are certain keywords, that are used to indicate auditing of associated SQL statements. these are called?
|
statement options
|
|
|
Which parameter in the AUDIT statement causes an audit record to be written for each SQL statement issued?
|
by access
|
|
|
What is the parameter to use when you want an audit record to be written only when the SQL statement is successful?
|
whenever successful
|
|
|
This parameter specifies the type of operation that is audited.
|
object_option
|
|
|
What is the object option you can use in the AUDIT objects statement that specifies that all operations are to be audited?
|
all
|
|
|
Which ON parameter specifies that objects that have not been created yet will be audited with the same auditing options as other objects?
|
on default
|
|
|
Which system privilege should be limited to DBAs only, to keep others from deleting the audit trail?
|
delete any tablespace
|
|
|
Audit entries for CONNECT and DISCONNECT operations
|
[USER]_AUDIT_SESSION
|
|
|
Audit all audit trail entries
|
USER]_AUDIT_TRAIL
|
|
|
The audit trail concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM commands
|
[USER]_AUDIT_STATEMENT
|
|