date:20030821

Hi!

It can happen with tar as well, I believe..

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 7:59 PM


 These wouldn't happen to be NFS filesystems would they?  Or written too by
rcp or something like that.  The number is the file owner's uid and if that
uid is not in the system passwd file, it will just show the number.  I have
typically seen this when uid and usernames do not match up across several
platforms and there is a lot of file movement going on.

 HtH,

 John P Weatherman
 Oracle Database Administrator
 Replacements, Ltd.



 -Original Message-
 Sent: Wednesday, August 20, 2003 11:54 AM
 To: Multiple recipients of list ORACLE-L


  Hello All,

  Why someof the directories will have ownership as
  some number . I
  observed this many times.

  what is this behaviour  ?( OS : Solaris 2.8)


  drwxrwxrwx   2 709  ftp 4096 May 16
  13:34 franceusexternal
  drwxrwxrwx   2 709  ftp 4096 May 16
  13:34 franceusinterco
  drwxr-xrwx   2 oracle   dba 4096 Jul 15
  01:03 gemssaexternal

  Thanks and Regards,
  Srinivas



 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: kommareddy sreenivasa
   INET: [EMAIL PROTECTED]

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

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



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

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

Re: Forms 3 and 9i

Title: Message



None, except forms 3 isn't supported for long time now, thus 
it probably doesn't work. And if it seems to work at first sight, you can't rely 
on it. You're on your own.

Tanel.


  - Original Message - 
  From: 
  Senthil Kumar 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 21, 2003 1:59 
  PM
  Subject: Forms 3 and 9i
  
  Hi All,
  
  Will forms 3 works with 9i. Any known issues in 
  this.
  
  TIA,
  Senthil.

RE: cursor_sharing in 8.1.7.4 - good or bad

2003-08-21 Thread Fedock, John (KAM.RHQ)



Thanks to all for the advice.  I plan to test sometime soon and will post results on 
how it works for us.

John

-Original Message-
Sent: Wednesday, August 20, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L


Like I said, it works fine here, but then again I also said, YMMV:


MYSID;/usr/oracle uname -a
HP-UX mybox B.11.00 .
MYSID;/usr/oracle sqlplus /

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Aug 20 10:43:20 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL select value from v$parameter where name = 'cursor_sharing';

VALUE
--
FORCE

SQL Select 'the current date is: '||sysdate from dual;

'THECURRENTDATEIS:'||SYSDA
-
the current date is: 20-AUG-03

SQL Select 'the current date is: '||sysdate from dual; 

'THECURRENTDATEIS:'||SYSDA
-
the current date is: 20-AUG-03

SQL exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production


Rich

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



-Original Message-
Sent: Wednesday, August 20, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L


NO...do not use. It is bugged. I believe it is fixed in 9x. It has problems
with core dumps/600 errors when executing SQL statements depending on their
length. It was not fixed as of 8.1.7.3, and I seem to remember it not
supposed to being fixed until 9x.
this statement might fail.
Select 'the current date is: '||sysdate from dual;
and this might succeed (only difference is an added space):
Select 'the current date is: '||sysdate from dual;
A consultant here supplied me with this info..as I was lookin at doing it
for ourselves.
Brian Spears
 
 
-Original Message-
Sent: Tuesday, August 19, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L


 Point noted. Excellent posts from both you and Walt. I guess that is what
the forum is for. To present one's experience without trashing someone
else's point of view. 

Since you have first hand experience on the latest I guess John should
listen to both of you first.  Thanks



Jesse, Rich [EMAIL PROTECTED] wrote:
True, but using binds isn't always an option, like when running a 3rd party
product. I also could not justify weeks of recoding homegrown software for
the relatively minor gains we would have using binds. And scalability (or
lack thereof) didn't seem to be argument enough.

We're using CS=F on 8.1.7.4 on HP/UX 11.0. We haven't yet had a single
issue attributable to it in the 7 months we've been at the .4 release.
There were some nasty issues with 8.1.7.2 (ORA-600 and silently returning
WRONG data), but like I said, .4 seems to have cleaned that up. YMMV.

Remember that under 8i, you may see some performance DROP by using binds.
The case that comes to mind is if you're using histograms with ANALYZE or
DBMS_STATS. Under 8i, the optimizer can no longer see the values and
therefore can't use the histograms. Under 9i (R2 only?), you can tell the
optimizer to peek at the bind variables' values in order to make use of
histograms. We plan on doing this when we get to 9i in order to use a very
low cardinality index, where less than 0.0001% of the rows is what we need
to fetch, but 8i won't use the index because of the cardinality.

Your best bet, of course, is to test! HTH! GL! :)


Rich

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



-Original Message-
Sent: Tuesday, August 19, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L


Hi,
No. I recommend that you do not change cursor_sharing if you are doing it
just to get rid of 4031. There could be serious problems. ora-600 etc. Maybe
Oracle has fixed everything in latest 817 but I suggest not to take that
chance.
For 4031 you can do the following : pin pl/sql sql preferably at startup,
use bind variables and periodically check fo! r sql not using bind
variables.
Goodluck. 


Fedock, John (KAM.RHQ) wrote:

Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel I
need to use it due to literal SQL statements being used. We have had misc
4031 errors off and on and I feel this is my last hope. I have a very busy
OPFS server (HP-UX). 

I did try using cursor_sharing in 8.1.7.2, and I remember incorrect sorting
and other unexpected results happening.

Thanks for any input.


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

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

Re: Forms - as sysdba

Title: Forms - as sysdba



Try if it works if you put sys/sys as sysdba to 
forms username prompt? (without quotes)
But why do you want to connect as sysdba 
anyway?

Tanel.


  - Original Message - 
  From: 
  Robo 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 21, 2003 11:54 
  AM
  Subject: Forms - as sysdba
  
  Hi all, I 
  have a 9.2.0.3 DB and I need 
  to connect to Forms 6i as user sys. There are 3 boxes for 
  username, password and database.
  I tried a lot of combinations, 
  eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba 
  sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error 
  message - either 
  invalid username/password or TNS error (can't recognize the connect 
  string). I have also 
  tried it from command line but didn't succeed. 
  Does anyone know if/how is it 
  possible?Thanks a lot Robert Pipich

Re: patches applied to RDBMS

Database  technology stack patches aren't recorded in AD_ tables in Apps.
Only patches going to APPL_TOP are.
And OP probably has just DB anyway.

Tanel.


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 9:44 AM


 select * from ad_bugs usually works unless the patch uses the Runinstaller
 to install.  Is this for a straight database or an Apps installation?

 Lon

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 11:49 AM


  Hi All,
 
   OS: Solaris 2.8
   DB: 8i/9i
 
   Is there a way to know whether a patch has been
   applied to the Oracle RDBMS (except lsinventory).
 
  I guess there shouldbe some log/history file that will
  have this info. but can't re-call now.
 
  can somebody through some light.
 
   Thanks and Regards,
   Srinivas
 
 
 
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free, easy-to-use web site design software
  http://sitebuilder.yahoo.com
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: kommareddy sreenivasa
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 

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

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



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

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

Re: question on how to retrive document

Hi!

 Of course, you could give IFS a shot.  I would still go with CLOBS if
 I were you. You can do bfiles, but hten you have to set NFS server
 and you can retrieve the document only if you have access to something
 called /docs/oracle/bfile or similar, and that is rather hard to do
 from an NT station. You can also store an ASCII file as an external

You can read BFILEs without having client access to the file. As long Oracle
has access to the file, it can open it  stream it to you.
But if you want write access to these files you have to do it from OS or
with utl_file or similar packages. Gets too complicated to use if your end
users want to modify those docs, but it could work if you're loading your
doc's once and they are only read afterwards.

But yes, internal lobs can be fast if implemented properly.

Tanel.



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

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

Re: Forms - as sysdba



Rather, why do you want to connect as SYS ?
If you've created some custom tables in the SYS schema in an earlier
version, 
create another user, connect as SYS in sqlplus, GRANT privileges to that
user
and connect as that new user in Forms. -- and think about migrating the
tables
out of the SYS schema.
If you are querying standard tables, OEM provides good views for most of
what
you need and the group here can provide better SQL scripts
anyway.
Hemant
At 07:29 AM 21-08-03 -0800, you wrote:
Try if it
works if you put sys/sys as sysdba to forms username prompt? (without
quotes)
But why do you want to connect as sysdba
anyway?

Tanel.


- Original Message - 
From: Robo 
To: Multiple recipients of
list ORACLE-L 
Sent: Thursday, August 21, 2003 11:54 AM
Subject: Forms - as sysdba

Hi all, 
I have a 9.2.0.3 DB and I need to connect
to Forms 6i as user sys. There are 3 boxes for username, password and
database.
I tried a lot of combinations, eg: 
Username: sys as sysdba

Password: sys 

Database: db 
sys/[EMAIL PROTECTED] as sysdba 
sys/[EMAIL PROTECTED] /as sysdba 
sys/[EMAIL PROTECTED] 'as sysdba' 
sys/[EMAIL PROTECTED] '/as sysdba' 
But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). 
I have also tried it from command line but didn't succeed. 

Does anyone know if/how is it possible?

Thanks a lot 
Robert Pipich 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

RE: logging oracle error code and message into a table within pro

Title: RE: logging oracle error code and message into a table within procedu



sorry  none ... remove the formal parameters ...

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Basavaraja, Ravindra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 
  20, 2003 10:31 PMTo: '[EMAIL PROTECTED]'Cc: 
  Jamadagni, RajendraSubject: RE: logging oracle error code and 
  message into a table within pro
  When 
  i call the log_errors in the exception block what should i give the aruguments 
  for the procedure.?
  
  thanks
  
-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 
12:54 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: logging oracle error code and message into a 
table within pro
sorry 
 should be ...

 insert into error_log (error_ts, ora_user, error_text, call_stack)  values 
(sysdate, user, szerrors,szcalls); 

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 


  -Original Message-From: Jamadagni, Rajendra 
  Sent: Thursday, July 31, 2003 3:45 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: logging oracle error 
  code and message into a table within pro
  create or replace log_errors (in_errors varchar2, in_calls 
  varchar2) is szerrors 
  varchar2(1000) := dbms_utility.format_error_stack; szCalls varchar2(1000) := 
  dbms_utility.format_call_stack; pragma 
  autonomous_transaction; begin  szerrors :=  insert into 
  error_log (error_ts, ora_user, error_text)  
  values (sysdate, user, szerrors);  
  commit; end; / 
  
  begin ... exception  when others 
  then  log_errors; 
   -- for benefit of the program 
  ...  raise; 
  end; / 
  something like this should help ... Raj  
  Rajendra dot Jamadagni at nospamespn dot com 
  All Views expressed in this email are strictly 
  personal. QOTD: Any clod can have facts, having an 
  opinion is an art ! 
  -Original Message- From: 
  Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, July 31, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: logging oracle error code and message into a table 
  within procedu 
  Hi All, 
  I want to log the oracle error code and messages that will 
  be generated within a procedure/trigger 
  into a table. 
  I know i can write this in the exception block.Does anyone 
  has any sample code to help me out. 
  thanks ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra 
   INET: [EMAIL PROTECTED] 
  Fat City Network Services -- 
  858-538-5051 http://www.fatcity.com San Diego, California -- 
  Mailing list and web hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in the message BODY, 
  include a line containing: UNSUB ORACLE-L (or the 
  name of mailing list you want to be removed from). You may 
  also send the HELP command for other information (like 
  subscribing). 
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Re: Forms 3 and 9i



I was about to say wouldn't work
But considering that Oracle Applications 10.7 Character-mode Forms
2.4 works with 8.1.7,
yes, why not ? [although 2.4 might actually be a higher version
than 3.0 as 2.4
was specifically built for Apps 10.7 and the Y2K upgrades while 3.0
predates Y2K].
Of course, you won't be supported.
Hemant
At 02:59 AM 21-08-03 -0800, you wrote:
Hi All,

Will forms 3 works with 9i. Any known issues in
this.

TIA,
Senthil.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hi!

I've always wondered why 3 syncs. Is it quaranteed,
that after *exactly 3* syncs everything has been written to disk? Or it more
like that after that number of syncs, most of the changes should be on disk?
(sounds stupid)

Tanel.

- Original Message -
From:
Tim Gorman

To: Multiple recipients of list ORACLE-L

Sent: Thursday, August 21, 2003 12:04
AM
Subject: Re: URGENT!!! My 9i databases
are not shutting down cleanly/cons
Id suggest throwing a couple ALTER SYSTEM
CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the
subsequent STARTUP (and just to make me feel better)...Does anyone
remember the UNIX mantra of entering sync; sync; sync before halt?
:-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:
We
have started waiting 90 min then do shutdown abort, startup, shutdown
immediateApril Wells
Oracle DBA/Oracle Apps
DBA Corporate Systems
Amarillo
Texas Few people really enjoy the simple pleasure of flying a
kite Adam Wells age 11

-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August
20, 2003 12:54 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting
down cleanly/consWhich
brings up that thread of - if they are hard to shutdown and possibly going
to crash anyway then . why not just wait some period of time and do
the old shutdown abort.
-Original
Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003
1:00 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not
shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have
trouble getting them to shutdown elegantly... and they sometimes
crashApril Wells Oracle
DBA/Oracle Apps DBA Corporate Systems Amarillo
Texas Few people really enjoy the simple pleasure of
flying a kite Adam Wells age 11
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday,
August 20, 2003 11:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not
shutting down cleanly/consBTW, nothing happening in terms of processes that would
hang-up the system. Also, I have check alert and trace files and
there are no obvious errors.
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday,
August 20, 2003 12:25 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not
shutting down cleanly/consThere seems to be a problem with
consistent shutdowns in 9i Oracle 9i
64bit 9.0.1.3.0 - infrastructure
database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are
running. Does anyone have problems
shutting down their databases consistently with 9i?
The
information contained in this communication, including attachments, is
strictly confidential and for the intended use of the addressee
only; it may also contain proprietary, price sensitive, or legally
privileged information. Notice is hereby given that any disclosure,
distribution, dissemination, use, or copying of the information by
anyone other than the intended recipient is strictly prohibited and
may be illegal. If you have received this communication in error,
please notify the sender immediately by reply e-mail, delete this
communication, and destroy all copies.Corporate
Systems, Inc. has taken reasonable precautions to ensure that any
attachment to this e-mail has been swept for viruses. We
specifically disclaim all liability and will accept no
responsibility for any damage sustained as a result of software viruses
and advise you to carry out your own virus checks before opening any
attachment.The
information contained in this communication, including attachments, is
strictly confidential and for the intended use of the addressee only; it
may also contain proprietary, price sensitive, or legally privileged
information. Notice is hereby given that any disclosure, distribution,
dissemination, use, or copying of the information by anyone other than
the intended recipient is strictly prohibited and may be illegal. If you
have received this communication in error, please notify the sender
immediately by reply e-mail, delete this

SHARED Memory Sema phores on SUN / LINUX for Oracle.

2003-08-21 Thread Veeraraju_Mareddi

Dear Friends,

Any good article to explain the above subject, SHARED Memory  Sema phores
on SUN / LINUX for Oracle. I just know what is shared memory , sema phores
are. But never involved practically much. Please also send me some typical
configurations , with explanation(if possible )

Please send me details about ur UNIX production Oracle systems, and lot of
examples. Any good we site with pictorial information.

NOTE: This is just for information only.

