 Related Questions 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.. ... 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 ... Installing and upgrading the Oracle Server and application tools.Allocating system storage and planning future storage requirements for the database system.Managing primary database structures Latest Answer : adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloading using exp/imp and sqlloader* providing help to ... DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's Latest Answer : &DBSNMPSupports Oracle SNMP (Simple Network Management Protocol). The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/ ... SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database Latest Answer : SQL Plus, SQL Loader, EXP, IMP ... What are the minimum parameters should exist in the parameter file (init.ora) ? DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
