Re: Data dictionary for function

[Ravinder_Bahadur]

Sorry the below should have read
dba/all _source table



   
 
Ravinder_Bahadur@singapore 
 
air.com.sgTo: Multiple recipients of 
list ORACLE-L  
Sent by: [EMAIL PROTECTED] <[EMAIL PROTECTED]>   
 
  cc:  
 
  Subject: Re: Data dictionary 
for function 
29-Jun-2001 01:50 PM   
 
Please respond to ORACLE-L 
 
   
 
Sender Info:   
 
No Sender Info found in
 
the address Book   
 
   
 
   
 





dba_all_source
Regards




"Sinardy Xing"

<[EMAIL PROTECTED]>

Sent by:  cc:

[EMAIL PROTECTED]  Subject: Data dictionary
for function


29-Jun-2001 12:20

PM

Please respond to

ORACLE-L


Sender Info:

No Sender Info

found in the

address Book








Hi all,

Do you know what data dictionary store information about all user function,
store procedure ?






Best Regards

Sinardy


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



__


Visit us at www.singaporeair.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).



__

Visit us at www.singaporeair.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).

RE: Data dictionary for function

[Sinardy Xing]

Hi all,

Thank you for your answers

dba_source
user_source
all_source

Sinardy


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, 29 June 2001 1:50 PM
To: Multiple recipients of list ORACLE-L



dba_all_source
Regards




"Sinardy Xing"
<[EMAIL PROTECTED]>
Sent by:  cc:
[EMAIL PROTECTED]  Subject: Data dictionary
for function


29-Jun-2001 12:20
PM
Please respond to
ORACLE-L

Sender Info:
No Sender Info
found in the
address Book







Hi all,

Do you know what data dictionary store information about all user function,
store procedure ?






Best Regards

Sinardy


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




__

Visit us at www.singaporeair.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: Sinardy Xing
  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).

starting up 8i on Win2000 Problems

[Denham Eva]

Hello,

I am new to the Windows Platform.
I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system.
My problem is this, when I shutdown the system, using svrmgrl and the
command shutdown immediate.
The system shuts down as one would expect with no errors. However when I try
restarting the instance, also
in svrmgrl as I have done thousands of time in UNIX, she refuses. Giving
either:
cannot open the database EXCLUSIVE  OR
the initPWD.ora is incorrect or corrupt.
I have been forced to bounce this system, were she will startup
automatically without a whisper of complaint.

Has anyone else experienced this? 
Does anyone have any idea what has gone wrong?
Does anyone have a soulution?

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

(No Subject)

[C.S.Venkata Subramanian]

HI Gurus,
I want to insert single quotes with my data from my application. 
Some data will contain quotes and some may not.

How can this be achieved?

Kindly help

TIA
Regards
C.S.Venkat



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
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: Data dictionary for function

[Ravinder_Bahadur]

dba_all_source
Regards



   
 
"Sinardy Xing" 
 
<[EMAIL PROTECTED]>   
 
Sent by:  cc:  
 
[EMAIL PROTECTED]  Subject: Data dictionary for 
function 
   
 
   
 
29-Jun-2001 12:20  
 
PM 
 
Please respond to  
 
ORACLE-L   
 
   
 
Sender Info:   
 
No Sender Info 
 
found in the   
 
address Book   
 
   
 
   
 





Hi all,

Do you know what data dictionary store information about all user function,
store procedure ?






Best Regards

Sinardy


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



__

Visit us at www.singaporeair.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).

Re: test

[novicedba]

what are you trying to test??
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 9:16 AM


> 
> test
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   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: novicedba
  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: Data dictionary for function

[C.S.Venkata Subramanian]

 user_source,dba_source
--

On Thu, 28 Jun 2001 20:20:23  
 Sinardy Xing wrote:
>
>Hi all,
>
>Do you know what data dictionary store information about all user function,
>store procedure ?
>
>
>
>
>
>
>Best Regards
>
>Sinardy
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Sinardy Xing
>  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).
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
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).

Delete me

[Sinardy Xing]

Hi,

I am changing e-mail address

sorry for the inconvenience 



Best Regards 

Sinardy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  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: Data dictionary for function

[jaimin]

Hi,

DBA_SOURCE is the table which stores information about all procedures and
fuctions.


SQL> desc dba_source
 NameNull?Type
 ---  
 OWNER   NOT NULL VARCHAR2(30)
 NAMENOT NULL VARCHAR2(30)
 TYPE VARCHAR2(12)
 LINENOT NULL NUMBER
 TEXT VARCHAR2(4000)


Jaimin.


-Original Message-
Xing
Sent: Friday, June 29, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L



Hi all,

Do you know what data dictionary store information about all user function,
store procedure ?






Best Regards

Sinardy


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
  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: jaimin
  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: Common Oracle RDBMS Misconceptions

[novicedba]

sorry greg
I could make neither head nor tail of the links
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:49 PM


> Hi
>
> Slightly off-topic ... if you're interested in a dictionary of clear
> definitions of mystical concepts, may I recommend ...
> http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/tail-recursion.html
>
> There's also a well-written boil-down of the last 50 years of IT
development
> into one and a half paragraphs on
>
http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/Infinite-Monkey-Theorem
> .html
>
> Cheers
> Greg
>
> -Original Message-
> Sent: Thursday, 28 June 2001 14:21
> To: Multiple recipients of list ORACLE-L
>

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

Testing

[Sinardy Xing]

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

Test

[Sinardy Xing]

[EMAIL PROTECTED]



Best Regards

Sinardy



***

CONFIDENTIALITY CAUTION
This message and its attachments (“Message”) are intended only for the use
of the individual or entity to whom it is addressed, is confidential and may
also be privileged.  If you are not the intended recipient, please do not
distribute, use or copy any part of it.  Instead, please inform us
immediately by return e-mail and delete this Message from your system or
destroy it if you received it otherwise than by e-mail.

Any opinions or representations contained in this Message shall not bind
Banking Computer Services Private Limited (“BCS”) unless the author is
authorized by BCS to communicate such opinion or representation and the
authority of the author to so bind BCS is duly verified.


**

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

Data dictionary for function

[Sinardy Xing]

Hi all,

Do you know what data dictionary store information about all user function,
store procedure ?






Best Regards

Sinardy


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

Discovering correct service names on a SUN Solaris, Oracle 8.1.6

[Reardon, Bruce (CALBBAY)]

Paul,

What is present snmp_ro.ora and snmp_rw.ora files on the Sun boxes (most
likely in the same location as your tnsnames.ora on the Sun boxes).

Do these files refer to "prod", "prod.world" or "prod.srvf01"?
If they refer to the incorrect domain - try a clean start of the agent on
the Sun box.

That is (and your directory paths may vary - I wrote these notes for NT):

stop the agent

from \oracle\admin\tns_admin (or where ever they are)
delete the snmp_rw.ora
delete the snmp_ro.ora

from \oracle\product\815\network\agent
delete services.ora

start up the agent (and recheck the contents of the snmp_ro.ora and
snmp_rw.ora)

also look at 
\oracle\product\815\network\log\nmi.log

Also, using SQLPlus  on your OEM box, which of the following connect strings
work: 
"prod", "prod.world" or "prod.srvf01"

What version of Oracle is running on the Sun boxes?

Also check out Metalink Note:71910.1 Subject:  Common console discovery
errors 

Hope this helps.

Regards,
Bruce Reardon

-Original Message-
Sent: Thursday, 28 June 2001 10:10 

Hi,

I've got Oracle Management Server (2.2) running on an NT Platform, with an
Oracle 8.1.6 Repository Database held on the same server. I want to use this
to remotely administer several databases on a variety of platforms on the
network. All the databases on NT servers have been discovered neatly by OEM,
with their (global) service names all present and correct. Flushed with
success, I moved on to the Sun/Solaris databases.

Now the fun starts! We have two Sun/Solaris servers with newly-upgraded
3rd-party systems installed on them (the same software in each case). Each
has a single instance called (unimaginatively enough) PROD. I looked at the
initialisation parameter files for these DBs and discovered they each had
"db_name = PROD", but no mention of "db_domain". Consequently, they were
both running with a service name of simply "PROD". So I added the lines
"db_domain = SRVF01" and "db_domain = SRVF02" to the two initialisation
files, respectively (SRVF01 and SRVF02 being the server names), and bounced
the instances on the 2 machines. Checking their generated parameters I
discovered to my satisfaction that they had "service_names = PROD.SRVF01"
and "service_names = PROD.SRVF02" respectively. So far so good! So, having
checked that the Intelligent Agents were running (and, indeed, having
bounced listeners and agents just to make sure they picked up the current
settings), I loaded up Oracle Enterprise Manager and told it to discover
node SRVF01. Which it did, successfully - however the database appeared in
the list as simply "PROD". So presumably if I had then tried to discover
node SRVF02, an error would have occurred, since that database would be
called PROD, too!

Now, when the databases were created on the NT servers, they were created
using the various wizards provided, so any relevant alterations of
LISTENER.ORA and TNSNAMES.ORA (for instance) will have been handled
automatically and invisibly. However, the databases on the Sun boxes were
created using scripts, so the 3rd-party installer people will have manually
made the necessary entries in these files. Our on-site knowledge of the
intricacies of these files is, er, limited, to say the least. So, could any
of you give me a few pointers as to which files I need to modify (and in
what way!) in order that my OEM console will discover these instances under
their correct service names?

Thanks!

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

Re: Re:

[novicedba]

thanks rachel
waiting for it
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:28 PM


> You didn't read the paper, just the slide presentation.
>
> If a slide presentation is done properly, then no, you can't get
everything
> from it. Otherwise why bother to a) stand in front of the room and present
> it, the attendees can just read the slides  and b) write the paper backing
> it up. My opinion only, but a presentation that is too filled with
> words/lines on the screen is not understandable when being presented..
it's
> distracting from the speaker.
>
> In fact, this presentation was deliberately written without explanations,
as
> our goal was to make people wonder if the statement was a myth or not. We
> then started our discussion of each bullet point, and got the audience to
> participate, giving their own interpretations. Marlene and I designed that
> presentation as an all day workshop, and it was meant first and foremost
to
> be educational AND entertaining.
>
> The paper will be on the NYOUG website in a few days.
>
> Rachel
>
>
> >From: "novicedba" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Date: Thu, 28 Jun 2001 03:36:54 -0800
> >
> >Hi Rachel,
> >read your paper 'exploding the myths' , but felt that explanation was
> >necessary atleast for some of them if not all. All along I felt the first
> >few slides were introduction and you will discuss each of the points in
> >detail, and was totally fooled when in the last slide you said " really
the
> >end. Honest. No, really. Really truly, no fingers crossed! "   as I was
> >waiting to see the explanations for all the statements.
> >Will be waiting for your response
> >please help
> >coz
> >I am a
> >novice
> >Oracle Certifiable DBBS
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  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: novicedba
  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 DBA with SQL Server and Manufacturing Industry exp.-

[Deshpande, Kirti]

> SQL Server or Alpha Server experience 

Who does Alpha Server?? 

- Kirti 

> -Original Message-
> From: OraStaff [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 4:34 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle DBA with SQL Server and Manufacturing Industry exp.-
> 
> This Richmond Virginia manufacturing company needs a solid Oracle DBA to
> join its' I.T. team.
> 
> This is a full time staff position so no sub-contractors or third parties
> please.
> 
> Please do not call or send a resume if you are not in the U.S. and/or need
> 
> sponsorship.
> 
> *Requirements:
> - Manufacturing experience- a must
> - 4+ yrs Oracle DBA experience
> - SQL Server or Alpha Server experience
> 
> Salary..Up to 95K D.O.E. + excellent benefits
> Relocation assistance is provided if needed.
> 
> PLEASE do not send your resume if you are not in the United States.
> 
> For  immediate consideration, please send your resume as an attachment to:
> Bill Law, 
> Oracle Placement Specialist
> OraStaff, Inc.
> Email: [EMAIL PROTECTED]
> 1-800-549-8502
> Please Use Job Code: One/DBA/Richmond/Sol
> 
-- 
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).

test

[Sinardy Xing]

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

No Subject

[Sinardy Xing]

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

test

[Sinardy Xing]

change add


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

FW: Testing

[Sinardy Xing]

-Original Message-
Sent: Friday, 29 June 2001 10:11 AM
To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list'


Testing 



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

Testing

[Sinardy Xing]

Testing 



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

Snapshot package.

[jaimin]

Hello gurus,
I am testing dbms_snapshot package on my test server. I run
"dbmssnapshot.sql" script which is in "rdbms" directory. The script gives no
error.
I have snapshot  called 'TEST_SNAP'.


When I execute procedure it gives me following error.

SQL> exec dbms_snapshot.refresh ('test_snap','?');
begin dbms_snapshot.refresh ('ja','?'); end;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_SNAPSHOT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Can any one help me on this?


Regards,
Jaimin.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: jaimin
  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 RE: 24 x 7 on NT?

[Kimberly Smith]

Actually, I think that was the Navy.  I remember discussions on this.
It happened more then once.


-Original Message-
Sent: Thursday, June 28, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L


Hahah, the software, the ship had to be towed back to port:)  However, not
sure if it was the coast guard or the navy, but I am going with the coast
guard.
KK

-Original Message-
Walt
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

Procedural Replication

[David Turner]

I have heard numbers of about 100-800 transactions per minute as the limit for Oracle
replication, but does anyone know if this would include procedural replication. If so
does anyone out there know of some better solutions for replicationg a really high 
number 
of transactions across a WAN.

Thanks, Dave Turner
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  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 Question on the Basics of PL/SQL

[MacGregor, Ian A.]

Functions are used when when a "value" must be returned.  The quotes are around value 
because the return type is not necessarily scalar.  Under most circumstances a  
function only returns one value.  I believe in sticking to that rule, although Oracle 
does not always:

Here's a line from the package header for dbms_standard:

function dictionary_obj_name_list (object_list out ora_name_list_t)
return binary_integer; 

The function returns both a binary integer and a table of varchar2(64)'s.


Functions are called in pl/sql using the following format  := 
function_name();
The parameters are nearly always "in" types.  Functions which return a datatype which 
can be handled by sqlplus and meet
the restrict_references criteria  can be invoked from sqlplus thus

select () from .  



Procedures are used when you want more than one value to be returned or no values at 
all.

Packages are collections of procedures, functions, variable definitons, type 
definitions etc.  It is a good idea to place your functions and procedures in a 
package.

A cursor is how Oracle, a set based database communicates with record oriented 
programming languages.  They are not really related to functions, procedures, or 
packages. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


   


