date:20021010


so if it's waiting for any active transaction, I guess you could put
the database in restricted mode until existing transactions complete.
Of course, that sort of defeats the purpose of putting it in read-only
so other people can access it.

um, 9ir2 has an export parameter of tablespace, if you want it
read-only so nothing changes while you export it, how about using the
consistent=y export parameter in conjunction with the tablespace
export?


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And with that correction, it seems checking for active transactions
 (in
 v$transaction) would address this. 
  
 However, by the time one gets a 'green' light from v$transaction and
 issues
 alter tablespace... there is the slight possibility of someone
 starting a
 new transaction locally or just selecting over a dblink...
  
 Too bad that the new 'transitional read-only' mode does not allow a
 graceful
 exit... Per the Admin Guide one must set compatible to  8.1.0 to
 make the
 command fail...  
  
 I would be interested in learning how you tackle this issue as I am
 also
 trying to implement TTS in some of my databases. 
  
 Thanks.
  
 - Kirti 
  
 -Original Message-
 Sent: Wednesday, October 09, 2002 4:34 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Just a slight correction it will wait until any transaction against
 the
 entire database, not just the tablespace is completed.
  
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Wednesday, October 09, 2002 1:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I am creating a stored proc that will export a tablespace. One task
 it needs
 to perform is to place the tablespace(s) in read only mode to make a
 copy.
 Based upon the application and proc logic, there should not be any
 transactions against objects in the ts. However, if there are, the
 ALTER
 TABLESPACE command will wait until the transaction is completed. I
 would
 rather have the ALTER TABLESPACE command fail immediately. If I
 cannot do
 that, I would like to be able to test for locks on objects in the
 tablespace
 (figured that one out, but it is rather kludgy).
  
 Is there a method to force an immediate failure of ALTER TABLESPACE
 tsname
 READ ONLY if it cannot be immediatly completed?
 Is there a clean method/proc to determine if the ALTER TABLESPACE
 command
 will work?
  
 Dan Fink
 
 


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Storage Recommendations

2002-10-10 Thread Anjo Kolk



Joshua,

There are papers on the internet, I have two papers on my site (not done
by me, so I can advertise). But one thing I should point out to you: the
size of the database is not important for buying storage. It is the
number of users and the number of I/O operations per second that the I/O
subsystem can do. I said it before and will do again: don't buy storage
but IO operations.

Anjo.



Joshua Becker wrote:
 
 Hi all,
 
 does anyone know a good site or have good white papers
 or presentations concerning physical storage
 recommendation for different size Oracle databases...
 and also for different platforms (Win2000 and HP-UX
 and Sun Solaris...)
 
 I would be VERY grateful for all information :-)
 
 Thank you very much in advance
 
 Joshua
 
 _
 Gratis e-mail resten av livet på www.yahoo.se/mail
 Busenkelt!
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Joshua=20Becker?=
   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.com
--
Author: Anjo Kolk
  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: Verrrry interesting article at MetaLink


you put the code out in the world without a comment in it about copying
is not allowed and you've made it free for the taking.

Compensation isn't likely. Credit is definitely due and should be
given.


--- [EMAIL PROTECTED] wrote:
 Jared,
 You should feel upset as well as flattered. In my view you have a
 strong
 case against Oracle for some form of compensation, as a minimum you
 should
 be credited in the article.
 Whether you can win against a  big corporation is another matter of
 course.
 I and many others can confirm that the document has been on your site
 for at
 least 3 - 4 years (although they state the article to be originally
 dated
 1998).
 
 I would certainly be in contact with Oracle about this. Perhaps a
 good
 starting point would be your sales rep or contact at wherever you are
 working now.
 
 John 
 
 -Original Message-
 Sent: 10 October 2002 08:13
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 Dear list,
 
 I found something rather interesting on MetaLink today.
 
 While doing a little research on UTL_FILE, I came across
 document # 1050919.6.  This document deals with how to
 dump a table to an ascii file.
 

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
 ase_id=NOTp_id=1050919.6
 
 I began to think the code looked a little familiar.  Then I
 saw the temporary file name of '_dtmp.sql', which was 
 rather reminiscent of file names I use.
 
 Further perusal revealed that the comments were written 
 by yours truly, and match word for word those I added to 
 the dump.sql script years ago.
 
 See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
 I don't know whether to be flattered or upset.
 
 Jared
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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.com
 -- 
 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).


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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:

2002-10-10 Thread Thomas, Kevin


Lookup SQL*Loader

-Original Message-
Sent: 10 October 2002 11:59
To: Multiple recipients of list ORACLE-L


Hello all,
 
  I have a client who will be doing the data capture and give me the
data in a flat file.
what i need to do in oracle is load from that flat file to my database.
any scripts available ?? please send me across. ASAP

Thanks and regards,

Santosh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  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: Verrrry interesting article at MetaLink


 At least they TOLD me that if I ever get our Unique configuration for
Apps to work they expect me to write thier documentation for them 

April
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/10/2002 2:13 AM



Dear list,

I found something rather interesting on MetaLink today.

While doing a little research on UTL_FILE, I came across
document # 1050919.6.  This document deals with how to
dump a table to an ascii file.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_d
atabase_id=NOTp_id=1050919.6

I began to think the code looked a little familiar.  Then I
saw the temporary file name of '_dtmp.sql', which was 
rather reminiscent of file names I use.

Further perusal revealed that the comments were written 
by yours truly, and match word for word those I added to 
the dump.sql script years ago.

See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql

I don't know whether to be flattered or upset.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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).

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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).

Loading a flat file into Oracle

2002-10-10 Thread John . Hallas


Santosh.
Putting a subject on your e-mails is useful to everyone
 
I suggest you look at sqlloader. There are some good pages on the FAQ
associated with this site
http://www.orafaq.com http://www.orafaq.com 

 

HTH

 

John

-Original Message-
Sent: 10 October 2002 11:59
To: Multiple recipients of list ORACLE-L


Hello all,
 
  I have a client who will be doing the data capture and give me the
data in a flat file.
what i need to do in oracle is load from that flat file to my database.
any scripts available ?? please send me across. ASAP

Thanks and regards,

Santosh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: DROP DEVELOPER not working

2002-10-10 Thread Jamadagni, Rajendra

Title: RE: DROP DEVELOPER not working





(taking a cue from RMAN syntax)


drop developer developer_name from third_floor position upside_down immediate
/


works for me all the time ... (sorry couldn't resist ... I have been a developer too for 8+ years)


BTW 10046 will write the sql statement to trace file as soon as it is parsed ... it will have appropriate entry for execution as well ...

Also, see if developer is doing all this inside a script ... take a closer look for a missing / or a semicolon ... 


Sometimes the best solution is an extra pair of eyes to see your code pick the person who hates you most, chances are he/she will find the most bugs in the least anount of time. It's human nature ...

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 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

Shutdown/Startup user

2002-10-10 Thread O'Neill, Sean


Does anyone know if it is possible to create a user who only has rights to
Shutdown a database?.  I'm thinking about scenario that if the password for
this user were ever compromised, e.g. seen in a script then worst case
scenario would be database might be shutdown.  Indulge me on this please as
I acknowledge that a shutdown could be source of major revenue loss.  This
is been driven by requirement to have a script to cleanly shutdown a
database potentially outside hours when DBA is not on site.  If anyone has
any other practical suggestions for management of this requirement I'd
appreciate hearing them too.

Oracle 7.3.3, 8.0.5, 8.1.7 
NT4, W2K 
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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: RMAN and TSM

2002-10-10 Thread Mark J. Bobak


We are in the midst of a big move to RMAN.  We use EMC's EDM to do
backups, and the SAs have been pushing us towards RMAN for a while now,
cause the EDM interface intergrates w/ RMAN seamlessly.  It really is a
nice backup solution.  (We started the process by upgrading all our EDM
units to 5.0)  Anyhow, we are setting up the RMAN catalog databases
ringht on the EDM boxes.  (The EDMs are Solaris boxes.)

It's working well.  We haven't yet fully rolled out, but all our testing
has worked fine.  We're about to start the production database migration
next week.

-Mark
On Thu, 2002-10-10 at 06:23, Connor McDonald wrote:
 There is a Metalink note (73431.1) which talks about
 the rman version compatibility, but it also states: 
 
 Ensure that the RMAN executable version matches the
 version of the target database that it is backing up
 
 which I presume to mean that you need to run rman from
 each target and push to the catalog  storage
 management node(s).  This is how I've always seen it
 done - but I've often wondered if one could get away
 driving eveything from the catalog node, pulling
 client databases over sqlnet  - thus only having a
 single TSM client (and license) on the rman catalog
 node.
 
 Cheers
 Connor
 
  --- MacGregor, Ian A. [EMAIL PROTECTED]
 wrote:  I'm  trying to use RMAN and TSM to backup
 multiple
  databases spread across various nodes with some
  nodes hosting more than one database.  The RMAN
  catalog database will reside on a node different
  from  any of the nodes hosting the other databases. 
  I have long used ADSM  without the RMAN clothing to
  backup the databases.  I have convinced the SA's to
  move on to TSM, and now I need to add the RMAN
  adornments.
  
  I assume I need the SA's to install TDP  for Oracle
  on all the nodes requiring RMAN backup.  Do I also
  need to install it on  the machine which will host
  the catalog database.  That database will undergo
  cold backup using naked TSM.  The same question
  applies to the tdpo.opt file.  Do I need multiple
  TDPO_FS values and multiple tdpo.opt files to hold
  them.
  
  
  I am also assuming I will start RMAN from one of the
  databases requiring backup and connect also to the
  RMAN catalog.  Is this typical.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: MacGregor, Ian A.
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). 
 
 =
 Connor McDonald
 http://www.oracledba.co.uk
 http://www.oaktable.net
 
 Remember amateurs built the ark - Professionals built the Titanic
 
 __
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
 http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  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).

bioinformatics

2002-10-10 Thread [EMAIL PROTECTED]


is there any strategy from oracle in bioinformatics?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Shutdown/Startup user

2002-10-10 Thread John . Hallas


Sean,
The role sysoper is already provided
Details are 
There are two main administrative privileges in Oracle: SYSOPER and SYSDBA
These are special privileges as they allow access to a database instance
even when it is not running and so control of these privileges is totally
outside of the database itself.   SYSOPER privilege allows operations such
as: 
Instance startup, mount  database open ;   
Instance shutdown, dismount  database close ; 
Alter database BACKUP, ARCHIVE LOG, and RECOVER.
This privilege allows the user to perform basic operational tasks  without
the ability to look at user data.

John

-Original Message-
Sent: 10 October 2002 13:29
To: Multiple recipients of list ORACLE-L


Does anyone know if it is possible to create a user who only has rights to
Shutdown a database?.  I'm thinking about scenario that if the password for
this user were ever compromised, e.g. seen in a script then worst case
scenario would be database might be shutdown.  Indulge me on this please as
I acknowledge that a shutdown could be source of major revenue loss.  This
is been driven by requirement to have a script to cleanly shutdown a
database potentially outside hours when DBA is not on site.  If anyone has
any other practical suggestions for management of this requirement I'd
appreciate hearing them too.

Oracle 7.3.3, 8.0.5, 8.1.7 
NT4, W2K 
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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.com
--
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: Loading a flat file into Oracle

2002-10-10 Thread moyam


You have got SQLLoader example scripts on your PC/laptop on which Oracle is
installed.

Check out C:\ORACLE\ORA81\RDBMS\DEMO on your Windows Installation. You will
find scripts names UTCASEn.CTL.

Edit these scripts to relfect your destination table, fields and you will be
done.

Moses Moya


-Original Message-
Sent: Thursday, October 10, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L


Santosh.
Putting a subject on your e-mails is useful to everyone
 
I suggest you look at sqlloader. There are some good pages on the FAQ
associated with this site
http://www.orafaq.com http://www.orafaq.com 

 

HTH

 

John

-Original Message-
Sent: 10 October 2002 11:59
To: Multiple recipients of list ORACLE-L


Hello all,
 
  I have a client who will be doing the data capture and give me the
data in a flat file.
what i need to do in oracle is load from that flat file to my database.
any scripts available ?? please send me across. ASAP

Thanks and regards,

Santosh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
--
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: Making a tablespace read-only - identifying blocking tx

2002-10-10 Thread Ruth Gramolini


Why don't you just to a consistant export?  That will not take any
transaction after the start of the export, at leasst this is how I
understand it.

Ruth.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 4:48 PM


 I am creating a stored proc that will export a tablespace. One task it
needs
 to perform is to place the tablespace(s) in read only mode to make a copy.
 Based upon the application and proc logic, there should not be any
 transactions against objects in the ts. However, if there are, the ALTER
 TABLESPACE command will wait until the transaction is completed. I would
 rather have the ALTER TABLESPACE command fail immediately. If I cannot do
 that, I would like to be able to test for locks on objects in the
tablespace
 (figured that one out, but it is rather kludgy).

 Is there a method to force an immediate failure of ALTER TABLESPACE
tsname
 READ ONLY if it cannot be immediatly completed?
 Is there a clean method/proc to determine if the ALTER TABLESPACE command
 will work?

 Dan Fink


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Packed decimal


Russ - What do you have in mind? Oracle stores numbers in its own format in
its own datafiles. Are you looking to hack the Oracle datafiles? Or do you
have an input file in packed decimal format that your are looking at loading
into Oracle? If you could tell us the objective you are seeking to achieve,
perhaps we could help you. Or maybe not. :-) My schedule doesn't allow me
much spare time to hack Oracle datafiles.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, October 09, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
  Is there any way to identify values in a field, defined in Oracle as
number(11,2), with a packed decimal format?  Or to update the field with
packed decimal values?
 
Thanks,
Russ

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: cpu on AIX


Henry - One idea for you to try is to nice the import job when you start
it. Check your O.S. documentation for available values. This has helped me
on some jobs that have tended to overwhelm the online users. Just a thought.
Good luck, sounds as if you may have other system problems.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, October 09, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L


Dennis,
Users are complaining, and at least this time the guilty process seems to be
an import from a database out of my control. What I am trying to do is
control how often this happens. It seems a bit strange that one moderate,
single threaded import should drain both CPUs on the server, so I was trying
to see how much could be pinned on those processes (imp and associated
oracle shadow process)and how much was due to other use and poor
configuration.

As I mentioned, both %wio (wa on vmstat AIX) and %idle were ~0. Everything
was split (kind of evenly 50-50 to 40-60) between %usr and %sys. Using ps -o
pcpu I could pin about 30% of %CPU on the import. I am not sure if this
includes the associated system calls (io) from this process. I don't think
so. (I wasn't seeing my %CPU adding up to 100% earlier because I was leaving
out the kernal processes. I needed a ps -k flag).

Now I am seeing some other funky stuff (maybe related, maybe not. I haven't
looked carefully for this before so I don't know) on the same machine. The
import ended and the %usr %sys breakdown was still 40-60. There are two
kproc processes (async IO???) each using 44.4%CPU. That's been unchanged for
hours and the machine is not being heavily used. Also, some other processes
are using 10-20%CPU which puts me up over 100% (I guess it really can give
120%).

I'll let you know what I find.

Henry

-Original Message-
WILLIAMS
Sent: Wednesday, October 09, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L


Henry - Here are my reactions, and hopefully someone that knows how to track
system CPU usage back to an application will reply. One thought I have is to
run each application on a test server and observe the system I/O there. I
haven't tried this. Other thoughts:
 1) Are interactive users complaining? If they are, then you have a definite
problem.
 2) In terms of maxing out the CPU, does this situation continue for long
periods of time? For example, I have a financial system that is overloaded
at the first of the month, but underutilized the rest of the month. But
another system simply couldn't process everything they needed each day, so
we had to do something. In that case the users ceased running some reports.
 3) I looked in Oracle Performance Tuning 101 to see what Gaja has to say.
He points out that the Solaris sar -q command has a %wio column, a measure
of processes that are currently using the CPU, but are waiting for I/O
requests to be serviced and hence are not making prudent use of the CPU. He
further says that %sys and %wio should be less than 10-15% and if it is
consistently higher you need to get to the bottom of it, and usually it is a
application causing the problem. No details on how to get to the bottom.
 4) Maybe you can get some type of O.S. audit that can report what system
calls are being made, and that will give you a clue.

