Database Administration (MOSC)

MOSC Banner

Understanding Oracle's Parallel Processing and expdp/impdp

edited Jun 26, 2017 9:07AM in Database Administration (MOSC) 2 commentsAnswered

Hi Team,

I created an index with parallel option 24.

But can see 47 process running at UNIX level:

oracle    1234     1  2 08:06 ?        00:00:09 ora_p000_eocmdb

oracle    1236     1  2 08:06 ?        00:00:10 ora_p001_eocmdb

oracle    1238     1  2 08:06 ?        00:00:10 ora_p002_eocmdb

oracle    1240     1  2 08:06 ?        00:00:09 ora_p003_eocmdb

oracle    1242     1  2 08:06 ?        00:00:10 ora_p004_eocmdb

oracle    1244     1  2 08:06 ?        00:00:11 ora_p005_eocmdb

oracle    1246     1  2 08:06 ?        00:00:10 ora_p006_eocmdb

oracle    1248     1  2 08:06 ?        00:00:10 ora_p007_eocmdb

oracle    1250     1  1 08:06 ?        00:00:08 ora_p008_eocmdb

oracle    1252     1  2 08:06 ?        00:00:09 ora_p009_eocmdb

oracle    1254     1  2 08:06 ?        00:00:10 ora_p010_eocmdb

oracle    1256     1  2 08:06 ?        00:00:10 ora_p011_eocmdb

oracle    1258     1  2 08:06 ?        00:00:10 ora_p012_eocmdb

oracle    1260     1  1 08:06 ?        00:00:09 ora_p013_eocmdb

oracle    1262     1  2 08:06 ?        00:00:09 ora_p014_eocmdb

oracle    1264     1  2 08:06 ?        00:00:09 ora_p015_eocmdb

oracle    1266     1  2 08:06 ?        00:00:09 ora_p016_eocmdb

oracle    1268     1  1 08:06 ?        00:00:09 ora_p017_eocmdb

oracle    1270     1  2 08:06 ?        00:00:09 ora_p018_eocmdb

oracle    1272     1  2 08:06 ?        00:00:10 ora_p019_eocmdb

oracle    1274     1  2 08:06 ?        00:00:10 ora_p020_eocmdb

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