drove me crazier!!!

[MOHAMMAD AMER]

hi pals,
I defied my customer that this won't work,and thanks to you it worked!!
Now,I have to convince him that what I had said to him was wrong!!

  thanks folks!
 dba Mohammad


Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MOHAMMAD AMER
  INET: [EMAIL PROTECTED]

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

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

[VIVEK_SHARMA]

When Attempting point in time recovery :-

1) Let Control File & Online Redo Logfiles be the Latest ( Current ) 
Ensure that you have WRITE Permission to the Online Redo logfiles so that In
case When the Database is Opened with RESETLOGS After Completion of Recovery
, the Online Redo Logfiles will be Written to.

2) Extract ONLY the Datafiles from the Backup , NOT the Online Redo Logfiles
from the Backup 

3) The Database should be in MOUNT Condition (NOT Open) When Issuing the
RECOVER DATABASE UNTIL TIME Command ?

4) After Completing the Roll forward by Applying the Archived ( Online Redo
logs , if required ) Issue Command 
ALTER DATABASE OPEN RESETLOGS 

MISCELLANEOUS - Check v$backup to see if STATUS = ACTIVE for the respective
Datafiles 


> -Original Message-
> From: Rocky Welch [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 09, 2001 11:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: !! Urgent  HELP (Table Deleted  In Production ) 
> 
> Hi Saroj,
> 
> If the table data isn't updated too often you can go back to an older
> export and import the table. If not, are you in archive log mode? Check
> your alert.log file for errors on the system datafile and let us know the
> status of your database to provide an accurate answer.
> 
> -Rocky
> 
> 
>   "Dash, Saroj (CAP,CEF)" <[EMAIL PROTECTED]> wrote: 
> 
> 
>   Dear Friends 
>   In product databace one of the developer had deleted a table and
> commited it
>   ,
>   database is in online backup but no export backup or table backup 
>   Please tell me how can the table be recovered 
>   please guide me the exact detaied steps torecover the table 
>   After getting the reply i will start it
>   
>   Thanks and Best regards
>   
>   I tried this command 
>   recover database until time '2001-02-09:22:00:00' ;
>   
>   it gived the following error 
>   recovery session canceled due to errors
>   ORA-01124: cannot recover data file 1 - file is in use or recovery
>   ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
>   SVRMGR> recover database
>   ORA-00283: recovery session canceled due to errors
>   ORA-01124: cannot recover data file 1 - file is in use or recovery
>   ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
>   SVRMGR> rec! ! over database until time '2001-02-09:22:00:00' ;
>   ORA-00283: recovery session canceled due to errors
>   ORA-01124: cannot recover data file 1 - file is in use or recovery
>   ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
>   SVRMGR> select * from v$backup ;
>   
>   then again i shut down the database then up it again i tried but
> same errors
>   
>   
>   Plese reply soon 
>   saroj dash 
>   
>   
>   
>   
>   -- 
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   -- 
>   Author: Dash, Saroj (CAP,CEF)
>   INET: [EMAIL PROTECTED]
>   
>   Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>   San Diego, California -- Public Internet access / Mailing Lists
>   
>   To REMOVE yourself from this mailing list, send an E-Mail message
>   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>   the message BODY, include a line containing: UNSUB ORACLE-L
>   (or t! ! he name of mailing list you want to be removed from). You
> may
>   also send the HELP command for other information (like subscribing).
> 
> 
> 
>   _  
> 
> Do You Yahoo!?
> - Get personalized email addresses from Yahoo! Mail Personal Address
>  - only $35 a year!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

recover datafile

[Bjorn Naessens]

hey dba ppl, 
 
anyone had a problem with recovering a datafile? 
Doesn't seem very hard if you have the archive log asked for... but what IF u 
haven't? 
 
running oracle 7.34 and 8.16 on ibm rs/6000 
aix
 
thx for any help
  

Oracle ASP Tools ?

[Sanjay Sinha]

Hi, 
Is anyone can guide me, for some product of Oracle as ASP(Application Service Provider) 
We are planing for some project of ASP and want to use only Oracle and its supporting tools. 

Right now we are prefered Oracle 8i, 9i and Oracle developer 6i. 
Is all are work fine ? or any other tools of oracle is also available for ASP project. 

Thanks in advance. 
SanjayGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sanjay Sinha
  INET: [EMAIL PROTECTED]

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

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

[Bunyamin K.Karadeniz]

REALLY  IT WORKED???
HOW , CAN YOU WRITE THE SCRIPT..

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 10:50 AM


hi pals,
I defied my customer that this won't work,and thanks to you it worked!!
Now,I have to convince him that what I had said to him was wrong!!

  thanks folks!
 dba Mohammad


Get free email and a permanent address at http://www.netaddress.com/?N=1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MOHAMMAD AMER
  INET: [EMAIL PROTECTED]

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

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

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

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

off topic : gathering information

[Bjorn Naessens]

hello fellow dba's 
 
we are currently running a project for updating our 
database management tools. We want a pro-active and easy-to-use graphical tool 
with a lot of possibilities ( db difference, performance manager, top sessions, 
lock managers, ... ). 
 
So i was wandering what all of you guys were using 
so I can have an idea about what's on the market.
 
thx in advance
 
bjorn naessens
junior system engineer + dba 
Roularta IT Solutions
 

RE: locking tables

[Mark Leith]

You can lock a table with:

lock table scott.emp in exclusive mode

This should lock that table for the session you are in, not sure what
permissions you need for it though?

Mark

-Original Message-
Sent: Monday, February 12, 2001 07:31
To: Multiple recipients of list ORACLE-L




hi list,

how can you prevent another session from selecting from the table until
your update has committed?

we have a procedure that is querying and updating the table as one
transaction. theoretically, we'd like to prevent any other session from
accessing that table.

is this possible? we cannot limit the oracle account to one session. many
sessions need to be open since this is an ecommerce database application.

we are running oracle 8.1.6 on solaris.

thanks!
kris




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

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

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

[O'Neill, Sean]

Larry,

MetaLink doc 1057885.6 will be of interest to you regarding this message.

HTH,
Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA

"They tell me nothing, but expect me to know everything!"


--

 From: Larry Taylor <[EMAIL PROTECTED]>
 Date: Mon, 12 Feb 2001 11:48:53 -0800
 Subject: Urgent! Alert file Displays this Message...

Has anyone seen is this message displayed in their alert log?

Mon Feb 12 11:31:39 2001
kccrsz: denied expansion of controlfile section 9 by 2026 record(s)
  the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
 RECID #462191 Recno 12154 Record timestamp 
 02/05/01 16:05:11
 Thread=1 Seq#=462191 Link-Recid=462190
  Low 
scn: 0x.04ae4dca
 02/05/01 16:05:09
 Next 
scn: 0x.04ae4df7

TIA
Larry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

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

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

RE: Consistent Gets?

[Steve Adams]

Hi Paul,

Thanks for sending the V$MYSTAT data offline.

Try this explanation ...
The first query is fetching all the rows using an array size of 15.
The V$MYSTAT data showed a difference of about 25000 'user calls',
and the 'SQL*Net roundtrips to/from client' data below matches that.
The number of additional 'consistent gets' is not much less than that.
This suggests that there is an extra consistent get for each fetch,
unless the previous fetch finished at a database block boundary.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Tuesday, 13 February 2001 8:41
To: Multiple recipients of list ORACLE-L


Hi Steve, thanks for your response.

I had analyzed the tables - chain_cnt = 0.  Just
to verify, I also checked "table fetch continued
row" which was 0 on all my tests.

Any other ideas?

Paul

--- Steve Adams <[EMAIL PROTECTED]> wrote:
> Hi Paul,
> 
> Analyze the table and see if you have any
> chained rows. If there are chained
> rows and if the STATE_CODE field is not always
> in the last row piece, then a
> extra consistent gets will be needed to get the
> column values from the trailing
> row pieces of chained rows that are not
> excluded by the where clause predicates.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
> 
> 
> -Original Message-
> Sent: Tuesday, 13 February 2001 3:31
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> Could someone attempt to explain the difference
> in the no. of "consistent gets" reported for
> these 2 queries?
> 
> I have a table (TEST1) made up of 11,333
> blocks.
> No indexes on this table.  I run two queries,
> both reported to do full table scans (as
> expected), one returning all the rows from the
> table and one with a bogus condition resulting
> in
> no rows returned.  I expected, that since both
> queries did full table scans, that the amount
> of
> IO would be the same.  Yet the query which
> returned data did 3 times as much IO as the one
> which did not.  Output follows :
> 
> 
> 12:08:16 T10-SERVCBO-CH> @p2
> 12:08:22 T10-SERVCBO-CH> set autotrace
> traceonly
> exp stat
> 12:08:22 T10-SERVCBO-CH> select
> 12:08:22   2  *
> 12:08:22   3  from
> 12:08:22   4  test1
> 12:08:22   5  where
> 12:08:22   6  pay_dealer_date >= '01/01/2000'
> 12:08:22   7  -- and state_code = 'AB'
> BOGUS CONDITION
> 12:08:22   8  ;
> 
> 375043 rows selected.
> 
> Elapsed: 00:00:55.46
> 
> Execution Plan
>
--
>0  SELECT STATEMENT Optimizer=CHOOSE
>10   TABLE ACCESS (FULL) OF 'TEST1'
> 
> Statistics
>
--
>   0  recursive calls
>  15  db block gets
>   35581  consistent gets
>   10575  physical reads
>   0  redo size
>66817080  bytes sent via SQL*Net to client
> 2775646  bytes received via SQL*Net from
> client
>   25004  SQL*Net roundtrips to/from client
>   0  sorts (memory)
>   0  sorts (disk)
>  375043  rows processed
> 
> 
> 12:09:18 T10-SERVCBO-CH> ed p2
> 
> 12:09:33 T10-SERVCBO-CH> @p2
> 12:09:35 T10-SERVCBO-CH> set autotrace
> traceonly
> exp stat
> 12:09:35 T10-SERVCBO-CH> select
> 12:09:35   2  *
> 12:09:35   3  from
> 12:09:35   4  test1
> 12:09:35   5  where
> 12:09:35   6  pay_dealer_date >= '01/01/2000'
> 12:09:35   7  and state_code = 'AB' 
> BOGUS
> CONDITION
> 12:09:35   8  ;
> 
> no rows selected
> 
> Elapsed: 00:00:03.43
> 
> Execution Plan
>
--
>0  SELECT STATEMENT Optimizer=CHOOSE
>10   TABLE ACCESS (FULL) OF 'TEST1'
> 
> 
> 
> Statistics
>
--
>   0  recursive calls
>  15  db block gets
>   11337  consistent gets
>   10573  physical reads
>   0  redo size
>1860  bytes sent via SQL*Net to client
> 313  bytes received via SQL*Net from
> client
>   1  SQL*Net roundtrips to/from client
>   0  sorts (memory)
>   0  sorts (disk)
>   0  rows processed
> 
> 12:09:38 T10-SERVCBO-CH> spool off
> 
> 
> What am I missing here?  Any help appreciated.
> 
> Thanx
> Paul
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Steve Adams
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

RE: off topic : gathering information

[Mark Leith]

www.bradmark.com
www.quest.com
www.ca.com
www.embarcadero.com
www.leccotech.com
www.bmc.com
www.compuware.com
 
A few 
to start with..
 
We 
deal with NORAD (previously DBGeneral) from Bradmark, and the general feel of 
the people we talk to is that is one of the better options for a full 
monitoring/management package, as it is so tightly integrated. There are a 
number of other vendours who do actually deal with specific areas of management 
"in-depth" (Quest for instance) where they have a whole bag full of of tools.. 
All of the tools out there are great though, its just a matter of personal 
preference.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn NaessensSent: 
  Tuesday, February 13, 2001 10:10To: Multiple recipients of list 
  ORACLE-LSubject: off topic : gathering 
  information
  hello fellow dba's 
   
  we are currently running a project for updating 
  our database management tools. We want a pro-active and easy-to-use graphical 
  tool with a lot of possibilities ( db difference, performance manager, top 
  sessions, lock managers, ... ). 
   
  So i was wandering what all of you guys were 
  using so I can have an idea about what's on the market.
   
  thx in advance
   
  bjorn naessens
  junior system engineer + dba 
  Roularta IT Solutions
   

Re: Resouce Allocation

[Saurabh Sharma]

but i did'nt find any bytes column in user_tables
analyzed table in compute mode..

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, February 09, 2001 9:05 PM


> analyze the table in compute mode.
>
> Then select bytes from user_tables where table_name = 'MY_TABLE';
>
>
> -Original Message-
> Sent: 09 February 2001 14:56
> To: Multiple recipients of list ORACLE-L
>
>
> Dear friends
> I have a little problem
>
> I have a table 
> here the description ...
>
> create table my_table
> ( id number primary key.
>namevarchar2(20),
>address varchar2(50),
>notesvarchar2(4000)
> );
>
> and then ... I inserted one record, and I wanna know ...
> How to count a resource allocation from one record ? byte ? kb ?
>
> I hope one of you can give me a solution to count resource allocation from
> one record.
>
> Thanks
>
> regards
> abimanyu
>
> "I'll be back!"
> Arnold Schwarzenegger
>
> --
> 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).
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Saurabh Sharma
  INET: [EMAIL PROTECTED]

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

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

************Urgent Help me !!!**************

[Dash, Saroj (CAP,CEF)]

Dear All,

In one of  database  the developer had deleted a table and
 commited it.
 database is in online backup but no export backup or table backup
 Please tell me how can I recover the the table .
 please guide me the exact detailed ed steps to recover the table .

 We have online backup .Archive log mode.

 We don`t have coldbackup.!!!

 I tried with shutdown the database.

 Strtup mount
 recover database until time '2001-02-09:22:00:00';
 media recovery completed.
 alter database open
 it says noresetlogs or resetlogs.

 I tried with norestelog then no data found i that table.

 after that I tried with resetlogs.

 still then no rows select from that table.

 send me the possible way to recover the table.please send me thesteps to
be done to recover the table.

 Regards,
 Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

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

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

[Abdul Aleem]

To my
understanding,

 

Oracle
tools support for JSP, but applications developed in ASP do run on OAS

 

HTH!

 

Aleem

 

-Original
Message-
From: Eriovaldo do Carmo Andrietta
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001
5:15 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Oracle ASP Tools ?

 

If you
will get some material, please send to me ...

I am
also interested to know about this.

 

Eriovaldo do
Carmo Andrietta
[EMAIL PROTECTED]
Widesoft Sistemas Ltda.
Limeira/SP - Brasil
F. +55 19 451 6300
ICQ #102604225



-
Original Message - 



From: Sanjay Sinha




To: Multiple
recipients of list ORACLE-L 

Sent: Tuesday, February 13,
2001 6:05 AM

Subject: Oracle
ASP Tools ?

 

Hi, 

Is anyone can
guide me, for some product of Oracle as ASP(Application Service Provider) 

We are
planing for some project of ASP and want to use only Oracle and its supporting
tools. 

Right now we
are prefered Oracle 8i, 9i and Oracle developer 6i. 

Is all are
work fine ? or any other tools of oracle is also available for ASP project. 

Thanks in
advance. 

Sanjay










Get Your
Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sanjay Sinha INET:
[EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051 San Diego, California -- Public Internet access / Mailing Lists
 To REMOVE
yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (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 ASP Tools ?

[Eriovaldo do Carmo Andrietta]

If you will get some material, please send to me 
...
I am also interested to know about 
this.
 
Eriovaldo do Carmo Andrietta[EMAIL PROTECTED]Widesoft Sistemas 
Ltda.Limeira/SP - BrasilF. +55 19 451 6300ICQ #102604225

  - Original Message - 
  From: 
  Sanjay 
  Sinha 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, February 13, 2001 6:05 
  AM
  Subject: Oracle ASP Tools ?
  
  Hi, 
  Is anyone can guide me, for some product of Oracle as 
  ASP(Application Service Provider) 
  We are planing for some project of ASP and want to use only Oracle 
  and its supporting tools. 
  
  Right now we are prefered Oracle 8i, 9i and Oracle developer 6i. 
  Is all are work fine ? or any other tools of oracle is also 
  available for ASP project. 
  
  Thanks in advance. 
  Sanjay
  
  Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
  Author: Sanjay Sinha INET: [EMAIL PROTECTED] Fat City Network Services -- 
  (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet 
  access / Mailing Lists 
   To REMOVE 
  yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from). You may also send the HELP command for other 
  information (like subscribing).

No recovery situation

[Beatriz Martinez Jimenez]

Hello list,
I know that the answer to my question it´s going to be a negative one,
but I have to try to do all that I can do.
Until yesterday I was doing some attempt with an Oracle installation,
without a backup copy. And, unfortunately, I had to format  my computer
(!!!).
Now I have the data associated with this installation,  I could save the
datafiles (*dbf). The database was in a non archivelog mode, and what is
the worst thing of all, it had some corrupt blocks in the system.dbf
file.
Could I do something with them, or are they totally unworhty?
Could anybody give me an advice?
Maybe it would be easier for me to start from the beginning again
A lot of thanks,

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

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

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

[VIVEK_SHARMA]

> Arun ,
> 
> Bingo , will Check for the Same using the Following SQL script :-
> 
> select  b.sid,
> substr(a.segment_name,1,25) OBJ_NAME,
> a.segment_type OBJ_TYPE,
> b.p1,
> b.p2 BLOCKID,
> b.p3 BLOCKS,
> b.event
> fromdba_extents a,
> v$session_wait b
> where   b.p2 between a.block_id AND (a.block_id+a.blocks)
> and a.file_id = b.p1
> and b.p1=12
> and b.p1text='file#'
> and b.event like 'db file scattered%';
>  
> 
> NOTE - 12 is the File Number of The Datafile of the respective Tablespace 
> 
> Any Points , Advice on the same ?
> 
> 
> -Original Message-
> From: ARUN K C [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 12:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: FULL Scanned Tables' Identification , within a
> Tablespace
> 
> why dont u check thro the scattered read which goes on thro the 
> session_event based on that track the table which is getting fully
> scanned.
> 
> 
> >From: VIVEK_SHARMA <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: FULL Scanned Tables' Identification , within a Tablespace
> >Date: Sun, 11 Feb 2001 09:10:26 -0800
> >
> >
> >The BLKS_READ Value is 15 Times the READS Value Indicating FULL Table
> Scans
> >
> >Qs. Is such a Product Exceedingly High ?  What may generally be termed as
> >acceptable
> >READS is to BLKSREAD ratios ?
> >
> >Qs.Any Advisable ways of locating WHICH Tables of the 50 are going for
> Full
> >Scans during
> >a Single Working Day ?
> >
> >NOTE - The Tablespace Contains 50 Tables .
> >
> >SVRMGR> Rem Sum IO operations over tablespaces.
> >SVRMGR> select
> >  2>   table_space||'
> '
> >  3>  table_space,
> >  4>   sum(phys_reads) reads,  sum(phys_blks_rd) blks_read,
> >  5>   sum(phys_rd_time) read_time,  sum(phys_writes) writes,
> >  6>   sum(phys_blks_wr) blks_wrt,  sum(phys_wrt_tim) write_time,
> >  7>   sum(megabytes_size) megabytes
> >  8>  from stats$files
> >  9>  group by table_space
> > 10>  order by table_space;
> >TABLE_SPACE  READSBLKS_READ  READ_TIME  WRITES BLKS_WRT
> >WRITE_TIME MEGABYTES
> >-- -- -- -- -- --
> >-- --
> >CONTROL 2403373647178  41802651651
> >1666105
> >
> >Any Other Misc. Observations ?
> >--
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

[Toepke, Kevin M]

Kris:

There is no native way of doing this. You would need to write your own
data-access methods -- maybe a stored procedure that returns a ref-cursor.
The procedure would attempt to lock a table before performing the select.
The DML operations on the table would have to lock the same table before the
operation can proceed. 

Hope this helps

Kevin

-Original Message-
Sent: Monday, February 12, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L




hi list, 

how can you prevent another session from selecting from the table until
your update has committed?

we have a procedure that is querying and updating the table as one
transaction. theoretically, we'd like to prevent any other session from
accessing that table.

is this possible? we cannot limit the oracle account to one session. many
sessions need to be open since this is an ecommerce database application.

we are running oracle 8.1.6 on solaris.

thanks!
kris




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

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

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

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

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

[nlzanen1]

Hi,


Try restoring an old backup first. Make sure that the newest datafile is
older than the point you want to return to.
Than do your PITR again.

MAKE OFFLINE BACKUP FIRST BEFORE ANY CHANGES.

ANother option is to restore on a different machine, export the table and
import the table on the production machine. (NO other data lost)


Jack


   

"Dash, Saroj   

(CAP,CEF)" To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
 Subject: Urgent Help me 
!!!**   
Sent by:   

[EMAIL PROTECTED]   

   

   

13-02-2001 12:45   

Please respond 

to ORACLE-L

   

   




Dear All,

In one of  database  the developer had deleted a table and
 commited it.
 database is in online backup but no export backup or table backup
 Please tell me how can I recover the the table .
 please guide me the exact detailed ed steps to recover the table .

 We have online backup .Archive log mode.

 We don`t have coldbackup.!!!

 I tried with shutdown the database.

 Strtup mount
 recover database until time '2001-02-09:22:00:00';
 media recovery completed.
 alter database open
 it says noresetlogs or resetlogs.

 I tried with norestelog then no data found i that table.

 after that I tried with resetlogs.

 still then no rows select from that table.

 send me the possible way to recover the table.please send me thesteps to
be done to recover the table.

 Regards,
 Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

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

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

Re: ************Urgent Help me !!!**************

[Praveen Gautam]

Did you restore the data files from the last hot backup?
Praveen

"Dash, Saroj (CAP,CEF)" wrote:
> 
> Dear All,
> 
> In one of  database  the developer had deleted a table and
>  commited it.
>  database is in online backup but no export backup or table backup
>  Please tell me how can I recover the the table .
>  please guide me the exact detailed ed steps to recover the table .
> 
>  We have online backup .Archive log mode.
> 
>  We don`t have coldbackup.!!!
> 
>  I tried with shutdown the database.
> 
>  Strtup mount
>  recover database until time '2001-02-09:22:00:00';
>  media recovery completed.
>  alter database open
>  it says noresetlogs or resetlogs.
> 
>  I tried with norestelog then no data found i that table.
> 
>  after that I tried with resetlogs.
> 
>  still then no rows select from that table.
> 
>  send me the possible way to recover the table.please send me thesteps to
> be done to recover the table.
> 
>  Regards,
>  Saroj.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj  (CAP,CEF)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
+===+
|  Praveen K. Gautam|
|  Tellabs, Inc.|
+===+
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen Gautam
  INET: [EMAIL PROTECTED]

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

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

Opinions on OLTP

[Sherrie . Kubis]

I am starting a Data Warehouse project, possibly using Oracle Warehouse
Builder.  One of the databases that I must bring together comes from IBM
DB2 database.  We have reverse engineered a piece of their database so that
we can produce an ER diagram so that we can start understanding their data.
A hindrance to us is that they do not use any constraints or referential
integrity, but place all of their checks into their COBOL code.  They tell
me this is because they are an online transaction processing system, and
that's how things are handled in that environment.  I always thought that
OLTP systems were airlines and such, but they, at best, have 20 data entry
people.  Is any database within DB2 under CICS considered OLTP, perhaps?
What thresholds would you use to determine what is an OLTP system?  Has
anyone ever heard about putting all of the RI into code as opposed to
allowing the database to do its job?  It seems silly to me to put all of
your checks into code because changes and maintenance would just kill you,
not to mention consistency, or lack thereof.

Any insights into this would be appreciated.


Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville, FL   34604
352.796.7211 Ext 4033
Fax:   352-754-6776
[EMAIL PROTECTED]


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

Default Export buffer size NT

[O'Neill, Sean]

Hi Folks,

I'm trying to find out the default "buffer" parameter size Export utility on
NT O.S., 8i Rel 3.  The utility manual says see your Oracle operating
system-specific documentation which I have done, or at least I believe I
have covered all manuals, but to no avail.  Anyhow, anyone know the value
and better still what manual it's documented in!

Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA

"They tell me nothing, but expect me to know everything!"



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

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

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

Re: export dump name for tape

[Mohammad Rafiq]

As I have not received any response to my following message, I am posting it 
again for UNIX GURUS..
My question ius whether is it possible to give name to export dump while
sending it directly to tape? If yes how

Thanks
Rafiq


Date: Mon, 12 Feb 2001 11:25:26 -0800

Hi,

Can somebody guide me to give name to export dump while sending export dump
directly to tape. Right now I am using following :


exp user/password file=/dev/rmt/2m volsize=16384M compress=n direct=y
log=/u308/oracle/home/dba/fullexp/log/exp_ar_FINPROD${expdate}.log

But now I want to export table by table giving individual file name to
dump on tape in one script.

Regards
Rafiq


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

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

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

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

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

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

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

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

db_block_checkpoint_batch

[elain he]

Hi,
Has anyone seen database performance degradation by setting this to a high 
value?

We set this value to 128 from the default value 4 and noticed a lot more 
free buffer waits event.

All database writers (DB01-10) are waiting for Null Event. The 
seconds_in_wait time from v$session_wait is 129614(~1.5days), ie the same 
time since the database started. The parent DBWR process is waiting on rdbms 
ipc message and the seconds_in_wait time is 0.

Here's the configuration:
DB 7.3.4
db_writer=10
async_io disable
Solaris 2.6/Sun T3 Array
_db_block_write_batch=512
db_block_checkpoint_batch=128 (512/4)

Appreciate any help you can provide.
Thanks.

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

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

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

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

[Riyaj_Shamsudeen]

Hi Johan
 Will this work ?

 Person A books the product he wants with 'select * from t1 for
update'. At this point, he has lock on the row.
 Person B comes in, looks at the product and does a 'select * from t1
for update nowait'
   If the row is locked for update then person B will get ORA-0054. If
Person B gets an ORA-0054 then, you know that the person A has booked the
product but not bought yet.

The locks hold by the person A will be cleaned by the pmon if the process
dies away.

 But the above will only work if each of the web user gets its own database
connections. I don't know about your environment, but in most environment,
the connection to the database is shared among the web sessions. If that is
the case, then you may have to use the flags to track the state changes.

 If you want to show only rows that are locked then you could use this
undocumented feature:
 'select * from t1 skip locked'. This will skip all the rows that have
been locked.


Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"These are my opinions and does not bind my employer. Use at your risk"



   
   
"Johan 
   
Locke@i-CommeTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
rce Services"cc:   
   

rce Services"cc:


Sent by: cc:

root@fatcity.Subject: Deadlock
Interpretation Assistance Requested
com





02/10/01

07:00 PM

Please

respond to

ORACLE-L









Listers,

HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet:

SELECT *   FROM UNIT_STATISTICS  WHERE UNIT_ID = :b1  AND MONTH = :b2  AND
YEAR = :b3  AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY

Deadlock graph:
   -Blocker(s)  -Waiter(s)
--
---
Resource Name  process session holds waits  process session holds
waits
TX-00180008-42d6   837 635 X784 481
S
TX-00160010-4412   784 481 X837 635
X
Rows waited on:
Session 481: no row
Session 635: obj - rowid = 0722 - 0289.0033.0102

I've never really encountered all that many deadlocks before. The ones I
*have* seen in the past were the "classic" TX locks where user A has a row
locked that user B needs and vice versa and the mode requested was X. On
Friday, the DBA's sent me a trace file from a deadlock (with the info above
from that trace file) and asked me to investigate. The deadlocks they had
seen in the past were due to application coding issues, hence their tossing
this to the development side of the house.

After a lot of research on Metalink, the Steve Adams site
(http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the
S
mode wait for session 481 (and no row) makes me think this isn't the
typical
application induced deadlock due to the way and order in which locks are
acquired.

There are 3 foreign keys on the table, and, each of them are indexed. There
is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know
all that much about how heavily DML is issued against the table. But, after
reading material on when the wait is in S mode, I wonder if this might be
an
ITL issue. From what I've read the past 2 days, there could be other
reasons
for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL
slots, and bitmap index were the most common reasons mentioned. Because the
statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?)
the
check for uniqueness wait during inserts, and, with no bitmap index on the
table, that leaves the ITL slots as the main candidate.

What I need to do is determine if this is indeed an application coding
issue, or, if I need to kick this back to the DBA's and let them research
it. And I don't mean that in a finger pointing way. The DBA's and
developers
there work well together. From what I've read and learned so far, this
deadlock doesn't seem to be an application coding issue. I am thinking
about
saying that and asking them (if they haven't already) to open a TAR and
provide the trace file to Oracle Support.

If anyone has any comments or suggestions, I would appreciate hearing them
(because if this could still be due to an application coding issue, more
research needs to be done on the development and/or my side of the house).

Regards,

Larry G. Elkins
[EMAIL PROTECTED]

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

Fat City Network Services

RE: ************Urgent Help me !!!**************

[Martin Kendall]

You will have to use your last Hot Backup file set and 
create a new database (use the alter database backup controlfile to trace
for the create db statement).  Then apply all the arch. redo files since
THAT backup, UPTO the point before
the Table was dropped.  Then extract the Table data and insert it into your
existing database.

-Original Message-
Sent: 13 February 2001 11:46
To: Multiple recipients of list ORACLE-L


Dear All,

In one of  database  the developer had deleted a table and
 commited it.
 database is in online backup but no export backup or table backup
 Please tell me how can I recover the the table .
 please guide me the exact detailed ed steps to recover the table .

 We have online backup .Archive log mode.

 We don`t have coldbackup.!!!

 I tried with shutdown the database.

 Strtup mount
 recover database until time '2001-02-09:22:00:00';
 media recovery completed.
 alter database open
 it says noresetlogs or resetlogs.

 I tried with norestelog then no data found i that table.

 after that I tried with resetlogs.

 still then no rows select from that table.

 send me the possible way to recover the table.please send me thesteps to
be done to recover the table.

 Regards,
 Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

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

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

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

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

[Smith, Ron L.]

Any system with online 'live' updates as opposed to saving up all the
updates and running them through a batch process
would be considered an OLTP application.

Ron Smith
Database Administration
[EMAIL PROTECTED]


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L


I am starting a Data Warehouse project, possibly using Oracle Warehouse
Builder.  One of the databases that I must bring together comes from IBM
DB2 database.  We have reverse engineered a piece of their database so that
we can produce an ER diagram so that we can start understanding their data.
A hindrance to us is that they do not use any constraints or referential
integrity, but place all of their checks into their COBOL code.  They tell
me this is because they are an online transaction processing system, and
that's how things are handled in that environment.  I always thought that
OLTP systems were airlines and such, but they, at best, have 20 data entry
people.  Is any database within DB2 under CICS considered OLTP, perhaps?
What thresholds would you use to determine what is an OLTP system?  Has
anyone ever heard about putting all of the RI into code as opposed to
allowing the database to do its job?  It seems silly to me to put all of
your checks into code because changes and maintenance would just kill you,
not to mention consistency, or lack thereof.

Any insights into this would be appreciated.


Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville, FL   34604
352.796.7211 Ext 4033
Fax:   352-754-6776
[EMAIL PROTECTED]


-- 
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: Opinions on OLTP

[Brian Wisniewski]

I'm working on a project which is converting from DB2 to Oracle and
possibly UDB.  All of the current constraints are in the Cobol code and
none are database enforced.  A version of the data model is stored in
Cool:Gen and we need to update this and use it to move all of the
constraints from the code into the database.  

We need to have someone who is familiar with Cool:Gen and the Cobol
code go through and get the model updated before we move it to ErWin.
Very tedious task which I am glad not to be tasked to do.

I agree the constraints should be enforced in the database for
consistency sake.

Good luck.

- Brian

--- [EMAIL PROTECTED] wrote:
> I am starting a Data Warehouse project, possibly using Oracle
> Warehouse
> Builder.  One of the databases that I must bring together comes from
> IBM
> DB2 database.  We have reverse engineered a piece of their database
> so that
> we can produce an ER diagram so that we can start understanding their
> data.
> A hindrance to us is that they do not use any constraints or
> referential
> integrity, but place all of their checks into their COBOL code.  They
> tell
> me this is because they are an online transaction processing system,
> and
> that's how things are handled in that environment.  I always thought
> that
> OLTP systems were airlines and such, but they, at best, have 20 data
> entry
> people.  Is any database within DB2 under CICS considered OLTP,
> perhaps?
> What thresholds would you use to determine what is an OLTP system? 
> Has
> anyone ever heard about putting all of the RI into code as opposed to
> allowing the database to do its job?  It seems silly to me to put all
> of
> your checks into code because changes and maintenance would just kill
> you,
> not to mention consistency, or lack thereof.
> 
> Any insights into this would be appreciated.
> 
> 
> Sherrie Kubis
> Southwest Florida Water Management District
> 2379 Broad Street
> Brooksville, FL   34604
> 352.796.7211 Ext 4033
> Fax:   352-754-6776
> [EMAIL PROTECTED]
> 
> 
> -- 
> 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!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: [EMAIL PROTECTED]

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

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

[Juan Marra]

Title: Oracle 816 on linux



Recompiler Kernel with new values in  
semaphores. (values is in technical notes)
The Red Hat 7.00 not recompiler Kernel. Have a 
bug. 
 Recomended RedHat 6.2 Kernel 2.2.14 or 
2.2.16, this Kernel recompiler an works fine with Oracle 8.1.6 or 
8.1.7
 

  - Original Message - 
  From: 
  Chakaphan Supacharuwong 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, February 08, 2001 10:55 
  PM
  Subject: Oracle 816 on linux
  
  Hi..   I 
  just install Oracle 816 on Redhat 7.0. Installation process went well without 
  creating DB. When I tried to create DB, I got error 3113: end-of-file on 
  communication channel after run "startup nomount pfile = 
  "/u01/app/oracle/admin/hrweb/pfile/inithrweb.ora"    ". I also 
  lookup in metalink. It told me to remove "remote_login_passwordfile = 
  exclusive" out of init.ora file. I did but it still does not work. Anybody 
  have this kind of error. Please help.
  Chakaphan Supacharuwong 

RE: Enqueue types

[jfedock]

As was pointed out to me a few weeks ago, this info is in Oracle8 Reference
Release 8.0 A58242-01
 
TX, Transaction 
 
Not sure about the others.  They are not in my manual (8.0.x)
 
 
John
 
 

-Original Message-
Sent: Thursday, February 08, 2001 11:36 PM
To: Multiple recipients of list ORACLE-L



Does anyone recognize enqueues JI, TC, and TX?  (Steve, are you on?) 

SELECT * 
FROM x$ksqst 
   WHERE ksqstget > 0; 


EVENTTOTAL_WAITS
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT 
 ---
-- ---  
enqueue   144378
7871825112607   173.936521 


ADDR   INDXINST_ID KS   KSQSTGET   KSQSTWAT 
 -- -- -- -- -- 
000399F11808 69  1 CF 179654 39 
000399F11820 72  1 CI  65152  0 
000399F11880 84  1 CU1043538 55 
000399F11938107  1 DL444  0 
000399F11968113  1 DR   5569  0 
000399F11988117  1 DV  46432  0 
000399F11998119  1 DX  95350  0 
000399F11B70178  1 FS  1  0 
000399F11D90246  1 HW  98917  0 
000399F11E70274  1 IS   9441  0 
000399F11F20296  1 JI  14455   5511   <--- 
000399F12268401  1 MR 20  0 
000399F12500484  1 PE 868094  0 
000399F12508485  1 PF134  0 
000399F12568497  1 PR 93  0 
000399F12570498  1 PS340  0 
000399F12778563  1 RT  1  0 
000399F12860592  1 SQ 504008 96 
000399F12870594  1 SS  6  0 
000399F12878595  1 ST  21481  1 
000399F128F0610  1 TC  23860   1243   <- 
000399F12940620  1 TM   17757089  0 
000399F12970626  1 TS   3829  0 
000399F12978627  1 TT1352011  0 
000399F12998631  1 TX   16390088648   < 
000399F12A70658  1 US 870014  0 
000399F12C38715  1 WL  47348  2 

27 rows selected. 


Any information or referral to a manual is appreciated.  I don't have
Steve's book with me, unfortunately.  

Thanks, 

Linda 

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

Public Synonym SYSTEM causing Problem with Export

[Nisha Patel]

Hi All,
 I have a really wierd problem with a client who has tried to export the
whole database. They get errors because there is
a public synonym called System created by a user FCAADMIN. This public
synonym caused several oracle supplied objects to go invalid resulting
in the failed Oracle exports.   I know we should not have a table called
System but I had inherited the database and it is too late in the game
to rename it. Does anyone have any solution to this problem?


Thanks in advance,
Nisha

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

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

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

[Bjorn Naessens]

We are currently comparing : 
 
Oracle : Enterprise Manager ( very expensive 
)
Ca : Manage-It
BMC : Patrol 
Tivoli : Database management ( how original 
) 
Softtree : Dbtools 
 
and now i added
 
bradmark : Norad 2.0
Embarcadero : Dbartisan ( it's decent but rather 
limited )
 
to the study. 
 
thanks for the links Mark leith. 
 
Bjorn Naessens
Junior system engineer + dba
Roularta IT Solutions
 

  - Original Message - 
  From: 
  Mark 
  Leith 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, February 13, 2001 12:26 
  PM
  Subject: RE: off topic : gathering 
  information
  
  www.bradmark.com
  www.quest.com
  www.ca.com
  www.embarcadero.com
  www.leccotech.com
  www.bmc.com
  www.compuware.com
   
  A 
  few to start with..
   
  We 
  deal with NORAD (previously DBGeneral) from Bradmark, and the general feel of 
  the people we talk to is that is one of the better options for a full 
  monitoring/management package, as it is so tightly integrated. There are a 
  number of other vendours who do actually deal with specific areas of 
  management "in-depth" (Quest for instance) where they have a whole bag full of 
  of tools.. All of the tools out there are great though, its just a matter of 
  personal preference.
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn NaessensSent: 
Tuesday, February 13, 2001 10:10To: Multiple recipients of list 
ORACLE-LSubject: off topic : gathering 
information
hello fellow dba's 
 
we are currently running a project for updating 
our database management tools. We want a pro-active and easy-to-use 
graphical tool with a lot of possibilities ( db difference, performance 
manager, top sessions, lock managers, ... ). 
 
So i was wandering what all of you guys were 
using so I can have an idea about what's on the market.
 
thx in advance
 
bjorn naessens
junior system engineer + dba 
Roularta IT Solutions
 

Re: No recovery situation

[Riyaj_Shamsudeen]

Hi
How did you find you have corrupt blocks ? Did you have any ORA-1578
errors ? Any alert log messages  for the same ?
I would first find out which objects exist in that particular corrupted
block (or ) alternatively you could analyze all the objects in the system
tablespace like this.
set pages 0
spool /tmp/exec_as.sql
select 'analyze table '||owner||'.'||table_name||' validate structure
cascade;'
from dba_tables
where tablespace_name='SYSTEM'
/
spool off
spool /tmp/exec_as1.out
@/tmp/exec_as.sql
spool off
spool /tmp/exec_as.sql
select 'analyze cluster '||owner||'.'||cluster_name||' validate structure
cascad
e;'
from dba_clusters
where tablespace_name='SYSTEM'
/
spool off
spool /tmp/exec_as2.out
@/tmp/exec_as.sql
spool off

If the corrupted object is an index, depending upon what index is
corrupted, you could potentially drop and recreate the index..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com


   
   
Beatriz
   
Martinez To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
Jimenez  cc:   
   
  
   
Sent by:   
   
root@fatcity.  
   
com
   
   
   
   
   
02/13/01   
   
06:30 AM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




Hello list,
I know that the answer to my question it´s going to be a negative one,
but I have to try to do all that I can do.
Until yesterday I was doing some attempt with an Oracle installation,
without a backup copy. And, unfortunately, I had to format  my computer
(!!!).
Now I have the data associated with this installation,  I could save the
datafiles (*dbf). The database was in a non archivelog mode, and what is
the worst thing of all, it had some corrupt blocks in the system.dbf
file.
Could I do something with them, or are they totally unworhty?
Could anybody give me an advice?
Maybe it would be easier for me to start from the beginning again
A lot of thanks,

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

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

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

[MOHAMMAD AMER]

hi dba ,
I went through the same problem here,where I reverse engineered a system
with no relations or integrity constraints and it was hell,since I guessed the
business rules and asked people from anywhere about the business of this
system,I don't want to remember this period of my life.
I 'm not depressing you,but it is really a very big effort.
I remember the ERD when when printed it,it was like the islands,no single
relation ship ever!!!
  good luck
 tortured dba


Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MOHAMMAD AMER
  INET: [EMAIL PROTECTED]

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

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

[Ron Rogers]

Rafiq,
It has been a while since I dumped to tape but I'll try and lead you in the right 
direction.
1. To dump different table one after the other you can list the table in a parfile and 
call the parfile from your script or
2. you cal execute your exp script each time for a different table specified in the 
command line and have the tape device indicated as "no rewind" untill the last table 
is exported. I think that the area that has to be modified is the "file=/dev/rmt/2m" 
entry. It should look like "file=/dev/rmt/2mn" for no rewind.

List correct me if I do not remember correctly..

ROR mª¿ªm

>>> [EMAIL PROTECTED] 02/13/01 10:15AM >>>
As I have not received any response to my following message, I am posting it 
again for UNIX GURUS..
My question ius whether is it possible to give name to export dump while
sending it directly to tape? If yes how

Thanks
Rafiq


Date: Mon, 12 Feb 2001 11:25:26 -0800

Hi,

Can somebody guide me to give name to export dump while sending export dump
directly to tape. Right now I am using following :


exp user/password file=/dev/rmt/2m volsize=16384M compress=n direct=y
log=/u308/oracle/home/dba/fullexp/log/exp_ar_FINPROD${expdate}.log

But now I want to export table by table giving individual file name to
dump on tape in one script.

Regards
Rafiq


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

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

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

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

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

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

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

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

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

HELP - Insert/Update trigger

[Fred Smith]

Listers,

   I am attempting to write a trigger on a table that will have batch 
inserts nightly.  I want each insert to check to see if a record with that 
primary key exists, and if it does, update the record.  If the primary key 
does not yet exist in the table, insert the record.  The batch load each 
night is a large series of inserts, no updates.  I want the trigger to 
figure out it if needs to update or insert.

Can this be done??

Thank you,
  -Fred Smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

RE: Off Topic: Row Locking - Row Id

[jkstill]

Depending on your application design, you may find a locking
scheme useful.  Below is an example that uses rowid to take
out a lock.  Note that this is not a lock on an object, but
simply a lock identified by a rowid.

As the demo is setup, the locks are automatically released
on rollback or commit, which would include exiting a session.

Not for use on OPS w/MTS.

See dbmslock.sql for details.

Jared

--

-- run this part from session A:

drop table lock_test;

create table lock_test ( name varchar2(10) not null );

insert into lock_test values ( 'nebula');
insert into lock_test values ( 'quasar');
insert into lock_test values ( 'pulsar');
insert into lock_test values ( 'red dwarf');
insert into lock_test values ( 'Lister');
insert into lock_test values ( 'Rimmer');
insert into lock_test values ( 'Cat');

commit;

-- Then run this section from session A and session B

declare


cursor c_hoser ( hoser_name_in lock_test.name%type )
is
select rowid
from lock_test
where name = hoser_name_in;

lock_handle pls_integer;

v_hoser_rowid rowid;

v_lock_handle pls_integer;

v_lock_result pls_integer;

v_name_to_book lock_test.name%type;

begin

v_name_to_book := 'Lister';
open c_hoser(v_name_to_book);
fetch c_hoser into v_hoser_rowid;
close c_hoser;

v_lock_handle := 
dbms_utility.get_hash_value(v_hoser_rowid,100,power(2,20));

v_lock_result := dbms_lock.request(
id => v_lock_handle
, timeout => 1
, release_on_commit => true
);

if v_lock_result = 0 then
dbms_output.put_line( 'You have booked ' || v_name_to_book );
elsif v_lock_result = 1 then
dbms_output.put_line( v_name_to_book || ' is currently booked');
else
dbms_output.put_line( 'Error attempting to lock ' || v_name_to_book || 
' return val: ' || to_char(v_lock_result));
end if;

end;
/


--

On Mon, 12 Feb 2001, Johan Locke@i-Commerce Services wrote:

> Thanks Riyaj
>
> Unfortunately it doesn't solve my problem. It only helps if the transaction
> is BLOCKING another transaction.
>
> This is my requirement, maybe somebody has a good solution.
>
> A product selection engine. There are a limited number of products, each
> unique.
>
> Person A comes in over the web (this important). Looks at the products and
> "books" the product he wants. At this stage I just want to issue a "SELECT
> FOR UPDATE" - without commiting. Person A goes through the payment
> selection, and if succesfull, the product is marked as "bought" and the
> transaction commited.
>
> If during the process of payment authorisation for Person A, person B looks
> through the products, Person B must see the product person A is buying as
> "Booked - not yet bought".
>
> Why don't I just set a flag in the row, commit it, do the payment and commit
> that?
> 
> --
> If for some reason person A's web session terminates voluntarily or
> involuntarily, I'd have to run a process in the background which cleans up
> the flags. As this is a very processing intensive table, it slows down the
> processing tremendously. Conversly, if I could use the user's web session
> termination, which will terminate the database session, to make oracle
> release the lock on that row it makes my life a lot easier.
>
> About 90% of the people will access the site within a period of about an 1-2
> hours (within which you're aiming to sell 54000 of the 6 products)
>

-- 
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: HELP - Insert/Update trigger

[Norrell, Brian]

Not with a normal table trigger.  Try creating a non-updateable view with an
"instead of" trigger for the insert.

Brian Norrell
Senior Software Engineer
QuadraMed
972-831-6600


-Original Message-
Sent: Tuesday, February 13, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Listers,

   I am attempting to write a trigger on a table that will have batch 
inserts nightly.  I want each insert to check to see if a record with that 
primary key exists, and if it does, update the record.  If the primary key 
does not yet exist in the table, insert the record.  The batch load each 
night is a large series of inserts, no updates.  I want the trigger to 
figure out it if needs to update or insert.

Can this be done??

Thank you,
  -Fred Smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

Re: db_block_checkpoint_batch

[Riyaj_Shamsudeen]

Hi elain
 I have not personally encountered performance degradation setting this
to high value. But I will attempt to help you.
 DBWR process is waiting for the IPC messages from the background
process or from the server processes, for the requests to write the dirty
buffers. That's how the processes communicate among themselves and wiating
for an IPC message is normal. Also DBWR is the process which scans the
buffer cache to create a list of buffers to write and then it distributes
that list to the slave process to write. So slave process has to wait for
the null event during no work. So, this is fine too.
 db_block_checkpoint_batch determines what portion of db writes can be
used for the slow checkpoints (in 7.3). By setting this to high value, the
checkpoint will complete faster, but the speed at which DBWR cleans the
buffer cache may be slightly slower. So more free buffer waits. You may
have to play around these parameters little bit to determine the optimum
value for your environment. I would set checkpoint batch size to be around
1/8 th or 1/10th of Internal batch write size and go upwards. Also make
sure that your log buffer is small enough and the DBW doesn't wait too much
for the  log file sync event. Converting the file system based database to
raw database and turning on async IO are other options.
 In fact, Steve Adams has written a paper about this DBWR tuning.
Search for db_block_checkpoint in his website www.ixora.com.au. You will
find his paper.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"This is my opinion and does not legally bind me or my employer. Use at
your own risk"


   
   
"elain he" 
   
  
ail.com> cc:   
   
Sent by: Subject: db_block_checkpoint_batch
   
root@fatcity.  
   
com
   
   
   
   
   
02/13/01   
   
08:26 AM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




Hi,
Has anyone seen database performance degradation by setting this to a high
value?

We set this value to 128 from the default value 4 and noticed a lot more
free buffer waits event.

All database writers (DB01-10) are waiting for Null Event. The
seconds_in_wait time from v$session_wait is 129614(~1.5days), ie the same
time since the database started. The parent DBWR process is waiting on
rdbms
ipc message and the seconds_in_wait time is 0.

Here's the configuration:
DB 7.3.4
db_writer=10
async_io disable
Solaris 2.6/Sun T3 Array
_db_block_write_batch=512
db_block_checkpoint_batch=128 (512/4)

Appreciate any help you can provide.
Thanks.

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

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

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

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

Doubt about charecter

[Eriovaldo do Carmo Andrietta]

Title: Oracle 816 on linux



I have a problem where in a statment of sql the DB Oracle doesn´t get 
the line in the follow situation :
 
    select name  
 from table1
  where field = 'AAA  #989';
 
I think that between A and # exist some strange character that i can´t 
identify it ..
 
How can I do it ?
 
Regards
 
Eriovaldo
    

Re: export dump name for tape

[Mohammad Rafiq]

Ron,
Thanks for guidance. I am also working with my UNIX admin to work out some 
solutions for distinct file name for each table export.
Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 13 Feb 2001 08:20:43 -0800

Rafiq,
It has been a while since I dumped to tape but I'll try and lead you in the 
right direction.
1. To dump different table one after the other you can list the table in a 
parfile and call the parfile from your script or
2. you cal execute your exp script each time for a different table specified 
in the command line and have the tape device indicated as "no rewind" untill 
the last table is exported. I think that the area that has to be modified is 
the "file=/dev/rmt/2m" entry. It should look like "file=/dev/rmt/2mn" for no 
rewind.

List correct me if I do not remember correctly..

ROR mª¿ªm

 >>> [EMAIL PROTECTED] 02/13/01 10:15AM >>>
As I have not received any response to my following message, I am posting it
again for UNIX GURUS..
My question ius whether is it possible to give name to export dump while
sending it directly to tape? If yes how

Thanks
Rafiq


Date: Mon, 12 Feb 2001 11:25:26 -0800

Hi,

Can somebody guide me to give name to export dump while sending export dump
directly to tape. Right now I am using following :


exp user/password file=/dev/rmt/2m volsize=16384M compress=n direct=y
log=/u308/oracle/home/dba/fullexp/log/exp_ar_FINPROD${expdate}.log

But now I want to export table by table giving individual file name to
dump on tape in one script.

Regards
Rafiq


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

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

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

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

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

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

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

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

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

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

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

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

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

Re: Doubt about charecter

[Scott Canaan]

Use 'AAA_#989',  the _ means any 1 character substitution.
Eriovaldo do Carmo Andrietta wrote:

I have a problem where in a statment
of sql the DB Oracle doesn´t get the line in the follow situation
: select name from table1 
where field = 'AAA  #989'; I think that between A and # exist
some strange character that i can´t identify it .. How can I
do it ? Regards Eriovaldo 

--
Scott Canaan ([EMAIL PROTECTED])
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
 



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

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

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

[Sukumar Kurup]

Hi,

We are observing some inconsistent behaviour in one of
our application (Solaris 2.6, Oracle 8.1.7). The
frontend is in VC++, and when we run a query through
our application GUI, the first few time it works and
then (mostly after the first time) , the process core
dumps with the following in the alert.log :
 
Errors in file
/oracle/admin/SMS44YA/udump/sms44ya_ora_29713.trc:
ORA-07445: exception encountered: core dump
[opipls()+10440] [SIGSEGV] [Address not mapped to
object] [132] [] [] ORA-00600: internal error code,
arguments: [12261], [], [], [], [], [], [], []
~
The corresponding trace file has the following
(warning / error ?) messages in the cursor details
area:

No Bind buffers allocated. 

This is there for all the (20) cursors. Is this the
cause of the problem ? 

However, after I flush the shared pool, it works
again.

Please suggest what should I look for ?


Thanks

Sukumar Kurup







__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sukumar Kurup
  INET: [EMAIL PROTECTED]

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

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

Unix Memory Question

[Schoen Volker]

Hi list,

I have a question about Unix and Oracle memory allocation. I have to say
that Unix isn't my platform, so I think for most of you this will be easy
answerd.

I have a HP Unix machine with follwing memory infos:

Memory Information:
physical page size = 4096 bytes, logical page size = 4096 bytes
Physical: 524288 Kbytes, lockable: 380640 Kbytes, available: 441536
Kbytes

There is a Oracle running on this box. Hit statistics show me that I have to
increase the db_block_buffers. What I like to know is, how much more memory
can I give oracle? There are about 50 User working with this instance.

TIA

Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de


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

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

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

Mailing from Oracle Procedure....

[Shankar Shanmugaswamy]

Hi Everybody,

I wanted to forward a mail to a particular Id thru an Oracle Procedure , 
can anybody tell me whether I can do that thru an Oralce Procedure 
if so pls inform how to do the same.

I dont want to mail to a Unix Login id , I want to mail to a mail server 

For e-g  [EMAIL PROTECTED] 


Thanks In Advance,

Shankar Swamy.



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

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

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

OCI

[Ravindra Basavaraja]

We are implementing OPS for our production database.We are aware that only
the select statements(query) gets failover in case of a node failure.
But I have been told, to achieve 100%TAF from our application side i.e the
user w/o reissuing a transaction(update and etc) we need to implement
OCI in the appllication so that the failover is transparent to the user.Is
this right?

I want to know if  implementing OCI means just loading the OCI
drivers?(don't  think so) but I think there should be something more than
just
loading the drivers that should be done on the application.Our application
is a java application and makes JDBC connection to the database.

Pls comment

Thanks

Ravindra

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

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

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

[Ferris, Shawn]

To get a better error messages make sure your ORACLE_HOME environment
variable is set. It appears in your case that 'export
ORACLE_HOME=/u01/app/OracleHome' would be appropriate.

Error number #6 (from /usr/include/asm/errno.h) is "No such device or
address".  Make sure your kernel is compiled with 'SysV IPC'. You may also
want to bump up the IPC related parameters depending on your database/size.
Check the "oracle installation guide for linux" documentation
http://technet.oracle.com/software/products/oracle8i/software_index.htm for
details.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom 

> -Original Message-
> From: Nosie [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 8:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle 816 on linux
> 
> 
> Dear All, including Shawn Ferris, Charles Wolfe and Chakaphan,
> 
> Based on Shawn's information, I "downgrade" my OS to Red Hat 
> 6.2. Oracle
> installation and database creation has succeed. But when I 
> invoke sqlplus
> /nolog, the error message arise. Would you all help me please
> 
> [oracle@Lynx oracle]$ /u01/app/OracleHome/bin/sqlplus /nolog
> Message file sp1.msb not found
> Error 6 initializing SQL*Plus
> 
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, February 09, 2001 10:42 PM
> 
> 
> > This is due to redhat-7. The glibc that ships with rh7 is 
> incompatible
> with
> > oracle. (All versions - Although I haven't tried the 
> 8.1.7.0.1 w/ OPS
> yet.)
> >
> > You have to install a backwards compatible rpms and edit a 
> few oracle
> > makefiles to get oracle to work on rh7. Running in this 
> environment is
> > definitely not recommended for production use. (In my 
> opinion anyway)
> There
> > is a note on metalink about getting this install to work. I 
> don't have the
> > doc id anymore.
> >
> > For linux beginners: I would recommend rh6.2 for use with oracle.
> >
> > It does work and I haven't had any problems. I also don't 
> do a high volume
> > amount of work on this db.
> >
> > HTH
> > Shawn M Ferris
> > Oracle DBA - Time Warner Telecom
> >
> > > -Original Message-
> > > From: Nosie [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 08, 2001 7:50 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Oracle 816 on linux
> > >
> > >
> > > Yes...I got almost the same problem. I failed when creating
> > > database using
> > > dbassist, but I got slightly different error message. It said
> > > ORA-03114 (not
> > > sure, though) NOT CONNECTED TO ORACLE. It seems that the
> > > instance startup
> > > failed..
> > > Now, I am trying to create it manually...
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Friday, February 09, 2001 8:55 AM
> > >
> > >
> > > > Hi..
> > > >   I just install Oracle 816 on Redhat 7.0. Installation
> > > process went well
> > > > without creating DB. When I tried to create DB, I got 
> error 3113:
> > > > end-of-file on communication channel after run "startup
> > > nomount pfile =
> > > > "/u01/app/oracle/admin/hrweb/pfile/inithrweb.ora"". I
> > > also lookup in
> > > > metalink. It told me to remove "remote_login_passwordfile =
> > > exclusive" out
> > > > of init.ora file. I did but it still does not work. Anybody
> > > have this kind
> > > > of error. Please help.
> > > >
> > > > Chakaphan Supacharuwong
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Nosie
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: 
> (858) 538-5051
> > > San Diego, California-- Public Internet access / 
> Mailing Lists
> > > 
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Ferris, Shawn
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: ht

Re: db_block_checkpoint_batch

[elain he]

Riyaj,
Thanks for your response.

The thing that puzzles me is that the seconds_in_wait time for all slaves 
dbwr processes equals to the time since the database was started. I would 
expect the seconds_in_wait time for slaves dbwr to be less than the database 
uptime. Does that mean that all slaves processes are idle? Or is the 
seconds_in_wait time for slaves dbwr interpreted differently than the rest 
of the db sessions?

I get conflicting opinion that Oracle does not support asyncio on Unix 
filesystem. Any idea if that is true?

Thanks.

--Elain


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: db_block_checkpoint_batch
>Date: Tue, 13 Feb 2001 09:16:33 -0800
>
>
>Hi elain
>  I have not personally encountered performance degradation setting 
>this
>to high value. But I will attempt to help you.
>  DBWR process is waiting for the IPC messages from the background
>process or from the server processes, for the requests to write the dirty
>buffers. That's how the processes communicate among themselves and wiating
>for an IPC message is normal. Also DBWR is the process which scans the
>buffer cache to create a list of buffers to write and then it distributes
>that list to the slave process to write. So slave process has to wait for
>the null event during no work. So, this is fine too.
>  db_block_checkpoint_batch determines what portion of db writes can be
>used for the slow checkpoints (in 7.3). By setting this to high value, the
>checkpoint will complete faster, but the speed at which DBWR cleans the
>buffer cache may be slightly slower. So more free buffer waits. You may
>have to play around these parameters little bit to determine the optimum
>value for your environment. I would set checkpoint batch size to be around
>1/8 th or 1/10th of Internal batch write size and go upwards. Also make
>sure that your log buffer is small enough and the DBW doesn't wait too much
>for the  log file sync event. Converting the file system based database to
>raw database and turning on async IO are other options.
>  In fact, Steve Adams has written a paper about this DBWR tuning.
>Search for db_block_checkpoint in his website www.ixora.com.au. You will
>find his paper.
>
>Thanks
>Riyaj "Re-yas" Shamsudeen
>Certified Oracle DBA
>"This is my opinion and does not legally bind me or my employer. Use at
>your own risk"
>
>
>
> "elain he"
> list ORACLE-L <[EMAIL PROTECTED]>
> ail.com> cc:
> Sent by: Subject: 
>db_block_checkpoint_batch
> root@fatcity.
> com
>
>
> 02/13/01
> 08:26 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Hi,
>Has anyone seen database performance degradation by setting this to a high
>value?
>
>We set this value to 128 from the default value 4 and noticed a lot more
>free buffer waits event.
>
>All database writers (DB01-10) are waiting for Null Event. The
>seconds_in_wait time from v$session_wait is 129614(~1.5days), ie the same
>time since the database started. The parent DBWR process is waiting on
>rdbms
>ipc message and the seconds_in_wait time is 0.
>
>Here's the configuration:
>DB 7.3.4
>db_writer=10
>async_io disable
>Solaris 2.6/Sun T3 Array
>_db_block_write_batch=512
>db_block_checkpoint_batch=128 (512/4)
>
>Appreciate any help you can provide.
>Thanks.
>
>--Elain
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: elain he
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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 

no alert.log

[Kris Austin]

hi list

we had a major outage at exodus lastnight. blew up both machines with 6
production databases. SAs have brought most of the disks back up but not
$ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
alert.log(s) live on the unmounted disks? doesn't an oracle database have
to be able to write to alert.log in order to start?

our databases are up. i've checked all the processes which are running (ps
-ef | grep ora), and i'm able to connect to all 6 remotely (just not
locally since the binaries for sqlplus and svrmgrl also live on those
unmounted disks). we are running 8.1.6 on solaris.

thanks,
kris

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

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

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

[Glenn Travis]

Please 
post your findings to the group.  I'm sure we'd all welcome 
it.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn NaessensSent: 
  Tuesday, February 13, 2001 10:02 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: off topic : gathering 
  information
  We are currently comparing : 
   
  Oracle : Enterprise Manager ( very expensive 
  )
  Ca : Manage-It
  BMC : Patrol 
  Tivoli : Database management ( how original 
  ) 
  Softtree : Dbtools 
   
  and now i added
   
  bradmark : Norad 2.0
  Embarcadero : Dbartisan ( it's decent but rather 
  limited )
   
  to the study. 
   
  thanks for the links Mark leith. 
   
  Bjorn Naessens
  Junior system engineer + dba
  Roularta IT Solutions
   
  
- Original Message - 
From: 
Mark 
Leith 
To: Multiple recipients of list ORACLE-L 

Sent: Tuesday, February 13, 2001 12:26 
PM
Subject: RE: off topic : gathering 
information

www.bradmark.com
www.quest.com
www.ca.com
www.embarcadero.com
www.leccotech.com
www.bmc.com
www.compuware.com
 
A 
few to start with..
 
We 
deal with NORAD (previously DBGeneral) from Bradmark, and the general feel 
of the people we talk to is that is one of the better options for a full 
monitoring/management package, as it is so tightly integrated. There are a 
number of other vendours who do actually deal with specific areas of 
management "in-depth" (Quest for instance) where they have a whole bag full 
of of tools.. All of the tools out there are great though, its just a matter 
of personal preference.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn 
  NaessensSent: Tuesday, February 13, 2001 10:10To: 
  Multiple recipients of list ORACLE-LSubject: off topic : 
  gathering information
  hello fellow dba's 
   
  we are currently running a project for 
  updating our database management tools. We want a pro-active and 
  easy-to-use graphical tool with a lot of possibilities ( db difference, 
  performance manager, top sessions, lock managers, ... ). 
   
  So i was wandering what all of you guys were 
  using so I can have an idea about what's on the market.
   
  thx in advance
   
  bjorn naessens
  junior system engineer + dba 
  Roularta IT Solutions
   

RE: HELP - Insert/Update trigger

[Fred Smith]

What is the purpose of the non-updateable view?
-FS


>From: "Norrell, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: HELP - Insert/Update trigger
>Date: Tue, 13 Feb 2001 09:56:15 -0800
>
>Not with a normal table trigger.  Try creating a non-updateable view with 
>an
>"instead of" trigger for the insert.
>
>Brian Norrell
>Senior Software Engineer
>QuadraMed
>972-831-6600
>
>
>-Original Message-
>Sent: Tuesday, February 13, 2001 9:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Listers,
>
>I am attempting to write a trigger on a table that will have batch
>inserts nightly.  I want each insert to check to see if a record with that
>primary key exists, and if it does, update the record.  If the primary key
>does not yet exist in the table, insert the record.  The batch load each
>night is a large series of inserts, no updates.  I want the trigger to
>figure out it if needs to update or insert.
>
>Can this be done??
>
>Thank you,
>   -Fred Smith
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Fred Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

RE: Doubt about charecter

[gregory . t . norris]

select name
   from table1
   where field like 'AAA_#989';
 
When used with LIKE, the underscore is a wildcard which will match any 
single character.
 
-Original Message-
Sent: Tuesday, February 13, 2001 11:26 AM
To: ORACLE-L
Cc: eca




I have a problem where in a statment of sql the DB Oracle doesn´t get 
the line in the follow situation :
 
    select name  
 from table1
  where field = 'AAA  #989';
 
I think that between A and # exist some strange character that i can´t 
identify it ..
 
How can I do it ?
 
Regards
 
Eriovaldo
    

RE: HELP - Insert/Update trigger

[Dasko, Dan]

Dang it,
Brian you're right, I didn't read the original post thoroughly.

Instead of batch inserts, do batch updates and in the exception handler, do
the insert.
Or you could use the %FOUND flag based on a select PK from table.

Dan

-Original Message-
Sent: Tuesday, February 13, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


Not with a normal table trigger.  Try creating a non-updateable view with an
"instead of" trigger for the insert.

Brian Norrell
Senior Software Engineer
QuadraMed
972-831-6600


-Original Message-
Sent: Tuesday, February 13, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Listers,

   I am attempting to write a trigger on a table that will have batch 
inserts nightly.  I want each insert to check to see if a record with that 
primary key exists, and if it does, update the record.  If the primary key 
does not yet exist in the table, insert the record.  The batch load each 
night is a large series of inserts, no updates.  I want the trigger to 
figure out it if needs to update or insert.

Can this be done??

Thank you,
  -Fred Smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

[dgoulet]

Bjorn,

We've spent the last two years trying just about every tool we could get our
hands on.  Some are very expensive & some pretty darn cheap.  But what I noticed
is that some of the expensive ones provide more glitz (namely a very fancy gui)
while the cheaper ones are missing in functionality.  In the end we settled on
OEM and Mamba.  OEM is expensive, about mid range, has good GUI's and is very
functional.  Mamba was very cheap (free), but did provide the read only web
based functionality we wanted.

If you want a successful search, first thing is to set down and list out
exactly what you need and what you'd like.  Then prioritize these  and match
then against the features of any tool you look at.  The one that matches the
most points in order wins.

Dick Goulet

Reply Separator
Author: "Bjorn Naessens" <[EMAIL PROTECTED]>
Date:   2/13/2001 2:10 AM

hello fellow dba's 

we are currently running a project for updating our database management tools.
We want a pro-active and easy-to-use graphical tool with a lot of possibilities
( db difference, performance manager, top sessions, lock managers, ... ). 

So i was wandering what all of you guys were using so I can have an idea about
what's on the market.

thx in advance

bjorn naessens
junior system engineer + dba 
Roularta IT Solutions
 







hello fellow dba's 
 
we are currently running a project for updating our

database management tools. We want a pro-active and easy-to-use graphical tool 
with a lot of possibilities ( db difference, performance manager, top sessions, 
lock managers, ... ). 
 
So i was wandering what all of you guys were using 
so I can have an idea about what's on the market.
 
thx in advance
 
bjorn naessens
junior system engineer + dba 
Roularta IT Solutions
 
-- 
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: Unix Memory Question

[Mohammad Rafiq]

Use glance(preferable) or top and see memory usage. Based on free memory
you can decide about increase of your buffers. If your db_block_size is
8K, adding 1000 block means addition of 8MB in your SGA. If still not sure 
check with your Unix Admin.
HTH,
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 13 Feb 2001 09:36:03 -0800

Hi list,

I have a question about Unix and Oracle memory allocation. I have to say
that Unix isn't my platform, so I think for most of you this will be easy
answerd.

I have a HP Unix machine with follwing memory infos:

Memory Information:
 physical page size = 4096 bytes, logical page size = 4096 bytes
 Physical: 524288 Kbytes, lockable: 380640 Kbytes, available: 441536
Kbytes

There is a Oracle running on this box. Hit statistics show me that I have to
increase the db_block_buffers. What I like to know is, how much more memory
can I give oracle? There are about 50 User working with this instance.

TIA

Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de


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

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

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

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

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

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

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

Scripts -- Scripts -- Scripts (One more time)

[Pablo ksksksk]

Thanks to all who replied.
Thanks all who answered.

Mary's script has benn very useful.
Unfortunately, this script does not generate the 
"procedure", "packages" and "triggers" scripts.

Does someone have some scripts to do so ?


thanks everybody.






--- "Ruiz, Mary A (CAP, CDI)"
<[EMAIL PROTECTED]> escribió: > Pablo:
>   Hola !  Here is something that was posted to the
> list that I have found to be extremely useful.  This
> uses a .dmp file produced by exp, and generates ddl
> for your database.
> Buena Suerte.
> 
> Mary Ruiz / Atlanta GA
> 
> -Original Message-
> From: Som Priani 
> Sent: Thursday, November 02, 2000 8:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Life made easier : Scripts to Extract DDL
> from Export DUMP
> 
> 
> Hi Listers,
> 
> Scenario : Build a test/play database from an export
> dump from Production
> (those monstrous sizes) but do not have disk space
> to accomodate all the
> extents...
> 
> Rummaging through the dump file and/or precreating
> tablespaces and objects
> and then importing the rest is the solution!! Even
> if all the SQL scripts
> are available - running them in the order of
> dependency will be quite
> tedious and error prone.
> 
> I have created Korn shell scripts to extract the DDL
> for objects which need
> disk space in the database and then to reduce them
> by a factor or set them
> to a fixed value. Please find them at
> http://members.tripod.com/Som_Priani
> The strategy
>   Create a new database
> 
>   Extract the SQL scripts from the export dump using
> the utility
>   Resize file and extent sizes ( the editing has been
> automated )
> 
>   CREATE TABLESPACES
>   CREATE ROLLBACK SEGMENTS
>   CREATE PROFILES
>   CREATE USERS
>   CREATE ROLES
>   GRANT SYSTEM PRIVS to USERS
>   REVOKE SYSTEM GRANTS /ALTER users
>   CREATE TABLES
>   CREATE INDEXES
>   Import with IGNORE=Y to get all the constraints,
> stored programs,
> triggers...
> 
> Takes a few minutes to run the whole thing - try it
> out...
> Bouquets and Brickbats welcome!! Please use
> backchannel.
> 
> HTH
> Som Priani
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Som Priani
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Envía mensajes instantáneos y recibe alertas de correo con 
Yahoo! Messenger - http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

[Boivin, Patrice J]

Have you thought of Precise Software?

I am evaluating the Precise / Savant tools now, next will be OEM 2.1.
Am looking for something that compares schemas or databases for integrity
after maintenance or Oracle upgrades.

www.precise.com  
www.savant.com  

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-
From:   Bjorn Naessens [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, February 13, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: off topic : gathering information

We are currently comparing : 
 
Oracle : Enterprise Manager ( very expensive )
Ca : Manage-It
BMC : Patrol 
Tivoli : Database management ( how original ) 
Softtree : Dbtools 
 
and now i added
 
bradmark : Norad 2.0
Embarcadero : Dbartisan ( it's decent but rather limited )
 
to the study. 
 
thanks for the links Mark leith. 
 
Bjorn Naessens
Junior system engineer + dba
Roularta IT Solutions
 

- Original Message - 
From: Mark Leith   
To: Multiple recipients of list ORACLE-L
  
Sent: Tuesday, February 13, 2001 12:26 PM
Subject: RE: off topic : gathering information

www.bradmark.com  
www.quest.com  
www.ca.com  
www.embarcadero.com  
www.leccotech.com  
www.bmc.com  
www.compuware.com  
 
A few to start with..
 
We deal with NORAD (previously DBGeneral) from Bradmark, and
the general feel of the people we talk to is that is one of the better
options for a full monitoring/management package, as it is so tightly
integrated. There are a number of other vendours who do actually deal with
specific areas of management "in-depth" (Quest for instance) where they have
a whole bag full of of tools.. All of the tools out there are great though,
its just a matter of personal preference.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bjorn Naessens
Sent: Tuesday, February 13, 2001 10:10
To: Multiple recipients of list ORACLE-L
Subject: off topic : gathering information


hello fellow dba's 
 
we are currently running a project for updating our
database management tools. We want a pro-active and easy-to-use graphical
tool with a lot of possibilities ( db difference, performance manager, top
sessions, lock managers, ... ). 
 
So i was wandering what all of you guys were using
so I can have an idea about what's on the market.
 
thx in advance
 
bjorn naessens
junior system engineer + dba 
Roularta IT Solutions
 

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

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

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

RE: HELP - Insert/Update trigger

[Dasko, Dan]

Yes, it can be done,
I'd write the trig to do a select on that PK and if %FOUND is true, update
otherwise in the exception handler for that block, do the insert.

begin
..
begin
select PK from table;
UPDATE
exception
INSERT
end
..
end

Dan
-Original Message-
Sent: Tuesday, February 13, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


Listers,

   I am attempting to write a trigger on a table that will have batch 
inserts nightly.  I want each insert to check to see if a record with that 
primary key exists, and if it does, update the record.  If the primary key 
does not yet exist in the table, insert the record.  The batch load each 
night is a large series of inserts, no updates.  I want the trigger to 
figure out it if needs to update or insert.

Can this be done??

Thank you,
  -Fred Smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

[William Beilstein]

How about removing the public synonym and create a private one in the schemas that 
need it. Except for a table or procedure that is truly global, making a public synonym 
is never a good idea.

>>> "Nisha Patel" <[EMAIL PROTECTED]> 02/13/01 09:55AM >>>
Hi All,
 I have a really wierd problem with a client who has tried to export the
whole database. They get errors because there is
a public synonym called System created by a user FCAADMIN. This public
synonym caused several oracle supplied objects to go invalid resulting
in the failed Oracle exports.   I know we should not have a table called
System but I had inherited the database and it is too late in the game
to rename it. Does anyone have any solution to this problem?


Thanks in advance,
Nisha

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

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

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

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

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

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

Re: no alert.log

[Ruth Gramolini]

To be clearer I should have said if the udump destination is present.  If
there are no errors I ofter delete the alert logs to make room.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:21 PM


>
>
> hi list
>
> we had a major outage at exodus lastnight. blew up both machines with 6
> production databases. SAs have brought most of the disks back up but not
> $ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
> alert.log(s) live on the unmounted disks? doesn't an oracle database have
> to be able to write to alert.log in order to start?
>
> our databases are up. i've checked all the processes which are running (ps
> -ef | grep ora), and i'm able to connect to all 6 remotely (just not
> locally since the binaries for sqlplus and svrmgrl also live on those
> unmounted disks). we are running 8.1.6 on solaris.
>
> thanks,
> kris
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

Re: Doubt about charecter

[Ruth Gramolini]

How about using this statement:
select name
 from table1
  where field  like  'AAA% #989';

The % represents any character.

HTH,
Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 12:25 PM


Oracle 816 on linuxI have a problem where in a statment of sql the DB Oracle
doesn?t get the line in the follow situation :

select name
 from table1
  where field = 'AAA  #989';

I think that between A and # exist some strange character that i can?t
identify it ..

How can I do it ?

Regards

Eriovaldo




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

RE: no alert.log

[Henry Poras]

Kris,
Try doing something to force a write to the alert log (e.g. switch logfile
or backup controlfile to trace). Of course to start up the database there
should also be writes to the alert log. Also, what did it use for init.ora?
That should also be under $ORACLE_BASE. You can check v$parameter for bdump.
If that is in $ORACLE_BASE, I would guess that the database didn't have a
normal startup and it hasn't looked for those directories yet. You can also
try searching the server for alertSID.log.

Henry

-Original Message-
Sent: Tuesday, February 13, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L




hi list

we had a major outage at exodus lastnight. blew up both machines with 6
production databases. SAs have brought most of the disks back up but not
$ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
alert.log(s) live on the unmounted disks? doesn't an oracle database have
to be able to write to alert.log in order to start?

our databases are up. i've checked all the processes which are running (ps
-ef | grep ora), and i'm able to connect to all 6 remotely (just not
locally since the binaries for sqlplus and svrmgrl also live on those
unmounted disks). we are running 8.1.6 on solaris.

thanks,
kris

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

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

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

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

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

RE: Offline doubt - Exclusive OR operator in PL/SQL??.

[Elliott, Patrick]

The only reference I found in the documentation was in the UTL_RAW package.

BIT_XOR Function
This function performs bitwise logical "exclusive or" of the values in RAW
r1 with RAW r2 and returns the "xor'd" result RAW. 

If r1 and r2 differ in length, then the "xor" operation is terminated after
the last byte of the shorter of the two RAWs, and the unprocessed portion of
the longer RAW is appended to the partial result.The result length equals
the longer of the two input RAWs. 

Syntax
UTL_RAW.BIT_XOR (
   r1 IN RAW,
   r2 IN RAW) 
  RETURN RAW;

Pragmas
pragma restrict_references(bit_xor, WNDS, RNDS, WNPS, RNPS); 

Parameters
Table 63-40 BIT_XOR Function Parameters 

> -Original Message-
> From: Arul kumar [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 7:31 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Offline doubt - Exclusive OR operator in PL/SQL??.
> 
> Hi Gurus,
> 
> We are currently working on migration of ORACLE / VB env. to ORACLE WEB
> SERVER env.
> 
> In this, we need to change one part of VB code which is using EXCLUSIVE
> OR operator functionality  to ORACLE (PL/SQL).
> 
> Do we have such  Exclusive OR operator in PL/SQL ? or is anyother way to
> get the work done.?
> 
> Note - Oracle Database Version - 7.x
> 
> Thank You.
> Arul.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Arul kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

[Brian D. Silverio]

> There is a Oracle running on this box. Hit statistics show me that I have to
> increase the db_block_buffers. What I like to know is, how much more memory
> can I give oracle? There are about 50 User working with this instance.
> 

The bottom line is that you can increase db_block_buffers until the system starts
to page and/or swap processes.  So, if you are already paging then you can't add
anything to db_block_buffers w/o reducing performance.  If you are NOT paging then
you can increase it by some amount and watch the system for paging activity.

You can use sar to determine if paging is taking place.  HP may have something better
for you to use.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian D. Silverio
  INET: [EMAIL PROTECTED]

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

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

[exu]

I believe that there are no easy answer to you how much memory  that you can add
to your SGA.  You need to some experimental work to find out how many memory
that  you can take away from system without dragging it down(or over burden it).
You can use 'vmstat' and 'sar -w' to monitor memory swapping. The rule of thrumb
is that you should see no memory swapping out  in your system.

Eveleen



Please respond to [EMAIL PROTECTED]


Schoen Volker <[EMAIL PROTECTED]> on 02/13/2001 11:36:03 AM


  Message - From: Schoen Volker <[EMAIL PROTECTED]> on 02/13/2001 05:36 PM GMT 




  
  
  
 To:  Multiple recipients of list ORACLE-L
  <[EMAIL PROTECTED]>  
  
 cc:  (bcc: Eveleen Xu/NNIB/NNNG) 
  
  
  
 Subject: Unix Memory Question
  






Hi list,

I have a question about Unix and Oracle memory allocation. I have to say
that Unix isn't my platform, so I think for most of you this will be easy
answerd.

I have a HP Unix machine with follwing memory infos:

Memory Information:
physical page size = 4096 bytes, logical page size = 4096 bytes
Physical: 524288 Kbytes, lockable: 380640 Kbytes, available: 441536
Kbytes

There is a Oracle running on this box. Hit statistics show me that I have to
increase the db_block_buffers. What I like to know is, how much more memory
can I give oracle? There are about 50 User working with this instance.

TIA

Volker Sch


ön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de


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

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

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

Beta Site

[Cyril Thankappan]

hello,

 can some one please help me with this

 a. What r the issues (advantages /disadvantages)
in becoming a beta site?

 b. How does one go about becoming a beta site?


Thanks

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com




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

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

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

[Elliott, Patrick]

That is correct.  In 8.0 the package does not need to be in memory to pin
it.

> -Original Message-
> From: Ray Feighery [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 4:21 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Database Startup Trigger is not pinning all packages
> 
> I believe this restriction has been lifted.
> It is no longer necessary to call the packages before loading them.
> 
> Ray
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 13, 2001 6:00 AM
> 
> 
> > I would need to double-check on your error, but the usual problem 
> > with pinning packages at startup is that they haven't been loaded 
> > into memory (standard and some of SYS's other packages load 
> > almost at the initial moment of startup). Try to put some code into 
> > the trigger to call the packages first, then load them. One approach 
> > is to put in dummy function in the user packages that returns null 
> > and call that function, thus pulling the package into memory.
> > 
> > Regards,
> > Chris Gait
> > -- 
> > 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: Ray Feighery
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

[Ruth Gramolini]

If there is not an alert_.log oracle will  create one as long as the
udump dest is present.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:21 PM


>
>
> hi list
>
> we had a major outage at exodus lastnight. blew up both machines with 6
> production databases. SAs have brought most of the disks back up but not
> $ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
> alert.log(s) live on the unmounted disks? doesn't an oracle database have
> to be able to write to alert.log in order to start?
>
> our databases are up. i've checked all the processes which are running (ps
> -ef | grep ora), and i'm able to connect to all 6 remotely (just not
> locally since the binaries for sqlplus and svrmgrl also live on those
> unmounted disks). we are running 8.1.6 on solaris.
>
> thanks,
> kris
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

RE: HELP - Insert/Update trigger

[Norrell, Brian]

I have never worked directly with "instead of" triggers, but their intent is
to be used on a non-updateable view.  For instance:

SQL> create view all_emps as select * from emps UNION select * from
archived_emps;
SQL> insert into all_emps (...);

The RDBMS then says "Which real table does this record need to go into? I'm
confused! ERROR! ERROR!"

SQL> create trigger emp_ins instead of insert on all_emps for each row
2begin
3   -- noone inserts straight to archive, so we know they need to go in
emps
4   insert into emps values (new.a, ...);
5end;
6/

SQL> insert into all_emps (...);

Yeah! It works now!!!

I know that these were intended to be used on what would otherwise be a
non-updateable views.  I do not think they can be created on other objects,
but I could be wrong - call Ripley :)

