Agree. We are talking the same things :)
Alexandre
Alexander,
OK, we're splitting hairs here. :)
Of course ROWID's are stored in indexes, the database
has to be able to locate the rows. They are an internal mechanism
and not part of the user data.
And yes they can be used, and safely
You have to use listener merely to establish (!) a connection. However, it
can be configured on other port. Note, that listener redirects (in general)
your connection to another port (to server process or to dispatcher), so
client uses another port to communicate with server.
Alexandre
-
As well as endorsing Bruce's post, on a great many
systems, the main cause of this style of contention is
poor sql, where 'poor' means massive buffer gets due
to either coding or executions. Take a look in v$sql
and see if there are any obvious candidates.
hth
connor
--- Robertson Lee -
Thanks to all (again !!)
-Original Message-
Sent: 17 May 2002 10:08
To: Multiple recipients of list ORACLE-L
As well as endorsing Bruce's post, on a great many
systems, the main cause of this style of contention is
poor sql, where 'poor' means massive buffer gets due
to either coding
http://www.intelligententerprise.com/020509/508feat1_1.shtml
an interview with Stephen Brobst (NCR), Don Haderle (IBM), Ken Jacobs
(Oracle) and Jeffrey Ullman (Stanford University)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marin Dimitrov
INET: [EMAIL
Qs 1 What is the MAXimum I-O size on IBM AIX 4.3.3 5.L ? Is it Tunable ?
Qs 2 Similarly What is the MAXimum I-O Size on Solaris 8 ?
Is it Tunable by Setting maxphys , if so to What max Value ?
NOTE - Checkign this to Compute Suitable RAID Stripe Width
--
Please see the official ORACLE-L
I failed to mention this is an 8.1.7.3 database. Sorry about that.
Nancy
-Original Message-
McCormick
Sent: Thursday, May 16, 2002 7:53 PM
To: Multiple recipients of list ORACLE-L
Hello,
I am hoping someone can help me with an elusive wait event called 'PX Deq:
Execution Msg'. As
I have heard of this occuring in the past on an IBM
port, but do not recall the exact details. I think it
had something to do with adding a link to a datafile
belonging to another datbase, and that datbase was
down at the time. It definitely resulted in a corrupt
datbase (ugly recovery).
DIR=directory where the files live
ls $DIR |
while read FILE
do
sqlldr ... file=$DIR/$FILE ...
done
--- Ravindra [EMAIL PROTECTED] wrote:
We have a process that generates log file
continously with dateandtime stamp on the filename
like log_041502_113545.log
These log files should be
Or if you want the loaded data to be recoverable :)
Also, you will find some nasty side affects when using
direct sql load (indexes are invalidated at the end
for rebuild). Of course you can use the
skip_unusable_indexes parameter to get around
concurrent query errors (this feature has been
this should fix yr problem.
EITHER you downgrade binutils
rpm -Uvh --force --nodeps binutils-2.10.0.18-1.i386.rpm
(in case you don't have it from rh70 get it from ftp.redhat.com)
and try to relink
OR
# vi $ORACLE_HOME/bin/genclntsh
search for the line:
LD_SELF_CONTAINED=-z defs
if your real question is can I circumvent the
listener, the answer is no.
Keith
Date: Thu, 16 May 2002 19:33:46 -0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Reply-to: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego,
California
Is it possible to
Nancy:
From your message the average wait time is less than 1 micro second (if I my
undertstanding is correct) and I would not worry much about that if that is
the case.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
ever wonder why SQLPlus is so damn robost? It can do
just about anything... in a messy and time consuming
way sometimes, but it is rock solid.
About 15 years ago, Sqlplus WAS Oracle. Nothing
else. Hard to imagine. An Oracle engine with nothing
inside (just tables and indexes):
no procedures,
Have you been on the sauce ???
-Original Message-
Sent: 17 May 2002 15:54
To: Multiple recipients of list ORACLE-L
ever wonder why SQLPlus is so damn robost? It can do
just about anything... in a messy and time consuming
way sometimes, but it is rock solid.
About 15 years ago,
You can connect directly to a dispatcher you have started on a
different port. No listener required.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 17 May 2002, Keith Peterson wrote:
if your real question is can I circumvent the
listener, the answer is no.
Keith
Date:
Thanks, Winnie! It works.
I have a further quetion. If the archivelogs from time when the file was
created to current were lost, do we still have someway to bring the file
online?
Tom
-Original Message-
Sent: Wednesday, May 15, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Yes, I can.
4 years ago I was porting our product to MS SQL 6.5 platform.
JP
On Fri 17. May 2002 16:53, you wrote:
ever wonder why SQLPlus is so damn robost? It can do
just about anything... in a messy and time consuming
way sometimes, but it is rock solid.
About 15 years ago, Sqlplus
OK Keith, do you remember what the prompt was that SQL*Plus came up with back
them what it stood for??
Dick Goulet
Reply Separator
Author: Jan Pruner [EMAIL PROTECTED]
Date: 5/17/2002 8:03 AM
Yes, I can.
4 years ago I was porting our product to
On Thu, May 16, 2002 at 08:58:18PM -0800, CP wrote:
The install of Oracle9i on Redhat 7.2 went well but had problems
--
RH 7.2 isn't supported by Oracle, in case it matters. The RH
monkies ticked Larry off.
===
Ray Stell [EMAIL
When we switch between production and standby databases our procedure is to
change the DNS Name to point to the new ip address.
This works perfectly for all our old Powerbuilder client/server apps.
However, our connections that go through Microsoft Transaction Server as a
middle tier apparently
Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a
red light across a 4 lane highway??
Good to see you again.
-Original Message-
Sent: Friday, May 17, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Tom,
If you lost an archivelog from the time this
Tom,
If you lost an archivelog from the time this datafile was created to present
time. There is no way to simply offline that file and recover that file. It will
become a classic case of performing incomplete recovery then.
Glad that it works out for you! :D
WInnie
--
\ /
I remember that Oracle reportedly paid DEC 100 million for the product
mainly for the technology a lot of which has subsequently appeared in Oracle
RDBMS. To add to the list... log miner I believe has it's roots in Oracle
RDB, also locally managed tablespaces. Oracle RDB has managed space in a
Weird question chaps
BUT
Anyone out there
using this product and if so, is there a way of finding out if the product is
licenced on your system.
FYI we are on
Tru64.
TIA
Lee
The information contained in this communication is
confidential, is intended only for the use of the
Title: oracle 8.0.5.1 on hpux 11.11
Has anyone got this combination working?
I'm aware of the fact that it is not certified
or supported, but 7.3.4.4 is working on 11.11,
and at least temporarily, I need 8.0.5.1 too.
But I get a ora-3113 (and a ORA-7445 [10] in the
trace file) every time I
Hey list,
It's been awhile since I've used MTS, and some questions have come
up regarding it.
The question revolves around sniped sessions, and the need to
remove these things automatically in some systems, since they
consume resources. Such as a DW where sessions may not
be created very
You mean that 40% A/V - 80%proof was not ketchup...?
and the most complex question for the group in those
days would have been:
I am new to Oracle and I have this problem
SQL desc emp
NameNull?Type
---
EMPLOYEE_ID
ufi, user friendly interface. Boy I feel old now
[EMAIL PROTECTED] wrote:
OK Keith, do you remember what the prompt was that SQL*Plus came up with back
them what it stood for??
Dick Goulet
Reply Separator
Author: Jan Pruner [EMAIL PROTECTED]
Date:
I believe, fifteen years ago, it had already changed to SQL. I'm also pretty sure
that iag/iap had also already been introduced. OCI was definitely there and probably
the Oracle pre-compilers for 3GL's as well.
As someone who has been an Oracle DBA since 1984, I can only say Keith's
One of our users called UFI User Surly Interface.
-Original Message-
Sent: Friday, May 17, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
ufi, user friendly interface. Boy I feel old now
[EMAIL PROTECTED] wrote:
OK Keith, do you remember what the prompt was that SQL*Plus
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that is what I see that
night!)
Third, that is just a LA street, not a highway! :P
Forth, this is not wild... just LA type of driving!
Winnie
--
\ /
Yeah, I have missed every OOW since then. Just not worth it compared to
IOUG.
I could have sworn I saw some Perl-looking DBA standing on the corner with
his eyes wide and mouth hanging open when she flung that car and her
passengers around.
BTW, when is that Perl/Oracle DBA book coming out.
Jared,
If you look in V$process and V$session you'll see that there are only a
limited number of processes and that as you surmised the dispatcher points back
to the idle sessions it is dealing with. Now if the session becomes active that
changes to the shared server doing the work. And if
Just make sure you have a good recovery plan!
Waleed
-Original Message-
Sent: Friday, May 17, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that is what I
Thanks Dick, that's the way I thought it worked.
Jared
[EMAIL PROTECTED]
05/17/2002 10:00 AM
To: [EMAIL PROTECTED], Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re:MTS questions
Jared,
If you look in V$process and
Hi,
I just wanted to find out if people are receiving postings from oracle list. I can see
my post come up but no posts from anybody else.
Thanks
---
Madhavan Amruthur
Outgrown your current e-mail service?
Get a 25MB Inbox, POP3 Access,
It's been kind of slow today !! everybody seems to be working hard.
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:
Where I used to work, they had it will it was still Platinum (before CA took
over). It was a decent product, but CA did not provide good support and was
always YEARS behind. When we wanted to upgrade the DB from 7.3.4 to 8.1.6
(in late 2000), we found out that CA did not have a version of
MacGregor, Ian A. wrote:
I believe, fifteen years ago, it had already changed to SQL.
Yes. Dates from Oracle5, 17 years ago.
I'm also pretty sure that iag/iap had also already been introduced. OCI was
definitely there
Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then.
-It's been kind of slow today !! everybody seems to be working hard.
Not me, I'm goofing off! :o)
Dave
-Original Message-
Sent: Friday, May 17, 2002 2:08 PM
To: Multiple recipients of list ORACLE-L
It's been kind of slow today !! everybody seems to be working hard.
Raj
It must be the Friday ritual and everyone is on the OT list today.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/17/02 03:08PM
It's been kind of slow today !! everybody seems to be working hard.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
the sun's out in the northeast US. I'd guess people took the day off!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 17, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
It's been kind of slow today !! everybody seems to be working hard.
Raj
Oracle5 had something called something like SQL*Star (can't remember exactly
if that is correct name though!) that I used to interface Oracle with a
McDonnelDouglas Hierarchical GDS system - about 17 years ago... What fond
memories we are dragging up!
Regards,
Melanie Burns
-Original
I forgot about the name change fron HLI to OCI, but the core functionality, the
ability to embed SQL in a 3GL, was there which was the gist of my claim.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 17, 2002 12:28 PM
To:
What it was called locally when I started using it is not usable in mixed
company.
Dick Goulet
Reply Separator
Author: Schilling; Ben [EMAIL PROTECTED]
Date: 5/17/2002 10:04 AM
One of our users called UFI User Surly Interface.
-Original
Terry,
Set Flames on
Would you mind not cursing on the list. CA is a 4 letter word around here,
just for the reason's you cite. The other is that they make Oracle look cheap.
Set flames off
Dick Goulet
Reply Separator
Author: Ball; Terry
I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.
Here is the issue.
I have a query that looks like this ...
select a.f1, a.f2, a.f3, a.f4 from table1 a
where a.f1 not in
( select b.n1 from b );
there is a primary key index
Platinum no longer exist - they now belong to
Computer Associates (CA).
CA still sell a product call Tsreorg (which had
fast unload bundled into it).
I am not sure if CA sell Fast unloan on its own.
To be honest it wasn't a great selling product at
Platinum on its own, but Tsreorg sold
No, not old... we were all preteens when we started with Oracle, remember!
Well thats my story and I am sticking to it!
Enough nostaglia for me!
Regards,
Melanie Burns
-Original Message-
Sent: Friday, May 17, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
ufi, user friendly
Stephane,
I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole
lot more efficient than iag/iap. Damn, those were the days when a mouse was an
optional item on your desktop that normally outlived the rest of the PC. That
is IF you had a PC!!
Dick Goulet
It's not using the index because of the NOT IN - it doesn't help to search
an index to see what's NOT in it. Did you try rewriting it to use a NOT
EXISTS instead?
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of
Yep... Got it.
Lon
Madhavan Amruthur wrote:
Hi,
I just wanted to find out if people are receiving postings from oracle list. I can
see my post come up but no posts from anybody else.
Thanks
---
Madhavan Amruthur
Outgrown your
At a recent NYOUG meeting the question was asked of of around 150 or so
attendees (very rough estimate) how many had 9i on a production system.
Two people raised their hands.
Jay Miller
-Original Message-
Sent: Tuesday, May 14, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L
I
Sounds like the old Platinum guys should start a support company of the old
products...
The biggest problem is that most of the techies left platinum (product
developers) and joined - wait for it - Quest... after CA took them over.
Now u know why the quest products work so well...
-
Curious how people are storing phone info in their database, eg.,
separate columns for country code, city code, area code, etc. Any
references about this would be appreciated!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL PROTECTED]
Fat
-- Kirsh, Gary [EMAIL PROTECTED]
It's not using the index because of the NOT IN - it doesn't help to search
an index to see what's NOT in it. Did you try rewriting it to use a NOT
EXISTS instead?
Which can quickly degenerate into a tablescan also... even
if the index exists if the entropy
Johnson, Michael wrote:
I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.
Here is the issue.
I have a query that looks like this ...
select a.f1, a.f2, a.f3, a.f4 from table1 a
where a.f1 not in
( select b.n1
Try...
select a.f1, a.f2, a.f3, a.f4 from table1 a
where not exists
(select b.n1 from b where b.n1 = a.f1);
Let me know...
Chris
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
I just just wanna go lie on a beach naked
on some remote
As for the adress, you have more flexibility when
storing each parts separately.
Stephane
--- Suzy Vordos [EMAIL PROTECTED] a écrit :
Curious how people are storing phone info in their
database, eg.,
separate columns for country code, city code, area
code, etc. Any
references about
I'm not sure an index would ever be used with not in (in seems to be bad
enough). Not exists would probably be quicker though it'd probably be
reasonable still to do a full table scan of a.
Personally I prefer the likes of minus though it'd be a bit convoluted here
e.g.
select a.f1, a.f2,
Title: RE: Do you ever have days where you dont want to think ?
Mike,
WheretheheckisOLN-AFMC? Okie City?
Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index.
Have you tried a hint?
select /*+ index(table1
Does anyone have experience with AQ tables? I would like to put a trigger
on my AQ table so that when a message comes in, it will automatically fire
off a job to dequeue the message. I opened a TAR and was told that I can
put a trigger on the table, but it's not recommended. When I asked why,
[EMAIL PROTECTED] wrote:
Stephane,
I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole
lot more efficient than iag/iap. Damn, those were the days when a mouse was an
optional item on your desktop that normally outlived the rest of the PC. That
is IF you had
-- Suzy Vordos [EMAIL PROTECTED]
Curious how people are storing phone info in their database, eg.,
separate columns for country code, city code, area code, etc. Any
references about this would be appreciated!
Useful for fast scans by a/c or prefix. Depends on the use.
Indexes on these
Yeah, I have those days.
The beach sounds good; don't worry, I'll go find my own.
Wouldn't want to frighten the natives.
Try 'not exists', 'not in' forces a table scan.
Even better, use an explicit anti-join.
select a.f1, a.f2, a.f3, a.f4
from table1 a, table2 b
where a.f1 = b.n1(+)
and
On Fri, May 17, 2002 at 02:03:25PM -0800, Miller, Jay wrote:
At a recent NYOUG meeting the question was asked of of around 150 or so
attendees (very rough estimate) how many had 9i on a production system.
Two people raised their hands.
--
similar experience at Atlantic Oracle Training
Sorry I dont want to think!!
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.
Here is the issue.
I have a query that
Stephane,
Understood boy do I agree. I was under the impression that these machines
were created to server us, not the other way around!!
Dick Goulet
Reply Separator
Author: Stephane Faroult [EMAIL PROTECTED]
Date: 5/17/2002 2:28 PM
[EMAIL
Hello all,
We're running Oracle RDBMS 8.1.7.2 on a Solaris 2.8 server platform.
The development team for a particular project has written a stored
procedure for sending data feeds to other projects. It spools
outputs of queries to UTL_FILE_DIR, and then other processes
E-mail the output files
Don't have time to help with the query but following this link may help
with the first part:
http://images.google.com/images?hl=enlr=q=naked+beach
(you military guys, one tract minds...lol)
Brian P. MacLean
Oracle DBA, OCP8i
prod = (description=
(address_list=
(failover=ON)
(load_balance=OFF)
(address=...) = points to primary db
(address=...) = points to standby db
)
Its out in the NW also, which is even more amazing considering the time
of year.
-Original Message-
Thomas F
Sent: Friday, May 17, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
the sun's out in the northeast US. I'd guess people took the day off!
Tom Mercadante
Oracle
It was ODL : Oracle Data Loader .
--- paquette stephane [EMAIL PROTECTED] a
écrit : Since we're in old stuff.
Anybody remember the ancestor of Sql*loader ?
Answers in 10 minutes !
--- [EMAIL PROTECTED] a écrit : Stephane,
I remember using Pro*C with Lattice C and/or
Vax
The beach part sounds great, though I don't care to see naked men running
around ;-) But it still beats doing this techie thing all the time.
FWIW, a NOT IN *can* use an index under the CBO, and has done so since early
7, behaving very much like a correlated NOT EXISTS with a slight difference
Hello,
It's very interesting for me how will Madhavan receive answers if he
can't see any posts. :-)
Saturday, May 18, 2002, 4:33:20 AM, you wrote:
LW Yep... Got it.
LW Lon
LW Madhavan Amruthur wrote:
Hi,
I just wanted to find out if people are receiving postings from oracle list. I can
76 matches
Mail list logo