date:20010709


Andrea Oracle wrote:
> 
> Hi, I have a simply SP, which dose an update when
> criteria matches.  It takes 34 IN paramters, if the
> service_location_id matches what's in the table, then
> update other 33 columns.  It's 815 on Sun 5.6.
> 
> When I execute it in sqlplus, it works fine.  But the
> programmer told me that he called it using a wrap
> written in C++, and got error:
> 
> [SERVERERROR] ORA-06513: PL/SQL: index for PL/SQL
> table out of range for host language array.
> 
> The wrap is used to run all the sp/functions, and
> works very well, except this one.
> 
> Attached is the procedure.

 Removed by the mailing list server.

> 
> Any idea? Thank you.
> 
> Andrea

 You cannot bind an array with more than 32K (or about) elements (using
a two-byte index).
It must be the reason for your error.
-- 
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: db-links question


"Hillman, Alex" wrote:
> 
> If I query table in the remote database using database link does user in the
> remote database which is referenced in the database link  create session in
> the remote database and if not could somebody explain how remote query is
> executed.
> 
> Alex Hillman
> 
> P.S. I know that I could try it myself but I am layzy (sp?) and tired
> (fighting with Ross for access to printing presses :-) )

Ir does. A DB link is nothing else than a named connection.
-- 
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: callout listener and external procedure issue


"Kempf, Reed" wrote:
> 
> Hello gurus,
> 
> I have written a plsql package which incorporates an external C procedure
> and therefore utilizes a callout listener and am having problems with the
> callout listener losing connection in the middle of my program
> 
> Has anyone out there had any sort of similar problems using an external
> procedure and a callout listener and if so is there a patch or workaround
> for this.
> 
> Here is my listener.ora file:
> 
> # LISTENER.ORA Network Configuration File:
> /opt/oracle/product/8.1.7/network/admin/listener.ora
> # Generated by Oracle configuration tools.
> 
> LISTENER_1 =
>   (DESCRIPTION_LIST =
> (DESCRIPTION =
>   (ADDRESS_LIST =
> (ADDRESS =
>(PROTOCOL = TCP)
>(HOST = weaklink)
>(PORT = 1521))
>   )
> )
>   )
> 
> CALLOUT =
>   (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL=IPC)
> (KEY=EXTPROC)
> )
>   )
> 
> SID_LIST_LISTENER_1 =
>   (SID_LIST =
> (SID_DESC =
> (SID_NAME = WEAKLINK)
> (ORACLE_HOME = /opt/oracle/product/8.1.7)
> )
>   )
> 
> SID_LIST_CALLOUT =
>   (SID_LIST =
> (SID_DESC =
> (SID_NAME = CALLOUT)
> (ORACLE_HOME = /opt/oracle/product/8.1.7)
> (PROGRAM = /opt/oracle/product/8.1.7/bin/extproc)
> )
>   )
> 
> Reed
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kempf, Reed
>   INET: [EMAIL PROTECTED]
> 

Reed,

   Don't know how it works in your case but remember that external
procedures are dynamically loaded. If you are using static variables,
they may be reset anytime. The reason may be that your proc is flushed
out of memory, then called back.
-- 
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: How to execute Unix Command/program within a pl/sql block.

Seema Singh wrote:
> 
> Hi
> How to execute unix command in PL/SQL ?
> Thanks in advance.
> -Seema

You can't. The nearest you can get is to write a daemon program which
waits for commands on a (dbms) pipe, executes them (popen(),
while(fgets()) {}, pclose() in C) and feeds the output back to the pipe.
Needless to say, it can be a serious security gap if you do not screen
the commands, since you are likely to execute them with the privileges
of the user under which the said program is run.
Many moons ago, there used to be something named 'flex' developed by
Oracle consultants and freely available on the web which was more or
less doing that. It may or may not still be around. I have had a look at
it after having developed my own (in Pro*Fortran and under VMS, nothing
stops me - no pipe, but a /OUTPUT=... was appended to the command and I
was reading and sending back the ouput file) and I can tell you that
Flex was unnecessarily complicated. To make simple seems very difficult
to many people.

-- 
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:db-links question


Alex,

This is one of those questions that gets a "depends" answer.

1) If you've specified a username to use on the remote server in the create
database link command then that's the account that starts a session.
2) If your using Oracle Names with it's db_link capability (namely you don't
have them defined in the database) then the user specified there runs the
session.

3) Your user account, with the same password, on the remote server runs the
session.

Dick Goulet

Reply Separator
Author: "Hillman; Alex" <[EMAIL PROTECTED]>
Date:   7/9/2001 1:05 PM

If I query table in the remote database using database link does user in the
remote database which is referenced in the database link  create session in
the remote database and if not could somebody explain how remote query is
executed.

Alex Hillman

P.S. I know that I could try it myself but I am layzy (sp?) and tired
(fighting with Ross for access to printing presses :-) )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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).

gzip does not want to work with files > 2G


I have Solaris 5.8 angzip does not want to work with files > 2G - tells that
file is too large. Anybody has any idea why?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: db-links question

2001-07-09 Thread Henry Poras


Yes, it creates a session. If you want to do a(n) SQL trace, you can do a
SELECT 'x' FROM dual@remote_site, find the session at the remote site and
turn on the trace, then run your next query. 

Henry

-Original Message-
Sent: Monday, July 09, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L


If I query table in the remote database using database link does user in the
remote database which is referenced in the database link  create session in
the remote database and if not could somebody explain how remote query is
executed.

Alex Hillman

P.S. I know that I could try it myself but I am layzy (sp?) and tired
(fighting with Ross for access to printing presses :-) )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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 mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sizing a new server

Title: RE: Sizing a new server





Yea no Sh*t!  I am beginning to miss the E10K I used to work on... now I have to talk fast and push buttons to even get a little 1-cpu dec as1000 box outfitted with hardware and software.  Boy have times changed 

No, I'm almost going to suggest I go to this meeting with management on this one.  I'll go to bat for a budget with hard numbers I believe in.  Gosh, I may have to brush up on my political skills :P

HA.  I'm beginning to sound like a director.  OH GAWD, NOoooOOOoo!






-Original Message-
From:   Sakthi , Raj [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 09, 2001 4:41 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Sizing a new server


Lisa ,
If you ever find a damagement which gives you what you
want just because "thats what you wanted"...let me
know . I would sell my soul to get in there ;) .
You have to manipulate the figures to show that you
want a particulat kinda machine . It is sorta like
reverse engineering ! You decide the machine you want
and work out the result figures accordingly . Of
course they have to be atleast slightly true you
don't want them to go and do a simple search and find
out the facts ...do you..??!! ;)
Cheers ,
RS
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Thanks Kimberly, 
> 
> I wish it was that way.  I have to justify my
> request with hard numbers or
> they are going to laugh at me when I say, "Because
> that's what I want".  :)
> They don't yet know how I'd react to that, it would
> be a knee-jerk type of
> reaction involving creative expletives...  not
> pretty.  
> 
> Good for you.  At least you have some real hardware
> and true HA.  I wish I
> did 
> 
> Lisa
> 
> 
> > -Original Message-
> > From:   Kimberly Smith
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, July 09, 2001 12:51 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:    RE: Sizing a new server
> > 
> > Get the biggest, kick ass server they will let you
> buy.  If your site is
> > anything like mine they just keep asking for more
> and more databases.  So
> > no matter what I have now I know its not enough. 
> I am really happy with
> > the nice new N-class HP cluster I have sitting
> next door running Service
> > Guard.  I am also getting a A-class database
> cluster for some important
> > but not fab critical databases.  Now if I can only
> get ride of the 5
> > K-class database servers.  Its kind of like when
> you go from a fast to a
> > slow PC.  Drives me crazy.  Not that there are
> issues with performance
> > from the databases.  It would only be me, while
> playing (which of course
> > means working) on the server, that would notice.
> > 
> >     -Original Message-
> >     From: Koivu, Lisa
> [mailto:[EMAIL PROTECTED]]
> >     Sent: Monday, July 09, 2001 8:30 AM
> >     To: Multiple recipients of list ORACLE-L
> >     Subject: Sizing a new server
> >     
> >     
> > 
> >     Good morning everyone, 
> > 
> >     Lucky me, I get to choose the size of the server
> this company should
> > consider purchasing.  I have been poking around on
> the net for any
> > guidelines - I can make guesses based upon my gut
> feel and how strapped
> > the current unix server is, but I want to be able
> to back this up with
> > hard numbers.  This is for a dw application.
> > 
> >     Can anyone point me to a website, book, or
> anything in particular
> > that can help me justify sizing a machine?  It's
> so fun working for a
> > company that doesn't have a sysadmin on staff...  
> > 
> >     Thanks 
> > 
> >     Lisa Koivu 
> >     Oracle Data Bored Administrator 
> >     Ft. Lauderdale, FL, USA 
> >     954-935-4117 
> > 
> >     The information in the electronic mail message is
> Cendant
> > confidential and may be legally privileged, it is
> intended solely for the
> > addressee(s) access to this internet electronic
> mail message by anyone
> > else is unauthorized. If you are not the intended
> recipient, any
> > disclosure, copying, distribution or any action
> taken or omitted to be
> > taken in reliance on it is prohibited and may be
> unlawful.
> > 
> >     The sender believes that this E-mail and any
> attachments were free
> > of any virus, worm, Trojan horse, and/or malicious
> code when sent. This
> > message and its attachments could have been
> infected during transmission.
> > By reading the message and opening any
> attachments, the recipient accepts
> > full responsibility for taking protective and
> remedial action about
> > viruses and other defects. Cendant Corporation or
> Affiliates are not
> > liable for any loss or damage arising in any way
> from this message or its
> > attachments. 
> > 
> > 
> 



__
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: Sakthi , Raj
  INET: [EMAIL PROTECTED]


Fat City

help: ORA-06513 ???

2001-07-09 Thread Andrea Oracle