Dennis Williams
DBA
Lifetouch, Inc.
[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.com
-- 
Author: Henry Poras
  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.com
-- 
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

Re: Index Oracle-l

2002-10-10 Thread Ray Stell


On Wed, Oct 09, 2002 at 09:18:30PM -0800, Joshua Becker wrote:
 INDEX ORACLE-L

indexing here won't help...

 
-  
ListGuru GENERAL Command HELP  
-  
  
This help file contains basic information about each command recognized by  
ListGuru.  More detailed help is available through these commands:  
  
HELP command  -- Gives detailed help about a given command (listed below)  
HELP DETAILED   -- Complete and exhaustive help on ALL commands  
HELP USAGE  -- A general primer on how to use your mailing list  
HELP FAQ-- A list of Frequently Asked Questions (FAQ)  
  
  
Interacting with ListGuru:  
--  
  
ListGuru is a Mailing List Manager (MLM) which understands the commonly  
used commands of many other MLM's, including ListProc, listserv, Majordomo,  
SmartList, Mailbase and Listcaster, among others.  
  
All commands should be sent by E-mail to the following address:  
  
[EMAIL PROTECTED] -- Note spelling closely...  
  
The Subject: line is ignored, so do not place commands on it.  Commands go  
in the message BODY, one command per line.  You can send as many commands in  
a single message as you wish.  Each command has a specific format, as outlined  
below.  In the explanations below, replace any word enclosed by angle brackets,  
with an appropriate response.  For example:  
  
INFO list  
  
would be replaced with:  
  
INFO GARDENING-L  
  
Other command replacements:  
  
list   means the mailing list name (always suffixed with -L)  
real name  means your given name or surname, not E-mail address  
password   means a password given to you for closed lists  
search textmeans arbitrary text, not case sensitive  
option means a particular option, dependent on the command  
filename   means a filename (no pathnames are allowed)  
commandmeans any ListGuru command  
descriptionmeans arbitrary text, case sensitive  
  
If you have any difficulties or questions regarding ListGuru, contact:  
  
[EMAIL PROTECTED]  
  
  
The following commands are recognized by ListGuru (in alphabetical order):  
--  
  
ALLMAIL list  
  Displays a short summary (who, when, what) of all messages received and  
  sent out since the last time a digest was produced (generally midnight of  
  the previous day, but could be longer on low-traffic lists).  
  
  See Also: CONFIRM, LASTMAIL  
  
ARCHIVES  
  Displays a list of all mailing lists which have file archives and which  
  you are currently a subscriber to.  
  
  See Also: GET, INDEX, SEARCH, SUBMIT, VIEW  
  
BIOGRAPHY list INDEX 
BIOGRAPHY list user 
BIOGRAPHY list ALL 
BIOGRAPHY list 
BIOGRAPHY list DELETE 
  The general intent of the BIO command is to provide a way for list members 
  to create a short biography for themselves, which is then available to all 
  other members of the same list.  BIOGRAPHY can be shortened to BIO if you 
  prefer -- both spellings work equally well. 
 
  *** NOTE *** 
 
  This command is fairly detailed, so it is recommended that you  
  either issue a HELP DETAILED or a HELP BIO command to get the full set 
  of instructions for using this command. 
 
  Form #1: BIO list INDEX 
 
  Returns a complete list of whose bio is available for the given list.  As 
  an example, you could do a BIO GARDENING-L INDEX command and ListGuru would 
  send back a list of all BIO's so far submitted for the GARDENING-L list. 
 
  Form #2: BIO list user 
 
  Sends back a BIO for a specific user.  Usually it is the next command you 
  issue after the INDEX form.  You will be sent back the complete biography 
  text as submitted by that specific user.  Be sure to use the name listed 
  in the INDEX form to get information on the right person. 
 
  Form #3: BIO list ALL 
 
  Similar to form #2, but sends ALL biographies that are available for the 
  list you specify.  A quick way to get familiar with everyone, instead of 
  just individual users. 
 
  Form #4: BIO list 
 
  This is how you submit your OWN biography.  When you use this form of the 
  command, it should be the only command you send in that message, and the 
  message MUST contain a uuencoded file containing your biography.  At the 
  current time, MIME attachments are not supported, so the attached file 
  must first be uuencoded, then sent with your message.  If you have problems 
  with uuencode, contact [EMAIL PROTECTED] for assistance. 
 
  Form #5: BIO list DELETE 
 
  This form deletes any biography entry YOU have submitted for the list 
  specified.  Note you cannot delete anyone elses entry; only your own. 
 
  See Also: INDEX, SUBMIT 
 
CONFIRM list  
  Confirms whether you are a subscriber to a particular

Re: Storage Recommendations


Anjo,

I'm pretty sure Jared would let you advertise papers you wrote as well
as  papers written by others!

We are installing new servers, new data center, new apps, new
databases. I have been given NO input into the decision-making process,
other than to tell them how large my databases will be.

At least 6 of the databases will be on the same server, although it
will be partitioned into domains. All 6 are critical and need to be
fast. All 6 will be sharing the same EMC Symmetrix disks.

The only saving grace in all this that I can see is that my title is
development DBA and the company we hired to manage staging and
production has told me that it is THEIR responsibility, not mine, to
monitor not just infrastructure but also system/app/database
performance.

It's going to be fun to watch the fireworks and know I don't have to
put on my firefighting gear. 

Small favors, for which I have made appropriate sacrifices to the gods
:)

Rachel

--- Anjo Kolk [EMAIL PROTECTED] wrote:
 
 Joshua,
 
 There are papers on the internet, I have two papers on my site (not
 done
 by me, so I can advertise). But one thing I should point out to you:
 the
 size of the database is not important for buying storage. It is the
 number of users and the number of I/O operations per second that the
 I/O
 subsystem can do. I said it before and will do again: don't buy
 storage
 but IO operations.
 
 Anjo.
 
 
 
 Joshua Becker wrote:
  
  Hi all,
  
  does anyone know a good site or have good white papers
  or presentations concerning physical storage
  recommendation for different size Oracle databases...
  and also for different platforms (Win2000 and HP-UX
  and Sun Solaris...)
  
  I would be VERY grateful for all information :-)
  
  Thank you very much in advance
  
  Joshua
  
  _
  Gratis e-mail resten av livet på www.yahoo.se/mail
  Busenkelt!
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: =?iso-8859-1?q?Joshua=20Becker?=
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.com
 --
 Author: Anjo Kolk
   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!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Verrrry interesting article at MetaLink

2002-10-10 Thread Mercadante, Thomas F


Jared,

I think you have a case for at the very least getting credit for your work.

It's one thing for someone to see what you've done and use the functionality
like you did.

It's completely something else for someone to lift all the code verbatim
without even changing a comment.  It just shows laziness on the Oracle
analyst part.  

What really bothers me is that it implies the person did not even test it.
If they are lazy enough to steal it, what does it say about testing
procedures?

Go get'em.  You deserve accreditation.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 10, 2002 3:13 AM
To: Multiple recipients of list ORACLE-L




Dear list,

I found something rather interesting on MetaLink today.

While doing a little research on UTL_FILE, I came across
document # 1050919.6.  This document deals with how to
dump a table to an ascii file.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=1050919.6

I began to think the code looked a little familiar.  Then I
saw the temporary file name of '_dtmp.sql', which was 
rather reminiscent of file names I use.

Further perusal revealed that the comments were written 
by yours truly, and match word for word those I added to 
the dump.sql script years ago.

See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql

I don't know whether to be flattered or upset.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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.com
-- 
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).

Oracle9i RMAN Backup and Recovery


Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all 
to look at if you like. Here is the URL:

http://shop.osborne.com/cgi-bin/osborne/0072226625.html

Enjoy!

Robert

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Thursday, October 10, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L


We are in the midst of a big move to RMAN.  We use EMC's EDM to do
backups, and the SAs have been pushing us towards RMAN for a while now,
cause the EDM interface intergrates w/ RMAN seamlessly.  It really is a
nice backup solution.  (We started the process by upgrading all our EDM
units to 5.0)  Anyhow, we are setting up the RMAN catalog databases
ringht on the EDM boxes.  (The EDMs are Solaris boxes.)

It's working well.  We haven't yet fully rolled out, but all our testing
has worked fine.  We're about to start the production database migration
next week.

-Mark
On Thu, 2002-10-10 at 06:23, Connor McDonald wrote:
 There is a Metalink note (73431.1) which talks about
 the rman version compatibility, but it also states: 
 
 Ensure that the RMAN executable version matches the
 version of the target database that it is backing up
 
 which I presume to mean that you need to run rman from
 each target and push to the catalog  storage
 management node(s).  This is how I've always seen it
 done - but I've often wondered if one could get away
 driving eveything from the catalog node, pulling
 client databases over sqlnet  - thus only having a
 single TSM client (and license) on the rman catalog
 node.
 
 Cheers
 Connor
 
  --- MacGregor, Ian A. [EMAIL PROTECTED]
 wrote:  I'm  trying to use RMAN and TSM to backup
 multiple
  databases spread across various nodes with some
  nodes hosting more than one database.  The RMAN
  catalog database will reside on a node different
  from  any of the nodes hosting the other databases. 
  I have long used ADSM  without the RMAN clothing to
  backup the databases.  I have convinced the SA's to
  move on to TSM, and now I need to add the RMAN
  adornments.
  
  I assume I need the SA's to install TDP  for Oracle
  on all the nodes requiring RMAN backup.  Do I also
  need to install it on  the machine which will host
  the catalog database.  That database will undergo
  cold backup using naked TSM.  The same question
  applies to the tdpo.opt file.  Do I need multiple
  TDPO_FS values and multiple tdpo.opt files to hold
  them.
  
  
  I am also assuming I will start RMAN from one of the
  databases requiring backup and connect also to the
  RMAN catalog.  Is this typical.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: MacGregor, Ian A.
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). 
 
 =
 Connor McDonald
 http://www.oracledba.co.uk
 http://www.oaktable.net
 
 Remember amateurs built the ark - Professionals built the Titanic
 
 __
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
 http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  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.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

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

RE: SOLARIS to linux

2002-10-10 Thread Molina, Gerardo


Or, if money is no object, then you can use Shareplex from Quest.  It can
replicate from one platform to another.

Gerardo

-Original Message-
Sent: Wednesday, October 09, 2002 8:04 PM
To: Multiple recipients of list ORACLE-L


One needs to use export/import while changing hardware platforms for Oracle
databases. 

- Kirti 

-Original Message-
Sent: Wednesday, October 09, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi
Can any one share data migration from sun solaris to linux ? Thx -Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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.com
-- 
Author: Deshpande, Kirti
  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.com
-- 
Author: Molina, Gerardo
  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-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

2002-10-10 Thread Yechiel Adar

Title: Message



Hello all

HELP - and I am not an idiot.

Oracle 8.1.6.3.4 on NT.

We have a problem that the datafile for the 
application tables autoextended from 3.9 GB to 4.1 GB.
We are getting ora-01115 errors and the datafile is 
offline.
We tried export but it gets the same error.

The status now is that the datafile is offline. 

Alter datafile online 
needsrecovery.
Recovery gets I/O error and aborts.

Anybody knows how to get the data out?

As per Murphy's law, the last full backup of the database 
ran about 2 weeks ago
and nobody noticed that the backup job ended ok but 
without backing up the files.
So recovery means restoring from 2 weeks ago and applying 
archive logs for some hours.

Oracle support are sending someone with a utility that MAY 
save the day.

Any ideas ???

HELP

Yechiel AdarMehish

Re: Verrrry interesting article at MetaLink

2002-10-10 Thread Jared Still



Not interested in compensation.  Just a litte irritated that
the only change to the script was to remove my name.

Jared

On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
 you put the code out in the world without a comment in it about copying
 is not allowed and you've made it free for the taking.

 Compensation isn't likely. Credit is definitely due and should be
 given.

 --- [EMAIL PROTECTED] wrote:
  Jared,
  You should feel upset as well as flattered. In my view you have a
  strong
  case against Oracle for some form of compensation, as a minimum you
  should
  be credited in the article.
  Whether you can win against a  big corporation is another matter of
  course.
  I and many others can confirm that the document has been on your site
  for at
  least 3 - 4 years (although they state the article to be originally
  dated
  1998).
 
  I would certainly be in contact with Oracle about this. Perhaps a
  good
  starting point would be your sales rep or contact at wherever you are
  working now.
 
  John
 
  -Original Message-
  Sent: 10 October 2002 08:13
  To: Multiple recipients of list ORACLE-L
 
 
 
 
  Dear list,
 
  I found something rather interesting on MetaLink today.
 
  While doing a little research on UTL_FILE, I came across
  document # 1050919.6.  This document deals with how to
  dump a table to an ascii file.

 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b

  ase_id=NOTp_id=1050919.6
 
  I began to think the code looked a little familiar.  Then I
  saw the temporary file name of '_dtmp.sql', which was
  rather reminiscent of file names I use.
 
  Further perusal revealed that the comments were written
  by yours truly, and match word for word those I added to
  the dump.sql script years ago.
 
  See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
  I don't know whether to be flattered or upset.
 
  Jared
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jared Still
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.com
  --
  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).

 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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[2]: Verrrry interesting article at MetaLink

2002-10-10 Thread dgoulet


Jared,

Should you be irritated?  I've had some of the things I published on the
list put out as gospel elsewhere with my name attached  it's been a real pain
in the ^^$.  I don't know.  I think I'd feel flattered and relieved that no one
knows where it came from.

Dick Goulet

Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date:   10/10/2002 7:19 AM


Not interested in compensation.  Just a litte irritated that
the only change to the script was to remove my name.

Jared

On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
 you put the code out in the world without a comment in it about copying
 is not allowed and you've made it free for the taking.

 Compensation isn't likely. Credit is definitely due and should be
 given.

 --- [EMAIL PROTECTED] wrote:
  Jared,
  You should feel upset as well as flattered. In my view you have a
  strong
  case against Oracle for some form of compensation, as a minimum you
  should
  be credited in the article.
  Whether you can win against a  big corporation is another matter of
  course.
  I and many others can confirm that the document has been on your site
  for at
  least 3 - 4 years (although they state the article to be originally
  dated
  1998).
 
  I would certainly be in contact with Oracle about this. Perhaps a
  good
  starting point would be your sales rep or contact at wherever you are
  working now.
 
  John
 
  -Original Message-
  Sent: 10 October 2002 08:13
  To: Multiple recipients of list ORACLE-L
 
 
 
 
  Dear list,
 
  I found something rather interesting on MetaLink today.
 
  While doing a little research on UTL_FILE, I came across
  document # 1050919.6.  This document deals with how to
  dump a table to an ascii file.

 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b

  ase_id=NOTp_id=1050919.6
 
  I began to think the code looked a little familiar.  Then I
  saw the temporary file name of '_dtmp.sql', which was
  rather reminiscent of file names I use.
 
  Further perusal revealed that the comments were written
  by yours truly, and match word for word those I added to
  the dump.sql script years ago.
 
  See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
  I don't know whether to be flattered or upset.
 
  Jared
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jared Still
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.com
  --
  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).

 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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.com
-- 
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

RE: Index Oracle-l

2002-10-10 Thread Mercadante, Thomas F


how 'bout a reverse bitmap hash-partition leading-edge index?


-Original Message-
Sent: Thursday, October 10, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L


On Wed, Oct 09, 2002 at 09:18:30PM -0800, Joshua Becker wrote:
 INDEX ORACLE-L

indexing here won't help...

 
-  
ListGuru GENERAL Command HELP  
-  
  
This help file contains basic information about each command recognized by  
ListGuru.  More detailed help is available through these commands:  
  
HELP command  -- Gives detailed help about a given command (listed below)

HELP DETAILED   -- Complete and exhaustive help on ALL commands  
HELP USAGE  -- A general primer on how to use your mailing list  
HELP FAQ-- A list of Frequently Asked Questions (FAQ)  
  
  
Interacting with ListGuru:  
--  
  
ListGuru is a Mailing List Manager (MLM) which understands the commonly  
used commands of many other MLM's, including ListProc, listserv, Majordomo,

SmartList, Mailbase and Listcaster, among others.  
  
All commands should be sent by E-mail to the following address:  
  
[EMAIL PROTECTED] -- Note spelling closely...  
  
The Subject: line is ignored, so do not place commands on it.  Commands go  
in the message BODY, one command per line.  You can send as many commands in

a single message as you wish.  Each command has a specific format, as
outlined  
below.  In the explanations below, replace any word enclosed by angle
brackets,  
with an appropriate response.  For example:  
  
INFO list  
  
would be replaced with:  
  
INFO GARDENING-L  
  
Other command replacements:  
  
list   means the mailing list name (always suffixed with
-L)  
real name  means your given name or surname, not E-mail
address  
password   means a password given to you for closed lists  
search textmeans arbitrary text, not case sensitive  
option means a particular option, dependent on the command

filename   means a filename (no pathnames are allowed)  
commandmeans any ListGuru command  
descriptionmeans arbitrary text, case sensitive  
  
If you have any difficulties or questions regarding ListGuru, contact:  
  
[EMAIL PROTECTED]  
  
  
The following commands are recognized by ListGuru (in alphabetical order):  
--  
  
ALLMAIL list  
  Displays a short summary (who, when, what) of all messages received and  
  sent out since the last time a digest was produced (generally midnight of

  the previous day, but could be longer on low-traffic lists).  
  
  See Also: CONFIRM, LASTMAIL  
  
ARCHIVES  
  Displays a list of all mailing lists which have file archives and which  
  you are currently a subscriber to.  
  
  See Also: GET, INDEX, SEARCH, SUBMIT, VIEW  
  
BIOGRAPHY list INDEX 
BIOGRAPHY list user 
BIOGRAPHY list ALL 
BIOGRAPHY list 
BIOGRAPHY list DELETE 
  The general intent of the BIO command is to provide a way for list members

  to create a short biography for themselves, which is then available to
all 
  other members of the same list.  BIOGRAPHY can be shortened to BIO if you 
  prefer -- both spellings work equally well. 
 
  *** NOTE *** 
 
  This command is fairly detailed, so it is recommended that you  
  either issue a HELP DETAILED or a HELP BIO command to get the full set 
  of instructions for using this command. 
 
  Form #1: BIO list INDEX 
 
  Returns a complete list of whose bio is available for the given list.  As 
  an example, you could do a BIO GARDENING-L INDEX command and ListGuru
