RE: Oracle 9i Real Application Cluster Concepts manual.

[Rajesh Dayal]

It's 

http://technet.oracle.com/docs/products/oracle9i/content.html

HTH,
Rajesh
-Original Message-
Tatikonda
Sent: Wednesday, January 09, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L

hi all,

if any of you has Oracle 9i Real Application Cluster Concepts manual
softcopy could you please pass it on to me. Alternately if any of you
could provide pointers from where i can download this manual will also
be of great help.

thanks in advance,
Sathish.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sathish Tatikonda
  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).




Oracle9i Database - Documentation.url
Description: Binary data

RE: _system_trig_enabled=false question

[Reardon, Bruce (CALBBAY)]

Jay,

My understanding is it turns off system triggers - ie logon, logoff,
database startup, object drop, creation etc

Whether I would allow user access would depend on if your application uses
these sort of triggers.
eg do you have triggers to audit object dropping / creation?
Do you have DB startup triggers that run necessary packages, do you have a
login triggers that (eg) sets a default schema?

Note, as per another lister, I also have had problems removing JVM and
re-installing it.
By problems, I mean I had to drop the database and rebuild it to reload the
JVM - luckily this was only in test.
I opened a TAR on it but the response was over a number of months and never
reached a solution.

Why do you need to drop the JVM totally?
Did you have JVM in your 804 database (I don't think this was possible) or
have you started the install since going up to 817?
Can you just continue the JVM install on from where you were up to before?

Regards,
Bruce Reardon

-Original Message-
Sent: Wednesday, 9 January 2002 8:21

Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a
disk failure while I was doing my cold backup which delayed my start time
from midnight to 3:30am) I was unable to finish installing the JVM (not a
priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be
fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".  

Can anyone here confirm or deny problems with allowing user access and DML
while _system_trig_enabled is set to false?  What exactly is this parameter
doing?


Thanks!

Jay Miller
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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).

Unix - script

[Roland . Skoldblom]

Hallo,

I would like to have an example of a unix script, which does the following:

copy some files from directory /prod/sas/data  located at "hardy".(which is a computer)
to the other database hakon. Is it possible to do this. Please help me quick.


Thanks in advance

Roland S

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

RE: trace file question

[Reardon, Bruce (CALBBAY)]

Hi,

This is probably related to usage of JVM.

Have a look at Metalink Note: 103954.1 (subject Session Exceeded Soft
Sessionspace Limit of 0x10 Bytes) which suggests you can probably ignore
this.

If you get it constantly, look at if you need to increase the parameters
JAVA_MAX_SESSIONSPACE_SIZE  and / or JAVA_SOFT_SESSIONSPACE_LIMIT

Also take a look at Note:105236.1 Subject:  Simple Guideline for Tuning
Memory Parameters Using the Oracle8i JVM 


>From an Oracle forum posting:
"


There's not a great deal on these, but here goes. 

There are 2 init.ora parameters that let you control the session memory
usage for Java programs. 

java_soft_sessionspace_limit: 

When a user's session-duration Java state exceeds this size, Aurora
generates a warning that goes into the RDBMS .trc file. The default is 1MB.
You should understand the memory requirements of your deployed applications,
especially as they relate to usage of session space. This parameter allows
you to specify a "soft limit" on Java memory usage in a session, as a means
to warn you if something is awry. 

java_max_sessionspace_size: (hidden parameter) 

When a user's session-duration Java state attempts to exceeds this size,
Aurora kills the session with an out-of-memory failure. The default is 4GB.
This limit is purposely set extremely high to be normally invisible. If a
user-invokable Java program executing in the server can be used in a way
that is not self-limiting in its memory usage, then this setting may be
useful to place a hard limit on the amount of session space made available
to it. 
"
it then says later:
"The kernel group contends that there is a "bug" of sorts on this and the
zero indicates you are using the default value. 
Nobody can tell me when this will be fixed."

HTH,
Bruce Reardon


-Original Message-
Sent: Tuesday, 8 January 2002 20:40

I have a trace file generated by the database. At the end of the file you
will see an error of 
Session 10 exceeded soft sessionspace limit of 0x10 bytes.
What is this ? How can I handle that if needed ?
Thank you 
bunyamin

Dump file G:\orafiles\uybs3\tracefiles\udump\ORA01216.TRC
Fri Jan 04 18:46:40 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 , CPU type 586
Instance name: uybs3
Redo thread mounted by this instance: 1
Oracle process number: 25
Windows thread id: 1216, image: ORACLE.EXE

*** 2002-01-04 18:46:40.984
*** SESSION ID:(11.23471) 2002-01-04 18:46:40.828
Session 10 exceeded soft sessionspace limit of 0x10 bytes.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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).

Kernel parameters (Sun Solaris)

[ALEMU Abiy]

Hi guys,

Is there any guide line or documentation which gives values of OS kernel
parameters for Oracle ?  What are the recommended values for n instances on
which we have p processes and u users each ?

Thanks a lot 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ALEMU Abiy
  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).

Oracle 9i Real Application Cluster Concepts manual.

[Sathish Tatikonda]

hi all,

if any of you has Oracle 9i Real Application Cluster Concepts manual
softcopy could you please pass it on to me. Alternately if any of you
could provide pointers from where i can download this manual will also
be of great help.

thanks in advance,
Sathish.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sathish Tatikonda
  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).

Re: A Simple Rollback Segment Question

[hemantchitale]

>>Personally I never create one. First thing I do though is create the rbs
>>tablespace with a couple of rollback seg's before all other create
scripts.

Yes, but in the "pre-historic" days, you couldn't create the rbs tablespace
without first creating
a non-system rollback segment in the system tablespace !

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


[EMAIL PROTECTED] 08/01/2002 07:10 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)

 Subject: Re: A Simple Rollback Segment Question   

   

   

   







Hi


AFAIK this is a prehistoric requirement (Pre 7.3 I believe, No offense
meant :-)). Oracle needed it to create the tablespaces etc. Since 7.3 this
is no longer required (anyone know exactly when?).
Personally I never create one. First thing I do though is create the rbs
tablespace with a couple of rollback seg's before all other create scripts.


Jack




Naveen Nahata <[EMAIL PROTECTED]>@fatcity.com on 08-01-2002 10:50:21

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hello people,
This one is from Oracle Manual:


"In general, after database creation, you should create at least one
additional rollback segment in the SYSTEM tablespace. "


I can understand that you should create one additional rollback segment
after database creation b'coz otherwise oracle will use the SYSTEM rollback
segment and this may lead to fragmentation in the SYSTEM tablespace and
also a performance degradation. But why is one additional rollback segment
needed in SYSTEM TABLESPACE?


TIA
  \\\|///
 \\ - - //
 (  @ @  )
