SGA Hit Ratio’s

Buffer Hit Ratio BUFFER HIT RATIO NOTES: Consistent Gets – The number of accesses made to the block buffer to retrieve data in a consistent mode. DB Blk Gets – The number of blocks accessed via single block gets (i.e. not through the consistent get mechanism). Physical Reads – The cumulative number of blocks read…

MS Office Silent Installation

? Microsoft Office 2007 Enterprise Volume Version (Eng and Kor) ? UltraISO Premium Edition 8.6.1.1985 ? Nero Burning ROM 6.6.1.15 Ultra Edition 1. Make New Folder (Example => C:\OFFICE12) 2. UltraISO Run => File => Open => Office 2007 image File (Example => OFFICE12.ISO) => UltraISO Actions Menu => Extract.. => C:\OFFICE12 => OK =>…

Finding and Updating the GUID of a User in Oracle Application Server

1) Finding the GUID of a User a. Using SQL SQL> select guid from portal.wwsec_person$ where user_name = ‘<user_name>’; b. Using ldapsearch: ldapsearch -h myhost -p 3060 -D cn=orcladmin -w <GUI_password_for_orcladmin_user> -b “” -s sub “cn=<cn_for_problem_user>” “*” orclguid 2) Manually updating a users GUID SQL> update portal.wwsec_person$ set guid = <OID_user_GUID> where user_name =’user_name’; SQL>…

Installation and configuration of Oracle BI Applications 7.9.6 with Oracle EBS R12 and Informatica 8.6

I had a recent activity which involved configuring Oracle BI Applications to utilize the preconfigured reports that come with it. I was able to do the entire setup on my Dell Vostro with 4GB RAM and 2.2 GHz processer, but for better performance I would recommend better hardware. When I initially started I had difficulty…

Concurrent Manager FAQs

Concurrent Manager FAQs Q: Which Concurrent Managers (CCMs) are supported by the Sysadmin team? * Internal Concurrent Manager (ICM) * Standard Manager * Conflict Resolution Manager (CRM) The setup of product-specific managers related issues should be directed to the associated product group, i.e. the Inventory manager Q: Where do the concurrent request output and log…