I'm running a Data Pump import, and tracking what it is doing. Right now, this is the last few lines of the log file:
. . imported "WK_TEST"."WK$STATISTIC" 6.984 KB 0 rows
. . imported "WK_TEST"."WK$URL" 12.30 KB 0 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
It is easy enough to find out what it is actually doing with this query: 1* select sql_text from v$sql where sql_text like 'CREATE%' and users_executing=1
SQL> /
SQL_TEXT
--------------------------------------------------------------------------------
CREATE INDEX "PROV"."AK_NPF_RUN_EVENT" ON "PROV"."NPF_RUN_EVENT" ("NPF_RUN_ID")
but that only works because I guessed it is creating something. What I want to run is this,
select sql_text from v$sql join v$session using (sql_id) where program like '%DW%';
" and "Bug 13068790 - the value of v$session.sql_id of active session is null [ID 13068790.8]"
Does anyone have a query that will let me see easily what the worker is doing, without having to guess?
] 
Blog
Search
Help
Members
Register
Login
Home
