Performance Tuning(How to find database growth on a Monthly wise)

Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,’RRRR’) year, to_char(CREATION_TIME,’MM’) month, round(sum(bytes)/1024/1024/1024) GB from   v$datafile group by  to_char(CREATION_TIME,’RRRR’),   to_char(CREATION_TIME,’MM’) order by   1, 2; YEAR MO              GB —- […]

Read More

SQLT in Oracle

SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, […]

Read More

Drop the SQLT in Oracle Database

Uninstalling SQLT removes the SQLT repository and all SQLTXPLAIN/SQLTXADMIN schema objects. SQLTXPLAIN and SQLTXADMIN users also gets dropped. To uninstall SQLT simply execute sqlt/install/sqdrop.sql connected as SYS.

Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]

Read More

Upgrade Database from Oracle 11gR2 to Oracle 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use the […]

Read More

Read-Only Oracle Homes on Oracle 18c

Starting with Oracle Database 18c, you can configure an Oracle home in read-only mode. In a read-only Oracle home, all the configuration data and log files reside outside of the read-only Oracle home. This feature allows you to use the read-only Oracle home as a software image that can be distributed across multiple servers. Apart […]

Read More

ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’

Installation of the Oracle 18c database software has been successfully completed, now while trying to run DBCA, there was an ORA-12754 error. Start DBCA DEBUG function, did not find valuable information, or decided to build a database by hand. However, the configuration of the password file and parameter file, the error is still

It […]

Read More

Upgrade Apex for Oracle 18c

Starting with Oracle Database Release 18, APEX has not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades. To download the latest APEX: Click Here

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read […]

Read More

Compile Fixed Objects

To upgrade from Oracle 11gR2 to Oracle 18c, we need to gather stat for fixed objects

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ […]

Read More

Remove OLAP for Oracle 18c

To upgrade from Oracle 11gR2 to Oracle 18c, we need remove OLAP. Remove OLAP Catalog by running the 11.2.0.4.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us […]

Read More

Remove EM for Oracle 18c

To upgrade from Oracle 11gR2 to Oracle 18c, we need to Enterprise Manager. Copy the $ORACLE_HOME/rdbms/admin/emremove.sql script from the target 18.0.0.0.0 ORACLE_HOME into the source 11.2.0.4.0 ORACLE_HOME. Step 1: If database control is configured, stop EM Database Control, using the following command

Step 2: Connect to the database using the SYS account AS SYSDBA […]

Read More