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.