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', ...
Wednesday, September 11, 2024
Classification of SQL Queries
SQL (Structured Query Language) is a standard language for managing and manipulating databases. SQL is divided into different languages or subcategories based on the type of operation it performs. Here's a classification of SQL languages along with examples of queries:1. **Data Query Language (DQL)**: - **Purpose**: Used to retrieve data from a database. ...
Query to Connect all tables of Sakila Database of MYSQL
select g1.first_name, g1.last_name, g1.film_id, g1.actor_id, g1.title, g1.release_year,g1.language_id, g1.rating, g1.inventory_id, g1.store_id,g3.staff_id, g3.staff_firstname, g3.staff_lastname, g3.staff_email, g3.store_id,g3.address, g3.district, g3.city_id, g3.phone, g3.city, g3.country,g3.payment_id, g3.rental_id, g3.customer_id, g3.amount, g3.cust_firstname,g3.cust_lastname,...
Saturday, August 31, 2024
Sunday, August 4, 2024
How a sentence in an LLM (Large Language Model) Constructed ?
A sentence in a Large Language Model (LLM) is constructed
through a process of predicting the next word in a sequence, based on the
context provided by the preceding words. This is achieved using a neural
network architecture, such as a transformer model, which processes input text
and generates coherent output by understanding patterns in the data.
Here's a step-by-step explanation of how a sentence is
constructed in an LLM, using an example:
Step-by-Step...
LLM (Large Language Model) in simple terms
LLM stands for Large Language Model. These are
advanced artificial intelligence systems designed to understand and generate
human-like text based on vast amounts of data. They are built using machine
learning techniques and are typically trained on diverse datasets containing
text from books, websites, articles, and other sources. The goal of an LLM is
to predict the next word in a sentence or generate coherent and contextually
relevant text.
How...
Sunday, June 2, 2024
The Great Green Revolution: Sustainable Tech for a Healthier Planet
Climate change is no longer a looming threat; it's a reality we face every day. The good news? Innovative technologies are emerging to combat environmental challenges and create a more sustainable future. In this blog, we'll explore the exciting world of green technology and how it's paving the way for a healthier planet.Going Green with InnovationSustainable technology, or green tech, encompasses a wide range of solutions aimed at minimizing...
