DB Installation and Configuration best practices 2

DB Installation and Configuration best practices. 1. export NLS_DATE_FORMAT=”MM-DD-YYYY HH24:MI:SS” Description: Environment variable to get the date value upto seconds.This variable we can set in the .profile or .bash_profile. Benefits:

DB Installation and Configuration best practices 1

DB Installation and Configuration best practices 1.Disable Transparent hugepages Description: Transparent HugePages memory is enabled by default with Red Hat Enterprise Linux , Red Hat Enterprise Linux , SUSE , 

Purge database recycle bin in oracle database

Purge database recycle bin in oracle database   export ORACLE_BASE=/u00/app/oracle export ORACLE_HOME=/u00/app/oracle/product/19000/db_1 export PATH=${ORACLE_HOME}:${ORACLE_HOME}/bin:$PATH:. export LOG_FILE=/u00/app/oracle/scripts/purge_recyclebin.logecho “Purge database recycle bin” echo ORADW   sqlplus -s /nolog << eof connect /

Oracle SQL Developer Installation and configuration

Oracle SQL Developer Tool Installation and configuration. Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud

Oracle Database Home for Exadata Database service

Oracle Database Home for Exadata Database service.   Oracle Database Home A Database Home is a directory location on the Exadata database compute servers that contains the Oracle Database software

Managing Exadata Cloud Infrastructure Resources

Managing Exadata Cloud Infrastructure Resources.   When you subscribe to the Exadata Database Service, the customer is responsible for managing everything that runs in the customer VMs. For the Exadata