• 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
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to run sql tuning advisor for a sql _id

November 12, 2020 by techgoeasy 1 Comment

Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running  sql tuning  advisor on the particular sql -id in the Cursor cache Create […]

Filed Under: Oracle, Oracle Database Tagged With: sql tuning task

How to rollback the patch after failed cutover phase in R12.2

November 12, 2020 by techgoeasy Leave a Comment

There may be scenario  when  cutover phase failed . It is possible to go back to previous state of cutover(rollback the patch) ,if flashback database is either enabled in the database or we have taken full backup prior to cutover I would be explaining it with respect to Database Flashback to rollback the patch I am […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to rollback the patch after failed cutover phase in R12.2

How to upgrade EBS database to 19c: Step by Step

November 10, 2020 by techgoeasy Leave a Comment

Here in this post , we wil checking out Upgrading Database to 19c with R12.1 Important points about 19c Upgrade When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to a multitenant architecture, which will consist of a Container Database (CDB) with a single Pluggable Database. Only multitenant architecture […]

Filed Under: Oracle, Oracle Ebuisness Suite

How to rollback the Oracle patch

November 10, 2020 by techgoeasy Leave a Comment

We apply lot of patches to Oracle product to add new feature, to rectify bugs. Sometime the patch do not work as expected and we need to rollback the oracle patch. I am presenting here the rollback cases for different type of Oracle patches Rollback of Database patches Database patches are applied using opatch. Each […]

Filed Under: Oracle, Oracle Database, Oracle Ebuisness Suite Tagged With: rollback of oracle patches

how to drop table in oracle

November 5, 2020 by techgoeasy Leave a Comment

The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer available for selection. Dropping a table drops the index and triggers associated with it. Oracle Views, synonym are not dropped but they become invalid Dropped table can be recovered using FLASHBACK utility, if […]

Filed Under: Oracle, Oracle Sql

how to delete rows from table in oracle

November 5, 2020 by techgoeasy Leave a Comment

This SQL tutorial provides explanations, examples for Delete from table in Oracle Delete from table  is used in Oracle Sql to delete the rows in the table. It is a DML (Data Manipulation language) statement. It is used to delete the subset of existing rows or all existing rows from the table.  Here is the […]

Filed Under: Oracle, Oracle Sql

  • « Previous Page
  • Page 1
  • …
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • …
  • Page 100
  • Next Page »

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

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

Recent Posts

  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1
  • Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack)

Copyright © 2021 : TechGoEasy

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