Thanks  a lot. 
Regards
Rajuveera
** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

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

Re: Re: Row level security and latch waits

2003-08-21 Thread Nuno Souto

Interesting.  I didn't get Connor's reply...

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 1:49 AM


 so in 9i dbms_rls increases the soft parses? 
  
  From: Connor McDonald [EMAIL PROTECTED]
  Date: 2003/08/20 Wed AM 11:21:59 EDT
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: Re: Re: Row level security and latch waits
  
  My understanding was that the rls predicate was added
  at parse time (hence the importance of the contexts
  and  avoiding things like 'sysdate')
  
  But also if I remember correctly, this behaviour was
  changed in v9 to process the security function with
  each execution (and hence probably increase the amount
  of parsing going on).
  
  You might want to have a play the the
  _dynamic_policies parameter (or something like that)
  which can be used to revert the 8i behaviour (which
  should reduce parsing to a degree)
  
  hth
  connor
  
   --- Nuno Souto [EMAIL PROTECTED] wrote: 
  - Original Message - 
   
- Use context values within predicates, as bind
   variables NOTE THIS
LINE.


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

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

Re: URGENT!!! My 9i databases are not shutting down



Habit. The sync command is picked up by the scheduler
sched and may not be executed immediately.
With three sync calls, at least one goes through by the time
you are ready to type in shutdown or init
0
Hemant
At 08:04 AM 21-08-03 -0800, you wrote:
Hi!

I've always wondered why 3 syncs. Is it
quaranteed, that after *exactly 3* syncs everything has been written to
disk? Or it more like that after that number of syncs, most of the
changes should be on disk? (sounds stupid)

Tanel.

- Original Message - 
From: Tim Gorman 
To: Multiple recipients of
list ORACLE-L 
Sent: Thursday, August 21, 2003 12:04 AM
Subject: Re: URGENT!!! My 9i databases are not shutting down
cleanly/cons

Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just
prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and
just to make me feel better)...

Does anyone remember the UNIX mantra of entering sync; sync; sync
before halt? :-)



on 8/20/03 11:09 AM, April Wells at
[EMAIL PROTECTED] wrote:

We have started waiting 90 min then do shutdown abort, startup,
shutdown
immediate
April Wells

Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. 
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash
April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

There seems to be a problem with consistent shutdowns in 9i 

Oracle 9i 64bit 
9.0.1.3.0 - infrastructure database that comes with the application server 
9.2.0.1.0 - that is the version of RDBMS we are running. 

Does anyone have problems shutting down their databases consistently with 9i? 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


Hemant K Chitale
Oracle 9i

RE: Collaboration Suite

2003-08-21 Thread Loughmiller, Greg

Title: RE: Collaboration Suite





we have it as a trial. I'll go along with the ability to admin the product... this version is tough to admin. 
greg


-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 21, 2003 2:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Collaboration Suite



Brian:


I have just implemented OCS for one of our client in the middle east
and it will be live from this month end. It is working like a charm.
Let me know if you have any specific questions. I will try to answer.


Basically it is an excellent product for end users and not so good
for administrators (at least the current versions)




Best Regards,
K Gopalakrishnan





-Original Message-
Brian Haas
Sent: Wednesday, August 20, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L



Hello all,


We're looking at Oracle collaboration suite and I'm wondering if anyone
here is
using it? If so, how is it working? Any issues? I know Oracle corp is using
it
for all their internal mail so I assume it could handle our 500 or so users
just
fine.


Thanks,



-Brian




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


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



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


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

RE: 9i on Redhat9 agent does not start...

2003-08-21 Thread Anjan Thakuria

Title: Message



Thanks 
Julio,

But 
that didnt work either..

Maybe 
I need to reinstall both Linux and 9i.

Thanks

Anjan

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  QuijadaReina, Julio CSent: Wednesday, August 20, 2003 7:54 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  9i on Redhat9 agent does not start...
  
  Anjan,
  
  Kind of strange there 
  is no lib32 dir under your $ORACLE_HOME. Hummm. try setting the following on 
  the users .profile or on your users shell startup file:
  
  LD_LIBRARY_PATH = 
  $ORACLE_HOME/lib
  LD_LIBRARY_PATH_64 = 
  $ORACLE_HOME/lib
  
  Maybe oracle is 
  looking for 64 bit library files!
  
  
  Julio 
  
  
  -Original 
  Message-From: Anjan 
  Thakuria [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 
  20, 2003 3:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: 9i on 
  Redhat9 agent does not start...
  
  
  Gurus,
  
  
  
  Would 
  appreciate any help that I can get on this...
  
  
  
  I have 
  9.2.0.1 on redhat 9 ...
  
  
  
  However 
  I cannot seen to start the agent on the server...
  
  
  
  agentctl 
  start just bails out.. no messages...
  
  
  
  This 
  what I see in the dbsnmp.nohup
  
  
  
  /db/app/oracle/product/9.2.0/bin/dbsnmp: 
  error while loading shared libraries: libvppdc.so: cannot open shared object 
  file: No such file or directoryAgent exited at Wed Aug 20 
  12:33:26 
  CDT 2003 with return 
  value 127Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 
  12:33:26 
  CDT 
  2003
  
  
  
  libvppdc.so file 
  exists in the location ORACLE_HOME/lib and it is a 32 bit 
  file..
  
  
  
  
  
  Thanks 
  in advance...
  
  
  
  Anjan

Re: OEM



I am able to use OEM 9.2.0.1 against 8.0.4-8.0.6 and 8.1.6-8.1.7
databases.  
Hemant

At 08:59 AM 20-08-03 -0800, you wrote:
Does OEM
9.2.0.1 works well with 8.1.7.4 database ? or in general with all
versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db
version and sends commands appropriately . Any Idea ?

thanks,
-ak


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

RE: 9i on Redhat9 agent does not start...

2003-08-21 Thread Anjan Thakuria

Thanks Ron,

Looks like that is what I might have to do -- reinstall 

But thanks anyway..

Anjan

-Original Message-
Rogers
Sent: Thursday, August 21, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L


Anjan,
 Check the otn site for the instructions on installing Oracle 9i on RedHat
Linux 9.
http://otn.oracle.com/sample_code/tutorials/idclinux/Oracle9iR2onredhat9.htm
l

You might have missed a critical step.
Ron.


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

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

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

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

Re: RAC - lms process

2003-08-21 Thread K Gopalakrishnan

Robert:

It is normal behavior only. But you didn't say about the OS and Cluster
Software. Make sure you use the highspeed private interconnect for the
block transfer between instances. I have seen in many sites public
interconnect has used for cache transfer.

Other than that, you may want to try bindling lms process to the
specific processor if your OS supports that. And also increasing the
priority also helps.

And there is an underscore parameter where you can change the lock down
converts, you can try that after checking with Oracle Support !




--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
 Running RAC on 9.2.0.3 the lms processes seem to be very busy.
 Anyone
 have any thoughts on that?
 
 Robert
 -- 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

RE: Collaboration Suite

Title: RE: Collaboration Suite

I'd ask the sales rep how many times the email server crashed ...
g or rather how long it has been up continuously and which release
too

Raj

Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !

-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21,
2003 11:01 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Collaboration Suite
we have it as a trial. I'll go along with the ability to
"admin" the product... this version is tough to admin. greg
-Original Message- From: K
Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 21, 2003 2:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Collaboration Suite
Brian:
I have just implemented OCS for one of our client in the
middle east and it will be live from this month end.
It is working like a charm. Let me know if you have
any specific questions. I will try to answer.
Basically it is an excellent product for end users and not so
good for administrators (at least the current
versions)
Best Regards, K Gopalakrishnan

-Original Message- Brian
Haas Sent: Wednesday, August 20, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Hello all,
We're looking at Oracle collaboration suite and I'm
wondering if anyone here is using it? If so, how is it working? Any issues? I know Oracle corp is
using it for all their
internal mail so I assume it could handle our 500 or so users just fine.
Thanks,
-Brian
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net -- Author: Brian Haas INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

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

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

Re: Row level security and latch waits - LONG email...

2003-08-21 Thread Madhavan Amruthur

Hi Nuno

 I don't think this is the issue at all.  The SQL in the function
 that generates the predicate WILL use bind variables and that
 is perfectly expected.  That's why you don't see an increase in parses
 on the SQL INSIDE the function.
 

That is correct. I should have posted the predicate clause generated and
I have posted that below

 What will not use bind variables is this bit:
 
  SQL select count(*) from dpr70_gl_acct_balance_f;
 
 because the added predicate is a string without bind syntax.

The added predicate for this is is using context as seen in the trace
file. This can be generated by setting event 10730

-
Logon user : SECUSER1
Table/View : DPA42HP92.DPR70_CURRENCY_D
Policy name: DPR70_CURRENCY_D_PLCY
Policy function:
DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION
RLS view :
SELECT  CURRENCY,CURRENCY_CODE,CURRENCY_DESC,CURRENCY_KEY FROM
DPA42HP9
2.DPR70_CURRENCY_D  DPR70_CURRENCY_D WHERE (CURRENCY_CODE in (select
value_
v
 from dp_security_values
where group_id in (select group_id from dp_upd_user_groups where
comp_group_id =
 sys_context('dp_comp_group_id_ctx','comp_group_id')) 

as you can see the context variable is being used in the generated
predicate clause

 However, I think if the added predicate string contains a reference
 to a context variable, which is what Tom is talking about, it might 
 well be the case this will act as a kind of bind variable
 even though the syntax is not the correct one. Anyone found if that
 is the case?

That was my point, that using the context variable in the predicate
clause will cause it to act like a bimnd variable and that is behaviour
that I have been seeing
Thanks
Madhavan
http://www.dpapps.com
-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://www.fastmail.fm - Choose from over 50 domains or use your own
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

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

RE: 9i on Redhat9 agent does not start...

2003-08-21 Thread John Dunn

Title: Message



see http://codah.net/install-oracle9iR2-on-redhat9.html

it 
might help. 




  -Original Message-From: Anjan Thakuria 
  [mailto:[EMAIL PROTECTED]Sent: 20 August 2003 
  20:05To: Multiple recipients of list ORACLE-LSubject: 9i 
  on Redhat9 agent does not start...
  Gurus,
  
  Would appreciate any help that I can get on 
  this...
  
  I 
  have 9.2.0.1 on redhat 9 ...
  
  However I cannot seen to start the agent on the 
  server...
  
  agentctl start just bails out.. no 
  messages...
  
  This 
  what I see in the dbsnmp.nohup
  
  /db/app/oracle/product/9.2.0/bin/dbsnmp: error while 
  loading shared libraries: libvppdc.so: cannot open shared object file: No such 
  file or directoryAgent exited at Wed Aug 20 12:33:26 CDT 2003 with return 
  value 127Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 
  2003
  
  libvppdc.so file exists in the location 
  ORACLE_HOME/lib and it is a 32 bit file..
  
  
  Thanks in advance...
  
  Anjan

RH not-so-Advanced 2.1 and new hardware

2003-08-21 Thread Jesse, Rich

We're trying to test/prove 9iRAC on a cheap setup.  Has anyone used newer
hardware when trying to install RH not-so-AS 2.1?  I've got an Intel
D845GERG2 motherboard and the old 2.4-9 kernel doesn't have a module for the
onboard ethernet.  Also, intel.com has a few Linux drivers for this MB, but
they require 2.4-11+.

I'm going to try and run -- shudder -- up2date, but I thought I'd ask
here, too, since I can't be the first to put up with this horse hockey.

TIA,
Rich

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

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

Re: cursor_sharing in 8.1.7.4 - good or bad

2003-08-21 Thread Daniel Fink

I was curious about your statement the kernel only peeks once per
session. I wondered if another session that executed the same statement
would be impacted by the peeking or would the optimizer reparse the
statement.

So I set up a test. Million row table with 2 columns. c1 - number, c2 -
date. C1 contains 2 distinct values 0 (999 rows) and 1 (999001 rows). I
analyzed the table and 'tried' to generate a 2 bucket histogram. However,
the num_buckets is still 1 on the column. When I run the query with a bind
variable, it always selects a FTS, regardless of the first value I place in
the variable.

I am obviously missing something, but I've run out of ideas. I 'think' the
problem is the number of buckets, but the analyze table column command
seems to think 1 bucket is enough.

Daniel


Cary Millsap wrote:

 And don't count too heavily upon 9i's bind value peek capability.
 Here's a simple test that Jonathan Lewis conjured up last year:

 PREPARATION. Create data for select c1, c2 from t1 where c1 = :bind1,
 where different bind1 values could have different paths if we used
 literals.

 1. flush shared pool
set bind1 = 5
execute query, notice an indexed access (optimal plan for bind1=5)
set bind1 = 70
execute query, notice that kernel still uses the index

 2. flush shared pool
set bind1 = 70
execute query, notice a table scan (optimal plan for bind1=70)
set bind1 = 5
execute query, notice that kernel still uses the table scan

 The moral: the kernel only peeks once per session.

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

 Upcoming events:
 - Hotsos Clinic 101 in Sydney
 - Hotsos Symposium 2004, March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...

 -Original Message-
 Jesse, Rich
 Sent: Tuesday, August 19, 2003 3:09 PM
 To: Multiple recipients of list ORACLE-L

 True, but using binds isn't always an option, like when running a 3rd
 party
 product.  I also could not justify weeks of recoding homegrown software
 for
 the relatively minor gains we would have using binds.  And scalability
 (or
 lack thereof) didn't seem to be argument enough.

 We're using CS=F on 8.1.7.4 on HP/UX 11.0.  We haven't yet had a single
 issue attributable to it in the 7 months we've been at the .4 release.
 There were some nasty issues with 8.1.7.2 (ORA-600 and silently
 returning
 WRONG data), but like I said, .4 seems to have cleaned that up.  YMMV.

 Remember that under 8i, you may see some performance DROP by using
 binds.
 The case that comes to mind is if you're using histograms with ANALYZE
 or
 DBMS_STATS.  Under 8i, the optimizer can no longer see the values and
 therefore can't use the histograms.  Under 9i (R2 only?), you can tell
 the
 optimizer to peek at the bind variables' values in order to make use of
 histograms.  We plan on doing this when we get to 9i in order to use a
 very
 low cardinality index, where less than 0.0001% of the rows is what we
 need
 to fetch, but 8i won't use the index because of the cardinality.

 Your best bet, of course, is to test!  HTH!  GL!  :)

 Rich

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

 -Original Message-
 Sent: Tuesday, August 19, 2003 2:49 PM
 To: Multiple recipients of list ORACLE-L

 Hi,
   No. I recommend that you do not change cursor_sharing if you are doing
 it
 just to get rid of 4031. There could be serious problems. ora-600 etc.
 Maybe
 Oracle has fixed everything in latest 817 but I suggest not to take that
 chance.
   For 4031 you can do the following : pin pl/sql sql preferably at
 startup,
 use bind variables and periodically check for sql not using bind
 variables.
 Goodluck.

 Fedock, John (KAM.RHQ) [EMAIL PROTECTED] wrote:

 Does anyone have any experience using cursor_sharing in 8.1.7.4?I
 feel I
 need to use it due to literal SQL statements being used.  We have had
 misc
 4031 errors off and on and I feel this is my last hope.  I have a very
 busy
 OPFS server (HP-UX).

 I did try using cursor_sharing in 8.1.7.2, and I remember incorrect
 sorting
 and other unexpected results happening.

 Thanks for any input.


 John
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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

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

Rman disk performance

2003-08-21 Thread Spears, Brian

Title: Message



Anybady have values of how many GIGS per HOUR they can 
Backup and RESTORE the database
using 
RMAN backup to disk.

What 
kind of machine, Memory, storage?

1) I 
am using cheap network attached disk 
2) I 
am getting about 40 Gigs an hour for Backup
3) I 
am getting about 34 Gigs an hour for Restore
4) 350 
Meg of SGA on an Hp9000

