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?

Report message to a moderator

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: 68641
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

Report message to a moderator

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

Report message to a moderator

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: 68641
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:51:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.