Techgoeasy

How to perform DML operations on Oracle View: Insert, Update, delete

DML operations like insert, update, and delete are allowed in Oracle views with certain restrictions. Let’s check in this post to update the view in Oracle, insert into view Oracle, delete from view in Oracle DML on view in Oracle For example, Let’s first create the TEST view. Create view emp_data as select e.empno,e.ename,e.sal,e.deptno,d.dname From …

How to perform DML operations on Oracle View: Insert, Update, delete Read More »

How to check Stale statistics in Oracle Database

Oracle, Oracle Database

Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table …

How to check Stale statistics in Oracle Database Read More »

RMAN List backup commands

Oracle, Oracle Database

RMAN List backup is a useful command to list the backup taken in the system. It shows all the details about the backup taken, what time it was taken, location of the backup. First, you need to connect with the Target database with or without a catalog and then these commands can be run. If …

RMAN List backup commands Read More »

how to find the Oracle database version

Oracle, Oracle Database

Many times questions are being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version Oracle Database Versions How to check Oracle database version in Linux …

how to find the Oracle database version Read More »

What is Essbase 21c

hyperion, Oracle

Essbase 21c is the latest version of Oracle essbase. It is the first release after 11.1.2.4 where Oracle is giving the option of installing on the on-prem machine. New Feature in Essbase 21c New Improved User Interface Essbase 21c has improved the user interface from the Essbase 19c Version. Shadow Application New Improved Outline Editor …

What is Essbase 21c Read More »

How to submit workflow background process from the backend

Oracle, Oracle Ebuisness Suite

Workflow is an important part of Oracle Ebiz Applications In this post, we will check out what is Workflow Background Engine, How to run it from Unix, How to run it using SQLPLUS, how to submit workflow background process from the backend What is Workflow Background Engine How to run Workflow Background Process from Unix …

How to submit workflow background process from the backend Read More »