What are Invisible Indexes? Beginning with Oracle Database 11g Release 1, you can create invisible indexes or make an existing index invisible. An invisible index is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level. Unlike unusable indexes, an invisible index is maintained during […]
How to Drop the index in Oracle
You can drop an index in oracle using DROP INDEX command. It removes the named index. The general Syntax is drop index <schema name>.<index name> ; Here schema name is the owner of the index and index name is the index name. If you dont provide the schema name, then it is assumed the index […]
How to use Analytic functions in oracle (Over Partition by Keyword)
This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” NUMBER(2,0), “DNAME” VARCHAR2(14), “LOC” […]
How to delete the manage server in R12.2
I was working on R12.2 Test env and I was suppose to decrease the JVM for the oacore(delete the manage server) The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on OC4J instances and were […]
How to add the manage server in R12.2
I was working on R12.2 Test env and I was suppose to increase the JVM(add the manage server in R12.2) for the oacore to sustain the load The procedure to increase JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on […]
How to run sql tuning advisor for a sql _id
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 […]
