Home » SQL & PL/SQL » SQL & PL/SQL » Accessing Data From Oracle Reports
Accessing Data From Oracle Reports [message #218791] Sat, 10 February 2007 06:04 Go to next message
Messages: 1
Registered: February 2007
Location: Srilanka
Junior Member
I am using Oracle 9I Data base and Oracle Reports 6I
My problem is that when the data is accessed using Oracle reports it is about 100 times slower than accesing through a
SQL navigator with the same SQL. THe SQL satement is properly tuned and runs very fast with the SQL navigator. But when it is run with the Oracle reports it is very mush slower with the same SQL statement. PLease advise
Re: Accessing Data From Oracle Reports [message #218820 is a reply to message #218791] Sat, 10 February 2007 15:21 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
- Run a trace/tkprof on both to check if the same plan is used
- Run the statement in sqlplus instead of sql-Navigator. (does sql-navigator return ALL rows or rows per page?)
Previous Topic: How to Remove New Line Character in Multilne String
Next Topic: merging the data
Goto Forum:

Current Time: Thu Jun 22 13:27:45 CDT 2017

Total time taken to generate the page: 0.12016 seconds