DBA_HIST_SEG_STAT become invalid
Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below is a list of available onoff…
Read MoreInstall oracle client via yum
CMD for Installation. yum -y -q install oracle-instantclient18.3-basic.x86_64.
Read MoreORA-00000: normal, successful completion
check correct hostname and ip on /etc/hosts fie or check environment variables.
Read MoreQuery to find ASM Error details.
Description: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_name –, d.label , d.read_errs , d.write_errs…
Read Morequery to find top sort segment usage.
Description: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col username format a25…
Read MoreDiagnostic test to validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup
This diagnostic test will validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup and do an initial data collection of frequently requested information. 1) Enable STATEMENT Level Logging for the…
Read MoreHere are the 10 amazing reasons to choose Oracle Cloud!
On-demand cloud computing services are gaining in popularity. Oracle Cloud supports technologies such as IoT, Machine Learning, AI, and human interfaces. Oracle Cloud Infrastructure offers scalability, reliability, and integrated governance.…
Read MoreActive database cloning from target to source – release 19c.
Creation of Duplicate database using the RMAN Starting from 11G you can proceed with the duplicate database in 2 ways – Active cloning and backup-based cloning. Now we are going…
Read MoreHow to compile forms in Apps R12.1.3
Frmcmp compiler used to compile forms and library application in R12 Syntax: frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx…
Read More