Anybody find a good way to improve performance other 
than increasing channels?

Cheers,
Thanks 
for any help


Brian SpearsSr. 
DBA[EMAIL PROTECTED] DC4 (614)577-2677 DC3 
(614)415-1398 Limitedbrands TECHNOLOGY 
SERVICES 

  -Original Message-From: Anjan Thakuria 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  12:24 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: 9i on Redhat9 agent does not start...
  Thanks Julio,
  
  But 
  that didnt work either..
  
  Maybe I need to reinstall both Linux and 9i.
  
  Thanks
  
  Anjan
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
QuijadaReina, Julio CSent: Wednesday, August 20, 2003 7:54 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
9i on Redhat9 agent does not start...

Anjan,

Kind of strange 
there is no lib32 dir under your $ORACLE_HOME. Hummm try setting the 
following on the user's .profile or on your user's shell startup 
file:

LD_LIBRARY_PATH = 
$ORACLE_HOME/lib
LD_LIBRARY_PATH_64 
= $ORACLE_HOME/lib

Maybe oracle is 
looking for 64 bit library files!


Julio 


-Original 
Message-From: Anjan 
Thakuria [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 
20, 2003 3:05 
PMTo: Multiple recipients of list 
ORACLE-LSubject: 9i on 
Redhat9 agent does not start...


Gurus,



Would 
appreciate any help that I can get on this...



I have 
9.2.0.1 on redhat 9 ...



However I cannot 
seen to start the agent on the server...



agentctl start just 
bails out.. no messages...



This 
what I see in the dbsnmp.nohup



/db/app/oracle/product/9.2.0/bin/dbsnmp: 
error while loading shared libraries: libvppdc.so: cannot open shared object 
file: No such file or directoryAgent exited at Wed Aug 20 
12:33:26 
CDT 2003 with return 
value 127Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 
12:33:26 
CDT 
2003



libvppdc.so file 
exists in the location ORACLE_HOME/lib and it is a 32 bit 
file..





Thanks 
in advance...



Anjan

wait event

2003-08-21 Thread Sai Selvaganesan

hi

i am trying to do some performance tuning.

null event is 9.2.0.3 is the number one in the list of 5 top wait events.what is this? i have gone through a few docs saying nothing to worry et al but i would like to understand this better.

thanks
sai

RE: Multiple parses with bind variables

2003-08-21 Thread Paul Baumgartel

Thanks for the replies.

I will also admit (sheepishly) that until today, I didn't realize that
the Misses in library cache during parse: line after each statement
in a trace file tells you how many of the parses for a statement were
hard parses.


--- Cary Millsap [EMAIL PROTECTED] wrote:
 Exactly! This is the thing that ora_check_sql=0 prevents when you
 use the Perl DBI. Then there's the problem of doing the prepare() 
 inside a
 loop. The way to fix that problem is to NEVER PARSE INSIDE A LOOP.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Hotsos Clinic 101 in Sydney
 - Hotsos Symposium 2004, March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 Josh Collier
 Sent: Wednesday, August 20, 2003 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 The application that is running this, or the connection thinger
 (ODBC,
 JDBC,
 DBI) is parsing it twice. They often do a describe before a parse,
 which
 results in two parses for every execution.
 
  945 * 2 = 1895
 
 
 Josh
 
 
 -Original Message-
 Sent: Wednesday, August 20, 2003 1:34 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Why should a query such as this, with bind variables and no literals,
 be parsed so many times?  Other queries in the trace show, for
 example,
 2 parses and 16 executions.  And while I'm at it, why does is the
 parse count shown equal to the SUM of executes and fetches?
 
 SELECT BENEFICIARY_FK, BENEFICIARY_PHONE_PK, PHONE_TYPE_FK,
 PHONE_NUMBER 
 FROM BENEFICIARY_PHONE WHERE COMPANY_FK = :V1 
 AND BENEFICIARY_FK IN ( :V2)
   
 
 
 call count   cpuelapsed   disk  querycurrent 
  
 
 --- --   -- -- -- -- 
 
 Parse 1890  0.21   0.17  0  0  0 
  

 Execute945  0.04   0.08  0  0  0 
  

 Fetch  945 38.48  43.24  0 620428  0
 
 
 
 =
 Paul Baumgartel
 Transcentive, Inc.
 www.transcentive.com
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Paul Baumgartel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Josh Collier
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Cary Millsap
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

RE: wait event

Sai - What was your database doing at the time? Sitting idle or were you
beating it up with some big queries?



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, August 21, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L


hi
 
i am trying to do some performance tuning.
 
null event is 9.2.0.3 is the number one in the list of 5 top wait
events.what is this? i have gone through a few docs saying nothing to worry
et al but i would like to understand this better.
 
thanks
sai

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

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

Re: Forms 3 and 9i

2003-08-21 Thread Peter Gram

Hi

Yes it is posible to use Forms 3.x agenst a version 9.x database.
My friend and coworker have implanted it at site on a sun box.
The way to do this is to install Forms 3.x ( 7.2.x dist ?)
in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH.
Set the unix environment var. TWO_TASK to point to a IPC alias
to the listener that can connect to the 9.x database.
The hard part is to find the Forms 4 patch (xx) it is not possible
to order it from Oracle support but I think it as distributed with
the 7.3.x Oracle database kit !


Senthil Kumar wrote:

Hi All,
 
Will forms 3 works with 9i. Any known issues in this.
 
TIA,
Senthil.


--
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail  : [EMAIL PROTECTED] - http://MiracleAS.dk
Upcoming events:
DatabaseForum 2003, Lalandia 2-4 October
Visit   http://miracleas.dk/events/DBF2003/invitation.html
Miracle Master Class with Tom Kyte, 12-14 January 2004



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

RE: wait event




wasn't is a bug that a bunch of stuff was classified as null wait event 
... wait it must be one of those (oracle) developer who still believes in 
BCHR.

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Sai Selvaganesan 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  1:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  wait event
  hi
  
  i am trying to do some performance tuning.
  
  null event is 9.2.0.3 is the number one in the list of 5 top wait 
  events.what is this? i have gone through a few docs saying nothing to worry et 
  al but i would like to understand this better.
  
  thanks
  sai
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: SHARED Memory Sema phores on SUN / LINUX for Oracle.

2003-08-21 Thread Vordos, Suzy

Here's what I have for Sun.  This info was derived from some docs at
SunSolve which I can't find anymore, and the Sun Perf Tuning book by Adrian
Cockcroft.
 
* --
* Semaphores/Shared Memory for ORACLE
* --
* shmmax = max size per shared memory segment
* shmmin = min size per shared memory segment
* shmmni = max num shared memory identifiers
* shmseg = max num shared memory segments per process
* semmns = max num semaphores system wide (=semmni*semmsl)
* semmni = max num semaphore sets system wide (=semmnu)
* semmsl = max num semaphores per semaphore set (=semopm)
* semmnu = max num sempahore undo structures (=semmni)
* semmap = max entries per semaphore map (=semmni*semmsl)
* semopm = max operations per semop call (=semmsl)
* semume = max undo entries per process (=semmsl)
* semvmx = max value of a semaphore (cannot be  32767)
 
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=4000
set semsys:seminfo_semmni=40
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmnu=40
set semsys:seminfo_semmap=4000
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767


-Original Message- 
Sent: Thu 8/21/2003 9:01 AM 
To: Multiple recipients of list ORACLE-L 
Cc: 



Dear Friends, 

Any good article to explain the above subject, SHARED Memory  Sema phores 
on SUN / LINUX for Oracle. I just know what is shared memory , sema phores 
are. But never involved practically much. Please also send me some typical 
configurations , with explanation(if possible ) 

Please send me details about ur UNIX production Oracle systems, and lot of 
examples. Any good we site with pictorial information. 

NOTE: This is just for information only. 

Thanks  a lot. 
Regards 
Rajuveera 
** 
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND 
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact 
the sender by email and delete all copies; your cooperation in this regard 
is appreciated. 
** 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
http://www.orafaq.net  
-- 
Author: Veeraraju_Mareddi 
  INET: [EMAIL PROTECTED] 

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

application/ms-tnef

RE: question on how to retrive document

Tanel, if you use oracle to read BFILE's, you're no faster then by reading
normal LOB's,
because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and
buffer sent to 
you through Oracle*Net. The only way that you can be faster then that is to
read the file 
name from a normal VARCHAR2 variable and then bypass oracle in accessing
that file, and 
access it through some non-oracle mechanism,typically NFS or CIFS (Samba).
Oracle database 
is created for reading structured tables by means of SQL, not for reading
plain files. 
To read a plain file, you will use software designed exactly for that
purpose. It's called 
file system.
Both NFSv3 and Samba V2 can beat oracle hands down in speed of
reading/writing files to
a remote node.  What Samba and NFS cannot do is to retrieve record sets from
those files
using SQL. They can help you to bulk read the file into a document processor
and nothing 
more. if speed is all that matters, you read the file name from oracle and
then read the
file by using appropriate tools like NFS, Samba or something else.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Tanel Poder
Sent: Thursday, August 21, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L


Hi!

 Of course, you could give IFS a shot.  I would still go with CLOBS if 
 I were you. You can do bfiles, but hten you have to set NFS server and 
 you can retrieve the document only if you have access to something 
 called /docs/oracle/bfile or similar, and that is rather hard to do 
 from an NT station. You can also store an ASCII file as an external

You can read BFILEs without having client access to the file. As long Oracle
has access to the file, it can open it  stream it to you. But if you want
write access to these files you have to do it from OS or with utl_file or
similar packages. Gets too complicated to use if your end users want to
modify those docs, but it could work if you're loading your doc's once and
they are only read afterwards.

But yes, internal lobs can be fast if implemented properly.

Tanel.



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

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



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

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

SharePlex info

Title: Message



Hi All, 

I'm trying to find some technical 
details about SharePlex, that is:

- How much network bandwidth I'd 
expect to replicate from database, generating 1-5 MB/sec redo. 
DoesSharePlex send SQL text over the network or data in some internal 
(hopefully compressed)format
- How much CPU on the source DB 
server side would it cost - just a ball park - very little- little - or a 
lot 
- Of two options, using 9.2 
physical async standby db and clone whole database vs replicate 50% (enough from 
business requirements) of tables using SharePlex, which onesounds 
preferrable keeping in mind minimizing CPU burden on the source database. 


Any opinion or pointer to any 
benchmark is highly appreciated. 

Thanks a 
lot
Vadim

RE: Oracle on RAID Case studies / Exaples

Rajuveera,
You probably want this article:
http://www.orapub.com/cgi/genesis.cgi?p1=subp2=abs132

-Original Message-
Sent: Thursday, August 21, 2003 11:01 AM
To: Multiple recipients of list ORACLE-L


Dear Friends,

How are you ? I have read some book to know about Oracle on RAID. Have
understood better about various RAIDs. But Implementing Oracle on RAID , I
am not much clear.

My understaning is 

1. All files on RAID 1 +0 ( because its good in IO rates, better protective
)
2. Read only TS on RAID 5.(because its read intensive ).

He has given some examples ,but could explain it well, Can you please send
some case studies on RAID for Oracle.

Please send me details about ur production Oracle systems, and lot of
examples. Any good we site with pictorial information.

NOTE: This is just for information only.

Thanks  a lot. 
Regards
Rajuveera
** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle 9i memory Leaks and other errors

2003-08-21 Thread Bhavesh Lala



-Original Message-
Sent: Monday 18 August 2003 06:36
To: '[EMAIL PROTECTED]'


Hi

Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are
issues such as memory leaks and other issues or bugs. Has anyone doing data
warehousing or transaction processing encountered any issues with this
version of Oracle and what have you done to fix it. 

I have found errors with using FOR CURSOR loops - encountered problems with
it where it took extremely long to run due to a memory leak in Oracle. We
had to apply a patch to fix this. HAs anyone encountered any other problems
as DBAs or Developers?

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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Title: Message



It's a 
superstition. Whole christian mithology is based on the number 3. We have 
Holy Trinity, we have 3 places to go when we transcend 
into 
food for ants (paradise,purgatory, and the place with great demos) , we 
have 3 layers of personality, according to Freud (libido, ego, 
super-ego),
to 
make the whole story short, number 3 is sort of a mystical number in christian 
mithology. Now, please send me $3,333,333.33


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel 
  PoderSent: Thursday, August 21, 2003 12:05 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  Hi!
  
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written to disk? 
  Or it more like that after that number of syncs, most of the changes should be 
  on disk? (sounds stupid)
  
  Tanel.
  
- Original Message - 
From: 
Tim Gorman 

To: Multiple recipients of list ORACLE-L 

Sent: Thursday, August 21, 2003 12:04 
AM
Subject: Re: URGENT!!! My 9i databases 
are not shutting down cleanly/cons
Id suggest throwing a couple ALTER SYSTEM 
CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the 
subsequent STARTUP (and just to make me feel better)...Does anyone 
remember the UNIX mantra of entering sync; sync; sync before halt? 
:-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:
We 
  have started waiting 90 min then do shutdown abort, startup, shutdown 
  immediateApril Wells Oracle 
  DBA/Oracle Apps DBA Corporate Systems Amarillo 
  Texas Few people really enjoy the simple pleasure of flying 
  a kite Adam Wells age 11 
  
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 
20, 2003 12:54 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown 
and possibly going to crash anyway then . why not just wait some 
period of time and do the old shutdown abort. 

-Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 
  1:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we 
  have trouble getting them to shutdown elegantly... and they sometimes 
  crashApril Wells Oracle 
  DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
  Few people 
  really enjoy the simple pleasure of flying a kite Adam 
  Wells age 11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, 
August 20, 2003 11:50 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consBTW, nothing happening in terms of processes that would 
hang-up the system. Also, I have check alert and trace files 
and there are no obvious errors. 
-Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  August 20, 2003 12:25 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consThere seems to be a problem with 
  consistent shutdowns in 9i Oracle 9i 
  64bit 9.0.1.3.0 - infrastructure 
  database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are 
  running. Does anyone have problems 
  shutting down their databases consistently with 9i? 
  The 
  information contained in this communication, including attachments, is 
  strictly confidential and for the intended use of the addressee 
  only; it may also contain proprietary, price sensitive, or legally 
  privileged information. Notice is hereby given that any 
  disclosure, distribution, dissemination, use, or copying of the 
  information by anyone other than the intended recipient is 
  strictly prohibited and may be illegal. If you have received this 
  communication in error, please notify the sender immediately by reply 
  e-mail, delete this communication, and destroy all 
  copies.Corporate Systems, Inc. has taken reasonable 
  precautions to ensure that any attachment to this e-mail has been 
  swept for viruses. We

RE: URGENT!!! My 9i databases are not shutting down

2003-08-21 Thread John Kanagaraj

Title: Message



Tanel,

It is 
more like 'two is company, three is a crowd'. The 'sync; sync; sync' was used in 
the days of yore when the disk controller was flaky and you had a few seconds of 
'think time' on your hand in between commands. As Hemant says, it became a habit 
which still dogs me after 19 years - I have my (younger) colleagues here asking 
'what is sync'?

This 
was far better than my initial days when we used 8" AC Floppy drives whose speed 
varied with the electricity supply frequency and we had to use a frequency meter 
to note down the frequency during a floppy recording. [Btw - the term 'floppy' 
came from this media which was a flexible plastic based magnetic disk enclosed 
in a flexible - floppy - cover. And there was a 5 1/4" version before it finally 
became the 3 1/2" 'firm' disk]. I also worked on card punch IBM machines with 64 
Kb RAM and 2 Mb (that right 2 MB!) system drives.

Now 
back to Oracle stuff before Jared bears down on us :)

John


-Original 
Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 9:19 AMTo: Multiple 
recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are 
not shutting down
Habit. The "sync" 
  command is picked up by the scheduler "sched" and may not be executed 
  immediately.With three "sync" calls, at least one goes through by the time 
  you are ready to type in "shutdown" or "init 0"HemantAt 08:04 AM 
  21-08-03 -0800, you wrote:
  Hi!I've always wondered 
why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has 
been written to disk? Or it more like that after that number of syncs, most 
of the changes should be on disk? (sounds stupid)Tanel. 

  - Original Message - 
  From: Tim Gorman 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Thursday, August 21, 2003 12:04 AM 
  Subject: Re: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just 
  prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and 
  just to make me feel better)...
  Does anyone remember the UNIX mantra of entering "sync; sync; sync" 
  before "halt"? :-)
  on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
  wrote:
  We have started waiting 90 min then do shutdown abort, startup, 
  shutdown immediate 
  April Wells 
  Oracle DBA/Oracle Apps DBA 
  Corporate Systems 
  Amarillo Texas 
  Few people really enjoy the simple pleasure of flying a 
  kite 
  Adam Wells age 11 
  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 20, 2003 12:54 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Which brings up that thread of - if they are hard to shutdown and 
  possibly going to crash anyway then . why not just wait some period of 
  time and do the old shutdown abort. 
  -Original Message- 
  From: April Wells [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 20, 2003 1:00 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting 
  them to shutdown elegantly... and they sometimes crash 
  April Wells 
  Oracle DBA/Oracle Apps DBA 
  Corporate Systems 
  Amarillo Texas 
  Few people really enjoy the simple pleasure of flying a 
  kite 
  Adam Wells age 11 
  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 20, 2003 11:50 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  BTW, nothing happening in terms of processes that would hang-up the 
  system. Also, I have check alert and trace files and there are no 
  obvious errors. 
  -Original Message- 
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 20, 2003 12:25 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  There seems to be a problem with consistent shutdowns in 
  9i 
  Oracle 9i 64bit 
  9.0.1.3.0 - infrastructure database that comes with the application 
  server 
  9.2.0.1.0 - that is the version of RDBMS we are running. 
  Does anyone have problems shutting down their databases consistently 
  with 9i? The information contained in this communication, including 
attachments, is strictly confidential and for the intended use of the 
addressee only; it may also contain proprietary, price sensitive,

Re: Forms 3 and 9i

2003-08-21 Thread Smart Aleck DBA


.. and be sure to document for the next poor slob
that has to act as admin for this mess



On Thu, 21 Aug 2003, Peter Gram wrote:

 Hi

 Yes it is posible to use Forms 3.x agenst a version 9.x database.
 My friend and coworker have implanted it at site on a sun box.
 The way to do this is to install Forms 3.x ( 7.2.x dist ?)
 in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH.
 Set the unix environment var. TWO_TASK to point to a IPC alias
 to the listener that can connect to the 9.x database.

 The hard part is to find the Forms 4 patch (xx) it is not possible
 to order it from Oracle support but I think it as distributed with
 the 7.3.x Oracle database kit !



 Senthil Kumar wrote:

  Hi All,
 
  Will forms 3 works with 9i. Any known issues in this.
 
  TIA,
  Senthil.


 --
 Peter Gram, Miracle A/S
 Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
 mail  : [EMAIL PROTECTED] - http://MiracleAS.dk

 Upcoming events:
 DatabaseForum 2003, Lalandia 2-4 October
 Visit   http://miracleas.dk/events/DBF2003/invitation.html

 Miracle Master Class with Tom Kyte, 12-14 January 2004




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

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


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

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

Re: URGENT!!! My 9i databases are not shutting down

2003-08-21 Thread Joe Testa

John, thats just hilarious, i remember doing sync;sync;sync all the time 
and still once in a while type sync on a unix box :)

