OraFAQ Forum: Performance Tuning » a table deleted or updated frequency issue

Home » RDBMS Server » Performance Tuning » a table deleted or updated frequency issue

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

a table deleted or updated frequency issue [message #557595]

Thu, 14 June 2012 03:28

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I select a table which have 10 rows data,it take a long time to get it, why?
the table is deleted or updated frequency.

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557598 is a reply to message #557595]

Thu, 14 June 2012 03:45

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

Senior Member
Account Moderator

For any performances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557599 is a reply to message #557598]

Thu, 14 June 2012 03:54

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel, the situation is that it take a long time to execute the flowing sql,why?

select Count(*)
  from ngoss_edw.fact_cxlm_reg_user t;

  COUNT(*)
----------
     10

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557600 is a reply to message #557599]

Thu, 14 June 2012 04:04

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

Senior Member
Account Moderator

Michel Cadot wrote on Thu, 14 June 2012 10:45

For any performances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557602 is a reply to message #557600]

Thu, 14 June 2012 04:17

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
Michel, what infomation do you need to diagnose my problem?

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557608 is a reply to message #557602]

Thu, 14 June 2012 04:41

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

Senior Member
Account Moderator

The ones that are requested in the link.

Regards
Michel

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557609 is a reply to message #557608]

Thu, 14 June 2012 04:45

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,the problem has solved using move,can you explain the reason?

Report message to a moderator

Re: a table deleted or updated frequency issue [message #557613 is a reply to message #557609]

Thu, 14 June 2012 05:01

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

Senior Member
Account Moderator

Once I will have the information I asked.

Regards
Michel

Report message to a moderator

Re: a table deleted or updated frequency issue [message #558989 is a reply to message #557613]

Wed, 27 June 2012 19:09

alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California

Senior Member

Instead of using "alter table emp move;" which invalidates indexes, I can use the new "shrink space" command that rebuilds the table and moves the rowids within the indexes. This way the indexes never become unusable and the application never experiences any down time.

SQL > alter table scott.emp enable row movement;

Table altered.

SQL > alter table scott.emp shrink space;

Table altered.

SQL > alter table scott.emp disable row movement;

Table altered.

Report message to a moderator

Previous Topic:	Outer join causes much slower performance
Next Topic:	Value for sga_target

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 13:56:54 CST 2025