Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/19

Click to flip

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