• 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 check if oracle database is encrypted

November 25, 2020 by techgoeasy Leave a Comment

Database encryption is a important concept these days because of security breaches . It is common practice to have database encryption enabled in Oracle database. Encryption can be present at two Level TDE ( Transparent Data encryption) : This is setup for Table levelTSE (Tablespace encryption): This is setup for Tablespace level Here is how […]

Filed Under: Oracle, Oracle Database

How to make index invisible in oracle

November 20, 2020 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Database

How to Drop the index in Oracle

November 20, 2020 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Sql

How to use Analytic functions in oracle (Over Partition by Keyword)

November 19, 2020 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Sql

How to delete the manage server in R12.2

November 12, 2020 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to delete the manage server in R12.2

How to add the manage server in R12.2

November 12, 2020 by techgoeasy 1 Comment

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

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to add the manage server in R12.2

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • …
  • 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