Wednesday, October 21, 2015

How to improve Jdev performance and resolve running Local Jdev in debug mode

I have recently seen an issue while running complex ADF application locally in debug mode, and Jdev performs very very slow to edit single line of code in AMImpl or .jsff file which are having more than 4k Lines of code.


Fix :

- Download JDK 64 bit if your operating system is 64bit
1. Install the Jrockit using below link

        http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-jrockit-2192437.html

2. Modify theC:\Users\xxx\AppData\Roaming\JDeveloper\system11.1.1.7.40.64.93\DefaultDomain\bin\setDomainEnv.cmd file with below changes

set USER_MEM_ARGS=-Xms64m -Xmx2048m -XX:MaxPermSize=1024m
set JAVA_VENDOR=Oracle

set BEA_JAVA_HOME=C:\Program Files\Java\jrockit-jdk1.6.0_45


3. Add below in jdev.conf file

         AddVMOption  -XX:MaxPermSize=1024M


Below article clearly explains the difference b/w having standard JDK vs Jrockit JDK

http://blog.dbi-services.com/a-comparison-of-java-virtual-machines-hotspot-jvm-vs-jrockit-jvm/

Monday, September 28, 2015

How to see the DB Queries executed in Database

It is very common requirement to see what are all the queries are being executed in database,


Step 1 - Execute the below query, In below example, I want to see what are all the queries are being executed on EMPLOYEE table.

select to_char(LAST_ACTIVE_TIME,'dd-mon-yyyy hh24:mi:ss'),last_load_time,sql_id,sql_text
    from v$sql where upper(sql_text) like '%EMPLOYEE%' order by 1 desc;

Step 2 - Look for most recent 'Last_Load_Time' time in the search results

Step 3 - Get the corresponding result row associated 'sql_id' value from above step and supply to below query

                select sql_fulltext from v$sql where sql_id='&name';

Step4 - Supply the sql_id to below query to see the bind variables

                  select name, value_string from v$sql_bind_capture where sql_id = '&sql_id'

Wednesday, June 17, 2015

How to Improve JDeveloper Performance



Identify jdev.conf file in $JDEV_HOME/jdeveloper/jdev/bin ( Eg : C:\Oracle\Middleware\jdeveloper\jdev\bin)

Append below content to jdev.conf file, Save and restart the Jdeveloper

AddVMOption -XX:+AggressiveOpts
AddVMOption -XX:+UseStringCache
AddVMOption -XX:+OptimizeStringConcat

#
# only since Java 6 update 21 performance release
# reduces memory consumption
#
#AddVMOption -XX:+UseCompressedStrings
AddVMOption -XX:+ScavengeBeforeFullGC

#
# only for multi-core machines
#
AddVMOption -XX:+UseConcMarkSweepGC
AddVMOption -XX:+UseGCOverheadLimit

#
# works only on 64-bit JVM
# dramatically reduces memory consumption
# by reducing memory addressing length overhead
#
#AddVMOption -XX:+UseCompressedOops

Thursday, May 14, 2015

Weblogic Learning Notes



Path for 'setDomainEnv.sh'

/boxName/admin/wcp_domain/aserver/wcp_domain/bin

Thursday, January 15, 2015

How to Manage Metadata Partitions using Fusion Middleware Controle

What is Metadata ?

A metadata repository contains metadata for Oracle Fusion Middleware components, such as Oracle BPEL Process Manager, Oracle B2B, and Oracle WebCenter Portal. It can also contain metadata about the configuration of Oracle Fusion Middleware and metadata for your applications.


How to see existing Metadata Repositories and delete them if needed?

- Login to Fusion Middleware Control ( EM Console)
- On Left hand side Menu, Expand 'Metadata Repositories'
- Select your metadata data source
-  Here you can see all the existing Metadata partitions, You can delete them if wanted, It is always best practice to have only one existing MDS Partition always, and remove all the unwanted one's to have more space available.
- You can also see Metadata labels as well.

Tuesday, January 6, 2015

Weblogic Server Workshop Assignments


This blog outlines some of the workshop assignments part of Webogic Server Administration


- Install Weblogic server on Windows Machine and Linux Machine.

- Create a domain name called 'fm_domain'

- Create a Managed Server called 'FMADFServer1'

- Create a Managed Server called 'FMADFServer2'

-  Write a WLST Script to create a Managed Server called 'FMADFServer3'

-  Upgrade the 'fm_domain' to have installed 'Oracle Enterprise Manager'

- Create a Cluster called 'FMADFCluster1'

- Create a Cluster called 'FMADFCluster2' using WLST Script

- Stop and Start 'FMADFServer1' using WLST Script

- Stop and Start 'FMADFServer2' using WLS Console

- Provide a WLST Script to have all the required AD libraries deployed to 'FMADFServer3'

- Create a JDBC Data Source called 'FMRecruitDS' pointing to Oracle Database and target to 'FMADFCluster1 and '2'

- Install Webcenter Portal 11.1.1.8 on Unix Machine

- Install Oracle SOA Suite 11g on Unix Machine

- Install Oracle OSB on Unix machine

- Install Webcenter Sites on Unix Machine

- Install Oracle Database 11g on Unix Machine

- Exercise on Managed Server Memory tuning

- Exercise on configuring Log files on a specific managed server

- Start / Stop Managed server using Node Manager

- Start / Stop Managed server in MSI(managed server independence)  Mode

- Create a domain 'fm_domain_prod' in Production Mode with one cluster , cluster contains two managed servers. Practice Start / Stop all managed servers using Node Manager as well as MSI mode.

- Create and extend a SOA Domain Template using Template Builder

- Use OPatch in Unix and experiment with applying patches to already installed SOA/Weblogic Server/ADF patches.

- Crate a JMS Server 'EmpJMSServer'

- Create  'JMS Module'

- Crate 'Queue' and add a message to the queue

- Create a 'Topic' , add a message to the queue.

- Copy the above created 'fm_domain' to TEST /  PROD environment, i.e try to practice how can you copy the existing domain to another machine without re doing the same again and again.

- Create a Data Source using Weblogic console , pointing to Oracle Database.