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.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upc
Thanks Justin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 00:39
> At 10:44 AM 1/1/2004, you wrote:
> >I was curious to find out why all the other sorts work the same but order
by
> >dbms_random.value ( which also retu
Joe you are absolutely right
>From the sql reference : "Where to use currval and nextval If
any of these locations contains references to both CURRVAL and NEXTVAL, then
Oracle increments the sequence and returns the same value for both CURRVAL
and
NEXTVAL."
Sorry for the rtfm question.
At 10:44 AM 1/1/2004, you wrote:
I was curious to find out why all the other sorts work the same but order by
dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves
totally different. Any ideas ?
When you order by dbms_random, Oracle will generate a random number for
each row
I was curious to find out why all the other sorts work the same but order by
dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves
totally different. Any ideas ?
Also could you please tell me what does it mean when someone says order by
. An integer constant would refer to t
Thanks a lot for your reply, Cary.
One follow-up question. What would motivate "a chat"
of sometimes 5, sometimes 10-20 'SQL*Net message
to/from client' consecutive wait lines emitted to the
trace file in the following manner:
WAIT #0: nam='SQL*Net message to client' ela= 2
p1=1413697536 p2=1 p3=
It is for the same reason that 'select empno from emp' without
and order by, also returns the same results.
Take a look at $ORACLE_HOME/sqlplus/demo/demobld.sql
Didn't you ask this same question earlier this week?
Jared
On Thu, 2004-01-01 at 01:14, [EMAIL PROTECTED] wrote:
> List can you please
Sounds like you need to read the docs on sequences, happy new year and
happy reading.
joe
[EMAIL PROTECTED] wrote:
Hello list and a happy new year to everyone, why does :
insert into test values (mysequence.nextval, mysequence.currval ) ;
have the same effect as
insert into test values (myse
Thank you for answering, Babette.
Your use of WLM is as I have it in mind. However, a year ago, or so, before
I was hired, the Infrastructure department once switched it on, and overall
performance dropped drastically. Of course they did something wrong. But,
nothing was logged/documented or wh
--
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
--
Hello list and a happy new year to everyone, why does :
insert into test values (mysequence.nextval, mysequence.currval ) ;
have the same effect as
insert into test values (mysequence.currval, mysequence.nextval ) ;
where
1. mysequence is
create sequence mysequence increment by 1 start with
List can you please explain to me why
select empno from emp
order by empno ;
is the same as
select empno from emp
order by sqrt(3.14);
but not the same as
select empno from emp
order by dbms_random.value;
What does sort by a random value do ? and why isn't dbms_random.value in
the documentat
12 matches
Mail list logo