Statistics played in key role in Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the Oracle table involved in the SQL queries. You may want to lock statistics in an Oracle table in some cases, for example There could be many more cases where we want to lock statistics […]
How to find the table where statistics are locked in Oracle Read More »
We often get in situations where we are Unable to Start Output Post Processor and workflow-related Concurrent Manager. If we check the error in the concurrent manager logs we see the following errors Error in log file : $ cat FNDOPP10587566924.txtUnable to initialize state monitor.oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01403: no data foundORA-06512: at “APPS.FND_CP_GSM_IPC”, line 539ORA-06512: at line 1at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)at
Unable to Start Output Post Processor and workflow related Concurrent Manager Read More »
In this article, we will check about the various ways Oracle database can be shut down, what things happen during shutdown, How to shutdown the RAC Database Oracle Shutdown steps decoded We can shut down the Oracle database in four ways(i) Shutdown normal(ii) Shutdown immediate(iii)Shutdown abort(iv) Shutdown Transactional sqlplus / as sysdbashutdown Normalsqlplus / as
Oracle Shutdown steps decoded Read More »
As part of learning the Oracle SQL tutorial, Here is good detail on the group by Oracle Group by Oracle We use Group by in the select statement to group rows into summary rows using column or expression. We often used aggregate or group functions on the group to obtain the summary rows Syntax SELECT col1,
Group by Oracle: Syntax, Uses, Restrictions Read More »
Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to
How to check block corruption in Oracle database and Fix it Read More »
Oracle Provides Automatic Managed Backup Service on DBCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy How to configure Automatic Managed Backup Step 1Open the navigation menu. Under Oracle Database, click Base Database service.Step 2Choose your Compartment.A list of
How to configure Automatic Managed Backup on DBCS Read More »