-Original Message-
Sent: Thursday, June 28, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L


I am a bit confused as to when to use the following.  I 
cannot seem to find any definitive rules.

- function
- cursor
- procedure
- package

If someone can point me to a white paper, or whatever, 
that defines the rules for their usage I would be most 
thankful.

Thanks,
Ken Janusz, CPIM
-- 
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: MacGregor, Ian 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).

Re: disk corruption?

[KC]

Jerry,

We had this problem recently on Solaris 2.6 and Oracle 8.0.5, Oracle
initially said upgrade to the 8.0.5.2 patch will fix the problem, we ended
up upgraded to the 8.0.6.2 to get rid of the problem. Anita is right about
the datafile is still intact, it just a read error, you can run dbv to
verify it.

KC


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Friday, June 29, 2001 8:30 AM


>Jerry,
>
>If you're on 8.0.x and file 9 is > 2GB then it's a
>known bug (774252) when a read crosses the 2GB
>boundary.
>
>The datafile is not corrupt, Oracle is merely unable
>to read it properly.
>
>It wasn't fixed in any of the patchsets, but there are
>PSE's (patchset exceptions) for most 8.0.x versions.
>Log a tar with support to get the right one for your
>specific RDBMS version.
>
>HTH,
>
>-- Anita
>
>--- Jerry C <[EMAIL PROTECTED]> wrote:
>> Hi all,
>>
>> I'm getting a disk error:
>>
>> ORA-01115: IO error reading block from file 9 (block
>> # 262144)
>> ORA-01110: data file 9:
>> '/orafiles/data01/xlepmprd/ewlarge.dbf'
>> ORA-27072: skgfdisp: I/O error
>> SVR4 Error: 25: Inappropriate ioctl for device
>> Additional information: 262143
>>
>> My sysadmin tells me that the disk is ok, since
>> there are no errors in
>> /var/adm/messages (I didn't see any, either). Is
>> there a way to verify that
>> the disk is free of errors?? Any other log files to
>> look at? The platform is
>> Sun:
>>
>> SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc
>> SUNW,Ultra-4
>>
>>
>> Thanks!
>>
>> Jerry
>>
>>
>>
>>
>>
>>
>_
>> Do You Yahoo!?
>> Get your free @yahoo.com address at
>> http://mail.yahoo.com
>>
>> --
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.com
>> --
>> Author: Jerry C
>>   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!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: A. Bardeen
>  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: KC
  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: Virus again

[lyudah]

If I get e-mail from the customer with virus I'll inform him/her about the
virus.  99.9% of customers would eliminate the source of the virus.  If they
refuse to do so I would probably not want to deal with them even as
customers. It would not make any impact on the business if I lost 0.1% of my
customers and that action would actualy work for me because all good people
out there would  know I don't challenge my values.  It is like going to an
unsanitized doctor's office, catching something there and doctor's claiming:
'you didn't get it from my office you got it from one of my patients'.  That
is what doesn't make scence I can even handle annoying recruter's
e-mails but not e-mails with viruses.  Noone asks you to block ALL e-mails
but when the source of inconvinience has been identified why not to take
care of it?

Anyway, I am giving up.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:56 PM


> > There is definately an association between this list and the person
>
> The point remains that such a broad solution makes no sense.  If you get
an
> email from a customer and it has a virus, you could say "there is
definitely
> an association between our customers and email with viruses."  But are you
> going to stop all email from customers?
>
> How about just stopping all email?  That would solve the problem.
>
> Perhaps the boys in network admin need to work on a more focused solution
> instead of cutting off a broad source of email.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
>   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: lyudah
  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: Is Oracle 9i RAC out

[Oliver Artelt]

Yes, is an option in the oui

oli

[EMAIL PROTECTED] wrote:
> I know that the Oracle 9i database is out for linux.  Does anyone know if
> Oracle 9i Real Application Cluster is out yet for linux?
> 
> -- 
> 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).
> 
> 

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  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: Virus again

[Bowes, Chris]

Title: RE: Virus again





It's not a list privacy violation.  At least it might not be.  The problem is that you can get pretty much any email address (not all, but most) just by reading the sig lines.  Others can be found by hitting reply and microsoft mail will put that in the reply footer.  Also, harvesting from a list is pretty easy, just look for @ in the body of the message and grab the line.  A quick scan will show which are email addresses and which are not.  Delete the junk lines and you have a directory.  I am not sure, but I believe the list was locked down so the subscriber list is not available.  However, for those that publish, there are no good protections that I know of.  

--Chris
[EMAIL PROTECTED]



-Original Message-
From: lyudah [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Virus again



Yes, no e-mail from the list contains virus.  The case is even worse:  he is
not attacking the list;  he attacks us(users of the list) personally one by
one.  There is definately an association between this list and the person
speading the virus because virus comes as a reply to the list posts.   I'd
like to ask a question:  are our e-mail addresses widely available to anyone
and there is nothing we can do about it?  I had an impression it wasn't the
case.  I would call it privacy violation(very strong statement, probably too
strong) or using technical list to do his durty business(more applicable to
the situation).  From now on I will think twice before signing up for
another list, posting messages, or replying to them.  Yes, you're right I
would not block my customers or friends e-mails because people who have any
respect for themselves would clean their machine up after becoming aware of
the virus. The problem here is that person has been notified by number of
people and he keeps doing it.  So, regardless on us individually blocking
his e-mails we need to get to the root of this problem and BLOCK that
person's access to the list.  It becomes clear he is doing it deliberatly.
Or you would say: 'Let him do it?'  That would not be a good sign
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 2:21 PM



> > The boys in network admin initially said they would "strip" the
virus-now
> > they have said that they are going to block email from the list.
>
> The boys  in network admin may be barking up the wrong tree.  As I
> understand it, no email from the list contains a virus.
>
> Even if the virus did come from the list, what kind of solution is this?
If
> someone from your accounting department sends you an email that has a
virus
> are they going to block all email from accounting?  If a customer sends an
> email with a virus are they going to block all email from customers?
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
>   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: lyudah
  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: Griping about auditing (not the Oracle Kind)

[Gregory Conron]

On June 28, 2001 11:51 am, Miller, Jay wrote:
> Yep, I've dealt with incredibly incompetent consultants (Because of
> our new division of responsibilties, all programming must come from
> the development team.  I

This brings up an interesting point - I've noticed that recently 
division of responsibilities is increasing and becoming more 
polarized. For example, in past incarnations, I was the dba, unix 
sysadmin, configuration manager, and responsible for software 
licenses for all software in the plant (in addition to whatever else 
the boss needed at that exact moment in time... :). Lately, however, 
I have started working on another project (in addition to my usual 
stuff) that has the sysadmin, development, "System" dba, and 
"Application" dba responsibilities spread across different group. 
Sysdba is handled by an Infernal Beuracratic Monster, sysadmin by 
somewhat Ejectable Data Sources, and Application dba stuff handled by 
we keaners. Very strange to have development arrive, review it for 
application impact, then send off any physical database change 
requests to another group.

I don't seem any valid reason to stratify the various 
responsibilities in this manner as it only seems to add several more 
layers of beauracracy without adding any addition value.

So,
a) am I alone, or have others seen this sort of stratification, and 
b) is my griping simply the loss of turf and the slowly broiling coup 
to get it back, or is it somewhat valid?

Cheers,
GC
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gregory Conron
  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[2]: Pocket Guide

[Jonathan Gennick]

Thursday, June 28, 2001, 4:15:56 PM, you wrote:
jb> help works for sqlplus, if you installed, but if there is a script for
jb> building sql command structure, please pass that on.  At least 'help
jb> index' is only showing the sqlplus commands.

When 8i was released, the SQL statements were removed from the help.

Best regards,

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


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

Re: Virus again

[Greg Moore]

> There is definately an association between this list and the person

The point remains that such a broad solution makes no sense.  If you get an
email from a customer and it has a virus, you could say "there is definitely
an association between our customers and email with viruses."  But are you
going to stop all email from customers?

How about just stopping all email?  That would solve the problem.

Perhaps the boys in network admin need to work on a more focused solution
instead of cutting off a broad source of email.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  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 RE: 24 x 7 on NT?

[Gregory Conron]

Give the man an onion! Or five bees for a quarter

On June 28, 2001 11:31 am, Kevin Kostyszyn wrote:
> You got me on this one, but my guess would be Grandpa Simpson said
> that one:)
> KK
>
> -Original Message-
> Conron
> Sent: Wednesday, June 27, 2001 9:18 PM
> To: Multiple recipients of list ORACLE-L
>
> On June 27, 2001 03:05 pm, Mustafa wrote:
> > True Fact:  Unix was first invented in 1913 by my great great
> > uncle (twice removed) Ralph Unix.  Ralph worked with him as THE
> > first DBA.
> >
> > I bet most of you didn't know that the Unix server Ralph is
> > talking about is powered by steam engine! ;-)
>
> 
>
>  of course, he had an onion tied to his belt, because that was
> the style of the time
>
> 
>
>
>
> Cheers,
> GC
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gregory Conron
>   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: Gregory Conron
  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: disk corruption?

[A. Bardeen]

Jerry,

If you're on 8.0.x and file 9 is > 2GB then it's a
known bug (774252) when a read crosses the 2GB
boundary.

The datafile is not corrupt, Oracle is merely unable
to read it properly.

It wasn't fixed in any of the patchsets, but there are
PSE's (patchset exceptions) for most 8.0.x versions. 
Log a tar with support to get the right one for your
specific RDBMS version.

HTH,

-- Anita

--- Jerry C <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> I'm getting a disk error:
> 
> ORA-01115: IO error reading block from file 9 (block
> # 262144)
> ORA-01110: data file 9:
> '/orafiles/data01/xlepmprd/ewlarge.dbf'
> ORA-27072: skgfdisp: I/O error
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 262143
> 
> My sysadmin tells me that the disk is ok, since
> there are no errors in
> /var/adm/messages (I didn't see any, either). Is
> there a way to verify that
> the disk is free of errors?? Any other log files to
> look at? The platform is
> Sun:
> 
> SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc
> SUNW,Ultra-4
> 
> 
> Thanks!
> 
> Jerry
> 
> 
> 
> 
> 
>
_
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jerry C
>   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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  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 24 x 7 on NT - ot

[lyudah]

Title: RE: OT 24 x 7 on NT - ot



Alex, I would even buy your book to support 
your efforts.  :-)
 

  - Original Message - 
  From: 
  Hillman, Alex 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 28, 2001 3:15 
  PM
  Subject: RE: OT 24 x 7 on NT - ot
  
  At 
  least your memory is good :-)
   
  Alex 
  Hillman
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 5:41 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
OT 24 x 7 on NT - ot
Lisa, my fine-feathered friend, i would have no idea what to write 
about. Clearly
not oracle. And since i'd probably self-publish, I'd likely have to 
go mano a  mano
with Alex Hillman on the printing presses. It wouldn't be pretty, and 
besides, I still
owe him a lunch. 
 
So...that leaves not much in the hopper. I am open to suggestions 
that do not
involve me wearing speedos, passing by mirrors, or being available 
while the
sun is up. 
 

 
Ah 
well, back to tweaking the nanokernel assembler extensions for the russian 
mafia. 
 
- 
Ross

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
  4:38 PMTo: '[EMAIL PROTECTED]'; 
  '[EMAIL PROTECTED]'Subject: RE: OT 24 x 7 on NT - 
  ot
  Ross, have you ever considered 
  becoming an author? I 
  would buy your book :) 
  Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA 
  
-Original Message- 
From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, June 28, 2001 3:50 PM To: Multiple recipients of list ORACLE-L 
Subject:    
OT  24 x 7 on NT? 
Everything. The whole Coast Guard. Everything 
just turned blue and froze. 
Then, someone using oracle with "read 
consistency" was able to order a replacement ship simultaneously with the guy who was removing the 
last ship from inventory, but 
fortunately for the USCG, Oracle doesn't let "writers block readers", so the order went through but was never 
fulfilled. 
Now, they're running DB2 on VMS on realtime 
nanokernel OS kiosks. 
-Original Message- Sent: Thursday, June 28, 2001 3:20 PM To: Multiple recipients of list ORACLE-L 

The software or the ship? 
--Walt Weaver   Bozeman, Montana, USA 
-Original Message- Sent: Thursday, June 28, 2001 12:56 PM 
To: Multiple recipients of list 
ORACLE-L 
On one of their newer ships they were using 
NT, and it froze up a couple of times. 
-Original Message- Sent: Thursday, June 28, 2001 1:36 PM To: Multiple recipients of list ORACLE-L 

The Coast guard uses Unisys, too...but i 
don't know where NT fits in to their 
front line systems. 
-- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, 
Walt   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: Virus again

[lyudah]

Yes, no e-mail from the list contains virus.  The case is even worse:  he is
not attacking the list;  he attacks us(users of the list) personally one by
one.  There is definately an association between this list and the person
speading the virus because virus comes as a reply to the list posts.   I'd
like to ask a question:  are our e-mail addresses widely available to anyone
and there is nothing we can do about it?  I had an impression it wasn't the
case.  I would call it privacy violation(very strong statement, probably too
strong) or using technical list to do his durty business(more applicable to
the situation).  From now on I will think twice before signing up for
another list, posting messages, or replying to them.  Yes, you're right I
would not block my customers or friends e-mails because people who have any
respect for themselves would clean their machine up after becoming aware of
the virus. The problem here is that person has been notified by number of
people and he keeps doing it.  So, regardless on us individually blocking
his e-mails we need to get to the root of this problem and BLOCK that
person's access to the list.  It becomes clear he is doing it deliberatly.
Or you would say: 'Let him do it?'  That would not be a good sign
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 2:21 PM


> > The boys in network admin initially said they would "strip" the
virus-now
> > they have said that they are going to block email from the list.
>
> The boys  in network admin may be barking up the wrong tree.  As I
> understand it, no email from the list contains a virus.
>
> Even if the virus did come from the list, what kind of solution is this?
If
> someone from your accounting department sends you an email that has a
virus
> are they going to block all email from accounting?  If a customer sends an
> email with a virus are they going to block all email from customers?
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
>   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: lyudah
  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: Scripts to monitor databases

[Jared . Still]

how about www.orafaq.org, which appears at the bottom of every email
from this list?  :)

oramag.oracle.com

Also on MetaLink, go to the technical library, scroll down til you find
database
admin, click on basic admin, and you will find a number of scripts.

Jared



   
 
Vikas Kawatra  
 
  
entry.com> cc: 
 
Sent by:   Subject: RE: Scripts to monitor 
databases
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
06/28/01 02:55 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 






