date:20021002


Try this one for DB2.  So do you have to deal with a bunch of RPG programmers for DB2?

www.idug.org 

Dave

-Original Message-
Sent: Tuesday, October 01, 2002 10:03 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I'll be seeing the dark side of the force as I'll be
the DBA on a DB2 UDB project.

Is there a list like this one for DB2 ?
Any links to DB2 stuff ?

I'd be interested in documents showing the
differences/similarities between Oracle and DB2 UDB.

Let's see our bargaining power with our Oracle rep
once DB2 is in our Oracle shop (over 100 instances)




=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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


Have you tried ftp://oracle-ftp.oracle.com/apps/patchsets/PATCHSET_COMPARE_TOOL/ ?
I think it is not using applptch.txt. 

inka

-Original Message-
Sent: Tuesday, October 01, 2002 11:58 PM
To: Multiple recipients of list ORACLE-L


Dear all,
  I have a situation where I need to find out the patches applied on 
different Oracle Application 11i (11.5.5) env. We have two environment PROD 
and TEST. It seems that there are some patches applied to  TEST in the past 
few months. I would like to know what patches are applied on TEST env:
Database stack
Application stack $APPL_TOP
Technology stack (Forms, reports, Jinitiator).

There is neither manual logging system where I can find the patch details 
nor locating  the files applpatch.txt or applptch.txt on the server.

Is there any other way I can easily find out the difference between those 
two instances in respect to patches?

Thanks in advance.
Michael Sesuraj
OCP.




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

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

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

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

RE: Dark side of the force

2002-10-02 Thread paquette stephane


Thanks.

I do not think so as DB2 was chosen because we'll be
implementing Siebel (and Siebel is recommanding DB2).
They're should be 2 DB2 databases, one for Siebel and
one for the staging area as 8 different data sources
will be loaded in Siebel. So I hope RPG won't fit in
;-)


 --- Farnsworth, Dave
[EMAIL PROTECTED] a écrit :  Try this
one for DB2.  So do you have to deal with a
 bunch of RPG programmers for DB2?
 
 www.idug.org 
 
 Dave
 
 -Original Message-
 Sent: Tuesday, October 01, 2002 10:03 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 
 I'll be seeing the dark side of the force as I'll be
 the DBA on a DB2 UDB project.
 
 Is there a list like this one for DB2 ?
 Any links to DB2 stuff ?
 
 I'd be interested in documents showing the
 differences/similarities between Oracle and DB2 UDB.
 
 Let's see our bargaining power with our Oracle rep
 once DB2 is in our Oracle shop (over 100 instances)
 
 
 
 
 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]
 

___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
 en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

doucments about securtiy

2002-10-02 Thread SIM/HAOUHACH


Hi everyone,
I will want documents or bonds of sites  on the security of the  database (
in French if it is possible)
Thank you

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

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

slightly OT: data modelling question

2002-10-02 Thread Antje . Sackwitz


Hi,
I am designing a (data warehouse) system where I would like to get some
hints for the table design.
I have dimensions time, standard_width, category
and dimension hierarchy
hierarchy has 5 levels with each having about 30 attributes
level1 .. level5 identified by ids that are generated by production system
per day via sequence - (8-10 attributes would make up the key, further
systems to add data reference the ids),
between level n and level (n+1) is a n:m-relationship

Then I have
facts type 1 just related hierarchy level5 and time, standard_width,
category
facts type 2 related to time and hierachy - hierarchy dimension is
non-additive
facts type 3 related to time and hierachy,standard_width, category all facts
are additive

Now I am wondering, do I construnct dimension hierarchy as a large dimension
(adding about 2000 records per day).
Or to I normalize the dimension having a table per level?  If second
solution how do I make sure performance for my facts of type 1 is still
acceptable?

The system is to use one of this featureful adhoc-query-tools.
Any tips?

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

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

RE: Dark side of the force

2002-10-02 Thread Grabowy, Chris


Interesting.  My company is also in the process of implementing Siebel.  We are a 
small consulting company, so some of us are still trying to figure this one out.  
Although for us we are using SQL Server (blah) on an IBM box.

Sounds like the Siebel acct execs have been busy.  No wonder it smells around here...

-Original Message-
Sent: Wednesday, October 02, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


Thanks.

I do not think so as DB2 was chosen because we'll be
implementing Siebel (and Siebel is recommanding DB2).
They're should be 2 DB2 databases, one for Siebel and
one for the staging area as 8 different data sources
will be loaded in Siebel. So I hope RPG won't fit in
;-)


 --- Farnsworth, Dave
[EMAIL PROTECTED] a écrit :  Try this
one for DB2.  So do you have to deal with a
 bunch of RPG programmers for DB2?
 
 www.idug.org 
 
 Dave
 
 -Original Message-
 Sent: Tuesday, October 01, 2002 10:03 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 
 I'll be seeing the dark side of the force as I'll be
 the DBA on a DB2 UDB project.
 
 Is there a list like this one for DB2 ?
 Any links to DB2 stuff ?
 
 I'd be interested in documents showing the
 differences/similarities between Oracle and DB2 UDB.
 
 Let's see our bargaining power with our Oracle rep
 once DB2 is in our Oracle shop (over 100 instances)
 
 
 
 
 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]
 

___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
 en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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


That's good cuz RPG IS the dark side, it's evil.

BUWAHAHAHAHAHAHA

-Original Message-
Sent: Wednesday, October 02, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


Thanks.

I do not think so as DB2 was chosen because we'll be
implementing Siebel (and Siebel is recommanding DB2).
They're should be 2 DB2 databases, one for Siebel and
one for the staging area as 8 different data sources
will be loaded in Siebel. So I hope RPG won't fit in
;-)


 --- Farnsworth, Dave
[EMAIL PROTECTED] a écrit :  Try this
one for DB2.  So do you have to deal with a
 bunch of RPG programmers for DB2?
 
 www.idug.org 
 
 Dave
 
 -Original Message-
 Sent: Tuesday, October 01, 2002 10:03 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 
 I'll be seeing the dark side of the force as I'll be
 the DBA on a DB2 UDB project.
 
 Is there a list like this one for DB2 ?
 Any links to DB2 stuff ?
 
 I'd be interested in documents showing the
 differences/similarities between Oracle and DB2 UDB.
 
 Let's see our bargaining power with our Oracle rep
 once DB2 is in our Oracle shop (over 100 instances)
 
 
 
 
 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]
 

___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
 en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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


Well ...
 if you need short reports, look for:

1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o 
8. shared pool memory distribution
9. session contention
10. session memory usage

inka

-Original Message-
Sent: Wednesday, October 02, 2002 7:08 AM
To: Multiple recipients of list ORACLE-L


Thak's Mark

I agreed, but they have gotten an idea to get only couple
most important measurements from db, because they don't want
to have a huge reports with all possible statistics. Very 
understandable, but as You wrote, there isn't any absolutely top ten.

In any case, I have to do this (stupid) list, so give Your best shot,
please.

t.Jorma
Ps. I heard, that Dave Ensor from BMC, has once presented that
kind of list?  

-Original Message-
Sent: 02 October, 2002 12:23
To: Multiple recipients of list ORACLE-L


Jorma,

Performance tuning is a complex subject.  There really isn't a list of
10 things to watch for.  Every system is different.

I would (attempt to) summarize tuning by these five steps:

1.)  Have a capacity/performance target in mind.  If you don't know
where you're going, how will you know if you have gotten there?

2.)  Monitor your response times as load increases.  Can you achieve
your response time target at the specified load?  If so, you're done,
successful test, congratulations.  If not, continue to next step.

3.)  Actively monitor what's going on in the database, while it's
happening.  It's always easier to see it in real time than just looking
at random StatsPack snapshots taken at 5 or 10 or 15 minute intervals. 
(Not that I'm saying StatsPack shouldn't be collected.  I'm just saying
don't rely on StatsPack as your only source of info about the
database.)  The V$ Wait Interface is your friend.  If you're not
familiar with it, go to http://www.hotsos.com/ and get Mogens Norgaard's
paper, Introducing the V$ Wait Interface.  Where is the database
spending it's time?  What's the bottleneck?  If you identify a few
trouble sessions, you may want to dive deeper w/ some 10046 traces at
level 8 on specific sessions.  You almost certainly do NOT want to do
this instance wide.

4.)  Once you have some indication as to what's going on in the
database, you need to see how the system is doing overall.  On most
flavors of *nix, where I'm comfortable, sar (System Activity Reporter)
is an excellent tool.  Use it to determine if you have any systemwide
CPU, memory, or I/O contention.  (Other OSes almost certainly have
similar utilities.)

5.)  Address the biggest bottleneck.  This is where it can't be
summarized in a simple step.  You need to understand the bottleneck, so
that you can understand how to tune it.  If may be latch contention. 
Depending on the latch, it could be poorly tuned SQL, or lack of bind
variables, or simple CPU capacity limits, or a whole host of things. 
I/O contention?  Could be anything from poorly designed and/or
configured RAID array to poorly tuned SQL, or who knows what.  Determine
the cause of the biggest bottleneck and minimize or eliminate it.


There you have it, Mark's Simplified Performance Tuning, in five easy
steps! ;-)

-Mark



On Wed, 2002-10-02 at 02:08, [EMAIL PROTECTED] wrote:
 Ave !
 
 I like to hear Your opinion about the most importat
 issues, what should be monitored from the database (8.1.7, SUN) during
 perfomance testing. The purpose in this case, is limit the
 monitoring to concern only about 10 most important ones.
 
 I have difficulties to make my mind to pick up the right ones, so
 if You had to have made similar kind of decisions or have opinions,
 please let me know.
 
 TIA
 Jorma
 -
 Name: Jorma Vuorio  Phone:  +358-9-7180 67759
 Company:  Nokia Business Infrastucture  Fax:+358-9-7180 67465
 Address:  P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND  
 Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043
 -
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

Oracle DBA Needed with Shareplex and Factory Works

2002-10-02 Thread OraStaff


Excellent opportunity with this client company in Bloomington, Minnesota
that needs a Sr.
Oracle DBA to join it's IT staff.

Relocation Assitance is provided.

PLEASE DO NOT send your resume for this position UNLESS you have the skills 
outlined below for this position.

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

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

NO H-1B candidates please.

*Requirements:
-BSCS or related degree.
-Related skills: A heavy internals DBA for a two terabyte data warehouse
mixed with some Unix
 Perl Skills Or a Heavy OLTP DBA to support a 24*7 Factory Works MES
 environment, and upgrade it from 7.3 to 8i/9i.
-Must have competence in Unix operating commands and tools. 
-Experience with techniques for data replication, data movement, data
 loading, data warehousing, and business intelligence tools is required.
-Specific experience with Oracle Advanced Replication (OAR), Quest
 Shareplex replication software, Oracle OEM and RMAN. 
-Experience with Unix operating systems current release for SUN and HP,
Scripting including
 Perl scripts, sockets code and C.
-Must have experience Factory Works
-Must be a U.S. citizen or perm. resident.

Base Salary is up to 80-90K..depending on experience.

or  immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
Please Use Job Code: One/Bloomington/DBA/Mark

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


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

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

RE: how to find out the patch applied on different env.

2002-10-02 Thread Markham, Richard

Title: RE: how to find out the patch applied on different env.





FILENAME adphrept.sql
DESCRIPTION
SQL script that creates a report file showing the patching history
of all patches


also can be used in conjuction with the following SQL, this tends to be more granular:
SELECT * FROM AD_PATCH_DRIVERS
WHERE PATCH_DRIVER_ID IN 
(SELECT PATCH_DRIVER_ID FROM AD_PATCH_RUNS WHERE PATCH_RUN_ID IN 
(SELECT PATCH_RUN_ID FROM AD_PATCH_RUN_BUGS WHERE ORIG_BUG_NUMBER='1' and UPPER(APPLIED_FLAG)='Y'))





-Original Message-
From: sesuraj m [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 11:58 PM
To: Multiple recipients of list ORACLE-L
Subject: how to find out the patch applied on different env.



Dear all,
 I have a situation where I need to find out the patches applied on 
different Oracle Application 11i (11.5.5) env. We have two environment PROD 
and TEST. It seems that there are some patches applied to TEST in the past 
few months. I would like to know what patches are applied on TEST env:
Database stack
Application stack $APPL_TOP
Technology stack (Forms, reports, Jinitiator).


There is neither manual logging system where I can find the patch details 
nor locating the files applpatch.txt or applptch.txt on the server.


Is there any other way I can easily find out the difference between those 
two instances in respect to patches?


Thanks in advance.
Michael Sesuraj
OCP.





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


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


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

logon trigger

2002-10-02 Thread George Leonard (ZA)


Hi guys

I am trying to create the following trigger.

The user in question is logging in using siebel application and siebel does
not allow multiple SQL statements during login so we through this might
solve the problem. My problem now is though, the set rollback works but the
alter session statements does not seem to want to work.

The server needs to be in RBO since this is the only mode supported by
siebel.

Help appreciated.

create or replace trigger smload.logon after logon  on database
begin
SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
Alter session enable parallel query;
Alter session set SORT_AREA_SIZE = 10485760;
Alter session set OPTIMIZER_MODE = choose;
end;
/

George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:[EMAIL PROTECTED]
Web:   http://www.didata.co.za
 
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed  Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!



***

This message contains information intended solely for the addressee,
which is confidential or private in nature and subject to legal privilege.
If you are not the intended recipient, you may not peruse, use,
disseminate, distribute or copy this message or any file attached to this
message. Any such unauthorised use is prohibited and may be unlawful. If
you have received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
original message from your machine. 
 
Furthermore, the information contained in this message, and any
attachments thereto, is for information purposes only and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of Dimension Data (South Africa) (Proprietary) Limited
or its subsidiaries and associated companies (Dimension Data). Dimension
Data therefore does not accept liability for any claims, loss or damages
of whatsoever nature, arising as a result of the reliance on such
information by anyone. 
 
Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information transmitted electronically and to preserve the
confidentiality thereof, Dimension Data accepts no liability or
responsibility whatsoever if information or data is, for whatsoever
reason, incorrect, corrupted or does not reach its intended destination. 

*


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Leonard (ZA)
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread Igor Neyman


Alter session ... is not DML, so I think you need to use dynamic SQL:

create or replace trigger smload.logon after logon  on database
begin
SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
EXECUTE IMMEDIATE Alter session enable parallel query;
EXECUTE IMMEDIATE Alter session set SORT_AREA_SIZE = 10485760;
EXECUTE IMMEDIATE Alter session set OPTIMIZER_MODE = choose;
end;
/


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 11:23 AM


 Hi guys

 I am trying to create the following trigger.

 The user in question is logging in using siebel application and siebel
does
 not allow multiple SQL statements during login so we through this might
 solve the problem. My problem now is though, the set rollback works but
the
 alter session statements does not seem to want to work.

 The server needs to be in RBO since this is the only mode supported by
 siebel.

 Help appreciated.

 create or replace trigger smload.logon after logon  on database
 begin
 SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
 Alter session enable parallel query;
 Alter session set SORT_AREA_SIZE = 10485760;
 Alter session set OPTIMIZER_MODE = choose;
 end;
 /

 George
 
 George Leonard
 Oracle Database Administrator
 Dimension Data (Pty) Ltd
 (Reg. No. 1987/006597/07)
 Tel: (+27 11) 575 0573
 Fax: (+27 11) 576 0573
 E-mail:[EMAIL PROTECTED]
 Web:   http://www.didata.co.za

 You Have The Obligation to Inform One Honestly of the risk, And As a
Person
 You Are Committed to Educate Yourself to the Total Risk In Any Activity!
 Once Informed  Totally Aware of the Risk, Every Fool Has the Right to
Kill
 or Injure Themselves as They See Fit!





***

 This message contains information intended solely for the addressee,
 which is confidential or private in nature and subject to legal privilege.
 If you are not the intended recipient, you may not peruse, use,
 disseminate, distribute or copy this message or any file attached to this
 message. Any such unauthorised use is prohibited and may be unlawful. If
 you have received this message in error, please notify the sender
 immediately by e-mail, facsimile or telephone and thereafter delete the
 original message from your machine.

 Furthermore, the information contained in this message, and any
 attachments thereto, is for information purposes only and may contain the
 personal views and opinions of the author, which are not necessarily the
 views and opinions of Dimension Data (South Africa) (Proprietary) Limited
 or its subsidiaries and associated companies (Dimension Data). Dimension
 Data therefore does not accept liability for any claims, loss or damages
 of whatsoever nature, arising as a result of the reliance on such
 information by anyone.

 Whilst all reasonable steps are taken to ensure the accuracy and
 integrity of information transmitted electronically and to preserve the
 confidentiality thereof, Dimension Data accepts no liability or
 responsibility whatsoever if information or data is, for whatsoever
 reason, incorrect, corrupted or does not reach its intended destination.



*


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: George Leonard (ZA)
   INET: [EMAIL PROTECTED]

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

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

2002-10-02 Thread JOE TESTA




George here is how we did ours"

create or replace trigger olap1_logon_trigger after logon on 
olap1.schemabegin execute immediate 'alter session set 
optimizer_mode = first_rows';end;/

Customize it to your liking.

Joe

Re: Dark side of the force

2002-10-02 Thread ltiu


I don't get it. Why RPG with DB2? Why not SQL and Java on DB2? Is this 
because of legacy RPG that's why shops still use RPG today? Or is there 
an advantage to using RPG ( Report Program Generator )?

I used to work for this company that couldn't find enough RPG 
programmers, they had to find a few dozen from a different country.

ltiu

Farnsworth, Dave wrote:

That's good cuz RPG IS the dark side, it's evil.

BUWAHAHAHAHAHAHA

-Original Message-
Sent: Wednesday, October 02, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


Thanks.

I do not think so as DB2 was chosen because we'll be
implementing Siebel (and Siebel is recommanding DB2).
They're should be 2 DB2 databases, one for Siebel and
one for the staging area as 8 different data sources
will be loaded in Siebel. So I hope RPG won't fit in
;-)


 --- Farnsworth, Dave
[EMAIL PROTECTED] a écrit :  Try this
one for DB2.  So do you have to deal with a
  

bunch of RPG programmers for DB2?

www.idug.org 

Dave

-Original Message-
Sent: Tuesday, October 01, 2002 10:03 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I'll be seeing the dark side of the force as I'll be
the DBA on a DB2 UDB project.

Is there a list like this one for DB2 ?
Any links to DB2 stuff ?

I'd be interested in documents showing the
differences/similarities between Oracle and DB2 UDB.

Let's see our bargaining power with our Oracle rep
once DB2 is in our Oracle shop (over 100 instances)




=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]




___
  

Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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



-
  

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

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



-
  

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



=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
  



-- 
ltiu
3/4 OCP 9i Eh?


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

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

2002-10-02 Thread paquette stephane


Hi,

Use dynamic SQL (execute imediate).

Also, consider placing your code into a stored proc
called by the trigger.


 --- George Leonard (ZA)
[EMAIL PROTECTED] a écrit :  Hi guys
 
 I am trying to create the following trigger.
 
 The user in question is logging in using siebel
 application and siebel does
 not allow multiple SQL statements during login so we
 through this might
 solve the problem. My problem now is though, the set
 rollback works but the
 alter session statements does not seem to want to
 work.
 
 The server needs to be in RBO since this is the only
 mode supported by
 siebel.
 
 Help appreciated.
 
 create or replace trigger smload.logon after logon 
 on database
 begin
   SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
   Alter session enable parallel query;
   Alter session set SORT_AREA_SIZE = 10485760;
   Alter session set OPTIMIZER_MODE = choose;
 end;
 /
 
 George
 
 George Leonard
 Oracle Database Administrator
 Dimension Data (Pty) Ltd
 (Reg. No. 1987/006597/07)
 Tel: (+27 11) 575 0573
 Fax: (+27 11) 576 0573
 E-mail:[EMAIL PROTECTED]
 Web:   http://www.didata.co.za
  
 You Have The Obligation to Inform One Honestly of
 the risk, And As a Person
 You Are Committed to Educate Yourself to the Total
 Risk In Any Activity!
 Once Informed  Totally Aware of the Risk, Every
 Fool Has the Right to Kill
 or Injure Themselves as They See Fit!
 
 
 

***
 
 This message contains information intended solely
 for the addressee,
 which is confidential or private in nature and
 subject to legal privilege.
 If you are not the intended recipient, you may not
 peruse, use,
 disseminate, distribute or copy this message or any
 file attached to this
 message. Any such unauthorised use is prohibited and
 may be unlawful. If
 you have received this message in error, please
 notify the sender
 immediately by e-mail, facsimile or telephone and
 thereafter delete the
 original message from your machine. 
  
 Furthermore, the information contained in this
 message, and any
 attachments thereto, is for information purposes
 only and may contain the
 personal views and opinions of the author, which are
 not necessarily the
 views and opinions of Dimension Data (South Africa)
 (Proprietary) Limited
 or its subsidiaries and associated companies
 (Dimension Data). Dimension
 Data therefore does not accept liability for any
 claims, loss or damages
 of whatsoever nature, arising as a result of the
 reliance on such
 information by anyone. 
  
 Whilst all reasonable steps are taken to ensure the
 accuracy and
 integrity of information transmitted electronically
 and to preserve the
 confidentiality thereof, Dimension Data accepts no
 liability or
 responsibility whatsoever if information or data is,
 for whatsoever
 reason, incorrect, corrupted or does not reach its
 intended destination. 
 

*
   
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: George Leonard (ZA)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread rao . rao


In my company, we require Oracle D.B.A. to maintain 
development and production Oracle databases.  This is a 
permanent position.  Our compnay is 24 yrs. old company.

Our company is situated on Route 128 in M.A.

We require the candidate urgently. If interested, please 
send your resumes within the next two days to the 
following e-mail: [EMAIL PROTECTED]

Following are the details for the job:

Our environment: Solaris 7 and solaris 8.

Databases versions: 804, 8.1.6.1, 8.1.7.3

OLTP databases and datawarehouse.

Veritas File System.

Middleware: Tuxedo and MQ series

Quest, DataMirror - Replication products

Apps: WebLogic

Following is the skill set for the candidate:

Following are essential requirements for an Oracle DBA.

1. Must have worked as Oracle developer at least 3 years.

2. Must have been working as Oracle DBA at least for the 
last 3 years in a
PRODUCTION environment in 8i. (We don't want development 
DBA's).

3. Must have excellent knowledge in installing Oracle 
software and its
products. Must have installed patches in his earlier job.

4. Thorough knowledge in Backup and Recovery procedures. 
Must be able to
solve scenarios during the interview.

5. Good knowlege in Oracle tuning process. Must be able 
to solve scenarios
during the interview.

4. Must have good knowledge in running various 
statistical packages like
STATSPACK.

5. Excellent knowledge in shell programming and 
understanding of awk and
sed usage.

6. Must be very familiar with Solaris 7 and higher 
versions. Must have
general understanding of tuning/performance processes 
involved on Unix
level. Should be able to give us various scenarious 
he/she faced during
his
career in tuning.

7. Must have good understanding of PL/SQL, SQL.

8. Must be familiar with OMS and its tools.

9. Must have thorough understanding of RAID concepts and 
its use in
Oracle.
And good knowledge on Oracle OFA methodology - -- This 
is must.

10. Must have good knowledge on normalization techniques.

11. Must be familiar with Oracle Standby databases and 
their running. --
This is essential.

12. Good communication skills and team work.

Optional but would have weightage:

1. Oracle 9i knowledge

2. Oracle RAC environment experience.

3. Datawarehous knowledge and issues involved in setting 
up production
datawarehouses

4. Understanding of Veritas

5. Knowledge about design tools like Oracle 
Designer/ERwin

6. Knowledge about Quest

7. Knowledge about DataMirror

8. General understanding of WebLogic

9. Understanding Tuxedo or MQM

10. Knowledge in C programing.


Rao




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

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

SQLLdr help needed

2002-10-02 Thread Rick_Cale


Hi All,

Oracle 8.1.6 WinNT
I have been trying to use sqlldr and I am getting following error

Record 1: Rejected - Error on table INTERVIEW, column COMMENTS.
end of logical record found when reading length of varying length field

Here is sample record and control file.

Any ideas why I get this error. MetaLink says TRAILING NULLCOLS should
correct.  The field it is complaining is second to last field
in input file.

37901|01/01/1970 04:59:10||LDMARCHI|||


LOAD DATA
INFILE 'd:\oracle\admin\tmwktst3\scripts\BDUMPI2.txt'
BADFILE 'd:\oracle\admin\tmwktst3\scripts\INTERVIEW.bad'
insert
INTO TABLE INTERVIEW
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(PROFILE_NO,
INTERVIEW_DATE DATE 'MM/DD/ HH24:MI:SS',
FU_DATE DATE 'MM/DD/',
OPERATOR CHAR,
SOURCE CHAR,
APPEARANCE CHAR,
FAMILY CHAR,
LANGUAGE_SKILLS CHAR,
CAREER_PLANS CHAR,
MALPRACTICE_HIS CHAR,
ECONOMICS1 CHAR,
ECONOMICS2 CHAR,
MET_WITH CHAR,
COMMENTS  varchar(4000)  SUBSTR(:COMMENTS,1,2000),
ROW_PROCESSED)


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

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

Re:logon trigger

2002-10-02 Thread dgoulet


George,

The SET TRANSACTION command, according to the documentation, only lasts
until the next commit/rollback.  That being the case I would not expect it's
duration to be very long.  Also, I am not in favor of assigning a particular
application/session to any specific rollback segment since it has little effect
on overall database performance or capability.  Sure it was applicable in older
versions of Oracle where a rollback segment behaved like a table, but since 7.x
where the optimal parameter came into use I prefer to set all rollback segments
as small, but with the ability to expand as needed.  It has eliminated my need
for large rollback segments and almost eliminated the ORA-01555 errors.

Dick Goulet

Reply Separator
Author: George Leonard (ZA) [EMAIL PROTECTED]
Date:   10/2/2002 7:23 AM

Hi guys

I am trying to create the following trigger.

The user in question is logging in using siebel application and siebel does
not allow multiple SQL statements during login so we through this might
solve the problem. My problem now is though, the set rollback works but the
alter session statements does not seem to want to work.

The server needs to be in RBO since this is the only mode supported by
siebel.

Help appreciated.

create or replace trigger smload.logon after logon  on database
begin
SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
Alter session enable parallel query;
Alter session set SORT_AREA_SIZE = 10485760;
Alter session set OPTIMIZER_MODE = choose;
end;
/

George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:[EMAIL PROTECTED]
Web:   http://www.didata.co.za
 
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed  Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!




***

This message contains information intended solely for the addressee,
which is confidential or private in nature and subject to legal privilege.
If you are not the intended recipient, you may not peruse, use,
disseminate, distribute or copy this message or any file attached to this
message. Any such unauthorised use is prohibited and may be unlawful. If
you have received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
original message from your machine. 
 
Furthermore, the information contained in this message, and any
attachments thereto, is for information purposes only and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of Dimension Data (South Africa) (Proprietary) Limited
or its subsidiaries and associated companies (Dimension Data). Dimension
Data therefore does not accept liability for any claims, loss or damages
of whatsoever nature, arising as a result of the reliance on such
information by anyone. 
 
Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information transmitted electronically and to preserve the
confidentiality thereof, Dimension Data accepts no liability or
responsibility whatsoever if information or data is, for whatsoever
reason, incorrect, corrupted or does not reach its intended destination. 


*


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Leonard (ZA)
  INET: [EMAIL PROTECTED]

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

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

Sample Pro*C code for TAF in 8iOPS/9iRAC

2002-10-02 Thread Hemant K Chitale




Can anyone send me sample Pro*C code depicting how
they've handled TAF in 8iOPS or 9iRAC ?

We've got some application servers running Pro*C programs
which don't seem to able to handle failover. SQLPlus sessions
are failing over to the remaining instance but the Pro*C programs
seem to be hanging, without returning any error, when
a transaction is in-flight  We do know that Insert/Update/Deletes
do not really failover but are wondering how the Pro*C programs
could be written to handle the oracle error on session failover
and resubmit the transaction.


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

2002-10-02 Thread George Leonard (ZA)










Hi all



Ok the trigger has been changed to this, It compiles.



The problem now is that all the objects
that need to be access is owner by the siebel user. I do not want to create
synonyms. The tool being used can not append the siebel schema name in front of
the objects, and it is expecting to log in as siebel.



Any idea why the 'Alter session set
CURRENT_SCHEMA = SIEBEL;' is not changing my current schema. I have tried
executing Alter session set CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at the user_tables
table and it is empty ?



create or replace trigger
olap1_logon_trigger

 after logon on smload.schema

begin

 execute immediate
'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';

 execute immediate
'Alter session enable parallel query;';

 execute immediate
'Alter session set SORT_AREA_SIZE = 10485760;';

 execute
immediate 'Alter session set OPTIMIZER_MODE = choose;';

 execute
immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';



end;

/





George



George
 Leonard

Oracle Database
Administrator

Dimension Data (Pty) Ltd

(Reg. No. 1987/006597/07)

Tel:(+27 11) 575
0573

Fax:(+27 11) 576
0573

E-mail:[EMAIL PROTECTED]

Web:  http://www.didata.co.za



You Have The Obligation
to Inform One Honestly of the risk, And As a Person

You Are Committed to
Educate Yourself to the Total Risk In Any Activity!

Once Informed 
Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure
Themselves as They See Fit!



-Original Message-
From: JOE TESTA
[mailto:[EMAIL PROTECTED]] 
Sent: 02 October 2002 16:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: re: logon trigger





George here is how we did
ours











create or replace trigger
olap1_logon_trigger
 after logon on olap1.schema
begin
 execute immediate 'alter session set optimizer_mode = first_rows';
end;
/











Customize it to your
liking.











Joe













***

This message contains information intended solely for the addressee,
which is confidential or private in nature and subject to legal privilege.
If you are not the intended recipient, you may not peruse, use,
disseminate, distribute or copy this message or any file attached to this
message. Any such unauthorised use is prohibited and may be unlawful. If
you have received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
original message from your machine. 
 
Furthermore, the information contained in this message, and any
attachments thereto, is for information purposes only and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of Dimension Data (South Africa) (Proprietary) Limited
or its subsidiaries and associated companies ("Dimension Data"). Dimension
Data therefore does not accept liability for any claims, loss or damages
of whatsoever nature, arising as a result of the reliance on such
information by anyone. 
 
Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information transmitted electronically and to preserve the
confidentiality thereof, Dimension Data accepts no liability or
responsibility whatsoever if information or data is, for whatsoever
reason, incorrect, corrupted or does not reach its intended destination. 

*

Data modeling question about reference table

2002-10-02 Thread paquette stephane


Hi,

We're discussing on reference table.
One containing everything (using a type) or one per
entity. We'll have a lot of entities.

This is for a staging area where data will be validate
before going in Siebel. In theory, this staging will
become a very big staging for a datarehouse and still
in theory there is no plan yet that that staging will
be available to the users as an ODS.

What do you think ?

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread Gene Sais


lol, i love #1  #2, developer but not a development dba.  good luck in your search, 
quite a few requirements :)

gene

 [EMAIL PROTECTED] 10/02/02 11:50AM 
In my company, we require Oracle D.B.A. to maintain 
development and production Oracle databases.  This is a 
permanent position.  Our compnay is 24 yrs. old company.

Our company is situated on Route 128 in M.A.

We require the candidate urgently. If interested, please 
send your resumes within the next two days to the 
following e-mail: [EMAIL PROTECTED] 

Following are the details for the job:

Our environment: Solaris 7 and solaris 8.

Databases versions: 804, 8.1.6.1, 8.1.7.3

OLTP databases and datawarehouse.

Veritas File System.

Middleware: Tuxedo and MQ series

Quest, DataMirror - Replication products

Apps: WebLogic

Following is the skill set for the candidate:

Following are essential requirements for an Oracle DBA.

1. Must have worked as Oracle developer at least 3 years.

2. Must have been working as Oracle DBA at least for the 
last 3 years in a
PRODUCTION environment in 8i. (We don't want development 
DBA's).

3. Must have excellent knowledge in installing Oracle 
software and its
products. Must have installed patches in his earlier job.

4. Thorough knowledge in Backup and Recovery procedures. 
Must be able to
solve scenarios during the interview.

5. Good knowlege in Oracle tuning process. Must be able 
to solve scenarios
during the interview.

4. Must have good knowledge in running various 
statistical packages like
STATSPACK.

5. Excellent knowledge in shell programming and 
understanding of awk and
sed usage.

6. Must be very familiar with Solaris 7 and higher 
versions. Must have
general understanding of tuning/performance processes 
involved on Unix
level. Should be able to give us various scenarious 
he/she faced during
his
career in tuning.

7. Must have good understanding of PL/SQL, SQL.

8. Must be familiar with OMS and its tools.

9. Must have thorough understanding of RAID concepts and 
its use in
Oracle.
And good knowledge on Oracle OFA methodology - -- This 
is must.

10. Must have good knowledge on normalization techniques.

11. Must be familiar with Oracle Standby databases and 
their running. --
This is essential.

12. Good communication skills and team work.

Optional but would have weightage:

1. Oracle 9i knowledge

2. Oracle RAC environment experience.

3. Datawarehous knowledge and issues involved in setting 
up production
datawarehouses

4. Understanding of Veritas

5. Knowledge about design tools like Oracle 
Designer/ERwin

6. Knowledge about Quest

7. Knowledge about DataMirror

8. General understanding of WebLogic

9. Understanding Tuxedo or MQM

10. Knowledge in C programing.


Rao




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

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

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

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

2002-10-02 Thread ltiu


You know what, this means the people who are hiring does not know what 
they are looking for.

Gene Sais wrote:

lol, i love #1  #2, developer but not a development dba.  good luck in your search, 
quite a few requirements :)

gene

  

[EMAIL PROTECTED] 10/02/02 11:50AM 


In my company, we require Oracle D.B.A. to maintain 
development and production Oracle databases.  This is a 
permanent position.  Our compnay is 24 yrs. old company.

Our company is situated on Route 128 in M.A.

We require the candidate urgently. If interested, please 
send your resumes within the next two days to the 
following e-mail: [EMAIL PROTECTED] 

Following are the details for the job:

Our environment: Solaris 7 and solaris 8.

Databases versions: 804, 8.1.6.1, 8.1.7.3

OLTP databases and datawarehouse.

Veritas File System.

Middleware: Tuxedo and MQ series

Quest, DataMirror - Replication products

Apps: WebLogic

Following is the skill set for the candidate:

Following are essential requirements for an Oracle DBA.

1. Must have worked as Oracle developer at least 3 years.

2. Must have been working as Oracle DBA at least for the 
last 3 years in a
PRODUCTION environment in 8i. (We don't want development 
DBA's).

3. Must have excellent knowledge in installing Oracle 
software and its
products. Must have installed patches in his earlier job.

4. Thorough knowledge in Backup and Recovery procedures. 
Must be able to
solve scenarios during the interview.

5. Good knowlege in Oracle tuning process. Must be able 
to solve scenarios
during the interview.

4. Must have good knowledge in running various 
statistical packages like
STATSPACK.

5. Excellent knowledge in shell programming and 
understanding of awk and
sed usage.

6. Must be very familiar with Solaris 7 and higher 
versions. Must have
general understanding of tuning/performance processes 
involved on Unix
level. Should be able to give us various scenarious 
he/she faced during
his
career in tuning.

7. Must have good understanding of PL/SQL, SQL.

8. Must be familiar with OMS and its tools.

9. Must have thorough understanding of RAID concepts and 
its use in
Oracle.
And good knowledge on Oracle OFA methodology - -- This 
is must.

10. Must have good knowledge on normalization techniques.

11. Must be familiar with Oracle Standby databases and 
their running. --
This is essential.

12. Good communication skills and team work.

Optional but would have weightage:

1. Oracle 9i knowledge

2. Oracle RAC environment experience.

3. Datawarehous knowledge and issues involved in setting 
up production
datawarehouses

4. Understanding of Veritas

5. Knowledge about design tools like Oracle 
Designer/ERwin

6. Knowledge about Quest

7. Knowledge about DataMirror

8. General understanding of WebLogic

9. Understanding Tuxedo or MQM

10. Knowledge in C programing.


Rao




  



-- 
ltiu
3/4 OCP 9i Eh?


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

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

2002-10-02 Thread Igor Neyman




Altering "current_schema", you will not see anything in 
"user_tables", but you should be able to reference tables in thisnew 
schema without using "siebel" prefix.

Igor Neyman, OCP DBA[EMAIL PROTECTED] 


  - Original Message - 
  From: 
  George Leonard (ZA) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, October 02, 2002 12:18 
  PM
  Subject: RE: logon trigger
  
  
  Hi 
  all
  
  Ok the trigger has 
  been changed to this, It 
  compiles.
  
  The problem now is 
  that all the objects that need to be access is owner by the siebel user. I do 
  not want to create synonyms. The tool being used can not append the siebel 
  schema name in front of the objects, and it is expecting to log in as 
  siebel.
  
  Any idea why the 
  'Alter session set CURRENT_SCHEMA = SIEBEL;' is not changing my current 
  schema. I have tried executing Alter session set CURRENT_SCHEMA = SIEBEL; in a 
  standard sqlplus window and then looking at the 
  user_tables table and it is empty 
  ?
  
  create or replace trigger 
  olap1_logon_trigger
   after logon 
  on smload.schema
  begin
   execute 
  immediate 'SET TRANSACTION USE ROLLBACK SEGMENT 
  RBBIG01;';
   execute 
  immediate 'Alter session enable parallel query;';
   execute 
  immediate 'Alter session set SORT_AREA_SIZE = 
  10485760;';
   
  execute immediate 'Alter session set 
  OPTIMIZER_MODE = choose;';
   
  execute immediate 'Alter session set 
  CURRENT_SCHEMA = SIEBEL;';
  
  end;
  /
  
  
  George
  
  George 
  Leonard
  Oracle 
  Database Administrator
  Dimension 
  Data (Pty) Ltd
  (Reg. 
  No. 1987/006597/07)
  Tel:(+27 
  11) 575 0573
  Fax:(+27 
  11) 576 0573
  E-mail:[EMAIL PROTECTED]
  Web: 
   http://www.didata.co.za
  
  You 
  Have The Obligation to Inform One Honestly of the risk, And As a 
  Person
  You 
  Are Committed to Educate Yourself to the Total Risk In Any 
  Activity!
  Once 
  Informed  Totally Aware of the Risk, Every Fool Has the Right to Kill or 
  Injure Themselves as They See Fit!
  -Original 
  Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 16:52 PMTo: [EMAIL PROTECTED]Cc: 
  [EMAIL PROTECTED]Subject: re: logon 
  trigger
  
  
  George here is how we did 
  ours"
  
  
  
  create or replace trigger 
  olap1_logon_trigger after logon on olap1.schemabegin 
  execute immediate 'alter session set optimizer_mode = 
  first_rows';end;/
  
  
  
  Customize it to your 
  liking.
  
  
  
  Joe
  
  ***This 
  message contains information intended solely for the addressee,which is 
  confidential or private in nature and subject to legal privilege.If you 
  are not the intended recipient, you may not peruse, use,disseminate, 
  distribute or copy this message or any file attached to thismessage. Any 
  such unauthorised use is prohibited and may be unlawful. Ifyou have 
  received this message in error, please notify the senderimmediately by 
  e-mail, facsimile or telephone and thereafter delete theoriginal message 
  from your machine. Furthermore, the information contained in this 
  message, and anyattachments thereto, is for information purposes only and 
  may contain thepersonal views and opinions of the author, which are not 
  necessarily theviews and opinions of Dimension Data (South Africa) 
  (Proprietary) Limitedor its subsidiaries and associated companies 
  ("Dimension Data"). DimensionData therefore does not accept liability for 
  any claims, loss or damagesof whatsoever nature, arising as a result of 
  the reliance on suchinformation by anyone. Whilst all reasonable 
  steps are taken to ensure the accuracy andintegrity of information 
  transmitted electronically and to preserve theconfidentiality thereof, 
  Dimension Data accepts no liability orresponsibility whatsoever if 
  information or data is, for whatsoeverreason, incorrect, corrupted or does 
  not reach its intended destination. 
  *

RE: logon trigger

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


In looking at this and thinking about it...doesn't any DDL
statement do an implied COMMIT?  If so, the first EXECUTE
IMMEDIATE will fire, commit, the SET TRANSACTION will be
released, and the user will not be assured of using that 
rollback segment.  Shouldn't the SET TRANSACTION be the
last statement in the trigger?

And if Siebel wants RBO, doesn't changing the optimizer at
the session level mean that all that session's queries will
be performed using CBO?  Is Siebel OK with that?

Cheers,
Mike

-Original Message-
Sent: Wednesday, October 02, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L


Alter session ... is not DML, so I think you need to use dynamic SQL:

create or replace trigger smload.logon after logon  on database
begin
SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
EXECUTE IMMEDIATE Alter session enable parallel query;
EXECUTE IMMEDIATE Alter session set SORT_AREA_SIZE = 10485760;
EXECUTE IMMEDIATE Alter session set OPTIMIZER_MODE = choose;
end;
/


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 11:23 AM


 Hi guys

 I am trying to create the following trigger.

 The user in question is logging in using siebel application and siebel
does
 not allow multiple SQL statements during login so we through this might
 solve the problem. My problem now is though, the set rollback works but
the
 alter session statements does not seem to want to work.

 The server needs to be in RBO since this is the only mode supported by
 siebel.

 Help appreciated.

 create or replace trigger smload.logon after logon  on database
 begin
 SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
 Alter session enable parallel query;
 Alter session set SORT_AREA_SIZE = 10485760;
 Alter session set OPTIMIZER_MODE = choose;
 end;
 /

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

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

FAILED_LOGIN_ATTEMPTS

2002-10-02 Thread Srini . Chavali



All,
I have implemented FAILED_LOGIN_ATTEMPTS in one of my database profiles -
and it works beautifully !
However - is there a way to trace or capture the incorrect password (and
machine name) that trips this counter ?
I am interested in finding out who (and from where) tried to connect
unsuccessfully.
TIA
Srini Chavali
Oracle DBA
Cummins Inc


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

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

Re: SQL Backtrack Reports

2002-10-02 Thread Peter Barnett


Do you want to parse the log file and only report the
backup start and stop times?  If so, that's a really
tall order.

What we do is run SQL Backtrack from a shell script
that reports start and stop time and emails
success/failure for each instance.


--- Smith, Ron L. [EMAIL PROTECTED] wrote:
 If anyone out there is using SQL Backtrack to backup
 Oracle I am looking for
 a home grown reporting
 script that will give me start and stop times for
 all the backups on the log
 file.
 
 Thanks!
 R. Smith
 -- 
 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
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


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

__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread Markham, Richard

Title: RE: Oracle D.B.A. required in M.A.





Is it that or is it a new goal to get a developer than can play part time DBA
or vice versa and reap all the benefits for the price of one?


-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle D.B.A. required in M.A.



You know what, this means the people who are hiring does not know what 
they are looking for.


Gene Sais wrote:


lol, i love #1  #2, developer but not a development dba. good luck in your search, quite a few requirements :)

gene

 

[EMAIL PROTECTED] 10/02/02 11:50AM 
 

In my company, we require Oracle D.B.A. to maintain 
development and production Oracle databases. This is a 
permanent position. Our compnay is 24 yrs. old company.

Our company is situated on Route 128 in M.A.

We require the candidate urgently. If interested, please 
send your resumes within the next two days to the 
following e-mail: [EMAIL PROTECTED] 

Following are the details for the job:

Our environment: Solaris 7 and solaris 8.

Databases versions: 804, 8.1.6.1, 8.1.7.3

OLTP databases and datawarehouse.

Veritas File System.

Middleware: Tuxedo and MQ series

Quest, DataMirror - Replication products

Apps: WebLogic

Following is the skill set for the candidate:

Following are essential requirements for an Oracle DBA.

1. Must have worked as Oracle developer at least 3 years.

2. Must have been working as Oracle DBA at least for the 
last 3 years in a
PRODUCTION environment in 8i. (We don't want development 
DBA's).

3. Must have excellent knowledge in installing Oracle 
software and its
products. Must have installed patches in his earlier job.

4. Thorough knowledge in Backup and Recovery procedures. 
Must be able to
solve scenarios during the interview.

5. Good knowlege in Oracle tuning process. Must be able 
to solve scenarios
during the interview.

4. Must have good knowledge in running various 
statistical packages like
STATSPACK.

5. Excellent knowledge in shell programming and 
understanding of awk and
sed usage.

6. Must be very familiar with Solaris 7 and higher 
versions. Must have
general understanding of tuning/performance processes 
involved on Unix
level. Should be able to give us various scenarious 
he/she faced during
his
career in tuning.

7. Must have good understanding of PL/SQL, SQL.

8. Must be familiar with OMS and its tools.

9. Must have thorough understanding of RAID concepts and 
its use in
Oracle.
And good knowledge on Oracle OFA methodology - -- This 
is must.

10. Must have good knowledge on normalization techniques.

11. Must be familiar with Oracle Standby databases and 
their running. --
This is essential.

12. Good communication skills and team work.

Optional but would have weightage:

1. Oracle 9i knowledge

2. Oracle RAC environment experience.

3. Datawarehous knowledge and issues involved in setting 
up production
datawarehouses

4. Understanding of Veritas

5. Knowledge about design tools like Oracle 
Designer/ERwin

6. Knowledge about Quest

7. Knowledge about DataMirror

8. General understanding of WebLogic

9. Understanding Tuxedo or MQM

10. Knowledge in C programing.


Rao




 




-- 
ltiu
3/4 OCP 9i Eh?



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


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

Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

2002-10-02 Thread Bernard, Gilbert


How to create this view X$KSPPI ?

I am trying to install statspack, and it missing this view. ! ! !
Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread Weaver, Walt


Yeah. Wow. Must be the first time in corporate bureaucracy history that sort
of thing has happened.

I'm shocked.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, October 02, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


You know what, this means the people who are hiring does not know what 
they are looking for.

Gene Sais wrote:

lol, i love #1  #2, developer but not a development dba.  good luck in
your search, quite a few requirements :)

gene

  

[EMAIL PROTECTED] 10/02/02 11:50AM 


In my company, we require Oracle D.B.A. to maintain 
development and production Oracle databases.  This is a 
permanent position.  Our compnay is 24 yrs. old company.

Our company is situated on Route 128 in M.A.

We require the candidate urgently. If interested, please 
send your resumes within the next two days to the 
following e-mail: [EMAIL PROTECTED] 

Following are the details for the job:

Our environment: Solaris 7 and solaris 8.

Databases versions: 804, 8.1.6.1, 8.1.7.3

OLTP databases and datawarehouse.

Veritas File System.

Middleware: Tuxedo and MQ series

Quest, DataMirror - Replication products

Apps: WebLogic

Following is the skill set for the candidate:

Following are essential requirements for an Oracle DBA.

1. Must have worked as Oracle developer at least 3 years.

2. Must have been working as Oracle DBA at least for the 
last 3 years in a
PRODUCTION environment in 8i. (We don't want development 
DBA's).

3. Must have excellent knowledge in installing Oracle 
software and its
products. Must have installed patches in his earlier job.

4. Thorough knowledge in Backup and Recovery procedures. 
Must be able to
solve scenarios during the interview.

5. Good knowlege in Oracle tuning process. Must be able 
to solve scenarios
during the interview.

4. Must have good knowledge in running various 
statistical packages like
STATSPACK.

5. Excellent knowledge in shell programming and 
understanding of awk and
sed usage.

6. Must be very familiar with Solaris 7 and higher 
versions. Must have
general understanding of tuning/performance processes 
involved on Unix
level. Should be able to give us various scenarious 
he/she faced during
his
career in tuning.

7. Must have good understanding of PL/SQL, SQL.

8. Must be familiar with OMS and its tools.

9. Must have thorough understanding of RAID concepts and 
its use in
Oracle.
And good knowledge on Oracle OFA methodology - -- This 
is must.

10. Must have good knowledge on normalization techniques.

11. Must be familiar with Oracle Standby databases and 
their running. --
This is essential.

12. Good communication skills and team work.

Optional but would have weightage:

1. Oracle 9i knowledge

2. Oracle RAC environment experience.

3. Datawarehous knowledge and issues involved in setting 
up production
datawarehouses

4. Understanding of Veritas

5. Knowledge about design tools like Oracle 
Designer/ERwin

6. Knowledge about Quest

7. Knowledge about DataMirror

8. General understanding of WebLogic

9. Understanding Tuxedo or MQM

10. Knowledge in C programing.


Rao




  



-- 
ltiu
3/4 OCP 9i Eh?


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

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

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

RE: Tool to load data

2002-10-02 Thread David . Schmoldt




TOAD 
has a GUI SQL Loader interface. It lets you use a wizard to create the CTL 
file, then you can later just re-load that file and execute the 
load.

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
  12:45 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Tool to load data
  Hi all,
  
  I'd like to know if there is some tool we 
  can use to automate loading data into database using SQLLDR either via GUI or 
  scripts. I need to allow someone to loginthe system to bulk load 
  data without worrying he destroys database. Any advices will be 
  appreciated.
  
  Regards,David

Re: Tool to load data

2002-10-02 Thread Ron Rogers


David,
 You could create a script that executes the sqlldr  with a
parameterfile and then only give permissions to the userid that you want
to do the load.
ie: sqlldr parfile=path/file.par
Ron

 [EMAIL PROTECTED] 10/02/02 01:44PM 
Hi all,
 
I'd like to know if there is some tool we can use to automate loading
data
into database using SQLLDR either via GUI or scripts.  I need to allow
someone to login the system to bulk load data without worrying he
destroys
database.  Any advices will be appreciated.
 
Regards,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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

NIKU v6.0.0.12?

2002-10-02 Thread Thomas Jeff

Title: NIKU v6.0.0.12?





Anyone running NIKU, v6.0.0.12 using an 8.1.7.2 repository on AIX 4.3.3? 



Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.


Email: [EMAIL PROTECTED]


Indy DBA Master Documentation available at:
http://gkmqp.tce.com/tis_dba
Select 'Indy DBA' then 'DBA Web Pages'

Re: Sample Pro*C code for TAF in 8iOPS/9iRAC




Hemant,


TAF was specific to OCI only in v8.0 of the 
database. In v8.1 and upwards, it is specified for any application or 
APIin the TNSNAMES entry...

This example comes straight out of the "Oracle Net8 
Administration" manual, page 8-14. I'd suggest reading up on the meaning 
of the FAILOVER_MODE settings, specifically TYPE= and METHOD=. Also, if 
you have your OPS/RAC instances in a pure "active/passive" arrangement, then the 
TNS entry below should work (i.e. LOAD_BALANCE=OFF). If you have both 
instances equally available for user connections (i.e. "active/active" failover 
arrangement), then you might consider changing LOAD_BALANCE=ON to distribute the 
connections randomly. However, you'll want to think carefully about 
usingthat mechanism... :-)


  sales.us.acme.com=
   (description=
   
  (load_balance=off)

  (failover=on)

  (address_list=

   (address=

(protocol=tcp)

(host=sales1-server)

(port=1521)

   )
  

   (address=

(protocol=tcp)

(host=sales2-server)

(port=1521)

   )

  )

  (connect_data=

   (service_name = sales.us.acme.com)

   (failover_mode = (type=select)(method=basic))

  )
   
)
Hope this helps...

-Tim

- Original Message - 
From: "Hemant K Chitale" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L" 
[EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 10:13 
AM
Subject: Sample Pro*C code for TAF in 
8iOPS/9iRAC
   Can anyone send me sample Pro*C code depicting 
how they've handled TAF in 8iOPS or 9iRAC ?  We've got 
some application servers running Pro*C programs which don't seem to able 
to handle failover. SQLPlus sessions are failing over to the remaining 
instance but the Pro*C programs seem to be "hanging", without returning 
any error, when a transaction is "in-flight" We do know that 
Insert/Update/Deletes do not really failover but are wondering how the 
Pro*C programs could be written to handle the oracle error on session 
failover and resubmit the transaction.   Hemant 
K Chitale My web site page is : http://hkchital.tripod.com 
  --  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
 Author: Hemant K Chitale  INET: [EMAIL PROTECTED] 
 Fat City Network Services -- 858-538-5051 http://www.fatcity.com San 
Diego, California -- Mailing list and 
web hosting services 
- To 
REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (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 Backtrack Reports

2002-10-02 Thread Smith, Ron L.


Yes, I am looking for something that reports sid start stop for every backup
recorded either in the log file
or in the oracatalog.

Ron

-Original Message-
Sent: Wednesday, October 02, 2002 12:23 PM
To: Multiple recipients of list ORACLE-L


Do you want to parse the log file and only report the
backup start and stop times?  If so, that's a really
tall order.

What we do is run SQL Backtrack from a shell script
that reports start and stop time and emails
success/failure for each instance.


--- Smith, Ron L. [EMAIL PROTECTED] wrote:
 If anyone out there is using SQL Backtrack to backup
 Oracle I am looking for
 a home grown reporting
 script that will give me start and stop times for
 all the backups on the log
 file.
 
 Thanks!
 R. Smith
 -- 
 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
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


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

__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

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


Or if you just want to create that view it is in Oracle_home\rdbms\admin\spcusr.sql.

Dave

-Original Message-
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L


How to create this view X$KSPPI ?

I am trying to install statspack, and it missing this view. ! ! !
Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

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

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

2002-10-02 Thread Jacques Kilchoer

Title: RE: Tool to load data





http://www.quest.com/requests/?RequestDefID=49


-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]


How do I get it for a trial?

David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]


TOAD has a GUI SQL Loader interface. It lets you use a wizard to create the CTL file, then you can later just re-load that file and execute the load.

Re:Tool to load data

2002-10-02 Thread dgoulet


If your on a MicroSlop OS try Winbatch (www.winbatch.com).

Dick Goulet

Reply Separator
Author: Nguyen; David M [EMAIL PROTECTED]
Date:   10/2/2002 9:44 AM

Hi all,
 
I'd like to know if there is some tool we can use to automate loading data
into database using SQLLDR either via GUI or scripts.  I need to allow
someone to login the system to bulk load data without worrying he destroys
database.  Any advices will be appreciated.
 
Regards,
David

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTML xmlns=http://www.w3.org/TR/REC-html40; xmlns:o = 
urn:schemas-microsoft-com:office:office xmlns:w = 
urn:schemas-microsoft-com:office:word xmlns:st1 = 
urn:schemas-microsoft-com:office:smarttagsHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1


META content=Word.Document name=ProgId
META content=MSHTML 5.00.2919.6307 name=GENERATOR
META content=Microsoft Word 10 name=OriginatorLINK 
href=cid:[EMAIL PROTECTED]; rel=File-Listo:SmartTagType 
namespaceuri=urn:schemas-microsoft-com:office:smarttags 
name=PersonName/o:SmartTagType!--[if gte mso 9]xml
 o:OfficeDocumentSettings
  o:DoNotRelyOnCSS/
 /o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
 w:WordDocument
  w:SpellingStateClean/w:SpellingState
  w:GrammarStateClean/w:GrammarState
  w:DocumentKindDocumentEmail/w:DocumentKind
  w:EnvelopeVis/
  w:BrowserLevelMicrosoftInternetExplorer4/w:BrowserLevel
 /w:WordDocument
/xml![endif]--!--[if !mso]
STYLEst1\:* {
BEHAVIOR: url(#default#ieooui)
}
/STYLE
![endif]--
STYLE@font-face {
font-family: Tahoma;
}
P.MsoNormal {
FONT-FAMILY: Times New Roman; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ; mso-pagination: widow-orphan; mso-fareast-font-family:
Times New Roman; mso-believe-normal-left: yes
}
LI.MsoNormal {
FONT-FAMILY: Times New Roman; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ; mso-pagination: widow-orphan; mso-fareast-font-family:
Times New Roman; mso-believe-normal-left: yes
}
DIV.MsoNormal {
FONT-FAMILY: Times New Roman; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ; mso-pagination: widow-orphan; mso-fareast-font-family:
Times New Roman; mso-believe-normal-left: yes
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.EmailStyle17 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply;
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: 10.0pt;
mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;
mso-bidi-font-family: Arial
}
SPAN.SpellE {
mso-style-name: ; mso-spl-e: yes
}
SPAN.GramE {
mso-style-name: ; mso-gram-e: yes
}
DIV.Section1 {
page: Section1
}
/STYLE
!--[if gte mso 10]
style
 /* Style Definitions */ 
 table.MsoNormalTable
{mso-style-name:Table Normal;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:Times New Roman;}
/style
![endif]--![if mso 9]
style
p.MsoNormal
{margin-left:1.5pt;}
/style
![endif]/HEAD
BODY bgColor=#ff lang=EN-US link=blue 
style=MARGIN-LEFT: 1.5pt; MARGIN-TOP: 1.5pt; tab-interval: 36.0pt 
vLink=purple
DIVSPAN class=715033316-02102002Hi all,/SPAN/DIV
DIVSPAN class=715033316-02102002/SPANnbsp;/DIV
DIVSPAN class=715033316-02102002I'd like to know if there is some tool we 
can use to automate loading data into database using SQLLDR either via GUI or 
scripts.nbsp; I need to allow someone to loginnbsp;the system to bulk load 
data without worrying he destroys database.nbsp; Any advices will be 
appreciated./SPAN/DIV
DIVSPAN class=715033316-02102002/SPANnbsp;/DIV
DIVSPAN class=715033316-02102002Regards,BRDavid/SPAN/DIV/BODY/HTML

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

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

RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

2002-10-02 Thread Deshpande, Kirti


That's an Oracle internal table that is created during the database creation
time. 

What is the exact error you are receiving?

BTW, Do you use APT scripts by Steve Adams? 

- Kirti


-Original Message-
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L


How to create this view X$KSPPI ?

I am trying to install statspack, and it missing this view. ! ! !
Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

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

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

RE: Tool to load data

2002-10-02 Thread Nguyen, David M




How do I get it for a trial?

David

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
  October 02, 2002 1:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Tool to load data
  TOAD 
  has a GUI SQL Loader interface. It lets you use a wizard to create the 
  CTL file, then you can later just re-load that file and execute the 
  load.
  
-Original Message-From: Nguyen, David M 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
12:45 PMTo: Multiple recipients of list 
ORACLE-LSubject: Tool to load data
Hi all,

I'd like to know if there is some tool 
we can use to automate loading data into database using SQLLDR either via 
GUI or scripts. I need to allow someone to loginthe system to 
bulk load data without worrying he destroys database. Any advices will 
be appreciated.

Regards,David

RE: SQLLdr help needed


I am not sure if it helps, but I would use:
- FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY ''
- COMMENTS position(n:n+2000) where n=the offset of the first character of the field 
COMMENTS including delimiters
- ROW_POCESSED SEQUENCE(MAX,1) 

inka
-Original Message-
Sent: Wednesday, October 02, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Oracle 8.1.6 WinNT
I have been trying to use sqlldr and I am getting following error

Record 1: Rejected - Error on table INTERVIEW, column COMMENTS.
end of logical record found when reading length of varying length field

Here is sample record and control file.

Any ideas why I get this error. MetaLink says TRAILING NULLCOLS should
correct.  The field it is complaining is second to last field
in input file.

37901|01/01/1970 04:59:10||LDMARCHI|||


LOAD DATA
INFILE 'd:\oracle\admin\tmwktst3\scripts\BDUMPI2.txt'
BADFILE 'd:\oracle\admin\tmwktst3\scripts\INTERVIEW.bad'
insert
INTO TABLE INTERVIEW
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(PROFILE_NO,
INTERVIEW_DATE DATE 'MM/DD/ HH24:MI:SS',
FU_DATE DATE 'MM/DD/',
OPERATOR CHAR,
SOURCE CHAR,
APPEARANCE CHAR,
FAMILY CHAR,
LANGUAGE_SKILLS CHAR,
CAREER_PLANS CHAR,
MALPRACTICE_HIS CHAR,
ECONOMICS1 CHAR,
ECONOMICS2 CHAR,
MET_WITH CHAR,
COMMENTS  varchar(4000)  SUBSTR(:COMMENTS,1,2000),
ROW_PROCESSED)


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

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

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

RE: Tool to load data




go to quest software home page www.gets.com

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
  2:33 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Tool to load data
  How do I get it for a trial?
  
  David
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
October 02, 2002 1:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Tool to load data
TOAD has a GUI SQL Loader interface. It lets you use a wizard 
to create the CTL file, then you can later just re-load that file and 
execute the load.

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
  12:45 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Tool to load data
  Hi all,
  
  I'd like to know if there is some tool 
  we can use to automate loading data into database using SQLLDR either via 
  GUI or scripts. I need to allow someone to loginthe system to 
  bulk load data without worrying he destroys database. Any advices 
  will be appreciated.
  
  Regards,David

RE: Tool to load data




Check 
out this site.

http://www.quest.com/solutions/database_management.asp

Dave

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
  1:33 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Tool to load data
  How do I get it for a trial?
  
  David
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
October 02, 2002 1:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Tool to load data
TOAD has a GUI SQL Loader interface. It lets you use a wizard 
to create the CTL file, then you can later just re-load that file and 
execute the load.

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 
  12:45 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Tool to load data
  Hi all,
  
  I'd like to know if there is some tool 
  we can use to automate loading data into database using SQLLDR either via 
  GUI or scripts. I need to allow someone to loginthe system to 
  bulk load data without worrying he destroys database. Any advices 
  will be appreciated.
  
  Regards,David

RE: Indexing SYS tables

2002-10-02 Thread Chaim . Katz



but there is a create index ... desc?

ASC | DESC
 specifies whether the index should be created in ascending or descending
order.
 Oracle treats descending indexes as if they were function-based indexes.
You do not need the QUERY REWRITE or GLOBAL QUERY REWRITE privileges to
create them, as you do with other function-based indexes.

Chaim




Jesse, Rich [EMAIL PROTECTED]@fatcity.com on 10/01/2002 04:23:22
PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



Yes it does, at least on my test instance.

Thanks!
Rich

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

 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 01, 2002 12:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Indexing SYS tables


 Again since the indexes store the row in ordered fashion, I
 guess a normal
 index should be able to do ORDER BY DESC by reading backwards

 Not sure though

 Regards
 Naveen

 -Original Message-
 Sent: Tuesday, October 01, 2002 10:33 PM
 To: Multiple recipients of list ORACLE-L


 Yes, you are obviously correct.  I really need to RTFM.
 sigh  Too many
 pots on the stove!

 Just a regular index, then.  Any other input?

 Thx!
 Rich

 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech International,
 Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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





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

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

Re: Performance monitoring

2002-10-02 Thread Greg Moore


The ten most important performance items to monitor are your ten most
important business transactions.  Period, end of story.

If you want to provide an intelligent response, monitor how long they take
and provide a weekly report, noting any changes.

Ratios and wait events are just diagnostic tools -- when business
transactions become slow you use them to find where the problem is.

Anyone who asks you to monitor ten internal things, such as ratios or wait
events, and no more than just ten because they only want the ten most
important, is simply uneducated and unexperienced, since these things are of
no importantance if the system is running fast enough for the users, and
besides there are way more than ten important things like this.  However,
they may also be very smart, since a good manager may be wise to start by
getting a handle on the ten most important things.

Probably, you want to be taking statspack snapshots every hour just to have
a baseline, so just DO THAT and give the statspack report to the manager
once a week -- and make them happy by picking out ten items you consider
important and running a yellow highlighter over them.  Have a cover page
that compares the current value of the ten items with the same items four
weeks ago -- so you are monitoring them.  That's fast, easy and smart, it
makes your manager happy and you'll have your eye on the ball too.

But don't forget that the most important thing to monitor is reality.  Your
coolest move is to have the manager pull the users into a meeting and get
them to identify the ten business transactions that are most important to
them.  Find out if any are too slow.  Find out if anything is too slow.
Monitor that.  Tune that.

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

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

RE: using obfuscation

2002-10-02 Thread Aponte, Tony

Title: RE: using obfuscation






I was wondering if this was of any help.


Tony Aponte


-Original Message-

From: Aponte, Tony 

Sent: Tuesday, September 17, 2002 7:04 PM

To: '[EMAIL PROTECTED]'

Cc: '[EMAIL PROTECTED]'

Subject: RE: using obfuscation



I've been developing a solution for a similar requirement. Although I reached a dead-end with this thread I think it solves your problem.

I'm picking it up from the point where the data in encrypted_data of sensitive_table needs encryption. I did that with an anonymous PL/SQL block:

CREATE TABLE sensitive_table (encrypted_data VARCHAR2(30), clear_text VARCHAR2(30));


I'll populate the table with text 16 characters long. I used 16 to simplify the example. DBMS_OBFUSCATION_TOOLKIT needs the data length to be a multiple of 8:

INSERT INTO sensitive_table 

SELECT TO_CHAR(ROWNUM,'fm0009'),TO_CHAR(ROWNUM,'fm0009') FROM DBA_OBJECTS WHERE ROWNUM  1000;


COMMIT;


Now run the anonymous block to encrypt the data in the encrypted_data column:


--Encrypt data

DECLARE

CURSOR xtab IS SELECT encrypted_data FROM sensitive_table FOR UPDATE;

input_string VARCHAR2(16) ;

raw_input RAW(400) ;

key_string VARCHAR2(8):= 'abcde123';

raw_key RAW(400) := UTL_RAW.CAST_TO_RAW(key_string);

encrypted_raw RAW(2048);

error_in_input_buffer_length EXCEPTION;

PRAGMA EXCEPTION_INIT(error_in_input_buffer_length, -28232);

INPUT_BUFFER_LENGTH_ERR_MSG VARCHAR2(100) :=

 '*** DES INPUT BUFFER NOT A MULTIPLE OF 8 BYTES - IGNORING EXCEPTION ***';

double_encrypt_not_permitted EXCEPTION;

PRAGMA EXCEPTION_INIT(double_encrypt_not_permitted, -28233);

DOUBLE_ENCRYPTION_ERR_MSG VARCHAR2(100) :=

 '*** CANNOT DOUBLE ENCRYPT DATA - IGNORING EXCEPTION ***';

BEGIN

FOR xrec IN xtab LOOP

 input_string:=xrec.encrypted_data;

 raw_input:= UTL_RAW.CAST_TO_RAW(input_string);

 DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT(input = raw_input,key = raw_key, encrypted_data = encrypted_raw );

 UPDATE sensitive_table 

  SET encrypted_data = UTL_RAW.CAST_TO_VARCHAR2(encrypted_raw)

 WHERE CURRENT OF xtab; 

END LOOP;

COMMIT;

EXCEPTION

 WHEN error_in_input_buffer_length THEN

 dbms_output.put_line(' ' || INPUT_BUFFER_LENGTH_ERR_MSG);

END;

/


I want to create a package (spec only) to contain global variables to be used by my encrypt/decrypt functions:


CREATE OR REPLACE PACKAGE cc_security_pkg

IS

g_KeyString_txt  VARCHAR2(8):= 'abcde123';

g_Key_raw RAW(400) := UTL_RAW.CAST_TO_RAW(g_KeyString_txt);

g_Input_raw RAW(400) ;

g_Decrypted_raw RAW(2048);

g_Encrypted_raw RAW(2048);

g_ErrorInInputBufferLength_exc EXCEPTION;

PRAGMA EXCEPTION_INIT(g_ErrorInInputBufferLength_exc, -28232);

g_InputBufferLengthErrMsg_txt VARCHAR2(100) :=

 '*** DES INPUT BUFFER NOT A MULTIPLE OF 8 BYTES - IGNORING EXCEPTION ***';

g_DoubleEncrypt_exc EXCEPTION;

PRAGMA EXCEPTION_INIT(g_DoubleEncrypt_exc, -28233);

g_DoubleEncryptionErrMsg_txt VARCHAR2(100) :=

 '*** CANNOT DOUBLE ENCRYPT DATA - IGNORING EXCEPTION ***';

--

END;

/


Here is the decrypt function. Not much to explain:


CREATE OR REPLACE cc_decrypt(p_Input_txt VARCHAR2)

RETURN VARCHAR2

IS

BEGIN

 DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT(INPUT = UTL_RAW.CAST_TO_RAW(p_Input_txt)

  ,KEY = cc_security_pkg.g_Key_raw

 ,DECRYPTED_DATA = cc_security_pkg.g_Decrypted_raw );

 RETURN(UTL_RAW.CAST_TO_VARCHAR2(cc_security_pkg.g_Decrypted_raw));

END cc_decrypt;

/


This is the corresponding encryption function. Two things to note, the use of the DETERMINISTIC pragma and the conflicting use of the value of CLIENT_INFO to determine the return value (encrypted or not.) I am deliberately (mis?)using DETERMINISTIC to trick Oracle into trusting that I will always return the same value for p_Input_txt. I'll explain why later on when I get to the function-based index. But for now all you need to know is that when the value of CLIENT_INFO equals 'buildingindex' I simply return the original value passed to the function. Otherwise the parameter is decrypted and returned:

CREATE OR REPLACE FUNCTION cc_encrypt(p_Input_txt VARCHAR2)

RETURN VARCHAR2

DETERMINISTIC

IS

BEGIN

 IF USERENV('CLIENT_INFO') = 'buildingindex' THEN

  RETURN(p_Input_txt);

 ELSE

  DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT(INPUT = UTL_RAW.CAST_TO_RAW(p_Input_txt)

  ,KEY = cc_security_pkg.g_Key_raw

 ,ENCRYPTED_DATA = cc_security_pkg.g_Encrypted_raw );

  RETURN(UTL_RAW.CAST_TO_VARCHAR2(cc_security_pkg.g_Encrypted_raw));

 END IF;

END cc_encrypt;

/


Now I want to be able to use and index when the query includes sensitive_table.encrypteed_data in the predicate. I believe this is where you are stuck. I want to execute this query that doesn't require pre-encryption of 0010:

SELECT cc_decrypt(encrypted_data),clear_text FROM sensitive_table WHERE encrypted_data = cc_encrypt('0010');

But the use of a function (cc_encrypt in this case) causes the optimizer to ignore an index on encrypted_data. This is where the function-based

RE: Performance monitoring

2002-10-02 Thread Smith, Ron L.


Right On!

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


The ten most important performance items to monitor are your ten most
important business transactions.  Period, end of story.

If you want to provide an intelligent response, monitor how long they take
and provide a weekly report, noting any changes.

Ratios and wait events are just diagnostic tools -- when business
transactions become slow you use them to find where the problem is.

Anyone who asks you to monitor ten internal things, such as ratios or wait
events, and no more than just ten because they only want the ten most
important, is simply uneducated and unexperienced, since these things are of
no importantance if the system is running fast enough for the users, and
besides there are way more than ten important things like this.  However,
they may also be very smart, since a good manager may be wise to start by
getting a handle on the ten most important things.

Probably, you want to be taking statspack snapshots every hour just to have
a baseline, so just DO THAT and give the statspack report to the manager
once a week -- and make them happy by picking out ten items you consider
important and running a yellow highlighter over them.  Have a cover page
that compares the current value of the ten items with the same items four
weeks ago -- so you are monitoring them.  That's fast, easy and smart, it
makes your manager happy and you'll have your eye on the ball too.

But don't forget that the most important thing to monitor is reality.  Your
coolest move is to have the manager pull the users into a meeting and get
them to identify the ten business transactions that are most important to
them.  Find out if any are too slow.  Find out if anything is too slow.
Monitor that.  Tune that.

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

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

table_changes

2002-10-02 Thread Nguyen, David M


I heard people said we can check table_changes to make sure data is actually
loaded into table using sqlldr.  If this is true, how do I verify data is
loaded by looking table_changes?

Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Perl::DBI problems after charset change (MORE INFO -- longish


Rich,

It's time for you to join the DBI users mailing list.  :)

http://lists.perl.org/showlist.cgi?name=dbi-users

Jared






Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 01:23 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Perl::DBI problems after charset change (MORE INFO -- 
longish


[first post bounced from fatcity.com with /var/spool/mail/autoresp:
Permission denied. among other errors]



I think I'm getting somewhere, but the research has given me the security
heebie-jeebies.

As I'm tracing at SUPPORT level on the server side of a test DB (can't 
trace
on the client because it's production), two major differences pop out at 
me.

First, the connect packets have the text in a different order:

Perl/DBI:
(CONNECT_DATA=(SID=testsid)(SRVR=DEDICATED)(CID=(PROGRAM=)(HOST=myclient)(US
ER=rjesse)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521))
))

SQL*Plus:
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521)))(CONNECT_DA
TA=(SID=testsid)(SRVR=DEDICATED)(CID=(PROGRAM=)(HOST=myclient)(USER=rjesse))
)(FADRL=(FC=)(FG=)))

Second, all other packets to and from Perl/DBI have every byte
zero-terminated, whereas SQL*Plus doesn't.  (Not knowing exactly where the
password is, I've *d out and xxd out some bytes where I believe the
encoded password and some other sensitive data to be)

Perl/DBI:
nsprecv: 267 bytes from transport
nsprecv: tlen=267, plen=267, type=6
nsprecv: packet dump
nsprecv: 01 0B 00 00 06 00 00 00  ||
nsprecv: 00 00 03 51 03 00 17 B9  |...Q|
nsprecv: 10 00 00 00 06 00 17 DB  ||
nsprecv: F2 00 00 00 11 00 00 00  ||
nsprecv: 00 00 00 00 00 00 00 00  ||
nsprecv: 00 00 00 00 00 00 17 DD  ||
nsprecv: 6E 00 00 00 05 00 17 DF  |n...|
nsprecv: 6C 00 00 00 04 00 17 DE  |l...|
nsprecv: 6D 00 00 00 06 00 00 08  |m...|
nsprecv: 00 00 17 E0 6B 00 00 00  |k...|
nsprecv: 05 00 17 E1 6A 00 00 00  |j...|
nsprecv: 20 00 00 00 00 00 00 00  | ...|
nsprecv: 00 00 00 00 00 00 00 00  ||
nsprecv: 00 00 00 00 00 00 00 00  ||
nsprecv: 00 00 00 00 00 00 xx 00  |..U.|
nsprecv: xx 00 xx 00 xx 00 xx 00  |N.A.M.E.|
nsprecv: xx 00 xx 00 xx 00 xx 00  |1.*.*.*.|
nsprecv: xx 00 xx 00 xx 00 xx 00  |*.*.*.*.|
nsprecv: 42 00 xx 00 44 00 45 00  |B.*.D.E.|
nsprecv: 34 00 41 00 xx 00 38 00  |4.A.8.8.|
nsprecv: 45 00 32 00 70 00 74 00  |E.2.p.t.|
nsprecv: 73 00 2F 00 35 00 xx 00  |s./.5.*.|
nsprecv: xx 00 xx 00 xx 00 72 00  |*.*.*.r.|
nsprecv: 6A 00 65 00 73 00 73 00  |j.e.s.s.|
nsprecv: 65 00 31 00 37 00 30 00  |e.1.7.0.|
nsprecv: 30 00 39 00 63 00 75 00  |0.9.c.u.|
nsprecv: 72 00 73 00 6F 00 72 00  |r.s.o.r.|
nsprecv: 5F 00 73 00 68 00 61 00  |_.s.h.a.|
nsprecv: 72 00 69 00 6E 00 67 00  |r.i.n.g.|
nsprecv: 5F 00 40 00 xx 00 xx 00  |_.@.*.*.|
nsprecv: xx 00 xx 00 20 00 28 00  |*.*. .(.|
nsprecv: 54 00 4E 00 53 00 20 00  |T.N.S. .|
nsprecv: 56 00 31 00 2D 00 56 00  |V.1.-.V.|
nsprecv: 32 00 29 00 00 00 00 00  |2.).|
nsprecv: normal exit

SQL*Plus:
nsprecv: 193 bytes from transport
nsprecv: tlen=193, plen=193, type=6
nsprecv: packet dump
nsprecv: 00 C1 00 00 06 00 00 00  ||
nsprecv: 00 00 03 76 02 00 1B 51  |...v...Q|
nsprecv: 20 00 00 00 06 00 00 00  | ...|
nsprecv: 01 FF BE DC 48 00 00 00  |H...|
nsprecv: 04 FF BE DA B8 FF BE DA  ||
nsprecv: B2 xx xx xx xx xx xx 00  |.UNAME1.|
nsprecv: 00 00 0D 0D 41 55 54 48  |AUTH|
nsprecv: 5F 54 45 52 4D 49 4E 41  |_TERMINA|
nsprecv: 4C 00 00 00 05 05 70 74  |L.pt|
nsprecv: 73 2F 35 00 00 00 00 00  |s/5.|
nsprecv: 00 00 13 13 41 55 54 48  |AUTH|
nsprecv: 5F 50 52 4F 47 52 41 4D  |_PROGRAM|
nsprecv: 5F 4E 4D 00 41 55 54 00  |_NM.AUT.|
nsprecv: 00 00 18 18 73 71 6C 70  |sqlp|
nsprecv: 6C 75 73 40 xx xx xx xx  |lus@|
nsprecv: 20 28 54 4E 53 20 56 31  | (TNS V1|
nsprecv: 2D 56 33 29 00 00 00 00  |-V3)|
nsprecv: 00 00 00 0C 0C 41 55 54  |.AUT|
nsprecv: 48 5F 4D 41 43 48 49 4E  |H_MACHIN|
nsprecv: 45 00 00 00 04 04 xx xx  |E.**|
nsprecv: xx xx 00 00 00 00 00 00  |**..|
nsprecv: 00 08 08 41 55 54 48 5F  |...AUTH_|
nsprecv: 50 49 44 00 00 00 05 05  |PID.|
nsprecv: 31 39 32 37 38 00 00 00  |19278...|
nsprecv: 00 00 00 00 00 00 00 00  ||
nsprecv: normal exit

From the Perl/DBI session trace, the next packet is the ORA-1017 sent to 
the
client:

nspsend: 162 bytes to transport
nspsend: packet dump
nspsend: 00 A2 00 00 06 00 00 00  ||
nspsend: 00 00 04 00 00 00 00 03  ||
nspsend: F9 00 00 00 00 00 00 00  ||
nspsend: 00 00 00 40 00 00 00 00  |...@|
nspsend: 00 00 00 00 00 00 00 00  ||
nspsend: 00 00 00 00 00 00 00 00  ||
nspsend: 00 03 00 00 00 00 00 00  ||
nspsend: FE 40 00 4F 00 52 00 41  |.@.O.R.A|
nspsend: 00 2D 00 30 00 31 00 30  |.-.0.1.0|
nspsend: 00 31 00 37 00 3A 00 20  |.1.7.:. |
nspsend: 00 69 00 6E 00 76 00 61  |.i.n.v.a|
nspsend:

RE: TSPITR Question


Welcome back Babette!

Jared





Babette Turner-Underwood [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 07:03 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: TSPITR Question


Also only available on Enterprise Edition.
- Babette

-Original Message-
WILLIAMS
Sent: Monday, September 30, 2002 10:03 PM
To: Multiple recipients of list ORACLE-L


Brian - Since nobody seems to have responded to your question, yes, there
are plenty of opportunities for gotchas with TSPITR. To recover deleted
data, you may want to take a look at LogMiner. Less risk. Normally, to
recover deleted data, you will be performing the TSPITR on a test (or
recovery) database so you avoid losing the data changes that were made to
your production system after the deletion. Otherwise, you are performing a
full database point in time recovery. The concept behind TSPITR is to
perform recovery on a small subset of your database somewhere separate 
from
your production database, then once you've recovered the data you need,
export and import it back to the production system.
Without more details on your situation and your experience level, 
about
the most help I can be is to say take a full backup first.




Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, September 30, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L



List -



I have the opportunity to learn first-hand about TSPITR today.  I need 
to
recover a good bit of data that was recently deleted, and do not have a
recent enough export to work from.



My question is this - I'm reading the documentation now, and one of the 
big,
bold Notes is that you should *NOT* try TSPITR for the first time on a
production database, or if you have a time constraint.  From looking at 
the
instructions, I believe that I understand what to do, and while I would 
love
to test this on another instance, I may not be able to.



So I ask you - do you know of any gotchas that I need to be aware of??



Thanks In Advance,


Brian



--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  |
--



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

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

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

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



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

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

select sequence.nextval from dual contributes to poor performan

2002-10-02 Thread Fowler, Kenneth R


Hi,


I am looking after an Oracle EE V8.1.6 database on Solaris 2.6 and I have
been monitoring the database to try and look for causes of poor performance.
I have been using Quest SQLLab Vision which is one of the tools around that
will look at the SGA directly and sample stats multiple times /sec.  Based
upon the information I get back, I can see that the following query...

SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;

Seems to use a significant amount of resource when you take into account the
number of times it is executed.  The query plan shows a full scan of
sys.dual and it uses significant CPU and I/O.


Is there a better (less resource intensive) way to get the nextval??  It may
seem a little petty but it just happens that this query is the second
highest resource user when you take into account the number of times it is
executed.


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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: select sequence.nextval from dual contributes to poor perfo

2002-10-02 Thread Fink, Dan


Ken,
Thanks for adding one more example to the history of the poor
performance of dual. I have a discussion on my website at
www.optimaldba.com/internals/oraint_dual.html.

Why does the app need to select just the nextval? I presume it will
be used to insert a value into a table and can be coded in the insert
statement. For example, INSERT INTO TABLEA (COL1) VALUES
(mysequence.nextval).

Dan Fink

-Original Message-
Sent: Wednesday, October 02, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
performan


Hi,


I am looking after an Oracle EE V8.1.6 database on Solaris 2.6 and I have
been monitoring the database to try and look for causes of poor performance.
I have been using Quest SQLLab Vision which is one of the tools around that
will look at the SGA directly and sample stats multiple times /sec.  Based
upon the information I get back, I can see that the following query...

SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;

Seems to use a significant amount of resource when you take into account the
number of times it is executed.  The query plan shows a full scan of
sys.dual and it uses significant CPU and I/O.


Is there a better (less resource intensive) way to get the nextval??  It may
seem a little petty but it just happens that this query is the second
highest resource user when you take into account the number of times it is
executed.


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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

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

ORA-1115

2002-10-02 Thread MacGregor, Ian A.


I'm getting ORA-1115  errors that do not appear in the  alert log nor do they  specify 
the file name  nor the block id, when performing certain operations against large, 100 
million row plus tables.  This is a 9.0.1.3 database.

I have seen some responses on other OS's which recommend turning off aysnchronous IO.  
As the file systems are cooked, which means Solaris will first try kernel AIO whch 
will fail, afterwhich  the IO will be completed by a user thread.  I have felt that 
when the Oracle documentaion refers to poor implementation of AIO, they are speaking 
of Solaris, but I haven't had a system sensitive to it before.

Inceasing the number of file descriptors is also mentioned.  I may do this based on 
the future needs of the database, but the busiest process iscurrently only holding 
open files which number about 40% of the soft limit for that parameter.

The system  adminsitrators report no problems with the T3's which hold the file 
system.  I am able to export the database without incident, and also validate the 
indexes via analyze command.  What fails are such things as create index, 
dbms_stats.analyze_schema.

Ian A MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

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

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

RE: select sequence.nextval from dual contributes to poor perfo

2002-10-02 Thread Nick Wagner

Title: RE: select sequence.nextval from dual contributes to poor performan





you might want to try increasing the 'cache' size of the sequence. 


If order is not important, and it is being used so often that it's having locking issues, you may want to create a couple different sequences, and have them increment by different values (start with 1 increment by 3, start with 2 increment by 3, start with 3 increment by 3) and have some switch in a trigger that pulls a value from one of the three sequences. 



-Original Message-
From: Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: select sequence.nextval from dual contributes to poor
performan



Hi,



I am looking after an Oracle EE V8.1.6 database on Solaris 2.6 and I have
been monitoring the database to try and look for causes of poor performance.
I have been using Quest SQLLab Vision which is one of the tools around that
will look at the SGA directly and sample stats multiple times /sec. Based
upon the information I get back, I can see that the following query...


SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;


Seems to use a significant amount of resource when you take into account the
number of times it is executed. The query plan shows a full scan of
sys.dual and it uses significant CPU and I/O.



Is there a better (less resource intensive) way to get the nextval?? It may
seem a little petty but it just happens that this query is the second
highest resource user when you take into account the number of times it is
executed.



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

Re: Oracle DBA Needed with Shareplex and Factory Works

2002-10-02 Thread Joe Testa


standard reply, no aliens(foreign or outerspace kind).

joe


OraStaff wrote:

snip


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

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


Gene,

 utl_file_dir = D:\directory name1
 utl_file_dir = D:\directory name2
 utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing 
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 11:25 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Utl_file and OPENVMS


i believe its 

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

 [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g. 

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

 [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
 I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
 The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
 Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE 
 
-- -- 
 
LOAD_USERIDLOADITUP 
 
LOAD_PASSWORD  ILOADIT 
 
LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP 
 
LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR] 
 
LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] 
 
LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL] 
 
LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG] 
 
LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD] 
 
LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD] 

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File 
 
  ( 
 
   P_Current_Table_Name  In  Varchar2 
, 
 
   P_Run_DateIn Date,  

 
   P_Load_Userid In  Varchar2 
, 
 
   P_Load_Password   In  Varchar2 
, 
 
   P_Load_Service_Name   In  Varchar2 
, 
 
   P_Load_Par_File_Dir   In  Varchar2 
, 
 
   P_Load_Data_File_Dir  In  Varchar2 
, 
 
   P_Load_Control_File_Dir   In  Varchar2  ,
 
   P_Load_Log_File_Dir   In  Varchar2 
, 
 
   P_Load_Bad_File_Dir   In  Varchar2 
, 
 
   P_Load_Discard_File_Dir   In  Varchar2   
 
  ) 
 
  as 
 
  Begin 
 
  Declare 
 
   L_Par_File_Hand   Utl_FIle.File_Type; -- Local 
variable to
hold the File Pointer for the parameter file. 
 
 
 
  Begin 
   I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
   PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
 -- Open a new parameter file  
 
 L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); 
 
 -- Print the following lines into the parameter file.   
 
 Utl_File.Put
(L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load
_Service_Name);
 
 
 
 
 Utl_File.New_Line(L_Par_File_Hand);  
 
 If Not P_Current_Table_Name = 'GLCRET'  
 
 Then  
 
 Utl_File.Put 
(L_Par_File_Hand,'Errors=1'); 
 
 Else  
 
 Utl_File.Put 
(L_Par_File_Hand,'Errors=50'); 
 
 End If;  
 
 Utl_File.New_Line(L_Par_File_Hand);  
 
 Utl_File.Put
(L_Par_File_Hand,'Control='||P_Load_Control_File_Dir||'/'||P_Current_Table_N
ame||'.CTL');
 
 
 
 
 Utl_File.New_Line(L_Par_File_Hand);  
 
 Utl_File.Put

RE: urgent help: replication, shareplex

2002-10-02 Thread Aponte, Tony

Title: RE: urgent help:  replication, shareplex






I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML on the Shareplex rowid map table. 

I don't see how the single-row commits would have an impact on the replication. Shareplex doesn't wait for the source's commit before sending the update to the target so that activity remains the same. Upon encountering a commit in the redo stream, it then sends a message to the target so that it also does a commit. We do approximately 40 commits per second consisting of multiple DML operations and we don't any latency (when everything is working correctly.)

HTH

Tony Aponte


-Original Message-

From: Ji, Richard [mailto:[EMAIL PROTECTED]]

Sent: Monday, September 30, 2002 1:09 PM

To: Multiple recipients of list ORACLE-L

Subject: urgent help: replication, shareplex



Hi All,


I needed some help here involving shareplex.


We run two databases (an OLTP type, and a repository type) on the same E10K

domain

which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is

being used

to replicate a table from the OLTP type to the repository. The current

volume we are getting

is about 40 inserts per second to the OLTP. And at this rate shareplex is

lagging behind

doing the replication, for 24 hours now. And I see the shareplex process

running at 10%

while all Oracle processes are below 1% of the CPU.


The situation is complicated, because it involves a hosting company. For

instance, I would

like to run the two databases on two separate domains but they chose not to.

So they

are blaming our application for doing commit on every insert being the

problem. I agree that

(and I will make the change) to commit every 1000 inserts or so. However, I

don't believe

that's the root of the problem. From what I understand, shareplex is log

based replication

and should not be as resource instensive. And 40 per/second isn't a huge

volume per se

and I am sure shareplex can handle a lot more than that.


So any suggestions, feedbacks are welcome.


Thanks


Richard

-- 

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

-- 

Author: Ji, Richard

 INET: [EMAIL PROTECTED]


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

San Diego, California -- Mailing list and web hosting services

-

To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(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 monitoring

2002-10-02 Thread Cary Millsap


Very well said.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


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

The ten most important performance items to monitor are your ten most
important business transactions.  Period, end of story.

If you want to provide an intelligent response, monitor how long they
take
and provide a weekly report, noting any changes.

Ratios and wait events are just diagnostic tools -- when business
transactions become slow you use them to find where the problem is.

Anyone who asks you to monitor ten internal things, such as ratios or
wait
events, and no more than just ten because they only want the ten most
important, is simply uneducated and unexperienced, since these things
are of
no importantance if the system is running fast enough for the users, and
besides there are way more than ten important things like this.
However,
they may also be very smart, since a good manager may be wise to start
by
getting a handle on the ten most important things.

Probably, you want to be taking statspack snapshots every hour just to
have
a baseline, so just DO THAT and give the statspack report to the manager
once a week -- and make them happy by picking out ten items you consider
important and running a yellow highlighter over them.  Have a cover page
that compares the current value of the ten items with the same items
four
weeks ago -- so you are monitoring them.  That's fast, easy and smart,
it
makes your manager happy and you'll have your eye on the ball too.

But don't forget that the most important thing to monitor is reality.
Your
coolest move is to have the manager pull the users into a meeting and
get
them to identify the ten business transactions that are most important
to
them.  Find out if any are too slow.  Find out if anything is too slow.
Monitor that.  Tune that.

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

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

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

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

Re: ORA-1115


Ian,

I had a similar experience with Solaris, Oracle and Async Io aboiut 3 
years ago.

We were testing a Hitachi storage system, and making and some 
incompatibility
with the Hitachi drives and Solaris was causing the async timeout to take 
an extremely
long time.

Though I didn't get errors, writing to disk was painfully slow.  Turning 
off async in
init.ora did the trick.

Jared





MacGregor, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/02/2002 03:38 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:ORA-1115


I'm getting ORA-1115  errors that do not appear in the  alert log nor do 
they  specify the file name  nor the block id, when performing certain 
operations against large, 100 million row plus tables.  This is a 9.0.1.3 
database.

I have seen some responses on other OS's which recommend turning off 
aysnchronous IO.  As the file systems are cooked, which means Solaris will 
first try kernel AIO whch will fail, afterwhich  the IO will be completed 
by a user thread.  I have felt that when the Oracle documentaion refers to 
poor implementation of AIO, they are speaking of Solaris, but I haven't 
had a system sensitive to it before.

Inceasing the number of file descriptors is also mentioned.  I may do this 
based on the future needs of the database, but the busiest process 
iscurrently only holding open files which number about 40% of the soft 
limit for that parameter.

The system  adminsitrators report no problems with the T3's which hold the 
file system.  I am able to export the database without incident, and also 
validate the indexes via analyze command.  What fails are such things as 
create index, dbms_stats.analyze_schema.

Ian A MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

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

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



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

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

Re: select sequence.nextval from dual contributes to poor perfo

...Ken wasn'tcomplaining about the
performance of the sequences, but rather about the performance of millions of
queries on SYS.DUAL..
.

- Original Message -
From:
Nick
Wagner
To: Multiple recipients of list ORACLE-L

Sent: Wednesday, October 02, 2002 4:53
PM
Subject: RE: select
sequence.nextval from dual contributes to poor perfo

you might want to try increasing the 'cache' size of the
sequence.
If order is not important, and it is being used so often that
it's having locking issues, you may want to create a couple different
sequences, and have them increment by different values (start with 1 increment
by 3, start with 2 increment by 3, start with 3 increment by 3) and have some
switch in a trigger that pulls a value from one of the three sequences.

-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: select sequence.nextval from dual contributes to
poor performan
Hi,
I am looking after an Oracle EE V8.1.6 database on Solaris 2.6
and I have been monitoring the database to try and
look for causes of poor performance. I have been using
Quest SQLLab Vision which is one of the tools around that will look at the SGA directly and sample stats multiple times
/sec. Based upon the information I get back, I
can see that the following query...
SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;
Seems to use a significant amount of resource when you take
into account the number of times it is executed.
The query plan shows a full scan of sys.dual and it
uses significant CPU and I/O.
Is there a better (less resource intensive) way to get the
nextval?? It may seem a little petty but it just
happens that this query is the second highest resource
user when you take into account the number of times it is executed.
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 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

svrmgrl echo v$database in script

2002-10-02 Thread Baker, Barbara



Oracle 8.0.5
Solaris 2.6

List:
I've created a script (ksh) called from elsewhere that shuts down the
database.  I REALLY want to echo the name of the database into my log file
before I shut down.While select name from v$database works fine from
svrmgrl interactively, it throws up in the script.  I'd guess the $ sign is
screwing it up.  (I can get other commands to work within the script.)
However, I don't know what to do about it.

Any ideas?

Thx!!!

Barb

$ svrmgrl

SVRMGR connect internal
Connected.
SVRMGR select name from v$database;
NAME
-
TADENT
1 row selected.


#!/usr/bin/ksh
# $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
# Name: stop_db.sh
# Author:   Barb Baker
# Purpose:  execute shutdown immediate on current database
#   (i.e., database pointed to by current value of ORACLE_SID)

echo Stop oracle instance \${ORACLE_SID}\  at `date` 
   ${ORACLE_HOME}/bin/svrmgrl  EOF
   connect internal
   select name from v_$database;
EOF


$  ./stop_db.sh
Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002


SVRMGR Connected.
SVRMGRselect name from v_
  *
ORA-00942: table or view does not exist
SVRMGR
Server Manager complete.

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

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

Backups

2002-10-02 Thread Robyn Anderson Sands


Hello,

I need some info about backups.  I am working on a customer site, and 
have implemented both exports and hot backups.  Both jobs copy to a 
separate mount point, and a job scripted by another individual then 
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it 
provides a succinct output he can email to non-technicals.  The file 
system is built on a 12 disk A1000 array.  We've provided him with a 
ufsdump script, but he's doesn't want to use it. Can the system be 
recovered from this tape?  Has anyone ever relied on a dd for a daily 
backup method? The system is Oracle 9i on Solaris 8.

Robyn

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

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

2002-10-02 Thread Babu Nagarajan


I have seen comma delimited entries working...

Babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 6:13 PM


Gene,

 utl_file_dir = D:\directory name1
 utl_file_dir = D:\directory name2
 utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 11:25 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

 [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

 [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
 I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
 The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
 Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

  (

   P_Current_Table_Name  In  Varchar2
,

   P_Run_DateIn Date,


   P_Load_Userid In  Varchar2
,

   P_Load_Password   In  Varchar2
,

   P_Load_Service_Name   In  Varchar2
,

   P_Load_Par_File_Dir   In  Varchar2
,

   P_Load_Data_File_Dir  In  Varchar2
,

   P_Load_Control_File_Dir   In  Varchar2  ,

   P_Load_Log_File_Dir   In  Varchar2
,

   P_Load_Bad_File_Dir   In  Varchar2
,

   P_Load_Discard_File_Dir   In  Varchar2

  )

  as

  Begin

  Declare

   L_Par_File_Hand   Utl_FIle.File_Type; -- Local
variable to
hold the File Pointer for the parameter file.



  Begin
   I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
   PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
 -- Open a new parameter file

 L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w');

 -- Print the following lines into the parameter file.

 Utl_File.Put
(L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load
_Service_Name);




 Utl_File.New_Line(L_Par_File_Hand);

 If Not P_Current_Table_Name = 'GLCRET'

 Then

 Utl_File.Put
(L_Par_File_Hand,'Errors=1');

 Else

 Utl_File.Put
(L_Par_File_Hand,'Errors=50');

 End If;

 Utl_File.New_Line(L_Par_File_Hand);

 Utl_File.Put
(L_Par_File_Hand,'Control='||P_Load_Control_File_Dir||'/'||P_Current_Table_N
ame||'.CTL');




 Utl_File.New_Line(L_Par_File_Hand);

RE: Utl_file and OPENVMS

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


I did it like the control_files entry:

utl_file_dir = (C:\TEMP,
D:\OraNT\Archive)

...and it works just fine.

Cheers,
Mike

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


Gene,

 utl_file_dir = D:\directory name1
 utl_file_dir = D:\directory name2
 utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing 
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 11:25 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Utl_file and OPENVMS


i believe its 

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

 [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g. 

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

 [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
 I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
 The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
 Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE 
 
-- -- 
 
LOAD_USERIDLOADITUP 
 
LOAD_PASSWORD  ILOADIT 
 
LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP 
 
LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR] 
 
LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] 
 
LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL] 
 
LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG] 
 
LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD] 
 
LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD] 

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File 
 
  ( 
 
   P_Current_Table_Name  In  Varchar2 
, 
 
   P_Run_DateIn Date,  

 
   P_Load_Userid In  Varchar2 
, 
 
   P_Load_Password   In  Varchar2 
, 
 
   P_Load_Service_Name   In  Varchar2 
, 
 
   P_Load_Par_File_Dir   In  Varchar2 
, 
 
   P_Load_Data_File_Dir  In  Varchar2 
, 
 
   P_Load_Control_File_Dir   In  Varchar2  ,
 
   P_Load_Log_File_Dir   In  Varchar2 
, 
 
   P_Load_Bad_File_Dir   In  Varchar2 
, 
 
   P_Load_Discard_File_Dir   In  Varchar2   
 
  ) 
 
  as 
 
  Begin 
 
  Declare 
 
   L_Par_File_Hand   Utl_FIle.File_Type; -- Local 
variable to
hold the File Pointer for the parameter file. 
 
 
 
  Begin 
   I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
   PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
 -- Open a new parameter file  
 
 L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); 
 
 -- Print the following lines into the parameter file.   
 
 Utl_File.Put
(L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load
_Service_Name);
 
 
 
 
 Utl_File.New_Line(L_Par_File_Hand);  
 
 If Not P_Current_Table_Name = 'GLCRET'  
 
 Then  
 
 Utl_File.Put 
(L_Par_File_Hand,'Errors=1'); 
 
 Else  
 
 Utl_File.Put 
(L_Par_File_Hand,'Errors=50'); 
 
 End If;  
 
 Utl_File.New_Line(L_Par_File_Hand);

Re: svrmgrl echo v$database in script

2002-10-02 Thread Ron Thomas



Sounds like you svrmgrl commands are in a where document.  You need to escape the $, 
ie

select name from v\$database ;



Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   

  [EMAIL PROTECTED] 

   To:   [EMAIL PROTECTED]  

  10/02/02 04:28 PMcc: 

  Please respond toSubject:  svrmgrl echo v$database in 
script 
  ORACLE-L 

   

   






Oracle 8.0.5
Solaris 2.6

List:
I've created a script (ksh) called from elsewhere that shuts down the
database.  I REALLY want to echo the name of the database into my log file
before I shut down.While select name from v$database works fine from
svrmgrl interactively, it throws up in the script.  I'd guess the $ sign is
screwing it up.  (I can get other commands to work within the script.)
However, I don't know what to do about it.

Any ideas?

Thx!!!

Barb

$ svrmgrl

SVRMGR connect internal
Connected.
SVRMGR select name from v$database;
NAME
-
TADENT
1 row selected.


#!/usr/bin/ksh
# $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
# Name: stop_db.sh
# Author:   Barb Baker
# Purpose:  execute shutdown immediate on current database
#   (i.e., database pointed to by current value of ORACLE_SID)

echo Stop oracle instance \${ORACLE_SID}\  at `date` 
   ${ORACLE_HOME}/bin/svrmgrl  EOF
   connect internal
   select name from v_$database;
EOF


$  ./stop_db.sh
Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002


SVRMGR Connected.
SVRMGRselect name from v_
  *
ORA-00942: table or view does not exist
SVRMGR
Server Manager complete.

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

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

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


Try this:

select
   fk.constraint_name
   , pk.table_name pk_table
   , pk.constraint_name pk_constraint
   , pkc.column_name pk_column
from
   dba_constraints fk
   , dba_constraints pk
   , dba_cons_columns pkc
where fk.owner = 'PRJSTAT'
and fk.table_name = 'PROJECTS'
and fk.r_constraint_name = pk.constraint_name
and fk.r_owner = pk.owner
and pkc.owner = fk.owner
and pkc.constraint_name = pk.constraint_name
order by 1,2,pkc.position
/

Jared





Lisa R. Clary [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2002 02:08 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Help find pk dependencies 7.3.4 db


I am trying to find out for a given table the column names for the parent
table to which the referential integrity is built upon. for example, table 
B
has primary keys=id, date_exam  that are a foreign keys to table a, which
has variable name pt_id, date_start. This is the query to deliver the 
pieces
of information, but as soon as I remove the comment line (as I only want 
one
line per return), it becomes a run-away and chews up the temp space. I 
have
looked at this for so long that I am probably missing the obvious.
Any thoughts?

select o.constraint_name ownerconstraint, o.table_name
ownertable,r1.position, r1.column_name, r.constraint_name, r2.position,
r2.column_name
 from all_constraints o,
  (select constraint_name, column_name, position from all_cons_columns 
)
r1,
  all_constraints r,
  (select constraint_name, column_name, position from 
all_cons_columns)
r2
 where o.constraint_name=r1.constraint_name and
   o.constraint_type='R' and
   o.r_constraint_name  = r.constraint_name and
   r.constraint_name = r2.constraint_name and
 ---  r1.position= r2.position and
   o.table_name='NEURO_ASSESSMENT'
 order by o.constraint_name, o.table_name;

lc

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

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



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

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

RE: svrmgrl echo v$database in script

2002-10-02 Thread Sujatha Madan


Hi Barbara!

Try using a  \ before the $.

So your script should read: 

echo Stop oracle instance \${ORACLE_SID}\  at `date` 
   ${ORACLE_HOME}/bin/svrmgrl  EOF
   connect internal
   select name from v\$database;
EOF

Cheers
Suji



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



Oracle 8.0.5
Solaris 2.6

List:
I've created a script (ksh) called from elsewhere that shuts down the
database.  I REALLY want to echo the name of the database into my log file
before I shut down.While select name from v$database works fine from
svrmgrl interactively, it throws up in the script.  I'd guess the $ sign is
screwing it up.  (I can get other commands to work within the script.)
However, I don't know what to do about it.

Any ideas?

Thx!!!

Barb

$ svrmgrl

SVRMGR connect internal
Connected.
SVRMGR select name from v$database;
NAME
-
TADENT
1 row selected.


#!/usr/bin/ksh
# $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
# Name: stop_db.sh
# Author:   Barb Baker
# Purpose:  execute shutdown immediate on current database
#   (i.e., database pointed to by current value of ORACLE_SID)

echo Stop oracle instance \${ORACLE_SID}\  at `date` 
   ${ORACLE_HOME}/bin/svrmgrl  EOF
   connect internal
   select name from v_$database;
EOF


$  ./stop_db.sh
Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002


SVRMGR Connected.
SVRMGRselect name from v_
  *
ORA-00942: table or view does not exist
SVRMGR
Server Manager complete.

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

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

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


Buffer Cache Hit Ratio?

What's that?






Inka Bezdziecka [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/02/2002 08:03 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Performance monitoring


Well ...
 if you need short reports, look for:

1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o 
8. shared pool memory distribution
9. session contention
10. session memory usage

inka

-Original Message-
Sent: Wednesday, October 02, 2002 7:08 AM
To: Multiple recipients of list ORACLE-L


Thak's Mark

I agreed, but they have gotten an idea to get only couple
most important measurements from db, because they don't want
to have a huge reports with all possible statistics. Very 
understandable, but as You wrote, there isn't any absolutely top ten.

In any case, I have to do this (stupid) list, so give Your best shot,
please.

t.Jorma
Ps. I heard, that Dave Ensor from BMC, has once presented that
kind of list? 

-Original Message-
Sent: 02 October, 2002 12:23
To: Multiple recipients of list ORACLE-L


Jorma,

Performance tuning is a complex subject.  There really isn't a list of
10 things to watch for.  Every system is different.

I would (attempt to) summarize tuning by these five steps:

1.)  Have a capacity/performance target in mind.  If you don't know
where you're going, how will you know if you have gotten there?

2.)  Monitor your response times as load increases.  Can you achieve
your response time target at the specified load?  If so, you're done,
successful test, congratulations.  If not, continue to next step.

3.)  Actively monitor what's going on in the database, while it's
happening.  It's always easier to see it in real time than just looking
at random StatsPack snapshots taken at 5 or 10 or 15 minute intervals. 
(Not that I'm saying StatsPack shouldn't be collected.  I'm just saying
don't rely on StatsPack as your only source of info about the
database.)  The V$ Wait Interface is your friend.  If you're not
familiar with it, go to http://www.hotsos.com/ and get Mogens Norgaard's
paper, Introducing the V$ Wait Interface.  Where is the database
spending it's time?  What's the bottleneck?  If you identify a few
trouble sessions, you may want to dive deeper w/ some 10046 traces at
level 8 on specific sessions.  You almost certainly do NOT want to do
this instance wide.

4.)  Once you have some indication as to what's going on in the
database, you need to see how the system is doing overall.  On most
flavors of *nix, where I'm comfortable, sar (System Activity Reporter)
is an excellent tool.  Use it to determine if you have any systemwide
CPU, memory, or I/O contention.  (Other OSes almost certainly have
similar utilities.)

5.)  Address the biggest bottleneck.  This is where it can't be
summarized in a simple step.  You need to understand the bottleneck, so
that you can understand how to tune it.  If may be latch contention. 
Depending on the latch, it could be poorly tuned SQL, or lack of bind
variables, or simple CPU capacity limits, or a whole host of things. 
I/O contention?  Could be anything from poorly designed and/or
configured RAID array to poorly tuned SQL, or who knows what.  Determine
the cause of the biggest bottleneck and minimize or eliminate it.


There you have it, Mark's Simplified Performance Tuning, in five easy
steps! ;-)

-Mark



On Wed, 2002-10-02 at 02:08, [EMAIL PROTECTED] wrote:
 Ave !
 
 I like to hear Your opinion about the most importat
 issues, what should be monitored from the database (8.1.7, SUN) during
 perfomance testing. The purpose in this case, is limit the
 monitoring to concern only about 10 most important ones.
 
 I have difficulties to make my mind to pick up the right ones, so
 if You had to have made similar kind of decisions or have opinions,
 please let me know.
 
 TIA
 Jorma
 -
 Name: Jorma Vuorio  Phone:  +358-9-7180 67759
 Company:  Nokia Business Infrastucture  Fax:+358-9-7180 67465
 Address:  P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND 
 Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043
 -
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
It is not enough to have a good mind.  The main thing is to use it
well.
 -- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com




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

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

RE: svrmgrl echo v$database in script

2002-10-02 Thread Jacques Kilchoer

Title: RE: svrmgrl echo v$database in script





The shell thinks that $database is an environment variable.
Try instead select name from v\$database


 -Original Message-
 From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database. I REALLY want to echo the name of the database 
 into my log file
 before I shut down. While select name from v$database 
 works fine from
 svrmgrl interactively, it throws up in the script. I'd guess 
 the $ sign is
 screwing it up. (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author: Barb Baker
 # Purpose: execute shutdown immediate on current database
 # (i.e., database pointed to by current value 
 of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\ at `date` 
 ${ORACLE_HOME}/bin/svrmgrl  EOF
 connect internal
 select name from v_$database;
 EOF
 
 
 $ ./stop_db.sh
 Stop oracle instance tadent at Wed Oct 2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGR select name from v_
 *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.

Failed to archive log....

2002-10-02 Thread Hussain Ahmed Qadri

Title: Failed to archive log





Hi all,


I just wanted a little insight on the following entries of my alert log file;
---

ARC0: Beginning to archive log# 3 seq# 51809
ARC0: Failed to archive log# 3 seq# 51809
Tue Oct 01 09:32:37 2002
ARC4: Beginning to archive log# 3 seq# 51809
ARC4: Failed to archive log# 3 seq# 51809
ARC4: Beginning to archive log# 4 seq# 51810
Tue Oct 01 09:32:37 2002
ARC0: Beginning to archive log# 4 seq# 51810
ARC0: Failed to archive log# 4 seq# 51810
Tue Oct 01 09:32:40 2002
Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x.02bfbd05
Tue Oct 01 09:32:41 2002
ARC3: Completed archiving log# 3 seq# 51809
---

ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive the same log seq# and it failed again but then the same archiver process (ARC4) started archiving next seq# and failed again. After a few seconds ARC0 successfully archives 51809. Similarly rest of the seq# get archived to after a few tries by one archiver or the other. This behavior is not regular, it appears off and on, most of the times there is no failing, and everything proceeds normally. 

I was wondering if any of you can explain the following points to help improve my concepts, 


* Is FAILING temporarily any threat? 
* What could be the reason for it?
* If the first archiver fails (ARC0) and then the second (ARC4) fails too, why does it try to archive the next seq# rather than finishing the previous one?

* Any reason for this inconsistency?


Thanks  Regards,
Hussain Ahmed Qadri
DBA 
SKMCHRC

Re: Backups

2002-10-02 Thread Ray Stell



Yes, you can use dd to read a tape.

from man dd:

 Example 3: Reading a Tape Into an ASCII File

 This example reads an EBCDIC tape blocked ten 80-byte EBCDIC
 card images per block into the ASCII file x:

 example% dd if=/dev/tape of=x ibs=800 cbs=80 conv=ascii,lcase


Are you going to sleep well until you have tested and documented
the recovery procedure?  No.  




On Wed, Oct 02, 2002 at 04:08:27PM -0800, Robyn Anderson Sands wrote:
 Hello,
 
 I need some info about backups.  I am working on a customer site, and 
 have implemented both exports and hot backups.  Both jobs copy to a 
 separate mount point, and a job scripted by another individual then 
 moves the files to tape.
 
 Here's the problem - he's using a dd command, primarily because it 
 provides a succinct output he can email to non-technicals.  The file 
 system is built on a 12 disk A1000 array.  We've provided him with a 
 ufsdump script, but he's doesn't want to use it. Can the system be 
 recovered from this tape?  Has anyone ever relied on a dd for a daily 
 backup method? The system is Oracle 9i on Solaris 8.
 
 Robyn
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

2002-10-02 Thread Rachel Carmichael


we're hiring a hosting company to manage and monitor our production
apps... they handed me their spreadsheet of Oracle things to
monitor... I finally found wait events on that list. Buffer cache hit
ratios were high on the list and flagged as critical

nuh uh, didn't have time to gently explain (with the two by four) that
that was going to be unacceptable. But I will have loads of time
tomorrow. What scares me is that this list was compiled by
experienced DBAs.

--- [EMAIL PROTECTED] wrote:
 Buffer Cache Hit Ratio?
 
 What's that?
 
 
 
 
 
 
 Inka Bezdziecka [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  10/02/2002 08:03 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Performance monitoring
 
 
 Well ...
  if you need short reports, look for:
 
 1. waits
 2. buffer cache hit ratio
 3. dictionary hit ratio
 4. library hit ratio
 5. latches
 6. parsing/execution ratio
 7. data file i/o 
 8. shared pool memory distribution
 9. session contention
 10. session memory usage
 
 inka
 
 -Original Message-
 Sent: Wednesday, October 02, 2002 7:08 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Thak's Mark
 
 I agreed, but they have gotten an idea to get only couple
 most important measurements from db, because they don't want
 to have a huge reports with all possible statistics. Very 
 understandable, but as You wrote, there isn't any absolutely top ten.
 
 In any case, I have to do this (stupid) list, so give Your best shot,
 please.
 
 t.Jorma
 Ps. I heard, that Dave Ensor from BMC, has once presented that
 kind of list? 
 
 -Original Message-
 Sent: 02 October, 2002 12:23
 To: Multiple recipients of list ORACLE-L
 
 
 Jorma,
 
 Performance tuning is a complex subject.  There really isn't a list
 of
 10 things to watch for.  Every system is different.
 
 I would (attempt to) summarize tuning by these five steps:
 
 1.)  Have a capacity/performance target in mind.  If you don't know
 where you're going, how will you know if you have gotten there?
 
 2.)  Monitor your response times as load increases.  Can you achieve
 your response time target at the specified load?  If so, you're done,
 successful test, congratulations.  If not, continue to next step.
 
 3.)  Actively monitor what's going on in the database, while it's
 happening.  It's always easier to see it in real time than just
 looking
 at random StatsPack snapshots taken at 5 or 10 or 15 minute
 intervals. 
 (Not that I'm saying StatsPack shouldn't be collected.  I'm just
 saying
 don't rely on StatsPack as your only source of info about the
 database.)  The V$ Wait Interface is your friend.  If you're not
 familiar with it, go to http://www.hotsos.com/ and get Mogens
 Norgaard's
 paper, Introducing the V$ Wait Interface.  Where is the database
 spending it's time?  What's the bottleneck?  If you identify a few
 trouble sessions, you may want to dive deeper w/ some 10046 traces at
 level 8 on specific sessions.  You almost certainly do NOT want to do
 this instance wide.
 
 4.)  Once you have some indication as to what's going on in the
 database, you need to see how the system is doing overall.  On most
 flavors of *nix, where I'm comfortable, sar (System Activity
 Reporter)
 is an excellent tool.  Use it to determine if you have any systemwide
 CPU, memory, or I/O contention.  (Other OSes almost certainly have
 similar utilities.)
 
 5.)  Address the biggest bottleneck.  This is where it can't be
 summarized in a simple step.  You need to understand the bottleneck,
 so
 that you can understand how to tune it.  If may be latch contention. 
 Depending on the latch, it could be poorly tuned SQL, or lack of bind
 variables, or simple CPU capacity limits, or a whole host of things. 
 I/O contention?  Could be anything from poorly designed and/or
 configured RAID array to poorly tuned SQL, or who knows what. 
 Determine
 the cause of the biggest bottleneck and minimize or eliminate it.
 
 
 There you have it, Mark's Simplified Performance Tuning, in five easy
 steps! ;-)
 
 -Mark
 
 
 
 On Wed, 2002-10-02 at 02:08, [EMAIL PROTECTED] wrote:
  Ave !
  
  I like to hear Your opinion about the most importat
  issues, what should be monitored from the database (8.1.7, SUN)
 during
  perfomance testing. The purpose in this case, is limit the
  monitoring to concern only about 10 most important ones.
  
  I have difficulties to make my mind to pick up the right ones, so
  if You had to have made similar kind of decisions or have opinions,
  please let me know.
  
  TIA
  Jorma
  -
  Name: Jorma Vuorio  Phone:  +358-9-7180 67759
  Company:  Nokia Business Infrastucture  Fax:+358-9-7180 67465
  Address:  P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND 
  Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043

Re: Backups


I've relied on dd, mainly when working with raw devices.  dd is
probably one of the oldest commands in the UNIX lexicon.  It's just another
way to get the job done...

soapbox rant
RMAN is a *much* better solution.  After all, how are these exports, backup
scripts, and what-not going to check the database for block corruption?  For
archived redo logfile corruption?  How will someone be able to determine how
many backups are on tape for each datafile and archived redo logfile?  Can
you do trial restores, to test what's on tape?  Will any restore/recovery
scenarios be scripted?
/soapbox rant

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 6:08 PM


 Hello,

 I need some info about backups.  I am working on a customer site, and
 have implemented both exports and hot backups.  Both jobs copy to a
 separate mount point, and a job scripted by another individual then
 moves the files to tape.

 Here's the problem - he's using a dd command, primarily because it
 provides a succinct output he can email to non-technicals.  The file
 system is built on a 12 disk A1000 array.  We've provided him with a
 ufsdump script, but he's doesn't want to use it. Can the system be
 recovered from this tape?  Has anyone ever relied on a dd for a daily
 backup method? The system is Oracle 9i on Solaris 8.

 Robyn

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

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

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

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

Re: Failed to archive log....

2002-10-02 Thread Mohammad Rafiq


There were lot of delete/update/insert at that time on your database and 
your archiving was too much at that time...
also try to use separate disk/mount time for your arch destination to avoid 
write contention at that time

Regards
Rafiq



Indicator

to increase size of your redologs or add some more group members


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 02 Oct 2002 16:58:22 -0800

Hi all,

I just wanted a little insight on the following entries of my alert log
file;

---
ARC0: Beginning to archive log# 3 seq# 51809
ARC0: Failed to archive log# 3 seq# 51809
Tue Oct 01 09:32:37 2002
ARC4: Beginning to archive log# 3 seq# 51809
ARC4: Failed to archive log# 3 seq# 51809
ARC4: Beginning to archive log# 4 seq# 51810
Tue Oct 01 09:32:37 2002
ARC0: Beginning to archive log# 4 seq# 51810
ARC0: Failed to archive log# 4 seq# 51810
Tue Oct 01 09:32:40 2002
Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x.02bfbd05
Tue Oct 01 09:32:41 2002
ARC3: Completed archiving log# 3 seq# 51809

---
ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive
the same log seq# and it failed again but then the same archiver process
(ARC4) started archiving next seq# and failed again. After a few seconds
ARC0 successfully archives 51809. Similarly rest of the seq# get archived to
after a few tries by one archiver or the other. This behavior is not
regular, it appears off and on, most of the times there is no failing, and
everything proceeds normally.
I was wondering if any of you can explain the following points to help
improve my concepts,

* Is FAILING temporarily any threat?
* What could be the reason for it?
* If the first archiver fails (ARC0) and then the second (ARC4) fails too,
why does it try to archive the next seq# rather than finishing the previous
one?
* Any reason for this inconsistency?

Thanks  Regards,
Hussain Ahmed Qadri
DBA
SKMCHRC





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

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

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

Re: Sample Pro*C code for TAF in 8iOPS/9iRAC

2002-10-02 Thread Scott


Tim, TAF still requires the application to be
programmed with Oracle8 OCI and greater. TAF is a
combination of OCI and net services to allow the
failover to occur. This requirement is still
documented in the Oracle9i R2 manuals.

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/rac.920/a96597/pshavdtl.htm#20180

Scott

--- Tim Gorman lt;[EMAIL PROTECTED]gt; wrote:
gt; Hemant,
gt; 
gt; TAF was specific to OCI only in v8.0 of the
gt; database.  In v8.1 and upwards, it is specified
for
gt; any application or API in the TNSNAMES entry...
gt; 
gt; This example comes straight out of the
#34;Oracle Net8
gt; Administration#34; manual, page 8-14.  I'd
suggest
gt; reading up on the meaning of the FAILOVER_MODE
gt; settings, specifically TYPE= and METHOD=.  Also,
if
gt; you have your OPS/RAC instances in a pure
gt; #34;active/passive#34; arrangement, then the
TNS entry
gt; below should work (i.e. LOAD_BALANCE=OFF).  If
you
gt; have both instances equally available for user
gt; connections (i.e. #34;active/active#34;
failover
gt; arrangement), then you might consider changing
gt; LOAD_BALANCE=ON to distribute the connections
gt; randomly.  However, you'll want to think
carefully
gt; about using that mechanism...  :-)
gt; 
gt;   sales.us.acme.com=
gt;   (description=
gt;   (load_balance=off)
gt;   (failover=on)
gt;   (address_list=
gt;   (address=
gt;   (protocol=tcp)
gt;   (host=sales1-server)
gt;   (port=1521)
gt;   )
gt;   (address=
gt;   (protocol=tcp)
gt;   (host=sales2-server)
gt;   (port=1521)
gt;   )
gt;   )
gt;   (connect_data=
gt;   (service_name = sales.us.acme.com)
gt;   (failover_mode =
gt; (type=select)(method=basic))
gt;   )
gt;   )
gt; Hope this helps...
gt; 
gt; -Tim
gt; 
gt; - Original Message - 
gt; To: #34;Multiple recipients of list
ORACLE-L#34;
gt; lt;[EMAIL PROTECTED]gt;
gt; Sent: Wednesday, October 02, 2002 10:13 AM
gt; 
gt; 
gt; gt; 
gt; gt; 
gt; gt; Can anyone send me sample Pro*C code
depicting how
gt; gt; they've handled TAF in 8iOPS or 9iRAC ?
gt; gt; 
gt; gt; We've got some application servers running
Pro*C
gt; programs
gt; gt; which don't seem to able to handle failover.
gt; SQLPlus sessions
gt; gt; are failing over to the remaining instance
but the
gt; Pro*C programs
gt; gt; seem to be #34;hanging#34;, without
returning any error,
gt; when
gt; gt; a transaction is #34;in-flight#34;  We do
know that
gt; Insert/Update/Deletes
gt; gt; do not really failover but are wondering how
the
gt; Pro*C programs
gt; gt; could be written to handle the oracle error
on
gt; session failover
gt; gt; and resubmit the transaction.
gt; gt; 
gt; gt; 
gt; gt; Hemant K Chitale
gt; gt; My web site page is : 
http://hkchital.tripod.com
gt; gt; 
gt; gt; 
gt; gt; -- 
gt; gt; Please see the official ORACLE-L FAQ:
gt; http://www.orafaq.com
gt; gt; -- 
gt; gt; Author: Hemant K Chitale
gt; gt;   INET: [EMAIL PROTECTED]
gt; gt; 
gt; gt; Fat City Network Services-- 858-538-5051
gt; http://www.fatcity.com
gt; gt; San Diego, California-- Mailing list
and
gt; web hosting services
gt; gt;
gt;
-
gt; gt; To REMOVE yourself from this mailing list,
send an
gt; E-Mail message
gt; gt; to: [EMAIL PROTECTED] (note EXACT
spelling of
gt; 'ListGuru') and in
gt; gt; the message BODY, include a line containing:
UNSUB
gt; ORACLE-L
gt; gt; (or the name of mailing list you want to be
gt; removed from).  You may
gt; gt; also send the HELP command for other
information
gt; (like subscribing).
gt; 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sample Pro*C code for TAF in 8iOPS/9iRAC