Oracle has different steps based on the version How to clone Oracle Home in 10g/11g/12c Prepare steps 1) On the source Create a tar file of the Oracle Home /u001/app/oracle/product/12.1.0/dbhome_1 $cd /u001/app/oracle/product/12.1.0/$ tar -cvf dbhome_1.tar dbhome_1 2) scp this tar file to the target machine and untar the file scp dbhome_1.tar LINUX1:/u001/appl/oracle//product/12.1.0Login to LINUX1cd /u001/appl/oracle//product/12.1.0tar […]
How to find the FND_FILE output of the running concurrent request
We generally write FND_FILE statements in concurrent programs for debugging, logs, and various other messages These are visible in Concurrent request logs and out once the concurrent program completes only If we want to see the logs and out for the running concurrent request, then we need to find the temporary log and out file […]
srvctl commands in Oracle
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 […]
Top SQL Patch Queries in Oracle Database
Here are some of the top SQL Patch Queries in Oracle Database Query to Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), ‘/hint’) as varchar2(500)) as outline_hintsfrom xmltable(‘/outline_data/hint’passing (select xmltype(comp_data) xmlfrom sys.sqlobj$datawhere signature = select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = ‘&SQL_ID’;)) x; How to find all the SQL_PATCH in the […]
how to find if the sql is using the SQL Patch
When we implement the SQL Patch for the statement, we would also like to confirm if the sql has started using the SQL Patch or not. We can use the below query to find out if the sql is using the SQL Patch How to find if the sql is using the SQL Patch col […]
How to create SQL Patch for sql tuning in Oracle
SQL patch is a new feature from 12c onwards where we can insert hints into the sql statement using this feature. This is particularly useful when the application code cannot be modified and hints are providing the performance benefits. We have other tools like Sql profile, Sql plan baseline available also to to tune the […]