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...
Thursday, May 29, 2025
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...
Monday, May 26, 2025
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', ...