Hi, I have a simply SP, which dose an update when
criteria matches.  It takes 34 IN paramters, if the
service_location_id matches what's in the table, then
update other 33 columns.  It's 815 on Sun 5.6.

When I execute it in sqlplus, it works fine.  But the
programmer told me that he called it using a wrap
written in C++, and got error:

[SERVERERROR] ORA-06513: PL/SQL: index for PL/SQL
table out of range for host language array.

The wrap is used to run all the sp/functions, and
works very well, except this one.

Attached is the procedure.

Any idea? Thank you.

Andrea


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
 LP_IVUPDSVCLOC_00.PRC

OT - get together for list participants in DC area


There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston Oracle
building. Details on www.maop.org  I am doing presentation about LMT,
temporary tablespaces and Global Temporary tables( very rude sel promo :-)).
I think it can be good opportunity to meet. After that we can go to get
couple of beers etc. I do not know that area very well, so any suggestions
welcome.

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

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

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

Standby DB & Veritas Cluster Server/Replicator

2001-07-09 Thread Janardhana Babu

Title: Standby DB & Veritas Cluster Server/Replicator

Dear List,
I need to implement the standby database for the Txn. Proc. Prod. system. I have a few doubts. If the failure/disaster happens to prod DB, and can't open the DB, then How to transfer the contents of online logs to standby database? My logs would switch once every hour, and so, I would lose atleast one hour worth of data if I need to activate the standby database. Is there any solution for this?

My second question would be: Temporary network failures are quite common here. We use Veritas Netbackup to backup using RMAN. Archived logs would be deleted after the backup as the archived logs quickly fill up the diskspace. How to keep atleast one copy of the archived logs on a seperate bigger disk permanently, atleast one week without being deleted by RMAN backup script. I tried defining LOG_ARCHIVE_DEST_3 as optional location in init.ora. But these files are also being deleted by RMAN backup script along with Mandatory archived logs. We would like RMAN backup script to delete the Archived logs from Mandatory location after the backups are done, but at the same time retain the Optional location archived logs. Is there any way to do this? Restoring from tape would be time consuming and so looking for a solution to retain one copy of the Archived logs on disk.

My third question would be: Is anyone using Veritas Volume Replicator or Veritas Cluster Server or similar product to recover the DB until the last transaction without production DB downtime, in case of failover/disaster? Iam thinking of this product, but not sure this would solve the Automatic Recovery problem until last transaction with no prod. down time.

Any help would be appreciated.
Thanks,
-- Janardhana Babu

RE: How to execute Unix Command/program within a pl/sql block.

Title: RE: How to execute Unix Command/program within a pl/sql block.





HOST [your command]




-Original Message-
From:   Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 09, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L
Subject:    How to execute Unix Command/program within a pl/sql block.


Hi
How to execute unix command in PL/SQL ?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


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


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

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

RE: Sizing a new server

2001-07-09 Thread Kimberly Smith


Lisa, I actually wanted the Superdome.  I settled.  Start big,
settle big but not as big.

-Original Message-
Sent: Monday, July 09, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


Lisa ,
If you ever find a damagement which gives you what you
want just because "thats what you wanted"...let me
know . I would sell my soul to get in there ;) .
You have to manipulate the figures to show that you
want a particulat kinda machine . It is sorta like
reverse engineering ! You decide the machine you want
and work out the result figures accordingly . Of
course they have to be atleast slightly true you
don't want them to go and do a simple search and find
out the facts ...do you..??!! ;)
Cheers ,
RS
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Thanks Kimberly, 
> 
> I wish it was that way.  I have to justify my
> request with hard numbers or
> they are going to laugh at me when I say, "Because
> that's what I want".  :)
> They don't yet know how I'd react to that, it would
> be a knee-jerk type of
> reaction involving creative expletives...  not
> pretty.  
> 
> Good for you.  At least you have some real hardware
> and true HA.  I wish I
> did 
> 
> Lisa
> 
> 
> > -Original Message-
> > From:   Kimberly Smith
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, July 09, 2001 12:51 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Sizing a new server
> > 
> > Get the biggest, kick ass server they will let you
> buy.  If your site is
> > anything like mine they just keep asking for more
> and more databases.  So
> > no matter what I have now I know its not enough. 
> I am really happy with
> > the nice new N-class HP cluster I have sitting
> next door running Service
> > Guard.  I am also getting a A-class database
> cluster for some important
> > but not fab critical databases.  Now if I can only
> get ride of the 5
> > K-class database servers.  Its kind of like when
> you go from a fast to a
> > slow PC.  Drives me crazy.  Not that there are
> issues with performance
> > from the databases.  It would only be me, while
> playing (which of course
> > means working) on the server, that would notice.
> > 
> > -Original Message-
> > From: Koivu, Lisa
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 09, 2001 8:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Sizing a new server
> > 
> > 
> > 
> > Good morning everyone, 
> > 
> > Lucky me, I get to choose the size of the server
> this company should
> > consider purchasing.  I have been poking around on
> the net for any
> > guidelines - I can make guesses based upon my gut
> feel and how strapped
> > the current unix server is, but I want to be able
> to back this up with
> > hard numbers.  This is for a dw application.
> > 
> > Can anyone point me to a website, book, or
> anything in particular
> > that can help me justify sizing a machine?  It's
> so fun working for a
> > company that doesn't have a sysadmin on staff...  
> > 
> > Thanks 
> > 
> > Lisa Koivu 
> > Oracle Data Bored Administrator 
> > Ft. Lauderdale, FL, USA 
> > 954-935-4117 
> > 
> > The information in the electronic mail message is
> Cendant
> > confidential and may be legally privileged, it is
> intended solely for the
> > addressee(s) access to this internet electronic
> mail message by anyone
> > else is unauthorized. If you are not the intended
> recipient, any
> > disclosure, copying, distribution or any action
> taken or omitted to be
> > taken in reliance on it is prohibited and may be
> unlawful.
> > 
> > The sender believes that this E-mail and any
> attachments were free
> > of any virus, worm, Trojan horse, and/or malicious
> code when sent. This
> > message and its attachments could have been
> infected during transmission.
> > By reading the message and opening any
> attachments, the recipient accepts
> > full responsibility for taking protective and
> remedial action about
> > viruses and other defects. Cendant Corporation or
> Affiliates are not
> > liable for any loss or damage arising in any way
> from this message or its
> > attachments. 
> > 
> > 
> 


__
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: Sakthi , Raj
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle support phone number


Thanks to everybody who replied.

Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L


Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database Links standards

2001-07-09 Thread Henry Poras

Title: 



 
-Original Message-From: Henry Poras Sent: 
Monday, July 09, 2001 4:52 PMTo: 
'[EMAIL PROTECTED]'Subject: RE: Database Links 
standards
Here is our stuff. Some of this arose because for a long time 
each application team worked as an independent entity.Up to this 
point, most of our database links have been private (owned by a particular 
schema) and connected via a given user/password determined during the creation 
of the link. I would like to move to public database links without embedded 
usernames and passwords. This will entail slightly more administration on the 
remote database (creating a user) but allow greater security and 
flexibility.The difficulties with database links as we have been using 
them are· Private database 
links are an administrative nightmare (for exports, compiling objects, 
.)· The user defined in the 
link often was the schema owner of most objects in the remote database. The 
security of the remote database was thus dependent on the security of the local 
database.· If the remote 
database needs to change the user password, there is no good way to know which 
applications and database links will be affected.Points 2 and 3 can be 
avoided by creating a new user on the remote database, but since all that is 
needed when creating the link is a single entry in the local database, this is 
often not done. (The phone call can be "can you tell me the username and 
password on your database?" "sure")The advantages with the newer method 
are· Better communication 
between the local and remote databases is 
necessary· The remote 
database will need to create a user to match the username on the local database. 
Thus it can easily control the rights assigned to this user. The remote database 
is in control of its own security. The username chosen should reflect the source 
application which will help in times of password changes.We no longer have 
to worry about private database links.
HTH
Henry-Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, 
July 06, 2001 4:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
Database Links standardsWe came up with the below standards with 
respect to  database links (heavilyused in our 
environment).   The result has been a billion complaints byour 
developers, stating that the standards are unnecessarily complex.  
I'mcurious as to what others might think, if they *are* indeed too 
complex.Also what kind of naming/adminstrative standards that other shops 
employ.1. To access remote data across a DB LINK, the   
standard implementation consists of four pieces:a) A private database link 
owned by the schema owner of the table   objects being 
accessed.  The CONNECT TO and IDENTIFIED BY clauses are   
required - Naming Standard:  {remote 
schema}_{database name}b) A standard PUBLIC SYNONYM created for the remote 
table being   accessed across the link.   - Naming 
Standard: {remote schema}_{remote table}.  The purpose of 
this synonym is both to allow portability and also 
to provide documentation of the remote 
connection.c) A VIEW created as a SELECT * from the PUBLIC SYNONYM above 
(1.b).  - Naming Standard: {remote 
table}_VWd) A PUBLIC SYNONYM on the VIEW above(1.c.)   - 
Naming Standard: {remote table}Thanks,Jeff T[EMAIL PROTECTED]

RE: Oracle support phone number

2001-07-09 Thread Yuval Arnon

Title: RE: Oracle support phone number





1-407-240-8900


-Original Message-
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle support phone number



Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.


Alex Hillman


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 support phone number


Which Country?? 

Within USA try 1-800-555-1212 or 1-800-223-1711 

- Kirti 

> -Original Message-
> From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 3:05 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle support phone number
> 
> Could somebody give me support 800 or long dist. phone number. I know that
> I
> need to log itar first but this is a damagement request and I cannot find
> mine.
> 
> Alex Hillman
> 
> 
-- 
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).

Re: Oracle support phone number

2001-07-09 Thread Sakthi , Raj


1-407-240-8900
OR
1-800-223-1711
Cheers,
RS
--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> Could somebody give me support 800 or long dist.
> phone number. I know that I
> need to log itar first but this is a damagement
> request and I cannot find
> mine.
> 
> Alex Hillman
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: Sakthi , Raj
  INET: [EMAIL PROTECTED]

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

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