+--oOOo-(_)-oOOo--+
|Naveen Nahata
| Off: Churhcill SSI
|   89 SVR Complex
|   Hosur Road
|   Madiwala,Bangalore -  560068
|   INDIA.
| Work: (9180)  5535005
|! &n! ! bsp;  Ext -  111
| Home: (9180)  6685754
| E-mail: [EMAIL PROTECTED]
+-Oooo---+
  oooO(   )
  (   )) /
   \ ((_/
\_)



Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.







===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying,  distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst &
Young is neither liable  for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===





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

Fat City Network Services-- (858) 538-5051  FAX:

RE: Oracle Future???

[Suhen Pather]

List,

SQL Server is not even a threat to Oracle in the database market share.
Oracle mains competitor is DB2.

MS SQL Server is still mickey mouse and cannot offer the robustness,
scalabilty, reliability and performance of Oracle.

And yes, lots of people will become unemployed and many companies would have
to close down if SQL Server takes over.

So Microslop dream on.

Regards
$uhen


If this is true, then there will be a massive unemployment in the whole
world. 
Venkat
--

On Tue, 08 Jan 2002 07:30:39  
 April Wells wrote:
>YOU too?  Although, I guess it is the Evil DB2 voices who have been talking
>to me, not the Mysql ones... 
>
>-Original Message-
>Sent: Tuesday, January 08, 2002 8:50 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Uh Oh ... I thought I was the only person to whom the little voices talk to
>... Damn ... there is one more ...
>
>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: Tuesday, January 08, 2002 9:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi Folks, 
>Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
>emails from a MSSQL mailing list, they were discussing the future of MSSQL.
>Some of the comments included comments about our DB - Oracle. 
>I've added two here... 
>...With Hyperion been seriously challenged and overrun by Analysis
Services,
>oracle will completely die out as they integrate their current offering
into
>Oracle9i. 
>...Oracle will become another Apple: 5% market share. ... 
>Do you guys agree? Is Oracle doing anything about the very serious threat
>that MSSQL is placing on their market share? 
>No, plans of changing personally, but wondering if cross education won't be
>beneficial:) 
>Regards 
>Denham 
>
>begin 666 InterScan_Disclaimer.txt
>M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!IM=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9OM(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%LM>2!PM:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1IM;W!Y:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA
>M;B!T:&4@:6YT96YD960@M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@M86=E(&EN(&5RM871E;'D@8GD@7-T96US+"!)
>M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
>M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AIM(&)E96X@M:71Y(&9OM;V9T=V%R92!V:7)U6]U(&-AM(&]W;B!V:7)U%;G0N#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  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: C.S.Venkata Subramanian
  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: Suhen Pather
  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).

URGENT : how to insert/retrieve Blob ??

[Prem J Khanna]

hello everybody ,

would someone give me an example to insert/retrieve a bolb ?

i posted the same query yesterday . No response yet :(

Jp.


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

RE: Oracle Future???

[C.S.Venkata Subramanian]

If this is true, then there will be a massive unemployment in the whole world. 
Venkat
--

On Tue, 08 Jan 2002 07:30:39  
 April Wells wrote:
>YOU too?  Although, I guess it is the Evil DB2 voices who have been talking
>to me, not the Mysql ones... 
>
>-Original Message-
>Sent: Tuesday, January 08, 2002 8:50 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Uh Oh ... I thought I was the only person to whom the little voices talk to
>... Damn ... there is one more ...
>
>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: Tuesday, January 08, 2002 9:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi Folks, 
>Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
>emails from a MSSQL mailing list, they were discussing the future of MSSQL.
>Some of the comments included comments about our DB - Oracle. 
>I've added two here... 
>...With Hyperion been seriously challenged and overrun by Analysis Services,
>oracle will completely die out as they integrate their current offering into
>Oracle9i. 
>...Oracle will become another Apple: 5% market share. ... 
>Do you guys agree? Is Oracle doing anything about the very serious threat
>that MSSQL is placing on their market share? 
>No, plans of changing personally, but wondering if cross education won't be
>beneficial:) 
>Regards 
>Denham 
>
>begin 666 InterScan_Disclaimer.txt
>M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!IM=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9OM(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%LM>2!PM:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1IM;W!Y:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA
>M;B!T:&4@:6YT96YD960@M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@M86=E(&EN(&5RM871E;'D@8GD@7-T96US+"!)
>M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
>M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AIM(&)E96X@M:71Y(&9OM;V9T=V%R92!V:7)U6]U(&-AM(&]W;B!V:7)U%;G0N#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  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: C.S.Venkata Subramanian
  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).

RE: EXPORT WITH QUERY CLAUSE in win NT

[rpapnoi]

Tom and others
thanks for the feedback. I could solve the problem and the right answer is as 
follow:

exp username/password@nts7 tables=(linemto,specs,specmast,password) 
file=c:\MTO.DMP QUERY='where proj_code=''CF-804'''

Thank you all.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet["'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>]
Cc: R Papnoi@Systems@Chemtex

Ramesh,

The following worked on Win2000, exp version 8.1.7

exp userid=user/pw@sid file=exp.dmp tables=(wtw_states) query='where
state_abbr = ''NY'' '

Export: Release 8.1.7.0.0 - Production on Tue Jan 8 09:33:23 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
With the Partitioning option
JServer Release 8.1.7.1.1 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set

About to export specified tables via Conventional Path ...
. . exporting table WTW_STATES  1 rows exported
Export terminated successfully without warnings.


Note the extra single quotes within the query clause.

Hope this helps!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, January 08, 2002 1:00 AM
To: Multiple recipients of list ORACLE-L


Hi list

I want to export few tables with a common column in all. My OS is WinNT and 
db version is Oracle 8.1.6

I am using the folling command

exp username/password@nts7 tables=(linemto,specs,specmast,password) 
file=c:\MTO.DMP QUERY="where PROJ_CODE='CF-804'"

It gives me the following error:
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-0: Export terminated unsuccessfully


Where I am missing? Can someone correct me.
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

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

RE: Constraints

[Kimberly Smith]

Are they all in the same schema?

-Original Message-
Sent: Tuesday, January 08, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L


Tell me if I have this right ..

There are not supposed to be any Duplicate Constraint names in your
Database, right ??

Right now I have a database that has 48 constraints that are duplicated in
name.  They are constraints that have a system generated name.

Its on Oracle 8.0.5.   Anyone know of any known bug that would allow this ?

Thanks

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

RE: Gas Pains

[Kimberly Smith]

Skyscrapers?  Do we have those in Canada.  You can't hit what
you can't find

Not that this is off topic or anything.  I would take it off
this list but I am not on the other one.

-Original Message-
Sent: Tuesday, January 08, 2002 8:51 AM
To: Multiple recipients of list ORACLE-L


Yea, but I don't notice the Canadians getting
their skyscrapers pounded by people enraged at
middle east policies, either.

I guess it's a mixed bag, low gas prices.

"You get what you pay for."

Me, I'd rather pay 4$ a gallon, and use it to
get us the F**K out of the Middle East. Period.

-Original Message-
Sent: Tuesday, January 08, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L


You still pay about three times for gas.  Gas prices in Canada as
they are in parts of Europe but they are bad.  Makes me want to
throttle people in Oregon who complain about the gas prices out
here.  Especially since they have no sales tax.

You never know how good you have it until you don't.

-Original Message-
Sent: Tuesday, January 08, 2002 4:35 AM
To: Multiple recipients of list ORACLE-L


The Canadian gallon is not the same as the U.S. gallon.  The Canadian gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re[2]: Becoming a DBA questions

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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: Ken Janusz
  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: Kimberly Smith
  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.c

RE: TABLESPACE ALERT

[CHAN Chor Ling Catherine (CSC)]

Hi Seema,

I've a weekly job that informs me "List Of Tablespaces With Next Extent >
Largest Free Extent".  This list helps me to identify the list of
tablespaces that need to be extended due to lack of space (This script will
take into considerations the autoextend indicator).  If this is what you
were looking for, below is the sql statement. I am using Oracle 8.1.6.

Hope it helps.

Regds,
New Bee

REM
REM NAME :  fail_ext_segment.sql
REM FUNCTION :  To identify segments that will fail to acquire
REM their next extent.
REM HISTORY  :
REM DATEWHO WHAT
REM --- 
REM 07-Nov-2001 CHORLINGCREATION
REM

connect / as sysdba

SET PAGESIZE 60
SET LINESIZE 132
SET FEEDBACK OFF
SET VERIFY OFF
SET ECHO OFF
SET HEADING OFF

SELECT  'Database :  '||NAME||' Time :  '||
TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS')
FROMV$DATABASE;

SELECT  'Report   :  List Of Segments With Next Extent > Largest Free
Extent'
FROMDUAL;

SET TERMOUT OFF
REM SET NEWPAGE 0
SET HEADING ON
SET SPACE 1

COLUMN OWNER FORMAT A10
COLUMN SEGMENT_NAME FORMAT A30
COLUMN SEGMENT_TYPE FORMAT A10
COLUMN TABLESPACE_NAME FORMAT A15
COLUMN SEGMENT_TYPE HEADING "Segment|Type"
COLUMN EXTENTS_ALLOC HEADING "EXTENTS|ALLOC" format 999,999
COLUMN MAX_FREE_BYTES FORMAT999,999,999
COLUMN NEXT_EXTENT_BYTES FORMAT 999,999,999
COLUMN AUTO_EXTEND_TABLESPACE FORMAT A7
COLUMN NEXT_EXTENT_BYTES HEADING "Next|Extent|Bytes"
COLUMN MAX_FREE_BYTES HEADING "Largest|Free|Extent"
COLUMN TABLESPACE_NAME HEADING "Tablespace|Name"
COLUMN AUTO_EXTEND_TABLESPACE HEADING "Auto|Extend"

BREAK ON OWNER SKIP 1

SELECT
T.OWNER,T.SEGMENT_NAME,T.SEGMENT_TYPE,F.TABLESPACE_NAME,T.NEXT_EXTENT_BYTES,
  T.Extents_alloc,F.MAX_FREE_BYTES,DF.AUTO Auto_Extend_Tablespace
FROM (SELECT
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,MAX(NEXT_EXTENT)
NEXT_EXTENT_BYTES,
  SUM(EXTENTS) Extents_alloc
  FROM DBA_SEGMENTS GROUP BY
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME) T,
 (SELECT TABLESPACE_NAME,MAX(BYTES) MAX_FREE_BYTES FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
 (SELECT TABLESPACE_NAME,MAX(AUTOEXTENSIBLE) AUTO FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) DF
WHERE T.TABLESPACE_NAME = F.TABLESPACE_NAME
AND  F.MAX_FREE_BYTES <= T.NEXT_EXTENT_BYTES
AND DF.TABLESPACE_NAME=T.TABLESPACE_NAME
AND DF.AUTO='NO'
union
SELECT
T.OWNER,T.SEGMENT_NAME,T.SEGMENT_TYPE,F.TABLESPACE_NAME,T.NEXT_EXTENT_BYTES,
  T.Extents_alloc,F.MAX_FREE_BYTES,'Yes' Auto_Extend_Tablespace
FROM (SELECT TABLESPACE_NAME,(MAXBYTES-USER_BYTES)
MAX_FREE_BYTES,AUTOEXTENSIBLE AUTO
  FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='YES') F,
 (SELECT
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,MAX(NEXT_EXTENT)
NEXT_EXTENT_BYTES,
  SUM(EXTENTS) Extents_alloc
  FROM DBA_SEGMENTS GROUP BY
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
AND F.MAX_FREE_BYTES <= T.NEXT_EXTENT_BYTES
ORDER BY 1,4,3,2;


-Original Message-
From:   Seema Singh [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, January 09, 2002 8:00 AM
To: Multiple recipients of list ORACLE-L
Subject:TABLESPACE ALERT

Hi
I want to set alert information whenever a tablespaces reach
close to full 
or some particular space is free.
If some one have any scripts please send me.
Thanks
-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  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: CHAN Chor Ling Catherine (CSC)
  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 

Re: ORA-12638 error

[Jared . Still]

You probably have a line in you sqlnet.ora file that looks like this:

sqlnet.authentication_services = (NTS)

If so, comment it out with a pound # sign.

Jared



   
 
"shuan"
 

.co.id>  cc:   
 
Sent by: Subject: ORA-12638 error  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 04:40 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




hai...DBA,

i'm a newcomer for Oracle Enterprise Edition.
i used to learn Personal Edition 8.1.6 before.

now i'm facing a problem in Enterprise Edition 8.1.6 on Win2000 Advance
Server.
It worked fine before then suddenly, when i attempt to login,
no matter it's SQLPlus, EMS, DBA Studio,
it's just returned this error message:
ORA-12638 Credential retrieval failed
so i can't login and can't start the oracle.

i referred to Oracle error code description,
it say,
Cause: The authentication service failed to retrieve
credentials of a user.
Action: Enable tracing to determine the exact error.

so, what should i do? enable tracing for what? Listener?


thanks and hav a nice day.



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

RE: Oracle Future???

[Nick Wagner]

bleak... or blank?   or perhaps it's a bigger 
statement, that 'we' don't know as a whole... 
hmmm..   
 
 
-Original Message-From: Johnston, Tim 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 2:32 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Oracle Future???
So 
you're telling the future is bleak?

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 
  3:53 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle Future???

ORA-12638 error

[shuan]

hai...DBA,
 
i'm a newcomer for Oracle Enterprise 
Edition.
i used to learn Personal Edition 8.1.6 
before.
 
now i'm facing a problem in Enterprise Edition 8.1.6 
on Win2000 Advance Server.
It worked fine before then suddenly, when i attempt 
to login,
no matter it's SQLPlus, EMS, DBA 
Studio,
it's just returned this error message:
    ORA-12638 Credential retrieval 
failed
so i can't login and can't start the 
oracle.
 
i referred to Oracle error code 
description,
it say,
    Cause: The authentication service 
failed to retrieve
        
    credentials of a user.
    Action: Enable tracing to 
determine the exact error.
 
so, what should i do? enable tracing for what? 
Listener?
 
 
thanks and hav a nice 
day.

TABLESPACE ALERT

[Seema Singh]

Hi
I want to set alert information whenever a tablespaces reach close to full 
or some particular space is free.
If some one have any scripts please send me.
Thanks
-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  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).

Re: _system_trig_enabled=false question

[Jared . Still]

While difficult to do, java *can* be removed without recreating the
database.

Details on MetaLink.

Jared



   
 
"Sakthi , Raj" 
 

YAHOO.COM>   cc:   
 
Sent by: Subject: Re: _system_trig_enabled=false 
question   
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 01:49 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Miller ,
Be very carefull
There is a note on Metastink
Note:159801.1 Full JVM removal on 8.1.7.
which you should read before doing anything with jvm.
Moreover I had very experience with 8.1.7 JVM. Once it
fails during installation I was not able to remove it
completely and as usual oracle support told me to drop
the entire database and recreate it ( yeah..!! ). It
was a dev database so I was lucky.
There is another note on orageek about JVM
installations
http://www.interealm.com/technotes/admin_java_opt.html
which you might find usefull.

HTH.
Cheers,
RS

--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Due to time constraints during my recent 8.0.4 ->
> 8.1.7 upgrade (we had a
> disk failure while I was doing my cold backup which
> delayed my start time
> from midnight to 3:30am) I was unable to finish
> installing the JVM (not a
> priority since no one is using it yet).
> What I need to do now is run rmjvm.sql, restart the
> instance with
> _system_trig_enabled=false, reinstall everything,
> and restart the database
> with _system_trig_enabled=true.
>
> Nothing in the documentation says that users
> shouldn't connect while
> _system_trig_enabled=false.
>
> I opened a TAR with Oracle and the person told me
> that I'd "probably" be
> fine so long as I wasn't running auditing or certain
> security programs.
>
> I'm uncomfortable with that "probably".
>
> Can anyone here confirm or deny problems with
> allowing user access and DML
> while _system_trig_enabled is set to false?  What
> exactly is this parameter
> doing?
>
>
> 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  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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sakthi , Raj
  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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (8

RE: Oracle Future???

[Johnston, Tim]

So 
you're telling the future is bleak?

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 
  3:53 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle Future???

RE: _system_trig_enabled=false question

[Miller, Jay]

Fortunately none of those existed in 8.0.4 so we don't have them yet :).

-Original Message-
Sent: Tuesday, January 08, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


Setting _system_trig_enabled to false disables login triggers, startup
triggers and other non-DML event triggers. For more see DBA guide and 
Concepts manual.

-Original Message-
Sent: Tuesday, January 08, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L


Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a
disk failure while I was doing my cold backup which delayed my start time
from midnight to 3:30am) I was unable to finish installing the JVM (not a
priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be
fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".  

Can anyone here confirm or deny problems with allowing user access and DML
while _system_trig_enabled is set to false?  What exactly is this parameter
doing?


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  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: Gogala, Mladen
  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: Miller, Jay
  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).

RE: _system_trig_enabled=false question

[Miller, Jay]

I've read through the note already.  Fortunately I hadn't run any of the
other init scripts due to the time constraints.  I double checked with the
specific objects they mentioned if you had run init_jis.sql and none of them
existed.

I'll check out the site you mention.

-Original Message-
Sent: Tuesday, January 08, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L


Miller ,
Be very carefull
There is a note on Metastink 
Note:159801.1 Full JVM removal on 8.1.7.
which you should read before doing anything with jvm.
Moreover I had very experience with 8.1.7 JVM. Once it
fails during installation I was not able to remove it
completely and as usual oracle support told me to drop
the entire database and recreate it ( yeah..!! ). It
was a dev database so I was lucky.
There is another note on orageek about JVM
installations
http://www.interealm.com/technotes/admin_java_opt.html
which you might find usefull.

HTH.
Cheers,
RS

--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Due to time constraints during my recent 8.0.4 ->
> 8.1.7 upgrade (we had a
> disk failure while I was doing my cold backup which
> delayed my start time
> from midnight to 3:30am) I was unable to finish
> installing the JVM (not a
> priority since no one is using it yet).
> What I need to do now is run rmjvm.sql, restart the
> instance with
> _system_trig_enabled=false, reinstall everything,
> and restart the database
> with _system_trig_enabled=true.
> 
> Nothing in the documentation says that users
> shouldn't connect while
> _system_trig_enabled=false.
> 
> I opened a TAR with Oracle and the person told me
> that I'd "probably" be
> fine so long as I wasn't running auditing or certain
> security programs.
> 
> I'm uncomfortable with that "probably".  
> 
> Can anyone here confirm or deny problems with
> allowing user access and DML
> while _system_trig_enabled is set to false?  What
> exactly is this parameter
> doing?
> 
> 
> 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  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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sakthi , Raj
  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: Miller, Jay
  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).

RE: Convert ACESS to Oracle

[schmoldt]

I used Oracle's Migration Workbench and was happy with the results.  It
automated the whole process, created the tables, moved the data, created
PL/SQL functions to mimic Access functions Oracle doesn't offer.  I believe
you need to br running Oracle 8.1.7 to use it.

Dave

> -Original Message-
> From: Rusnak, George A. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 08, 2002 10:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Convert ACESS to Oracle
> 
> 
> Group,
> Can anyone please give me links, steps, document or step by 
> step procedures
> to convert an Access database to an Oracle database? Also, 
> please include
> any 'Gottcha's'.
> 
> Thanks
> 
> Al Rusnak
> 
> DeCA: 804-734-8453 
>[EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rusnak, George A.
>   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: 
  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).

Re: _system_trig_enabled=false question

[Sakthi , Raj]

Miller ,
Be very carefull
There is a note on Metastink 
Note:159801.1 Full JVM removal on 8.1.7.
which you should read before doing anything with jvm.
Moreover I had very experience with 8.1.7 JVM. Once it
fails during installation I was not able to remove it
completely and as usual oracle support told me to drop
the entire database and recreate it ( yeah..!! ). It
was a dev database so I was lucky.
There is another note on orageek about JVM
installations
http://www.interealm.com/technotes/admin_java_opt.html
which you might find usefull.

HTH.
Cheers,
RS

--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Due to time constraints during my recent 8.0.4 ->
> 8.1.7 upgrade (we had a
> disk failure while I was doing my cold backup which
> delayed my start time
> from midnight to 3:30am) I was unable to finish
> installing the JVM (not a
> priority since no one is using it yet).
> What I need to do now is run rmjvm.sql, restart the
> instance with
> _system_trig_enabled=false, reinstall everything,
> and restart the database
> with _system_trig_enabled=true.
> 
> Nothing in the documentation says that users
> shouldn't connect while
> _system_trig_enabled=false.
> 
> I opened a TAR with Oracle and the person told me
> that I'd "probably" be
> fine so long as I wasn't running auditing or certain
> security programs.
> 
> I'm uncomfortable with that "probably".  
> 
> Can anyone here confirm or deny problems with
> allowing user access and DML
> while _system_trig_enabled is set to false?  What
> exactly is this parameter
> doing?
> 
> 
> 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  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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sakthi , Raj
  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).

RE: _system_trig_enabled=false question

[Khedr, Waleed]

Again PROBABLY it's OK since no DDL was run.

-Original Message-
Sent: Tuesday, January 08, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L


Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a
disk failure while I was doing my cold backup which delayed my start time
from midnight to 3:30am) I was unable to finish installing the JVM (not a
priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be
fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".  

Can anyone here confirm or deny problems with allowing user access and DML
while _system_trig_enabled is set to false?  What exactly is this parameter
doing?


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  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: Khedr, Waleed
  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).

Re: EMC Not Releasing Space

[Mohammad Rafiq]

Work around is to unmount file system and mount it back...THis I have seen 
with HP-UX 10.20 and EMC
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 08 Jan 2002 10:55:31 -0800



This is a unix thing, not necessarily Oracle.

When you delete a file on unix, it will remain on disk as long
as there is an existing process holding the file open.

You will see the space reclaimed when the database is bounced.

Jared





 Walter K
 
 HOO.COM> cc:
 Sent by: Subject: EMC Not Releasing 
Space
 [EMAIL PROTECTED]
 om


 01/08/02 10:19
 AM
 Please respond
 to ORACLE-L






Hi,

Just curious if anyone has any experience with an EMC
Symmetrix not releasing the space for a deleted
datafile. If so, is there a solution or work-around?

Yesterday, we took a tablespace offline, dropped it
and then deleted the associated datafile. The file was
1G in size and today the space has still not been
released as indicated by 'df -k'. According to another
DBA here, they have seen this in the past and said
bouncing the DB remedied the problem.

It sounds like the inodes are still in use by Oracle
but I can't imagine why. I've worked with Symmetrix
systems before and have never experienced this
behavior. We are running 8.1.7.2 (64bit) on Solaris
2.8. Any suggestions?

As always, your feedback is appreciated.

-w

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
   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:
   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).




MOHAMMAD RAFIQ


_
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: Mohammad Rafiq
  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).

RE: _system_trig_enabled=false question

[Gogala, Mladen]

Setting _system_trig_enabled to false disables login triggers, startup
triggers and other non-DML event triggers. For more see DBA guide and 
Concepts manual.

-Original Message-
Sent: Tuesday, January 08, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L


Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a
disk failure while I was doing my cold backup which delayed my start time
from midnight to 3:30am) I was unable to finish installing the JVM (not a
priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be
fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".  

Can anyone here confirm or deny problems with allowing user access and DML
while _system_trig_enabled is set to false?  What exactly is this parameter
doing?


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  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: Gogala, Mladen
  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).

Re: login/exit problems

[Mohammad Rafiq]

Try to flush shared pool and check again the behaviour..
Regards
Rafiq

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 08 Jan 2002 11:19:56 -0800

We have an Oracle 7.3.4 database that has been stable for a number of
years but has started having problems during logon and exit with both
sqlplus and remote logins. It hangs for up to a minute before connecting
to Oracle server after you get

