Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Fernando.

Asked: July 18, 2001 - 9:41 am UTC

Last updated: October 30, 2004 - 2:11 pm UTC

Version: Oracle 8.0.x

Viewed 10K+ times! This question is

You Asked

Dear Tom,

Is it normal if my Oracle 8.0x database starts to create "strange" sessions with the next set of characteristics:

- They are created eventually (2 or 3 times a day),
- They are created with the name of the end users (field v$session.username),
- If I check the program associated (field v$session.program), it says: "ORACLE80.EXE(P001)" or (P002) or 3 or 4
- If I kill that session, I'm not killing the session of the end user (I think I'm killing a process in the server that's creating a dump file). If I check in my dump-directory the files <SID>P001.trc I find the text: "ksedmp: internal or fatal error"

Is there any way to avoid it (I mean avoid those "new sessions")?!

Thanks,

Fdo.




and Tom said...

they are parallel query slaves. You have enabled parallel query in your database and your end users are (trying to) taking advantage of it.

don't kill them, turn off parallel query if you want, but don't kill them.



Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

How DO you kill them

Doug, October 28, 2004 - 3:56 pm UTC

Tom - When asked to kill an operation in parallel I can't seem to do it. I use Note:202219.1 to determine the various sid's involved but if I kill them all in a row, they just pick up new serial#s. How do you kill a parallel query?

Tom Kyte
October 28, 2004 - 7:44 pm UTC

kill the parent session only. the pqs will stop when they discover the coordinator is gone.

Killing coordinator

Doug C, October 30, 2004 - 1:32 am UTC

Tom after killing the coordinator process it took 19 hours for the pq's to quit - is that normal?

Tom Kyte
October 30, 2004 - 2:11 pm UTC

could be -- they don't bother talking to the coordinator until they have something to tell it.

but it could also be that they finished and just hung out waiting to be asked to do something else by someone else.

where they still active that entire time?
where they doing pdml or query only.

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.