RE: Sizing a new server

2001-07-09 Thread Sakthi , Raj


Lisa ,
If you ever find a damagement which gives you what you
want just because "thats what you wanted"...let me
know . I would sell my soul to get in there ;) .
You have to manipulate the figures to show that you
want a particulat kinda machine . It is sorta like
reverse engineering ! You decide the machine you want
and work out the result figures accordingly . Of
course they have to be atleast slightly true you
don't want them to go and do a simple search and find
out the facts ...do you..??!! ;)
Cheers ,
RS
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Thanks Kimberly, 
> 
> I wish it was that way.  I have to justify my
> request with hard numbers or
> they are going to laugh at me when I say, "Because
> that's what I want".  :)
> They don't yet know how I'd react to that, it would
> be a knee-jerk type of
> reaction involving creative expletives...  not
> pretty.  
> 
> Good for you.  At least you have some real hardware
> and true HA.  I wish I
> did 
> 
> Lisa
> 
> 
> > -Original Message-
> > From:   Kimberly Smith
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, July 09, 2001 12:51 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Sizing a new server
> > 
> > Get the biggest, kick ass server they will let you
> buy.  If your site is
> > anything like mine they just keep asking for more
> and more databases.  So
> > no matter what I have now I know its not enough. 
> I am really happy with
> > the nice new N-class HP cluster I have sitting
> next door running Service
> > Guard.  I am also getting a A-class database
> cluster for some important
> > but not fab critical databases.  Now if I can only
> get ride of the 5
> > K-class database servers.  Its kind of like when
> you go from a fast to a
> > slow PC.  Drives me crazy.  Not that there are
> issues with performance
> > from the databases.  It would only be me, while
> playing (which of course
> > means working) on the server, that would notice.
> > 
> > -Original Message-
> > From: Koivu, Lisa
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 09, 2001 8:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Sizing a new server
> > 
> > 
> > 
> > Good morning everyone, 
> > 
> > Lucky me, I get to choose the size of the server
> this company should
> > consider purchasing.  I have been poking around on
> the net for any
> > guidelines - I can make guesses based upon my gut
> feel and how strapped
> > the current unix server is, but I want to be able
> to back this up with
> > hard numbers.  This is for a dw application.
> > 
> > Can anyone point me to a website, book, or
> anything in particular
> > that can help me justify sizing a machine?  It's
> so fun working for a
> > company that doesn't have a sysadmin on staff...  
> > 
> > Thanks 
> > 
> > Lisa Koivu 
> > Oracle Data Bored Administrator 
> > Ft. Lauderdale, FL, USA 
> > 954-935-4117 
> > 
> > The information in the electronic mail message is
> Cendant
> > confidential and may be legally privileged, it is
> intended solely for the
> > addressee(s) access to this internet electronic
> mail message by anyone
> > else is unauthorized. If you are not the intended
> recipient, any
> > disclosure, copying, distribution or any action
> taken or omitted to be
> > taken in reliance on it is prohibited and may be
> unlawful.
> > 
> > The sender believes that this E-mail and any
> attachments were free
> > of any virus, worm, Trojan horse, and/or malicious
> code when sent. This
> > message and its attachments could have been
> infected during transmission.
> > By reading the message and opening any
> attachments, the recipient accepts
> > full responsibility for taking protective and
> remedial action about
> > viruses and other defects. Cendant Corporation or
> Affiliates are not
> > liable for any loss or damage arising in any way
> from this message or its
> > attachments. 
> > 
> > 
> 


__
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: Sakthi , Raj
  INET: [EMAIL PROTECTED]

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

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

Re: Corrupt block in DBVERIFY

2001-07-09 Thread Jared . Still




Ron,

Was the database open when you ran dbverify?

If so, run it on the file again and see if it still reports corruption.

I've done this a number of times on an open database. When
a corruption was found, running dbverify a second time would
show that the file was ok.

The only sure way to run dbverify is on a closed database.

Jared



   
   
"Smith, Ron
   
L."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc:   
   
om>  Subject: Corrupt block in DBVERIFY
   
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
07/09/01 09:51 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




I have a corrupt block according to DBVERIFY.  The block is on an index so
I
can rebuild it but I don't know how to find the object with the information
displayed in DBVERIFY.  Can anyone tell me how to find the object?

Thanks!
Ron

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




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

db-links question


If I query table in the remote database using database link does user in the
remote database which is referenced in the database link  create session in
the remote database and if not could somebody explain how remote query is
executed.

Alex Hillman

P.S. I know that I could try it myself but I am layzy (sp?) and tired
(fighting with Ross for access to printing presses :-) )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 support phone number

2001-07-09 Thread Terry Ball


1-800-223-1711

Terry

"Hillman, Alex" wrote:

> Could somebody give me support 800 or long dist. phone number. I know that I
> need to log itar first but this is a damagement request and I cannot find
> mine.
>
> Alex Hillman
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: 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: Oracle support phone number

2001-07-09 Thread Chan, Millie


try this number 1-800-223-1711

Millie Chan
Rutgers, The State University of New Jersey
Administrative Computing Services
65 Davidson Road
Piscataway, NJ 08855
Tel: (732)445-5433
EMAIL: [EMAIL PROTECTED]
 


-Original Message-
Sent: Monday, July 09, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L


Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing)..
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chan, Millie
  INET: [EMAIL PROTECTED]

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

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

How to execute Unix Command/program within a pl/sql block.

2001-07-09 Thread Seema Singh


Hi
How to execute unix command in PL/SQL ?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Re:Oracle support phone number


800-223-1711


Reply Separator
Author: "Hillman; Alex" <[EMAIL PROTECTED]>
Date:   7/9/2001 12:05 PM

Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Keeping up w/list Email

2001-07-09 Thread Mark Leith


Have you tried using multiple conditions under the advanced filter options?

-Original Message-
Alex
Sent: Monday, July 09, 2001 08:22
To: Multiple recipients of list ORACLE-L


Is it possible to search in MS Outlook for something like Solaris and IO and
size?
When I enter solaris io size it gives me everything about solaris. I tried
advanced fieatures but it looks like that there is only OR condution by
default.

Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


I agree, I do exactly the same - though I AutoArchive anything older than 3
days..

Outlook really does rock when you exploit its full potential..

-Original Message-
Sent: Monday, July 09, 2001 04:00
To: Multiple recipients of list ORACLE-L


Liberal use of Outlook filters and AutoArchive. I generally scan the
list of threads each morning, and follow the ones that look interesting,
usually ignore the rest (unless it's a slow day). AutoArchive cleans out
everything more than a week old whether I've read it or not, to an
off-line .PST where I can search it.

I know all the "cool kids" hate Microsoft, but Outlook truly rocks, I'm
never going back to Pine or Netscape.

g


-Original Message-
Sent: Monday, July 09, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L


Not sure how others handle getting behind on mail, but work lately
leaves me precious little time to keep up.  Just spent the better part
of a month clawing back through 6000 odd messages that queued up after a
period  away from the list.

My curiosity lies w/how others handle the situation.  I've always been
reluctant to can the folder contents, as there's always gems hidden in
there somewhere.  Now I'm totally caught up and it's a bloody big
relief.  Gems were there too.  :-)

Anyone find themselves in the same boat from time to time or do you just
click, shift+left mouse and delete em' all?



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: 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: Mark Leith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

callout listener and external procedure issue

2001-07-09 Thread Kempf, Reed


Hello gurus,

I have written a plsql package which incorporates an external C procedure
and therefore utilizes a callout listener and am having problems with the
callout listener losing connection in the middle of my program

Has anyone out there had any sort of similar problems using an external
procedure and a callout listener and if so is there a patch or workaround
for this.

Here is my listener.ora file:

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = 
   (PROTOCOL = TCP)
   (HOST = weaklink)
   (PORT = 1521))
  )
)
  )

CALLOUT =
  (ADDRESS_LIST =
(ADDRESS = 
(PROTOCOL=IPC)
(KEY=EXTPROC)
)
  )

SID_LIST_LISTENER_1 =
  (SID_LIST =
(SID_DESC =
(SID_NAME = WEAKLINK)
(ORACLE_HOME = /opt/oracle/product/8.1.7)
)
  )

SID_LIST_CALLOUT =
  (SID_LIST =
(SID_DESC =
(SID_NAME = CALLOUT)
(ORACLE_HOME = /opt/oracle/product/8.1.7)
(PROGRAM = /opt/oracle/product/8.1.7/bin/extproc)
)
  )

Reed 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 support phone number

2001-07-09 Thread William Beilstein


1-800-223-1711 . Please be aware that this number will require you to enter your CSI 
number and it will only work for those people who have a gold or silver support 
contract.

>>> [EMAIL PROTECTED] 07/09/01 04:05PM >>>
Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: William Beilstein
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 support phone number

2001-07-09 Thread Jamadagni, Rajendra


Alex,

My recent experience with iTAR was horrendous  
I got a reply within 10 minutes  where is this world heading to 

btw 800 223 1711

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*1

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

*1

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 support phone number

2001-07-09 Thread Jonathan Gennick


Hello Alex,

The number I have, which I haven't used in a lng time,
and which consequently may no longer be good (dial it and
check) is: 800.223.1711.

Best regards,

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

Monday, July 09, 2001, 4:05:26 PM, you wrote:
HA> Could somebody give me support 800 or long dist. phone number. I know that I
HA> need to log itar first but this is a damagement request and I cannot find
HA> mine.

-- 
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: Oracle support phone number

2001-07-09 Thread Mohammad Rafiq

Phone 800 223 1711

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 09 Jul 2001 12:05:26 -0800

Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:Performance/Optimization/Monitoring Tools

2001-07-09 Thread Seema Singh


