Oracle Notes

Tables: This is a set of elements organized in vertical and horizontal fashion. Tablespaces: This is a logical storage unit in Oracle. Views: It is virtual table derived from one or more tables. Indexes: This is a performance tuning method to process the records. Synonyms: This is a name for tables. Oracle Database consists of … Read more

Hash cluster is a technique to store a data in hash table and improve the performance of data retrieval. Hash function is applied on table row’s cluster key value and store in hash cluster. In Oracle, a hash cluster is a type of table cluster that uses a hash function to distribute rows among a … Read more

Save points are used to divide a transaction into smaller parts. It allows rolling back of a transaction. Maximum five save points are allowed. It is used to save our data, whenever you encounter an error you can roll back from the point where you save your SAVEPOINT. In Oracle database, a savepoint is a … Read more

Oracle shared pools contains two layers: library cache data dictionary cache As of my last knowledge update in January 2022, Oracle Database does not have a concept of “memory layers” in the shared pool. The shared pool in Oracle Database is a component of the System Global Area (SGA) that stores shared SQL and PL/SQL … Read more

Hot backup (Online Backup): A hot backup is also known as online backup because it is done while the database is active. Some sites can not shut down their database while making a backup copy, they are used for 24 hour a day, 7 days a week. Cold backup (Offline Backup): A cold backup is … Read more