I'm trying to compile a set of scripts for daily health check of all our
databases .I would like to set these up as jobs in OEM or as cron jobs to
run every morning.
I am sure many of you have scripts that WORK - such as for tablespace
storage /fragmentation , user audit , poor SQL , database performance stats
etc - Can you guys recommend good scripts /URL's etc

thanks

vikas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Kawatra
  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 24 x 7 on NT - ot

[Hillman, Alex]

Title: RE: OT 24 x 7 on NT - ot



At 
least your memory is good :-)
 
Alex 
Hillman

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 5:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT 24 x 7 on NT - ot
  Lisa, my fine-feathered friend, i would have no idea what to write 
  about. Clearly
  not 
  oracle. And since i'd probably self-publish, I'd likely have to go mano 
  a  mano
  with 
  Alex Hillman on the printing presses. It wouldn't be pretty, and besides, I 
  still
  owe 
  him a lunch. 
   
  So...that leaves not much in the hopper. I am open to suggestions that 
  do not
  involve me wearing speedos, passing by mirrors, or being available 
  while the
  sun 
  is up. 
   
  
   
  Ah 
  well, back to tweaking the nanokernel assembler extensions for the russian 
  mafia. 
   
  - 
  Ross
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
4:38 PMTo: '[EMAIL PROTECTED]'; 
'[EMAIL PROTECTED]'Subject: RE: OT 24 x 7 on NT - 
ot
Ross, have you ever considered 
becoming an author? I would 
buy your book :) 
Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA 

  -Original Message- From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, June 28, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Subject:    OT  24 x 7 on NT? 
  Everything. The whole Coast Guard. Everything 
  just turned blue and froze. 
  Then, someone using oracle with "read 
  consistency" was able to order a replacement ship simultaneously with the guy who was removing the 
  last ship from inventory, but 
  fortunately for the USCG, Oracle doesn't let "writers block readers", so the order went through but was never 
  fulfilled. 
  Now, they're running DB2 on VMS on realtime 
  nanokernel OS kiosks. 
  -Original Message- Sent: Thursday, June 28, 2001 3:20 PM To: Multiple recipients of list ORACLE-L 
  The software or the ship? 
  --Walt Weaver   Bozeman, Montana, USA 
  -Original Message- Sent: Thursday, June 28, 2001 12:56 PM To: Multiple recipients of list ORACLE-L 
  On one of their newer ships they were using NT, 
  and it froze up a couple of times. 
  -Original Message- Sent: Thursday, June 28, 2001 1:36 PM To: Multiple recipients of list ORACLE-L 
  The Coast guard uses Unisys, too...but i 
  don't know where NT fits in to their 
  front line systems. 
  -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, 
  Walt   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: Interest in an Oracle on Tru64 specific list?

[Mohan, Ross]

Guess this is a bustno response here, either

-Original Message-
Sent: Wednesday, June 20, 2001 2:43 PM
To: Multiple recipients of list ORACLE-L



http://www.ornl.gov/its/archives/mailing-lists/tru64-unix-managers/2001/06/m
sg00265.html
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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: OT RE: 24 x 7 on NT?

[Kevin Kostyszyn]

ahhahahahaha

-Original Message-
William
Sent: Thursday, June 28, 2001 6:04 PM
To: Multiple recipients of list ORACLE-L


"Mohan, Ross" wrote:
> 
> yea, they could call it the gpF-22 then.:)

give the phrase "blue screen of death" a whole new meaning.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
"Search out every place a sick, twisted, solitary  misfit might run to.
I'll start with radio shack." - Lisa Simpson
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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 Kostyszyn
  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: OT RE: 24 x 7 on NT?

[Kevin Kostyszyn]

It's funny what this thread has turned into!!!

-Original Message-
Sent: Thursday, June 28, 2001 6:04 PM
To: Multiple recipients of list ORACLE-L


that's my job, soldier: Humor Mach One. Now, at ease, and smoke 'em if you
got 'em.

-Original Message-
Sent: Thursday, June 28, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L


Ohhh...that was good, wish I would have thought of that:)

-Original Message-
Sent: Thursday, June 28, 2001 5:34 PM
To: Multiple recipients of list ORACLE-L


yea, they could call it the gpF-22 then.:)

-Original Message-
Sent: Thursday, June 28, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


OH MAN, the F-22 with NT, oh jeez...Hey I love NT, but the amount of times I
have had to reboot a machine, I couldn't imagine that in an F-22.

-Original Message-
Sent: Thursday, June 28, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.

||   Don't you mean they had a good
"AN-UYK" over it?

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla,
dos, unix, or nt. VMS maybe
--
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: Kevin Kostyszyn
  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).

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

OT RE: 24 x 7 on NT?

[Jacques Kilchoer]

Title: OT RE: 24 x 7 on NT?





> -Original Message-
> From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> 
> Hahah, the software, the ship had to be towed back to port:)  
> However, not
> sure if it was the coast guard or the navy, but I am going 
> with the coast
> guard.



Navy ship USS Yorktown.


http://www.gcn.com/archives/gcn/1998/july13/cov2.htm


This article (in  Scientific American) says that the problem may have been caused by 3rd party software, not NT.


http://www.sciam.com/1998/1198issue/1198techbus2.html

RE: A Question on the Basics of PL/SQL

[Sherman, Edward]

Get the PL/SQL Programming book by Oracle Press.
Thats where I got the definitions below from.

It also comes with a CD containing scripts which will populate
database tables so you can try the examples in the book.

Go nuts!

-Original Message-
Sent: Thursday, June 28, 2001 5:17 PM
To: Multiple recipients of list ORACLE-L


I am a bit confused as to when to use the following.  I 
cannot seem to find any definitive rules.

- function
"Functions are named PL/SQL blocks that return a value and
can be called with arguments. They can be used as part of an
expression. They are legal in procedural statements, and certain
functions can be used in SQL statements in PL/SQL 2.1 and higher.
Functions can be stored in the database with the CREATE [OR REPLACE]
FUNCTION command, or they can be located in the declarative section
of another block."


- cursor
"Cursors are used to control the processing for queries that return
more than one row. A cursor is declared using the CURSOR..IS syntax,
then processed with OPEN, FETCH, and CLOSE. Cursor attributes are used to
determine the current status of a cursor, with information about how many
rows the cursor has returned, whether the cursor is open, and whether the
last fetch was successful."


- procedure
"Procedures can be stored in the database with the CREATE OR REPLACE
PROCEDURE statement, or they can be declared in the declarative secion of a
block. A procedure is a named block that can be called with parameters. The
parameters can either accept a value from the calling environment (IN),
return a value to the calling environment (OUT), or both (IN OUT)."


- package
"Packages are defined as two separate data dictionary objects--the package
header (or specification) and the package body. The header is created with
the CREATE OR REPLACE PACKAGE command, the body with the CREATE OR REPLACE
PACKAGE BODY command. Packages must be stored in the database; they cannot
be placed in the declarative section like procedures or functions. Packages
themselves can contain procedures, functions, variables, types, cursors, and
exceptions. Items declared in the package header will be visible outside the
package, while items defined in only the package body will be private to the
package. Packages also break the dependency chain because the package body
can be recompiled without affecting the package specification."

If someone can point me to a white paper, or whatever, 
that defines the rules for their usage I would be most 
thankful.

Thanks,
Ken Janusz, CPIM
-- 
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).


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  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: OT RE: 24 x 7 on NT?

[Mohan, Ross]

that's my job, soldier: Humor Mach One. Now, at ease, and smoke 'em if you
got 'em. 

-Original Message-
Sent: Thursday, June 28, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L


Ohhh...that was good, wish I would have thought of that:)

-Original Message-
Sent: Thursday, June 28, 2001 5:34 PM
To: Multiple recipients of list ORACLE-L


yea, they could call it the gpF-22 then.:)

-Original Message-
Sent: Thursday, June 28, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


OH MAN, the F-22 with NT, oh jeez...Hey I love NT, but the amount of times I
have had to reboot a machine, I couldn't imagine that in an F-22.

-Original Message-
Sent: Thursday, June 28, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.

||   Don't you mean they had a good
"AN-UYK" over it?

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla,
dos, unix, or nt. VMS maybe
--
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: Kevin Kostyszyn
  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).

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

Re: OT RE: 24 x 7 on NT?

[Thater, William]

"Mohan, Ross" wrote:
> 
> yea, they could call it the gpF-22 then.:)

give the phrase "blue screen of death" a whole new meaning.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
"Search out every place a sick, twisted, solitary  misfit might run to.
I'll start with radio shack." - Lisa Simpson
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Scripts to monitor databases

[Vikas Kawatra]

I'm trying to compile a set of scripts for daily health check of all our
databases .I would like to set these up as jobs in OEM or as cron jobs to
run every morning. 
I am sure many of you have scripts that WORK - such as for tablespace
storage /fragmentation , user audit , poor SQL , database performance stats
etc - Can you guys recommend good scripts /URL's etc 

thanks

vikas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vikas Kawatra
  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: executable trigger

[Stephane Faroult]

"Allen R. Lucas" wrote:
> 
> We have Oracle 8.0.5 in NT4.0.
> 
> A developer asked if an Oracle trigger can be used to kick off an
> executable.  Looking in my books, I would have to assume 'no' as I find
> noreference to this, but can anyone verify I am wrong, and where could I
> get addiional information  if I am wrong?
> 

If you want to directly code :
   begin
 execute_code('myprog');
   end;
not directly. What you can do is to have the program in the starting
blocks, waiting, and issue a DBMS_ALERT call in your trigger which will
be interpreted as a gun firing by your program.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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 24 x 7 on NT - ot

[Mohan, Ross]

Title: RE: OT 24 x 7 on NT - ot



Lisa, 
my fine-feathered friend, i would have no idea what to write about. 
Clearly
not 
oracle. And since i'd probably self-publish, I'd likely have to go mano a  
mano
with 
Alex Hillman on the printing presses. It wouldn't be pretty, and besides, I 
still
owe 
him a lunch. 
 
So...that leaves not much in the hopper. I am open to suggestions that do 
not
involve me wearing speedos, passing by mirrors, or being available while 
the
sun is 
up. 
 

 
Ah 
well, back to tweaking the nanokernel assembler extensions for the russian 
mafia. 
 
- 
Ross

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
  4:38 PMTo: '[EMAIL PROTECTED]'; 
  '[EMAIL PROTECTED]'Subject: RE: OT 24 x 7 on NT - 
  ot
  Ross, have you ever considered 
  becoming an author? I would 
  buy your book :) 
  Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA 
  
-Original Message- From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, June 28, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Subject:    OT  24 x 7 on NT? 
Everything. The whole Coast Guard. Everything 
just turned blue and froze. 
Then, someone using oracle with "read 
consistency" was able to order a replacement ship simultaneously with the guy who was removing the 
last ship from inventory, but fortunately 
for the USCG, Oracle doesn't let "writers 
block readers", so the order went through but was never fulfilled. 

Now, they're running DB2 on VMS on realtime 
nanokernel OS kiosks. 
-Original Message- Sent: Thursday, June 28, 2001 3:20 PM To: Multiple recipients of list ORACLE-L 
The software or the ship? 
--Walt Weaver   Bozeman, Montana, USA 
-Original Message- Sent: Thursday, June 28, 2001 12:56 PM To: Multiple recipients of list ORACLE-L 
On one of their newer ships they were using NT, 
and it froze up a couple of times. 

-Original Message- Sent: Thursday, June 28, 2001 1:36 PM To: Multiple recipients of list ORACLE-L 
The Coast guard uses Unisys, too...but i 
don't know where NT fits in to their 
front line systems. 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, 
Walt   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: Invalid packages not being recompiled by Oracle

[Troiano, Paul (CAP, GEFA)]

Thanks Lisa and others,
 
The dbms_utility.compile_schema will work. It is a bit annoying though as
this involves six schemas and hundreds of packages to be recompiled.
Fortunatly I do keep control and there are no circular dependencies in the
packages. I am sending out an order of dependency among the schemas to the
appropriate people. The recursive error seems to have been fixed when I
patched to 8.0.5.2.1. Has anyone seen it in 8.1.7?
 
It seems to be only for one package that this happens. It is larger than the
rest at 6000 lines and 250 KB 
 
Modifying the application to execute again isn't really feasible in this
case. There are dozens of packages that refer to this packages. Each one
would have to be modified and fully regression tested.
 
As far as standard behavior, Oracle is supposed to (and does in all other
cases except for this package) automatically recompile any package flagged
as invalid at execution time. It should only raise an error when the package
in question can not be recompiled. In this case, the user can 'alter package
package_name compile' and all is fixed, provided the 'user' is privileged to
do so. Obviously, in production there aren't many who can do this.
 
Any thoughts as to how or what could cause this normal behavior to fail?
 
- Paul
 
 

-Original Message-
Sent: Thursday, June 28, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L



HI Paul, 

By chance can you use dbms_utility.compile_Schema after recompiling? Are you
using it already?  I know it doesn't answer your quesiton but this package
is suppossed to follow the dependencies, no matter how odd they are (what
you are describing below is pretty weird). 

HTH 
Lisa Koivu 
Database Bored Administrator 
Ft. Lauderdale, FL, USA 

-Original Message- 
Sent:   Thursday, June 28, 2001 2:56 PM 
To: Multiple recipients of list ORACLE-L 


We have one package A that refers to package B. If package B's body
and 
specification are both recompiled by user 1, package A is correctly marked 
as invalid. Another user, user 2, then attempts to execute package A and 
gets the following error stack: 

-- ORA-04068: existing state of packages has been discarded 
-- ORA-04061: existing state of package "B" has been invalidated 
-- ORA-04065: not executed, altered or dropped package "B" 
-- ORA-06508: PL/SQL: could not find program unit being called 
-- ORA-06512: at "B", line n ORA-06512: at line 2 

User 2 then issues the statement 'alter package A compile;' It
compiles 
successfully and user 2 can now execute the package. 

Why does Oracle not automatically recompile package A as it should?
Since 
user 2 was able to recompile the package in its existing state, Oracle 
should not have failed at doing so. User 2's session instantiation of 
package A (as well as all of their other instantiated packages) should have 
been lost when package A was invalidated. 

I understand that two possible options are: (1) Flush the shared
pool after 
recompiling; and (2) Manually recompile all dependent packages (such as A). 
The first seems like overkill and will cause performance issues. The second,

with many dependencies involved, is not an option. 

We need to consistently be able to recompile a package that other
packages 
are dependent upon without a user recieving the above error stack in 
addition to not impacting performance or without having to recompile all the

dependent packages. 