joe

John Kanagaraj wrote:

Tanel,
 
It is more like 'two is company, three is a crowd'. The 'sync; sync; 
sync' was used in the days of yore when the disk controller was flaky 
and you had a few seconds of 'think time' on your hand in between 
commands. As Hemant says, it became a habit which still dogs me after 
19 years - I have my (younger) colleagues here asking 'what is sync'?
 
This was far better than my initial days when we used 8 AC Floppy 
drives whose speed varied with the electricity supply frequency and we 
had to use a frequency meter to note down the frequency during a 
floppy recording. [Btw - the term 'floppy' came from this media which 
was a flexible plastic based magnetic disk enclosed in a flexible - 
floppy - cover. And there was a 5 1/4 version before it finally 
became the 3 1/2 'firm' disk]. I also worked on card punch IBM 
machines with 64 Kb RAM and 2 Mb (that right 2 MB!) system drives.
 
Now back to Oracle stuff before Jared bears down on us :)
 
John
 
 -Original Message-
*From:* Hemant K Chitale [mailto:[EMAIL PROTECTED]
*Sent:* Thursday, August 21, 2003 9:19 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* Re: URGENT!!! My 9i databases are not shutting down

Habit.  The sync command is picked up by the scheduler sched
and may not be executed immediately.
With three sync calls, at least one goes through by the time you
are ready to type in shutdown or init 0
Hemant
At 08:04 AM 21-08-03 -0800, you wrote:
Hi!
 
I've always wondered why 3 syncs. Is it quaranteed, that after
*exactly 3* syncs everything has been written to disk? Or it more
like that after that number of syncs, most of the changes should
be on disk? (sounds stupid)
 
Tanel.

- Original Message - 
From: Tim Gorman mailto:[EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L
mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 12:04 AM 
Subject: Re: URGENT!!! My 9i databases are not shutting down
cleanly/cons

I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT
commands just prior to the SHUTDOWN ABORT, to help speed up
the subsequent STARTUP (and just to make me feel better)...
Does anyone remember the UNIX mantra of entering sync; sync;
sync before halt?  :-)




on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
We have started waiting 90 min then do shutdown abort,
startup, shutdown immediate 
April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11

-Original Message- 
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:54 PM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons

Which brings up that thread of - if they are hard to shutdown
and possibly going to crash anyway then . why not just
wait some period of time and do the old shutdown abort.  
-Original Message- 
From: April Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:00 PM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble
getting them to shutdown elegantly... and they sometimes crash 
April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11

-Original Message- 
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 11:50 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons

BTW, nothing happening in terms of processes that would
hang-up the system.  Also, I have check alert and trace files
and there are no obvious errors.  
-Original Message- 
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:25 PM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons

There seems to be a problem with consistent shutdowns in 9i

Oracle 9i 64bit 
9.0.1.3.0 - infrastructure database that comes with the
application server

Re: Collaboration Suite

2003-08-21 Thread Tim Gorman

Brian,

We're using OCS Release 2 on Linux (RHAS2.1) internally (15 users).  We also
did a production install of OCS Release 2 on Linux RHAS2.1 for a customer in
NJ (100 users).  They are very happy and impressed with the OCS
functionality, especially iMeeting.  The price comparison to Exchange didn't
hurt, either...  :-)

By the way, both of these installs were on a single Dell server, which is
something that Oracle has not yet figured out how to do, apparently.  The
complicating issue is not collapsing everything onto a single server, which
is pretty straightforward (as with Oracle E-Business Suites).

Rather, it is more that a single-server install makes things more
complicated from a security perspective, as you have to be much more
specific about what ports are opened to the internet and which ports are
not.  As with Oracle E-Business Suites, OCS uses lots and lots of network
ports, but E-Biz is usually a purely intranet app and rarely (if ever?)
faces the big bad internet.  Believe me, put a server on the internet and
you *will* be hacked within 4 hours...

For 500 users, you'd definitely want a two-server configuration anyway, so
it's probably a moot point.  Let me know if you'd like some HW sizing info?

Hope this helps...

-Tim


on 8/20/03 2:49 PM, Brian Haas at [EMAIL PROTECTED] wrote:

 Hello all,
 
 We're looking at  Oracle collaboration suite and I'm wondering if anyone here
 is 
 using it? If so, how is it working? Any issues? I know Oracle corp is using it
 for all their internal mail so I assume it could handle our 500 or so users
 just 
 fine.
 
 Thanks,
 
 
 -Brian
 
 

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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Mercadante, Thomas F

Title: Message



how 
about if I send you $1,111,111.11 3 times.


  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  It's 
  a superstition. Whole christian mithology is based on the number 3. We 
  have Holy Trinity, we have 3 places to go when we transcend 
  
  into 
  food for ants (paradise,purgatory, and 
  the place with great demos) , we have 3 layers of personality, according to 
  Freud (libido, ego, super-ego),
  to 
  make the whole story short, number 3 is sort of a mystical number in christian 
  mithology. Now, please send me $3,333,333.33
  
  
  --Mladen GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Tanel PoderSent: Thursday, August 21, 2003 12:05 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
URGENT!!! My 9i databases are not shutting down 
cleanly/cons
Hi!

I've always wondered why 3 syncs. Is it 
quaranteed, that after *exactly 3* syncs everything has been written to 
disk? Or it more like that after that number of syncs, most of the changes 
should be on disk? (sounds stupid)

Tanel.

  - Original Message - 
  From: 
  Tim Gorman 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, August 21, 2003 12:04 
  AM
  Subject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  Id suggest throwing a couple ALTER SYSTEM 
  CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the 
  subsequent STARTUP (and just to make me feel better)...Does anyone 
  remember the UNIX mantra of entering sync; sync; sync before halt? 
  :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
  We have started waiting 90 min then do shutdown 
abort, startup, shutdown immediateApril 
Wells Oracle DBA/Oracle Apps DBA Corporate 
Systems Amarillo Texas 
Few people really 
enjoy the simple pleasure of flying a kite Adam 
Wells age 11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  August 20, 2003 12:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWhich brings up that thread of - if they are hard to 
  shutdown and possibly going to crash anyway then . why not just 
  wait some period of time and do the old shutdown abort. 
  
  -Original 
Message-From: April Wells 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 1:00 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we 
have trouble getting them to shutdown elegantly... and they 
sometimes crashApril 
Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
Few people 
really enjoy the simple pleasure of flying a kite Adam 
Wells age 11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  August 20, 2003 11:50 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consBTW, nothing happening in terms of processes that would 
  hang-up the system. Also, I have check alert and trace files 
  and there are no obvious errors. 
  -Original 
Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 12:25 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consThere seems to be a problem with consistent shutdowns in 
9i Oracle 9i 64bit 
9.0.1.3.0 - infrastructure database 
that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are 
running. Does anyone have problems 
shutting down their databases consistently with 9i? 
The 
information contained in this communication, including attachments, 
is strictly confidential and for the intended use of the 
addressee only; it may also contain proprietary, price 
sensitive, or legally privileged information. Notice is hereby given 
that any disclosure,

RE: Forms 3 and 9i

2003-08-21 Thread Mercadante, Thomas F

I think the real answer to the questions is - no, Forms 3 does not work with
9i.  You must convert it to Forms 6i.

Must put a stop to this stuff at some point.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 21, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L



.. and be sure to document for the next poor slob
that has to act as admin for this mess



On Thu, 21 Aug 2003, Peter Gram wrote:

 Hi

 Yes it is posible to use Forms 3.x agenst a version 9.x database.
 My friend and coworker have implanted it at site on a sun box.
 The way to do this is to install Forms 3.x ( 7.2.x dist ?)
 in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH.
 Set the unix environment var. TWO_TASK to point to a IPC alias
 to the listener that can connect to the 9.x database.

 The hard part is to find the Forms 4 patch (xx) it is not possible
 to order it from Oracle support but I think it as distributed with
 the 7.3.x Oracle database kit !



 Senthil Kumar wrote:

  Hi All,
 
  Will forms 3 works with 9i. Any known issues in this.
 
  TIA,
  Senthil.


 --
 Peter Gram, Miracle A/S
 Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
 mail  : [EMAIL PROTECTED] - http://MiracleAS.dk

 Upcoming events:
 DatabaseForum 2003, Lalandia 2-4 October
 Visit   http://miracleas.dk/events/DBF2003/invitation.html

 Miracle Master Class with Tom Kyte, 12-14 January 2004




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

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


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

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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Stefick Ronald S Contr ESC/HRIDD

Title: Message



Hey 
Tom, 
You 
can send me $111 3 times and I'll be happy! ;o)

-Scott 
Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
  21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how 
  about if I send you $1,111,111.11 3 times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
It's a superstition. Whole christian mithology is based on the 
number 3. We have Holy Trinity, we have 3 places to go when we transcend 

into food for ants (paradise,purgatory, 
and the place with great demos) , we have 3 layers of personality, according 
to Freud (libido, ego, super-ego),
to 
make the whole story short, number 3 is sort of a mystical number in 
christian mithology. Now, please send me $3,333,333.33


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Hi!
  
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written to 
  disk? Or it more like that after that number of syncs, most of the changes 
  should be on disk? (sounds stupid)
  
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
12:04 AM
Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"? :-)on 8/20/03 
11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do shutdown 
  abort, startup, shutdown immediateApril 
  Wells Oracle DBA/Oracle Apps DBA Corporate Systems 
  Amarillo 
  Texas Few people really enjoy the simple pleasure of 
  flying a kite Adam Wells age 11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, 
August 20, 2003 12:54 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not just 
wait some period of time and do the old shutdown abort. 

-Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 1:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 
  we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 11:50 AMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consBTW, nothing happening in terms of processes that 
would hang-up the system. Also, I have check alert and 
trace files and there are no obvious errors. 

-Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: 
  Wednesday, August 20, 2003 12:25 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
  My 9i databases are not shutting down 
  cleanly/consThere seems to be a problem with consistent shutdowns 
  in 9i Oracle 9i 64bit

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

I will not object to anything. You can send me $1 and I'll gladly take it

OT: DataType mapping between Oracle and SQL Server

2003-08-21 Thread Rick_Cale





Can someone post a URL or other reference where I can get a 1-1 mapping
where applicable of all Oracle datatypes to SQL Server.

Thanks
Rick

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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Paula_Stankus

Title: Message



Thanks 
for all the wonderful and interesting responses - esp. Tim Gorman. I think 
that is what I needed. Sorry to resurface that old issue again. 
Mladen, you too? Did the nuns hit your knuckles with a ruler as 
well?



  -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Hey 
  Tom, 
  You 
  can send me $111 3 times and I'll be happy! ;o)
  
  -Scott Stefick
  

