List of important Data Dictionary queries in Oracle 19c

 Here's a comprehensive list of important Data Dictionary queries in Oracle 19c and the useful information you can extract from each. These are helpful for DBAs and developers when managing, troubleshooting, or analyzing an Oracle database. 🔷 1. USER_TABLES Query: SELECT * FROM USER_TABLES; Use: Lists all tables owned by the current user. Info you get: Table name Tablespace name Row count estimate Last analyzed date Compression...

Read More

ERD of Oracle HR Schema

&nb...

Read More

Process to import SAKILA Schema in Oracle database

 #####Create a directory for sakila filesmkdir /u01/app/oracle/sakilacd /u01/app/oracle/sakila------------------------------------------------------------------------------------------------------------------#####Download the schema filewget https://raw.githubusercontent.com/DataGrip/dumps/master/oracle-sakila-db/oracle-sakila-schema.sql#####Download the data filewget https://raw.githubusercontent.com/DataGrip/dumps/master/oracle-sakila-db/oracle-sakila-insert-data.sql#####verify...

Read More

Explanation of Parameters of Control file used while creation in Oracle Database

 CREATE CONTROLFILE REUSE DATABASE "ORCLTRN" NORESETLOGS  ARCHIVELOG    MAXLOGFILES 16    MAXLOGMEMBERS 3    MAXDATAFILES 100    MAXINSTANCES 8    MAXLOGHISTORY 292LOGFILE  GROUP 1 (    '+DATADG/ORCLTRN/ONLINELOG/group_1.262.1201513375',    '+RECODG/ORCLTRN/ONLINELOG/group_1.257.1201513377'  ) SIZE 200M BLOCKSIZE 512,  GROUP 2 (    '+DATADG/ORCLTRN/ONLINELOG/group_2.263.1201513375', ...

Read More

Steps to install oci8 on centos 8

The following steps is valid for Oracle 11g, you can modify as per your oracle version in a similar fashion.1. Install the Oracle Instant Client:    - Download the Oracle Instant Client RPM packages for your architecture from the Oracle website (https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html). You'll need  oracle-instantclient-basic , ...

Read More

Physical IP Vs Virtual IP Vs SCAN IP (with Examples)

Physical IP, Virtual IP, and SCAN IP are terms often used in the context of networking and IT infrastructure. Let's break down the differences between these concepts:1. Physical IP (Internet Protocol):A physical IP address is a unique numerical label assigned to each device (like computers, routers, servers, etc.) connected to a network. It serves as an identifier that helps in routing data packets to the correct destination. Physical IP addresses...

Read More

What is Archive logs in Oracle database?

An archive log is a term commonly used in the context of database management systems, particularly with relation to Oracle Database.In a database system, the archive log refers to a copy of a redo log file that has been filled with data and then archived (backed up) to a storage location, such as a separate disk or tape. The redo log files store a record of changes made to...

Read More

Differences between Datafile and Tablespace

  Datafile Tablespace Definition Physical file used by the DBMS to store data Logical storage container within a database Purpose Stores actual data, indexes, and other database objects Provides a logical organization and management structure for storing and accessing data ...

Read More

Real Application Clusters (RAC) in database

RAC stands for Real Application Clusters, and it is a feature of Oracle Database that allows multiple instances (database servers) to simultaneously access and manage a single database. This distributed architecture provides several benefits in terms of high availability, scalability, and performance.In a RAC configuration, multiple servers are interconnected, forming a cluster....

Read More