Thanks in advance, 

- Paul 


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

NT4 - ORA 8.0.5 - NT4

[Allen R. Lucas]

We have Oracle 8.0.5 in NT4.0.

A developer asked if an Oracle trigger can be used to kick off an
executable.  Looking in my books, I would have to assume 'no' as I find
noreference to this, but can anyone verify I am wrong, and where could I
get addiional information  if I am wrong?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Allen R. Lucas
  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 24 x 7 on NT - ot

[Koivu, Lisa]

Title: RE: OT  24 x 7 on NT - ot





Ross, have you ever considered becoming an author? 
I would buy your book :)


Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA


-Original Message-
From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, June 28, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L
Subject:    OT  24 x 7 on NT?


Everything. The whole Coast Guard. Everything just turned blue and froze. 


Then, someone using oracle with "read consistency" was able to order a 
replacement ship simultaneously with the guy who was removing the last 
ship from inventory, but fortunately for the USCG, Oracle doesn't let
"writers block readers", so the order went through but was never fulfilled.


Now, they're running DB2 on VMS on realtime nanokernel OS kiosks.



-Original Message-
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L



The software or the ship?


--Walt Weaver
  Bozeman, Montana, USA


-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L



On one of their newer ships they were using NT, and it froze up a couple of
times.


-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L



The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: OT::Take a look.

[Mohan, Ross]

Yea, the latest stuff with Anita Hill and David Brock is pretty amazing. 

They are talking about opening up a review of Clarence Thomas' appointment
to the bench. 

-Original Message-
Sent: Thursday, June 28, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Well, send him back to Washington, his job ain't done yet!!

Reply Separator
Author: "JOE TESTA" <[EMAIL PROTECTED]>
Date:   6/28/2001 3:50 PM

The old independent council(goofball starr) is coming to BFE Ohio for some
reason, saw it on the news the other day.

joe


>>> [EMAIL PROTECTED] 06/28/01 04:26PM >>>

Dick Goulet

PS: For those of you who feel I'm Republican bashing, I'm not.  I'd have
VERY
happily voted for McCain, even if that meant having Bush as a VP.  Now
where's
that independent counsel when you need him!!!






The old independent council(goofball starr) is

coming to BFE Ohio for some reason, saw it on the news the other day.
 
joe
>>> [EMAIL PROTECTED] 06/28/01 04:26PM 
>>>Dick GouletPS: For those of you who
feel

I'm Republican bashing, I'm not.  I'd have VERYhappily voted for 
McCain, even if that meant having Bush as a VP.  Now where'sthat 
independent counsel when you need him!!!
 

-- 
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: 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 DBA with SQL Server and Manufacturing Industry exp.-

[OraStaff]

This Richmond Virginia manufacturing company needs a solid Oracle DBA to
join its' I.T. team.

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

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Requirements:
- Manufacturing experience- a must
- 4+ yrs Oracle DBA experience
- SQL Server or Alpha Server experience

Salary..Up to 95K D.O.E. + excellent benefits
Relocation assistance is provided if needed.

PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Email: [EMAIL PROTECTED]
1-800-549-8502
Please Use Job Code: One/DBA/Richmond/Sol

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


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

Fat City Network Services-- (858) 538-5051  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: OT RE: 24 x 7 on NT?

[Kevin Kostyszyn]

Ohhh...that was good, wish I would have thought of that:)

-Original Message-
Sent: Thursday, June 28, 2001 5:34 PM
To: Multiple recipients of list ORACLE-L


yea, they could call it the gpF-22 then.:)

-Original Message-
Sent: Thursday, June 28, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


OH MAN, the F-22 with NT, oh jeez...Hey I love NT, but the amount of times I
have had to reboot a machine, I couldn't imagine that in an F-22.

-Original Message-
Sent: Thursday, June 28, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.

||   Don't you mean they had a good
"AN-UYK" over it?

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla,
dos, unix, or nt. VMS maybe
--
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: Kevin Kostyszyn
  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).

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

A Question on the Basics of PL/SQL

[kjanusz]

I am a bit confused as to when to use the following.  I 
cannot seem to find any definitive rules.

- function
- cursor
- procedure
- package

If someone can point me to a white paper, or whatever, 
that defines the rules for their usage I would be most 
thankful.

Thanks,
Ken Janusz, CPIM
-- 
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).

executable trigger

[Allen R. Lucas]

We have Oracle 8.0.5 in NT4.0.

A developer asked if an Oracle trigger can be used to kick off an
executable.  Looking in my books, I would have to assume 'no' as I find
noreference to this, but can anyone verify I am wrong, and where could I
get addiional information  if I am wrong?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Allen R. Lucas
  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: OT RE: 24 x 7 on NT?

[Mohan, Ross]

yea, they could call it the gpF-22 then.:)

-Original Message-
Sent: Thursday, June 28, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


OH MAN, the F-22 with NT, oh jeez...Hey I love NT, but the amount of times I
have had to reboot a machine, I couldn't imagine that in an F-22.

-Original Message-
Sent: Thursday, June 28, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.

||   Don't you mean they had a good
"AN-UYK" over it?

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla,
dos, unix, or nt. VMS maybe
--
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: Kevin Kostyszyn
  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).

OCP Discount S36

[kjanusz]

OTN says that you can get an OCT 20% discount on the 
testw with code S36.  However, it doesn't say when this 
code expires?

Thanks,
Ken Janusz, CPIM
-- 
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: Virus again

[Greg Moore]

> The boys in network admin initially said they would "strip" the virus-now
> they have said that they are going to block email from the list.

The boys  in network admin may be barking up the wrong tree.  As I
understand it, no email from the list contains a virus.

Even if the virus did come from the list, what kind of solution is this?  If
someone from your accounting department sends you an email that has a virus
are they going to block all email from accounting?  If a customer sends an
email with a virus are they going to block all email from customers?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  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: OT RE: 24 x 7 on NT?

[Kevin Kostyszyn]

OH MAN, the F-22 with NT, oh jeez...Hey I love NT, but the amount of times I
have had to reboot a machine, I couldn't imagine that in an F-22.

-Original Message-
Sent: Thursday, June 28, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.

||   Don't you mean they had a good
"AN-UYK" over it?

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla,
dos, unix, or nt. VMS maybe
--
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: Kevin Kostyszyn
  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: SQL-Server Presentation/Reality Check

[MacGregor, Ian A.]

Befor slamming sql-server you'd better look at how Oracle works.  Oracle's default is 
statement level read consistency.  That is a statement will not see data that was 
changed by another user  after the statement was issued whether that data is committed 
or not.  However, if  the other user commits the data, and the first user issues the 
statement again, the changed data will be seen.  The read was not repeatable.  A 
transaction can contain several selects.  If another user changes and commits the data 
between these selects the transaction is not read consistent.  if you want transaction 
level read consistency you need to use  "set transaction read only", I believe that's 
the syntax.  There are restrictions on doing so such as the transaction cannot make 
any changes.  It also puts a load on the rollback segments.  How does Oracle's 
statement level read consistency differ frol SQL-Server's "READ COMMITTED".  Are you 
saying that a sql_server query will see committed changes made!
!
 after
the query started.  That it doesn't even provide statement level read consistency.

I'm not sure what is meant by phantom.  Is it that users making changes cannot perform 
repeatable reads because they  their own uncommited data.  This is how Oracle works as 
well.

Doesn't 9i give you the ability to do dirty reads, if you want.  I have heard rumors 
to that effect.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


 

-Original Message-
Sent: Wednesday, June 27, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L



>From SQL-Server BOL (Books on Line)

"READ COMMITTED

Specifies that shared locks are held while the data is being read to avoid
dirty reads, but the data can be changed before the end of the transaction,
resulting in nonrepeatable reads or phantom data. This option is the SQL
Server default.

READ UNCOMMITTED

Implements dirty read, or isolation level 0 locking, which means that no
shared locks are issued and no exclusive locks are honored. When this option
is set, it is possible to read uncommitted or dirty data; values in the data
can be changed and rows can appear or disappear in the data set before the
end of the transaction. This option has the same effect as setting NOLOCK on
all tables in all SELECT statements in a transaction. This is the least
restrictive of the four isolation levels."

Note in the above 'nonreaptable reads'
and 'phantom data'. Again, from BOL:

nonrepeatable read:
When a transaction reads the same row more than one time, and between the
two (or more) reads, a separate transaction modifies that row. Because the
row was modified between reads within the same transaction, each read
produces different values, which introduces inconsistency.

phantom:
By one task, the insertion of a new row or the deletion of an existing row
in a range of rows previously read by another task that has not yet
committed its transaction. The task with the uncommitted transaction cannot
repeat its original read because of the change to the number of rows in the
range. If a connection sets its transaction isolation level to serializable,
SQL Server uses key-range locking to prevent phantoms.

My observations:
Note that setting the transaction isolation level to serializeable may make
large portions
of a table unavailable to another transaction yet that's the only way to
insure no phantom
data, and is too restrictive to be the default.

Also note that unless a transaction explicitly defines 'Begin Transaction', 
data is auto-committed. i.e. 'update students set lname='Smith'
followed by 'go' will trash your student table if you forget the 'where'
clause.
You cannot issue a rollback, since you didn't define a transaction. In
addition,
another transaction already reading the student table will get some
percentage
of all rows as 'Smith' even though it began before the 'bad' update.
Try it yourself, as a I did (I used a large 'waitfor' in the middle of
a procedural loop to simulate a larger table or more per-row processing)

HTH
Still unashamedly anti-Redmond, 

Ed Maurer
Sr. DBA
Acquirex


> -Original Message-
> From: Post, Ethan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 2:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL-Server Presentation/Reality Check
> 
> 
> Can you provide some references to lack of support of 
> read-consistency.  Not
> that I don't believe you but I just read that to a guy next 
> to me and he is
> clamoring for evidence. - E
> 
> -Original Message-
> Sent: Wednesday, June 27, 2001 2:07 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Privilege ? Reality? Reality and MS is an oxymoron.
> I've had the fortune (misfortune) to become a SQL Server DBA
> in addition to my Oracle duties, due to packaged application
> requirements. As an admitted defiler of all MS stands for and
> it's dubious accomplishments, I'll offer a few grains of sand,
> most of which you might

RE: Invalid packages not being recompiled by Oracle

[JOE TESTA]

Tom, if you do enough patches to oracle, you'll 
remember(assuming you as anal as me and really read the patch 
instructions).
 
joe
 
>>> [EMAIL PROTECTED] 06/28/01 04:26PM 
>>>
Joe,
 
I keep forgetting about that 
one...  :)
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 4:03 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Invalid packages not being recompiled by Oracle
  later versions of oracle 
   
  $ORACLE_HOME/rdbms/admin/utlrp.sql
   
  joe
   
  >>> [EMAIL PROTECTED] 06/28/01 03:40PM 
  >>>
  Paul,
   
  Lisa 
  has the correct answer - you must recompile all dependent items.  
  
  This 
  behavior has been standard since the beginning of PL/SQL.
   
  Actually, if your application could be changed to 
  capture the error, and just call the package a second time, all would be well 
  - that is - the package would be compiled by the call, and be 
  validated.
   
  I 
  would suggest either running the dbms_utility.compile_Schema utility 
  (which I am not a fan of, as it sometimes dies with a recursive sql error) or 
  running the script below which will re-compile all invalid objects within the 
  schema.
   
  hope 
  this helps.
   
   
  set 
  heading offset pagesize 5000set pages 100set serveroutput 
  onexec dbms_output.enable(50);spool 
  compile.sqldeclarecursor c1 is  select 'alter ' || 
  object_type || ' ' || object_name || ' compile;' out_line  from 
  user_objects  where status='INVALID'  and object_type in 
  ('PROCEDURE','PACKAGE','FUNCTION','VIEW','TRIGGER')  order by 
  1;begin for c1_rec in c1 loop   
  dbms_output.put_line(c1_rec.out_line); end 
  loop; dbms_output.put_line('exit');end;/spool 
  off@compile
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
3:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Invalid packages not being recompiled by 
Oracle
HI Paul, 
By chance can you use 
dbms_utility.compile_Schema after recompiling? Are you using it 
already?  I know it doesn't answer your quesiton but this package is 
suppossed to follow the dependencies, no matter how odd they are (what you 
are describing below is pretty weird). 
HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA 

  -Original Message- From:   Troiano, Paul (CAP, GEFA) [SMTP:[EMAIL PROTECTED]] 
  Sent:   Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:    Invalid packages not being recompiled by Oracle 
  
  We have one package A that refers to package B. 
  If package B's body and specification 
  are both recompiled by user 1, package A is correctly marked 
  as invalid. Another user, user 2, then 
  attempts to execute package A and gets 
  the following error stack: 
  -- ORA-04068: existing state of packages has 
  been discarded -- ORA-04061: existing 
  state of package "B" has been invalidated -- ORA-04065: not executed, altered or dropped package "B" 
  -- ORA-06508: PL/SQL: could not find 
  program unit being called -- ORA-06512: 
  at "B", line n ORA-06512: at line 2 
  User 2 then issues the statement 'alter package 
  A compile;' It compiles successfully 
  and user 2 can now execute the package. 
  Why does Oracle not automatically recompile 
  package A as it should? Since user 2 
  was able to recompile the package in its existing state, Oracle 
  should not have failed at doing so. User 2's 
  session instantiation of package A (as 
  well as all of their other instantiated packages) should have 
  been lost when package A was 
  invalidated. 
  I understand that two possible options are: (1) 
  Flush the shared pool after recompiling; and (2) Manually recompile all dependent packages 
  (such as A). The first seems like 
  overkill and will cause performance issues. The second, with many dependencies involved, is not an 
  option. 
  We need to consistently be able to recompile a 
  package that other packages are 
  dependent upon without a user recieving the above error stack in 
  addition to not impacting performance or 
  without having to recompile all the dependent packages. 
  Thanks in advance, 
  - Paul 
  -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, 
  Paul (CAP, GEFA)   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 

OT::Take a look.

[JOE TESTA]

The old independent council(goofball starr) is 
coming to BFE Ohio for some reason, saw it on the news the other day.
 
joe
>>> [EMAIL PROTECTED] 06/28/01 04:26PM 
>>>Dick GouletPS: For those of you who feel 
I'm Republican bashing, I'm not.  I'd have VERYhappily voted for 
McCain, even if that meant having Bush as a VP.  Now where'sthat 
independent counsel when you need him!!!
 

Re:OT::Take a look.

[dgoulet]

Well, send him back to Washington, his job ain't done yet!!

