If X is fixed for all sessions, do a step increase of X so that you only have
to select 1 row from dual.
Anjo.
On Friday 27 September 2002 00:18, you wrote:
All...
Is there a method by which I can select the next x values from a
sequence from dual? I've searched Google and OraFAQs.com,
Sure, do post it
Aleem
-Original Message-
Sent: Friday, September 27, 2002 1:31 AM
To: Multiple recipients of list ORACLE-L
Subject:Should I post a preview of Oracle9i RMAN Backup and Recovery
Hand
I was wondering if anyone would be interested in me posting one chapter
One more vote for it
-Original Message-
Robert
Sent: Thursday, September 26, 2002 10:31 PM
To: Multiple recipients of list ORACLE-L
Hand
I was wondering if anyone would be interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't
If I wanted to degrade a database, I'd take it out
to a cheap pub, get it drunk, and let it make a fool
of itself on the dancefloor before taking it home for
some wild bedroom scenes...
Next morning, rest assured, the database will roll
over in your bed and exclaim:
I'll feel so degraded
:-)
ALL_INDEXES is a 9-way table join (some outer) with a
few correlated subqueries. ALL_IND_COLUMNS is a 8-way
table join with a few correlated subqueries as well.
That's a lot of work to churn through...
hth
connor
--- Adams, Matthew (GEA, MABG, 088130)
[EMAIL PROTECTED] wrote: why would a
Give me a break - I'm looking for solutions, not to compound the problem!!
peter
edinburgh
-Original Message-
From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2002 20:05
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA place in the business (was RE: DBA
Have you gone through what's the difference between an
application DBA and
a database DBA? yet?
Oh yes, and a logical dba, and a physical dba ... you name it, we found it
... which rather confirms the point Jared was making - 'We fit everywhere,
and nowhere.'
peter
edinburgh
Thanks for this Gerardo,
I forgot to mention, but unfortunately this activity will have to
be carried out on NT rather than Unix. I guess it would be more
complicated as the registry and services would come into play aswell.
Cheers,
Kieran
-Original Message-
Sent: Thursday, September
yea i'm interested by all means.
joe
Freeman, Robert wrote:
I was wondering if anyone would be interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
Push the question about the requirement of RAW devices.. and ask if
Veritas's product can work without any restrictions.. The veritas clustered
file system is supposedly ok to use with RAC where you can take advantage
of using file systems. But I haven't seen confirmation of that. also-ask
about
Must say I liked Inka's notion of calling all interested parties with
details, though it could be income threatening =:-0
Maybe a compromise would be to agree some type of SOP for such situations
and have the interested callers list put in there. I mean if they are so
keen to know first thing
yea i'm interested by all means.
joe
Freeman, Robert wrote:
I was wondering if anyone would be interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
I'm trying to get information of the limitations of ODBC drivers,
specifically Oracle's and Microsoft's drivers for Oracle.
Things like maximum no. of records they can fetch etc. As I know very
little about ODBC (which might be reflected in the nature of my question) I
hope I'm asking a sensible
I got the first bid in!!!
Matt Adams - GE Appliances - [EMAIL PROTECTED]Their
fundamental design flaws are completelyhidden by their superficial design
flaws. - Douglas Adams
-Original Message-From: JOE
TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26,
2002
Title: RE: Degrade a database??
I have no fresh ideas but how about keeping a file system backup of your oracle installation and 3 copies (in different locations of course) of a complete cold backup before the upgrade?
Or copy the existing database on a similar but separate machine, ready to
Setting LOAD_BALANCING=ON parameter in listener.ora Versus tnsnames.ora .
Which is Better Why ?
Any Docs , Links ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
That is the recommended way. I have a 6 partition table with each partition
in a different tablespace and each table space on a different drive. It's
working well!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002
I found that query-only applications seemed to run OK against 8.x.x
databases,
but update applications encountered locking problems because of the expanded
rowid.
(I think Forms 3.0 stores the rowids within the form and only stores part of
the
expanded rowid).
I don't know how you could possibly
Yes, we use it for our Winders/Linux/Solaris/HPUX boxes. It's actually used
by our parent company, which also does our networking, MS sExchange
administration, and Windows server admin. I'm on the mailing list for when
server in our building isn't pingable.
Unlike OEM, I've had no problems
anyone have a specific URL for the "lot"?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, MABG,
088130)Sent: 27 September 2002 14:18To: Multiple
recipients of list ORACLE-LSubject: RE: oracle-dba.com
domain
I got
For any indexes on the table ,LOCAL prefixed indexes (b*tree/bitmap) is the preferred
way to go !
-Original Message-
Sent: Friday, September 27, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L
tablespace,
That is the recommended way. I have a 6 partition table with each
The Database Character Set and the National Character Set are different.
Your DB CharSet could be UTF8 but the National CharSet AL16UTF16 .
[I believe that when you create a database without specifying charsets,
the default DB CharSet is still US7ASCII but the NationalCharSet is
SET ORACLE-L NOMAIL
_
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItemitem=2057533249
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mark LeithSent:
Friday, September 27, 2002 9:38 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: oracle-dba.com domain
anyone
On Wednesday 25 September 2002 12:33, Hand, Michael T wrote:
Got a couple of questions for those of you dealing with SAP:
1) Has anyone heard of a timeline as to when (or if) SAP R3 will support
Oracle 9.x? And,
No, and I doubt it.
2) Has anyone implemented table partitions as a method of
With regards to any creativity embedded in the BDBAFH thread that I might
have contributed, those who have read the BOFH saga will recognize that I
copied a segment (almost!) word-for-word from Simon Travaglia's original
text. If you haven't read the BOFH sagas, they are a scream (flash to
They can be on the same box but memory and CPU may be an issue since they both like
hog each.
Dave
-Original Message-
Sent: Friday, September 27, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they
and as long as we're coming clean, i too plagiarized. mine from the very
first post in the BOFH saga i believe.
but blame Mladen - he got us started.
--- Original Message ---
Date: Fri, 27 Sep 2002 08:49:06 -0800
With regards to any creativity embedded in the BDBAFH thread that I might
have
OK, here's the obligatory,
ARE YOU AN IDIOT?
Farnsworth, Dave [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/27/2002 08:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
HELP
Oracle won't care, but I can't speak for SQL*server. MicroSoft has a habit of
being non-compatible.
Dick Goulet
Reply Separator
Author: Farnsworth; Dave [EMAIL PROTECTED]
Date: 9/27/2002 9:19 AM
They can be on the same box but memory and CPU may
If I'm feeling particularly AR, or just want to revel in
the fact that I can do simple multiplication and addition
without error, I'll figure the datafile size to the byte.
e.g. 200m + 64k for an LMT is 2097217536 bytes.
On NT I tend to use NNNMm on 8.0 and NNNM
on 8i LMT's where the extent
yes, but not recommended for busy systems.
ok for sandbox though.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 11:56 AM
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will
they
conflict?
--
Hi Ian...
I can tell you how it works in 8.1.7...
You can alter a tablespace to read only with transactions in the database
and the steps are as follows:
You issue the alter to read only command and it will wait for EVERY
transaction in the database that started BEFORE you issued the command
Yes, I would like that too. A lot of people are awaiting your book, btw.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 4:30 PM
I was wondering if anyone would be interested in me posting one chapter
from
but your outbid already by someone in the UK :)
joe
Adams, Matthew (GEA, MABG, 088130) wrote:
I got the first bid in!!!
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
-
Dan,
The default is for oracle to determine this by timestamp.
You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter.
This may not apply to your situation as I don't know if it applies to
dependencies on
a local database as well.
e.g. ALTER SESSION SET
Jared, Thank You .
Tom Kytes book pages 108 to 111 goes into this.
I will continue to follow this advice.
Mike
-Original Message-
Sent: Friday, September 27, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
I always use indexes on FK's.
If it's a table with many
Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find
it in the fatcity.com archives (search is subject-only!), and I'm guessing
that Rachel's offline, given Her recent post.
As I'm delving into this, I seem to remember from those posts that we're too
small for a Papa Bear
Oracle seems to be inconsistant in the way it names
roles:
SQL select role, GRANTED_ROLE from ROLE_ROLE_PRIVS;
ROLE GRANTED_ROLE
-- --
DBADELETE_CATALOG_ROLE
DBA
Anjo...
Thanks for the reply!!
If X is fixed for all sessions, do a step increase of X so that you
only have to select 1 row from dual.
Unfortunately, I don't feel I can do that. I'm using the returned
values as unique identifiers to protect against duplicate database
submissions from a
They got that changed rather quickly. MS is no where on the first page
now. IF you combine go to hell with Microsoft you get 7 hits but the top
2 are sites commenting on this story.
Ain't it great to have clout.
Thanks Ruth, I may have some legal issues with posting it on the
newsgroup, and I'm trying to work that out with OP right now.
They want to post it, but I have to have the list owner agree to
it, and the item posted has to go through some changes. With the
nature of news groups, it may not be
Thanks. I believe that's how it works on 8.1.6 as well. Of course if someone has
walked away without committing a transaction then one is still stuck. There is also
the problem of distributed queries. If on database A, one selects from
table_name@B. An entry is made into the transaction
Thanks, I'll take a look..
-Original Message-
Sent: Friday, September 27, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
Dan,
The default is for oracle to determine this by timestamp.
You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter.
This may not apply
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can make 1
simple call passing it X.
Is that what you wanted ??? Or do you have to have them as returned values
of a select ?
Kevin
-Original
The app was getting an ORA-600, which metalink identified as a 'bug' in 9i.
The app uses persistent connections and the 'login' package had been
recompiled without removing the connections. All of a sudden the ORA-600s
started being thrown.
It made me curious (call me George) as to how Oracle
this is the first time I've NOT figured the file size the AR way :)
--- [EMAIL PROTECTED] wrote:
If I'm feeling particularly AR, or just want to revel in
the fact that I can do simple multiplication and addition
without error, I'll figure the datafile size to the byte.
e.g. 200m + 64k
Hi.
I want to update a table based on data in another
table. Something like:
update table1 a set f1 =
(select f2
from table2
where table2.f3 = table1.f3
and table2.f4 = table1.f4);
this seems to work, but generates a lot of redo logs.
So I tried to add NOLOGGING. Alas, seems like
NOLOGGING
We are looking into setting up cursor_sharing parameter to FORCE. Has
anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any
real bad effects of setting it..?
I was thinking of going back to my developers and make them use bind
variables in their code.
If I set the above
I'm here.. was away for a day but you guys flood my inbox :)
goldilocks was the name I gave to the methodology of
small/medium/large tablespace sizing. There was no hard and fast
rule for how big each of these tablespaces should be, nor was there one
for the extent sizes.
Just that if a table
I have been asked by damagement on the possibility of of linking Oracle to DB2 so that
an Oracle trigger can update a DB2 table. I have been reading some of the fine manual
along with reading stuff on metalink. From what I can tell in order to connect to
nonOracle data I need to use Oracles
Title: extremely long parse time
Matt,
Is it
Oracle 9?
If
yes, time is in microseconds.
Alex.
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, September
26, 2002 10:30 AMTo: Multiple recipients of list
ORACLE-LSubject:
What do you expect? When the god Gates speaks the feeble move.
Reply Separator
Author: Thomas Day [EMAIL PROTECTED]
Date: 9/27/2002 11:33 AM
They got that changed rather quickly. MS is no where on the first page
now. IF you combine go to hell
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can
make 1 simple call passing it X. Is that what you wanted ??? Or do you
have to have them as returned values of a select ?
I would need the values
H...even after flushing the cache, MS is still the top link for me on
Google (except for the news stories).
Rich
-Original Message-
From: Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT: For
NOLOGGING does not work on update, period. has nothing to do with
aliases.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 3:48 PM
Hi.
I want to update a table based on data
Exactly... I had to face this at my current job... I have a separate alter
to read only job... Basically, it is a script that calls a stored
procedure... I put the script in cron to run every 12 hours... The stored
procedure alters eligible tablespaces to read only (eligible as defined by
For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken
from the paper How to Stop Defragmenting and Start Living. Can't
remember the author but I'm sure someone will chime in as it's a well-known
paper.
Cherie Machler
Oracle DBA
Gelco Information Network
Can someone please repost the Goldilocks LMT Sizing
Guideline?
That's from a tar on Metalink... doc 12988.2 (I think)
;-
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Your update is updating all rows in table1. Is that
what you want ?
nologging only works with direct path insert, not with
update.
--- Gurelei [EMAIL PROTECTED] a écrit : Hi.
I want to update a table based on data in another
table. Something like:
update table1 a set f1 =
(select f2
Nat
You may want to take a look at:
http://www.interealm.com/roby/technotes/cursor_sharing.html
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, September 27, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
We are looking into setting up
I went thru this recently ...
The best thing to do is to FORCE the developers to use
bind variables and then this is no longer an issue.
If you do set it to FORCE , I believe there is a problem
with it in versions 8.1.6 and before and it should not be
used.Double Check with Metalink on
Make them use bind variables. Even if cursor_sharing did work correctly
(it might in 8.1.7, but I don't remember), using bind variables will
relieve the Oracle kernel of a lot of work (i.e., response time).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos
Reminds of a user who wanted to ungrade to Win98. They didn't know how
right they were.
Rajesh.Rao
Juan Loaiza, Rosanne Toohey, and Bhaskar Himatsingka.
The paper's online at www.hotsos.com/catalog.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR
OK, here's the obligatory,
ARE YOU AN IDIOT?
HELP
SET ORACLE-L NOMAIL
I think what Jared may have meant to say is me here trying to be
funny...
All LIST commands should be sent to
[EMAIL PROTECTED]
NOT
[EMAIL PROTECTED]
You recied a help message whan you subscribed to the
Rich - The paper that started it all (as far as I know), How to Stop
Defragmenting and Start Living posted at:
http://otn.oracle.com/deploy/availability/pdf/defrag.pdf
Suggests for Oracle 8 and above that the uniform extents be one of three
sizes: 128k, 4m, and 128m, and it explains why you
I recently used it on 8.1.7.4 and 9i.
I gained 33% performance gain. It would be different depending on how
much literal SQL is used in your code.
My process ran fine, and I was able to load the data. However, I have
not fully checked the data yet.
Shakir
--- Johnson, Michael [EMAIL
This is from Steve Adam's Oracle 8i Internal Services(page 50-51)
Library cache locks are held in shared mode during parse operation.
A pin is applied to the library cache object for a PL/SQL program unit
or SQL statement while it is being compiled, parsed or executed. Pins
are normally held in
Title: RE: Setting Cursor Sharing = Force in 8.1.7.3
We had problems with FORCE setting on 901x. The query it was changing to bind variables was
select to_char(sysdate,:b1)
from dual
/
Now :b1 is a format mask supplied by developer. Initially it would work fine and then start throwing
Thanks all! I've already got the doc d/l'd -- I just couldn't remember
where I saw the numbers. All I could remember was Goldilocks! :)
Hmmm...could be a case for an Oracle-based PDM ;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Bob,
The 'ARE YOU AN IDIOT?' reply is required on this list
when one encounters a help command sent to the list
rather than the list manager software.
It's from a thread from some time ago, and is meant
in jest. Dave knows it, as well as many others.
Now, you know it too. :)
Jared
List - We have discussed the employment situation a lot over the past year,
and I am still dismayed to hear of Oracle DBAs out of work. I found some
interesting statistics that put the situation in perspective:
In 2001, there were an estimated 10.4 million IT workers in the U.S.
In
Gary Chambers wrote:
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can
make 1 simple call passing it X. Is that what you wanted ??? Or do you
have to have them as returned values of a select ?
I
Greg, For the most part RAW is still a requirement for
RAC. There are more Cluster File system Options now
then there where 6 months ago.
Windows/2000 - Oracle now provides a CFS. I believe
you can download it from OTN. I don't have NT
installed so I can't comment on its reliability or
How many went back to their old non-IT jobs before they moved into IT
during the boom years when IT sucked people from the non-IT sector?
ltiu
DENNIS WILLIAMS wrote:
List - We have discussed the employment situation a lot over the past year,
and I am still dismayed to hear of Oracle DBAs out
I tried to do full database import use sys ID and have error come
out. for sqlplus I can use sqlplus /nolog to avoid it, but on
import/export how to avoid it?
RSS::/home/app/oracle/admin/db92/export[173]% imp
Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002
Copyright (c)
And besides, the Are you an idiot? question is redundant. After all, this
*is* a DBA list...
developer ducking for cover
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject:
I would love to read that .
bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 11:08 AM
Hand
Yes, I would like that too. A lot of people are awaiting your book, btw.
Ruth
- Original Message -
To: Multiple
Me too.
Bing Wong
Open Systems Database Administrator
This e-mail may contain material that is confidential. Any review, reliance
or distribution by others or forwarding without express permission is
strictly prohibited. If you are not the intended recipient, please contact
the sender and
Is Select ... For Update;
a cheap table lock?
It seems whenever code uses this statement
all the records in the cursor are locked
until the cursor is closed.
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.yahoo.com
--
Please
It would appear you don't know the pw of sys, or maybe the capslock is
on ;) If you can sqlplus /nolog can connect and alter the sys pw.
Then you will know the sys pw and can use it on imp cmd.
$ sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002
(c)
On 2002.09.27 20:33 tony ynot wrote:
Is Select ... For Update;
a cheap table lock?
It seems whenever code uses this statement
all the records in the cursor are locked
until the cursor is closed.
Fancy that! It works as described in the manual! Who would say?
--
Mladen Gogala
--
Please
At 07:28 AM 9/27/2002, you wrote:
I'm trying to get information of the limitations of ODBC drivers,
specifically Oracle's and Microsoft's drivers for Oracle.
Things like maximum no. of records they can fetch etc.
I don't believe there's any limitation in the number of records you can get
Stephane...
Thanks for the reply.
SELECT sequence.nextval FROM table WHERE ROWNUM x
It just seems too kludgy, and I didn't think creating a table with
dummy data for the count would be a good way to go. Any suggestions?
Why 'too kludgy' ? If you are inside a PL/SQL package have you
85 matches
Mail list logo