-Original Message-From: Mercadante, 
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
21, 2003 1:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
how about if I send you $1,111,111.11 3 
times.


  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  2:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  It's a superstition. Whole christian mithology is based on 
  the number 3. We have Holy Trinity, we have 3 places to go when we 
  transcend 
  into food for ants (paradise,purgatory, 
  and the place with great demos) , we have 3 layers of personality, 
  according to Freud (libido, ego, super-ego),
  to make the whole story short, number 3 is sort of a mystical 
  number in christian mithology. Now, please send me 
  $3,333,333.33
  
  
  --Mladen GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Tanel PoderSent: Thursday, August 21, 2003 12:05 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Re: URGENT!!! My 9i databases are not shutting down 
cleanly/cons
Hi!

I've always wondered why 3 syncs. Is it 
quaranteed, that after *exactly 3* syncs everything has been written to 
disk? Or it more like that after that number of syncs, most of the 
changes should be on disk? (sounds stupid)

Tanel.

  - Original Message - 
  From: 
  Tim 
  Gorman 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, August 21, 2003 
  12:04 AM
  Subject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  I'd suggest throwing a couple ALTER 
  SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
  speed up the subsequent STARTUP (and just to make me feel 
  better)...Does anyone remember the UNIX mantra of entering 
  "sync; sync; sync" before "halt"? :-)on 8/20/03 
  11:09 AM, April Wells at [EMAIL PROTECTED] 
  wrote:
  We have started waiting 90 min then do shutdown 
abort, startup, shutdown immediateApril 
Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
Few people 
really enjoy the simple pleasure of flying a kite Adam 
Wells age 11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  August 20, 2003 12:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWhich brings up that thread of - if they are hard to 
  shutdown and possibly going to crash anyway then . why not 
  just wait some period of time and do the old shutdown abort. 
  
  -Original 
Message-From: April Wells 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 1:00 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
not shutting down cleanly/consWe do, Paula... both in 
9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown 
elegantly... and they sometimes 
crashApril Wells Oracle DBA/Oracle Apps 
DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure 
of flying a kite Adam Wells age 
11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: 
  Wednesday, August 20, 2003 11:50 AMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
  My 9i databases are not shutting down 
  cleanly/consBTW, nothing happening in terms of processes that

RE: DataType mapping between Oracle and SQL Server

2003-08-21 Thread Rothouse, Michael

Oracle Migration Workbench documentation

http://download-west.oracle.com/docs/cd/B10501_01/win.920/a97248/ch2.htm
#1026430

-Original Message-
Sent: Thursday, August 21, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L






Can someone post a URL or other reference where I can get a 1-1 mapping
where applicable of all Oracle datatypes to SQL Server.

Thanks
Rick

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

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

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

RE: Rman disk performance

Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  

copy some big files using file system commands like cp and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Title: Message



One thingI like about 'sync' is it will fail silently. i.e.., if 
you don't have privs, it will not complain but pretend that it completed 
successfully, which is correct, it completed successfully but didn't do 
anything.

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Thanks for all the wonderful and interesting responses - esp. Tim 
  Gorman. I think that is what I needed. Sorry to resurface that old 
  issue again. Mladen, you too? Did the nuns hit your knuckles with 
  a ruler as well?
  
  
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy! 
;o)

-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11 3 
  times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/cons
It's a superstition. Whole christian mithology is based on 
the number 3. We have Holy Trinity, we have 3 places to go when we 
transcend 
into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of 
personality, according to Freud (libido, ego, 
super-ego),
to make the whole story short, number 3 is sort of a mystical 
number in christian mithology. Now, please send me 
$3,333,333.33


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  Hi!
  
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written 
  to disk? Or it more like that after that number of syncs, most of the 
  changes should be on disk? (sounds stupid)
  
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
12:04 AM
Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"? :-)on 
8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do 
  shutdown abort, startup, shutdown 
  immediateApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 12:54 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not 
just wait some period of time and do the old shutdown abort. 

-Original 
  Message-From: April Wells

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Mercadante, Thomas F

Title: Message



"Did 
the nuns hit your knuckles with a ruler as well?"

three 
times for the father, son and holy ghost!


PS - 
Jared, is this enough???

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Thanks for all the wonderful and interesting responses - esp. Tim 
  Gorman. I think that is what I needed. Sorry to resurface that old 
  issue again. Mladen, you too? Did the nuns hit your knuckles with 
  a ruler as well?
  
  
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy! 
;o)

-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11 3 
  times.
  
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/cons
It's a superstition. Whole christian mithology is based on 
the number 3. We have Holy Trinity, we have 3 places to go when we 
transcend 
into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of 
personality, according to Freud (libido, ego, 
super-ego),
to make the whole story short, number 3 is sort of a mystical 
number in christian mithology. Now, please send me 
$3,333,333.33


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  Hi!
  
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written 
  to disk? Or it more like that after that number of syncs, most of the 
  changes should be on disk? (sounds stupid)
  
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
12:04 AM
Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"? :-)on 
8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do 
  shutdown abort, startup, shutdown 
  immediateApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 12:54 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not 
just wait some period of time and do the old shutdown abort. 

-Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 
  20, 2003 1:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
  not shutting down cleanly/consWe do, Paula... both 
  in 9.0.1.3 and 9.2.0.2 we have trouble getting them to

RE: Design question, historic and views

2003-08-21 Thread Stephane Paquette

The message did not generate many feedbacks.
Any feedback is welcome on the  historic and views questions.

Thanks

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Tuesday, August 19, 2003 10:37 AM
To: [EMAIL PROTECTED]


Hi,

In an ODS, it is feed in near real time during the day and pushes data to
the DW and other systems at night.
So it may need to keep several copies of the same data (several changes or
the DW can be offline so the the ODS may need to keep several days).

All tables have a surrogated PK and the PK from the source systems are used
as alternate non-unique keys.
All tables will have a DW_transfer indicator (yes/no)
There are 2 designs I can immediately think of :

1. I keep all the data in the same table and I use fields like
last_version_indicator (yes/no), start date, end date.
   This is fast since it implies inserting the new record and updating the
previous record.

2. The last version for each rows are kept in a table and the historic are
kept in a second table.Each table has its historic table. This implies
inserting in the core table, insert the previous record in the historic
table and deleting it.

3. another way ?

The ODS must answer the following:
All changes need to be transferred to the DW not only the last version.
End-users will query the ODS (I do not know yet if queries will access only
the last version or not).


Views.
In the case the solution1 is used. Would you used views to do the following
table_t : the table
table_last_version_v : view showing only the last version (with where
last_version_indicator='YES'), used for queries.


In both cases, would you used a view
table_not_transferred_v : view showing records with the
DW_transfer_indicator set to no, that view would be updated by the ETL
processes

or let the the programs do the where DW_transfer_indicator=no.


Thanks

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


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

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

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Jared . Still


Um, yeah.








Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2003 12:39 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: URGENT!!! My 9i databases are not shutting down cleanly/cons


Did the nuns hit your knuckles with a ruler as well?

three times for the father, son and holy ghost!


PS - Jared, is this enough???
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Thanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well?


-Original Message-
From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hey Tom, 
You can send me $111 3 times and I'll be happy! ;o)

-Scott Stefick
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

how about if I send you $1,111,111.11  3 times.

-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend 
into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego),
to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33


--
Mladen Gogala
Oracle DBA 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder
Sent: Thursday, August 21, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hi!

I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid)

Tanel.
- Original Message - 
From: Tim Gorman 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, August 21, 2003 12:04 AM
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...

Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-)



on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:

We have started waiting 90 min then do shutdown abort, startup, shutdown immediate

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. 
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons


There seems to

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Title: Message



Yes 
they did, despite the fact that Croatia had communism while I was growing 
up.


--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consUm, 
  yeah. 
  


  
  "Mercadante, Thomas F" 
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
08/21/2003 12:39 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:RE: URGENT!!! My 9i 
databases are not shutting down 
  cleanly/cons"Did the nuns hit your knuckles with a ruler as 
  well?"  three times for the father, son and holy 
  ghost!   PS - Jared, is this enough??? -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consThanks for 
  all the wonderful and interesting responses - esp. Tim Gorman. I think 
  that is what I needed. Sorry to resurface that old issue again. 
  Mladen, you too? Did the nuns hit your knuckles with a ruler as 
  well?   -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHey Tom, 
  You can send me $111 3 times and 
  I'll be happy! ;o)  -Scott 
  Stefick -Original 
  Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 
  1:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/conshow about if I 
  send you $1,111,111.11  3 times.  -Original 
  Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consIt's a 
  superstition. Whole christian mithology is based on the number 3. We 
  have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and 
  the place with great demos) , we have 3 layers of personality, according to 
  Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in 
  christian mithology. Now, please send me $3,333,333.33   --Mladen 
  GogalaOracle DBA -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: 
  Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHi!  I've 
  always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs 
  everything has been written to disk? Or it more like that after that number of 
  syncs, most of the changes should be on disk? (sounds stupid)  Tanel. - Original 
  Message - From: 
  Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases 
  are not shutting down cleanly/cons I'd 
  suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the 
  SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me 
  feel better)...Does anyone remember the UNIX mantra of entering "sync; 
  sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April 
  Wells at [EMAIL PROTECTED] 
  wrote:We have 
  started waiting 90 min then do shutdown abort, startup, shutdown 
  immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate 
  Systems Amarillo Texas Few people really enjoy the simple pleasure of 
  flying a kite Adam Wells age 11 -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 12:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consWhich 
  brings up that thread of - if they are hard to shutdown and possibly going to 
  crash anyway then . why not just wait some period of time and do the old 
  shutdown abort.  -Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 
  9.2.0.2 we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril Wells 
  Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo Texas 
  Few people really enjoy the 
  simple pleasure of flying a

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Thater, William






  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  4:04 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Um, yeah. [Shrek]
  sync
  sync
  sync
  
  move 
  thread to [EMAIL PROTECTED]
  
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA BAARF Party member #25
   
  [EMAIL PROTECTED]
  
  A 
  good intention but fixed and resolute - bent on high and holy ends, we shall 
  find means to them on every side and at every moment; and even obstacles and 
  opposition will but make us "like the fabled spectre-ships," which sail the 
  fastest in the very teeth of the wind. - Ralph Waldo 
  Emerson

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Paul Baumgartel

A couple of corrections are in order here.  First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
mythology.  Second, I thought we became food for worms, not ants.


--- Mladen Gogala [EMAIL PROTECTED] wrote:
 It's a superstition.  Whole christian mithology is based on the
 number 3. We
 have Holy Trinity, we have 3 places to go when we transcend 
 into food  for ants (paradise,purgatory, and the place with great
 demos) ,
 we have 3 layers of personality, according to Freud (libido, ego,
 super-ego),
 to make the whole story short, number 3 is sort of a mystical number
 in
 christian mithology. Now, please send me $3,333,333.33
  
  
 --
 Mladen Gogala
 Oracle DBA 
 
 
 -Original Message-
 Tanel Poder
 Sent: Thursday, August 21, 2003 12:05 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Hi!
  
 I've always wondered why 3 syncs. Is it quaranteed, that after
 *exactly 3*
 syncs everything has been written to disk? Or it more like that after
 that
 number of syncs, most of the changes should be on disk? (sounds
 stupid)
  
 Tanel.
 
 - Original Message - 
 To: Multiple recipients of list ORACLE-L
 mailto:[EMAIL PROTECTED]  
 Sent: Thursday, August 21, 2003 12:04 AM
 
 
 I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just
 prior to
 the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just
 to
 make me feel better)...
 
 Does anyone remember the UNIX mantra of entering sync; sync; sync
 before
 halt?  :-)
 
 
 
 on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:
 
 
 
 We have started waiting 90 min then do shutdown abort, startup,
 shutdown
 immediate
 
 April Wells 
 Oracle DBA/Oracle Apps DBA 
 Corporate Systems 
 Amarillo Texas 
 
 Few people really enjoy the simple pleasure of flying a kite 
 Adam Wells age 11 
 
 
 
 -Original Message-
 ]
 Sent: Wednesday, August 20, 2003 12:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Which brings up that thread of - if they are hard to shutdown and
 possibly
 going to crash anyway then . why not just wait some period of
 time and
 do the old shutdown abort.  
 
 
 -Original Message-
 Sent: Wednesday, August 20, 2003 1:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting
 them to
 shutdown elegantly... and they sometimes crash
 
 April Wells 
 Oracle DBA/Oracle Apps DBA 
 Corporate Systems 
 Amarillo Texas 
 
 Few people really enjoy the simple pleasure of flying a kite 
 Adam Wells age 11 
 
 
 
 -Original Message-
 ]
 Sent: Wednesday, August 20, 2003 11:50 AM
 To: Multiple recipients of list ORACLE-L
 
 
 BTW, nothing happening in terms of processes that would hang-up the
 system.
 Also, I have check alert and trace files and there are no obvious
 errors.  
 
 
 -Original Message-
 ]
 Sent: Wednesday, August 20, 2003 12:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 There seems to be a problem with consistent shutdowns in 9i 
 
 Oracle 9i 64bit 
 
 9.0.1.3.0 - infrastructure database that comes with the application
 server 
 9.2.0.1.0 - that is the version of RDBMS we are running. 
 
 Does anyone have problems shutting down their databases consistently
 with
 9i? 
 
 
 
 The information contained in this communication, including
 attachments, is
 strictly 
 confidential and for the intended use of the addressee only; it may
 also
 contain 
 proprietary, price sensitive, or legally privileged information.
 Notice is
 hereby given that 
 any disclosure, distribution, dissemination, use, or copying of the
 information by anyone 
 other than the intended recipient is strictly prohibited and may be
 illegal.
 If you have 
 received this communication in error, please notify the sender
 immediately
 by reply e-mail, 
 delete this communication, and destroy all copies.
  
 
 Corporate Systems, Inc. has taken reasonable precautions to ensure
 that any
 attachment to 
 this e-mail has been swept for viruses. We specifically disclaim all
 liability and will 
 accept no responsibility for any damage sustained as a result of
 software
 viruses and advise 
 you to carry out your own virus checks before opening any attachment.
 
 
 The information contained in this communication, including
 attachments, is
 strictly 
 confidential and for the intended use of the addressee only; it may
 also
 contain 
 proprietary, price sensitive, or legally privileged information.
 Notice is
 hereby given that 
 any disclosure, distribution, dissemination, use, or copying of the
 information by anyone 
 other than the intended recipient is strictly prohibited and may be
 illegal.
 If you have 
 received this communication in error, please notify the sender
 immediately
 by reply e-mail, 
 delete this communication, and destroy all copies.
  
 
 Corporate Systems, Inc. has taken reasonable precautions to ensure
 that any
 attachment to 
 this e-mail has been swept for viruses. We

DB gets really slow

2003-08-21 Thread Reuben D. Budiardja


Hello,
Sorry if this is a really newbie kinda question. I am a web developer and at 
this point we have a contract to develop something using Oracle. We use PHP 
as the front end to connect to oracle.

Now, eventually all the codes will be moves to the company that outsource it 
to us, and they have cluster oracle and their DBA. But for development 
purposes, for some reason, we don't have access to their DB server. 

So I downloaded the demo version and install it to our own development server 
(Redhat Linux 7.3, 1GB RAM, 1.4GHz Athlon XP). I just do install as explained 
here:http://www.puschitz.com/InstallingOracle9i.html, started the database, 
and started doing development (creating/dropping table, 
insert/update/delete/select, etc). I don't have very much data, since it's 
only dummy data for testing purposes.
So it's really a vanilla oracle-install. No customization, optimization 
whatsoever.


