Triggers are an important construct in Oracle. These are the codes that are fired when a row is updated, inserted, or deleted in the Oracle table. Let’s find out how to check trigger status in Oracle, how to check trigger definition in Oracle, how to find all triggers in the table, and much more How […]
How to check trigger status in oracle Read More »
What is Temporary Tablespace A temporary tablespace is used for sorting operations in Oracle. It is also used in the join operations. Basically, it is temporary storage and temporary objects are created here. Global temporary tables are also created in this tablespace. This is quite a significant tablespace and can pose issues if not managed
How to check temp tablespace in Oracle: Size, resize, add, drop Read More »
In this post, we will see the important topic of histograms in Optimizer stats What is a histograms in Oracle A histogram is a special type of column statistic that provides more detailed information about the data distribution in a table column. By gathering histogram data, the CBO can make improved selectivity estimates in the
Histograms in Oracle Read More »
We can check RMAN backup status in sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup. The
How to check RMAN backup status in sql Read More »
Oracle EBS users can be created from the front end through Oracle forms or using backend PLSQL Blocks as well. We will see how to create user in oracle apps from the backend in this post Application User can be created from sqlplus using PLSQL Block Set serveroutput on BEGIN fnd_user_pkg.CreateUser(x_user_name => ‘UserName’ ,x_owner =>
Create EBS user from backend & Assign Responsibility Read More »
Types of jobs and their resolutions .odf files : -odf files are there to create tables, indexes , views etc.-If encountered locking, identify the session that holds the lock and kill the session. Do not skip the job because of locking. Sometimes odf failed to drop the index. then you can manually drop the index
Troubleshooting adpatch/adop failed job Read More »
