System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are inaccessible to users because users have no control over their occurrence or duration. Latches A latch is a simple, low-level serialization mechanism that coordinates multiuser access to shared data structures, objects, and files. Latches protect … Read more
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly, we opted in creating Range Replicat. The RANGE function The way the @RANGE function works is it computes a hash value of the columns specified in the input. If no columns are specified, it uses … Read more
Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can be located on ASM or file system on disk. So either you can add datafile in ASM or else you can add datafiles to tablespace in Oracle located on file system. There are two different … Read more
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip, tar, and cpio to compress the Oracle home. It is highly recommended to take a backup of the Oracle_Home binaries and Central Inventory prior to applying patchsets or patches. It should also be done as … Read more
To create a shell script to run export/import utilities. Running the script If you save the script as exp_comp.sh, type the following command at the Unix prompt to run it: Note: Edit the above script to use it for your specific exports or imports (like full, schema, table, TTS). In case of traditional export/imp (exp/imp), … Read more
The ps utility can get the process state. The process state code will contain the character + when running in foreground. Absence of + means code is running in background. However, it will be hard to tell whether the background script was invoked using nohup. It’s also almost impossible to rely on the presence of … Read more
1. Create a pfile as a backup of your spfile 2. Update the control_file parameter in the spfile. 3. Shutdown / Startup the database in nomount mode 4. Copy the new control file using RMAN. 5. Modify the spfile with the name of new control file 6. Shutdown / Startup the database and check the … Read more
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple users who share theseattributes.You should assign a profile to each user. Each user can have only one profile. Profile resource limits are enforced only when you enable resource limitation for the … Read more
About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access your database, you must create user accounts and grant appropriate database access privileges to those accounts. A user account is identified by a user name and defines the attributes of the user, including the following: … Read more