At some point, after being up for a while, the whole thing starts to slowdown. 
I am assuming it's Oracle, since I can't really think anything else who slow 
it down. The same codes and tables and data using postgreSQL doesn't do this.

Restarting oracle and the webserver helps, and things back to normal.

My question is, is there anything critical that I miss here? Do I have to do 
something, like cleaning up etc., to keep the DB running well? In the early 
starts of development, we did a lot  of dropping and re-creating tables, 
indexes, constraint, and updating/deleting data. Does this have any effect? 
Anything I can do to find the source of this problem?

We don't have an Oracle DBA, and I am not very familiar with oracle from DBA 
point of view (only as developer), and I didn't really want to spend a lot of 
time customizing/learning/optimizing the development database because we 
needed to start development ASAP, but it's probably time to start learning.

Thanks for any help.
Reuben D.Budiardja

-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format  
 X   attachments.
/ \
-

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

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

Re: DB gets really slow

2003-08-21 Thread rgaffuri

are you using bind variables? If your not you need to. 

asktom.oracle.com 

type in bind variables he will tell you why they are important. I dont know how to 
use them with PHP. Its probably not hard. 

This sounds just like that. All bouncing the database does is flush the SGA(memory). 
An easy way to test this is when it runs slow do:

alter system flush shared_pool;

if oracle 'speeds up' after that then it probably means you are not using bind 
variables. 

asktom has some more specific ways to test for this. You need to use bind variables. 

 
 From: Reuben D. Budiardja [EMAIL PROTECTED]
 Date: 2003/08/21 Thu PM 04:19:41 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: DB gets really slow
 
 
 Hello,
 Sorry if this is a really newbie kinda question. I am a web developer and at 
 this point we have a contract to develop something using Oracle. We use PHP 
 as the front end to connect to oracle.
 
 Now, eventually all the codes will be moves to the company that outsource it 
 to us, and they have cluster oracle and their DBA. But for development 
 purposes, for some reason, we don't have access to their DB server. 
 
 So I downloaded the demo version and install it to our own development server 
 (Redhat Linux 7.3, 1GB RAM, 1.4GHz Athlon XP). I just do install as explained 
 here:http://www.puschitz.com/InstallingOracle9i.html, started the database, 
 and started doing development (creating/dropping table, 
 insert/update/delete/select, etc). I don't have very much data, since it's 
 only dummy data for testing purposes.
 So it's really a vanilla oracle-install. No customization, optimization 
 whatsoever.
 
 
 At some point, after being up for a while, the whole thing starts to slowdown. 
 I am assuming it's Oracle, since I can't really think anything else who slow 
 it down. The same codes and tables and data using postgreSQL doesn't do this.
 
 Restarting oracle and the webserver helps, and things back to normal.
 
 My question is, is there anything critical that I miss here? Do I have to do 
 something, like cleaning up etc., to keep the DB running well? In the early 
 starts of development, we did a lot  of dropping and re-creating tables, 
 indexes, constraint, and updating/deleting data. Does this have any effect? 
 Anything I can do to find the source of this problem?
 
 We don't have an Oracle DBA, and I am not very familiar with oracle from DBA 
 point of view (only as developer), and I didn't really want to spend a lot of 
 time customizing/learning/optimizing the development database because we 
 needed to start development ASAP, but it's probably time to start learning.
 
 Thanks for any help.
 Reuben D.Budiardja
 
 -- 
 Reuben D. Budiardja
 Department of Physics and Astronomy
 The University of Tennessee, Knoxville, TN
 -
 /\  ASCII Ribbon Campaign against HTML
 \ /  email and proprietary format  
  X   attachments.
 / \
 -
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Reuben D. Budiardja
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

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

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

Re: SharePlex info

2003-08-21 Thread raju pa

1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you would need for physical stdby.

2) CPU burden would be 'little' I guess.

3) Shareplex replication allows you to have the table available for read on the target. (even update). If you need this or if it is a great advantage then you can consider shareplex. Else physical stdby would be better.
You have to basically consider the huge cost of shareplex and maintenance it needs.CPU usageof source would be a lesser consideration i think.

somedaysback there was a thread on this started by oneNelson ( I think)so you can maybe look at the archives and thatshould help you make a decision.

"Gorbounov,Vadim" [EMAIL PROTECTED] wrote:

Hi All,

I'm trying to find some technical details about SharePlex, that is:

- How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format
- How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot
- Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which onesounds preferrable keeping in mind minimizing CPU burden on the source database.

Any opinion or pointer to any benchmark is highly appreciated.

Thanks a lot
Vadim
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

Re: question on how to retrive document

Agree.
When using NFS or any other OS file sharing mechanism, then there's no point
of using BFILEs at all Or is context catrtidge/oracle text able to index
contents of bfiles?

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 7:59 PM


 Tanel, if you use oracle to read BFILE's, you're no faster then by reading
 normal LOB's,
 because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and
 buffer sent to
 you through Oracle*Net. The only way that you can be faster then that is
to
 read the file
 name from a normal VARCHAR2 variable and then bypass oracle in accessing
 that file, and
 access it through some non-oracle mechanism,typically NFS or CIFS (Samba).
 Oracle database
 is created for reading structured tables by means of SQL, not for reading
 plain files.
 To read a plain file, you will use software designed exactly for that
 purpose. It's called
 file system.
 Both NFSv3 and Samba V2 can beat oracle hands down in speed of
 reading/writing files to
 a remote node.  What Samba and NFS cannot do is to retrieve record sets
from
 those files
 using SQL. They can help you to bulk read the file into a document
processor
 and nothing
 more. if speed is all that matters, you read the file name from oracle and
 then read the
 file by using appropriate tools like NFS, Samba or something else.

 --
 Mladen Gogala
 Oracle DBA



 -Original Message-
 Tanel Poder
 Sent: Thursday, August 21, 2003 11:55 AM
 To: Multiple recipients of list ORACLE-L


 Hi!

  Of course, you could give IFS a shot.  I would still go with CLOBS if
  I were you. You can do bfiles, but hten you have to set NFS server and
  you can retrieve the document only if you have access to something
  called /docs/oracle/bfile or similar, and that is rather hard to do
  from an NT station. You can also store an ASCII file as an external

 You can read BFILEs without having client access to the file. As long
Oracle
 has access to the file, it can open it  stream it to you. But if you want
 write access to these files you have to do it from OS or with utl_file or
 similar packages. Gets too complicated to use if your end users want to
 modify those docs, but it could work if you're loading your doc's once and
 they are only read afterwards.

 But yes, internal lobs can be fast if implemented properly.

 Tanel.



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

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



 Note:
 This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
 Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.

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

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



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

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

Re: Re: Row level security and latch waits

Nuno,

I've seen previous replies appearing much later than subsequent replies
quite many times here... Few times even my posts have got lost for good...

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 6:00 PM


 Interesting.  I didn't get Connor's reply...

 Cheers
 Nuno Souto
 [EMAIL PROTECTED]
 - Original Message - 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, August 21, 2003 1:49 AM


  so in 9i dbms_rls increases the soft parses?
  
   From: Connor McDonald [EMAIL PROTECTED]
   Date: 2003/08/20 Wed AM 11:21:59 EDT
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Subject: Re: Re: Row level security and latch waits
  
   My understanding was that the rls predicate was added
   at parse time (hence the importance of the contexts
   and  avoiding things like 'sysdate')
  
   But also if I remember correctly, this behaviour was
   changed in v9 to process the security function with
   each execution (and hence probably increase the amount
   of parsing going on).
  
   You might want to have a play the the
   _dynamic_policies parameter (or something like that)
   which can be used to revert the 8i behaviour (which
   should reduce parsing to a degree)
  
   hth
   connor
  
--- Nuno Souto [EMAIL PROTECTED] wrote: 
   - Original Message - 
   
 - Use context values within predicates, as bind
variables NOTE THIS
 LINE.


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

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



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

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

Re: SharePlex info

Title: Message



Hi!

Btw, you can physically replicate 50% of your 
tables with regular standby mechanisms as well. You just take the files 
belonging to non-needed tablespaces offline and standby recovers only the 
required part. You just have to arrange your tables to right tablespaces and 
spend your money elsewhere.

Physical standby and shareplex can operate on 
archivelogs, thus they can do their jobs without any additional burden to source 
database CPU, since you generate and archive your logs anyway. You can do 
archivelog's processing on target or some staging server.

Tanel.


  - Original Message - 
  From: 
  Gorbounov,Vadim 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 21, 2003 8:49 
  PM
  Subject: SharePlex info
  
  Hi All, 
  
  
  I'm trying to find some technical 
  details about SharePlex, that is:
  
  - How much network bandwidth I'd 
  expect to replicate from database, generating 1-5 MB/sec redo. 
  DoesSharePlex send SQL text over the network or data in some internal 
  (hopefully compressed)format
  - How much CPU on the source DB 
  server side would it cost - just a ball park - very little- little - or 
  a lot 
  - Of two options, using 9.2 
  physical async standby db and clone whole database vs replicate 50% (enough 
  from business requirements) of tables using SharePlex, which onesounds 
  preferrable keeping in mind minimizing CPU burden on the source database. 
  
  
  Any opinion or pointer to any 
  benchmark is highly appreciated. 
  
  Thanks a 
  lot
  Vadim

Re: Collaboration Suite

2003-08-21 Thread Brian Haas

Brian Haas wrote:
Hello all,

We're looking at  Oracle collaboration suite and I'm wondering if anyone 
here is using it? If so, how is it working? Any issues? I know Oracle 
corp is using it for all their internal mail so I assume it could handle 
our 500 or so users just fine.

Thanks,

-Brian





Thanks for the replies. Sounds like it works well. Of course I'm not happy to 
hear that administration isn't as easy as it could be, but I'm used to having 
new products thrown on my lap and the boss saying You're the admin on this now ;).

For a trial run, I'm installing all products on a Sun E450 we have laying 
around. I'm not sure what we will move to for production, but knowing our 
sysadmin it will probably be big sun iron.

-Brian

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

OCFS on RedHat 9

2003-08-21 Thread Jesse, Rich

Has anyone tried running OCFS on RedHat 9?  I downloaded and installed the
binary RPMS, but the OCFS kernel mod wouldn't insert into the newer kernel
because it was compiled with gcc2 and the RH9 kernel is gcc3.  So, I
downloaded the source, hacked it a bit (RH9 apparently breaks lots of things
like filesystems with their custom kernels), and got it running on the RH9
default 2.4.20-8 kernel.  lsmod even shows Not tainted.  :)

Other than OCFS seeming to be slow from the OS, the only other initial issue
is that I'm not able to re-format an existing partition.  Even when I
unmount and format the partition, the bitmap still shows the old allocations
and blocksize.  I know that OCFS requires contiguous space for OS file
extent creation, so this could be a showstopper.

Is this just my OCFS hack or does the version on RH AS 2.1 (which isn't
usable on the new PC I've got) work the same way?


TIA,
Rich

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

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

RE: question on how to retrive document

Yes, context can index BFILEs. We used in to index a collection of pdfs.
This is probably not fastest way of reading data, but it is not always a
goal. 
Vadim

-Original Message-
Sent: Thursday, August 21, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


Agree.
When using NFS or any other OS file sharing mechanism, then there's no point
of using BFILEs at all Or is context catrtidge/oracle text able to index
contents of bfiles?

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 7:59 PM


 Tanel, if you use oracle to read BFILE's, you're no faster then by reading
 normal LOB's,
 because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and
 buffer sent to
 you through Oracle*Net. The only way that you can be faster then that is
to
 read the file
 name from a normal VARCHAR2 variable and then bypass oracle in accessing
 that file, and
 access it through some non-oracle mechanism,typically NFS or CIFS (Samba).
 Oracle database
 is created for reading structured tables by means of SQL, not for reading
 plain files.
 To read a plain file, you will use software designed exactly for that
 purpose. It's called
 file system.
 Both NFSv3 and Samba V2 can beat oracle hands down in speed of
 reading/writing files to
 a remote node.  What Samba and NFS cannot do is to retrieve record sets
from
 those files
 using SQL. They can help you to bulk read the file into a document
processor
 and nothing
 more. if speed is all that matters, you read the file name from oracle and
 then read the
 file by using appropriate tools like NFS, Samba or something else.

 --
 Mladen Gogala
 Oracle DBA



 -Original Message-
 Tanel Poder
 Sent: Thursday, August 21, 2003 11:55 AM
 To: Multiple recipients of list ORACLE-L


 Hi!

  Of course, you could give IFS a shot.  I would still go with CLOBS if
  I were you. You can do bfiles, but hten you have to set NFS server and
  you can retrieve the document only if you have access to something
  called /docs/oracle/bfile or similar, and that is rather hard to do
  from an NT station. You can also store an ASCII file as an external

 You can read BFILEs without having client access to the file. As long
Oracle
 has access to the file, it can open it  stream it to you. But if you want
 write access to these files you have to do it from OS or with utl_file or
 similar packages. Gets too complicated to use if your end users want to
 modify those docs, but it could work if you're loading your doc's once and
 they are only read afterwards.

 But yes, internal lobs can be fast if implemented properly.

 Tanel.



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

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



 Note:
 This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
 Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.

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

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



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

Fat City Network Services

RE: DB gets really slow

Reuben
   Well, as you get into web development it is more important to learn to
pinpoint the performance problem. First, figure out how to check the
performance on your Linux box. Try to find out whether the Linux system gets
progressively more heavily loaded as your DB gets slower, or becomes less
loaded. As Jonathan Lewis on this list put it, 
   If you have a performance problem, 
   either your database is working too hard,
   or it's not being allowed to work. 

Next, check inside Oracle to see what your Oracle database is waiting on.
Here is a script that was previously posted on this list. This may unearth
the problem or you may have to dig a little deeper, as Ryan has pointed out.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

REM From: Mohammed Shakir [mailto:[EMAIL PROTECTED]
REM Sent: Thursday, October 10, 2002 5:14 PM
REM To: Multiple recipients of list ORACLE-L
REM Subject: RE: Table Scans
REM Try the following script. I am not sure where I found it on the web.
REM However, this script I use to find the bottlenecks in the system.
REM Run it while your application is running.
REM Look for wait event 'db_file_scattered_read'.
REM Check the related SQL.
REM You can remove other wait events if you do not need them.
set echo off feedback off timing off pause off
set pages 100 lines 500 trimspool on trimout on space 1 recsep each

col sid format 990
col program format a15 word_wrap
col event format a8 word_wrap
col ospid format 990 heading Srvr|PID
col name format a15 word_wrap heading OBJECT NAME
col sql_text format a30 word_wrap
select /*+ rule */
w.sid,
w.event,
s.program,
p.spid ospid,
e.owner || '.' || e.segment_name || ' (' || e.segment_type || ')'
name,
a.sql_text
fromsys.v_$sqlarea  a,
sys.dba_extents e,
sys.v_$process  p,
sys.v_$session  s,
sys.v_$session_wait w
where   w.event in ('write complete waits',
'latch free',
'log buffer space',
'free buffer waits',
'buffer busy waits',
'db file scattered read',
'db file sequential read',
'library cache pin',
'log file switch completion',
'enqueue',
'log file parallel write',
'db file parallel write',
'log file sync',
'file open',
'direct path write',
'library cache lock')
and s.sid = w.sid
and p.addr = s.paddr
and e.file_id = to_number(w.p1)
and to_number(w.p2) between e.block_id and (e.block_id + (e.blocks -
1))
and a.address (+) = s.sql_address;

-Original Message-
Sent: Thursday, August 21, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L



Hello,
Sorry if this is a really newbie kinda question. I am a web developer and at

this point we have a contract to develop something using Oracle. We use PHP 
as the front end to connect to oracle.

Now, eventually all the codes will be moves to the company that outsource it

to us, and they have cluster oracle and their DBA. But for development 
purposes, for some reason, we don't have access to their DB server. 

So I downloaded the demo version and install it to our own development
server 
(Redhat Linux 7.3, 1GB RAM, 1.4GHz Athlon XP). I just do install as
explained 
here:http://www.puschitz.com/InstallingOracle9i.html, started the database, 
and started doing development (creating/dropping table, 
insert/update/delete/select, etc). I don't have very much data, since it's 
only dummy data for testing purposes.
So it's really a vanilla oracle-install. No customization, optimization 
whatsoever.


At some point, after being up for a while, the whole thing starts to
slowdown. 
I am assuming it's Oracle, since I can't really think anything else who slow

it down. The same codes and tables and data using postgreSQL doesn't do
this.

Restarting oracle and the webserver helps, and things back to normal.

My question is, is there anything critical that I miss here? Do I have to do

something, like cleaning up etc., to keep the DB running well? In the early 
starts of development, we did a lot  of dropping and re-creating tables, 
indexes, constraint, and updating/deleting data. Does this have any effect? 
Anything I can do to find the source of this problem?

We don't have an Oracle DBA, and I am not very familiar with oracle from DBA

point of view (only as developer), and I didn't really want to spend a lot
of 
time customizing/learning/optimizing the development database because we 
needed to start development ASAP, but it's probably time to start learning.

Thanks for any help.
Reuben D.Budiardja

-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format  
 X   attachments.
/ \
-

-- 
Please see the

RE: SharePlex info




Thank 
you, Raju. Very helpful

  -Original Message-From: raju pa 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:59 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  SharePlex info
  1)You would need lessnetwork bandwidth with shareplex than 
  you would for transporting archive logs. about 1/3 rd ofwhat you would 
  need for physical stdby.
  
  2) CPU burden would be 'little' I guess.
  
  3) Shareplex replication allows you to have the table available for read 
  on the target. (even update). If you need this or if it is a great advantage 
  then you can consider shareplex. Else physical stdby would be better. 
  
  You have to basically consider the huge cost of shareplex and maintenance 
  it needs.CPU usageof source would be a lesser consideration i 
  think. 
  
  somedaysback there was a thread on this started by oneNelson 
  ( I think)so you can maybe look at the archives and thatshould 
  help you make a decision.
  
  "Gorbounov,Vadim" [EMAIL PROTECTED] 
  wrote:
  