would 
  send back a list of all BIO's so far submitted for the GARDENING-L list. 
 
  Form #2: BIO list user 
 
  Sends back a BIO for a specific user.  Usually it is the next command you 
  issue after the INDEX form.  You will be sent back the complete biography 
  text as submitted by that specific user.  Be sure to use the name listed 
  in the INDEX form to get information on the right person. 
 
  Form #3: BIO list ALL 
 
  Similar to form #2, but sends ALL biographies that are available for the 
  list you specify.  A quick way to get familiar with everyone, instead of 
  just individual users. 
 
  Form #4: BIO list 
 
  This is how you submit your OWN biography.  When you use this form of the 
  command, it should be the only command you send in that message, and the 
  message MUST contain a uuencoded file containing your biography.  At the 
  current time, MIME attachments are not supported, so the attached file 
  must first be uuencoded, then sent with your message.  If you have
problems 
  with uuencode, contact [EMAIL PROTECTED] for assistance. 
 
  Form #5: BIO list DELETE 
 
  This form deletes any biography entry YOU have submitted for the list

Space... confusion


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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: Making a tablespace read-only - identifying blocking tx


It is not the export per se that causes the problem. It is the copying of
the datafile that is the issue. The tablespace must be made read only so
that the datafile can be copied in a consistent version. I can understand
(and support) no active tx in the tablespace, but why the whole (*#(*$#
database? If I need to take INVOICE_1999 tablespace and migrate it to an
ODS, why does it matter if Joe Accountant is adding an expense report in the
EXPENSE_2002 ts?

In the Oracle doc, it lists the requirements for making a ts read only. On
the next page it states (verbatim from doc)

You do not have to wait for transactions to complete before issuing the
ALTER
TABLESPACE ... READ ONLY statement. When the statement is issued, the target
tablespace goes into a transitional read-only mode in which no further write
operations (DML statements) are allowed against the tablespace. Existing
transactions that modified the tablespace are allowed to commit or rollback.
Once
all transactions (in the database) have completed, the tablespace becomes
read-only.

I love how Oracle buries a very important consideration in the very last
line of a paragraph!

We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do have
other options. The application architecture is such that I am pretty certain
very bad things would happen if I tried to but the database in restricted
mode.

Dan

-Original Message-
Sent: Thursday, October 10, 2002 5:09 AM
To: Multiple recipients of list ORACLE-L


so if it's waiting for any active transaction, I guess you could put
the database in restricted mode until existing transactions complete.
Of course, that sort of defeats the purpose of putting it in read-only
so other people can access it.

um, 9ir2 has an export parameter of tablespace, if you want it
read-only so nothing changes while you export it, how about using the
consistent=y export parameter in conjunction with the tablespace
export?


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And with that correction, it seems checking for active transactions
 (in
 v$transaction) would address this. 
  
 However, by the time one gets a 'green' light from v$transaction and
 issues
 alter tablespace... there is the slight possibility of someone
 starting a
 new transaction locally or just selecting over a dblink...
  
 Too bad that the new 'transitional read-only' mode does not allow a
 graceful
 exit... Per the Admin Guide one must set compatible to  8.1.0 to
 make the
 command fail...  
  
 I would be interested in learning how you tackle this issue as I am
 also
 trying to implement TTS in some of my databases. 
  
 Thanks.
  
 - Kirti 
  
 -Original Message-
 Sent: Wednesday, October 09, 2002 4:34 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Just a slight correction it will wait until any transaction against
 the
 entire database, not just the tablespace is completed.
  
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Wednesday, October 09, 2002 1:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I am creating a stored proc that will export a tablespace. One task
 it needs
 to perform is to place the tablespace(s) in read only mode to make a
 copy.
 Based upon the application and proc logic, there should not be any
 transactions against objects in the ts. However, if there are, the
 ALTER
 TABLESPACE command will wait until the transaction is completed. I
 would
 rather have the ALTER TABLESPACE command fail immediately. If I
 cannot do
 that, I would like to be able to test for locks on objects in the
 tablespace
 (figured that one out, but it is rather kludgy).
  
 Is there a method to force an immediate failure of ALTER TABLESPACE
 tsname
 READ ONLY if it cannot be immediatly completed?
 Is there a clean method/proc to determine if the ALTER TABLESPACE
 command
 will work?
  
 Dan Fink
 
 


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

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

RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

Title: Message



Note # 
148894.1 on Metalink has a possible solution... 

NT has a limit of 4GB for the file size :( 


- 
Kirti

-Original Message-From: Yechiel Adar 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 10:08 
AMTo: Multiple recipients of list ORACLE-LSubject: 
ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Hello all

HELP - and I am not an idiot.

Oracle 8.1.6.3.4 on NT.

We have a problem that the datafile for the 
application tables autoextended from 3.9 GB to 4.1 GB.
We are getting ora-01115 errors and the datafile is 
offline.
We tried export but it gets the same error.

The status now is that the datafile is offline. 

Alter datafile online 
needsrecovery.
Recovery gets I/O error and aborts.

Anybody knows how to get the data out?

As per Murphy's law, the last full backup of the database 
ran about 2 weeks ago
and nobody noticed that the backup job ended ok but 
without backing up the files.
So recovery means restoring from 2 weeks ago and applying 
archive logs for some hours.

Oracle support are sending someone with a utility that MAY 
save the day.

Any ideas ???

HELP

Yechiel AdarMehish

RE: Index Oracle-l

2002-10-10 Thread Gogala, Mladen

BITMAP INDEX ORACLE-L TABLESPACE LOST_IN_SPACE STORAGE (INITIAL 1M NEXT 1M)

 -Original Message-
 From: Joshua Becker [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 1:19 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Index Oracle-l

 INDEX ORACLE-L

 _
 Gratis e-mail resten av livet på www.yahoo.se/mail
 Busenkelt!
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?Joshua=20Becker?=
   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.com
--
Author: Gogala, Mladen
  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: cpu on AIX

2002-10-10 Thread Scott . Shafer


Henry,

I had a similiar situation occur recently on HPUX, Oracle 817.  CPU was
pegged out and users were complaining of taking over 5 minutes to quey one
record (usually took 5 seconds).  It was a matter of statistics not being
present on certain schema.  A quick analyze cleared it all up.  Just an
idea...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Henry Poras [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 09, 2002 6:35 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: cpu on AIX
 
 Dennis,
 Users are complaining, and at least this time the guilty process seems to
 be
 an import from a database out of my control. What I am trying to do is
 control how often this happens. It seems a bit strange that one moderate,
 single threaded import should drain both CPUs on the server, so I was
 trying
 to see how much could be pinned on those processes (imp and associated
 oracle shadow process)and how much was due to other use and poor
 configuration.
 
 As I mentioned, both %wio (wa on vmstat AIX) and %idle were ~0. Everything
 was split (kind of evenly 50-50 to 40-60) between %usr and %sys. Using ps
 -o
 pcpu I could pin about 30% of %CPU on the import. I am not sure if this
 includes the associated system calls (io) from this process. I don't think
 so. (I wasn't seeing my %CPU adding up to 100% earlier because I was
 leaving
 out the kernal processes. I needed a ps -k flag).
 
 Now I am seeing some other funky stuff (maybe related, maybe not. I
 haven't
 looked carefully for this before so I don't know) on the same machine. The
 import ended and the %usr %sys breakdown was still 40-60. There are two
 kproc processes (async IO???) each using 44.4%CPU. That's been unchanged
 for
 hours and the machine is not being heavily used. Also, some other
 processes
 are using 10-20%CPU which puts me up over 100% (I guess it really can give
 120%).
 
 I'll let you know what I find.
 
 Henry
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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:DROP DEVELOPER not working

2002-10-10 Thread dgoulet


Raj,

I'll take OTS's point of view on the subject, namely if the duhveloper can
drop the table via SQL*Plus then he needs to call the vendor of the third party
application.  The database responds to a command the same way no matter where
the command is issued from if it is complete and executed.  More than likely
there's either a bug in the third party code or else in his configuration
thereof.

More than likely, and I've seen this before (actually did it myself), the
application is doing something like a 'select count(*) from tablename;' and as
long as count(*)  0 it will wait,  Well when the application leaves data laying
around without cleaning up after itself guess what happens.  DUH!!!

Dick Goulet

PS: I liked the drop duhveloper off of third floor balcony idea.  But I still
prefer the 12 gauge shotgun method.  It's faster  leaves a more noticeable
mark!!  *-)

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/9/2002 1:28 PM

We have a developer here, installing a third party application, who claims
one of his delete campaign process is hanging. I looked at the wait
events, saw nothing, and asked him to politely to go look at the code.
After much analysys, the developer now complains, that Oracle is not
executing a drop table command at the end of the process, and hanging
there. He claims he can drop the table from SQLPLUS.

I asked him to rerun the process. I noticed no wait events for that session
in v$session_wait when he claims the process is hanging. I see no DROP
statements in the v$sqlarea. I did a 10046 trace, and the last statement in
the trace file is a select statement.  I looked at the sql addresses from
v$session, linked it to v$sqlarea and the sql_text shows the same select
statement as is seen in the trace file. I see no exclusive locks on the
said table. I conclude that the application is not sending a DROP statement
to Oracle for execution. He claims that cannot be the case. They have done
the same installation in a test environment and it worked fine. The jury
seems to be taking sides. I scream SOS. What more should I be doing? And
Does an Oracle 10046 trace write into the trace file after the statement
has executed?

Thanks
Raj




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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: Making a tablespace read-only - identifying blocking tx


That would be one option, but we are trying to avoid the overhead of the
import process as we move the data to a new database. This process will
happen daily and transporting a tablespace and plugging in a datafile is
perceived to be faster (has not been tested yet).

Dan

-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L


Why don't you just to a consistant export?  That will not take any
transaction after the start of the export, at leasst this is how I
understand it.

Ruth.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  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: Listener Problem

2002-10-10 Thread Peter Barnett


Unfortunately, our company is large enough that no one
ever really has to admit to anything because it is
simply too difficult to run down the perpetrators.  

The listener did start.  Some users could connect to
the databases from one server but not another.  We
think it was related to an intrusion software install,
but the back out of the install did not fix the
problem.  There was a giant meeting of everyone who
might have any impact on the box and minutes after the
meeting ended everything was working again.  My guess
is that someone in the meeting recognized a mistake
and corrected it without saying anything.  So, we will
never know the true cause.

 
--- #34;Jesse, Rich#34;
lt;[EMAIL PROTECTED]gt; wrote:
gt; As luck would have it, we just went through a
gt; similar problem.
gt; 
gt; Does the listener actually startup?  Can you stop
gt; and restart it manually
gt; using #34;lsnrctl#34;?
gt; 
gt; Ours wouldn't.  We tracked it down to two
problems,
gt; both security related.
gt; The one that was hampering our listener was a
change
gt; in /etc/nsswitch.conf
gt; that caused a change in the way that the listener
gt; tried to listen on the
gt; port.  Specifically, look for differences in the
gt; #34;protocols#34; line and the
gt; #34;services#34; line.  Also, potentially, the
#34;ipnodes#34;
gt; line.
gt; 
gt; We were installing LDAP and had changed these
lines
gt; to #34;ldap
gt; [NOTFOUND=return] files#34;, but the listener
just
gt; didn't like it, so we
gt; changed them back to just #34;files#34;.  Also,
the only
gt; time we'd see a problem
gt; is in the start and stop of the listener.  If we
gt; changed the files back to
gt; #34;ldap...#34; while the listener was up,
connections
gt; worked fine.  We just
gt; couldn't start it back up if it was shutdown.
gt; 
gt; Barring this, check for security differences in
your
gt; #34;bin#34; and #34;network#34; dir
gt; trees under $ORACLE_HOME.  Check for owner, group
gt; and protection bits.
gt; 
gt; HTH!  GL!  :)
gt; 
gt; Rich
gt; 
gt; 
gt; Rich Jesse  
System/Database
gt; Administrator
gt; [EMAIL PROTECTED]  Quad/Tech
gt; International, Sussex, WI USA
gt; 
gt; 
gt; gt; -Original Message-
gt; gt; From: Peter Barnett
[mailto:[EMAIL PROTECTED]]
gt; gt; Sent: Wednesday, October 09, 2002 2:09 PM
gt; gt; To: Multiple recipients of list ORACLE-L
gt; gt; Subject: Listener Problem
gt; gt; 
gt; gt; 
gt; gt; Yesterday we had a cpu panic followed by a
gt; spontaneous
gt; gt; reboot of a Sun E6000 server.  When the
server and
gt; gt; databases came back on line we were getting
'no
gt; gt; listener' errors from several Unix servers
but not
gt; all
gt; gt; of them.  We also lost connectivity between
the
gt; gt; mainframe and the databases on the affected
gt; server. 
gt; gt; Those that failed were consistent, those
that
gt; conected
gt; gt; were also consistent.  
gt; gt; 
gt; gt; The Unix Admin captured the following lines
from a
gt; gt; netsta -an command:
gt; gt; 
gt; gt; Following line is from dragon - the server
that
gt; has
gt; gt; the TNSLISTENER on only one interface
gt; gt; 
gt; gt; 161.208.1.138.1521 *.*  
 0   
gt;   0
gt; gt; 0  0 LISTEN
gt; gt; 
gt; gt; 
gt; gt; Following line is from beowulf - the server
that
gt; has
gt; gt; the TNSLISTENER on all interfaces
gt; gt; 
gt; gt;   *.1521   *.*  
 0   
gt;   0
gt; gt; 0  0 LISTEN
gt; gt; 
gt; gt; He is focusing the ip address binding to the
gt; oracle
gt; gt; port on one server but using a wild card for
the
gt; gt; other.
gt; gt; 
gt; gt; We have a tar open for this but so far, they
have
gt; not
gt; gt; been too helpful.
gt; gt; 
gt; -- 
gt; Please see the official ORACLE-L FAQ:
gt; http://www.orafaq.com
gt; -- 
gt; Author: Jesse, Rich
gt;   INET: [EMAIL PROTECTED]
gt; 
gt; Fat City Network Services-- 858-538-5051
gt; http://www.fatcity.com
gt; San Diego, California-- Mailing list and
web
gt; hosting services
gt;
-
gt; To REMOVE yourself from this mailing list, send
an
gt; E-Mail message
gt; to: [EMAIL PROTECTED] (note EXACT spelling of
gt; 'ListGuru') and in
gt; the message BODY, include a line containing:
UNSUB
gt; ORACLE-L
gt; (or the name of mailing list you want to be
removed
gt; from).  You may
gt; also send the HELP command for other information
gt; (like subscribing).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  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

RE: DROP DEVELOPER not working

Title: RE: DROP DEVELOPER not working



I hear 
that they are enhancing that command in 10i. You know have the option of naming 
the employment position:
drop 
manager
drop 
user
drop 
cow-worker
etc...

I 
recall that in Unix, the trace file is written right away, but NT waits for the 
process to complete. *Could be wrong on this one...only 1 cup of coffee this 
morning

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 
  2002 5:39 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: DROP DEVELOPER not 
working
  (taking a cue from RMAN syntax) 
  drop developer developer_name from third_floor 
  position upside_down immediate / 
  works for me all the time ... (sorry couldn't resist ... I 
  have been a developer too for 8+ years) 
  BTW 10046 will write the sql statement to trace file as soon 
  as it is parsed ... it will have appropriate entry for execution as well 
  ...
  Also, see if developer is doing all this inside a script ... 
  take a closer look for a missing / or a semicolon ... 
  Sometimes the best solution is an extra pair of eyes to see 
  your code pick the person who hates you most, chances are he/she will find the 
  most bugs in the least anount of time. It's human nature ...
  Raj __ Rajendra Jamadagni 
   MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any 
  opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
  QOTD: Any clod can have facts, but having an opinion 
  is an art!

RE: Oracle9i RMAN Backup and Recovery


Congratulations, Robert!! 

Looking forward to receiving my copy... 

- Kirti 

-Original Message-
Sent: Thursday, October 10, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all 
to look at if you like. Here is the URL:

http://shop.osborne.com/cgi-bin/osborne/0072226625.html

Enjoy!

Robert

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Thursday, October 10, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L


We are in the midst of a big move to RMAN.  We use EMC's EDM to do
backups, and the SAs have been pushing us towards RMAN for a while now,
cause the EDM interface intergrates w/ RMAN seamlessly.  It really is a
nice backup solution.  (We started the process by upgrading all our EDM
units to 5.0)  Anyhow, we are setting up the RMAN catalog databases
ringht on the EDM boxes.  (The EDMs are Solaris boxes.)

It's working well.  We haven't yet fully rolled out, but all our testing
has worked fine.  We're about to start the production database migration
next week.

-Mark
On Thu, 2002-10-10 at 06:23, Connor McDonald wrote:
 There is a Metalink note (73431.1) which talks about
 the rman version compatibility, but it also states: 
 
 Ensure that the RMAN executable version matches the
 version of the target database that it is backing up
 
 which I presume to mean that you need to run rman from
 each target and push to the catalog  storage
 management node(s).  This is how I've always seen it
 done - but I've often wondered if one could get away
 driving eveything from the catalog node, pulling
 client databases over sqlnet  - thus only having a
 single TSM client (and license) on the rman catalog
 node.
 
 Cheers
 Connor
 
  --- MacGregor, Ian A. [EMAIL PROTECTED]
 wrote:  I'm  trying to use RMAN and TSM to backup
 multiple
  databases spread across various nodes with some
  nodes hosting more than one database.  The RMAN
  catalog database will reside on a node different
  from  any of the nodes hosting the other databases. 
  I have long used ADSM  without the RMAN clothing to
  backup the databases.  I have convinced the SA's to
  move on to TSM, and now I need to add the RMAN
  adornments.
  
  I assume I need the SA's to install TDP  for Oracle
  on all the nodes requiring RMAN backup.  Do I also
  need to install it on  the machine which will host
  the catalog database.  That database will undergo
  cold backup using naked TSM.  The same question
  applies to the tdpo.opt file.  Do I need multiple
  TDPO_FS values and multiple tdpo.opt files to hold
  them.
  
  
  I am also assuming I will start RMAN from one of the
  databases requiring backup and connect also to the
  RMAN catalog.  Is this typical.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: MacGregor, Ian A.
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). 
 
 =
 Connor McDonald
 http://www.oracledba.co.uk
 http://www.oaktable.net
 
 Remember amateurs built the ark - Professionals built the Titanic
 
 __
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
 http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  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

RE: Space... confusion

2002-10-10 Thread Vergara, Michael (TEM)


April:

I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?

HTH,
Mike


-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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).

RE: DROP DEVELOPER not working

2002-10-10 Thread Jesse, Rich


DROP COW-WORKER only works here in the Dairy State...  ;)

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, October 10, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


