xmltype.createxml function slow performance
hi
one of the developers is using a plsql block to select/insert/convert to xml/load into queue for processing
the code works however as the rows are processed we are seeing perfomance degradation in the amount of rows processed as time passes. so the first select in the queue shows 30k rows processed, then a minute later only 23K, then 1 min later 10K and so on.
Cannot find any errors in alert logs or trace files of the database.
Has anyone seen this behavior before or know why slowness happens over time while using this function?
this is being tested in our unit environment oracle 10.2 on sun solaris sparc 5.10. pga is set at 100M and workarea init variable set to auto.
any insight is greatly appreciated. stumped in Connecticut!