Brian Norrell
Senior Software Engineer
QuadraMed
972-831-6600


-Original Message-
Sent: Tuesday, February 13, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L


What is the purpose of the non-updateable view?
-FS


>From: "Norrell, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: HELP - Insert/Update trigger
>Date: Tue, 13 Feb 2001 09:56:15 -0800
>
>Not with a normal table trigger.  Try creating a non-updateable view with 
>an
>"instead of" trigger for the insert.
>
>Brian Norrell
>Senior Software Engineer
>QuadraMed
>972-831-6600
>
>
>-Original Message-
>Sent: Tuesday, February 13, 2001 9:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Listers,
>
>I am attempting to write a trigger on a table that will have batch
>inserts nightly.  I want each insert to check to see if a record with that
>primary key exists, and if it does, update the record.  If the primary key
>does not yet exist in the table, insert the record.  The batch load each
>night is a large series of inserts, no updates.  I want the trigger to
>figure out it if needs to update or insert.
>
>Can this be done??
>
>Thank you,
>   -Fred Smith
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Fred Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

RE: HELP - Insert/Update trigger

[Fred Smith]

Dan,
  If I send an update to the table, an no record exists to update, Oracle 
does not throw an ORA- error.  (It just says "zero records exist".)  Is 
there a way around this??
Thanks,
  -FS