I hear that they are enhancing that command in 10i. You know have the option
of naming the employment position:
drop manager
drop user
drop cow-worker
etc...
 
I recall that in Unix, the trace file is written right away, but NT waits
for the process to complete. *Could be wrong on this one...only 1 cup of
coffee this morning
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Verrrry interesting article at MetaLink

2002-10-10 Thread Gogala, Mladen


Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having your name
embedded into the oracle source code is something much better.
Jared, in a few millenniums, with Oracle 256(i?) you'll be one of
the most celebrated individuals in the galaxy, standing next to Hari 
Seldon or Zaphod Beeblebrox.

 -Original Message-
 From: Cary Millsap [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 3:58 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Vey interesting article at MetaLink
 
 
 I've learned that those two emotions are not mutually exclusive.
 
 If you name's not in Oracle's source code somewhere, then I'd suggest
 you write someone at Oracle a note. It's an easy problem for them to
 solve.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
 - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
 - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
 
 
 -Original Message-
 Still
 Sent: Thursday, October 10, 2002 2:13 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Dear list,
 
 I found something rather interesting on MetaLink today.
 
 While doing a little research on UTL_FILE, I came across
 document # 1050919.6.  This document deals with how to
 dump a table to an ascii file.
 
 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo
 cument?p_d
 atabase_id=NOTp_id=1050919.6
 
 I began to think the code looked a little familiar.  Then I
 saw the temporary file name of '_dtmp.sql', which was 
 rather reminiscent of file names I use.
 
 Further perusal revealed that the comments were written 
 by yours truly, and match word for word those I added to 
 the dump.sql script years ago.
 
 See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
 I don't know whether to be flattered or upset.
 
 Jared
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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.com
 -- 
 Author: Cary Millsap
   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.com
-- 
Author: Gogala, Mladen
  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: DROP DEVELOPER not working - 10046 trace


And  I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?

- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -


   
 
Rajesh Rao 
 
 To: [EMAIL PROTECTED]  
 
October 10,  cc:   
 
2002 10:14 AMSubject: RE: DROP DEVELOPER not working - 
10046 trace(Document link:   
 Rajesh Rao)   
 
   
 




As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file.  Why dont I see it here? The entries in the trace file are :

PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0





   
 
Rajesh Rao 
 
 To: [EMAIL PROTECTED]  
 
October 10,  cc:   
 
2002 12:34 AMSubject: RE: DROP DEVELOPER not 
working(Document link: Rajesh Rao) 
   
 
   
 



Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.

Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.

Thanks
Raj




   
   
Deshpande, Kirti 
   
kirti.deshpande@veTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
rizon.com cc: 
   
Sent by:   Subject: RE: DROP DEVELOPER not 
working
[EMAIL PROTECTED]   
   
   
   
   
   
October 09, 2002   
   
10:58 PM

RE: Loading a flat file into Oracle

2002-10-10 Thread Don Malzahn


Santosh,

The Oracle Utilities manual is not bad either, it explains sqlldr and 
export and import, all database utilities that come with the database.

Find it at the Oracle web site if you don't have a copy.

 I suggest you look at sqlloader. There are some good pages on the FAQ
 associated with this site



   I have a client who will be doing the data capture and give me the
 data in a flat file.
 what i need to do in oracle is load from that flat file to my database.
 any scripts available ?? please send me across. ASAP


Don Malzahn, IT/AS, Harper Community College   Voice:(847) 925-6829
E-mail: [EMAIL PROTECTED]Web page: http://www.harper.cc.il.us
The only limit to our realization of tomorrow will be our doubts of
today. - FDR



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Malzahn
  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: Advice needed on move to Sun 15K (losing spindles)


More than separate ORACLE_HOMEs, you might also consider individual oracle
software owner accounts and dba and oper groups for each database...

Folks often install all Oracle distributions under a single account,
oracle, specifying a single SYSDBA group (dba) and a single SYSOPER
group (oper).  The intent is usually to have database instances share
ORACLE_HOMEs where possible...

There are several practical downsides to this:
* different applications may require different patch levels of the same
version (i.e. same ORACLE_HOME)
* it is difficult to track resource consumption (i.e. cpu, memory, I/O)
using OS utilities if numerous Oracle database instances run under the
single oracle account
* if administration of different database instances is to be performed
by separate individuals or teams, there is no way to isolate/protect each
team's territory from another

Although HW vendors (including Sun) have developed partitioning schemes
for servers, it is perhaps overkill.  A form of server partitioning has
always been possible by making creative use of OS accounts and groups.  The
major difference between the HW vendors server partitioning scheme and
using OS accounts to separate things is the fact that the former actually
assigns groups of CPUs and allocates memory to each partition.  Dividing by
OS accounts allows all resources to be shared amongst the partitions.  The
trade-offs should be obvious...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 3:18 PM


 Others have addressed the performance issues.

 What about the admin issues?

 If consolidate to a single server, consider a separate
 ORACLE_HOME for each database.  You may need
 to apply different patches to fix different problems in
 various databases.

 You have this ability now, but will lose it if you consolidate
 without separate ORACLE_HOME's.

 Something else you will lose is the ability to reboot the
 server if needed for a single database.

 Since you may be moving to a 15k, investigate server
 partitioning to retain this functionality.

 Jared





 Miller, Jay [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  10/09/2002 11:53 AM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
 cc:
 Subject:Advice needed on move to Sun 15K (losing spindles)


  Our  CIO  has  suggested that we get a Sun 15K to house all of our
 databases.  This has some advantages (communication between the various
 boxes would be much faster) but I have some performance concerns.

 Specifically, our main OLTP database would go down from 18 spindles to 8
 spindles.  Mirroring will take away 4 of those leaving 4 spindles.  The
 vendor (Sun) was recommending striping across all 4 spindles. He said we
 don't need to worry about i/o issues because there will be a large cache.

 I'm skeptical and argued for cutting them in half (striping 2 and 2).  We
 could then at least seperate the redo logs from the datafiles (probably
 putting them with the oracle executables and some other files).

 The Sun rep kept talking up how much more powerful the CPUs were and I
 kept
 saying, but we're not CPU bound, we don't need any more CPU.

 If anyone can either

 a) tell me I'm worrying for nothing
 b) recommend a better way to stripe/distribute my files
 c) provide references  or experience to show this is a bad idea

 I'd really appreciate it.


 Thanks,
 Jay Miller


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Miller, Jay
   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.com
 --
 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.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Jamadagni, Rajendra

Title: RE: DROP DEVELOPER not working - 10046 trace





execution plan comes at the end ... that's why ...


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DROP DEVELOPER not working - 10046 trace



And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?




*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

Not Oracle DBA problem:APPS 11/ WinNt: HRMS export of query results generates FRM-99999 error 2 with Explorer 5 on win2000

2002-10-10 Thread Inka Bezdziecka


Good morning,
if it is good, which I doubt...
It is not Oracle database problem, unfortunately is showing within Oracle, so...need I 
say more?

I wonder if any of you had a misfortune (which I truly hope one had) of running into 
the PC set-up problem, which generates the error:
FRM-9: Failed to execute command. 
 Command =iexplore server:80/OA_HTML/bin/fndvfile.exe?id
 Full Details: 
CreateProcess:iexplore.exe
server:80/OA_HTML/bin/fndvfile.exe?id
 error=2 
I have checked MetaLink - there are similar problems - nothing worked for this case. 

Error is generated during ActionExport (query results). 
I have added to PATH C:\Program Files\Internet Explorer; and restarted that PC. 
That function works on another Windows2000 PC, and stopped working after a new PC was 
set up.
Since I do not know how to spell PC, I would appreciate some directions where to look 
to compare both.

Could it be an authorisation problem? Should user account be created locally and added 
to the Local Administration Group? It seems that there is only domain account.
Microsoft experts in here are rather well...junior, so  I need desperately some help.
Since it is so distant relation to Oracle, the blessed soul who can help me, please 
contact me at [EMAIL PROTECTED] This way the rest of company will be spared. 

inka
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
  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: Making a tablespace read-only - identifying blocking tx

2002-10-10 Thread Henry Poras


But can you know for sure if an open txn will hit your tablespace until the
txn is closed?

Henry

-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


