date:20010622


I wanted to say : I feel the statement: "Oracle does not let NT manage VM"
is not a
correct statement.

-Original Message-
Sent: Friday, June 22, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L


I do not feel the statement: "Oracle does not let NT manage VM" is not a
correct statement.

I'm not an NT expert but I believe that Oracle on NT is like any WINDOWS 32
application that allocates memory through OS which is NT.


If you have anything that proves otherwise please let's know.

Regards,


Waleed



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


I am starting to think that it is a memory leak, it's just to huge to be
anything else.  I will calculate the size of the tables, that will be the
best sign of whats happening.
Interesting point, which I am sure everyone knows already, is that
Oracle
does not let NT manage VM, it takes care of it itself.  My question would
be, how does it know how much to use?  I mean, will it just keep sucking up
disk space for VM and bring the machine down?  Stick to DB's Oracle, leave
VMM to OS people:)
Thanks for the advice:)
Kev

-Original Message-
Waleed
Sent: Thursday, June 21, 2001 7:03 PM
To: Multiple recipients of list ORACLE-L


The amount of memory (Virtual) that is used is proportional to the size of
PL/SQL table.
There is no solution for this b/c it's perfectly normal except that the
amount of used memory is huge in comparison to the maximum amount of data in
the table which could be a memory leak.

You could estimate the size of data inserted into this PL/SQL table.

If it's correct then the design should change to using global (or even
regular) temporary tables or change the logic to use cursors
that will split your job.

Regards,


Waleed



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


Hi all,
I have a procedure that seems to be bringing my server to it's
knees.
Winnt, Oracle 817 (Pipe down Ross:))
Anyway, what happens is a pl/sql table is placed into memory and then later
on it will be written to the disk.  However, by the time the process is
about to get to the writing part the machine is dead.  The Oracle.exe
process is well over 700MBs and the Virtual Memory is over a gig and a
half!!  Is there anyway for me to limit this, I tried using the registry
entry ORA_WORKINGSETMAX, however that doesn't seem to work.  Has anyone used
this setting?  Are you just supposed to put a number in the entry?  I put
600 but nothing happens.  Any help would be greatly appreciated.


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

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

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

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

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

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

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

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

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

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

To REMOVE yourself from thi

Re: TRUNCATE IN PL/SQL

2001-06-22 Thread Gregory Conron


On June 21, 2001 10:36 am, Rachel Carmichael wrote:
> anyone who has "delete any table" can truncate.

isn't it 'drop any table'?

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:




With these commands:

from your PC:

  telnet -l oracle 

After you are logged in, and assuming the Oracle environment
is already set up:

   view $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log

HTH

Jared



   
 
"Tulika  Samrendra"
 
  
fmail.com> cc: 
 
Sent by:   Subject:
 
[EMAIL PROTECTED]   
 
   
 
   
 
06/22/01 04:58 PM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




how can i read the alert file of my oracle 8i database
insttalled on hp-ux system

_
Buy Lagaan & Yaadein music for 30% less.
Avail this special offer at
http://shopping.rediff.com/shopping/music/offerrediffmailer.htm



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

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

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


Never surrender! use:  select c1 from median  group by c1,rownum
in the inner query!

Regards,

Waleed

-Original Message-
Sent: Friday, June 22, 2001 7:58 PM
To: Multiple recipients of list ORACLE-L


Fraid group by will not work either  it removes the duplicate rows and
changes the median.

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


You can replace the order by BY group by.
Group by does an implicit sort.

Regards,

Waleed

-Original Message-
Sent: Friday, June 22, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Waleed;
  Well, I am afraid, its not going to be this simple on my version of
Oracle, 8.0.5.   Apparently, you can not do an order by in the from
statement on this version so I can not get the crucial order of the data.

Thanks anyway.  I may have to resort to an pl/sql function.

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


What about this:
SQL> create table median ( c1 number );

Table created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (3);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
3

SQL> 
SQL> 
SQL> insert into median values (6);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
4

Regards,

Waleed



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


Does anyone have a handy function for calculating the Median of data ??  It
seems like it should be simple ...but

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


Thank you Jeremiah

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


This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:

strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
sort | uniq

The typical location for underscore parameters is x$ksppi:

(as SYS:)
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';

The event codes (most of them) are documented in
$ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 21 Jun 2001, Kevin Lange wrote:

>   Is there any place that has a list of ALL the things you can put into
the
> Init file and what they do ??   Not just the regular  option strings I
> can get a list of these from a couple of web sites , but all of the hidden
,
> and as far as I know, undocumented EVENT strings as well??

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

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

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

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

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

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

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

RE: Deadlock Detection


Did you check bug 1328999  if it applicable in your case.

Regards,

Waleed

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


All,

My current application (still under development) is experiencing Oracle
deadlock problems.  The applications people are performing stress testing
where the application is being repeatedly called simulating actual users
hitting the database.

The application is written using VB thru ADO and COM, Oracle 816 on NT.

My problem is that, while I can review the trace file produced, I can't
figure out what the actual deadlock is occurring on.  I have seen deadlock
trace files that clearly state "table blah", but in this case, I get:


*** 2001-06-21 14:32:03.841
*** SESSION ID:(27.31211) 2001-06-21 14:32:03.810
DEADLOCK DETECTED
Deadlock graph:
   -Blocker(s)
-Waiter(s)-
Resource Name  process session holds waits  process session holds
waits
DX-003b-22  18 X 24  27
X
session 18: DID 0001-0018-003C  session 27: DID 0001-0018-003C
Rows waited on:
Session 27: no row
*** 2001-06-21 14:32:03.857
ksedmp: internal or fatal error
ORA-00060: deadlock detected while waiting for resource

Is there something like TKPROF that will process the trace file and give me
more info on what is happening?  It looks like I am waiting for a resource
to be freed, but which one is the question.

thanks for any help.

Tom Mercadante
Oracle Certified Professional

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

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

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

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

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

2001-06-22 Thread Paul Drake


Anita,

It must be a lack of sleep thing. :)

Paul

-Original Message-
Sent: Friday, June 22, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L


Riyaj,

Doh!  My bad.  I completely missed the DX.  You are
absolutely correct that what I wrote is applicable
only to TX locks.

Thanks for catching it.

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

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

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

No Subject

2001-06-22 Thread Tulika Samrendra


how can i read the alert file of my oracle 8i database
insttalled on hp-ux system 

_
Buy Lagaan & Yaadein music for 30% less.
Avail this special offer at 
http://shopping.rediff.com/shopping/music/offerrediffmailer.htm 



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

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

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

2001-06-22 Thread Kevin Lange


Fraid group by will not work either  it removes the duplicate rows and
changes the median.

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


You can replace the order by BY group by.
Group by does an implicit sort.

Regards,

Waleed

-Original Message-
Sent: Friday, June 22, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Waleed;
  Well, I am afraid, its not going to be this simple on my version of
Oracle, 8.0.5.   Apparently, you can not do an order by in the from
statement on this version so I can not get the crucial order of the data.

Thanks anyway.  I may have to resort to an pl/sql function.

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


What about this:
SQL> create table median ( c1 number );

Table created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (3);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
3

SQL> 
SQL> 
SQL> insert into median values (6);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
4

Regards,

Waleed



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


Does anyone have a handy function for calculating the Median of data ??  It
seems like it should be simple ...but

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


Thank you Jeremiah

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


This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:

strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
sort | uniq

The typical location for underscore parameters is x$ksppi:

(as SYS:)
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';

The event codes (most of them) are documented in
$ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 21 Jun 2001, Kevin Lange wrote:

>   Is there any place that has a list of ALL the things you can put into
the
> Init file and what they do ??   Not just the regular  option strings I
> can get a list of these from a couple of web sites , but all of the hidden
,
> and as far as I know, undocumented EVENT strings as well??

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

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

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

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

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

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

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

Re: Deadlock Detection

2001-06-22 Thread A. Bardeen


Riyaj,

Doh!  My bad.  I completely missed the DX.  You are
absolutely correct that what I wrote is applicable
only to TX locks.

Thanks for catching it.

-- Anita

--- [EMAIL PROTECTED] wrote:
> Hi Anita
> If it is an ITL problem, then the resource
> type would be TX 
> instead of DX. If the ITL table is full then the
> process requesting an ITL 
> entry in that block will randomly select one of the
> transaction holding an 
> ITL entry and wait for that process to complete or
> rollback. Since the 
> process will wait for a transaction and as you are
> well aware of, the 
> transaction id is a slot in a rollback segment and
> hence the enqueue type 
> would be TX. Since this trace indicates that it is a
> DX type enqueue I 
> would incline to think that this is a distributed
> transaction problem. 
> Feel free to correct me if I am missing something..
> 
> Thanks
> Riyaj "Re-yas" Shamsudeen
> Certified Oracle DBA
> i2 technologies   www.i2.com
> 
> 
> 
> 
> "A. Bardeen" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/22/01 10:50 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re: Deadlock Detection
> 
> 
> Tom,
> 
> The information you need should be in the trace
> file,
> but it's not in the excerpt you've listed, but the
> true problem is listed:
> 
> > Rows waited on:
> > Session 27: no row
> 
> "No row" indicates that the deadlock is due to a
> lack
> of available ITL slots in the datablock.
> 
> Unfortunately resolving this requires recreating the
> object with either a high initrans value (to
> explicitly reserve space for more ITL slots) or a
> higher pctfree value (to give the ITL table more
> room
> to grow).
> 
> Depending on the application it could also be that
> multiple sessions are acquiring the same block off
> the
> free list so using multiple free lists could also
> help.  Starting with 8.1.6 this setting can be
> changed
> dynamically; prior to that you must recreate the
> object.
> 
> Note: 62365.1 also has some good info
> 
> HTH,
> 
> -- Anita
> 
> --- "Mercadante, Thomas F"
> <[EMAIL PROTECTED]>
> wrote:
> > All,
> > 
> > My current application (still under development)
> is
> > experiencing Oracle
> > deadlock problems.  The applications people are
> > performing stress testing
> > where the application is being repeatedly called
> > simulating actual users
> > hitting the database.
> > 
> > The application is written using VB thru ADO and
> > COM, Oracle 816 on NT.
> > 
> > My problem is that, while I can review the trace
> > file produced, I can't
> > figure out what the actual deadlock is occurring
> on.
> >  I have seen deadlock
> > trace files that clearly state "table blah", but
> in
> > this case, I get:
> > 
> > 
> > *** 2001-06-21 14:32:03.841
> > *** SESSION ID:(27.31211) 2001-06-21 14:32:03.810
> > DEADLOCK DETECTED
> > Deadlock graph:
> >-Blocker(s)
> > -Waiter(s)-
> > Resource Name  process session holds waits
> 
> > process session holds
> > waits
> > DX-003b-22  18 X 
> > 24  27
> > X
> > session 18: DID 0001-0018-003C
> session 27: DID
> > 0001-0018-003C
> > Rows waited on:
> > Session 27: no row
> > *** 2001-06-21 14:32:03.857
> > ksedmp: internal or fatal error
> > ORA-00060: deadlock detected while waiting for
> > resource
> > 
> > Is there something like TKPROF that will process
> the
> > trace file and give me
> > more info on what is happening?  It looks like I
> am
> > waiting for a resource
> > to be freed, but which one is the question.
> > 
> > thanks for any help.
> > 
> > Tom Mercadante
> > Oracle Certified Professional
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Mercadante, Thomas F
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

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

RE: Limiting Oracle Memory


I do not feel the statement: "Oracle does not let NT manage VM" is not a
correct statement.

I'm not an NT expert but I believe that Oracle on NT is like any WINDOWS 32
application that allocates memory through OS which is NT.


If you have anything that proves otherwise please let's know.

Regards,


Waleed



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


I am starting to think that it is a memory leak, it's just to huge to be
anything else.  I will calculate the size of the tables, that will be the
best sign of whats happening.
Interesting point, which I am sure everyone knows already, is that
Oracle
does not let NT manage VM, it takes care of it itself.  My question would
be, how does it know how much to use?  I mean, will it just keep sucking up
disk space for VM and bring the machine down?  Stick to DB's Oracle, leave
VMM to OS people:)
Thanks for the advice:)
Kev

-Original Message-
Waleed
Sent: Thursday, June 21, 2001 7:03 PM
To: Multiple recipients of list ORACLE-L


The amount of memory (Virtual) that is used is proportional to the size of
PL/SQL table.
There is no solution for this b/c it's perfectly normal except that the
amount of used memory is huge in comparison to the maximum amount of data in
the table which could be a memory leak.

You could estimate the size of data inserted into this PL/SQL table.

If it's correct then the design should change to using global (or even
regular) temporary tables or change the logic to use cursors
that will split your job.

Regards,


Waleed



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


Hi all,
I have a procedure that seems to be bringing my server to it's
knees.
Winnt, Oracle 817 (Pipe down Ross:))
Anyway, what happens is a pl/sql table is placed into memory and then later
on it will be written to the disk.  However, by the time the process is
about to get to the writing part the machine is dead.  The Oracle.exe
process is well over 700MBs and the Virtual Memory is over a gig and a
half!!  Is there anyway for me to limit this, I tried using the registry
entry ORA_WORKINGSETMAX, however that doesn't seem to work.  Has anyone used
this setting?  Are you just supposed to put a number in the entry?  I put
600 but nothing happens.  Any help would be greatly appreciated.


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

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

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

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

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

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

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

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

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

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

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

RE: Security. Is YOUR machine on this list?

2001-06-22 Thread Post, Ethan


Read that yesterday, that is a great article. - E

-Original Message-
Sent: Friday, June 22, 2001 3:34 PM
To: Multiple recipients of list ORACLE-L



http://grc.com/dos/attacklog.htm
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

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

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


Scott, Scott, Scott, 

If Bill doesn't catch this, someone else will:

it's  DBMS_PIPE.DOWN('Bill');



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 5:58 PM
To: Multiple recipients of list ORACLE-L


All right, Bill.  Pipe down and go play with your thermite!;-P

Scott Shafer
San Antonio, TX
210-581-6217

"Do not throw cigarette butts in the urinal.  It makes them soggy and hard
to light."

PS -- for the humor impaired or non native english speaker - THIS IS A
FRIENDLY JOKE.


> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 4:27 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT: trimming the replies
> 
> OK, Ladies and Geltlemen, i have noticed that many of you are replying MS
> style
> at the top of the message.  that's fine except nobody is trimming off the
> message after replying so they keep getting longer and longer.  this will
> cause
> problems for many people when the length reaches certin limits, as well as
> taking longer to download.
> 
> i respectfully request that you trim the messages after you finish
> replying.
> 
> thank you and we now return you to your regularly scheduled guru
> sessions.;-)
> 
> 
> --
> Bill "Shrek" Thater   Certifiable ORACLE DBA
> Telergy, Inc.[EMAIL PROTECTED]
> ~~
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> ~~
> Do you like me for my brain or my baud?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thater, William
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: exp performance question ( direct=y)

2001-06-22 Thread Mohammad Rafiq


Please check export parameter RECORDLENGTH and try export with maximum
allowable limit of your OS system with direct=y . On some OS limit is 65535 
and see if it improves export time..
Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 22 Jun 2001 13:06:07 -0800

Thanks to all who helped me get a clear understanding of the direct=Y option 
for the exp utility.
I feel good, it is Friday and I have learned something today.
ROR mô¿ôm

 >>> [EMAIL PROTECTED] 06/22/01 04:44PM >>>
No, direct only effects two things, the way oracle exports the data
(avoiding character conversions and buffering) and the format of the file.
The size and import speed of the export are effect only but .0001% or so.
Basically insignificant.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Friday, June 22, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


I thought that DIRECT=Y was for imports only. It makes since because in the
import you are placing the data directly into the blocks with out a redo
log.
  I have no idea why there was a difference in the times unless it was the
