Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!g8g2000pri.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Spying on queries from application? Date: Wed, 3 Mar 2010 10:10:44 -0800 (PST) Organization: http://groups.google.com Lines: 58 Message-ID: References: <89940d92-9bd6-4aca-a03c-08da0e173a9d@z11g2000yqz.googlegroups.com> <62cbe258-eb16-4474-86ad-bf977e8cbef6@q23g2000yqd.googlegroups.com> NNTP-Posting-Host: 12.232.112.189 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1267639844 11755 127.0.0.1 (3 Mar 2010 18:10:44 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 3 Mar 2010 18:10:44 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: g8g2000pri.googlegroups.com; posting-host=12.232.112.189; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Mar 3, 8:40=A0am, jodleren wrote: > On Mar 3, 6:25=A0pm, John Hurley wrote: > > > > > On Mar 3, 9:51=A0am, jodleren wrote: > > > snip > > > > Hi all > > > > We have a management programme, which uses Oracle DB. > > > We (I) also make some intranet stuff etc for this system, which uses > > > the same DB. > > > > Now I need to track what this programme does, meaning I want to know > > > which tables it uses etc for certain actions. The programme is not > > > made by us, we just have our own additions. > > > Therefore I need to copy some of that action. > > > > Is there a spy that can give me that? > > > The programme uses ODBC. My driver is 10.2. I dont know about the DB > > > version. > > > > WBR > > > Sonnich > > > You can set an after login database trigger and activate low level > > tracing if needed. > > > The trace files can get very big and you don't want to do this for > > many sessions probably. > > > Google around for things like "oracle database login trigger" and/or > > "10046 trace" ... proceed cautiously and test out everything in a test > > environment before even thinking about possibly doing this in a live > > prod environment. > > > Have you talked to your DBA's about the information that you need? > > The DBA is long time dead :) And I do not know that much about Oracle > yet. > We have a test DB where I can play, I will check it out. > > Sonnich dbconsole or it's big brother EM can do it, you can look at all sessions, pick out cursors and specific SQL to your hearts content. There is probably a port 550x or 180x access through your browser. Try https://yourhostname:5500/em You may need to know the system login or equivalent. We could give more advice if we knew what kind of host you have, like where to look for the information about ports, or how to see if it is running. jg -- @home.com is bogus. http://www.fastcompany.com/magazine/53/peters.html