It is not the export per se that causes the problem. It is the copying of
the datafile that is the issue. The tablespace must be made read only so
that the datafile can be copied in a consistent version. I can understand
(and support) no active tx in the tablespace, but why the whole (*#(*$#
database? If I need to take INVOICE_1999 tablespace and migrate it to an
ODS, why does it matter if Joe Accountant is adding an expense report in the
EXPENSE_2002 ts?

In the Oracle doc, it lists the requirements for making a ts read only. On
the next page it states (verbatim from doc)

You do not have to wait for transactions to complete before issuing the
ALTER
TABLESPACE ... READ ONLY statement. When the statement is issued, the target
tablespace goes into a transitional read-only mode in which no further write
operations (DML statements) are allowed against the tablespace. Existing
transactions that modified the tablespace are allowed to commit or rollback.
Once
all transactions (in the database) have completed, the tablespace becomes
read-only.

I love how Oracle buries a very important consideration in the very last
line of a paragraph!

We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do have
other options. The application architecture is such that I am pretty certain
very bad things would happen if I tried to but the database in restricted
mode.

Dan

-Original Message-
Sent: Thursday, October 10, 2002 5:09 AM
To: Multiple recipients of list ORACLE-L


so if it's waiting for any active transaction, I guess you could put
the database in restricted mode until existing transactions complete.
Of course, that sort of defeats the purpose of putting it in read-only
so other people can access it.

um, 9ir2 has an export parameter of tablespace, if you want it
read-only so nothing changes while you export it, how about using the
consistent=y export parameter in conjunction with the tablespace
export?


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And with that correction, it seems checking for active transactions
 (in
 v$transaction) would address this.

 However, by the time one gets a 'green' light from v$transaction and
 issues
 alter tablespace... there is the slight possibility of someone
 starting a
 new transaction locally or just selecting over a dblink...

 Too bad that the new 'transitional read-only' mode does not allow a
 graceful
 exit... Per the Admin Guide one must set compatible to  8.1.0 to
 make the
 command fail...

 I would be interested in learning how you tackle this issue as I am
 also
 trying to implement TTS in some of my databases.

 Thanks.

 - Kirti

 -Original Message-
 Sent: Wednesday, October 09, 2002 4:34 PM
 To: Multiple recipients of list ORACLE-L


 Just a slight correction it will wait until any transaction against
 the
 entire database, not just the tablespace is completed.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 -Original Message-
 Sent: Wednesday, October 09, 2002 1:49 PM
 To: Multiple recipients of list ORACLE-L


 I am creating a stored proc that will export a tablespace. One task
 it needs
 to perform is to place the tablespace(s) in read only mode to make a
 copy.
 Based upon the application and proc logic, there should not be any
 transactions against objects in the ts. However, if there are, the
 ALTER
 TABLESPACE command will wait until the transaction is completed. I
 would
 rather have the ALTER TABLESPACE command fail immediately. If I
 cannot do
 that, I would like to be able to test for locks on objects in the
 tablespace
 (figured that one out, but it is rather kludgy).

 Is there a method to force an immediate failure of ALTER TABLESPACE
 tsname
 READ ONLY if it cannot be immediatly completed?
 Is there a clean method/proc to determine if the ALTER TABLESPACE
 command
 will work?

 Dan Fink




__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  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.com
--
Author: Fink, Dan

RE: Verrrry interesting article at MetaLink

2002-10-10 Thread Inka Bezdziecka


Jared,
Yes, you should be both.

Well, this not a legal advise, just my personal view:
 I would find a layer, who specialises in the intellectual property laws, sue Oracle 
... and settle.

Add a clause to the header, which will allow for usage of your scripts the way you 
mean it.

For all those of you, who may be in the similar situation, here is an anecdote from my 
previous life.

 When times were less certain and rules adhered to seldom and far apart, the way to 
protect oneself in case of a future legal dispute was:
 - write (by hand) on whatever you created
 - seal in the envelope 
 - send to oneself by the registered post
 - put into a safe without  opening

 Sad but real.

inka


-Original Message-
Sent: Thursday, October 10, 2002 3:13 AM
To: Multiple recipients of list ORACLE-L




Dear list,

I found something rather interesting on MetaLink today.

While doing a little research on UTL_FILE, I came across
document # 1050919.6.  This document deals with how to
dump a table to an ascii file.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1050919.6

I began to think the code looked a little familiar.  Then I
saw the temporary file name of '_dtmp.sql', which was 
rather reminiscent of file names I use.

Further perusal revealed that the comments were written 
by yours truly, and match word for word those I added to 
the dump.sql script years ago.

See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql

I don't know whether to be flattered or upset.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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.com
--
Author: Inka Bezdziecka
  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: Space... confusion


Which files were being reported in the ORA-01114s? Could you provide more
info as to the exact architecture of the db files and file system. For
example, is it a single file system and ALL database files (including redo
logs/archived logs/temp files/...) are stored on it. Are the control
files/dump files also stored there?

-Original Message-
Sent: Thursday, October 10, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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.com
-- 
Author: Fink, Dan
  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: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

2002-10-10 Thread Johnston, Tim

Title: Message

Looks
like your stuck... Maybe someone else can help... Good luck...

Doc
ID:
Note:148894.1

Subject:
ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on
NT/2000 Platforms

Type:
ALERT

Status:
PUBLISHED

Content Type:
TEXT/PLAIN

Creation Date:
07-JUN-2001

Last Revision Date:
25-JUL-2002Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms ~ Change Record ~~ 27-Dec-01: The fix release in the Patches section of this alert was modified from 8.1.7.2 to 8.1.7.3. Versions Affected ~ The problems described here can affect releases 8.1.6 and 8.1.7. Platforms Affected ~~ The problems affect Oracle8i releases on Windows NT and Windows 2000. Description ~~~ Releases of Oracle8i on Windows NT and Windows 2000 platforms can exhibitserious problems when a datafile autoextends or is resized onto a 4GBboundary (e.g. 4GB, 8GB).When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend: a. when in noarchive log mode it causes the database to crash b. when in archive log mode the file is marked offline in V$RECOVER_FILEWhen not in archive log mode, it is safe to restart the database andcontinue, altering datafiles to autoextend onto different boundaries asap.NOTE: It may be necessary to stop and restart the OracleService itself.The only way to recover this file when in archive log mode is to restorethe whole database and roll forward to a point before the file autoextended.Likelihood of Occurrence It is highly likely that problems will be encountered if an attempt is made to autoextend or resize a datafile onto a 4Gb boundary. Possible Symptoms ~ The possible symptoms from this problem are:a. The database crashes (when in noarchive log mode) and the alert fileand database writer (DBW0) trace file report: KCF: write/open error block=0xX online=Yfile=N '..'error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'b. The file is marked offline in V$RECOVER_FILE and access to the databasecontinues. The following error appears in the alert.log: KCF: write/open error block=0xX online=Yfile=N '..'error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)' Automatic datafile offline due to write error on file N: '..' Workaround ~~ The only safe workaround at present is to ensure that no file is resized orcreated to autoextend onto a 4Gb boundary. This is best achieved by makingsure all datafiles have AUTOEXTEND disabled.It is advisable to read the article below which describes potentialissues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use. Patches ~~~A fix is now available in 8.1.7.1.4 Bug.1823173 and will be included in8.1.7.3 BUG.1794199References ~~ 2Gb or not 2Gb - File limits in Oracle[NOTE:62427.1] Base bug reporting this problem [BUG:1668488]

-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 11:08
AMTo: Multiple recipients of list ORACLE-LSubject:
ora-01115 after datafile autoexetend from 3.9 GB to 4.1
GB
Hello all

HELP - and I am not an idiot.

Oracle 8.1.6.3.4 on NT.

We have a problem that the datafile for the
application tables autoextended from 3.9 GB to 4.1 GB.
We are getting ora-01115 errors and the datafile
is offline.
We tried export but it gets the same error.

The status now is that the datafile is offline.

Alter datafile online
needsrecovery.
Recovery gets I/O error and aborts.

Anybody knows how to get the data out?

As per Murphy's law, the last full backup of the
database ran about 2 weeks ago
and nobody noticed that the backup job ended ok but
without backing up the files.
So recovery means restoring from 2 weeks ago and
applying archive logs for some hours.

Oracle support are sending someone with a utility that
MAY save the day.

Any ideas ???

HELP

Yechiel AdarMehish

RE: DROP DEVELOPER not working - 10046 trace




As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file.  Why dont I see it here? The entries in the trace file are :

PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0





   
 
Rajesh Rao 
 
 To: [EMAIL PROTECTED]  
 
October 10,  cc:   
 
2002 12:34 AMSubject: RE: DROP DEVELOPER not 
working(Document link: Rajesh Rao) 
   
 
   
 



Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.

Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.

Thanks
Raj




   
   
Deshpande, Kirti 
   
kirti.deshpande@veTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
rizon.com cc: 
   
Sent by:   Subject: RE: DROP DEVELOPER not 
working
[EMAIL PROTECTED]   
   
   
   
   
   
October 09, 2002   
   
10:58 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Revoke the drop/delete privilege from role/userid, and ask them to run the
process. That would confirm if the code ever encounters the drop/delete
instruction.
The process could very well be data dependent...

- Kirti

-Original Message-
Sent: Wednesday, October 09, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L


It worked fine in development!

I can't believe anyone would still say that.

Has your duhveloper traced the code in the current environment,
to ensure that the offending piece of

RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

2002-10-10 Thread Vergara, Michael (TEM)

Title: Message



This is interesting. I had a vendor do an install on 
one
of our NT servers, and they set the files to autoextend 
to
8GB. When I modified that limit down to 2GB (our 
company
standard) they clouded up and rained all over 
me! They said
there was no physical reason to limit the file size 
since
it was on a RAID array blah blah blah.

I read the note and it talks about extending to a 4GB or 
8GB
boundary. Is that kinda like the speed of light...where 
some
physicists have theorized that you can travel below the 
speed
of light or above the speed of light, but not AT the 
speed
of light? Gosh! Who knew?

Cheers,
Mike

-Original Message-From: Deshpande, Kirti 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 
8:29 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 
GB

  Note 
  # 148894.1 on Metalink has a possible solution... 
  
  NT has a limit of 4GB for the file size 
  :( 
  
  - 
  Kirti

RE: Verrrry interesting article at MetaLink

2002-10-10 Thread Gesler, Rich


Actually, Oracle 256i is slated for a June, 2012 release.  

-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having your name
embedded into the oracle source code is something much better.
Jared, in a few millenniums, with Oracle 256(i?) you'll be one of
the most celebrated individuals in the galaxy, standing next to Hari 
Seldon or Zaphod Beeblebrox.

 -Original Message-
 From: Cary Millsap [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 3:58 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Vey interesting article at MetaLink
 
 
 I've learned that those two emotions are not mutually exclusive.
 
 If you name's not in Oracle's source code somewhere, then I'd suggest
 you write someone at Oracle a note. It's an easy problem for them to
 solve.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
 - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
 - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
 
 
 -Original Message-
 Still
 Sent: Thursday, October 10, 2002 2:13 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Dear list,
 
 I found something rather interesting on MetaLink today.
 
 While doing a little research on UTL_FILE, I came across
 document # 1050919.6.  This document deals with how to
 dump a table to an ascii file.
 
 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo
 cument?p_d
 atabase_id=NOTp_id=1050919.6
 
 I began to think the code looked a little familiar.  Then I
 saw the temporary file name of '_dtmp.sql', which was 
 rather reminiscent of file names I use.
 
 Further perusal revealed that the comments were written 
 by yours truly, and match word for word those I added to 
 the dump.sql script years ago.
 
 See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
 I don't know whether to be flattered or upset.
 
 Jared
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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.com
 -- 
 Author: Cary Millsap
   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.com
-- 
Author: Gogala, Mladen
  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.com
--
Author: Gesler, 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: Space... confusion


Is journaling, but journal isn't in that file system, just on the raw part
of the volume group

April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous


-Original Message-
Sent: Thursday, October 10, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L


April:

I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?

HTH,
Mike


-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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: DROP DEVELOPER not working - 10046 trace


Execution plan is not generated by using event 10046 for tracing.

If you using 8i+, there is a way to prevent owner of the table from
performing ddl.
Here's a post by Joe Testa quite some time ago. 
And I have used this process successfully. 

HTH,
- Kirti

On Thu, 6 Jan 2000, Joseph Testa wrote:

 Why would you want to do that, well, i'm at a place where the developers 
 have the schema owner password but we DBAs(being retentitive as we
are)dont 
 want them to make any ddl changes.
 
 
 here are the steps:
 
 Feel free to change the names to your liking
 
 create user schema_control identified by passwd
 grant create any trigger to schema_control;
 
 edit the 3 following triggers, changing the SCHEMA_NAME to the schema
you 
 want to put the control on:
 
 create or replace trigger create_control_trigger
 before create on SCHEMA_NAME.schema
 
 begin
   raise_application_error(-20001,'NO CREATE DDL ALLOWED');
 end;
 /
 
 create or replace trigger drop_control_trigger
 before drop on SCHEMA_NAME.schema
 
 begin
   raise_application_error(-20001,'NO DROP DDL ALLOWED');
 end;
 /
 
 create or replace trigger alter_control_trigger
 before alter on SCHEMA_NAME.schema
 
 begin
   raise_application_error(-20001,'NO ALTER DDL ALLOWED');
 end;
 /
 
 
 revoke alter any trigger from SCHEMA_NAME;
 
 the previous line is needed so they dont alter the trigger to disable it
:)
 
 the next time they attempt to create, drop or alter anything in that
schema 
 they get error msg.
 
 This all assumes they are not dba :)
 
 hht, joe

-Original Message-
Sent: Thursday, October 10, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L


And  I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?

- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -


 

Rajesh Rao

 To: [EMAIL PROTECTED]

October 10,  cc:

2002 10:14 AMSubject: RE: DROP DEVELOPER not
working - 10046 trace(Document link:   
 Rajesh Rao)

 





As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file.  Why dont I see it here? The entries in the trace file are :

PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=33977073
4
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=3397707
34
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=33977073
4
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0





 

Rajesh Rao

 To: [EMAIL PROTECTED]

October 10,  cc:

2002 12:34 AMSubject: RE: DROP DEVELOPER not
working(Document link: Rajesh Rao) 
 

 




Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.

Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.

Thanks
Raj




 

Deshpande, Kirti

kirti.deshpande@veTo: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
rizon.com cc:

Sent by:   Subject: RE: DROP
DEVELOPER not working
[EMAIL PROTECTED]

 

 

October 09, 2002

10:58 PM

Please respond to

ORACLE-L

 

 





Revoke the drop/delete privilege from role/userid, and ask

RE: Index Oracle-l


Are you sure an index is appropriate? Will it actually reduce the LIOs or
will it artifically inflate the BCHR? This is just the kind of thinking that
Cary is trying to eradicate!

-Original Message-
Sent: Thursday, October 10, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


how 'bout a reverse bitmap hash-partition leading-edge index?


-Original Message-
Sent: Thursday, October 10, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L


On Wed, Oct 09, 2002 at 09:18:30PM -0800, Joshua Becker wrote:
 INDEX ORACLE-L

indexing here won't help...

 
-  
ListGuru GENERAL Command HELP  
-  
  
This help file contains basic information about each command recognized by  
ListGuru.  More detailed help is available through these commands:  
  
HELP command  -- Gives detailed help about a given command (listed below)

HELP DETAILED   -- Complete and exhaustive help on ALL commands  
HELP USAGE  -- A general primer on how to use your mailing list  
HELP FAQ-- A list of Frequently Asked Questions (FAQ)  
  
  
Interacting with ListGuru:  
--  
  
ListGuru is a Mailing List Manager (MLM) which understands the commonly  
used commands of many other MLM's, including ListProc, listserv, Majordomo,

SmartList, Mailbase and Listcaster, among others.  
  
All commands should be sent by E-mail to the following address:  
  
[EMAIL PROTECTED] -- Note spelling closely...  
  
The Subject: line is ignored, so do not place commands on it.  Commands go  
in the message BODY, one command per line.  You can send as many commands in

a single message as you wish.  Each command has a specific format, as
outlined  
below.  In the explanations below, replace any word enclosed by angle
brackets,  
with an appropriate response.  For example:  
  
INFO list  
  
would be replaced with:  
  
INFO GARDENING-L  
  
Other command replacements:  
  
list   means the mailing list name (always suffixed with
-L)  
real name  means your given name or surname, not E-mail
address  
password   means a password given to you for closed lists  
search textmeans arbitrary text, not case sensitive  
option means a particular option, dependent on the command

filename   means a filename (no pathnames are allowed)  
commandmeans any ListGuru command  
descriptionmeans arbitrary text, case sensitive  
  
If you have any difficulties or questions regarding ListGuru, contact:  
  
[EMAIL PROTECTED]  
  
  
The following commands are recognized by ListGuru (in alphabetical order):  
--  
  
ALLMAIL list  
  Displays a short summary (who, when, what) of all messages received and  
  sent out since the last time a digest was produced (generally midnight of

  the previous day, but could be longer on low-traffic lists).  
  
  See Also: CONFIRM, LASTMAIL  
  
ARCHIVES  
  Displays a list of all mailing lists which have file archives and which  
  you are currently a subscriber to.  
  
  See Also: GET, INDEX, SEARCH, SUBMIT, VIEW  
  
BIOGRAPHY list INDEX 
BIOGRAPHY list user 
BIOGRAPHY list ALL 
BIOGRAPHY list 
BIOGRAPHY list DELETE 
  The general intent of the BIO command is to provide a way for list members

  to create a short biography for themselves, which is then available to
all 
  other members of the same list.  BIOGRAPHY can be shortened to BIO if you 
  prefer -- both spellings work equally well. 
 
  *** NOTE *** 
 
  This command is fairly detailed, so it is recommended that you  
  either issue a HELP DETAILED or a HELP BIO command to get the full set 
  of instructions for using this command. 
 
  Form #1: BIO list INDEX 
 
  Returns a complete list of whose bio is available for the given list.  As 
  an example, you could do a BIO GARDENING-L INDEX command and ListGuru
would 
  send back a list of all BIO's so far submitted for the GARDENING-L list. 
 
  Form #2: BIO list user 
 
  Sends back a BIO for a specific user.  Usually it is the next command you 
  issue after the INDEX form.  You will be sent back the complete biography 
  text as submitted by that specific user.  Be sure to use the name listed 
  in the INDEX form to get information on the right person. 
 
  Form #3: BIO list ALL 
 
  Similar to form #2, but sends ALL biographies that are available for the 
  list you specify.  A quick way to get familiar with everyone, instead of 
  just individual users. 
 
  Form #4: BIO list 
 
  This is how you submit your OWN biography.  When you use this form of the 
  command, it should be the only command you send in that message, and the 
  message MUST contain a uuencoded file containing your biography.  At the 
  current time, MIME attachments

RE: Re[2]: Verrrry interesting article at MetaLink

2002-10-10 Thread Mercadante, Thomas F


Dick,

the difference is that Oracle is a corporation that is making money on
someone else's work.  they are quick to hammer the people we work for over
license issues and, in this case, use someone elses work as a part of their
software suite.

it's not right.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 10, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L


Jared,

Should you be irritated?  I've had some of the things I published on the
list put out as gospel elsewhere with my name attached  it's been a real
pain
in the ^^$.  I don't know.  I think I'd feel flattered and relieved that no
one
knows where it came from.

Dick Goulet

Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date:   10/10/2002 7:19 AM


Not interested in compensation.  Just a litte irritated that
the only change to the script was to remove my name.

Jared

On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
 you put the code out in the world without a comment in it about copying
 is not allowed and you've made it free for the taking.

 Compensation isn't likely. Credit is definitely due and should be
 given.

 --- [EMAIL PROTECTED] wrote:
  Jared,
  You should feel upset as well as flattered. In my view you have a
  strong
  case against Oracle for some form of compensation, as a minimum you
  should
  be credited in the article.
  Whether you can win against a  big corporation is another matter of
  course.
  I and many others can confirm that the document has been on your site
  for at
  least 3 - 4 years (although they state the article to be originally
  dated
  1998).
 
  I would certainly be in contact with Oracle about this. Perhaps a
  good
  starting point would be your sales rep or contact at wherever you are
  working now.
 
  John
 
  -Original Message-
  Sent: 10 October 2002 08:13
  To: Multiple recipients of list ORACLE-L
 
 
 
 
  Dear list,
 
  I found something rather interesting on MetaLink today.
 
  While doing a little research on UTL_FILE, I came across
  document # 1050919.6.  This document deals with how to
  dump a table to an ascii file.


http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b

  ase_id=NOTp_id=1050919.6
 
  I began to think the code looked a little familiar.  Then I
  saw the temporary file name of '_dtmp.sql', which was
  rather reminiscent of file names I use.
 
  Further perusal revealed that the comments were written
  by yours truly, and match word for word those I added to
  the dump.sql script years ago.
 
  See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
  I don't know whether to be flattered or upset.
 
  Jared
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jared Still
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.com
  --
  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).

 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Re: Space... confusion

2002-10-10 Thread Connor McDonald


Are you using tempfiles ?

Just a hypothesis:  Tempfiles are created sparse, so
you ask for 100M, but in reality only 1M might be
allocated.  As people sort, you actually start needing
the 100M and kapow!

hth
connor

 --- April Wells [EMAIL PROTECTED] wrote:  Please
forgive the cross postings, but I am hoping
 that someone in all of
 the sets of eyes that see this might have an idea I
 haven't thought of.
 ***
 Facts
 **
 aix 4.3.3
 oracle 9.0.1.3
 new instance, up for 2 weeks
 locally managed tablespaces
 nothing with autoextend on
 file system at 7:01 am was at 98%
 12:00 altered index tablespaces to nologging (but
 this did not change the
 file sizes... checked)
 12:30 users (it is not a transactional instance...
 it is strictly reporting)
 started getting Ora-01114 errors corresponding
 (roughly) to when the file
 system hit 100%
 The only thing in the file system are database files
 Nothing could have changed at OS level in that
 time..to my
 knowledge
 ITAR open, not much progress (re... that can't
 happen)
 
 
 DID happen... now trying desperately to find out WHY
 it happened.  The
 'problem' effected our biggest client.  I need to
 find out what happened so
 it doesn't happen again...
 
 File system now at 92%, but will need to add dasd in
 the near future for
 growth
 
 one interesting finding found in the digging
 9i created files of 2000m are 2097168384 k at os
 level
 8i created and upgraded to 9i files of 2000m are
 2097156096 at os level... 
 
 Anybody have any ideas how something that can't
 happen, did?  Anyone ever
 seen this kind of weirdness before?
 
 
 April Wells
 Oracle DBA 
 Keep yourself well oiled with life, laughter, new
 ideas and action.
 Otherwise you will rust out.  _Anonymous
 
 
 
 begin 666 InterScan_Disclaimer.txt

M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S

M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E

M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL

M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@

M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C

M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA

M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
 M2!B92!I;QE9V%L+B
 @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S

M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I

M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)

M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@

M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S

M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL

M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S

M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R

M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
 +;G0N#0H-@T*#0H 
 end
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: April Wells
   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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: Oracle9i RMAN Backup and Recovery


I hope it meets everyone's expectations. We worked like dogs to get this one
done by OOW.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Thursday, October 10, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Congratulations, Robert!! 

Looking forward to receiving my copy... 

- Kirti 

-Original Message-
Sent: Thursday, October 10, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all 
to look at if you like. Here is the URL:

http://shop.osborne.com/cgi-bin/osborne/0072226625.html

Enjoy!

Robert

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Thursday, October 10, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L


We are in the midst of a big move to RMAN.  We use EMC's EDM to do
backups, and the SAs have been pushing us towards RMAN for a while now,
cause the EDM interface intergrates w/ RMAN seamlessly.  It really is a
nice backup solution.  (We started the process by upgrading all our EDM
units to 5.0)  Anyhow, we are setting up the RMAN catalog databases
ringht on the EDM boxes.  (The EDMs are Solaris boxes.)

It's working well.  We haven't yet fully rolled out, but all our testing
has worked fine.  We're about to start the production database migration
next week.