extra overhead for a command that was not used.
ROR mª¿ªm

 >>> [EMAIL PROTECTED] 06/22/01 12:55PM >>>
Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I
changed the setting "direct" to "y" two days ago while leaving all other
parameters unchanged, hoping to gain some performance. I am a bit surprused
to find that it did not. It actually took longer to create dump file with
less data to export. The whole exp process takes about 2 hours to finish.
Yes, there could be lots of other unix processes running during that time.
But I would still expect to see some improvement because we are doing this
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
   INET: [EMAIL PROTECTED]

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

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

RE: Using Recovery Catalog with RMAN

2001-06-22 Thread Glasrot, Nechama


hi ...
we keep the rman database on a separate server, and back it up to one of the
servers that has the database ... hth

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 
nglasrot @seisint.com   
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
 


-Original Message-
Sent: Friday, June 22, 2001 6:11 PM
To: Multiple recipients of list ORACLE-L


Solaris 2.6
Oracle 8.1.6

What are some practical ways that people have came up with to protect the
RMAN recovery catalog? We have the catalog in a separate database on the
same box as the database we are wanting to backup. The situation came up
recently where the all three control files for both databases were corrupted
by an attempted OS upgrade. So we could not bring up the database that
contained the Recovery Catalog. How are people approaching the backup of the
database which contains the Recovery Catalog?

All input is appreciated

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


This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you


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

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

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

2001-06-22 Thread Scott . Shafer


My humble apologies Oh Great Ross!  Forever I am in your shadow...



Scott Shafer
San Antonio, TX
210-581-6217

"Do not throw cigarette butts in the urinal.  It makes them soggy and hard
to light."

> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 5:34 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: trimming the replies
> 
> Scott, Scott, Scott, 
> 
> If Bill doesn't catch this, someone else will:
> 
> it's  DBMS_PIPE.DOWN('Bill');
> 
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 5:58 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> All right, Bill.  Pipe down and go play with your thermite!;-P
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> "Do not throw cigarette butts in the urinal.  It makes them soggy and hard
> to light."
> 
> PS -- for the humor impaired or non native english speaker - THIS IS A
> FRIENDLY JOKE.
> 
> 
> > -Original Message-
> > From:   Thater, William [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, June 22, 2001 4:27 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:OT: trimming the replies
> > 
> > OK, Ladies and Geltlemen, i have noticed that many of you are replying
> MS
> > style
> > at the top of the message.  that's fine except nobody is trimming off
> the
> > message after replying so they keep getting longer and longer.  this
> will
> > cause
> > problems for many people when the length reaches certin limits, as well
> as
> > taking longer to download.
> > 
> > i respectfully request that you trim the messages after you finish
> > replying.
> > 
> > thank you and we now return you to your regularly scheduled guru
> > sessions.;-)
> > 
> > 
> > --
> > Bill "Shrek" Thater   Certifiable ORACLE DBA
> > Telergy, Inc.[EMAIL PROTECTED]
> > ~~
> > You gotta program like you don't need the money,
> > You gotta compile like you'll never get hurt,
> > You gotta run like there's nobody watching,
> > It's gotta come from the heart if you want it to work.
> > ~~
> > Do you like me for my brain or my baud?
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Thater, William
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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


Hi
        One of our developers are planning to migrate from 32 bit OCI to 64 bit OCI. Have any of you encountered any issues with that ? How much performance improvement can we expect ?
        
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

OT: Security. Is YOUR machine on this list?



http://grc.com/dos/attacklog.htm
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

Multiple Oracle Listener Denial of Service Vulnerabilities

2001-06-22 Thread Wolfe, Charles


FYI.

http://xforce.iss.net/alerts/advise82.php

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

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

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

Buffer Cache Lists and DBWR

2001-06-22 Thread Pablo ksksksk


Hi List,
I'd just like to know exactly how many lists are there
in the SGA to administrate the buffer cache? (LRUW,
LRU, hash chain list, etc)

And how they are used by the DBWR.

thanks a lot.

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
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: exp performance question ( direct=y)

2001-06-22 Thread Deshpande, Kirti


Here are some numbers from my testing of various options for exp and imp... 
Table had 4.9 Mil rows. Oracle 8.1.7 on AIX 4.3.3. Time is average from 3
attempts. 
Exporting the table: 
Conventional (without any options)  412.81sec   
  recordlength=16384399.65sec   recordlength is set to the value of
DB_BLOCK_SIZE
  buffer=1048576251.79sec   
  buffer=1048576 recordlength=16384248.75secrecordlength is set to
the value of DB_BLOCK_SIZE
  buffer=1048576 recordlength=65535   235.38sec   recordlength is set to the
maximum value for the platform
  direct=y  66.20sec
  direct=y recordlength=16384   51.85sec  recordlength is set to the
value of DB_BLOCK_SIZE
  direct=y recordlength=65535 45.60sec  recordlength is set to the
maximum value for the platform 
Importing the same table (Table had no PKEY constraints).
  commit=y indexes=n ignore=y   594.88sec   
  commit=y indexes=n ignore=y buffer=1048576  312.96sec Approximately 16,131
rows in the insert array
  commit=y indexes=n ignore=y buffer=5242880  289.55sec Approximately 80,860
rows in the insert array
  commit=y indexes=n ignore=y buffer=10485760 288.12sec Approximately
161,320 rows in the insert array

Hope this helps... 

Regards,


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

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 4:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: exp performance question ( direct=y)
> 
> I believe so. It may have a slightly different meaning.  Rows, commit, 
> these things act a little differently. (Is that not specific enough?)  And
> direct is an exp param, that greatly affects your imp. 
>  
> Statistics is another exp parameter that takes affect on import. The
> export puts a stats statement in the dump file, which imp finds and
> executes. I imagine direct works the same way. 
>  
> A quick test on a tiny table shows that conventional exp creates a
> dump file that's slightly bigger. Visually, in a text editor, both files
> look very much alike.
>  
> And the timing difference - for the export - was BIG. The conventional
> exported in 12 seconds, the direct was INSTANT, less than a second.
>  
> I've experienced the same on large tables, and I probably even have
> timings saved somewhere.
>  
> HTH,
>  
> Yosi
>  
>
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: Interest in an Oracle on Tru64 specific list?


Ray, 

Thanks for this, btw

Ross

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



http://www.ornl.gov/its/archives/mailing-lists/tru64-unix-managers/2001/06/m
sg00265.html
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

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

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

Using Recovery Catalog with RMAN

2001-06-22 Thread Donald Bricker


Solaris 2.6
Oracle 8.1.6

What are some practical ways that people have came up with to protect the RMAN 
recovery catalog? We have the catalog in a separate database on the same box as the 
database we are wanting to backup. The situation came up recently where the all three 
control files for both databases were corrupted by an attempted OS upgrade. So we 
could not bring up the database that contained the Recovery Catalog. How are people 
approaching the backup of the database which contains the Recovery Catalog?

All input is appreciated

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







Solaris 2.6
Oracle 8.1.6
 
What are some practical ways that people have came up with to 
protect the RMAN recovery catalog? We have the catalog in a separate database on 
the same box as the database we are wanting to backup. The situation came up 
recently where the all three control files for both databases were corrupted by 
an attempted OS upgrade. So we could not bring up the database that contained 
the Recovery Catalog. How are people approaching the backup of the database 
which contains the Recovery Catalog?
 
All input is appreciated
 
Don BrickerInformation Systems AnalystIllinois 
Environmental Protection Agency1021 North Grand Avenue EastMail Code 
#32Springfield, IL 62794-9276mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED](217)
 
558-2290

RE: exp performance question ( direct=y)




Don't you wish you 
could take back posts? (Jared, Bruce - how's that for
a 
feature!?)
 
Rows is SQL*Loader, 
not exp/imp. I mean it's exp/imp also, but it means
something else in 
Loader, and in Loader it differs for direct path. 
And I
meant Loader's 
bindsize also, not exp/imp's buffer. 
 
I mean... well never mind what I 
mean. Basically, ignore that first 
para-
graph. Read Chris' 
post, ignore mine, I've had it, and I'm outta here. It's
been a long week, 
and it's time for a weekend. 
 
Have a great one 
y'all.
 
y
 
 

  -Original Message-From: Yosi Sent: 
  Friday, June 22, 2001 5:19 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: exp performance question ( 
  direct=y)
  I believe so. It 
  may have a slightly different meaning.  Rows, commit, 

  these things act a 
  little differently. (Is that not specific enough?)  
  And
  direct is an exp 
  param, that greatly affects your imp. 
   
  Statistics 
  is another 
  exp 
  parameter that takes affect on import. 
  The
  export puts a 
  stats statement in the dump file, which imp finds and
  executes. I 
  imagine direct works the same way. 
   
  A quick test on a 
  tiny table shows that conventional exp creates a
  dump file that's 
  slightly bigger. Visually, in a text editor, both files
  look very much 
  alike.
   
  And the timing 
  difference - for the export - was BIG. The conventional
  exported 
  in 12 seconds, the direct was INSTANT, less than a 
  second.
   
  I've experienced 
  the same on large tables, and I probably even have
  timings saved 
  somewhere.
   
  HTH,
   
  Yosi
   
   
   -Original 
  Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 4:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  exp performance question ( direct=y)
  
I dunno. Does the BUFFER 
still matter when DIRECT=Y?
 
If so, I either remove it 
entirely, or multiply it by about a factor of five or so. 

 
my 
$0.02

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: exp performance question ( direct=y)
  Ron, 
   
  ok i'm now confused, 
   
  exp direct=n|y
  imp no such option
  sql_loader has direct also.
   
  or am i missing something here?
   
  joe
   
  >>> [EMAIL PROTECTED] 06/22/01 03:00PM 
  >>>I thought that DIRECT=Y was for imports only. It makes 
  since because in the import you are placing the data directly into the 
  blocks with out a redo log.I have no idea why there was a difference 
  in the times unless it was the extra overhead for a command that was not 
  used.ROR mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
  >>>Oracle : 8.0.5Platform : SunCurrently we 
  have cron job every night (starting from 11pm) to do export. I changed 
  the setting "direct" to "y" two days ago while leaving all other 
  parameters unchanged, hoping to gain some performance. I am a bit 
  surprused to find that it did not. It actually took longer to create 
  dump file with less data to export. The whole exp process takes about 
  2 hours to finish. Yes, there could be lots of other unix processes 
  running during that time. But I would still expect to see some 
  improvement because we are doing this way for quite a while. So my 
  questions are:1. From your "real" export experience, how much 
  performance boost did you see when you set "direct=y"?2. If 
  "direct=y" improves the performance, why would anyone want to use  
  "direct=n"?Thanks.Guang-- here is my orcle 
  dump file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, 
  dmp.4 and dmp.5 are from direct=n).-rw-rw-r--   1 
  mt   prog 
  1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
  mt   prog 
  1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
  mt   prog 
  1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
  mt   prog 
  1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
  mt   prog 
  1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
  file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
  YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
  YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS 
  = YUSERID = xxx/yyyOWNER = 
  (aaa,bbb)_Get 
  your FREE download of MSN Explorer at http://explorer.msn.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 
  538-5051San Diego, 
  California    -- Public Internet 
  access / Mailing

Re: OT: trimming the replies

2001-06-22 Thread Gene Sais


Agreed.  I also suggest ppl sign below their message, as it is difficult to detect who 
wrote what.  TGIF!  Hey, where's that recipe?

Gene Sais

>>> [EMAIL PROTECTED] 06/22/01 05:27PM >>>
OK, Ladies and Geltlemen, i have noticed that many of you are replying MS style
at the top of the message.  that's fine except nobody is trimming off the
message after replying so they keep getting longer and longer.  this will cause
problems for many people when the length reaches certin limits, as well as
taking longer to download.

i respectfully request that you trim the messages after you finish replying.

thank you and we now return you to your regularly scheduled guru sessions.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED] 
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

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

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

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

RE: exp performance question ( direct=y)

Title: RE: exp performance question ( direct=y)

But
Lisa, don't you think Chris posts too much, just like on
LazyDBA?

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 5:27
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
exp performance question ( direct=y)
Christopher, this is exactly why you
should keep posting no matter what they whiners say. Thanks for sending this to the list. I
learned something today.
Have a great weekend!
Lisa Koivu Ft. Lauderdale, FL, USA

-Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 22, 2001 4:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: exp performance question ( direct=y)
1) You can expect to see as much as 75%
performance gain on export. There is just about no performance gain on the import. The reason for
this is it avoids 3 copies and 2
character conversions when exporting the data. This is due to the conversion from column major to row major when
bringing in the buffers into the buffer
cache, then converting back to column major to handle the select. I would recomend looking at the recordlength
parameter as it has a good (1-4%) effect
on performance initially, but after 32k it generally has very little performance gain. During conventional
exports, recordlength can prove as much
as 6% performance gain. Ussually setting it to 32k is the best you will see.
One thing to know about exports is conventional
exports are cpu bound where as direct
exports are Io bound. But either will only use a fractional
portion of the cpu/io. Also note, if your
using consistent exports it will incur
locking as well as redo/rollback generation. So time for
exports cannot be 100% accurately
consistent.
Another thing is direct exports use as much as
65% less memory than conventional and
about 35% less cpu. Also direct exports tend to do a three
fold increase in io throughput over
conventional. You can ussually export a max export sustained speed of around 5-6% of max i/o.
2) Target, source, and client used to
export must be of the same character set
and you cannot export lobs.
This is perhaps more than you asked for, but
hopefully it helps.
"Walking on water and developing software from a
specification are easy if both are
frozen."
Christopher R. Spence Oracle DBA Fuelspot

-Original Message- Sent: Friday, June 22, 2001 12:56 PM To: Multiple recipients of list ORACLE-L
Oracle : 8.0.5 Platform : Sun
Currently we have cron job every night (starting
from 11pm) to do export. I changed the
setting "direct" to "y" two days ago while leaving all other
parameters unchanged, hoping to gain some
performance. I am a bit surprused to find
that it did not. It actually took longer to create dump file with
less data to export. The whole exp
process takes about 2 hours to finish. Yes, there could be lots of other unix processes running during that
time. But I would still expect to see
some improvement because we are doing this way for quite a while. So my questions are:
1. From your "real" export experience, how much
performance boost did you see when you
set "direct=y"?
2. If "direct=y" improves the performance, why
would anyone want to use "direct=n"?
Thanks.
Guang
-- here is my orcle dump file's time
stamp: (dmp.1 and dmp.2 are from
direct=y, dmp.3, dmp.4 and dmp.5 are from
direct=n).
-rw-rw-r-- 1
mt prog
1042197132 Jun 18 01:05 oracle.dmp.5.gz -rw-rw-r-- 1 mt
prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r-- 1
mt prog
1042556662 Jun 20 00:25 oracle.dmp.3.gz -rw-rw-r-- 1 mt
prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r-- 1
mt prog
1035237986 Jun 22 01:22 oracle.dmp.1.gz
--here is the parameter file: BUFFER = 64000 COMPRESS
= Y CONSISTENT = N CONSTRAINTS = Y DIRECT
= Y FILE =
/oracle/exports/oracle.dmp.pipe #FULL =
Y GRANTS = Y INDEXES = Y LOG =
/oracle/exports/export.log ROWS =
Y USERID = xxx/yyy OWNER = (aaa,bbb)
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang
Mei INET: [EMAIL PROTECTED]

Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 San Diego, California --
Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
an E-Mail message to:
[

OT: trimming the replies


I was going to start attaching an annotated copy of the 
oracle 817 binaries I got from Chris to every message, 
but now I don't think it's a very good idea. 



-Original Message-
Sent: Friday, June 22, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L


OK, Ladies and Geltlemen, i have noticed that many of you are replying MS
style
at the top of the message.  that's fine except nobody is trimming off the
message after replying so they keep getting longer and longer.  this will
cause
problems for many people when the length reaches certin limits, as well as
taking longer to download.

i respectfully request that you trim the messages after you finish replying.

thank you and we now return you to your regularly scheduled guru
sessions.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

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

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

RE: trimming the replies

2001-06-22 Thread Scott . Shafer


All right, Bill.  Pipe down and go play with your thermite!;-P

Scott Shafer
San Antonio, TX
210-581-6217

"Do not throw cigarette butts in the urinal.  It makes them soggy and hard
to light."

PS -- for the humor impaired or non native english speaker - THIS IS A
FRIENDLY JOKE.


> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 4:27 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT: trimming the replies
> 
> OK, Ladies and Geltlemen, i have noticed that many of you are replying MS
> style
> at the top of the message.  that's fine except nobody is trimming off the
> message after replying so they keep getting longer and longer.  this will
> cause
> problems for many people when the length reaches certin limits, as well as
> taking longer to download.
> 
> i respectfully request that you trim the messages after you finish
> replying.
> 
> thank you and we now return you to your regularly scheduled guru
> sessions.;-)
> 
> 
> --
> Bill "Shrek" Thater   Certifiable ORACLE DBA
> Telergy, Inc.[EMAIL PROTECTED]
> ~~
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> ~~
> Do you like me for my brain or my baud?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thater, William
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

