Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 88EF910034AA6E for ; Thu, 21 Oct 2021 20:20:29 +0200 (CEST) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 524FD416B3; Thu, 21 Oct 2021 18:20:28 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 370563FB43; Thu, 21 Oct 2021 18:20:28 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1634840428; bh=Ed4i+rmhh7B78kbm1VfcTcAV4bX6bOZnW9lf1pZlHIU=; h=From:Sender:Sender:From; b=lTaJALzzMUPLv6yDHlorqDnjF29yGPmo3dQpSz2nhIqPiPYOqRMAbrVU5yuOOHygz /reXNA9aCZWLWrVMX8cSQYUxUzyvg5xXxWyzS11aaRNKPfAt6drJ23T1/2dvNapxcv YzOT+pMN6sfWlTvwM9e263A99FCkpwgu6bWaFses= X-Virus-Scanned: by FreeLists at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id OswxJiuOngVz; Thu, 21 Oct 2021 18:20:28 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id D92BD3FB46; Thu, 21 Oct 2021 18:20:24 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1634840426; bh=Ed4i+rmhh7B78kbm1VfcTcAV4bX6bOZnW9lf1pZlHIU=; h=From:Sender:Sender:From; b=TcwJ238Ql3caHiOHbpFjFw7UEm/fBVVJfIWrBMzSTxuuztCiq0IsrHCzAxM9eRcQ/ WxZCGx7Ceiz/J45eprCp43wVamqSp2ymB8RsOpQjMtotIyqcuT7WSsDkxDL+sHCEsL 2oz8cCv9qI/oJ0Vr+T5V5jNxPd5XesfjTK+oMews= Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 21 Oct 2021 18:20:23 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 3CE5A3FB43 for ; Thu, 21 Oct 2021 18:20:23 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key; unprotected) header.d=selectcomfort.onmicrosoft.com header.i=@selectcomfort.onmicrosoft.com header.a=rsa-sha256 header.s=selector1-selectcomfort-onmicrosoft-com header.b=NFgvjFrm; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id YCoe0s9PjCcO for ; Thu, 21 Oct 2021 18:20:23 +0000 (UTC) Received: from NAM12-MW2-obe.outbound.protection.outlook.com (mail-mw2nam12on2040.outbound.protection.outlook.com [40.107.244.40]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id E4D943FB3E for ; Thu, 21 Oct 2021 18:20:22 +0000 (UTC) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=aWuN/NzU5X4JPoCNTrjzrP2UftWgVIvrD8UDtJB/0OwlnSybBs3zv9IJFjCaJG4hMo378TD/Kz0jWb5w/UGow864Is14QuSTsF9Gsh4IOU2u0Up7DvnteAPDYsSjzOGoIjL3BuS2axDHc3beGRYytZ/62eG/D4T+L8bC5FALi31dDqVEmgAIZ+MtCt96AHd3Gc67cqeSPxMoiVkXRfHXg7F68RUjE9VnXeq/7CzMsi70KS9/aGYAqys+HQNa1+m34MiuUatJMnkk9TOOzwsnvAq8txnm1vG2sevdrQfMpny70yCev9HOaeDlcJtV8AB1Pas/977E0wlDKqvQGJp6qw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Y83WqnJm+KfIVBBNk3T/NsbmcVlJlrb7V+kH7TBTJSc=; b=KPovAsxvvQZv+U+PjNFdvl248TLmIcC7Mp9FOmOmSIyt1C6X0QPTOfxXHLXDVJimZc+Mv6lmzHgZjvOzcfesGwngZbADsDqWMoC+5UihVJ+XUaC/oT4J6/bb6skO+iF1mMTegxL/I3pTWqJpqu6x+PDkjNDuLXYK4i2MZGZIJDH7P2VrWWzuvO9wD8bfAsecev5ZVGCmx0qcUdN4XIJXXUJyLbORGhNHTvey+hC4D3koiXtYZEro5mgDA9ccWt+3uy8TMDYNwl5npM2GiPrO0Vzu7WMQYpzhEF7x6ISjgnz2mmnt6Kf7HgNwyOVT8lb0sEIPtXiJnWX7FbQy2gL9eg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=sleepnumber.com; dmarc=pass action=none header.from=sleepnumber.com; dkim=pass header.d=sleepnumber.com; arc=none Received: from CH0PR14MB5012.namprd14.prod.outlook.com (2603:10b6:610:d3::12) by CH2PR14MB4152.namprd14.prod.outlook.com (2603:10b6:610:a9::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4628.15; Thu, 21 Oct 2021 18:20:21 +0000 Received: from CH0PR14MB5012.namprd14.prod.outlook.com ([fe80::adfd:712e:feec:8c27]) by CH0PR14MB5012.namprd14.prod.outlook.com ([fe80::adfd:712e:feec:8c27%8]) with mapi id 15.20.4628.018; Thu, 21 Oct 2021 18:20:21 +0000 From: "Hameed, Amir" To: Noveljic Nenad , ORACLE-L Subject: RE: [EXTERNAL] RE: Timestamp and module of DDL operation Thread-Topic: [EXTERNAL] RE: Timestamp and module of DDL operation Date: Thu, 21 Oct 2021 18:20:21 +0000 Message-ID: References: <5bee9be07acb4a0c91d04da3ffa3d072@vontobel.com> In-Reply-To: <5bee9be07acb4a0c91d04da3ffa3d072@vontobel.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: vontobel.com; dkim=none (message not signed) header.d=none;vontobel.com; dmarc=none action=none header.from=sleepnumber.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: e93135e9-3305-4c45-daac-08d994bf7187 x-ms-traffictypediagnostic: CH2PR14MB4152: x-ms-oob-tlc-oobclassifiers: OLM:6430; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CH0PR14MB5012.namprd14.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(64756008)(33656002)(9326002)(53546011)(66556008)(2906002)(166002)(66446008)(110136005)(52536014)(6506007)(5660300002)(86362001)(8936002)(38070700005)(66946007)(7696005)(66476007)(316002)(83380400001)(76116006)(9686003)(8676002)(26005)(122000001)(71200400001)(38100700002)(55016002)(186003)(508600001);DIR:OUT;SFP:1101; Content-Type: multipart/alternative; boundary="_000_CH0PR14MB50124F8A53F13ECE6100FB9FE0BF9CH0PR14MB5012namp_" MIME-Version: 1.0 X-OriginatorOrg: sleepnumber.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CH0PR14MB5012.namprd14.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: e93135e9-3305-4c45-daac-08d994bf7187 X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Oct 2021 18:20:21.3132 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: ed8aabd5-14de-4982-9fb6-d6528851af5e X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: amir.hameed@sleepnumber.com X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH2PR14MB4152 X-archive-position: 81213 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: amir.hameed@sleepnumber.com Precedence: normal Reply-To: amir.hameed@sleepnumber.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --_000_CH0PR14MB50124F8A53F13ECE6100FB9FE0BF9CH0PR14MB5012namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Nenad, Auditing is set up at a limited level and not every DDL action is being aud= ited. We have asked the DBAs to start auditing DDL statements related to SY= NONYMs. Thank you, Amir From: Noveljic Nenad Sent: Thursday, October 21, 2021 2:16 PM To: Hameed, Amir ; ORACLE-L Subject: [EXTERNAL] RE: Timestamp and module of DDL operation CAUTION: External source Hi Amir, Have you considered setting up auditing? Best regards, Nenad From: oracle-l-bounce@freelists.org <= oracle-l-bounce@freelists.org> On Beh= alf Of Hameed, Amir Sent: Donnerstag, 21. Oktober 2021 00:57 To: ORACLE-L > Subject: Timestamp and module of DDL operation Hi, We are trying to find out when and from which application a DDL statement c= ame that caused issues in the apps because it recompiled a SYNONYM that one= of the main app's packages has a hard dependency on. The LAST_ACTIVE_TIME = column V$SQLSTATS is NULL. Is there a way to find out the MODULE and the ex= ecute timestamp of a DDL statement? In our case the statement was: ALTER SYNONYM "APPS"."FND_USER" COMPILE Thanks, Amir ____________________________________________________ Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken. Important Notice This message is intended only for the individual named. It may contain conf= idential or privileged information. If you are not the named addressee you = should in particular not disseminate, distribute, modify or copy this e-mai= l. Please notify the sender immediately by e-mail, if you have received thi= s message by mistake and delete it from your system. Without prejudice to any contractual agreements between you and us which sh= all prevail in any case, we take it as your authorization to correspond wit= h you by e-mail if you send us messages by e-mail. However, we reserve the = right not to execute orders and instructions transmitted by e-mail at any t= ime and without further explanation. E-mail transmission may not be secure or error-free as information could be= intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also p= rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob= el Holding Ltd. and any of its affiliates (hereinafter collectively referre= d to as "Vontobel Group") for any damages resulting from e-mail use is excl= uded. You are advised that urgent and time sensitive messages should not be= sent by e-mail and if verification is required please request a printed ve= rsion. Please note that all e-mail communications to and from the Vontobel Group a= re subject to electronic storage and review by Vontobel Group. Unless state= d to the contrary and without prejudice to any contractual agreements betwe= en you and Vontobel Group which shall prevail in any case, e-mail-communica= tion is for informational purposes only and is not intended as an offer or = solicitation for the purchase or sale of any financial instrument or as an = official confirmation of any transaction. The legal basis for the processing of your personal data is the legitimate = interest to develop a commercial relationship with you, as well as your con= sent to forward you commercial communications. You can exercise, at any tim= e and under the terms established under current regulation, your rights. If= you prefer not to receive any further communications, please contact your = client relationship manager if you are a client of Vontobel Group or notify= the sender. Please note for an exact reference to the affected group entit= y the corporate e-mail signature. For further information about data privac= y at Vontobel Group please consult www.vontobel.com. --_000_CH0PR14MB50124F8A53F13ECE6100FB9FE0BF9CH0PR14MB5012namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Ne= nad,

Audit= ing is set up at a limited level and not every DDL action is being audited.= We have asked the DBAs to start auditing DDL statements related to SYNONYM= s.

=  

Thank= you,

Amir<= o:p>

From: Noveljic Nenad <nenad.noveljic@vonto= bel.com>
Sent: Thursday, October 21, 2021 2:16 PM
To: Hameed, Amir <amir.hameed@sleepnumber.com>; ORACLE-L <o= racle-l@freelists.org>
Subject: [EXTERNAL] RE: Timestamp and module of DDL operation

 

<= span lang=3D"DE-CH" style=3D"font-size:10.0pt;color:white">CAUTION: External= source

 =

Hi Amir,

 =

Have you considered setting up auditing= ?

 

Best regards,

 

Nenad

 

From: oracle-l-bounce@freelists.org <oracle-l-bounce@freelists.org> On Behalf Of Hameed, Amir
Sent: Donnerstag, 21. Oktober 2021 00:57
To: ORACLE-L <oracle-l@= freelists.org>
Subject: Timestamp and module of DDL operation

Hi,

We are trying to fi= nd out when and from which application a DDL statement came that caused iss= ues in the apps because it recompiled a SYNONYM that one of the main app= 217;s packages has a hard dependency on. The LAST_ACTIVE_TIME column V$SQLSTATS is NULL. Is there a way to find out the= MODULE and the execute timestamp of a DDL statement? In our case the state= ment was:

ALTER SYNONYM "= ;APPS"."FND_USER" COMPILE

 

Thanks,
Amir

____________________________________________________

Please consider the environment before printing this e-mail.<= /span>

Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail d= rucken.=


Important Notice

This message is intended only for the individual named. It may contain conf= idential or privileged information. If you are not the named addressee you = should in particular not disseminate, distribute, modify or copy this e-mai= l. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from= your system.
Without prejudice to any contractual agreements between you and us which sh= all prevail in any case, we take it as your authorization to correspond wit= h you by e-mail if you send us messages by e-mail. However, we reserve the = right not to execute orders and instructions transmitted by e-mail at any time and without further explana= tion.
E-mail transmission may not be secure or error-free as information could be= intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also p= rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob= el Holding Ltd. and any of its affiliates (hereinafter collectively referred to as "Vontobel Group") for a= ny damages resulting from e-mail use is excluded. You are advised that urge= nt and time sensitive messages should not be sent by e-mail and if verifica= tion is required please request a printed version.
Please note that all e-mail communications to and from the Vontobel Group a= re subject to electronic storage and review by Vontobel Group. Unless state= d to the contrary and without prejudice to any contractual agreements betwe= en you and Vontobel Group which shall prevail in any case, e-mail-communication is for informational purpo= ses only and is not intended as an offer or solicitation for the purchase o= r sale of any financial instrument or as an official confirmation of any tr= ansaction.
The legal basis for the processing of your personal data is the legitimate = interest to develop a commercial relationship with you, as well as your con= sent to forward you commercial communications. You can exercise, at any tim= e and under the terms established under current regulation, your rights. If you prefer not to receive any fu= rther communications, please contact your client relationship manager if yo= u are a client of Vontobel Group or notify the sender. Please note for an e= xact reference to the affected group entity the corporate e-mail signature. For further information about data = privacy at Vontobel Group please consult www.vontobel.com.

--_000_CH0PR14MB50124F8A53F13ECE6100FB9FE0BF9CH0PR14MB5012namp_-- -- http://www.freelists.org/webpage/oracle-l