Reply Separator
Author: "JOE TESTA" <[EMAIL PROTECTED]>
Date:   6/28/2001 3:50 PM

The old independent council(goofball starr) is coming to BFE Ohio for some
reason, saw it on the news the other day.

joe


>>> [EMAIL PROTECTED] 06/28/01 04:26PM >>>

Dick Goulet

PS: For those of you who feel I'm Republican bashing, I'm not.  I'd have VERY
happily voted for McCain, even if that meant having Bush as a VP.  Now where's
that independent counsel when you need him!!!






The old independent council(goofball starr) is 
coming to BFE Ohio for some reason, saw it on the news the other day.
 
joe
>>> [EMAIL PROTECTED] 06/28/01 04:26PM 
>>>Dick GouletPS: For those of you who feel

I'm Republican bashing, I'm not.  I'd have VERYhappily voted for 
McCain, even if that meant having Bush as a VP.  Now where'sthat 
independent counsel when you need him!!!
 

-- 
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: How to do a bitwise OR from SQL*Plus

[Stephane Faroult]

"Kempf, Reed" wrote:
> 
> There is a some good info on working with external procedures out on
> metalink and also on this orafaq document.
> 

Just a note about external procedures. I'd rather not use them if many
concurrent users need to call the routine. The reason is that every
session will have a shadow 'runproc' program running, the purpose of
which is to load on demand the routine from a shared library, execute
and return the result - if you have many concurrent sessions the
extra-load may be significant (not too mention that if you want C just
to get better performance than with PL/SQL, you may be disappointed). It
is of course OK if your connections are pooled or if your routines are
used by a single batch program. There are also a number of concerns
which may be a pain when coding :
- Oracle mention that runproc is currently (8i, unchecked with 9i)
unthreaded, but they leave the option open for the future. Watch
therefore critical sections and polish your semaphores.
- Static variables are forbidden, because you do not control when the
function is reloaded in memory (resetting everything). A workaround
might be, if you need some persistence between successive calls,  shared
memory, but I still have to play with this.
In brief, uncareful coding may lead to bugs, if not right now, in a near
future, and they may be difficult to find then.

An alternative to consider would be, in my opinion, a dedicated 'service
provider' daemon, which could answer requests through dbms_pipe - the
'give me a quote' example in the Oracle documentation for pipes is
perfectly adequate. The 'service provider' could collect the information
from a Reuters or Bloomberg flow and send it back, a certainly more
efficient solution than external procedures getting the quote directly
from the non-Oracle source. Of course, then you have the problem of
starting/stopping the server, which is a non-problem with runproc.

My 0.02c.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: Venkata's pc is back in line "VIRUS" messgaes again

[Gene Sais]

Why we don't all send it back to him 10x?  Also, when you get junk snail mail w/ a 
prepaid return envelope, just send it back empty.  This way the marketers have to pay 
twice :).

>>> [EMAIL PROTECTED] 06/28/01 12:23PM >>>
same here. 

-Original Message-
Sent: Thursday, June 28, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I Just received 3 messages from Venlata Apparao that had virus's attached.
My mail server deleted the attachment. The mail was sent directly to me and
not the ORACLE-L list.
ROR mª¿ªm

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

RE: Invalid packages not being recompiled by Oracle

[Mohammad Rafiq]

You may run a script in cron to check invalids and recompile them. It may 
run once or twice in a day...This problem pertains to custom code...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 28 Jun 2001 11:50:27 -0800

Are you talking about an auto-recompile that happens when a user tries to
access a package that is invalid ??   Basically, just like views do ???

I have wanted that for a long time !  Every time we modify one package we
always have to go back and do an entire recompile on our system.  There are
usually over 100 invalid items at that time  depending on what we
changed.   Its a pain.

Kevin

-Original Message-
Sent: Thursday, June 28, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L



We have one package A that refers to package B. If package B's body and
specification are both recompiled by user 1, package A is correctly marked
as invalid. Another user, user 2, then attempts to execute package A and
gets the following error stack:

-- ORA-04068: existing state of packages has been discarded
-- ORA-04061: existing state of package "B" has been invalidated
-- ORA-04065: not executed, altered or dropped package "B"
-- ORA-06508: PL/SQL: could not find program unit being called
-- ORA-06512: at "B", line n ORA-06512: at line 2

User 2 then issues the statement 'alter package A compile;' It compiles
successfully and user 2 can now execute the package.

Why does Oracle not automatically recompile package A as it should? Since
user 2 was able to recompile the package in its existing state, Oracle
should not have failed at doing so. User 2's session instantiation of
package A (as well as all of their other instantiated packages) should have
been lost when package A was invalidated.

I understand that two possible options are: (1) Flush the shared pool after
recompiling; and (2) Manually recompile all dependent packages (such as A).
The first seems like overkill and will cause performance issues. The second,
with many dependencies involved, is not an option.

We need to consistently be able to recompile a package that other packages
are dependent upon without a user recieving the above error stack in
addition to not impacting performance or without having to recompile all the
dependent packages.

Thanks in advance,

- Paul


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

_
Get your FREE download of MSN Explorer at http://explorer.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: OT 24 x 7 on NT?

[JOE TESTA]

Ross, you'll leave me no choice but to filter you out if you 
get serious on me :)
 
Joe
_make_sql_run_faster now part of the oracle 
kernel
>>> [EMAIL PROTECTED] 06/28/01 04:35PM 
>>>I have passed through Humor Mach One. The sonic boom 
temporarily deafens the listener, making all communicationeffectively go 
to /dev/null.Ok, on the USCG, i posted something serious after 
thatpost AND I am trying to get into contact with an oldcolleague of 
mine who runs IT in Martinsburg. I hope to have something serious, soon. 
Seriously. Really, guys! Come on 
backhey.guys?-Original Message-Sent: Thursday, June 
28, 2001 4:08 PMTo: Multiple recipients of list ORACLE-LYou know 
what's really sad?  I have no idea when you're (Ross) being seriousor 
joking:)-Original Message-Sent: Thursday, June 28, 2001 3:50 
PMTo: Multiple recipients of list ORACLE-LEverything. The whole 
Coast Guard. Everything just turned blue and froze.Then, someone using 
oracle with "read consistency" was able to order areplacement ship 
simultaneously with the guy who was removing the lastship from inventory, 
but fortunately for the USCG, Oracle doesn't let"writers block readers", so 
the order went through but was never fulfilled.Now, they're running DB2 
on VMS on realtime nanokernel OS kiosks.-Original 
Message-Sent: Thursday, June 28, 2001 3:20 PMTo: Multiple recipients 
of list ORACLE-LThe software or the ship?--Walt 
Weaver  Bozeman, Montana, USA-Original 
Message-Sent: Thursday, June 28, 2001 12:56 PMTo: Multiple 
recipients of list ORACLE-LOn one of their newer ships they were 
using NT, and it froze up a couple oftimes.-Original 
Message-Sent: Thursday, June 28, 2001 1:36 PMTo: Multiple recipients 
of list ORACLE-LThe Coast guard uses Unisys, too...but i 
don'tknow where NT fits in to their front line systems.--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Weaver, 
Walt  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso 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-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Kevin Kostyszyn  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso 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-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: RE: OT RE: 24 x 7 on NT?

[Mohan, Ross]

Dick.

||  Thanks for chiming in!

On number one, those Unisys workstations were standardized over all of
the
services since GSA singed a VERY large contract for them.  We had them all
over
the place in the USAF as well.

||  Well..ok...but I never saw any in the Navy. But I was in what is now
called
SPAWAR...maybe they didn't dig those GSA contracts.  The ones you and I saw
where
the SW-II. Since then, they've got SW-III in. I wonder if they still call
them
"snotboxes" since they kinda looked like a tissue box


On the second point, your dead right.  I do not remember the ship
involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The
totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.
Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.  

||  Yeaabout five years ago?  SS6.0 maybe?

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.  

||   Don't you mean they had a good
"AN-UYK" over it?  

Better ideas I do believe have prevailed.

||  I can't imagine making anything mission critical either under vanilla, 
dos, unix, or nt. VMS maybe
-- 
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: Install Oracle 9i on SUSE Linux 7.1

[JOE TESTA]

nice setup, doubt i'll drop the $$$ this time to get a machine 
to handle 512M of ram, maybe for oracle 10j when it comes out and i can't force 
it to run on my laptop :)
 
joe
 
PS:  the 10j is just +9i+  not real meaning or 
significance, oh wait and for those of you waiting for the
 
 
PSS:  _make_sql_run_faster undocumented parameter for 
9i.  Its already set in the kernel, its not needed anymore.
 
 
>>> [EMAIL PROTECTED] 06/28/01 04:15PM 
>>>
Hi,
 
For those interested I installed Oracle 
9i on Linux today.
 
My configuration :
Dell Inspiron 7500
512 Mb memory
30 Gb disk
SUSE 7.1
Swap partition = 2 Gb
 
I began with a fresh and clean install of 
Linux SUSE 7.1. (default system + networking)
(Kernel 2.4, I had to modify the 
semaphore and shared memory parameters)
I installed the jdk118_v3 from 
blackdown.org.
I ftp'd the 3 .cpio files from 
Technet.
Began Installing the Oracle Software and 
choose to automatically install the database by use of the database 
assistant.
 
Installation of software took about a 
hour and a half. The swap went to approximitely 500 Mb.
Than the installation of the database 
with Database Assistant ..
I took all the options (Java 
VM,Intermedia,Ultrasearch,Examples) and it took about 3 hours to install the 
database.
Swap went up to almost 600 Mb 
!!
 
Everything runs fine as far as I can see 
now.
 
So basically I encountered not one single 
problem. It just took a hell of a time to do the install.
I work for a client with more than 200 
databases (small, but a lot of big ones), so we need to optimize the install or 
upgrade.
Off course the machines are a whole lot 
bigger than my portable.
 
Just to let you know that 9i can 
run on SUSE 7.1 without problems.(on my portable off course does not 
implicitly mean everywhere)
 
Ing. Patrick Van der SandeManaging 
DirectorANDES Consulting BVBAwww.andes-consulting.be0477/367285

Re:RE: OT RE: 24 x 7 on NT?

[dgoulet]

Ross,

On number one, those Unisys workstations were standardized over all of the
services since GSA singed a VERY large contract for them.  We had them all over
the place in the USAF as well.

On the second point, your dead right.  I do not remember the ship involved,
but it turned out to have been a SQL*Server bug that gpf'd the OS.  The totality
of the problem was that the ship's radar, navigation, weapons control, and
digital electronic control system were all knocked out at the same time.  Can
you say "OOPS!!".The ship returned to port under manual control without
incident.  Seems someone at the Navy was a little old fashioned in their
thinking.  

BTW: My source of info here is the Air Force News Agency's daily news
letter.  They had a good laugh I'm sure since I understand that the F-22 was
suppose to be NT driven as well initially.  Better ideas I do believe have
prevailed.

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   6/28/2001 12:07 PM

I think it was the Navy. 

The US Coast Guard has something called USCG SW-III (Standard
Workstation III) that is NT 4.0 on Unisys. If you have ever
worked at the Coast Guard, you know these boxes are EVERYWHERE.
Some people even have two.  They are highly standardized, well 
above average in MTBF and MTTR, and the Coast Guard runs on them. 

I ::think:: (but could easily be wrong) that the Navy was trying
to integrate an NT box with a disparate realtime targeting system
and when the NT box GPF'ed, it downed the targeting radar. Prudence
dictated the ship head back to port for repairs, radar being directly
related to a destroyers seaworthiness. 

But, again, this could be WAY WRONG, so two grains of salt, ok guys?



-Original Message-
Sent: Thursday, June 28, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


Hahah, the software, the ship had to be towed back to port:)  However, not
sure if it was the coast guard or the navy, but I am going with the coast
guard.
KK

-Original Message-
Walt
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

Responses to Vivek Sharma's multiple postings on Oracle-L

[Gaja Krishna Vaidyanatha]

Dear Vivek,

I totally respect your "requests for clarification"
and I will be more than happy to give them to you. But
going forward, I urge you NOT to send "specific
questions" on bullet points in the powerpoint slides
of my presentations to the list (and that too multiple
times), instead send it to me directly at -
[EMAIL PROTECTED]

Your questions "directed to me" but posted on the list
may not be appropriate for the following reasons:

1) People may not have access to the PPT you are
referring to, and thus may not have any "point of
reference".

2) Not everyone (yourself included) have the
background material that is covered during the
presentation, as part the talk (explanations that are
done during a presentation). There may be a lot of
content that is missed. Bullets in my PPTs are
"outlines" for me to talk and expand further.

3) #2 can potentially lead people to arrive at
"erroneous conclusions" as some bullet points may be
"taken out of context". As a result, this may raise
more questions.

4) Lastly, you may be cluttering the Inbox of a few
thousand people for "questions directed to me NOT to
the list" and people may not appreciate that.

Here are responses to your queries:

1) sar -d Interpretation. "High disk queue numbers + 
high service times -> I/O contention". What values of
disk queue numbers, high service times are Considered
High ?

Ans. For most storage architectures available today,
an average service time for I/O requests that exceeds
20ms is considered a "bottleneck". Service times of
20ms or above are usually accompanied by "wait queue
and run queue" numbers that are non-zero. What is
"high" for one environment, may not be relevant for
another. The 20ms threshold may not be applicable to
some of the more esoteric storage devices (such as
solid state disks). These are "guidelines" NOT
"draconian rules".

2) sar -d Interpretation. "%busy can be high if
service times are within (4 *CPU time-slice)". What
does CPU time-slice mean & how can it be Calculated ?

Ans. The "4*CPU time-slice" guideline is a method we
used in the past to diagnose I/O bottlenecks. I
mention this to "lay some foundation and history"
during my presentation. 

For example, if your system's CPU timeslice was set at
10ms, any service time above 40ms was considered to be
"high". CPU time slice is the amount of CPU time a
process gets when requesting the CPU, until it
consumes the slice, or undergoes a context switch to
perform I/O. The CPU timeslice is a OS kernel
configurable parameter. Please check your OS docs for
specific details. Again, a guideline NOT a rule.

3) How to configure sort_write_buffers and
sort_write_buffer_size?

Ans. These parameters are configured (prior to
Oracle8i) to enable Oracle to write the temporary
segments directly to disk, by bypassing the database
buffer cache.  This is only relevant when configuring
SORT_DIRECT_WRITES to TRUE. The 2 related parameters
namely SORT_WRITE_BUFFERS and SORT_WRITE_BUFFER_SIZE
can be set to 4 and 65536 (but the max. values for
these may be OS dependent).  From Oracle 8.1 onwards,
the only configurable sort parameters are
SORT_AREA_SIZE, SORT_AREA_RETAINED_SIZE and
SORT_MULTIBLOCK_READ_COUNT, as all other sort-related
parameters have been de-supported.

