Clota Blog

Author: Tarif Ahmad

  • R-MAN BACKUP

    Hi guys, in this blog I am going to explain you about R-MAN BACKUP. Archivelog : Archive log mode permits complete recovery from disk failure as well as instance failure, because all changes made to the database are permanently saved in an archived redo log. These redo log files are used with backups of your data files to…

    Read More

    Tarif Ahmad

    //

  • Oracle Table Partitions

    Oracle Table Partition Table partitioning in Oracle is a database feature that allows you to divide a large table into smaller, more manageable segments called partitions. Each partition is an independent unit that stores a subset of the data in the table. Partitioning is designed to improve performance, simplify data management, and enhance maintenance tasks,…

    Read More

    Tarif Ahmad

    //

  • Oracle Deadlock

    A deadlock in Oracle occurs when two or more transactions are blocked, each waiting for the other to release a lock. This situation creates a circular dependency where neither transaction can proceed, and the database system needs to resolve the deadlock. Oracle employs a mechanism to detect and resolve deadlocks automatically. For example, Transaction A…

    Read More

    Tarif Ahmad

    //

  • Oracle Database logs

    Oracle Database logs Oracle Database logs can provide valuable information about the database’s health, performance, and any issues that might have occurred. Here are several ways to check Oracle Database logs: Alert Log: The Oracle Alert Log is a primary source of information about the database. It contains messages about database startup, shutdown, errors, and…

    Read More

    Tarif Ahmad

    //

  • Data Integrity

    Introduction to Data Integrity It is important that data maintain data integrity, which is adherence to business rules determined by the database administrator or application developer. Business rules specify conditions and relationships that must always be true or must always be false. For example, each company defines its own policies about salaries, employee numbers, inventory tracking,…

    Read More

    Tarif Ahmad

    //

  • System Views in Oracle

    In Oracle Database, the concepts of “system view” typically refer to different types of views that provide access to metadata and information about the database objects. Let’s delve into each of these concepts: System Views: System views are also known as data dictionary views or catalog views. These views are part of the Oracle data…

    Read More

    Tarif Ahmad

    //

  • Data file and Log File

    Data file: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle assigns each datafile two associated file numbers, an absolute file number and a relative file number, that are used to uniquely identify it. In Oracle, you can…

    Read More

    Tarif Ahmad

    //

  • Resource Manager and Task Schedular-

    In Oracle Database, the Resource Manager is a feature that allows you to manage and allocate resources among different users and applications. It enables you to control the number of resources (CPU, memory, and parallel execution servers) consumed by database sessions and helps in preventing runaway queries or resource-intensive operations from adversely impacting the overall…

    Read More

    Tarif Ahmad

    //

  • Oracle Data Dictionary and the Dynamic Performance Views

    An important part of an Oracle database is its data dictionary, which is a read-only set of tables that provides administrative metadata about the database. A data dictionary contains information such as the following: ·         The definitions of every schema object  in the database, including default values for columns and integrity constraint information ·         The amount of space allocated…

    Read More

    Tarif Ahmad

    //

Search

Categories

Recent Posts