OT: trimming the replies

2001-06-22 Thread Thater, William


OK, Ladies and Geltlemen, i have noticed that many of you are replying MS style
at the top of the message.  that's fine except nobody is trimming off the
message after replying so they keep getting longer and longer.  this will cause
problems for many people when the length reaches certin limits, as well as
taking longer to download.

i respectfully request that you trim the messages after you finish replying.

thank you and we now return you to your regularly scheduled guru sessions.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

RE: exp performance question ( direct=y)

Title: RE: exp performance question ( direct=y)

I took
his comment the wrong as it was something people complained about when I was on
LazyDBA.
I
don't think he meant anything negative by it.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 4:33
PMTo: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'Subject: RE: exp performance question (
direct=y)
Christopher, this is exactly why you
should keep posting no matter what they whiners say. Thanks for sending this to the list. I
learned something today.
Have a great weekend!
Lisa Koivu Ft. Lauderdale, FL, USA

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

RE: your mail - Forms & database roles - Thanks

2001-06-22 Thread Krishnan, Manjula R.


Thanks for the quick response. I can fix that easy enough.

Manjula

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/22/01 3:44 PM

On Fri, 22 Jun 2001,Krishnan, Manjula R. scribbled on the wall in
glitter...:

->Thanks Bill:
->
->So, how can we get around that situation. We only want users with
->insert/update access to the tables to be  able to write.
->
->Manjula

either rewrite the package so it doesn't write to the table, or don't
use that
package with the read only role.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

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

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

RE: exp performance question ( direct=y)

2001-06-22 Thread Koivu, Lisa

Title: RE: exp performance question ( direct=y)





Christopher, this is exactly why you should keep posting no matter what they whiners say. 
Thanks for sending this to the list.  I learned something today. 


Have a great weekend!
Lisa Koivu
Ft. Lauderdale, FL, USA


-Original Message-
From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, June 22, 2001 4:45 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: exp performance question ( direct=y)


1)  You can expect to see as much as 75% performance gain on export.  There
is just about no performance gain on the import.  The reason for this is it
avoids 3 copies and 2 character conversions when exporting the data. This is
due to the conversion from column major to row major when bringing in the
buffers into the buffer cache, then converting back to column major to
handle the select.  I would recomend looking at the recordlength parameter
as it has a good (1-4%) effect on performance initially, but after 32k it
generally has very little performance gain.  During conventional exports,
recordlength can prove as much as 6% performance gain.  Ussually setting it
to 32k is the best you will see.


One thing to know about exports is conventional exports are cpu bound where
as direct exports are Io bound.  But either will only use a fractional
portion of the cpu/io.  Also note, if your using consistent exports it will
incur locking as well as redo/rollback generation.  So time for exports
cannot be 100% accurately consistent.


Another thing is direct exports use as much as 65% less memory than
conventional and about 35% less cpu.  Also direct exports tend to do a three
fold increase in io throughput over conventional.  You can ussually export a
max export sustained speed of around 5-6% of max i/o.


2)  Target, source, and client used to export must be of the same character
set and you cannot export lobs.


This is perhaps more than you asked for, but hopefully it helps.


"Walking on water and developing software from a specification are easy if
both are frozen."


Christopher R. Spence
Oracle DBA
Fuelspot 




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



Oracle : 8.0.5
Platform : Sun



Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:


1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?


2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?


Thanks.


Guang


-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).


-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz



--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)


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


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


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

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


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

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

RE: exp performance question ( direct=y)




I believe so. It may 
have a slightly different meaning.  Rows, commit, 
these things act a 
little differently. (Is that not specific enough?)  And
direct is an exp 
param, that greatly affects your imp. 
 
Statistics is 
another 
exp 
parameter that takes affect on import. 
The
export puts a stats 
statement in the dump file, which imp finds and
executes. I imagine 
direct works the same way. 
 
A quick test on a 
tiny table shows that conventional exp creates a
dump file that's 
slightly bigger. Visually, in a text editor, both files
look very much 
alike.
 
And the timing 
difference - for the export - was BIG. The conventional
exported in 12 
seconds, the direct was INSTANT, less than a second.
 
I've experienced the 
same on large tables, and I probably even have
timings saved 
somewhere.
 
HTH,
 
Yosi
 
 
 -Original Message-From: 
Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 
4:01 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: exp performance question ( direct=y)

  I dunno. Does the BUFFER 
  still matter when DIRECT=Y?
   
  If so, I either remove it 
  entirely, or multiply it by about a factor of five or so. 
   
  my $0.02
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
exp performance question ( direct=y)
Ron, 
 
ok i'm now confused, 
 
exp direct=n|y
imp no such option
sql_loader has direct also.
 
or am i missing something here?
 
joe
 
>>> [EMAIL PROTECTED] 06/22/01 03:00PM 
>>>I thought that DIRECT=Y was for imports only. It makes since 
because in the import you are placing the data directly into the blocks with 
out a redo log.I have no idea why there was a difference in the times 
unless it was the extra overhead for a command that was not used.ROR 
mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
>>>Oracle : 8.0.5Platform : SunCurrently we 
have cron job every night (starting from 11pm) to do export. I changed 
the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit 
surprused to find that it did not. It actually took longer to create 
dump file with less data to export. The whole exp process takes about 2 
hours to finish. Yes, there could be lots of other unix processes 
running during that time. But I would still expect to see some 
improvement because we are doing this way for quite a while. So my 
questions are:1. From your "real" export experience, how much 
performance boost did you see when you set "direct=y"?2. If 
"direct=y" improves the performance, why would anyone want to use  
"direct=n"?Thanks.Guang-- here is my orcle dump 
file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 
and dmp.5 are from direct=n).-rw-rw-r--   1 
mt   prog 
1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
mt   prog 
1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
mt   prog 
1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
mt   prog 
1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
mt   prog 
1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = 
YUSERID = xxx/yyyOWNER = 
(aaa,bbb)_Get 
your FREE download of MSN Explorer at http://explorer.msn.com -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from).  You mayalso send the 
HELP command for other information (like subscribing).--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
Rogers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containi

RE: Forms 3.0


Yea, Larry and the Block Boys toured right after that to promote the
binaries.



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


1990 sounds about right

Tom Mercadante
Oracle Certified Professional


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



Hi,

About of 1990





"Deen Dayal" <[EMAIL PROTECTED]>@fatcity.com on 22/06/2001 04:11:50 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


hi,

does any body know when forms 3.0 is released. Does any body have forms
history of releases


Thanks
Deen


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

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

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



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

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

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

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

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

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

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

RE: Limiting Oracle Memory


And NT does a good job with VM?

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



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


I am starting to think that it is a memory leak, it's just to huge to be
anything else.  I will calculate the size of the tables, that will be the
best sign of whats happening.
Interesting point, which I am sure everyone knows already, is that
Oracle
does not let NT manage VM, it takes care of it itself.  My question would
be, how does it know how much to use?  I mean, will it just keep sucking up
disk space for VM and bring the machine down?  Stick to DB's Oracle, leave
VMM to OS people:)
Thanks for the advice:)
Kev

-Original Message-
Waleed
Sent: Thursday, June 21, 2001 7:03 PM
To: Multiple recipients of list ORACLE-L


The amount of memory (Virtual) that is used is proportional to the size of
PL/SQL table.
There is no solution for this b/c it's perfectly normal except that the
amount of used memory is huge in comparison to the maximum amount of data in
the table which could be a memory leak.

You could estimate the size of data inserted into this PL/SQL table.

If it's correct then the design should change to using global (or even
regular) temporary tables or change the logic to use cursors
that will split your job.

Regards,


Waleed



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


Hi all,
I have a procedure that seems to be bringing my server to it's
knees.
Winnt, Oracle 817 (Pipe down Ross:))
Anyway, what happens is a pl/sql table is placed into memory and then later
on it will be written to the disk.  However, by the time the process is
about to get to the writing part the machine is dead.  The Oracle.exe
process is well over 700MBs and the Virtual Memory is over a gig and a
half!!  Is there anyway for me to limit this, I tried using the registry
entry ORA_WORKINGSETMAX, however that doesn't seem to work.  Has anyone used
this setting?  Are you just supposed to put a number in the entry?  I put
600 but nothing happens.  Any help would be greatly appreciated.


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

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

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

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

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

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

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

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

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

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

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




I'd set recordlength to 128 or 
64K, depending on your OSjust a read stride...

  -Original 
  Message-From: Jim Conboy 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 4:28 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  exp performance question ( direct=y)
  No, buffer is ignored for 
  DIRECT=Y.  But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple 
  of it.  I've had dramatic gains in performance doing this.
   
  Also, pre-8i you couldn't do 
  direct-mode export of LONG fields.  As of sometime in 8i you can (I know 
  it works in 8.1.7).
   
  Jim
  >>> [EMAIL PROTECTED] 06/22/01 04:00PM 
  >>>
  I dunno. Does the BUFFER 
  still matter when DIRECT=Y?
   
  If so, I either remove it 
  entirely, or multiply it by about a factor of five or so. 
   
  my $0.02
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
exp performance question ( direct=y)
Ron, 
 
ok i'm now confused, 
 
exp direct=n|y
imp no such option
sql_loader has direct also.
 
or am i missing something here?
 
joe
 
>>> [EMAIL PROTECTED] 06/22/01 03:00PM 
>>>I thought that DIRECT=Y was for imports only. It makes since 
because in the import you are placing the data directly into the blocks with 
out a redo log.I have no idea why there was a difference in the times 
unless it was the extra overhead for a command that was not used.ROR 
mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
>>>Oracle : 8.0.5Platform : SunCurrently we 
have cron job every night (starting from 11pm) to do export. I changed 
the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit 
surprused to find that it did not. It actually took longer to create 
dump file with less data to export. The whole exp process takes about 2 
hours to finish. Yes, there could be lots of other unix processes 
running during that time. But I would still expect to see some 
improvement because we are doing this way for quite a while. So my 
questions are:1. From your "real" export experience, how much 
performance boost did you see when you set "direct=y"?2. If 
"direct=y" improves the performance, why would anyone want to use  
"direct=n"?Thanks.Guang-- here is my orcle dump 
file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 
and dmp.5 are from direct=n).-rw-rw-r--   1 
mt   prog 
1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
mt   prog 
1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
mt   prog 
1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
mt   prog 
1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
mt   prog 
1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = 
YUSERID = xxx/yyyOWNER = 
(aaa,bbb)_Get 
your FREE download of MSN Explorer at http://explorer.msn.com -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from).  You mayalso send the 
HELP command for other information (like subscribing).--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
Rogers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from).  You mayalso send the 
HELP command for other information (like 
subscribing).

RE: Calculating of the Median of Data


You can replace the order by BY group by.
Group by does an implicit sort.

Regards,

Waleed

-Original Message-
Sent: Friday, June 22, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Waleed;
  Well, I am afraid, its not going to be this simple on my version of
Oracle, 8.0.5.   Apparently, you can not do an order by in the from
statement on this version so I can not get the crucial order of the data.

Thanks anyway.  I may have to resort to an pl/sql function.

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


What about this:
SQL> create table median ( c1 number );

Table created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (3);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
3

SQL> 
SQL> 
SQL> insert into median values (6);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
4

Regards,

Waleed



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


Does anyone have a handy function for calculating the Median of data ??  It
seems like it should be simple ...but

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


Thank you Jeremiah

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


This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:

strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
sort | uniq

The typical location for underscore parameters is x$ksppi:

(as SYS:)
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';

The event codes (most of them) are documented in
$ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 21 Jun 2001, Kevin Lange wrote:

>   Is there any place that has a list of ALL the things you can put into
the
> Init file and what they do ??   Not just the regular  option strings I
> can get a list of these from a couple of web sites , but all of the hidden
,
> and as far as I know, undocumented EVENT strings as well??

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

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

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

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

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

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

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-

RE: Monitoring Memory on DYNIX

Gene, 

thx...for me, I would tying the IBM
SAs up and asking about everything they
see or touch. I'm like that. 

You got me confusedthey are *raising*
BUFPCT b/c your *oracle* hit ratio is high
enough?  if so, that's reasonable, but I still
would want to know about how SAS is acting, 
rather than "backing into" tuning it by
saying oracle is doing ok. 

the sar flags are fine. you might find some
value in Sequent's version of top. it might
even be loaded by default in your version. 

Also, try swap -[l|..] to look at swap

lastly, there is ALOT more to paging, etc
than BUFPCT, but.i am too freaking lazy
to write about it now...nuff said to say
worry alot more about the page OUTs than
the page INsnuff said

hth

Ross

-Original Message-
Sent: Friday, June 22, 2001 3:43 PM
To: Multiple recipients of list ORACLE-L

Ross,

I'm not sure why it is being done. We had an audit of
our systems done by IBM people and that's one of their
recommendations. I think their logic is "you hit ratio
is pretty high - 99% - so you can do with less
memory".
This server is not a dedicated Oracle server, we are
running another application (SAS) on it.

I have been running sar -wpr to get info on paging,
swapping and unused memory. Does this make sense to
you?

thank you

Gene

--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> 1) use sar on SVR4 systemsvmstat is a BSD thing
> 2) DYNIX rocks
> 3) IMHO yer BUFPCT is too high. If this is a
> dedicated database server ( i.e. no other apps on it
) and you are using ptx's DirectIO ( check with yer
SA, 
 or run truss on a shadow ) you really don't need much
more than 10. YMMV, etc. 
> 4) You never mention WHY you are tweaking kernel
> params.What is going on?
> 
> 
> 
> -Original Message-
> Sent: Friday, June 22, 2001 11:17 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all
> 
> We are running oracle 8.1.6 on DYNIX 4.4.7.
> CUrrently the BUFPCT is set to 25 and during this
> weekend will be increased to 30. I'd like to be
> able to check whether this affects oracle in any
> way.
> What statistics should I be looking at? I was
> thinking
> of using a vmstat (to check of page-outs ) but it
> doesn't exist on DYNIX. Any ideas?
> 
> thanks

=

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

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

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

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

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

RE: exp performance question ( direct=y)

2001-06-22 Thread Ron Rogers


Thanks to all who helped me get a clear understanding of the direct=Y option for the 
exp utility. 
I feel good, it is Friday and I have learned something today.
ROR mô¿ôm

>>> [EMAIL PROTECTED] 06/22/01 04:44PM >>>
No, direct only effects two things, the way oracle exports the data
(avoiding character conversions and buffering) and the format of the file.
The size and import speed of the export are effect only but .0001% or so.
Basically insignificant.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Friday, June 22, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


I thought that DIRECT=Y was for imports only. It makes since because in the
import you are placing the data directly into the blocks with out a redo
log.
 I have no idea why there was a difference in the times unless it was the
extra overhead for a command that was not used.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/22/01 12:55PM >>>
Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Christopher Spence
  INET: [EMAIL PROTECTED] 

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

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

RE: Deadlock Detection

Hi
        I think, you may be hitting another parameter before you exceed distributed transactions limit. If you look at your original trace the enqueue is DX-003b-. Here 3b is hex representation of 59. Considering the initial allocation is 60, this may be the last element in the distributed transactions array. So, why would a process select a last element of the array and wait for that transaction to complete. I think, there are two other parameters open_links and open_links_per_instance need to be increased. Default value for these parameters are 4 and 4.  So, I think, if the instance does not have enough links, then it pseudo randomly selects a distributed transaction slot array element and waits for it. Again, this is my guess and it would be worth a try to increase these two parameters and see whether that fixes the problem or !
!
not.

Mr. Steve Adams,
        Can you please explain this to us ?
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/22/01 02:48 PM
Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Deadlock Detection

Anita & Riyaj,

Thanks for the replies.  My email server "went away" for awhile, so I am just getting your replies now.

Anita, I am able to modify INITRANS for the tables (I tried this on a test table), and I will try this.  Right now, we are performing other stress tests to narrow down the problem to be sure that it is update related (has to be, right?).

Riyaj, I checked the value of  max_utilization vs initial_Allocation in the v$resource_Limit view for distributed transactions.  Max_util=5, while init_alloc=61.  Is the value of 61 a default?  I do not have it set in my init.ora (maybe I should! - something else to try).  The value of Transactions is max=5, init=247 and limit=247.

It doesn't seem to be stressed according to these values, right?

As for distributed Trans, we are using VB calling ADO using COM+ connecting to Oracle.  My impression is that ADO and COM+ are performing the distributed trans, but that the ADO performs the commits?  

I'm not at all familiar with how ADO/COM+ works, but I guess I better bring a book home and figure it out.

Any other ideas, I would greatly appreciate it.

thanks
Tom Mercadante 
Oracle Certified Professional 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Deadlock Detection

Hi Anita 
        If it is an ITL problem, then the resource type would be TX instead of DX. If the ITL table is full then the process requesting an ITL entry in that block will randomly select one of the transaction holding an ITL entry and wait for that process to complete or rollback. Since the process will wait for a transaction and as you are well aware of, the transaction id is a slot in a rollback segment and hence the enqueue type would be TX. Since this trace indicates that it is a DX type enqueue I would incline to think that this is a distributed transaction problem. Feel free to correct me if I am missing something.. 

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

"A. Bardeen" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
06/22/01 10:50 AM 
Please respond to ORACLE-L 

        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        Re: Deadlock Detection

Tom,

The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:

> Rows waited on:
> Session 27: no row

"No row" indicates that the deadlock is due to a lack
of available ITL slots in the datablock.

Unfortunately resolving this requires recreating the
object with either a high initrans value (to
explicitly reserve space for more ITL slots) or a
higher pctfree value (to give the ITL table more room
to grow).

Depending on the application it could also be that
multiple sessions are acquiring the same block off the
free list so using multiple free lists could also
help.  Starting with 8.1.6 this setting can be changed
dynamically; prior to that you must recreate the
object.

Note: 62365.1 also has some good info

HTH,

-- Anita

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> All,
> 
> My current application (still under development) is
> experiencing Oracle
> deadlock problems.  The applications people are
> performing stress testing
> where the application is being repeatedly called
> simulating actual users
> hitting the database.
> 
> The application is written using VB thru ADO and
> COM, Oracle 816 on NT.
> 
> My problem is that, while I can review the trace
> file produced, I can't
> figure out what the actual deadlock is occurring on.
>  I

RE: Forms 3.0

2001-06-22 Thread Mercadante, Thomas F


1990 sounds about right

Tom Mercadante
Oracle Certified Professional


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



Hi,

About of 1990





"Deen Dayal" <[EMAIL PROTECTED]>@fatcity.com on 22/06/2001 04:11:50 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


hi,

does any body know when forms 3.0 is released. Does any body have forms
history of releases


Thanks
Deen


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

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

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



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

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

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

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

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

RE: exp performance question ( direct=y)


No, direct only effects two things, the way oracle exports the data
(avoiding character conversions and buffering) and the format of the file.
The size and import speed of the export are effect only but .0001% or so.
Basically insignificant.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Friday, June 22, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


I thought that DIRECT=Y was for imports only. It makes since because in the
import you are placing the data directly into the blocks with out a redo
log.
 I have no idea why there was a difference in the times unless it was the
extra overhead for a command that was not used.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/22/01 12:55PM >>>
Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

2001-06-22 Thread Thater, William


On Fri, 22 Jun 2001,Krishnan, Manjula R. scribbled on the wall in glitter...:

->Thanks Bill:
->
->So, how can we get around that situation. We only want users with
->insert/update access to the tables to be  able to write.
->
->Manjula

either rewrite the package so it doesn't write to the table, or don't use that
package with the read only role.;-)


--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

Large volumes of users


All,

Can someone please point me to a paper or papers on
supporting large numbers of users and connections? I
find that most scalability papers talk about data,
not users. How do you support thousands of users?

Does anyone use cman? My current volume of zero
users (one on a good day) has sort of left me out of
reality on this, and my job search is forcing me to
actually think about things like this.

Thanks, as always,

Yosi



Yosi Greenfield
Oracle Certified Professional
[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).

RE: exp performance question ( direct=y)


1)  You can expect to see as much as 75% performance gain on export.  There
is just about no performance gain on the import.  The reason for this is it
avoids 3 copies and 2 character conversions when exporting the data. This is
due to the conversion from column major to row major when bringing in the
buffers into the buffer cache, then converting back to column major to
handle the select.  I would recomend looking at the recordlength parameter
as it has a good (1-4%) effect on performance initially, but after 32k it
generally has very little performance gain.  During conventional exports,
recordlength can prove as much as 6% performance gain.  Ussually setting it
to 32k is the best you will see.

One thing to know about exports is conventional exports are cpu bound where
as direct exports are Io bound.  But either will only use a fractional
portion of the cpu/io.  Also note, if your using consistent exports it will
incur locking as well as redo/rollback generation.  So time for exports
cannot be 100% accurately consistent.

Another thing is direct exports use as much as 65% less memory than
conventional and about 35% less cpu.  Also direct exports tend to do a three
fold increase in io throughput over conventional.  You can ussually export a
max export sustained speed of around 5-6% of max i/o.

2)  Target, source, and client used to export must be of the same character
set and you cannot export lobs.

This is perhaps more than you asked for, but hopefully it helps.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



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


Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

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

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

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

2001-06-22 Thread Bellefeuille, Wayne S

An explanation would be that the user who created the package has the
authority to write to the table.  This is how it is supposed to work.

Wayne

-Original Message-
Sent: Friday, June 22, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: 

Dear DBA's:

Have any of you come across this bizzare behavior? We have an
application
that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2)
on
an 8i database.

A user has been granted access through a role. This role APP_READ only
has
select privileges on all the tables for the application. But, on one of
the
forms the user is able to write into a table. This form uses a package
to
write into the table. The role has execute on the package. I checked the
form code to see if there was any explicit connect. There was none. I
even
recreated the user and the same thing is happening.

Can anyone explain this? 

Thanks,

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

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

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

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

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

Re: Forms 3.0

2001-06-22 Thread Leonardo Fernandez



Hi,

About of 1990





"Deen Dayal" <[EMAIL PROTECTED]>@fatcity.com on 22/06/2001 04:11:50 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


hi,

does any body know when forms 3.0 is released. Does any body have forms
history of releases


Thanks
Deen


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

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

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



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

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

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

2001-06-22 Thread Gupta, Brijesh




Thanks 
Riyaj
 It was the degree of 
parallelism on the indexes.
 
Brijesh

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 1:39 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Rule base optimizer selecting different execution path ( Tuning 
  )Brijesh 
          There are few 
  conditions where the optimizer will select CBO even when the optimizer_mode is 
  set to rule. Do you have any objects in the schema with a parallelism >1 
  (tables and indexes) ? One of the common problem is that DBAs rebuild the 
  index with higher parallelism and forget to change the parallelism back to 
  noparallel. Parallelism >1 will turn on CBO. What is your optimizer_mode ? 
  I assume it is rule. Let us know if not.         Seeing hash_join in your second plan, I am 
  positive that the CBO is being turned on. Do you have any hints in the code ? 
  Does your session change the optimizer_goal at the session level by any chance 
  ? ThanksRiyaj "Re-yas" 
  ShamsudeenCertified Oracle DBAi2 technologies   www.i2.com 
  
  


  
  "Gupta, Brijesh" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
06/22/01 01:12 PM Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        Rule base optimizer selecting 
different execution path ( Tuning 
  )Hi All,     
     Can somebody help me 
  in understanding this. We have a query which runs faster on 
  development and not on production. 
  When I checked the trace , it 
  using different execution path on both database. Database is 8.0.5 running oracle application and the optimizer is 
  RULE. 
  Does anybody know why two execution 
  path oracle optimizer has selected when its a RULE base optimizer. I know that is possible if its cost base optimizer but in rule it 
  should be same right ( All the indexes are same on both database ) 
  Only thing I did was rebuild some of 
  the indexes on Test instance. 
  
  Thanks Brijesh 
  Here is the explain plan of both the 
  database. 
  
  * Development Database 
  *** Optimizer goal: RULE Parsing user id: 45  (APPS)  
  select substr(mil.segment1||'.'||mil.segment2||'.'||mil.segment3,1,45) 
  Locator, mmt.subinventory_code 
  Subinventory, msi.segment1 PART_NO, mmt.transaction_uom UOM, 
  sum(mmt.transaction_quantity) from mtl_item_locations mil, 
  mtl_transaction_types 
  typ, mtl_material_transactions mmt, mtl_system_items msi, 
  mtl_parameters mp where mp.organization_code='768' and mp.organization_id+0=msi.organization_id and msi.organization_id=mmt.organization_id and msi.inventory_item_id=mmt.inventory_item_id and trunc(mmt.transaction_date) between '01-APR-01' and 
  '31-MAY-01' and 
  mmt.transaction_type_id=typ.transaction_type_id and typ.transaction_type_name='Account alias receipt' and mmt.locator_id=mil.inventory_location_id(+) and mmt.organization_id=mil.organization_id(+) and mil.subinventory_code = 'CORROSIVE' group by mil.segment1, 
  mil.segment2, mil.segment3, 
  mmt.subinventory_code, 
  msi.segment1, mmt.transaction_uom 
  
  call     count     
    cpu    elapsed       disk     
   query    current        rows --- --   -- -- -- 
  --  -- 
  Parse       
   1      0.01       0.01     
       0          0       
     0           0 Execute      1      0.00   
      0.00          0       
     0          0         
    0 Fetch        2   
    51.68     901.33      85134     
  395083          0           
  4 --- --   -- 
  -- -- --  -- total        4     51.69   
    901.34      85134     395083     
       0           4 
  Misses in library cache during parse: 
  0 Optimizer goal: RULE Parsing user id: 45  (APPS) 
  Rows     Execution 
  Plan --- 
   ---      0  SELECT STATEMENT   GOAL: 
  RULE      4   SORT (GROUP 
  BY)     33   
   FILTER     32     NESTED LOOPS 
  (OUTER)     33      NESTED 
  LOOPS    132       NESTED 
  LOOPS   2445       
   NESTED LOOPS      1       
    TABLE ACCESS (BY INDEX ROWID) OF 'MTL_PARAMETERS'      2          INDEX 
  (RANGE SCAN) OF 'ORGANIZATION_CODE' 
          
              (NON-UNIQUE)   2445         TABLE ACCESS   GOAL: 
  ANALYZED (BY INDEX ROWID) OF 
          
             'MTL_SYSTEM_ITEMS'   2446          INDEX   GOAL: 
  ANALYZED (RANGE SCAN) OF 
          
              'MTL_SYSTEM_ITEMS_N1' 
  (NON-UNIQUE) 194874        TABLE 
  ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF                   
  'MTL_MATERIAL_TRANSACTIONS' 
  846350       
    AND-EQUAL 500017         
   INDEX (RANGE SCAN) OF 'ORGANIZATION_ID'                   
    (NON-UNIQUE) 3487

RE:


Reality check. Is write on that table granted to public?

> -Original Message-
> From: Krishnan, Manjula R. [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 
> 
> 
> Dear DBA's:
> 
> Have any of you come across this bizzare behavior? We have an 
> application
> that was written using Forms 6i. It runs on the web (using 
> OAS 4.0.8.2) on
> an 8i database.
> 
> A user has been granted access through a role. This role 
> APP_READ only has
> select privileges on all the tables for the application. But, 
> on one of the
> forms the user is able to write into a table. This form uses 
> a package to
> write into the table. The role has execute on the package. I 
> checked the
> form code to see if there was any explicit connect. There was 
> none. I even
> recreated the user and the same thing is happening.
> 
> Can anyone explain this? 
> 
> Thanks,
> 
> Manjula
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Krishnan, Manjula R.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

2001-06-22 Thread Krishnan, Manjula R.


Thanks Bill:

So, how can we get around that situation. We only want users with
insert/update access to the tables to be  able to write.

Manjula

-Original Message-
To: Krishnan, Manjula R.
Cc: Multiple recipients of list ORACLE-L
Sent: 6/22/01 2:23 PM

On Fri, 22 Jun 2001,Krishnan, Manjula R. scribbled on the wall in
glitter...:

->Dear DBA's:
->
->Have any of you come across this bizzare behavior? We have an
application
->that was written using Forms 6i. It runs on the web (using OAS
4.0.8.2) on
->an 8i database.
->
->A user has been granted access through a role. This role APP_READ only
has
->select privileges on all the tables for the application. But, on one
of the
->forms the user is able to write into a table. This form uses a package
to
->write into the table. The role has execute on the package. I checked
the
->form code to see if there was any explicit connect. There was none. I
even
->recreated the user and the same thing is happening.
->
->Can anyone explain this?
->
->Thanks,
->
->Manjula
->
if the role is granted execute on the package, then when the package is
invoked
it runs with the permissions of the owner of the package.  that explains
the
write to the table since the owner of the package has the permissions to
write
to that table.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Krishnan, Manjula R.
  INET: [EMAIL PROTECTED]

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

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

Re:

2001-06-22 Thread Rachel Carmichael


I can explain it easily -- the owner of the package has write access to the 
table. And the user who has execute privs on the package inherits (for the 
time the package is running, and only for the running of that package) all 
the privileges the package owner has.

Now, in 8 (I *think* 8.0 but certainly 8i) you can create packages that run 
with the invoker's rights. So a user who did not have write access to that 
table would not be able to write into it, even if he had execute on the 
package itself.


>From: "Krishnan, Manjula R." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: Fri, 22 Jun 2001 12:00:41 -0800
>
>Dear DBA's:
>
>Have any of you come across this bizzare behavior? We have an application
>that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on
>an 8i database.
>
>A user has been granted access through a role. This role APP_READ only has
>select privileges on all the tables for the application. But, on one of the
>forms the user is able to write into a table. This form uses a package to
>write into the table. The role has execute on the package. I checked the
>form code to see if there was any explicit connect. There was none. I even
>recreated the user and the same thing is happening.
>
>Can anyone explain this?
>
>Thanks,
>
>Manjula
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Krishnan, Manjula R.
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

RE: exp performance question ( direct=y)

2001-06-22 Thread Jim Conboy




No, buffer is ignored for 
DIRECT=Y.  But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple 
of it.  I've had dramatic gains in performance doing this.
 
Also, pre-8i you couldn't do 
direct-mode export of LONG fields.  As of sometime in 8i you can (I know it 
works in 8.1.7).
 
Jim
>>> [EMAIL PROTECTED] 06/22/01 04:00PM 
>>>
I dunno. Does the BUFFER still 
matter when DIRECT=Y?
 
If so, I either remove it 
entirely, or multiply it by about a factor of five or so. 
 
my $0.02

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  exp performance question ( direct=y)
  Ron, 
   
  ok i'm now confused, 
   
  exp direct=n|y
  imp no such option
  sql_loader has direct also.
   
  or am i missing something here?
   
  joe
   
  >>> [EMAIL PROTECTED] 06/22/01 03:00PM 
  >>>I thought that DIRECT=Y was for imports only. It makes since 
  because in the import you are placing the data directly into the blocks with 
  out a redo log.I have no idea why there was a difference in the times 
  unless it was the extra overhead for a command that was not used.ROR 
  mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
  >>>Oracle : 8.0.5Platform : SunCurrently we have 
  cron job every night (starting from 11pm) to do export. I changed the 
  setting "direct" to "y" two days ago while leaving all other parameters 
  unchanged, hoping to gain some performance. I am a bit surprused to find 
  that it did not. It actually took longer to create dump file with less 
  data to export. The whole exp process takes about 2 hours to finish. Yes, 
  there could be lots of other unix processes running during that time. But 
  I would still expect to see some improvement because we are doing this way 
  for quite a while. So my questions are:1. From your "real" export 
  experience, how much performance boost did you see when you set 
  "direct=y"?2. If "direct=y" improves the performance, why would anyone 
  want to use  "direct=n"?Thanks.Guang-- here 
  is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from 
  direct=y,dmp.3, dmp.4 and dmp.5 are from 
  direct=n).-rw-rw-r--   1 
  mt   prog 1042197132 
  Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
  mt   prog 1042375633 
  Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
  mt   prog 1042556662 
  Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
  mt   prog 1034773279 
  Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
  mt   prog 1035237986 
  Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
  file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
  YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
  YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = 
  YUSERID = xxx/yyyOWNER = 
  (aaa,bbb)_Get 
  your FREE download of MSN Explorer at http://explorer.msn.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).--Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
  Rogers  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like 
subscribing).

Re: your mail

2001-06-22 Thread Thater, William


On Fri, 22 Jun 2001,Krishnan, Manjula R. scribbled on the wall in glitter...:

->Dear DBA's:
->
->Have any of you come across this bizzare behavior? We have an application
->that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on
->an 8i database.
->
->A user has been granted access through a role. This role APP_READ only has
->select privileges on all the tables for the application. But, on one of the
->forms the user is able to write into a table. This form uses a package to
->write into the table. The role has execute on the package. I checked the
->form code to see if there was any explicit connect. There was none. I even
->recreated the user and the same thing is happening.
->
->Can anyone explain this?
->
->Thanks,
->
->Manjula
->
if the role is granted execute on the package, then when the package is invoked
it runs with the permissions of the owner of the package.  that explains the
write to the table since the owner of the package has the permissions to write
to that table.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Do you like me for my brain or my baud?

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

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

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

Forms 3.0

2001-06-22 Thread Deen Dayal


hi,

does any body know when forms 3.0 is released. Does any body have forms history of 
releases


Thanks
Deen


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

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

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

RE: timed statistics


When you have timed statistics on all your doing is when oracle acquires a
resource it stores the time, then it is done, it stores a time.  This is
very low resource task, even compared to many of the smallest transactions.
Most transactions outweigh the time to do this by 100 - 1000 fold or more.  

Considering wait events are so much more effective and useful for tuning
than ratio, proper performance is almost impossible to obtain without using
time statistics.  Another thing to note is when you tune a database, it
doesn't stay properly tuned forever.  Without statistics it is hard to see
when other problems start to crop up until it is too late.  I.E., if your
log parrallel write time increases because of increased redo generation and
lack of enough spindles cannot be noticed in due time without proper
statistics.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



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


Timed statistics has very little performance impact - most of the work is
already done internally anyway.  It is very useful - for tkprof, wait
statistics, and a few other things.  I always set it and have for years -
even on exceptionally hot OLTP systems.  A guy I know from the Oracle Center
of Expertise gave a talk to our local user group two weeks ago and mentioned
that he had never seen any noticeable performance degradation due to setting
it.  If there is any significant performance impact, you have much bigger
problems than timed statistics.

I have seen only one very specific bug related to setting it.  That was just
recently after upgrading an 8.1.7.0.0 OPS database on Sun Solaris to
8.1.7.1.0.  Prior to the upgrade, no problem.  After the upgrade, shutting
down an instance while in parallel mode resulted in a long wait (several
additional minutes, even with immediate) and an ORA-07445 error that
generated a trace file and a cdump.  The problem is that one of the OPS
processes, bsp, would not shut down cleanly.  This is one of the last things
that happens during the instance shutdown.  Since the database had already
been dismounted, it probably isn't that serious.  As far as I know, it only
happens with PARALLEL_SERVER=TRUE in 8.1.7.1.0 (on Sun Solaris at least) and
it did not happen in any prior release/patchlevel of 8i.

-Don Granaman
[certifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 10:16 AM


> Hi
>
> Has anyone experienced any problems after setting timed_statistics to true
> on a prod database (at system level) ?
>
> Can anyone give me a guess as to the performance hit of doing this ?
>
> Running Oracle 8.1.6, there are fairly predictable periods of high,
medium,
> and low load so I can avoid collecting stats at peak periods if necessary.
>
> Cheers
> Greg
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Solomon
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Don Granaman
  INET: [EMAIL PROTECTED]

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

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

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

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

No Subject

2001-06-22 Thread Krishnan, Manjula R.


Dear DBA's:

Have any of you come across this bizzare behavior? We have an application
that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on
an 8i database.

A user has been granted access through a role. This role APP_READ only has
select privileges on all the tables for the application. But, on one of the
forms the user is able to write into a table. This form uses a package to
write into the table. The role has execute on the package. I checked the
form code to see if there was any explicit connect. There was none. I even
recreated the user and the same thing is happening.

Can anyone explain this? 

Thanks,

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

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

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

RE: exp performance question ( direct=y)




I dunno. Does the BUFFER still 
matter when DIRECT=Y?
 
If so, I either remove it 
entirely, or multiply it by about a factor of five or so. 
 
my $0.02

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  exp performance question ( direct=y)
  Ron, 
   
  ok i'm now confused, 
   
  exp direct=n|y
  imp no such option
  sql_loader has direct also.
   
  or am i missing something here?
   
  joe
   
  >>> [EMAIL PROTECTED] 06/22/01 03:00PM 
  >>>I thought that DIRECT=Y was for imports only. It makes since 
  because in the import you are placing the data directly into the blocks with 
  out a redo log.I have no idea why there was a difference in the times 
  unless it was the extra overhead for a command that was not used.ROR 
  mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
  >>>Oracle : 8.0.5Platform : SunCurrently we have 
  cron job every night (starting from 11pm) to do export. I changed the 
  setting "direct" to "y" two days ago while leaving all other parameters 
  unchanged, hoping to gain some performance. I am a bit surprused to find 
  that it did not. It actually took longer to create dump file with less 
  data to export. The whole exp process takes about 2 hours to finish. Yes, 
  there could be lots of other unix processes running during that time. But 
  I would still expect to see some improvement because we are doing this way 
  for quite a while. So my questions are:1. From your "real" export 
  experience, how much performance boost did you see when you set 
  "direct=y"?2. If "direct=y" improves the performance, why would anyone 
  want to use  "direct=n"?Thanks.Guang-- here 
  is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from 
  direct=y,dmp.3, dmp.4 and dmp.5 are from 
  direct=n).-rw-rw-r--   1 
  mt   prog 1042197132 
  Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
  mt   prog 1042375633 
  Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
  mt   prog 1042556662 
  Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
  mt   prog 1034773279 
  Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
  mt   prog 1035237986 
  Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
  file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
  YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
  YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = 
  YUSERID = xxx/yyyOWNER = 
  (aaa,bbb)_Get 
  your FREE download of MSN Explorer at http://explorer.msn.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).--Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
  Rogers  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

RE: timed statistics


8.1.5 has some known performance problems, but 8.1.6 resolved them.

I always run timed_statistics = true.  

There is a slow down of .1-5% depending on who you talk to, I don't think it
is much more than 1%.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, June 20, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


Hi

Has anyone experienced any problems after setting timed_statistics to true
on a prod database (at system level) ?

Can anyone give me a guess as to the performance hit of doing this ?

Running Oracle 8.1.6, there are fairly predictable periods of high, medium,
and low load so I can avoid collecting stats at peak periods if necessary.

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

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

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

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

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

2001-06-22 Thread Mercadante, Thomas F




Anita 
& Riyaj,
 
Thanks 
for the replies.  My email server "went away" for awhile, so I am just 
getting your replies now.
 
Anita, 
I am able to modify INITRANS for the tables (I tried this on a test table), and 
I will try this.  Right now, we are performing other stress tests to narrow 
down the problem to be sure that it is update related (has to be, 
right?).
 
Riyaj, 
I checked the value of  max_utilization vs initial_Allocation in the 
v$resource_Limit view for distributed transactions.  Max_util=5, while 
init_alloc=61.  Is the value of 61 a default?  I do not have it set in 
my init.ora (maybe I should! - something else to try).  The value of 
Transactions is max=5, init=247 and limit=247.
 
It 
doesn't seem to be stressed according to these values, 
right?
 
As for 
distributed Trans, we are using VB calling ADO using COM+ connecting to 
Oracle.  My impression is that ADO and COM+ are performing the distributed 
trans, but that the ADO performs the commits?  
 
I'm 
not at all familiar with how ADO/COM+ works, but I guess I better bring a book 
home and figure it out.
 
Any 
other ideas, I would greatly appreciate it.
 
thanks
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 2:17 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Deadlock DetectionHi 
  Anita         If 
  it is an ITL problem, then the resource type would be TX instead of DX. If the 
  ITL table is full then the process requesting an ITL entry in that block will 
  randomly select one of the transaction holding an ITL entry and wait for that 
  process to complete or rollback. Since the process will wait for a transaction 
  and as you are well aware of, the transaction id is a slot in a rollback 
  segment and hence the enqueue type would be TX. Since this trace indicates 
  that it is a DX type enqueue I would incline to think that this is a 
  distributed transaction problem. Feel free to correct me if I am missing 
  something.. ThanksRiyaj 
  "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies   
  www.i2.com 
  


  
  "A. Bardeen" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
06/22/01 10:50 AM Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        Re: Deadlock 
DetectionTom,The information you need should be in the trace 
  file,but it's not in the excerpt you've listed, but thetrue problem is 
  listed:> Rows waited on:> Session 27: no row"No row" 
  indicates that the deadlock is due to a lackof available ITL slots in the 
  datablock.Unfortunately resolving this requires recreating 
  theobject with either a high initrans value (toexplicitly reserve 
  space for more ITL slots) or ahigher pctfree value (to give the ITL table 
  more roomto grow).Depending on the application it could also be 
  thatmultiple sessions are acquiring the same block off thefree list so 
  using multiple free lists could alsohelp.  Starting with 8.1.6 this 
  setting can be changeddynamically; prior to that you must recreate 
  theobject.Note: 62365.1 also has some good 
  infoHTH,-- Anita--- "Mercadante, Thomas F" 
  <[EMAIL PROTECTED]>wrote:> All,> > My 
  current application (still under development) is> experiencing 
  Oracle> deadlock problems.  The applications people are> 
  performing stress testing> where the application is being repeatedly 
  called> simulating actual users> hitting the database.> 
  > The application is written using VB thru ADO and> COM, Oracle 
  816 on NT.> > My problem is that, while I can review the 
  trace> file produced, I can't> figure out what the actual 
  deadlock is occurring on.>  I have seen deadlock> trace 
  files that clearly state "table blah", but in> this case, I 
  get:> > > *** 2001-06-21 14:32:03.841> *** SESSION 
  ID:(27.31211) 2001-06-21 14:32:03.810> DEADLOCK DETECTED> 
  Deadlock graph:>               
           -Blocker(s)> 
  -Waiter(s)-> Resource Name         
   process session holds waits > process session holds> 
  waits> DX-003b-        22     
   18     X        >     24 
       27> X> session 18: DID 0001-0018-003C 
                  session 27: 
  DID> 0001-0018-003C> Rows waited on:> Session 27: no 
  row> *** 2001-06-21 14:32:03.857> ksedmp: internal or fatal 
  error> ORA-00060: deadlock detected while waiting for> 
  resource> > Is there something like TKPROF that will process 
  the> trace file and give me> more info on what is happening? 
   It looks like I am> waiting for a resource> to be freed, 
  but which one is the question.> > thanks for any help.> 
  > Tom Mercadante> Oracle Certified Professional> > 
  -- > Please see the official ORACLE-L FAQ:> 
  http://www.orafaq.com> -- > Author: Mercadante, Thomas F>

Re: OPS in Sun E10K

2001-06-22 Thread JOE TESTA

i dont think thats a valid statement anymore, "but the administration overhead you will face
is negligible compared to the performance boost you can achieve.
"
You said it has been a few years
since then, have you tried any of the "new" type filesystems,
recently?
joe
>>> [EMAIL PROTECTED] 06/22/01 03:06PM
>>>Bala I don't see any responses.
So, please ignore if this is already answered. First of all, In Sun, you have to use RAW for
an Oracle Parallel Server database. (I am not sure whether you can use Veritas
Quick I/O to configure OPS, my guess would be no). Second, if it is a
performance critical database with high concurrent activity, even in a non-OPS
set up, I would go for RAW or Quick IO. There is always the discussion about the raw
vs file system, but the administration overhead you will face is negligible
compared to the performance boost you can achieve. I agree that you need to
preconfigure the volumes and plan the size etc.., but in a production database
that needs to be done anyway. Most of the backup software don't care whether it
is a file system or raw either. On the other hand you avoid double
copying, double buffering, vnode lock etc. Specifically, if you use multiple
DBWRs also to simulate async IO, vnode lock will serialize your writes degrading
the scalability. You can also achieve true asynchronous IO also if you raw disk
based database.
Couple of years ago, at my previous employer, we converted few databases
to raw and our performance was much better. Particularly, considering that we
had I/O intensive OLTP application, we were able to scale beyond the
requirements easily. ThanksRiyaj
"Re-yas" ShamsudeenCertified Oracle DBAi2 technologies
www.i2.com

Balakrishnan Subramanian
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
06/22/01 10:10 AM Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Subject:
OPS in Sun
E10KSystem : Sun E10KOS : Sun solaris 2.8Oracle : 8i Rel 3 64bit
optionDatabase : OPSType : OLTP &# concurrent users : 1000
(including US and international users Europe, Asia&
Australia)Our System admin suggesting us to go for File system (veritas,
withoutVeritas quick i/o) instead of raw devices, the reason is ease
ofmaintenance. He says, with OS and Oracle tuning, we can bring OPS
upto thelevel of raw device performance.I appreciate if you can
share your experience.Thanks,Bala.-- Please see the
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Balakrishnan
Subramanian INET: [EMAIL PROTECTED]Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San Diego,
California -- Public Internet access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).

RE: Monitoring Memory on DYNIX

2001-06-22 Thread Gene Gurevich

Ross,

I'm not sure why it is being done. We had an audit of
our systems done by IBM people and that's one of their
recommendations. I think their logic is "you hit ratio
is pretty high - 99% - so you can do with less
memory".
This server is not a dedicated Oracle server, we are
running another application (SAS) on it.

I have been running sar -wpr to get info on paging,
swapping and unused memory. Does this make sense to
you?

thank you

Gene

