That phrase the second testing day scares me a bit.
: )
Patrice.
-Original Message-
Sent: Monday, September 08, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
what do they have you do? you set up a database where everything that can go
wrong does go wrong with no access to
how many ocms are there world wide?
From: GovindanK [EMAIL PROTECTED]
Date: 2003/09/08 Mon PM 02:49:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle Masters exam
Congrats Tanel on becoming OCM.
GovindanK
Certified DBA(8,8i,Brainbench-Master)
Too many.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, September 08, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: Oracle Masters exam
how many ocms
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: Oracle Masters exam
how many ocms are there world wide?
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost
My feeling is that, given the clumsy way external procedures are implemented, the
argument of C speed doesn't hold too well. If you must write a function which will be
called through IPCs each time you return a row, from instance, C will look javaish in
speed. Add to this that static variables
OCM is about marketing. consulting companies will use that to sell their consultants.
Ive noticed that alot of employers and co-workers are more likely to listen to someone
who is certified than someone who isnt. Its one of the reasons, Im getting mine. Makes
it easier to get people to do what
- Original Message -
Degree/OCP achievement doesn't teach f all - in my opinion - though it
does prove your memory isn't shot.
I can think of much cheaper and much more reliable and credible ways of
checking my memory... :)
lot. The reason, for example, that I personally prefer
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab
here the trace :
SELECT STATEMENT, GOAL = CHOOSE 2 72 1368
FOR UPDATE
FILTER
PARTITION RANGE SINGLE
TABLE ACCESS BY LOCAL INDEX ROWID FICOM HREL_FUSION 2 72 1368
INDEX RANGE SCAN FICOM
SQL.BSQ file that creates the data dictionary is neat. Its good for getting into
arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist
'v$ table', you open sql.bsq and its 'create or replace view v_$'
There is alot of neat stuff in sql.bsq. Notes that were placed
Bala,my reply is also the same as John said.
PC Anywhere or the console straightaway
Jp.
04-09-2003 17:34:26, Hallas, John, Tech Dev [EMAIL PROTECTED]
wrote:
PC Anywhere or direct from the console
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ??
table primedi_enr2_temp_fusion : 133
Prem Khanna J [mailto:[EMAIL PROTECTED] on Thursday, September 04, 2003
4:05 AM said;
Bala,my reply is also the same as John said.
PC Anywhere or the console straightaway
My favorite for remote console access on W2K is TightVNC -
http://www.tightvnc.com/ - or the 'ol standby, NetMeeting. We
i saw some posts on the usenets that oracle has been cancelling masters exams and not
refunding the money.
saw a couple of posts on that.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/04 Thu AM 11:19:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE:
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
more and more employers are requiring OCPs and 'related degrees' such as computer
science or a masters degree.
At least in the US they are. How are things in other parts of the world?
For an
Mercadante, Thomas F scribbled on the wall in glitter crayon:
Bill,
Did you point out to them how *freekin wrong* they had been?!?!?!?!
I would not have been able to resist the free shot.
ya never know when i'll need to find another contract, so i was very
diplomatic. but damn it was
if your on a 1099 the classes should be a business expense. dont know about the
certification. so you could write off the classes. will only save people 25-28%
though...
From: April Wells [EMAIL PROTECTED]
Date: 2003/09/04 Thu PM 12:24:35 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
well tom kyte isnt certified and refuses to discuss it on his website. OCP is
important for most people. Employers want it.
Im not sure masters certification means much unless you are a principal consultant or
owner of a consultant. You then use that certification to sell your company. Its the
Still out there on Amazon, even though I don't get any royalties from it
any more (since the publisher went under). It's also available for
online purchase chapter by chapter (I think) on http://www.robonerd.com
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
The last National Geographic talks about slavery, it's running rampant.
Jared this is getting into OT !!!
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
I don't believe that you can be an owner of a consultant. This
Noons writes
For an application DBA? Exactly which part of the degree
or OCP prepares or qualifies one for such a job
specification? Matter of fact, where is application DBA
defined in Oracle education or any other IT education
organization? Which courses from Oracle prepare one for
I don't believe that you can be an owner of a consultant. This practice
was stopped, I believe, in 1865, in the Appomatox courthouse.
Virgil Caine is my name and I drove on the Danville train
'til so much cavalry came and tore up the tracks again
In the winter of '65, we were hungry,
The Exam Cram books are harder and harder to find, but used ones are still
available. However, I believe that Pete is going to co-author my upcomming
Mastering Oracle10g book from Sybex So, if you liked his style, stay
tuned.
RF
-Original Message-
To: Multiple recipients of list
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.
GovindanK
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or,
Thanx Dennis,Robert,and Ruth.
I'm going thro' Roberts's book now.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one .
but just thought, i could some more inputs from you Gurus.
thanx a lot guys.
I will continue with the book.
Regards,
Jp.
--
more and more employers are requiring OCPs and 'related degrees' such as computer
science or a masters degree.
At least in the US they are. How are things in other parts of the world?
From: Nuno Souto [EMAIL PROTECTED]
Date: 2003/09/03 Wed AM 07:19:25 EDT
To: Multiple recipients of list
1. by 'filling' are you doing inserts also? I see a 'FOR UPDATE' statement which
implies that you are doing updates from with in a cursor.
2. How many indexes do you have on this table?
3. Is anything else running at the same time?
4. Are you doing your DML from with in a cursor. This is very
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
more and more employers are requiring OCPs and 'related degrees' such
as computer science or a masters degree. At least in the US they are.
How are things in other parts of the world?
that they are and experience doesn't seem to
im going with the flow. doing a Masters(company is paying for it) and doing
my OCP. Ill probably go cert happy over time... do java,solaris, etc... I
know for a fact not having a computer science degree hurt me. I was told it.
So if employers want something, Ill give it to them. As long as a
Bill,
Did you point out to them how *freekin wrong* they had been?!?!?!?! I would
not have been able to resist the free shot.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, September 03, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
[EMAIL
Back in India, the academic qualification is weighed more than anything
else. Guys from institutes like Indian Institute of Technology IITs
/ Indian Institue Management (IIT/IM) (to quote an example) are treated as
demi-godes and look at with awe (even if the guy doesn't know anything
about
William, I did my OCP because of the same reason. My student was given
preference by one recruiter who did OCP and my resume kept on a side because
I was not OCP. My 10 years experience in 1998 was not counted agianst 1 year
experience + OCP of my student.
Yes, this happened in USA. Now a days
Cannot be since you are allowed to have the same companynumber several times for type
2 - but you are right in refering to 'id' - in fact the design is faulty. Quite
obviously the 'type' is an attribute of the company, not of the employee. There is no
way but a trigger to check it, but it
http://www.tpc.org
Jake
Compare to what? Another database? To what its
performance should be?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 28, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Is there a
i figured it out. here
http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm=3748097f.5471527%40newshost.us.oracle.comrnum=1prev=/groups%3Fq%3Doracle%2Bcast%2Bpl%252Fsql%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
From: Charu Joshi [EMAIL PROTECTED]
Date: 2003/08/29 Fri PM 12:09:36 EDT
To:
no i need it in several placse and i dont want to run it over and over again. Im
passing it around.
From: Charu Joshi [EMAIL PROTECTED]
Date: 2003/08/29 Fri AM 11:54:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: how to do a variable in-list of numbers?
: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Stephane Faroult
Sent: Friday, August 29, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: How can I measure my DB performance
its kinda slick. i have large tables. if i use the nested table with the cast
function, I can use an index.
ill keep it in mind.
a senior dba who can train others and help developers is far more valuable to an
organization than one who cant or wont.
also pays better too.
From: [EMAIL PROTECTED]
Date: 2003/08/29 Fri PM 03:54:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: The Coming
My own theory is that either male or female don't use their brain much. In fact it's
pretty equivalent to the load of a Java-free machine. And perhaps it is just as well
as it is.
- --- Original Message --- -
From: Sinardy Xing [EMAIL PROTECTED]
To: Multiple recipients of list
atm is obsolete. cheap is relative. i didnt mean its $20/month or comparable to
getting AOL. alot of mid-large businesses have them.
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/08/28 Thu AM 03:14:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Grid
Hi!
The Linux kernel is totally different, though you will find
some code in it that is from System 4 UNIX.
And maybe even from SCO G,DR
Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi!
Mac OS X has modified mach microkernel, FreeBSD userspace, FreeBSD NetBSD
drivers and Aqua user interface.
from http://developer.apple.com/darwin
Beneath the appealing, easy-to-use interface of Mac OS X is a rock-solid
foundation that is engineered for stability, reliability, and
Hi!
If it does, and the proc if wrapped, you could also hack around by putting a
trigger on some table which gets updated/inserted/deleted few times during
the proc and put dbms_output.disable in it. I've never tried it myself, but
it could work as well...
Tanel.
- Original Message -
Hi,
eeh, sorry but your
1. post says: 'I need to display'
now, your
1. post says: 'I don't want to display'.
Would you please tell us what you really
want / need. And (as Naveen wrote: where).
Still headscratching,
Guido
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
its commonly known that years of experience is more valuable than productivity or
skill in the technical business. Who hasnt had a call from a recruiter when 9i came
out about how much 9i experience you have. They dont ask you about any of the new
features. They just want to know how long you
Apart form all the others you've already heard
about, Fujitsu and some of their subsidiaries
also have their own Unix flavour. I believe
Unisys and NCR also have their own.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I am afraid you are totally off-topic. This is not a database problem, it is a
character set problem. Check the character set you are using, there may be, among
those weird characters outside the 'usual' ranges, a tiny little 2 hanging up. Note
down the character number, say n, and store 'x' ||
Hey, all you gotta do is tell them 5 years.
Like, it makes a difference to what they
know of it?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 9:59 PM
in the technical business. Who
Store it as 'x ** 2' and everybody will
understand.
Or store it in two rows, one row is ' 2' and second
one is 'x'
SQL select ' 2' || chr(10) || 'x' SQR from
dual;
SQR2x
;)
Tanel.
I am not offtopic.
Mq question was to display the notation x superscript 2 as written down in paper.
-Original Message-
Stephane Faroult
Sent: Wednesday, August 27, 2003 6:19 PM
To: [EMAIL PROTECTED]
I am afraid you are totally off-topic. This is not a database problem, it is a
Manoj
I agree entirely with Stephane. For most of us the display is based on
the ASCII character set, which doesn't have the character you desire. If you
go beyond ASCII, then you are in the device-dependent region. For example,
if you wanted to print this on an HP laser printer, then you'd
is there a listserv for design? i know all the business rules guys post to odtug-dev2k
and des2k forums?
From: TOMPKINS, MARGARET [EMAIL PROTECTED]
Date: 2003/08/27 Wed AM 11:24:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: ERD to O-O
Paul Dorsey wrote
You may want to check out the ODTUG-RULES-L list. Maggie
Respectfully,
Maggie Tompkins - DCII Integration
Technology Services Organization - Kansas City
Defense Finance and Accounting Service
816-926-1117 (DSN 465); [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 27,
thanks. didnt know about that one.
From: TOMPKINS, MARGARET [EMAIL PROTECTED]
Date: 2003/08/27 Wed PM 02:34:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: ERD to O-O
You may want to check out the ODTUG-RULES-L list. Maggie
Respectfully,
Maggie
Remember the 'single instance' ?
- --- Original Message --- -
From: Robson, Peter [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 26 Aug 2003 01:49:27
Although I haven't got into the technical details
of 'The Grid' (and thanks
for this
how different is it to administer oracle on different flavors of unix? Im running into
some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell.
is it just little syntax differences or is there alot more to it?
From: Dwayne Cox [EMAIL PROTECTED]
Date: 2003/08/26
- Original Message -
how different is it to administer oracle on different flavors of unix? Im running
into some annoying nuassances in
syntax between solaris korn shell and hp-unix korn shell.
is it just little syntax differences or is there alot more to it?
You sure it's HP
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything upper case, now lower cass, its a LOWER
function in SQL) thats even in the oreilly korn shell book.
no solaris has to get cute and make you do:
tr [:upper:] {:lower:]
what i mean by that is
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: OT - Linux books ??
- Original Message -
how different is it to administer oracle on different flavors of unix? Im running
into some annoying nuassances in
syntax between solaris korn shell and hp-unix korn shell
Solaris simply requires you to quote your translates
tr '[A-B]' '[a-b]'
-Original Message-
Sent: Tuesday, August 26, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
what got me for about 2 hours recently was the standard:
tr [A-B] [a-b],(it just means make everything
Well, IBM has AIX, a very solid and stable version of unix which works
really
well. SCO has become very popular lately and using SCO Unix will turn you
into
the most popular guy on this list. Then there is Irix, made by SGI. HP
actually has
several unix versions Tru64, HP-UX, Tandem Unix, Ultrix,
, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OT - Linux books ??
Well, IBM has AIX, a very solid and stable version of unix
which works really
well. SCO has become very popular lately and using SCO Unix
will turn you into the most popular guy on this list
i thought linux was just unix designed to run on a PC. how different is the kernel?
From: Matthew Zito [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:24:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
And of course, there's the other
-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: Tuesday, August 26, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OT - Linux books ??
Well, IBM
Mladen Gogala scribbled on the wall in glitter crayon:
AIX phased out in favor of Linux? I believe that SCO asked for
injunction to prevent IBM
from distributing AIX, and there is a whole saga around SCO and Linux.
According to some,
Unix variants are like higlanders: there can be only one.
PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OT - Linux books ??
i thought linux was just unix designed to run on a PC. how
different is the kernel?
From: Matthew Zito
talk about unprofessional... this stuff should never go into production. which vendor
is it? ill aviod?
cant you juse set serveroutput off? to turn off the output?
From: Kevin Toepke [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:44:42 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: Tuesday, August 26, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OT - Linux books ??
AIX phased out in favor of Linux? I
Forgot the smiley!
And, to make up for that, I ran a simple test and found that 'set
serveroutput off' solves the problem.
My code:
BEGIN
dbms_output.put_line('sysdate: ' || sysdate);
END;
/
with serveroutput on started dumping data to the screen in about 5 seconds.
With serveroutput off I
looks like internally from proc its setting dbms_output.enable();
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 11:04 AM
talk about unprofessional... this stuff should never go into production.
which vendor is it?
is the
kernel?
From: Matthew Zito [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:24:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
And of course, there's the other free UNIXes - the BSDs (OpenBSD,
FreeBSD, NetBSD). Tragically, none
linux from unix?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 02:34:28 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
Different from what? It's very different from NT kernel.
--
Mladen Gogala
Oracle DBA
designed to run on a PC. how different is
the kernel?
From: Matthew Zito [EMAIL PROTECTED]
Date: 2003/08/26 Tue PM 01:24:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: OT - Linux books ??
And of course, there's the other free UNIXes - the BSDs
PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: Tuesday, August 26, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OT
Define based?
--
Mladen Gogala
Oracle DBA
-Original Message-
Tanel Poder
Sent: Tuesday, August 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
AFAIK, Apples unix is based on [Open|Free]BSD as well.
Tanel.
Note:
This message is for the named person's use only. It may
then i dont know. CBO can be finicky. Ive seen the CBO draw two totally different
plans when i have identically data in two different tablespaces. One ran in 10
minutes, one ran for 18 hours and i killed it.
what version of oracle are you on?
also try analyze index index_name validate
how different is the concept of a grid from RAC?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/08/25 Mon PM 03:39:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Grid
In my understanding, Oracle 10 won't support the real grid. Instead it'll
probably a
Don't know more than I wrote. And I even don't *know* that :)
I guess we'll find out in September.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 10:54 PM
how different is the concept of a grid from RAC?
From:
Poder [EMAIL PROTECTED]
Date: 2003/08/25 Mon PM 04:24:34 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: Grid
Don't know more than I wrote. And I even don't *know* that :)
I guess we'll find out in September.
Tanel.
- Original Message
:
Subject:Re: Re: Grid
how different is the concept of a grid from RAC?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/08/25 Mon PM 03:39:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Grid
In my understanding, Oracle 10 won't support the real grid. Instead
i head paul dorsey(from dulcian) speak last night. he was talking about a business
rules repository modeller that his company has called 'BRIM'
supposed it will generate the bulk of the code for you. anyone ever work with that?
From: John Flack [EMAIL PROTECTED]
Date: 2003/08/22 Fri AM
Mladen,
There is another thing happening: companies are
more and more relying on
canned,
off the shelf applications, in a hope to become
compliant with present
standards.
That has dramatically cut down the number of needed
developers, because if
you don't
have to develop your general ledger,
There is another problem with canned applications. The damanagement has to
make a choice to either bend the business to match the application of bend the
application to match the business. From my point of view, the latter is happening
more than the former. Also, as a side note, I
Well, I wanted to add my .2 Cents here.
Custom development projects have shrunk over the past year because companies
are tired of the maintenance issues associated with custom applications.
More organizations are shifting their efforts towards implementing canned
solutions and taking the bite, as
PROTECTED]
Date: 2003/08/20 Wed AM 11:21:59 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: Row level security and latch waits
My understanding was that the rls predicate was added
at parse time (hence the importance of the contexts
and avoiding things
PROTECTED]
Date: 2003/08/20 Wed AM 11:21:59 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: Row level security and latch waits
My understanding was that the rls predicate was added
at parse time (hence the importance of the contexts
and avoiding
- Original Message -
- Use context values within predicates, as bind variables NOTE THIS
LINE.
None of that implies it's not appending a where clause like it
was explained.
It uses the context values (if that's the case) in a function
which then returns a string. That string
My understanding was that the rls predicate was added
at parse time (hence the importance of the contexts
and avoiding things like 'sysdate')
But also if I remember correctly, this behaviour was
changed in v9 to process the security function with
each execution (and hence probably increase the
so in 9i dbms_rls increases the soft parses?
From: Connor McDonald [EMAIL PROTECTED]
Date: 2003/08/20 Wed AM 11:21:59 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: Row level security and latch waits
My understanding was that the rls predicate was added
the user would be sys. I need to create grants to DBA_ views on the fly so we can
scale an application. We add new users and some of them need access to these to run a
load process properly.
ill just run it from unix.
From: Pardee, Roy E [EMAIL PROTECTED]
Date: 2003/08/20 Wed PM 01:24:25
:
Sent by: Subject: Re: Re: Row level security
and latch waits
[EMAIL PROTECTED
Title: RE: Re: tuning question when you have a 3GL application
Cary,
is there any event top resolve political problems? or
alter system set event 'immediate dump person_causing_problem, level cause_pain'; is the only choice??
Raj
Political problems are best solved by hiring action move stars with
abominable
accents and a lot of muscle. In other words, the company should hire a
terminator
to deal with the bad guys. Hasta la vista, baby!
--
Mladen Gogala
Oracle DBA
-Original Message-
Millsap
Sent: Tuesday,
its the way the taem is organized. all communication goes through the product managers
to the client. No direct access for the technical people.
i dont make the rules. I just have to live with them. Ive been onsite with clients
before. its easier.
So Im looking for things to make my life
im fairly certain its because DBMS_RLS doesnt use bind variables now. latch waits
indicates plus your 100 concurrent users.
you can check this by going to v$sqlarea and checking for similiar sql_text
statements. if they are there, then your not using bind variables. there is a query in
tom
its just appending a where clause. its not binding it.
im not familiar with contexts. never worked with them. someone correct me if im wrong
here? Could have sworn i read that somewhere.
i looked up application contexts. they appear to be handled differently.
am i wrong?
From: [EMAIL
]
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Re
i wasny referring to application contexts. I was referring to just using a policy
based on dbms_rls.
thats different isnt it?
From: [EMAIL PROTECTED]
Date: 2003/08/19 Tue PM 03:14:28 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re: Row level security
PROTECTED]Subject: Re: Re: Row level
security and latch waits
.com
08/19/2003 01:39
PM
Please respond to
ORACLE-L
its just appending
Luis,
Sorry for the delayed reply.
we installed the same patch on all our 8i/9i instances on win2k.
we have not faced any problem so far.
Regards,
Jp.
Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
We are running 9i 9.0.1.1.1 on an Windows 2000 advanced
901 - 1000 of 2727 matches
Mail list logo