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 MoreThe 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 MoreFor 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 MoreOne 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 MorePlease 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 MoreSteps 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 MorePlease use the below script. #!/bin/ksh file1=$1 file2=$2 for parameter in `cat $file1 | grep = | awk ‘{print $1}’ | grep -v ‘#’` do value1=`grep ^$parameter $file1 |…
Read MoreIt is a feature that is enhanced in oracle 19c and it is mainly used to automate the upgrade process.it not only automates the database upgrade but also performs the pre-upgrade steps…
Read MoreIt is possible to recover datafile when accidentally removed or deleted and when there is no backup at all , We can recover the datafile without any issues ,now i…
Read MoreORA-01555 / ORA-600 in standby database after switchover After doing a SwitchOver from Production to standby(open read only), We were facing frequent ORA-01555 error. This is a Oracle bug in…
Read More