RE: All phasis are aborted only cleanup is completed

Posted by latifa on Jan 13, 2017; 10:21pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1911.html

Hi,

 

One more information : after check shell sessions, the following doesn’t exist any more:

 

opfinbac  8566 23366   0 16:09:23 ?           0:00 sqlplus -s /nolog

 

and I think it corresponds to SID = 259 which is not present.

 

Regards,

Latifa

 

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 9:26 PM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1909.html

To unsubscribe from All phasis are aborted only cleanup is completed, click here.
NAML

Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l’intention exclusive des destinataires désignés. Il contient des informations confidentielles et pouvant être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de détruire le message. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse de l’émetteur. L'internet ne garantissant pas l'intégrité de ce message lors de son acheminement, Atos (et ses filiales) décline(nt) toute responsabilité au titre de son contenu. Bien que ce message ait fait l’objet d’un traitement anti-virus lors de son envoi, l’émetteur ne peut garantir l’absence totale de logiciels malveillants dans son contenu et ne pourrait être tenu pour responsable des dommages engendrés par la transmission de l’un d’eux.

This message and any attachments (the "message") are intended solely for the addressee(s). It contains confidential information, that may be privileged. If you receive this message in error, please notify the sender immediately and delete the message. Any use of the message in violation of its purpose, any dissemination or disclosure, either wholly or partially is strictly prohibited, unless it has been explicitly authorized by the sender. As its integrity cannot be secured on the internet, Atos and its subsidiaries decline any liability for the content of this message. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.