>From: "Dasko, Dan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: HELP - Insert/Update trigger
>Date: Tue, 13 Feb 2001 10:51:22 -0800
>
>Dang it,
>Brian you're right, I didn't read the original post thoroughly.
>
>Instead of batch inserts, do batch updates and in the exception handler, do
>the insert.
>Or you could use the %FOUND flag based on a select PK from table.
>
>Dan
>
>-Original Message-
>Sent: Tuesday, February 13, 2001 12:56 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Not with a normal table trigger.  Try creating a non-updateable view with 
>an
>"instead of" trigger for the insert.
>
>Brian Norrell
>Senior Software Engineer
>QuadraMed
>972-831-6600
>
>
>-Original Message-
>Sent: Tuesday, February 13, 2001 9:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Listers,
>
>I am attempting to write a trigger on a table that will have batch
>inserts nightly.  I want each insert to check to see if a record with that
>primary key exists, and if it does, update the record.  If the primary key
>does not yet exist in the table, insert the record.  The batch load each
>night is a large series of inserts, no updates.  I want the trigger to
>figure out it if needs to update or insert.
>
>Can this be done??
>
>Thank you,
>   -Fred Smith
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Fred Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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 message has been checked for all known viruses by UUNET delivered
>through the MessageLabs Virus Control Centre. For further information visit
>http://www.uk.uu.net/products/security/virus/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Dasko, Dan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

Difference between OAS and OiAS

[Murali Vallath]

Anyone have any idea what the difference between the following two products 
from Oracle.

Oracle Application Server and Oracle Internet Application Server


Regards,

Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/

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

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

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

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

[Elliott, Patrick]

Change the command to 

su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"

You need the double quotes I believe.

> -Original Message-
> From: Van M. Etheridge [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 10:13 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  automatic startup and shutdown of LISTENER 
> 
> I would like to be able tostartup and shutdown the listener when my SA 
> shutsdown and brings the Unix box back up. What happens when my SA brings
> up
> 
> the OS is that he gets the lsnrctl prompt rather than listener starting.
> He 
> can then type the start command and listerner starts. But it should start 
> without him having to key in the command.
> I have the following in both the  /etc/init.d/dbstart and
> /etc/rc2.d/s99dbstart  files:
> su - oracle -c $ORACLE_HOME/bin/ lsnrctl start
> (I use the default listener name "LISTENER")
> Sun SPARC Solaris OS 2.4
> Oracle7 ServerRelease 7.3.4.0.1 - Production
> With thedistributed, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.0.0 - Production
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Van M. Etheridge
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

[Mohammad Rafiq]

Even ver 7.3.4 provides the same functionality. I am pinning almost
80 packages at database startup.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 13 Feb 2001 11:22:07 -0800

That is correct.  In 8.0 the package does not need to be in memory to pin
it.

 > -Original Message-
 > From:Ray Feighery [SMTP:[EMAIL PROTECTED]]
 > Sent:Monday, February 12, 2001 4:21 PM
 > To:  Multiple recipients of list ORACLE-L
 > Subject: Re: Database Startup Trigger is not pinning all packages
 >
 > I believe this restriction has been lifted.
 > It is no longer necessary to call the packages before loading them.
 >
 > Ray
 > - Original Message -
 > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
 > Sent: Tuesday, February 13, 2001 6:00 AM
 >
 >
 > > I would need to double-check on your error, but the usual problem
 > > with pinning packages at startup is that they haven't been loaded
 > > into memory (standard and some of SYS's other packages load
 > > almost at the initial moment of startup). Try to put some code into
 > > the trigger to call the packages first, then load them. One approach
 > > is to put in dummy function in the user packages that returns null
 > > and call that function, thus pulling the package into memory.
 > >
 > > Regards,
 > > Chris Gait
 > > --
 > > 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: Ray Feighery
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (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: Elliott, Patrick
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Oracle vs MS Access

[Maria Freytag]

We are developing web database standards in my workplace.  I need to identify 
advantages/disadvantages of using Oracle verses MS Access for web databases.

Does anyone know of any good resources for gathering this info (web sites, articles, 
etc)?  Any help would be greatly appreciated.

Thanks Maria

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

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

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

listner.log cannot be generated

[exu]

Hi list,

About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though i did
 not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one month
 period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
  extproc   has 1 service handler(s)
  idms  has 1 service handler(s)
  orac  has 3 service handler(s)
  tsp   has 1 service handler(s)
  vign  has 2 service handler(s)
The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.


nnidb1:/export/home/oracle@orac> cd /u01/app/oracle/product/8.0.5/network/log
nnidb1:/u01/app/oracle/product/8.0.5/network/log@orac> ls -laF
total 4488
drwxr-xr-x   4 oracle   dba  512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba  512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba  512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba  512 Jan  5 09:57 2001/
-rw-rw-rw-   1 oracle   dba0 Jan  5 14:24 listener.log
-rw-rw-rw-   1 oracle   dba  2278569 Jan 23 09:55 sqlnet.log


Will someone in the list enlight me?

Thanks

Eveleen


-- 
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: Beta Site

[Steve Adams]

Hi Cyril,

The deadline for applications to participate in the beta program was back in
mid-December.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Wednesday, 14 February 2001 5:36
To: Multiple recipients of list ORACLE-L



hello,

 can some one please help me with this

 a. What r the issues (advantages /disadvantages)
in becoming a beta site?

 b. How does one go about becoming a beta site?


Thanks

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com




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

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

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

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

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

[Carle, William T (Bill), NLCIO]

Have you bounced the listener since you moved the log file?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Tuesday, February 13, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject:listner.log cannot be generated



Hi list,

About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though i
did
 not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one
month
 period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
  extproc   has 1 service handler(s)
  idms  has 1 service handler(s)
  orac  has 3 service handler(s)
  tsp   has 1 service handler(s)
  vign  has 2 service handler(s)
The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.


nnidb1:/export/home/oracle@orac> cd
/u01/app/oracle/product/8.0.5/network/log
nnidb1:/u01/app/oracle/product/8.0.5/network/log@orac> ls -laF
total 4488
drwxr-xr-x   4 oracle   dba  512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba  512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba  512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba  512 Jan  5 09:57 2001/
-rw-rw-rw-   1 oracle   dba0 Jan  5 14:24 listener.log
-rw-rw-rw-   1 oracle   dba  2278569 Jan 23 09:55 sqlnet.log


Will someone in the list enlight me?

Thanks

Eveleen


-- 
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: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

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

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

[Mohammad Rafiq]

Under this scenrio when listener is up them removing lines is a better 
choice to clean log file.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 13 Feb 2001 13:01:22 -0800


Hi
 I think, you removed the listener log file while the listener is up and
running. When you removed the listener log, listener was having a file
pointer open. Since the file pointer is not closed, the listener is still
writing to the same node.

 If you stop and start the listener, you would see the log file.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"These are my opinions and usual disclaimers apply"



 [EMAIL PROTECTED]
 Sent by: To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
 root@fatcity.cc:
 com  Subject: listner.log cannot be 
generated


 02/13/01
 02:29 PM
 Please
 respond to
 ORACLE-L








Hi list,

About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though
i did
  not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one
month
  period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
   extproc   has 1 service handler(s)
   idms  has 1 service handler(s)
   orac  has 3 service handler(s)
   tsp   has 1 service handler(s)
   vign  has 2 service handler(s)
The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.


nnidb1:/export/home/oracle@orac> cd
/u01/app/oracle/product/8.0.5/network/log
nnidb1:/u01/app/oracle/product/8.0.5/network/log@orac> ls -laF
total 4488
drwxr-xr-x   4 oracle   dba  512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba  512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba  512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba  512 Jan  5 09:57 2001/
-rw-rw-rw-   1 oracle   dba0 Jan  5 14:24 listener.log
-rw-rw-rw-   1 oracle   dba  2278569 Jan 23 09:55 sqlnet.log


Will someone in the list enlight me?

Thanks

Eveleen


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

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

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




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

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

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

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

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

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

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

RE: Offline doubt - Exclusive OR operator in PL/SQL??.

[MacGregor, Ian A.]

I said it was a bit xor. Your first message was not very specific.  There is no 
general xor operator in Oracle.  However under Oracle 8i you can create one.  Look at 
the create operator command.

You could also do something like

(select x from A where y = 2
union
select x from A where z = 2)
minus
(select x from A where y = 2
intersect
select x from dual where z= 2)


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Tuesday, February 13, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L


The only reference I found in the documentation was in the UTL_RAW package.

BIT_XOR Function
This function performs bitwise logical "exclusive or" of the values in RAW
r1 with RAW r2 and returns the "xor'd" result RAW. 

If r1 and r2 differ in length, then the "xor" operation is terminated after
the last byte of the shorter of the two RAWs, and the unprocessed portion of
the longer RAW is appended to the partial result.The result length equals
the longer of the two input RAWs. 

Syntax
UTL_RAW.BIT_XOR (
   r1 IN RAW,
   r2 IN RAW) 
  RETURN RAW;

Pragmas
pragma restrict_references(bit_xor, WNDS, RNDS, WNPS, RNPS); 

Parameters
Table 63-40 BIT_XOR Function Parameters 

> -Original Message-
> From: Arul kumar [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 7:31 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Offline doubt - Exclusive OR operator in PL/SQL??.
> 
> Hi Gurus,
> 
> We are currently working on migration of ORACLE / VB env. to ORACLE WEB
> SERVER env.
> 
> In this, we need to change one part of VB code which is using EXCLUSIVE
> OR operator functionality  to ORACLE (PL/SQL).
> 
> Do we have such  Exclusive OR operator in PL/SQL ? or is anyother way to
> get the work done.?
> 
> Note - Oracle Database Version - 7.x
> 
> Thank You.
> Arul.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Arul kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Public Synonym SYSTEM causing Problem with Export

[Nisha Patel]

I tried that and it worked fine. Thankyou soo much.

> -Original Message-
> From: William Beilstein [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 13, 2001 1:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Public Synonym SYSTEM causing Problem with Export
> 
> How about removing the public synonym and create a private one in the
> schemas that need it. Except for a table or procedure that is truly
> global, making a public synonym is never a good idea.
> 
> >>> "Nisha Patel" <[EMAIL PROTECTED]> 02/13/01 09:55AM >>>
> Hi All,
>  I have a really wierd problem with a client who has tried to export
> the
> whole database. They get errors because there is
> a public synonym called System created by a user FCAADMIN. This public
> synonym caused several oracle supplied objects to go invalid resulting
> in the failed Oracle exports.   I know we should not have a table
> called
> System but I had inherited the database and it is too late in the game
> to rename it. Does anyone have any solution to this problem?
> 
> 
> Thanks in advance,
> Nisha
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Nisha Patel
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: William Beilstein
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nisha Patel
  INET: [EMAIL PROTECTED]

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

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

top n or top n%

[Leslie Lu]

Hi listers,

I remeber vaguely there is a way to select top n or
top % rows of a select statement.  But I cannot find
it anywhere.  Could somebody let me know?  Thank you.

Leslie

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

system command hangs from external pl/sql

[Myszkowski.Mark]

Title: system command hangs from external pl/sql





Hi 
I am trying to implement printing from pl/sql on our system.  We are running Tru64 Unix and Oracle 8.0.5.  I have configured an external procedure listener and created a shared library by following some of the documentation in Metalink.  The test procedure called "wordcat" works fine.  One of the things it does is create a file in /tmp called wordcat.out.  Now I'd like to print this file.  When I add the following to the c source code and then recompile the external procedure hangs:

int i;
i=system("/usr/bin/lpr -Ppedctest /tmp/wordcat.out");


(It hangs for any system call I make; e.g., "/usr/bin/touch".)  The system command works fine when I compile it into it's own program.  Has anyone run into something like this?  Thanks a lot for any suggestions - I appreciate it.

Mark

Problems with database link - 8.1.6

[Manas Dasgupta]

Hi:

I'm having problems setting up and using database link.
My create statement looks as follows:
create database link PROD connect to xuser identified by xpwd using
'TRNGPROD';

I then execute :
select * from sysadm.employees@PROD.
and get the following error:
ORA-12154: TNS:could not resolve service name

However I can connect to TRNGPROD from SQLPlus.

What am I doing wrong?

TIA,
Manas.


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

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

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

[Renato Huliganga]

Only in M$ SQL Server 7.
eg:

SELECT * TOP 100 FROM yourtable

(I think your leading a double life!)

Renato
Database Services
IBM Global Services A/NZ


Leslie Lu <[EMAIL PROTECTED]> on 14/02/2001 08:50:43

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Renato Huliganga/Australia/IBM)




Hi listers,

I remeber vaguely there is a way to select top n or
top % rows of a select statement.  But I cannot find
it anywhere.  Could somebody let me know?  Thank you.

Leslie

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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



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

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

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

[Ron Rogers]

Eveleen,
If you did NOT stop the listener and then restart it ,the listener would continue to 
write to the renamed file is it could find it. The steps to work with the listener log 
are to:
1. stop the listener.
2. rename to log to a new name ie: log.old.
3. restart the listener.
The users active (connected) during this procedure will not be disconnected. only new 
users will be denied during the small down time.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 02/13/01 03:29PM >>>


Hi list,

About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though i did
 not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one month
 period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
  extproc   has 1 service handler(s)
  idms  has 1 service handler(s)
  orac  has 3 service handler(s)
  tsp   has 1 service handler(s)
  vign  has 2 service handler(s)
The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.


nnidb1:/export/home/oracle@orac> cd /u01/app/oracle/product/8.0.5/network/log
nnidb1:/u01/app/oracle/product/8.0.5/network/log@orac> ls -laF
total 4488
drwxr-xr-x   4 oracle   dba  512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba  512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba  512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba  512 Jan  5 09:57 2001/
-rw-rw-rw-   1 oracle   dba0 Jan  5 14:24 listener.log
-rw-rw-rw-   1 oracle   dba  2278569 Jan 23 09:55 sqlnet.log


Will someone in the list enlight me?

Thanks

Eveleen


-- 
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: top n or top n%

[Suhen Pather]

Leslie,

Try using a rownum.

select * from emp
where rownum<20
order by sal;

HTH
Suhen


Hi listers,

I remeber vaguely there is a way to select top n or
top % rows of a select statement.  But I cannot find
it anywhere.  Could somebody let me know?  Thank you.

Leslie

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

[Kris Austin]

thanks, but this is what i get when i try to cd to $ORACLE_HOME:

db1:PHYS:/ora1_app> cd $ORACLE_HOME
bash: cd: /ora1_app/product/8.1.6: No such file or directory
db2:CONC:/ora2_app> cd $ORACLE_HOME
bash: cd: /ora2_app/product/8.1.6: No such file or directory

or an ls on $ORACLE_BASE:

db1:PHYS:/ora1_app> ls $ORACLE_BASE
db1:PHYS:/ora1_app> 

nothing!

the disks on these 2 machines: ora1_app and ora2_app have not mounted. i
don't know where the alert.log is being written to, or how the init.ora
was read (both are located on those disks).

i checked v$parameter and all the parameters (background_dump_dest,
etc) show directories that are not mounted. i'm still trying to get
an SA to find any log or trc files.

thanks,
kris

On Tue, 13 Feb 2001, William Dong wrote:

> Hi:
> If the specified bdump is not accessable, oracle may write the alert_log to
> $ORACLE_HOME/dbms or dbs directory by default. I am sure you can find it
> somewhere in oracle_home.
> 
> 
> 
> 
> 
> |+--->
> ||  Henry Poras  |
> ||   ||  ctp.com> |
> ||   |
> ||  02/13/01 |
> ||  02:10 PM |
> ||  Please   |
> ||  respond to   |
> ||  ORACLE-L |
> ||   |
> |+--->
>   >-|
>   | |
>   |   To: Multiple recipients of list ORACLE-L  |
>   |   <[EMAIL PROTECTED]>|
>   |   cc: (bcc: William Dong/New York Life Asset|
>   |   Management)   |
>   |   Subject: RE: no alert.log |
>   >-|
> 
> 
> 
> 
> Kris,
> Try doing something to force a write to the alert log (e.g. switch logfile
> or backup controlfile to trace). Of course to start up the database there
> should also be writes to the alert log. Also, what did it use for init.ora?
> That should also be under $ORACLE_BASE. You can check v$parameter for bdump.
> If that is in $ORACLE_BASE, I would guess that the database didn't have a
> normal startup and it hasn't looked for those directories yet. You can also
> try searching the server for alertSID.log.
> 
> Henry
> 
> -Original Message-
> Sent: Tuesday, February 13, 2001 1:21 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> hi list
> 
> we had a major outage at exodus lastnight. blew up both machines with 6
> production databases. SAs have brought most of the disks back up but not
> $ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
> alert.log(s) live on the unmounted disks? doesn't an oracle database have
> to be able to write to alert.log in order to start?
> 
> our databases are up. i've checked all the processes which are running (ps
> -ef | grep ora), and i'm able to connect to all 6 remotely (just not
> locally since the binaries for sqlplus and svrmgrl also live on those
> unmounted disks). we are running 8.1.6 on solaris.
> 
> thanks,
> kris

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

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

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

[William Dong]

The following may work:

su - oracle -c $ORACLE_HOME/bin/lsnrctl <
||  "Elliott, Patrick" |
||   |
|| |
||  02/13/01 03:03 PM  |
||  Please respond to  |
||  ORACLE-L   |
|| |
|+->
  >-|
  | |
  |   To: Multiple recipients of list ORACLE-L  |
  |   <[EMAIL PROTECTED]>|
  |   cc: (bcc: William Dong/New York Life Asset|
  |   Management)   |
  |   Subject: RE: automatic startup and|
  |   shutdown of LISTENER  |
  >-|




Change the command to

su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"

You need the double quotes I believe.

> -Original Message-
> From: Van M. Etheridge [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 10:13 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:   automatic startup and shutdown of LISTENER
>
> I would like to be able tostartup and shutdown the listener when my SA
> shutsdown and brings the Unix box back up. What happens when my SA brings
> up
>
> the OS is that he gets the lsnrctl prompt rather than listener starting.
> He
> can then type the start command and listerner starts. But it should start
> without him having to key in the command.
> I have the following in both the  /etc/init.d/dbstart and
> /etc/rc2.d/s99dbstart  files:
> su - oracle -c $ORACLE_HOME/bin/ lsnrctl start
> (I use the default listener name "LISTENER")
> Sun SPARC Solaris OS 2.4
> Oracle7 ServerRelease 7.3.4.0.1 - Production
> With thedistributed, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.0.0 - Production
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Van M. Etheridge
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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




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

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

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

[William Dong]

Hi:
If the specified bdump is not accessable, oracle may write the alert_log to
$ORACLE_HOME/dbms or dbs directory by default. I am sure you can find it
somewhere in oracle_home.





|+--->
||  Henry Poras  |
||   |
||   |
||  02/13/01 |
||  02:10 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >-|
  | |
  |   To: Multiple recipients of list ORACLE-L  |
  |   <[EMAIL PROTECTED]>|
  |   cc: (bcc: William Dong/New York Life Asset|
  |   Management)   |
  |   Subject: RE: no alert.log |
  >-|




Kris,
Try doing something to force a write to the alert log (e.g. switch logfile
or backup controlfile to trace). Of course to start up the database there
should also be writes to the alert log. Also, what did it use for init.ora?
That should also be under $ORACLE_BASE. You can check v$parameter for bdump.
If that is in $ORACLE_BASE, I would guess that the database didn't have a
normal startup and it hasn't looked for those directories yet. You can also
try searching the server for alertSID.log.

Henry

-Original Message-
Sent: Tuesday, February 13, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L




hi list

we had a major outage at exodus lastnight. blew up both machines with 6
production databases. SAs have brought most of the disks back up but not
$ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
alert.log(s) live on the unmounted disks? doesn't an oracle database have
to be able to write to alert.log in order to start?

our databases are up. i've checked all the processes which are running (ps
-ef | grep ora), and i'm able to connect to all 6 remotely (just not
locally since the binaries for sqlplus and svrmgrl also live on those
unmounted disks). we are running 8.1.6 on solaris.

thanks,
kris

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

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

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

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

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




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

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

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

Oracle JDBC Thin Driver Licensing Issue

[Sanjay Kumar]

hi,
 
Does anyone know whether Oracle JDBC Thin Driver 
can be shipped  to the clients without getting any license from 
Oracle?.
 
Is it free for shipping? 
 
Sanjay
 
 

Re: listner.log cannot be generated

[Riyaj_Shamsudeen]

Hi
I think, you removed the listener log file while the listener is up and
running. When you removed the listener log, listener was having a file
pointer open. Since the file pointer is not closed, the listener is still
writing to the same node.

If you stop and start the listener, you would see the log file.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"These are my opinions and usual disclaimers apply"


   
   
[EMAIL PROTECTED]   
   
Sent by: To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
root@fatcity.cc:   
   
com  Subject: listner.log cannot be generated  
   
   
   
   
   
02/13/01   
   
02:29 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   






Hi list,

About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though
i did
 not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one
month
 period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
  extproc   has 1 service handler(s)
  idms  has 1 service handler(s)
  orac  has 3 service handler(s)
  tsp   has 1 service handler(s)
  vign  has 2 service handler(s)
The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.


nnidb1:/export/home/oracle@orac> cd
/u01/app/oracle/product/8.0.5/network/log
nnidb1:/u01/app/oracle/product/8.0.5/network/log@orac> ls -laF
total 4488
drwxr-xr-x   4 oracle   dba  512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba  512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba  512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba  512 Jan  5 09:57 2001/
-rw-rw-rw-   1 oracle   dba0 Jan  5 14:24 listener.log
-rw-rw-rw-   1 oracle   dba  2278569 Jan 23 09:55 sqlnet.log


