|
What is Privilege Auditing?
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects. What is Object Auditing? Object auditing is the auditing of accesses to specific schema objects without regard to user. What is Auditing? Monitoring of user access to aid in the investigation of database use. How does one see the uptime for a database? (for DBA) Look at the following SQL query: SELECT to_char (startup_time,'DD-MON-YYYY HH24: MI: SS')
"DB Startup Time"
Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? (for DBA) Tempfiles, unlike normal datafiles, are not listed in
v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files:
How do I find used/free space in a TEMPORARY tablespace? (for DBA) Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view: SELECT tablespace_name, SUM (bytes used), SUM (bytes free)
What is a profile? Each database user is assigned a Profile that specifies limitations on various system resources available to the user. How will you enforce security using stored procedures? Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure. How can one see who is using a temporary segment? (for DBA) For every user using temporary space, there is an entry in SYS.V$_LOCK with type 'TS'. All temporary segments are named 'ffff.bbbb' where 'ffff' is the file it is in and 'bbbb' is first block of the segment. If your temporary tablespace is set to TEMPORARY, all sorts are done in one large temporary segment. For usage stats, see SYS.V_$SORT_SEGMENT From Oracle 8.0, one can just query SYS.v$sort_usage. Look at these examples: select s.username, u."USER", u.tablespace, u.contents,
u.extents, u.blocks
|
|