The Tablespace to contain schema objects created without specifying a tablespace name.
Latest Answer: The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is not mentioned while creating the user, the default ...
The collective amount of disk space available to the objects in a schema on a particular tablespace.
Each database user is assigned a Profile that specifies limitations on various system resources available to the user.
Latest Answer: A profile is used to restrict the reource uses, password reuses, idle time of a session etc. We can also attach a password verify function for the database user. A database user can be assigned a profile. It is an optional clause. ...
The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE
Latest Answer: Amount of CPU TIME, PERCENTAGE CPU, IDLE TIME etc.. ...
Monitoring of user access to aid in the investigation of database use.
Latest Answer: Auditing involves in recording all the activities based on the auditing rulesSome types of auditing are Database level Auditing, Schema Level auditing, Object level Auditing and Statement level auditing. ...
Statement Auditing, Privilege Auditing and Object Auditing.
Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
Latest Answer: The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege. ...
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
Latest Answer: Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM ...
Object auditing is the auditing of accesses to specific schema objects without regard to user.
Latest Answer: Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users. ...
To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary.
View page << Previous 1 2 [3]
Go Top