Hope that helps,

Gaja

=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Krishna Vaidyanatha
  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).

Password file in 8.1.6

[Smith, Ron L.]

I needed to create a couple of similar instances on NT so I chose to save
the script in the Oracle Database Configuration Assistant.  When I tried to
use the script I kept getting an error that said something like "error
writing to password file."  I looked and the password file for the new
instance did not exist so it wasn't trying to write over an old password
file.  I reran Configuration Assistant and let it create the instance and it
worked fine.  Apparantly if you run Configuration Assistant it handles this
but the script does not.  Can anyone tell me what I am doing wrong?

Thanks!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 24 x 7 on NT?

[Kevin Kostyszyn]

hahahahaha

-Original Message-
Sent: Thursday, June 28, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


I have passed through Humor Mach One. The sonic boom
temporarily deafens the listener, making all communication
effectively go to /dev/null.

Ok, on the USCG, i posted something serious after that
post AND I am trying to get into contact with an old
colleague of mine who runs IT in Martinsburg.

I hope to have something serious, soon.

Seriously.

Really, guys! Come on backhey.guys?

-Original Message-
Sent: Thursday, June 28, 2001 4:08 PM
To: Multiple recipients of list ORACLE-L


You know what's really sad?  I have no idea when you're (Ross) being serious
or joking:)

-Original Message-
Sent: Thursday, June 28, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Everything. The whole Coast Guard. Everything just turned blue and froze.

Then, someone using oracle with "read consistency" was able to order a
replacement ship simultaneously with the guy who was removing the last
ship from inventory, but fortunately for the USCG, Oracle doesn't let
"writers block readers", so the order went through but was never fulfilled.

Now, they're running DB2 on VMS on realtime nanokernel OS kiosks.


-Original Message-
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

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

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

RE: Take a look.

[Adams, Matthew (GEA, 088130)]

Title: RE: Take a look.





"some people claim
both sides are the same,
the good guys and the bad guys"




> -Original Message-
> From: Terry Ball [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 3:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Take a look.
> 
> 
> Good and bad news, whichever side you take.
> 
> http://www.msnbc.com/news/563498.asp
> 
> Terry
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Terry Ball
>   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: Invalid packages not being recompiled by Oracle

[Mercadante, Thomas F]

Joe,
 
I keep forgetting about that 
one...  :)
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 4:03 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Invalid packages not being recompiled by Oracle
  later versions of oracle 
   
  $ORACLE_HOME/rdbms/admin/utlrp.sql
   
  joe
   
  >>> [EMAIL PROTECTED] 06/28/01 03:40PM 
  >>>
  Paul,
   
  Lisa 
  has the correct answer - you must recompile all dependent items.  
  
  This 
  behavior has been standard since the beginning of PL/SQL.
   
  Actually, if your application could be changed to 
  capture the error, and just call the package a second time, all would be well 
  - that is - the package would be compiled by the call, and be 
  validated.
   
  I 
  would suggest either running the dbms_utility.compile_Schema utility 
  (which I am not a fan of, as it sometimes dies with a recursive sql error) or 
  running the script below which will re-compile all invalid objects within the 
  schema.
   
  hope 
  this helps.
   
   
  set 
  heading offset pagesize 5000set pages 100set serveroutput 
  onexec dbms_output.enable(50);spool 
  compile.sqldeclarecursor c1 is  select 'alter ' || 
  object_type || ' ' || object_name || ' compile;' out_line  from 
  user_objects  where status='INVALID'  and object_type in 
  ('PROCEDURE','PACKAGE','FUNCTION','VIEW','TRIGGER')  order by 
  1;begin for c1_rec in c1 loop   
  dbms_output.put_line(c1_rec.out_line); end 
  loop; dbms_output.put_line('exit');end;/spool 
  off@compile
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
3:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Invalid packages not being recompiled by 
Oracle
HI Paul, 
By chance can you use 
dbms_utility.compile_Schema after recompiling? Are you using it 
already?  I know it doesn't answer your quesiton but this package is 
suppossed to follow the dependencies, no matter how odd they are (what you 
are describing below is pretty weird). 
HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA 

  -Original Message- From:   Troiano, Paul (CAP, GEFA) [SMTP:[EMAIL PROTECTED]] 
  Sent:   Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:    Invalid packages not being recompiled by Oracle 
  
  We have one package A that refers to package B. 
  If package B's body and specification 
  are both recompiled by user 1, package A is correctly marked 
  as invalid. Another user, user 2, then 
  attempts to execute package A and gets 
  the following error stack: 
  -- ORA-04068: existing state of packages has 
  been discarded -- ORA-04061: existing 
  state of package "B" has been invalidated -- ORA-04065: not executed, altered or dropped package "B" 
  -- ORA-06508: PL/SQL: could not find 
  program unit being called -- ORA-06512: 
  at "B", line n ORA-06512: at line 2 
  User 2 then issues the statement 'alter package 
  A compile;' It compiles successfully 
  and user 2 can now execute the package. 
  Why does Oracle not automatically recompile 
  package A as it should? Since user 2 
  was able to recompile the package in its existing state, Oracle 
  should not have failed at doing so. User 2's 
  session instantiation of package A (as 
  well as all of their other instantiated packages) should have 
  been lost when package A was 
  invalidated. 
  I understand that two possible options are: (1) 
  Flush the shared pool after recompiling; and (2) Manually recompile all dependent packages 
  (such as A). The first seems like 
  overkill and will cause performance issues. The second, with many dependencies involved, is not an 
  option. 
  We need to consistently be able to recompile a 
  package that other packages are 
  dependent upon without a user recieving the above error stack in 
  addition to not impacting performance or 
  without having to recompile all the dependent packages. 
  Thanks in advance, 
  - Paul 
  -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, 
  GEFA)   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 

RE: OT 24 x 7 on NT?

[Mohan, Ross]

I have passed through Humor Mach One. The sonic boom 
temporarily deafens the listener, making all communication
effectively go to /dev/null.

Ok, on the USCG, i posted something serious after that
post AND I am trying to get into contact with an old
colleague of mine who runs IT in Martinsburg. 

I hope to have something serious, soon. 

Seriously. 

Really, guys! Come on backhey.guys?

-Original Message-
Sent: Thursday, June 28, 2001 4:08 PM
To: Multiple recipients of list ORACLE-L


You know what's really sad?  I have no idea when you're (Ross) being serious
or joking:)

-Original Message-
Sent: Thursday, June 28, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Everything. The whole Coast Guard. Everything just turned blue and froze.

Then, someone using oracle with "read consistency" was able to order a
replacement ship simultaneously with the guy who was removing the last
ship from inventory, but fortunately for the USCG, Oracle doesn't let
"writers block readers", so the order went through but was never fulfilled.

Now, they're running DB2 on VMS on realtime nanokernel OS kiosks.


-Original Message-
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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: How to do a bitwise OR from SQL*Plus

[Kempf, Reed]

There is a some good info on working with external procedures out on
metalink and also on this orafaq document.

Here is the jist of it:
/*
 * extproc.c  
 * 
 * Call operating system commands from PL/SQL using the External 
 * Procedure Interface.
 *
 *  Frank Naude - Dec 2000
 * 
 * Setup instructions:
 *
 * 1. Compile this program: cc -G extproc.c -o extproc.so (on Unix)
 * 2. Run $ORACLE_HOME/bin/extproc to ensure it is executable
 * 3. Define this TNSNAMES.ORA entry (Use the correct domain):
 *   EXTPROC_CONNECTION_DATA.WORLD = (DESCRIPTION =
 *  (ADDRESS=(PROTOCOL=IPC)(KEY=extproc))
 *  (CONNECT_DATA=(SID=extproc)))
 * 4. Define this LISTENER.ORA entry:
 *   EXTERNAL_PROCEDURE_LISTENER =
 *  (ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)))
 *   SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
 *  (SID_LIST=(SID_DESC=(SID_NAME=extproc)
 *  (ORACLE_HOME=/app/oracle/product.8.1.7)(PROGRAM=extproc)))
 * 5. Start the new listener: lsnrctl start EXTERNAL_PROCEDURE_LISTENER
 * 6. SQL> create library shell_lib as '/app/oracle/local/extproc.so'; 
 * /
 * 7. SQL> create or replace function sysrun (syscomm in varchar2)
 * return binary_integer
 * as language C  -- Use "as external" for older Oracle releases
 *name "sysrun"
 *library shell_lib
 *parameters(syscomm string);
 * /
 * 8. Execute an OS command from PL/SQL: 
 *   PL/SQL> declare
 *  rc number;
 *   begin
 *  rc := sysrun('/bin/ls -l');
 *  dbms_output.put_line('Return Code='||rc);
 *   end;
 *   /
 *
 * 
 * Notes: 
 *
 * 1. When running shell-scripts, very few environment variables will be
 *defined (as with cron jobs). Remember to set everything 
 *explicitly. Ie. $PATH, etc.
 * 2. Rewrite this program using C Piping if you need to capture command 
 *output. Look at the popen (pipe open) function.
 * 3. In addition to this, you can also try to make the external 
 *procedure example as provided by Oracle:
 *   $ cd $ORACLE_HOME/plsql/demo
 *   $ make -f demo_plsql.mk extproc.so
 *
 * 
 */

int sysrun(char *command)
{
   return system(command);
}



-Original Message-
Sent: Friday, June 22, 2001 4:05 AM
To: Multiple recipients of list ORACLE-L


Hi

Would external procedures be a way of doing this if bitand didn't exist ?
Just that there is a lot of very cool C code out there.

Have RTFM, but I'm a C compiler dunce and cc turned out to stand for
completely confused :-)

Has anyone managed to use external procedures ?  Is it hard to do ?  What's
the stability ?  And performance ?

Cheers
GS

-Original Message-
Sent: Thursday, 21 June 2001 16:01
To: Multiple recipients of list ORACLE-L


> why do you need to do a "bitwise or" within sqlplus?

Good question... I have a really good engineer who is working with C and
Oracle OCI. He's developing an install routine and assures me that he needs
bitwise operators from SQL because he can do some really powerful things
with them. Then he said SQLServer and MySQL had them so the challenge was
on. Turns out I was able to give him what he wanted with a little bit of
help from something I found in a google search. There is an undocumented
bitand function in oracle and it appears it must be called from another
function. (Why?) You can see how this function is used in some of the data
dictionary view creation scripts. Here's and example of bitand...

SQL> select sum(bitand(12,11)) bitand from dual;
 
BITAND
--
 8

If you can get a bitand you can do a bitor...
SQL> select sum(12+11-bitand(12,11)) bitor from dual;
 
 BITOR
--
15

The math...
1100  "12"  
1011  "11"
  bitand
1000   "8"

1100  "12"  
1011  "11"
  bitor
  "15"


Not an alpha geek today,
Steve Orr


-Original Message-
Sent: Thursday, June 21, 2001 7:06 AM
To: Multiple recipients of list ORACLE-L


but, why do you need to do a "bitwise or" within sqlplus?
just curious.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 20, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L

OK, for the alpha geek award of the day...

Who can tell me how to do a "bitwise or" from SQLPlus -- NOT PL/SQL? Isn't
there an internal undocumented bitand function and how could you use that to
implement a bitor function from SQL?

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

Fat City Network Services-- (858) 538-50

Re:Take a look.

[dgoulet]

Terry,

I'm going to call it BAD news.  Good old King George II was heavily funded
last year by MS & company (read that Bill Gates) because he did not approve of
any of the antitrust lawsuit.  None of them made any bones about it and I figure
Bill is just calling in the IOU's, that's all.

Dick Goulet

PS: For those of you who feel I'm Republican bashing, I'm not.  I'd have VERY
happily voted for McCain, even if that meant having Bush as a VP.  Now where's
that independent counsel when you need him!!!

Reply Separator
Author: Terry Ball <[EMAIL PROTECTED]>
Date:   6/28/2001 11:30 AM

Good and bad news, whichever side you take.

http://www.msnbc.com/news/563498.asp

Terry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  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 RE: 24 x 7 on NT?

[Kevin Kostyszyn]

Sounds a little more familiar, I am pretty sure that it was a destroyer.  I
think I may have to do some investigating:)

-Original Message-
Sent: Thursday, June 28, 2001 4:08 PM
To: Multiple recipients of list ORACLE-L


I think it was the Navy.

The US Coast Guard has something called USCG SW-III (Standard
Workstation III) that is NT 4.0 on Unisys. If you have ever
worked at the Coast Guard, you know these boxes are EVERYWHERE.
Some people even have two.  They are highly standardized, well
above average in MTBF and MTTR, and the Coast Guard runs on them.

I ::think:: (but could easily be wrong) that the Navy was trying
to integrate an NT box with a disparate realtime targeting system
and when the NT box GPF'ed, it downed the targeting radar. Prudence
dictated the ship head back to port for repairs, radar being directly
related to a destroyers seaworthiness.

But, again, this could be WAY WRONG, so two grains of salt, ok guys?



-Original Message-
Sent: Thursday, June 28, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


Hahah, the software, the ship had to be towed back to port:)  However, not
sure if it was the coast guard or the navy, but I am going with the coast
guard.
KK

-Original Message-
Walt
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

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

Install Oracle 9i on SUSE Linux 7.1

[Van der Sande Patrick]

Hi,
 
For those interested I installed Oracle 
9i on Linux today.
 
My configuration :
Dell Inspiron 7500
512 Mb memory
30 Gb disk
SUSE 7.1
Swap partition = 2 Gb
 
I began with a fresh and clean install of 
Linux SUSE 7.1. (default system + networking)
(Kernel 2.4, I had to modify the 
semaphore and shared memory parameters)
I installed the jdk118_v3 from 
blackdown.org.
I ftp'd the 3 .cpio files from 
Technet.
Began Installing the Oracle Software and 
choose to automatically install the database by use of the database 
assistant.
 
Installation of software took about a 
hour and a half. The swap went to approximitely 500 Mb.
Than the installation of the database 
with Database Assistant ..
I took all the options (Java 
VM,Intermedia,Ultrasearch,Examples) and it took about 3 hours to install the 
database.
Swap went up to almost 600 Mb 
!!
 
Everything runs fine as far as I can see 
now.
 
So basically I encountered not one single 
problem. It just took a hell of a time to do the install.
I work for a client with more than 200 
databases (small, but a lot of big ones), so we need to optimize the install or 
upgrade.
Off course the machines are a whole lot 
bigger than my portable.
 
