Home » RDBMS Server » Performance Tuning » a table deleted or updated frequency issue
a table deleted or updated frequency issue [message #557595] Thu, 14 June 2012 03:28 Go to next message
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.
Re: a table deleted or updated frequency issue [message #557598 is a reply to message #557595] Thu, 14 June 2012 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: a table deleted or updated frequency issue [message #557599 is a reply to message #557598] Thu, 14 June 2012 03:54 Go to previous messageGo to next message
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


Re: a table deleted or updated frequency issue [message #557600 is a reply to message #557599] Thu, 14 June 2012 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: a table deleted or updated frequency issue [message #557602 is a reply to message #557600] Thu, 14 June 2012 04:17 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
Michel, what infomation do you need to diagnose my problem?
Re: a table deleted or updated frequency issue [message #557608 is a reply to message #557602] Thu, 14 June 2012 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The ones that are requested in the link.

Regards
Michel
Re: a table deleted or updated frequency issue [message #557609 is a reply to message #557608] Thu, 14 June 2012 04:45 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,the problem has solved using move,can you explain the reason?
Re: a table deleted or updated frequency issue [message #557613 is a reply to message #557609] Thu, 14 June 2012 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once I will have the information I asked.

Regards
Michel
Re: a table deleted or updated frequency issue [message #558989 is a reply to message #557613] Wed, 27 June 2012 19:09 Go to previous message
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.
Previous Topic: Outer join causes much slower performance
Next Topic: Value for sga_target
Goto Forum:
  


Current Time: Thu Dec 18 22:10:16 CST 2014

Total time taken to generate the page: 0.23282 seconds