$ sqlplus ***/***

SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.



and similarly following an exit from Oracle server after disconnecting

Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options PL/SQL Release 2.3.4.0.0 - Production



before returning to OS command line prompt

lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
database make no difference. Any advice or help will be much
appreciated.

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




MOHAMMAD RAFIQ

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

RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

[Mohan, Ross]

if you attended IOUG and had a user/pwd it would, yea. 

thanks

-Original Message-
Sent: Tuesday, January 08, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


So we stumbled upon the white paper...

WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET 
By David F. Pennington, GlaxoSmithKline

This white paper raises a potential issue that DBAs might need to be aware
of.  Basically, it has to do with certain characters not storing correctly
in the database because of different character sets being used between the
database, client and how the user enters data into the application.

Has this issue been raised on the list before?

Basically, were wondering how other DBAs/sites are handling/approaching this
issue.

Many TIA!!

Chris

I believe the below link will get you to the white paper on the IOUG
website.

http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tech_
content_phy_Id=5310&v_trx=784353
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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: Mohan, Ross
  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).

Oracle Application DBA vs. Oracle DBA

[Leslie Lu]

Hi all,

What's the difference/similarity between Oracle
Application DBA and Oracle DBA.  To be an applicatoin
DBA, what kind of materials need to be studied?

Any idea, white paper, web site will be appreciated.

Thanks.

Leslie

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  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).

Re: Constraints

[Rachel Carmichael]

who is the owner of the duplicated constraints? if the owner names are
different, could you have created one set by import from the other
user?

just like any other object, the name can be the same if the owners are
different

--- Kevin Lange <[EMAIL PROTECTED]> wrote:
> Tell me if I have this right ..
> 
> There are not supposed to be any Duplicate Constraint names in your
> Database, right ??
> 
> Right now I have a database that has 48 constraints that are
> duplicated in
> name.  They are constraints that have a system generated name.
> 
> Its on Oracle 8.0.5.   Anyone know of any known bug that would allow
> this ?
> 
> Thanks
> 
> Kevin
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Lange
>   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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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).

RE: Best practices for data warehousing in 9i

[HAWKINS, JAMES W [IT/1000]]

Materialized views with query_rewrite enabled.  Can work wonders for
long-running reports.  This was available in 8i, so not exactly new to 9i,
but something you left off your list.

Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, January 08, 2002 2:53 PM
To: Multiple recipients of list ORACLE-L



What are considered to be some of the best practices for physical database
layout in 9i for data warehouses.

This would be on Sun Solaris 2.6 and 9.0.1 (or possibly 9.0.2 if it comes
out anytime soon).   Would be using partitioning and star schema as well as
bit-map indexes.

Anything important to consider in 9i in terms of new features for data
warehousing?   Any thing to watch out for?

Thanks for any experience you might have in this area.

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: HAWKINS, JAMES W [IT/1000]
  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).

RE: Constraints

[Jacques Kilchoer]

Title: RE: Constraints





> -Original Message-
> From: Kevin Lange [mailto:[EMAIL PROTECTED]]
> 
> There are not supposed to be any Duplicate Constraint names in your
> Database, right ??
> 
> Right now I have a database that has 48 constraints that are 
> duplicated in
> name.  They are constraints that have a system generated name.
> 
> Its on Oracle 8.0.5.   Anyone know of any known bug that 
> would allow this ?


The constraints probably have different owners. See example below.


LQS> create table wolfgang.t (n number not null) ;


Table créée.


LQS> select constraint_name from dba_constraints
  2  where owner = 'WOLFGANG' and table_name = 'T' ;


CONSTRAINT_NAME
--
SYS_C001631


LQS> create table amedeus.t (n number constraint sys_c001631 not null) ;


Table créée.


LQS> select owner, constraint_name
  2  from dba_constraints
  3  where owner in ('WOLFGANG', 'AMEDEUS') and table_name = 'T' ;


OWNER  CONSTRAINT_NAME
-- --
WOLFGANG   SYS_C001631
AMEDEUS    SYS_C001631

_system_trig_enabled=false question

[Miller, Jay]

Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a
disk failure while I was doing my cold backup which delayed my start time
from midnight to 3:30am) I was unable to finish installing the JVM (not a
priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be
fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".  

Can anyone here confirm or deny problems with allowing user access and DML
while _system_trig_enabled is set to false?  What exactly is this parameter
doing?


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

RE: Constraints

[Khedr, Waleed]

CREATE UNIQUE INDEX SYS.I_CON1
ON SYS.CON$(OWNER#,NAME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE SYSTEM
STORAGE(INITIAL 16K
NEXT 96K
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 50
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
LOGGING
NOPARALLEL
/

-Original Message-
Sent: Tuesday, January 08, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Tell me if I have this right ..

There are not supposed to be any Duplicate Constraint names in your
Database, right ??

Right now I have a database that has 48 constraints that are duplicated in
name.  They are constraints that have a system generated name.

Its on Oracle 8.0.5.   Anyone know of any known bug that would allow this ?

Thanks

Kevin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  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: Khedr, Waleed
  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).

US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!!!

[Grabowy, Chris]

So we stumbled upon the white paper...

WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET 
By David F. Pennington, GlaxoSmithKline

This white paper raises a potential issue that DBAs might need to be aware
of.  Basically, it has to do with certain characters not storing correctly
in the database because of different character sets being used between the
database, client and how the user enters data into the application.

Has this issue been raised on the list before?

Basically, were wondering how other DBAs/sites are handling/approaching this
issue.

Many TIA!!

Chris

I believe the below link will get you to the white paper on the IOUG
website.

http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tech_
content_phy_Id=5310&v_trx=784353
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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).

RE: Archive log dest full

[Henry Poras]

I've used:  (sorry, but I can never remember which lists let through text
documents and which lists don't. I can always resend as such)

#!/usr/bin/ksh

##NAME: maint_arch.sh
##CREATED ON:   10/17/2001
##CREATED BY:   Henry Poras
##DESCRIPTION:  Script to deal with space issues when
##  the directory containing Oracle archive logs
##  fills up. The logs can be compressed or moved
##  to a new location.
##SETUP:Set the following parameters:
##  VOL_I   Volume containing the archive logs as seen
##  through df -k
##  DIR_I   Current directory holding the logs
##  DIR_F   Final location of the logs (if they are
##  to be moved)
##  THRESH  Threshold of %space used in VOL_I before
##  CMD is run
##  CMD Command to be run. Standard input consists
##  of the full path of the archive log files
##  LOG_PREFIX  
##  LOG_SUFFIX
##  Can be run from cron or manually
##MODIFICATIONS:
##
###

VOL_I=/vol00# volume of concern as appearing in df -k
# A grep of this name should only return
# a single line.
DIR_I=/vol00/orabu/test # The initial directory of the archive logs.
DIR_F=/vol05/orabu/test # The final location of the archive logs.
THRESH=3# Threshold of %space used to trigger the 
# actions.
#CMD="mv {} $DIR_F/{}"  # Command to move the files
#CMD="compress {}"  # Command to compress the files
CMD=" -t echo {}"
LOG_PREFIX=arch.log1_   # Log name leading the numbers (standard is
# arch)
LOG_SUFFIX=.dbf # Log name following the numbers (standard is
# .arc) 

##
##
##  Test that there is only a single volume containing VOL_I. If not,
##  THRESH cannot be used.
##
##

if  #check for single volume

test `df -kl|grep $VOL_I|wc -l` -ne 1
then
echo 'Error in initial volume'
else
if  #test %used greater than threshold
test `df -kl|grep $VOL_I|awk '{print $5}'|sed 's/%//'` -gt $THRESH
then
ls $DIR_I/arch*|
#use grep -v to exclude the maximum archive
#log from the list (ls). This is in case
#it is still active. (fuser could also
#be used (thanks Jared).
grep -v `ls $DIR_I/arch*|
 sed 's/$LOG_PREFIX//
  s/$LOG_SUFFIX//'|
 nawk '
  BEGIN {MAX_ARCH_NO==0}
{if ($1>MAX_ARCH_NO) {MAX_ARCH_NO=$1}}
  END   {printf "%s\n", MAX_ARCH_NO}
  '
`|
xargs -i $CMD
fi
fi



-Original Message-
Sent: Tuesday, January 08, 2002 3:01 PM
To: Multiple recipients of list ORACLE-L


it's just a shell script that does a cd, then gzip *.archive

run in cron... 
--- Prakriteswar Santikary <[EMAIL PROTECTED]>
wrote:
> Rachel,
> 
> do you have a script for this ? I would appreciate if you could send
> me that
> script.
> 
> regards
> Santi
> 
> -Original Message-
> Sent: Tuesday, January 08, 2002 5:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> we run a batch job every hour that takes all the unzipped archived
> redo
> logs and zips them, so that we keep compressing space. The other
> thing
> I used to do was on a daily basis, move the prior day's logs to
> another
> drive so that I was only storing one day's worth of archived logs at
> the archive log dest drive
> 
> 
> --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> > So yesterday the archive log dest disk filled up on one of our
> > prduction
> > systems causing the Oracle DB to halt as it's supposed to.  Disk
> > space was
> > tight and there was a bit of data loading done.  Anyhow I freed up
> > disk
> > space on relevant drive and proceeded to server console to press
> the
> > OK
> > button to allow archiving to restart.  However, the console was
> > locked by a
> > PC Anywhere session which prevented me from getting to the console
> > window
> > with archive dest full message.  Anyhow ended up having to bounce
> the
> > database.  Apart from throttling the user who set the PC anywhere
> > lock on
> > the console and insisting it not be done again I'm wondering did I
> > have any
> > other options apart from a database bounce

RE: CASE WHEN or DECODE - any efficiency differences

[Jacques Kilchoer]

Title: RE: CASE WHEN or DECODE - any efficiency differences





In my original tests (I wish I had kept the numbers), trying different combinations on several different million-row tables, in a development database with no one else connected, on a development server otherwise unused, my results were that the majority of times CASE was faster, but only by 10% or less, and a few times DECODE was faster. Of course my test was only on "long"-running queries (5 minutes or more). Perhaps your "fast" query paints a more accurate picture.

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> 
> Using the supplied query on a Linuxbox RH7.1 Oracle 8.1.7 
> provided the following:
> 
> CASE Elapsed: 00:00:00.10
> 
> Statistics
> ---
>   0  recursive calls
>   8  db block gets
>    6010  consistent gets
> 283  physical reads
>   0  redo size
>  156280  bytes sent via SQL*Net to client
>   42823  bytes received via SQL*Net from client
> 384  SQL*Net roundtrips to/from client
>   0  sorts (memory)
>   0  sorts (disk)
>    5735  rows processed
> *-
> 
> DECODE Elapsed: 00:00:00.40
> 
> Statistics
> 
>   7  recursive calls
>   8  db block gets
>    6013  consistent gets
> 278  physical reads
>   0  redo size
>  156280  bytes sent via SQL*Net to client
>   43219  bytes received via SQL*Net from client
> 384  SQL*Net roundtrips to/from client
>   0  sorts (memory)
>   0  sorts (disk)
>    5735  rows processed
> *
> There appears to be a large difference between the two.

RE: Constraints

[Kevin Lange]

OK.   My problem . and a bad error message from Oracle..  Never
mind.

-Original Message-
Sent: Tuesday, January 08, 2002 2:53 PM
To: Multiple recipients of list ORACLE-L


Tell me if I have this right ..

There are not supposed to be any Duplicate Constraint names in your
Database, right ??

Right now I have a database that has 48 constraints that are duplicated in
name.  They are constraints that have a system generated name.

Its on Oracle 8.0.5.   Anyone know of any known bug that would allow this ?

Thanks

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

Re: Constraints

[Brian McGraw]

Can we see the script that allowed you to determine this?  Are you sure you're
accounting for different users?

Brian

Kevin Lange wrote:

> Tell me if I have this right ..
>
> There are not supposed to be any Duplicate Constraint names in your
> Database, right ??
>
> Right now I have a database that has 48 constraints that are duplicated in
> name.  They are constraints that have a system generated name.
>
> Its on Oracle 8.0.5.   Anyone know of any known bug that would allow this ?
>
> Thanks
>
> Kevin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   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).

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


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

RE: Oracle Future???

[Andrey Bronfin]

Best practices for data warehousing in 9i

[Cherie_Machler]

What are considered to be some of the best practices for physical database
layout in 9i for data warehouses.

This would be on Sun Solaris 2.6 and 9.0.1 (or possibly 9.0.2 if it comes
out anytime soon).   Would be using partitioning and star schema as well as
bit-map indexes.

Anything important to consider in 9i in terms of new features for data
warehousing?   Any thing to watch out for?

Thanks for any experience you might have in this area.

Cherie Machler
Oracle DBA
Gelco Information Network

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

RE: login/exit problems

[Johnston, Tim]

Check to see if otrace is enabled...  Note: 45482.1 on Metalink should
help...

Tim

-Original Message-
Sent: Tuesday, January 08, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


We have an Oracle 7.3.4 database that has been stable for a number of
years but has started having problems during logon and exit with both
sqlplus and remote logins. It hangs for up to a minute before connecting
to Oracle server after you get

$ sqlplus ***/***

SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.  



and similarly following an exit from Oracle server after disconnecting 

Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options PL/SQL Release 2.3.4.0.0 - Production 



before returning to OS command line prompt

lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
database make no difference. Any advice or help will be much
appreciated.

Tony
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: afa2
  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: Johnston, Tim
  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).

When is 9.0.2 supposed to be released?

[Cherie_Machler]

Anybody heard when 9.0.2 is expected to be  released for Sun Solaris?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

Oracle9iAS and proxy servers

[Ben Poels]

Hi

I have used Oracle8i but I am new to the Oracle9iAS world.

I would like to set up a proxy server outside a firewall
which routes to an Oracle9iAS server inside the firewall.
Can the proxy server just be a basic Apache install, or are
their benefits/requirements to using 9iAS (maybe the core
or minimal edition) as the proxy? 

Can anyone point me at some documentation on this topic, as
nothing came up on my MetaLink search except numerous references
to the "Proxy log on failed" problem.

Thanks,

Ben

==
 Ben Poels - Senior Technical Analyst - Queen's University at Kingston
 Phone: 613.533.2449  Fax: 613.533.2168  Email: [EMAIL PROTECTED]
==

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

RE: Dig it - killer freeware editor

[Mohan, Ross]

I've used thisit is stellar. 

-Original Message-
Sent: Tuesday, January 08, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L


Another cheap and excellent editor.

http://www.multiedit.com/

>>> [EMAIL PROTECTED] 01/08/02 02:10PM >>>
Ross,

Try www.ultraedit.com as well.  It may not be free, but it sure is CHEAP
and
extremely robust.  The guy who wrote context should have looked here first.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   1/8/2002 10:40 AM

http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Mohan, Ross
  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: 
  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: Gene Sais
  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: Mohan, Ross
  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).

RE: Dig it - killer freeware editor

[Mohan, Ross]

roger that, my DBA Brother..

-Original Message-
Sent: Tuesday, January 08, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Looks very cool Ross, thanks for the link. -E

-Original Message-
Sent: Tuesday, January 08, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: Post, Ethan
  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: Mohan, Ross
  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).

RE: Oracle Future??? - from the darkside

[tday6]

I won't comment on what I think about Oracle as a company.  However, the
fact that Beta was technically superior to VHS and sold at a cheaper price
did not save it from a series of bad marketing decisions.  Today people
don't even remember that VCR's used to come in two separate and
incompatible "flavors".


   

"Bowes,

Chris"   To: Multiple recipients of list ORACLE-L  



@kosa.com>   cc:   

Sent by: rootSubject: RE: Oracle Future??? - from the  

 darkside  

   

01/08/2002 

11:50 AM   

Please 

respond to 

ORACLE-L   

   

   






Actually, It's possible.  Maybe not down to 5%,  but if y'all don't think
that Oracle is ripe for a market defeat, then you need  to take a hard look
at our industry...  Take here for example.   We had Oracle here everywhere.
We have Oracle programmers, DBA's,  etc.  Then, we get a new CEO.  Fresh
out of Harvard (where they  obviously know everything), he went to company
"A" and they had  sqlserver.  When he left company "A" and came here, guess
what we were ordered to convert EVERYTHING to.  Well, everything  except
SAP.  Oracle will be out of here by 2003.  Gone, Bye Bye.   C'ya, don't
want to be ya.  Oracle personnel that don't cross train or  haven't shown
the ability to cross train are gone too.  The only thing we  had to say
about it was "Luke, I am your father, where are the sqlserver  discs?"  In
one month, 6 years of oracle development was ordered to be out  within 2
years.

