Below section I have tried to present all the important features in Oracle Database management
Oracle 23c is the latest Release of Oracle Database. Oracle has introduced lot of new features in it. Here are the Top Features Developer-Friendly Features Oracle has been adding features to make developers’ lives easier, such as SQL and PL/SQL enhancements, JSON improvements, REST interfaces, etc. SELECT without FROM clause You can now run SELECT …
Oracle 23c Database New Features Read More »
In this post, we will discuss how to drop the Oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdba startup mount (If database not started) create pfile=’/tmp/pfile.ora’ from spfile; Dropping an Oracle database …
We have already posted on Autotrace in Oracle, tkprof, and sql trace. Here we will be looking for the Oracle Explain Plan utility and how we can effectively use it to tune the Oracle sql statement What is Explain Plan in Oracle Oracle database internally creates a query execution plan in order to fetch the …
Cloning an Oracle Home is a process where you copy the Oracle Home directory from one server (source) to another server (destination) or to a different location on the same server. The goal is often to replicate an Oracle software installation without the need to perform a full installation from scratch. Oracle has different steps …
srvctl commands is an important tool to manage the Oracle database in the RAC environment and Oracle restarts env(Single node env with ASM). This can be used to stop, start, find status, and other things in the cluster or the server. Let’s review those command srvctl commands srvctl is a utility in $ORACLE_HOME/bin and it …
Here are some of the Top Useful Queries for SQL Patch in Oracle Database Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), ‘/hint’) as varchar2(500)) as outline_hints from xmltable(‘/outline_data/hint’ passing (select xmltype(comp_data) xml from sys.sqlobj$data where signature = (select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = ‘&SQL_ID’))) x; How to find all …
Top SQL Patch Queries in Oracle Database Read More »
