Crystal reports issue?

I'm trying to debug an application which had zero dba participation when it was 
built and now a client who is using it is experiencing 'performance' problems.
 
In their statspack reports I originially thought recursive sql was the problem 
based on the way the sql was structured and the developers claiming it wasn't 
their code.  Statspack wasn't showing the entire sql so it threw me for a loop 
initially.
 
We brought in an export of their db and loaded it and I traced a run of the 
problem child.
 
I found the exact same sql in the trace file that was showing as hugely 
expensive in the statspack report. Since then I found out that Crystal reports 
is somehow integrated into this application.  
 
Has anyone seen anything like this kicked out of Crystal?
 
There is no user named 'Admi', they don't have db_links but they have a ton of 
synonyms. 
 
SELECT /*+ RULE */ COUNT(*) FROM ALL_SYNONYMS WHERE DB_LINK IS NOT NULL AND 
SYNONYM_NAME='CLASS' AND OWNER='Admi'
 
SELECT /*+ RULE */ COUNT(*) FROM ALL_SYNONYMS WHERE DB_LINK IS NOT NULL AND 
SYNONYM_NAME='CLASS'
 
SELECT /*+ RULE */ '',owner,table_name,column_name,0,data_type, data_precision, 
decode(data_type,'DATE',16,'FLOAT',8,'LONG 
RAW',2147483647,'LONG',2147483647,'CLOB',2147483647,'BLOB',2147483647,'BFILE',2147483647,'NUMBER',NVL(data_precision+2,40),data_length),
 data_scale, 0, decode(nullable, 'Y', 1, 'N', 0), '' , '', 0, 0, 0, column_id, 
decode(nullable, 'Y', 'YES', 'N', 'NO')  FROM all_tab_columns WHERE 
TABLE_NAME='CLASS' AND OWNER='Admi' UNION SELECT /*+ RULE */ 
'',b.owner,b.synonym_name,a.column_name, 0, a.data_type, a.data_precision, 
a.data_length, a.data_scale, 0, decode(a.nullable, 'Y', 1, 'N', 0), '' , '', 0, 
0, 0, a.column_id, decode(a.nullable, 'Y', 'YES', 'N', 'NO')  FROM 
all_tab_columns a, all_synonyms b WHERE a.table_name = b.table_name and a.owner 
= b.table_owner  AND b.synonym_name
='CLASS' AND b.OWNER='Admi'  ORDER BY 2,3,17
I have no clue as to why these queries would be run in the first place since 
they'd return nothing.  But these type of queries are definitely the source of 
the problem.
 
I know next to nothing about Crystal reports and was hoping someone had 
experienced something similiar to this before.
 
Thanks - Brian
 
 

                
---------------------------------
Yahoo! Mail
 Stay connected, organized, and protected. Take the tour

--
http://www.freelists.org/webpage/oracle-l

Other related posts: