date:20020205


Hello Seema

Oracle magazine for 01-02/2002 has on page 91 an article 
that gives step by step instructions on this issue for 9i.
They also have a reference to:
http://www.oracle.com/oramag/oracle/jan02/metadata.html

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Mon, February 04, 2002 7:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  HOW TO KNOW INDEX NOT IN USE?
 
 Hi
 I there any view which can tell us which indexes are not in use?
 Thx
 -Seema
 
 
 
 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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


Hello Sameer

The manual in this case is :
Oracle8i Utilities
Release 2 (8.1.6)
See case study number 5: loading data into multiply tables.
In your case do three different loads into the same table.
I just hope that you can load into one table in this case.


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Ghadge,Sameer [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, February 05, 2002 10:05 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  how to Loading data file (SQL LOADER)
 
 Hi all,
 Just think some how i have foll. file(I have a data file coming from
 VAX/VMS
 machine,on unix machine ,but i currently want soln for WIN2000)
 
 HDR 280120022044
 SELL031128012002ESP051712311ESP28A
 SELL055728012002EUR0020011534557EUR28A
 SELL015728012002USD0005003289157USD28A
 SELL005328012002USD0010006579053USD28A
 SELL046428012002EUR0060034602464EUR28A
 TRL 000137
 Record structure
 Record Size:54 Bytes
 -- Record Contents --
 Item TypeSize  Occ  Offset
 IMX-HEADER-RECORDCHARACTER 540
 .IMX-HEADER-TYPE CHARACTER  40
 .PROCESS-DATECHARACTER 124
_IMX-DETAIL-RECORDCHARACTER 540
 .IMX-DETAIL-TYPE CHARACTER  40
 .SHOP-NUMBER CHARACTER  44
 .TRANSACTION-DATECHARACTER  88
 .CURRENCY-CODE   CHARACTER  3   16
 Item TypeSize  Occ  Offset
 .IMX-CURRENCY-VALUE  ZONED UNSIGNED13   19
 .IMX-STERLING-EQUIVALENT ZONED UNSIGNED13   32
 .REFERENCE-NUMBERCHARACTER  9   45
_IMX-TRAILER-RECORD   CHARACTER 540
 .IMX-TRAILER-TYPECHARACTER  40
 .IMX-RECORD-COUNTZONED UNSIGNED 64
 
 
 
 How do I load this using SQLoader (is it possible)
 ya u all must be thinking ,i m loading flat file in a table and not
 applying
 RDBMS (normalization) concepts.
 but that the way i have to do,(now don't ask why? we'll discuss off the
 list)
 
 so my table struct is as foll.
 NameNull?Type
 ---  
 IMX_REC_TYPE  NOT NULL VARCHAR2(4)
 SHOP_NO   VARCHAR2(4)
 TRANSACTION_DATE  DATE
 CURRENCY_CODE   VARCHAR2(3)
 IMX_CURRENCY_VALUE  NUMBER(13)
 IMX_STERLING_EQUIVALENT   NUMBER(13)
 REFERENCE_NUMBERVARCHAR2(9)
 PROCESS_DATE DATE
 IMX_RECORD_COUNT  NUMBER(6)
 IMX_REC_NO   NUMBER(6)
 
 any help is appreciated
 using oracle 8.1.6 on win2000
 Thx
 Sameer
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ghadge,Sameer
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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


Hello Erik

I followed this thread (about 15 messages so far) and I think that
you can run  this as an OEM job running host script.
This will avoid all connection problem.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Erik Williams [SMTP:[EMAIL PROTECTED]]
 Sent: Mon, February 04, 2002 9:13 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  NOHUP SQLPLUS
 
 I am going to be executing a long running job this weekend from home. I am
 going to VPN into the corp network and telnet to the server. I am affraid
 of
 loosing my telnet terminal session and the job dying mid way through. The
 plan is to use 'nohup sqlplus system/* @long_running.sql'. Has anyone
 used this or run into issues using it? Every time I assume something will
 'just work', IT DOESNT!
 
 Thanks
 Erik 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Erik Williams
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Mark Leith


Check out Heterogeneous Services and Transparent Gateways on
http://otn.oracle.com . I believe that it is possible using a mixture of
these two.. Heterogeneous Services are also described pretty well in the
Net8 Admin Guide, Section 8 Advanced Net8 Features - Configuring Connections
to Non-Oracle Database Services.

HTH

Mark

-Original Message-
Peter
Sent: 04 February 2002 21:11
To: Multiple recipients of list ORACLE-L


We are working on an application which runs under AIX, using
Oracle which needs access to some data stored in a legacy app
using DB2 on OS/390.  Is it possible to create a DBLink in
the Oracle database so that we can query from the DB2 instance?

thanks,

Peter Schauss
Northrop Grumman Corporation
516-346-3148
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Dropping user hangs indefnitely

2002-02-05 Thread SARKAR, Samir


Hi list,

Can anybody help me how to identify why the dropping of a particular user
hangs indefnitely ??

Database is 8.1.7 on Solaris 7.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

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

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

2002-02-05 Thread K Gopalakrishnan


Probably that user might have connected to the instance. Check V$session.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Samir
Sent: Tuesday, February 05, 2002 1:41 AM
To: Multiple recipients of list ORACLE-L


Hi list,

Can anybody help me how to identify why the dropping of a particular user
hangs indefnitely ??

Database is 8.1.7 on Solaris 7.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018



___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___

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

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

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

Euro Character Set

2002-02-05 Thread Malik, Fawzia



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

2002-02-05 Thread Sandeep Kurliye

User may be having many tables, and that's why taking lots of time to drop.

 -Original Message-
Sent:   Tuesday, February 05, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Dropping user hangs indefnitely

Hi list,

Can anybody help me how to identify why the dropping of a particular user
hangs indefnitely ??

Database is 8.1.7 on Solaris 7.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018

___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___

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

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

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

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

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

2002-02-05 Thread SARKAR, Samir


Thanks for your reply, Gopalakrishnan. I did check whether the user has 
logged into the database but I got a negative.
However, I did come across the following possiblity but I am not sure of
this so 
could u please throw some light on it ?? 

We have a context server running Intermedia applications which accesses the
the objects held by that user (the user trying to b dropped). Is there a
chance
of a lock being held on one of those objects due to which the dropping of
the user
takes forever ?? Will it help if we shutdown the context server which runs
the
Intermedia applications before we try to drop the user ??

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 05 February 2002 10:30
To: Multiple recipients of list ORACLE-L


Probably that user might have connected to the instance. Check V$session.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Samir
Sent: Tuesday, February 05, 2002 1:41 AM
To: Multiple recipients of list ORACLE-L


Hi list,

Can anybody help me how to identify why the dropping of a particular user
hangs indefnitely ??

Database is 8.1.7 on Solaris 7.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018



___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___

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

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

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

2002-02-05 Thread Mark Leith


The Euro symbol is in WE8ISO8859P15. 

HTH

Mark 

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance 


-Original Message-
Fawzia
Sent: 05 February 2002 10:40
To: Multiple recipients of list ORACLE-L



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

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

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

RE: Euro Character Set

2002-02-05 Thread Malik, Fawzia



Thanks. We currently have WE8IS08859P1 set...to display a euro symbol, would
I need to alter the nls parameters to do this then??

Thanks
-Original Message-
Sent: 05 February 2002 11:56
To: Multiple recipients of list ORACLE-L


The Euro symbol is in WE8ISO8859P15. 

HTH

Mark 

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance 


-Original Message-
Fawzia
Sent: 05 February 2002 10:40
To: Multiple recipients of list ORACLE-L



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

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

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

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

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

9i data guard broker

2002-02-05 Thread Joe Testa


Anyon on the list using 9i data guard broker?,  I've been trying 
unsucessfully for days to get rid of some configurations via the 
CLI(dgmgrl) and via the GUI(OEM) to no avail.

Seems the info is buried in some table in the oem repository(or other 
files under $ORACLE_HOME).

OS: Linux, oracle 9.0.1.2

Would appreciate anyone's insight.

thanks, joe


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

2002-02-05 Thread Bjørn Engsig

Title: Message



With the caveat, that I am a consultant and not actually a DBA, I would argue
very strongly, that the OPS DBA needs quite some extra understanding, knowledge
and experience compared to one managing a single instance Oracle. In particular:

- Performance problems, primarily due to poor application design/development,
that are seen in single instance are likely to be one to two orders of magnitude
worse in OPS. Hence, the DBA needs a much better application understanding.

- There are Oracle features (e.g. free list groups) that must be used with
OPS and which rarely are needed single instance.

- Recovery scenarios are more complex

- You must use raw devices (except on platforms with inhertance from Digital
Corp), which can add complexity

- A frequent requirement of OPS systems is better uptimes than for single
instance, which is a very non-trivial task. The whole stack is far more
complex, and even though the possibility to have two or more independent
nodes sound really great in theory, the practical assurance, that they are
in fact completely independent is difficult. And if they aren't independent,
they are likely to have worse uptimes than the single instance!

- And I probably forgot something, so it is far more than knowing the GC_
parameters, which, BTW, by itself isn't that simple!

- Also, BTW, note that except for a few things, RAC doesn't make your life
easier than OPS!

Thanks, Bjrn.

Shreeni wrote:

  
  
  
  
  
  
  
  
  
Hi  John,
  
  
Thx for the  input. I really appreciate it. I was just kind of stumped when
I was asked not  once but several times and places, to point out the diff
between an OPS DBA and  a "regular" DBA that I am.
  
  
Thanks  again
  
  
Shreeni
  
Shreenivasa Rao
  e-Z
ing  Technologies,
 Inc..
41-43 Beekman Street, 3rd Floor
New York, NY 10038.
Tel:  (212)233-9861 xt.241
Fax: (212)233-9862
Cell:(917)861-4966
  
lsama@e-zingtech.com
  
  ***
**Your IT Solutions  Provider
*** *** 
http://www.e-zingtech.com

***
Under Bill s.1618  Title III passed by the 105th U.S. Congress this mail
can
not be considered  spam as long as we include contact information and a remove
link for removal  from our mailing list. To be removed from our mailing list
reply with remove in  the subject heading and your email address in the body.
Include complete address  and/or domain to be  removed.

  

-Original Message-
From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf
Of Hallas John
Sent:Monday, February 04, 2002 4:05 AM
To: Multiple recipients of listORACLE-L
Subject: OPS DBA work (was dumbquestion)



Shreeni,


Themangement of a OPS system does not require any extra skills or facilities.
   Areas that are different or need more attention from a standalone instance
   include the following :


Management and tuning of internode communication.Specifically reducing
the level of pinging - use of GC% init.oravariables

Requirement for different start up scripts (exclusiveand shared modes)

Someadditional work when duplicating databases using RMAN

Perhaps more involvement with application and sysadmin teams to determine
load balancing factors


Iam sure there are others (probably ones Ishould be doing that I am
not)



Thesimplest thing to remember about OPS is that there is only 1 set of
datafilesand therefore tables, despite the number of instances that may
be using thosedatafiles.Thispoint is occasionally madeto thosewhob
   elieve that we have a fully resilient setup.



HTH


John

  
-Original Message-
  From: Shreeni  [mailto:[EMAIL PROTECTED]]
  Sent: 04 February 2002  00:40
  To: Multiple recipients of list ORACLE-L
  Subject:  Dumb question
  
  
  
Hi  List,
  
  
To ask a  dumb question, is there any special way to run exp/imp on Oracle
Parallel  server on Solaris ?? Is parallel server DBA different than
a "regular" DBA  ?? :)
  
  
TIA
  
  
Shreeni
  
Shreenivasa  Rao
  e-Z
ing Technologies,
Inc..
41-43 Beekman Street, 3rd Floor
New York,  NY 10038.
Tel: (212)233-9861 xt.241
Fax:  (212)233-9862
Cell:(917)861-4966
  
lsama@e-zingtech.com
  
  ***
**Your IT Solutions  Provider
*** *** 
http://www.e-zingtech.com

***
Under Bill s.1618  Title III passed by the 105th U.S. Congress this mail
can
not be  considered spam as long as we include contact information and
a remove link  for removal from our mailing list. To be removed from
our mailing list reply  with remove in the subject heading and your email
address in the body.  Include complete address and/or domain to be  
   removed.

Book suggestion

2002-02-05 Thread Roland . Skoldblom


Hallo,

Is there anyone who knows about any book which deals with  the connection 
Oracle(PL/SQL) and Access..

Thanks in advance

Roland


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

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

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

RE: How to find out what caused job to fail?

2002-02-05 Thread Jamadagni, Rajendra


One of the reason a failed job leaves us clueless is failure of coding the
right way. If you have a failure, you must capture enough information about
the failure and dump it somewhere so that you can go back and make use of
the dumped information to debug the problem.

I'd say, that will be a good start.

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

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

-Original Message-
Sent: Monday, February 04, 2002 3:40 AM
To: Multiple recipients of list ORACLE-L


Hi! 
Is there a way to find out, why a database job failed? in dba_jobs (or
user_jobs), I can only see that it failed, but no indication of the reason
why it failed. Any ideas?
This is 8.1.7 on Solaris. 
Thanks, 
Helmut 


***1

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

***1

RE: Euro Character Set

2002-02-05 Thread nlzanen1



Hi


Unfortunately No.

You need to re-create the database and export / import the data

There are some differnces with other characters for which the conversion
could pose problems. Info can be found on metalink


Jack




Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002 13:20:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


Thanks. We currently have WE8IS08859P1 set...to display a euro symbol,
would
I need to alter the nls parameters to do this then??

Thanks
-Original Message-
Sent: 05 February 2002 11:56
To: Multiple recipients of list ORACLE-L


The Euro symbol is in WE8ISO8859P15.

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance


-Original Message-
Fawzia
Sent: 05 February 2002 10:40
To: Multiple recipients of list ORACLE-L



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**

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

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

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

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

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

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

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




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.

RE: OPS DBA work (was dumb question)

2002-02-05 Thread Hallas John

Title: Message



Bjorn, 

I 
don't have any issues with what you say - in fact it really agrees mostly with 
what I stated. You have added 2 important factors though, better application 
knowledge and use of raw file systems.
I use 
Compaq Tru64 so that does not require raw files systems but other o/s certainly 
do.

I 
think you were a bit unfair to suggest thatI meant you 
only needed to check a few init.ora parameters out ( 'it is far more than 
knowing the GC_ parameters' ). I am fully aware of the need to look at freelists 
and freelist groups - I encompassed that in my statement 

'Management and tuning of internode communication. 
Specifically reducing the level of pinging - use of GC% init.ora 
variables'

Anyway 
I don't think we are that far away from each 
other

Regards

John



-Original Message-From: 
Bjørn Engsig [mailto:[EMAIL PROTECTED]]Sent: 05 February 20021
 2:25To: Multiple recipients of list ORACLE-LSubject: Re: 
OPS DBA work (was dumb question)
With the caveat, that I am a consultant and not actually a 
  DBA, I would argue very strongly, that the OPS DBA needs quite some extra
  understanding, knowledge and experience compared to one managing a single
  instance Oracle. In particular:- Performance problems, primarily 
  due to poor application design/development, that are seen in single instance 
  are likely to be one to two orders of magnitude worse in OPS. Hence, the 
  DBA needs a much better application understanding.- There are Oracle 
  features (e.g. free list groups) that must be used with OPS and which rarely 
  are needed single instance.- Recovery scenarios are more 
  complex- You must use raw devices (except on platforms with inhertance 
  from Digital Corp), which can add complexity- A frequent requirement 
  of OPS systems is better uptimes than for single instance, which is a very 
  non-trivial task. The whole stack is far more complex, and even though 
  the possibility to have two or more independent nodes sound really great in 
  theory, the practical assurance, that they are in fact completely independent 
  is difficult. And if they aren't independent, they are likely to have 
  worse uptimes than the single instance!- And I probably forgot 
  something, so it is far more than knowing the GC_ parameters, which, BTW, by 
  itself isn't that simple!- Also, BTW, note that except for a few
  things, RAC doesn't make your life easier than OPS!Thanks, 
  Bjørn.Shreeni wrote:
  






Hi 
John,

Thx for 
the input. I really appreciate it. I was just kind of stumped when I was 
asked not once but several times and places, to point out the diff between 
an OPS DBA and a "regular" DBA that I am.

Thanks 
again

Shreeni
Shreenivasa 
Raoe-Z 
ing Technologies, 
Inc..41-43 Beekman Street, 3rd FloorNew York, NY 10038.Tel:
(212)233-9861 xt.241Fax: 
(212)233-9862Cell:(917)861-4966lsama@e-zingtech.com 
*Your IT Solutions
Provider*** *** http://www.e-zingtech.com  ***Under Bill s.1618 Title III passed by the 105th U.S. 
Congress this mail cannot be considered spam as long as we include
contact information and a remove link for removal from our mailing list. To 
be removed from our mailing list reply with remove in the subject heading 
and your email address in the body. Include complete address and/or domain 
to be 
removed.

  -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf 
  Of Hallas JohnSent: Monday, February 04, 2002 4:05 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  OPS DBA work (was dumb question)
  Shreeni,
  
  The mangement of a OPS system does not require 
  any extra skills or facilities. Areas that are different or need more
  attention from a standalone instance include the following 
  :
  
  Management and tuning of internode communication. 
  Specifically reducing the level of pinging - use of GC% init.ora 
  variables
  Requirement for different start up scripts
  (exclusive and shared modes)
  Some additional work when duplicating databases 
  using RMAN
  Perhaps more involvement with application and sys 
  admin teams to determine load balancing factors
  
  Iam sure there are others (probably ones I 
  should be doing that I am not)
  
  
  The simplest thing to remember about OPS is that 
  there is only 1 set of datafiles and therefore tables, despite the number 
  of instances that may be using those datafiles.Thispoint is 
  occasionally madeto thosewhob elieve that we have a fully
  resilient set up.
  
  HTH
  
  John
  
-Original Message-From: Shreeni [mailto:[EMAIL PROTECTED]]Sent: 
04 February 2002 00:40To:

Re: Euro Character Set

2002-02-05 Thread Marin Dimitrov





 The Euro symbol is in WE8ISO8859P15.


MetaLink note 68790.1 lists few more:

EL8ISO8859P7 , WE8EBCDIC1140 , D8EBCDIC1141  ,DK8EBCDIC1142 , S8EBCDIC1143
, I8EBCDIC1144  , WE8EBCDIC1145 , WE8EBCDIC1146 , F8EBCDIC1147  ,
WE8EBCDIC1148 , WE8PC858  , EE8MSWIN1250  ,CL8MSWIN1251  , WE8MSWIN1252
, EL8MSWIN1253  , TR8MSWIN1254  , IW8MSWIN1255  , AR8MSWIN1256  ,
BLT8MSWIN1257 and of course AL24UTFFSS   and UTF8


hth,

Marin



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




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

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

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

RE: Dropping user hangs indefnitely

2002-02-05 Thread Mark Leith


I think that might be a good start..

-Original Message-
Samir
Sent: 05 February 2002 11:30
To: Multiple recipients of list ORACLE-L


Thanks for your reply, Gopalakrishnan. I did check whether the user has 
logged into the database but I got a negative.
However, I did come across the following possiblity but I am not sure of
this so 
could u please throw some light on it ?? 

We have a context server running Intermedia applications which accesses the
the objects held by that user (the user trying to b dropped). Is there a
chance
of a lock being held on one of those objects due to which the dropping of
the user
takes forever ?? Will it help if we shutdown the context server which runs
the
Intermedia applications before we try to drop the user ??

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 05 February 2002 10:30
To: Multiple recipients of list ORACLE-L


Probably that user might have connected to the instance. Check V$session.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Samir
Sent: Tuesday, February 05, 2002 1:41 AM
To: Multiple recipients of list ORACLE-L


Hi list,

Can anybody help me how to identify why the dropping of a particular user
hangs indefnitely ??

Database is 8.1.7 on Solaris 7.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018



___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___

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

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

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

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

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

RE: Dropping user hangs indefnitely


before shutting down the server why not look to see if there are locks
on the objects?


--- Mark Leith [EMAIL PROTECTED] wrote:
 I think that might be a good start..
 
 -Original Message-
 Samir
 Sent: 05 February 2002 11:30
 To: Multiple recipients of list ORACLE-L
 
 
 Thanks for your reply, Gopalakrishnan. I did check whether the user
 has 
 logged into the database but I got a negative.
 However, I did come across the following possiblity but I am not sure
 of
 this so 
 could u please throw some light on it ?? 
 
 We have a context server running Intermedia applications which
 accesses the
 the objects held by that user (the user trying to b dropped). Is
 there a
 chance
 of a lock being held on one of those objects due to which the
 dropping of
 the user
 takes forever ?? Will it help if we shutdown the context server which
 runs
 the
 Intermedia applications before we try to drop the user ??
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED] 
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 -Original Message-
 Sent: 05 February 2002 10:30
 To: Multiple recipients of list ORACLE-L
 
 
 Probably that user might have connected to the instance. Check
 V$session.
 
 
 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA
 
 
 
 -Original Message-
 Samir
 Sent: Tuesday, February 05, 2002 1:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi list,
 
 Can anybody help me how to identify why the dropping of a particular
 user
 hangs indefnitely ??
 
 Database is 8.1.7 on Solaris 7.
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 

___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented
 are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have
 received
 this
 email in error and that any use, dissemination, forwarding, printing,
 or
 copying of this email is strictly prohibited.
 
 If you have received this email in error please notify the
 SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.

___
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: SARKAR, Samir
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: SARKAR, Samir
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mark Leith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San

export/import on the same server


I have a question on the export/import utility.  I have my live(PROD)
and test(TEST) databases are on the same server.  These are basically
the same schemas except that the data in TEST is old and that the
datafiles for PROD are on I: drive and the datafiles for TEST are on E:
drive.
My question is, since these are on the same server do I have to worry
about which data files will be written to during the import.  For
example;
I do a full export of my PROD database.  When I do my import into my
TEST database will the data automatically go to E: drive or will it
still be pointing to I: drive?  I am reading the Import section of the
fine manual but am a bit confused on the datafiles part of it when doing
a full export/import.  Do I need to use the DESTROY=N parameter?
I am new to this utility but want to learn it.  I am reading the manuals
and some other reading material but still am not clear on this.  I do
not want it to start overwriting my live data.  That is not good for job
security.

Thanks,

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

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

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

2002-02-05 Thread Bjørn Engsig

Title: Message



You're right John - my comments were clearly more of a general nature than
specific followup to your statements.

The cool thing is that I expect to get lots of nice business to do if/when
people start following Larry's vision: Many nodes of cheap hardware with
Linux and RAC on top:-)

Rgds, Bjrn. 

Hallas John wrote:

  
  
  
Bjorn,  
  
I  don't have any issues with what you say - in fact it really agrees mostly
with  what I stated. You have added 2 important factors though, better application
 knowledge and use of raw file systems.
  
I use  Compaq Tru64 so that does not require raw files systems but other
o/s certainly  do.
  
  
I  think you were a bit unfair to suggest that
I meant you  only needed to check a few init.ora parameters out ( 'it is
far more than  knowing the GC_ parameters' ). I am fully aware of the need
to look at freelists  and freelist groups - I encompassed that in my statement
 
  
'
Management and tuning of internode communication.  Specifically reducing
the level of pinging - use of GC% init.ora  variables
'
  
  
Anyway  I don't think we are that far away from each  other
  
  
Regards
  
  
John
  

  
  
  
-Original Message-
  From:  Bjrn Engsig [mailto:[EMAIL PROTECTED]]
  Sent: 05 February 20021  2:25
  To: Multiple recipients of list ORACLE-L
  Subject: Re:  OPS DBA work (was dumb question)
  
  
  With the caveat, that I am a consultant and not actually a
   DBA, I would argue very strongly, that the OPS DBA needs quite some extra
   understanding, knowledge and experience compared to one managing a single
   instance Oracle. In particular:

- Performance problems, primarilydue to poor application design/development,
that are seen in single instanceare likely to be one to two orders of
magnitude worse in OPS. Hence, theDBA needs a much better application
understanding.

- There are Oraclefeatures (e.g. free list groups) that must be used
with OPS and which rarelyare needed single instance.

- Recovery scenarios are morecomplex

- You must use raw devices (except on platforms with inhertancefrom Digital
Corp), which can add complexity

- A frequent requirementof OPS systems is better uptimes than for single
instance, which is a verynon-trivial task. The whole stack is far more
complex, and even thoughthe possibility to have two or more independent
nodes sound really great intheory, the practical assurance, that they
are in fact completely independentis difficult. And if they aren't independent,
they are likely to haveworse uptimes than the single instance!

- And I probably forgotsomething, so it is far more than knowing the
GC_ parameters, which, BTW, byitself isn't that simple!

- Also, BTW, note that except for a fewthings, RAC doesn't make your
life easier than OPS!

Thanks,Bjrn.

Shreeni wrote:

  
  
  
  
  
  
  
  
Hi  John,
  
  
Thx for  the input. I really appreciate it. I was just kind of stumped
when I was  asked not once but several times and places, to point out
the diff between  an OPS DBA and a "regular" DBA that I am.
  
  
Thanks  again
  
  
Shreeni
  
Shreenivasa  Rao
  e-Z
  ing Technologies,
 Inc..
41-43 Beekman Street, 3rd Floor
New York, NY 10038.
Tel:  (212)233-9861 xt.241
Fax:  (212)233-9862
Cell:(917)861-4966
  
lsama@e-zingtech.com
  
  ***
**Your IT Solutions  Provider
*** *** 
http://www.e-zingtech.com
   
***
Under Bill s.1618 Title III passed by the 105th U.S.  Congress this mail
can
not be considered spam as long as we include  contact information and
a remove link for removal from our mailing list. To  be removed from
our mailing list reply with remove in the subject heading  and your email
address in the body. Include complete address and/or domain  to be  
   removed.

  

-Original Message-
From:
[EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
] On BehalfOf Hallas John
Sent: Monday, February 04, 2002 4:05AM
To: Multiple recipients of list ORACLE-L
Subject:OPS DBA work (was dumb question)



Shreeni,


The mangement of a OPS system does not requireany extra skills or
facilities. Areas that are different or need moreattention from a
standalone instance include the following:


Management and tuning of internode communication.Specifically reducing
the level of pinging - use of GC% init.oravariables

Requirement for different start up scripts(exclusive and shared modes)

Some additional work when duplicating databasesusing RMAN

Perhaps more involvement with

RE: Euro Character Set

2002-02-05 Thread Malik, Fawzia



To convert WE8IS08859P1 to WE8IS08859P15..would I need to do the
export/import??Metalink presents the following solution (in restricted
session):

alter database character set WE8ISO8859P15; 

Also you might change the national character set: 

alter database national character set WE8ISO8859P15;

Thanks in advance...


-Original Message-
Sent: 05 February 2002 13:00
To: Multiple recipients of list ORACLE-L



Hi


Unfortunately No.

You need to re-create the database and export / import the data

There are some differnces with other characters for which the conversion
could pose problems. Info can be found on metalink


Jack




Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002 13:20:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


Thanks. We currently have WE8IS08859P1 set...to display a euro symbol,
would
I need to alter the nls parameters to do this then??

Thanks
-Original Message-
Sent: 05 February 2002 11:56
To: Multiple recipients of list ORACLE-L


The Euro symbol is in WE8ISO8859P15.

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance


-Original Message-
Fawzia
Sent: 05 February 2002 10:40
To: Multiple recipients of list ORACLE-L



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**

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

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

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

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

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

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

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




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht,

Re: FW: how to Loading data file (SQL LOADER)

2002-02-05 Thread G . Plivna



i forgot to mention that i did look in to manual
This soon will be the right style write it :-

I really not expert in sqlloader but I can say what I would do in such a
situation

I would create a temporary table and load all data (of course remebering
the order) there without any modifications at all or maybe only simple
ones.
Then create a PL/SQL procedure/package to insert data from temporary table
into destination table that handles all these complicated things.

This is just because I'm feeling much bettter in PL/SQL than loader
scripts, and in the same time I'm sure one can do much more with PL/SQL
than loader control files.

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
  
Ghadge,Sameer
  
Sameer_Ghadge@Synt   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
elinc.comcc:  
  
Sent by:  Subject: FW: how to Loading data 
file (SQL LOADER) 
[EMAIL PROTECTED]   
  
   
  
   
  
2002.02.05 10:05   
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




i forgot to mention that i did look in to manual

 -Original Message-
 From: Ghadge,Sameer
 Sent: Tuesday, February 05, 2002 1:41 PM
 To:   'Multiple recipients of list ORACLE-L'
 Subject:   how to Loading data file (SQL LOADER)

 Hi all,
 Just think some how i have foll. file(I have a data file coming from
 VAX/VMS machine,on unix machine ,but i currently want soln for WIN2000)

 HDR 280120022044
 SELL031128012002ESP051712311ESP28A
 SELL055728012002EUR0020011534557EUR28A
 SELL015728012002USD0005003289157USD28A
 SELL005328012002USD0010006579053USD28A
 SELL046428012002EUR0060034602464EUR28A
 TRL 000137
 Record structure
 Record Size:54 Bytes
 -- Record Contents --
 Item TypeSize  Occ
Offset
 IMX-HEADER-RECORDCHARACTER 54
0
 .IMX-HEADER-TYPE CHARACTER  4
0
 .PROCESS-DATECHARACTER 12
4
_IMX-DETAIL-RECORDCHARACTER 54
0
 .IMX-DETAIL-TYPE CHARACTER  4
0
 .SHOP-NUMBER CHARACTER  4
4
 .TRANSACTION-DATECHARACTER  8
8
 .CURRENCY-CODE   CHARACTER  3
16
 Item TypeSize  Occ
Offset
 .IMX-CURRENCY-VALUE  ZONED UNSIGNED13
19
 .IMX-STERLING-EQUIVALENT ZONED UNSIGNED13
32
 .REFERENCE-NUMBERCHARACTER  9
45
_IMX-TRAILER-RECORD   CHARACTER 54
0
 .IMX-TRAILER-TYPECHARACTER  4
0
 .IMX-RECORD-COUNTZONED UNSIGNED 6
4



 How do I load this using SQLoader (is it possible)
 ya u all must be thinking ,i m loading flat file in a table and not
 applying RDBMS (normalization) concepts.
 but that the way i have to do,(now don't ask why? we'll discuss off the
 list)

 so my table struct is as foll.
 NameNull?Type
 ---  
 IMX_REC_TYPENOT NULL VARCHAR2(4)
 SHOP_NO   VARCHAR2(4)
 TRANSACTION_DATEDATE
 CURRENCY_CODE   VARCHAR2(3)
 IMX_CURRENCY_VALUE  NUMBER(13)
 IMX_STERLING_EQUIVALENT   NUMBER(13)
 REFERENCE_NUMBERVARCHAR2(9)
 PROCESS_DATE DATE
 IMX_RECORD_COUNT  NUMBER(6)
 IMX_REC_NO

Re: export/import on the same server

2002-02-05 Thread nlzanen1




Hi


All can be fine since you have to log on to the database.

However if tablespaces do not exist already before import they will be
created in the PROD directory!!
So pre-create the tablespaces log on to the test database with the import
utility and do a full import
(ignore = y)


Jack





Farnsworth, Dave [EMAIL PROTECTED]@fatcity.com on
05-02-2002 15:20:34

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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

I have a question on the export/import utility.  I have my live(PROD)
and test(TEST) databases are on the same server.  These are basically
the same schemas except that the data in TEST is old and that the
datafiles for PROD are on I: drive and the datafiles for TEST are on E:
drive.
My question is, since these are on the same server do I have to worry
about which data files will be written to during the import.  For
example;
I do a full export of my PROD database.  When I do my import into my
TEST database will the data automatically go to E: drive or will it
still be pointing to I: drive?  I am reading the Import section of the
fine manual but am a bit confused on the datafiles part of it when doing
a full export/import.  Do I need to use the DESTROY=N parameter?
I am new to this utility but want to learn it.  I am reading the manuals
and some other reading material but still am not clear on this.  I do
not want it to start overwriting my live data.  That is not good for job
security.

Thanks,

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

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

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




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
===


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

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

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

Re: export/import on the same server


Dave,

are you planning on completely dropping the TEST database and
recreating it from the PROD export? If so, you are right to be
cautious.

If you want to refresh the data and the number of schema owners is
small, you might consider just dropping the users and their objects
then recreating the users in the TEST database.

Then you can just import fromuser= touser= and make sure that you are
pointing to the TEST database (I'd log in via sqlnet, even though they
are on the same box:

imp testdba/testdbapassword@test file=  fromuser= touser=   etc


If that won't work, then the next best thing to do would be to drop and
recreate the TEST database, tablespaces/datafiles and all. Then use
IGNORE=Y and DESTROY=N and again MAKE SURE YOU ARE POINTING TO TEST
when you do the import.


--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
 I have a question on the export/import utility.  I have my live(PROD)
 and test(TEST) databases are on the same server.  These are basically
 the same schemas except that the data in TEST is old and that the
 datafiles for PROD are on I: drive and the datafiles for TEST are on
 E:
 drive.
 My question is, since these are on the same server do I have to worry
 about which data files will be written to during the import.  For
 example;
 I do a full export of my PROD database.  When I do my import into my
 TEST database will the data automatically go to E: drive or will it
 still be pointing to I: drive?  I am reading the Import section of
 the
 fine manual but am a bit confused on the datafiles part of it when
 doing
 a full export/import.  Do I need to use the DESTROY=N parameter?
 I am new to this utility but want to learn it.  I am reading the
 manuals
 and some other reading material but still am not clear on this.  I do
 not want it to start overwriting my live data.  That is not good for
 job
 security.
 
 Thanks,
 
 Dave
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Farnsworth, Dave
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: export/import on the same server


Hello Dave

I checked the docs.
It seems to me that destroy is associated with transport_tablespaces.
If you transport tablespaces destroy=y means overwrite old data files
with the same name.

In regular import the @database set the target database.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, February 05, 2002 4:21 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  export/import on the same server
 
 I have a question on the export/import utility.  I have my live(PROD)
 and test(TEST) databases are on the same server.  These are basically
 the same schemas except that the data in TEST is old and that the
 datafiles for PROD are on I: drive and the datafiles for TEST are on E:
 drive.
 My question is, since these are on the same server do I have to worry
 about which data files will be written to during the import.  For
 example;
 I do a full export of my PROD database.  When I do my import into my
 TEST database will the data automatically go to E: drive or will it
 still be pointing to I: drive?  I am reading the Import section of the
 fine manual but am a bit confused on the datafiles part of it when doing
 a full export/import.  Do I need to use the DESTROY=N parameter?
 I am new to this utility but want to learn it.  I am reading the manuals
 and some other reading material but still am not clear on this.  I do
 not want it to start overwriting my live data.  That is not good for job
 security.
 
 Thanks,
 
 Dave
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Farnsworth, Dave
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Ron Rogers


 IMX-HEADER-RECORD
 CHARACTER 54
0
 .IMX-HEADER-TYPE CHARACTER  4
0
 .PROCESS-DATECHARACTER 12
4
_IMX-DETAIL-RECORDCHARACTER 54
0
 .IMX-DETAIL-TYPE CHARACTER  4
0
 .SHOP-NUMBER CHARACTER  4
4
 .TRANSACTION-DATECHARACTER  8
8
 .CURRENCY-CODE   CHARACTER  3
16
 Item TypeSize  Occ
Offset
 .IMX-CURRENCY-VALUE  ZONED UNSIGNED13
19
 .IMX-STERLING-EQUIVALENT ZONED UNSIGNED13
32
 .REFERENCE-NUMBERCHARACTER  9
45
_IMX-TRAILER-RECORD   CReceived: from CONNECT-MTA by 
galotterHARACTER 54
0
 .IMX-TRAILER-TYPECHARACTER  4
0
 .IMX-RECORD-COUNTZONED UNSIGNED 6
4



 How do I load this using SQLoader (is it possible)
 ya u all must be thinking ,i m loading flat file in a table and not
 applying RDBMS (normalization) concepts.
 but that the way i have to do,(now don't ask why? we'll discuss off
the
 list)

 so my table struct is as foll.
 NameNull?Type
 ---  
 IMX_REC_TYPENOT NULL VARCHAR2(4)
 SHOP_NO   VARCHAR2(4)
 TRANSACTION_DATEDATE
 CURRENCY_CODE   VARCHAR2(3)
 IMX_CURRENCY_VALUE  NUMBER(13)
 IMX_STERLING_EQUIVALENT   NUMBER(13)
 REFERENCE_NUMBERVARCHAR2(9)
 PROCESS_DATE DATE
 IMX_RECORD_COUNT  NUMBER(6)
 IMX_REC_NO   NUMBER(6)

 any help is appreciated
 using oracle 8.1.6 on win2000
 Thx
 Sameer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ghadge,Sameer
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

RE: Dropping user hangs indefnitely

2002-02-05 Thread SARKAR, Samir


Rachel,

This is bafflingI did look up the v$locked_object view and dba_waiters
both of which returned no rows. The v$lock had the value 0 for lock
requests.
I tried a shutdown immediate through a stored script which brings down the 
context server alongwith bringing down the database. That hung as well 
although there weren't any users using the database. 
I looked up the processes on the server and sure enough there was a ctxhx
process
initiated by the context server which was running. I killed the same and the

database shutdown was completed. The database was restarted and we could
then 
remove the user.
My point is since the context server held locks on the objects owned by a
particular
user in the database, the same should have shown up in the lock info which I
accessed.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 05 February 2002 14:15
To: Multiple recipients of list ORACLE-L


before shutting down the server why not look to see if there are locks
on the objects?


--- Mark Leith [EMAIL PROTECTED] wrote:
 I think that might be a good start..
 
 -Original Message-
 Samir
 Sent: 05 February 2002 11:30
 To: Multiple recipients of list ORACLE-L
 
 
 Thanks for your reply, Gopalakrishnan. I did check whether the user
 has 
 logged into the database but I got a negative.
 However, I did come across the following possiblity but I am not sure
 of
 this so 
 could u please throw some light on it ?? 
 
 We have a context server running Intermedia applications which
 accesses the
 the objects held by that user (the user trying to b dropped). Is
 there a
 chance
 of a lock being held on one of those objects due to which the
 dropping of
 the user
 takes forever ?? Will it help if we shutdown the context server which
 runs
 the
 Intermedia applications before we try to drop the user ??
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED] 
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 -Original Message-
 Sent: 05 February 2002 10:30
 To: Multiple recipients of list ORACLE-L
 
 
 Probably that user might have connected to the instance. Check
 V$session.
 
 
 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA
 
 
 
 -Original Message-
 Samir
 Sent: Tuesday, February 05, 2002 1:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi list,
 
 Can anybody help me how to identify why the dropping of a particular
 user
 hangs indefnitely ??
 
 Database is 8.1.7 on Solaris 7.
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 

___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented
 are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have
 received
 this
 email in error and that any use, dissemination, forwarding, printing,
 or
 copying of this email is strictly prohibited.
 
 If you have received this email in error please notify the
 SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.

___
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: SARKAR, Samir
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail

Re: export/import on the same server

2002-02-05 Thread Rick_Cale



Dave,

If you are in a position to shutdown prod. I would think it would be easier
to copy all prod datafiles,etc to test location
and recreate the control file on test to point to correct directory and
your there.  If you need more detail I can provide.

Rick



   

Rachel 

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

yahoo.com   Subject: Re: export/import on the same 
server 
Sent by:   

root@fatcity.  

com

   

   

02/05/2002 

10:05 AM   

Please 

respond to 

ORACLE-L   

   

   





Dave,

are you planning on completely dropping the TEST database and
recreating it from the PROD export? If so, you are right to be
cautious.

If you want to refresh the data and the number of schema owners is
small, you might consider just dropping the users and their objects
then recreating the users in the TEST database.

Then you can just import fromuser= touser= and make sure that you are
pointing to the TEST database (I'd log in via sqlnet, even though they
are on the same box:

imp testdba/testdbapassword@test file=  fromuser= touser=   etc


If that won't work, then the next best thing to do would be to drop and
recreate the TEST database, tablespaces/datafiles and all. Then use
IGNORE=Y and DESTROY=N and again MAKE SURE YOU ARE POINTING TO TEST
when you do the import.


--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
 I have a question on the export/import utility.  I have my live(PROD)
 and test(TEST) databases are on the same server.  These are basically
 the same schemas except that the data in TEST is old and that the
 datafiles for PROD are on I: drive and the datafiles for TEST are on
 E:
 drive.
 My question is, since these are on the same server do I have to worry
 about which data files will be written to during the import.  For
 example;
 I do a full export of my PROD database.  When I do my import into my
 TEST database will the data automatically go to E: drive or will it
 still be pointing to I: drive?  I am reading the Import section of
 the
 fine manual but am a bit confused on the datafiles part of it when
 doing
 a full export/import.  Do I need to use the DESTROY=N parameter?
 I am new to this utility but want to learn it.  I am reading the
 manuals
 and some other reading material but still am not clear on this.  I do
 not want it to start overwriting my live data.  That is not good for
 job
 security.

 Thanks,

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

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


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ:

RE: Dropping user hangs indefnitely


Have you tried investigating the session_waits to see what the
session doing the dropping is waiting on?  You will need to
run it several times.

select
   s.username username,
   e.event event,
   s.sid,
   e.p1text,
   e.p1,
   e.p2text,
   e.p2,
   e.wait_time,
   e.seconds_in_wait,
   e.state
from v$session s, v$session_wait e
where s.username is not null
   and s.sid = e.sid
   -- skip sqlnet idle session messages
   and e.event not like '%message%client'
order by s.username, upper(e.event);

Also look at the transaction for the same session.  A lot of rollback 
would
indicate that there's a bit of recursive SQL going on.

select s.osuser
  ,s.username
  ,s.sid
  ,r.segment_name
  ,t.space
  ,t.recursive
  ,t.noundo
  ,t.used_ublk
  ,t.used_urec
  ,t.log_io
  ,t.phy_io
  ,substr(sa.sql_text,1,200) txt
from v$session s,
 v$transaction t,
 dba_rollback_segs r,
 v$sqlarea sa
where s.taddr=t.addr
and   t.xidusn=r.segment_id(+)
and   s.sql_address=sa.address(+);

Jared






SARKAR, Samir [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/02 07:15 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Dropping user hangs indefnitely


Rachel,

This is bafflingI did look up the v$locked_object view and dba_waiters
both of which returned no rows. The v$lock had the value 0 for lock
requests.
I tried a shutdown immediate through a stored script which brings down the 

context server alongwith bringing down the database. That hung as well 
although there weren't any users using the database. 
I looked up the processes on the server and sure enough there was a ctxhx
process
initiated by the context server which was running. I killed the same and 
the

database shutdown was completed. The database was restarted and we could
then 
remove the user.
My point is since the context server held locks on the objects owned by a
particular
user in the database, the same should have shown up in the lock info which 
I
accessed.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018 


-Original Message-
Sent: 05 February 2002 14:15
To: Multiple recipients of list ORACLE-L


before shutting down the server why not look to see if there are locks
on the objects?


--- Mark Leith [EMAIL PROTECTED] wrote:
 I think that might be a good start..
 
 -Original Message-
 Samir
 Sent: 05 February 2002 11:30
 To: Multiple recipients of list ORACLE-L
 
 
 Thanks for your reply, Gopalakrishnan. I did check whether the user
 has 
 logged into the database but I got a negative.
 However, I did come across the following possiblity but I am not sure
 of
 this so 
 could u please throw some light on it ?? 
 
 We have a context server running Intermedia applications which
 accesses the
 the objects held by that user (the user trying to b dropped). Is
 there a
 chance
 of a lock being held on one of those objects due to which the
 dropping of
 the user
 takes forever ?? Will it help if we shutdown the context server which
 runs
 the
 Intermedia applications before we try to drop the user ??
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED] 
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018 
 
 
 -Original Message-
 Sent: 05 February 2002 10:30
 To: Multiple recipients of list ORACLE-L
 
 
 Probably that user might have connected to the instance. Check
 V$session.
 
 
 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA
 
 
 
 -Original Message-
 Samir
 Sent: Tuesday, February 05, 2002 1:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi list,
 
 Can anybody help me how to identify why the dropping of a particular
 user
 hangs indefnitely ??
 
 Database is 8.1.7 on Solaris 7.
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 

___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented
 are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have
 received
 this
 email in error and that any use, dissemination, forwarding, printing,
 or
 copying of this email is strictly prohibited.
 
 If you have received this email in error please notify the
 SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.

RE: Euro Character Set

2002-02-05 Thread nlzanen1



Hi


Look for note 66320.1

I interpreted it as saying that to convert the database it had to be
ex/imported
I was on 8.0.5 when I checked this out so maybe it's different in 8i


Jack




Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002 15:45:50

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


To convert WE8IS08859P1 to WE8IS08859P15..would I need to do the
export/import??Metalink presents the following solution (in restricted
session):

alter database character set WE8ISO8859P15;

Also you might change the national character set:

alter database national character set WE8ISO8859P15;

Thanks in advance...


-Original Message-
Sent: 05 February 2002 13:00
To: Multiple recipients of list ORACLE-L



Hi


Unfortunately No.

You need to re-create the database and export / import the data

There are some differnces with other characters for which the conversion
could pose problems. Info can be found on metalink


Jack




Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002 13:20:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


Thanks. We currently have WE8IS08859P1 set...to display a euro symbol,
would
I need to alter the nls parameters to do this then??

Thanks
-Original Message-
Sent: 05 February 2002 11:56
To: Multiple recipients of list ORACLE-L


The Euro symbol is in WE8ISO8859P15.

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance


-Original Message-
Fawzia
Sent: 05 February 2002 10:40
To: Multiple recipients of list ORACLE-L



Can anyone please tell me  what character set needs to be set up for
supporting the euro ..and whether any procedure needs to be run to put this
into process??

Thanks and Rgds

Fawzia


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**

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

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

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

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

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

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

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




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke

PERFORMANCE QUESTION

2002-02-05 Thread Harvinder Singh


Hi,

We are running batch job and generate statspack report every hour...
Database is getting slow gradually..
statspack report shows value of wait for DB FILE SEQUENTIAL READ increase
from 24034(for 3-5 hrs)  to 332456 and still increasing..
and DB FILE PARALLEL WRITE is also very high about 24567 - 38987..
What can be the possible cause of increasing DB FILE SEQUENTIAL
READ...
We are running same set of queries for testing..

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

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

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

RE: Tkprof.

2002-02-05 Thread DBarbour



Check OTN.  Signup is free, otn.oracle.com, they've never hassled or
spammed me, and the documentation is invaluable.


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


   

Rajesh Dayal   

Rajesh@ohitel   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
ecom.comcc:   

Sent by: Subject: RE: Tkprof.  

[EMAIL PROTECTED] 

om 

   

   

02/05/2002 

12:15 AM   

Please respond 

to ORACLE-L

   

   





Just type tkprof on command line (DOS) or on shell prompt (UNIX),

You would find the help and all your doubts would be cleared.

HTH,
Rajesh
-Original Message-
Sent: Tuesday, February 05, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L

Hi all

I am having a doubt in how to use Tkprof.



This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.



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

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

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

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

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




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

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

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

RE: HOW TO KNOW INDEX NOT IN USE?


Can anyone else get to this article? 

My browser gets redirected to 
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/d_metada.htm#1656


Jared





àãø éçéàì [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/02 12:45 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: HOW TO KNOW INDEX NOT IN USE?


Hello Seema

Oracle magazine for 01-02/2002 has on page 91 an article 
that gives step by step instructions on this issue for 9i.
They also have a reference to:
http://www.oracle.com/oramag/oracle/jan02/metadata.html

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From:  Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent:  Mon, February 04, 2002 7:55 PM
 To:Multiple recipients of list ORACLE-L
 Subject:   HOW TO KNOW INDEX NOT IN USE?
 
 Hi
 I there any view which can tell us which indexes are not in use?
 Thx
 -Seema
 
 
 
 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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



W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ(§Ú©Êëa¢²
2ZçR¶)e§b³+¢aZ´(È×ÂäIêïÇ¬ó9ßÎtçQ@_Î|ç9ÓRjpâz
jX¢¹âhû'×«ëZqÇ¬³óX§¸¬¶ÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\²¥)à¡òâ²Ñ®®æ§v)íé²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þé¨½ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º-êâú+«b¢ybë.nÇ+¸§

RE: Dropping user hangs indefnitely

2002-02-05 Thread Jenkins, Michael


Another thing to look at is dba_ddl_locks.  We have seen instances hang in
the past because sessions were waiting on a DDL lock to become freed.

--Michael

-Original Message-
Sent: Tuesday, February 05, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L


Rachel,

This is bafflingI did look up the v$locked_object view and dba_waiters
both of which returned no rows. The v$lock had the value 0 for lock
requests.
I tried a shutdown immediate through a stored script which brings down the 
context server alongwith bringing down the database. That hung as well 
although there weren't any users using the database. 
I looked up the processes on the server and sure enough there was a ctxhx
process
initiated by the context server which was running. I killed the same and the

database shutdown was completed. The database was restarted and we could
then 
remove the user.
My point is since the context server held locks on the objects owned by a
particular
user in the database, the same should have shown up in the lock info which I
accessed.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 05 February 2002 14:15
To: Multiple recipients of list ORACLE-L


before shutting down the server why not look to see if there are locks
on the objects?


--- Mark Leith [EMAIL PROTECTED] wrote:
 I think that might be a good start..
 
 -Original Message-
 Samir
 Sent: 05 February 2002 11:30
 To: Multiple recipients of list ORACLE-L
 
 
 Thanks for your reply, Gopalakrishnan. I did check whether the user
 has 
 logged into the database but I got a negative.
 However, I did come across the following possiblity but I am not sure
 of
 this so 
 could u please throw some light on it ?? 
 
 We have a context server running Intermedia applications which
 accesses the
 the objects held by that user (the user trying to b dropped). Is
 there a
 chance
 of a lock being held on one of those objects due to which the
 dropping of
 the user
 takes forever ?? Will it help if we shutdown the context server which
 runs
 the
 Intermedia applications before we try to drop the user ??
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED] 
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 -Original Message-
 Sent: 05 February 2002 10:30
 To: Multiple recipients of list ORACLE-L
 
 
 Probably that user might have connected to the instance. Check
 V$session.
 
 
 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA
 
 
 
 -Original Message-
 Samir
 Sent: Tuesday, February 05, 2002 1:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi list,
 
 Can anybody help me how to identify why the dropping of a particular
 user
 hangs indefnitely ??
 
 Database is 8.1.7 on Solaris 7.
 
 Regards,
 Samir
 
 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : +44 (0) 115 - 957 6217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018
 
 
 

___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented
 are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have
 received
 this
 email in error and that any use, dissemination, forwarding, printing,
 or
 copying of this email is strictly prohibited.
 
 If you have received this email in error please notify the
 SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.

___
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: SARKAR, Samir
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]

O9i Predefined Roles

2002-02-05 Thread Orr, Steve


Are the CONNECT, RESOURCE, and DBA roles still predefined roles in O9i like
they are in O8i?


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

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

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

NT Monitoring Scripts

2002-02-05 Thread dmeng


Greetings,
We recently implemented an Oracle 8.1.7 database on NT4.0. Since this is
the first for our company, I need some help setting up the monitoring
procedure. On the unix side I have a Korn script that parses the alert log
and page/E-mail me if errors are found. But NT is a different beast and I
don't know much about the scripting side of things ( other than it's pretty
lame :) ). So does anyone out there have a script/tool handy? I think I
have better things to do than picking up an NT scripting book just for this
one database. Also, does anyone have good experience with MKS? Our NT
administrator is not crazy about installing it on our production server.

TIA

Dennis

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

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

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

Re: FW: how to Loading data file (SQL LOADER)

2002-02-05 Thread Ron Rogers


 IMX-HEADER-RECORD
 CHARACTER 54
0
 .IMX-HEADER-TYPE CHARACTER  4
0
 .PROCESS-DATECHARACTER 12
4
_IMX-DETAIL-RECORDCHARACTER 54
0
 .IMX-DETAIL-TYPE CHARACTER  4
0
 .SHOP-NUMBER CHARACTER  4
4
 .TRANSACTION-DATECHARACTER  8
8
 .CURRENCY-CODE   CHARACTER  3
16
 Item TypeSize  Occ
Offset
 .IMX-CURRENCY-VALUE  ZONED UNSIGNED13
19
 .IMX-STERLING-EQUIVALENT ZONED UNSIGNED13
32
 .REFERENCE-NUMBERCHARACTER  9
45
_IMX-TRAILER-RECReceived: from CONNECT-MTA by galotterORD   
CHARACTER 54
0
 .IMX-TRAILER-TYPECHARACTER  4
0
 .IMX-RECORD-COUNTZONED UNSIGNED 6
4



 How do I load this using SQLoader (is it possible)
 ya u all must be thinking ,i m loading flat file in a table and not
 applying RDBMS (normalization) concepts.
 but that the way i have to do,(now don't ask why? we'll discuss off
the
 list)

 so my table struct is as foll.
 NameNull?Type
 ---  
 IMX_REC_TYPENOT NULL VARCHAR2(4)
 SHOP_NO   VARCHAR2(4)
 TRANSACTION_DATEDATE
 CURRENCY_CODE   VARCHAR2(3)
 IMX_CURRENCY_VALUE  NUMBER(13)
 IMX_STERLING_EQUIVALENT   NUMBER(13)
 REFERENCE_NUMBERVARCHAR2(9)
 PROCESS_DATE DATE
 IMX_RECORD_COUNT  NUMBER(6)
 IMX_REC_NO   NUMBER(6)

 any help is appreciated
 using oracle 8.1.6 on win2000
 Thx
 Sameer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ghadge,Sameer
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

RE: export/import on the same server


unless I am misreading the 9i docs (see below) this has nothing to do
with transportable tablespaces

If you use DESTROY=Y and a full database import, Oracle will overwrite
the datafiles as defined in the create tablespace statement that is in
the dump file. It's the equivalent of issuing:

create tablespace tbsname datafile 'prod file name' reuse;

From the 9i Utilities manual:

Specifies whether or not the existing datafiles making up the database
should be reused. That is, specifying DESTROY=y causes Import to
include the REUSE option in the datafile clause of the CREATE
TABLESPACE statement, which causes Import to reuse the original
database's datafiles after deleting their contents. 

Note that the export file contains the datafile names used in each
tablespace. If you specify DESTROY=y and attempt to create a second
database on the same system (for testing or other purposes), the Import
utility will overwrite the first database's datafiles when it creates
the tablespace. In this situation you should use the default,
DESTROY=n, so that an error occurs if the datafiles already exist when
the tablespace is created. Also, when you need to import into the
original database, you will need to specify IGNORE=y to add to the
existing datafiles without replacing them. 



--- àãø_éçéàì [EMAIL PROTECTED] wrote:
 Hello Dave
 
 I checked the docs.
 It seems to me that destroy is associated with transport_tablespaces.
 If you transport tablespaces destroy=y means overwrite old data files
 with the same name.
 
 In regular import the @database set the target database.
 
 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]
 
  -Original Message-
  From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
  Sent:   Tue, February 05, 2002 4:21 PM
  To: Multiple recipients of list ORACLE-L
  Subject:export/import on the same server
  
  I have a question on the export/import utility.  I have my
 live(PROD)
  and test(TEST) databases are on the same server.  These are
 basically
  the same schemas except that the data in TEST is old and that the
  datafiles for PROD are on I: drive and the datafiles for TEST are
 on E:
  drive.
  My question is, since these are on the same server do I have to
 worry
  about which data files will be written to during the import.  For
  example;
  I do a full export of my PROD database.  When I do my import into
 my
  TEST database will the data automatically go to E: drive or will it
  still be pointing to I: drive?  I am reading the Import section of
 the
  fine manual but am a bit confused on the datafiles part of it when
 doing
  a full export/import.  Do I need to use the DESTROY=N parameter?
  I am new to this utility but want to learn it.  I am reading the
 manuals
  and some other reading material but still am not clear on this.  I
 do
  not want it to start overwriting my live data.  That is not good
 for job
  security.
  
  Thanks,
  
  Dave
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   This e-mail was scanned by the eSafe Mail Gateway 
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself

RE: HOW TO KNOW INDEX NOT IN USE?

2002-02-05 Thread Aponte, Tony

Title: RE: HOW TO KNOW INDEX NOT IN USE?






Nope. Same behavior for me.


-Original Message-

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Sent: Tuesday, February 05, 2002 11:01 AM

To: Multiple recipients of list ORACLE-L

Subject: RE: HOW TO KNOW INDEX NOT IN USE?



Can anyone else get to this article? 


My browser gets redirected to 

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/d_metada.htm#1656


Jared






àãø éçéàì [EMAIL PROTECTED]

Sent by: [EMAIL PROTECTED]

02/05/02 12:45 AM

Please respond to ORACLE-L




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

 cc: 

 Subject: RE: HOW TO KNOW INDEX NOT IN USE?



Hello Seema


Oracle magazine for 01-02/2002 has on page 91 an article 

that gives step by step instructions on this issue for 9i.

They also have a reference to:

http://www.oracle.com/oramag/oracle/jan02/metadata.html


Yechiel Adar, Mehish Computer Services

[EMAIL PROTECTED]


 -Original Message-

 From: Seema Singh [SMTP:[EMAIL PROTECTED]]

 Sent: Mon, February 04, 2002 7:55 PM

 To: Multiple recipients of list ORACLE-L

 Subject: HOW TO KNOW INDEX NOT IN USE?

 

 Hi

 I there any view which can tell us which indexes are not in use?

 Thx

 -Seema

 

 

 

 _

 Chat with friends online, try MSN Messenger: http://messenger.msn.com

 

 -- 

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

 -- 

 Author: Seema Singh

 INET: [EMAIL PROTECTED]

 

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

 San Diego, California -- Public Internet access / Mailing Lists

 

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

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

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

 (or the name of mailing list you want to be removed from). You may

 also send the HELP command for other information (like subscribing).

 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 This e-mail was scanned by the eSafe Mail Gateway 

 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


-- 

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

-- 

Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=

 INET: [EMAIL PROTECTED]


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

San Diego, California -- Public Internet access / Mailing Lists



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

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

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

(or the name of mailing list you want to be removed from). You may

also send the HELP command for other information (like subscribing).




W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ

(§Ú©Êëa¢²

2ZçR¶)e§b³+¢aZ´(È×ÂäIêïÇ¬ó9ßÎtçQ@_Î|ç9ÓRjpâz

jX¢¹âhû'×«ëZqÇ¬³óX§¸¬¶ÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\²¥)à¡òâ²Ñ®®æ§v)íé²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þé¨½ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º-êâú+«b¢ybë.nÇ+¸§

RE: Euro Character Set


I think that you have to examine CAREFULLY both charsets.
If you do not use in your data any of the characters that are different
between the two you can probably succeed with alter database.
I did it with no problems.

Check also the nls_lang parameter in the registry of the server.
When you do import/export/SQL loader on the server there will
be conversion if the nls_lang in the server does not match
your charset.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, February 05, 2002 5:35 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Euro Character Set
 
 
 Hi
 
 
 Look for note 66320.1
 
 I interpreted it as saying that to convert the database it had to be
 ex/imported
 I was on 8.0.5 when I checked this out so maybe it's different in 8i
 
 
 Jack
 
 
 
 
 Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002
 15:45:50
 
 Please respond to [EMAIL PROTECTED]
 
 Sent by:  [EMAIL PROTECTED]
 
 
 To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
 
 
 To convert WE8IS08859P1 to WE8IS08859P15..would I need to do the
 export/import??Metalink presents the following solution (in restricted
 session):
 
 alter database character set WE8ISO8859P15;
 
 Also you might change the national character set:
 
 alter database national character set WE8ISO8859P15;
 
 Thanks in advance...
 
 
 -Original Message-
 Sent: 05 February 2002 13:00
 To: Multiple recipients of list ORACLE-L
 
 
 
 Hi
 
 
 Unfortunately No.
 
 You need to re-create the database and export / import the data
 
 There are some differnces with other characters for which the conversion
 could pose problems. Info can be found on metalink
 
 
 Jack
 
 
 
 
 Malik, Fawzia [EMAIL PROTECTED]@fatcity.com on 05-02-2002
 13:20:17
 
 Please respond to [EMAIL PROTECTED]
 
 Sent by:  [EMAIL PROTECTED]
 
 
 To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
 
 
 Thanks. We currently have WE8IS08859P1 set...to display a euro symbol,
 would
 I need to alter the nls parameters to do this then??
 
 Thanks
 -Original Message-
 Sent: 05 February 2002 11:56
 To: Multiple recipients of list ORACLE-L
 
 
 The Euro symbol is in WE8ISO8859P15.
 
 HTH
 
 Mark
 
 ===
  Mark Leith | T: +44 (0)1905 330 281
  Sales  Marketing  | F: +44 (0)870 127 5283
  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
 ===
http://www.cool-tools.co.uk
Maximising throughput  performance
 
 
 -Original Message-
 Fawzia
 Sent: 05 February 2002 10:40
 To: Multiple recipients of list ORACLE-L
 
 
 
 Can anyone please tell me  what character set needs to be set up for
 supporting the euro ..and whether any procedure needs to be run to put
 this
 into process??
 
 Thanks and Rgds
 
 Fawzia
 
 
 **
 Information in this email is confidential and may be privileged.
 It is intended for the addressee only. If you have received it in error,
 please notify the sender immediately and delete it from your system.
 You should not otherwise copy it, retransmit it or use or disclose its
 contents to anyone.
 Thank you for your co-operation.
 **
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Malik, Fawzia
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mark Leith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Malik, Fawzia
   INET: [EMAIL PROTECTED]
 
 Fat City Network

RE: NT Monitoring Scripts

2002-02-05 Thread Smith, Ron L.


Here is what we use:

Ron Smith

@ECHO ON
REM
*
REM * This script will scan the Oracle alert log and look for various error
*
REM * messages.  The messages are then sent to the Oracle NT DBA's.
*
REm * The email is sent using the BLAT utility so the utility must already
*
REM * exist on the server and be located in the path.
*
REM *
*
REM * Two parameters are required:
*
REM *
*
REM * ALERTLOG - The fully qualified name of the Oracle Alertlog.
*
REM *   Example: c:\orant\rdbms73\trace\xrt1alrt.log
*
REM *
*
REM * SID - A descriptive name of the sid or sid / server combination. This
*
REM *   parameter is used to create temporary files and as the subject
*
REM *   in the email message.
*
REM *   Example: XRT1_Corp24
*


setlocal
set ALERTLOG=%1
set SID=%2

REM
*
REM * Check for existance of files
REM
*
if exist c:\%SID%tempx.log del c:\%SID%tempx.log

if exist %ALERTLOG% (copy %ALERTLOG% c:\%SID%alrt.log
goto :FINDSTRING)

ECHO * No %ALERTLOG% was found *  c:\%SID%tempx.log
ECHO *  %ALERTLOG%_listing.txt
goto :SENDMSG

REM
*
REM * Look for error messages
REM
*
:FINDSTRING
findstr /B ORA- C:\%SID%alrt.log  c:\%SID%tempx.log
findstr /B OSD- C:\%SID%alrt.log  c:\%SID%tempx.log
findstr /B O/S- C:\%SID%alrt.log  c:\%SID%tempx.log
findstr /B TNS- C:\%SID%alrt.log  c:\%SID%tempx.log

REM
*
REM * Send message
REM
*
:SENDMSG
blat.exe c:\%SID%tempx.log -t [EMAIL PROTECTED] -s %SID% Alert Log Scan
pause
endlocal
exit
quit

-Original Message-
Sent: Tuesday, February 05, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L


Greetings,
We recently implemented an Oracle 8.1.7 database on NT4.0. Since this is
the first for our company, I need some help setting up the monitoring
procedure. On the unix side I have a Korn script that parses the alert log
and page/E-mail me if errors are found. But NT is a different beast and I
don't know much about the scripting side of things ( other than it's pretty
lame :) ). So does anyone out there have a script/tool handy? I think I
have better things to do than picking up an NT scripting book just for this
one database. Also, does anyone have good experience with MKS? Our NT
administrator is not crazy about installing it on our production server.

TIA

Dennis

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

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

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

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

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

RE: compressing rman backups through pipes

2002-02-05 Thread DENNIS WILLIAMS


Ruth - If you have space for individual RMAN backups, but not enough room
for all RMAN backups, consider this. For simplicity, assume that you only
have two production databases on your system.
- Backup database A using RMAN.
- Copy the backup to tape.
- Delete the disk copy of the RMAN backup.
- Backup database B using RMAN
- Copy the backup to tape.

This means that if you have to recover database A, then you'll have to
delete backup B and read A's backup in from tape. That means the recovery
time will be longer. But maybe not that much longer than if you were using a
media manager and writing directly to tape.
Actually, we are considering a schedule like this down the road. Buy
a cheap NAS unit just to hold backups until they are copied to tape.
Incremental backups, staggered days, etc. may make this arrangement
more usable.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, February 05, 2002 9:41 AM
To: Multiple recipients of list ORACLE-L


If I get it to work, which from everything I've heard so far won't happen, I
will be happy to let everyone know.  As of today, I had to compress some
backup sets so I could backup the last production database.  What a waste of
time!

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 3:58 PM


 Ruth - The RMAN documentation says the test of where you can save your
 backup is whether Oracle can do a CREATE TABLESPACE to that location. That
 is what rules out tape except through a certified media manager. I would
 guess that also rules out compressing through a pipe, but if you get it to
 work, let the rest of us know.
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Monday, February 04, 2002 8:40 AM
 To: Multiple recipients of list ORACLE-L


 Hi all,

 Does anyone know if you can do rman backups throught pipes and compress
them
 the way you can with an export?

 Thanks in advance,
 Ruth

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

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

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

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

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

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

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

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

RE: HOW TO KNOW INDEX NOT IN USE?

2002-02-05 Thread Gendre François


http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html

HTH
Francois

 -Message d'origine-
 De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Date: mardi, 5. février 2002 17:01
 À:Multiple recipients of list ORACLE-L
 Objet:RE: HOW TO KNOW INDEX NOT IN USE?
 
 Can anyone else get to this article? 
 
 My browser gets redirected to 
 http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/
 d_metada.htm#1656
 
 Jared
 
 
 
 
 
 ??? ? [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 02/05/02 12:45 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: HOW TO KNOW INDEX NOT IN USE?
 
 
 Hello Seema
 
 Oracle magazine for 01-02/2002 has on page 91 an article 
 that gives step by step instructions on this issue for 9i.
 They also have a reference to:
 http://www.oracle.com/oramag/oracle/jan02/metadata.html
 
 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]
 
  -Original Message-
  From:  Seema Singh [SMTP:[EMAIL PROTECTED]]
  Sent:  Mon, February 04, 2002 7:55 PM
  To:Multiple recipients of list ORACLE-L
  Subject:   HOW TO KNOW INDEX NOT IN USE?
  
  Hi
  I there any view which can tell us which indexes are not in use?
  Thx
  -Seema
  
  
  
  _
  Chat with friends online, try MSN Messenger: http://messenger.msn.com
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Seema Singh
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   This e-mail was scanned by the eSafe Mail Gateway 
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 W±?z?^¡??r¥9,B?m¶??(§?©??a¢²
 2Z?R¶)e§b³+¢aZ´(????I¬?9??t?Q@_?|?9?Rjp?z
 jX¢¹?h?-'?«?Zq?¬³?X§EUR¸¬¶??DCTL¨÷»*??¢ka?X§'X¬¶?§u©?1¨¥(tm)?
 ,j ¸¬´k«¹?r+rr?§¢?\²-¥-)?¡??²?®®?§v)?...?²?
 xfb)?-?^jX§y?'µ¨§x5%9,B?®?^©¡?X§'X¬·*.?©?¶???¨½?_®?~¢??©l¢?§v?^
 B?r?¦jw_¢÷-...???+(tm)«b¢yb'?.n?+?¸§
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Gendre_François?  INET: [EMAIL PROTECTED]

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

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


Robert,

Simulating the problem and proving the correction is an excellent idea.

One thing to consider when putting together your testing scenario is
that writes to the database block by a transaction are done in memory,
that is they are made to the cached database blocks.

An internal locking mechanism ( a latch ) is used to control access to
the cache, and it is normally held for only a short time.

The data may be written to the disk before a commit, and it may not
be written to disk until after a commit.  ( referring to datafiles only
here, not the redo log ).

The 60 second sleep in your script is only simulating user think time,
it's not actually blocking anything.  You will need to similate several
session simultaneously inserting, and you will need to know if the 
contention
is in the table or in an index: I'm guessing it's an index or indexes.

Some time spent with the Concepts manual would help you out here.

Here's an excerpt from the section on database writer:

Database Writer (DBWn) 

The database writer writes modified blocks from the database buffer 
cache to the datafiles. Although one database writer process (DBW0) 
is sufficient for most systems, you can configure additional processes
(DBW1 through DBW9) to improve write performance for a system that 
modifies data heavily. The initialization parameter DB_WRITER_PROCESSES 
specifies the number of DBWn processes. 

Since Oracle uses write-ahead logging, DBWn does not need to write 
blocks when a transaction commits. Instead, DBWn is designed to perform 
batched
writes with high efficiency. In the most common case, DBWn writes only 
when more 
data needs to be read into the system global area and too few database
buffers are free. The least recently used data is written to the datafiles 
first. DBWn 
also performs writes for other functions such as checkpointing. 

Take a look at Chapter 15 on Transactions as well.

Also check out Steve Adams' web site, www.ixora.com.au.  Lots of 
interesting stuff
there if you want to learn about the internals.  Here's an excerpt from 
the section
on Free lists:

As mentioned previously, free list contention occurs when multiple 
processes using the same free list attempt to modify the data block on the 
head of the free list concurrently. It is shown in V$WAITSTAT against the data block 
class. V$WAITSTAT can also show contention for the segment header and free list 
blocks. This occurs where multiple transaction in the same free list 
group need to update their free list header records simultaneously. There 
are various ways of addressing these problems such as rebuilding the table 
with more free list groups, or increasing _bump_highwater_mark_count, or the novel 
idea of fixing the application. 
To drill down on which segments are causing data block contention, I suggested using 
event 10046, level 8. This creates a trace 
file much like to one produced by the sql_trace facility, except that for each event 
wait a line is printed to the trace 
file. In particular, each buffer busy wait is recorded together with the 
P1 and P2 values which are the data file and block number of the wait. So 
to find which blocks a process has been waiting on, you just grep the trace file for 
buffer busy waits lines and produce a histogram of the file and block numbers most 
commonly 
waited for. Once you have suspect file and block numbers, you can relate 
them to a segment by querying DBA_EXTENTS. In the case of free list 
contention on a table it is common to have several hot blocks just below 
the high water mark for the segment. 

If you really want to learn the internals, his book is excellent for that. 
 It's not normally necessary
IMO to delve that deep into the internals to deal with tuning problems, at 
least in my experience.

It will certainly help you develop insight and intuition as to what is 
going on with your database though.

HTH

Jared






Robert Eskridge [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/04/02 08:15 PM
Please respond to ORACLE-L

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


I've got a database that I'm experiencing blocking locks on insert
statements into the largest, most active transaction table.  The
freelists currently=1 and it's on a 4 CPU Sparc under 8.0.5 in a 24/7
environment.

I think this points to freelists needing to be increased. The powers
that be want a guarantee before they give me a maintenance window so I
can go through the rebuild on this table to change the freelists.
(We've got an 8.1.7 conversion project going but this can't wait.)

So I'm trying to put together a test set to prove that the freelist
increase will help.  What I've  been trying has two parts.  A simple
sql script like:

$cat blocktest.sql
insert into block_test values 
('

Re: NT Monitoring Scripts

2002-02-05 Thread Gene Sais


you can buy the mks toolkit, real cheap or convert to perl, then it works on any OS :) 
 also, big brother monitoring sw is free and cool.
gene

 [EMAIL PROTECTED] 02/05/02 11:10AM 
Greetings,
We recently implemented an Oracle 8.1.7 database on NT4.0. Since this is
the first for our company, I need some help setting up the monitoring
procedure. On the unix side I have a Korn script that parses the alert log
and page/E-mail me if errors are found. But NT is a different beast and I
don't know much about the scripting side of things ( other than it's pretty
lame :) ). So does anyone out there have a script/tool handy? I think I
have better things to do than picking up an NT scripting book just for this
one database. Also, does anyone have good experience with MKS? Our NT
administrator is not crazy about installing it on our production server.

TIA

Dennis

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

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

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

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

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

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

RE: HOW TO KNOW INDEX NOT IN USE?


I get redirected to the same place you do.

-Original Message-
Sent: Tuesday, February 05, 2002 10:01 AM
To: Multiple recipients of list ORACLE-L


Can anyone else get to this article? 

My browser gets redirected to 
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a8985
2/d_metada.htm#1656

Jared





àãø éçéàì [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/02 12:45 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: 
Subject:RE: HOW TO KNOW INDEX NOT IN USE?


Hello Seema

Oracle magazine for 01-02/2002 has on page 91 an article 
that gives step by step instructions on this issue for 9i.
They also have a reference to:
http://www.oracle.com/oramag/oracle/jan02/metadata.html

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From:  Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent:  Mon, February 04, 2002 7:55 PM
 To:Multiple recipients of list ORACLE-L
 Subject:   HOW TO KNOW INDEX NOT IN USE?
 
 Hi
 I there any view which can tell us which indexes are not in use?
 Thx
 -Seema
 
 
 
 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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



W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ(§Ú©Êëa¢²
2ZçR¶)e§b³+¢aZ´(È×ÂäIêïÇ¬ó9ßÎtçQ@_Î|ç9ÓRjpâz
jX¢¹âhû'×«ëZqÇ¬³óX§¸¬¶ÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j
 ¸¬´k«¹ör+rr§¢×\²¥)à¡òâ²Ñ®®æ§v)íé²Æ xb)Üç^jX§yÊ'µ¨§x5%9
,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þé¨½ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º-êâú+«b¢yb
ë.nÇ+¸§
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

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

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

Compaq Oracle on Tru64 UNIX course

2002-02-05 Thread Boivin, Patrice J


FYI,

I just tried to ask Compaq if course 620 is still offered
(http://www5.compaq.com/training/620.html), and the message I got on their
voice mail was:

Due to technical difficulties your call cannot be completed.  Please try
again.

Then, a dial tone.

Their Web site does not list any class times for this course, that I could
find.

I am going to try again, but if anyone has info on where Oracle on Tru64
courses are offered, please let me know.
 
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]

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

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

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

Problem with 9i

2002-02-05 Thread KENNETH JANUSZ




9i (9.0.1) on Dell 8200 using XP Prof.

I am logged into SQL*Plus. I enter "set pause 
on". I run a simple select statement. Boom!! SQL*Plus instantly logs 
out.

If I don't set pause on the code works and I stay 
in SQL*Plus.

Any idea what is causing this?

Thanks,
Ken Janusz, CPIM

RE: O9i Predefined Roles

2002-02-05 Thread Deshpande, Kirti


Yes, they come predefined.  

- Kirti 

-Original Message-
Sent: Tuesday, February 05, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L


Are the CONNECT, RESOURCE, and DBA roles still predefined roles in O9i like
they are in O8i?


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

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

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

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

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

RE: HOW TO KNOW INDEX NOT IN USE?

2002-02-05 Thread Deshpande, Kirti


Here is the correct link for the article on the index usage in 9i. 
http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html

The original post mentioned that the article contained a link to the
Metadata package and had a link to it, but it did not contain the link to
the article itself !! :( 

HTH,

- Kirti


-Original Message-
Sent: Tuesday, February 05, 2002 10:01 AM
To: Multiple recipients of list ORACLE-L


Can anyone else get to this article? 

My browser gets redirected to 
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/d_
metada.htm#1656

Jared

àãø éçéàì [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/02 12:45 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: HOW TO KNOW INDEX NOT IN USE?


Hello Seema

Oracle magazine for 01-02/2002 has on page 91 an article 
that gives step by step instructions on this issue for 9i.
They also have a reference to:
http://www.oracle.com/oramag/oracle/jan02/metadata.html

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From:  Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent:  Mon, February 04, 2002 7:55 PM
 To:Multiple recipients of list ORACLE-L
 Subject:   HOW TO KNOW INDEX NOT IN USE?
 
 Hi
 I there any view which can tell us which indexes are not in use?
 Thx
 -Seema
 
 
 
 _
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re: O9i Predefined Roles


yes, I believe so


--- Orr, Steve [EMAIL PROTECTED] wrote:
 Are the CONNECT, RESOURCE, and DBA roles still predefined roles in
 O9i like
 they are in O8i?
 
 
 Steve Orr
 Bozeman, MT
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Browett, Darren


Try http://www.globalknowledge.com/canada  they have courses for Oracle and
Tru64, not sure
if they have a course for Oracle on Tru64.

I attended a Tru64 course in Toronto, it was really good.

Darren

-Original Message-
Sent: February 5, 2002 9:26 AM
To: Multiple recipients of list ORACLE-L


FYI,

I just tried to ask Compaq if course 620 is still offered
(http://www5.compaq.com/training/620.html), and the message I got on their
voice mail was:

Due to technical difficulties your call cannot be completed.  Please try
again.

Then, a dial tone.

Their Web site does not list any class times for this course, that I could
find.

I am going to try again, but if anyone has info on where Oracle on Tru64
courses are offered, please let me know.
 
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]

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

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

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

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

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

RE: export/import on the same server


Hello Rachel

It seems that I misunderstood the docs.
Just to make sure, I did a full database export and checked the output.
Yip - the create tablespace statements are there.
Since I have done my share of full database imports and have never seen
tablespace created, I never thought that you can create tablespace
during import.

Mea Culpa

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, February 05, 2002 6:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: export/import on the same server
 
 unless I am misreading the 9i docs (see below) this has nothing to do
 with transportable tablespaces
 
 If you use DESTROY=Y and a full database import, Oracle will overwrite
 the datafiles as defined in the create tablespace statement that is in
 the dump file. It's the equivalent of issuing:
 
 create tablespace tbsname datafile 'prod file name' reuse;
 
 From the 9i Utilities manual:
 
 Specifies whether or not the existing datafiles making up the database
 should be reused. That is, specifying DESTROY=y causes Import to
 include the REUSE option in the datafile clause of the CREATE
 TABLESPACE statement, which causes Import to reuse the original
 database's datafiles after deleting their contents. 
 
 Note that the export file contains the datafile names used in each
 tablespace. If you specify DESTROY=y and attempt to create a second
 database on the same system (for testing or other purposes), the Import
 utility will overwrite the first database's datafiles when it creates
 the tablespace. In this situation you should use the default,
 DESTROY=n, so that an error occurs if the datafiles already exist when
 the tablespace is created. Also, when you need to import into the
 original database, you will need to specify IGNORE=y to add to the
 existing datafiles without replacing them. 
 
 
 
 --- àãø_éçéàì [EMAIL PROTECTED] wrote:
  Hello Dave
  
  I checked the docs.
  It seems to me that destroy is associated with transport_tablespaces.
  If you transport tablespaces destroy=y means overwrite old data files
  with the same name.
  
  In regular import the @database set the target database.
  
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
  
   -Original Message-
   From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
   Sent: Tue, February 05, 2002 4:21 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  export/import on the same server
   
   I have a question on the export/import utility.  I have my
  live(PROD)
   and test(TEST) databases are on the same server.  These are
  basically
   the same schemas except that the data in TEST is old and that the
   datafiles for PROD are on I: drive and the datafiles for TEST are
  on E:
   drive.
   My question is, since these are on the same server do I have to
  worry
   about which data files will be written to during the import.  For
   example;
   I do a full export of my PROD database.  When I do my import into
  my
   TEST database will the data automatically go to E: drive or will it
   still be pointing to I: drive?  I am reading the Import section of
  the
   fine manual but am a bit confused on the datafiles part of it when
  doing
   a full export/import.  Do I need to use the DESTROY=N parameter?
   I am new to this utility but want to learn it.  I am reading the
  manuals
   and some other reading material but still am not clear on this.  I
  do
   not want it to start overwriting my live data.  That is not good
  for job
   security.
   
   Thanks,
   
   Dave
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Farnsworth, Dave
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing
  Lists
  
  
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like
  subscribing).
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This e-mail was scanned by the eSafe Mail Gateway 
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT

RE: HOW TO KNOW INDEX NOT IN USE?


Hello John

I already send the article URL to the list.
I think that the members would like the URL
rather then : I can get it.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Shaw John-P55297 [SMTP:[EMAIL PROTECTED]]
 Sent: Tue, February 05, 2002 7:36 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: HOW TO KNOW INDEX NOT IN USE?
 
 I can get it.
 
   -Original Message-
   From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, February 05, 2002 11:21 AM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: HOW TO KNOW INDEX NOT IN USE?
   
   
 
   Nope.  Same behavior for me. 
 
   -Original Message- 
   From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] 
   Sent: Tuesday, February 05, 2002 11:01 AM 
   To: Multiple recipients of list ORACLE-L 
   Subject: RE: HOW TO KNOW INDEX NOT IN USE? 
 
 
   Can anyone else get to this article? 
 
   My browser gets redirected to 
   
 http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852
 /d_metada.htm#1656 
 
   Jared 
 
 
 
 
 
 [EMAIL PROTECTED] 
   Sent by: [EMAIL PROTECTED] 
   02/05/02 12:45 AM 
   Please respond to ORACLE-L 
 
 
   To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED] 
   cc: 
   Subject:RE: HOW TO KNOW INDEX NOT IN USE? 
 
 
   Hello Seema 
 
   Oracle magazine for 01-02/2002 has on page 91 an article 
   that gives step by step instructions on this issue for 9i. 
   They also have a reference to: 
   http://www.oracle.com/oramag/oracle/jan02/metadata.html 
 
   Yechiel Adar, Mehish Computer Services 
   [EMAIL PROTECTED] 
 
-Original Message- 
From:  Seema Singh [SMTP:[EMAIL PROTECTED]] 
Sent:  Mon, February 04, 2002 7:55 PM 
To:Multiple recipients of list ORACLE-L 
Subject:   HOW TO KNOW INDEX NOT IN USE? 

Hi 
I there any view which can tell us which indexes are not in use? 
Thx 
-Seema 



_ 
Chat with friends online, try MSN Messenger:
 http://messenger.msn.com 

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

Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051 
San Diego, California-- Public Internet access / Mailing
 Lists 
   
  
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You
 may 
also send the HELP command for other information (like
 subscribing). 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 
 This e-mail was scanned by the eSafe Mail Gateway 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 
 
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com 
   -- 
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 
 INET: [EMAIL PROTECTED] 
 
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
   San Diego, California-- Public Internet access / Mailing
 Lists 
   
 
   To REMOVE yourself from this mailing list, send an E-Mail message 
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
   the message BODY, include a line containing: UNSUB ORACLE-L 
   (or the name of mailing list you want to be removed from).  You may 
   also send the HELP command for other information (like subscribing).
 
 
 
 
   Wz?^!r9,B?m?? 
   (??a 
   2ZR)eb+aZ(???I??9??tQ@_?|9?Rjpz 
   
 jXh?-'?Zq?XEUR?DCTL*ka?X'X?u?1(tm)
 ,j kr+rr??\--)!?v)...?
 xfb)?-^jXy?'x5%9,B?^!X'X*.???_?~?l?v?^
 B?r?jw_-...+(tm)byb'.n?+?
 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?_?  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL

Looking for FM T R

2002-02-05 Thread Bellows, Bambi

Title: RE: HOW TO KNOW INDEX NOT IN USE?

Friends -

Once upon a time, a very long time ago, I
had a large black notebook. I found
it in my cube when I moved into it in 1985. I think it was from v4 days as it was
old and dog-eared and we were currently on v5.0.14 or thereabouts. Anyway, this notebook was a tutorial
that Oracle put out on all its wonderful features in SQL*Plus, based on
SCOTT/TIGER. There were queries and
joins and correlated subqueries and uncorrelated subqueries.
There was GROUP BYs and CONNECTs. There
were UNIONs and INTERSECTs
and MINUSs.
There were DECODEs and NVLs
and lots of different DATE functions.
There were tricks to do with MOD, and ABS and SIGN, and the 101 ways to
spend your vacation in the DUAL table.
Overall, it was a grand frolic of SQL, and, geek that I am, I really
enjoyed it.

Of course, I left that notebook in the cube when I left the
company having gone through the book to teach myself SQL after long years of
QUEL. The years have gone by, and
now I'm in a new company with a lovely boss who's an old geek too,
but on the IBM side. This is his
first exposure to Oracle and I wanted to get him a grand frolic through the
non-ANSI standard extensions of Oracle, and would have *thought* that a book similar to my old
black notebook but even bigger and better would still be in existence
somewhere.

But try as I may, I can't find anything like it. In fact, even getting a vanilla 5 page "this
is scott/tiger" set of introductory exercises
is not as easy as one might think. I'm
going to snag one off of google. But, in the meantime, does anyone know
of an online version of "this-is-all-the-cool-sh*t-you-can-do-in-Oracle-whether-or-not-its-ANSI-standard-(ANSI-is-for-wimps-anyway)"
floating around?

So as not to pester the List, if you could email me directly,
that would sure be swell. And, as always, your thoughts are
appreciated.

Best wishes!

Bambi.

RE: O9i Predefined Roles

2002-02-05 Thread Orr, Steve


The documentation says they could go away with a future release but I guess
we can depend on them for a while longer.

-Original Message-
Sent: Tuesday, February 05, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L


yes, I believe so


--- Orr, Steve [EMAIL PROTECTED] wrote:
 Are the CONNECT, RESOURCE, and DBA roles still predefined roles in
 O9i like
 they are in O8i?
 
 
 Steve Orr
 Bozeman, MT
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Compaq Oracle on Tru64 UNIX course

2002-02-05 Thread Boivin, Patrice J


Thanks, but there is nothing specifically for Oracle on Tru64 UNIX.

Compaq used to offer four courses, they have no dates now.

Oracle used to offer courses (if I remember correctly) through their Masters
program (the old version), but no longer OS-specific.

I think Compaq is floundering...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, February 05, 2002 2:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Compaq Oracle on Tru64 UNIX course

Try http://www.globalknowledge.com/canada  they have courses for Oracle and
Tru64, not sure
if they have a course for Oracle on Tru64.

I attended a Tru64 course in Toronto, it was really good.

Darren

-Original Message-
Sent: February 5, 2002 9:26 AM
To: Multiple recipients of list ORACLE-L


FYI,

I just tried to ask Compaq if course 620 is still offered
(http://www5.compaq.com/training/620.html), and the message I got on their
voice mail was:

Due to technical difficulties your call cannot be completed.  Please try
again.

Then, a dial tone.

Their Web site does not list any class times for this course, that I could
find.

I am going to try again, but if anyone has info on where Oracle on Tru64
courses are offered, please let me know.
 
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]

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

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

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

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

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

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

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

9iAS and iPlanet LDAP

2002-02-05 Thread James Howerton


DBA's

1. Has anyone been able to get 9iAS Apache and/or Portal to work with
the iPlanet LDAP sever. I tried following the December 2000 Configuring
Oracle 9iAS Portal for LDAP Authentication white paper. No luck. Opened
a TAR they suggested I use Oracle's LDAP  sync it with iPlanet. We
don't want to maintain several separate LDAP's unless there is no other
way. Re-linking Apache with mod_auth_ldap is not supported???

2. Is there a 9iAS listserv similar to this list?

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

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

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

RE: export/import on the same server


Thanks to everyone for their help.  Since these are the same schema I
see no reason why to do a full import.  Anyway, I am in learning mode
and need to learn about possible parameters to use.  I am going to do an
owner import from my full export file since I only need a few of the
owners schema's.  I'll first creat my PARFILE like

FILE=C:\my_export_file.dmp
FROMUSER=(dorkboy,geekgirl,sheep_lover,monkey_spanker)
GRANTS=Y
INDEXES=Y


Then do a

SET ORACLE_SID=my_test_db

then

IMP my_login/my_dirty_pwd parfile=my_parfile.dat

My login to test is different from my live database login so I should be
covered there.  Does this look like it will work so that it will not try
to write to the datafiles of my live database?  Remember, the file I am
importing into my test database is an export from my live database which
both reside on the same server but have their data on different drives.

Thanks much everyone,

Dave

-Original Message-
Sent: Tuesday, February 05, 2002 10:10 AM
To: Multiple recipients of list ORACLE-L


unless I am misreading the 9i docs (see below) this has nothing to do
with transportable tablespaces

If you use DESTROY=Y and a full database import, Oracle will overwrite
the datafiles as defined in the create tablespace statement that is in
the dump file. It's the equivalent of issuing:

create tablespace tbsname datafile 'prod file name' reuse;

From the 9i Utilities manual:

Specifies whether or not the existing datafiles making up the database
should be reused. That is, specifying DESTROY=y causes Import to
include the REUSE option in the datafile clause of the CREATE
TABLESPACE statement, which causes Import to reuse the original
database's datafiles after deleting their contents. 

Note that the export file contains the datafile names used in each
tablespace. If you specify DESTROY=y and attempt to create a second
database on the same system (for testing or other purposes), the Import
utility will overwrite the first database's datafiles when it creates
the tablespace. In this situation you should use the default,
DESTROY=n, so that an error occurs if the datafiles already exist when
the tablespace is created. Also, when you need to import into the
original database, you will need to specify IGNORE=y to add to the
existing datafiles without replacing them. 



--- àãø_éçéàì [EMAIL PROTECTED] wrote:
 Hello Dave
 
 I checked the docs.
 It seems to me that destroy is associated with transport_tablespaces.
 If you transport tablespaces destroy=y means overwrite old data files
 with the same name.
 
 In regular import the @database set the target database.
 
 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]
 
  -Original Message-
  From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
  Sent:   Tue, February 05, 2002 4:21 PM
  To: Multiple recipients of list ORACLE-L
  Subject:export/import on the same server
  
  I have a question on the export/import utility.  I have my
 live(PROD)
  and test(TEST) databases are on the same server.  These are
 basically
  the same schemas except that the data in TEST is old and that the
  datafiles for PROD are on I: drive and the datafiles for TEST are
 on E:
  drive.
  My question is, since these are on the same server do I have to
 worry
  about which data files will be written to during the import.  For
  example;
  I do a full export of my PROD database.  When I do my import into
 my
  TEST database will the data automatically go to E: drive or will it
  still be pointing to I: drive?  I am reading the Import section of
 the
  fine manual but am a bit confused on the datafiles part of it when
 doing
  a full export/import.  Do I need to use the DESTROY=N parameter?
  I am new to this utility but want to learn it.  I am reading the
 manuals
  and some other reading material but still am not clear on this.  I
 do
  not want it to start overwriting my live data.  That is not good
 for job
  security.
  
  Thanks,
  
  Dave
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   This e-mail was scanned by the eSafe Mail Gateway 
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   INET: [EMAIL PROTECTED]
 
 Fat

Capacity Planning

2002-02-05 Thread Donald Bricker


Could anyone direct me to some excellent documentation on capacity planning or give 
any insights that they might have?

Thanks


Don Bricker
Database Administrator / System Administrator
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290

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

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

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

2002-02-05 Thread Babich , Sergey


Hi, colleagues,
Could someone enlighten me on the above subject? 8.1.7.0.0/ Win2k 2.5G RAM.
Users get a lot of those when reports are run heavily. Once I opened a TAR
on that, and Oracle support recommended either cutting the db_block_buffers
(which I did), or changing the process memory addressability to 3G. Reports
use a lot of views based on joins of huge tables. Now I'm getting these
errors again. Any advice appreciated.
Regards,
Sergey Babich


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

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

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

Re: Problem with 9i


well, don't set pause on unless you invoked sqlplus from the command
line :)

--- [EMAIL PROTECTED] wrote:
 In reply to a similar complaint on MetaLink:
 
  You are hitting the Bug #1902459. Since the bug is not published so
 right 
 now you won't be able to see it. But as per the bug
  content, it seems that the bug will be fixed in 9.0.2 
 ...
 Ishwar is right. Bug content says the problem is only with the GUI
 version 
 of SQL*Plus but works fine if SQL*Plus is invoked
  through command prompt. 
  Bug Number has been provided. Once it gets published you will be
 able to 
 see it. 
 
 So, I guess this means Don't 'set pause on'
 
 Jared
 
 
 
 
 
 KENNETH JANUSZ [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 02/05/02 09:25 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Problem with 9i
 
 
 9i (9.0.1) on Dell 8200 using XP Prof.
  
 I am logged into SQL*Plus.  I enter set pause on.  I run a simple
 select 
 statement.  Boom!! SQL*Plus instantly logs out.
  
 If I don't set pause on the code works and I stay in SQL*Plus.
  
 Any idea what is causing this?
  
 Thanks,
 Ken Janusz, CPIM
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Deepak Thapliyal


yes
--- Orr, Steve [EMAIL PROTECTED] wrote:
 Are the CONNECT, RESOURCE, and DBA roles still
 predefined roles in O9i like
 they are in O8i?
 
 
 Steve Orr
 Bozeman, MT
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Ferguson II, Roy E


for sun: Configuration and capacity planning for Solaris servers by Brian L.
Wong.

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


Could anyone direct me to some excellent documentation on capacity planning
or give any insights that they might have?

Thanks


Don Bricker
Database Administrator / System Administrator
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290

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

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

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

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

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

RE: export/import on the same server


No biggie -- I just know it because that was how we used to build our
contingency database a few jobs  back. :)


--- àãø_éçéàì [EMAIL PROTECTED] wrote:
 Hello Rachel
 
 It seems that I misunderstood the docs.
 Just to make sure, I did a full database export and checked the
 output.
 Yip - the create tablespace statements are there.
 Since I have done my share of full database imports and have never
 seen
 tablespace created, I never thought that you can create tablespace
 during import.
 
 Mea Culpa
 
 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]
 
  -Original Message-
  From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
  Sent:   Tue, February 05, 2002 6:10 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: export/import on the same server
  
  unless I am misreading the 9i docs (see below) this has nothing to
 do
  with transportable tablespaces
  
  If you use DESTROY=Y and a full database import, Oracle will
 overwrite
  the datafiles as defined in the create tablespace statement that is
 in
  the dump file. It's the equivalent of issuing:
  
  create tablespace tbsname datafile 'prod file name' reuse;
  
  From the 9i Utilities manual:
  
  Specifies whether or not the existing datafiles making up the
 database
  should be reused. That is, specifying DESTROY=y causes Import to
  include the REUSE option in the datafile clause of the CREATE
  TABLESPACE statement, which causes Import to reuse the original
  database's datafiles after deleting their contents. 
  
  Note that the export file contains the datafile names used in each
  tablespace. If you specify DESTROY=y and attempt to create a second
  database on the same system (for testing or other purposes), the
 Import
  utility will overwrite the first database's datafiles when it
 creates
  the tablespace. In this situation you should use the default,
  DESTROY=n, so that an error occurs if the datafiles already exist
 when
  the tablespace is created. Also, when you need to import into the
  original database, you will need to specify IGNORE=y to add to the
  existing datafiles without replacing them. 
  
  
  
  --- àãø_éçéàì [EMAIL PROTECTED] wrote:
   Hello Dave
   
   I checked the docs.
   It seems to me that destroy is associated with
 transport_tablespaces.
   If you transport tablespaces destroy=y means overwrite old data
 files
   with the same name.
   
   In regular import the @database set the target database.
   
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
   
-Original Message-
From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent:   Tue, February 05, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject:export/import on the same server

I have a question on the export/import utility.  I have my
   live(PROD)
and test(TEST) databases are on the same server.  These are
   basically
the same schemas except that the data in TEST is old and that
 the
datafiles for PROD are on I: drive and the datafiles for TEST
 are
   on E:
drive.
My question is, since these are on the same server do I have to
   worry
about which data files will be written to during the import. 
 For
example;
I do a full export of my PROD database.  When I do my import
 into
   my
TEST database will the data automatically go to E: drive or
 will it
still be pointing to I: drive?  I am reading the Import section
 of
   the
fine manual but am a bit confused on the datafiles part of it
 when
   doing
a full export/import.  Do I need to use the DESTROY=N
 parameter?
I am new to this utility but want to learn it.  I am reading
 the
   manuals
and some other reading material but still am not clear on this.
  I
   do
not want it to start overwriting my live data.  That is not
 good
   for job
security.

Thanks,

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

Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
San Diego, California-- Public Internet access /
 Mailing
   Lists
   
  
 
To REMOVE yourself from this mailing list, send an E-Mail
 message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
 and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You
 may
also send the HELP command for other information (like
   subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 INET: [EMAIL PROTECTED]
   
   Fat

Re: Tkprof.

2002-02-05 Thread Bjørn Engsig


If you are in to doing just moderately interesting performance 
investigation and tuning, I would highly recommend learning how to use 
the raw trace file.  The aggregation that tkprof does has a tendency to 
hide information rather than providing much more than the raw file.

Thanks, Bjørn.

[EMAIL PROTECTED] wrote:

Check OTN.  Signup is free, otn.oracle.com, they've never hassled or
spammed me, and the documentation is invaluable.


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


  
 
Rajesh Dayal  
 
Rajesh@ohitel   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
ecom.comcc:  
 
Sent by: Subject: RE: Tkprof. 
 
[EMAIL PROTECTED]
 
om
 
  
 
  
 
02/05/2002
 
12:15 AM  
 
Please respond
 
to ORACLE-L   
 
  
 
  
 




Just type tkprof on command line (DOS) or on shell prompt (UNIX),

You would find the help and all your doubts would be cleared.

HTH,
Rajesh
-Original Message-
Sent: Tuesday, February 05, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L

Hi all

I am having a doubt in how to use Tkprof.



This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.



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

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

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

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

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

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

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

RMAN question

2002-02-05 Thread Sona


Hi
if I take an incremental level 0 backups with RMAN .How do I determine by
the list command if all these backups listed are of the same backup set or
not.
I took a incremental level 0 backup with filesperset 2.
which is the column I should look at to uniquely identify a backup set.

shown below is the output of the

RMANlist backup set of database;

List of Backup Sets
Key Recid  Stamp  LV Set Stamp  Set Count  Completion Time
--- -- -- -- -- -- -
-
378 16 452962659  0  452962651  20 04-FEB-02

List of Backup Pieces
Key Pc# Cp# Status  Completion TimePiece Name
--- --- --- --- -- -
---
379 1   1   AVAILABLE   04-FEB-02
/ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp

List of Datafiles Included
File Name  LV Type Ckp SCNCkp Time
 - --  -- --
---
3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0  Full 142896
04-FEB-02

List of Backup Sets
Key Recid  Stamp  LV Set Stamp  Set Count  Completion Time
--- -- -- -- -- -- -
-
384 17 452970568  0  452970560  21 04-FEB-02

List of Backup Pieces
Key Pc# Cp# Status  Completion TimePiece Name
--- --- --- --- -- -
---
385 1   1   AVAILABLE   04-FEB-02
/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp

List of Datafiles Included
File Name  LV Type Ckp SCNCkp Time
 - --  -- --
---
2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0  Full 142925
04-FEB-02
5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0  Full 142925
04-FEB-02

List of Backup Sets
Key Recid  Stamp  LV Set Stamp  Set Count  Completion Time
--- -- -- -- -- -- -
-
389 18 452971072  0  452971064  23 04-FEB-02

List of Backup Pieces
Key Pc# Cp# Status  Completion TimePiece Name
--- --- --- --- -- -
---
392 1   1   AVAILABLE   04-FEB-02
/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp

List of Datafiles Included
File Name  LV Type Ckp SCNCkp Time
 - --  -- --
---
2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0  Full 162954
04-FEB-02
5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0  Full 162954
04-FEB-02

List of Backup Sets
Key Recid  Stamp  LV Set Stamp  Set Count  Completion Time
--- -- -- -- -- -- -
-
390 19 452971100  0  452971080  24 04-FEB-02

List of Backup Pieces
Key Pc# Cp# Status  Completion TimePiece Name
--- --- --- --- -- -
---
393 1   1   AVAILABLE   04-FEB-02
/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp

List of Datafiles Included
File Name  LV Type Ckp SCNCkp Time
 - --  -- --
---
1/ora/data01/bkuptest/dbfiles/system.1.dbf 0  Full 162955
04-FEB-02

List of Backup Sets
Key Recid  Stamp  LV Set Stamp  Set Count  Completion Time
--- -- -- -- -- -- -
-
391 20 452971112  0  452971105  25 04-FEB-02

List of Backup Pieces
Key Pc# Cp# Status  Completion TimePiece Name
--- --- --- --- -- -
---
394 1   1   AVAILABLE   04-FEB-02
/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp

List of Datafiles Included
File Name  LV Type Ckp SCNCkp Time
 - --  -- --
---
3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0  Full 162956
04-FEB-02

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

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

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

Security for Table/Procedure

2002-02-05 Thread Burton, Laura L.

Title: Security for Table/Procedure





I know that you can grant access on a table whether it be select, update, delete, etc, and I know that to keep from granting access to a table you can use procedures and grant execute rights to the procedure. 

Our situation is that we want to use procedures for security, but the procedures select data to populate a form and then update if applicable. We had talked about granting select to the tables by using a role since anyone can view the data, and then using procedures to update the tables. The only problem is that if we grant select to the tables and the application executes the procedure within it, the procedure will not be found and even the select will not happen.

Could some of you share how you handle security? Am I missing something with tables/procedures? Any ideas would be appreciated. We are just beginning development and need to have a handle on how we are going to do this.

Thanks,

Laura

RE: Problem with 9i

2002-02-05 Thread Mercadante, Thomas F


Doctor - Doctor - it hurts when I do this - - Then don't do that!

well, don't set pause on unless you invoked sqlplus from the command line

--- [EMAIL PROTECTED] wrote:
 In reply to a similar complaint on MetaLink:
 
  You are hitting the Bug #1902459. Since the bug is not published so
 right 
 now you won't be able to see it. But as per the bug
  content, it seems that the bug will be fixed in 9.0.2 
 ...
 Ishwar is right. Bug content says the problem is only with the GUI
 version 
 of SQL*Plus but works fine if SQL*Plus is invoked
  through command prompt. 
  Bug Number has been provided. Once it gets published you will be
 able to 
 see it. 
 
 So, I guess this means Don't 'set pause on'
 
 Jared
 
 
 
 
 
 KENNETH JANUSZ [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 02/05/02 09:25 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Problem with 9i
 
 
 9i (9.0.1) on Dell 8200 using XP Prof.
  
 I am logged into SQL*Plus.  I enter set pause on.  I run a simple
 select 
 statement.  Boom!! SQL*Plus instantly logs out.
  
 If I don't set pause on the code works and I stay in SQL*Plus.
  
 Any idea what is causing this?
  
 Thanks,
 Ken Janusz, CPIM
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: O9i Predefined Roles


the documentation has been saying that since at least Version 7

heck, they've been saying svrmgr will go away with each release since
7, they finally got rid of it in 9


--- Orr, Steve [EMAIL PROTECTED] wrote:
 The documentation says they could go away with a future release but I
 guess
 we can depend on them for a while longer.
 
 -Original Message-
 Sent: Tuesday, February 05, 2002 10:56 AM
 To: Multiple recipients of list ORACLE-L
 
 
 yes, I believe so
 
 
 --- Orr, Steve [EMAIL PROTECTED] wrote:
  Are the CONNECT, RESOURCE, and DBA roles still predefined roles in
  O9i like
  they are in O8i?
  
  
  Steve Orr
  Bozeman, MT
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Orr, Steve
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 
 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Orr, Steve
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: RMAN question

2002-02-05 Thread Deepak Thapliyal


Use LV-- level 
--- Sona [EMAIL PROTECTED] wrote:
 Hi
 if I take an incremental level 0 backups with RMAN
 .How do I determine by
 the list command if all these backups listed are of
 the same backup set or
 not.
 I took a incremental level 0 backup with filesperset
 2.
 which is the column I should look at to uniquely
 identify a backup set.
 
 shown below is the output of the
 
 RMANlist backup set of database;
 
 List of Backup Sets
 Key Recid  Stamp  LV Set Stamp  Set
 Count  Completion Time
 --- -- -- -- --
 -- -
 -
 378 16 452962659  0  452962651  20  
   04-FEB-02
 
 List of Backup Pieces
 Key Pc# Cp# Status  Completion Time 
   Piece Name
 --- --- --- ---
 -- -
 ---
 379 1   1   AVAILABLE   04-FEB-02

/ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp
 
 List of Datafiles Included
 File Name  LV
 Type Ckp SCNCkp Time
  - --
  -- --
 ---
 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 
 Full 142896
 04-FEB-02
 
 List of Backup Sets
 Key Recid  Stamp  LV Set Stamp  Set
 Count  Completion Time
 --- -- -- -- --
 -- -
 -
 384 17 452970568  0  452970560  21  
   04-FEB-02
 
 List of Backup Pieces
 Key Pc# Cp# Status  Completion Time 
   Piece Name
 --- --- --- ---
 -- -
 ---
 385 1   1   AVAILABLE   04-FEB-02

/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp
 
 List of Datafiles Included
 File Name  LV
 Type Ckp SCNCkp Time
  - --
  -- --
 ---
 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 
 Full 142925
 04-FEB-02
 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf
 0  Full 142925
 04-FEB-02
 
 List of Backup Sets
 Key Recid  Stamp  LV Set Stamp  Set
 Count  Completion Time
 --- -- -- -- --
 -- -
 -
 389 18 452971072  0  452971064  23  
   04-FEB-02
 
 List of Backup Pieces
 Key Pc# Cp# Status  Completion Time 
   Piece Name
 --- --- --- ---
 -- -
 ---
 392 1   1   AVAILABLE   04-FEB-02

/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp
 
 List of Datafiles Included
 File Name  LV
 Type Ckp SCNCkp Time
  - --
  -- --
 ---
 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 
 Full 162954
 04-FEB-02
 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf
 0  Full 162954
 04-FEB-02
 
 List of Backup Sets
 Key Recid  Stamp  LV Set Stamp  Set
 Count  Completion Time
 --- -- -- -- --
 -- -
 -
 390 19 452971100  0  452971080  24  
   04-FEB-02
 
 List of Backup Pieces
 Key Pc# Cp# Status  Completion Time 
   Piece Name
 --- --- --- ---
 -- -
 ---
 393 1   1   AVAILABLE   04-FEB-02

/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp
 
 List of Datafiles Included
 File Name  LV
 Type Ckp SCNCkp Time
  - --
  -- --
 ---
 1/ora/data01/bkuptest/dbfiles/system.1.dbf 0
  Full 162955
 04-FEB-02
 
 List of Backup Sets
 Key Recid  Stamp  LV Set Stamp  Set
 Count  Completion Time
 --- -- -- -- --
 -- -
 -
 391 20 452971112  0  452971105  25  
   04-FEB-02
 
 List of Backup Pieces
 Key Pc# Cp# Status  Completion Time 
   Piece Name
 --- --- --- ---
 -- -
 ---
 394 1   1   AVAILABLE   04-FEB-02

/ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp
 
 List of Datafiles Included
 File Name  LV
 Type Ckp SCNCkp Time
  - --
  -- --
 ---
 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 
 Full 162956
 04-FEB-02
 
 TIA
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Sona
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

Re: NT Monitoring Scripts

2002-02-05 Thread Stephane Faroult


[EMAIL PROTECTED] wrote:
 
 Greetings,
 We recently implemented an Oracle 8.1.7 database on NT4.0. Since this is
 the first for our company, I need some help setting up the monitoring
 procedure. On the unix side I have a Korn script that parses the alert log
 and page/E-mail me if errors are found. But NT is a different beast and I
 don't know much about the scripting side of things ( other than it's pretty
 lame :) ). So does anyone out there have a script/tool handy? I think I
 have better things to do than picking up an NT scripting book just for this
 one database. Also, does anyone have good experience with MKS? Our NT
 administrator is not crazy about installing it on our production server.
 
 TIA
 
 Dennis
 

FYI David Korn has written a version of ksh for NT. Somewhere on
www.att.com. You can evaluate it for free and you almost forget you are
on NT. A few incompatibilities with Oracle, though, but searching alert
files should be no problem.
-- 
Regards,

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

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

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

RE: export/import on the same server


Is it necessary to drop the users and/or their objects?  I guess I was
not planning on dropping them.  The IGNORE=Y, will this cause the
import to skip an object if it already exists, but it will still import
the data???

Thanks again Rachel,

Dave

-Original Message-
Sent: Tuesday, February 05, 2002 1:25 PM
To: Multiple recipients of list ORACLE-L


yes that should work because you aren't doing a full db import which is
the only way you can destroy the files.

I might do ignore=y as well

are you going to drop the users first, drop just their objects or only
truncate the objects?

if you drop the users, you will need to recreate them or the import
will  load everything into mylogin

for safety's sake, I'd probably run the import once for each user, and
have fromuser= and touser= in the parfile


--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
 Thanks to everyone for their help.  Since these are the same schema I
 see no reason why to do a full import.  Anyway, I am in learning mode
 and need to learn about possible parameters to use.  I am going to do
 an
 owner import from my full export file since I only need a few of the
 owners schema's.  I'll first creat my PARFILE like
 
 FILE=C:\my_export_file.dmp
 FROMUSER=(dorkboy,geekgirl,sheep_lover,monkey_spanker)
 GRANTS=Y
 INDEXES=Y
 
 
 Then do a
 
 SET ORACLE_SID=my_test_db
 
 then
 
 IMP my_login/my_dirty_pwd parfile=my_parfile.dat
 
 My login to test is different from my live database login so I should
 be
 covered there.  Does this look like it will work so that it will not
 try
 to write to the datafiles of my live database?  Remember, the file I
 am
 importing into my test database is an export from my live database
 which
 both reside on the same server but have their data on different
 drives.
 
 Thanks much everyone,
 
 Dave
 
 -Original Message-
 Sent: Tuesday, February 05, 2002 10:10 AM
 To: Multiple recipients of list ORACLE-L
 
 
 unless I am misreading the 9i docs (see below) this has nothing to do
 with transportable tablespaces
 
 If you use DESTROY=Y and a full database import, Oracle will
 overwrite
 the datafiles as defined in the create tablespace statement that is
 in
 the dump file. It's the equivalent of issuing:
 
 create tablespace tbsname datafile 'prod file name' reuse;
 
 From the 9i Utilities manual:
 
 Specifies whether or not the existing datafiles making up the
 database
 should be reused. That is, specifying DESTROY=y causes Import to
 include the REUSE option in the datafile clause of the CREATE
 TABLESPACE statement, which causes Import to reuse the original
 database's datafiles after deleting their contents. 
 
 Note that the export file contains the datafile names used in each
 tablespace. If you specify DESTROY=y and attempt to create a second
 database on the same system (for testing or other purposes), the
 Import
 utility will overwrite the first database's datafiles when it creates
 the tablespace. In this situation you should use the default,
 DESTROY=n, so that an error occurs if the datafiles already exist
 when
 the tablespace is created. Also, when you need to import into the
 original database, you will need to specify IGNORE=y to add to the
 existing datafiles without replacing them. 
 
 
 
 --- àãø_éçéàì [EMAIL PROTECTED] wrote:
  Hello Dave
  
  I checked the docs.
  It seems to me that destroy is associated with
 transport_tablespaces.
  If you transport tablespaces destroy=y means overwrite old data
 files
  with the same name.
  
  In regular import the @database set the target database.
  
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
  
   -Original Message-
   From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
   Sent: Tue, February 05, 2002 4:21 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  export/import on the same server
   
   I have a question on the export/import utility.  I have my
  live(PROD)
   and test(TEST) databases are on the same server.  These are
  basically
   the same schemas except that the data in TEST is old and that the
   datafiles for PROD are on I: drive and the datafiles for TEST are
  on E:
   drive.
   My question is, since these are on the same server do I have to
  worry
   about which data files will be written to during the import.  For
   example;
   I do a full export of my PROD database.  When I do my import into
  my
   TEST database will the data automatically go to E: drive or will
 it
   still be pointing to I: drive?  I am reading the Import section
 of
  the
   fine manual but am a bit confused on the datafiles part of it
 when
  doing
   a full export/import.  Do I need to use the DESTROY=N parameter?
   I am new to this utility but want to learn it.  I am reading the
  manuals
   and some other reading material but still am not clear on this. 
 I
  do
   not want it to start overwriting my live data.  That is not good
  for job
   security.
   
   Thanks,
   
   Dave
   -- 
   Please see the

RE: Security for Table/Procedure

2002-02-05 Thread marmstrong

Title: Security for Table/Procedure



You 
could set up a role that has all the privileges necessary to run the application 
then use the set role command in the application - this turns on the 
functionality while the user is using the application. Once out of the app, the 
users do not have privileges to tables/procedures unless granted via another 
role or specifically to the user. You can also create the role with a password - 
this password would be needed to use the set role command. This provides an 
additional level of security.

Michele

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 05, 2002 2:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Security for Table/Procedure
  I know that you can grant access on a 
  table whether it be select, update, delete, etc, and I know that to keep from 
  granting access to a table you can use 
  procedures and grant execute rights to the procedure. 
  Our situation is that we want to use 
  procedures for security, but the procedures select data to populate a form and 
  then update if applicable. We had talked about 
  granting select to the tables by using a role since anyone can view the data, and then 
  using procedures to update the tables. The only problem is that if we 
  grant select to the tables and the application executes the procedure within 
  it, the 
  procedure will not be found and even the select will not 
  happen.
  Could some of you share how you handle 
  security? Am I missing something with tables/procedures? Any ideas 
  would be appreciated. We are just 
  beginning development and need to have a handle on how we are going to do this.
  Thanks,
  Laura

Re: O9i Predefined Roles

2002-02-05 Thread Stephane Faroult


Rachel Carmichael wrote:
 
 the documentation has been saying that since at least Version 7
 
 heck, they've been saying svrmgr will go away with each release since
 7, they finally got rid of it in 9
 

It will probably take more time. All their sample users are created with

  GRANT CONNECT, RESOURCE TO SAMPLE_USER;

I guess that rewriting demobld.sql musn't be high on the priority list.
-- 
Regards,

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

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

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

RE: Security for Table/Procedure

2002-02-05 Thread Mercadante, Thomas F

Title: Security for Table/Procedure



Laura,

Have 
you looked at public synonyms for your stored procedures? This will solve 
your problem of not being able to find the procedure.

Secondly, where are you creating the stored 
procedures? I would create them in the same account as the tables, and 
grant execute access to whomever needs them.

Finally, you are correct in trying to resolve this now, 
before development gets too far along. Write back to the list - we are all 
willing to help!

Hope 
this helps.
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 05, 2002 2:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Security for Table/Procedure
  I know that you can grant access on a 
  table whether it be select, update, delete, etc, and I know that to keep from 
  granting access to a table you can use 
  procedures and grant execute rights to the procedure. 
  Our situation is that we want to use 
  procedures for security, but the procedures select data to populate a form and 
  then update if applicable. We had talked about 
  granting select to the tables by using a role since anyone can view the data, and then 
  using procedures to update the tables. The only problem is that if we 
  grant select to the tables and the application executes the procedure within 
  it, the 
  procedure will not be found and even the select will not 
  happen.
  Could some of you share how you handle 
  security? Am I missing something with tables/procedures? Any ideas 
  would be appreciated. We are just 
  beginning development and need to have a handle on how we are going to do this.
  Thanks,
  Laura

RE: export/import on the same server


You don't have to drop the users or their objects but you need to at
minimum truncate the tables or the imported data will be APPENDED to
the existing data. 

ignore=y will ignore the create error on the object but will still load
the data.