--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> 1) use sar on SVR4 systemsvmstat is a BSD thing
> 2) DYNIX rocks
> 3) IMHO yer BUFPCT is too high. If this is a
> dedicated database server ( i.e. no other apps on it
) and you are using ptx's DirectIO ( check with yer
SA, 
 or run truss on a shadow ) you really don't need much
more than 10. YMMV, etc. 
> 4) You never mention WHY you are tweaking kernel
> params.What is going on?
> 
> 
> 
> -Original Message-
> Sent: Friday, June 22, 2001 11:17 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all
> 
> We are running oracle 8.1.6 on DYNIX 4.4.7.
> CUrrently the BUFPCT is set to 25 and during this
> weekend will be increased to 30. I'd like to be
> able to check whether this affects oracle in any
> way.
> What statistics should I be looking at? I was
> thinking
> of using a vmstat (to check of page-outs ) but it
> doesn't exist on DYNIX. Any ideas?
> 
> thanks

=

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

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

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

2001-06-22 Thread JOE TESTA




Ron, 
 
ok i'm now confused, 
 
exp direct=n|y
imp no such option
sql_loader has direct also.
 
or am i missing something here?
 
joe
 
>>> [EMAIL PROTECTED] 06/22/01 03:00PM 
>>>I thought that DIRECT=Y was for imports only. It makes since 
because in the import you are placing the data directly into the blocks with out 
a redo log.I have no idea why there was a difference in the times unless it 
was the extra overhead for a command that was not used.ROR 
mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
>>>Oracle : 8.0.5Platform : SunCurrently we have 
cron job every night (starting from 11pm) to do export. I changed the 
setting "direct" to "y" two days ago while leaving all other parameters 
unchanged, hoping to gain some performance. I am a bit surprused to find 
that it did not. It actually took longer to create dump file with less data 
to export. The whole exp process takes about 2 hours to finish. Yes, there 
could be lots of other unix processes running during that time. But I would 
still expect to see some improvement because we are doing this way for quite 
a while. So my questions are:1. From your "real" export experience, how 
much performance boost did you see when you set "direct=y"?2. If 
"direct=y" improves the performance, why would anyone want to use  
"direct=n"?Thanks.Guang-- here is my orcle dump 
file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 and 
dmp.5 are from direct=n).-rw-rw-r--   1 
mt   prog 1042197132 
Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
mt   prog 1042375633 
Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
mt   prog 1042556662 
Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
mt   prog 1034773279 
Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
mt   prog 1035237986 
Jun 22 01:22 oracle.dmp.1.gz--here is the parameter file:BUFFER 
= 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = YDIRECT = 
YFILE = /oracle/exports/oracle.dmp.pipe#FULL = YGRANTS = 
YINDEXES = YLOG = /oracle/exports/export.logROWS = YUSERID = 
xxx/yyyOWNER = 
(aaa,bbb)_Get 
your FREE download of MSN Explorer at http://explorer.msn.com -- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang 
Mei  INET: [EMAIL PROTECTED] Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).--Please see the official 
ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
Rogers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: OPS in Sun E10K

Bala
I don't see any responses. So, please ignore if this is already answered.
First of all, In Sun, you have to use RAW for an Oracle Parallel Server database. (I am not sure whether you can use Veritas Quick I/O to configure OPS, my guess would be no). Second, if it is a performance critical database with high concurrent activity, even in a non-OPS set up, I would go for RAW or Quick IO.
There is always the discussion about the raw vs file system, but the administration overhead you will face is negligible compared to the performance boost you can achieve. I agree that you need to preconfigure the volumes and plan the size etc.., but in a production database that needs to be done anyway. Most of the backup software don't care whether it is a file system or raw either. On the other hand you avoid double copying, double buffering, vnode lock etc. Specifically, if you use multiple DBWRs also to simulate async IO, vnode lock will serialize your writes degrading the scalability. You can also achieve true asynchronous IO also if you raw disk based database.
Couple of years ago, at my previous employer, we converted few databases to raw and our performance was much better. Particularly, considering that we had I/O intensive OLTP application, we were able to scale beyond the requirements easily.

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

Balakrishnan Subramanian <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/22/01 10:10 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: OPS in Sun E10K

System : Sun E10K
OS : Sun solaris 2.8
Oracle : 8i Rel 3 64bit option
Database : OPS
Type : OLTP &
# concurrent users : 1000 (including US and international users Europe, Asia
& Australia)

Our System admin suggesting us to go for File system (veritas, without
Veritas quick i/o) instead of raw devices, the reason is ease of
maintenance. He says, with OS and Oracle tuning, we can bring OPS upto the
level of raw device performance.

I appreciate if you can share your experience.

Thanks,

Bala.

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

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

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

Re: Query help !!!

2001-06-22 Thread Ron Thomas



Is this what you are trying to do?

select a.customer_id
from table a, table b
where a.customer_id = b.customer_id
and   a.status  = 'F'
and   b.status <> 'F'

Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]

"Karaoke: Japanese for migraine"



   

leslie_y_lu@y  

ahoo.com To: [EMAIL PROTECTED]  

Sent by: cc:   

root@fatcity.Subject: Query help !!!   

com

   

   

06/22/01   

10:51 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi,

If I have this:
Customer_id  Status
-- ---
1   F
1   A
1   B
2   F
2   F
3   A
3   B

How do I found out a customer who has both F and not F
for them.  (If he only gets F, or gets other than F,
that's fine).  In this case, I should get 1.  Thank
you!  I need this badly!

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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: Ron Thomas
  INET: [EMAIL PROTECTED]

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

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

2001-06-22 Thread Ron Thomas



FWIR, if there is a tie between two indexes, oracle will use the index that was 
created/recreated
most recently.

Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]

"Karaoke: Japanese for migraine"



   
 
Brijesh.Gupta@Airl 
 
iquide.comTo: [EMAIL PROTECTED] 
 
Sent by:  cc:  
 
[EMAIL PROTECTED]  Subject: Rule base optimizer 
selecting different execution path   
  ( Tuning )   
 
   
 
06/22/01 11:12 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Hi All,
Can somebody help me in understanding this.
We have a query which runs faster on development and not on production.
When I checked the trace , it using different execution path on both database.
Database is 8.0.5 running oracle application and the optimizer is RULE.


Does anybody know why two execution path oracle optimizer has selected when its a RULE 
base
optimizer.
I know that is possible if its cost base optimizer but in rule it should be same right 
( All the
indexes are same on both database )


Only thing I did was rebuild some of the indexes on Test instance.


Thanks
Brijesh


Here is the explain plan of both the database.






* Development Database ***
Optimizer goal: RULE
Parsing user id: 45  (APPS)



select
substr(mil.segment1||'.'||mil.segment2||'.'||mil.segment3,1,45) Locator,
mmt.subinventory_code Subinventory,
msi.segment1 PART_NO,
mmt.transaction_uom UOM,
sum(mmt.transaction_quantity)
from
mtl_item_locations mil,
mtl_transaction_types typ,
mtl_material_transactions mmt,
mtl_system_items msi,
mtl_parameters mp
where
mp.organization_code='768'
and mp.organization_id+0=msi.organization_id
and msi.organization_id=mmt.organization_id
and msi.inventory_item_id=mmt.inventory_item_id
and trunc(mmt.transaction_date) between '01-APR-01' and '31-MAY-01'
and mmt.transaction_type_id=typ.transaction_type_id
and typ.transaction_type_name='Account alias receipt'
and mmt.locator_id=mil.inventory_location_id(+)
and mmt.organization_id=mil.organization_id(+)
and mil.subinventory_code = 'CORROSIVE'
group by mil.segment1,
mil.segment2,
mil.segment3,
mmt.subinventory_code,
msi.segment1,
mmt.transaction_uom


call count   cpuelapsed   disk  querycurrentrows
--- --   -- -- -- --  --
Parse1  0.01   0.01  0  0  0   0
Execute  1  0.00   0.00  0  0  0   0
Fetch2 51.68 901.33  85134 395083  0   4
--- --   -- -- -- --  --
total4 51.69 901.34  85134 395083  0   4


Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 45  (APPS)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: RULE
  4   SORT (GROUP BY)
 33FILTER
 32 NESTED LOOPS (OUTER)
 33  NESTED LOOPS
132   NESTED LOOPS
   2445NESTED LOOPS
  1 TABLE ACCESS (BY INDEX ROWID) OF 'MTL_PARAMETERS'
  2  INDEX (RANGE SCAN) OF 'ORGANIZATION_CODE'
 (NON-UNIQUE)
   2445 TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
'MTL_SYSTEM_ITEMS'
   2446  INDEX   GOAL: ANALYZED (RANGE SCAN) OF
 'MTL_SYSTEM_ITEMS_N1' (NON-UNIQUE)
 194874TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
   'MTL_MATERIAL_TRANSACTIONS'
 846350 AND-EQUAL
 500017  INDEX (RANGE SCAN) OF 'ORGANIZATION_ID'
 (NON-UNIQUE)
 348778  INDEX (RANGE SCAN) OF 'INVENTORY_ITEM_ID'

Re: Query help !!! - Rewrite

2001-06-22 Thread Rocky Welch


How about:

select f.customer_id
from  f,  a, .b
where f.customer_id = a.customer_id and
  f.customer_id = b.customer_id and
  a.customer_id = b.customer_id and
  f.status = 'F' and
  a.status = 'A' and
  b.status = 'B';

Much cleaner than the one below.

--- Rocky Welch <[EMAIL PROTECTED]> wrote:
> Hi Leslie,
> This will be crude but it's a start. Gang, feel free to correct/improve:
> 
> select customer_id
> from 
> where 
> customer_id in (select customer_id from  where status = 'F')
> and
> customer_id in (select customer_id from  where status = 'A')
> and
> customer_id in (select customer_id from  where status =
> 'B');
> 
> Pretty messy and resource intensive but it should work.
> 
> HTH,
> -Rocky
> 
> --- Leslie Lu <[EMAIL PROTECTED]> wrote:
> > Just to clearfy my previous question (as follow):
> > 
> > if 1 has F and A and B, that what I want.
> > 
> > If 1 has F all the time, that's not what I want.
> > If 1 has A, B, C, but never F, that's not what I want
> > either.
> > 
> > --- Leslie Lu <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > > 
> > > If I have this:
> > > Customer_id  Status
> > > -- ---
> > > 1   F
> > > 1   A
> > > 1   B
> > > 2   F
> > > 2   F
> > > 3   A
> > > 3   B
> > > 
> > > How do I found out a customer who has both F and not
> > > F
> > > for them.  (If he only gets F, or gets other than F,
> > > that's fine).  In this case, I should get 1.  Thank
> > > you!  I need this badly!
> > > 
> > > __
> > > Do You Yahoo!?
> > > Get personalized email addresses from Yahoo! Mail
> > > http://personal.mail.yahoo.com/
> > > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 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).
> 
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rocky Welch
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

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

2001-06-22 Thread Ron Rogers


I thought that DIRECT=Y was for imports only. It makes since because in the import you 
are placing the data directly into the blocks with out a redo log.
 I have no idea why there was a difference in the times unless it was the extra 
overhead for a command that was not used.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/22/01 12:55PM >>>
Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

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

2001-06-22 Thread Rama Malladi

Yes. You can enable OEM through the web and DBA Studio comes along with
it. That is what I do to maintain all our databases. I am using OEM 2.2
which has HTTP server bundled in the OEM CD. The same can be done with OEM
2.1, but you may have to configure your existing APACHE... webserver to
work with OEM.

Rama

Szecsy Tamas wrote:

> Hi,
>
> is it possible to run DBA*Studio 8.1.7 on the Web through a browser?
>
> Thanks in advance.
>
> Tamas Szecsy
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Szecsy Tamas
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Rama Malladi
  INET: [EMAIL PROTECTED]

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

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

RE: Query help !!!

2001-06-22 Thread Nicoll, Iain (Calanais)


Leslie,

The query below will find all those with any number of 'F's and at least one
status that is not 'F'.

select distinct customer_id 
from mytablename t
where status = 'F'
and   exists (select '' 
  from mytablename t2
  where t2.customer_id = t.customer_id
  and   t2.status != 'F')

Cheers 

Iain Nicoll
-Original Message-
Sent: 22 June 2001 19:06
To: Multiple recipients of list ORACLE-L


Just to clearfy my previous question (as follow):

if 1 has F and A and B, that what I want.

If 1 has F all the time, that's not what I want.
If 1 has A, B, C, but never F, that's not what I want
either.

--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> If I have this:
> Customer_id  Status
> -- ---
> 1   F
> 1   A
> 1   B
> 2   F
> 2   F
> 3   A
> 3   B
> 
> How do I found out a customer who has both F and not
> F
> for them.  (If he only gets F, or gets other than F,
> that's fine).  In this case, I should get 1.  Thank
> you!  I need this badly!
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> 


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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

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

Re: Query help !!!

2001-06-22 Thread Regina Harter


Here is one way:

select distinct customer_id c1 where exists
(select 'X' from customer_id where customer_id = c1.customer_id and status 
= 'F')
and exists
(select 'X' from customer_id where customer_id = c1.customer_id and status 
<> 'F')

At 10:05 AM 6/22/01 -0800, you wrote:
>Just to clearfy my previous question (as follow):
>
>if 1 has F and A and B, that what I want.
>
>If 1 has F all the time, that's not what I want.
>If 1 has A, B, C, but never F, that's not what I want
>either.
>
>--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > If I have this:
> > Customer_id  Status
> > -- ---
> > 1   F
> > 1   A
> > 1   B
> > 2   F
> > 2   F
> > 3   A
> > 3   B
> >
> > How do I found out a customer who has both F and not
> > F
> > for them.  (If he only gets F, or gets other than F,
> > that's fine).  In this case, I should get 1.  Thank
> > you!  I need this badly!
> >
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.com/
> >
>
>
>__
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: 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: Regina Harter
  INET: [EMAIL PROTECTED]

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

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

RE: OT - interviewing your superior(fun question)


Ray, have you been not inhaling again?

;-)

-Original Message-
Sent: Friday, June 22, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


On Fri, Jun 22, 2001 at 08:11:03AM -0800, Kevin wrote:
> Ross, it's not that votes don't count, it's that most of the people don't
> know how to follow instructions or ask for help!  Besides, it's not the
> first election where something like that happened:)
> Kev
> 
> -Original Message-
> Sent: Thursday, June 21, 2001 11:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yes, the statement is different, but just based on the words in the
> sentence. "Playing a role in inventing"!=  "inventing".  Odd thing
> about words: they mean something.


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

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

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

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

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

RE: RE: Limiting Oracle Memory


:-)

Yes!  And anything you have, i'll be glad to try!

-Original Message-
Sent: Friday, June 22, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L


Ross have you stopped taking your medication again :)

Dave

Ross Mohan wrote 
Snip 

> a) I *like* NT, actually.


Snip 

-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Query help !!!

2001-06-22 Thread Jesse, Rich


Is 'F' the largest value?  If so, then:

SELECT
customer_id
FROM
( 
SELECT customer_id
, SUM(DECODE(status,'F',1,0)) stat_f
, SUM(DECODE(status,'F',0,1)) stat_no_f
FROM my_table
GROUP BY customer_id
)
WHERE stat_f > 0 AND stat_no_f > 0;

should work.  May not be the best way, but I THINK it'll get the job done!

Good luck!

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

STANDARD DISCLAIMER APPLIES! (Code is "as-is", no warranties, etc)

-Original Message-
Sent: Friday, June 22, 2001 12:52
To: Multiple recipients of list ORACLE-L


Hi,

If I have this:
Customer_id  Status
-- ---
1   F
1   A
1   B
2   F
2   F
3   A
3   B

