Re: code to load tracefile into CLOB?
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Aug 2011 10:43:11 +0200
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@xxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