You can visit www.newworldapps.com web site.They are providing DB-ASSURE 
which is a service and I think it will meet your purpose.New world apps 
service is very good in Database base monitoring,performance tuning etc.



>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re:Performance/Optimization/Monitoring Tools
>Date: Mon, 09 Jul 2001 11:01:18 -0800
>
>Mike,
>
> In the case of CA, you had either steer clear of them or have some 
>pretty
>DEEP pockets.  All of their tools are being integrated into their Jasmine
>infrastructure that supposedly allows their tools to "talk" to each other
>seamlessly.  The problem is that Jasmine is EXPENSIVE and each tool has 
>it's
>share added on for the integration.  BTW: I just saw this morning that CA 
>was
>"breaking up their tools into modules" so that they were most cost 
>competitive
>in the midrange and small IT shops.  That capability was what Jasmine was
>suppose to buy for them 3 years ago.  Wonder how much they added on to 
>break the
>tools back up again???
>
>Dick Goulet
>
>PS: If you get the idea that I enjoy CA bashing, your right.  Right next to
>MicroSlop bashing.
>
>Reply Separator
>Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]>
>Date:   7/9/2001 9:05 AM
>
>DBA's:
>
>We're looking at tools for monitoring and tuning our databases.  Our
>primary applications are data warehouse, data marts, document control,
>help desk, and laboratory management.  (We also have SAP but they have
>their own tool set).
>
>Anybody have any experience/recommendations/stay-away-froms for stuff from
>vendors like BMC, Quest, CA, etc.?
>
>Thanks,
>Mike
>
>---
>===
>Michael P. Vergara  | I've got a PBS mind in an MTV world
>Oracle DBA  |
>Guidant Corporation |
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Vergara, Michael (TEM)
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Oracle support phone number


Could somebody give me support 800 or long dist. phone number. I know that I
need to log itar first but this is a damagement request and I cannot find
mine.

Alex Hillman

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Corrupt block in DBVERIFY

2001-07-09 Thread Mohammad Rafiq


Besides there must be some trace file indication in alertSID.log for such
index corruption. If you see that trace file you will find object_id and on 
the basis of that you can check it from dba_objects...save definition of 
index,drop it and recreate it. Recompile all other objects became invalid 
due index drop.

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 09 Jul 2001 10:41:45 -0800

I think you can run an "analyze index validate structure" on all the indexes
in the tablespace associated with that datafile.  Once you identify the
corrupted index(es), you can drop/recreate them.

Jim


 > I have a corrupt block according to DBVERIFY.  The block is on an index 
so
I
 > can rebuild it but I don't know how to find the object with the
information
 > displayed in DBVERIFY.  Can anyone tell me how to find the object?
 >
 > Thanks!
 > Ron
 >
 > --
 > 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).
 >
 >


--
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:RE: Book/Website for SQL, PL/SQL ,Oracle questions/proble


Try http://www.revealnet.com/Pipelines/pipelines.htm as well.

Dick Goulet

Reply Separator
Author: Norwood Bradly A <[EMAIL PROTECTED]>
Date:   7/9/2001 11:07 AM

www.cramsession.brainbuzz.com/cramsession/oracle should be a useful
information site, Dharminder.

-Original Message-
Sent: Monday, July 09, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL, PL/SQL I am looking for this information so that the a newcomer to
Oracle can enhance his/her skill in oracle by solving these
problems/questions. I already know one such book Oracle PL/SQL Programming
Developer's Workbook. 
Thanks in advance.

Dharminder Kumar




This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal. Unless otherwise stated,
opinions expressed in this e-mail are those of the author and are not
endorsed by the author's employer.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Norwood Bradly A
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Keeping up w/list Email


Is it possible to search in MS Outlook for something like Solaris and IO and
size?
When I enter solaris io size it gives me everything about solaris. I tried
advanced fieatures but it looks like that there is only OR condution by
default.

Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


I agree, I do exactly the same - though I AutoArchive anything older than 3
days..

Outlook really does rock when you exploit its full potential..

-Original Message-
Sent: Monday, July 09, 2001 04:00
To: Multiple recipients of list ORACLE-L


Liberal use of Outlook filters and AutoArchive. I generally scan the
list of threads each morning, and follow the ones that look interesting,
usually ignore the rest (unless it's a slow day). AutoArchive cleans out
everything more than a week old whether I've read it or not, to an
off-line .PST where I can search it.

I know all the "cool kids" hate Microsoft, but Outlook truly rocks, I'm
never going back to Pine or Netscape.

g


-Original Message-
Sent: Monday, July 09, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L


Not sure how others handle getting behind on mail, but work lately
leaves me precious little time to keep up.  Just spent the better part
of a month clawing back through 6000 odd messages that queued up after a
period  away from the list.

My curiosity lies w/how others handle the situation.  I've always been
reluctant to can the folder contents, as there's always gems hidden in
there somewhere.  Now I'm totally caught up and it's a bloody big
relief.  Gems were there too.  :-)

Anyone find themselves in the same boat from time to time or do you just
click, shift+left mouse and delete em' all?



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: 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: Mark Leith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:Performance/Optimization/Monitoring Tools


For those of you who maybe interested:

Kumar: CA to organize products into four brands

At CA World, Computer Associates President and CEO Sanjay Kumar outlined the
software vendor's plan to refocus on six core segments divided into four branded
product lines.

http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62061_NLTam%2C00.html
-- 
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: Sizing a new server


Hi Lisa,
 You may want to take a look at a paper #112 at Craig Shallahamer's site
http://www.orapub.com, titled "The Ratio Modeling Technique: Quickly
Performing Low Confidence Capacity Predictions Using Ratio Modeling". It has
recently been updated. It would give you some ideas to generate those
numbers and/or ask for more information that would help generate those
numbers.

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 1:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Sizing a new server
> 
> Thanks Kimberly, 
> 
> I wish it was that way.  I have to justify my request with hard numbers or
> they are going to laugh at me when I say, "Because that's what I want".
> :)  They don't yet know how I'd react to that, it would be a knee-jerk
> type of reaction involving creative expletives...  not pretty.  
> 
> Good for you.  At least you have some real hardware and true HA.  I wish I
> did 
> 
> Lisa 
> 
> 
> -Original Message- 
> From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]] 
> Sent:   Monday, July 09, 2001 12:51 PM 
> To: Multiple recipients of list ORACLE-L 
> Subject:RE: Sizing a new server 
> 
> Get the biggest, kick ass server they will let you buy.  If your site is
> anything like mine they just keep asking for more and more databases.  So
> no matter what I have now I know its not enough.  I am really happy with
> the nice new N-class HP cluster I have sitting next door running Service
> Guard.  I am also getting a A-class database cluster for some important
> but not fab critical databases.  Now if I can only get ride of the 5
> K-class database servers.  Its kind of like when you go from a fast to a
> slow PC.  Drives me crazy.  Not that there are issues with performance
> from the databases.  It would only be me, while playing (which of course
> means working) on the server, that would notice.
> 
>   -Original Message-
>   From: Koivu, Lisa [ ]
>   Sent: Monday, July 09, 2001 8:30 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Sizing a new server
>   
>   
> 
>   Good morning everyone, 
> 
>   Lucky me, I get to choose the size of the server this company should
> consider purchasing.  I have been poking around on the net for any
> guidelines - I can make guesses based upon my gut feel and how strapped
> the current unix server is, but I want to be able to back this up with
> hard numbers.  This is for a dw application.
> 
>   Can anyone point me to a website, book, or anything in particular
> that can help me justify sizing a machine?  It's so fun working for a
> company that doesn't have a sysadmin on staff...  
> 
>   Thanks 
> 
>   Lisa Koivu
>   Oracle Data Bored Administrator
>   Ft. Lauderdale, FL, USA
>   954-935-4117 
> 
> 
> 
> 
-- 
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).

RE: Book/Website for SQL, PL/SQL ,Oracle questions/problems.

2001-07-09 Thread Norwood Bradly A


www.cramsession.brainbuzz.com/cramsession/oracle should be a useful
information site, Dharminder.

-Original Message-
Sent: Monday, July 09, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL, PL/SQL I am looking for this information so that the a newcomer to
Oracle can enhance his/her skill in oracle by solving these
problems/questions. I already know one such book Oracle PL/SQL Programming
Developer's Workbook. 
Thanks in advance.

Dharminder Kumar




This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal. Unless otherwise stated,
opinions expressed in this e-mail are those of the author and are not
endorsed by the author's employer.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Norwood Bradly 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:Performance/Optimization/Monitoring Tools


Mike,

In the case of CA, you had either steer clear of them or have some pretty
DEEP pockets.  All of their tools are being integrated into their Jasmine
infrastructure that supposedly allows their tools to "talk" to each other
seamlessly.  The problem is that Jasmine is EXPENSIVE and each tool has it's
share added on for the integration.  BTW: I just saw this morning that CA was
"breaking up their tools into modules" so that they were most cost competitive
in the midrange and small IT shops.  That capability was what Jasmine was
suppose to buy for them 3 years ago.  Wonder how much they added on to break the
tools back up again???

Dick Goulet

PS: If you get the idea that I enjoy CA bashing, your right.  Right next to
MicroSlop bashing.

Reply Separator
Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]>
Date:   7/9/2001 9:05 AM

DBA's:

We're looking at tools for monitoring and tuning our databases.  Our
primary applications are data warehouse, data marts, document control,
help desk, and laboratory management.  (We also have SAP but they have
their own tool set).

Anybody have any experience/recommendations/stay-away-froms for stuff from
vendors like BMC, Quest, CA, etc.?

Thanks,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Corrupt block in DBVERIFY

2001-07-09 Thread Jim Hawkins


I think you can run an "analyze index validate structure" on all the indexes 
in the tablespace associated with that datafile.  Once you identify the 
corrupted index(es), you can drop/recreate them.

Jim


> I have a corrupt block according to DBVERIFY.  The block is on an index so 
I
> can rebuild it but I don't know how to find the object with the 
information
> displayed in DBVERIFY.  Can anyone tell me how to find the object?
> 
> Thanks!
> Ron
> 
> -- 
> 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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Corrupt block in DBVERIFY

