OraFAQ Forum: Server Administration » Partitioned Tables for 30+ GB table which load very slow in front end GUI

Home » RDBMS Server » Server Administration » Partitioned Tables for 30+ GB table which load very slow in front end GUI (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitioned Tables for 30+ GB table which load very slow in front end GUI [message #584369]

Mon, 13 May 2013 07:24

oranooob
Messages: 88
Registered: May 2009

Member

Hi

that are my biggest tables

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

Michel Cadot
Messages: 68782
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68782
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 10 05:53:22 CDT 2026