• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads

How to clone Oracle Home in 10g/11g/12c/19c/23c

September 21, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to find the FND_FILE output of the running concurrent request

September 20, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Ebuisness Suite

srvctl commands in Oracle

September 20, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

Top SQL Patch Queries in Oracle Database

September 14, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

how to find if the sql is using the SQL Patch

September 13, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to create SQL Patch for sql tuning in Oracle

September 12, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 124
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to clone Oracle Home in 10g/11g/12c/19c/23c
  • How to find the FND_FILE output of the running concurrent request
  • srvctl commands in Oracle
  • Top SQL Patch Queries in Oracle Database
  • how to find if the sql is using the SQL Patch

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us