Pular para o conteúdo principal

Postagens

Mostrando postagens de julho, 2011

List Responsibilities That Can Run a Given Concurrent Program

set verify off set pagesize 1000 column RN format A40 heading "Responsibility Name" prompt prompt &1 can be run by: SELECT responsibility_name RN FROM fnd_request_groups frg, fnd_request_group_units frgu, fnd_concurrent_programs_vl fcpv, fnd_responsibility_vl frv WHERE frgu.request_unit_type = 'P' AND (UPPER(fcpv.concurrent_program_name) = UPPER('&1') OR UPPER(fcpv.user_concurrent_program_name) = UPPER('&1')) AND frgu.request_group_id = frg.request_group_id AND frgu.request_unit_id = fcpv.concurrent_program_id AND frv.request_group_id = frg.request_group_id ORDER BY responsibility_name / Metalink note: 134036.1

Finalize Concurrent Program with Normal/Warning/Error Status Code

declare l_result boolean; SELECT count(1) a, (CASE WHEN a < 1000 THEN l_result := fnd_concurrent.set_completion_status('NORMAL',Complete normal.'); WHEN a >= 1000 THEN l_result := fnd_concurrent.set_completion_status('WARNING','Complete with warnings.'); ELSE l_result := fnd_concurrent.set_completion_status('ERROR','Complete with error.'); END ) Raise FROM teste; commit; end; / exit;

What is The Maximum JVM Heap Size (-Xmx) Value To Set In jvmOptions Parameter?

C:\Users\denilson>java -Xmx1520m -version java version "1.4.2_14" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_14-b05) Java HotSpot(TM) Client VM (build 1.4.2_14-b05, mixed mode) C:\Users\denilson>java -Xmx1530m -version Error occurred during initialization of VM Could not reserve enough space for object heap Could not create the Java virtual machine.