Search This Blog

DBA Master

"Check the Error Log, Find the Solution, Execute with Properly"

Linux
PostgreSQL
ORACLE 19C
MySQL

More…

Oracle Database Versions and features

Get link
Facebook
X
Pinterest
Email
Other Apps

oracle sql

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Pages

Linux
PostgreSQL
ORACLE 19C
MySQL

Oracle Database 19C Performance Tunning - PART 1

Advantages: 1. Improved Query Performance • Optimized SQL execution plans lead to faster query response times. • Reduces unnecessary full table scans and improves indexing strategies. • Parallel execution tuning speeds up large data processing tasks. 2. Better Resource Utilization • Efficient use of CPU, memory, disk I/O, and network resources. • Reduces contention on Redo Logs, Undo Tablespaces, and Buffer Cache. • Helps in load balancing across multiple instances in RAC (Real Application Clusters). 3. Increased System Scalability • Ensures that the database can handle a growing number of users and transactions. • Proper tuning allows scaling without degrading performance. • Optimized parallel processing ensures better performance on multi-core servers. 4. Lower Infrastructure Costs • Reduces the need for add...

Oracle 19c Database Software Installation in OEL8

Pre-requisites for OS level: Set the static IP Address Disable the Firewall (systemctl stop firewalld & systemctl disable firewalld) set SELINUX=permissive on /etc/selinux/config ##Need to restart the server use init 6 Oracle Installation Pre-requisites Methods Automatic Setup Manual Setup Automatic requisites Setup: (avoid step 1 to step 5): dnf install -y oracle-database-preinstall-19c Install the dependencies: curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm Manual Setup: step 1: Add the karenl parameters and values vi /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel....

PostgreSQL Opensource Installation in RHEL or Oracle Linux(OEL) 8 and above

Types OF Installation Binary(Packages) Source RPM (Red hat Package Management) Notes: Once Installed the PostgreSQL set Password for postgres (OS Level) User. Login the root user and set password like passwd postgres Binary Installation: (Online Installation – Internet Must) Step 1: goto https://www.postgresql.org/ and click Download Choose Packages on Top Left Cornor Step 2: Select Your Operating System. Choose Linux and select your Linux distribution( Redhat/centos ). and scroll down Step 3: Select PostgreSQL Version. Example Choose 17 Step 4: Select Linux Platform. Example select Red Hat enterprise, CentOS, Scientific or Oracle version 8 Step 5: Select OS architecture Type. Example Select x86_64 Step 6: Copy the Script and paste your terminal Example: # Install the repository RPM: sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Disab...

Oracle RMAN Backup And Restore

RMAN: (Oracle 8) RMAN (Recovery Manager) is a utility provided by Oracle Database to perform backup, restore, and recovery operations. It is a command line tool. Features of RMAN in Oracle 19c Comprehensive Backup Capabilities: Full and incremental backups. Block-level backups for efficient data storage. Archived redo log backups. Fast Recovery Area (FRA) integration for centralized backup storage. Efficient Recovery Options: Point-in-time recovery (PITR). Complete and incomplete recovery. Flashback database capabilities for quick undo of changes. Multitenant Database Support: RMAN fully supports container databases (CDBs) and pluggable databases (PDBs). Provides flexibility to back up and recover individual PDBs or entire CDBs. Automatic Space Management: Manages disk space in the FRA. Automatically deletes obsolete backups and archived logs. Data Deduplication and Compression: Backup optimization through block-level deduplication. Built-in compression algorithms to reduce storage req...

Oracle Patching Using Opatch Utility

Opatch: It is a utility for patching Oracle software, specifically Oracle databases and related products. It is used to apply, roll back, and check Oracle patches, including interim patches, one-off patches, and bundle patches. Types of Patches: Patch Type Purpose Release Frequency Includes Security Fixes? Includes Bug Fixes? Includes New Features? One-off Patch Fix a specific issue As needed No Yes No PSU (Patch Set Update) Security + Bug fixes Quarterly Yes Yes Minimal CPU (Critical Patch Update) Security fixes only Quarterly Yes No No RU (Release Update) Security + Bug + Functional changes Quarterly Yes Yes Yes BP (Bundle Patch) Exadata/Windows patch...

Oracle Database Versions and features

Comments

Post a Comment