Hi All, 


I'm trying to find some 
technical details about SharePlex, that is:

- How much network bandwidth 
I'd expect to replicate from database, generating 1-5 MB/sec redo. 
DoesSharePlex send SQL text over the network or data in some internal 
(hopefully compressed)format
- How much CPU on the source DB 
server side would it cost - just a ball park - very little- little - 
or a lot 
- Of two options, using 9.2 
physical async standby db and clone whole database vs replicate 50% (enough 
from business requirements) of tables using SharePlex, which onesounds 
preferrable keeping in mind minimizing CPU burden on the source database. 


Any opinion or pointer to any 
benchmark is highly appreciated. 

Thanks a 
lot
Vadim
  
  
  Do you Yahoo!?SBC 
  Yahoo! DSL - Now only $29.95 per month!

RE: SharePlex info

2003-08-21 Thread Aponte, Tony

Title: Message



Your 
bandwidth requirements will be the rate of changes to the actual data. The 
traffic consists of the actual data and control information needed to reassemble 
the transaction on the target. The source database's other redo payload 
(i.e., index operations, rollback segment maintenance, etc.) is not used by 
Shareplex. 

In our 
environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU 
consumption on the source and target sides combined. It varies according 
to the DML load on the source but not by much. We've never had a problem 
with it consuming a noticeable amount.

I have 
a question on the comparison between a physical standby and Shareplex 
replication.Isn't9i's logical standby featurebetter 
suited for the comparison to Shareplex? I'm assuming that you are 
considering offloading some processing to another host since you are looking to 
replicate about 50% of the tables in the source database.

HTH
Tony 
Aponte



  -Original Message-From: Gorbounov,Vadim 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 1:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: SharePlex info
  Hi All, 
  
  
  I'm trying to find some technical 
  details about SharePlex, that is:
  
  - How much network bandwidth I'd 
  expect to replicate from database, generating 1-5 MB/sec redo. 
  DoesSharePlex send SQL text over the network or data in some internal 
  (hopefully compressed)format
  - How much CPU on the source DB 
  server side would it cost - just a ball park - very little- little - or 
  a lot 
  - Of two options, using 9.2 
  physical async standby db and clone whole database vs replicate 50% (enough 
  from business requirements) of tables using SharePlex, which onesounds 
  preferrable keeping in mind minimizing CPU burden on the source database. 
  
  
  Any opinion or pointer to any 
  benchmark is highly appreciated. 
  
  Thanks a 
  lot
  Vadim

RE: SharePlex info

Title: Message



Tanel, 

That's 
nice trick, thanks a lot.
In 
this casewhole redo steam must be passed over the network anyway. 5 MB/sec 
over WAN. So we'are doing research if we could same some 
bandwidth.

Vadim
-Original Message-From: Tanel Poder 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:14 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
SharePlex info

  Hi!
  
  Btw, you can physically replicate 50% of your 
  tables with regular standby mechanisms as well. You just take the files 
  belonging to non-needed tablespaces offline and standby recovers only the 
  required part. You just have to arrange your tables to right tablespaces and 
  spend your money elsewhere.
  
  Physical standby and shareplex can operate on 
  archivelogs, thus they can do their jobs without any additional burden to 
  source database CPU, since you generate and archive your logs anyway. You can 
  do archivelog's processing on target or some staging server.
  
  Tanel.
  
  
- Original Message - 
From: 
Gorbounov,Vadim 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, August 21, 2003 8:49 
PM
Subject: SharePlex info

Hi All, 


I'm trying to find some 
technical details about SharePlex, that is:

- How much network bandwidth 
I'd expect to replicate from database, generating 1-5 MB/sec redo. 
DoesSharePlex send SQL text over the network or data in some internal 
(hopefully compressed)format
- How much CPU on the source DB 
server side would it cost - just a ball park - very little- little - 
or a lot 
- Of two options, using 9.2 
physical async standby db and clone whole database vs replicate 50% (enough 
from business requirements) of tables using SharePlex, which onesounds 
preferrable keeping in mind minimizing CPU burden on the source database. 


Any opinion or pointer to any 
benchmark is highly appreciated. 

Thanks a 
lot
Vadim

Re: cursor_sharing in 8.1.7.4 - good or bad

Hi!

How did you check which execution plan was chosen? Explain plan and
autotrace lie, use 10046 or v$sql_plan instead.
For num_buckets, dba_tab_cols view substracts one from real bucket count for
some reason. To get real value go to base tables and check row_cnt from
sys.hist_head$ or just count(*) appropriate rows from sys.histgrm$.

But yes, the execution plan is chosen once per session, if first one took
FTS based on one value, then if second one picks index access, another
version of query execution plan is generated for the same SQL statement -
only soft parse is required.

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 7:54 PM


 I was curious about your statement the kernel only peeks once per
 session. I wondered if another session that executed the same statement
 would be impacted by the peeking or would the optimizer reparse the
 statement.

 So I set up a test. Million row table with 2 columns. c1 - number, c2 -
 date. C1 contains 2 distinct values 0 (999 rows) and 1 (999001 rows). I
 analyzed the table and 'tried' to generate a 2 bucket histogram. However,
 the num_buckets is still 1 on the column. When I run the query with a bind
 variable, it always selects a FTS, regardless of the first value I place
in
 the variable.

 I am obviously missing something, but I've run out of ideas. I 'think' the
 problem is the number of buckets, but the analyze table column command
 seems to think 1 bucket is enough.

 Daniel


 Cary Millsap wrote:

  And don't count too heavily upon 9i's bind value peek capability.
  Here's a simple test that Jonathan Lewis conjured up last year:
 
  PREPARATION. Create data for select c1, c2 from t1 where c1 = :bind1,
  where different bind1 values could have different paths if we used
  literals.
 
  1. flush shared pool
 set bind1 = 5
 execute query, notice an indexed access (optimal plan for bind1=5)
 set bind1 = 70
 execute query, notice that kernel still uses the index
 
  2. flush shared pool
 set bind1 = 70
 execute query, notice a table scan (optimal plan for bind1=70)
 set bind1 = 5
 execute query, notice that kernel still uses the table scan
 
  The moral: the kernel only peeks once per session.
 
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
 
  Upcoming events:
  - Hotsos Clinic 101 in Sydney
  - Hotsos Symposium 2004, March 7-10 Dallas
  - Visit www.hotsos.com for schedule details...
 
  -Original Message-
  Jesse, Rich
  Sent: Tuesday, August 19, 2003 3:09 PM
  To: Multiple recipients of list ORACLE-L
 
  True, but using binds isn't always an option, like when running a 3rd
  party
  product.  I also could not justify weeks of recoding homegrown software
  for
  the relatively minor gains we would have using binds.  And scalability
  (or
  lack thereof) didn't seem to be argument enough.
 
  We're using CS=F on 8.1.7.4 on HP/UX 11.0.  We haven't yet had a single
  issue attributable to it in the 7 months we've been at the .4 release.
  There were some nasty issues with 8.1.7.2 (ORA-600 and silently
  returning
  WRONG data), but like I said, .4 seems to have cleaned that up.  YMMV.
 
  Remember that under 8i, you may see some performance DROP by using
  binds.
  The case that comes to mind is if you're using histograms with ANALYZE
  or
  DBMS_STATS.  Under 8i, the optimizer can no longer see the values and
  therefore can't use the histograms.  Under 9i (R2 only?), you can tell
  the
  optimizer to peek at the bind variables' values in order to make use of
  histograms.  We plan on doing this when we get to 9i in order to use a
  very
  low cardinality index, where less than 0.0001% of the rows is what we
  need
  to fetch, but 8i won't use the index because of the cardinality.
 
  Your best bet, of course, is to test!  HTH!  GL!  :)
 
  Rich
 
  Rich Jesse   System/Database Administrator
  [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 
  -Original Message-
  Sent: Tuesday, August 19, 2003 2:49 PM
  To: Multiple recipients of list ORACLE-L
 
  Hi,
No. I recommend that you do not change cursor_sharing if you are doing
  it
  just to get rid of 4031. There could be serious problems. ora-600 etc.
  Maybe
  Oracle has fixed everything in latest 817 but I suggest not to take that
  chance.
For 4031 you can do the following : pin pl/sql sql preferably at
  startup,
  use bind variables and periodically check for sql not using bind
  variables.
  Goodluck.
 
  Fedock, John (KAM.RHQ) [EMAIL PROTECTED] wrote:
 
  Does anyone have any experience using cursor_sharing in 8.1.7.4?I
  feel I
  need to use it due to literal SQL statements being used.  We have had
  misc
  4031 errors off and on and I feel this is my last hope.  I have a very
  busy
  OPFS server (HP-UX).
 
  I did try using cursor_sharing in 8.1.7.2, and I remember incorrect
  sorting
  and other

RE: Rman disk performance

2003-08-21 Thread Spears, Brian

ok... I just hanging on here...don't let me fall...

 what ..what?

Brian :)

-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L


Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  

copy some big files using file system commands like cp and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

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

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

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

Re: SharePlex info




But you would be wanting to transfer *full* 
logfiles away from your production servers anyway at least if your data is 
worth something...

Tanel.



  
1)You would need lessnetwork bandwidth with shareplex than 
you would for transporting archive logs. about 1/3 rd ofwhat you would 
need for physical stdby.

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Stephane Faroult

Paul Baumgartel wrote:
 
 A couple of corrections are in order here.  First, some Christians
 might object to your characterizing the Holy Trinity, et. al. as
 mythology. 

I don't believe Andrei Rublev to be on this list.

-- 
Regards,

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

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

RE: Rman disk performance

Brian
  Sorry, the mail system mangled my message. It's all there, just part is
below the signature. Here it is again:

I think that is about the performance we get. Maybe faster than what we get.
   One idea would be to copy some big files using file system commands like
cp and see what the performance is. My guess is that would be your
theoretical upper limit.
 
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, August 21, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


ok... I just hanging on here...don't let me fall...

 what ..what?

Brian :)

-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L


Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  

copy some big files using file system commands like cp and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

RE: URGENT!!! My 9i databases are not shutting down

2003-08-21 Thread Nelson, Allan

Oh, we're used to it.  It's the predominant mythos of the current
society.  Everybody gets their own opinion unitl either death or
judgment.

Allan

-Original Message-
Sent: Thursday, August 21, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
cleanly/cons


Paul Baumgartel wrote:
 
 A couple of corrections are in order here.  First, some Christians 
 might object to your characterizing the Holy Trinity, et. al. as 
 mythology.

I don't believe Andrei Rublev to be on this list.

-- 
Regards,

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

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



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

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

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

Re: SharePlex info

Title: Message



Ok, in this case Shareplex might be better, if it 
is able to extract only relevant data from logs.
Actually, you could dosomewhat similar 
yourself using logminer as well. You just extract all needed DML statements on 
either production or staging server, compress the output (because file with sql 
statements is going to be big but will compress well) and send over network, or 
go with Oracle Streams rightaway.There's going to be an issue with 
some special datatypes though IIRC.

I don't know the pricing of shareplex, maybe it'd 
be easier going with it..

Tanel.


  - Original Message - 
  From: 
  Gorbounov,Vadim 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, August 22, 2003 12:54 
  AM
  Subject: RE: SharePlex info
  
  Tanel, 
  That's nice trick, thanks a lot.
  In 
  this casewhole redo steam must be passed over the network anyway. 5 
  MB/sec over WAN. So we'are doing research if we could same some 
  bandwidth.
  
  Vadim
  -Original Message-From: Tanel Poder 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  5:14 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: SharePlex info
  
Hi!

Btw, you can physically replicate 50% of your 
tables with regular standby mechanisms as well. You just take the files 
belonging to non-needed tablespaces offline and standby recovers only the 
required part. You just have to arrange your tables to right tablespaces and 
spend your money elsewhere.

Physical standby and shareplex can operate on 
archivelogs, thus they can do their jobs without any additional burden to 
source database CPU, since you generate and archive your logs anyway. You 
can do archivelog's processing on target or some staging 
server.

Tanel.


  - Original Message - 
  From: 
  Gorbounov,Vadim 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, August 21, 2003 8:49 
  PM
  Subject: SharePlex info
  
  Hi All, 
  
  
  I'm trying to find some 
  technical details about SharePlex, that is:
  
  - How much network bandwidth 
  I'd expect to replicate from database, generating 1-5 MB/sec redo. 
  DoesSharePlex send SQL text over the network or data in some 
  internal (hopefully compressed)format
  - How much CPU on the source 
  DB server side would it cost - just a ball park - very little- 
  little - or a lot 
  - Of two options, using 9.2 
  physical async standby db and clone whole database vs replicate 50% 
  (enough from business requirements) of tables using SharePlex, which 
  onesounds preferrable keeping in mind minimizing CPU burden on the 
  source database. 
  
  Any opinion or pointer to any 
  benchmark is highly appreciated. 
  
  Thanks a 
  lot
  Vadim