2001-07-09 Thread Jim Hawkins


I think you can run an "analyze index validate structure" on all the indexes 
in the tablespace associated with that datafile.  Once you identify the 
corrupted index(es), you can drop/recreate them.

Jim


> I have a corrupt block according to DBVERIFY.  The block is on an index so 
I
> can rebuild it but I don't know how to find the object with the 
information
> displayed in DBVERIFY.  Can anyone tell me how to find the object?
> 
> Thanks!
> Ron
> 
> -- 
> 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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sizing a new server

Title: RE: Sizing a new server





Thanks Kimberly, 


I wish it was that way.  I have to justify my request with hard numbers or they are going to laugh at me when I say, "Because that's what I want".  :)  They don't yet know how I'd react to that, it would be a knee-jerk type of reaction involving creative expletives...  not pretty.  

Good for you.  At least you have some real hardware and true HA.  I wish I did 


Lisa



-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 09, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Sizing a new server


Get the biggest, kick ass server they will let you buy.  If your site is anything like mine they just keep asking for more and more databases.  So no matter what I have now I know its not enough.  I am really happy with the nice new N-class HP cluster I have sitting next door running Service Guard.  I am also getting a A-class database cluster for some important but not fab critical databases.  Now if I can only get ride of the 5 K-class database servers.  Its kind of like when you go from a fast to a slow PC.  Drives me crazy.  Not that there are issues with performance from the databases.  It would only be me, while playing (which of course means working) on the server, that would notice.

-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L
Subject: Sizing a new server




Good morning everyone, 


Lucky me, I get to choose the size of the server this company should consider purchasing.  I have been poking around on the net for any guidelines - I can make guesses based upon my gut feel and how strapped the current unix server is, but I want to be able to back this up with hard numbers.  This is for a dw application.

Can anyone point me to a website, book, or anything in particular that can help me justify sizing a machine?  It's so fun working for a company that doesn't have a sysadmin on staff...  

Thanks 


Lisa Koivu
Oracle Data Bored Administrator
Ft. Lauderdale, FL, USA
954-935-4117 


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.

RE: Corrupt block in DBVERIFY


Ron,
 I have not done this myself yet...but had searched for it in the past... 
 If DBVERIFY is reporting Database Addresses (DBA) as corrupt, then you will
have to convert those to file# and block# and from there you can query the
DBA_EXTENTS view to get the object name. 
 There is a Note #113005.1 on Metalink that lists a script to convert DBA to
file# and block#. Give it a try and let me know if that works. 

 Hope this helps.

 Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:51 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Corrupt block in DBVERIFY
> 
> I have a corrupt block according to DBVERIFY.  The block is on an index so
> I
> can rebuild it but I don't know how to find the object with the
> information
> displayed in DBVERIFY.  Can anyone tell me how to find the object?
> 
> Thanks!
> Ron
> 
> -- 
> 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).
-- 
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).

RE: Sizing a new server

Title: RE: Sizing a new server





That's the Guy Hammond I remember from a couple of years ago.  Very useful posts with a bit of humor attached :)


Thanks Guy!
Lisa


