Performance – Transfering Stats 11i
Source: Oracle Documentations It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts […]
Uncategorized
scripts
Collection of Queries/Scripts
1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’;
Uncategorized
Tables Used by Purge Concurrent Request Concurrent Program
Source: Oracle Documentations Log and Output files retention policy can be controlled by you at o/s level. Once you decide
scripts, workflow
Collection of Workflow Administration Scripts and/or Concurrent Program
Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For
Database
Kill Oracle Sessions
One day My manager fired one sql statement, it got stuck and not moving further. He called up me
Uncategorized
Log files in $APPLCSF/$APPLLOG directory
I would like to share some important things here. You all might know these, but Oracle Apps newbie will get
others
I’ve been tagged – OraBlog Tag
I got a mail in my inbox that “You’ve been tagged” and was really curious to see what does this
ssl
Oracle Wallets – SSL/HTTPS OWM
Oracle Wallet is container/repository to store credentials like certificates, certificate request and private keys, and used if you wish to
Unix
Linux/Unix Basics
‘ROOT‘ on linux is the centre of all power. This account/user is the system administrator who has the access to all files
Uncategorized
Oracle Apps DBA Interview/Technical Question : 10g AS with Apps 11i/R12/12i
Here are few more interview question, focused on Oracle 10g Application Server, Apps 11i/r12/12i and integration of Oracle E-Business Suite