Home » RDBMS Server » Performance Tuning » Need Help
Need Help [message #239050] Mon, 21 May 2007 06:10 Go to next message
faisalferoze
Messages: 3
Registered: May 2007
Location: Pak
Junior Member
I have a table which size is approximately 10GB. In this table client Openning Balances and client daily balance DR/CR. When I run the report against this table.
It takes approximately 8minutes.
Query is written in such format that if i want to print a report of 21st may. It first pick up the opening balance when client open account and do plus or minus up to 21st may. and show us the closing balance against 21st may. Please tell me the best way to overcome this situation. What changes may be helpfull. Any Idea??

Thanks
Re: Need Help [message #239055 is a reply to message #239050] Mon, 21 May 2007 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems a fashionable question as I answer the same 10 days ago there:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3083286970877#267273900346652341

Regards
Michel
Re: Need Help [message #239059 is a reply to message #239050] Mon, 21 May 2007 06:48 Go to previous messageGo to next message
faisalferoze
Messages: 3
Registered: May 2007
Location: Pak
Junior Member
Thanks

We are using the vendor application. So I do not require a query. In first post i just try to mention the way our query work. I just want to enhance the performance of the query as a DBA. How can i do that??. Any Idea??

Thanks
Re: Need Help [message #239070 is a reply to message #239059] Mon, 21 May 2007 07:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change the query? Or ask the vendor to change it.
Add new index.
Create a materialized view.
Add parallelism.
Increase cache size.
Add new cpu.

Who knows what you have?

Regards
Michel

Re: Need Help [message #239083 is a reply to message #239070] Mon, 21 May 2007 07:59 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You can also take a look at stored outlines if you cant change the query.
Re: Need Help [message #239305 is a reply to message #239083] Tue, 22 May 2007 00:29 Go to previous message
faisalferoze
Messages: 3
Registered: May 2007
Location: Pak
Junior Member
Thanks. but problem is we have not vendor support.
Our Application made in Oracle developer. I have never used oracle developer so i have no idea. I want to share some steps and please guide me according to this.we have a report section we just select the report and provide all criteria then we press print button and it open a report background engine and then show us report. Current Query used pl/SQl code using bind variables. Please tell me now which is the best option for me to used.

Materialized view
Stored Outlines
any other U think after reading scenario

Things really confused me
Please help me on this

Can we create a materialized view on query which used bind variables ????
And also considered the upper scenario whether i forced the query to used the mateirlized view??? Our current query used the plsql code. If i create a materialized view on that code whether it is override the plsqlcode???

Thanks





Previous Topic: NEED GUIDENCE
Next Topic: How to get TRACE for a Sql script which is being called from a shell program
Goto Forum:
  


Current Time: Fri Dec 02 22:50:18 CST 2016

Total time taken to generate the page: 0.14703 seconds