Will someone in the list enlight me?

Thanks

Eveleen


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

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

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




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

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

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

SQL Text

[Sanjay Kumar]

hi,
 
I want to see the latest SQL Statements that I sent 
to Database. I know that I can make use of V$sqlarea but it restricts only 
to first 1000 characters.
But my query is more than that.
 
Any help.
 
Sanjay

RE: SQL Text

[Reardon, Bruce (CALBBAY)]

Hi Sanjay,

Try the following:

-- this one will be faster but only shows the first 1000 characters of the
SQL

select username, q.* 
from
   v$session s , v$sql q
where
  q.address = s . sql_address
   and q.hash_value = s.SQL_HASH_VALUE
   and s.username = 'user'
;


-- this will get the FULL SQL being executed.

select   a.address, 
   a.buffer_gets, 
   a.executions, 
   b.piece, 
   b.sql_text 
from  v$sqlarea a, v$sqltext b , v$session s
where a.ADDRESS = b.ADDRESS 
and   a.HASH_VALUE = b.HASH_VALUE 
and   a.hash_value = s.sql_hash_value
and   s.sid=&sidd
order by 1,4; 


-- an example of more detail for whole instance

select   a.address, 
   a.buffer_gets, 
   a.executions, 
   buffer_gets/executions, 
   b.piece, 
   b.sql_text 