Just to let you know that 9i can 
run on SUSE 7.1 without problems.(on my portable off course does not 
implicitly mean everywhere)
 
Ing. Patrick Van der SandeManaging 
DirectorANDES Consulting BVBAwww.andes-consulting.be0477/367285

Re: Pocket Guide

[jon baker]

help works for sqlplus, if you installed, but if there is a script for
building sql command structure, please pass that on.  At least 'help
index' is only showing the sqlplus commands.



Jon Baker   
Database Engineer (1/5)
<[EMAIL PROTECTED]>
www.netsec.net



Mohammad Rafiq wrote:
> 
> Quick way to check sytax ,type on sqlpromt
> 
> help create table
> 
> show all
> 
> and you will see what you want..provided you have installed help on your
> database
> 
> Regards
> Rafiq
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Thu, 28 Jun 2001 08:42:34 -0800
> 
> I'm more interested in the SQLPlus commands.  Especially the various SET
> options.  They are not intuitive (to me) and, since I only use them in
> SQLPlus they are not fresh in my memory.
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: jon baker
  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 RE: 24 x 7 on NT?

[Mohan, Ross]

I think it was the Navy. 

The US Coast Guard has something called USCG SW-III (Standard
Workstation III) that is NT 4.0 on Unisys. If you have ever
worked at the Coast Guard, you know these boxes are EVERYWHERE.
Some people even have two.  They are highly standardized, well 
above average in MTBF and MTTR, and the Coast Guard runs on them. 

I ::think:: (but could easily be wrong) that the Navy was trying
to integrate an NT box with a disparate realtime targeting system
and when the NT box GPF'ed, it downed the targeting radar. Prudence
dictated the ship head back to port for repairs, radar being directly
related to a destroyers seaworthiness. 

But, again, this could be WAY WRONG, so two grains of salt, ok guys?



-Original Message-
Sent: Thursday, June 28, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


Hahah, the software, the ship had to be towed back to port:)  However, not
sure if it was the coast guard or the navy, but I am going with the coast
guard.
KK

-Original Message-
Walt
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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 Kostyszyn
  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: OT RE: 24 x 7 on NT?

[Henry Poras]

Interesting how the concept of history is different for science vs.
technology.

Henry

-Original Message-
Sent: Thursday, June 28, 2001 1:23 PM
To: Multiple recipients of list ORACLE-L


Guy, 

Sidestepping the fact that you targeted your excellent 
reply to a person who has been disinvited from the list, 
I have to say it's one of the best posts I have read in 
a while ( on this "my daddy is going to beat up your daddy" 
OS trend ). 

I think most of us got into and stayed in this business 
because we like technology...tinkering...systems..figuring 
out how things work and making them better.  Somewhere 
along the line, we adopted "brand name" allegiances and
left behind our raw enthusiasm. Just my opinion...no bad 
vibes intended.

Personally, I am interested in seeing what the next twenty 
years bring. I can't wait to talk with my kids about the 
newest mindblowing technology in their worldwouldn't 
mind working on it,either

and I am pretty sure my kids will laugh at me when I
told them I actually used VMS, DOS, NT, and Unix. I might
even get interviewed for a Social Studies report on history.

Now *that's* living!

- Ross

-Original Message-
Sent: Thursday, June 28, 2001 12:24 PM
To: Multiple recipients of list ORACLE-L


My $0.02: 

Unisys will build you a 99.999% available system, on NT. Boeing and
NASDAQ, two very serious organizations, use NT for their line of
business. I could go on and on, but I will summarize:

Whatever your Unix box can do, my old VMS box can do better. Uptime,
performance tuning, clustering, security, the works. I say this not to
brag, but merely to illustrate that if you let a sentimental attachment
to a technology cloud your judgment, you are destined for the scrap
heap.

If I had ca$h money to spend on new technology, I would consider your
advice tainted by a clear lack of objectivity. The issue is, the right
tool for the right job. It doesn't matter if technology XYZ is the
greatest. What matter is, can I get people to work on it? Can I afford
the hardware to run it on? Etc... there are a lot of businesses that do
not and will never need the kind of computing power that NASDAQ need...
and NT is good enough for them. Just like the average athlete doesn't
need the last Air Zoom Super Whiz, but they'll buy a pair of Nikes
anyway.

Personally, I think that OSs are just those silly things you need to run
Oracle on, and I can't wait until everything is an Oracle Appliance! :0)

g


-Original Message-
Sent: Wednesday, June 27, 2001 12:09 AM
To: Multiple recipients of list ORACLE-L


Never said that. In fact if you read back a little further I
specifically
say "NT is good for the desktop." Or did your exchange server not
deliver
that message? Perhaps a nice little vb script held your outlook session
hostage and you werent able to get the e-mail. Good thing for reply
messages, right? All I'm saying is that NT really doesnt have a place in
a
5 9 env, pretty simple eh? When you reboot your laptop everynight, and
dont care about nasty memory leaks on your workstation with too much ram
cause you work for a fancy startup w/ too much venture capital, then NT
is
wonderful. Easy to use, and if you dont want to think and have a lot of
patience for things breaking that are beyond your control, and excellent
product for end users.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guy Hammond
  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).
-- 
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this m

RE: Virus.............???????????????????????????????? hope not??????????????

[Kevin Kostyszyn]

Remember the new guy who was very combative?

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Helen rwulfjeqSent: 
  Thursday, June 28, 2001 3:31 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Virus. 
  hope not??
   This is another one. It is different name but same virus found which 
  is called W32.Badtrans.13312@mm. I don't know what is going on. Your replied 
  email includes nothing but "Take a look at the attachment". What is going on 
   
  


  Scan Result 

  Name of File:
   
  searchURL.scr

  Type of File:
   
  application/octet-stream

  Scan Result:
   
  Virus W32.Badtrans.13312@mm found. 
File NOT cleaned. 

   
   
  This file is infected with a computer virus, a program that 
can spread to many other files on your computer and can delete files, 
steal sensitive information, or render your machine 
unusable.

   
  
  


  

  
  

  This attachment has a virus that may infect your computer. 
  It cannot be cleaned.We recommend that you DO NOT 
  download this attachment. 


   
  


  

  
  
Download INFECTED Attachment 
   
Back to Message 
 
View Attachment 
 
  
 
 Check here to automatically email the sender that their 
  file is infected 
  
  Disclaimer: This virus scanner may not be able to 
  detect or repair all viruses and variants. Please be aware that there is a 
  risk involved whenever downloading email attachments to your computer or 
  sending email attachments to others and that, as provided in the Terms of 
  Service, neither Yahoo nor its licensors are responsible for any damages 
  caused by your decision to do so. 
     
  


  

  
  
Powered by:Does your computer have a 
  virus?Get Norton AntiVirus & find 
  out!
    Venkata Apparao N <[EMAIL PROTECTED]> wrote: 
  'Helen 
rwulfjeq' wrote:- - Hi ,- - - - Oracle 
database system uses very complicated lock/unlock design for 
readlock,writelock and row/recordlock etc. Does anyone know lock/unlock 
is implemented both client like sqlplus and server side or just on server 
side or just client side. For instance, one user using sqlplus access 
database to update one record of table XX. So should be sqlplus's 
responsibility to lock this record based on row level of XX table? or server 
is also involved in? Than ...'> Take a look to the 
attachment. > ATTACHMENT part 2 application/octet-stream 
name=searchURL.scr 
  
  
  Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - 
  only $35 a year!http://personal.mail.yahoo.com/

RE: OT 24 x 7 on NT?

[Kevin Kostyszyn]

You know what's really sad?  I have no idea when you're (Ross) being serious
or joking:)

-Original Message-
Sent: Thursday, June 28, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Everything. The whole Coast Guard. Everything just turned blue and froze.

Then, someone using oracle with "read consistency" was able to order a
replacement ship simultaneously with the guy who was removing the last
ship from inventory, but fortunately for the USCG, Oracle doesn't let
"writers block readers", so the order went through but was never fulfilled.

Now, they're running DB2 on VMS on realtime nanokernel OS kiosks.


-Original Message-
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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: Invalid packages not being recompiled by Oracle

[JOE TESTA]

later versions of oracle 
 
$ORACLE_HOME/rdbms/admin/utlrp.sql
 
joe
 
>>> [EMAIL PROTECTED] 06/28/01 03:40PM 
>>>
Paul,
 
Lisa 
has the correct answer - you must recompile all dependent items.  

This 
behavior has been standard since the beginning of PL/SQL.
 
Actually, if your application could be changed to 
capture the error, and just call the package a second time, all would be well - 
that is - the package would be compiled by the call, and be 
validated.
 
I 
would suggest either running the dbms_utility.compile_Schema utility (which 
I am not a fan of, as it sometimes dies with a recursive sql error) or running 
the script below which will re-compile all invalid objects within the 
schema.
 
hope 
this helps.
 
 
set 
heading offset pagesize 5000set pages 100set serveroutput onexec 
dbms_output.enable(50);spool compile.sqldeclarecursor c1 
is  select 'alter ' || object_type || ' ' || object_name || ' compile;' 
out_line  from user_objects  where status='INVALID'  
and object_type in ('PROCEDURE','PACKAGE','FUNCTION','VIEW','TRIGGER')  
order by 1;begin for c1_rec in c1 loop   
dbms_output.put_line(c1_rec.out_line); end 
loop; dbms_output.put_line('exit');end;/spool 
off@compile
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
  3:20 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Invalid packages not being recompiled by Oracle
  HI Paul, 
  By chance can you use 
  dbms_utility.compile_Schema after recompiling? Are you using it already?  
  I know it doesn't answer your quesiton but this package is suppossed to follow 
  the dependencies, no matter how odd they are (what you are describing below is 
  pretty weird). 
  HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA 
  
-Original Message- From:   Troiano, Paul (CAP, GEFA) [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:    Invalid packages not being recompiled by Oracle 

We have one package A that refers to package B. 
If package B's body and specification are 
both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute 
package A and gets the following error 
stack: 
-- ORA-04068: existing state of packages has been 
discarded -- ORA-04061: existing state of 
package "B" has been invalidated -- 
ORA-04065: not executed, altered or dropped package "B" -- ORA-06508: PL/SQL: could not find program unit being 
called -- ORA-06512: at "B", line n 
ORA-06512: at line 2 
User 2 then issues the statement 'alter package A 
compile;' It compiles successfully and 
user 2 can now execute the package. 
Why does Oracle not automatically recompile 
package A as it should? Since user 2 was 
able to recompile the package in its existing state, Oracle should not have failed at doing so. User 2's session 
instantiation of package A (as well as 
all of their other instantiated packages) should have been lost when package A was invalidated. 
I understand that two possible options are: (1) 
Flush the shared pool after recompiling; 
and (2) Manually recompile all dependent packages (such as A). 
The first seems like overkill and will cause 
performance issues. The second, with many 
dependencies involved, is not an option. 
We need to consistently be able to recompile a 
package that other packages are dependent 
upon without a user recieving the above error stack in addition to not impacting performance or without having to 
recompile all the dependent 
packages. 
Thanks in advance, 
- Paul 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, 
Paul (CAP, GEFA)   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 24 x 7 on NT?

[Mohan, Ross]

Everything. The whole Coast Guard. Everything just turned blue and froze. 

Then, someone using oracle with "read consistency" was able to order a 
replacement ship simultaneously with the guy who was removing the last 
ship from inventory, but fortunately for the USCG, Oracle doesn't let
"writers block readers", so the order went through but was never fulfilled.

Now, they're running DB2 on VMS on realtime nanokernel OS kiosks.


-Original Message-
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Invalid packages not being recompiled by Oracle

[Mercadante, Thomas F]

Title: RE: Invalid packages not being recompiled by Oracle



Paul,
 
Lisa 
has the correct answer - you must recompile all dependent items.  

This 
behavior has been standard since the beginning of PL/SQL.
 
Actually, if your application could be changed to 
capture the error, and just call the package a second time, all would be well - 
that is - the package would be compiled by the call, and be 
validated.
 
I 
would suggest either running the dbms_utility.compile_Schema utility (which 
I am not a fan of, as it sometimes dies with a recursive sql error) or running 
the script below which will re-compile all invalid objects within the 
schema.
 
hope 
this helps.
 
 
set 
heading offset pagesize 5000set pages 100set serveroutput onexec 
dbms_output.enable(50);spool compile.sqldeclarecursor c1 
is  select 'alter ' || object_type || ' ' || object_name || ' compile;' 
out_line  from user_objects  where status='INVALID'  
and object_type in ('PROCEDURE','PACKAGE','FUNCTION','VIEW','TRIGGER')  
order by 1;begin for c1_rec in c1 loop   
dbms_output.put_line(c1_rec.out_line); end 
loop; dbms_output.put_line('exit');end;/spool 
off@compile
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 
  3:20 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Invalid packages not being recompiled by Oracle
  HI Paul, 
  By chance can you use 
  dbms_utility.compile_Schema after recompiling? Are you using it already?  
  I know it doesn't answer your quesiton but this package is suppossed to follow 
  the dependencies, no matter how odd they are (what you are describing below is 
  pretty weird). 
  HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA 
  
-Original Message- From:   Troiano, Paul (CAP, GEFA) [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:    Invalid packages not being recompiled by Oracle 

We have one package A that refers to package B. 
If package B's body and specification are 
both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute 
package A and gets the following error 
stack: 
-- ORA-04068: existing state of packages has been 
discarded -- ORA-04061: existing state of 
package "B" has been invalidated -- 
ORA-04065: not executed, altered or dropped package "B" -- ORA-06508: PL/SQL: could not find program unit being 
called -- ORA-06512: at "B", line n 
ORA-06512: at line 2 
User 2 then issues the statement 'alter package A 
compile;' It compiles successfully and 
user 2 can now execute the package. 
Why does Oracle not automatically recompile 
package A as it should? Since user 2 was 
able to recompile the package in its existing state, Oracle should not have failed at doing so. User 2's session 
instantiation of package A (as well as 
all of their other instantiated packages) should have been lost when package A was invalidated. 
I understand that two possible options are: (1) 
Flush the shared pool after recompiling; 
and (2) Manually recompile all dependent packages (such as A). 
The first seems like overkill and will cause 
performance issues. The second, with many 
dependencies involved, is not an option. 
We need to consistently be able to recompile a 
package that other packages are dependent 
upon without a user recieving the above error stack in addition to not impacting performance or without having to 
recompile all the dependent 
packages. 
Thanks in advance, 
- Paul 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, 
GEFA)   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: Invalid packages not being recompiled by Oracle

[Kevin Lange]

Are you talking about an auto-recompile that happens when a user tries to
access a package that is invalid ??   Basically, just like views do ???

I have wanted that for a long time !  Every time we modify one package we
always have to go back and do an entire recompile on our system.  There are
usually over 100 invalid items at that time  depending on what we
changed.   Its a pain.

Kevin

-Original Message-
Sent: Thursday, June 28, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L



We have one package A that refers to package B. If package B's body and
specification are both recompiled by user 1, package A is correctly marked
as invalid. Another user, user 2, then attempts to execute package A and
gets the following error stack:

-- ORA-04068: existing state of packages has been discarded 
-- ORA-04061: existing state of package "B" has been invalidated 
-- ORA-04065: not executed, altered or dropped package "B" 
-- ORA-06508: PL/SQL: could not find program unit being called 
-- ORA-06512: at "B", line n ORA-06512: at line 2

User 2 then issues the statement 'alter package A compile;' It compiles
successfully and user 2 can now execute the package.

Why does Oracle not automatically recompile package A as it should? Since
user 2 was able to recompile the package in its existing state, Oracle
should not have failed at doing so. User 2's session instantiation of
package A (as well as all of their other instantiated packages) should have
been lost when package A was invalidated.

I understand that two possible options are: (1) Flush the shared pool after
recompiling; and (2) Manually recompile all dependent packages (such as A).
The first seems like overkill and will cause performance issues. The second,
with many dependencies involved, is not an option.

We need to consistently be able to recompile a package that other packages
are dependent upon without a user recieving the above error stack in
addition to not impacting performance or without having to recompile all the
dependent packages.

Thanks in advance,

- Paul


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

Take a look.

[Terry Ball]

Good and bad news, whichever side you take.

http://www.msnbc.com/news/563498.asp

Terry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  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 RE: 24 x 7 on NT?

[Kevin Kostyszyn]

Hahah, the software, the ship had to be towed back to port:)  However, not
sure if it was the coast guard or the navy, but I am going with the coast
guard.
KK

