Oracle Point, Oracle Life.

This is a script to monitor parallel queries against oracle database. It’s tested on Oracle 9.2.0.6 and 10.2.0.1.0.

Monitor_Parallel_Query.sql

Also, in Oracle 9ir2, we can use the following statement to monitoring the salves which are being waited by others.

set SERVEROUTPUT on
declare
inst   varchar(20);
sender varchar(20);
begin
select bitand(&&p1, 16711680) - 65535 as SNDRINST,
decode(bitand(&&p1, 65535),65535, 'QC', 'P'||to_char(bitand(&&p1, 65535),'fm000') ) as SNDR
into  inst , sender
from dual
where bitand(&&p1, 268435456) = 268435456;
dbms_output.put_line('Instance = '||inst);
dbms_output.put_line('Sender = '||sender );
end;
/

Among this statement, the variable &&P1 (senderid) can be retrieved by using the script  Map_Senderid_in_Px_Wait_Event_Oracle_Process.sql.

If we find that lots of slaves are waiting one (several) slaves, we need to investigate why the slaves is not fast enough to dequeue the messages and send the blocks.

Popularity: 3% [?]

Using Mircosoft Vista may introduce the problem of activating Jinitiator while running Oracle forms via oracle application server. The basic solution for this is listed as following.

1. Download latest Java JDK (such as jdk1.6.0)

2. Install JDK and copy the file X:\Program Files\Java\jre1.6.0_01\bin\client\jvm.dll to folder X:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot. To overwrite the existing jvm.dll.

3. Solve OS compatible issue
under folder X:\Program Files\Oracle\JInitiator 1.3.1.21\lib
change font.properties.zh.5 to font.properties.zh.6，and
font.properties.zh.5.1 to font.properties.zh.6.1

4. Languages compatible issue (if you use multiple languages)
in file X:\Program Files\Oracle\JInitiator 1.3.1.21\lib\font.properties, change filename.\u5b8b\u4f53=SIMSUN.TTF to filename.\u5b8b\u4f53=SIMSUN.TTC

Above is the essential changes after OS is upgraded to Microsoft Vista.

Popularity: 100% [?]