Database Tuning (MOSC)

MOSC Banner

Auto DOP can't work,no idea why

edited Feb 14, 2015 10:00AM in Database Tuning (MOSC) 4 commentsAnswered

Table test is very big,about 45G,

following SQL takes very long time to finish if running in serial:

select avg(a.line_location_id+b.line_location_id) from test a,test b

the workload of the database server is very low:

top - 15:51:42 up 29 days,  2:38,  1 user,  load average: 0.42, 0.50, 0.47

Tasks: 1377 total,   1 running, 1373 sleeping,   0 stopped,   3 zombie

Cpu(s):  2.6%us,  1.1%sy,  0.0%ni, 95.7%id,  0.6%wa,  0.0%hi,  0.0%si,  0.0%st

Mem:  264331892k total, 58181952k used, 206149940k free,  1244216k buffers

Swap: 20479992k total,        0k used, 20479992k free, 28706808k cached

and I configured auto DOP as following:

SQL> show parameter parallel

NAME                                 TYPE        VALUE

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

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