-Original Message-
From:   Guy Hammond [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Sizing a new server


Hi Lisa,
 
Pick your favorite vendor and ask 'em if they've got anything like this:
 

 
If it's going to be a big purchase, most vendors will send someone over to take a look too. I remember the good 'ol days when you could call up a DEC sales rep and tell him you wanted to by so many VUPs (VAX Units of Performance). There were tables and formulae you could use to work up how many VUPs you needed to run your application, so you just ordered like that, and took whatever kit they sent you... kinda like walking into a diner and just saying "I'm very hungry, just give me some food!".

 
SGI used to have a policy that if they'd sized a system for you and it wouldn't deliver the transactions/sec that you were expecting, they'd upgrade your equipment for free until it did. Unfortunately, SGI now means "soon going insolvent" :0(

 
Completely off topic, but I read once that the army of the former Soviet Empire used to size battle groups using tables and formulae too. They could plug in variables for the strength of the enemy, the terrain, the weather etc and their method would tell them how many of which sorts of battalions they'd need. Maybe it was like Lee's index calculation - they'd only get one-fifth of the tanks they needed! :0)

 
HTH,
 
g
 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Sizing a new server




Good morning everyone, 


Lucky me, I get to choose the size of the server this company should consider purchasing.  I have been poking around on the net for any guidelines - I can make guesses based upon my gut feel and how strapped the current unix server is, but I want to be able to back this up with hard numbers.  This is for a dw application.

Can anyone point me to a website, book, or anything in particular that can help me justify sizing a machine?  It's so fun working for a company that doesn't have a sysadmin on staff...  

Thanks 


Lisa Koivu
Oracle Data Bored Administrator
Ft. Lauderdale, FL, USA
954-935-4117

RE: PX Idle Wait?

2001-07-09 Thread Jon Walthour




Tom:

It's a wait that indicates that the Parallel Query slave is waiting
for something to do. You can ignore it.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- "Terrian, Tom" <[EMAIL PROTECTED]> wrote:
>> After looking at the top waits in my databases, I
>> see "PX Idle Wait" pop up a
>> lot.  Does anyone know what this wait means?
>> 
>> Tom
>> 
>> Tom Terrian
>> Oracle DBA
>> WPAFB - DAASC
>> [EMAIL PROTECTED]
>> 937-656-3844 
>> 
>> -- 
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.com
>> -- 
>> Author: Terrian, Tom
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- (858) 538-5051  FAX:
>> (858) 538-5051
>> San Diego, California-- Public Internet
>> access / Mailing Lists
>>
>
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (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: marsy mahmud
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be 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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Performance/Optimization/Monitoring Tools

2001-07-09 Thread Grabowy, Chris


I have no real product experiences to share with you.  Just offering to add
another name to your list.  

www.dbdoctor.net  They contaced me after they had read my white paper about
database monitoring.  They sell a service, not a product.  Basically they
have software that collects data/stats about your databases.  From this data
they generate reports.  One of the reports is a DBA to-do list of things
that need to be fixed/tweaked.  Check'em out.  

If, by chance, you do sign up with them then please let me know what you
think of there service.

Thanks.

Chris
"May Oracle be with you...always"

-Original Message-
Sent: Monday, July 09, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L


DBA's:

We're looking at tools for monitoring and tuning our databases.  Our
primary applications are data warehouse, data marts, document control,
help desk, and laboratory management.  (We also have SAP but they have
their own tool set).

Anybody have any experience/recommendations/stay-away-froms for stuff from
vendors like BMC, Quest, CA, etc.?

Thanks,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

Re: DBMS_JOB

2001-07-09 Thread Mitchell


 Thanks Jack. It is working now after commit.

Mitchell

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 4:00 AM


>
> Hi,
>
>
> Did you do a commit after you submitted the job?
>
>
> Jack
>
>
>
> "Yadav,
> Shailesh"  To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]   cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
> ate.ny.us> Subject: RE: DBMS_JOB
> Sent by:
> [EMAIL PROTECTED]
>
>
> 06-07-2001 22:20
> Please respond
> to ORACLE-L
>
>
>
>
>
> Mitchell,
>
>   What did you specify for next_date? Try to set it to something like a
> second after you setup the job.. It should work and you should not have to
> execute a new job...
>   I think JOB_QUEUE_PROCESSES is the maximum number of jobs that can run
in
> parallel and JOB_QUEUE_INTERVAL is the seconds after which the processes
> wake up to execute any job.
>
> Shailesh
>
> -Original Message-
> Sent: Friday, July 06, 2001 2:42 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear DBAs
>
> I have submitted a job to run at a time but never  go. I had to send
> dbms_job.run(jobno) and then the job will run at defined interval.
>
> My question is
> 1.  I have to exec dbms_job.run(jobno) everytime to init the the new job.
> 2.  What is real meaning for JOB_QUEUE_PROCESSES and  JOB_QUEUE_INTERVAL
at
> initdb.ora
>
> Mitchell
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mitchell
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Yadav, Shailesh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> =
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de
verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable
for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carryi

Book/Website for SQL, PL/SQL ,Oracle questions/problems.

2001-07-09 Thread Kumar, Dharminder


Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL, PL/SQL I am looking for this information so that the a newcomer to
Oracle can enhance his/her skill in oracle by solving these
problems/questions. I already know one such book Oracle PL/SQL Programming
Developer's Workbook. 
Thanks in advance.

Dharminder Kumar




This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal. Unless otherwise stated,
opinions expressed in this e-mail are those of the author and are not
endorsed by the author's employer.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Global Temp Tables and Indexes


Hi Novicedba, 
 There is a Note # 65973.1 on Metalink. It explains in detail how sort
extent pool works. Rephrasing portions of it to include in this e-mail would
not do any good to understand it clearly. 
 As far as my analogy of 'create table' with initial extent goes, it's just
to illustrate that when you create a table with an initial extent set to a
certain size, that much space is allocated to the table right away, but it
does not contain any data. Whereas, with GTT such allocation of space does
not take place until data is inserted into the GTT. Please refer to Note #
93756.1 for detail information on GTT. 

 You may post any specific questions you may have after you review these
notes. If you must address them to me, please send them to my personal
e-mail address. As a follow up, I will try to respond. Thanks. 

 HTH,
 
 Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: novicedba [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 2:15 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Global Temp Tables and Indexes
> 
> hi kirti,
>   will you please tell me some more about extent pool and how 'create
> table'
> with initial extent works.
> Can you please guide me to the part of the manual or any link which would
> enlighten me
> 
> coz
> I am a
> novice
> Oracle Certifiable DBBS
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 10:30 AM
> 
> 
> > Bruce,
> >  When the 1st row is inserted into GTT, Oracle will acquire the temp
> segment
> > in user's temporary tablespace and that will be reflected in
> v$sort_usage.
> > However, it will continue to hold the table's data in the PGA of the
> session
> > within the sort areas rather than in the data base buffer cache. When
> > sort_area_size worth of data is collected, it will be written to the
> already
> > acquired temp segment using the extent pool algorithm. Compare this to
> how
> > 'create table' with initial extent works, where a table segment is
> created
> > first, to be followed by inserts. Only in this case, 1st insert
> operation
> > creates the 'extent' but actual data is inserted at a later stage, if
> > required.
> > Hope this helps.
> >
> > Regards,
> >
> > - Kirti Deshpande
> >   Verizon Information Services
> >http://www.superpages.com
> >
> > > -Original Message-
> > > From: Reardon, Bruce (CALBBAY)
> > > [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wednesday, June 27, 2001 8:30 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Global Temp Tables and Indexes
> > >
> > > Kirti,
> > >
> > > I am running 81712 on NT4 with a 1MB sort_area_size and a 1MB
> > > sort_area_retained_size.
> > >
> > > As soon as I insert 1 row into a 6 column GTT (
> > > VARCHAR2(2),NUMBER(5),NUMBER(5),NUMBER(8),VARCHAR2(1),DATE) I see a
> record
> > > appear in v$sort_usage.
> > > In testing, this the first thing I do as soon as I connect and I do
> not
> > > have
> > > a login script that runs any sorts.
> > >
> > > Why might this be (ie why isn't the row held entirely in the PGA given
> the
> > > 1M sort_area_size)?
> > >
> > > I altered the system's sort_area_size to 10M and reconnected and still
> > > after
> > > inserting just 1 row I see a record in v$sort_usage.
> > > I get the same behaviour regardless of whether the temp tablespace has
> > > temporary or permanent contents.
> > >
> > > Thanks,
> > > Bruce
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, 28 June 2001 11:06
> > >
> > > Jack,
> > >  Those rows will be stored in session's PGA in the sort areas
> > > (sort_area_size). When you insert more rows to fill up sort_area_size,
> you
> > > will see the table using your temporary tablespace. Or you can alter
> your
> > > session to use much smaller sort_area_size. Also, you can check
> > > v$sort_usage view to see how the numbers change as you add to the GTT.
> > >
> > >  Hope this helps,
> > >
> > > - Kirti Deshpande
> > >   Verizon Information Services
> > >http://www.superpages.com
> > >
> > > > -Original Message-
> > > > From: Jack C. Applewhite [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, June 27, 2001 7:01 PM
> > > >
> > > > Hi,
> > > >
> > > > Using Oracle8i 8.1.6...
> > > >
> > > > I've created a Temp table and inserted a couple of rows, but there
> seems
> > > > to
> > > > be no way to verify that it's segment(s) is(are) in the temp
> tablespace
> > > of
> > > > the creating user.  I've looked at every USER*, DBA*, and v$* view I
> can
> > > > find - Tablespace_Name is null in all of them.  I inserted the rows
> > > > because
> > > > I know that the first extent of a temp table is not allocated until
> the
> > > > first insert.
> > > >
> > > > I'd like to see that the segment is where I think it is because I
> want
> > > > another user whose temp t.s. is on another drive to create an index
> on
> > > > that
>

RE: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr


Ken,
   Earlier versions had sqlldr and sqlload as copies of the same code.  I
think sqlload was a link in 8.0.x. Now with 8i it's gone. You can create the
link if you do not wish to change the existing code. We did just that since
Developers did not want to change their scripts. 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Fowler, Kenneth R [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr
> 
> List,
> 
> I am currently working on migrating an application from Oracle 7.3 to
> Oracle
> 8.1.6.2 (This is on Solaris 2.6).  One of the shell scripts makes use of
> sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not
> on
> the 8.1.6.2 server.  On the 7.3 server it looks like there are two
> directory
> entries, one for sqlload and one for sqlldr...
> 
> orapps1 $ ls -al | grep sql
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlldr
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlload
> 
> On the 8.1.6.2 server there is just sqlldr.  I am wondering if the sqlload
> link is something that has been dropped from newer versions? or has
> someone
> manually applied the link to the 7.3 server?
> 
> Thanks,
> Ken
> _
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:[EMAIL PROTECTED]
> 
> 
> 
> LEGAL NOTICE
> Unless expressly stated otherwise, this message is confidential and may be
> privileged. It is intended for the addressee(s) only. Access to this
> E-mail by anyone else is unauthorized. If you are not an addressee, any
> disclosure or copying of the contents of this E-mail or any action taken
> (or not taken) in reliance on it is unauthorized and may be unlawful. If
> you are not an addressee, please inform the sender immediately.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fowler, Kenneth R
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: Sizing a new server

2001-07-09 Thread Kimberly Smith

Title: Sizing a new server



Get 
the biggest, kick ass server they will let you buy.  If your site is 
anything like mine they just keep asking for more and more databases.  So 
no matter what I have now I know its not enough.  I am really happy with 
the nice new N-class HP cluster I have sitting next door running Service 
Guard.  I am also getting a A-class database cluster for some important but 
not fab critical databases.  Now if I can only get ride of the 5 K-class 
database servers.  Its kind of like when you go from a fast to a slow 
PC.  Drives me crazy.  Not that there are issues with performance from 
the databases.  It would only be me, while playing (which of course 
means working) on the server, that would notice.

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 09, 2001 8:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Sizing a new server
  Good morning everyone, 
  Lucky me, I get to choose the size of the 
  server this company should consider purchasing.  I have been poking 
  around on the net for any guidelines - I can make guesses based upon my gut 
  feel and how strapped the current unix server is, but I want to be able to 
  back this up with hard numbers.  This is for a dw application.
  Can anyone point me to a website, book, or 
  anything in particular that can help me justify sizing a machine?  It's 
  so fun working for a company that doesn't have a sysadmin on staff...  
  
  Thanks 
  Lisa Koivu Oracle Data Bored Administrator Ft. Lauderdale, FL, USA 954-935-4117 
  The information in the electronic mail message is 
  Cendant confidential and may be legally privileged, it is intended solely for 
  the addressee(s) access to this internet electronic mail message by anyone 
  else is unauthorized. If you are not the intended recipient, any disclosure, 
  copying, distribution or any action taken or omitted to be taken in reliance 
  on it is prohibited and may be unlawful.
  The sender believes that this E-mail and any 
  attachments were free of any virus, worm, Trojan horse, and/or malicious code 
  when sent. This message and its attachments could have been infected during 
  transmission. By reading the message and opening any attachments, the 
  recipient accepts full responsibility for taking protective and remedial 
  action about viruses and other defects. Cendant Corporation or Affiliates are 
  not liable for any loss or damage arising in any way from this message or its 
  attachments.

OT -- satire on Ellison

2001-07-09 Thread Boivin, Patrice J


http://www.satirewire.com/news/0006/satire-ellison.shtml
 

This is old I think, I remember vaguely last year something about Ellison
making a similar speech at Yale or some other Ivy League school.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

Re: How to improve the performance of "Direct path Write"?

2001-07-09 Thread Johnson Poovathummoottil


We too had a similar problem and thought that we
should do something to make the sorts faster. But
investigating a little deeper found the actual amount
of time waited in direct path read/write  was very
little although there are a number waits attibuted to
direct path read and write while sorting. We also
tried increasing the sort_area_size, but it gave
adverse performance. 
Of the total time spend for the query cpu time was
always above 90 percent and wait time was less than 10
%. we executed the same queries on faster cpu machines
and got better results. Also parallelizing the queries
helped.

--- [EMAIL PROTECTED] wrote:
> How many extents are being written to your temporary
> tablespace?
> You could increase your sort_area_size if you have
> the memory.
> 
> I have seen 1 gig of temp tablespace being chewed up
> reduced to 0 by tuning the sql.
> 
> You may not always realize that your program
> statements invoke a sort. Sorting is performed by
> the following statements:
> 
> In my case I put an index on the columns in the
> order by and that took care of the sorts to disk.
> 
> w CREATE INDEXw   DISTINCT
> w GROUP BYw   ORDER BY
> w INTERSECT   w   MINUS
> w UNION   w   Unindexed table joins
> w Some correlated subqueries
> 
> Depending on your system, you can put your temporary
> files on a Raid 1 layout.
> 
> HTH
> 
> Mike
> [EMAIL PROTECTED]
> On Mon, 09 July 2001, WinterSun_Zhao wrote:
> 
> > 
> > Hi, DBAs:
> >   I find a process occupy about 50% Cpu. I checked
> the wait event, it was waiting for the event of
> "direct path write".
> >   I know it is because it is writing to the
> temporary tablespace. The extent size of the
> temporary tablespace is 5M, it is temporary.
> >   Would you please tell me how to improve the
> performance of "Direct path write"? How to decrease
> its cpu occuption.
> >   Thanks!
> > 
> > WinterSun Zhao
> > Oracle DBA ( 2 yr+)
> > Unix SysAdmin ( 4 yr)
> > [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> > www.pconline.com.cn
> > 
> > 
> > 
> > 
> > 
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> [EMAIL PROTECTED]
> > To subscribe:   send a blank email to
> [EMAIL PROTECTED]
> > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 
> 
>
__
> Get your FREE personalized e-mail at
> http://www.canada.com
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> [EMAIL PROTECTED]
> To subscribe:   send a blank email to
> [EMAIL PROTECTED]
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: UNIX SA

2001-07-09 Thread Richard Ji


docs.sun.com

They have System Administrator's Guide online.



>>> [EMAIL PROTECTED] 07/09/01 11:55AM >>>
Dear list !
I'd like to start getting into some beginner level UNIX (Solaris) system
administration .
I have some knowledge in UNIX  (scripting, basic commands , etc ... -
user/programmer/DBA level , not a sys. admin. level).
Can U please recommend what to start with ?
I prefer free resources on the web over the books i'll have to buy, off
course.
Thanks a lot for your recommendations.
Andrey.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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*LOADER Questions

2001-07-09 Thread Jonathan Gennick


Monday, July 09, 2001, 11:30:20 AM, Ron Smith wrote:
SRL> We are trying to replace a VB program with SQL*Loader.  Two Questions.  The
SRL> input file contains record types.  A type 1 header record contains data that
SRL> must be retained and combined with a type 3 record.  Also, depending on the
SRL> record type the data is loaded into different tables.  Is all this possible
SRL> in SQL*Loader?

SQL*Loader can recognize record types, and can direct data
from the different types of records to different tables.
Retaining data from a type 1 record, and combining it with a
type 3 record, especially multiple type 3 records, is beyond
what SQL*Loader can do. At least, I can't conceive of a way
to do it as I think about it right now.

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: PX Idle Wait?


Those waits indicate that your Parallel Query Slaves are waiting for
'orders' to do something :) 
You can safely ignore these. 

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: marsy mahmud [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:32 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: PX Idle Wait?
> 
> It means you need to take a break and play golf.
> 
> Marsy
> --- "Terrian, Tom" <[EMAIL PROTECTED]> wrote:
> > After looking at the top waits in my databases, I
> > see "PX Idle Wait" pop up a
> > lot.  Does anyone know what this wait means?
> > 
> > Tom
> > 
> > Tom Terrian
> > Oracle DBA
> > WPAFB - DAASC
> > [EMAIL PROTECTED]
> > 937-656-3844 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Terrian, Tom
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
-- 
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).

RE: SQL*LOADER Questions

2001-07-09 Thread Mercadante, Thomas F


Ron,

If it were me, I would use Sql*Loader to load the data into a "loading" db
tables, and then use a PL/SQL script to read that table and process the
records into wherever it is needed.  You can certainly guarantee that the
data will be read in the correct order (by the PL/SQL script) by creating
additional columns in this loading table, and load the data/time, or a
sequence number.

this seems to be the easiest way to do this.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, July 09, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


We are trying to replace a VB program with SQL*Loader.  Two Questions.  The
input file contains record types.  A type 1 header record contains data that
must be retained and combined with a type 3 record.  Also, depending on the
record type the data is loaded into different tables.  Is all this possible
in SQL*Loader?
 
Thanks!
Ron

 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Keeping up w/list Email

2001-07-09 Thread Jack C. Applewhite


Casey,

Keeping up is definitely a problem.  When I have the time, I browse a
sampling of all messages of topics that sound like they might apply to me.
That way I get a little more familiar with posters and sometimes uncover
those "gems" you're talking about.

When I'm pressed for time or returning from a few days away, I'm fairly
ruthless at deleting all messages except those from folks like Steve Adams,
Gaja Vaidyanatha, Jared Still, Rachel Carmichael, and several others.
That's where I find the best "gems".

Also, after a while you realize that you probably won't entirely miss out on
most of the "gems", since those questions will inevitably be asked and
answered again...and again, and again - an endless supply of "newbie" DBAs.
8^)   Moreover, lots of good stuff is more or less permanently posted on
various websites, such as OTN, MetaLink, Steve Adams' Ixora, etc.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Sent: Monday, July 09, 2001 8:20 AM
To: Multiple recipients of list ORACLE-L


Not sure how others handle getting behind on mail, but work lately
leaves me precious little time to keep up.  Just spent the better part
of a month clawing back through 6000 odd messages that queued up after a
period  away from the list.

My curiosity lies w/how others handle the situation.  I've always been
reluctant to can the folder contents, as there's always gems hidden in
there somewhere.  Now I'm totally caught up and it's a bloody big
relief.  Gems were there too.  :-)

Anyone find themselves in the same boat from time to time or do you just
click, shift+left mouse and delete em' all?


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Keeping up w/list Email

2001-07-09 Thread Mark Leith


I agree, I do exactly the same - though I AutoArchive anything older than 3
days..

Outlook really does rock when you exploit its full potential..

-Original Message-
Sent: Monday, July 09, 2001 04:00
To: Multiple recipients of list ORACLE-L


Liberal use of Outlook filters and AutoArchive. I generally scan the
list of threads each morning, and follow the ones that look interesting,
usually ignore the rest (unless it's a slow day). AutoArchive cleans out
everything more than a week old whether I've read it or not, to an
off-line .PST where I can search it.

I know all the "cool kids" hate Microsoft, but Outlook truly rocks, I'm
never going back to Pine or Netscape.

g


-Original Message-
Sent: Monday, July 09, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L


Not sure how others handle getting behind on mail, but work lately
leaves me precious little time to keep up.  Just spent the better part
of a month clawing back through 6000 odd messages that queued up after a
period  away from the list.

My curiosity lies w/how others handle the situation.  I've always been
reluctant to can the folder contents, as there's always gems hidden in
there somewhere.  Now I'm totally caught up and it's a bloody big
relief.  Gems were there too.  :-)

Anyone find themselves in the same boat from time to time or do you just
click, shift+left mouse and delete em' all?



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: 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: Mark Leith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: UNIX SA

2001-07-09 Thread William Beilstein


What UNIX OS are you interested in administering? While many commands are the same, 
there are differences between the various flavors of Unix.

>>> [EMAIL PROTECTED] 07/09/01 11:55AM >>>
Dear list !
I'd like to start getting into some beginner level UNIX (Solaris) system
administration .
I have some knowledge in UNIX  (scripting, basic commands , etc ... -
user/programmer/DBA level , not a sys. admin. level).
Can U please recommend what to start with ?
I prefer free resources on the web over the books i'll have to buy, off
course.
Thanks a lot for your recommendations.
Andrey.

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

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

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

security problem with 8i

2001-07-09 Thread Bill Conner


Hi All,

i am not sure if this has already been posted or not, but..

--29 June 2001  Oracle8i Database Buffer Overflow Vulnerability
Security experts found and disclosed a pair of vulnerabilities in the
standard and enterprise editions of Oracle8i database.  The Transport
Network Substrate (TNS) Listener has a buffer overflow vulnerability;
a flaw in the SQL Net protocol leaves the system vulnerable to
denial-of- service attacks.  Patches are available.

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

-bill

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

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

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

Re: export / import users definition

2001-07-09 Thread Bunyamin K. Karadeniz


look at the script



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 6:45 PM


> Is it possible to Export and Import Users definition including password .
>
> Here we have a production schema where we have created users to access our
> production objects . We are moving production database to another test
> database
> . Now we wants users definition and password also to be moved there ...
> Is there any way to do it. ??
>
> Brajesh Jaiswal
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 Corporate Support
 Problem Repository



1. Prob# 1019554.6  TFTS: SCRIPT TO EXPORT USER DEFINITIONS

Problem ID  : 1019554.6
Affected Platforms  : Generic: not platform specific
Affected Products   : Oracle Server - Enterprise Edition V7
Affected Components : RDBMS V07.XX
Affected Oracle Vsn : V07.XX

Summary:
TFTS: SCRIPT TO EXPORT USER DEFINITIONS

+=+

Circulation:** Available to Customers ** 
Topic:  ** Tales from the Scrypt ** 
Subject:TFTS: SCRIPT TO EXPORT USER DEFINITIONS  
Keywords:
-- 
 
== 
Title: 
== 
 
Export User Definitions 
 
=== 
Disclaimer: 
=== 
 
This script is provided for educational purposes only. It is NOT supported by 
Oracle Support Services.  The script has been tested and appears to work as 
intended.  However, you should always test any script before relying on it. 
 
PROOFREAD THIS SCRIPT PRIOR TO USING IT!  Due to differences in the way text  
editors, email packages and operating systems handle text formatting (i.e. 
spaces, tabs and carriage returns), this script may not be in an executable 
state when you first receive it.  Check over the script to ensure that errors 
of this type are corrected. 
 
 
= 
Abstract: 
= 
 
This script will create a child script to build all the users in the  
database.  It will pull password, QUOTA(s), PROFILE, and defaults for each  
user from the data dictionary.  The child script, create_users.sql, can be run 
with the DBA role or with the  'CREATE USER' system privilege. 
 
 
= 
Requirements: 
= 
 
DBA role 
 
=== 
Script: 
=== 
 
--- cut -- cut -- cut -- 
 
SET ECHO off 
REM NAME:TFSCRUSR 
REM USAGE:"@path/tfscrusr" 
REM -- 
REM REQUIREMENTS: 
REMDBA role 
REM - 
REM PURPOSE: 
REMThis script will in turn create a script to build all the 
REMusers in the database.  This created script, create_users.sql, 
REMcan be run with the DBA role or 'CREATE USER' system privilege. 
REM - 
REM EXAMPLE: 
REMCREATE USER scott 
REMIDENTIFIED BY  VALUES 'F894844C34402B67' 
REMDEFAULT TABLESPACE TOOLS 
REMTEMPORARY TABLESPACE TEMP 
REMQUOTA -1 ON TOOLS 
REMQUOTA -1 ON USERS 
REMPROFILE DEFAULT; 
REM 
REMCREATE USER shaq 
REMIDENTIFIED BY VALUES '3835037579B13ACA' 
REMDEFAULT TABLESPACE USERS 
REMTEMPORARY TABLESPACE TEMP 
REMQUOTA -1 ON USERS 
REMPROFILE DEFAULT; 
REM  
REM - 
REM DISCLAIMER: 
REMThis script is provided for educational purposes only. It is NOT  
REMsupported by Oracle Support Services. 
REMThe script has been tested and appears to work as intended. 
REMYou should always run new scripts on a test instance initially. 
REM -- 
REM Main text of script follows: 
 
 
set verify off; 
set termout off; 
set feedback off; 
set echo off; 
set pagesize 0; 
 
set termout on 
select 'Creating user build script...' from dual; 
set termout off; 
 
create table usr_temp( lineno number, 
  usr_name varchar2(30),text varchar2(80)) 
/ 
 
DECLARE 
 CURSOR usr_cursor IS select username, 
password, 
default_tablespace, 
   temporary_tablespace, 
profile 
   from sys.dba_u

Performance/Optimization/Monitoring Tools

2001-07-09 Thread Vergara, Michael (TEM)


DBA's:

We're looking at tools for monitoring and tuning our databases.  Our
primary applications are data warehouse, data marts, document control,
help desk, and laboratory management.  (We also have SAP but they have
their own tool set).

Anybody have any experience/recommendations/stay-away-froms for stuff from
vendors like BMC, Quest, CA, etc.?

Thanks,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: query prob

2001-07-09 Thread Yadav, Shailesh


Karthik,

  Try CHR(13).. I use it all the time to format text output...

Shailesh

-Original Message-
Sent: Friday, July 06, 2001 11:40 PM
To: Multiple recipients of list ORACLE-L


Not very sure about that but  I think that you can try finding the ascii
value of the enter key (i.e. a newline character) and use this value to
identify the enter operation...but do we have an ascii value for a newline
character ...? any ideas, anyone ?

Regards,
Karthik Mohan


-Original Message-
Sent: Thursday, July 05, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L


thanks a lot..

one more thing...how to get the value of return key using sql..
i mean using gui data is entered and the user used enter key for next line
so how to get that

Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yadav, Shailesh
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Rollback usage

2001-07-09 Thread Mohammad Rafiq


You can try this script also..courtesy this list

set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8) "# of Records"
from v$locked_object a
, dba_objects b
, dba_rollback_segs c
, v$transaction d
, v$session e
where a.object_id = b.object_id
and a.xidusn = c.segment_id
and a.xidusn = d.xidusn
and a.xidslot = d.xidslot
and d.addr = e.taddr
/
Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 06 Jul 2001 09:20:30 -0800

I believe that I got this off of this list a while back...

clear columns
column rbs format A7 heading 'RBS'
column ora_usr format a10
column program format a39
column sid format 
select r.name rbs,
s.sid  SID,
substr(osuser,1,10) os_user,
nvl(s.username, ' -- ') ora_usr,
s.program
from v$lock l, v$session s, v$rollname r
where l.sid = s.sid(+) and
   trunc(l.id1(+)/65536) = r.usn  and
   l.type(+) = 'TX' and
   l.lmode (+) = 6
order by r.name;



Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844


-Original Message-
Sent: Friday, July 06, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L


Hi All,
Does anyone have a script or know of a way to determine which user is
using
which rollback segment?  I had a developer issue a "set transaction" before
she started a migration and I wanted to see if I could make sure that she
was using the proper rollback segment.  Thanks a lot:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).

Corrupt block in DBVERIFY

2001-07-09 Thread Smith, Ron L.


I have a corrupt block according to DBVERIFY.  The block is on an index so I
can rebuild it but I don't know how to find the object with the information
displayed in DBVERIFY.  Can anyone tell me how to find the object?

Thanks!
Ron

-- 
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: Sizing a new server

2001-07-09 Thread Guy Hammond

Title: Sizing a new server



Hi 
Lisa,
 
Pick 
your favorite vendor and ask 'em if they've got anything like 
this:
 
http://www.compaq.com/solutions/enterprise/database-oracle-sizer-download.html
 
If 
it's going to be a big purchase, most vendors will send someone over to take a 
look too. I remember the good 'ol days when you could call up a DEC sales rep 
and tell him you wanted to by so many VUPs (VAX Units of Performance). There 
were tables and formulae you could use to work up how many VUPs you needed to 
run your application, so you just ordered like that, and took whatever kit they 
sent you... kinda like walking into a diner and just saying "I'm very hungry, 
just give 
me some food!".
 
SGI 
used to have a policy that if they'd sized a system for you and it wouldn't 
deliver the transactions/sec that you were expecting, they'd upgrade your 
equipment for free until it did. Unfortunately, SGI now means "soon going 
insolvent" :0(
 
Completely off topic, but I read once that the army of 
the former Soviet Empire used to size battle groups using tables and formulae 
too. They could plug in variables for the strength of the enemy, the terrain, 
the weather etc and their method would tell them how many of which sorts of 
battalions they'd need. Maybe it was like Lee's index calculation - they'd only 
get one-fifth of the tanks they needed! :0)
 
HTH,
 
g
 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 09, 2001 4:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Sizing a new server
  Good morning everyone, 
  Lucky me, I get to choose the size of the 
  server this company should consider purchasing.  I have been poking 
  around on the net for any guidelines - I can make guesses based upon my gut 
  feel and how strapped the current unix server is, but I want to be able to 
  back this up with hard numbers.  This is for a dw application.
  Can anyone point me to a website, book, or 
  anything in particular that can help me justify sizing a machine?  It's 
  so fun working for a company that doesn't have a sysadmin on staff...  
  
  Thanks 
  Lisa Koivu Oracle Data Bored Administrator Ft. Lauderdale, FL, USA 954-935-4117

$ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

2001-07-09 Thread Fowler, Kenneth R


List,

I am currently working on migrating an application from Oracle 7.3 to Oracle
8.1.6.2 (This is on Solaris 2.6).  One of the shell scripts makes use of
sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not on
the 8.1.6.2 server.  On the 7.3 server it looks like there are two directory
entries, one for sqlload and one for sqlldr...

orapps1 $ ls -al | grep sql
-rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlldr
-rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlload

On the 8.1.6.2 server there is just sqlldr.  I am wondering if the sqlload
link is something that has been dropped from newer versions? or has someone
manually applied the link to the 7.3 server?

Thanks,
Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: mailto:[EMAIL PROTECTED]



LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. 
It is intended for the addressee(s) only. Access to this E-mail by anyone else is 
unauthorized. If you are not an addressee, any disclosure or copying of the contents 
of this E-mail or any action taken (or not taken) in reliance on it is unauthorized 
and may be unlawful. If you are not an addressee, please inform the sender immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fowler, Kenneth R
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Keeping up w/list Email

2001-07-09 Thread Luis DeUrioste

I set up a bunch of filters in netscape mail, and created a folder for each
list (Designer, Developer, Java, DBA ) and
a sub folder for each list where I would keep the stuff that I think I will
need.  Inside the folder I sort the mail by subject, so if I'm away for a
couple of days I can just skim through the headers and delete chunks at a
time.

my way

Tavo

Casey Dyke wrote:

> Not sure how others handle getting behind on mail, but work lately
> leaves me precious little time to keep up.  Just spent the better part
> of a month clawing back through 6000 odd messages that queued up after a
> period  away from the list.
>
> My curiosity lies w/how others handle the situation.  I've always been
> reluctant to can the folder contents, as there's always gems hidden in
> there somewhere.  Now I'm totally caught up and it's a bloody big
> relief.  Gems were there too.  :-)
>
> Anyone find themselves in the same boat from time to time or do you just
> click, shift+left mouse and delete em' all?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Casey Dyke
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: PX Idle Wait?