--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
 Is it necessary to drop the users and/or their objects?  I guess I
 was
 not planning on dropping them.  The IGNORE=Y, will this cause the
 import to skip an object if it already exists, but it will still
 import
 the data???
 
 Thanks again Rachel,
 
 Dave
 
 -Original Message-
 Sent: Tuesday, February 05, 2002 1:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 yes that should work because you aren't doing a full db import which
 is
 the only way you can destroy the files.
 
 I might do ignore=y as well
 
 are you going to drop the users first, drop just their objects or
 only
 truncate the objects?
 
 if you drop the users, you will need to recreate them or the import
 will  load everything into mylogin
 
 for safety's sake, I'd probably run the import once for each user,
 and
 have fromuser= and touser= in the parfile
 
 
 --- Farnsworth, Dave [EMAIL PROTECTED] wrote:
  Thanks to everyone for their help.  Since these are the same schema
 I
  see no reason why to do a full import.  Anyway, I am in learning
 mode
  and need to learn about possible parameters to use.  I am going to
 do
  an
  owner import from my full export file since I only need a few of
 the
  owners schema's.  I'll first creat my PARFILE like
  
  FILE=C:\my_export_file.dmp
  FROMUSER=(dorkboy,geekgirl,sheep_lover,monkey_spanker)
  GRANTS=Y
  INDEXES=Y
  
  
  Then do a
  
  SET ORACLE_SID=my_test_db
  
  then
  
  IMP my_login/my_dirty_pwd parfile=my_parfile.dat
  
  My login to test is different from my live database login so I
 should
  be
  covered there.  Does this look like it will work so that it will
 not
  try
  to write to the datafiles of my live database?  Remember, the file
 I
  am
  importing into my test database is an export from my live database
  which
  both reside on the same server but have their data on different
  drives.
  
  Thanks much everyone,
  
  Dave
  
  -Original Message-
  Sent: Tuesday, February 05, 2002 10:10 AM
  To: Multiple recipients of list ORACLE-L
  
  
  unless I am misreading the 9i docs (see below) this has nothing to
 do
  with transportable tablespaces
  
  If you use DESTROY=Y and a full database import, Oracle will
  overwrite
  the datafiles as defined in the create tablespace statement that is
  in
  the dump file. It's the equivalent of issuing:
  
  create tablespace tbsname datafile 'prod file name' reuse;
  
  From the 9i Utilities manual:
  
  Specifies whether or not the existing datafiles making up the
  database
  should be reused. That is, specifying DESTROY=y causes Import to
  include the REUSE option in the datafile clause of the CREATE
  TABLESPACE statement, which causes Import to reuse the original
  database's datafiles after deleting their contents. 
  
  Note that the export file contains the datafile names used in each
  tablespace. If you specify DESTROY=y and attempt to create a second
  database on the same system (for testing or other purposes), the
  Import
  utility will overwrite the first database's datafiles when it
 creates
  the tablespace. In this situation you should use the default,
  DESTROY=n, so that an error occurs if the datafiles already exist
  when
  the tablespace is created. Also, when you need to import into the
  original database, you will need to specify IGNORE=y to add to the
  existing datafiles without replacing them. 
  
  
  
  --- àãø_éçéàì [EMAIL PROTECTED] wrote:
   Hello Dave
   
   I checked the docs.
   It seems to me that destroy is associated with
  transport_tablespaces.
   If you transport tablespaces destroy=y means overwrite old data
  files
   with the same name.
   
   In regular import the @database set the target database.
   
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
   
-Original Message-
From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent:   Tue, February 05, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject:export/import on the same server

I have a question on the export/import utility.  I have my
   live(PROD)
and test(TEST) databases are on the same server.  These are
   basically
the same schemas except that the data in TEST is old and that
 the
datafiles for PROD are on I: drive and the datafiles for TEST
 are
   on E:
drive.
My question is, since these are on the same server do I have to
   worry
about which data files will be written to during the import. 
 For
example;
I do a full export of my PROD database.  When I do my import
 into
   my
TEST database will the data automatically go to E: drive or
 will
  it
still be pointing to I: drive?  I am reading the Import section
  of

FYI: ALWAYS test your recovery plan!

2002-02-05 Thread Jesse, Rich


So, here we are, restoring production from tape.  Our recovery methods are
sound (we have two or three ways back, depending on circumstances) as we
will have ZERO loss of data with minimal downtime in off-hours, but we hit a
bit of a snag today.

We need to recover all datafiles from tape.  The tape we need is an
incremental, but due to an apparent bug in HP's OmniBack software, it thinks
it needs to recover all datafiles from the full backup, then all of them
from the incremental.  This has the effect of almost doubling our recovery
time.  Since our DB files are only about 23GB, we need to effectively
restore 46GB.  Now if this were 150GB...

Long story short: TEST YOUR DATABASE RECOVERY!  We've tested before, so this
must've cropped up in an Omniback upgrade.

BTW, our production DB is fine, except for the 3M row table a developer
truncated...  ;)

Hope this helps someone!

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

dbms_stats question

2002-02-05 Thread Magaliff, Bill


if you don't specify a partition name when executing
dbms_stats.gather_table_stats, will Oracle gather stats for each partition
separately?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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

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

2002-02-05 Thread Grabowy, Chris


So your telling me that tonight when I watch the evening news, there will be
a report of a murder in Sussex???  Flogging??  Beating??  Rioting??

-Original Message-
Sent: Tuesday, February 05, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L


So, here we are, restoring production from tape.  Our recovery methods are
sound (we have two or three ways back, depending on circumstances) as we
will have ZERO loss of data with minimal downtime in off-hours, but we hit a
bit of a snag today.

We need to recover all datafiles from tape.  The tape we need is an
incremental, but due to an apparent bug in HP's OmniBack software, it thinks
it needs to recover all datafiles from the full backup, then all of them
from the incremental.  This has the effect of almost doubling our recovery
time.  Since our DB files are only about 23GB, we need to effectively
restore 46GB.  Now if this were 150GB...

Long story short: TEST YOUR DATABASE RECOVERY!  We've tested before, so this
must've cropped up in an Omniback upgrade.

BTW, our production DB is fine, except for the 3M row table a developer
truncated...  ;)

Hope this helps someone!

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

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

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

Re: FYI: ALWAYS test your recovery plan!


Thanks for the info Jesse.  Interesting problem with OmniBack.

Re the table truncation:   been there, done that.  Had problems
with SQL*backtrack that took a couple of hours to resolve.  It was
a *very* bad time for it.

The developer's privileges were quickly reduced on the production
database, something to which he gladly consented.  ( hint, hint :)

Jared






Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/02 12:31 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:FYI: *ALWAYS* test your recovery plan!


So, here we are, restoring production from tape.  Our recovery methods are
sound (we have two or three ways back, depending on circumstances) as we
will have ZERO loss of data with minimal downtime in off-hours, but we hit 
a
bit of a snag today.

We need to recover all datafiles from tape.  The tape we need is an
incremental, but due to an apparent bug in HP's OmniBack software, it 
thinks
it needs to recover all datafiles from the full backup, then all of them
from the incremental.  This has the effect of almost doubling our recovery
time.  Since our DB files are only about 23GB, we need to effectively
restore 46GB.  Now if this were 150GB...

Long story short: TEST YOUR DATABASE RECOVERY!  We've tested before, so 
this
must've cropped up in an Omniback upgrade.

BTW, our production DB is fine, except for the 3M row table a developer
truncated...  ;)

Hope this helps someone!

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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



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

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

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

RE: ALWAYS test your recovery plan!

2002-02-05 Thread Mercadante, Thomas F


Rich,

I've always said to test your recovery plan frequently.

The standard joke here (when we were starting to test Rman with Edm) was
that:
We can back-up anything.  It's the restore part that is giving us trouble.

Glad at least you can get your db back.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, February 05, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L


So, here we are, restoring production from tape.  Our recovery methods are
sound (we have two or three ways back, depending on circumstances) as we
will have ZERO loss of data with minimal downtime in off-hours, but we hit a
bit of a snag today.

We need to recover all datafiles from tape.  The tape we need is an
incremental, but due to an apparent bug in HP's OmniBack software, it thinks
it needs to recover all datafiles from the full backup, then all of them
from the incremental.  This has the effect of almost doubling our recovery
time.  Since our DB files are only about 23GB, we need to effectively
restore 46GB.  Now if this were 150GB...

Long story short: TEST YOUR DATABASE RECOVERY!  We've tested before, so this
must've cropped up in an Omniback upgrade.

BTW, our production DB is fine, except for the 3M row table a developer
truncated...  ;)

Hope this helps someone!

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

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

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

Re: Compaq Oracle on Tru64 UNIX course

2002-02-05 Thread orantdba




HI All,

Ifound course 616 being offerred as shown below:

Compaq/Oracle8i for Tru64 UNIX
Course Number: 616

Course Description:
Compaq and Oracle are pleased to announce a joint training
 initiative and the availability of a special Compaq/Oracle8i Integration
 and Performance course offering. This new offering is a 5-day consecutive
 program that is made up of two individual classes presented in the
following  order:
 Oracle Internet Database Operator for Windows NT - Normally
presented  by Oracle as a four-day stand-alone course Compaq/Oracle8i
Integration  and Performance with Tru64 UNIX - Normally presented
by Compaq as a three-day  stand-alone course
 This course provides in-depth technical information about integration,  
   tuning, and optimization of Oracle8i on Compaq platforms. Demonstrations,
 labs, and discussion sessions are focused on how to create an optimized
 installation and how to select a balance between performance, cost,
and  fault tolerance. Real world issues such as planning, sizing,
performance monitoring and tuning will be addressed.

It is being offered in 
Framing ham, MA April 8-12
June 3-7
Lakewood, CO   April 22-26

Los Angelos, CA  April 15 - 19

Hope this helps,
John

[EMAIL PROTECTED] wrote:

  Thanks, but there is nothing specifically for Oracle on Tru64 UNIX.Compaq used to offer four courses, they have no dates now.Oracle used to offer courses (if I remember correctly) through their Mastersprogram (the old version), but no longer OS-specific.I think Compaq is floundering...Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems Admin  Operations | Admin. et Exploit. des systmesTechnology Services| Services technologiquesInformatics Branch | Direction de l'informatique Maritimes Region, DFO  | Rgion des Maritimes, MPOE-Mail: [EMAIL PROTECTED] -Original Message-Sent:   Tuesday, February 05, 2002 2:41 PMTo: Multiple recipients of list ORACLE-LSubject:RE: Compaq Oracle on Tru64 UNIX courseTry http://www.globalknowledge.com/canada  they have courses for Oracle andTru64, not sureif they have "a" course for Oracle on Tru64.I attended a Tru64 course in Toronto, it was really good.Darren-Original Message-Sent: February 5, 2002 9:26 AMTo: Multiple recipients of list ORACLE-LFYI,I just tried to ask Compaq if course 620 is still offered(http://www5.compaq.com/training/620.html), and the message I got on theirvoice mail was:"Due to technical difficulties your call cannot be completed.  Please tryagain."Then, a dial tone.Their Web site does not list any class times for this course, that I couldfind.I am going to try again, but if anyone has info on where Oracle on Tru64courses are offered, please le
t me know. Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems Admin  Operations | Admin. et Exploit. des systmesTechnology Services| Services technologiquesInformatics Branch | Direction de l'informatique Maritimes Region, DFO  | Rgion des Maritimes, MPOE-Mail: [EMAIL PROTECTED]

TABLESPACE PCTINCREASE?

2002-02-05 Thread Seema Singh


Hi
WHAT will be good value for PCTINCREASE Parameter at tablespace level?
Zero,100 or 1

Thx
-Seema


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

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

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

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

2002-02-05 Thread Jacques Kilchoer

Title: RE: TABLESPACE PCTINCREASE?





 -Original Message-
 From: Seema Singh [mailto:[EMAIL PROTECTED]]
 
 WHAT will be good value for PCTINCREASE Parameter at tablespace level?
 Zero,100 or 1



I suppose that the current fashion is to set it at zero, and adopt a uniform extent size policy. What kind of objects will be contained in that tablespace? Tables? Indexes? Rollback segments? Temporary segments?

I would urge you first to read this old but classic paper:
HOW TO STOP DEFRAGMENTING AND START LIVING: THE DEFINITIVE WORD ON FRAGMENTATION
Bhaskar Himatsingka, Oracle Corporation
Juan Loaiza, Oracle Corporation
A PDF version of the document can be found here:
http://technet.oracle.com/deploy/availability/pdf/defrag.pdf

RE: TABLESPACE PCTINCREASE?

2002-02-05 Thread Suhen Pather


Seema,

PCTINCREASE should always be set to 0

$uhen

Hi
WHAT will be good value for PCTINCREASE Parameter at tablespace level?
Zero,100 or 1

Thx
-Seema


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

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

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

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

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

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

RE: TABLESPACE PCTINCREASE?

2002-02-05 Thread Jacques Kilchoer

Title: RE: TABLESPACE PCTINCREASE?





 -Original Message-
 From: Seema Singh [mailto:[EMAIL PROTECTED]]
 
 WHAT will be good value for PCTINCREASE Parameter at tablespace level?
 Zero,100 or 1



P.S. Forgot to mention - once you have read the White Paper 711 mentioned in my previous e-mail (Stop Defragmenting and Start Living), you should read this document from Steve Adams at his ixora website.

The document describes automatic coalescing of freespace by the SMON background process.
http://www.ixora.com.au/q+a/0102/21002406.htm

RE: Security for Table/Procedure

2002-02-05 Thread Jacques Kilchoer

Title: RE: Security for Table/Procedure





-Original Message-
From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]


I know that you can grant access on a table whether it be select, update, delete, etc, and I know that to keep from granting access to a table you can use procedures and grant execute rights to the procedure. 

Our situation is that we want to use procedures for security, but the procedures select data to populate a form and then update if applicable. We had talked about granting select to the tables by using a role since anyone can view the data, and then using procedures to update the tables. The only problem is that if we grant select to the tables and the application executes the procedure within it, the procedure will not be found and even the select will not happen.

Could some of you share how you handle security? Am I missing something with tables/procedures? Any ideas would be appreciated. We are just beginning development and need to have a handle on how we are going to do this.


-
As other posters have mentioned - the procedure not being found might be explained by the fact that the application must refer to the procedure by user_name.procedure_name unless the Oracle user running the application has access to a public/private synonym pointing to that procedure.

For security on tables/procedures - I have used the scheme mentioned by Michele ([EMAIL PROTECTED]) in the past - the application sets a password-enabled role upon startup, so the users can perform inserts/updates on tables via privileges granted by the role. However if the same user signed on in SQL*Plus, they would not be able to set the same role (because they wouldn't know the password) and so would be restricted to SELECT.

Another option might be to write a database trigger after logon to grant a role depending on which application is being run (check v$session.program to see which application is being run by the user)

I'm sure you know about the use of views to restrict access vertically (excluding certain columns) or horizontally (excluding certain rows.)

Finally, instead of using roles, you could also implement security policies. Simple example:
Users that are not SYSTEM cannot select mugs with an ID = 100
Users that are not SYSTEM cannot select, insert, update, delete any china pattern EXCEPT Kent Gardens



create table tbl_owner..my_mug_collection
 (mug_id number,
 mug_shape varchar2 (10),
 mug_capacity number
 )
 tablespace tbl_tbsp ;


create table tbl_owner..my_china_collection
 (plate_id number,
 pattern varchar2 (10),
 plate_diameter number
 )
 tablespace tbl_tbsp ;



create function func_owner..collectible_policy (owner varchar2, object_name varchar2)
return varchar2
is
 v_policy varchar2 (2000) ;
begin
 if owner = 'tbl_owner' and object_name = 'MY_MUG_COLLECTION'
 then
 if sys_context ('userenv', 'session_user') != 'SYSTEM'
 then
 v_policy := 'mug_id  100' ;
 end if ;
 end if ;
 if owner = 'tbl_owner' and object_name = 'MY_CHINA_COLLECTION'
 then
 if sys_context ('userenv', 'session_user') != 'SYSTEM'
 then
 v_policy := 'pattern = ''Kent Gardens''' ;
 end if ;
 end if ;
 return v_policy ;
end collectible_policy ;
/


exec dbms_rls.add_policy (object_schema = 'tbl_owner', -
 object_name = 'MY_MUG_COLLECTION', -
 policy_name = 'MUG_POLICY', -
 function_schema = 'func_owner', -
 policy_function = 'COLLECTIBLE_POLICY', -
 statement_types = 'SELECT')


exec dbms_rls.add_policy (object_schema = 'tbl_owner', -
 object_name = 'MY_CHINA_COLLECTION', -
 policy_name = 'CHINA_POLICY', -
 function_schema = 'func_owner', -
 policy_function = 'COLLECTIBLE_POLICY', -
 statement_types = 'SELECT, INSERT, UPDATE, DELETE', -
 update_check = true, -
 enable = false)

Creating a missing datafile

2002-02-05 Thread Ross Collado



Env.
HP-UX 10.2
Oracle 7.1.6
Archivelog mode


Found this in the alert.log

Dictionary check beginning
File #41 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING0041' in the controlfile.
Dictionary check complete

I did a dump of the controlfile to trace and checked.  It had MISSING0041 in
it.  However, I did a find on this file and couldn't find it.  Does this
mean MISSING0041 was just updated in the controlfile and was not actually
created as a physical file?
I know the complete path/filename of what this MISSING0041 datafile should
be (it should be /u2/db/archive2_2.dbf).  This is actually the 3rd datafile
of ARCHIVE tablespace.  If this file existed then it would have been an easy
rename of datafile via ALTER TABLESPACE ... RENAME DATAFILE  But there
is no physical file to rename.
I don't think I can do a create a file via ALTER DATABASE CREATE
DATAFILE... in this case because the controlfile won't have the correct
path/filename of this datafile (it's got 'MISSING0041' SIZE 500M).
How do I go about recreating a physical file having the correct filename and
size?

TIA,

Ross

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

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

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