How do I found out a customer who has both F and not F
for them.  (If he only gets F, or gets other than F,
that's fine).  In this case, I should get 1.  Thank
you!  I need this badly!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: Rule base optimizer selecting different execution path ( Tuning )


Brijesh
        There are few conditions where the optimizer will select CBO even when the optimizer_mode is set to rule. Do you have any objects in the schema with a parallelism >1 (tables and indexes) ? One of the common problem is that DBAs rebuild the index with higher parallelism and forget to change the parallelism back to noparallel. Parallelism >1 will turn on CBO. What is your optimizer_mode ? I assume it is rule. Let us know if not.
        Seeing hash_join in your second plan, I am positive that the CBO is being turned on. Do you have any hints in the code ? Does your session change the optimizer_goal at the session level by any chance ?

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






"Gupta, Brijesh" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/22/01 01:12 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Rule base optimizer selecting different execution path ( Tuning )


Hi All, 
        Can somebody help me in understanding this. 
We have a query which runs faster on development and not on production. 
When I checked the trace , it using different execution path on both database. 
Database is 8.0.5 running oracle application and the optimizer is RULE. 
Does anybody know why two execution path oracle optimizer has selected when its a RULE base optimizer. 
I know that is possible if its cost base optimizer but in rule it should be same right ( All the indexes are same on both database )
Only thing I did was rebuild some of the indexes on Test instance. 
Thanks 
Brijesh 
Here is the explain plan of both the database. 


* Development Database *** 
Optimizer goal: RULE 
Parsing user id: 45  (APPS) 
 
select 
substr(mil.segment1||'.'||mil.segment2||'.'||mil.segment3,1,45) Locator, 
mmt.subinventory_code Subinventory, 
msi.segment1 PART_NO, 
mmt.transaction_uom UOM, 
sum(mmt.transaction_quantity) 
from 
mtl_item_locations mil, 
mtl_transaction_types typ, 
mtl_material_transactions mmt, 
mtl_system_items msi, 
mtl_parameters mp 
where 
mp.organization_code='768' 
and mp.organization_id+0=msi.organization_id 
and msi.organization_id=mmt.organization_id 
and msi.inventory_item_id=mmt.inventory_item_id 
and trunc(mmt.transaction_date) between '01-APR-01' and '31-MAY-01' 
and mmt.transaction_type_id=typ.transaction_type_id 
and typ.transaction_type_name='Account alias receipt' 
and mmt.locator_id=mil.inventory_location_id(+) 
and mmt.organization_id=mil.organization_id(+) 
and mil.subinventory_code = 'CORROSIVE' 
group by mil.segment1, 
mil.segment2, 
mil.segment3, 
mmt.subinventory_code, 
msi.segment1, 
mmt.transaction_uom 
call     count       cpu    elapsed       disk      query    current        rows 
--- --   -- -- -- --  -- 
Parse        1      0.01       0.01          0          0          0           0 
Execute      1      0.00       0.00          0          0          0           0 
Fetch        2     51.68     901.33      85134     395083          0           4 
--- --   -- -- -- --  -- 
total        4     51.69     901.34      85134     395083          0           4 
Misses in library cache during parse: 0 
Optimizer goal: RULE 
Parsing user id: 45  (APPS) 
Rows     Execution Plan 
---  --- 
      0  SELECT STATEMENT   GOAL: RULE 
      4   SORT (GROUP BY) 
     33    FILTER 
     32     NESTED LOOPS (OUTER) 
     33      NESTED LOOPS 
    132       NESTED LOOPS 
   2445        NESTED LOOPS 
      1         TABLE ACCESS (BY INDEX ROWID) OF 'MTL_PARAMETERS' 
      2          INDEX (RANGE SCAN) OF 'ORGANIZATION_CODE' 
                     (NON-UNIQUE) 
   2445         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'MTL_SYSTEM_ITEMS' 
   2446          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'MTL_SYSTEM_ITEMS_N1' (NON-UNIQUE) 
 194874        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'MTL_MATERIAL_TRANSACTIONS' 
 846350         AND-EQUAL 
 500017          INDEX (RANGE SCAN) OF 'ORGANIZATION_ID' 
                     (NON-UNIQUE) 
 348778          INDEX (RANGE SCAN) OF 'INVENTORY_ITEM_ID' 
                     (NON-UNIQUE) 
    132       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'MTL_TRANSACTION_TYPES' 
    132        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                   'MTL_TRANSACTION_TYPES_U1' (UNIQUE) 
     32      TABLE ACCESS (BY INDEX ROWID) OF 'MTL_ITEM_LOCATIONS' 
     32       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'MTL_ITEM_LOCATIONS_U1' (UNIQUE)

RE: Undocumented Init.Ora Parms

2001-06-22 Thread Mark Leith


DUHHH!! Now why didn't I think of that!! Having had to deal with installs of
our products on a couple of NUMA-Qs it should have sprung to mind - Guess
I'm still in holiday mode - or coffee deprived (I suspect both :)

Having said that - I still didn't know what NUMA stood for - Thanks for the
info Scott, Jared & Hannibal!

Regards

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, June 22, 2001 06:02
To: Multiple recipients of list ORACLE-L


Non Uniform Memory Access (aka, Sequent machines? NUMA-Q?)  Check O'Reilly's
website, they have an excerpt from Oracle Parallel Processing:

"Non Uniform Memory Access systems Non Uniform Memory Access (NUMA) systems
consist of several SMP systems that are interconnected in order to form a
larger system. All of the memory in all of the SMP systems are connected
together to form a single large memory space. NUMA systems run one copy of
the operating system across all nodes."

http://www.oreilly.com/catalog/oraclepp/chapter/ch01.html

Scott Shafer
San Antonio, TX
210-581-6217

"Do not throw cigarette butts in the urinal.  It makes them soggy and hard
to light."

> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 10:11 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Undocumented Init.Ora Parms
>
> Taking a look at these parameters, I notice that the first two relate to a
> "NUMA POOL"? What is this? If anyone has read any of Clive Custlers novels
> -
> they would think "National Underwater & Marine Agency" :)
>
> Any insight oh list gurus?
>
> Cheers
>
> Mark
>
> -Original Message-
> Gramolini
> Sent: Friday, June 22, 2001 03:21
> To: Multiple recipients of list ORACLE-L
>
>
> Here is a script that will list all of the undocumented parameters.  I got
> is from one of the lists.
>
> select KSPPINM,
> nvl(KSPPSTVL,'NULL'),
> KSPPDESC
> from x$ksppi x, x$ksppcv y
> where x.INDX = y.INDX
> and translate(KSPPINM,'_','#') like '#%'
> order by KSPPINM;
>
> HTH,
> Ruth
>
--
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: 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).

Oracle 8.1.6 and Web Server 4.0.8.2 - session specific temporary

2001-06-22 Thread Grabowy, Chris


A developer is struggling with a temporary table issue.  He created a
session specific temporary table, and is executing two procedures from the
web server.  The first procedure populates the temporary table, but the
second procedure does not see that data.  He has worked with another DBA,
they tracked his session, and it appears to be the same session.  The
developer went on and checked his session # from the session as he is
running the procedures and it is the same session #.  When he tries this
from SQL*Plus it works fine.  

Since the data is not there, it appears that they are executing from two
different sessions, but there testing seems to say otherwise.  They searched
Metalink and didn't find relevant articles.

Any ideas?  Has anyone been in this particular situation?

Many thanks!!!

Chris 
"May Oracle be with you...always"
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

RE: Query help !!!

2001-06-22 Thread Toepke, Kevin M


SELECT *
FROM customer c1
WHERE  status = 'F'
AND   EXISTS (SELECT 1 
   FROM customer c2
WHERE c2.customer_id = c1.customer_id
AND c2.status != 'F');

-Original Message-
Sent: Friday, June 22, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L


Just to clearfy my previous question (as follow):

if 1 has F and A and B, that what I want.

If 1 has F all the time, that's not what I want.
If 1 has A, B, C, but never F, that's not what I want
either.

--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> If I have this:
> Customer_id  Status
> -- ---
> 1   F
> 1   A
> 1   B
> 2   F
> 2   F
> 3   A
> 3   B
> 
> How do I found out a customer who has both F and not
> F
> for them.  (If he only gets F, or gets other than F,
> that's fine).  In this case, I should get 1.  Thank
> you!  I need this badly!
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> 


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

2001-06-22 Thread Rocky Welch


Hi Leslie,
This will be crude but it's a start. Gang, feel free to correct/improve:

select customer_id
from 
where 
customer_id in (select customer_id from  where status = 'F')
and
customer_id in (select customer_id from  where status = 'A')
and
customer_id in (select customer_id from  where status = 'B');

Pretty messy and resource intensive but it should work.

HTH,
-Rocky

--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Just to clearfy my previous question (as follow):
> 
> if 1 has F and A and B, that what I want.
> 
> If 1 has F all the time, that's not what I want.
> If 1 has A, B, C, but never F, that's not what I want
> either.
> 
> --- Leslie Lu <[EMAIL PROTECTED]> wrote:
> > Hi,
> > 
> > If I have this:
> > Customer_id  Status
> > -- ---
> > 1   F
> > 1   A
> > 1   B
> > 2   F
> > 2   F
> > 3   A
> > 3   B
> > 
> > How do I found out a customer who has both F and not
> > F
> > for them.  (If he only gets F, or gets other than F,
> > that's fine).  In this case, I should get 1.  Thank
> > you!  I need this badly!
> > 
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.com/
> > 
> 
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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).


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

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

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

2001-06-22 Thread Ron Thomas



FWIR, recerate the table as user sys but specify a different tablespace.  Does not 
require synonyms,
views, act of vodoo, etc.

Ron
[EMAIL PROTECTED]
[EMAIL PROTECTED]

"Karaoke- Japanese for migraine."



   

BNorrell@Quad  

raMed.comTo: [EMAIL PROTECTED]  

Sent by: cc:   

root@fatcity.Subject: RE: Auditing 

com

   

   

06/22/01   

10:05 AM   

Please 

respond to 

ORACLE-L   

   

   





I did this about 3 years ago, so either Oracle plugged the hole, or I am not 
remembering correctly.
Maybe it is a  public synonym, or try create view sys.aud$ as select * from 
system.aud$.  That
sounds vaguely familiar...



Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


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



Hi Norrell,


I just tested ur case.


Can you tell me, how it's possible , when doing auditing, oracle will refer to the 
sys.aud$ table
itself, correct?.


If i droped it (even there is a synonym on that name),


Oracle giving an error, it's not able to find the sys.aud$ table.


Nirmal,


 -Original Message-
 From:   Norrell, Brian [SMTP:[EMAIL PROTECTED]]
 Sent:   Thursday, June 21, 2001 6:33 PM
 To: Multiple recipients of list ORACLE-L
 Subject:RE: Auditing


 aud$ is one of the few system tables that can have an owner other than sys.
 You can create it under another schema (like system) and give sys a private
 synonym pointing to system.aud$.  Then put the trigger on the alternate aud$


 create table system.aud$ as select * from sys.aud$;
 drop table sys.aud$;
 create synonym sys.aud$ for system.aud$;
 create trigger x on system.aud$ as ...


 Brian Norrell
 Manager, MPI Development
 QuadraMed
 511 E John Carpenter Frwy, Su 500
 Irving, TX 75062
 (972) 831-6600





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





 This will not work as you can't create triggers on sys objects.
 So tell me the way how i should create triggers on aud$.


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





 i think u can use triggers such kind of auditing.
 create aud$ table with one more column, and try updating the column as soon
 user fires some sql.


 this is just a thought. could find another opinion.


 saurabh
 - Original Message -
 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 Sent: Thursday, June 21, 2001 11:15 AM





 > Hi all there,
 > I am auditing a database where 400 users are concurrently accessing the
 > database.
 > Now in the table AUD$ we have all the records of the user transactions.But
 > is there any way to store what sort of query he is running so that i can
 see
 > the actual text of query which was fired 3 days before.
 > Regards,
 > Anand
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Anand
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE

Re: Deadlock Detection

Hi Anita
        If it is an ITL problem, then the resource type would be TX instead of DX. If the ITL table is full then the process requesting an ITL entry in that block will randomly select one of the transaction holding an ITL entry and wait for that process to complete or rollback. Since the process will wait for a transaction and as you are well aware of, the transaction id is a slot in a rollback segment and hence the enqueue type would be TX. Since this trace indicates that it is a DX type enqueue I would incline to think that this is a distributed transaction problem. Feel free to correct me if I am missing something..

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

"A. Bardeen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/22/01 10:50 AM
Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Deadlock Detection

Tom,

The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:

> Rows waited on:
> Session 27: no row

"No row" indicates that the deadlock is due to a lack
of available ITL slots in the datablock.

Unfortunately resolving this requires recreating the
object with either a high initrans value (to
explicitly reserve space for more ITL slots) or a
higher pctfree value (to give the ITL table more room
to grow).

Depending on the application it could also be that
multiple sessions are acquiring the same block off the
free list so using multiple free lists could also
help.  Starting with 8.1.6 this setting can be changed
dynamically; prior to that you must recreate the
object.

Note: 62365.1 also has some good info

HTH,

-- Anita

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> All,
> 
> My current application (still under development) is
> experiencing Oracle
> deadlock problems.  The applications people are
> performing stress testing
> where the application is being repeatedly called
> simulating actual users
> hitting the database.
> 
> The application is written using VB thru ADO and
> COM, Oracle 816 on NT.
> 
> My problem is that, while I can review the trace
> file produced, I can't
> figure out what the actual deadlock is occurring on.
>  I have seen deadlock
> trace files that clearly state "table blah", but in
> this case, I get:
> 
> 
> *** 2001-06-21 14:32:03.841
> *** SESSION ID:(27.31211) 2001-06-21 14:32:03.810
> DEADLOCK DETECTED
> Deadlock graph:
>                        -Blocker(s)
> -Waiter(s)-
> Resource Name          process session holds waits 
> process session holds
> waits
> DX-003b-        22      18     X        
>     24      27
> X
> session 18: DID 0001-0018-003C                 session 27: DID
> 0001-0018-003C
> Rows waited on:
> Session 27: no row
> *** 2001-06-21 14:32:03.857
> ksedmp: internal or fatal error
> ORA-00060: deadlock detected while waiting for
> resource
> 
> Is there something like TKPROF that will process the
> trace file and give me
> more info on what is happening?  It looks like I am
> waiting for a resource
> to be freed, but which one is the question.
> 
> thanks for any help.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>

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

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

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

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

Query help !!!

2001-06-22 Thread Leslie Lu


Hi,

If I have this:
Customer_id  Status
-- ---
1   F
1   A
1   B
2   F
2   F
3   A
3   B

How do I found out a customer who has both F and not F
for them.  (If he only gets F, or gets other than F,
that's fine).  In this case, I should get 1.  Thank
you!  I need this badly!

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

Rule base optimizer selecting different execution path ( Tuning )

2001-06-22 Thread Gupta, Brijesh

Title: Rule base optimizer selecting different execution path ( Tuning )





Hi All,
    Can somebody help me in understanding this.
We have a query which runs faster on development and not on production.
When I checked the trace , it using different execution path on both database.
Database is 8.0.5 running oracle application and the optimizer is RULE.


Does anybody know why two execution path oracle optimizer has selected when its a RULE base optimizer.
I know that is possible if its cost base optimizer but in rule it should be same right ( All the indexes are same on both database )

Only thing I did was rebuild some of the indexes on Test instance.


Thanks
Brijesh


Here is the explain plan of both the database.




* Development Database ***
Optimizer goal: RULE
Parsing user id: 45  (APPS)



select
substr(mil.segment1||'.'||mil.segment2||'.'||mil.segment3,1,45) Locator,
mmt.subinventory_code Subinventory,
msi.segment1 PART_NO,
mmt.transaction_uom UOM,
sum(mmt.transaction_quantity)
from
mtl_item_locations mil,
mtl_transaction_types typ,
mtl_material_transactions mmt,
mtl_system_items msi,
mtl_parameters mp
where
mp.organization_code='768'
and mp.organization_id+0=msi.organization_id
and msi.organization_id=mmt.organization_id
and msi.inventory_item_id=mmt.inventory_item_id
and trunc(mmt.transaction_date) between '01-APR-01' and '31-MAY-01'
and mmt.transaction_type_id=typ.transaction_type_id
and typ.transaction_type_name='Account alias receipt'
and mmt.locator_id=mil.inventory_location_id(+)
and mmt.organization_id=mil.organization_id(+)
and mil.subinventory_code = 'CORROSIVE'
group by mil.segment1,
mil.segment2,
mil.segment3,
mmt.subinventory_code,
msi.segment1,
mmt.transaction_uom


call count   cpu    elapsed   disk  query    current    rows
--- --   -- -- -- --  --
Parse    1  0.01   0.01  0  0  0   0
Execute  1  0.00   0.00  0  0  0   0
Fetch    2 51.68 901.33  85134 395083  0   4
--- --   -- -- -- --  --
total    4 51.69 901.34  85134 395083  0   4


Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 45  (APPS)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: RULE
  4   SORT (GROUP BY)
 33    FILTER
 32 NESTED LOOPS (OUTER)
 33  NESTED LOOPS
    132   NESTED LOOPS
   2445    NESTED LOOPS
  1 TABLE ACCESS (BY INDEX ROWID) OF 'MTL_PARAMETERS'
  2  INDEX (RANGE SCAN) OF 'ORGANIZATION_CODE'
 (NON-UNIQUE)
   2445 TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
    'MTL_SYSTEM_ITEMS'
   2446  INDEX   GOAL: ANALYZED (RANGE SCAN) OF
 'MTL_SYSTEM_ITEMS_N1' (NON-UNIQUE)
 194874    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
   'MTL_MATERIAL_TRANSACTIONS'
 846350 AND-EQUAL
 500017  INDEX (RANGE SCAN) OF 'ORGANIZATION_ID'
 (NON-UNIQUE)
 348778  INDEX (RANGE SCAN) OF 'INVENTORY_ITEM_ID'
 (NON-UNIQUE)
    132   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
  'MTL_TRANSACTION_TYPES'
    132    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
   'MTL_TRANSACTION_TYPES_U1' (UNIQUE)
 32  TABLE ACCESS (BY INDEX ROWID) OF 'MTL_ITEM_LOCATIONS'
 32   INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
  'MTL_ITEM_LOCATIONS_U1' (UNIQUE)










**  TEST Database  ***
Optimizer goal: RULE
Parsing user id: 45  (APPS)



select
substr(mil.segment1||'.'||mil.segment2||'.'||mil.segment3,1,45) Locator,
mmt.subinventory_code Subinventory,
msi.segment1 PART_NO,
mmt.transaction_uom UOM,
sum(mmt.transaction_quantity)
from
mtl_item_locations mil,
mtl_transaction_types typ,
mtl_material_transactions mmt,
mtl_system_items msi,
mtl_parameters mp
where
mp.organization_code='768'
and mp.organization_id+0=msi.organization_id
and msi.organization_id=mmt.organization_id
and msi.inventory_item_id=mmt.inventory_item_id
and trunc(mmt.transaction_date) between '01-APR-01' and '31-MAY-01'
and mmt.transaction_type_id=typ.transaction_type_id
and typ.transaction_type_name='Account alias receipt'
and mmt.locator_id=mil.inventory_location_id(+)
and mmt.organization_id=mil.organization_id(+)
and mil.subinventory_code = 'CORROSIVE'
group by mil.segment1,
mil.segment2,
mil.segment3,
mmt.subinventory_co

Re: Query help !!!

2001-06-22 Thread Leslie Lu

Just to clearfy my previous question (as follow):

if 1 has F and A and B, that what I want.

If 1 has F all the time, that's not what I want.
If 1 has A, B, C, but never F, that's not what I want
either.

--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> If I have this:
> Customer_id  Status
> -- ---
> 1   F
> 1   A
> 1   B
> 2   F
> 2   F
> 3   A
> 3   B
> 
> How do I found out a customer who has both F and not
> F
> for them.  (If he only gets F, or gets other than F,
> that's fine).  In this case, I should get 1.  Thank
> you!  I need this badly!
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> 

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

Re: OT - interviewing your superior(fun question)

2001-06-22 Thread Ray Stell


On Fri, Jun 22, 2001 at 08:11:03AM -0800, Kevin wrote:
> Ross, it's not that votes don't count, it's that most of the people don't
> know how to follow instructions or ask for help!  Besides, it's not the
> first election where something like that happened:)
> Kev
> 
> -Original Message-
> Sent: Thursday, June 21, 2001 11:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yes, the statement is different, but just based on the words in the
> sentence. "Playing a role in inventing"!=  "inventing".  Odd thing
> about words: they mean something.


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

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

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

OT: RE: Limiting Oracle Memory

2001-06-22 Thread Dave Morgan


Ross have you stopped taking your medication again :)

Dave

Ross Mohan wrote 
Snip 

> a) I *like* NT, actually.