2001-07-09 Thread marsy mahmud


It means you need to take a break and play golf.

Marsy
--- "Terrian, Tom" <[EMAIL PROTECTED]> wrote:
> After looking at the top waits in my databases, I
> see "PX Idle Wait" pop up a
> lot.  Does anyone know what this wait means?
> 
> Tom
> 
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Terrian, Tom
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: marsy mahmud
  INET: [EMAIL PROTECTED]

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

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

Re: export / import users definition

2001-07-09 Thread ASHOKE MANDAL


Take a full export as system user from the source database and import into 
the destination database. In this process all the new schema(users)along 
with their privileges/roles should be loaded into the destination database.

Thanks,
Ashoke


>From: "Oracle DBA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: export / import users definition
>Date: Mon, 09 Jul 2001 07:45:25 -0800
>
>Is it possible to Export and Import Users definition including password .
>
>Here we have a production schema where we have created users to access our
>production objects . We are moving production database to another test
>database
>. Now we wants users definition and password also to be moved there ...
>Is there any way to do it. ??
>
>Brajesh Jaiswal
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: ASHOKE MANDAL
  INET: [EMAIL PROTECTED]

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

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

RE: RE: * Oracle DBA Needed in Phoenix..

2001-07-09 Thread Kimberly Smith

Tell you one thing, if I wasn't here I would be there.  Last job was
in NS.  Came out here on a 4 month TDY a year and a half ago.  Although
I make more then $65000 I would have probably stayed there for that if 
a good enough job as around at the time.