from  v$sqlarea a, v$sqltext b 
where executions > 0 
and a.ADDRESS = b.ADDRESS 
and   a.HASH_VALUE = b.HASH_VALUE 
order by 1,5; 

Regards,
Bruce

-Original Message-
Sent: Wednesday, 14 February 2001 10:31
hi,
I want to see the latest SQL Statements that I sent to Database. I know that
I can make use of V$sqlarea but it restricts only to first 1000 characters.
But my query is more than that.
Any help.
Sanjay
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

Urgent! Change Character Set from WE8IS088591 to UTF8

[Larry Taylor]

I have a 8.1.6.0.0 database.

What is the best way to change Character Set from WE8ISO8859P1 to UTF8

 from: 
NLS_CHARACTERSET WE8ISO8859P1   

To:
NLS_CHARACTERSET UTF8  

Thanks

Larry



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

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

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

Degree of Parallelism: 0?

[Koivu, Lisa]

Title: Degree of Parallelism:  0?





Hello all, 


I've purposely got PQO off.  But I was shocked to see I've got some parallel query slaves out there.  I checked to see which objects they are, listed below.  I'm not concerned about the sys/system stuff, I"m worried about CTX (my intermedia text stuff.)  Can anyone tell me exactly what DEGREE = 0 is??  I don't see it in the doco. 

