Profile is information contain that particular modules.
snapshort log is used updated data for master table and if any recored is updated after certen period to refer the master table collect the snapshot log. because tha table size is very large it take lot of time. thus by ues the snapshot log.
So many database utilities are available:
its the tablespace in to which the objects created by a user go.default tablespace can alloted to a user while creating he user or can also be changed after creating the user. the default table space of a user is system tablespace unless mentioned specfically while creating the user.
To perform one of these function on an index,table, or cluster:
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available for simple snapshots. It should be created before creating snapshots.
Depending on the company and the department, this role can either be highly specialized or incredibly diverse. The primary role of the Database Administrator is to adminster, develop, maintain and implement the policies and procedures necessary to ensure the security and integrity of the corporate database. Sub roles within the Database Administrator classification may include security, architecture, warehousing and/or business analysis.
Other primary roles will include:
Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.
To check database is in which mode:
To set database in Archivelog mode:
To set database in NoArchivelog Mode:
Amount of tablespace that can be used by a user for creating his own database objects is called talespace quota.its a way of limiting the usage of memory or disk space by user or restricting him by giving a fixed disk space.
snapshot is nothing but a consistent data for master table if any chance the master table snapshot is fetch the updated data for master table.
RMAN is an Oracle tool for taking the backup and recovering the databases. You can copy, restore, and recover datafiles, control files and archived redo logs (all 3 files or any one file). It has command line utility as well as GUI-based Enterprise Manager Backup. Here we are discussing the command line utility.
For example, we have TEST and PROD databases. Here TEST is the catalog database and PROD is the target database for which the backup has to be taken. You may loose your backup if you have your catalog and target databases on the same box and the box crashes .So it is always advisable to keep a separate database for RMAN catalog .
Create two databases. One for RMAN catalog(Test) and one target(PROD). Both the Databases should be archive log mode(for security).
DBA_DATA_FILES is view to show the space for the tablespace if you want the calulate the space of the database the all tablespace size is the database size.
If a user wants to give some privileges to another user or a group of users then they will create role and they give this role to the users.let the privileges be 'insert' and 'update' on 'emp' table then instead of specifying them by their names they will create role which inturn includes these methods. this role is further given to the users.
If in futher if he wants to remove some privilege given to the users, he can just alter the role and remove that particular privilege such as he can remove update from this created role..
Later the users cant do updations on that emp table.but still can insert the values into that table.
Hence Roles are the easiest way to grant and manage common privileges needed by different groups of database users.Creating roles and assign each role to group of users will simplify the job of assigning privileges to individual users.
By setting the following values in init.ora file:
LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc
(%S - Log sequence number and is zero left paded,%s - Log sequence number not padded. %T - Thread number lef-zero-paded and %t - Thread number not padded).
The file name created is arch 0001 are if %S is used.
LOG_ARCHIVE_DEST = path.
snapshots is three types of complite,fast and force.
Time the references to occur when master tables are not in use.Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.
It is mean it is primary key column.
By creating a Role with a password
An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges
Dynamic data replication is feture of oracle actualy the to more database ex:- this is production database and other database with and synconoze with the production databse throuth the dynamic replication. if any change the proction database the symaltantinasly change the other database the replication. the benefite the the user can access any were ether prodction or syn with other database.