thats not appropriate. go to metalink, there is a script to run to setup
security to work with .mmbs. we used on a project i was on last year. I
think it was pretty easy to use. it just creates views and checks existing
roles. I 'think'. I cant remember exactly. I think you combine this with a
data
Title: Re: has anyone used threads to parallelize bulk loads?
we are still on 8i at work. That stuff is useful in
the future. what would you suggest for parallel extraction to from a DB to
files? I dont know perl and dont have time to learn it right now. I can do it in
C. yeah I know its easy
id like the wait, notify because when parts of a
load end, I need to kick off other parts. you know any good sources on
this?
we are using 8i at work. So I cant use the
recommendations that tim made.
whenever i do a google search on pthreads, I get a
ton of results and cant find good on
Title: Re: has anyone used threads to parallelize bulk loads?
Or forget about 3GL programming altogether and just query 9i external tables in parallel and pass the results into an INSERT /*+ APPEND PARALLEL */? Combine it all with PL/SQL pipelined table functions and you have parallel ETL -- “
Hi Rahul,
I know this isn't a direct answer to your question but you may find
useful a large number of papers about Oracle security that are available
on my website, quite a few by me and links to papers by many others that
I have collected together. My site is http;//www.petefinnigan.com - have
a
Why dbms_job at all? Just create as many sqlplus
sessions as you want using nohup in your database and execute your
procedures from there. You can still use dbms_lock, dbms_alert and
dbms_pipe that way.
Pthreads or IPC & stuff is probably overkill if
you don't need synchronization outside th
> Ryan wrote:
>
> I find this useful when I have large loads with alot of small to
> medium sized DML statements. Instead of running them serially I use
> DBMS_JOB and break them up into pieces.
>
> DBMS_JOB is limiting in that it can only do 36 at once per instance.
> If I want to do more, Id ha
I find this useful when I have large loads with
alot of small to medium sized DML statements. Instead of running them serially I
use DBMS_JOB and break them up into pieces.
DBMS_JOB is limiting in that it can only do 36 at
once per instance. If I want to do more, Id have to do it outside t
Yep. Forgot to mention that. But there is a catch. Sometimes the
Connection pooling logic doesn't make call to the same SID,Serial#
combination. Hence you might find quite a no.of SNIPEd sessions remaining
in v$session. Just keep an eye on it along with avbl shared_pool at
runtime. When you reac
Env AMD 1.6 processor 512 Ram WD 120G HD (Personal computer)
While installing Redhat Linux 8 from a CD (came with a book) on newly
purchased 120G WD harddrive(manufacturing date of HD is 07/2003) it is keep
hanging after recognizing mouse. I tried both gui as well as text option.
The bios disk
List, after reading so much about managing the srcurity from the db users,
roles and privileges, i have finally decided to do the same. I have figured
out most of the things...
1. i have made a form interface to create role and grant privileges to
roles. all the data goes to app tables, and the
You may take a look at the book Oracle for Linux DBA's.
> "Design and Implementation of the [UNIX || 4.x BSD] Operating System" by
> [Bach || McCusic et all]
>
> Should both have excellent overviews of shared memory, semaphores, and why
> they're useful. If you want even more nitty gritty, pick u
> But the user need select access to v$mystat
connect as sysdba and grant select on v_$mystat to ;
HTH
GovindanK
> Thanks all for the input.
>
> the script is select sid,serial# from v$session where sid=(select sid from
> v$mystat where rownum=1)
>
> But the user need select access to v$mystat
>
If the problem is with idle sessions remaining open, then you can use
profile IDLE_TIME to kill them.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, August 30, 2003 3:14 PM
> Nuala,
>
> I have been on this damn Java Client con
Hello Experts,
I am using Jdeveloper 9i to make a simple Application which
reads data from a binary file and displayes it in a TextArea
or JTextArea. This application works fine when i run & test
it through the JDeveloper 9i Environment. But when i deploy this
application into a "JAR File - S
>Put the following code snippet
> "if [ "$LOGNAME" = "root" ];
> then init 0
> fi;
> in your oraenv. I guarantee you that the SA will no longer be
connecting >as SYSDBA.
May be it will happen once. A smart SA will suppress it next time.
OR he/she can always create another OS account with i
Nuala,
I have been on this damn Java Client connections for quite a while.
If it is development , you can use PROFILES/SESSIONS_PER_USER and prevent
init.ora setting from being reached and hog the system.
The unfortunate thing is the connection pool is that the code is not proven
in most of the
Drop the index, create it in another tbs/disk; check if the error(s)
appear during the next RMAN bkp run. If it doesn't then it would confirm
that your problem is real.
> Roger
>I have never received this error (or didn't read the log closely
> enough).
> I think I heard somewhere that is how
- Original Message -
> asked to hold on the TAR call for a dozen ORA-600 errors? Or negotiating
> with a bunch of developers for using bind variable?
Oh, can I bring the blunt implement?
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Use a Database Trigger AFTER SERVERRROR.
[careful, the table might fill up pretty quickly -- e.g at my site a load job
ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!]
Try this :
drop table system.oracle_errors;
create table system.oracle_errors
(db_username varcha
Title: Re: How to keep "root" out?
A...
But if you encrypt it, where do you keep the key? How do you retrieve it for use? Don’t forget to follow the problem to the next step...
...and when you do, you realize that if nobody can be trusted, then the problem of security becomes an
Hmm.
Note 29732.1 on MetaLink does list seperate part numbers for Oracle7.3.4
on HPUX 10.20 and 11.x.
But does not make it clear that the two OS versions are not object-file
compatible.
See Note 99206.1 for the different possible scenarios in upgrades on HP.
However, Jesse's advice is best.
It worked with both X11 emulator and an Ultra 5 station which has native X11.
As far as PC is concerned, performance was decent. Same goes for SUN.
As for security holes, no testing was done. I mean using Windoze is insecure
enough, why worry about X11? It's windoze where's the problem, not X11.
On
Is there anyway to setup oracle on the server side to log all fail and error
transaction in a file or something? I mean, error/fail transaction due to,
eg: Integrity Contraint violation, Check constraint, Not Null constraint, any
other error.
It would simply debugging since then we don't have
24 matches
Mail list logo