Thanks



  1  select owner, index_name, table_name, degree
  2  from dba_indexes
  3* where degree <> 1
SQL> /


OWNER  INDEX_NAME TABLE_NAME DEGREE
-- -- -- ---
SYS    SYS_IL000261C2$$   KOTTD$ 0
SYS    SYS_IL000265C2$$   KOTTB$ 0
SYS    SYS_IL000269C2$$   KOTAD$ 0
SYS    SYS_IL000273C2$$   KOTMD$ 0
SYSTEM SYS_IL002316C00012$$   AQ$_QUEUES 0
SYSTEM SYS_IL002462C00025$$   DEF$_AQCALL    0
SYSTEM SYS_IL002472C00025$$   DEF$_AQERROR   0
SYSTEM SYS_IL002490C5$$   DEF$_LOB   0
SYSTEM SYS_IL002490C4$$   DEF$_LOB   0
SYSTEM SYS_IL002490C3$$   DEF$_LOB   0
SYSTEM SYS_IL002499C3$$   DEF$_TEMP$LOB  0
SYSTEM SYS_IL002499C2$$   DEF$_TEMP$LOB  0
SYSTEM SYS_IL002499C1$$   DEF$_TEMP$LOB  0
SYSTEM SYS_IL003112C5$$   REPCAT$_TEMPLATE_OBJECTS   0
SYSTEM SYS_IL003125C4$$   REPCAT$_TEMPLATE_PARMS 0
SYSTEM SYS_IL003139C4$$   REPCAT$_USER_PARM_VALUES   0
SYSTEM SYS_IL003162C3$$   REPCAT$_RUNTIME_PARMS  0
CTXSYS SYS_IL076392C2$$   DR$STATS   0
QODE_APP   SYS_IL014135C2$$   CREATE$JAVA$LOB$TABLE  0
SYS    SYS_IL056091C3$$   AURORA$SNS$ATTRIBUTES$ 0
QODE_BC    SYS_IL093690C6$$   DR$CTX_MFG_SEARCH$I    0
QODE_BC    SYS_IL093695C2$$   DR$CTX_MFG_SEARCH$R    0
QODE_BC    SYS_IL140689C6$$   DR$CTX_CAT_SEARCH$I    0
QODE_BC    SYS_IL140694C2$$   DR$CTX_CAT_SEARCH$R    0
QODE_BC    SYS_IL143153C6$$   DR$CTX_PRODUCT_SEARCH$I    0
QODE_BC    SYS_IL143158C2$$   DR$CTX_PRODUCT_SEARCH$R    0


26 rows selected.


SQL> 


26 rows selected.


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com


"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

RE: Oracle vs MS Access

[David Barbour]

Please try to be gentle with this soul.

Maria -

Access should not even be on your short list.  The underlying architecture
is not designed for simultaneous use by multiple sessions.  What type of
"web database" application(s) will you be creating?  How many concurrent
users do you expect for each application?  How much data will you need to
store/query per transaction?  What webserver will you be using?  On what
platform will the webserver and database be running?  How much data will you
be storing overall?  Will the different databases need to exchange
information?  What type of availability is required?  What is your budget?
What capability/capacity do you have to support the database?  

These are only a couple of general questions, but I'm hoping you are
beginning to understand that database selection is a pretty
thought-provoking exercise.

You cannot compare Access and Oracle, they're sort of like Matchbox toys and
Caterpillar trucks.  One is used by children to move grains of sand, the
other is used by knowledgeable adults and has the capability of hauling
boulders.

You might start by looking at some of the comparisons available at:
http://sqlexperts.aspcode.net/datcomp.asp

I'm sure others will weigh in with more sagacious advice.   Good Luck.




David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, February 13, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


We are developing web database standards in my workplace.  I need to
identify advantages/disadvantages of using Oracle verses MS Access for web
databases.

Does anyone know of any good resources for gathering this info (web sites,
articles, etc)?  Any help would be greatly appreciated.

Thanks Maria

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

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

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

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

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

[???]

try this.
select * from emp a
where 20 > (select count(*) from emp b
where  a.sal < b.sal);

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Suhen Pather
Sent: Wednesday, February 14, 2001 7:33 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: top n or top n%


Leslie,

Try using a rownum.

select * from emp
where rownum<20
order by sal;

HTH
Suhen


Hi listers,

I remeber vaguely there is a way to select top n or
top % rows of a select statement.  But I cannot find
it anywhere.  Could somebody let me know?  Thank you.

Leslie

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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).•æ¬zǞ¶¨}øœ‰©ND‹±@Bm§ÿðÃ
+iöªr‰€ºØh¬ƒDNXì_]­æ¦Æw­«BŠÜzÜ(®Dž®øœzÏ9óüçNuüçÎwó9Õ&§'  &¥‰ú+ž&¹¹bp‰íz¹Þµ§zË?1¨¥ŠxŠËlN„D0åDʋ«±é_~º&¶¬™¨¥Šx%ŠËlzwZœCŠYž²Æ zÚŠËFº»Ÿj×"·'(šz-xEÀ
+   ;)zYbž
.+-êîjwbžØ^™ë,j86"Énu楊wœ¢{ZŠx§CRP‘"Ä.Ší…éڙꙨ¥Šx%ŠËr¢ìžÛhmêޚ‹Þuú虊.™¬š–Ê,zwm…áÄ,÷(šf§uú+¢Ø^®)ߢ¹š¶*'–)²æìr¸›Šx

Help optimize statement

[adm-unix]

Hello,

 I have this user statement below which is very long in a 8.1.6.2
database.
Any ideas to optimize it is wellcome.

Best Regards
Philippe

**
SELECT
  PLT_LISTE_DES_AGENTS_PL97.SEXE,
  PLT_FORMATION_AGENT_PL74.PL0PL009_COLLEGE,
  count(PLT_FORMATION_AGENT_PL74.PL97_MATRICULE),
  PLT_FORMATION_AGENT_PL74.DUR_TOT
FROM
  PLT_LISTE_DES_AGENTS_PL97,
  PLT_FORMATION_AGENT_PL74,
  PLT_FORMATION_ACTION_PL73
WHERE
  (PLT_LISTE_DES_AGENTS_PL97.MATRICULE = PLT_FORMATION_AGENT_PL74.PL97_MATRICULE)
  AND (PLT_FORMATION_ACTION_PL73.ACTION = PLT_FORMATION_AGENT_PL74.PL73_ACTION and
  PLT_FORMATION_ACTION_PL73.INDICE = PLT_FORMATION_AGENT_PL74.PL73_INDICE)
  AND  (
  PLT_LISTE_DES_AGENTS_PL97.SEXE  =  'M'
  AND  PLT_FORMATION_AGENT_PL74.COD_STAGIAIRE  =  'O'   ((INDEX CREATED)
  AND  PLT_FORMATION_ACTION_PL73.NO_ACTION  LIKE  'F0%'  ((PRIMARY KEY°
  )
GROUP BY
  PLT_LISTE_DES_AGENTS_PL97.SEXE,
  PLT_FORMATION_AGENT_PL74.PL0PL009_COLLEGE,
  PLT_FORMATION_AGENT_PL74.DUR_TOT
ORDER BY
  PLT_LISTE_DES_AGENTS_PL97.SEXE,
  PLT_FORMATION_AGENT_PL74.PL0PL009_COLLEGE
/

explain plan :**
STATEMENT=MRrepFor  TIMESTAMP= 12/02/01
OPERATION=SORT  OPTION=  ORDER BY



  ID=  1   parentID=   0POSITION=  1

MRrepFor   12/02/01

SORT   GROUP BY



2  1  1


MRrepFor   12/02/01
NESTED LOOPS




3  2  1

MRrepFor   12/02/01
NESTED LOOPS




4  3  1


MRrepFor   12/02/01
TABLE ACCESS   FULL

OBJECTOWNER=BOCONFID  OBJECTNAME= PLT_FORMATION_AGENT_PL74 
2


5  4  1

MRrepFor   12/02/01
TABLE ACCESS   BY INDEX ROWID

BOCONFID   PLT_LISTE_DES_AGENTS_PL971


6  4  2



MRrepFor   12/02/01
INDEX  UNIQUE SCAN

BOCONFID   PL97_PKUNIQUE

7  6  1



MRrepFor   12/02/01
TABLE ACCESS   BY INDEX ROWID

BOCONFID   PLT_FORMATION_ACTION_PL733

8  3  2


MRrepFor   12/02/01
INDEX  RANGE SCAN

BOCONFID   PL73_PKUNIQUE

9  8  1



MRrepFor   12/02/01
SELECT STATEMENT


CHOOSE
0

--
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: Problems with database link - 8.1.6

[Keith Shum]

Hello, Manas,

I think it's about the GLOBAL_NAME init parameter on the server
site.
Check to see if you have GLOBAL_NAME set to TRUE where PROD points
to.
Be very careful about GLOBAL_NAME, coz when it set to be TRUE, then
you are using DB_NAME.DB_DOMAIN instead of just the DB_NAME.
Hope it helps!

Yours,

Keith Shum   

[EMAIL PROTECTED]

iLux Corporation
Phone (510) 226-5600 x 643
Fax (510) 226-8182
Cellular Phone (510) 435-0286
5600 Mowry School Road, Newark, CA 94560
http://www.iLux.com


-Original Message-
Sent: Tuesday, February 13, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


Hi:

I'm having problems setting up and using database link.
My create statement looks as follows:
create database link PROD connect to xuser identified by xpwd using
'TRNGPROD';

I then execute :
select * from sysadm.employees@PROD.
and get the following error:
ORA-12154: TNS:could not resolve service name

However I can connect to TRNGPROD from SQLPlus.

What am I doing wrong?

TIA,
Manas.


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

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

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

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

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

Re: SQL Text

[Gregory Conron]

On Tue, 13 Feb 2001, Sanjay Kumar wrote:
> 
> hi,
> 
> I want to see the latest SQL Statements that I sent to Database. I know that I can 
>make use of V$sqlarea but it restricts only to first 1000 characters.
> But my query is more than that.

Use v$sqltext or v$sqltext_with_newlines. Simple join against v$session will
give you the sql for any current user.

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

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

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

RE: A Solaris question on memory usage

[Nguyen, Long]

Thanks David. You are right, I did not notice that the private figure
actually included the SGA size as well.

Regards
Long

-Original Message-
Sent: Thursday, 8 February 2001 7:55 PM
To: Multiple recipients of list ORACLE-L


Long

pmap seems to include portions of the SGA in the Private and Resident
columns, not the Shared one.  On solaris, this shows up as a line with
(shmid=0x...) in the Mapped File column.  To get a more sensible memory
usage, I suppose that you would have to subtract these from total (the size
is different for background and user processes ) and then add the size of
the SGA once.

Regards
David Lord

-Original Message-
Sent: 08 February 2001 04:35
To: Multiple recipients of list ORACLE-L


Good day,

I am looking at how Oracle and other applications running on a Solaris 2.6
server are using memory. The server has 512 MB of RAM. I issued the
"/usr/proc/bin/pmap $pid" command to display memory usage info and used the
figure from the "total KB" line of the output (the last line of the output).
When I add up the figures for all Oracle processes the sum of the Private
areas for all Oracle processes on teh system is 1.5 GB. I do not understand
this. How can this be greater than the physical RAM amount (which is 512
MB)? As I understand the Private amount is the Resident amount less the
Shared amount, so the Private amount for a process would be the physical
memory amount used exclusive by the process and not shared with other
processes.

If you could help me to understand more about this stuff, very much
appreciate.

I am trying to see if we need to up the RAM on the system.

Thanks
Long


-Original Message-
Sent: Thursday, 21 December 2000 3:13 AM
To: Multiple recipients of list ORACLE-L


In a query I found the total no of blocks used ,total size
,minextents,maxextents ,empty blocks of  a table.

But In index i am unable to find free / Empty blocks .

but i find leaf blovks ,avg no. of leaf blocks .

Please tell me how can I found free or empty  blocks of a Index.

Regards,
Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

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

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

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

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

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