Snip 

-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

2001-06-22 Thread Danisment Gazi Unal (Unal Bilisim)


Hello Johnson,

There are great papers at
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/

But, I still disagree with you. Becasue, tuning SORT will not make benefit
in your case.

yes, you are right, it's not easy to generate good SQL if SQL is generated
by end-users. I don't know your design, perhaps, you can add hidden
indexed-columns to generated SQLs to make end-users to use indexes.

regards...

Johnson Poovathummoottil wrote:

>  Hi Danisment Gazi Unal,
>
> Itprof's suggestion is valid that I should be able to
> use an index to speed up this query.
>
> But my objective here is to help sorting. Many users
> write adhoc queries to into my warehouse and all are
> not going to be tuned queries. Many go for full
> tablescans  on some big fact tables and sort like
> hell.
>
> We do have some good indexes for often used queries.
> But it is the adhoc one which people cook up that hurt
> us bad.
>
> So my intention is to tune sorts. In that light could
> you give me an explanation for the query running slow
> because the sort_area_size was increased?
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Johnson Poovathummoottil
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

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

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


:)

my pleasure!

-Original Message-
Sent: Friday, June 22, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L


I like that idea Ross, maybe I'll just bring all of you DBA geniouses in and
you guys can corner him with a hot cattle prod:)
Thanks again for all of your help Rossinater!
Kev

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


yea, you're on the right trackif he says
"I can't" claim you have found a guru who can
and you want to bring him in for an interview.

Then, watch the creativity unfurl from his
puckered sphincter.


As for DBMS_APPLICATION, it's a real thang. rtfm,
it's interesting even if you don't use it

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


All right, I am not DBASTUD, you're using big words!!:)  I am all over the
idea of having him split up the code.  I recommended doing it with script
files that way we could end the session after the first run, free up the ram
and the vm and then start the process again.  But he says he can't do it.  I
will continue to try and convince him.  So ah...yeah, what is this
dbms_application, or am I falling for a Rossism?

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


yea, have him break his code into modules and
try to track it down that way.

or, do it the right way and use dbms_application.



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


I would love to speak more of this mythical code, but that would require me
to understand the cryptic inner sanctum of the code of P.Dorsey and his
developers!!  I will speak to the developer, see what I can squeeze out of
him without getting shot!!
KK

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


soa PL/SQL table?.can you say more
about the code in question without violating
the cryptic inner sanctum of Dulcian?

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


DBMS_PIPE.down('Ross');,
Thanks for not destroying me with your mental powers:)  I am
concerned
about the size because it is completely hosing the machine.  The worst part
is, it is ONE connection that is doing it.  No one else is connected to the
db, but once this migration begins, POW, the memory goes to town and the
machine eats it.
So what I was hoping to do was set a limit on Oracle, let it have
600 megs
and finish the job.  Yes, it would probably be slower, but at least the
server wouldn't die.  Once it dies that's it, it has to be done all over
again.  I am going to talk to the developer and see if we can do this whole
thing differently, unless I can figure out how to use ora_workingsetmax!!
Thanks again:)
Kev

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


:)

a) I *like* NT, actually.
b) that's "DBMS_PIPE.down('Ross'); to you, Buster"
c) oracle, as a process, should include EVERYTHING
on the box having to do w/Oracle with the
exception of the listener. Including user
connects, i believe700MBytes is not at
all large in that context

Do this:  track user sessions and memory over time.

if they grow commensurately...then there is no leak.

if there are monotonic jumps in the latter w/o any in
the former, you may well have a leak, and you'll need
to move to the thread level to find it, likely.

I am sure Jared and Mladen will be glad to help you
with deep internal NT questions. 

hth

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


Hi all,
I have a procedure that seems to be bringing my server to it's
knees.
Winnt, Oracle 817 (Pipe down Ross:))
Anyway, what happens is a pl/sql table is placed into memory and then later
on it will be written to the disk.  However, by the time the process is
about to get to the writing part the machine is dead.  The Oracle.exe
process is well over 700MBs and the Virtual Memory is over a gig and a
half!!  Is there anyway for me to limit this, I tried using the registry
entry ORA_WORKINGSETMAX, however that doesn't seem to work.  Has anyone used
this setting?  Are you just supposed to put a number in the entry?  I put
600 but nothing happens.  Any help would be greatly appreciated.


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

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

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

To REMOVE yourself from this mailing list

RE: How to do a bitwise OR from SQL*Plus




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

Greg,

I wrote an article on encryption that may be of some use.  It uses external
procedures
and includes information on setting it up.

Like many things Oracle, it's much easier to setup than the documentation
makes
it appear.

You'll  find it at www.cybcon.com/~jkstill/util

Jared



-- 
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: Deadlock Detection


wow. great post. 

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


Tom,

The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:

> Rows waited on:
> Session 27: no row

"No row" indicates that the deadlock is due to a lack
of available ITL slots in the datablock.

Unfortunately resolving this requires recreating the
object with either a high initrans value (to
explicitly reserve space for more ITL slots) or a
higher pctfree value (to give the ITL table more room
to grow).

Depending on the application it could also be that
multiple sessions are acquiring the same block off the
free list so using multiple free lists could also
help.  Starting with 8.1.6 this setting can be changed
dynamically; prior to that you must recreate the
object.

Note: 62365.1 also has some good info

HTH,

-- Anita

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> All,
> 
> My current application (still under development) is
> experiencing Oracle
> deadlock problems.  The applications people are
> performing stress testing
> where the application is being repeatedly called
> simulating actual users
> hitting the database.
> 
> The application is written using VB thru ADO and
> COM, Oracle 816 on NT.
> 
> My problem is that, while I can review the trace
> file produced, I can't
> figure out what the actual deadlock is occurring on.
>  I have seen deadlock
> trace files that clearly state "table blah", but in
> this case, I get:
> 
> 
> *** 2001-06-21 14:32:03.841
> *** SESSION ID:(27.31211) 2001-06-21 14:32:03.810
> DEADLOCK DETECTED
> Deadlock graph:
>-Blocker(s)
> -Waiter(s)-
> Resource Name  process session holds waits 
> process session holds
> waits
> DX-003b-22  18 X
> 24  27
> X
> session 18: DID 0001-0018-003Csession 27: DID
> 0001-0018-003C
> Rows waited on:
> Session 27: no row
> *** 2001-06-21 14:32:03.857
> ksedmp: internal or fatal error
> ORA-00060: deadlock detected while waiting for
> resource
> 
> Is there something like TKPROF that will process the
> trace file and give me
> more info on what is happening?  It looks like I am
> waiting for a resource
> to be freed, but which one is the question.
> 
> thanks for any help.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

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

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

Can DBA*Studio run on the Web through a browser?

2001-06-22 Thread Szecsy Tamas


Hi,

is it possible to run DBA*Studio 8.1.7 on the Web through a browser?

Thanks in advance.

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

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

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



> Taking a look at these parameters, I notice that the first two relate to
a
> "NUMA POOL"? What is this? If anyone has read any of Clive Custlers
novels -
> they would think "National Underwater & Marine Agency" :)

Mark,

NUMA is a shared memory bus architecture for Intel chips, it's been
around for about 6 years now.


It allows a box to do things like run NT and Unix simultaneously.  Sequent
( now IBM ) and some other can do this.

There are various incarnations of the acronym:

  Non Uniform Memory Access
  Non-Uniform Memory Allocation (Sequent)
  Non-Uniform Memory Architecture

Jared


-- 
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: Calculating of the Median of Data

2001-06-22 Thread Kevin Lange


Khedr;
  That was the kind of thing I was looking for.   A simple select
(relatively) that can be added to another data select that I have for a
report I am producing for a client.

Thanks

And thanks to all that answered !

Kevin

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


What about this:
SQL> create table median ( c1 number );

Table created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (3);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
3

SQL> 
SQL> 
SQL> insert into median values (6);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
4

Regards,

Waleed



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


Does anyone have a handy function for calculating the Median of data ??  It
seems like it should be simple ...but

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


Thank you Jeremiah

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


This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:

strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
sort | uniq

The typical location for underscore parameters is x$ksppi:

(as SYS:)
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';

The event codes (most of them) are documented in
$ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 21 Jun 2001, Kevin Lange wrote:

>   Is there any place that has a list of ALL the things you can put into
the
> Init file and what they do ??   Not just the regular  option strings I
> can get a list of these from a couple of web sites , but all of the hidden
,
> and as far as I know, undocumented EVENT strings as well??

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

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

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

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

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

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

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

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

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

RE: Calculating of the Median of Data

2001-06-22 Thread Kevin Lange


Waleed;
  Well, I am afraid, its not going to be this simple on my version of
Oracle, 8.0.5.   Apparently, you can not do an order by in the from
statement on this version so I can not get the crucial order of the data.

Thanks anyway.  I may have to resort to an pl/sql function.

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


What about this:
SQL> create table median ( c1 number );

Table created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (1);

1 row created.

SQL> insert into median values (3);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> insert into median values (5);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
3

SQL> 
SQL> 
SQL> insert into median values (6);

1 row created.

SQL> select avg(c1) 
  2  from (select count(*) m_count from median) A,
  3   (select c1, rownum b_rownum from (select c1 from median order by
c1)) B
  4  where b_rownum between (m_count / 2) and (m_count / 2) +1;

  AVG(C1)
-
4

Regards,

Waleed



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


Does anyone have a handy function for calculating the Median of data ??  It
seems like it should be simple ...but

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


Thank you Jeremiah

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


This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:

strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
sort | uniq

The typical location for underscore parameters is x$ksppi:

(as SYS:)
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';

The event codes (most of them) are documented in
$ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 21 Jun 2001, Kevin Lange wrote:

>   Is there any place that has a list of ALL the things you can put into
the
> Init file and what they do ??   Not just the regular  option strings I
> can get a list of these from a couple of web sites , but all of the hidden
,
> and as far as I know, undocumented EVENT strings as well??

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

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

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

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

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

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

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

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

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

exp performance question ( direct=y)

2001-06-22 Thread Guang Mei


Oracle : 8.0.5
Platform : Sun


Currently we have cron job every night (starting from 11pm) to do export. I 
changed the setting "direct" to "y" two days ago while leaving all other 
parameters unchanged, hoping to gain some performance. I am a bit surprused 
to find that it did not. It actually took longer to create dump file with 
less data to export. The whole exp process takes about 2 hours to finish. 
Yes, there could be lots of other unix processes running during that time. 
But I would still expect to see some improvement because we are doing this 
way for quite a while. So my questions are:

1. From your "real" export experience, how much performance boost did you 
see when you set "direct=y"?

2. If "direct=y" improves the performance, why would anyone want to use  
"direct=n"?

Thanks.

Guang

-- here is my orcle dump file's time stamp:
(dmp.1 and dmp.2 are from direct=y,
dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r--   1 mt   prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r--   1 mt   prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r--   1 mt   prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r--   1 mt   prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r--   1 mt   prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz


--here is the parameter file:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

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

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

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

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