to using
synonyms) or it is a feature of Oracle's proxy
authentication implementation
3) how to check proxy identity of the user - i.e.
how to run something like sys_context('userenv',
'proxy_user') for sessions other than my own.
Thanks,
Boris Dali.
--- Anjo Kolk [EMAIL PROTECTED] wrote
Thanks, Tanel.
I did checked v$session_connect info, but it doesn't
tell me much, except authentication_type='PROXY' which
is less than useful as it doesn't tell to whom.
v$session.client_identifier is empty.
Thanks,
Boris Dali.
Check V$SESSION_CONNECT_INFO view.
CLIENT_IDENTIFIER in V
://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
,
Boris Dali.
--- Cary Millsap [EMAIL PROTECTED] wrote:
Boris,
Cursor #0 seems reserved for two special uses: (1)
wait events
associated with COMMIT processing (also, of course,
ROLLBACK and
SAVEPOINT), and (2) wait events associated with
dbcalls not instrumented
because of bug 2425312
How about
select * from (select tab1.*, count(a) over(partition
by a) a_count from tab1) where a_count =1;
... would probably save you one pass over tab1.
Thanks,
Boris Dali.
--- elain he [EMAIL PROTECTED] wrote: Hi,
Does anyone have a better way of rewriting the
following query? I'm
if session gets switched, wouldn't this terminate
sql trace for the session (in my case it doesn't)?
Thanks,
Boris Dali.
--- Anjo Kolk [EMAIL PROTECTED] wrote:
Cursor 0 also happens in oracle due to session
switching (multiple
sessions in the same process), oracle apps uses
that
but it also could
happen with certain other application servers
(haven't investigated it).
Anjo.
-Original Message-
Boris Dali
Sent: Monday, January 05, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
Thanks, Cary.
Could you elaborate what do you mean by wait
have to commit or
rollback on every
switch that you perform. SQL trace is inherited by
the process it you
set in a session, so other sessions that run in the
same process will
produce also trace output.
Anjo.
-Original Message-
Boris Dali
Sent: Monday, January 05, 2004 7:34 PM
free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-case where I get
cursor #0 emitted for me and yet tracing real
applications I see it all over (like in the excerpt
above)
I guess I have more than one follow-up question :-(
Thanks,
Boris Dali.
--- Cary Millsap [EMAIL PROTECTED] wrote:
WAIT #31: nam='SQL*Net message to client' ela= 1
p1
)
stuff can be trusted to.
Am I missing something obvious?
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET
(and possibly + 2295 ???) be
less than 261?
Oracle 9.2.0.4.0 on HP-UX 11.11
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
Version?
select case when substr(banner, instr(banner,
'Release')+length('Release')+1, 1) 9 then
'tough luck. sql and pl/sql parsers are different'
else 'check the syntax' end
from v$version where banner like 'Oracle%';
Thanks,
Boris Dali.
--- Pillai, Rajesh [EMAIL PROTECTED]
wrote
mismatch
Thanks,
Boris Dali.
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
I recall James Morle saying something about
code not being sharable if the declared sizes
of the bind variables don't match. If Informatica
is using a 3GL to call anonymous pl/sql blocks
with different bind variables every
-32
33-128
129-2000
2001-4000
I wonder if this behavior can be changed by some init
settings?
Thanks,
Boris Dali.
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
Notes in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer
-- implicit rollback
right after commit due to OCITransRollback() call
Thanks,
Boris Dali.
--- [EMAIL PROTECTED] wrote: doesnt this force
you to commit after every single
DML statement?
From: Mercadante, Thomas F
[EMAIL PROTECTED]
Date: 2003/12/15 Mon AM 08:36:09 EST
to, as I
didn't really understand it.
Thanks,
Boris Dali.
--- Cary Millsap [EMAIL PROTECTED] wrote:
Boris,
I think I covered this in my response to Ryan. It
was the two stages
part.
Note that you can avoid even using queueing theory
at all if you just
make sure that utilization stays
,
Boris Dali.
--- Cary Millsap [EMAIL PROTECTED] wrote:
Boris,
If you mean that some people on your system execute
Bus.Tx1, some others
execute Bus.Tx2, and some others (maybe with some
overlap) execute
Bus.Tx3, then my answer to your question is:
No, I would strongly encourage
measured Sum( LIOs(...)) for a 50 users in
a unit testing environment and I am told that
production would be 10 times more than that, what do I
do?
Thanks,
Boris Dali.
--- Cary Millsap [EMAIL PROTECTED] wrote:
My answers are in-line, preceded with [Cary
Millsap]...
Cary Millsap
Hotsos
(r)=97%
Bus.Tx2 - CPU time=8s CDF(r)=95%
Bus.Tx3 - CPU time=10s CDF(r)=90%
How can I combine these three together and make any
conclusions as to what the overall CDF(r) would be for
the whole system consisting of the above 3 business
transactions? Is this doable?
Thanks,
Boris Dali
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
is used for what?
Guess I can turn timed_statistics off and see how it
affects the (amount of) sys calls issued
Thanks,
Boris Dali.
--- Niall Litchfield
[EMAIL PROTECTED] wrote: me reads
Jonathan's description and blushes/me
So it'll be a *feature* and not a bug then. IIRC e
comes from POSIX
,dep=1,og=4,tim=1777314524922
Oracle 9.2.0.4.0 on HP-UX 11.11
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET
Thanks a lot, Cary.
Indeed the indented notation seems rather convenient.
I would be delighted to take your PD101 course, just
not sure if people here dealing with the training
budget would share the delight with me :-(
Doesn't hurt to ask though...
Thanks again,
Boris Dali
. I've just experimented with it a bit
now, but to no avail - just setting it alone and/or
combined with 10046 doesn't seem to make much
difference.
Thanks,
Boris Dali.
--- Jeroen van Sluisdam
[EMAIL PROTECTED] wrote: We could
narrow it down to the value of the sequence
exceeding
16777216 (2
Thanks, Raj.
So yes, as I said in my other email - the rule stated
in the book seem to apply to EXEC db calls only (in
case of SQL fired from PL/SQL). I guess I
misinterpreted it the way that it applies to ALL db
calls for recursive cursors.
Thanks,
Boris Dali.
--- Jamadagni, Rajendra
[EMAIL
that uses OCI session pooling (as opposed to
connection pooling I suppose? - just reading chapter 9
of the OCI manual) doesn't scale well with respect to
the number of concurrent users?
Thanks,
Boris Dali.
--- Jared Still [EMAIL PROTECTED] wrote: Using a
slightly modified version of run_stats
well with me that 30 selects are as cheap
as 30 selects with 30 rollbacks.
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris
attempt an
explanation inline.
Daniel Fink
Boris Dali wrote:
Reading Cary's Optimizing Oracle Performance,
page
91 it says:
A database call with dep=n+1 is the recursive
child
of the first SUBSEQUENT (empasis mine) dep=n
database
call listed in the SQL trace data stream
Does
this mean that
this app rollbacks (implicitly?) after each of those
selects?
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
=1413697536 p2=1 p3=0
=
... Totaly different calls
=
So here it looks like the child CURSOR #2 with dep=1
is emitted AFTER the parent (CURSOR #1, dep=0)
Thanks,
Boris Dali.
__
Post your free ad
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Boris Dali
Sent: Friday, October 10, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Barbara,
Shoot in the dark. Any chance last vendor upgrade
introduced global temporary tables
dbms_stats
for...
The last remark certainly applies to me. With all due
respect to Tom, I got only more confused ater reading
the above. Can somebody enlighten me?
TIA,
Boris Dali.
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote: Our production
and test systems are same ... test
lags 24 hours
dbms_stats
for...
The last remark certainly applies to me. With all due
respect to Tom, I got only more confused ater reading
the above. Can somebody enlighten me?
TIA,
Boris Dali.
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote: Our production
and test systems are same ... test
lags 24 hours
,
pga_aggreagate_target is a 100M)
Thanks for any help,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED
the underscore parameter
_like_with_bind_as_equality to get the index
costing.
KG
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
Aha, just come accross note 94051.1 explaining
_LIKE_WITH_BIND_AS_EQUALITY... but it's probably not
relevant in my case as my query doesn't make use of
bind variables. And yes I tried it (at the session
level) just for kicks with no effect on the execution
plan
Thanks anyway,
Boris Dali
.
Cheers,
Boris Dali.
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Boris,
Nice to discuss this with someone who understands
the numerous (and various)
options of 'sar' :) I use 'sar -r' to cross verify
the 'rate of need for
swap' - a sudden increase may mean either bursts of
I/O (eating up
for the sake of tuning (and than I agree -
system wide data shouldn't probably drive the tuning
effort). But there's also other types of monitoring
where StatsPack seems to be quite useful to me. It all
depends on the objectives.
Cheers,
Boris Dali.
--- Mogens_Nørgaard [EMAIL PROTECTED] wrote
(2.4.19-16mdkenterprise)
2.4GHz uniprocessor P4 box, 1GB SDRAM
TIA,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET
stats in 9i statspack)
Thanks again,
Boris Dali.
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Boris - I'm not surprised in your results. I
wouldn't describe STATSPACK as
brutal, but it is a significant hit, so you
wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does
about c in the
raw traces?
Thanks John,
Boris Dali.
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Boris,
The default statspack snapshot is at level 5, which
collects Top SQL (by
buffer and Phys reads, etc.) from the Shared pool,
and that would cause
significant latching for a large shared
://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
is that both
vmstat and sar -u agree here on Mandrake that it is
the kernel-mode that chews up most of the CPU for this
3-4 sec snapshot time.
Thanks,
Boris Dali.
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Boris,
I missed the second part of your question...
apologies. If your SGA/Shared
pool
. 181508.1 Choosing the DB char set
8. 137127.1 Char set, Code Pages, Fonts and the
NLS_LANG value
9. 158577.1 NLS_LANG explained (how does client-server
char converison works?)
10.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2.htm#100796
Thanks,
Boris Dali.
--- Boris
the
board (as we have now) for all DBs on Unix and MS AND
2. avoid (automatic, but not free) conversion on
DB-Client Net communication AND
3. we need euro symbol
is there a painless solution out there?
Thanks,
Boris Dali
: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send
truncated ===
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
===
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
design for RAC?
TIA
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail
it tell me?
--- Ray Stell [EMAIL PROTECTED] wrote: On Tue,
Nov 12, 2002 at 10:53:37AM -0800, Boris Dali
wrote:
Hope not everybody is off to OOW :(
Did anybody get the above combo working? I know
that
I have installed Oracle 9.2.0.1 on Mandrake 9 twice
on marginal machines
58 matches
Mail list logo