Performance - EBS (MOSC)

MOSC Banner

Select low performance on temporary table and hight performance on no temporary table

edited Jun 25, 2012 10:12PM in Performance - EBS (MOSC) 2 commentsAnswered
Hi,
On RDBMS 10.2.0.5 we have low performance when we run a select on temporary table but we replace the temporary table with no temporary table
the result performance are better.

Details :

CREATE GLOBAL TEMPORARY TABLE "XLA"."XLA_REPORT_BALANCES_GT"
( "LEDGER_ID" NUMBER(15,0),....



sqlplus apps

insert into xla_report_balances_gt (.....) select from ........;

14038 rows created.

--- result 1select on temporary  table xla_report_balances_gt ( no statistique on this temporary table and full acces table xla_report_balances_gt ) :

select count(*)
................. from ...... XLA_REPORT_BALANCES_GT
union .....
from .... XLA_REPORT_BALANCES_GT
....;

 COUNT(*)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
----------                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
1389


call     count       cpu    elapsed       disk      query    current        rows

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center