Re: code to load tracefile into CLOB?

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 17 Aug 2011 10:43:11 +0200
Message-ID: <4E4B7F1F.2060803_at_nordea.com>

W dniu 17.08.2011 09:26, Dunbar, Norman (Capgemini) pisze:
> Morning Jeremy,
>

>>> Just wondering...  does anyone out there have a snippit of code that
>>> will load a 10046 trace file from bdump or udump into a LOB?

> No, sorry.
>

>>> looking for a quick and dirty way to give some developers access to
>>> tracefiles (without requiring unix logins).

> Could you not set up a "chrooted" SFTP server on the system with rights
> only to the user_dump_dest location and let them pull down their own
> trace files?
>
> I presume they use "alter session set
> tracefile_identifier=something_or_other;" to readily identify their own
> traces? Using sftp (or even better scp?) would be quite useful.
>
> It might work for you.

another way is to use for example some shared network resource mounted by NFS - of course there are drawbacks - nfs performance, users see all the traces - so You could copy chosen files by some mechanism, but this is more complicated then

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, 
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, 
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, 
o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 17 2011 - 03:43:11 CDT