-Mark
On Thu, 2002-10-10 at 06:23, Connor McDonald wrote:
 There is a Metalink note (73431.1) which talks about
 the rman version compatibility, but it also states: 
 
 Ensure that the RMAN executable version matches the
 version of the target database that it is backing up
 
 which I presume to mean that you need to run rman from
 each target and push to the catalog  storage
 management node(s).  This is how I've always seen it
 done - but I've often wondered if one could get away
 driving eveything from the catalog node, pulling
 client databases over sqlnet  - thus only having a
 single TSM client (and license) on the rman catalog
 node.
 
 Cheers
 Connor
 
  --- MacGregor, Ian A. [EMAIL PROTECTED]
 wrote:  I'm  trying to use RMAN and TSM to backup
 multiple
  databases spread across various nodes with some
  nodes hosting more than one database.  The RMAN
  catalog database will reside on a node different
  from  any of the nodes hosting the other databases. 
  I have long used ADSM  without the RMAN clothing to
  backup the databases.  I have convinced the SA's to
  move on to TSM, and now I need to add the RMAN
  adornments.
  
  I assume I need the SA's to install TDP  for Oracle
  on all the nodes requiring RMAN backup.  Do I also
  need to install it on  the machine which will host
  the catalog database.  That database will undergo
  cold backup using naked TSM.  The same question
  applies to the tdpo.opt file.  Do I need multiple
  TDPO_FS values and multiple tdpo.opt files to hold
  them.
  
  
  I am also assuming I will start RMAN from one of the
  databases requiring backup and connect also to the
  RMAN catalog.  Is this typical.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: MacGregor, Ian A.
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). 
 
 =
 Connor McDonald
 http://www.oracledba.co.uk
 http://www.oaktable.net
 
 Remember amateurs built the ark - Professionals built the Titanic
 
 __
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
 http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

Oracle Financials DBA Needed in New York City..

2002-10-10 Thread OraStaff


Position: Oracle Financials DBA 

Location: New York, New York

Industry: Financial Institution

Salary Range: Up to 120K-depends on experience.

* This company may consider candidates outside the Greater New York City area 
  who have the skills outlined below and are willing to pay thier own interview
  and relocation expenses...must be able to interview on-site if needed with 
  little wait time.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

*Please do not send your resume unless you meet these requirements:
-BSCS degree or related discipline.
-Must have solid Oracle 8i DBA experience.
_Must have solid Oracle Financials DBA experience with GL, AP and FA.
-Must have solid Oracle 11i experience 11.0.3- 11.5.5 (11.5.7 experience is
desired)
-Must be a U.S. citizen or permanent resident.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/New York City//Oracle Fin DBA/John T.

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the position described above- if it is not a match for your skills.
Thanks,
Bill Law

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraStaff
  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: Space... confusion


April - This is what I hear you saying:
  - The database was set up on a file system, and there was room to spare.
  - The file system ran out of space.
  - Don't know what occurred to take up space, there should have been
nothing.
  - The situation is fixed now. HOW??
If the above is true, I think your best bet may be to attempt to reproduce
the problem. But first, carefully measure everything, using something like
Unix's du -k command. I think that is the only way you will ever pin it
down. If you are essentially back to operating again, then get a snapshot
now.
  One thought that just occurred to me, is to check the timestamps. If
something changed in size, the timestamp may have changed. I don't believe
the Oracle datafiles are updated in a read-only situation. The control file
probably gets written to frequently.

-Original Message-
Sent: Thursday, October 10, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L


Is journaling, but journal isn't in that file system, just on the raw part
of the volume group

April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous


-Original Message-
Sent: Thursday, October 10, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L


April:

I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?

HTH,
Mike


-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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

Re: sequence numbers




CACHE 20 is the default, so if you remove the clause, it 
will have absolutely no impact on performance or anything else...

...of course, I get the feeling that that wasn't the gist 
of your question, was it?

  - Original Message - 
  From: 
  April Wells 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, October 09, 2002 8:54 
  AM
  Subject: sequence numbers
  
  I have been given create scripts for 
  sequences to be used in tables that will be loaded via bulk loads. How 
  huge is the potential performancehit if I take out the cache 
  20?
  
  April Wells Oracle DBAThere is neither good nor bad, but thinking makes it 
  so. -Shakespeare

Re: Packed decimal




SQL*Loader understands how to translate PACKED and 
ZONED DECIMAL format; pretty sure that PRO*Cobol does as well, though I 
don't do Cobol...

If you're interested in conversion routines, I've a 
"C" function named "ptof()" that converts packed-decimal to 
floating-point; wrote it 10 years ago and have just been hauling it around 
since. However, the converse function ("ftop()") seems to have disappeared 
in the mists of time. It wouldn't be too hard to reconstruct, but the need 
hasn't arisen...

The "ptof()" source code comes with a pretty 
explanation of packed-decimal format, reprinted here:

   This routine converts 
  the packed decimal in the input argument buffer
  into a double floating-point 
  number.
  
   If these assumptions are incorrect, then 
  this routine won't work!
  
   1. 
  each 4-bit "nibble" in the packed decimal field contains a
   decimal 
  digit in hex...
  
   2. 
  the decimal digits are ordered from right to left when
   scanning 
  from the lowest order digit to the highest...
  
   3. 
  the "sign" nibble is the rightmost nibble in the packed
   decimal 
  field...
  
   4. 
  if the "sign" nibble is 0xA, 0xC, or 0xE, then the packed
   decimal's 
  value is positive...
  
   5. 
  if the "sign" nibble is 0xB, 0xD, or 0xF, then the packed
   decimal's 
  value is negative...
  
   6. 
  the actual byte width of the field is:
  
   
  if (decimal width is an "odd" number then
   
  (decimal width + 1) / 2)
   
  else
   
  (decimal width / 2) + 1
  
   7. 
  the "sign" nibble is ALWAYS the rightmost nibble
  
   This is a diagram of a packed decimal 
  field defined "DEC(9,5)" in
   Cobol:
  
   
  0 1 
  2 3 
  4 5 byte offset
   
  |---+---|---+---|---+---|---+---|---+---|
   | 
  | | | | | 
  | | | | |
  
   
  0x12 0x34 0x56 
  0x78 0x9B hex value of each 
  byte
  
   0x1 0x2 0x3 0x4 0x5 
  0x6 0x7 0x8 0x9 0xB hex value of each nibble
   
  ^
   
  sign = 0xB means "negative"
  
  This packed decimal field contains the 
  value "-1234.56789", because
  it's format specification (i.e 
  "DEC(9,5)") specifies a total field
  width of nine digits, five of which are 
  to the right of the decimal
  point, and the sign is "0xB", which means 
  it's a negative number...
Just recently, I had the dubious pleasure of 
writing PACKED2NUMBER and NUMBER2PACKED functions in PL/SQL. These took 
packed-decimal numbers as input (in RAW format) and returned a NUMBER and 
vice-versa...

I haven't posted them, but I'd be glad toif 
you need them...

  - Original Message - 
  From: 
  Brooks, 
  Russ 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, October 09, 2002 1:09 
  PM
  Subject: Packed decimal
  
  Hi,
   Is there 
  any way to identify values in a field, defined in Oracle as number(11,2), with 
  a packed decimal format? Or to update the field with packed decimal 
  values?
  
  Thanks,
  Russ

Re: Space... confusion


Probably due to tempfiles in your TEMPORARY tablespace...

Tempfiles are sparsely populated files (not certain if that is the correct
term).  That is, if you display them with the command ls -l, you'll see
them apparently consuming the full amount of space you specified when you
created them.  However, if you get the chance, try to perform a df -k
against the file-system in question before and after you ADD TEMPFILE and
you'll see that the space consumed within the file-system doesn't change.
Then, as sorting or global-temporary-table activity hits the TEMP
tablespace, you'll see changes in df -k...

In essence, there is a difference between the output displayed by ls -l
and df -k, and the df command is correct.  I'm not sure how the du
command reacts to all this...

Not really sure how to explain it, but I'm pretty that this is what you are
experiencing.  Rather annoying, isn't it?

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 9:13 AM


 Please forgive the cross postings, but I am hoping that someone in all of
 the sets of eyes that see this might have an idea I haven't thought of.
 ***
 Facts
 **
 aix 4.3.3
 oracle 9.0.1.3
 new instance, up for 2 weeks
 locally managed tablespaces
 nothing with autoextend on
 file system at 7:01 am was at 98%
 12:00 altered index tablespaces to nologging (but this did not change the
 file sizes... checked)
 12:30 users (it is not a transactional instance... it is strictly
reporting)
 started getting Ora-01114 errors corresponding (roughly) to when the file
 system hit 100%
 The only thing in the file system are database files
 Nothing could have changed at OS level in that time..to my
 knowledge
 ITAR open, not much progress (re... that can't happen)
 

 DID happen... now trying desperately to find out WHY it happened.  The
 'problem' effected our biggest client.  I need to find out what happened
so
 it doesn't happen again...

 File system now at 92%, but will need to add dasd in the near future for
 growth

 one interesting finding found in the digging
 9i created files of 2000m are 2097168384 k at os level
 8i created and upgraded to 9i files of 2000m are 2097156096 at os level...

 Anybody have any ideas how something that can't happen, did?  Anyone ever
 seen this kind of weirdness before?


 April Wells
 Oracle DBA
 Keep yourself well oiled with life, laughter, new ideas and action.
 Otherwise you will rust out.  _Anonymous











 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   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.com
-- 
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: Verrrry interesting article at MetaLink

2002-10-10 Thread John Weatherman


That's interesting.  I'd heard it was for OpenWorld '07.

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 10, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


Actually, Oracle 256i is slated for a June, 2012 release.  

-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having your name
embedded into the oracle source code is something much better.
Jared, in a few millenniums, with Oracle 256(i?) you'll be one of
the most celebrated individuals in the galaxy, standing next to Hari 
Seldon or Zaphod Beeblebrox.

 -Original Message-
 From: Cary Millsap [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 3:58 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Vey interesting article at MetaLink
 
 
 I've learned that those two emotions are not mutually exclusive.
 
 If you name's not in Oracle's source code somewhere, then I'd suggest
 you write someone at Oracle a note. It's an easy problem for them to
 solve.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
 - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
 - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
 
 
 -Original Message-
 Still
 Sent: Thursday, October 10, 2002 2:13 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Dear list,
 
 I found something rather interesting on MetaLink today.
 
 While doing a little research on UTL_FILE, I came across
 document # 1050919.6.  This document deals with how to
 dump a table to an ascii file.
 
 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo
 cument?p_d
 atabase_id=NOTp_id=1050919.6
 
 I began to think the code looked a little familiar.  Then I
 saw the temporary file name of '_dtmp.sql', which was 
 rather reminiscent of file names I use.
 
 Further perusal revealed that the comments were written 
 by yours truly, and match word for word those I added to 
 the dump.sql script years ago.
 
 See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
 I don't know whether to be flattered or upset.
 
 Jared
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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.com
 -- 
 Author: Cary Millsap
   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.com
-- 
Author: Gogala, Mladen
  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.com
-- 
Author: Gesler, 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

RE: Space... confusion


Anything reported in the system logs? 
Can you get the SAs to run the 'errpt' report to make sure there were no
disk related problems. 

Do the permissions on the mount point directory keep others away? 

Once I had a smart developer(and a newbie DBA), who pointed his vi
'directory' to one of the data files', since it had more empty space and was
set to 777 !! 

- Kirti



-Original Message-
Sent: Thursday, October 10, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)


DID happen... now trying desperately to find out WHY it happened.  The
'problem' effected our biggest client.  I need to find out what happened so
it doesn't happen again...

File system now at 92%, but will need to add dasd in the near future for
growth

one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level... 

Anybody have any ideas how something that can't happen, did?  Anyone ever
seen this kind of weirdness before?


April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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.com
-- 
Author: Deshpande, Kirti
  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: Making a tablespace read-only - identifying blocking tx


Forehead Slap D'OH!

You are absolutely correct. I completely overthought the issue and missed
the obvious.

Thanks Henry

-Original Message-
Sent: Thursday, October 10, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


But can you know for sure if an open txn will hit your tablespace until the
txn is closed?

Henry

-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


It is not the export per se that causes the problem. It is the copying of
the datafile that is the issue. The tablespace must be made read only so
that the datafile can be copied in a consistent version. I can understand
(and support) no active tx in the tablespace, but why the whole (*#(*$#
database? If I need to take INVOICE_1999 tablespace and migrate it to an
ODS, why does it matter if Joe Accountant is adding an expense report in the
EXPENSE_2002 ts?

In the Oracle doc, it lists the requirements for making a ts read only. On
the next page it states (verbatim from doc)

You do not have to wait for transactions to complete before issuing the
ALTER
TABLESPACE ... READ ONLY statement. When the statement is issued, the target
tablespace goes into a transitional read-only mode in which no further write
operations (DML statements) are allowed against the tablespace. Existing
transactions that modified the tablespace are allowed to commit or rollback.
Once
all transactions (in the database) have completed, the tablespace becomes
read-only.

I love how Oracle buries a very important consideration in the very last
line of a paragraph!

We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do have
other options. The application architecture is such that I am pretty certain
very bad things would happen if I tried to but the database in restricted
mode.

Dan

-Original Message-
Sent: Thursday, October 10, 2002 5:09 AM
To: Multiple recipients of list ORACLE-L


so if it's waiting for any active transaction, I guess you could put
the database in restricted mode until existing transactions complete.
Of course, that sort of defeats the purpose of putting it in read-only
so other people can access it.

um, 9ir2 has an export parameter of tablespace, if you want it
read-only so nothing changes while you export it, how about using the
consistent=y export parameter in conjunction with the tablespace
export?


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And with that correction, it seems checking for active transactions
 (in
 v$transaction) would address this.

 However, by the time one gets a 'green' light from v$transaction and
 issues
 alter tablespace... there is the slight possibility of someone
 starting a
 new transaction locally or just selecting over a dblink...

 Too bad that the new 'transitional read-only' mode does not allow a
 graceful
 exit... Per the Admin Guide one must set compatible to  8.1.0 to
 make the
 command fail...

 I would be interested in learning how you tackle this issue as I am
 also
 trying to implement TTS in some of my databases.

 Thanks.

 - Kirti

 -Original Message-
 Sent: Wednesday, October 09, 2002 4:34 PM
 To: Multiple recipients of list ORACLE-L


 Just a slight correction it will wait until any transaction against
 the
 entire database, not just the tablespace is completed.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 -Original Message-
 Sent: Wednesday, October 09, 2002 1:49 PM
 To: Multiple recipients of list ORACLE-L


 I am creating a stored proc that will export a tablespace. One task
 it needs
 to perform is to place the tablespace(s) in read only mode to make a
 copy.
 Based upon the application and proc logic, there should not be any
 transactions against objects in the ts. However, if there are, the
 ALTER
 TABLESPACE command will wait until the transaction is completed. I
 would
 rather have the ALTER TABLESPACE command fail immediately. If I
 cannot do
 that, I would like to be able to test for locks on objects in the
 tablespace
 (figured that one out, but it is rather kludgy).

 Is there a method to force an immediate failure of ALTER TABLESPACE
 tsname
 READ ONLY if it cannot be immediatly completed?
 Is there a clean method/proc to determine if the ALTER TABLESPACE
 command
 will work?

 Dan Fink




__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  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:

RE: DROP DEVELOPER not working - 10046 trace



I am not talking of the execution plan for the drop table statement, but
for the select that's run prior to it? I opened a TAR for it, and Metalink
states:  sql trace messages are not in sync with the session. Some
messages will only dump to trace when the cursor is closed, or the program
normally exits. If you kill the program when it is hanging, very likely,
statistics information will not dump to trace.

Thanks
Raj




  One attachment (0k)
   
   
Jamadagni,
   
Rajendra  To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
Rajendra.Jamadagnicc: 
   
@espn.com Subject: RE: DROP DEVELOPER not 
working - 10046 trace  
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
October 10, 2002   
   
12:59 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




execution plan comes at the end ... that's why ...


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!





-Original Message-
Sent: Thursday, October 10, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L





And  I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Oracle9i upgrade exam - Recommended books/material? (Borderin


Thanks Dennis! I'm sitting here dying because one of my stereo headphone
speakers i do ng t is t m ri gt n w.

ARRRUUU.

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Friday, September 13, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L


Kieran - I haven't read it because I am still working out the 8i OCP tests,
but here is a link to a book by Robert Freeman, who participates on this
list. It has been recommended by other list members in the past.

http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W
9isbn=0072223855

 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 13, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New
Features for Administrators).
Could anyone recommend some good reading material on the matter?
I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre
reviews.

Your opinions would be very much appreciated,

Kieran Murray
Development DBA
CardBASE Technologies Limited® 
BIM House
Crofton Road
Dun Laoghaire
Co Dublin
Ireland 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Freeman, 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).

RE: Oracle9i upgrade exam - Recommended books/material?


May I offer my Oracle9i New Features book as one source of preparation.
While it does not cover 100% of the 9i OCP objectives (nor was it intended
too), I think you will find it a
good introductory guide to 9i and the new features you will need to know
about. 

I also agree with others here that the STS tests are quite good.

I'd take these two resources (and Daniels book really isn't as bad as part
of an overall set of prep resources) and the Oracle documentation as my
source material. Download the latest Oracle 9iNF test objectives available
at education.oracle.com and prepare topic by topic as shown in the test
objectives.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 

 



-Original Message-
Sent: Friday, September 13, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New
Features for Administrators).
Could anyone recommend some good reading material on the matter?
I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre
reviews.

Your opinions would be very much appreciated,

Kieran Murray
Development DBA
CardBASE Technologies Limited® 
BIM House
Crofton Road
Dun Laoghaire
Co Dublin
Ireland 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Freeman, 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).

RE: Re[2]: Verrrry interesting article at MetaLink


From Oracle's Terms of Use on Metalink...

