priya

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

A snapshot is a replica of a target master table from a single point-in-time. In simple words you can say, snapshot is a copy of a table on a remote database. In Oracle database, a snapshot typically refers to a read-consistent, static view of a set of data at a specific point in time. There … Read more

An Oracle database contains one or more logical storage units called tablespaces. These tablespaces collectively store whole data of databases and each tablespace in Oracle database consists of one or more files called datafiles. These datafiles are physical structure that confirm with the operating system in which Oracle is running. In Oracle, the relationship among … Read more

Bulk copy or BCP in Oracle, is used to import or export data from tables and views but it does not copy structure of same data. The main advantage of BCP is fast mechanism for coping data and you can also take the backup of data easily. Bulk Copy, or BCP, is not a term … Read more