The  sad fact is that the Jared Still's and Steve Adam's are not making the
decisions in enough companies.  There are too many managers way up the food
chain who have no clue that the marketing hype they is pure BS.  They  buy
the spin and make the decisions based on that.   The fact that  sqlserver
cannot out perform Oracle is not relevant.  The fact that  sqlserver can
only run on NT/2000/XP is not relevant.  It will actually be  sold as a
positive.  "Ya, know, most mcse's are also mcDba's  too..."  It may not be
true, but facts are not where the decision will  be made.  Marketing hype
is.  When the "cost savings" is put into the  manager's head, the decision
will be made.  By the time that the facts of  the performance and headaches
and costs of conversion are pointed  out, people will bury it and forget it
existed.  "After all, it is  just a computer and I am not going to risk
my job arguing over a  computer decision. Besides, the IT folks can do
anything..."   Remember, spending 2 million to convert to something that
will save 100K a year  thereafter, is a SAVINGS in the eyes of an upper
manager.

Other  companies I have worked for are doing the same thing.  Marketing
drives the  industry now (look at SAP).  Too many idiots.  Not
enough voices of reason.   I don't expect Oracle to lose their  share to
5%, but if they don't start fighting better, they will have serious
competition from sqlserver and other areas.

--Chris
[EMAIL PROTECTED]









--Chris
[EMAIL PROTECTED]


-Original  Message-
a
Sent: 08 January 2002 14:25
To:  Multiple recipients of list ORACLE-L



Hi Folks,

Wonder if anyone  would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL  mailing list, they were discussing the future of
MSSQL.

Some of the  comments included comments about our DB - Oracle.
I've added two here...

...With Hyperion  been seriously challenged and overrun by Analysis
Services, oracle will  completely die out as they integrate their current
offering into Oracle9i.  

...Oracle will  become another Apple: 5% market share. ...

Do you guys agree?  Is Oracle doing anything about the very serious threat
that MSSQL is placing on  their market share?

No, plans of  changing personally, but wondering if cross education won't
be  beneficial:)

Regards
Denham

This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal - For more  information pl

Constraints

[Kevin Lange]

Tell me if I have this right ..

There are not supposed to be any Duplicate Constraint names in your
Database, right ??

Right now I have a database that has 48 constraints that are duplicated in
name.  They are constraints that have a system generated name.

Its on Oracle 8.0.5.   Anyone know of any known bug that would allow this ?

Thanks

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

Re: additional duties, as required / Re: ORACLE-L Digest -- Volume 2002, Number

[Jared . Still]

Eric,

I hope this was actually meant for the off topic list, cuz
it doesn't belong here.

Jared



   
 
"Eric D.   
 
Pierce"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: additional duties, as required / 
Re: ORACLE-L Digest --   
Sent by:  Volume 2002, Number 008  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 11:42 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




His job responsibilities probably also include selling
penis gourds, some of which have with smiley faces.
that is where the really big money is at these days.



ORACLE-L Digest -- Volume 2002, Number 008
>RE: Becoming a DBA questions
> On 4 Jan 2002 at 14:00, Randy Kirkpatrick wrote:
>
> > I'm sorry ... but "a little over $100K" + $7K is way over what any
> > reasonable person would pay for a newbie DBA! I stand by my previous
> > message ... this is full of crap unless he's doing more than DBA work!
>


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

RE: Oracle Future???

[John Kanagaraj]

Eva et al,
 
I believe the survivability of a product is based on a number of factors
including current market share, depth and availability of skills in the
marketplace (this translates to product momentum), availability (and ease)
of upgrades for newer and better features in new versions (catching up with
ya!), availability of choice-of-platform (I can choose the better,
lower-cost platform and am not locked in to one h/w vendor), availability of
third-party packages as well as add-on packages that can be plugged on to
cater to areas that are not addressed in the base product (e.g. ERP
products, monitoring tools, etc.), financial ability and sustainability of
the company, depth and breadth of products, effort required to move off the
product, *apart* from base cost (what it costs to buy), total cost of
ownership (what it costs to run, including staff costs, server licences,
etc.) . If you look at the products that have 'died', it is because they
lacked one or more of these factors when compared to another similar product
that survived. In this case, they did a natural death. In some cases, they
were also taken over by another competitor and be 'put to death' (as with
IBM/Informix). I don't think that neither Oracle nor MS is at that place.
Although MS is available only on M$ platforms, they have a very large base
that will carry them along for a while. I believe that Oracle will survive
at least in the ERP areas as they are actively increasing their base in this
area at the cost of SAP and other packages, and it is difficult to knock off
a working ERP application that is entrenced with the bean-counters.
 
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Wanna know the reason for the season? Click on ' http://www.needhim.org'
 

** The opinions and statements above are entirely my own and not
those of my employer or clients **


-Original Message-
Sent: Tuesday, January 08, 2002 6:25 AM
To: Multiple recipients of list ORACLE-L



Hi Folks, 

Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL mailing list, they were discussing the future of MSSQL.

Some of the comments included comments about our DB - Oracle. 
I've added two here... 

...With Hyperion been seriously challenged and overrun by Analysis Services,
oracle will completely die out as they integrate their current offering into
Oracle9i. 

...Oracle will become another Apple: 5% market share. ... 

Do you guys agree? Is Oracle doing anything about the very serious threat
that MSSQL is placing on their market share? 

No, plans of changing personally, but wondering if cross education won't be
beneficial:) 

Regards 
Denham 

  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


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

RE: Updating table a from table c through table b.

[Jacques Kilchoer]

Title: RE: Updating table a from table c through table b.





> -Original Message-
> From: Rod Clayton [mailto:[EMAIL PROTECTED]]
> 
> I have a field in a table called C called ID that I want to 
> use to update a field in table A called ID.  
> 
> Table A has a key to table B which has a key to table C.
> 
> I can not find a working example of doing this.  
> 
> Does anyone have a suggtion.  I have been using the examples 
> in the Oracle manuals, but I can't seem to get one to work.



Here's an example:


LQS> select * from a ;


 K ID
-- --
 1
 2


LQS> select * from b ;


 K K2
-- --
 1 11
 3 33


LQS> select * from c ;


    K2 ID
-- --
    11    111
    22    222
    33    333
    44   


LQS> update a set a.id = (select c.id from b, c where b.k = a.k and c.k2 = b.k2)
  2  where exists (select * from b, c where b.k = a.k and c.k2 = b.k2) ;


1 ligne mise à jour.


LQS> select * from a ;


 K ID
-- --
 1    111
 2

RE: CASE WHEN or DECODE - any efficiency differences

[Ron Rogers]

Using the supplied query on a Linuxbox RH7.1 Oracle 8.1.7 provided the following:

CASE Elapsed: 00:00:00.10

Statistics
---
  0  recursive calls
  8  db block gets
   6010  consistent gets
283  physical reads
  0  redo size
 156280  bytes sent via SQL*Net to client
  42823  bytes received via SQL*Net from client
384  SQL*Net roundtrips to/from client
  0  sorts (memory)
  0  sorts (disk)
   5735  rows processed
*-
DECODE Elapsed: 00:00:00.40

Statistics

  7  recursive calls
  8  db block gets
   6013  consistent gets
278  physical reads
  0  redo size
 156280  bytes sent via SQL*Net to client
  43219  bytes received via SQL*Net from client
384  SQL*Net roundtrips to/from client
  0  sorts (memory)
  0  sorts (disk)
   5735  rows processed
*
There appears to be a large difference between the two.
Thanks for the query and ability to test.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 01/08/02 02:38PM >>>
> -Original Message-
> From: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] 
> 
> I've just been asked whether there are any efficiency 
> differences between
> CASE WHEN and DECODE.  I'd imagined that they would use the 
> same underlying
> code but perhaps not.  Does anyone know which is more 
> efficient (I realise
> that CASE is SQL-92 compliant and allows use of IN but 
> excluding this is
> there any efficiency difference)

This is not the test I originally ran, but you could try this in your
database (uses dba_objects). I just ran this script on one of our
development databases with a large number of objects. The version with case
took approx. 27 seconds, the version with decode approx. 24 seconds (time
displayed by "set timing on").

set timing on
set autotrace traceonly statistics
select
   case
 when substr (object_name, 1, 1) = 'A'
   then 'Object Name starts with A'
 when substr (object_name, 1, 1) = 'B'
  then 'Object Name starts with B'
 when substr (object_name, 1, 1) = 'C'
  then 'Object Name starts with C'
 when substr (object_name, 1, 1) = 'D'
  then 'Object Name starts with D'
 when substr (object_name, 1, 1) = 'E'
  then 'Object Name starts with E'
 when substr (object_name, 1, 1) = 'F'
  then 'Object Name starts with F'
 when substr (object_name, 1, 1) = 'G'
  then 'Object Name starts with G'
 when substr (object_name, 1, 1) = 'H'
  then 'Object Name starts with H'
 when substr (object_name, 1, 1) = 'I'
  then 'Object Name starts with I'
 when substr (object_name, 1, 1) = 'J'
  then 'Object Name starts with J'
 when substr (object_name, 1, 1) = 'K'
  then 'Object Name starts with K'
 when substr (object_name, 1, 1) = 'L'
  then 'Object Name starts with L'
 when substr (object_name, 1, 1) = 'M'
  then 'Object Name starts with M'
 when substr (object_name, 1, 1) = 'N'
  then 'Object Name starts with N'
 when substr (object_name, 1, 1) = 'O'
  then 'Object Name starts with O'
 when substr (object_name, 1, 1) = 'P'
  then 'Object Name starts with P'
 when substr (object_name, 1, 1) = 'Q'
  then 'Object Name starts with Q'
 when substr (object_name, 1, 1) = 'R'
  then 'Object Name starts with R'
 when substr (object_name, 1, 1) = 'S'
  then 'Object Name starts with S'
 when substr (object_name, 1, 1) = 'T'
  then 'Object Name starts with T'
 when substr (object_name, 1, 1) = 'U'
  then 'Object Name starts with U'
 when substr (object_name, 1, 1) = 'V'
  then 'Object Name starts with V'
 when substr (object_name, 1, 1) = 'W'
  then 'Object Name starts with W'
 when substr (object_name, 1, 1) = 'X'
  then 'Object Name starts with X'
 when substr (object_name, 1, 1) = 'Y'
  then 'Object Name starts with Y'
 when substr (object_name, 1, 1) = 'Z'
  then 'Object Name starts with Z'
 else 'Object Name doesn''t start with capital letter'
   end as object_name_first_letter
from dba_objects ;
/
select
   decode (substr (object_name, 1, 1),
   'A', 'Object Name starts with A',
   'B', 'Object Name starts with B',
   'C', 'Object Name starts with C',
   'D', 'Object Name starts with D',
   'E', 'Object Name starts with E',
   'F', 'Object Name starts with F',
   'G', 'Object Name starts with G',
   'H', 'Object Name starts with H',
   'I', 'Object Name starts with I',
   'J', 'Object Name starts with J',
   'K', 'Object Name starts with K',
   'L', 'Object Name starts with L',
   'M', 'Object Name starts with

RE: OT list

[Scott . Shafer]

Be afraid.  Be very afraid...

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and
desperate."

> -Original Message-
> From: JOE TESTA [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 08, 2002 2:01 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT list
> 
> There is an off topic oracle list so that we dont clutter up the people
> who want to read real oracle posts.
>  
> send email to [EMAIL PROTECTED]
> 
>  
> assuming i remember correctly.
>  
> joe
>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).

RE: Archive log dest full

[Prakriteswar Santikary]

thanks Rachael.

-Original Message-
Sent: Tuesday, January 08, 2002 12:01 PM
To: Multiple recipients of list ORACLE-L


it's just a shell script that does a cd, then gzip *.archive

run in cron... 
--- Prakriteswar Santikary <[EMAIL PROTECTED]>
wrote:
> Rachel,
> 
> do you have a script for this ? I would appreciate if you could send
> me that
> script.
> 
> regards
> Santi
> 
> -Original Message-
> Sent: Tuesday, January 08, 2002 5:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> we run a batch job every hour that takes all the unzipped archived
> redo
> logs and zips them, so that we keep compressing space. The other
> thing
> I used to do was on a daily basis, move the prior day's logs to
> another
> drive so that I was only storing one day's worth of archived logs at
> the archive log dest drive
> 
> 
> --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> > So yesterday the archive log dest disk filled up on one of our
> > prduction
> > systems causing the Oracle DB to halt as it's supposed to.  Disk
> > space was
> > tight and there was a bit of data loading done.  Anyhow I freed up
> > disk
> > space on relevant drive and proceeded to server console to press
> the
> > OK
> > button to allow archiving to restart.  However, the console was
> > locked by a
> > PC Anywhere session which prevented me from getting to the console
> > window
> > with archive dest full message.  Anyhow ended up having to bounce
> the
> > database.  Apart from throttling the user who set the PC anywhere
> > lock on
> > the console and insisting it not be done again I'm wondering did I
> > have any
> > other options apart from a database bounce to overcome this
> problem?.
> > 
> > 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  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).
> 
> 
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   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: Prakriteswar Santikary
>   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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.

Re: RE: Gas Pains

[Jared . Still]

Somewhere on yahoo.

Someone else that knows the location will have to chime in here.

Jared



   
 
sdlockhart@big 
 
planet.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Re: RE: Gas Pains
 
om 
 
   
 
   
 
01/08/02 11:38 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Jared,
Where is the Off Topic List?

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

RE: OT list

[Khedr, Waleed]

Are you trying to say ENOUGH 
PLEASE?

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 3:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: OT 
  list
  There is an off topic oracle list so that we dont clutter up the people 
  who want to read real oracle posts.
   
  send email to [EMAIL PROTECTED]
   
  assuming i remember correctly.
   
  joe
   

RE: login/exit problems

[Baker, Barbara]

Can't hurt to start a new listener log.  (Is you old one huge?)
stop listener, rename log file, restart it.



