Returning Clause in Oracle Plsql
Use RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read MoreHow to Create Manual Database in Oracle ASM File-system using Cloud Instance
Description: The recommended method of creating your database is to use database configuration assistant (dbca). however, if you create your database manually using the create database statement, then oracle asm enables you…
Read MoreFind Database Query From the Linux PID
Find Database Query From the Linux PID PID=32370 select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t where p.addr=s.paddr and s.sql_address=t.address and s.sql_hash_value=t.hash_value and p.spid = 32370;
Read MoreCalculate Actual Size of All Tables in a Schema in Oracle
SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) MB FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE segment_type in (‘TABLE’,’TABLE SUBPARTITION’,’TABLE PARTITION’) UNION ALL SELECT i.table_name, i.owner, s.bytes FROM dba_indexes i, dba_segments s…
Read MoreEBS R12.2 Weblogic Managed Servers are crashing frequently
ISSUE ====== EBS R12.2 Weblogic Managed Servers are crashing frequently . Weblogic Managed Servers crashing frequently due to “weblogic.socket.MaxMessageSizeExceededException” error Admin Server Log file has the below error message. ===================================================…
Read MoreOutput Post Processor (FNDOPP) is not Staring
The Output Post Processor (FNDOPP) Manager is not starting, process status is shown as Actual with 0 and the Target is 1 The OPP logfile shows the following exceptions: [UNEXPECTED] java.sql.SQLException:…
Read MoreSetting A Discoverer Preference At A User Level
For Discoverer 10g: 1. On the Discoverer 10g Server machine, please set the environment variables by running the following script, . ./$OH/discoverer/discwb.sh (Note : It is dot space dot slash…
Read MoreASMCMD useful commands
One small article on ASMCMD commands which can help you in day to day ASM Command-Line tasks. 1. Let’s check ASMCMD’s version. [oracle@dbnode1 ~]$ asmcmd -V asmcmd version 11.2.0.0.0 Let’s…
Read MoreSteps to Uninstall Apex in Database
Please follow the below steps col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; COMP_ID COMP_NAME STATUS —————…
Read MoreStesp to Add/Resize Redolog files
Steps to Resize the Online Redo Logfiles >sqlplus /nolog SQL> connect / as sysdba SQL> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– PROD READ WRITE Please check the below…
Read More