RE: SharePlex info

2003-08-21 Thread A Joshi

Yes. A nice neat trick indeed. Has anyone tried this? 

About your redo generation : 5MB/sec - 18000 MB/hour == 18GB

IT is indeed huge. IS this peak or average? Good luck. "Gorbounov,Vadim" [EMAIL PROTECTED] wrote:




Tanel, 
That's nice trick, thanks a lot.
In this casewhole redo steam must be passed over the network anyway. 5 MB/sec over WAN. So we'are doing research if we could same some bandwidth.

Vadim
-Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePlex info

Hi!

Btw, you can physically replicate 50% of your tables with regular standby mechanisms as well. You just take the files belonging to non-needed tablespaces offline and standby recovers only the required part. You just have to arrange your tables to right tablespaces and spend your money elsewhere.

Physical standby and shareplex can operate on archivelogs, thus they can do their jobs without any additional burden to source database CPU, since you generate and archive your logs anyway. You can do archivelog's processing on target or some staging server.

Tanel.


- Original Message - 
From: Gorbounov,Vadim 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, August 21, 2003 8:49 PM
Subject: SharePlex info

Hi All, 

I'm trying to find some technical details about SharePlex, that is:

- How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format
- How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot 
- Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which onesounds preferrable keeping in mind minimizing CPU burden on the source database. 

Any opinion or pointer to any benchmark is highly appreciated. 

Thanks a lot
Vadim
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Paul Baumgartel

Wow--that one sent me scrambling to Google.  Nice riposte!


--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Paul Baumgartel wrote:
  
  A couple of corrections are in order here.  First, some Christians
  might object to your characterizing the Holy Trinity, et. al. as
  mythology. 
 
 I don't believe Andrei Rublev to be on this list.
 
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Software
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

Re: SharePlex info




It's documented in 8.1.7 docs:

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76995/standbym.htm#27264

In 9.2 docs I didn't find it with brief 
search...

Tanel.


  - Original Message - 
  From: 
  A Joshi 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, August 22, 2003 2:14 
  AM
  Subject: RE: SharePlex info
  
  Yes. A nice neat trick indeed. Has anyone tried this? 
  
  About your redo generation : 5MB/sec - 18000 MB/hour == 
  18GB
  
  IT is indeed huge. IS this peak or average? Good luck. 
  "Gorbounov,Vadim" [EMAIL PROTECTED] 
  wrote:
  



Tanel, 
That's nice trick, thanks a lot.
In 
this casewhole redo steam must be passed over the network anyway. 5 
MB/sec over WAN. So we'are doing research if we could same some 
bandwidth.

Vadim
-Original Message-From: Tanel Poder 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
5:14 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: SharePlex info

  Hi!
  
  Btw, you can physically replicate 50% of your 
  tables with regular standby mechanisms as well. You just take the files 
  belonging to non-needed tablespaces offline and standby recovers only the 
  required part. You just have to arrange your tables to right tablespaces 
  and spend your money elsewhere.
  
  Physical standby and shareplex can operate on 
  archivelogs, thus they can do their jobs without any additional burden to 
  source database CPU, since you generate and archive your logs anyway. You 
  can do archivelog's processing on target or some staging 
  server.
  
  Tanel.
  
  
- Original Message - 
From: 
Gorbounov,Vadim 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
8:49 PM
Subject: SharePlex info

Hi All, 


I'm trying to find some 
technical details about SharePlex, that is:

- How much network 
bandwidth I'd expect to replicate from database, generating 1-5 MB/sec 
redo. DoesSharePlex send SQL text over the network or data in some 
internal (hopefully compressed)format
- How much CPU on the 
source DB server side would it cost - just a ball park - very 
little- little - or a lot 
- Of two options, using 9.2 
physical async standby db and clone whole database vs replicate 50% 
(enough from business requirements) of tables using SharePlex, which 
onesounds preferrable keeping in mind minimizing CPU burden on the 
source database. 

Any opinion or pointer to 
any benchmark is highly appreciated. 

Thanks a 
lot
Vadim
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software

Re: cursor_sharing in 8.1.7.4 - good or bad

2003-08-21 Thread Anjo Kolk


May be it should say that the peek is only done at the hard parse stage (seems 
to be implied by example of Jonathan Lewis)

On Friday 22 August 2003 00:09, Tanel Poder wrote:
 Hi!

 How did you check which execution plan was chosen? Explain plan and
 autotrace lie, use 10046 or v$sql_plan instead.
 For num_buckets, dba_tab_cols view substracts one from real bucket count
 for some reason. To get real value go to base tables and check row_cnt from
 sys.hist_head$ or just count(*) appropriate rows from sys.histgrm$.

 But yes, the execution plan is chosen once per session, if first one took
 FTS based on one value, then if second one picks index access, another
 version of query execution plan is generated for the same SQL statement -
 only soft parse is required.

 Tanel.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, August 21, 2003 7:54 PM

  I was curious about your statement the kernel only peeks once per
  session. I wondered if another session that executed the same statement
  would be impacted by the peeking or would the optimizer reparse the
  statement.
 
  So I set up a test. Million row table with 2 columns. c1 - number, c2 -
  date. C1 contains 2 distinct values 0 (999 rows) and 1 (999001 rows). I
  analyzed the table and 'tried' to generate a 2 bucket histogram. However,
  the num_buckets is still 1 on the column. When I run the query with a
  bind variable, it always selects a FTS, regardless of the first value I
  place

 in

  the variable.
 
  I am obviously missing something, but I've run out of ideas. I 'think'
  the problem is the number of buckets, but the analyze table column
  command seems to think 1 bucket is enough.
 
  Daniel
 
  Cary Millsap wrote:
   And don't count too heavily upon 9i's bind value peek capability.
   Here's a simple test that Jonathan Lewis conjured up last year:
  
   PREPARATION. Create data for select c1, c2 from t1 where c1 = :bind1,
   where different bind1 values could have different paths if we used
   literals.
  
   1. flush shared pool
  set bind1 = 5
  execute query, notice an indexed access (optimal plan for bind1=5)
  set bind1 = 70
  execute query, notice that kernel still uses the index
  
   2. flush shared pool
  set bind1 = 70
  execute query, notice a table scan (optimal plan for bind1=70)
  set bind1 = 5
  execute query, notice that kernel still uses the table scan
  
   The moral: the kernel only peeks once per session.
  
   Cary Millsap
   Hotsos Enterprises, Ltd.
   http://www.hotsos.com
  
   Upcoming events:
   - Hotsos Clinic 101 in Sydney
   - Hotsos Symposium 2004, March 7-10 Dallas
   - Visit www.hotsos.com for schedule details...
  
   -Original Message-
   Jesse, Rich
   Sent: Tuesday, August 19, 2003 3:09 PM
   To: Multiple recipients of list ORACLE-L
  
   True, but using binds isn't always an option, like when running a 3rd
   party
   product.  I also could not justify weeks of recoding homegrown software
   for
   the relatively minor gains we would have using binds.  And scalability
   (or
   lack thereof) didn't seem to be argument enough.
  
   We're using CS=F on 8.1.7.4 on HP/UX 11.0.  We haven't yet had a single
   issue attributable to it in the 7 months we've been at the .4 release.
   There were some nasty issues with 8.1.7.2 (ORA-600 and silently
   returning
   WRONG data), but like I said, .4 seems to have cleaned that up.  YMMV.
  
   Remember that under 8i, you may see some performance DROP by using
   binds.
   The case that comes to mind is if you're using histograms with ANALYZE
   or
   DBMS_STATS.  Under 8i, the optimizer can no longer see the values and
   therefore can't use the histograms.  Under 9i (R2 only?), you can tell
   the
   optimizer to peek at the bind variables' values in order to make use of
   histograms.  We plan on doing this when we get to 9i in order to use a
   very
   low cardinality index, where less than 0.0001% of the rows is what we
   need
   to fetch, but 8i won't use the index because of the cardinality.
  
   Your best bet, of course, is to test!  HTH!  GL!  :)
  
   Rich
  
   Rich Jesse   System/Database Administrator
   [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
  
   -Original Message-
   Sent: Tuesday, August 19, 2003 2:49 PM
   To: Multiple recipients of list ORACLE-L
  
   Hi,
 No. I recommend that you do not change cursor_sharing if you are
   doing it
   just to get rid of 4031. There could be serious problems. ora-600 etc.
   Maybe
   Oracle has fixed everything in latest 817 but I suggest not to take
   that chance.
 For 4031 you can do the following : pin pl/sql sql preferably at
   startup,
   use bind variables and periodically check for sql not using bind
   variables.
   Goodluck.
  
   Fedock, John (KAM.RHQ) [EMAIL PROTECTED] wrote:
  
   Does anyone have any experience using cursor_sharing in

Making my firts job

2003-08-21 Thread Teresita Castro




Hi!!
I am making my firts job and I have some problems calculating 
the correct time to lauch the job.
I have the next procedure:

CREATE OR REPLACE PROCEDURE 
SP_SOH_HANDASBEGININSERT INTO TB_ICTRANSX select COMPANY, 
LOCATION,ITEM,SOH_QTY,AVERAGE_COST, SYSDATE-1, UPDATE_TIME from iTEMLOC where 
TRACKING_FL='Y';COMMIT;END SP_SOH_HAND;/

This procedure will feed a table every day, I want this 
tohappen after midnight, on the first second of the next day, every day. 
How can I create a job to do that?

RE: Forms - as sysdba

2003-08-21 Thread Suhen Pather

Title: RE: Forms - as sysdba







One thing to bear in mind for forms development
is Oracle does not support connecting as / (OPS$).


Suhen



-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 August 2003 1:02 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Forms - as sysdba




As this is Forms 6i, which was around long before 
connect '/ as sysdba' was required, Forms does
not know about the new syntax.


Try checking on MetaLink for a patch.


Jared


On Thu, 2003-08-21 at 01:54, Robo wrote:
 Hi all,
 I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There
 are 3 boxes for username, password and database.
 I tried a lot of combinations, eg:
 Username: sys as sysdba 
 Password: sys
 Database: db
 sys/[EMAIL PROTECTED] as sysdba
 sys/[EMAIL PROTECTED] /as sysdba
 sys/[EMAIL PROTECTED] 'as sysdba'
 sys/[EMAIL PROTECTED] '/as sysdba'
 But I always get an error message - either invalid username/password or
 TNS error (can't recognize the connect string).
 I have also tried it from command line but didn't succeed.
 
 Does anyone know if/how is it possible?
 
 Thanks a lot
 Robert Pipich
 
 



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


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

Re: cursor_sharing in 8.1.7.4 - good or bad

I'm resending my reply, because it appears to be lost. Sorry if you get a
duplicate few days later (sigh).

Tanel.

 Hi!

 How did you check which execution plan was chosen? Explain plan and
 autotrace lie, use 10046 or v$sql_plan instead.
 For num_buckets, dba_tab_cols view substracts one from real bucket count
for
 some reason. To get real value go to base tables and check row_cnt from
 sys.hist_head$ or just count(*) appropriate rows from sys.histgrm$.

 But yes, the execution plan is chosen once per session, if first one took
 FTS based on one value, then if second one picks index access, another
 version of query execution plan is generated for the same SQL statement -
 only soft parse is required.

 Tanel.

 - Original Message - 
 From: Daniel Fink [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, August 21, 2003 7:54 PM
 Subject: Re: cursor_sharing in 8.1.7.4 - good or bad


  I was curious about your statement the kernel only peeks once per
  session. I wondered if another session that executed the same statement
  would be impacted by the peeking or would the optimizer reparse the
  statement.
 
  So I set up a test. Million row table with 2 columns. c1 - number, c2 -
  date. C1 contains 2 distinct values 0 (999 rows) and 1 (999001 rows). I
  analyzed the table and 'tried' to generate a 2 bucket histogram.
However,
  the num_buckets is still 1 on the column. When I run the query with a
bind
  variable, it always selects a FTS, regardless of the first value I place
 in
  the variable.
 
  I am obviously missing something, but I've run out of ideas. I 'think'
the
  problem is the number of buckets, but the analyze table column command
  seems to think 1 bucket is enough.
 
  Daniel
 
 
  Cary Millsap wrote:
 
   And don't count too heavily upon 9i's bind value peek capability.
   Here's a simple test that Jonathan Lewis conjured up last year:
  
   PREPARATION. Create data for select c1, c2 from t1 where c1 =
:bind1,
   where different bind1 values could have different paths if we used
   literals.
  
   1. flush shared pool
  set bind1 = 5
  execute query, notice an indexed access (optimal plan for bind1=5)
  set bind1 = 70
  execute query, notice that kernel still uses the index
  
   2. flush shared pool
  set bind1 = 70
  execute query, notice a table scan (optimal plan for bind1=70)
  set bind1 = 5
  execute query, notice that kernel still uses the table scan
  
   The moral: the kernel only peeks once per session.
  
   Cary Millsap
   Hotsos Enterprises, Ltd.
   http://www.hotsos.com
  
   Upcoming events:
   - Hotsos Clinic 101 in Sydney
   - Hotsos Symposium 2004, March 7-10 Dallas
   - Visit www.hotsos.com for schedule details...
  
   -Original Message-
   Jesse, Rich
   Sent: Tuesday, August 19, 2003 3:09 PM
   To: Multiple recipients of list ORACLE-L
  
   True, but using binds isn't always an option, like when running a 3rd
   party
   product.  I also could not justify weeks of recoding homegrown
software
   for
   the relatively minor gains we would have using binds.  And scalability
   (or
   lack thereof) didn't seem to be argument enough.
  
   We're using CS=F on 8.1.7.4 on HP/UX 11.0.  We haven't yet had a
single
   issue attributable to it in the 7 months we've been at the .4 release.
   There were some nasty issues with 8.1.7.2 (ORA-600 and silently
   returning
   WRONG data), but like I said, .4 seems to have cleaned that up.  YMMV.
  
   Remember that under 8i, you may see some performance DROP by using
   binds.
   The case that comes to mind is if you're using histograms with ANALYZE
   or
   DBMS_STATS.  Under 8i, the optimizer can no longer see the values
and
   therefore can't use the histograms.  Under 9i (R2 only?), you can tell
   the
   optimizer to peek at the bind variables' values in order to make use
of
   histograms.  We plan on doing this when we get to 9i in order to use a
   very
   low cardinality index, where less than 0.0001% of the rows is what we
   need
   to fetch, but 8i won't use the index because of the cardinality.
  
   Your best bet, of course, is to test!  HTH!  GL!  :)
  
   Rich
  
   Rich Jesse   System/Database Administrator
   [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
  
   -Original Message-
   Sent: Tuesday, August 19, 2003 2:49 PM
   To: Multiple recipients of list ORACLE-L
  
   Hi,
 No. I recommend that you do not change cursor_sharing if you are
doing
   it
   just to get rid of 4031. There could be serious problems. ora-600 etc.
   Maybe
   Oracle has fixed everything in latest 817 but I suggest not to take
that
   chance.
 For 4031 you can do the following : pin pl/sql sql preferably at
   startup,
   use bind variables and periodically check for sql not using bind
   variables.
   Goodluck.
  
   Fedock, John (KAM.RHQ) [EMAIL PROTECTED] wrote:
  
   Does anyone have any

Re: cursor_sharing in 8.1.7.4 - good or bad