Confidentiality
---
Except for information in Web sites controlled by third parties that are
accessible via hyperlinks from the MetaLink Web site, the information
contained in the Materials is the confidential proprietary information of
Oracle. You may not use, disclose, reproduce, transmit, or otherwise copy in
any form or by any means the information contained in the Materials for any
purpose, other than to support your authorized use of the Oracle Programs
for which you hold a supported license from Oracle, without the prior
written permission of Oracle. Oracle will take reasonable measures to keep
third parties from obtaining unauthorized access to Technical Assistance
Requests (TARs) that you submit using the MetaLink Web site; however, Oracle
does not guarantee that third parties will not have access to any
information, comments, feedback, or materials that you submit to Oracle
through or in association with the MetaLink Web site.

Oracle claims ownership of Jared's script, which it cannot do since it does
not own the copy rights. Check copyright law, but there is a strong case for
copyright infringement. There is a difference between passing copyrighted
material on to others (giving someone a book) and claiming ownership (Look,
ma, I just wrote this great play called 'Romeo and Juliet'). If Oracle had
placed a copyright notice or attibution for Jared, I think they are okay,
but they are passing the script as one of their own.

On the non-legal side, to me there is a big difference between being used by
a corporation and used by an individual or other. Any/all of my
scripts/documents on my website are available for use by anyone who so
desires for their personal use. If I find that one of my presentation
becomes part of Jim-Bob's Oracle Consulting Training classes, we are going
to have to have a talk about fair use. Even if they preserve my copyright
and/or attribution, they are using it for material gain. Since Oracle
charges for support and access to Metalink, there may be a case. If they had
posted it to OTN or Oracle Mag, which is free to use, it is another story.

Go Get 'Em Jared!

-Original Message-
Sent: Thursday, October 10, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


Dick,

the difference is that Oracle is a corporation that is making money on
someone else's work.  they are quick to hammer the people we work for over
license issues and, in this case, use someone elses work as a part of their
software suite.

it's not right.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 10, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L


Jared,

Should you be irritated?  I've had some of the things I published on the
list put out as gospel elsewhere with my name attached  it's been a real
pain
in the ^^$.  I don't know.  I think I'd feel flattered and relieved that no
one
knows where it came from.

Dick Goulet

Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date:   10/10/2002 7:19 AM


Not interested in compensation.  Just a litte irritated that
the only change to the script was to remove my name.

Jared

On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
 you put the code out in the world without a comment in it about copying
 is not allowed and you've made it free for the taking.

 Compensation isn't likely. Credit is definitely due and should be
 given.

 --- [EMAIL PROTECTED] wrote:
  Jared,
  You should feel upset as well as flattered. In my view you have a
  strong
  case against Oracle for some form of compensation, as a minimum you
  should
  be credited in the article.
  Whether you can win against a  big corporation is another matter of
  course.
  I and many others can confirm that the document has been on your site
  for at
  least 3 - 4 years (although they state the article to be originally
  dated
  1998).
 
  I would certainly be in contact with Oracle about this. Perhaps a
  good
  starting point would be your sales rep or contact at wherever you are
  working now.
 
  John
 
  -Original Message-
  Sent: 10 October 2002 08:13
  To: Multiple recipients of list ORACLE-L
 
 
 
 
  Dear list,
 
  I found something rather interesting on MetaLink today.
 
  While doing a little research on UTL_FILE, I came across
  document # 1050919.6.  This document deals with how to
  dump a table to an ascii file.


http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b

  ase_id=NOTp_id=1050919.6
 
  I began to think the code looked a little familiar.  Then I
  saw the temporary file name of '_dtmp.sql', which was
  rather reminiscent of file names I use.
 
  Further perusal revealed that the comments were written
  by yours truly, and match word for word those I added to
  the dump.sql script years ago.
 
  See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql

RE: Making a tablespace read-only - identifying blocking tx


ah! transportable tablespaces?  you did't SAY that


--- Fink, Dan [EMAIL PROTECTED] wrote:
 It is not the export per se that causes the problem. It is the
 copying of
 the datafile that is the issue. The tablespace must be made read only
 so
 that the datafile can be copied in a consistent version. I can
 understand
 (and support) no active tx in the tablespace, but why the whole
 (*#(*$#
 database? If I need to take INVOICE_1999 tablespace and migrate it to
 an
 ODS, why does it matter if Joe Accountant is adding an expense report
 in the
 EXPENSE_2002 ts?
 
 In the Oracle doc, it lists the requirements for making a ts read
 only. On
 the next page it states (verbatim from doc)
 
 You do not have to wait for transactions to complete before issuing
 the
 ALTER
 TABLESPACE ... READ ONLY statement. When the statement is issued, the
 target
 tablespace goes into a transitional read-only mode in which no
 further write
 operations (DML statements) are allowed against the tablespace.
 Existing
 transactions that modified the tablespace are allowed to commit or
 rollback.
 Once
 all transactions (in the database) have completed, the tablespace
 becomes
 read-only.
 
 I love how Oracle buries a very important consideration in the very
 last
 line of a paragraph!
 
 We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do
 have
 other options. The application architecture is such that I am pretty
 certain
 very bad things would happen if I tried to but the database in
 restricted
 mode.
 
 Dan
 
 -Original Message-
 Sent: Thursday, October 10, 2002 5:09 AM
 To: Multiple recipients of list ORACLE-L
 
 
 so if it's waiting for any active transaction, I guess you could put
 the database in restricted mode until existing transactions complete.
 Of course, that sort of defeats the purpose of putting it in
 read-only
 so other people can access it.
 
 um, 9ir2 has an export parameter of tablespace, if you want it
 read-only so nothing changes while you export it, how about using
 the
 consistent=y export parameter in conjunction with the tablespace
 export?
 
 
 --- Deshpande, Kirti [EMAIL PROTECTED] wrote:
  And with that correction, it seems checking for active transactions
  (in
  v$transaction) would address this. 
   
  However, by the time one gets a 'green' light from v$transaction
 and
  issues
  alter tablespace... there is the slight possibility of someone
  starting a
  new transaction locally or just selecting over a dblink...
   
  Too bad that the new 'transitional read-only' mode does not allow a
  graceful
  exit... Per the Admin Guide one must set compatible to  8.1.0 to
  make the
  command fail...  
   
  I would be interested in learning how you tackle this issue as I am
  also
  trying to implement TTS in some of my databases. 
   
  Thanks.
   
  - Kirti 
   
  -Original Message-
  Sent: Wednesday, October 09, 2002 4:34 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Just a slight correction it will wait until any transaction against
  the
  entire database, not just the tablespace is completed.
   
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
  
  -Original Message-
  Sent: Wednesday, October 09, 2002 1:49 PM
  To: Multiple recipients of list ORACLE-L
  
  
  I am creating a stored proc that will export a tablespace. One task
  it needs
  to perform is to place the tablespace(s) in read only mode to make
 a
  copy.
  Based upon the application and proc logic, there should not be any
  transactions against objects in the ts. However, if there are, the
  ALTER
  TABLESPACE command will wait until the transaction is completed. I
  would
  rather have the ALTER TABLESPACE command fail immediately. If I
  cannot do
  that, I would like to be able to test for locks on objects in the
  tablespace
  (figured that one out, but it is rather kludgy).
   
  Is there a method to force an immediate failure of ALTER TABLESPACE
  tsname
  READ ONLY if it cannot be immediatly completed?
  Is there a clean method/proc to determine if the ALTER TABLESPACE
  command
  will work?
   
  Dan Fink
  
  
 
 
 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   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

Re: DROP DEVELOPER not working

2002-10-10 Thread Stephane Faroult


[EMAIL PROTECTED] wrote:
 
 We have a developer here, installing a third party application, who claims
 one of his delete campaign process is hanging. I looked at the wait
 events, saw nothing, and asked him to politely to go look at the code.
 After much analysys, the developer now complains, that Oracle is not
 executing a drop table command at the end of the process, and hanging
 there. He claims he can drop the table from SQLPLUS.
 
 I asked him to rerun the process. I noticed no wait events for that session
 in v$session_wait when he claims the process is hanging. I see no DROP
 statements in the v$sqlarea. I did a 10046 trace, and the last statement in
 the trace file is a select statement.  I looked at the sql addresses from
 v$session, linked it to v$sqlarea and the sql_text shows the same select
 statement as is seen in the trace file. I see no exclusive locks on the
 said table. I conclude that the application is not sending a DROP statement
 to Oracle for execution. He claims that cannot be the case. They have done
 the same installation in a test environment and it worked fine. The jury
 seems to be taking sides. I scream SOS. What more should I be doing? And
 Does an Oracle 10046 trace write into the trace file after the statement
 has executed?
 
 Thanks
 Raj
 

DROP DEVELOPER, what a nice idea ... Anyway, it reminds me of a similar
problem I had ca 1990 in a Pro*C program. I was checking something in a
table, cleanly closing my cursor, and trying to drop the table and it
timed out each time. The reason was that although my cursor was closed,
Pro*C was keeping it open in the hope that somewhat later I would reuse
it and it would save a parse. The lock which was preventing me from
dropping my table was not an exclusive lock, but a share lock on the
dictionary - as long as a cursor references a table, you can't drop it.
It was solved by adding the relevant bit of code (kind of pragma) to the
Pro*C code.
Does your saying 'I see no exclusive locks on the said table' implicitly
means that you are seeing other locks? 
I think that there is one of those obscure init.ora parameters
instructing Oracle to cache or not to cache closed cursors. This may be
the difference between your test and prod environments.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

RE: DROP DEVELOPER not working - 10046 trace



Thanks Kirti. While I cannot stop drops completely, I am thinking I could
use dbms_system with the scripts, to write to the alert log whenever  a
drop statement is executed.

And by the way, I did a level 12 trace, and for the statements it does put
in the execution plan :

PARSING IN CURSOR #3 len=72 dep=0 uid=187 oct=7 lid=187 tim=339770729
hv=592557958 ad='68ae6978'
DELETE FROM VANTAGE.VANTAGE_DYN_TAB VDT WHERE VDT.VANTAGE_ALIAS = 'SFO4'
END OF STMT
PARSE #3:c=0,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=339770729
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=0,e=0,p=0,cr=4,cu=7,mis=0,r=9223372041149743105,dep=0,og=4,tim=339770729
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 2 p1=1413697536 p2=1 p3=0
STAT #3 id=1 cnt=1 pid=0 pos=0 obj=0 op='DELETE VANTAGE_DYN_TAB '
STAT #3 id=2 cnt=2 pid=1 pos=1 obj=128620 op='TABLE ACCESS FULL
VANTAGE_DYN_TAB '

Thanks
Raj





   
   
Deshpande, Kirti 
   
kirti.deshpande@veTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
rizon.com cc: 
   
Sent by:   Subject: RE: DROP DEVELOPER not 
working - 10046 trace  
[EMAIL PROTECTED]   
   
   
   
   
   
October 10, 2002   
   
01:49 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Execution plan is not generated by using event 10046 for tracing.

If you using 8i+, there is a way to prevent owner of the table from
performing ddl.
Here's a post by Joe Testa quite some time ago.
And I have used this process successfully.

HTH,
- Kirti

On Thu, 6 Jan 2000, Joseph Testa wrote:

 Why would you want to do that, well, i'm at a place where the developers
 have the schema owner password but we DBAs(being retentitive as we
are)dont
 want them to make any ddl changes.


 here are the steps:

 Feel free to change the names to your liking

 create user schema_control identified by passwd
 grant create any trigger to schema_control;

 edit the 3 following triggers, changing the SCHEMA_NAME to the schema
you
 want to put the control on:

 create or replace trigger create_control_trigger
 before create on SCHEMA_NAME.schema

 begin
   raise_application_error(-20001,'NO CREATE DDL ALLOWED');
 end;
 /

 create or replace trigger drop_control_trigger
 before drop on SCHEMA_NAME.schema

 begin
   raise_application_error(-20001,'NO DROP DDL ALLOWED');
 end;
 /

 create or replace trigger alter_control_trigger
 before alter on SCHEMA_NAME.schema

 begin
   raise_application_error(-20001,'NO ALTER DDL ALLOWED');
 end;
 /


 revoke alter any trigger from SCHEMA_NAME;

 the previous line is needed so they dont alter the trigger to disable it
:)

 the next time they attempt to create, drop or alter anything in that
schema
 they get error msg.

 This all assumes they are not dba :)

 hht, joe

-Original Message-
Sent: Thursday, October 10, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L


And  I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?

- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -




Rajesh Rao

 To: [EMAIL PROTECTED]

October 10,  cc:

2002 10:14 AMSubject: RE: DROP DEVELOPER
not
working - 10046 trace(Document link:
 Rajesh Rao)







As I was

RE: Space... confusion


Oh good... isn't that special...

du -k says they are 3401728 k... not 'quite' 4000 meg... that makes sense.

anywhere I can look this up to do more research (ie... is there a friendly
manual)?

April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous


-Original Message-
Sent: Thursday, October 10, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L


Probably due to tempfiles in your TEMPORARY tablespace...

Tempfiles are sparsely populated files (not certain if that is the correct
term).  That is, if you display them with the command ls -l, you'll see
them apparently consuming the full amount of space you specified when you
created them.  However, if you get the chance, try to perform a df -k
against the file-system in question before and after you ADD TEMPFILE and
you'll see that the space consumed within the file-system doesn't change.
Then, as sorting or global-temporary-table activity hits the TEMP
tablespace, you'll see changes in df -k...

In essence, there is a difference between the output displayed by ls -l
and df -k, and the df command is correct.  I'm not sure how the du
command reacts to all this...

Not really sure how to explain it, but I'm pretty that this is what you are
experiencing.  Rather annoying, isn't it?

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 9:13 AM


 Please forgive the cross postings, but I am hoping that someone in all of
 the sets of eyes that see this might have an idea I haven't thought of.
 ***
 Facts
 **
 aix 4.3.3
 oracle 9.0.1.3
 new instance, up for 2 weeks
 locally managed tablespaces
 nothing with autoextend on
 file system at 7:01 am was at 98%
 12:00 altered index tablespaces to nologging (but this did not change the
 file sizes... checked)
 12:30 users (it is not a transactional instance... it is strictly
reporting)
 started getting Ora-01114 errors corresponding (roughly) to when the file
 system hit 100%
 The only thing in the file system are database files
 Nothing could have changed at OS level in that time..to my
 knowledge
 ITAR open, not much progress (re... that can't happen)
 

 DID happen... now trying desperately to find out WHY it happened.  The
 'problem' effected our biggest client.  I need to find out what happened
so
 it doesn't happen again...

 File system now at 92%, but will need to add dasd in the near future for
 growth

 one interesting finding found in the digging
 9i created files of 2000m are 2097168384 k at os level
 8i created and upgraded to 9i files of 2000m are 2097156096 at os level...

 Anybody have any ideas how something that can't happen, did?  Anyone ever
 seen this kind of weirdness before?


 April Wells
 Oracle DBA
 Keep yourself well oiled with life, laughter, new ideas and action.
 Otherwise you will rust out.  _Anonymous











 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   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.com
-- 
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).

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I

RE: Verrrry interesting article at MetaLink

2002-10-10 Thread Gesler, Rich



2007 would not give enough time to complete the class time for the more rigorous OCP 
256i requirements.  Quit spreading false rumours.

-Original Message-
Sent: Thursday, October 10, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L


That's interesting.  I'd heard it was for OpenWorld '07.

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 10, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


Actually, Oracle 256i is slated for a June, 2012 release.  

-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having your name
embedded into the oracle source code is something much better.
Jared, in a few millenniums, with Oracle 256(i?) you'll be one of
the most celebrated individuals in the galaxy, standing next to Hari 
Seldon or Zaphod Beeblebrox.

 -Original Message-
 From: Cary Millsap [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 3:58 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Vey interesting article at MetaLink
 
 
 I've learned that those two emotions are not mutually exclusive.
 
 If you name's not in Oracle's source code somewhere, then I'd suggest
 you write someone at Oracle a note. It's an easy problem for them to
 solve.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
 - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
 - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
 
 
 -Original Message-
 Still
 Sent: Thursday, October 10, 2002 2:13 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Dear list,
 
 I found something rather interesting on MetaLink today.
 
 While doing a little research on UTL_FILE, I came across
 document # 1050919.6.  This document deals with how to
 dump a table to an ascii file.
 
 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo
 cument?p_d
 atabase_id=NOTp_id=1050919.6
 
 I began to think the code looked a little familiar.  Then I
 saw the temporary file name of '_dtmp.sql', which was 
 rather reminiscent of file names I use.
 
 Further perusal revealed that the comments were written 
 by yours truly, and match word for word those I added to 
 the dump.sql script years ago.
 
 See for yourself:  http://www.cybcon.com/~jkstill/util/zips/dump.sql
 
 I don't know whether to be flattered or upset.
 
 Jared
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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.com
 -- 
 Author: Cary Millsap
   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.com
-- 
Author: Gogala, Mladen
  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.com
-- 
Author: Gesler, 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:

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

2002-10-10 Thread Mohammad Rafiq


Robert,

If you don't mind , both books are good as I passed my 9i upgarde with the 
help of both books and I shall give credit to you and Daniel for writing 
these books.  However, yours was the first one which I bought sometime in 
Jan'2002 and his book was released end March, 2002.

Thanks again for your excellent effort. Now will wait for your book on Rman 
as you already given the url for that.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 10 Oct 2002 10:28:16 -0800

Thanks Dennis! I'm sitting here dying because one of my stereo headphone
speakers i do ng t is t m ri gt n w.

ARRRUUU.

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-Original Message-
Sent: Friday, September 13, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L


Kieran - I haven't read it because I am still working out the 8i OCP tests,
but here is a link to a book by Robert Freeman, who participates on this
list. It has been recommended by other list members in the past.

http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W
9isbn=0072223855

 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, September 13, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New
Features for Administrators).
Could anyone recommend some good reading material on the matter?
I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre
reviews.

