--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
A quick and dirty hack to the existing PL/SQL code
which typically adds good performance improvement is
to fetch from your cursor in bulk collect (say 200-500
records at a time).
Otherwise its Perl/C/etc/etc time.
hth
connor
--- Tim Gorman [EMAIL PROTECTED] wrote: Options
#1 (Perl) and #2
Hi
I am trying to maintain currently connected users list using LOGON/LOGOFF
triggres.
But I am experiencing some unexpected behavior for SYS user.
CREATE OR REPLACE TRIGGER SCOTT.LOGON_TRIG
AFTER LOGON ON DATABASE
BEGIN
insert into logon_info
I also have one in Perl that I use to dump an entire schema
to flat files, generating sqlldr parameter and control files
as is goes.
sqlunldr.pl is part of the PDBA toolkit:
http://www.oreilly.com/catalog/oracleperl - click on 'Toolkit'
Jared
On Sat, 2004-01-10 at 19:39, Rachel Carmichael
... with the caveat of somewhat complicating the recovery process.
On Sat, 2004-01-10 at 13:49, DENNIS WILLIAMS wrote:
Ryan - I don't see where you received a direct answer to this question. To
use RMAN to back up to tape you must license what Oracle terms a MML (media
management library).
What happens is that you have a database wide logon trigger,
not just a trigger on scott.schema which needs an execution context.
A pseudo session with a SID=0 is established and the trigger is executed.
Personally, I would use auditing (audit session or audit session by scott),
not a database
Dear Mladen,
Thanks for your response.
SYS and REPADMIN users are keep on LOGGING-IN and LOGGING-OUT periodically
in the background.
That is why SYS user got deleted(when automatic LOG-OUT happens).
Anyway I'll try auditing feature as you suggested.
Thanks again,
Sami
-Original
Dear Mladen,
Thanks for your response.
SYS and REPADMIN users are keep on LOGGING-IN and LOGGING-OUT periodically
in the background.
That is why SYS user got deleted(when automatic LOG-OUT happens).
Anyway I'll try auditing feature as you suggested.
Thanks again,
Sami
-Original
In article [EMAIL PROTECTED], nelson flores
[EMAIL PROTECTED] writes
Something important to take into account when talking about security, is
the problem with if you don't know it's happening you can't stop it...
..
Remember to read/analyze logs for unusual stuff (Oracle or FW logs)...
preferably
Correct me if I am wrong ... but Oracle *does* maintain a list of currently connected
users ... it is called v$session. Why are you trying to do the same manually?
Raj
Rajendra dot Jamadagni at nospamespn dot com
Is there a place that we can see the code without installing the PDBA
toolkit? I don't need to dump any table or schema, I just need to dump a
selected query result (many many rows) into a text file.
Do you just use perl's print to write data?
Guang
On Sun, 11 Jan 2004, Jared Still wrote:
I
Hi All,
I am trying to setup/explore Streams (En-queue/De-queue) in Windows OS using Oracle
Ver 9.2.0.4
The example used given below
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96571/messagedemo.htm#133
But I am getting ORA-03113: end-of-file on communication channel error.
Hi Ron,
If it's going to be an ongoing occurance you might want to consider
Princeton Softech's Relational Tools for Servers suite. In particular,
the Move for Servers product.
I use it to populate up to 20 different development / testing environments
with a relationally intact subset of
A tool such as this would be much more useful if it were
to come preconfigured for use with well known apps, such
as SAP for instance.
It doesn't per chance have such an option does it?
Most ERP systems have far too many tables to try and
do this on your own, unless you are working for a rather
Princeton have definitions for ClarifyCRM, Oracle Apps and PeopleSoft
indicated on their website. I'd strongly suggest talking to their rep's if
you are interested though...
They have excellent support staff and have always been helpful. Plus I
have been told, but don't specifically have
Don,
Comments inline...
Yes! IME, there ARE still problems in the CBO, especially with complex
subqueries.
I have more than a dozen systems where management insists on staying with
the RBO!
[TG]: With all due respect, what does management know about this stuff
anyway? They do not work
Hi Pete
Thanks for the reference. I did visit your site earlier and collected
necessary info.
Using our internal documents, we did come up with our audit review.
Anyway, once again thanks a lot.
Regards
Vidya
Pete Finnigan wrote:
Hi Vidya,
security! - There are a few checklists for security
17 matches
Mail list logo