SQL Performance (MOSC)

MOSC Banner

Update Statement Is Too Slow

edited Feb 17, 2016 4:08AM in SQL Performance (MOSC) 9 commentsAnswered

Hi

I have oracle database 11.2.0.4 on oracle linux 6.4

I have configure huge page on this OS .

After 5 months of my projects , when i want to update any tables their have over 20,000,000 records  , this action is too slow or if i want to alter a table to drop a column .

For example , the shahab table has 28,000,000 records , i want to execute the query in below :

UPDATE /*+ PARALLEL(20) */ SHAHAB SET FLAG0='TEST'

in Enterprise manager after sql execue i have this report :

some of statistics about my database :

show parameter sga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean       FALSE

pre_page_sga                      boolean        FALSE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center