Your opinions would be very much appreciated,

Kieran Murray
Development DBA
CardBASE Technologies Limited®
BIM House
Crofton Road
Dun Laoghaire
Co Dublin
Ireland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kieran Murray
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Freeman, 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).




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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: SOLARIS to linux

2002-10-10 Thread Seema Singh

Yes,Let me know is any other way  except EXPORT/import I can do ?

Thx
-Seema

From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: SOLARIS to linux
Date: Wed, 09 Oct 2002 19:03:41 -0800

One needs to use export/import while changing hardware platforms for Oracle
databases.

- Kirti

-Original Message-
Sent: Wednesday, October 09, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L

Hi
Can any one share data migration from sun solaris to linux ?
Thx
-Seema

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
   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.com
--
Author: Deshpande, Kirti
   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).

import

_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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]: Verrrry interesting article at MetaLink

2002-10-10 Thread Ruth Gramolini


I agree!  Stick it to 'em. They do it to us all the time.  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 3:24 PM


 From Oracle's Terms of Use on Metalink...

 Confidentiality
 ---
 Except for information in Web sites controlled by third parties that are
 accessible via hyperlinks from the MetaLink Web site, the information
 contained in the Materials is the confidential proprietary information of
 Oracle. You may not use, disclose, reproduce, transmit, or otherwise copy
in
 any form or by any means the information contained in the Materials for
any
 purpose, other than to support your authorized use of the Oracle Programs
 for which you hold a supported license from Oracle, without the prior
 written permission of Oracle. Oracle will take reasonable measures to keep
 third parties from obtaining unauthorized access to Technical Assistance
 Requests (TARs) that you submit using the MetaLink Web site; however,
Oracle
 does not guarantee that third parties will not have access to any
 information, comments, feedback, or materials that you submit to Oracle
 through or in association with the MetaLink Web site.

 Oracle claims ownership of Jared's script, which it cannot do since it
does
 not own the copy rights. Check copyright law, but there is a strong case
for
 copyright infringement. There is a difference between passing copyrighted
 material on to others (giving someone a book) and claiming ownership
(Look,
 ma, I just wrote this great play called 'Romeo and Juliet'). If Oracle had
 placed a copyright notice or attibution for Jared, I think they are okay,
 but they are passing the script as one of their own.

 On the non-legal side, to me there is a big difference between being used
by
 a corporation and used by an individual or other. Any/all of my
 scripts/documents on my website are available for use by anyone who so
 desires for their personal use. If I find that one of my presentation
 becomes part of Jim-Bob's Oracle Consulting Training classes, we are going
 to have to have a talk about fair use. Even if they preserve my copyright
 and/or attribution, they are using it for material gain. Since Oracle
 charges for support and access to Metalink, there may be a case. If they
had
 posted it to OTN or Oracle Mag, which is free to use, it is another story.

 Go Get 'Em Jared!

 -Original Message-
 Sent: Thursday, October 10, 2002 11:09 AM
 To: Multiple recipients of list ORACLE-L


 Dick,

 the difference is that Oracle is a corporation that is making money on
 someone else's work.  they are quick to hammer the people we work for over
 license issues and, in this case, use someone elses work as a part of
their
 software suite.

 it's not right.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Thursday, October 10, 2002 11:45 AM
 To: Multiple recipients of list ORACLE-L


 Jared,

 Should you be irritated?  I've had some of the things I published on
the
 list put out as gospel elsewhere with my name attached  it's been a real
 pain
 in the ^^$.  I don't know.  I think I'd feel flattered and relieved that
no
 one
 knows where it came from.

 Dick Goulet

 Reply Separator
 Author: Jared Still [EMAIL PROTECTED]
 Date:   10/10/2002 7:19 AM


 Not interested in compensation.  Just a litte irritated that
 the only change to the script was to remove my name.

 Jared

 On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
  you put the code out in the world without a comment in it about copying
  is not allowed and you've made it free for the taking.
 
  Compensation isn't likely. Credit is definitely due and should be
  given.
 
  --- [EMAIL PROTECTED] wrote:
   Jared,
   You should feel upset as well as flattered. In my view you have a
   strong
   case against Oracle for some form of compensation, as a minimum you
   should
   be credited in the article.
   Whether you can win against a  big corporation is another matter of
   course.
   I and many others can confirm that the document has been on your site
   for at
   least 3 - 4 years (although they state the article to be originally
   dated
   1998).
  
   I would certainly be in contact with Oracle about this. Perhaps a
   good
   starting point would be your sales rep or contact at wherever you are
   working now.
  
   John
  
   -Original Message-
   Sent: 10 October 2002 08:13
   To: Multiple recipients of list ORACLE-L
  
  
  
  
   Dear list,
  
   I found something rather interesting on MetaLink today.
  
   While doing a little research on UTL_FILE, I came across
   document # 1050919.6.  This document deals with how to
   dump a table to an ascii file.
 
 

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
 b
 
   ase_id=NOTp_id=1050919.6
  
   I began to think the code looked a little familiar.  Then I
   saw the

RE: Space... confusion


At the OS level, the files are 4000 meg.  If they are created sparse, would
it show at the OS level?

April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous


-Original Message-
Sent: Thursday, October 10, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L


Are you using tempfiles ?

Just a hypothesis:  Tempfiles are created sparse, so
you ask for 100M, but in reality only 1M might be
allocated.  As people sort, you actually start needing
the 100M and kapow!

hth
connor

 --- April Wells [EMAIL PROTECTED] wrote:  Please
forgive the cross postings, but I am hoping
 that someone in all of
 the sets of eyes that see this might have an idea I
 haven't thought of.
 ***
 Facts
 **
 aix 4.3.3
 oracle 9.0.1.3
 new instance, up for 2 weeks
 locally managed tablespaces
 nothing with autoextend on
 file system at 7:01 am was at 98%
 12:00 altered index tablespaces to nologging (but
 this did not change the
 file sizes... checked)
 12:30 users (it is not a transactional instance...
 it is strictly reporting)
 started getting Ora-01114 errors corresponding
 (roughly) to when the file
 system hit 100%
 The only thing in the file system are database files
 Nothing could have changed at OS level in that
 time..to my
 knowledge
 ITAR open, not much progress (re... that can't
 happen)
 
 
 DID happen... now trying desperately to find out WHY
 it happened.  The
 'problem' effected our biggest client.  I need to
 find out what happened so
 it doesn't happen again...
 
 File system now at 92%, but will need to add dasd in
 the near future for
 growth
 
 one interesting finding found in the digging
 9i created files of 2000m are 2097168384 k at os
 level
 8i created and upgraded to 9i files of 2000m are
 2097156096 at os level... 
 
 Anybody have any ideas how something that can't
 happen, did?  Anyone ever
 seen this kind of weirdness before?
 
 
 April Wells
 Oracle DBA 
 Keep yourself well oiled with life, laughter, new
 ideas and action.
 Otherwise you will rust out.  _Anonymous
 
 
 

begin 666 InterScan_Disclaimer.txt
MM   5AE(EN9F]R;6%T:6]N
M(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!SM   
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T
M:4@:6YT96YD960@=7-EM   
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
MM   2!PFEV:6QE9V5D(%N
M9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@M   
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L
M;W-UF4L('5S92!OB!CM   
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
MM   ;B!T:4@:6YT96YD960@
MF5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B
MM@268@6]U(AA=F4@F5C96EV960@=AIR!M97
MM   86=E(EN(5RF]R+!P
M;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961IM   
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!O
MF%T92!37-T96US+!)M   
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
MM   96YS=7)E('1H870@86YY
M(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%SM   
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A
M8V-E'0@;F\@;EA8FELM   
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
MM   ;V9T=V%R92!V:7)UV5S
M(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5RM   
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI
M;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H M 
M %.$MM  
M -- M   
M P,%!3% 3%% 4(% /)#)!, ORACLE-L FAQ:M  (440://777./2!!1.#
M/-M  -- M   
M A54(/2: A02), W%,,3M  INET: !7%,,3@#3%$
M'%.#/-M  M  
M F!4 C)49 N%47/2+ S%26)#%3-- 858-538 (440://777.!4#)49.
M#/-M S!. D)%'/, C!,)/2.)!-- M!),).'
M (/34).' 3%26)#%3M  M   
M- -#P,I;;]I03U4DQ3!@!DC
MS0%4P#0233AP#0)3;023 #14TP1Q;0%#
MV@+4U)U4E8!@5 R53@SS0#CU!0)(8] $T ![4U)U4E1R0 3A 3K0  
M  %!0#14TP1Q0(KY.3 3@S%1!0 0#3A0 SSE 20+\
MH8[)3;+0  #T@%!0#@310#Q@#0233
MAP#4U 3U0%P3E % !DCS23@ .3U0#06;03
M$SP$Q3A %!0*);,  SS303A !CT@#U!4@3@#2Q0$U0DPTB0B3AR3@+0
M
M '777;0 /../
M2 M#D/.!,$M   !11!H\]==XU%$CSU
MUUSC

CPU WAIT I/O statistic

2002-10-10 Thread Pablo Rodriguez


Hi list
   Can anyone explain me what exactly does the WAIT
I/O column of the sar -u output mean?

   Does it represent the % of CPU used by the kernel
processes to perform I/O? 

   As far as I know the waiting processes do no wait
actively when they ask for an I/O. right? The OS uses
the SLEEP and WAKEUP primitives.
   So, Which process is using this CPU? (The WAIT
I/O%)

   Or does this WAIT I/O have to be taken as if the
CPU were idle?

Please shed some light on this.
Thanks

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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: DROP DEVELOPER not working - 10046 trace


Sorry, I did not pay attention to what level trace you were generating... :(

- Kirti

-Original Message-
Sent: Thursday, October 10, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L



Thanks Kirti. While I cannot stop drops completely, I am thinking I could
use dbms_system with the scripts, to write to the alert log whenever  a
drop statement is executed.

And by the way, I did a level 12 trace, and for the statements it does put
in the execution plan :

PARSING IN CURSOR #3 len=72 dep=0 uid=187 oct=7 lid=187 tim=339770729
hv=592557958 ad='68ae6978'
DELETE FROM VANTAGE.VANTAGE_DYN_TAB VDT WHERE VDT.VANTAGE_ALIAS = 'SFO4'
END OF STMT
PARSE #3:c=0,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=339770729
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=0,e=0,p=0,cr=4,cu=7,mis=0,r=9223372041149743105,dep=0,og=4,tim=33977072
9
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 2 p1=1413697536 p2=1 p3=0
STAT #3 id=1 cnt=1 pid=0 pos=0 obj=0 op='DELETE VANTAGE_DYN_TAB '
STAT #3 id=2 cnt=2 pid=1 pos=1 obj=128620 op='TABLE ACCESS FULL
VANTAGE_DYN_TAB '

Thanks
Raj




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: bioinformatics

2002-10-10 Thread Greg Moore


 is there any strategy from oracle in bioinformatics?

Oracle has application software they call Oracle Clinical.  Apparently it is
designed to support clinical trials of new drugs.

If you find out more on this topic I hope you'll post it to this list.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  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: Space... confusion


That is it EXACTLY... thank you.. it was created sparsely, du -ak gives what
df -k believes, but ls -al gives what Oracle thinks it is... Now if I can
just find the manual to research the logic behind why.

Okay... Oracle's answer was it can't happen, therefore it didn't happen and
it therefore won't happen again.

Thank you... so much.  

April Wells
Oracle DBA 
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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: SOLARIS to linux


Seema
  Perhaps you can give us some idea of why export/import is unsatisfactory
for your purposes. Too much data? If so, how much data? Too small an amount
of time for production to be down?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, October 10, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L


Yes,Let me know is any other way  except EXPORT/import I can do ?

Thx
-Seema


From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: SOLARIS to linux
Date: Wed, 09 Oct 2002 19:03:41 -0800

One needs to use export/import while changing hardware platforms for Oracle
databases.

- Kirti

-Original Message-
Sent: Wednesday, October 09, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi
Can any one share data migration from sun solaris to linux ?
Thx
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
   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.com
--
Author: Deshpande, Kirti
   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).


import

_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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.com
-- 
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: DROP DEVELOPER not working



Whoa  Stephane  You might be onto something here. The developer
confirmed that they do use Pro*C and cursors in the process. Will
investigate.

Thanks a ton
Raj




   
 
Stephane   
 
Faroult  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
sfaroult@oricc:   
 
ole.com Subject: Re: DROP DEVELOPER not working   
 
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
October 10,
 
2002 03:25 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




[EMAIL PROTECTED] wrote:

 We have a developer here, installing a third party application, who
claims
 one of his delete campaign process is hanging. I looked at the wait
 events, saw nothing, and asked him to politely to go look at the code.
 After much analysys, the developer now complains, that Oracle is not
 executing a drop table command at the end of the process, and hanging
 there. He claims he can drop the table from SQLPLUS.

 I asked him to rerun the process. I noticed no wait events for that
session
 in v$session_wait when he claims the process is hanging. I see no DROP
 statements in the v$sqlarea. I did a 10046 trace, and the last statement
in
 the trace file is a select statement.  I looked at the sql addresses from
 v$session, linked it to v$sqlarea and the sql_text shows the same select
 statement as is seen in the trace file. I see no exclusive locks on the
 said table. I conclude that the application is not sending a DROP
statement
 to Oracle for execution. He claims that cannot be the case. They have
done
 the same installation in a test environment and it worked fine. The jury
 seems to be taking sides. I scream SOS. What more should I be doing? And
 Does an Oracle 10046 trace write into the trace file after the statement
 has executed?

 Thanks
 Raj


DROP DEVELOPER, what a nice idea ... Anyway, it reminds me of a similar
problem I had ca 1990 in a Pro*C program. I was checking something in a
table, cleanly closing my cursor, and trying to drop the table and it
timed out each time. The reason was that although my cursor was closed,
Pro*C was keeping it open in the hope that somewhat later I would reuse
it and it would save a parse. The lock which was preventing me from
dropping my table was not an exclusive lock, but a share lock on the
dictionary - as long as a cursor references a table, you can't drop it.
It was solved by adding the relevant bit of code (kind of pragma) to the
Pro*C code.
Does your saying 'I see no exclusive locks on the said table' implicitly
means that you are seeing other locks?
I think that there is one of those obscure init.ora parameters
instructing Oracle to cache or not to cache closed cursors. This may be
the difference between your test and prod environments.

--
Regards,

Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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

RE: CPU WAIT I/O statistic


Pablo - I posted the following paragraph yesterday:

 3) I looked in Oracle Performance Tuning 101 to see what Gaja has to say.
He points out that the Solaris sar -q command has a %wio column, a measure
of processes that are currently using the CPU, but are waiting for I/O
requests to be serviced and hence are not making prudent use of the CPU. He
further says that %sys and %wio should be less than 10-15% and if it is
consistently higher you need to get to the bottom of it, and usually it is a
application causing the problem. No details on how to get to the bottom.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, October 10, 2002 3:16 PM
To: Multiple recipients of list ORACLE-L


Hi list
   Can anyone explain me what exactly does the WAIT
I/O column of the sar -u output mean?

   Does it represent the % of CPU used by the kernel
processes to perform I/O? 

   As far as I know the waiting processes do no wait
actively when they ask for an I/O. right? The OS uses
the SLEEP and WAKEUP primitives.
   So, Which process is using this CPU? (The WAIT
I/O%)

   Or does this WAIT I/O have to be taken as if the
CPU were idle?

Please shed some light on this.
Thanks

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  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.com
--
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: SOLARIS to linux

2002-10-10 Thread Weaver, Walt


How about a database link?

--Walt (RTFM are my middle initials) Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, October 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


Yes,Let me know is any other way  except EXPORT/import I can do ?

Thx
-Seema


From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: SOLARIS to linux
Date: Wed, 09 Oct 2002 19:03:41 -0800

One needs to use export/import while changing hardware platforms for Oracle
databases.

- Kirti

-Original Message-
Sent: Wednesday, October 09, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi
Can any one share data migration from sun solaris to linux ?
Thx
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
   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.com
--
Author: Deshpande, Kirti
   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).


import

_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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.com
-- 
Author: Weaver, Walt
  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: DROP DEVELOPER not working - 10046 trace


Raj,
This reminds me of a similar situation I encountered several years
ago, perhaps there will be something in it that will help...
A 3rd party app was periodically committing only 2 of 3 changes that
were required. The most likely explanation of the problem was that there was
an unhandled exception and the app was issuing a commit regardless. This
turned out to be the case. This also would explain your situation where the
app fails, but the same command run manually works.
If the debug mode of the app failed to reveal any new info, I was
going to turn on events to dump out an error stack in case of an error on
inserts. We put together a list of probable errors on an insert (privs, bad
data, unable to extend, etc.) and could have placed these events in the
init.ora. The syntax is event = error trace name errorstack level 3
where error is the error number (1555 for Snapshot too old).

Dan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  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: Making a tablespace read-only - identifying blocking tx