> --
> From: afa2[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, January 08, 2002 12:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  login/exit problems
> 
> We have an Oracle 7.3.4 database that has been stable for a number of
> years but has started having problems during logon and exit with both
> sqlplus and remote logins. It hangs for up to a minute before connecting
> to Oracle server after you get
> 
> $ sqlplus ***/***
> 
> SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002
> 
> Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.  
> 
> 
> 
> and similarly following an exit from Oracle server after disconnecting 
> 
> Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
> With the distributed, replication, parallel query and Spatial Data
> options PL/SQL Release 2.3.4.0.0 - Production 
> 
> 
> 
> before returning to OS command line prompt
> 
> lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
> database make no difference. Any advice or help will be much
> appreciated.
> 
> Tony
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: afa2
>   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: Baker, Barbara
  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).

Updating table a from table c through table b.

[Rod Clayton]

I have a field in a table called C called ID that I want to use to update a field in 
table A called ID.  

Table A has a key to table B which has a key to table C.

I can not find a working example of doing this.  

Does anyone have a suggtion.  I have been using the examples in the Oracle manuals, 
but I can't seem to get one to work.

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  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).

OT list

[JOE TESTA]

There is an off topic oracle list so that we dont clutter up the people who 
want to read real oracle posts.
 
send email to [EMAIL PROTECTED]
 
assuming i remember correctly.
 
joe
 

RE: Archive log dest full

[Rachel Carmichael]

it's just a shell script that does a cd, then gzip *.archive

run in cron... 
--- Prakriteswar Santikary <[EMAIL PROTECTED]>
wrote:
> Rachel,
> 
> do you have a script for this ? I would appreciate if you could send
> me that
> script.
> 
> regards
> Santi
> 
> -Original Message-
> Sent: Tuesday, January 08, 2002 5:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> we run a batch job every hour that takes all the unzipped archived
> redo
> logs and zips them, so that we keep compressing space. The other
> thing
> I used to do was on a daily basis, move the prior day's logs to
> another
> drive so that I was only storing one day's worth of archived logs at
> the archive log dest drive
> 
> 
> --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> > So yesterday the archive log dest disk filled up on one of our
> > prduction
> > systems causing the Oracle DB to halt as it's supposed to.  Disk
> > space was
> > tight and there was a bit of data loading done.  Anyhow I freed up
> > disk
> > space on relevant drive and proceeded to server console to press
> the
> > OK
> > button to allow archiving to restart.  However, the console was
> > locked by a
> > PC Anywhere session which prevented me from getting to the console
> > window
> > with archive dest full message.  Anyhow ended up having to bounce
> the
> > database.  Apart from throttling the user who set the PC anywhere
> > lock on
> > the console and insisting it not be done again I'm wondering did I
> > have any
> > other options apart from a database bounce to overcome this
> problem?.
> > 
> > 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  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).
> 
> 
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   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: Prakriteswar Santikary
>   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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

RE: login/exit problems

[Karniotis, Stephen]

Look in your "$ORACLE_HOME/otrace/admin" directory to see if you have any
files like process.dat, collect.dat, etc.  If so, delete them.  Also looking
the "$ORACLE_HOME/rdbms/audit" directory to locate any ".aud" files.  The
Oracle*Trace files can cause the slowdown you have described.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Tuesday, January 08, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
Subject:login/exit problems

We have an Oracle 7.3.4 database that has been stable for a number of
years but has started having problems during logon and exit with both
sqlplus and remote logins. It hangs for up to a minute before connecting
to Oracle server after you get

$ sqlplus ***/***

SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.  



and similarly following an exit from Oracle server after disconnecting 

Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options PL/SQL Release 2.3.4.0.0 - Production 



before returning to OS command line prompt

lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
database make no difference. Any advice or help will be much
appreciated.

Tony
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: afa2
  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: Karniotis, Stephen
  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).

additional duties, as required / Re: ORACLE-L Digest -- Volume 2002, Number 008

[Eric D. Pierce]

His job responsibilities probably also include selling 
penis gourds, some of which have with smiley faces. 
that is where the really big money is at these days.



ORACLE-L Digest -- Volume 2002, Number 008
>RE: Becoming a DBA questions
> On 4 Jan 2002 at 14:00, Randy Kirkpatrick wrote:
> 
> > I'm sorry ... but "a little over $100K" + $7K is way over what any
> > reasonable person would pay for a newbie DBA! I stand by my previous
> > message ... this is full of crap unless he's doing more than DBA work!
> 


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

Re: RE: Gas Pains

[sdlockhart]

Jared,
Where is the Off Topic List?

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

Re:Dig it - killer freeware editor

[Gene Sais]

Another cheap and excellent editor.

http://www.multiedit.com/

>>> [EMAIL PROTECTED] 01/08/02 02:10PM >>>
Ross,

Try www.ultraedit.com as well.  It may not be free, but it sure is CHEAP and
extremely robust.  The guy who wrote context should have looked here first.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   1/8/2002 10:40 AM

http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Mohan, Ross
  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: 
  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: Gene Sais
  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).

login/exit problems

[afa2]

We have an Oracle 7.3.4 database that has been stable for a number of
years but has started having problems during logon and exit with both
sqlplus and remote logins. It hangs for up to a minute before connecting
to Oracle server after you get

