Stephen,
(BWhen you say there IS an problem with index rebuilds what do you mean?
(BHave Oracle acknowledged it as a bug?
(B
(BYour work around basically slows the volume of data being passed through the buffer
(Bcache, presumably allowing other users to get on with their work.
(BI assume
Hello world,
Can anyone explain (forgive the pun) how to get cost/card/bytes information out of the
Explain Plan? I'm using Toad and sometimes it gives me cost info and sometimes it
doesn't. Why?
Regards,
Eric
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eric
That could be quite a LARGE update.. ;)
-Original Message-
Carmichael
Sent: 05 June 2003 01:49
To: Multiple recipients of list ORACLE-L
geez, back to the very very first presentation Marlene Theriault and I
did together, about version 6, called All the Things THEY Didn't Tell
You
you
It just occurred to me why - it's the analyze, stupid! One of my tables wasn't
analyzed.
:-) Eric
-Original Message-
From: Eric Mortensen
Sent: Thu 05.06.2003 10:48
To: [EMAIL PROTECTED]
Cc:
Subject: Cost info in Explain Plan
Hellolist,
I have installed InstallShield(comes along with Delphi)in my PC. When i
run it, it gives me the message : Installshield for Windows Installer is unable
to start. Ensure that the Windows Installer engine has been installed
properly.
but when i go to
control panel/services/and
Hallo all,
anyone whom could help me with this:
I would like to have an example of pl/sql procedur which does the following:
CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT
If you do exp/imp... grab DDL on package bodies, grab the SYS grants, ...
Patrice.
-Original Message-
Sent: Wednesday, June 04, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
Hi Rich,
No. I guess by manual I mean I didn't use the gui. I ran the appropriate
upgrade script.
Guys,
can someone give a simple example ( piece of code ) for:
How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ?
..peeped into metalink too.
can u give me any other example / URL for the same ???!
TIA.
Jp.
--
Please see the official ORACLE-L FAQ:
Hi,
Anything in the event log?
HTH.
-Original Message-
Sent: Thursday, June 05, 2003 6:10 AM
To: Multiple recipients of list ORACLE-L
Hello list,
I have installed InstallShield(comes along with Delphi) in my PC.
When i run it, it gives me the message : Installshield for Windows
why would removing optimal setting help with snapshot too old?
what I dont understand is that each of my DML transactions are independent of each
other. They query and perform DML on different tables. None of them overlap. The only
time they overlap is when they hit the data dictionary for
Hi Bob,
I don't know if its possible to do it by those means, but it is
definitely possible, using heterogeneous services to have Oracle pull
the data from Access over a database link. You could schedule that
through the Oracle scheduler, or have MS scheduler execute a sql script.
HTH.
Beth
Good
question. I see it very intermittently with sessions (robot cells) that
stay connected for days on end. Just had an occurrence this week.
The DB has been up for 96 days before all heck broke loose. Thankfully we
only need to reconnect/restart the robots.
Dick GouletSenior Oracle
Doh, I replied to Jared only. Here it is:
-Original Message-
I knew that was coming. :) Should of explained in the last e-mail.
Sorry, was busy with many things.
The error ora 1017 says logon denied. That got me chasing all
the connection stuff. Turns out the package uses a remote
Thanx Ganesh,Jared,Jay,Roy and Chajol.
Thanks for the info'.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Untitled
ODTUG-DEV2K-L - [EMAIL PROTECTED]
[EMAIL PROTECTED]
---BeginMessage---
SUBSCRIBE ORACLE-L
---End Message---
Have a look at rman which is part of the
Oracle installation. You should be able to do any kind of backup you want
with this product.
Regards,
Ruth
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Friday, May 30, 2003 8:25
thanks for your excellent responses. I guess striping doesnt help with netapps.
I was finding alot of waits for redo logs, full table scans, and index reads. However,
I guess I have to live with it with the netapps. I believe we have a 1GB pipe. Does it
matter if I put my indexes in seperate
I have a bit of Oracle memorabilia but I probably won't be willing to
part with it. Maybe the Oracle Museum should be virtual, with a
registry of who has what archaic Oracle stuff.
I have all the version 5 for DOS diskettes, which it sounds like you
have as well. I tried running the installer
Title: RE: Chris: Thank you!
got
some 6.0.36 diskettesfor those interested:-)
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003
8:31 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Chris: Thank you!
Dang ...
last
Hi list ,
Can you help me please .
I have a report that show data as follows :
debit credit balance
30-3
0 -1 2
1 0 3
Is their a way to get balance without using a separet query in a
formula
But then Larry's yacht appeared racing in the America's Cup ;)
May be a bug? ;)
- Kirti
--- Binley Lim [EMAIL PROTECTED] wrote:
Big Blue button that ships with the new OEM. Hold down the shift key and
triple click on the middle mouse button.
- Original Message -
To:
Hey, I've got an old Leading Edge 486DLC in my basement. Needs a new set of drives.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, June 04, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L
I have a bit of Oracle memorabilia but I
Title: RE: Good technical documents/references on tuning restores
Paula,
IIRC
'MISSING' means it is in the data dictionary, but not the control file. I've
gotten that before, but haven't played that game in a while. You might be able
to 'DROP' them, but I'm not sure. Check that first on a
Title: passing ref cursor on a procedure
If
in SQL*Plus:
Just declare variable of REFCURSOR type
and pass it to stored procedure:
DECLARE lCursor REFCURSOR;
Begin
procedure_name(par1, par2, ,
:lCursor);
end;
/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original
Oh-My-Gosh.
Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I set the
COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors:
ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release
135294976
ORA-01571: redo version
Have a look at analytical functions (LAG() and the like)
- --- Original Message --- -
From: Walid Alkaakati
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 04 Jun 2003 05:10:14
Hi list ,
Can you help me please .
I have a report that
If this is a regular CONCSUB job and your stuff is in default spots then
look at $APPL_TOP/admin/your instance/log
Allan
-Original Message-
Sent: Tuesday, June 03, 2003 10:00 PM
To: Multiple recipients of list ORACLE-L
Any APPS DBAs out there?
I need to know where to find the argltp
I think it's good to have (forgive me Jared :)).
It reminds me with Pascal language.
Waleed
-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
My first real PL/SQL program used this technique. Of course since it was my
first program I ran
Walid
You can use SUM as an analytic function like this: -
SQL select credit, debit, sum(credit + debit) over (order by rowid) from
foo;
CREDIT DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID)
-- -- ---
3 0
Title: RE: Good technical documents/references on tuning restores
Paula,
It was very entertaining to read this
thread -J
Did you answer all your questions?-J
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
From memory (of a course attended looong ago),
Oracle recommends one rollback segment for every
three to four users.
Four rollback segments between thirty six processes
does seem a little mean.
Garry
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/06/03 13:59
Please respond to ORACLE-L
Lisa,
Did you do the upgrade manually or via the GUI? I'm interested because I'm
looking forward to 20 upgrades several of which will have to be done in place as their
too big otherwise.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent:
Title: passing ref cursor on a procedure
Oops
Its supposed to be:
Variable lCursor REFCURSOR;
Not: declare lCursor REFCURSOR;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor
Neyman
Hi ,
Iam looking on how to solve this in a report ,,,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
Title: RE: Good technical documents/references on tuning restores
I had
this problem yesterday. not sure if what I did is correct but it seemed to
work for me.
1)
Create another tablespace (TEST)
2)
move the objects from the tablespace that has the missing files into TEST
tablespace
I agree with you Lisa ... g,
I don't understand the PR ...
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 10:40 AM
To: Multiple
How about
SELECT DEBIT,CREDIT,CREDIT-DEBIT
FROM WHATEVER_THE_TABLE
WHERE CREDIT*CREDIT=-1;
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L
Hi list ,
Can you
Title: RE: Good technical documents/references on tuning restores
Sometimes it just helps to "talk" it all out. Virtually or
otherwise.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path when you
come upon it, because you will suddenly
I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on
Linux... PERIOD. This despite the fact that we've had files in excess of this for some
time and they work just fine. The problem occurs when the autoextend feature reaches
the 2GB threshhold. Of course, Oracle
Title: RE: Good technical documents/references on tuning restores
Paula,
Have you tried backing up your controlfile to
trace, editing the trace file to get rid of the unwanted datafiles, and
reopening the database with the new edited controlfile? That should get
rid of them. Of course, to a
Title: passing ref cursor on a procedure
example
-Original Message-From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June
04, 2003 2:40 PMTo: Multiple recipients of list
ORACLE-LSubject: passing ref cursor on a
procedure
Dear All,
I have a vendor
Or $AR_TOP/$APPLLOG, if $APPLCSF is unset. If $APPLCSF is set, $APPLCSF/$APPLLOG.
- John
-Original Message-
From: Nelson, Allan [mailto:[EMAIL PROTECTED]
Sent: Wed 6/4/2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Cc:
Depending on the structure of your table, you can also use plain SQL with a
self-join, similar to:
select v1.cust_id
, v1.order_date
, v1.order_total
, sum(v2.order_total) cumulative_total
from orders v1
, orders v2
where v1.cust_id =
Paula,
Was the tablespace read-only?
Those weired MISSING... names refer to data files in those tablspaces.
Do you have a controlfile trace? Look in there to see what is what..
Here is what I see in the CF trace for my read-only tablespace:
# Files in read-only tablespaces are now named.
ALTER
Title: passing ref cursor on a procedure
Example
Package ll is
Type lrec is record(
? A ?integer,
? B? varchar2(72));
Type lrectype is REF CURSOR return lrec;
Procedure getl( par1 in varchar2,
?? Xcursor IN OUT lrectype);
End;
Now ,
HOW do
Try removing optimal setting, and shrinking RBS to the min extents (or even below)
before running
your tests.
- Kirti
--- Garry Gillies [EMAIL PROTECTED] wrote:
From memory (of a course attended looong ago),
Oracle recommends one rollback segment for every
three to four users.
Four
--- Igor Neyman [EMAIL PROTECTED] wrote:
Paula,
It was very entertaining to read this thread -:-)
Did you answer all your questions?-:-)
I agree with Igor! ;-)
well, Paula...
you have MISSING datafiles because they are registered
on your data dictionary and they were not included in
Hi Dick,
This was a manual upgrade. I sure hope your upgrades go better than mine have.
Lisa
-Original Message-
Sent: Wednesday, June 04, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Lisa,
Did you do the upgrade manually or via the GUI? I'm interested because
Hi
Possible scenario where it might make sense:
You want to hide some implementation from people that use your package.
Since, AFAIK PL/SQL doesn't have information hiding (private, protected,
public etc.),
this might be a way of not showing your private helper method's signature
in your
I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)
JP
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM
I've just been informed that there is a 2GB datafile size
Title: RE: Good technical documents/references on tuning restores
I had that problem in a 9.2.0.3 AIX4.3.3 to AIX 5L upgrade... missing
with really weird names... if you look at your tablespace sizes, the ones that
are 0 bytes are the ones that have the missing files. If you can figure
out
I'd say file size limit/autoextend feature has been Oracle's
dirty little secret for quite a while. For a very long period
of time there was similar 4GB 'magic' barrier on Windows, that
was allegedly fixed. Workaround for the problem was to create
datafile 1 MB larger than the 'magic' number, and
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with autoextending
datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation
imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this
I think, you did.
Using packages you still can hide procedures/functions.
Just have them in package body, and don't declare them in package
header/declaration. Thus, describe package_name will not show
private procedures/functions.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original
There are a Lot of options to DBMS_STATS .. And be Judicious in using
the same. Read the docs before attempting it.
BTW .. What is the session waiting for .. Just Check v$session_wait.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Set the Compatiable Parameter to the Actual Version you Upgraded and not
to any patch rel that was rel later on.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
I believe PL/SQL packages let you do a fair bit of information hiding--any
signature you leave out of the package spec is essentially private to the
package. You can also decare package-wide variables in the package body to
keep them private to the package. For instance:
create or replace
Any Oracle Apps DBA out there..
Am getting the following error when am trying to install 11.5.8 on Redhat 8. The error messgae in the adcrdb_PROD.txt is as follows:-
ORA-12547:TNS:lost contact
SP2-0640 Not connected.
Am getting the error when rapwiz is running adcrdb.sh - creating the database
I have two Oracle installations on the same host. Between installs I
updated /etc/oraInst.loc and /var/opt/oracle/oraInst.loc accordingly so
that I have two inventory directoies, one per installation.
My question is that /etc/oratab has a facility for multiple
installations via 'SID:$ORACLE_HOME
Hi Ganesh,
Thanks for your reply. Still, no dice. Now it thinks it's in recovery and I can't
force it to do an incomplete recovery with OPEN RESETLOGS. The brilliant response I
got from support is Restore from backup and try again
Lovely. This is the second upgrade I have tried to
real quick thought from mostly a lurker
Your soft parsing % probably indicates what you suspected
in string literals.The % of your physical reads is way
to high versus logical reads.Check you SQL area and see
if their are any obvious dogs in there. Your second wait
latch free
Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There
NICE! Thanks.
-Original Message-
Sent: Wednesday, June 04, 2003 11:57 AM
To: Multiple recipients of list ORACLE-L
It's a combo problem between oracle and linux. When Linux first
implemented largefile support, many of the traditional linux apps were
not aware of the concept of 2GB
It's a combo problem between oracle and linux. When Linux first
implemented largefile support, many of the traditional linux apps were
not aware of the concept of 2GB files and were using 32-bit offsets for
file pointer storage. So, as a workaround, 32- and 64-bit versions of
the various file
Thanks Branimir for confirming my right to be peeved. :-)
I never liked the autoextend feature but we use it because:
1) We have this nifty end user driven feature where they can clone their data via a
nice web GUI interface. (This is for web site upgrades scheduled by the end user.)
2) We don't
Title: RE: oraInst.loc question
We have one oraInst.loc file for each individual set of binaries (two on production, three in development/test) and every time we patch/upgrade/install we rename the oraInst.loc file to whatever we are working on.
Not an optimal solution, but the only one I
Oracle7 Server Release 7.3.4.5.0 (yes, I know, old); AIX
4.3.3
Hello All,
I am trying to limit concurrent sessions on my
database. The Oracle documentation says I can do it. However, when
I follow the steps (create profile with sessions per user set to one, then assign
Oracle user
Title: Those installing Oracle 9i on AIX 5.2L
Raj,
Here was what my SA (Claus)sent me when I
asked him what we did special to AIX that Oracle required:
Standard 5.2 installation with 64-bit support and the basic JFS
filesystem.Graphics were included (Oracle needs X windows).Only
extra
Title: Those installing Oracle 9i on AIX 5.2L
Raj,
On more thing to remember. If you are going
to apply the 9.2.0.3 patchset, be sure to pick the 5L version, not the RS6000
version of the patchset to download. If you pick the wrong one, it will be
full of errors. If you pick the 5L version,
This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...
J'ai une impression d'avoir déjà vu ceci.
: )
Patrice.
-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Steve - are you
Lisa, when you say you manually migrated, did you use exp/imp after a
fresh CREATE DATABASE in 9i? Also, what platform? 32-bit?
Thx!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original
Title: Those installing Oracle 9i on AIX 5.2L
Thanks Ruth ...
I'll pass this to my SA.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
Well... datafiles 2GB seem to work okay but since Oracle is being a weenie about
supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump
thru in the wild goose chase was to manually extend datafiles via maxsize without
using unlimited. Eventually the only
Title: Those installing Oracle 9i on AIX 5.2L
But it is on disk 1 of the installation set for 5L!
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path when you
come upon it, because you will suddenly have all the energy and imagination you
Title: Those installing Oracle 9i on AIX 5.2L
Thanks for reminding ... we have been through this about 4 times ... once
it almost brought down the system, but luckily we shut down the affected site
and the other side supported the users while we screamed at
Oracle.
Raj
Title: Those installing Oracle 9i on AIX 5.2L
I got several "can't write to insert string.so" errors... but
renaming those files allowed it to finish... and I always get those
errors.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path
Steve - Is there a Metalink note on this? What would a person search for?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file
nice. either way, you're screwed into doing more work than you had planned.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Well... datafiles 2GB seem to work okay but since Oracle is
Tuesday, June 3, 2003, 10:59:42 PM, you wrote:
MR 3) If the company has done something which makes it impossible for the
MR service provider to maintain the SLA then re-negotiation is required.
This is probably harder than it sounds. How does the
service-provider prove that the client has done
Yeah, now I call it the outta-extend feature. :-)
-Original Message-
Sent: Wednesday, June 04, 2003 12:28 PM
To: '[EMAIL PROTECTED]'
Cc: Orr, Steve
nice. either way, you're screwed into doing more work than you had planned.
Tom Mercadante
Oracle Certified Professional
Bingo!
Thanks Dick, it is working now.
Sam
GBC
-Original Message-
From: Goulet, Dick
[mailto:[EMAIL PROTECTED]
Sent: June 4, 2003 2:30 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Limiting Concurrent
Sessions Not Working
Do you
have resource_limit =
Nevermind, a search on 2gb yielded Note 112011.1, which seems to explain
it all. Oh well, one more item for my to do list.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 2:30 PM
To: Multiple recipients of list
Title: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Upgrading was number 2?
NO way!?! I am (genuinely) surprised that it wasn't number 1 suggestion...
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it,
As per Branimer's previous post, try searching under dirty little secrets. :-)
-Original Message-
Sent: Wednesday, June 04, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L
Steve - Is there a Metalink note on this? What would a person search for?
Dennis Williams
DBA, 80%OCP, 100%
It doesn't seem to be a problem on other platforms... Just when I stopped feeling like
a neglected step child for running on Linux. Don't worry... Be happy... There's a
workaround... Upgrade and buy more software...
D'ai jobu desu... er, eh, Ca ne fais rien.
-Original Message-
Sent:
Title: Message
Oracle
8i on linux, while functional, definitely had/has a whole boatload of
problems. 9i is much better all around, and I'm not surprised that Oracle
support is pushing it heavily. We're getting a lot of customers that are
trying to get off 8i because of problems like this
As root, from other session, you can run 'slibclean' (check the man pages for more
info).
Then there is no need to rename/remove so *.so library files.
- Kirti
--- April Wells [EMAIL PROTECTED] wrote:
I got several can't write to insert string.so errors... but renaming
those files
OK,
now watch out for Oracle bug 643709 which can send your users a
pile of "ORA-02394: exceeded session limit on IO usage, you are
being logged off" even though you don't have any IO limits set. It's
fixed in 8.1.x.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original
Ahem . . . according to Note 112011.1, these problems can affect all
platforms except OS/390 which does NOT support datafile resizing
(fiendishly clever those mainframe types).
It looks like 8.1.7.4 and above is not affected. I would highly recommend
that all Oracle DBAs take a look at this note.
Hello List,
We are developing an application using Visual Basic and Microsoft ADO. We
are also using Oracle Provider for OLE DB and the database is Oracle 8.1.7.
We were using client side cursors in application and had some problems. We
switched to server side cursors and explicit Begin and End
We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years
and let other customers QA this Oracle feature until they get it right.
Steve
-Original Message-
Sent: Wednesday, June 04, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Ahem . . . according
Title: Message
A
library cache hitmeans that when parsing a statement the object definition
is already found in the cached data dictionary (likely it has been recently
used). A library cache miss means that it aint there.
Now if
you can explain to your line of business boss why you would
I understand why you wouldn't wish to part with it, but a virtual museum
will never work. The 'where to find a leading edge PC' problem has
already been mentioned, where to find an industry standard floppy disk
will become an issue as well. For my money the best route for a museum
would be a
That would be next to Oracle is half the cost of sqlserver for packaged
apps, which would apeear to me to be a lie, in the sense that it is a
statement which would be untrue for any given customer migrating.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Hi Rich,
No. I guess by manual I mean I didn't use the gui. I ran the appropriate upgrade
script.
Gosh I hope it doesn't come to exp/imp... I can't even export my database.
Lisa
-Original Message-
Sent: Wednesday, June 04, 2003 2:46 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Thanks a lot, the diamond of the day from the list.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, June 04, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Ahem . . . according to Note 112011.1, these problems can
Title: RE: Those installing Oracle 9i on AIX 5.2L
We don't GET access to man pages here... they take up too much space... so does the C compiler.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you
What do you wish to discover?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Satya Prakash Viswanath
Sent: 03 June 2003 05:40
To: Multiple recipients of list ORACLE-L
Subject: Benchmarking of ASP.NET with Oracle v/s MSSQL
Hi List,
Anybody
Steve
Personally I am VERY glad you mentioned this today. Since I run 64-bit
Unix, I didn't think this applied to me, but after reading the note, I ran
their formula and found a file on one of my databases that was very close to
the limit. Plenty happy to dodge that bullet.
Dennis Williams
But every time you modify test_test2, c1 will become invalid - using a
package will not have this issue.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Khedr, Waleed
Sent: 04 June 2003 15:20
To: Multiple recipients of list ORACLE-L
1 - 100 of 116 matches
Mail list logo