Hi Raj,
I never heard such time
Date can handle
century + year + month + day + hour + minute + second
but not milliseconds
Sinardy
-Original Message-
Sent: Tuesday, 8 May 2001 1:14 PM
To: LazyDBA mailing list
can anyone help me with date + time in milliseconds.
i want to inpurt the
Hi,
I get this error if I give a (standalone) function in a where clause:
ORA-06573: Function WSNADDR modifies package state, cannot be used here
What exactly does it mean and how can I workaround it ? The statement I
tried to issue looks like this:
select
You can store the whole thing as a string in one column or store as two
columns: date + milliseconds.
The Oracle DATE type does not support time granularity below one second.
We have used both methods here - just depends on how you want to use the
data later.
Ron Morton
Database Architect /
If you get milliseconds in the data and want to keep it, you have to store it in
a field different than date, If you don't need to keep the milliseconds, you can
use different functions to convert the data.
If you need to get the time in milliseconds, you can write a Java stored
procedure. You
one that will be out in a few weeks... Oracle Performance Tuning 101 by Gaja
Krishna Vaidyanatha, a member of this list. (Oracle Press)
No, I do not get anything for promoting this book -- except perhaps a hug
from Gaja the next time I see him (but I'd get that anyway)
I was privileged to do
a little? I could have sworn that the members of this list were, at least
nominally, adults.
We are getting down to did too, did not, your mama wears Army boots.
give it a rest folks
From: John Lewis [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Seema,
I just got back from a seminar presented by Richard Niemiec of TUSC corp.
His seminar was super and very informative. I would recommend his book on tuning. It
can be located at www.tusc.com and is on sale this week.
ROR mª¿ªm
[EMAIL PROTECTED] 05/07/01 06:11PM
Hi
Which book is good
Thanks, this is good news.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
Subject:
Bill,
Yes it is. Trust Me ;)
- Kirti Deshpande
-Original Message-
From: Thater, William [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle tuning book
On Tue, 8 May 2001,Rachel Carmichael scribbled
On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-one that will be out in a few weeks... Oracle Performance Tuning 101 by Gaja
-Krishna Vaidyanatha, a member of this list. (Oracle Press)
If the book is written like he presents, I'm ordering my copy now. [Now if I
On Tue, 8 May 2001,Deshpande, Kirti scribbled on the wall in glitter crayon:
-Bill,
-
-Yes it is. Trust Me ;)
-
-- Kirti Deshpande
OK. I done already ordered it.;-)
Hi my name is Bill and I'm a Compulsive Tuner.;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.
Eric,
Fess up.
Are you into Hermeticism now? Alchemy on the side?
Do you have ancestors in the Netherlands or the Black Forest?
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
it is :)
From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle tuning book
Date: Tue, 08 May 2001 06:25:49 -0800
On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter
crayon:
-one
I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ...
could you provide the ID number and/or a working
method to find the .1.1 patch for NT?
The Oracle DBA wrote:
I guess you are not on NT because the .1.1 patch is there. The std procedure for 817
is to
Do what the action says...add the pragma. Consult your fine manual (or at least it's
electronic equivalent on CD) for more details.
[EMAIL PROTECTED] 05/08/01 10:25AM
Tim Sawmiller schrieb:
oerr ora 6573
06573, 0, Function %s modifies package state, cannot be used here
// *Cause:
Kirti,
Is that your name on the book with Gaja?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have
Back a few years ago I remember being able to crash a NetWare server (4.x I
think) running an early version of Oracle7 just by running some
syntactically incorrect SQL. Yup, that not only crashed the database, but
also the server.
Henry
-Original Message-
Sent: Tuesday, May 08, 2001
Are you an idiot?
;-
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 07, 2001 9:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
|| HELP
||
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
OK Rachel, based on your recommendation alone I am going after management
to get that book so my other half has an idea what I am talking about when I
ask him to do something. I just love training new DBA's.
-Original Message-
Sent: Tuesday, May 08, 2001 6:26 AM
To: Multiple recipients
The instructions at the bottom of each message leave some ambiguity as to
where to send the h*lp message, i.e., the address is explicitly stated for
s*b/uns*b commands but not for h*lp. (had to * some vowels as L-guru
bounces the message otherwise). People new or not familiar with the list
can
Tim,
small update, one can't specify pragma for standalone functions ... it is
determined automatically by Oracle at-least till 8x, I am not sure about 8i.
Pragma can only be specified for functions in a package.
I believe the problem is with DBMS_OUTPUT, if you take it out, the function
will
On Tue, 8 May 2001,Jamadagni, Rajendra scribbled on the wall in glitter crayon:
-Kirti,
-
-Is that your name on the book with Gaja?
I do believe so.;-) And the other autograph I'll need to get.;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
Jared,
The only difference is about a weeks worth of extra data. Well, the hardware
is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But
regardless, shouldn't init.ora optimizer_mode=choose be identical to
optimizer_mode=rule with hint=choose? If I have the time, I'll try to set up
a
I beleave Kirty Despande is also one of coauthors.
Alex Hillman
-Original Message-
Sent: Tuesday, May 08, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
it is :)
From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Barbie doesn't talk when he takes her
clothes off.
|| -Original Message-
|| From: David A. Barbour [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 07, 2001 10:35 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Taking your time when a crisis occurs
||
||
|| Eric,
||
||
Hello Chris,
You also can store that name as lowercase like 'scott' and always use where ..
person.name like lower( v_name ) || '%' ..
When you need to display it, use something like initcap( person.name ).
Actually, it depends on whether you need the store exact case entered by user nor
I finally found it -
ID:611940 Patchset::1711240
it's not returned in the initial patch download query page - you need to go
to the new click here page to get the patch returned.
-Original Message-
Sent: Tuesday, May 08, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
I must
Jared,
:) Thanks
But, how long do you think it took to write this?
Seriously...
Ross
|| -Original Message-
|| From: Jared Still [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 07, 2001 9:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: sorry,
||
||
||
||
www.grc.com got nailed:
~ WE WERE UNDER ATTACK ~
At approximately 8:00 PM Pacific Time, a concerted Distributed
Denial of Service (DDoS) attack was initiated against us. The attack
was trivial to block once we made contact with our ISP but that
took 17 hours! I am preparing a
Why does it have to be an either/or choice? Lets do 'em all!!! ;-)
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 4:52 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: sorry,
(way more than you wanted to know:)
On 8 May 2001, at 7:06, Boivin, Patrice J wrote:
Date sent: Tue, 08 May 2001 07:06:09 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Are you into Hermeticism now?
I don't think so, I had some brown
Yeah what the heck!!!
-Original Message-
Sent: Tuesday, May 08, 2001 12:23 PM
To: Multiple recipients of list ORACLE-L
Are you an idiot?
;-
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 07, 2001 9:11 PM
|| To: Multiple
,, grind, clank, rumble, zz
if it's tuesday, i must be in shaqramento
***REPOST***
http://www.apa.org/journals/psp/psp7761121.html
Selected Article © 1999
by the American Psychological Association
For personal use only--not for distribution
December 1999 Vol.
I have been informed privately that some may find this remark offensive,
perhaps even deeply so.
For those people: Sorry!, that wasn't my intent.
|| -Original Message-
|| From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 12:23 PM
|| To: Multiple recipients of
What specific events should I look for in these tables ! - atleast the imp
ones -
And What's a block split ?
vikas
-Original Message-
Sent: Tuesday, May 08, 2001 6:32 AM
To: Multiple recipients of list ORACLE-L
instead of checking hit ratios, try looking at wait events in
Are you an idiot?
;-)
|| -Original Message-
|| From: [EMAIL PROTECTED]
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 12:23 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
|| Why does it have to be an either/or choice? Lets do 'em all!!!
I'd be scared except I KNOW it's good :)
From: Kimberly Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle tuning book
Date: Tue, 08 May 2001 07:40:52 -0800
OK Rachel, based on your recommendation alone I am going
Joe,
Look in the Oracle Networking manual for info on Connection Manager.
Dick Goulet
Reply Separator
Author: Leyden; Joseph [EMAIL PROTECTED]
Date: 5/8/2001 9:25 AM
In UNIX,
Knowing the IP address can I restrict any login
to the ORACLE db
Henry,
I've run into the same problem in the past.
Export a database to a different machine with a significantly
different configuration, and you will get different execution paths.
I was never successfull in getting the correct excution plans
via database parameters. The solution was to use
On Tue, 8 May 2001,[EMAIL PROTECTED] scribbled on the wall in...:
-Why does it have to be an either/or choice? Lets do 'em all!!! ;-)
A la the 82nd Airborne?;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
I just received this from a iTar. It is for Win NT.
Go to Metalink. On the left side, choose Patches. Under Patch Download,
click:
== NEW! Click here for ALL Product Patches
On the Patch Download screen, choose: Oracle Server for Product Family
8.1.7.1 for Product Release
MS Windows NT for
yep...locked downdo you have a copy?
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 12:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Hey, looks like MS got .NET to work!!
||
||
|| www.grc.com got nailed:
the way Ross's mind functions probably about 3 minutes and 14 seconds.
-Original Message-
Sent: Tuesday, May 08, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L
Jared,
:) Thanks
But, how long do you think it took to write this?
Seriously...
Ross
|| -Original
Hello,
I'm using OCI in my application to connect to the Oracle server (currently
using orlon call, have not yet moved on to OCILogon). My question is this:
when the password is sent by the OCI code from the client to the server, is
the password encrypted? I want to find out if my application
or succintly stated, 'ignorant of their own ignorance'
Been there, not a pretty picture. Sometimes I wish my
memory had the lifespan of TEAC tapes. ;)
Jared
On Tuesday 08 May 2001 10:01, Eric D. Pierce wrote:
,, grind, clank, rumble, zz
if it's tuesday, i must be in
Wow, Eric, you're a walking violation to GIGO.
Thanks.
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 1:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
||
|| ,, grind, clank,
knowing you, you just tossed it off in under 15 minutes :)
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sorry,
Date: Tue, 08 May 2001 08:15:29 -0800
Jared,
:) Thanks
But, how long do you think it
knowing you, you just tossed it off in under 15 minutes :)
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sorry,
Date: Tue, 08 May 2001 08:15:29 -0800
Jared,
:) Thanks
But, how long do you think it
yup -- Kirti wrote it with Gaja and did a heck of a job too!
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle tuning book
Date: Tue, 08 May 2001 07:46:29 -0800
Kirti,
Is that your name on
Forgive my ignorance but I thought hints were only for cost based optimizer.
Have you checked in case anybody has changed any parameters while the system
is running as I know that changing the hash_area_size can change the
execution plan?. Are you using parallelism as if a table had to be
Title: RE: restrict login with known IP address
use the
tcp.invited_nodes
paramter in a protocol.ora file (.protocol.ora if you
are on 8.1.6 due)
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.
Yes it is..
That's my official full first name..
Hope Mogens doesn't get any ideas ;)
- Kirti
-Original Message-
From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle tuning book
Yes, it is possible thorugh protocol.ora. Practically, you must configure the
excluded IP addresses using excluded nodes option.
Regards,
Pierre
-Original Message-
From: LeydenJ [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 7:26 PM
To: ORACLE-L
Cc: LeydenJ
Subject:
Hi Joe,
What version of Oracle do you use?
In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of
the current session using the following sikvel:
select sys_context('USERENV', 'IP_ADDRESS') from dual;
I haven't tryed this policy yet but I believe it
Christophe,
I'm not sure why you are trying to use CAST and MULTICAST
as these are for use with object oriented features of Oracle.
Below is an example of Top N queries. The 8i version is somewhat
simpler, as an 'ORDER BY' is allowed in the subquery.
This example also has one less level of
Hello, Joseph
Try something like this
CREATE OR REPLACE TRIGGER IP_CATCH AFTER LOGON ON DATABASE
BEGIN
if ora_client_ip_address = '172.16.0.175' then
raise_application_error(-20001, 'No way from '||ora_client_ip_address);
end if;
END;
/
HTH
Vadim Gorbounov
Oracle DBA
-Original
Pi?
You are too kind by approximately one minute and 46 seconds.
|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 1:39 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
|| the way Ross's mind functions
Being a relatively new and often times struggling Oracle DBA I was wondering
what 3 or 4 books everyone recommends as a must have reference/knowledge
base in day to day support/programming of their databases.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Keith Myers
Now I think that it was a very insencitive sexist remark? :-)
Alex Hillman
-Original Message-
Sent: Tuesday, May 08, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
I have been informed privately that some may find this remark offensive,
perhaps even deeply so.
For those
A query that has run for a long time has suddenly started hanging. The query
joins 3 tables - 2 of them across a link. The query runs on an RDBMS 8.0.5 NT.
The tables across the link are on AIX RDBMS 7.3.2.3. All indexes are VALID.
When I connect to the NT and run the query by hand it also
Hi All,
I'm experimenting with oracle 817 on a w2k box. It was
running fine, but this morning it refused to start.
When I tried to log onto the oracle server, I got the
following error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
I searched the web for a
totally random madness!
http://images.amazon.com/images/P/B4T8RM.01.LZZZ.jpg
http://www.amazon.com/exec/obidos/ASIN/B4T8RM
---
Ken as Scarecrow from the Wizard of Oz
From Toysrus.com Amazon.com
Editorial Review
Ken is ready to follow Dorothy down the
Yeah, but its good for color and the occasional comic relief. After all,
dba'ing is pretty high pressure at times...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 1:06 PM
To: Multiple
I'm using 8.0.5
am I hopeless?
-Original Message-
Sent: Tuesday, May 08, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Hi Joe,
What version of Oracle do you use?
In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of
the current
Of course, knowing you, I have to wonder what
conversations you didn't share with us... then again,
maybe I don't wanna know after all ;)
--- Mohan, Ross [EMAIL PROTECTED] wrote:
Jared guessed it exactly at 5 minutes.
It works like this...I see myself in a room with
all the relevant folks
Jared guessed it exactly at 5 minutes.
It works like this...I see myself in a room with
all the relevant folks from the list. It is saturday.
all pagers are elsewhere. we have drinks in hand, be
they hard or soft, and we are talking.
Then, I just type out the conversation.
So, if you read
I am looking for opions on their tool. I am installing and setting it up
right now. Is anyone out there using it and do you like it? Can you
compare it to OEM (which I actually hate).
Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503)
On Tue, 8 May 2001,Keith Myers scribbled on the wall in glitter crayon:
-Being a relatively new and often times struggling Oracle DBA I was wondering
-what 3 or 4 books everyone recommends as a must have reference/knowledge
-base in day to day support/programming of their databases.
-
-
One I
Nah, he'd mess with your last name, not first :)
Okay folks, to clue those who weren't there in, at IOUG, at a presentation
by Mogens Norgaard (an Oracle God as far as I am concerned), he played games
with the spelling of Gaja's last name as well as Craig Shallahamer's... in
fun, but boy did
nope.
There is a Greg Johnson @
http://www.cclabs.missouri.edu/people/staff.shtml
but, can't get to his home page either.
(however: http://iatservices.missouri.edu/communicator/security.html
,
http://www.cclabs.missouri.edu/things/instruction/perl/prelude/
,
It kinda depends on your environment, but I like:
Oracle8i DBA Handbook
Oracle Press
Oracle8i Backup and Recovery
Oracle Press
Oracle 24x7 Tips and Techniques
Oracle Press
Oracle Networking 101
Oracle Press
Oracle Documentation
http://otn.oracle.com
This covers much of the core Oracle DBA
LOL
Hi, Anita! And yes, you don't want
to knowbut let's get into a room
and talk about it over drinks.
Take care.
- Ross
prophylactic apology
(Warning: The above remarks contains nothing bad,
evil, salacious, mean, malacious, sexual, misogynistic
or politically incorrect. It
Hi Vikas,
In simple words, a block split happens when an INSERT needs to add an entry
into a leaf block and finds it full, requiring it to 'split' and balance
itself by migrating half the index entries into the new block (at's why it's
called a B Tree or 'Balanced' tree). More details in the
Hi Everybody
I need advise for one of mine problem. I am trying to
access database from ODBC test in Windows to Server on
UNIX and when doing
select sysdate from dual;
then are getting let say 12:00pm
and when trying to run the same query on the server by
telnet to server, it is working
--- Forwarded message follows ---
(also see 136214.1 ?
startup and shutdown related registry entry's
for 8i on windows NT - 2000
)
Microsoft Servers and Utilities Technical Forum
Displayed below are the messages of the selected thread.
Thread Status: Closed
...
Hello,
I use BLAT which can be found on page 2 of Command Line Mail Tools
at http://www.freedownloadscenter.com/Email_Tools/.
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Rao,
We are using it here with mixed results. One of our biggest issues is the fact that
it will go down without notice and therefore not notify us of pending problems.
Another problem is that we have a very specific on-call schedule that varies by time
of day and from week to week. We have not
Hi all,
I got a table, when I do desc, delete, it works, but
when I do truncate, I got error table or view does
not exist. Any idea?
SQL desc associate -- can see the table
SQL select count(*) from associate; -- works
1
SQL truncate table associate; -- got error below
truncate
As Rachel already said, don't bother with hit ratios.
They are in fact nearly useless for any kind of tuning.
For a good ( but verbose ) paper on the subject, goto
www.hotsos.com
Jared
On Monday 07 May 2001 17:55, Vikas Kawatra wrote:
Anyone have ideas on why OLTP database inserts would
Let's do the ez one first.
On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote:
When I do a describe across the link I get ORA-12663-Services required by
the client not available on the server.
This is a bug, don't worry about it. The only fix is to upgrade your
database from 7.3 to
My guess would be that you are actually looking at a synonym (or view)
called associate.
The table name that the synonym (or view) is referencing is probably
not called associate, hence the non-existence error when trying to truncate
the table called associate. Run the following query to verify
Actually there is a similar bug in 8.1.7. Basically, don't describe
across db links.
-Original Message-
Sent: Tuesday, May 08, 2001 6:41 PM
To: Multiple recipients of list ORACLE-L
Let's do the ez one first.
On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote:
When I do a
Actually thinking about it, I should have said ...
"The table name that the synonym (or view) is referencing is probably
not called associate or is not in your current schema, hence
the non-existence error..."
Glen Mitchell wrote:
My guess would be that you are actually looking at
a synonym (or
yes I can see him in that tent I have come to save your database with the
new world from on high -- tune with wait events (Gaja, you know I love you,
right?)
Mogens is pretty darned smart, I lump him in with the Gaja/Cary
Millsap/Craig Shallahamer crowd... people who can teach me much and who
Out Look Rule wizard testing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
On Tuesday 08 May 2001 15:02, Kimberly Smith wrote:
Jared, are you saying that because we know what we are doing
we go off topic more?
Well, yeah, in a round about kind of way.
I'm not sure at the moment how to put it without
offending some folks.
Lemme think about it; I'll get back to it
Total Newbie
I need to create an autonumber field in an Oracle Table (from a SQL server table
identity field) , I was looking for a default value that I could assign (select
max(ID) + 1) or some way to create an identity field
or use a trigger after insert but nothing seems to work for me. Any
If the system is Rule based and you code Hints, the CBO will be
automatically invoked
Sam
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 10:12 PM
Forgive my ignorance but I thought hints were only for cost based
optimizer.
Sam,
Thanks for the answer. I am having no trouble invoking the CBO. What is
confusing me is its apparent(?) inconsistency. If I EXPLAIN a query with the
instance using 'CHOOSE' in init.ora I get a different plan than if I EXPLAIN
the same query on the same database on the same hardware with the
Just to throw in my 2 cents (and you owe me a penny back), some good
references that I have read include:
Practical Oracle8i - Jonathan Lewis
Great look at the features of Oracle 8i from high up: not an
incredibly technical book but a refreshing read
Oracle Performance
90 matches
Mail list logo