date:20030605




April, 
 
and you thought you were alone ... on our most 
production systems, we have everything that we need. But when we talk about the 
machines in the DMZ (outside the firewall), The security group sometimes goes 
overboard. Once we had to put a new oracle install on a new machine. We have an 
identical machine inside the firewall. We do our build there, 
tar,gzip,scp,gunzip,untar are the steps.
 
So when we requested the access (with certain steps be 
done by root), we got everything, except 
1. the ip for the machine
2. Firewall post for the machine
3. no user account on the machine for oracle 
owner
 
Security rocks ... eventually we gave them a detailed 
list and everything got fixed in an hour. We still laugh at it at times 
...
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  
  April Wells <[EMAIL PROTECTED]> wrote:
  

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 
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: example to use bind variables with OO4O/VB

2003-06-05 Thread Regis Biassala

go to your: 
(B%ORACLE_HOME%\oo4o\VB\SAMPLES
(B
(Bit has a lot of example which should help
(B
(BRegis
(B
(B-Original Message-
(BSent: Thursday, June 05, 2003 1:00 PM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BGuys,
(B
(Bcan someone give a simple example ( piece of code ) for:
(B
(BHow to use bind variables with OO40/VB6 to connect to a 8.1.6 database ?
(B
(B..peeped into metalink too.
(B
(Bcan u give me any other example / URL for the same ???!
(B
(BTIA.
(B
(BJp.
(B
(B
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Prem Khanna J
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).
(B*
(BThis electronic transmission is strictly confidential and intended solely
(Bfor the addressee. It may contain information which is covered by legal,
(Bprofessional or other privilege. If you are not the intended addressee,
(Byou must not disclose, copy or take any action in reliance of this
(Btransmission. If you have received this transmission in error, 
(Bplease notify the sender as soon as possible.
(B
(BThis footnote also confirms that this message has been swept
(Bfor computer viruses.
(B**
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Regis Biassala
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

Re: Create index script in pl/sql

2003-06-05 Thread rgaffuri

just put it in quotes and add execute immedite. you can also use concantenation and 
variables ot make it more dynamic.

declare

begin

execute immediate '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  PCTINCREASE  )';

end;

you could for instance do this.

proc makeIndex(p_indexName IN VARCHAR2) IS

begin 

execute immediate 'CREATE INDEX '||p_indexName||' ON
  ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
  TABLESPACE PBKIX PCTFREE 10  STORAGE(INITIAL 65536 NEXT  PCTINCREASE  )'

you will need to put close and opening quotes on each line and use || to concatenate 
together. you can do any type of SQL with execute immediate including Alter System and 
alter session commands. Its pretty robust. 


> 
> From: [EMAIL PROTECTED]
> Date: 2003/06/05 Thu AM 06:54:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Create index script in pl/sql
> 
> 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  PCTINCREASE  )
> ;
> 
> CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON
>   ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, ARTNR)
>   TABLESPACE PBKIX PCTFREE 10  STORAGE(INITIAL 65536 NEXT  PCTINCREASE  )
> 
> So the pl/sql procedur should create those 2 indexesd, how can I write the pl/sql 
> code then?
> 
> 
> Thanks in advance
> 
> 
> Roland
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: WARNING: Re: [suse-oracle] AIO trouble

2003-06-05 Thread Jeroen van Sluisdam

FYI

I got this with an interception of a worm tanatos-b virus and this virus
Is spreading out very fast because we got it from different sources
yesterday in just a couple of hours.

Jeroen

-Oorspronkelijk bericht-
Van: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] 
Verzonden: Thursday, June 05, 2003 22:55
Aan: Multiple recipients of list ORACLE-L
Onderwerp: WARNING: Re: [suse-oracle] AIO trouble

FYI -

When this message came in to me it had the PE_BUGBEAR.B virus.

Mike

-Original Message-
Sent: Thursday, June 05, 2003 11:07 AM
To: undisclosed-recipients

Michael Hasenstein wrote:

> Which SuSE Linux?

SLES 8

>
>
> Which kernel (run "rpm -q k_smp")?

k_smp-2.4.19-195

>
>
> What hardware?

2 Processor Xeon 2GHz
2 Gb RAM a this time

cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model  : 2
model 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Re[2]: performance questions

Title: RE: Re[2]: performance questions





Mark,


I do not think this thread is OT ... this is till very much on topic. I have been gaining so many views on SLA ... I love this topic.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Mark Richard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 05, 2003 3:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: performance questions




Jonathan,


Your comment "this is probably harder than it sounds" should be reworded to
"this IS harder than it sounds".  I've been involved in these bumfights
before and they are never pleasant, especially when a contract of
significant question is on the line (like a $3m / month performance bonus).


A simple example of re-negotiation is a batch system (system A) dependent
on data from another system (system B).  If the SLA says "system A will be
available by 7:00am each day" and system B starts delivering the data at
2:00am instead of midnight, then system A might try to renegotiate for a
new deadline.  Of course in reality the response will be "I don't care, you
just be complete by 7:00am still".


I think most times this point relates to an SLA which wasn't written
correctly and needs to be updated.  Say the SLA had a token query which
must execute from a clients desktop and return within 2 seconds.  Initially
the ping time between desktop and host was 20ms but something changed and
the ping is now 200ms.  Add in a few round trips and suddenly you've eaten
away the 2 seconds regardless of query execution time.  Did the original
SLA have a clause about ping time in it?  If not it probably should have,
but since we are only human it's easy to forget.  Of course the real trick
is to prove the degradation in network performance - who would ever keep
ping stats?


Alternatively an SLA might be based on a customer-base of 10,000 customers
and a company acquisition might mean the customer base will grow to 100,000
customers - this might trigger SLA re-negotiation depending on the wording
of the SLA and the generousity of the company.  It would be nice to think
that companies would be reasonable in this circumstance but sometimes it's
a battle.  I guess an intra-company SLA (where no money is typically on the
line) is easier to manage that one with a financial price attached.


Anyway I'll stop now - I think this has reached OT status for the Oracle
list and I'm not really the most qualified person to speak about this.  I'm
just the guy who has had to "prove it wasn't our fault".


Regards,
  Mark.



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Mailing List

2003-06-05 Thread Sameer Ghadge


 <> 
ODTUG-DEV2K-L - [EMAIL PROTECTED]
[EMAIL PROTECTED]



--- Begin Message ---
SUBSCRIBE ORACLE-L
--- End Message ---

Re: Re: Snapshot too old during stress test... how to avoid

2003-06-05 Thread rgaffuri

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 some brief queries. 
> 
> From: Tim Gorman <[EMAIL PROTECTED]>
> Date: 2003/06/05 Thu AM 03:25:36 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Snapshot too old during stress test... how to avoid
> 
> Speaking of this trick with a txn in each RBS, I've got a shell script on my
> website (http://www.evdbt.com/tools.htm) that does just that.  It is named
> "prevent1555.sh" which uses a stored procedure created by a SQL script named
> "prevent1555_ddl.sql"...
> 
> As Jared mentioned, it is kind of a last resort, but it works...
> 
> 
> 
> 
> on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> 
> > .. and if it still doesn't work, use the trick of putting a transaction
> > in
> > each of the rollback segments while the system is otherwise quiesced,
> > and *do not* commit or rollback the transactions.
> > 
> > This forces the rollbacks to extend if necessary, they will never wrap
> > back to the first extent ( actually the second) as long as those
> > transactions
> > are not committed.
> > 
> > It just uses a lot of disk space.  Disk is cheap, right?  :)
> > 
> > Consider offlining all your production RBS and creating temporary ones
> > that you can easily drop later.
> > 
> > I've used it with SAP client copies, which will not run to completion
> > without
> > doing this, at least on our system.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 06/04/2003 09:45 AM
> > Please respond to ORACLE-L
> > 
> > 
> >   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >   cc: 
> >   Subject:Re: Snapshot too old during stress test... how to avoid
> > 
> > 
> > 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 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
> >> 
> >> 
> >> To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> >> cc: 
> >> Subject:Snapshot too old during stress test... how to
> > avoid
> >> 
> >> 
> >> Im testing worst case scenarios right now. So Im doing batch
> >> updates,inserts,deletes and 'create table as' from a staging tablespace
> > of 
> >> approximately 5GBs to a master tablespace of approximately 11GBs.
> >> 
> >> Ive got my job queue processes set to 36 and Im running 36 at a time in
> >> the background in order to gather statistics and timing under worst case
> > 
> >> scenarios. 
> >> 
> >> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB
> > 
> >> for this test. I have 4 standard RBS with optimal size set to 1GB. Why
> >> would I get a snapshot too old? I would think that 11GBs of rollback
> > would 
> >> be big enough. Would increasing the number of Rollback segments avoid
> > this 
> >> even though I have the same amount of space in the tablespace?
> >> 
> >> In reality Im going to seriallize the process to avoid this and to
> > improve 
> >> performance, however, I want to stress the system.
> >> 
> >> any advice? 
> >> 
> >> -- 
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> -- 
> >> Author: <[EMAIL PROTECTED]
> >>   INET: [EMAIL PROTECTED]
> >> 
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> > http://calendar.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San

RE: Off-Topic (InstallShield Installation Problem)

2003-06-05 Thread Seefelt, Beth


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
Installer is unable to start. Ensure that the Windows Installer engine
has been installed properly.

but when i go to control panel/services/and try to start windows
installer, it gives me the message : Could not start windows installer
service on \\vsantosh. 

Any solutions will be highly appreciated.

Thanks and regards,
Santosh


 



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

example to use bind variables with OO4O/VB

2003-06-05 Thread Prem Khanna J

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: 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 and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Thanks --> Re: example to use bind variables with OO4O/VB

2003-06-05 Thread Prem Khanna J

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 and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Shite of the day

2003-06-05 Thread Boivin, Patrice J

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. 

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


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 Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Shite of the day
> 
> 
> 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 complete 
> and failed miserably at.  This is NOT giving me a warm fuzzy 
> about upgrading production. 
> 
> Lisa 
> (Can one more thing go wrong today?  Please?)
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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.
> ===
> 
> 
> -Original Message-
> Lisa
> Sent: Wednesday, June 04, 2003 10:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 9.0.2.0.0 incompatible with ORACLE version
> 8.1.7.0.0
> 
> So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
> altogether, and I get the same type of error.  It won't open at all. 
> 
> I tried initiating recovery.  This database is in noarc mode. 
>  It starts
> looking for arclogs that *do not* exist.  I also tried to 
> drop the redo
> log groups and recreate them.  Still, no dice. 
> 
> Again, unbreakable my FUNDAMENT.
> 
> So has anyone seen this before?  I opened a tar yesterday and promptly
> confused support. 
> 
> Lisa
> 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 7:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> "Trade SQL Server for Oracle9i Database and get up to 100% license
> credit 
> and peace of mind.
> 
> Tired of applying patches? Frustrated with managing mulitple database
> servers? 
> In the time it takes you to apply all Microsoft's patches to your
> servers, 
> you can successfully migrate your database to Oracle9i 
> Database and be 
> worry-free. "
> 
> 
> From 
> http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
> 462&Act=16
> 
> 
> I don't understand PR of Oracle. The RDBMS has so much 
> properties which
> are 
> much more better implemented in Oracle than in MS SQL and they choose 
> 'patching' which *** on both servers.
> 
> JP
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-

RE: FW: ora 1017 -solved

2003-06-05 Thread Richard Ji

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 sequence
that I forgot to create a synonym for.  If the PL/SQL stack trace
didn't bomb with ora-600 [17090], I would probably found it sooner.

Richard Ji

-Original Message-
Sent: Thursday, June 05, 2003 5:26 PM
To: [EMAIL PROTECTED]
Cc: Richard Ji
Importance: High


and what did you do to solve it?






"Richard Ji" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/05/2003 03:04 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:FW: ora 1017 -solved


Never mind, I solved.  Man, that error message is misleading. :)

>  -Original Message-
> From:  Richard Ji 
> Sent:  Thursday, June 05, 2003 4:46 PM
> To:Multiple recipients of list ORACLE-L (E-mail)
> Subject:   ora 1017
> 
> Hi,
> 
> I am accessing a table over database link, which I am able
> to select, insert, delete from etc.
> 
> Now I have a package locally that does insert, delete on that
> remote table but when I run the package, I get ora 1017. But
> from SQL*Plus I can do my select, insert, delete just fine.
> 
> If I drop the synonym and create a real table locally, everything
> works.
> 
> I also tried to do a PL/SQL stack trace and got an ora-600.
> 
> Any ideas?
> 
> Thanks
> 
> Richard 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Limiting Concurrent Sessions Not Working




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 DBAOracle Certified 8i DBA 

-Original Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 05, 2003 4:50 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working

Hi Dick, Thanks for the 
tip.  Metalink says the bug applies to RDBMS 8.0.4.  I tested it as 
well, using a modified version of their test case.  I did not encounter 
this bug at all.  
 
Perhaps it is OK on 
Oracle 7.3.4?
 

Sam 
Bootsma
George Brown 
College
[EMAIL PROTECTED]
416-415-5000 
x4933
 
-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 2003 4:15 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working
 

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 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:30 
PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working
Bingo!
 
Thanks 
Dick, it is working now.
 

Sam
GBC
 
-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 2003 2:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working
 

Do you 
have "resource_limit = true" in init.ora?  If you don't it defaults to 
FALSE & the profile has no effect.

 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 
-Original 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 2:10 
PMTo: Multiple recipients of 
list ORACLE-LSubject: Limiting 
Concurrent Sessions Not Working
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 to this profile) the user is not stopped from 
exceeding the number of concurrent sessions.  I tested this by connecting 
using Sql Plus.  I even tried bouncing the database, to see if that makes a 
difference, but to no avail.  
 
Any ideas what is happening?  
Am I missing something?  Is this a problem/bug with Oracle 7.3.4?  The 
output below shows the steps I followed to create the profile and user.  It 
also shows multiple connections to the database after bouncing the 
instance.
 
Thanks for any 
suggestions!
 
Sam.

 
 
SQL> create profile sam limit 
sessions_per_user 1;
 
Profile created.
 
SQL> create user sam identified 
by sam;
 
User created.
 
SQL> alter user sam profile 
sam;
 
User altered.
 
SQL> grant create session to 
sam;
 
Grant succeeded.
 
SQL> 
 
SQL> l
  1  select 
limit
  2  from 
dba_profiles
  3  where 
profile=''
  4* and resource_name = 
'SESSIONS_PER_USER'
SQL> /
 
LIMIT

1
 
SQL> 
 
SQL> select 
profile
  2  from 
dba_users
  3  where username = 
'SAM';
 
PROFILE
--
SAM
 
SQL>
 
SVRMGR> shutdown 
normal
Database closed.
Database 
dismounted.
ORACLE instance shut 
down.
 
SVRMGR> connect 
internal
Connected to an idle 
instance.
SVRMGR> startup
ORACLE instance 
started.
Total System Global 
Area  34122296 bytes
Fixed 
Size   
38992 bytes
Variable 
Size 
31797736 bytes
Database 
Buffers   
2252800 bytes
Redo 
Buffers 
32768 bytes
Database mounted.
Database opened.
SVRMGR> select osuser, 
username
 2> from 
v$session;   
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle  
SYS   

12 rows selected.
SVRMGR> select osuser, username 
from v$session;
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle

Create index script in pl/sql

2003-06-05 Thread roland . skoldblom

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  PCTINCREASE  )
;

CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON
  ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, ARTNR)
  TABLESPACE PBKIX PCTFREE 10  STORAGE(INITIAL 65536 NEXT  PCTINCREASE  )

So the pl/sql procedur should create those 2 indexesd, how can I write the pl/sql code 
then?


Thanks in advance


Roland



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Off-Topic (InstallShield Installation Problem)

2003-06-05 Thread Santosh Varma




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 Installer is unable 
to start. Ensure that the Windows Installer engine has been installed 
properly.
 
but when i go to 
control panel/services/and try to start windows installer, it gives me the 
message : Could not start windows installer service on \\vsantosh. 
 
Any solutions will 
be highly appreciated.
 
Thanks and 
regards,
Santosh

RE: MS Access 97 to Oracle 8.1.7 Scheduler

2003-06-05 Thread Seefelt, Beth


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

-Original Message-
Sent: Thursday, June 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Gurus,

We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package. 

Please share your experience in this regard and let me
know what could be the best method to automate loading
data from MS Access 97 to Oracle 8.1.7.

Thank,
Bob

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cost info in Explain Plan

2003-06-05 Thread Eric Mortensen

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

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 Mortensen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Mark Leith

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 mean I hafta update it AGAIN?

:)

--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> And thanks for the note recommendation Dennis...
> 
> There's too many of these bullets flying around. Need a short list
> called: "Things you should know that Oracle doesn't tell you straight
> out." 
> 
> Of course there's the bug list but who has time for that and can
> remember it all? Sigh...
> 
> 
> Steve
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 4:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 4:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 3:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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: Wednesday, June 04, 2003 12:46 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 dij` vu ceci.
> 
> : )
> 
> Patrice.
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 3:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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 problem. And my peeve is that it
> took
> OWS 4 days to "discover" this "limit."
> 
> 
> Still peeved,  :-)
> Steve
> 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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
> didn't tell me this until after about 4 days of back and forth
> testing for
> them. (There is no such O/S file size limit.) I've reviewed the Linux
> release notes, the Linux install guide, the Linux admin guide and the
> contents of $ORACLE_HOME/relnotes and I don't find any such
> limitation in
> the documentation. Did I miss it? Can anyone find any such published
> limitation in the docs? Is this a secret?
> >
> >
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego,

Cost info in Explain Plan

2003-06-05 Thread Eric Mortensen

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 Mortensen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9.2.0.3 online index builds resolved (we hope)

2003-06-05 Thread Hallas, John, Tech Dev

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 that this causes the index rebuild to take longer than it did with with a 
(Bhigher MBRC on 8.1.7.4 - is that true ?
(B
(BJust trying to determine the extent of this issue
(B
(BJohn
(B
(B-Original Message-
(BSent: 03 June 2003 18:05
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(B
(BWell folks, there IS an issue with online index builds in 9.2.0.3.  Not only
(Bhave we experienced "normal" SQL getting blocked, but we have seen index
(Bbuilds hang indefinitely -- while holding the blocking lock (of course!).
(BThe work around is (we hope):
(B
(Balter session set db_file_multiblock_read_count=1;
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Stephen Lee
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Hallas, John, Tech Dev
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

Re: Snapshot too old during stress test... how to avoid

2003-06-05 Thread Tim Gorman

Speaking of this trick with a txn in each RBS, I've got a shell script on my
website (http://www.evdbt.com/tools.htm) that does just that.  It is named
"prevent1555.sh" which uses a stored procedure created by a SQL script named
"prevent1555_ddl.sql"...

As Jared mentioned, it is kind of a last resort, but it works...




on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:

> .. and if it still doesn't work, use the trick of putting a transaction
> in
> each of the rollback segments while the system is otherwise quiesced,
> and *do not* commit or rollback the transactions.
> 
> This forces the rollbacks to extend if necessary, they will never wrap
> back to the first extent ( actually the second) as long as those
> transactions
> are not committed.
> 
> It just uses a lot of disk space.  Disk is cheap, right?  :)
> 
> Consider offlining all your production RBS and creating temporary ones
> that you can easily drop later.
> 
> I've used it with SAP client copies, which will not run to completion
> without
> doing this, at least on our system.
> 
> Jared
> 
> 
> 
> 
> 
> Kirtikumar Deshpande <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/04/2003 09:45 AM
> Please respond to ORACLE-L
> 
> 
>   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   cc: 
>   Subject:Re: Snapshot too old during stress test... how to avoid
> 
> 
> 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 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
>> 
>> 
>> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
>> cc: 
>> Subject:Snapshot too old during stress test... how to
> avoid
>> 
>> 
>> Im testing worst case scenarios right now. So Im doing batch
>> updates,inserts,deletes and 'create table as' from a staging tablespace
> of 
>> approximately 5GBs to a master tablespace of approximately 11GBs.
>> 
>> Ive got my job queue processes set to 36 and Im running 36 at a time in
>> the background in order to gather statistics and timing under worst case
> 
>> scenarios. 
>> 
>> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB
> 
>> for this test. I have 4 standard RBS with optimal size set to 1GB. Why
>> would I get a snapshot too old? I would think that 11GBs of rollback
> would 
>> be big enough. Would increasing the number of Rollback segments avoid
> this 
>> even though I have the same amount of space in the tablespace?
>> 
>> In reality Im going to seriallize the process to avoid this and to
> improve 
>> performance, however, I want to stress the system.
>> 
>> any advice? 
>> 
>> -- 
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> -- 
>> Author: <[EMAIL PROTECTED]
>>   INET: [EMAIL PROTECTED]
>> 
> 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Re[2]: performance questions

2003-06-05 Thread Mark Richard


Jonathan,

Your comment "this is probably harder than it sounds" should be reworded to
"this IS harder than it sounds".  I've been involved in these bumfights
before and they are never pleasant, especially when a contract of
significant question is on the line (like a $3m / month performance bonus).

A simple example of re-negotiation is a batch system (system A) dependent
on data from another system (system B).  If the SLA says "system A will be
available by 7:00am each day" and system B starts delivering the data at
2:00am instead of midnight, then system A might try to renegotiate for a
new deadline.  Of course in reality the response will be "I don't care, you
just be complete by 7:00am still".

I think most times this point relates to an SLA which wasn't written
correctly and needs to be updated.  Say the SLA had a token query which
must execute from a clients desktop and return within 2 seconds.  Initially
the ping time between desktop and host was 20ms but something changed and
the ping is now 200ms.  Add in a few round trips and suddenly you've eaten
away the 2 seconds regardless of query execution time.  Did the original
SLA have a clause about ping time in it?  If not it probably should have,
but since we are only human it's easy to forget.  Of course the real trick
is to prove the degradation in network performance - who would ever keep
ping stats?

Alternatively an SLA might be based on a customer-base of 10,000 customers
and a company acquisition might mean the customer base will grow to 100,000
customers - this might trigger SLA re-negotiation depending on the wording
of the SLA and the generousity of the company.  It would be nice to think
that companies would be reasonable in this circumstance but sometimes it's
a battle.  I guess an intra-company SLA (where no money is typically on the
line) is easier to manage that one with a financial price attached.

Anyway I'll stop now - I think this has reached OT status for the Oracle
list and I'm not really the most qualified person to speak about this.  I'm
just the guy who has had to "prove it wasn't our fault".

Regards,
  Mark.




   
   
  Jonathan Gennick 
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  .com>cc: 
   
  Sent by: Subject:  Re[2]: performance questions  
   
  [EMAIL PROTECTED]

   
   
   
   
  05/06/2003 05:35 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




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 something
that makes it impossible for the service-provider to
maintain the SLA?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

RE: Sum of Previous Record

2003-06-05 Thread Walid Alkaakati


Thanks  All ,

I solved the problem as follows :


 I defined a  sum  summary column on same group  with   the reset  on group
above it,the to add balance brought forward i
used  the   first   summary  function to add balance brought forward to
the first record.

Bay .


-- 
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 web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:StoredProc SQL statistics

2003-06-05 Thread sam d

Thanks a lot everyone.
I will start working on these things.

Regards
Sam
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L


>Hi People,
>Is there any way to find the statistics(like tkprof
>
>gives) of SQL's within storedproc , when storedrpoc
>is
>called.
>
>Basically I want to find culprit SQL within
>StoredProc.
>
>
>Any help is appreciated
>Regards
>Sam 
>

x$kglrd, x$kglcursor, sys.obj$, x$kgldp and
sys.dependency$ ...
I don't have the details here, so I let you work it
out :-).
The first three will let you find out by what a
statement (from V$SQL) is fired, which is probably
what you need.
If x$kglnaown is null in x$kglrd, the row refers to a
PL/SQL block (command type 47 in V$SQL) and you find
the corresponding (address, hash_value) in
x$kglcursor. Otherwise, it refers to the
x$glnaown.x$kglcnam stored object.
All this out of memory (you are lucky I was into this
not long ago), so it's not guaranteed to be flawless
but it should get you started.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
-
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from).  You may
also send the HELP command for other information (like
subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sam d
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Those installing Oracle 9i on AIX 5.2L

Oh, Well.. Use this link for AIX man pages... 
http://publib.boulder.ibm.com/cgi-bin/ds_rslt?lang=en_US&viewset=AIX&view=Commands
- Kirti 
 
April Wells <[EMAIL PROTECTED]> wrote:


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 will suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~ 
-Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 04, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Those installing Oracle 9i on AIX 5.2L 
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 .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 when you come upon it, because you will > suddenly have all the energy and imagination you will ever need. > > ~ Jerry Gillies ~ > > -Original Message- > Sent: Wednesday, June 04, !
2003 1:51 PM > To: Multiple recipients of list ORACLE-L > > > 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, it installed for me without error. >  > Ruth > > - Original Message - > To: Multiple recipients of list ORACLE-L   > Sent: Monday, June 02, 2003 8:39!
 AM > > > Hi all, > > If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you > have a list of APARS that _must_ be installed? > > I am talking about regatta (p690) servers if that matters ... > > Thanks in advance > Raj >  > 
__ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com San Diego, California    -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). 



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

Re: Shite of the day (now 9i upgrade)

2003-06-05 Thread Binley Lim

It is worry-free if you follow the upgrade instructions, and not skip around
like you appear to have done.

Did you run u0801070.sql at all? Did you check for any errors it might have
produced? Both your errors indicate there was a problem in that area.

Where did you dig COMPATIBLE = 9.0.2 from? There's no such release. Mere
details, but details are important in a manual upgrade.

If you decide to back-down COMPATIBLE to 8.1.7, did you run the downgrade
script, check the outputs and follow the instructions? You need to do the
following in order:

- run the downgrade script and follow the instructions
- run "alter database reset compatibility;" (OK, this bit is not that
obvious in the documentation)
- modify init.ora and restart

If the database is in noarchivelog, isn't it reasonable that archivelogs do
not exist? As for dropping redologs, k!

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 2:40 AM


> 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 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0
>
> So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
altogether, and I get the same type of error.  It won't open at all.
>
> I tried initiating recovery.  This database is in noarc mode.  It starts
looking for arclogs that *do not* exist.  I also tried to drop the redo log
groups and recreate them.  Still, no dice.
>
> Again, unbreakable my FUNDAMENT.
>
> So has anyone seen this before?  I opened a tar yesterday and promptly
confused support.
>
> Lisa


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Binley Lim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Babette Turner-Underwood

Woohoo!! Us OS/390ers have it made !
 actually in 9i they started allowing files to autoextend but I am not
sure how they do it... On OS/390 you still cannot shrink a datafile.

- Babette

-Original Message-
WILLIAMS
Sent: Wednesday, June 04, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') a

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Rachel Carmichael

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 mean I hafta update it AGAIN?

:)

--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> And thanks for the note recommendation Dennis...
> 
> There's too many of these bullets flying around. Need a short list
> called: "Things you should know that Oracle doesn't tell you straight
> out." 
> 
> Of course there's the bug list but who has time for that and can
> remember it all? Sigh...
> 
> 
> Steve
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 4:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 4:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 3:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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: Wednesday, June 04, 2003 12:46 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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 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 problem. And my peeve is that it
> took
> OWS 4 days to "discover" this "limit."
> 
> 
> Still peeved,  :-)
> Steve
> 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 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
> didn't tell me this until after about 4 days of back and forth
> testing for
> them. (There is no such O/S file size limit.) I've reviewed the Linux
> release notes, the Linux install guide, the Linux admin guide and the
> contents of $ORACLE_HOME/relnotes and I don't find any such
> limitation in
> the documentation. Did I miss it? Can anyone find any such published
> limitation in the docs? Is this a secret?
> >
> >
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REM

FW: virtual computer museum

2003-06-05 Thread Jacques Kilchoer

Title: FW: virtual computer museum





Why go to Bozeman when I've just stepped through the virtual tour? :)
Very nice. Are you getting ready to donate the old Sinclair ZX80 that's sitting in your attic?


> -Original Message-
> From: Orr, Steve [mailto:[EMAIL PROTECTED]]
> 
> Forget the virtual computer museum, just come to Bozeman. 
> Check it out at: http://www.compustory.com/index.html
> 
> Steve Orr from guess where...

RE: Chris: Thank you!

2003-06-05 Thread Jacques Kilchoer

Title: RE: Chris: Thank you!





Haven't you seen The Matrix? The "leading edge PC" can be a virtual PC emulated on an IBM AIX machine. The floppy disk will be a virtual floppy disk emulated on a USB keychain disk drive. etc.

(Aside: how many of the posters on the list are actually software constructs? Come on, be honest.)


> -Original Message-
> From: Niall Litchfield [mailto:[EMAIL PROTECTED]]
> 
> 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 source code library and a set of emulators of each
> architecture that is preserved.

RE: Shite of the day

2003-06-05 Thread Jacques Kilchoer

Title: RE: Shite of the day





I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2?

I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out.

> -Original Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
> 
> 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. 
> 
> -Original Message-
> 
> Lisa, when you say you "manually" migrated, did you use 
> exp/imp after a
> fresh CREATE DATABASE in 9i?  Also, what platform?  32-bit?
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -Original Message-
> > Lisa
> > 
> > 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

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

And thanks for the note recommendation Dennis...

There's too many of these bullets flying around. Need a short list called: "Things you 
should know that Oracle doesn't tell you straight out." 

Of course there's the bug list but who has time for that and can remember it all? 
Sigh...


Steve


-Original Message-
Sent: Wednesday, June 04, 2003 4:40 PM
To: Multiple recipients of list ORACLE-L


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
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


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 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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Jared . Still

That's 2.5 MB per second, which ain't bad on what I assume is 10m 
ethernet.

If it's on 100MB or 1G ethernet, then it's rather slow.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 06/03/2003 06:50 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Good technical documents/references on tuning restores


Okay, almost 4 minutes for a datafile that was 78168 blocks - how do I 
know if this is reasonable? 
Also, seems to write these files out (restore sychron.) why can't it 
restore different datafiles in parallel?  - stupid question huh?
-Original Message- 
Sent: Tuesday, June 03, 2003 8:46 PM 
To: Stankus, Paula G; '[EMAIL PROTECTED]' 

SELECT SID, SERIAL#, CONTEXT, 
 ROUND(SOFAR/TOTALWORK*100,2) "% complete", 
SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) "Time now" 
FROM V$SESSION_LONGOPS 
WHERE OPNAME like '%restore%'; 
. 
showed all 100% complete but msglog from RMAN shows it is truly still 
running. 
-Original Message- 
Sent: Tuesday, June 03, 2003 8:40 PM 
To: Stankus, Paula G; '[EMAIL PROTECTED]' 

Also found on monitoring performance of RMAN jobs: 
Note:144640.1 on Metalink 
-Original Message- 
Sent: Tuesday, June 03, 2003 8:36 PM 
To: Stankus, Paula G; '[EMAIL PROTECTED]' 

Found this white paper: 
http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf 
Anything better? 
-Original Message- 
Sent: Tuesday, June 03, 2003 8:33 PM 
To: Stankus, Paula G; '[EMAIL PROTECTED]' 

This is what I have set on my target database: 
--- --- --- 
backup_tape_io_slaves   boolean FALSE 
tape_asynch_io  boolean TRUE 
Version 8.1.7.4 database and RMAN catalog - 32 bit 
Networker MML 
Using RAID 1+0 
Solaris 2.8 
-Original Message- 
Sent: Tuesday, June 03, 2003 8:28 PM 
To: Stankus, Paula G; '[EMAIL PROTECTED]' 

Okay - from my reading you don't need to have multiple tape io slaves if 
you are using asynch. I/O.  Again, best document for perf. tuning database 
restores using RMAN would make mucho difference.  Read old note about 
someone doing an analyze on the RMAN catalog tables to improve performance 
of restore.  I think it has something to do with how quickly it finds the 
file on tape and writes to disk. 
-Original Message- 
Sent: Tuesday, June 03, 2003 8:25 PM 
To: '[EMAIL PROTECTED]' 

Seems to be taking awfully long to read files from tape and write to disk. 
 I allocate multiple tape channels like I do for the backup which only 
takes about 45 minutes.  Does not seem to be spawning multiple sessions. 
Do I need to change parameters on my init.ora file to use multiple tape io 
slaves to see this. Anyway, would like notes/docs., references if you all 
have some.
Thanks, 
Paula 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Snapshot too old during stress test... how to avoid

2003-06-05 Thread Jared . Still

... and if it still doesn't work, use the trick of putting a transaction 
in
each of the rollback segments while the system is otherwise quiesced,
and *do not* commit or rollback the transactions.

This forces the rollbacks to extend if necessary, they will never wrap
back to the first extent ( actually the second) as long as those 
transactions
are not committed.

It just uses a lot of disk space.  Disk is cheap, right?  :) 

Consider offlining all your production RBS and creating temporary ones
that you can easily drop later.

I've used it with SAP client copies, which will not run to completion 
without
doing this, at least on our system.

Jared

Kirtikumar Deshpande <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/04/2003 09:45 AM
 Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Snapshot too old during stress test... how to avoid

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 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
> 
> 
> To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
> cc: 
> Subject:Snapshot too old during stress test... how to 
avoid
> 
> 
> Im testing worst case scenarios right now. So Im doing batch 
> updates,inserts,deletes and 'create table as' from a staging tablespace 
of 
> approximately 5GBs to a master tablespace of approximately 11GBs.
> 
> Ive got my job queue processes set to 36 and Im running 36 at a time in 
> the background in order to gather statistics and timing under worst case 

> scenarios. 
> 
> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB 

> for this test. I have 4 standard RBS with optimal size set to 1GB. Why 
> would I get a snapshot too old? I would think that 11GBs of rollback 
would 
> be big enough. Would increasing the number of Rollback segments avoid 
this 
> even though I have the same amount of space in the tablespace? 
> 
> In reality Im going to seriallize the process to avoid this and to 
improve 
> performance, however, I want to stress the system.
> 
> any advice? 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Interesting!

2003-06-05 Thread Jared . Still

In addition, it's very easy to expose those hidden functions/procedures
in a package by simply declaring them in the header.  This can be useful
for testing and debugging.

You can't do that with a stored procedure/function/plsql block.

Jared






"Igor Neyman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/04/2003 10:40 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Interesting!


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 " will not show
"private" procedures/functions.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Jahnke
Sent: Wednesday, June 04, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L

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 package declaration. 
And yes, I am aware of the fact that it only makes sense with procs,
funcs
that 
you only want to use from within the scope of the proc/func you define
them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


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 into a very annoying variable scope issue.  Of
course
after spending hours debugging the code, I realized I should have taken
the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember
the
actual error I encountered.  It probably had nothing or very little to
do
with my nested procedures, but in my mind I can't consider this to be a
good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
a

RE: virtual computer museum

Forget the virtual computer museum, just come to Bozeman. 
Check it out at: http://www.compustory.com/index.html

Steve Orr from guess where...



-Original Message-
Sent: Wednesday, June 04, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L


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 source code library and a set of emulators of each
architecture that is preserved. 

Niall

Who can't believe that he used the word architecture, despite despising
it it deeply and
Who moved the last 6.0.36 db we have to MS Access earlier this year :( 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Jeremiah Wilton
> Sent: 04 June 2003 14:35
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Chris: Thank you!
> 
> 
> 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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Interesting!

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
> Subject: RE: Interesting!
> 
> 
> 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 into a very annoying 
> variable scope issue.  Of course after spending hours 
> debugging the code, I realized I should have taken the advice 
> of our DBA, the infamous Jared Still, and just used a 
> package.  I have since looked askew at the nesting of 
> procedures.  I can't remember the actual error I encountered. 
>  It probably had nothing or very little to do with my nested 
> procedures, but in my mind I can't consider this to be a good 
> practice.  A package does the same job, and so much cleaner.
> 
> P.S.  I think this was the first time I noted Jared's 
> annoying habit of being right
> 
> 
> Steve McClure
> 
> -Original Message-
> Waleed
> Sent: Tuesday, June 03, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I've just discovered this, never thought if it was possible 
> or not. Just wanted to share it with you, so forgive me if 
> you know it already. Procedure can contain other procedures:
> 
> create or replace procedure test_test1 as
> procedure test_test2 as
> begin
>  dbms_output.put_line('hello2');
>  end;
> function c1 ( p1 in number) return number as
> begin
>  return(p1 * 2);
> end;
> begin
>   dbms_output.put_line('hello1');
>   test_test2;
>   dbms_output.put_line( c1(10));
> end;
> 
> Regards,
> 
> Waleed
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Steve McClure
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


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 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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please

RE: Benchmarking of ASP.NET with Oracle v/s MSSQL

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 done performance benchmarking of a typical ASP.NET 
> application with IIS(or any web server) with Oracle 
> database(9.2) v/s MS SQL Server.(Latest version)  
> Any pointers for the same is most appreciated. If there is 
> any document on which POC has been done, plz mail to my id. 
> FYI: 80% of the transactions are DB intensive. So, any 
> guidelines for the same will be useful to me. 
> 
> Thanks !
> 
> Regards,
> Satya Prakash
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Satya Prakash Viswanath
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Those installing Oracle 9i on AIX 5.2L

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 will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~

-Original Message-
From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Those installing Oracle 9i on AIX 5.2L

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 .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 when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
> 
> ~ Jerry Gillies ~ 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 1:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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, it installed for me without error.
>  
> Ruth
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L   
> Sent: Monday, June 02, 2003 8:39 AM
> 
> 
> Hi all, 
> 
> If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you
> have a list of APARS that _must_ be installed? 
> 
> I am talking about regatta (p690) servers if that matters ... 
> 
> Thanks in advance 
> Raj 
> 
>

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa

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


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 Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Shite of the day
> 
> 
> 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 complete 
> and failed miserably at.  This is NOT giving me a warm fuzzy 
> about upgrading production. 
> 
> Lisa 
> (Can one more thing go wrong today?  Please?)
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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.
> ===
> 
> 
> -Original Message-
> Lisa
> Sent: Wednesday, June 04, 2003 10:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 9.0.2.0.0 incompatible with ORACLE version
> 8.1.7.0.0
> 
> So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
> altogether, and I get the same type of error.  It won't open at all. 
> 
> I tried initiating recovery.  This database is in noarc mode. 
>  It starts
> looking for arclogs that *do not* exist.  I also tried to 
> drop the redo
> log groups and recreate them.  Still, no dice. 
> 
> Again, unbreakable my FUNDAMENT.
> 
> So has anyone seen this before?  I opened a tar yesterday and promptly
> confused support. 
> 
> Lisa
> 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 7:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> "Trade SQL Server for Oracle9i Database and get up to 100% license
> credit 
> and peace of mind.
> 
> Tired of applying patches? Frustrated with managing mulitple database
> servers? 
> In the time it takes you to apply all Microsoft's patches to your
> servers, 
> you can successfully migrate your database to Oracle9i 
> Database and be 
> worry-free. "
> 
> 
> From 
> http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
> 462&Act=16
> 
> 
> I don't understand PR of Oracle. The RDBMS has so much 
> properties which
> are 
> much more better implemented in Oracle than in MS SQL and they choose 
> 'patching' which *** on both servers.
> 
> JP
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Shit of the day

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] On Behalf Of 
> Jan Pruner
> Sent: 04 June 2003 12:45
> To: Multiple recipients of list ORACLE-L
> Subject: Shit of the day
> 
> 
> "Trade SQL Server for Oracle9i Database and get up to 100% 
> license credit 
> and peace of mind.
> 
> Tired of applying patches? Frustrated with managing mulitple 
> database servers? 
> In the time it takes you to apply all Microsoft's patches to 
> your servers, 
> you can successfully migrate your database to Oracle9i 
> Database and be 
> worry-free. "
> 
> 
> From 
> http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
462&Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Chris: Thank you!

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 source code library and a set of emulators of each
architecture that is preserved. 

Niall

Who can't believe that he used the word architecture, despite despising
it it deeply and
Who moved the last 6.0.36 db we have to MS Access earlier this year :( 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Jeremiah Wilton
> Sent: 04 June 2003 14:35
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Chris: Thank you!
> 
> 
> 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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: get hit ration

Title: Message



A 
library cache hit means 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 wish to improve the 
ratio of one to the other by allocating some memory that could be used for 
something else to the library cache (located in the shared pool), then go right 
ahead. 
 
On the 
other hand you might have a real performance problem (my report runs for 1.5 
hours and it only used to run for 3 minutes),  these sorts of problems 
generally have a different underlying cause than finding objects in memory 
rather than on disk, 80 % of the time or thereabouts its the sql, 10% or there 
abouts its the data. 
 

Niall 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: 03 June 2003 
  17:35To: Multiple recipients of list ORACLE-LSubject: 
  get hit ration
  found that gethitratio in v$librarycahce is very 
  low for indexes. what does it mean ? is there any way to improve this 
  .
   
  thanks,
  -ak

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, in

Problem using CLOB with ADO

2003-06-05 Thread Yadav, Shailesh

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 transactions as
per Oracle documentation and noticed that triggers were firing each time the
clob was updated. The problem seems to be that Oracle submits the changes to
clob(when using serverside cursors in application) immediately and also
fires the trigger on that row if the. 
The work around was to initialize clobs when the record was inserted and
thus the trigger fired only once. 
However the problem now is that if an error is raised by a trigger with a
CLOB. the application get the error "ROW-00060: Internal error:
[daputchunk,2]". Has anyone ever come across this problem. Any insight would
be highy appreciated.

thanks,
Shailesh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yadav, Shailesh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F

RE: Limiting Concurrent Sessions Not Working




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 Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:30 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working

Bingo!
 
Thanks Dick, it is 
working now.
 

Sam
GBC
 
-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 
2003 2:30 
PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working
 

Do you 
have "resource_limit = true" in init.ora?  If you don't it defaults to 
FALSE & the profile has no effect.

 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 
-Original 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 2:10 
PMTo: Multiple recipients of 
list ORACLE-LSubject: Limiting 
Concurrent Sessions Not Working
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 to this profile) the user is not stopped from 
exceeding the number of concurrent sessions.  I tested this by connecting 
using Sql Plus.  I even tried bouncing the database, to see if that makes a 
difference, but to no avail.  
 
Any ideas what is happening?  
Am I missing something?  Is this a problem/bug with Oracle 7.3.4?  The 
output below shows the steps I followed to create the profile and user.  It 
also shows multiple connections to the database after bouncing the 
instance.
 
Thanks for any 
suggestions!
 
Sam.

 
 
SQL> create profile sam limit 
sessions_per_user 1;
 
Profile created.
 
SQL> create user sam identified 
by sam;
 
User created.
 
SQL> alter user sam profile 
sam;
 
User altered.
 
SQL> grant create session to 
sam;
 
Grant succeeded.
 
SQL> 
 
SQL> l
  1  select 
limit
  2  from 
dba_profiles
  3  where 
profile=''
  4* and resource_name = 
'SESSIONS_PER_USER'
SQL> /
 
LIMIT

1
 
SQL> 
 
SQL> select 
profile
  2  from 
dba_users
  3  where username = 
'SAM';
 
PROFILE
--
SAM
 
SQL>
 
SVRMGR> shutdown 
normal
Database closed.
Database 
dismounted.
ORACLE instance shut 
down.
 
SVRMGR> connect 
internal
Connected to an idle 
instance.
SVRMGR> startup
ORACLE instance 
started.
Total System Global 
Area  34122296 bytes
Fixed 
Size   
38992 bytes
Variable 
Size 
31797736 bytes
Database 
Buffers   
2252800 bytes
Redo 
Buffers 
32768 bytes
Database mounted.
Database opened.
SVRMGR> select osuser, 
username
 2> from 
v$session;   
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle  
SYS   

12 rows selected.
SVRMGR> select osuser, username 
from v$session;
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle    

oracle    

oracle    

oracle 
   
oracle    

oracle    

oracle    

oracle    

oracle  
  
oracle  
SYS   

sam    
 SAM   

sam   
  SAM   

14 rows selected.
SVRMGR>
 
Sam 
GBC

RE: Those installing Oracle 9i on AIX 5.2L

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 .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 when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
> 
> ~ Jerry Gillies ~ 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 1:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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, it installed for me without error.
>  
> Ruth
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L   
> Sent: Monday, June 02, 2003 8:39 AM
> 
> 
> Hi all, 
> 
> If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you
> have a list of APARS that _must_ be installed? 
> 
> I am talking about regatta (p690) servers if that matters ... 
> 
> Thanks in advance 
> Raj 
> 
>

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Matthew Zito

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 one, plus that 8.1.7 is the
terminal release for 8i and they're tired of getting flack from Oracle
support.
Thanks,
Matt
--Matthew ZitoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent:
Wednesday, June 04, 2003 2:30 PMTo: Multiple recipients of list
ORACLE-LSubject: 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,
because you will suddenly have all the energy and imagination you will ever
need.
~ Jerry Gillies ~
-Original Message- From: Orr,
Steve [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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
workarounds suggested by Oracle were: 1) turn off autoextend and manually add
datafiles; 2) upgrade to 9i.
-Original Message- Sent:
Wednesday, June 04, 2003 12:10 PM To: Multiple
recipients of list ORACLE-L
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 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 problem. And my peeve is that it
took OWS 4 days to "discover" this "limit."

Still peeved, :-) Steve

-Original Message- Sent:
Wednesday, June 04, 2003 10:55 AM To: Multiple
recipients of list ORACLE-L
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
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 didn't tell me this until after about 4
days of back and forth testing for them. (There is no
such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and
the contents of $ORACLE_HOME/relnotes and I don't find
any such limitation in the documentation. Did I miss
it? Can anyone find any such published limitation in
the docs? Is this a secret? > > > Peeved at Oracle... AGAIN,
> Steve Orr > --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- > Author: Orr,
Steve > INET: [EMAIL PROTECTED]
> > Fat City Network
Services -- 858-538-5051 http://www.fatcity.com > San
Diego, California -- Mailing list
and web hosting services >
-
> To REMOVE yourself from this mailing list, send an
E-Mail message > to: [EMAIL PROTECTED] (note
EXACT spelling of 'ListGuru') and in > the message
BODY, include a line containing: UNSUB ORACLE-L >
(or the name of mailing list you want to be removed from). You
may > also send the HELP command for other
information (like subscribing). >
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message B

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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% 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTE

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???



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 workarounds suggested by Oracle were: 1) turn off autoextend and manually add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L



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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."



Still peeved,  :-)
Steve




-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L



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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thoma

RE: ??? Linux/Oracle 8.1.7 2GB file size 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 ORACLE-L


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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

RE: Limiting Concurrent Sessions Not Working

2003-06-05 Thread Sam Bootsma










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 = true" in init.ora?  If you don't it
defaults to FALSE & the profile has no effect.





 



Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
From: Sam Bootsma
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003
2:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: Limiting Concurrent
Sessions Not Working

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 to this profile) the user is not stopped from exceeding the
number of concurrent sessions.  I tested this by connecting using Sql
Plus.  I even tried bouncing the database, to see if that makes a
difference, but to no avail.  

 

Any ideas what is happening? 
Am I missing something?  Is this a problem/bug with Oracle 7.3.4? 
The output below shows the steps I followed to create the profile and
user.  It also shows multiple connections to the database after bouncing
the instance.

 

Thanks for any suggestions!

 

Sam.



 



 

SQL> create profile sam limit
sessions_per_user 1;

 

Profile created.

 

SQL> create user sam identified
by sam;

 

User created.

 

SQL> alter user sam profile sam;

 

User altered.

 

SQL> grant create session to sam;

 

Grant succeeded.

 

SQL> 

 

SQL> l

  1  select limit

  2  from dba_profiles

  3  where profile=''

  4* and resource_name =
'SESSIONS_PER_USER'

SQL> /

 

LIMIT



1

 

SQL> 

 

SQL> select profile

  2  from dba_users

  3  where username =
'SAM';

 

PROFILE

--

SAM

 

SQL>

 

SVRMGR> shutdown normal

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SVRMGR> connect internal

Connected to an idle instance.

SVRMGR> startup

ORACLE instance started.

Total System Global
Area  34122296 bytes

Fixed
Size  
38992 bytes

Variable
Size
31797736 bytes

Database
Buffers  
2252800 bytes

Redo
Buffers
32768 bytes

Database mounted.

Database opened.

SVRMGR> select osuser, username

 2> from
v$session;   

OSUSER 
USERNAME 


---
--

oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle 
SYS  


12 rows selected.

SVRMGR> select osuser, username
from v$session;

OSUSER 
USERNAME 


---
--

oracle   


oracle   


oracle   


oracle   


oracle   


oracle
   

oracle   


oracle   


oracle   


oracle   


oracle 
  

oracle 
SYS  


sam   
 SAM  


sam  
  SAM  


14 rows selected.

SVRMGR>

 

Sam 

GBC

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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

-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 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
workarounds suggested by Oracle were: 1) turn off autoextend and manually
add datafiles; 2) upgrade to 9i.

-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L

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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."

Still peeved,  :-)
Steve

-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L

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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

Re[2]: performance questions

2003-06-05 Thread Jonathan Gennick

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 something
that makes it impossible for the service-provider to
maintain the SLA?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Mercadante, Thomas F

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 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
workarounds suggested by Oracle were: 1) turn off autoextend and manually
add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Those installing Oracle 9i on AIX 5.2L

Title: Those installing Oracle 9i on AIX 5.2L



I got several "can't write to .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 when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  1:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: 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, it installed for me 
  without error.
   
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Those installing Oracle 9i on AIX 5.2L

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
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  2:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: 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, it installed for me 
  without error.
   
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Those installing Oracle 9i on AIX 5.2L

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 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  1:42 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: 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 thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
  Application Development Math Library(bos.adt.libm) is not installed by 
  default.-Claus
   
  Hope this helps!  
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 workarounds suggested by Oracle were: 1) turn 
off autoextend and manually add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq

RE: Those installing Oracle 9i on AIX 5.2L

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 
can have facts, having an opinion is an art ! 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  2:42 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: 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 thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
  Application Development Math Library(bos.adt.libm) is not installed by 
  default.-Claus
   
  Hope this helps!  
  Ruth
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Shite of the day

2003-06-05 Thread Jesse, Rich

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 Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Shite of the day
> 
> 
> 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 complete 
> and failed miserably at.  This is NOT giving me a warm fuzzy 
> about upgrading production. 
> 
> Lisa 
> (Can one more thing go wrong today?  Please?)
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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.
> ===
> 
> 
> -Original Message-
> Lisa
> Sent: Wednesday, June 04, 2003 10:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 9.0.2.0.0 incompatible with ORACLE version
> 8.1.7.0.0
> 
> So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
> altogether, and I get the same type of error.  It won't open at all. 
> 
> I tried initiating recovery.  This database is in noarc mode. 
>  It starts
> looking for arclogs that *do not* exist.  I also tried to 
> drop the redo
> log groups and recreate them.  Still, no dice. 
> 
> Again, unbreakable my FUNDAMENT.
> 
> So has anyone seen this before?  I opened a tar yesterday and promptly
> confused support. 
> 
> Lisa
> 
> 
> 
> -Original Message-
> Sent: Wednesday, June 04, 2003 7:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> "Trade SQL Server for Oracle9i Database and get up to 100% license
> credit 
> and peace of mind.
> 
> Tired of applying patches? Frustrated with managing mulitple database
> servers? 
> In the time it takes you to apply all Microsoft's patches to your
> servers, 
> you can successfully migrate your database to Oracle9i 
> Database and be 
> worry-free. "
> 
> 
> From 
> http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
> 462&Act=16
> 
> 
> I don't understand PR of Oracle. The RDBMS has so much 
> properties which
> are 
> much more better implemented in Oracle than in MS SQL and they choose 
> 'patching' which *** on both servers.
> 
> JP
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Boivin, Patrice J

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 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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

Re: Those installing Oracle 9i on AIX 5.2L

2003-06-05 Thread Ruth Gramolini

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, it installed for me without 
error.
 
Ruth

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 02, 2003 8:39 AM
  Subject: Those installing Oracle 9i on 
  AIX 5.2L
  
  Hi all, 
  If you are installing or upgrading 
  9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
  installed? 
  I am talking about regatta (p690) servers 
  if that matters ... 
  Thanks in advance Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art !

Re: Those installing Oracle 9i on AIX 5.2L

2003-06-05 Thread Ruth Gramolini

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 thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
Application Development Math Library(bos.adt.libm) is not installed by 
default.-Claus
 
Hope this helps!  
Ruth

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 02, 2003 8:39 AM
  Subject: Those installing Oracle 9i on 
  AIX 5.2L
  
  Hi all, 
  If you are installing or upgrading 
  9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
  installed? 
  I am talking about regatta (p690) servers 
  if that matters ... 
  Thanks in advance Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art !

RE: Limiting Concurrent Sessions Not Working




Do you 
have "resource_limit = true" in init.ora?  If you don't it defaults to 
FALSE & the profile has no effect.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 2:10 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Limiting Concurrent Sessions Not Working

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 to this profile) the user is not stopped from 
exceeding the number of concurrent sessions.  I tested this by connecting 
using Sql Plus.  I even tried bouncing the database, to see if that makes a 
difference, but to no avail.  
 
Any ideas what is happening?  
Am I missing something?  Is this a problem/bug with Oracle 7.3.4?  The 
output below shows the steps I followed to create the profile and user.  It 
also shows multiple connections to the database after bouncing the 
instance.
 
Thanks for any 
suggestions!
 
Sam.

 
 
SQL> create profile sam limit 
sessions_per_user 1;
 
Profile created.
 
SQL> create user sam identified 
by sam;
 
User created.
 
SQL> alter user sam profile 
sam;
 
User altered.
 
SQL> grant create session to 
sam;
 
Grant succeeded.
 
SQL> 
 
SQL> l
  1  select 
limit
  2  from 
dba_profiles
  3  where 
profile=''
  4* and resource_name = 
'SESSIONS_PER_USER'
SQL> /
 
LIMIT

1
 
SQL> 
 
SQL> select 
profile
  2  from 
dba_users
  3  where username = 
'SAM';
 
PROFILE
--
SAM
 
SQL>
 
SVRMGR> shutdown 
normal
Database closed.
Database 
dismounted.
ORACLE instance shut 
down.
 
SVRMGR> connect 
internal
Connected to an idle 
instance.
SVRMGR> startup
ORACLE instance 
started.
Total System Global 
Area  34122296 bytes
Fixed 
Size   
38992 bytes
Variable 
Size 
31797736 bytes
Database 
Buffers   
2252800 bytes
Redo 
Buffers 
32768 bytes
Database mounted.
Database opened.
SVRMGR> select osuser, 
username
 2> from 
v$session;   
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle    

oracle  
SYS   

12 rows selected.
SVRMGR> select osuser, username 
from v$session;
OSUSER  
USERNAME  

--- 
--
oracle    

oracle    

oracle    

oracle    

oracle    

oracle 
   
oracle    

oracle    

oracle    

oracle    

oracle  
  
oracle  
SYS   

sam    
 SAM   

sam   
  SAM   

14 rows selected.
SVRMGR>
 
Sam Bootsma
George Brown College
[EMAIL PROTECTED]
416-415-5000 x4933

Limiting Concurrent Sessions Not Working

2003-06-05 Thread Sam Bootsma









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 to this profile) the user is not stopped from exceeding the number
of concurrent sessions.  I tested this by connecting using Sql Plus. 
I even tried bouncing the database, to see if that makes a difference, but to
no avail.  

 

Any ideas what is happening?  Am I missing
something?  Is this a problem/bug with Oracle 7.3.4?  The output
below shows the steps I followed to create the profile and user.  It also
shows multiple connections to the database after bouncing the instance.

 

Thanks for any suggestions!

 

Sam.



 



 

SQL> create profile sam limit sessions_per_user 1;

 

Profile created.

 

SQL> create user sam identified by sam;

 

User created.

 

SQL> alter user sam profile sam;

 

User altered.

 

SQL> grant create session to sam;

 

Grant succeeded.

 

SQL> 

 

SQL> l

  1  select limit

  2  from dba_profiles

  3  where profile=''

  4* and resource_name = 'SESSIONS_PER_USER'

SQL> /

 

LIMIT



1

 

SQL> 

 

SQL> select profile

  2  from dba_users

  3  where username = 'SAM';

 

PROFILE

--

SAM

 

SQL>

 

SVRMGR> shutdown normal

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SVRMGR> connect internal

Connected to an idle instance.

SVRMGR> startup

ORACLE instance started.

Total System Global Area 
34122296 bytes

Fixed
Size  
38992 bytes

Variable
Size
31797736 bytes

Database
Buffers  
2252800 bytes

Redo
Buffers
32768 bytes

Database mounted.

Database opened.

SVRMGR> select osuser, username

 2> from v$session;   

OSUSER 
USERNAME 


--- --

oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle   


oracle 
SYS  


12 rows selected.

SVRMGR> select osuser, username from v$session;

OSUSER 
USERNAME 


--- --

oracle   


oracle   


oracle   


oracle   


oracle   


oracle
   

oracle   


oracle   


oracle   


oracle   


oracle 
  

oracle 
SYS  


sam     SAM  


sam     SAM  


14 rows selected.

SVRMGR>

 

Sam Bootsma

George Brown College

[EMAIL PROTECTED]

416-415-5000 x4933

RE: oraInst.loc question

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 really have found so far.


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 will ever need.

~ Jerry Gillies ~




-Original Message-
From: Rich Holland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 1:01 PM
To: Multiple recipients of list ORACLE-L
Subject: oraInst.loc question



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 ':<$ORACLE_HOME path>:N' entries, but the
oraInst.loc appears to be for a single installation.


Now in order to apply patches and such, I have to modify
/etc/oraInst.loc every time (it appears Opatch is ignoring the
/var/opt/oracle version).


Has anyone found an easy way to use multiple oraInst.loc files or to use
a single oraInst.loc file for multiple inventories?  I'm strongly
considering hiding opatch and replacing it with a wrapper script that
rewrites the oraInst.loc files prior to calling the 'real' opatch
executable, but thought I'd see if there's an easier way first.  :-)


Thanks!
Rich Holland
SAP Technical Consultant
Guidance Technologies, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rich Holland
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 want the user to decide how much disk storage to allocate so we let the 
datafiles autoextend. 
3) As the DBA/DUHveloper (Python/CGI) who "bequeathed" certain DBA functions to the 
GUI interface, I depended on autoextend working and was too lazy to "algorithm-ize" 
the number of datafiles based on current storage needs.
4) Upon self-chastizement I'm undoing the autoextend "feature" and am now going to 
dba_segments to develop a "capacity planning" algorithm.

Developing DBA automation tools driven via events and end user input is a fun and wild 
ride on the margin of DBA fiefdom. 

Commiserating with my DBA buddy Walt, "Help... we're losing control and we hate giving 
up 'power.'" :-)


Staring out the window at the mountains in Big Sky Country,
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L


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 ether resize 
it using this trick or add another datafile to tablespace when 
the time comes (whenever MagicNumber or N x MagicNumber is close).

Despite rumours (of having fixed autoextend feature on Windows)
I recently witnessed failed imports into Oracle 9.2.0.1.0 
caused by too small tablespaces that just wouldn't autoextend.
Interestingly, import died "beautifully" cuz silently in the
middle of job without _any_ errors, traces etc. Just gone.

There is also interesting myth here at the place where I work
that systems tablespace autoextend feature ain't to be trusted
as "it is known" to have caused intermittent data dictionary 
corruptions while code recompilation takes place under space 
"crunch" conditions... 
 
On slightly cynical side note: autoextend that doesn't - maps
nicely into job safety ;-)

Branimir

> -Original Message-
> From: Orr, Steve [mailto:[EMAIL PROTECTED]
> Sent: June 4, 2003 11:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ???
> 
> 
> 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 
> didn't tell me this until after about 4 days of back and 
> forth testing for them. (There is no such O/S file size 
> limit.) I've reviewed the Linux release notes, the Linux 
> install guide, the Linux admin guide and the contents of 
> $ORACLE_HOME/relnotes and I don't find any such limitation in 
> the documentation. Did I miss it? Can anyone find any such 
> published limitation in the docs? Is this a secret? 
> 
> 
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Matthew Zito



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 operation calls were made to specify whether a 32-bit
or 64-bit offset should be returned, as well as specifying a flag
O_LARGEFILE that could be sent to the traditional open() that indicated
the application was largefile aware.  When an application is compiled,
you can specify to the compiler that you want it to be 64-bit aware and
the 64-bit versions of things like open and seek will be used, or the
code can use the O_LARGEFILE flag in open().  The end result of this is
that while linux is >2GB aware, oracle 8.1.7 is not quite entirely.  I
bet that the chunk of code that opens a datafile for traditional access
in 8.1.7 is 64-bit aware, while the code that grows the file is not.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Jan Pruner
> Sent: Wednesday, June 04, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
> 
> 
> 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 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 didn't tell me 
> this until after about 4 days of back and forth testing for 
> them. (There is no such O/S file size limit.) I've reviewed 
> the Linux release notes, the Linux install guide, the Linux 
> admin guide and the contents of $ORACLE_HOME/relnotes and I 
> don't find any such limitation in the documentation. Did I 
> miss it? Can anyone find any such published limitation in the 
> docs? Is this a secret?
> >
> >
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 files and were using 32-bit offsets for
file pointer storage.  So, as a workaround, 32- and 64-bit versions of
the various file operation calls were made to specify whether a 32-bit
or 64-bit offset should be returned, as well as specifying a flag
O_LARGEFILE that could be sent to the traditional open() that indicated
the application was largefile aware.  When an application is compiled,
you can specify to the compiler that you want it to be 64-bit aware and
the 64-bit versions of things like open and seek will be used, or the
code can use the O_LARGEFILE flag in open().  The end result of this is
that while linux is >2GB aware, oracle 8.1.7 is not quite entirely.  I
bet that the chunk of code that opens a datafile for traditional access
in 8.1.7 is 64-bit aware, while the code that grows the file is not.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Jan Pruner
> Sent: Wednesday, June 04, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
> 
> 
> 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 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 didn't tell me 
> this until after about 4 days of back and forth testing for 
> them. (There is no such O/S file size limit.) I've reviewed 
> the Linux release notes, the Linux install guide, the Linux 
> admin guide and the contents of $ORACLE_HOME/relnotes and I 
> don't find any such limitation in the documentation. Did I 
> miss it? Can anyone find any such published limitation in the 
> docs? Is this a secret?
> >
> >
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web 
> hosting services
> > 
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may 
> also send 
> > the HELP command for other information (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Mercadante, Thomas F

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 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 problem. And my peeve is that it took
OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: library cache pin wait

2003-06-05 Thread Johnson, Michael

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 could be indicative of string literal problems.  

Your memory usage should be lower than what it is on the shared
pool side say down around 75% is ideal, but this may be indicative of
the problem above as you have to load up all those diffent SQL statements
into the pool.If that percentage gets to high then you may be
aging out "good SQL" requiring you to hard parse SQL all over again if
it is needed.  

Gotta clean up those applications.   If Cursor_sharing=Force works
well in 9+, it will just make folks more lazy as you will bail them out.
Gotta get tough like a parent and force them to rewrite their
software.  You will win no friends, but Oh well.

Also,  ask the applications developers or users if they have noticed
any kind of a slowdown during this 60 minute session you are looking at.
Consider setting a 10046 trace on a users session and you should see the 
wait in there and the competing problem.  Also, see www.hotsos.com 
for some information on 10046 data.

Also, use Gaja and Kirti's most excellent book Oracle Performance 
tuning 101 to drill down on those library cache pin and latch free waits.   

Also,  Tom Kyte's most excellent book has a pretty good explanation in
Chapter 10 I believe on using Statspack and what to look for in
the report.

Focus on the Soft Parsing % first by tracking down bad SQL, then revisit
this report again after some time and see if that helped.  Talk with
Millsap, Kyte, Gaja, Anjo and Kirti on this stuff.  

They are all studs.
Good Luck with it.

Mike



-Original Message-
Sent: Wednesday, June 04, 2003 12:40 AM
To: Multiple recipients of list ORACLE-L



For a Hybrid Banking Application , following waits are Observed :-
Oracle ver 9.2 (Dedicated Server connections)
Solaris 8
M/c SF15K
Application mostly uses Static Queries (i.e. with Bind variables) , 
though there may be some amount of Literal SQLs too 
DB Size = 250 GB

Qs How may the following waits be approached ?
Qs Since we have just moved to 9.2 , any advisable standard init.ora
parameters with 9.2 ?
Qs Should CURSOR_SHARING = FORCE or SIMILAR be considered ? Which is better 
& what may be the Overhead of these on production ?

Shall answer any Clarifications .

Thanks


--
STATSPACK report for

DB Name DB IdInstance Inst Num Release Cluster Host
 ---   --- ---

TBASUN1820705732 tbasun  1 9.2.0.3.0   NO  IB15KDB

Snap Id Snap Time  Sessions Curs/Sess Comment
--- --  -
---
Begin Snap:  71 03-Jun-03 12:00:052,953  53.2
  End Snap:  91 03-Jun-03 13:00:053,030  55.2
   Elapsed:   60.00 (mins)

Cache Sizes (end)
~
   Buffer Cache:   703M  Std Block Size: 8K
   Shared Pool Size:   400M  Log Buffer: 6,144K

Load Profile
Per Second   Per Transaction
   ---   ---
  Redo size:251,510.31  1,682.23
  Logical reads: 35,458.62237.17
  Block changes:  1,226.80  8.21
 Physical reads:  2,391.08 15.99
Physical writes:155.51  1.04
 User calls:  8,556.91 57.23
 Parses:495.46  3.31
Hard parses: 71.17  0.48
  Sorts:201.79  1.35
 Logons:  8.80  0.06
   Executes:  5,949.80 39.80
   Transactions:149.51

  % Blocks changed per Read:3.46Recursive Call %:43.86
 Rollback per transaction %:   55.51   Rows per Sort:45.29

Instance Efficiency Percentages (Target 100%)
~
Buffer Nowait %:   99.98   Redo NoWait %:   99.99
Buffer  Hit   %:   93.35In-memory Sort %:   99.94
Library Hit   %:   98.14Soft Parse %:   85.64
 Execute to Parse %:   91.67 Latch Hit %:   98.81
Parse CPU to Parse Elapsd %:3.56 % Non-Parse CPU:   90.92

 Shared Pool StatisticsBegin   End
   --  --

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa

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 complete and failed miserably at.  
This is NOT giving me a warm fuzzy about upgrading production. 

Lisa 
(Can one more thing go wrong today?  Please?)

-Original Message-
Sent: Wednesday, June 04, 2003 1:38 PM
To: Multiple recipients of list ORACLE-L


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.
===


-Original Message-
Lisa
Sent: Wednesday, June 04, 2003 10:40 PM
To: Multiple recipients of list ORACLE-L


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 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
altogether, and I get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts
looking for arclogs that *do not* exist.  I also tried to drop the redo
log groups and recreate them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly
confused support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


"Trade SQL Server for Oracle9i Database and get up to 100% license
credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database
servers? 
In the time it takes you to apply all Microsoft's patches to your
servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. "


>From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462&Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name

oraInst.loc question

2003-06-05 Thread Rich Holland

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 ':<$ORACLE_HOME path>:N' entries, but the
oraInst.loc appears to be for a single installation.

Now in order to apply patches and such, I have to modify
/etc/oraInst.loc every time (it appears Opatch is ignoring the
/var/opt/oracle version).

Has anyone found an easy way to use multiple oraInst.loc files or to use
a single oraInst.loc file for multiple inventories?  I'm strongly
considering hiding opatch and replacing it with a wrapper script that
rewrites the oraInst.loc files prior to calling the 'real' opatch
executable, but thought I'd see if there's an easier way first.  :-)

Thanks!
Rich Holland
SAP Technical Consultant
Guidance Technologies, Inc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rich Holland
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-12547: TNS:lost contact

2003-06-05 Thread Zabair Ahmed

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 controlfile. I know this is a connectivity issue to the instance. but how do I resolve it.
 
Thanks
 Yahoo! Plus - For a better Internet experience

RE: Interesting!

2003-06-05 Thread Pardee, Roy E

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 package my_package is
  v_my_public_var VARCHAR2(30) ;

  procedure my_public_procedure ;
end my_package ;

create or replace package body my_package is
  v_my_private_var VARCHAR2(30) ;
  procedure my_private_procedure is
  begin
v_my_private_var := 'Hello!' ;
  end my_private_procedure ;
  procedure my_public_procedure is
  begin
my_private_procedure ;
  end my_public_procedure ;
end my_package ;

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, June 04, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L


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 package declaration. 
And yes, I am aware of the fact that it only makes sense with procs, funcs
that 
you only want to use from within the scope of the proc/func you define them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


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 into a very annoying variable scope issue.  Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember the
actual error I encountered.  It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be remo

RE: Shite of the day

2003-06-05 Thread Ganesh Raja

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.
===


-Original Message-
Lisa
Sent: Wednesday, June 04, 2003 10:40 PM
To: Multiple recipients of list ORACLE-L


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 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
altogether, and I get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts
looking for arclogs that *do not* exist.  I also tried to drop the redo
log groups and recreate them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly
confused support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


"Trade SQL Server for Oracle9i Database and get up to 100% license
credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database
servers? 
In the time it takes you to apply all Microsoft's patches to your
servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. "


>From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462&Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Schedule Analyze using DBMS_STATS ???

2003-06-05 Thread Ganesh Raja

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
===
Live to learn... forget... and learn again.
===

-Original Message-
Keshava Murthy (Cognizant)
Sent: Wednesday, June 04, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L

 Hi all,
Everyone is recommending DBMS_STATS to be used for
computing the statistics.  But even after specifying the parallel option
, DBMS_STATS is taking lots of time ! in comparison to Analyze...

 In case of tables with a million  records the query just hangs when i
use the stats package...

 Can anybody tell me whts happening ?

 Regards
 kesh

-Original Message-
Sent: Tuesday, June 03, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L

Sorry JP, I should have clarified that DBMS_STATS is the way to go, when
on a 9i or above release. One of the simple factors being that ANALYZE
is being deprecated.. There seemed to be a number of bugs/quirks,
whatever you want to call them, in certain 8.1.x versions, which are now
fixed within 9i..

There's a number of threads about the issues, available in the list
archives (you can find them at http://www.faqchest.com), which I dug
around - as I remembered seeing a post by Connor McDonald, where he gave
away an alternate script to gather stats, here's the mail:

http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0210/ora-021011/ora0210
0802
_06150.html

I think the general consensus is that DBMS_STATS is quicker. I've never
personally done any comparative benchmarks to corroborate this sheep
following attitude though.. ;)

Regards

Mark

-Original Message-
Sent: 03 June 2003 14:55
To: Mark Leith
Cc: [EMAIL PROTECTED]

Thanx a lot Mark.
Sure , your code has given me a starting point.
let me change accordingly to use DBMS_STATSe and give a try :-)

So,can i conclude that DBMS_STATS is better than ANALYZE ?!

Someone over the list mentioned that DBMS_STATS is slower.
is it so ? What is your opinion regarding this ?!
just curious to know !

Regards,
Jp.

3-6-2003 22:01:32, "Mark Leith" <[EMAIL PROTECTED]> wrote:

>Prem,
>
>Use DBMS_JOBS to run the analyze:
>
>===
>
>undef username
>undef password
>grant analyze any to &&username
>/
>
>connect &&username/&&password
>
>CREATE or REPLACE PROCEDURE analyze_tables (
>  v_stat_type IN VARCHAR2 := 'COMPUTE') AS
>  CURSOR c IS
>  SELECT DISTINCT owner
>  FROM   all_tables
>  WHERE  owner not in ('SYS','SYSTEM');
>  BEGIN
>  FOR any_row IN c LOOP
>dbms_utility.analyze_schema(
>  any_row.owner,v_stat_type);
>  END LOOP;
>  END;
>/
>
>===
>
>variable jobno number
>declare jobno number;
>  BEGIN
>  dbms_job.submit(:jobno,
>'begin &&username.analyze_tables; end;',
>to_date('03jun0304:00','DDMONYYHH24:MI'),
>'trunc(sysdate)+(1+(4/24))');
>  END;
>
>===
>
>The above will run a COMPUTE analyze on all schemas, except SYS and
SYSTEM,
>at 4:00am every day. Modify it to your own needs, but it should give
you a
>starting point..
>
>I would also recommend using DBMS_STATS to generate your statistics.
>
>Have fun! ;0)
>
>Mark

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB

RE: Interesting!

2003-06-05 Thread Igor Neyman

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 " will not show
"private" procedures/functions.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Jahnke
Sent: Wednesday, June 04, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L

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 package declaration. 
And yes, I am aware of the fact that it only makes sense with procs,
funcs
that 
you only want to use from within the scope of the proc/func you define
them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


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 into a very annoying variable scope issue.  Of
course
after spending hours debugging the code, I realized I should have taken
the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember
the
actual error I encountered.  It probably had nothing or very little to
do
with my nested procedures, but in my mind I can't consider this to be a
good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note E

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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 
problem. And my peeve is that it took OWS 4 days to "discover" this "limit."


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Branimir Petrovic

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 ether resize 
it using this trick or add another datafile to tablespace when 
the time comes (whenever MagicNumber or N x MagicNumber is close).

Despite rumours (of having fixed autoextend feature on Windows)
I recently witnessed failed imports into Oracle 9.2.0.1.0 
caused by too small tablespaces that just wouldn't autoextend.
Interestingly, import died "beautifully" cuz silently in the
middle of job without _any_ errors, traces etc. Just gone.

There is also interesting myth here at the place where I work
that systems tablespace autoextend feature ain't to be trusted
as "it is known" to have caused intermittent data dictionary 
corruptions while code recompilation takes place under space 
"crunch" conditions... 
 
On slightly cynical side note: autoextend that doesn't - maps
nicely into job safety ;-)

Branimir

> -Original Message-
> From: Orr, Steve [mailto:[EMAIL PROTECTED]
> Sent: June 4, 2003 11:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ???
> 
> 
> 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 
> didn't tell me this until after about 4 days of back and 
> forth testing for them. (There is no such O/S file size 
> limit.) I've reviewed the Linux release notes, the Linux 
> install guide, the Linux admin guide and the contents of 
> $ORACLE_HOME/relnotes and I don't find any such limitation in 
> the documentation. Did I miss it? Can anyone find any such 
> published limitation in the docs? Is this a secret? 
> 
> 
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good technical documents/references on tuning restores

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 what files go with those tablespaces, shutdown the database, "fix" the 
create control file script so those files are in it (if those tablespaces and 
files are still valid in the database)... and startup nomount and run the script 
again... it will tell you that you have those datafiles needing media 
recovery.  
 
recover datafile ''
 
If the tablespaces and files aren't valid anymore, you can offline drop 
them and they won't be in the data dictionary OR in the control file... 

 
 
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 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  11:05 AMTo: Multiple recipients of list ORACLE-LSubject: 
  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 backup immediately after this.
   
  Good luck,
  Ruth
  
- Original Message - 
From: 
Henry 
Poras 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, June 04, 2003 10:09 
AM
Subject: 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 mini-test system.
 
Henry
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 
  11:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Good technical documents/references on 
  tuning restores
  Okay, 
   
  Database open and I wanted to not restore and not reference certain 
  index and materia. view datafiles.  Now the datafiles show up with 
  weird MISSING.. names.  How do I clean this 
  up?
   
  Thanks,
  paula
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 
2003 10:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Good technical documents/references on 
tuning restores
Strange: 
looking at v$backup_async_io found some datafiles 
where     active bytes per sec    
    long-waits    
2154608      
    
    297   
 
7489829    
    
    
    297  
How can I start finding the disparity?  
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 
9:05 PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good 
technical documents/references on tuning restores 
Did I say that throughout this restore/recovery process 
my tapes being mounted and unmounted while other database backups and 
cloning was occurring.  Big duh - this has got to be slowing down 
the process.  Any ideas on how to handle this?  Perhaps more 
than one tape subsystem would be better or while doing restores other 
backup utility is halted - hmmm - but that risks those other 
systems?  How can I sell that?  H.  Maybe I will 
first backup to disk.  Yep, one backup to disk.  
Yep.
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 
9:00 PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good 
technical documents/references on tuning restores 
See nwadmin shows parellism = 32.  I am not the 
tape person - that is my sys admin.  I don't believe they actually 
have 32 tapes involved only 4.  Can this impact performance by 
setting this too high?  I also notice one backup server for 
networker with nwadmin messages like "clone sets being created...", 
"other databases being backed up".  What is the usual policy on 
concurrently running backups, cloning at the same time recovery is 
taking place.  It appears to show a lot of media waiting 
events:  waiting for dlt7000 tape ... of the tapes that

Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Jan Pruner

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 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
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

AW: Interesting!

2003-06-05 Thread Stefan Jahnke

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 package declaration. 
And yes, I am aware of the fact that it only makes sense with procs, funcs
that 
you only want to use from within the scope of the proc/func you define them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


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 into a very annoying variable scope issue.  Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember the
actual error I encountered.  It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa

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 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: Wednesday, June 04, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


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 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I 
get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts looking for 
arclogs that *do not* exist.  I also tried to drop the redo log groups and recreate 
them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly confused 
support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


"Trade SQL Server for Oracle9i Database and get up to 100% license credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database servers? 
In the time it takes you to apply all Microsoft's patches to your servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. "


>From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462&Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Jose Luis Delgado

--- 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
your backup controlfile file at the moment of
recreating the control file.

You can, re-attempt:
alter database backup controlfile to trace

include ALL you datafiles (name and path)...
and then... you can drop, rename or whatever you want!

HTH
JL


> Igor Neyman, OCP DBA
> 
> [EMAIL PROTECTED]
> 
>  
> 
>  
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, June 03, 2003 9:05 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> Did I say that throughout this restore/recovery
> process my tapes being
> mounted and unmounted while other database backups
> and cloning was
> occurring.  Big duh - this has got to be slowing
> down the process.  Any
> ideas on how to handle this?  Perhaps more than one
> tape subsystem would
> be better or while doing restores other backup
> utility is halted - hmmm
> - but that risks those other systems?  How can I
> sell that?  H.
> Maybe I will first backup to disk.  Yep, one backup
> to disk.  Yep.
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 9:00 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> See nwadmin shows parellism = 32.  I am not the tape
> person - that is my
> sys admin.  I don't believe they actually have 32
> tapes involved only 4.
> Can this impact performance by setting this too
> high?  I also notice one
> backup server for networker with nwadmin messages
> like "clone sets being
> created...", "other databases being backed up". 
> What is the usual
> policy on concurrently running backups, cloning at
> the same time
> recovery is taking place.  It appears to show a lot
> of media waiting
> events:  waiting for dlt7000 tape ... of the tapes
> that I specifically
> need for this restore.  Did I say:  I love my
> admin...I love my
> adminI love my admin...
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:53 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> Okay, almost 4 minutes for a datafile that was 78168
> blocks - how do I
> know if this is reasonable? 
> 
> Also, seems to write these files out (restore
> sychron.) why can't it
> restore different datafiles in parallel?  - stupid
> question huh?
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:46 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> SELECT SID, SERIAL#, CONTEXT,   
> 
>  ROUND(SOFAR/TOTALWORK*100,2) "% complete", 
> 
> SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) "Time
> now"
> FROM V$SESSION_LONGOPS  
> 
> WHERE OPNAME like '%restore%';  
> 
> .   
> 
> showed all 100% complete but msglog from RMAN shows
> it is truly still
> running.  
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:40 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> Also found on monitoring performance of RMAN jobs: 
> Note:144640.1 on Metalink 
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:36 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> Found this white paper: 
> 
>
http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf
> 
> 
> Anything better? 
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:33 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> This is what I have set on my target database: 
> 
> --- ---
> --- 
> backup_tape_io_slaves   boolean FALSE   
>   
> tape_asynch_io  boolean TRUE
>   
> 
> Version 8.1.7.4 database and RMAN catalog - 32 bit 
> Networker MML 
> Using RAID 1+0 
> Solaris 2.8 
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:28 PM 
> To: Stankus, Paula G; '[EMAIL PROTECTED]' 
> 
>  
> 
> Okay - from my reading you don't need to have
> multiple tape io slaves if
> you are using asynch. I/O.  Again, best document for
> perf. tuning
> database restores using RMAN would make mucho
> difference.  Read old note
> about someone doing an analyze on the RMAN catalog
> tables to improve
> performance of restore.  I think it has something to
> do with how quickly
> it finds the file on tape and writes to disk.  
> 
> -Original Message- 
> Sent: Tuesday, June 03, 2003 8:25 PM 
> To: '[EMAIL PROTECTED]' 
> 
>  
> 
> Seems to be taking awfully long to read files from
> tape and write to
> disk.  I allocate multiple tape channels like I do
> for the backup which
> only takes about 45 minutes.  Does not seem to be
> spawning multiple
> sessions.  Do I need to change parameters on my
> init.ora file to use
> multiple tap

Re: Snapshot too old during stress test... how to avoid

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 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
> 
>  
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc: 
> Subject:Snapshot too old during stress test... how to avoid
> 
> 
> Im testing worst case scenarios right now. So Im doing batch 
> updates,inserts,deletes and 'create table as' from a staging tablespace of 
> approximately 5GBs to a master tablespace of approximately 11GBs.
> 
> Ive got my job queue processes set to 36 and Im running 36 at a time in 
> the background in order to gather statistics and timing under worst case 
> scenarios. 
> 
> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB 
> for this test. I have 4 standard RBS with optimal size set to 1GB. Why 
> would I get a snapshot too old? I would think that 11GBs of rollback would 
> be big enough. Would increasing the number of Rollback segments avoid this 
> even though I have the same amount of space in the tablespace? 
> 
> In reality Im going to seriallize the process to avoid this and to improve 
> performance, however, I want to stress the system.
> 
> any advice? 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: passing ref cursor on a procedure

2003-06-05 Thread Hatzistavrou John

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 I execute procedure getl from sqlplus? 

 



Kind Regards, 

 

Hatzistavrou Yannis 
?



-Original
Message-
From: Regis Biassala
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday,
 June 04, 2003 6:05
 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: passing ref cursor on
a procedure

 



example





-Original Message-
From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003
2:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: passing ref cursor on a
procedure

Dear
All,

I have a vendor procedure which I
wish to run . This procedure 
takes as input variables a varchar and a ref_cursor.

I know the query that is related to
the ref_cursor and I wish to implicitly pass it to the procedure . How can this be done?

Kind Regards,

 

Hatzistavrou Yannis








*

This electronic transmission is strictly confidential and intended solely

for the addressee. It may contain information which is covered by legal,

professional or other privilege. If you are not the intended addressee,

you must not disclose, copy or take any action in reliance of this

transmission. If you have received this transmission in error, 

please notify the sender as soon as possible.


This footnote also confirms that this message has been swept

for computer viruses.

**

RE: Good technical documents/references on tuning restores