-Original Message-
Sent: Friday, July 06, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L

On July  6, 2001 05:38 pm, [EMAIL PROTECTED] wrote:

> > OH, I've stayed out of this one, but I think a word or two should
> be acceptable.
>
> $75K with minimal relocation may be cheap upfront, but if your
> current salary is $0.00 then this is better, even if the relocation
> $$$ are not what one would expect.  Besides, I started here at $36K
> some 9 years ago & pretty darn soon their going to crack the $100K
> barrier.  So look to the future, even if one must live in the
> present (when one is at the bottom of the barrel, all roads point
> up).

Or come to Nova Scotia - DBA w/ ~5 years experience can expect  
around 65K. Supposedly due to lower cost of living, however, I 
believe it simply has more to do with less demand (there are few 
employers here large enough to warrant a full-time experienced dba - 
most shops are small development shops that have one disk to hold 
Oracle and it's usually running NT). Oh well, got saltwater in my 
veins, so I'll stick around here for a while :)

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

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

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

Re: AUDIT QUESTION

2001-07-09 Thread Rachel Carmichael


nope, auditing won't tell you who did what to which row

you will need triggers, and a table to insert that info into


>From: "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: AUDIT QUESTION
>Date: Mon, 09 Jul 2001 07:15:23 -0800
>
>Hi Gurus,
>
>ORACLE 8.1.7
>I want an auditing which will record update,insert and delete on all 
>tables.
>
>My client wants to see who updated this row,who inserted this row,who 
>deleted this row.
>
>IN Which table  is this information is held?
>HOw can I log this transaction ?
>Can I do it with AUDIT option?
>
>Thank you

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

Sizing a new server