Home » RDBMS Server » Server Administration » Partitioned Tables for 30+ GB table which load very slow in front end GUI (Oracle 10g)
Partitioned Tables for 30+ GB table which load very slow in front end GUI [message #584369] Mon, 13 May 2013 07:24 Go to next message
oranooob
Messages: 88
Registered: May 2009
Member
Hi

that are my biggest tables

http://i.imgur.com/SCJy2gf.png

Users use front end (called ESS Console) and when they try to open one of those tables they wait very long (really bad performance). Sometimes the GUI even hanging without displaying results.

Does Partitioned Tables feature helps for better performance? What do you think?

Re: Partitioned Tables for 30+ GB table which load very slow in front end GUI [message #584372 is a reply to message #584369] Mon, 13 May 2013 07:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you "open" the whole table, nothing can help you but buy faster disks, cpu and network.

Regards
Michel
Re: Partitioned Tables for 30+ GB table which load very slow in front end GUI [message #584375 is a reply to message #584372] Mon, 13 May 2013 07:42 Go to previous messageGo to next message
oranooob
Messages: 88
Registered: May 2009
Member
No they usally open the last 2000 records of those tables (order by timestamp, newest first). But it is possible to use custom filters, so a full (or at least index scan) table scan is required Sad
Re: Partitioned Tables for 30+ GB table which load very slow in front end GUI [message #584379 is a reply to message #584375] Mon, 13 May 2013 08:00 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you know the problem.
I advise you to hire a consultant to optimize your environment, a forum is not a good place for this unless you are able to provide all information requested in this post.

Regards
Michel
Previous Topic: Migration Assistance
Next Topic: ERROR: ORA-12500
Goto Forum:
  


Current Time: Sat Oct 25 20:32:08 CDT 2014

Total time taken to generate the page: 0.11203 seconds