Hi All,
Right now, we are loading a data warehouse. Typically, there would be lots of activity at this point, however, that isn't the case this time.
I do see that there are 3 active select statements and 57 active insert commands. For the select statements, I see that all of them have the wait event: resmgr:pq queued. And, for the inserts, most are showing: PX Deq Credit: send blkd and 1 or 2 have PX Deq: Execute Reply and resmgr:pq queued.
We did recently make some parameter changes. Here are the notable ones:
alter system set parallel_max_servers=256 scope=spfile;
alter system set parallel_degree_policy='ADAPTIVE' scope=spfile;
alter system set parallel_servers_target=128 scope=spfile;
alter system set job_queue_processes=1000 scope=spfile;
alter system set _b_tree_bitmap_plans=FALSE scope=spfile;
alter system set db_writer_processes=16 scope=spfile;
This is a non-production instance. Also, I am running an AWR report to see what it comes up with. The whole loading process started 9/16 around 4pm (note: it is not unusual for this to take several days).
We're trying to understand what is happening and how long we should wait ... or, if we should just start over.
DB (DW) version 12.1.0.2
Regards,
Charles