-Original Message-
Walt
Sent: Thursday, June 28, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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 Kostyszyn
  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: Comparing pl/sql - sql

[DBarbour]

Roland,

I just love your posts.  I would guess that the procedure is doing
something to further refine the select returned from the "pure" sql query.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Roland.Skoldb  
   
[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
Sent by: cc:   
   
root@fatcity.Subject: Comparing pl/sql - sql   
   
com
   
   
   
   
   
06/28/2001 
   
12:01 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




Hallo,

I  have a pl/sql code and when  i run the procedure I get the result of 20
records(20 rows) but when I copy the sql query into the sql window and run
only the query it gives me the result of 30 records(30 rows). What does
this depend on? How can I
solve this problem?

Sincerely


Roland Sköldblom







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

Fwd:Re: Update: Appeals court judges take Jackson to task

[Ron Rogers]

As a side note the Fed's are condemplating another suit against MS for XP. see 
www.theregister.co.uk for the story.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/28/01 03:12PM >>>
For those of you interested in the fortunes of MicroSlop, it would appear that
politics has done it again!!

Forward Header_
t
Author: "Sharon Machlis" <[EMAIL PROTECTED]>
Date:   6/28/2001 1:21 PM



Thanks for writing to us in the past about the Microsoft antitrust trial.
Because of your previous e-mail, we wanted to let you know that:

A U.S. Appeals Court has just overturned Judge Jackson's order to break up
Microsoft Corp.

You can read our bulletin at

http://www.computerworld.com/storyba/0,4125,NAV47_STO61733,00.html 

and then post your opinion on our interactive forum at

http://cwforums.computerworld.com/WebX?50@@.ee9a4d9/0 

(Note: Anyone can read messages; free registration is required to post. If
you're not registered yet, head to http://cwforums.computerworld.com/webX?18@@ )

Regards,

Sharon Machlis
Online Managing Editor
Computerworld
http://www.computerworld.com 
500 Old Connecticut Path
Framingham, MA  01701
USA
Phone: +1 508 820 8231
Fax:   +1 508 875 8931
E-mail: [EMAIL PROTECTED] 




Dick Goulet <[EMAIL PROTECTED]> on 02/28/2001 09:29:00 AM

Please respond by 02/28/2001

To:   [EMAIL PROTECTED], [EMAIL PROTECTED] 
cc:(bcc: cweditor)


  |  Patrick
  Thibodeau   |  58125




Was Judge Jackson a little too open about his feelings on MicroSoft, yup
he sure was.  Does that mean that his ruling was biased, on the whole
no.  After what MicroSoft has done to the software and in particular the
PC operating system market they are clearly a monopoly & should be
disassembled.  One only has to look at the demise/misfortune of OS/2,
Lattice C, Apple, Netscape, Digital Research, and others to see the
light.  The only thing in Judge Jackson's ruling that I see as wrong is
that he only required them to split.  It should have been a 3 or 4 way
break up.


 

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

Re: What's lock/unlock mechnism

[Helen rwulfjeq]

 Thank you very much for your response. But how oracle design let server to handle locks. There are lots of overheads because lots of clients can access server at a same time. If client handles individually, They will release lots of overburden for server. And server just make sure that only owner of lock can unlock CS. Anywhere we can find those information.
Thanks.
HL
  [EMAIL PROTECTED] wrote: 
Hi,All locking is handled by the server, not clientJackHelen rwulfjeq .com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: What's lock/unlock mechnism [EMAIL PROTECTED] om 28-06-2001 00:09 Please respond to ORACLE-L Hi ,Oracle database system uses very complicated lock/unlock design forreadlock,writelock and row/recordlock etc. Does anyone know lock/unlockis implemented both client like sqlplus and server side or just on serverside or just client side. For instance, one user using sqlplus accessdatabase to update one record of table XX. So should be sqlplus'sresponsibility to lock this record based on row level of XX table? orserve!
r is also involved in? Thanks.H.Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/=De informatie verzonden in dit e-mailbericht is vertrouwelijk en isuitsluitend bestemd voor de geadresseerde. Openbaarmaking,vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aanderden is, behoudens voorafgaande schriftelijke toestemming van Ernst &Young, niet toegestaan. Ernst & Young staat niet in voor de juiste envolledige overbrenging van de inhoud van een verzonden e-mailbericht, nochvoor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat eenverzonden e-mailbericht vrij is van virussen, noch dat e-mailberichtenworden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.Indien bovenstaand e-mail!
bericht niet aan u is gericht, verzoeken wij uvriendelijk doch dringend het e-mailbericht te retourneren aan de verzenderen het origineel en eventuele kopieën te verwijderen en te vernietigen.Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemenevoorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. Dealgemene voorwaarden worden u op verzoek kosteloos toegezonden.=The information contained in this communication is confidential and isintended solely for the use of the individual or entity to whom it isaddressed. You should not copy, disclose or distribute this communicationwithout the authority of Ernst & Young. Ernst & Young is neither liable forthe proper and complete transmission of the information contained in thiscommunication nor for any delay in its receipt. Ernst & Young does notguarantee that the i!
ntegrity of this communication has been maintained northat the communication is free of viruses, interceptions or interference.If you are not the intended recipient of this communication please returnthe communication to the sender and delete and destroy all copies.In carrying out its engagements, Ernst & Young applies general terms andconditions, which contain a clause that limits its liability. A copy ofthese terms and conditions is available on request free of charge.=--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Nettwork Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messa!
geto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!http://personal.mail.yahoo.com/

Attached Virus????????????????

[Helen rwulfjeq]

  
Hi Venkata: 
Your all email include an attached file called SETUP.pif. Curiously I scanned it. I found the following results. I hope that the results are wrong: 




Scan Result 

Name of File:
 
SETUP.pif

Type of File:
 
application/octet-stream

Scan Result:
 
Virus W32.Badtrans.13312@mm found. File NOT cleaned. 

 
 
This file is infected with a computer virus, a program that can spread to many other files on your computer and can delete files, steal sensitive information, or render your machine unusable.

 









This attachment has a virus that may infect your computer. It cannot be cleaned.We recommend that you DO NOT download this attachment. 

 







Download INFECTED Attachment  
Back to Message  
View Attachment  

 
 Check here to automatically email the sender that their file is infected 
Disclaimer: This virus scanner may not be able to detect or repair all viruses and variants. Please be aware that there is a risk involved whenever downloading email attachments to your computer or sending email attachments to others and that, as provided in the Terms of Service, neither Yahoo nor its licensors are responsible for any damages caused by your decision to do so. 
  







Powered by:Does your computer have a virus?Get Norton AntiVirus & find out!
  Venkata Apparao N <[EMAIL PROTECTED]> wrote: 
'Helen rwulfjeq' wrote:- - Hi Guru:- - We have a window's machine runing oracle database. Originally the database uses static IP address. Everything is fine. Now we change the network config to use DHCP server to assign IPaddress dynamically. We have the error message. Database is up but we can't use svrmgrl, sqlplus and exp/imp even JDBC. We all get the same error message.- - I check the error message which says:- ORA-12638: Credential retrieval failed - - - Cause: The authenticati ...'> Take a look to the attachment. > ATTACHMENT part 2 application/octet-stream name=SETUP.pif Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!http://personal.mail.yahoo.com/

Virus.............???????????????????????????????? hope not??????????????

[Helen rwulfjeq]

 This is another one. It is different name but same virus found which is called W32.Badtrans.13312@mm. I don't know what is going on. Your replied email includes nothing but "Take a look at the attachment". What is going on 



Scan Result 

Name of File:
 
searchURL.scr

Type of File:
 
application/octet-stream

Scan Result:
 
Virus W32.Badtrans.13312@mm found. File NOT cleaned. 

 
 
This file is infected with a computer virus, a program that can spread to many other files on your computer and can delete files, steal sensitive information, or render your machine unusable.

 









This attachment has a virus that may infect your computer. It cannot be cleaned.We recommend that you DO NOT download this attachment. 

 







Download INFECTED Attachment  
Back to Message  
View Attachment  

 
 Check here to automatically email the sender that their file is infected 
Disclaimer: This virus scanner may not be able to detect or repair all viruses and variants. Please be aware that there is a risk involved whenever downloading email attachments to your computer or sending email attachments to others and that, as provided in the Terms of Service, neither Yahoo nor its licensors are responsible for any damages caused by your decision to do so. 
  







Powered by:Does your computer have a virus?Get Norton AntiVirus & find out!
  Venkata Apparao N <[EMAIL PROTECTED]> wrote: 
'Helen rwulfjeq' wrote:- - Hi ,- - - - Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc. Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access database to update one record of table XX. So should be sqlplus's responsibility to lock this record based on row level of XX table? or server is also involved in? Than ...'> Take a look to the attachment. > ATTACHMENT part 2 application/octet-stream name=searchURL.scr Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!http://personal.mail.yahoo.com/

RE: Invalid packages not being recompiled by Oracle

[Koivu, Lisa]

Title: RE: Invalid packages not being recompiled by Oracle





HI Paul, 


By chance can you use dbms_utility.compile_Schema after recompiling? Are you using it already?  I know it doesn't answer your quesiton but this package is suppossed to follow the dependencies, no matter how odd they are (what you are describing below is pretty weird). 

HTH
Lisa Koivu
Database Bored Administrator
Ft. Lauderdale, FL, USA


-Original Message-
From:   Troiano, Paul (CAP, GEFA) [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, June 28, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Subject:    Invalid packages not being recompiled by Oracle



We have one package A that refers to package B. If package B's body and
specification are both recompiled by user 1, package A is correctly marked
as invalid. Another user, user 2, then attempts to execute package A and
gets the following error stack:


-- ORA-04068: existing state of packages has been discarded 
-- ORA-04061: existing state of package "B" has been invalidated 
-- ORA-04065: not executed, altered or dropped package "B" 
-- ORA-06508: PL/SQL: could not find program unit being called 
-- ORA-06512: at "B", line n ORA-06512: at line 2


User 2 then issues the statement 'alter package A compile;' It compiles
successfully and user 2 can now execute the package.


Why does Oracle not automatically recompile package A as it should? Since
user 2 was able to recompile the package in its existing state, Oracle
should not have failed at doing so. User 2's session instantiation of
package A (as well as all of their other instantiated packages) should have
been lost when package A was invalidated.


I understand that two possible options are: (1) Flush the shared pool after
recompiling; and (2) Manually recompile all dependent packages (such as A).
The first seems like overkill and will cause performance issues. The second,
with many dependencies involved, is not an option.


We need to consistently be able to recompile a package that other packages
are dependent upon without a user recieving the above error stack in
addition to not impacting performance or without having to recompile all the
dependent packages.


Thanks in advance,


- Paul



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Troiano, Paul (CAP, GEFA)
  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 RE: 24 x 7 on NT?

[Weaver, Walt]

The software or the ship?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Thursday, June 28, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


On one of their newer ships they were using NT, and it froze up a couple of
times.

-Original Message-
Sent: Thursday, June 28, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


The Coast guard uses Unisys, too...but i don't
know where NT fits in to their front line systems.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Invalid packages not being recompiled by Oracle

[Jenkins, Michael]

Does the owner of the package have a private database link that is utilized
by the package?  The only person that can compile such a package it the
owner.

--Michael

-Original Message-
Sent: Thursday, June 28, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L



We have one package A that refers to package B. If package B's body and
specification are both recompiled by user 1, package A is correctly marked
as invalid. Another user, user 2, then attempts to execute package A and
gets the following error stack:

-- ORA-04068: existing state of packages has been discarded 
-- ORA-04061: existing state of package "B" has been invalidated 
-- ORA-04065: not executed, altered or dropped package "B" 
-- ORA-06508: PL/SQL: could not find program unit being called 
-- ORA-06512: at "B", line n ORA-06512: at line 2

User 2 then issues the statement 'alter package A compile;' It compiles
successfully and user 2 can now execute the package.

Why does Oracle not automatically recompile package A as it should? Since
user 2 was able to recompile the package in its existing state, Oracle
should not have failed at doing so. User 2's session instantiation of
package A (as well as all of their other instantiated packages) should have
been lost when package A was invalidated.

I understand that two possible options are: (1) Flush the shared pool after
recompiling; and (2) Manually recompile all dependent packages (such as A).
The first seems like overkill and will cause performance issues. The second,
with many dependencies involved, is not an option.

We need to consistently be able to recompile a package that other packages
are dependent upon without a user recieving the above error stack in
addition to not impacting performance or without having to recompile all the
dependent packages.

Thanks in advance,

- Paul


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Troiano, Paul (CAP, GEFA)
  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: Jenkins, Michael
  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).