Profile Metadata
Run this query first, so that it will print the complete metadata Now use DBMS_Meta_Data
Real Application Testing – Database Reply
Oracle Real Application Testing (RAT) was created to give DBAs the ability to make preemptive modifications while also knowing exactly what to expect when a change is done. It considerably reduces the possibility of any harmful consequences. Oracle RAT is made up of two major parts. The first component is referred to as Database Replay. […]
Oracle Database startup and shutdown Time
Shutdown and Startup of Database Startup History Check DB_UP time
Update .bash_profile to display user and path of the Home and Environmental Variable
Install Oracle Instant Client on Linux server
Space and Objects details in Oracle Database
Object Count of schema and tablespace Physical Size of the Oracle database (Multi-Tenant) Physical Size of the Oracle Database (Logfile,Tempfile,datafile) Logical Size (Space utilise by the data in the database) Tablespace Utilisation Schema Size Tables inside specific Schema with size_in_mb
Convert Centos 7 to OEL 7.9
Several factors secure the change from CentOS to Oracle Enterprise Linux: The contents of the “/etc/centos-release” file indicate our current CentOS installation. Install the curl package or wget package before downloading the script from the public github repository. or Check the downloaded file in your present location Now execute the script using bash Now wait […]
Oracle 19c Database Installation
Installing Oracle Database 19c involves several steps, and the process can vary based on your operating system and specific requirements. Here’s a general outline of the steps you would follow for installing Oracle Database 19c: Update hosts parameter to point the DNS and IP to your server After, updating changes in the Hosts file, we […]