Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trace file being generated even with exception is being trapped

kaericnJun 25 2019 — edited Jun 26 2019

Dear community,

We get this err

"ORA-30926: unable to get a stable set of rows in the source tables"

In one of ETL App,  but the exception is trapped.

The main reason why is the source and target and different UK strategy.

In the beginning   data is out-of-sync between source and target and cause the below exception.

However, eventually the data is in-sync after sometimes when it comes to a steady-state.

However, it generates excessive trace file because of that and our DBA team is NOT HAPPY.

below is the trace file DBA team shows us.

The identified object from the DBA email YUK_URN

is the procedure and object that causes our in-transit error.

However, due to our timeline and stability, we cannot going back to the drawing board and have it work out perfectly.

So we suggest some options to  our team

1)DBA team to archive and delete those trace file

2)alter session or ora-debug turn off the trace file

3)call oracle p1 support and have a live session with them

Our else we dev team can do to help in this situation ??

Dev team,

DBA team see lot of trace files on PRD DB  There is nothing much informational in trace file but looks like they are due to ETL exceptions.

Pls have a look.It's urgent as very large files are being generated due to this and filling up f/s space.

Block header dump: 0x32c5dc6a

Object id on Block? Y

seg/obj: 0x490f45 csc: 0xada.c628a1fc itc: 2 flg: E typ: 1 - DATA

brn: 0 bdba: 0x32c5d98b ver: 0x01 opc: 0

inc: 0 exflg: 0

Itl Xid Uba Flag Lck Scn/Fsc

0x01 0x0019.00f.016c8d4e 0x82db7eab.81d1.0f C--- 0 scn 0x0ada.c6281220

0x02 0x001d.00f.0150a48c 0x2580b4bd.4124.0f ---- 11 fsc 0x0000.00000000

bdba: 0x32c5dc6a

data_block_dump,data header at 0x700012d182a6064

===============

tsiz: 0x1f98

hsiz: 0x9a

pbl: 0x700012d182a6064

76543210

flag=--------

ntab=1

nrow=68

frre=-1

fsbo=0x9a

fseo=0x1c6

avsp=0x337

tosp=0x337

0xe:pti[0] nrow=68 offs=0

0x12:pri[0] offs=0x1f2a

0x14:pri[1] offs=0x1ec2

0x16:pri[2] offs=0x1e5c

0x18:pri[3] offs=0x1df4

0x1a:pri[4] offs=0x1d8c

seg/obj: 0x490f45 => YUK_URN

Comments
Post Details
Added on Jun 25 2019
4 comments
341 views