$ sqlplus ***/***

SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.  



and similarly following an exit from Oracle server after disconnecting 

Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options PL/SQL Release 2.3.4.0.0 - Production 



before returning to OS command line prompt

lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
database make no difference. Any advice or help will be much
appreciated.

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

RE: DBA's are Duhvelopers Too!!! - was Centralized Alert Log

[Post, Ethan]

Regarding alert log monitor...I have been using a highly adapted version of
Connor McDonald's, uses the dd command to clip off new sections of the alert
log.  Here are a few of the features of my script.

   * Will run from a single copy in a single NFS mounted directory.
   * Can process oratab and hit all databases on host, only need a single
cron entry for all database.
   * Command line switches can roll/trim the alert log and keep it at a
constant size.
   * You can operate in paranoid mode which sends you email for all
unrecognized patterns.
   * You can set it to page for db up/down events.
   * It will monitor for physical structure changes and automatically call
control file backup script.
   * You can set options for email delivery and paging. 
   * You can force the immediate trim/roll and email delivery of any log.
   * Easy to modify to segment known non-critical errors from stuff I want
to get paged about.

Regarding RRD tool...I integrated my performance charting software with MRTG
(www.mrtg.org) some time back.  It is a lot easier to use than RRD.
Currently I just use an access database to see my charts and print them to
nice pretty reports.  I perform the same type of aggregation series at RRD
and MRTG so I can easily keep a year's worth of performance metrics in a
small amount of space.  I will be re-integrating with MRTG so the client can
see the charts a bit easier in a bit.

Regarding the general concept of developing new tools...good luck...the idea
is good, why don't we take the best ideas and apply them to one or two good
solutions that will work for everyone. My experience is that the guy with
the idea will end up doing 99.9% of the work and fizzle out at 80% of the
project.  Would be best to start really small and focused and see what
happens.

Jared...Thanks for the DBI message board links, my friend found the solution
to his trouble there.

- Ethan Post
  


-Original Message-
Sent: Tuesday, January 08, 2002 9:46 AM
To: Multiple recipients of list ORACLE-L


...DBA tools written in Python? Hey that was my idea! :-)  

Python is great!!! We have a ton of operational Python scripts to support
application administration and all the data is stored in Oracle. I've
piggy-backed on the development efforts of other Python newbies and the code
is quite readable... in stark contrast to newbie Perl code!

I've developed DBA tools and monitoring stuff in PHP and Perl but now I'm
entertaining a redo and consolidation into Python with RRDTool graphing.
(I'm still anxiously awaiting Jared's book with TONS of Perl!! :-) Regarding
drivers, do you use cxOracle or DCOracle? Database access with Perl is more
mature. I like PHP because it's SO GOOD (and easy) for generating web pages
but I haven't found Python/HTML integration to be as good. Have you used the
Zope stuff? I'm thinking Zope will help for HTML/XML integration but it
seems like overhead and too much of a learning curve. Nevertheless, the
object orientation of Python/Zope should help once you learn it.

Any plans to publish and collaborate development in a forum like
SourceForge? I'm thinking the collaborative development efforts of folks in
the DBA community could produce something better than current commercial
offerings (especially Oracle's OEM) and the resulting tool set would be
extensible, customizable and FREE. Is anyone interested in this? 


DBA's are Duhvelopers too!

Steve Orr,
Bozeman, Montana

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

Re:RE: Oracle Future???

[dgoulet]

Mladen,

Companies that want to lock themselves in to anything MicroSoft do in fact
exist.  I've interviewed with a couple, one of which did in fact whiter & die
due to failure to release their product in time.  That was related to their
customers not being so enchanted with everything MicroSoft.  The other is still
out there, but I doubt it will last long now.  At any rate they do exist and
will continue to do so, even if for only a moment.  Doesn't bother MicroSoft, a
sale once made in a bird in the hand.

Dick Goulet

Reply Separator
Author: "Gogala; Mladen" <[EMAIL PROTECTED]>
Date:   1/8/2002 10:40 AM

Microsoft is trying to win a significant market share in the
database arena for years and could never get anywhere. I see much
more significant threat in MySQL and PosgresSQL because they are
rapidly gaining popularity. As a matter of fact, MySQL has approximately
as much of a market share as SQL Server and that is really disastrous 
for the SQL Server. 
There are two problems with the SQL server, besides the stability of the
underlying platform :

a) Lack of features (poor row level locking, lock escalation, Transact/SQL
 being much, much weaker then PL/SQL, lack of support 
 for Java and objects, poor connectivity to anything
except 
 other Microsoft products, generally poor performance,
making it
 possible for oracle to ridicule it with "challenges")
b) The fact that it runs on one platform only. If a company wants to have a
decently
   sized database, it is highly unlikely that NT 2000 will be the platform
of choice
   for such a server. HP 9000, SUN, RS6000 and AS400 are much more probable
solutions
   and guess what: SQL Server doesn't run on those. Unless there is an idiot
CIO willing
   to lock his company into a single-vendor solution without the slightest
possibility of
   changing platforms without having to sign a very big check, chances for
making a sale
   are virtually null. If there is such a CIO, then the company will wither
and die on it's 
   own and is not a good client.

What are we panicking about? Microsoft is losing the server ground to Linux
and win XP
is allegedly the worst edition ever when it comes to stability and security.
Microsoft
has been found a monopoly and a remedy has yet to be decided. A rumor mill
trying the
usual FUD tactics has failed to work before and will fail again. Oracle will
probably
lower the prices and once again increase the market share. I've been reading
about Microsoft
winning on the database market for a 5 or 6 years by now and, so far,
Microsoft hasn't even
been able to significantly threaten oracle dominance. 



-Original Message-
Sent: Tuesday, January 08, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L




Um... What threat?

Consider the source.

Jared



 

Denham Eva

<[EMAIL PROTECTED]   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
za>  cc:

Sent by: Subject: Oracle Future???

[EMAIL PROTECTED]

om

 

 

01/08/02 06:25

AM

Please respond

to ORACLE-L

 

 





Hi Folks,


Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL mailing list, they were discussing the future of MSSQL.


Some of the comments included comments about our DB - Oracle.
I've added two here...


...With Hyperion been seriously challenged and overrun by Analysis
Services, oracle will completely die out as they integrate their current
offering into Oracle9i. 


...Oracle will become another Apple: 5% market share. ...


Do you guys agree? Is Oracle doing anything about the very serious threat
that MSSQL is placing on their market share?


No, plans of changing personally, but wondering if cross education won't be
beneficial:)


Regards
Denham


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Gogala, Mladen
  INET: [EMA

RE: CASE WHEN or DECODE - any efficiency differences

[Jacques Kilchoer]

Title: RE: CASE WHEN or DECODE - any efficiency differences





> -Original Message-
> From: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]]
> 
> I've just been asked whether there are any efficiency 
> differences between
> CASE WHEN and DECODE.  I'd imagined that they would use the 
> same underlying
> code but perhaps not.  Does anyone know which is more 
> efficient (I realise
> that CASE is SQL-92 compliant and allows use of IN but 
> excluding this is
> there any efficiency difference)


This is not the test I originally ran, but you could try this in your database (uses dba_objects). I just ran this script on one of our development databases with a large number of objects. The version with case took approx. 27 seconds, the version with decode approx. 24 seconds (time displayed by "set timing on").

set timing on
set autotrace traceonly statistics
select
   case
 when substr (object_name, 1, 1) = 'A'
   then 'Object Name starts with A'
 when substr (object_name, 1, 1) = 'B'
  then 'Object Name starts with B'
 when substr (object_name, 1, 1) = 'C'
  then 'Object Name starts with C'
 when substr (object_name, 1, 1) = 'D'
  then 'Object Name starts with D'
 when substr (object_name, 1, 1) = 'E'
  then 'Object Name starts with E'
 when substr (object_name, 1, 1) = 'F'
  then 'Object Name starts with F'
 when substr (object_name, 1, 1) = 'G'
  then 'Object Name starts with G'
 when substr (object_name, 1, 1) = 'H'
  then 'Object Name starts with H'
 when substr (object_name, 1, 1) = 'I'
  then 'Object Name starts with I'
 when substr (object_name, 1, 1) = 'J'
  then 'Object Name starts with J'
 when substr (object_name, 1, 1) = 'K'
  then 'Object Name starts with K'
 when substr (object_name, 1, 1) = 'L'
  then 'Object Name starts with L'
 when substr (object_name, 1, 1) = 'M'
  then 'Object Name starts with M'
 when substr (object_name, 1, 1) = 'N'
  then 'Object Name starts with N'
 when substr (object_name, 1, 1) = 'O'
  then 'Object Name starts with O'
 when substr (object_name, 1, 1) = 'P'
  then 'Object Name starts with P'
 when substr (object_name, 1, 1) = 'Q'
  then 'Object Name starts with Q'
 when substr (object_name, 1, 1) = 'R'
  then 'Object Name starts with R'
 when substr (object_name, 1, 1) = 'S'
  then 'Object Name starts with S'
 when substr (object_name, 1, 1) = 'T'
  then 'Object Name starts with T'
 when substr (object_name, 1, 1) = 'U'
  then 'Object Name starts with U'
 when substr (object_name, 1, 1) = 'V'
  then 'Object Name starts with V'
 when substr (object_name, 1, 1) = 'W'
  then 'Object Name starts with W'
 when substr (object_name, 1, 1) = 'X'
  then 'Object Name starts with X'
 when substr (object_name, 1, 1) = 'Y'
  then 'Object Name starts with Y'
 when substr (object_name, 1, 1) = 'Z'
  then 'Object Name starts with Z'
 else 'Object Name doesn''t start with capital letter'
   end as object_name_first_letter
from dba_objects ;
/
select
   decode (substr (object_name, 1, 1),
   'A', 'Object Name starts with A',
   'B', 'Object Name starts with B',
   'C', 'Object Name starts with C',
   'D', 'Object Name starts with D',
   'E', 'Object Name starts with E',
   'F', 'Object Name starts with F',
   'G', 'Object Name starts with G',
   'H', 'Object Name starts with H',
   'I', 'Object Name starts with I',
   'J', 'Object Name starts with J',
   'K', 'Object Name starts with K',
   'L', 'Object Name starts with L',
   'M', 'Object Name starts with M',
   'N', 'Object Name starts with N',
   'O', 'Object Name starts with O',
   'P', 'Object Name starts with P',
   'Q', 'Object Name starts with Q',
   'R', 'Object Name starts with R',
   'S', 'Object Name starts with S',
   'T', 'Object Name starts with T',
   'U', 'Object Name starts with U',
   'V', 'Object Name starts with V',
   'W', 'Object Name starts with W',
   'X', 'Object Name starts with X',
   'Y', 'Object Name starts with Y',
   'Z', 'Object Name starts with Z',
   'Object Name doesn''t start with capital letter'
  ) as object_name_first_letter
from dba_objects ;
/

RE: Dig it - killer freeware editor

[Post, Ethan]

Looks very cool Ross, thanks for the link. -E

-Original Message-
Sent: Tuesday, January 08, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: Post, Ethan
  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).

Re:Dig it - killer freeware editor

[dgoulet]

Ross,

Try www.ultraedit.com as well.  It may not be free, but it sure is CHEAP and
extremely robust.  The guy who wrote context should have looked here first.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   1/8/2002 10:40 AM

http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: 
  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).

RE: Gas Pains

[Jared . Still]

Hey folks, take it to the Off Topic list please.

Jared




   
 
"Mohan, Ross"  
 

SMI.com> cc:   
 
Sent by: Subject: RE: Gas Pains
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 10:23 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Dear Gogala Ma Laden,

I dunno...we're doing pretty well with B-52s and
single story adobe huts in Tora "sourceforge" Bora.

Ross

p.s. de rigeur oracle question: anyone actually using RRD out there, other
   than Steve Orr who is currently planning?

-Original Message-
Sent: Tuesday, January 08, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L


Are there any skyscrapers in Canada? Log cabins are much harder
to hit with a Boeing 767

-Original Message-
Sent: Tuesday, January 08, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L


Yea, but I don't notice the Canadians getting
their skyscrapers pounded by people enraged at
middle east policies, either.

I guess it's a mixed bag, low gas prices.

"You get what you pay for."

Me, I'd rather pay 4$ a gallon, and use it to
get us the F**K out of the Middle East. Period.

-Original Message-
Sent: Tuesday, January 08, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L


You still pay about three times for gas.  Gas prices in Canada as
they are in parts of Europe but they are bad.  Makes me want to
throttle people in Oregon who complain about the gas prices out
here.  Especially since they have no sales tax.

You never know how good you have it until you don't.

-Original Message-
Sent: Tuesday, January 08, 2002 4:35 AM
To: Multiple recipients of list ORACLE-L


The Canadian gallon is not the same as the U.S. gallon.  The Canadian
gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To:Multiple recipients of list ORACLE-L

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know
how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth
more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the 

RE: CASE WHEN or DECODE - any efficiency differences

[Jacques Kilchoer]

Title: RE: CASE WHEN or DECODE - any efficiency differences





> -Original Message-
> From: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]]
> 
> I've just been asked whether there are any efficiency 
> differences between
> CASE WHEN and DECODE.  I'd imagined that they would use the 
> same underlying
> code but perhaps not.  Does anyone know which is more 
> efficient (I realise
> that CASE is SQL-92 compliant and allows use of IN but 
> excluding this is
> there any efficiency difference)



I think CASE is preferable because the statement is easier to read, and you can have conditions with AND/OR, which you cannot do using DECODE. To answer your question about performance: an informal test I did on several large tables (millions of rows), comparing a statement with DECODE vs. a statement with CASE, I found that the difference was negligible. Of course I'm not a performance expert so my results may be misleading. 

RE: CHAINED ROWS

[Jacques Kilchoer]

Title: RE: CHAINED ROWS





If your chained rows are inside an Index-Organized table, be sure to read the Oracle manual on the "Analyze" command. There are two versions of the "chained-row" table, for index-organized tables you should create the "chained-row" table with universal rowids (head_rowid has datatype urowid). The "chained-row" table with universal rowids is the one named "...1.sql", i.e. has a 1 at the end of the file name.

-Original Message-
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]


If Oracle 8i is ur current version, run the utlchain1.sql script available in ur ORACLE_HOME/rdbms/admin
directory. This will create the chained_rows table for u.
Now analyze the affected table using the command :
 
analyze table  list chained rows into chained_rows;
 
Now when u select from the chained_rows table, u will get the rowid of all the rows that r chained in the table as
head_rowid.
 
The best way to deal with chained rows is to export the table's data, rebuild the table with a higher pctfree and
import the data back.
 
Otherwise, copy the chained rows into a temporary work table in the following way :
 
create table  as 
select * from  where rowid in 
(select head_rowid from chained_rows where table_name = ''
 and owner_name = '');
 
Then delete the chained rows from the main table in the following way :
 
 delete from  
 where rowid in
(select head_rowid from chained_rows where table_name = '' 
 and owner_name = '');
 
Next, re-insert the chained rows into the table :
 
insert into table_name
    select * from ;
 
Commit ur work. Remember to disable any foreign key constraints during the deletion stage and re-enable them 
again after re-insertion of the rows.
This should eliminate most of ur chained rows.


 
-Original Message-
From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]


I have seen that There are some number of  chained rows in several tables of a schema in my database . 
What is it done in such a situation ?

RE: Oracle Future???

[Gogala, Mladen]

Microsoft is trying to win a significant market share in the
database arena for years and could never get anywhere. I see much
more significant threat in MySQL and PosgresSQL because they are
rapidly gaining popularity. As a matter of fact, MySQL has approximately
as much of a market share as SQL Server and that is really disastrous 
for the SQL Server. 
There are two problems with the SQL server, besides the stability of the
underlying platform :

a) Lack of features (poor row level locking, lock escalation, Transact/SQL
 being much, much weaker then PL/SQL, lack of support 
 for Java and objects, poor connectivity to anything
except 
 other Microsoft products, generally poor performance,
making it
 possible for oracle to ridicule it with "challenges")
b) The fact that it runs on one platform only. If a company wants to have a
decently
   sized database, it is highly unlikely that NT 2000 will be the platform
of choice
   for such a server. HP 9000, SUN, RS6000 and AS400 are much more probable
solutions
   and guess what: SQL Server doesn't run on those. Unless there is an idiot
CIO willing
   to lock his company into a single-vendor solution without the slightest
possibility of
   changing platforms without having to sign a very big check, chances for
making a sale
   are virtually null. If there is such a CIO, then the company will wither
and die on it's 
   own and is not a good client.

What are we panicking about? Microsoft is losing the server ground to Linux
and win XP
is allegedly the worst edition ever when it comes to stability and security.
Microsoft
has been found a monopoly and a remedy has yet to be decided. A rumor mill
trying the
usual FUD tactics has failed to work before and will fail again. Oracle will
probably
lower the prices and once again increase the market share. I've been reading
about Microsoft
winning on the database market for a 5 or 6 years by now and, so far,
Microsoft hasn't even
been able to significantly threaten oracle dominance. 



-Original Message-
Sent: Tuesday, January 08, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L




Um... What threat?

Consider the source.

Jared



 

Denham Eva

<[EMAIL PROTECTED]   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
za>  cc:

Sent by: Subject: Oracle Future???

[EMAIL PROTECTED]

om

 

 

01/08/02 06:25

AM

Please respond

to ORACLE-L

 

 





Hi Folks,


Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL mailing list, they were discussing the future of MSSQL.


Some of the comments included comments about our DB - Oracle.
I've added two here...


...With Hyperion been seriously challenged and overrun by Analysis
Services, oracle will completely die out as they integrate their current
offering into Oracle9i. 


...Oracle will become another Apple: 5% market share. ...


Do you guys agree? Is Oracle doing anything about the very serious threat
that MSSQL is placing on their market share?


No, plans of changing personally, but wondering if cross education won't be
beneficial:)


Regards
Denham


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com







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

Re: EMC Not Releasing Space

[George Schlossnagle]

Hi,

This almost certainly has nothing to do with your symmetrix.  The first two
guesses I would make are:

1) oracle still has an open filehandle associated with the now-gone inode.
The space will not be deallocated until thta filehandle is closed.  You can
use a tool like lsof to see if anyone still has on open fh associated with
that object (for example, any session that had used that file before it was
removed)
2) your file system has not updated it's metadata.  Try syncing the file
system a couple times and see if that fixes it (i.e. sync; sync; sync).
Also, some filesystems (notably vxfs) have had bugs were the tools 'lied'
about allocation information.

HTH,

George

--- http://www.pythian.com
--  [EMAIL PROTECTED]
--  877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 1:19 PM


> Hi,
>
> Just curious if anyone has any experience with an EMC
> Symmetrix not releasing the space for a deleted
> datafile. If so, is there a solution or work-around?
>
> Yesterday, we took a tablespace offline, dropped it
> and then deleted the associated datafile. The file was
> 1G in size and today the space has still not been
> released as indicated by 'df -k'. According to another
> DBA here, they have seen this in the past and said
> bouncing the DB remedied the problem.
>
> It sounds like the inodes are still in use by Oracle
> but I can't imagine why. I've worked with Symmetrix
> systems before and have never experienced this
> behavior. We are running 8.1.7.2 (64bit) on Solaris
> 2.8. Any suggestions?
>
> As always, your feedback is appreciated.
>
> -w
>
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Walter K
>   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: George Schlossnagle
  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).

Re: EMC Not Releasing Space

[Jared . Still]

This is a unix thing, not necessarily Oracle.

When you delete a file on unix, it will remain on disk as long
as there is an existing process holding the file open.

You will see the space reclaimed when the database is bounced.

Jared




   
 
Walter K   
 

HOO.COM> cc:   
 
Sent by: Subject: EMC Not Releasing Space  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 10:19 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi,

Just curious if anyone has any experience with an EMC
Symmetrix not releasing the space for a deleted
datafile. If so, is there a solution or work-around?

Yesterday, we took a tablespace offline, dropped it
and then deleted the associated datafile. The file was
1G in size and today the space has still not been
released as indicated by 'df -k'. According to another
DBA here, they have seen this in the past and said
bouncing the DB remedied the problem.

It sounds like the inodes are still in use by Oracle
but I can't imagine why. I've worked with Symmetrix
systems before and have never experienced this
behavior. We are running 8.1.7.2 (64bit) on Solaris
2.8. Any suggestions?

As always, your feedback is appreciated.

-w

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
  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: 
  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).

RE: Question re Installation & Possible Conflicts

[JoJo Al-Zawawi]

Thanks!
--JoJo


-Original Message-

You should have no issues.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  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).

RE: EMC Not Releasing Space

[HAWKINS, JAMES W [IT/1000]]

Walter,

We had the same exact problem on our SAP installation running on EMC
Symmetrix.  The space would not be release until the database was bounced.
We never did find a work-around.

Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, January 08, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L


Hi,

Just curious if anyone has any experience with an EMC
Symmetrix not releasing the space for a deleted
datafile. If so, is there a solution or work-around?

Yesterday, we took a tablespace offline, dropped it
and then deleted the associated datafile. The file was
1G in size and today the space has still not been
released as indicated by 'df -k'. According to another
DBA here, they have seen this in the past and said
bouncing the DB remedied the problem.

It sounds like the inodes are still in use by Oracle
but I can't imagine why. I've worked with Symmetrix
systems before and have never experienced this
behavior. We are running 8.1.7.2 (64bit) on Solaris
2.8. Any suggestions? 

As always, your feedback is appreciated.

-w

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: HAWKINS, JAMES W [IT/1000]
  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).

Dig it - killer freeware editor

[Mohan, Ross]

http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread
the site...!)   


Apologies to the OFF TOPIC list for this ON topic crap!



- Ross "Data bin Loaden" Mohan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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).

Re: DBA's are Duhvelopers Too!!! - was Centralized Alert

[Jan Pruner]

Yes, it is, but for non-commercial use.
1 - 9 Licenses $100.00 
10 - 49 Licenses $80.00 
50 - 99 Licenses $60.00 
100+ Licenses $50.00 

I'm using it on Linux and it's great piece of code.

JP

On Tue 8. January 2002 18:50, you wrote:
> At 08:55 AM 1/8/2002 -0800, you wrote:
> >Steve,
> >
> >"Any plans to publish and collaborate development in a forum like
> >SourceForge?"
> >
> >Isn't that what TOra is all about?
>
> TOra for windows is no longer free.
>
> >http://sourceforge.net/projects/tora
> >
> >Mark
> >
> >-Original Message-
> >Sent: 08 January 2002 15:46
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >...DBA tools written in Python? Hey that was my idea! :-)
> >
> >Python is great!!! We have a ton of operational Python scripts to support
> >application administration and all the data is stored in Oracle. I've
> >piggy-backed on the development efforts of other Python newbies and the
> > code is quite readable... in stark contrast to newbie Perl code!
> >
> >I've developed DBA tools and monitoring stuff in PHP and Perl but now I'm
> >entertaining a redo and consolidation into Python with RRDTool graphing.
> >(I'm still anxiously awaiting Jared's book with TONS of Perl!! :-)
> > Regarding drivers, do you use cxOracle or DCOracle? Database access with
> > Perl is more mature. I like PHP because it's SO GOOD (and easy) for
> > generating web pages but I haven't found Python/HTML integration to be as
> > good. Have you used the Zope stuff? I'm thinking Zope will help for
> > HTML/XML integration but it seems like overhead and too much of a
> > learning curve. Nevertheless, the object orientation of Python/Zope
> > should help once you learn it.
> >
> >Any plans to publish and collaborate development in a forum like
> >SourceForge? I'm thinking the collaborative development efforts of folks
> > in the DBA community could produce something better than current
> > commercial offerings (especially Oracle's OEM) and the resulting tool set
> > would be extensible, customizable and FREE. Is anyone interested in this?
> >
> >
> >DBA's are Duhvelopers too!
> >
> >Steve Orr,
> >Bozeman, Montana
> >
> >
> >
> >-Original Message-
> >Sent: Tuesday, January 08, 2002 7:10 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I'm working on a complete monitoring system written in Python.  I made a
> >list
> >of all the things I want to check for and am working my way through the
> > list
> >
> >as I find time.  I chose Python because I really enjoy programming in the
> >language and find that it does everything I need with few issues.  I chose
> >this project to work on because I needed to improve our system of db
> >monitoring here and found the commercial products lacking and/or just too
> >expensive to justify.  Having a project which allows me to hone my Python
> >programming skills is also nice.  Eventually, I may bring the various
> >scripts
> >together to update a central server where a web interface will show
> >immediately the condition of the various systems.  That combined with
> > email alerts would meet most if not all my needs.
> >
> >Right now, I have several utilities written which email warnings about
> >potential database problems.
> >
> >One utility scans all the alert logs for the database instances on the
> >server.  Every 15 minutes, it checks the file mod time against the current
> >time.  If the file changed within the last 15 minutes, I open the file and
> >readlines checking the timestamp tags in the file.  When it find the tag
> >from
> >the latest entry, it writes that line and the remainder of the alert log
> >file
> >to a mail message which gets sent to me.
> >
> >I had a daemon process running that looked for changes in the file size,
> > but
> >
> >I didn't have a good mechanism for guaranteeing that the daemon was always
> >running other than using a cron job to check and restart it if necessary.
> >In
> >which case I had to have logic to correctly pick up where it last quit.
> >That
> >proved too much trouble, so I decided to set it up to run as a cron job
> > and thought file mod times gave me the best way to check for changes. 
> > Something
> >
> >tells me that the timestamp in the file may not get updated for every
> > alert log update, so I may have to work on another way for parsing the
> > file to find
> >the latest entries.
> >
> >Another utility program scans the dump directories looking for new files.
> >When one is found, email gets sent to me with the file name and the first
> > 25
> >
> >lines of the file.
> >
> >Glenn Stauffer
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Orr, Steve
> >   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: [

RE: Gas Pains

[Mohan, Ross]

Dear Gogala Ma Laden, 

I dunno...we're doing pretty well with B-52s and 
single story adobe huts in Tora "sourceforge" Bora. 

Ross

p.s. de rigeur oracle question: anyone actually using RRD out there, other
than Steve Orr who is currently planning?

-Original Message-
Sent: Tuesday, January 08, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L


Are there any skyscrapers in Canada? Log cabins are much harder 
to hit with a Boeing 767

-Original Message-
Sent: Tuesday, January 08, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L


Yea, but I don't notice the Canadians getting
their skyscrapers pounded by people enraged at
middle east policies, either. 

I guess it's a mixed bag, low gas prices. 

"You get what you pay for."

Me, I'd rather pay 4$ a gallon, and use it to
get us the F**K out of the Middle East. Period. 

-Original Message-
Sent: Tuesday, January 08, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L


You still pay about three times for gas.  Gas prices in Canada as
they are in parts of Europe but they are bad.  Makes me want to
throttle people in Oregon who complain about the gas prices out
here.  Especially since they have no sales tax.

You never know how good you have it until you don't.

-Original Message-
Sent: Tuesday, January 08, 2002 4:35 AM
To: Multiple recipients of list ORACLE-L


The Canadian gallon is not the same as the U.S. gallon.  The Canadian gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re[2]: Becoming a DBA questions

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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: Ken Janusz
  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: Kimberly Smith
  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 EXA

Fwd: Re: oemctrl won't start stop ping or check status on Linux

[tomas]

>Date: Tue, 08 Jan 2002 13:27:42 -0500
>To: "Marin Dimitrov" <[EMAIL PROTECTED]>
>From: tomas <[EMAIL PROTECTED]>
>Subject: Re: oemctrl won't start stop ping or check status on Linux
>
>Nope, My database is 8I standart, this oms was working before. it stop 
>cople of days ago, when Istarted to try the oemapp and I got this SIGSEGV 
>core dumped problem this one I solved it downloading another version of 
>java, now those (emca oemapp) would start every time I need them but the 
>oemctrl won't do anything and oemapp would freeze because very probably 
>this oemctrl is not started yet.
>
>Thanks for your help.
>
>
>
>
>
>At 07:25 PM 1/8/02 +0200, you wrote:
>
>>- Original Message -
>>From: "tomas" <[EMAIL PROTECTED]>
>>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>>Sent: Tuesday, January 08, 2002 17:50
>>Subject: Re: oemctrl won't start stop ping or check status on Linux
>>
>>
>> >
>> > No error messages file in there, it's not producing anything
>> >
>>
>>
>>any chance that it is related to Note:149420.1 from Metalink?
>>
>>==
>>"Due to bug 1784544,  the Oracle9i database hangs if it is configured for
>>Shared
>>Server mode and the Resource Manager option is enabled. This hang bug in
>>turn
>>causes problems in Enterprise Manager such as OMS hangs or failures to
>>start.
>>
>>Possible Symptoms
>>~
>>   1) An Oracle9i database startup/shutdown takes more than 10 minutes.
>>
>>   2) There is a long wait when attempting to connect to an Oracle9i database
>>  (e.g. selecting a database folder in the Console Navigator tree)
>>
>>   3) If you are using an Oracle9i database for your Enterprise Manager
>>  repository:
>>
>>  a) You will not be able to start the Oracle Management Server (OMS).
>>
>>  b) An OMS starts with some of the database sessions but over time no
>>more
>> sessions are available to it and it crashes.
>>
>>   4) Other symptoms:
>>  a) Database clients cannot log in.
>>  b) There will be a slow down or the system will hang abruptly. "
>>==
>>
>>
>>
>> Marin
>>
>>
>>
>>"...what you brought from your past, is of no use in your present. When
>>you must choose a new path, do not bring old experiences with you.
>>Those who strike out afresh, but who attempt to retain a little of the
>>old life, end up torn apart by their own memories. "

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

RE: Gas Pains

[Boivin, Patrice J]

There are, but nobody cares about them.

: )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, January 08, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Gas Pains

Are there any skyscrapers in Canada? Log cabins are much harder 
to hit with a Boeing 767

-Original Message-
Sent: Tuesday, January 08, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L


Yea, but I don't notice the Canadians getting
their skyscrapers pounded by people enraged at
middle east policies, either. 

I guess it's a mixed bag, low gas prices. 

"You get what you pay for."

Me, I'd rather pay 4$ a gallon, and use it to
get us the F**K out of the Middle East. Period. 

-Original Message-
Sent: Tuesday, January 08, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L


You still pay about three times for gas.  Gas prices in Canada as
they are in parts of Europe but they are bad.  Makes me want to
throttle people in Oregon who complain about the gas prices out
here.  Especially since they have no sales tax.

You never know how good you have it until you don't.

-Original Message-
Sent: Tuesday, January 08, 2002 4:35 AM
To: Multiple recipients of list ORACLE-L


The Canadian gallon is not the same as the U.S. gallon.  The Canadian gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re[2]: Becoming a DBA questions

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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: Ken Janusz
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

EMC Not Releasing Space

[Walter K]

Hi,

Just curious if anyone has any experience with an EMC
Symmetrix not releasing the space for a deleted
datafile. If so, is there a solution or work-around?

Yesterday, we took a tablespace offline, dropped it
and then deleted the associated datafile. The file was
1G in size and today the space has still not been
released as indicated by 'df -k'. According to another
DBA here, they have seen this in the past and said
bouncing the DB remedied the problem.

It sounds like the inodes are still in use by Oracle
but I can't imagine why. I've worked with Symmetrix
systems before and have never experienced this
behavior. We are running 8.1.7.2 (64bit) on Solaris
2.8. Any suggestions? 

As always, your feedback is appreciated.

-w

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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).

RE: Gas Pains

[Gogala, Mladen]

Are there any skyscrapers in Canada? Log cabins are much harder 
to hit with a Boeing 767

-Original Message-
Sent: Tuesday, January 08, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L


Yea, but I don't notice the Canadians getting
their skyscrapers pounded by people enraged at
middle east policies, either. 

I guess it's a mixed bag, low gas prices. 

"You get what you pay for."

Me, I'd rather pay 4$ a gallon, and use it to
get us the F**K out of the Middle East. Period. 

-Original Message-
Sent: Tuesday, January 08, 2002 10:36 AM
To: Multiple recipients of list ORACLE-L


You still pay about three times for gas.  Gas prices in Canada as
they are in parts of Europe but they are bad.  Makes me want to
throttle people in Oregon who complain about the gas prices out
here.  Especially since they have no sales tax.

You never know how good you have it until you don't.

-Original Message-
Sent: Tuesday, January 08, 2002 4:35 AM
To: Multiple recipients of list ORACLE-L


The Canadian gallon is not the same as the U.S. gallon.  The Canadian gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re[2]: Becoming a DBA questions

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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: Ken Janusz
  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: Kimberly Smith
  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: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services

RE: Oracle Future??? - from the darkside

[Henry Poras]

Title: Oracle Future???



Where 
I am the management focus (I've got to find a better word) changed so frequently 
from UNIX to NT to anything but MicroSoft that just the slightest bit of inertia 
in migrating meant that nothing ever changed. The major effect was seen on new 
installations/purchases made during the Fad of the Day.
 
Henry

  -Original Message-From: Bowes, Chris 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 11:51 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle Future??? - from the darkside
  Actually, It's possible.  Maybe not down to 5%, 
  but if y'all don't think that Oracle is ripe for a market defeat, then you 
  need to take a hard look at our industry...  Take here for 
  example.  We had Oracle here everywhere.  We have Oracle 
  programmers, DBA's, etc.  Then, we get a new CEO.  Fresh out of 
  Harvard (where they obviously know everything), he went to company "A" 
  and they had sqlserver.  When he left company "A" and came 
  here, guess what we were ordered to convert EVERYTHING to.  
  Well, everything except SAP.  Oracle will be out of here by 2003.  
  Gone, Bye Bye.  C'ya, don't want to be ya.  Oracle personnel that 
  don't cross train or haven't shown the ability to cross train are gone 
  too.  The only thing we had to say about it was "Luke, I am your father, 
  where are the sqlserver discs?"  In one month, 6 years of oracle 
  development was ordered to be out within 2 years.
   
  The 
  sad fact is that the Jared Still's and Steve Adam's are not making the 
  decisions in enough companies.  There are too many managers way up the 
  food chain who have no clue that the marketing hype they is pure 
  BS.  They buy the spin and make the decisions based on that.   
  The fact that sqlserver cannot out perform Oracle is not relevant.  The 
  fact that sqlserver can only run on NT/2000/XP is not relevant.  It 
  will actually be sold as a positive.  "Ya, know, most mcse's are 
  also mcDba's too..."  It may not be true, but facts are not where 
  the decision will be made.  Marketing hype is.  When the "cost 
  savings" is put into the manager's head, the decision will be made.  By 
  the time that the facts of the performance and headaches and costs 
  of conversion are pointed out, people will bury it and forget it 
  existed.  "After all, it is just a computer and I am not going to risk 
  my job arguing over a computer decision. Besides, the IT folks 
  can do anything..."  Remember, spending 2 million to convert to something 
  that will save 100K a year thereafter, is a SAVINGS in the eyes of an upper 
  manager. 
   
  Other companies I have worked for are doing the same 
  thing.  Marketing drives the industry now (look at SAP).  
  Too many idiots.  Not enough voices of reason.   I 
  don't expect Oracle to lose their share to 5%, but if they don't start 
  fighting better, they will have serious competition from sqlserver and other 
  areas.
   
  --Chris
  [EMAIL PROTECTED]
   
   
   
   
   
   
  --Chris 
  [EMAIL PROTECTED] 
   
  -Original 
  Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On 
  Behalf Of Denham EvaSent: 08 January 2002 14:25To: 
  Multiple recipients of list ORACLE-LSubject: Oracle 
  Future???
  Hi Folks, 
  
  Wonder if anyone 
  would like to comment, my MSSQL DBA sent me a couple of emails from a MSSQL 
  mailing list, they were discussing the future of MSSQL.
  Some of the 
  comments included comments about our DB - Oracle. I've added two here... 
  ...With Hyperion 
  been seriously challenged and overrun by Analysis Services, oracle will 
  completely die out as they integrate their current offering into Oracle9i. 
  
  ...Oracle will 
  become another Apple: 5% market share. ... 
  Do you guys 
  agree? Is Oracle doing anything about the very serious threat that MSSQL is 
  placing on their market share? 
  No, plans of 
  changing personally, but wondering if cross education won't be 
  beneficial:) 
  Regards 
  Denham 
  
  
  This e-mail message has been scanned for Viruses and Content and cleared 
  by MailMarshal - For more 
  information please visit www.marshalsoftware.com 
  
  

RE: Oracle Future??? - from the darkside

[Steve McClure]

Title: Oracle Future???



For 
God's sake sell your stock!!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
  Tuesday, January 08, 2002 8:51 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Oracle Future??? - from the 
  darkside
  Actually, It's possible.  Maybe not down to 5%, 
  but if y'all don't think that Oracle is ripe for a market defeat, then you 
  need to take a hard look at our industry...  Take here for 
  example.  We had Oracle here everywhere.  We have Oracle 
  programmers, DBA's, etc.  Then, we get a new CEO.  Fresh out of 
  Harvard (where they obviously know everything), he went to company "A" 
  and they had sqlserver.  When he left company "A" and came 
  here, guess what we were ordered to convert EVERYTHING to.  
  Well, everything except SAP.  Oracle will be out of here by 2003.  
  Gone, Bye Bye.  C'ya, don't want to be ya.  Oracle personnel that 
  don't cross train or haven't shown the ability to cross train are gone 
  too.  The only thing we had to say about it was "Luke, I am your father, 
  where are the sqlserver discs?"  In one month, 6 years of oracle 
  development was ordered to be out within 2 years.
   
  The 
  sad fact is that the Jared Still's and Steve Adam's are not making the 
  decisions in enough companies.  There are too many managers way up the 
  food chain who have no clue that the marketing hype they is pure 
  BS.  They buy the spin and make the decisions based on that.   
  The fact that sqlserver cannot out perform Oracle is not relevant.  The 
  fact that sqlserver can only run on NT/2000/XP is not relevant.  It 
  will actually be sold as a positive.  "Ya, know, most mcse's are 
  also mcDba's too..."  It may not be true, but facts are not where 
  the decision will be made.  Marketing hype is.  When the "cost 
  savings" is put into the manager's head, the decision will be made.  By 
  the time that the facts of the performance and headaches and costs 
  of conversion are pointed out, people will bury it and forget it 
  existed.  "After all, it is just a computer and I am not going to risk 
  my job arguing over a computer decision. Besides, the IT folks 
  can do anything..."  Remember, spending 2 million to convert to something 
  that will save 100K a year thereafter, is a SAVINGS in the eyes of an upper 
  manager. 
   
  Other companies I have worked for are doing the same 
  thing.  Marketing drives the industry now (look at SAP).  
  Too many idiots.  Not enough voices of reason.   I 
  don't expect Oracle to lose their share to 5%, but if they don't start 
  fighting better, they will have serious competition from sqlserver and other 
  areas.
   
  --Chris
  [EMAIL PROTECTED]
   
   
   
   
   
   
  --Chris 
  [EMAIL PROTECTED] 
   
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denham 
  EvaSent: 08 January 2002 14:25To: Multiple recipients of 
  list ORACLE-LSubject: Oracle Future???
  Hi Folks, 
  
  Wonder if anyone 
  would like to comment, my MSSQL DBA sent me a couple of emails from a MSSQL 
  mailing list, they were discussing the future of MSSQL.
  Some of the 
  comments included comments about our DB - Oracle. I've added two here... 
  ...With Hyperion 
  been seriously challenged and overrun by Analysis Services, oracle will 
  completely die out as they integrate their current offering into Oracle9i. 
  
  ...Oracle will 
  become another Apple: 5% market share. ... 
  Do you guys 
  agree? Is Oracle doing anything about the very serious threat that MSSQL is 
  placing on their market share? 
  No, plans of 
  changing personally, but wondering if cross education won't be 
  beneficial:) 
  Regards 
  Denham 
  
  
  This e-mail message has been scanned for Viruses and Content and cleared 
  by MailMarshal - For more 
  information please visit www.marshalsoftware.com 
  
  

RE: Convert ACESS to Oracle

[Gogala, Mladen]

Downloading oracle migration workbench from the OTN
and using it to migrate your access databases might 
be even better idea.

-Original Message-
Sent: Tuesday, January 08, 2002 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi,
 I would think the general idea could be converting all the tables into flat
files and then loading them into your Oracle pre-built database ( you have
to create  schemas, of course) using SQLLDR. If you have any integrity
constraints, I think you will have to manually create them in Oracle. Try  a
search on GOOGLE.com. Very helpful.
Regards,
Sergey Babich

 -Original Message-
Sent:   Tuesday, January 08, 2002 11:31 AM
To: Multiple recipients of list ORACLE-L
Subject:Convert ACESS to Oracle

Group,
Can anyone please give me links, steps, document or step by step procedures
to convert an Access database to an Oracle database? Also, please include
any 'Gottcha's'.

Thanks

Al Rusnak

DeCA: 804-734-8453 
   [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  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: Babich , Sergey
  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: Gogala, Mladen
  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).

RE: inode density for Oracle filesystems

[John Kanagaraj]

Bill,

This is Ok as long as you create *only* Datafiles/redologs (i.e. static
number of file objects) in that filesystem. I have done this without
problems, albeit on AIX boxes.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Fear is the darkroom where Evil develops your negatives. 
Wanna break free of fear? Click on 'http://www.needhim.org'

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Bill Buchan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 08, 2002 7:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: inode density for Oracle filesystems
> 
> 
> 
> 
> Is there any real benefit in using sparse inodes on a 
> filesystem for Oracle 
> datafiles?
> 
> We originally had a system with few inodes because there 
> would only be a 
> few, large Oracle datafiles.  However this has also rendered 
> the free space 
> left useless as a handy place to put a load of very static file 
> archives.I'm tempted to rebuild the filesystem with more inodes.
> 
> Any reason why not?  (This is UFS on Solaris)
> 
> Thanks for any info
> - Bill
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bill Buchan
>   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: John Kanagaraj
  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).

RE: Reversing Unused Setting on a Column

[James McCann]

Here you go, in Mike's own words...


First, this is UNSUPPORTED only use it in emergencies!

Getting Back a Column Marked as UNUSED

Oops…marked the wrong column as UNUSED and now you find that you can’t go
back…or can you? During the testing of this feature I found a method to get
back a column marked as UNUSED. Once you DROP a column that has been marked
as UNUSED it is gone for good, but up to the point where it is actually
dropped, it can be reclaimed. This is how the technique works, I suggest
practicing before doing the reclaim on a production table.

The col$ has obj#, col#, name and property fields which tie into the columns
for each table where obj# will correspond to the obj# in the tab$ table.
When a column is marked unused the col# is set to zero, the name is set to a
system generated name and the property is set to 32800 from its initial
value of 0 (for a normal, non-type column). In the tab$ table the number of
columns is decremented by one in the cols column. The obj$ table stores the
link between the object name and owner and the obj#, you then use that obj#
to pull relevant data from the tab$ and col$ tables.

In order to reverse the unused state, reset the col# value to its original
value, reset the name column to the proper name and reset the property to 0.
In the tab$ table reset the cols column to the appropriate value.

You will have to flush the shared pool or even restart to flush the object
caches and dictionary caches to see the column again.

To test this process perform the following steps:
1. Create a small table with two to three columns
2. Look at the entries for obj$, tab$ and col$ for this table noting the
values for COLS in tab$ and COL#, INTCOL#, PROPERTY and NAME in col$ (from
SYS or INTERNAL user).
3. Add data to the table and commit.
4. Select from the table to confirm the data and columns.
5. Use ALTER TABLE SET UNUSED to mark a column unused.
6. Select from the table to confirm the column unavailable.
7. Log in as SYS or INTERNAL and check tab$ and col$ as before.
8. Update tab$ and col$ to before the ALTER conditions and commit.
9. Flush the shared pool to get rid of the post condition select statement
parse.

Issue a select against the table to confirm the column came back.

(Note: sometimes you may need to shutdown and restart before the column will
come back)

That should do it...of course if you actually drop the column you can't get
it back. And remember,

dropping any column in a table will result in loss of all columns marked
UNUSED whether mentioned in the DROP or not.


-Original Message-
Sent: 08 January 2002 16:45
To: Multiple recipients of list ORACLE-L


Kirti:

Thanks, but I don't have access to Metalink.

Ken

 -Original Message-
Sent:   Tuesday, January 08, 2002 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Reversing Unused Setting on a Column

Yes, it is possible. But not supported by Oracle.
There is post by Mike Ault on Metalink Forum describing how to do this. Pl
search Metalink for it. BTW, his post is followed by Oracle's post reminding
the readers that it is a non supported operation (on data dictionary tables
owned by SYS).

- Kirti

-Original Message-
Sent: Tuesday, January 08, 2002 9:36 AM
To: Multiple recipients of list ORACLE-L


I have heard that you can revere the UNUSED setting on a column.  Anyone
know how to do this?

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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: Deshpande, Kirti
  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: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, Californ

RE: DBA's are Duhvelopers Too!!! - was Centralized Alert

[Bill Conner]

At 08:55 AM 1/8/2002 -0800, you wrote:
>Steve,
>
>"Any plans to publish and collaborate development in a forum like
>SourceForge?"
>
>Isn't that what TOra is all about?

TOra for windows is no longer free.


>http://sourceforge.net/projects/tora
>
>Mark
>
>-Original Message-
>Sent: 08 January 2002 15:46
>To: Multiple recipients of list ORACLE-L
>
>
>...DBA tools written in Python? Hey that was my idea! :-)
>
>Python is great!!! We have a ton of operational Python scripts to support
>application administration and all the data is stored in Oracle. I've
>piggy-backed on the development efforts of other Python newbies and the code
>is quite readable... in stark contrast to newbie Perl code!
>
>I've developed DBA tools and monitoring stuff in PHP and Perl but now I'm
>entertaining a redo and consolidation into Python with RRDTool graphing.
>(I'm still anxiously awaiting Jared's book with TONS of Perl!! :-) Regarding
>drivers, do you use cxOracle or DCOracle? Database access with Perl is more
>mature. I like PHP because it's SO GOOD (and easy) for generating web pages
>but I haven't found Python/HTML integration to be as good. Have you used the
>Zope stuff? I'm thinking Zope will help for HTML/XML integration but it
>seems like overhead and too much of a learning curve. Nevertheless, the
>object orientation of Python/Zope should help once you learn it.
>
>Any plans to publish and collaborate development in a forum like
>SourceForge? I'm thinking the collaborative development efforts of folks in
>the DBA community could produce something better than current commercial
>offerings (especially Oracle's OEM) and the resulting tool set would be
>extensible, customizable and FREE. Is anyone interested in this?
>
>
>DBA's are Duhvelopers too!
>
>Steve Orr,
>Bozeman, Montana
>
>
>
>-Original Message-
>Sent: Tuesday, January 08, 2002 7:10 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I'm working on a complete monitoring system written in Python.  I made a
>list
>of all the things I want to check for and am working my way through the list
>
>as I find time.  I chose Python because I really enjoy programming in the
>language and find that it does everything I need with few issues.  I chose
>this project to work on because I needed to improve our system of db
>monitoring here and found the commercial products lacking and/or just too
>expensive to justify.  Having a project which allows me to hone my Python
>programming skills is also nice.  Eventually, I may bring the various
>scripts
>together to update a central server where a web interface will show
>immediately the condition of the various systems.  That combined with email
>alerts would meet most if not all my needs.
>
>Right now, I have several utilities written which email warnings about
>potential database problems.
>
>One utility scans all the alert logs for the database instances on the
>server.  Every 15 minutes, it checks the file mod time against the current
>time.  If the file changed within the last 15 minutes, I open the file and
>readlines checking the timestamp tags in the file.  When it find the tag
>from
>the latest entry, it writes that line and the remainder of the alert log
>file
>to a mail message which gets sent to me.
>
>I had a daemon process running that looked for changes in the file size, but
>
>I didn't have a good mechanism for guaranteeing that the daemon was always
>running other than using a cron job to check and restart it if necessary.
>In
>which case I had to have logic to correctly pick up where it last quit.
>That
>proved too much trouble, so I decided to set it up to run as a cron job and
>thought file mod times gave me the best way to check for changes.  Something
>
>tells me that the timestamp in the file may not get updated for every alert
>log update, so I may have to work on another way for parsing the file to
>find
>the latest entries.
>
>Another utility program scans the dump directories looking for new files.
>When one is found, email gets sent to me with the file name and the first 25
>
>lines of the file.
>
>Glenn Stauffer
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Orr, Steve
>   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: Mark Leith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Inte

Re:RE: Oracle Future???

[dgoulet]

Ron,

I see the DUMB people too, especially those who make choices based solely on
$ to acquire.  IMHO Oracle's biggest challenge in the near future is controlling
their desires for big $.  If they don't they'll price themselves (and us) right
out of the market.

Dick Goulet

Reply Separator
Author: "Ron Rogers" <[EMAIL PROTECTED]>
Date:   1/8/2002 7:45 AM

I'm jeolous, I don't hear the voices... But I do see DUMB people..

"one by one the Penguins steal my sanity" 

ROR mô¿ôm

>>> [EMAIL PROTECTED] 01/08/02 09:50AM >>>
Uh Oh ... I thought I was the only person to whom the little voices talk to
... Damn ... there is one more ...

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: Tuesday, January 08, 2002 9:25 AM
To: Multiple recipients of list ORACLE-L


Hi Folks, 
Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL mailing list, they were discussing the future of MSSQL.
Some of the comments included comments about our DB - Oracle. 
I've added two here... 
...With Hyperion been seriously challenged and overrun by Analysis Services,
oracle will completely die out as they integrate their current offering into
Oracle9i. 
...Oracle will become another Apple: 5% market share. ... 
Do you guys agree? Is Oracle doing anything about the very serious threat
that MSSQL is placing on their market share? 
No, plans of changing personally, but wondering if cross education won't be
beneficial:) 
Regards 
Denham 

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

Reorgs in a Replicated environment

[Aschenbrenner, Alan]

Hi,

I'm trying to determine what might be the best way to do table reorgs in a 
replicated 24/7 environment running 8.1.6.  Currently I'm thinking of setting up a 
third database in the replication group (1 master definition site, which is 
inaccessible by the customers, and 2 master sites, available to customers in a load 
balancing scenario).  With this additional site I could restrict access to it, take it 
offline (dbms_offline_og.begin_load), reload the data, followed by an online 
(dbms_offline_of.end_load).  Then unrestrict the access and repeat the procedure on 
the other master site.  Finally allow access to either of the customer master sites.  
Any suggestions, comments, etc. are welcome.  Is there an easier way that I'm 
overlooking?  Do I need more coffee?  Has anyone been down this path?

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

RE: Oracle Future???

[Boivin, Patrice J]

This may help you regain your bearings:
http://www.theregister.co.uk/content/4/23518.html

No, don't thank me, I'm glad I could help.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Tuesday, January 08, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Future???

I'm jeolous, I don't hear the voices... But I do see DUMB people..

"one by one the Penguins steal my sanity" 

ROR mô¿ôm

>>> [EMAIL PROTECTED] 01/08/02 09:50AM >>>
Uh Oh ... I thought I was the only person to whom the little voices talk to
... Damn ... there is one more ...

Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  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).

Re: oemctrl won't start stop ping or check status on Linux

[Marin Dimitrov]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 17:50


>
> No error messages file in there, it's not producing anything
>


any chance that it is related to Note:149420.1 from Metalink?

==
"Due to bug 1784544,  the Oracle9i database hangs if it is configured for
Shared
Server mode and the Resource Manager option is enabled. This hang bug in
turn
causes problems in Enterprise Manager such as OMS hangs or failures to
start.

Possible Symptoms
~
  1) An Oracle9i database startup/shutdown takes more than 10 minutes.

  2) There is a long wait when attempting to connect to an Oracle9i database
 (e.g. selecting a database folder in the Console Navigator tree)

  3) If you are using an Oracle9i database for your Enterprise Manager
 repository:

 a) You will not be able to start the Oracle Management Server (OMS).

 b) An OMS starts with some of the database sessions but over time no
more
sessions are available to it and it crashes.

  4) Other symptoms:
 a) Database clients cannot log in.
 b) There will be a slow down or the system will hang abruptly. "
==



Marin



"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "



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

RE: DBA's are Duhvelopers Too!!! - was Centralized Alert Log

[Orr, Steve]

Check out: http://www.python.org/; 
http://www.faqts.com/knowledge_base/index.phtml/fid/199/;
http://aspn.activestate.com/ASPN/Cookbook/Python.

Cheerz


-Original Message-
Sent: Tuesday, January 08, 2002 9:31 AM
To: Multiple recipients of list ORACLE-L


Never worked with Python, but it might be a fun thing to work on during my
down-time starting next month.

Henry

-Original Message-
Sent: Tuesday, January 08, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L


...DBA tools written in Python? Hey that was my idea! :-)  

Python is great!!! We have a ton of operational Python scripts to support
application administration and all the data is stored in Oracle. I've
piggy-backed on the development efforts of other Python newbies and the code
is quite readable... in stark contrast to newbie Perl code!

I've developed DBA tools and monitoring stuff in PHP and Perl but now I'm
entertaining a redo and consolidation into Python with RRDTool graphing.
(I'm still anxiously awaiting Jared's book with TONS of Perl!! :-) Regarding
drivers, do you use cxOracle or DCOracle? Database access with Perl is more
mature. I like PHP because it's SO GOOD (and easy) for generating web pages
but I haven't found Python/HTML integration to be as good. Have you used the
Zope stuff? I'm thinking Zope will help for HTML/XML integration but it
seems like overhead and too much of a learning curve. Nevertheless, the
object orientation of Python/Zope should help once you learn it.

Any plans to publish and collaborate development in a forum like
SourceForge? I'm thinking the collaborative development efforts of folks in
the DBA community could produce something better than current commercial
offerings (especially Oracle's OEM) and the resulting tool set would be
extensible, customizable and FREE. Is anyone interested in this? 


DBA's are Duhvelopers too!

Steve Orr,
Bozeman, Montana



-Original Message-
Sent: Tuesday, January 08, 2002 7:10 AM
To: Multiple recipients of list ORACLE-L


I'm working on a complete monitoring system written in Python.  I made a
list 
of all the things I want to check for and am working my way through the list

as I find time.  I chose Python because I really enjoy programming in the 
language and find that it does everything I need with few issues.  I chose 
this project to work on because I needed to improve our system of db 
monitoring here and found the commercial products lacking and/or just too 
expensive to justify.  Having a project which allows me to hone my Python 
programming skills is also nice.  Eventually, I may bring the various
scripts 
together to update a central server where a web interface will show 
immediately the condition of the various systems.  That combined with email 
alerts would meet most if not all my needs.

Right now, I have several utilities written which email warnings about 
potential database problems.

One utility scans all the alert logs for the database instances on the 
server.  Every 15 minutes, it checks the file mod time against the current 
time.  If the file changed within the last 15 minutes, I open the file and 
readlines checking the timestamp tags in the file.  When it find the tag
from 
the latest entry, it writes that line and the remainder of the alert log
file 
to a mail message which gets sent to me.

I had a daemon process running that looked for changes in the file size, but

I didn't have a good mechanism for guaranteeing that the daemon was always 
running other than using a cron job to check and restart it if necessary.
In 
which case I had to have logic to correctly pick up where it last quit.
That 
proved too much trouble, so I decided to set it up to run as a cron job and 
thought file mod times gave me the best way to check for changes.  Something

tells me that the timestamp in the file may not get updated for every alert 
log update, so I may have to work on another way for parsing the file to
find 
the latest entries.

Another utility program scans the dump directories looking for new files.  
When one is found, email gets sent to me with the file name and the first 25

lines of the file.

Glenn Stauffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 5

Re: Archive log dest full

[Jared . Still]

Sean,

A number of respondents have said that all you need to do is backup
archive logs, delete them and get on with business.

Sorry folks, that might work on unix, but not in M$ Windoze, at least with
the versions of Oracle 8+ that I've dealt with on Win32.

Once the archive log destination has filled up,  Oracle Win32  does
not know how to continue, even if you free up the space.

To fix the problem online, you must redirect the archive log destination:

  alter system set log_archive_dest_1 = 'location=c:
\oracle\oradata\ts10\archive2'

Oracle will then start working again.  There may be other variations on
this, but
I've had to use this once or twice.

You will then need to restart Oracle at a convenient time to reset the
archlog
destination.  No need to reboot.

Jared





   
 
"O'Neill,  
 
Sean"To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
   Subject: Archive log dest full
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 03:50 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




So yesterday the archive log dest disk filled up on one of our prduction
systems causing the Oracle DB to halt as it's supposed to.  Disk space was
tight and there was a bit of data loading done.  Anyhow I freed up disk
space on relevant drive and proceeded to server console to press the OK
button to allow archiving to restart.  However, the console was locked by a
PC Anywhere session which prevented me from getting to the console window
with archive dest full message.  Anyhow ended up having to bounce the
database.  Apart from throttling the user who set the PC anywhere lock on
the console and insisting it not be done again I'm wondering did I have any
other options apart from a database bounce to overcome this problem?.

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

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

Re: Oracle Future???

[Jared . Still]

Um... What threat?

Consider the source.

Jared



   
 
Denham Eva 
 
<[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
za>  cc:   
 
Sent by: Subject: Oracle Future??? 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
01/08/02 06:25 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi Folks,


Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
emails from a MSSQL mailing list, they were discussing the future of MSSQL.


Some of the comments included comments about our DB - Oracle.
I've added two here...


...With Hyperion been seriously challenged and overrun by Analysis
Services, oracle will completely die out as they integrate their current
offering into Oracle9i. 


...Oracle will become another Apple: 5% market share. ...


Do you guys agree? Is Oracle doing anything about the very serious threat
that MSSQL is placing on their market share?


No, plans of changing personally, but wondering if cross education won't be
beneficial:)


Regards
Denham


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit www.marshalsoftware.com







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

parallel SQL*Loader load

[Gene Gurevich]

Hi.

We are using Ab Initio to load bunch of tables. 
The load is done via SQL*Loader in direct mode in
parallel. We have 8 streams. According to Oracle
documentation in this situation Oracle would create
temporary extents for every process to dump the data
and will merge these extents into one at the end.
In my case however the latter part doesn't seem to be
happenning. After every load the number of extents in
the table increase by 8 and the size of these extents
is 32K while the NEXT parameter is 512K. Does anyone
know anything about this and how do I force oracle to
indeed merge the temp extents?


thanks

=


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  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).