Understanding Oracle's Parallel Processing and expdp/impdp
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