What is Oracle index clustering factor(CF)? The clustering factor is a number that represents the degree to which data is randomly distributed in a table as compared to the indexed column. In simple terms, it is the number of “block switches” while reading a table using an index. It is an important statistic that play important […]
How Oracle Index clustering factor is calculated Read More »
SSH key pairs can be used for secure login to Linux server with out prompting for password. Puttygen is a very useful key generator which can be used to generate key pairs for login to Linux node on cloud or on premise using putty utility. It uses the private key in ppk format to login
How to Use Puttygen on Windows for key generation Read More »
This post talks about how to recover table using flashback standby database Many times because of human error, Table accidentally get dropped/truncated or partially deleted in the primary database. Such errors can result in “logical” data corruption or cause one or more components of the IT infrastructure to cease operating We will discuss about recovering
Recover drop/truncate/delete table on primary using flashback on standby database Read More »
We already know How to check/change the Workflow Notification mailer configuration from OAM. Today I am going to speak about How to check/change Workflow Notification mailer configuration from the backend ie. database side Workflow Mailer/agent configuration are stored in these tables How to take backup of all the workflow mailer configuration from backend Suppose we want
How to check/change Workflow Notification mailer configuration from backend Read More »
We all know the steps on How to check the status/stop/start Workflow Notification Mailer from OAM( Oracle Application Manager) Login to OAM(Oracle Application Manager)then Workflow Manager->Workflow Then click on the service components It would show the status of all the workflow components. Here you can see the status of the Workflow Notification mailer Here I
How to check the status/stop/start Workflow Notification Mailer from Backend Read More »
Oracle Apps Printer Queries Check which printer,concurrent request is going to print SELECT NUMBER_OF_COPIES ,NLS_LANGUAGE ,NLS_TERRITORY ,PRINTER , PRINT_STYLE ,COMPLETION_TEXT ,OUTPUT_FILE_TYPE , NLS_CODESET ,OUTFILE_NODE_NAME,OUTFILE_NAME FROM apps.FND_CONCURRENT_REQUESTS WHERE REQUEST_ID= &REQID; Check the print style and other things for the concurrent request SELECT PRINTER_STYLE_NAME ,SRW_DRIVER ,WIDTH , LENGTH , ORIENTATION FROM apps.FND_PRINTER_STYLES WHERE PRINTER_STYLE_NAME= ( SELECT PRINT_STYLE
Top 9 Useful Oracle Apps Printer queries Read More »
