Oracle 8 - Processes and Security Part 2
Terms
undefined, object
copy deck
- 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
- 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