Another virus #############

[Greg Moore]

word up.

email in my inbox from   Bunyamin K. Karadeniz

looks like another virus

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

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

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

Listener freezes up

[blair]

AIX: 4.3.2.0
RDBMS 8.1.6.3

We have two instances on two different servers.  There is replication from
serverA to serverB.  Periodically SID_A starts filling its alertlog with
"ORA-00020 Max sessions" errors. It is reporting a failure of the replication
into SID_B.  It is SID_B that has the max sessions error (this is verified by
connection to SQLNET on both instances).  A

At the same time the listener on serverA freezes up with anywhere from 400-600
ESTABLISHED connections against port 1521 - the SQLNET LISTENER.

I'm capturing TNSPING times from server_B to SID_A.  I'm also capturing a
session count every 2 minutes.  In my opinion the session count starts going up
about 20 minutes before the TNSPING time get very long and ultimately stops
returning.


We've had a TAR open for weeks and Oracle cannot solve it.

Any ideas for further troubleshooting?

..t


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

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

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

RE: CURSOR_SHARING = FORCE ques.

[John Lewis]

Ditto here. 
It solves the re-coding-using-vars problem. The java programmers are such
whiners (I hope none of them read this list!).

-Original Message-
Sent: Monday, July 02, 2001 6:05 PM
To: Multiple recipients of list ORACLE-L



>
>2) Anyone out there using it?  Does it give that much better performance 
>gains?  It seems to me like it's not worth implementing.

we're using it, on 8.1.6  No problems so far, and it relieved the problem of

not being able to get a chunk of memory for the shared pool and having to 
flush. My programmers wrote their code using constants... on insert 
statements in a registration system. So my sqlarea was getting filled with 
identical statements, except for the value of the constant.

Rather than make them recode (trust me, I would have had to get the rack and

thumbscrews out to make that happen), I turned on cursor_sharing=force and 
it's worked like a dream.

Rachel

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

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

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

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

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

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

[Rachel Carmichael]

>
>2) Anyone out there using it?  Does it give that much better performance 
>gains?  It seems to me like it's not worth implementing.

we're using it, on 8.1.6  No problems so far, and it relieved the problem of 
not being able to get a chunk of memory for the shared pool and having to 
flush. My programmers wrote their code using constants... on insert 
statements in a registration system. So my sqlarea was getting filled with 
identical statements, except for the value of the constant.

Rather than make them recode (trust me, I would have had to get the rack and 
thumbscrews out to make that happen), I turned on cursor_sharing=force and 
it's worked like a dream.

Rachel

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

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

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

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

Re[2]: Looking for a test Database

[Jonathan Gennick]

For my SQL*Loader book, I downloaded a partial list of place names
from the U.S. Geological Survey web site. There's a file for each
state, and the number of names is quite large. Unfortunately, the data
structure is fairly simple, so you don't necessarily end up with many
tables. Though you could derive tables of county names, airport names,
township names, and the like.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Monday, July 02, 2001, 5:20:34 PM, you wrote:
GM> some books include a test database.  guy harrison's book has a web site and
GM> you can download a large test database from the web site for that book.  i
GM> believe gennick's book also has a test database, either on cd-rom or from a
GM> web site.  best of all, why not just use the scott/tiger demo database and
GM> write a few simple pl/sql loops that add as many rows as you want.


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

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

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

[Hagedorn, Linda]

Thank 
you Ross.  

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 12:25 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Disk layout for datafiles
  Search under "OFA" or "Optimal Flexible Architecture" for a wealth of 
  information. 
   
   
  
-Original Message-From: Hagedorn, Linda 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Disk layout for datafiles
I found and then lost a Metalink 
document about laying out datafiles under five or seven mount points. 
Does anyone have a link to this note, or any regarding datafile naming 
conventions/path layouts for unix/sun? 
Thanks, Linda 

RE: Migration Workbench

[MakoSoft]

Thanks, Reed, I'm in.  Guess you had the same problem cause I found nothing on 
Metalink.


Dave

-
There is a bug in migration workbench that you have to make sure that your
root password on the mysql database is 8 characters long, then specify that
password when connecting through migration workbench.


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

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

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

RE: LMT for system tablespace

[Jim Newman]

Isn't SYSTEM the original locally managed tablespace? (lower case anyways)
%^)

Jim

-Original Message-
Carmichael
Sent: Monday, July 02, 2001 4:10 AM
To: Multiple recipients of list ORACLE-L


Justin,

You can't make the SYSTEM tablespace a locally managed tablespace. Oracle
won't allow it. Not even in 9i. :)  And they do set up the other tablespaces
as LMTs in the demo install.

Rachel


>From: "Justin Coleman" Reply-To: [EMAIL PROTECTED] To: Multiple
>recipients of list ORACLE-L Subject: LMT for system tablespace Date: Mon,
>02 Jul 2001 02:45:27 -0800
>
>Dear All,
>
>A quick question.
>
>Is there any issues with setting up the System Tablespace as a Local
>Managed Tablespace? Do everyone now do this, or people still set-up as a
>Dictionary Managed Tablespace?
>
>Cheers, Justin
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com --
>Author: Justin Coleman INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego,
>California -- Public Internet access / Mailing Lists
> To
>REMOVE yourself from this mailing list, send an E-Mail message to:
>[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
>BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
>list you want to be removed from). You may also send the HELP command for
>other information (like subscribing).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

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

[Norwood Bradly A]

Title: CURSOR_SHARING = FORCE ques.



You're probably referring to this bug, Ivan, I haven't 
seen a fix via MetaLink.
Somewhere I read a recommendation of 
cursor_sharing=exact, but can't pinpoint 
that 
advice.
 
BUG 984132Description: If 
automatic replacement of literals with bind variables is enabled by using 
setting CURSOR_SHARING = FORCE (either in as an initialization parameter or 
by setting it in an ALTER SYSTEM or ALTER SESSION statement), then 
statements with literals in a cursor expression can core dump. 
There 
is no workaround for thisproblem, other than disabling replacement of 
literals. Eg: "selectcursor(select 'a' from dual) from po" may 
dump    

 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 5:33 
PMTo: Multiple recipients of list ORACLE-LSubject: 
CURSOR_SHARING = FORCE ques.
Gurus 
Well the boss is now getting on my back for me to upgrade my OCP 
to 8i.  I know, I know, I wasn't going to, please don't flame me, but work 
is insisting that I do.  So now I'm studying the upgrade book and it's 
sparked up a couple of questions regarding cursor_sharing = force.
1) I've heard a bunch of negative things (like bugs) regarding 
using this feature, was this just with 8.1.6 or is it still buggy?
2) Anyone out there using it?  Does it give that much 
better performance gains?  It seems to me like it's not worth 
implementing.
3)Can the guys playing with 9i out there verify if this is buggy 
in 9i? 
Thanks to all. Ivan Rivera 

CURSOR_SHARING = FORCE ques.

[Ivan_Rivera]

Title: CURSOR_SHARING = FORCE ques.





Gurus


Well the boss is now getting on my back for me to upgrade my OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, but work is insisting that I do.  So now I'm studying the upgrade book and it's sparked up a couple of questions regarding cursor_sharing = force.

1) I've heard a bunch of negative things (like bugs) regarding using this feature, was this just with 8.1.6 or is it still buggy?

2) Anyone out there using it?  Does it give that much better performance gains?  It seems to me like it's not worth implementing.

3)Can the guys playing with 9i out there verify if this is buggy in 9i?


Thanks to all.
Ivan Rivera 

RE: Migration Workbench

[Kempf, Reed]

There is a bug in migration workbench that you have to make sure that your
root password on the mysql database is 8 characters long, then specify that
password when connecting through migration workbench.

This should clear up the handshake error.

Hope this helps.

-Original Message-
Sent: Monday, July 02, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Has anyone encountered problems with the Migration Workbench?  

We are moving an older database from mysql 3.23 to oracle 8.1.7, however,
when I try to connect to the mysql database from the tool, I get either a
handshake error, or told no databases running on that server.

I am able to connect to the mysql from windows command line.  

And to anyone that has used the migration tool in general, did they find it
of much use?

Thanks,

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

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

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

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

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

Migration Workbench

[MakoSoft]

Has anyone encountered problems with the Migration Workbench?  

We are moving an older database from mysql 3.23 to oracle 8.1.7, however, when I try 
to connect to the mysql database from the tool, I get either a handshake error, or 
told no databases running on that server.

I am able to connect to the mysql from windows command line.  

And to anyone that has used the migration tool in general, did they find it of much 
use?

Thanks,

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

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

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

Re: have been wondering for quite a while

[Oliver Artelt]

Hi,

CONSTRAINT_TYPE  
 VARCHAR2(1)  
   
Type of constraint definition:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option on a view)
O (with read only, on a view)  


oli


[EMAIL PROTECTED] wrote:
> DBAs:
> 
> On the user_constraints view, you can find the constraint_type has five 
distinct
> values:
> C, O, P, R, U, and V.
> C=check,
> P=primary key,
> R=foreign key,
> U=unique key.
> What about O and V?
> 
> If I assume O=optional(null/not null), I really can not guess V.
> 
> Anyone can help?, Thanks in advance.
> 
> William
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: William Dong
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

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

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

[Rachel Carmichael]

null is a check constraint

v is (I believe) a view constraint



>From: "William Dong" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: have been wondering for quite a while
>Date: Mon, 02 Jul 2001 12:46:41 -0800
>
>DBAs:
>
>On the user_constraints view, you can find the constraint_type has five 
>distinct
>values:
>C, O, P, R, U, and V.
>C=check,
>P=primary key,
>R=foreign key,
>U=unique key.
>What about O and V?
>
>If I assume O=optional(null/not null), I really can not guess V.
>
>Anyone can help?, Thanks in advance.
>
>William
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: William Dong
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

Re: have been wondering for quite a while

[Stephane Faroult]

William Dong wrote:
> 
> DBAs:
> 
> On the user_constraints view, you can find the constraint_type has five distinct
> values:
> C, O, P, R, U, and V.
> C=check,
> P=primary key,
> R=foreign key,
> U=unique key.
> What about O and V?
> 
> If I assume O=optional(null/not null), I really can not guess V.
> 
> Anyone can help?, Thanks in advance.
> 
> William
> 
> --

Out of memory, I think it is 'CHECK OPTION' for views. Check
$ORACLE_HOME/rdbms/admin/sql.bsq for cdef$.

Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Re: The Median, The Joe Celko Solution , and Wait Events

[Gaja Krishna Vaidyanatha]

Hi Ian,

You are right, in this case the contention may be
"self-inflicted" by the process that you are running.
Hopefully you are using "both prongs" in the 2-prong
method that we suggest. The O/S prong is very useful
especially in cases such as these. The state of
"waited short time" indicates that the wait events are
for a duration of < 1/100th of a second (centisecond).
Such wait events are usually not a "source for
concern" unless they occur many times within a short
period of time (say the duration of running the SQL
statement). 

Although "many" cannot be defined and generalized, a
frequency of many thousands of times within the short
period should get your attention. You also should use
the 10046 wait event with level 12 for the offending
session, to trap the wait-events at the SQL
statement-level. Details on how to do that has been
described in "chapter 2", in the section "Trapping
Wait Events to a trace file". You can then look at the
ora_SPID.trc file and search for the keyword "WAIT"
and go from there.

To determine what P1 is in this case and in the
future, you can query P1_TEXT for a description of P1.
The same holds good for P2 and P3. Below is a
copy/paste of the "direct path read" wait event from
the Reference Guide:

direct path read


During Direct Path operations the data is
asynchronously read from the database files. At some
stage the session needs to make sure that all
outstanding asynchronous I/O have been completed to
disk. This can also happen if during a direct read no
more slots are available to store outstanding load
requests (a load request could consist of multiple
I/Os). 

Wait Time: 10 seconds. The session will be posted by
the completing asynchronous I/O. It will never wait
the entire 10 seconds. The session waits in a tight
loop until all outstanding I/Os have completed. 

Parameters: 

descriptor address 
 This is a pointer to the I/O context of outstanding
direct I/Os on which the session is currently waiting.
 
 
first dba 
 The dba of the oldest I/O in the context referenced
by the descriptor address. 
 
block cnt 
 Number of valid buffers in the context referenced by
the descriptor address. 
 
One of the related init.ora parameters that affects
this is DB_FILE_DIRECT_IO_COUNT. Keep us posted on how
things progress.

Cheers,

Gaja

--- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
> I ran  the Celko algorthm against scott.emp.  Wow
> was that fast!  Then I ran it against the 70,000
> record table which my alogorthm took 8 seconds to
> compute.   The statment hung.  Armed with "ORACLE
> 101 Performance Tuning" by Gaja, Kirti, and a John
> A. Kostelac, I  discovered that the event being
> waited for was "direct path read."   The explanation
> states this is usually due to  contention on
> devices.
> 
> I was running this on a test machine the with  no
> other user sql statements being run.  The only
> conflict  must be self-inflicted.  I then went to
> the v$session_wait table to further clarify the
> contention, but was not successful.
> V$SESSION_EVENT showed that  the total_waits columns
> was only being incremented for the "direct path
> read"  event.   The state of the wait for "direct
> path read" event was always "waited short time"  
> 
> What does the p1 value of v$session_wait indicate in
> this case?  It does not appear to be a file_id.
> 
> I killed the query after several minutes.  The
> "direct path read" wait events continued to
> increment until then.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> 
> 
> -Original Message-
> Sent: Monday, July 02, 2001 7:47 AM
> To: Multiple recipients of list ORACLE-L
> Code
> 
> 
> Ian,
> 
> Nice stuff!
> 
> Since this subject was brought back up, I thought
> maybe some would be
> interested in the following. I've never had a need
> to calculate a median,
> but, I knew Celko's SQL for Smarties had a few
> variations and examples from
> various people, each with caveats. And then there
> were differences between
> what he termed statistical and financial mean, and
> some other things as
> well. Anyway, a google search turned up another
> Celko solution. And this one
> also brings up the concept of weighted median.
> 
> Here is his example,
>
http://www.intelligententerprise.com/db_area/archives/1999/992004/celko.shtm
> l, modified by me to use the  standard EMP table's
> SAL column:
> 
> SQL> SELECT AVG(DISTINCT x.sal)
>   2FROM (SELECT F1.sal
>   3FROM emp F1, emp F2
>   4   GROUP BY F1.empno, F1.sal
>   5  HAVING SUM(CASE WHEN F2.sal = F1.sal
>   6   THEN 1 ELSE 0 END)
>   7  >= ABS(SUM(CASE WHEN F2.sal < F1.sal
> THEN 1
>   8  WHEN F2.sal > F1.sal
> THEN -1
>   9   ELSE 0 END)))
>  10  X
>  11  /
> 
> AVG(DISTINCTX.SAL)
> --
>   1550
> 
> The link above goes into some detail regarding the
> logic behind the query

RE: The Median, The Joe Celko Solution , and Wait Events

[Norwood Bradly A]

Ian:

Steve Adams briefly addressed P1 a few weeks ago in "What is a fib?" on his
Ixora site.
I don't recall the details.

-Original Message-
Sent: Monday, July 02, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


I ran  the Celko algorthm against scott.emp.  Wow was that fast!  Then I ran
it against the 70,000 record table which my alogorthm took 8 seconds to
compute.   The statment hung.  Armed with "ORACLE 101 Performance Tuning" by
Gaja, Kirti, and a John A. Kostelac, I  discovered that the event being
waited for was "direct path read."   The explanation states this is usually
due to  contention on devices.

I was running this on a test machine the with  no other user sql statements
being run.  The only conflict  must be self-inflicted.  I then went to the
v$session_wait table to further clarify the contention, but was not
successful.
V$SESSION_EVENT showed that  the total_waits columns was only being
incremented for the "direct path read"  event.   The state of the wait for
"direct path read" event was always "waited short time"  

What does the p1 value of v$session_wait indicate in this case?  It does not
appear to be a file_id.

I killed the query after several minutes.  The "direct path read" wait
events continued to increment until then.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, July 02, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L
Code


Ian,

Nice stuff!

Since this subject was brought back up, I thought maybe some would be
interested in the following. I've never had a need to calculate a median,
but, I knew Celko's SQL for Smarties had a few variations and examples from
various people, each with caveats. And then there were differences between
what he termed statistical and financial mean, and some other things as
well. Anyway, a google search turned up another Celko solution. And this one
also brings up the concept of weighted median.

Here is his example,
http://www.intelligententerprise.com/db_area/archives/1999/992004/celko.shtm
l, modified by me to use the  standard EMP table's SAL column:

SQL> SELECT AVG(DISTINCT x.sal)
  2FROM (SELECT F1.sal
  3FROM emp F1, emp F2
  4   GROUP BY F1.empno, F1.sal
  5  HAVING SUM(CASE WHEN F2.sal = F1.sal
  6   THEN 1 ELSE 0 END)
  7  >= ABS(SUM(CASE WHEN F2.sal < F1.sal THEN 1
  8  WHEN F2.sal > F1.sal THEN -1
  9   ELSE 0 END)))
 10  X
 11  /

AVG(DISTINCTX.SAL)
--
  1550

The link above goes into some detail regarding the logic behind the query
and how his query finally reached the form above. I may never need to do a
median, but, this subject has been a good opportunity for learning. I've
tested the above with even, odd, multiple occurences of SAL, null,s etc. It
seems to work, but, everyone have a whack at it if you like.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MacGregor,
> Ian A.
> Sent: Saturday, June 30, 2001 9:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Calculating The Median: Error Discovered in Oracle SQL 101 Code
>
>
> I ran the code from Oracle SQL 101 which Jared posted modifying
> it to find the median of the sal  column on that table
>
> SQL> select
>   2   rownum,
>   3   sal
>   4  from (
>   5   select sal
>   6   from scott.emp
>   7   where sal is not null
>   8   union
>   9   select 1 from dual where 1=2
>  10  )
>  11  group by sal, rownum
>  12  having rownum >= (
>  13   select decode( mod(total_freq,2),
>  141,trunc(total_freq/2 + 1),
>  150,trunc(total_freq/2)
>  16   )
>  17   from (
>  18select count(*) total_freq
>  19from scott.emp
>  20where sal is not null
>  21   )
>  22  )
>  23  and rownum <= (
>  24   select decode( mod(total_freq,2),
>  251,trunc(total_freq/2 + 1),
>  260,trunc(total_freq/2 + 1)
>  27   )
>  28   from (
>  29select count(*) total_freq
>  30from scott.emp
>  31where sal is not null
>  32   )
>  33  )
>  34  /
>
>values
>  averaged
> ROWNUM  in median
> -- --
>  7   1600
>  8   2450
>--
> Median   2025
>
> --
> 
> This answer is different from the result of the code I posted
> which uses the new analytical functions.
>
>  select
>  case
>  when mod(number_salaried,2) = 0 then
> (select sum(sal)/2 from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> where salrank  = number_salaried/2
> or salrank = number_salaried/2 +1)
>  else
> (select sal from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> 

Re: Replacement patches for listener security bugs 1656431 and 1814117

[Ray Stell]

On Mon, Jul 02, 2001 at 09:45:29AM -0800, A. Bardeen wrote:
> To download these patches from metalink:
> 
> Select Patches from the left hand menu
>   Click on the red "==> Click here for Patches
> released after February 19, 2001 and for all
> Application Patches. " link
> Enter one of the above patch #'s 
> 
-- 
The patch is not in tar.Z format, even for unix systems.

The 8.1.6.3.0 instructions don't mention any constraints.  The script
warns you:

   This procedure assumes that:
- Your current working directory
  /db03/app/oracle/product/8.1.6/patches/1788961
  is where you have restored this patch archive to.
- You have read the README.* file.
- You have at least 120 Mb available in the following filesystem.
  /db03/app/oracle/product/8.1.6
- You have at least 39 Mb available in following filesystem
  /db03/app/oracle/product/8.1.6/lib
- You have shutdown all database instances under this ORACLE_HOME
  before running this script.
- YOU WILL NOT INTERRUPT THIS PROCEDURE!
  Are you ready to continue? [N] => y

Installation is smooth.  However, if you don't adhere to the above,
my guess is you will blow several toes off.  It would be nice
if the readme mentioned this up front.   
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Gogala, Mladen]

The other  really cool free tool is "tora" (Tool for ORAcle). It's free and
it works even on
Windoze platforms. Tora can be found through slashdot (go to "slashdot.org"
and
type  "tora" in the "search freshmeat" field. I tested the app on RH 6.2,
Slackware and 
Windoze platforms and it works on all of them.
 

-Original Message-
Sent: Monday, July 02, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L



Bunyamin, 
Download Toad (www.toadsoft.com).  It does it for you.  THe only thing it
doesn't handle (from what I remember) is partitioning. 

HTH 
Lisa Koivu 
Data Bored Administrator 
Ft. Lauderdale, FL, 

-Original Message- 
Sent:   Monday, July 02, 2001 1:46 PM 
To: Multiple recipients of list ORACLE-L 


Hi Gurus, 
I do not have time to write it. 
IF you have a script creating 
   the create table scripts of a schema, I will be so happy . 
Thanks 
Bunyamin 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Norwood Bradly A]

Robert:
 
You 
might try comparing your script to one of the old reverse engineering scripts on 
www.oramag.com.
-Original Message-From: Yexley Robert D SSgt AFIT/SCA 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 3:40 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
I wanted to throw this out there for anyone/everyone, whatever.  
Being the struggling, wannabe DBA that I am, if anyone gets a chance (or would 
be willing, just to help me out) to take a look at this script (the one attached 
to the original message) and provide any feedback/observations as to how it 
could be improved, I would certainly be open and 
appreciative.
 
Direct responses would probably be most appropriate.  Thanks for 
your time.
 
-::YEX::-
<)))><

  -Original Message-From: Yexley Robert D SSgt 
  AFIT/SCA [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 
  14:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A 
  SCHEMA.
  
  I just finished this the other day.  It works for individual 
  tables only, but you could pretty easily modify it to work for all of the 
  tables within a schema.  Hope it helps.
   
  -::YEX::-
  <)))><
   
   
  
-Original Message-From: Bunyamin K. Karadeniz 
[mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 
13:46 PMTo: Multiple recipients of list 
ORACLE-LSubject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS 
OF A SCHEMA.
Hi Gurus,
I do not have time to write it.
IF you have a script creating 
   
the create table scripts of a schema, I will be so happy .
Thanks 
Bunyamin

RE: have been wondering for quite a while

[Maser, Donna (SEA)]

>From the manual:
CONSTRAINT_TYPE 
Type of constraint definition:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option, on a view)
O (with read only, on a view)


-Original Message-
Sent: Monday, July 02, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L


DBAs:

On the user_constraints view, you can find the constraint_type has five
distinct
values:
C, O, P, R, U, and V.
C=check,
P=primary key,
R=foreign key,
U=unique key.
What about O and V?

If I assume O=optional(null/not null), I really can not guess V.

Anyone can help?, Thanks in advance.

William


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

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

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


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Yexley Robert D SSgt AFIT/SCA]

I wanted to throw this out there for anyone/everyone, whatever.  
Being the struggling, wannabe DBA that I am, if anyone gets a chance (or would 
be willing, just to help me out) to take a look at this script (the one attached 
to the original message) and provide any feedback/observations as to how it 
could be improved, I would certainly be open and 
appreciative.
 
Direct responses would probably be most appropriate.  Thanks for 
your time.
 
-::YEX::-
<)))><

  -Original Message-From: Yexley Robert D SSgt 
  AFIT/SCA [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 
  14:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A 
  SCHEMA.
  
  I just finished this the other day.  It works for individual 
  tables only, but you could pretty easily modify it to work for all of the 
  tables within a schema.  Hope it helps.
   
  -::YEX::-
  <)))><
   
   
  
-Original Message-From: Bunyamin K. Karadeniz 
[mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 
13:46 PMTo: Multiple recipients of list 
ORACLE-LSubject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS 
OF A SCHEMA.
Hi Gurus,
I do not have time to write it.
IF you have a script creating 
   
the create table scripts of a schema, I will be so happy .
Thanks 
Bunyamin

Re: Looking for a test Database

[Greg Moore]

some books include a test database.  guy harrison's book has a web site and
you can download a large test database from the web site for that book.  i
believe gennick's book also has a test database, either on cd-rom or from a
web site.  best of all, why not just use the scott/tiger demo database and
write a few simple pl/sql loops that add as many rows as you want.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 7:06 AM


> Hi
> I was wondering if there is somewhere that I can get a small test
database.
> I know some of the products have databases to be installed, I have done
> some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7
> installed I was hoping to find something a little meatier in size to run
> some tests with. perhaps something that might build a Meg or more of
> tables and data
> TIA
>
>
> Peter McLarty
> [EMAIL PROTECTED]
> 04 0209 4238
> L Plate Oracle DBA
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Peter McLarty
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

SQL translation from Access/VB/ADO to Oracle/VB/ADO

[Johnston, Steve]

I have a sql string generated in a vb function that returns a sql string.  Worked fine 
in Access but as it uses internal vb functions in a couple of places it fails in 
Oracle.  If someone could point the error of my ways I'd appreciate the language 
lesson..
(I take no responsibility for the table design!.. existing app!)

Working Access String:
SELECT H.SSNO, CDbl([A.GIFTVAL]*-1) AS GVal, H.EMPNO,  H.FNAME, H.LNAME FROM H1EMP H 
INNER JOIN AWARDS_AWARDS A ON A.EmpNo = H.EmpNo WHERE ((A.ORDERNO)='& CStr(6) &' AND 
((A.BATCHKEY)=6) ORDER BY H.LNAME, H.FNAME;

Non-Working Oracle String:
SELECT H.SSNO, TO_NUMBER([A.GIFTVAL]*-1) AS GVal, H.EMPNO,  H.FNAME, H.LNAME FROM 
H1EMP H INNER JOIN AWARDS_AWARDS A ON A.EmpNo = H.EmpNo WHERE ((A.ORDERNO)= TO_CHAR(6) 
&  AND ((A.BATCHKEY)=6) ORDER BY H.LNAME, H.FNAME;


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

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

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

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[The Oracle DBA]

And sub-partitioning



---

TheOracleDBA
[EMAIL PROTECTED]



On Mon, 02 Jul 2001 11:40:23  
 Koivu, Lisa wrote:
>Bunyamin, 
>Download Toad (www.toadsoft.com).  It does it for you.  THe only thing it
>doesn't handle (from what I remember) is partitioning. 
>
>HTH
>Lisa Koivu
>Data Bored Administrator
>Ft. Lauderdale, FL, 
>
>> -Original Message-
>> From:Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]]
>> Sent:Monday, July 02, 2001 1:46 PM
>> To:  Multiple recipients of list ORACLE-L
>> Subject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS  OF A SCHEMA.
>> 
>> Hi Gurus,
>> I do not have time to write it.
>> IF you have a script creating 
>>the create table scripts of a schema, I will be so happy .
>> Thanks 
>> Bunyamin
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Bunyamin K. Karadeniz]

Title: RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.



Thank you Lisa  .
Bunyamin 

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, July 02, 2001 10:40 
PM
  Subject: RE: SCRIPT NEEDED TO MAKE THE 
  CREATE TABLE SCRIPTS OF A SCHEMA.
  
  Bunyamin, Download Toad (www.toadsoft.com).  It does it for 
  you.  THe only thing it doesn't handle (from what I remember) is 
  partitioning. 
  HTH Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, 
  
-Original Message- From:   Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday, July 02, 2001 1:46 PM To: Multiple recipients of list ORACLE-L Subject:    SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS  OF A 
SCHEMA. 
Hi Gurus, I do 
not have time to write it. IF you have a 
script creating    the create table scripts of a schema, I will be so happy 
. Thanks Bunyamin 

RE: Oracle 8.1.6 and Web Server 4.0.8.2 - session specific tempor

[Grabowy, Chris]

It appears the developer find the answer in the doc...

I was going through some Oracle documentation and came across the following:

Writing Stateful PL/SQL Stored Procedures

Typically, when a PL/SQL stored procedure is run over the web, its
state goes away when the procedure ends. This state information includes the
values  of any package variables it accesses, its transaction
state, and any rows it inserted into temporary tables. 


This anwsers my question. I knew that web was stateless, but I did not know
that the state information included rows inserted into temporary tables.

Thanks everyone.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 24, 2001 8:16 PM
To: Multiple recipients of list ORACLE-L
tempor


Hi Chris,

Was the table created to preserve on commit or to delete on commit?

If created as delete on commit then maybe webserver issues a commit between
the 2 procedures?

Regards,
Bruce

-Original Message-
Sent: Saturday, 23 June 2001 4:43 

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

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

Any ideas?  Has anyone been in this particular situation?

Many thanks!!!

Chris 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

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

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

have been wondering for quite a while

[William Dong]

DBAs:

On the user_constraints view, you can find the constraint_type has five distinct
values:
C, O, P, R, U, and V.
C=check,
P=primary key,
R=foreign key,
U=unique key.
What about O and V?

If I assume O=optional(null/not null), I really can not guess V.

Anyone can help?, Thanks in advance.

William


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

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

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

The Median, The Joe Celko Solution , and Wait Events

[MacGregor, Ian A.]

I ran  the Celko algorthm against scott.emp.  Wow was that fast!  Then I ran it 
against the 70,000 record table which my alogorthm took 8 seconds to compute.   The 
statment hung.  Armed with "ORACLE 101 Performance Tuning" by Gaja, Kirti, and a John 
A. Kostelac, I  discovered that the event being waited for was "direct path read."   
The explanation states this is usually due to  contention on devices.

I was running this on a test machine the with  no other user sql statements being run. 
 The only conflict  must be self-inflicted.  I then went to the v$session_wait table 
to further clarify the contention, but was not successful.
V$SESSION_EVENT showed that  the total_waits columns was only being incremented for 
the "direct path read"  event.   The state of the wait for "direct path read" event 
was always "waited short time"  

What does the p1 value of v$session_wait indicate in this case?  It does not appear to 
be a file_id.

I killed the query after several minutes.  The "direct path read" wait events 
continued to increment until then.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, July 02, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L
Code


Ian,

Nice stuff!

Since this subject was brought back up, I thought maybe some would be
interested in the following. I've never had a need to calculate a median,
but, I knew Celko's SQL for Smarties had a few variations and examples from
various people, each with caveats. And then there were differences between
what he termed statistical and financial mean, and some other things as
well. Anyway, a google search turned up another Celko solution. And this one
also brings up the concept of weighted median.

Here is his example,
http://www.intelligententerprise.com/db_area/archives/1999/992004/celko.shtm
l, modified by me to use the  standard EMP table's SAL column:

SQL> SELECT AVG(DISTINCT x.sal)
  2FROM (SELECT F1.sal
  3FROM emp F1, emp F2
  4   GROUP BY F1.empno, F1.sal
  5  HAVING SUM(CASE WHEN F2.sal = F1.sal
  6   THEN 1 ELSE 0 END)
  7  >= ABS(SUM(CASE WHEN F2.sal < F1.sal THEN 1
  8  WHEN F2.sal > F1.sal THEN -1
  9   ELSE 0 END)))
 10  X
 11  /

AVG(DISTINCTX.SAL)
--
  1550

The link above goes into some detail regarding the logic behind the query
and how his query finally reached the form above. I may never need to do a
median, but, this subject has been a good opportunity for learning. I've
tested the above with even, odd, multiple occurences of SAL, null,s etc. It
seems to work, but, everyone have a whack at it if you like.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MacGregor,
> Ian A.
> Sent: Saturday, June 30, 2001 9:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Calculating The Median: Error Discovered in Oracle SQL 101 Code
>
>
> I ran the code from Oracle SQL 101 which Jared posted modifying
> it to find the median of the sal  column on that table
>
> SQL> select
>   2   rownum,
>   3   sal
>   4  from (
>   5   select sal
>   6   from scott.emp
>   7   where sal is not null
>   8   union
>   9   select 1 from dual where 1=2
>  10  )
>  11  group by sal, rownum
>  12  having rownum >= (
>  13   select decode( mod(total_freq,2),
>  141,trunc(total_freq/2 + 1),
>  150,trunc(total_freq/2)
>  16   )
>  17   from (
>  18select count(*) total_freq
>  19from scott.emp
>  20where sal is not null
>  21   )
>  22  )
>  23  and rownum <= (
>  24   select decode( mod(total_freq,2),
>  251,trunc(total_freq/2 + 1),
>  260,trunc(total_freq/2 + 1)
>  27   )
>  28   from (
>  29select count(*) total_freq
>  30from scott.emp
>  31where sal is not null
>  32   )
>  33  )
>  34  /
>
>values
>  averaged
> ROWNUM  in median
> -- --
>  7   1600
>  8   2450
>--
> Median   2025
>
> --
> 
> This answer is different from the result of the code I posted
> which uses the new analytical functions.
>
>  select
>  case
>  when mod(number_salaried,2) = 0 then
> (select sum(sal)/2 from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> where salrank  = number_salaried/2
> or salrank = number_salaried/2 +1)
>  else
> (select sal from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> where salrank = ceil(number_salaried/2))
>  end median
>  from (select sal,rank() over (order by sal) as rk from scott.emp),
>  (select count(sal) number_salaried from scott.emp)
>  where rk = 1
> /
>
>MEDIAN
> 

mts, 2 listeners, protocol.ora

[yangx]

Hi Gurus,

I am puzzled about when protocol.ora is used when the listener get started. 


I have two listeners (regular and TNS_ADMIN) that listen for two sets of 
databases, regular dedicated and MTS, respectively.  I want to restrict 
connections for only the databases with dedicated connections.

I can do it, but only when the mts listener is started first WITHOUT 
protocol.ora in place, then the dedicated listener with protocol.ora in the 
$ORACLE_HOME/network/admin directory.

This is not the case when both listeners listen for only dedicated 
connection databases.  protocol.ora gets used properly for this situation 
and no need for this particular order of starting.

Does anyone know why?

Thanks,

Sharon

Xiaohong Yang (Sharon)
Certified Oracle database administrator
Center for Bioinformatics
UNC-CH


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

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

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

java error

[Farnsworth, Dave]

I have a java developer that is getting the following error when running a
java query.  I have Oracle 8.1.7 running on NT 4.0 SP5.

processOutgoingFreeTextMessages()java.sql.SQLException: Message file
'oracle.jdbc.dbaccess.Messages' is missing.

I cannot find any info on it on Metalink and also got only three hits on
google.  The three hits were people with about the same question.  Any help
or info would be appreciated.

Thanks,

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

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

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

RE: Gaping holes found in Oracle 8i (patch 1654631 info)

[Miller, Jay]

I just wanted to say THANK YOU to everyone who posted on this.  I see a
patch installation in my near future...

-Original Message-
Sent: Monday, July 02, 2001 5:31 AM
To: Multiple recipients of list ORACLE-L


Ian,

Per MetaLink info on the patches:

Reason for Obsolescence
  This patch is being withdrawn because of a
regression of bug 1654631 which is fixed as bug
1814117 . The patch will be made available again with
the new fix included as soon as possible. 


BTW, when the new patch is released it can be applied
over the old patch if that one was already installed.

HTH,

-- Anita


--- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
> Why was it obsoleted?  Did the patch contain a bug?
> 
> Ian MacGregor
> Stanford Linear Acclerator Center
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: A. Bardeen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 29, 2001 4:34 PM
> To: MacGregor, Ian A.; LazyDBA.com Discussion;
> ORACLE-L
> Subject: RE: Gaping holes found in Oracle 8i (patch
> 1654631 info)
> 
> 
> Patch 1654631 has been obsoleted in favor of patch
> 1814117.  1814117 is listed in metalink as
> obsoleted,
> but it will be replaced shortly (expected date is
> Monday, 07/02/2001).
> 
> The patch will be released for the following
> versions:
> 
> 8.1.7.1, 8.1.6.3, 8.1.6.2 and 8.1.6.1.
> 
> For any platforms that have 5 digit patchsets as the
> latest patchset (ex. 8.1.6.3.2 64-bit on HP-UX 11) I
> expect that it will be released for the latest
> patchset.
> 
> These patches will not require passwords, the way
> other PSE's do.
> 
> HTH,
> 
> -- Anita
> 
> 
> 
> 
> --- "MacGregor, Ian A." <[EMAIL PROTECTED]>
> wrote:
> > It is true.  Patches are available via Metalink. 
> > Yesterday the only patches available were for  the
> > latest release levels.  For instance, there is a
> > patch for 8.1.6.3 but not 8.1.6.0 through 8.1.6.2;
> > there is a patch for 8.1.7.1 but not 8.1.7.0.  
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > 
> > -Original Message-
> > From: Thye Hock Gan [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 29, 2001 12:19 AM
> > To: LazyDBA.com Discussion
> > Subject: Re: Gaping holes found in Oracle 8i
> > 
> > 
> > This is not some prank, is it? Do you know the
> link
> > to
> > the patches?
> > 
> > --- Kavi Zaman <[EMAIL PROTECTED]> wrote:
> > > 
> > > 
> > > Guys,
> > > Check this out- 
> > > 
> > > http://www.itnews.com.au/story.cfm?ID=7091#top
> > > 
> > > Any thought please share.
> > > 
> > > Thanks
> > > Kavi Zaman
> > > 
> > > 
> > > 
> > > Oracle documentation is here:
> > >
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > > To unsubscribe: send a blank email to
> > > [EMAIL PROTECTED]
> > > To subscribe:   send a blank email to
> > > [EMAIL PROTECTED]
> > > Visit the list archive:
> > > http://www.LAZYDBA.com/odbareadmail.pl
> > > Tell yer mates about http://www.farAwayJobs.com
> > > By using this list you agree to these
> > > terms:http://www.lazydba.com/legal.html
> > > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.com/
> > 
> > 
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > [EMAIL PROTECTED]
> > To subscribe:   send a blank email to
> > [EMAIL PROTECTED]
> > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > 
> > 
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > [EMAIL PROTECTED]
> > To subscribe:   send a blank email to
> > [EMAIL PROTECTED]
> > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > 
> 
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/


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

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

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

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Yexley Robert D SSgt AFIT/SCA]

I just finished this the other day.  It works for individual tables 
only, but you could pretty easily modify it to work for all of the tables within 
a schema.  Hope it helps.
 
-::YEX::-
<)))><
 
 

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 13:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A 
  SCHEMA.
  Hi Gurus,
  I do not have time to write it.
  IF you have a script creating 
     
  the create table scripts of a schema, I will be so happy .
  Thanks 
  Bunyamin
 gen_table_ddl.sql

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Jack C. Applewhite]

Bunyamin,
 
A very easy thing to do is export the schema 
(Rows=No), then copy the Create Table statements from the *.dmp file.  That 
way you don't have to worry about your script getting out of date with features 
of newer versions of the RDBMS.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. 
  KaradenizSent: Monday, July 02, 2001 12:46 PMTo: 
  Multiple recipients of list ORACLE-LSubject: SCRIPT NEEDED TO MAKE 
  THE CREATE TABLE SCRIPTS OF A SCHEMA.
  Hi Gurus,
  I do not have time to write it.
  IF you have a script creating 
     
  the create table scripts of a schema, I will be so happy .
  Thanks 
  Bunyamin

RE: Disk layout for datafiles

[Mohan, Ross]

Search 
under "OFA" or "Optimal Flexible Architecture" for a wealth of information. 

 
 

  -Original Message-From: Hagedorn, Linda 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31 
  PMTo: Multiple recipients of list ORACLE-LSubject: Disk 
  layout for datafiles
  I found and then lost a Metalink 
  document about laying out datafiles under five or seven mount points. 
  Does anyone have a link to this note, or any regarding datafile naming 
  conventions/path layouts for unix/sun? 
  Thanks, Linda 

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Koivu, Lisa]

Title: RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS  OF A SCHEMA.





Bunyamin, 
Download Toad (www.toadsoft.com).  It does it for you.  THe only thing it doesn't handle (from what I remember) is partitioning. 

HTH
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, 


-Original Message-
From:   Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 02, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
Subject:    SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS  OF A SCHEMA.


Hi Gurus,
I do not have time to write it.
IF you have a script creating 
   the create table scripts of a schema, I will be so happy .
Thanks 
Bunyamin

Re: "ALTER SYNONYM"?

[Ron Thomas]

The problem with this would be any dependent objects on the view would need to be 
recompiled
whenever the view was created.  How about a synonym to a periodically recreated view?

Ron.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
"Karaoke: Japanese for migraine."



   

Jim.Conboy@tr  

w.comTo: [EMAIL PROTECTED]  

Sent by: cc:   

root@fatcity.Subject: Re: "ALTER SYNONYM"? 

com

   

   

07/02/01   

08:35 AM   

Please 

respond to 

ORACLE-L   

   

   





Can you use a view instead?

SVRMGR> create table temp1 (temp1 varchar2(1));
Statement processed.
SVRMGR> create table temp2 (temp1 varchar2(1));
Statement processed.
SVRMGR> insert into temp1 values ('a');
1 row processed.
SVRMGR> insert into temp1 values ('a');
1 row processed.
SVRMGR> insert into temp1 values ('a');
1 row processed.
SVRMGR> insert into temp1 values ('a');
1 row processed.
SVRMGR> insert into temp2 values ('b');
1 row processed.
SVRMGR> insert into temp2 values ('b');
1 row processed.
SVRMGR> insert into temp2 values ('b');
1 row processed.
SVRMGR> create or replace view temp as select * from temp1;
Statement processed.
SVRMGR> select * from temp;
T
-
a
a
a
a
4 rows selected.
SVRMGR> create or replace view temp as select * from temp2;
Statement processed.
SVRMGR> select * from temp;
T
-
b
b
b
3 rows selected.
SVRMGR>

Maybe some unwanted overhead with the view, but it might help out.

Jim



>>> [EMAIL PROTECTED] 06/30/01 04:56PM >>>
Is there a way to do what would be an ALTER SYNONYM?

I've got a synonym created that rotates between pointing to two different
tables.  Sometimes it points to TABLE_A, sometimes to TABLE_B.  (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table "never disappears".)

However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:

drop synonym table_syn;
create synonym table_syn for table_b;

Is there a way to make that instantaneous for the database?  If someone
does a select at the exact instant between those two commands, it'll error
out, because the table "won't exist".

-Rick

+--+
| Rick Osterberg   [EMAIL PROTECTED]|
| Database Applications Specialist FAS Computer Services   |
+--+

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

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

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



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

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

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

Disk layout for datafiles

[Hagedorn, Linda]

I found and then lost a Metalink document about laying out datafiles 
under five or seven mount points. Does anyone have a link to this note, or 
any regarding datafile naming conventions/path layouts for unix/sun? 
Thanks, Linda 

SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

[Bunyamin K. Karadeniz]

Hi Gurus,
I do not have time to write it.
IF you have a script creating 
   
the create table scripts of a schema, I will be so happy .
Thanks 
Bunyamin

Replacement patches for listener security bugs 1656431 and 1814117

[A. Bardeen]

Hi all!

The following replacement PSE's for listener security
bugs 1656431 and 1814117 are available on metalink:

For 8.1.7.1: 1859604 

For 8.1.6.3: 1859654 

These are the only replacement PSE's of which I'm
aware, but I expect that replacement PSE's for
different releases and OS's will be forthcoming.

To download these patches from metalink:

Select Patches from the left hand menu
  Click on the red "==> Click here for Patches
released after February 19, 2001 and for all
Application Patches. " link
Enter one of the above patch #'s 

You must have the appropriate patchset applied.  For
example PSE 1859654 can be applied only to 8.1.6.3.0. 
If you are running an earlier version of 8.1.6 you
must wait for the PSE for your version to be released
or apply the 8.1.6.3.0 patchset first.  For those of
you running 64-bit Oracle versions that 8.1.6.3.x
patchset released, you must wait for the PSE for your
specific 5-digit patchset (i.e you cannot apply the
PSE for 64-bit 8.1.6.3.0 to a db running 8.1.6.3.1).

HTH,

-- Anita



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

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

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

RE: temp problem when rebuilding Index

[Gupta, Brijesh]

Title: RE: temp problem when rebuilding Index





You can increase the SORT_AREA_SIZE for that particular session only.


Alter session set SORT_AREA_SIZE=  ;


You don't have to change the init.ora just for rebuilding index.


But if index is large , I still prefer dropping and recreating it.


Brijesh
-Original Message-
From: james ellis [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: temp problem when rebuilding Index



You can also increase your SORT_AREA_SIZE parameter in
the initDBNAME.ora. This will allow more of your
sorting to be done in memory rather on disk. This will
also help speed up the process.


--- Raghu Kota <[EMAIL PROTECTED]> wrote:
> Hi Friends
> 
> Iam rebuilding my 6Gb index, But Iam getting problem
> with TEMP tablespace. 
> What is solution for this??
> 
> iam using alter index index_name rebuild
> tablespace_name;
> 
> ORA-1652: unable to extend temp segment by 128 in
> tablespace    TEMP
> 
> Any Ideas??
> 
> Thanks
> Raghu.
>
_
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Raghu Kota
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California    -- Public Internet
> access / Mailing Lists
>

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



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


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

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

FRM-92090 Error

[dmeng]

Hi All,
We just installed Apps 11.5.2 on one of our Solaris 2.7 servers and were
able to start up all the processes sucessfully.
After loggin on through the apps logon front end I encountered the
following error when clicking on any one of the application modules:

FRM-92090: An unexpected error occurred.

Details...
Java Exception:
java.lang.NullPointerException
   at oracle.forms.net.HTTPStream.getResponse(Compiled Code)
   at oracle.forms.netHTTPStream.flush(Compiled Code)
   at oracle.forms.engine.Main.createRunform(Unknown Source)
   at oracle.forms.engine.Main.start(Unknown Source)
   at sun.applet.JinitAppletPanel.run(Compiled Code )
   at java.lang.Thread.run(Thread.java:466)

Anybody has a clue of what is going on?
TIA!
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

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

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

*1*: Where is RemoteORADBA?

[The Oracle DBA]

Hi Don.

This is Earl. Have we met?


---

TheOracleDBA
[EMAIL PROTECTED]



On Sun, 01 Jul 2001 07:50:20  
 Don Dealy II wrote:
>Anybody know the current web page or email address for Earl Shaffer and the company 
>RemoteOraDba?
>
>Thx - Don
>
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

[Ramon Estevez]

Thanks again to all that reply

I used the procedure run of the package DBMS_JOB to reexecute my jobs
and they rescheduled with the correct dates again

DMBS_JOB.RUN(JOB_NUMBER)

tks

Ramon Estevez 



*809-565-3121 x 225

 

* [EMAIL PROTECTED]

 



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ramon Estevez
Enviado el: Monday, 02 July, 2001 9:01 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBMS_JOB


Thanks to all that reply,

I want to clean the queue, erase to the jobs, and reschedule them again

Ramon Estevez 



*809-565-3121 x 225

 

* [EMAIL PROTECTED]

 



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de A. Bardeen
Enviado el: Monday, 02 July, 2001 3:50 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBMS_JOB


Ramon,

When a job is broken the next_date is set to
01/01/4000.

I'm not sure I understand exactly what your initial
request was, but you can alter the next_date and
interval for any job using DBMS_JOB.CHANGE (or by
calling DBMS_JOB.NEXT_DATE and DBMS_JOB.INTERVAL
individually).

For examples of specifying different intervals, see
Note: 1068369.6 "Example:  Using DBMS_JOB.SUBMIT to
Execute Jobs at Regular Intervals"

HTH,

-- Anita

--- Raymond Lee Meng Hong <[EMAIL PROTECTED]>
wrote:
> If order to stop those funny date , can you show me
> the code of your pl/sql
> and let us try to solve it ? Becoz it seen you try
> to add in those error
> date into your next_date ?
> 
> You might need to create a lookup table to key in
> those require date,and let
> it parse to the procedure automatical..
> 
> 
> 
> -Original Message-
> Sent: Saturday, June 30, 2001 6:41 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thanks Ray and Dick,
> 
> This the output, obviously some mistakes(*), how do
> I stop them from
> executing, (take them out)
> 
>   LAST_DATE  NEXT_DATE
>   -- --
> carga_d   29/06/2001 30/06/2001
> mueve_h_f 20/02/2001 01/01/4000*
> carga_d   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl14/03/2001 01/01/4000*
> carga_v_f_s   29/06/2001 06/07/2001
> carga_v_f_m   05/06/2001 05/07/2001
> carga_d   20/03/2001 01/01/4000*
> carga_d   19/03/2001 01/01/4000*
> carga_s   20/03/2001 01/01/4000*
> carga_v   20/03/2001 01/01/4000*
> mueve_h   29/06/2001 30/06/2001
> carga_s   29/06/2001 30/06/2001
> carga_v   29/06/2001 30/06/2001
> carga_h   29/06/2001 30/06/2001
> mueve_h   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl   02/07/2001
> 
> What is the sintax
> to execute the procedures, some every day, some
> every week
> and some two times a week, passing different dates
> automatically as a
> parameter.
> 
> Thanks,
> 
> 
> Ramon Estevez
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ramon Estevez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


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

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

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

Re: ORA

[Jared Still]

The TNS-0510 error is self explanatory:

00510, 0, "Internal limit restriction exceeded"
// *Cause: Too many files or sockets open simultaneously (or some other
// resource has been depleted).
// *Action: For further details, trace the operation for protocol
// details.


There are several entries on MetaLink that deal with this,
you should take a look.

Also, when asking for help, by supplying the following you
may prevent a number of folks from ignoring your message.

OS: name and version
Oracle:  version
Platform:  brand, how much RAM

Jared


On Monday 02 July 2001 06:10, Denham Eva wrote:
> Hi here's more of the error:
>
> 02-JUL-2001 13:57:07 *
> (CONNECT_DATA=(SERVICE_NAME=maxtfmc)(CID=(PROGRAM=C:\Program
> Files\Max411\MAXLOGIN.EXE)(HOST=CENT8000)(USER=HAMILTT))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=165.144.249.68)(PORT=2062)) * establish *
> maxtfmc * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
>  TNS-12540: TNS:internal limit restriction exceeded
>   TNS-12560: TNS:protocol adapter error
>TNS-00510: Internal limit restriction exceeded
> 32-bit Windows Error: 8: Exec format error
> I hope this will help...
>
> -Original Message-
> Sent: Monday, July 02, 2001 2:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> Please help!, I have a number of clients connecting to a Oracle Database:
> Oracle8i Release 8.1.6.0.0 - Production
> PL/SQL Release 8.1.6.0.0 - Production
> CORE 8.1.6.0.0 Production
> TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
> The problem is that the connections are either being dropped, or are
> failing some way.
> The Oracle error experienced is :
> ORA-12500: TNS:listener failed to start a dedicated server process
>
> The platform is Windows 2000.
> The clients are all running the same oracle version, only the client side,
> also on NT/Win 2000.
> Please help. This all worked fine during Development:-)
>
> Regards
> Denham
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

[Mark Leith]

Me too Peter, I posted this not long back, and I know of one other person
interested in this.. But got no replies! PLEASE ANYBODY?

Cheers

Mark

-Original Message-
McLarty
Sent: Monday, July 02, 2001 03:06
To: Multiple recipients of list ORACLE-L


Hi
I was wondering if there is somewhere that I can get a small test database.
I know some of the products have databases to be installed, I have done
some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7
installed I was hoping to find something a little meatier in size to run
some tests with. perhaps something that might build a Meg or more of
tables and data
TIA


Peter McLarty
[EMAIL PROTECTED]
04 0209 4238
L Plate Oracle DBA

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

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

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

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

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

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

Re: "ALTER SYNONYM"?

[Jim Conboy]

Can you use a view 
instead?
 
SVRMGR> create table temp1 (temp1 varchar2(1));Statement 
processed.
SVRMGR> create table temp2 (temp1 varchar2(1));Statement 
processed.
SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.
SVRMGR> create or replace view temp as select * from temp1;Statement 
processed.SVRMGR> select * from temp;T-4 
rows selected.SVRMGR> create or replace view temp as select * from 
temp2;Statement processed.SVRMGR> select * from 
temp;T-bbb3 rows selected.SVRMGR>
Maybe some unwanted overhead with the 
view, but it might help out.
 
Jim
 
>>> [EMAIL PROTECTED] 06/30/01 04:56PM 
>>>Is there a way to do what would be an ALTER SYNONYM?I've 
got a synonym created that rotates between pointing to two 
differenttables.  Sometimes it points to TABLE_A, sometimes to 
TABLE_B.  (This isso that behind the scenes, I can truncate and reload 
TABLE_A, and thenswap, etc. so the table "never 
disappears".)However, when I want to switch the SYNONYM from pointing to 
TABLE_A topointing to TABLE_B, the only way is to:drop synonym 
table_syn;create synonym table_syn for table_b;Is there a way to 
make that instantaneous for the database?  If someonedoes a select at 
the exact instant between those two commands, it'll errorout, because the 
table "won't 
exist".-Rick+--+| 
Rick Osterberg   
[EMAIL PROTECTED]    
|| Database Applications 
Specialist FAS Computer 
Services   
|+--+-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rick 
Osterberg  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: Looking for a test Database

[Jared Still]

One possibility is to get the TPC benchmark and
use it to build the TPC-H, TPC-R or TPC-W benchmark
databases.

The TPC-C specification is no longer on their web
page for some reason.

www.tpc.org

Jared


On Monday 02 July 2001 07:06, Peter McLarty wrote:
> Hi
> I was wondering if there is somewhere that I can get a small test database.
> I know some of the products have databases to be installed, I have done
> some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7
> installed I was hoping to find something a little meatier in size to run
> some tests with. perhaps something that might build a Meg or more of
> tables and data
> TIA
>
>
> Peter McLarty
> [EMAIL PROTECTED]
> 04 0209 4238
> L Plate Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

[Speaks, Chuck W.]

We were running ArcServ to backup everything in our Network Operations
Center.  We had some problems with ArcServ being slow to do things like
restore.  As a result we have gone to Veritas and it seems quite a bit
faster and more reliable.  This is what I hear from our network guys as they
are VERY pleased with Veritas.  Again, I have limited exposure to both, but
the people who used both products on a daily basis around here, favor
Veritas hands down.

Hope this helps

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Monday, July 02, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


Good morning,

Can anyone share an opinion on how the CA's ARCServer compares to Veritas
Backup Exec on Windows platform?

This will support Windows 2000 and Oracle 8.1.7

Thanks in advance,

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

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

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

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

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

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

OT: For the older crowd who may have known him.

[dgoulet]

** alt.rest.in.peace

Jim Ellis, one of the founders of the Usenet system which 
predated and helped shape the Web, died Thursday of non-Hodgkins 
lymphoma at his home in Pennsylvania. He was 45. The newbies 
amongst us might not be familiar with Usenet, a massive 
information-sharing service where files were swapped, friends and 
enemies were made, and just about every topic imaginable was 
discussed. It served as the model for modern message boards and 
for a long time was the coolest thing happening on the Internet. 

In 1979, as a graduate student at Duke University, Ellis helped 
design the system, linking computers at Duke to some at the 
University of North Carolina. Within just a few years, it spread 
worldwide. By 1993, there were 1,200 newsgroups and the system 
reflected an increasingly diverse and chaotic online community. 
Users would post messages and encrypted files in a series of 
newsgroups built into a hierarchy of interests, such as 
rec.collecting.stamps and comp.os.linux. The infamous alt. groups 
were home to the wilder topics, from alt.religion.kibology to 
alt.pave.the.earth.

In time, as with many communities, it got crowded and went into 
decline. By 1999, an estimated 37,000 newsgroups were in 
operation, and legitimate postings had largely been drowned out 
by ads, spam, and flame wars. But the impact of Ellis' creation 
on our modern Internet can't be dismissed. For his contributions, 
Jim Ellis received the Electronic Frontier Foundation's Pioneer 
Award in 1993 and the Usenix Lifetime Achievement Award in 1995. 
An archive of Usenet postings dating back to 1995 is hosted by 
Google at 
http://update.informationweek.com/cgi-bin4/flo?y=eD3u0BdFGA0V20PYk0AR
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Performance on Network Appliance

[Orr, Steve]

REPOST... I should have known better than to post this on a Friday.

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


It seems Oracle Corp has been putting more resources into improving 3rd
party storage solutions, e.g. the OSCP, Oracle Storage Compatibility
Program. (See
http://otn.oracle.com/deploy/availability/htdocs/oscp_papers.html#Oracle_OSC
P) 

Network Appliance has received Oracle's blessing but I'm wondering... 
When properly configured, HOW DOES IT PERFORM? 
Especially when compared to other solutions such as EMC?? 

I reviewed list posts, OTN, and Metalink posts for the last year and I don't
see a unanimous conclusion one way or the other. It seems some DBA's have
had very good performance with large OLTP and DSS databases but others have
not. I'm suspecting there were platform/configuration issues when
performance problems were evident. Someone hinted that NetApp with Linux was
not as solid as NetApp with Solaris. 

I eagerly await any and all feedback regarding your experience with storing
Oracle datafiles on Network Appliance filers. 

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

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

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

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

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

RE: "ALTER SYNONYM"?

[Norwood Bradly A]

Although I have not used their software, I recall that Platinum's Desktop
DBA has a  feature for  'alter synonym". 

-Original Message-
Sent: Sunday, July 01, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L


Rick:

No. There is no "alter synonym" command in SQL (none that I can find or know
of, at least). The way you describe is the only way to do it.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, June 30, 2001 4:56 PM


> Is there a way to do what would be an ALTER SYNONYM?
>
> I've got a synonym created that rotates between pointing to two different
> tables.  Sometimes it points to TABLE_A, sometimes to TABLE_B.  (This is
> so that behind the scenes, I can truncate and reload TABLE_A, and then
> swap, etc. so the table "never disappears".)
>
> However, when I want to switch the SYNONYM from pointing to TABLE_A to
> pointing to TABLE_B, the only way is to:
>
> drop synonym table_syn;
> create synonym table_syn for table_b;
>
> Is there a way to make that instantaneous for the database?  If someone
> does a select at the exact instant between those two commands, it'll error
> out, because the table "won't exist".
>
> -Rick
>
>
+--+
> | Rick Osterberg   [EMAIL PROTECTED]
|
> | Database Applications Specialist FAS Computer Services
|
>
+--+
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rick Osterberg
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

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

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

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

RE: Calculating The Median: Error Discovered in Oracle SQL 101 Code

[Larry Elkins]

Ian,

Nice stuff!

Since this subject was brought back up, I thought maybe some would be
interested in the following. I've never had a need to calculate a median,
but, I knew Celko's SQL for Smarties had a few variations and examples from
various people, each with caveats. And then there were differences between
what he termed statistical and financial mean, and some other things as
well. Anyway, a google search turned up another Celko solution. And this one
also brings up the concept of weighted median.

Here is his example,
http://www.intelligententerprise.com/db_area/archives/1999/992004/celko.shtm
l, modified by me to use the  standard EMP table's SAL column:

SQL> SELECT AVG(DISTINCT x.sal)
  2FROM (SELECT F1.sal
  3FROM emp F1, emp F2
  4   GROUP BY F1.empno, F1.sal
  5  HAVING SUM(CASE WHEN F2.sal = F1.sal
  6   THEN 1 ELSE 0 END)
  7  >= ABS(SUM(CASE WHEN F2.sal < F1.sal THEN 1
  8  WHEN F2.sal > F1.sal THEN -1
  9   ELSE 0 END)))
 10  X
 11  /

AVG(DISTINCTX.SAL)
--
  1550

The link above goes into some detail regarding the logic behind the query
and how his query finally reached the form above. I may never need to do a
median, but, this subject has been a good opportunity for learning. I've
tested the above with even, odd, multiple occurences of SAL, null,s etc. It
seems to work, but, everyone have a whack at it if you like.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MacGregor,
> Ian A.
> Sent: Saturday, June 30, 2001 9:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Calculating The Median: Error Discovered in Oracle SQL 101 Code
>
>
> I ran the code from Oracle SQL 101 which Jared posted modifying
> it to find the median of the sal  column on that table
>
> SQL> select
>   2   rownum,
>   3   sal
>   4  from (
>   5   select sal
>   6   from scott.emp
>   7   where sal is not null
>   8   union
>   9   select 1 from dual where 1=2
>  10  )
>  11  group by sal, rownum
>  12  having rownum >= (
>  13   select decode( mod(total_freq,2),
>  141,trunc(total_freq/2 + 1),
>  150,trunc(total_freq/2)
>  16   )
>  17   from (
>  18select count(*) total_freq
>  19from scott.emp
>  20where sal is not null
>  21   )
>  22  )
>  23  and rownum <= (
>  24   select decode( mod(total_freq,2),
>  251,trunc(total_freq/2 + 1),
>  260,trunc(total_freq/2 + 1)
>  27   )
>  28   from (
>  29select count(*) total_freq
>  30from scott.emp
>  31where sal is not null
>  32   )
>  33  )
>  34  /
>
>values
>  averaged
> ROWNUM  in median
> -- --
>  7   1600
>  8   2450
>--
> Median   2025
>
> --
> 
> This answer is different from the result of the code I posted
> which uses the new analytical functions.
>
>  select
>  case
>  when mod(number_salaried,2) = 0 then
> (select sum(sal)/2 from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> where salrank  = number_salaried/2
> or salrank = number_salaried/2 +1)
>  else
> (select sal from(select sal, row_number()
> over ( order by sal) as salrank
> from scott.emp)
> where salrank = ceil(number_salaried/2))
>  end median
>  from (select sal,rank() over (order by sal) as rk from scott.emp),
>  (select count(sal) number_salaried from scott.emp)
>  where rk = 1
> /
>
>MEDIAN
> -
>  1550
> --
> --
> Emp is a 14 row table .   The median should be the average of the
> seventh and eighth values.
> I cleared the computes and columns and ran the first part of the
> SQL 101 code
>
>  clear computes
> utes cleared
>  select
>   rownum,
>   sal
>  from (
>   select sal
>   from scott.emp
>   where sal is not null
>   union
>   select 1 from dual where 1=2
>  )
>  group by sal, rownum
>  /
>
> ROWNUMSAL
> -- --
>  1800
>  2950
>  3   1100
>  4   1250
>  5   1300
>  6   1500
>  7   1600
>  8   2450
>  9   2850
> 10   2975
> 11   3000
>
> ROWNUMSAL
> -- --
> 12   5000
>
> and also ran the part of my code which corresponded.  I changed
> my code slightly so the salrank column would print.
>
> SQL> select salrank, sal from(select sal, row_number()
>   2  over ( order by sal) as salrank
>   3  from scott.emp)
>   4  /
>
>SALRANKSAL
> -- --
>  1800
>  2950
>  3   1100
>  4 

CA ARCserver Vs. Veritas Backup Exec?

[Gary Weber]

Good morning,

Can anyone share an opinion on how the CA's ARCServer compares to Veritas
Backup Exec on Windows platform?

This will support Windows 2000 and Oracle 8.1.7

Thanks in advance,

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

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

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

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

[Jack C. Applewhite]

Justin,

We store over 8 million CLOB documents in our 8.1.6 DB under Win2k.  All are
indexed using interMedia Text.  I haven't done a direct comparison of BFile
storage with that many documents, so I can't comment on all the pros and
cons.  However, CLOBs perform well for us with the only con I can think of
being the much larger amount of redo and rollback generated for inserts and
deletes vs what I imagine would be almost none for external BFiles.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Coleman
Sent: Monday, July 02, 2001 5:51 AM
To: Multiple recipients of list ORACLE-L


Dear All,

I am presently debating about if I wish to store 2 million rich multimedia
data files as LOB's in the database or as Bfile references in the Database.
I think I should use LOB's?

Do must people use Bfile references or LOB's?  What are the disadvantages of
LOB's?

Cheers,
Justin


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

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

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

[james ellis]

You can also increase your SORT_AREA_SIZE parameter in
the initDBNAME.ora. This will allow more of your
sorting to be done in memory rather on disk. This will
also help speed up the process.

--- Raghu Kota <[EMAIL PROTECTED]> wrote:
> Hi Friends
> 
> Iam rebuilding my 6Gb index, But Iam getting problem
> with TEMP tablespace. 
> What is solution for this??
> 
> iam using alter index index_name rebuild
> tablespace_name;
> 
> ORA-1652: unable to extend temp segment by 128 in
> tablespaceTEMP
> 
> Any Ideas??
> 
> Thanks
> Raghu.
>
_
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Raghu Kota
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

[Ramon Estevez]

Thanks to all that reply,

I want to clean the queue, erase to the jobs, and reschedule them again

Ramon Estevez 



*809-565-3121 x 225

 

* [EMAIL PROTECTED]

 



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de A. Bardeen
Enviado el: Monday, 02 July, 2001 3:50 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBMS_JOB


Ramon,

When a job is broken the next_date is set to
01/01/4000.

I'm not sure I understand exactly what your initial
request was, but you can alter the next_date and
interval for any job using DBMS_JOB.CHANGE (or by
calling DBMS_JOB.NEXT_DATE and DBMS_JOB.INTERVAL
individually).

For examples of specifying different intervals, see
Note: 1068369.6 "Example:  Using DBMS_JOB.SUBMIT to
Execute Jobs at Regular Intervals"

HTH,

-- Anita

--- Raymond Lee Meng Hong <[EMAIL PROTECTED]>
wrote:
> If order to stop those funny date , can you show me
> the code of your pl/sql
> and let us try to solve it ? Becoz it seen you try
> to add in those error
> date into your next_date ?
> 
> You might need to create a lookup table to key in
> those require date,and let
> it parse to the procedure automatical..
> 
> 
> 
> -Original Message-
> Sent: Saturday, June 30, 2001 6:41 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thanks Ray and Dick,
> 
> This the output, obviously some mistakes(*), how do
> I stop them from
> executing, (take them out)
> 
>   LAST_DATE  NEXT_DATE
>   -- --
> carga_d   29/06/2001 30/06/2001
> mueve_h_f 20/02/2001 01/01/4000*
> carga_d   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl14/03/2001 01/01/4000*
> carga_v_f_s   29/06/2001 06/07/2001
> carga_v_f_m   05/06/2001 05/07/2001
> carga_d   20/03/2001 01/01/4000*
> carga_d   19/03/2001 01/01/4000*
> carga_s   20/03/2001 01/01/4000*
> carga_v   20/03/2001 01/01/4000*
> mueve_h   29/06/2001 30/06/2001
> carga_s   29/06/2001 30/06/2001
> carga_v   29/06/2001 30/06/2001
> carga_h   29/06/2001 30/06/2001
> mueve_h   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl   02/07/2001
> 
> What is the sintax
> to execute the procedures, some every day, some
> every week
> and some two times a week, passing different dates
> automatically as a
> parameter.
> 
> Thanks,
> 
> 
> Ramon Estevez
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ramon Estevez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


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

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

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

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

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

Looking for a test Database

[Peter McLarty]

Hi
I was wondering if there is somewhere that I can get a small test database.
I know some of the products have databases to be installed, I have done
some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7
installed I was hoping to find something a little meatier in size to run
some tests with. perhaps something that might build a Meg or more of
tables and data
TIA


Peter McLarty
[EMAIL PROTECTED]
04 0209 4238
L Plate Oracle DBA

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

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

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

How many lists are there in the buffer cache?

[Pablo ksksksk]

Hi list,

I'd like to know how many lists are there in version
8.1.7 in the buffer cache that control buffer's aging.
And how does server processes and DBW0 interact with
them.

TIA

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

OT: starting the NT/UNIX holy war on a mon morning: Re: ORA

[JOE TESTA]

Its NT what more do you expect.
 
Have you looked up the error?
 
required oracle comment:
  no need(according to oracle) for rollback segments in 
9i :)
 
joe
 
>>> [EMAIL PROTECTED] 07/02/01 08:25AM 
>>>Hi,Please help!, I have a number of clients connecting 
to a Oracle Database:Oracle8i Release 8.1.6.0.0 - Production PL/SQL 
Release 8.1.6.0.0 - Production CORE 8.1.6.0.0 Production TNS for 32-bit 
Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - 
ProductionThe problem is that the connections are either being dropped, or 
are failingsome way.The Oracle error experienced is :ORA-12500: 
TNS:listener failed to start a dedicated server processThe platform is 
Windows 2000.The clients are all running the same oracle version, only the 
client side,also on NT/Win 2000.Please help. This all worked fine during 
Development:-)RegardsDenham-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Denham Eva  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Simple SQL Query Question

[ALEMU Abiy]

Your 
query also seems working, not a novice's solution :--)
Thank 
you

  -Message d'origine-De : novicedba 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
  14:05À : Multiple recipients of list 
  ORACLE-LObjet : Re: Simple SQL Query 
  Question
  select decode(emm_freq,0,1,emm_freq) * 
  decode(rec_freq,0,1,rec_freq) valuefrom (select count(emission_freq) 
  emm_freq,count(reception_freq) rec_freq from test where 
  station='STAT2')
   
     
  VALUE   3
   
  I am selecting from a view which as you see has 
  the counts of both the columns
  I am using decode to replace '0' with '1' , 
  without this step the answer would be improper
  for example 
  for stat2 the inner view will fetch values 3 and 
  0 when multiplied will give 0
  to overcome this I replace 0 with 1
   
  Hope this serves the purpose
   
   
  cozI am anoviceOracle Certifiable DBBS
  
- Original Message - 
From: 
ALEMU Abiy 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, July 02, 2001 3:30 
PM
Subject: RE: Simple SQL Query 
Question

For example for a table like this 
one,
 
STATION    
EMISSION_FREQ   
RECEPTION_FREQ-- 
-    
--   STAT1  
192.5  
193.5 STAT2  
192.5   STAT2  194   
STAT1  
193.5  
194.5  
STAT2  195   

 
 
I 
would like to have a value for STAT1 which is equal to 2*2=4  and for 
STAT2 equal to 3*1=3

  -Message d'origine-De : novicedba 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 
  2001 11:15À : Multiple recipients of list 
  ORACLE-LObjet : Re: Simple SQL Query 
  Question
  SELECT 
  STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) 
  VALUEFROM TEST;
   
  STATION    
  EMISSION_FREQ   RECEPTION_FREQ 
  VALUE-- 
  -    
  --    
  -STAT1  
  192.5  
  193.5  
  385STAT2  
  192.5    
  192.5STAT2  194   
  194STAT2  
  193.5  
  194.5  
  387STAT2  195   
  195
   
  I did not understand what you meant by 'And I would like to select the 
  number of frequencies, sort of count(*), for a given station and multiply 
  that value by 2 '
  so what I 
  have done is 
  if 
  
      the reception_freq is null 
  (that would mean there is only emission_freq )
  then 
  
      value=emission_freq*1
  else
      
  value=emission_freq*1
  end 
  if
   
  Hope this is 
  what you wanted
   
  cozI am anoviceOracle Certifiable DBBS
  
- Original Message - 
From: 
ALEMU Abiy 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, July 02, 2001 1:00 
PM
Subject: Simple SQL Query 
Question

I've a 
table with the following structure and sample data :
 
Station    
Emission_Freq    
Reception_Freq
    
-    
--
STAT1    
192.5    
193.5
STAT2    
193    
STAT2    
194
STAT2    
193.5    
194.5
STAT2    
195
 
 
And I would 
like to select the number of frequencies, sort of count(*), for a given 
station and multiply that value by 2 if the station has Emission 
frequency and reception frequency and multiply by one if the station has 
only the emission frequency or only the reception frequency.  I 
don't know how to use a condition in SQL.  I'm sure that it's 
possible to do it but I don't know how.  Can anybody help me 
?

@biy @lemu
[EMAIL PROTECTED]
Database Administration 
Engineer

France
 

RE: Simple SQL Query Question

[ALEMU Abiy]

Thank you Harsh, your query seems working

-Message d'origine-
De : Harsh Agrawal [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 2 juillet 2001 14:05
À : Multiple recipients of list ORACLE-L
Objet : RE: Simple SQL Query Question


Hi ALEMU Abiy,
 
Try out this :
 
select count(*)*2 FREQC
from sample1
where station='&ST'
  and emission_freq is not null
  and reception_freq is not null
having count(*) > 0
union
select count(*)*1 FREQC
from sample1
where station='&ST'
  and ( emission_freq is not null
and reception_freq is null)
  or  ( emission_freq is null
and reception_freq is not null)
having count(*) > 0
/

Result:
 
When ST=STAT1 Result = 4
When ST=STAT2 Result = 3
 
As reqrd by u.
 
Hope this will help u.
 
Bye
- Harsh 
 
 -Original Message-
Sent: Monday, July 02, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L



Well, then decode would be the only option, as suggested by other members.
Case is not supported.
 
rgds
amar

-Original Message-
Sent: Monday, July 02, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L


I'm using Oracle 7.3.4, so is it possible to use CASE statements ?

-Message d'origine-
De : Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 2 juillet 2001 10:57
À : Multiple recipients of list ORACLE-L
Objet : RE: Simple SQL Query Question


select count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq,
0) != 0) 
 then 1 else null end)) * 2 + 
   count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq,
0) != 0) 
 then null else 1 end)) * 1 as "total"
from am39
where station = '';
 
rgds
amar

-Original Message-
Sent: Monday, July 02, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


I've a table with the following structure and sample data :
 
StationEmission_FreqReception_Freq
---
STAT1192.5193.5
STAT2193
STAT2194
STAT2193.5194.5
STAT2195
 
 
And I would like to select the number of frequencies, sort of count(*), for
a given station and multiply that value by 2 if the station has Emission
frequency and reception frequency and multiply by one if the station has
only the emission frequency or only the reception frequency.  I don't know
how to use a condition in SQL.  I'm sure that it's possible to do it but I
don't know how.  Can anybody help me ?


@biy @lemu
[EMAIL PROTECTED]  
Database Administration Engineer
 Groupe CRIL TECHNOLOGY  
France
 

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

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

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

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

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

[A. Bardeen]

Ray,

Advanced replication definitely does NOT require using
replication manager.  Being an anti-gui person, I use
the repapi calls almost exclusively.  Starting with
8.1.6 replication manager is java-based and therefore
you should be able to run it from any java-capable
client, although I personally have not tried it from
anything other than a windows client.  (Yes, I know it
was java-based in 8.1.5, but it was considered a beta
product until 8.1.6).

Once you're comfortable setting up replication,
setting it up via scripts can be just as quick or
quicker than using replication manager.  Since
replication manager incorporates some additional views
behind the scenes for displaying info from the rep
views I prefer to query the views directly.

The biggest problems I've found with using replication
manager are:
  *  if you don't know what you're doing it's too easy
to click on the wrong buttons and make matters worse.

  *  logging onto replication manager as a user other
than the registered propagator causes all sorts of
problems if you then attempt to perform rep
operations.  While it's possible to do the same thing
from command line, I find one is less likely to log on
as the wrong user.

  *  if replication manager hangs, the user just kills
the replication manager session and starts a new one
(depending on the stupidity of the user this can be an
endless loop!) so you end up with locks being held by
the original session and everything else backs up
waiting on those locks to be released.

HTH,

-- Anita

--- Ray Stell <[EMAIL PROTECTED]> wrote:
> 
> I was beginning to think advanced replication looked
> like
> a reasonable solution for an applicaiton.  Then I
> read:
> 
> Replication environments supporting both multimaster
> and snapshot
> replication can be challenging to configure and
> manage. To help
> administer these replication environments, Oracle
> provides a
> sophisticated management tool called Oracle
> Replication Manager.
> 
> Coupled with the absence of a config guide, am I to
> guess 
> that Oracle is underpining it's advanced technology
> with a 
> toy OS?  This would be ironic, pathetic, and
> unacceptable.  
> Please tell me I've missed the real config guide. 
>
===
> Ray Stell   [EMAIL PROTECTED] (540) 231-4109
> KE4TJC28^D
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ray Stell
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

Re: Snapshot package.

[A. Bardeen]

Jaimin,

For read-only snapshots, there is no need to run any
additional scripts as dbmssnap.sql is called by
catproc.  I suspect that running the script
invalidated some objects that you didn't recompile
prior to trying to refresh the snapshot.

Either you still have invalid objects, in which case
you need to resolve them, or calling
dbms_snapshot.refresh recompiled them, in which case
calling it again should work.

HTH,

-- Anita

--- jaimin <[EMAIL PROTECTED]> wrote:
> 
> Hello gurus,
>   I am testing dbms_snapshot package on my test
> server. I run
> "dbmssnapshot.sql" script which is in "rdbms"
> directory. The script gives no
> error.
> I have snapshot  called 'TEST_SNAP'.
> 
> 
> When I execute procedure it gives me following
> error.
> 
> SQL> exec dbms_snapshot.refresh ('test_snap','?');
> begin dbms_snapshot.refresh ('ja','?'); end;
> 
> *
> ERROR at line 1:
> ORA-04068: existing state of packages has been
> discarded
> ORA-04063: package body "SYS.DBMS_SNAPSHOT" has
> errors
> ORA-06508: PL/SQL: could not find program unit being
> called
> ORA-06512: at line 1
> 
> Can any one help me on this?
> 
> 
> Regards,
> Jaimin.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: jaimin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

Re: ORA

[A. Bardeen]

Denham,

Most likely you're hitting the 3GB process limit (or
2GB if you haven't enabled the process to grow past
2GB).  See Note: 46001.1 "Oracle Database and the
Windows NT memory architecture, Technical Bulletin"
for more details.  Check the memory used by the
oracle.exe process in task manager.

If you're already hitting the 3GB limit, then you
should consider using MTS connections instead of
dedicated server connections.  Also make sure that
sort_area_size and sort_area_retained_size are not set
too high.

HTH,

-- Anita

--- Denham Eva <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> Please help!, I have a number of clients connecting
> to a Oracle Database:
> Oracle8i Release 8.1.6.0.0 - Production 
> PL/SQL Release 8.1.6.0.0 - Production 
> CORE 8.1.6.0.0 Production 
> TNS for 32-bit Windows: Version 8.1.6.0.0 -
> Production 
> NLSRTL Version 3.4.1.0.0 - Production
> The problem is that the connections are either being
> dropped, or are failing
> some way.
> The Oracle error experienced is :
> ORA-12500: TNS:listener failed to start a dedicated
> server process
> 
> The platform is Windows 2000.
> The clients are all running the same oracle version,
> only the client side,
> also on NT/Win 2000.
> Please help. This all worked fine during
> Development:-)
> 
> Regards
> Denham


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

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

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

RE: ORA

[Denham Eva]

Hi here's more of the error:

02-JUL-2001 13:57:07 *
(CONNECT_DATA=(SERVICE_NAME=maxtfmc)(CID=(PROGRAM=C:\Program
Files\Max411\MAXLOGIN.EXE)(HOST=CENT8000)(USER=HAMILTT))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=165.144.249.68)(PORT=2062)) * establish *
maxtfmc * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12540: TNS:internal limit restriction exceeded
  TNS-12560: TNS:protocol adapter error
   TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
I hope this will help...

-Original Message-
Sent: Monday, July 02, 2001 2:25 PM
To: Multiple recipients of list ORACLE-L


Hi,

Please help!, I have a number of clients connecting to a Oracle Database:
Oracle8i Release 8.1.6.0.0 - Production 
PL/SQL Release 8.1.6.0.0 - Production 
CORE 8.1.6.0.0 Production 
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production 
NLSRTL Version 3.4.1.0.0 - Production
The problem is that the connections are either being dropped, or are failing
some way.
The Oracle error experienced is :
ORA-12500: TNS:listener failed to start a dedicated server process

The platform is Windows 2000.
The clients are all running the same oracle version, only the client side,
also on NT/Win 2000.
Please help. This all worked fine during Development:-)

Regards
Denham

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

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

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

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

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

ORA

[Denham Eva]

Hi,

Please help!, I have a number of clients connecting to a Oracle Database:
Oracle8i Release 8.1.6.0.0 - Production 
PL/SQL Release 8.1.6.0.0 - Production 
CORE 8.1.6.0.0 Production 
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production 
NLSRTL Version 3.4.1.0.0 - Production
The problem is that the connections are either being dropped, or are failing
some way.
The Oracle error experienced is :
ORA-12500: TNS:listener failed to start a dedicated server process

The platform is Windows 2000.
The clients are all running the same oracle version, only the client side,
also on NT/Win 2000.
Please help. This all worked fine during Development:-)

Regards
Denham

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

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

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

[novicedba]

select decode(emm_freq,0,1,emm_freq) * 
decode(rec_freq,0,1,rec_freq) valuefrom (select count(emission_freq) 
emm_freq,count(reception_freq) rec_freq from test where 
station='STAT2')
 
   
VALUE   3
 
I am selecting from a view which as you see has the 
counts of both the columns
I am using decode to replace '0' with '1' , 
without this step the answer would be improper
for example 
for stat2 the inner view will fetch values 3 and 0 
when multiplied will give 0
to overcome this I replace 0 with 1
 
Hope this serves the purpose
 
 
cozI am anoviceOracle Certifiable DBBS

  - Original Message - 
  From: 
  ALEMU Abiy 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, July 02, 2001 3:30 PM
  Subject: RE: Simple SQL Query 
  Question
  
  For 
  example for a table like this one,
   
  STATION    
  EMISSION_FREQ   
  RECEPTION_FREQ-- 
  -    
  --   STAT1  
  192.5  
  193.5 STAT2  
  192.5   STAT2  194   
  STAT1  
  193.5  
  194.5  
  STAT2  195   
  
   
   
  I 
  would like to have a value for STAT1 which is equal to 2*2=4  and for 
  STAT2 equal to 3*1=3
  
-Message d'origine-De : novicedba 
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
11:15À : Multiple recipients of list 
ORACLE-LObjet : Re: Simple SQL Query 
Question
SELECT 
STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) 
VALUEFROM TEST;
 
STATION    
EMISSION_FREQ   RECEPTION_FREQ 
VALUE-- 
-    
--    
-STAT1  
192.5  
193.5  
385STAT2  
192.5    
192.5STAT2  194   
194STAT2  
193.5  
194.5  
387STAT2  195   
195
 
I did not understand what you meant by 'And I would like to select the 
number of frequencies, sort of count(*), for a given station and multiply 
that value by 2 '
so what I have 
done is 
if 

    the reception_freq is null (that 
would mean there is only emission_freq )
then 

    value=emission_freq*1
else
    
value=emission_freq*1
end 
if
 
Hope this is 
what you wanted
 
cozI am anoviceOracle Certifiable DBBS

  - Original Message - 
  From: 
  ALEMU Abiy 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, July 02, 2001 1:00 
  PM
  Subject: Simple SQL Query 
  Question
  
  I've a table 
  with the following structure and sample data :
   
  Station    
  Emission_Freq    
  Reception_Freq
      
  -    
  --
  STAT1    
  192.5    
  193.5
  STAT2    
  193    
  STAT2    
  194
  STAT2    
  193.5    
  194.5
  STAT2    
  195
   
   
  And I would 
  like to select the number of frequencies, sort of count(*), for a given 
  station and multiply that value by 2 if the station has Emission frequency 
  and reception frequency and multiply by one if the station has only the 
  emission frequency or only the reception frequency.  I don't know how 
  to use a condition in SQL.  I'm sure that it's possible to do it but 
  I don't know how.  Can anybody help me ?
  
  @biy @lemu
  [EMAIL PROTECTED]
  Database Administration 
  Engineer
  
  France
   

SYSSTAT statistics

[Dave Leach]

DBA's,

Can anyone shed some light on the following query.

I have performed a single column update on 1 row (update basic set col1  =
9998 where col1 = 9).  The following stats were displayed prior
to the update:

consistent gets 15291
db block changes 199
db block gets 1120

After the update the stats were as follows:

consistent gets 15350
db block changes 209
db block gets 1136

My question is what is it that causes the 'consistent gets' figure to
increase, I was under the impression that all blocks would be acquired in
current mode.

Many thanks for any replies.

Dave Leach




**
The above information is confidential to the addressee and may be 
privileged.  Unauthorised access and use is prohibited.

Internet communications are not secure and therefore this Company does
not accept legal responsibility for the contents of this message.

If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on
it, is prohibited and may be unlawful.

Claybrook Computing Limited is a subsidiary of 
Claybrook Computing (Holdings) Limited
Registered Office: Abbey House. 282 Farnborough Road, Farnborough,
Hampshire GU14 7NJ
Registered in England and Wales No 1287205

A Hogg Robinson plc company
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Leach
  INET: [EMAIL PROTECTED]

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

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

[ALEMU Abiy]

Okay 
but how do you use DECODE with the count(*) ?   For example the query 
below doesn't work
 
SELECT 
decode(reception_freq, null, 1, 2)*count(*) from 
my_table
where 
station = 'STAT1' ;

  -Message d'origine-De : Amar Kumar Padhi 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
  13:20À : Multiple recipients of list 
  ORACLE-LObjet : RE: Simple SQL Query 
  Question
  Well, then decode would be the only option, as suggested by other 
  members. Case is not supported.
   
  rgds
  amar
  
-Original Message-From: ALEMU Abiy 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
2:00 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Simple SQL Query 
Question
I'm using Oracle 7.3.4, so is it possible to use 
CASE statements ?

  -Message d'origine-De : Amar Kumar Padhi 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
  10:57À : Multiple recipients of list 
  ORACLE-LObjet : RE: Simple SQL Query 
  Question
  select 
  count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 
  0) 
   
  then 1 else null end)) * 2 +    
  count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 
  0) 
   
  then null else 1 end)) * 1 as "total"from 
  am39
  where station = '';
   
  rgds
  amar
  
-Original Message-From: ALEMU Abiy 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 
2001 11:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: Simple SQL Query 
Question
I've a 
table with the following structure and sample data :
 
Station    
Emission_Freq    
Reception_Freq
    
-    
--
STAT1    
192.5    
193.5
STAT2    
193    
STAT2    
194
STAT2    
193.5    
194.5
STAT2    
195
 
 
And I would 
like to select the number of frequencies, sort of count(*), for a given 
station and multiply that value by 2 if the station has Emission 
frequency and reception frequency and multiply by one if the station has 
only the emission frequency or only the reception frequency.  I 
don't know how to use a condition in SQL.  I'm sure that it's 
possible to do it but I don't know how.  Can anybody help me 
?

@biy @lemu
[EMAIL PROTECTED]
Database Administration 
Engineer

France
 

RE: Simple SQL Query Question

[Harsh Agrawal]

Hi ALEMU Abiy,
 
Try out this :
 
select count(*)*2 FREQC
from sample1
where station='&ST'
  and emission_freq is not null
  and reception_freq is not null
having count(*) > 0
union
select count(*)*1 FREQC
from sample1
where station='&ST'
  and ( emission_freq is not null
and reception_freq is null)
  or  ( emission_freq is null
and reception_freq is not null)
having count(*) > 0
/

Result:
 
When ST=STAT1 Result = 4
When ST=STAT2 Result = 3
 
As reqrd by u.
 
Hope this will help u.
 
Bye
- Harsh 
 
 -Original Message-
Sent: Monday, July 02, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L



Well, then decode would be the only option, as suggested by other members.
Case is not supported.
 
rgds
amar

-Original Message-
Sent: Monday, July 02, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L


I'm using Oracle 7.3.4, so is it possible to use CASE statements ?

-Message d'origine-
De : Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 2 juillet 2001 10:57
À : Multiple recipients of list ORACLE-L
Objet : RE: Simple SQL Query Question


select count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq,
0) != 0) 
 then 1 else null end)) * 2 + 
   count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq,
0) != 0) 
 then null else 1 end)) * 1 as "total"
from am39
where station = '';
 
rgds
amar

-Original Message-
Sent: Monday, July 02, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


I've a table with the following structure and sample data :
 
StationEmission_FreqReception_Freq
---
STAT1192.5193.5
STAT2193
STAT2194
STAT2193.5194.5
STAT2195
 
 
And I would like to select the number of frequencies, sort of count(*), for
a given station and multiply that value by 2 if the station has Emission
frequency and reception frequency and multiply by one if the station has
only the emission frequency or only the reception frequency.  I don't know
how to use a condition in SQL.  I'm sure that it's possible to do it but I
don't know how.  Can anybody help me ?


@biy @lemu
[EMAIL PROTECTED]  
Database Administration Engineer
 Groupe CRIL TECHNOLOGY  
France
 

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

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

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

[Mark Leith]

The only issue I know of - is that Oracle won't let you do it:)

HTH

Mark

-Original Message-
Coleman
Sent: Monday, July 02, 2001 11:45
To: Multiple recipients of list ORACLE-L


Dear All,

A quick question.

Is there any issues with setting up the System Tablespace as a Local Managed
Tablespace?  Do everyone now do this, or people still set-up as a Dictionary
Managed Tablespace?

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

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

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

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

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

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

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

Re: LMT for system tablespace

[Stephane Faroult]

Rachel Carmichael wrote:
> 
> Justin,
> 
> You can't make the SYSTEM tablespace a locally managed tablespace. Oracle
> won't allow it. Not even in 9i. :)  And they do set up the other tablespaces
> as LMTs in the demo install.
> 
> Rachel

Their 'there are rules for you and rules for us' has always left me feel
uncomfortable. On the other hand, when you consider the mess that the
dictionary has grown into, you understand their cautiousness ...
--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Re: LOb's vs Bfiles

[Stephane Faroult]

Justin Coleman wrote:
> 
> Dear All,
> 
> I am presently debating about if I wish to store 2 million rich multimedia
> data files as LOB's in the database or as Bfile references in the Database.
> I think I should use LOB's?
> 
> Do must people use Bfile references or LOB's?  What are the disadvantages of
> LOB's?
> 
> Cheers,
> Justin
>

IMHO I'd favour BFILES over LOBs if you have the choice. In fact it
depends on volumes, and what you want to do on your data. If you want to
apply functions (when searching) to it, quite obviously you have to
store everything inside the database; same if you need to replicate. On
the other hand, I have not experienced a lot with LOBs yet, so consider
the following more as a list of questions than answers, but consider
everything which revolves around the data (rollback segments, redo logs)
and wonder how it will behave with LOBs.
 As far as when you are storing a lot of data you have to work closely
with the SA, I think that BFILEs are something s/he will understand
better than the Oracle black box. It also matters. 

--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

RE: Simple SQL Query Question

[Amar Kumar Padhi]

Well, then decode would be the only option, as suggested by other 
members. Case is not supported.
 
rgds
amar

  -Original Message-From: ALEMU Abiy 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
  2:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Simple SQL Query Question
  I'm 
  using Oracle 7.3.4, so is it possible to use CASE statements 
  ?
  
-Message d'origine-De : Amar Kumar Padhi 
[mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
10:57À : Multiple recipients of list 
ORACLE-LObjet : RE: Simple SQL Query 
Question
select count((case 
when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) 
 
then 1 else null end)) * 2 +    
count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 
0) 
 
then null else 1 end)) * 1 as "total"from 
am39
where station = '';
 
rgds
amar

  -Original Message-From: ALEMU Abiy 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 
  2001 11:30 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Simple SQL Query Question
  I've a table 
  with the following structure and sample data :
   
  Station    
  Emission_Freq    
  Reception_Freq
      
  -    
  --
  STAT1    
  192.5    
  193.5
  STAT2    
  193    
  STAT2    
  194
  STAT2    
  193.5    
  194.5
  STAT2    
  195
   
   
  And I would 
  like to select the number of frequencies, sort of count(*), for a given 
  station and multiply that value by 2 if the station has Emission frequency 
  and reception frequency and multiply by one if the station has only the 
  emission frequency or only the reception frequency.  I don't know how 
  to use a condition in SQL.  I'm sure that it's possible to do it but 
  I don't know how.  Can anybody help me ?
  
  @biy @lemu
  [EMAIL PROTECTED]
  Database Administration 
  Engineer
  
  France
   

Re: LMT for system tablespace

[Rachel Carmichael]

Justin,

You can't make the SYSTEM tablespace a locally managed tablespace. Oracle 
won't allow it. Not even in 9i. :)  And they do set up the other tablespaces 
as LMTs in the demo install.

Rachel


>From: "Justin Coleman" Reply-To: [EMAIL PROTECTED] To: Multiple 
>recipients of list ORACLE-L Subject: LMT for system tablespace Date: Mon, 
>02 Jul 2001 02:45:27 -0800
>
>Dear All,
>
>A quick question.
>
>Is there any issues with setting up the System Tablespace as a Local 
>Managed Tablespace? Do everyone now do this, or people still set-up as a 
>Dictionary Managed Tablespace?
>
>Cheers, Justin 
>_ 
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com --
>Author: Justin Coleman INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, 
>California -- Public Internet access / Mailing Lists 
> To 
>REMOVE yourself from this mailing list, send an E-Mail message to: 
>[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
>BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing 
>list you want to be removed from). You may also send the HELP command for 
>other information (like subscribing).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

LOb's vs Bfiles

[Justin Coleman]

Dear All,

I am presently debating about if I wish to store 2 million rich multimedia 
data files as LOB's in the database or as Bfile references in the Database.  
I think I should use LOB's?

Do must people use Bfile references or LOB's?  What are the disadvantages of 
LOB's?

Cheers,
Justin




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

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

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

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

LMT for system tablespace

[Justin Coleman]

Dear All,

A quick question.

Is there any issues with setting up the System Tablespace as a Local Managed 
Tablespace?  Do everyone now do this, or people still set-up as a Dictionary 
Managed Tablespace?

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

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

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

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

No Subject

[Deewaker G.V.]

Title: 





Hi


Can any one tell me What is the Expansion of ORACLE... I have never ever come across it.


with warm regards,


Deewaker G. V.


Baazee.com India Pvt. Ltd.
Ph: 4611323 Extn: 216
Fax: 4611324


 <> 



 Deewaker G.V..vcf

RE: Re: Sizing Raw Vols and Oracle Datafiles

[Mark Leith]

I did!! Only a couple of times though - but throughout the list! Deja-vu!!

-Original Message-
Sent: Sunday, July 01, 2001 12:41
To: Multiple recipients of list ORACLE-L


Hmmm, it is just me or did everyone get the same message multiple times
(like ten or more)?

>>> [EMAIL PROTECTED] 06/29/01 05:02PM >>>
Folks,

Have a question regarding sizing raw volumes and
Oracle datafiles.  I'm using Veritas 3.1, Solaris 2.6
and Oracle 8i (R2)

This is what I did.  Using Volume Manager, I resized a
raw volume from 1GB to 2GB (the raw volume belonged to
an Oracle datafile).  I then went into Oracle and did
a alter database datafile 'temp.dbf' resize 1999M.  I
did this after making sure that the raw volume had
enough room to grow and that it would not overwrite
any other volumes.

When discussing this with an SA, he said that he has
never done this or has been asked to do this either in
an Oracle shop or Sybase shop.  He's been told by
other DBAs' that this should never be done and it is
best to add new volumes and then do 'alter tablespace
add datafile ...'.  I was unable to get an answer as
to why this is bad and should'nt be done.

So, my question is, is this a myth; can it done and if
not, what is the reason for not doing this?

Any opinions or facts?

Thanks

mkb


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

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

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

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

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

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

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

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

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

RE: Simple SQL Query Question

[ALEMU Abiy]

For 
example for a table like this one,
 
STATION    EMISSION_FREQ   
RECEPTION_FREQ-- 
-    
--   STAT1  
192.5  
193.5 STAT2  
192.5   STAT2  194   
STAT1  
193.5  
194.5  
STAT2  195   

 
 
I 
would like to have a value for STAT1 which is equal to 2*2=4  and for STAT2 
equal to 3*1=3

  -Message d'origine-De : novicedba 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
  11:15À : Multiple recipients of list 
  ORACLE-LObjet : Re: Simple SQL Query 
  Question
  SELECT 
  STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) 
  VALUEFROM TEST;
   
  STATION    
  EMISSION_FREQ   RECEPTION_FREQ 
  VALUE-- 
  -    
  --    
  -STAT1  
  192.5  
  193.5  
  385STAT2  
  192.5    
  192.5STAT2  194   
  194STAT2  
  193.5  
  194.5  
  387STAT2  195   
  195
   
  I did not understand what you meant by 'And I would like to select the 
  number of frequencies, sort of count(*), for a given station and multiply that 
  value by 2 '
  so what I have 
  done is 
  if 
  
      the reception_freq is null (that 
  would mean there is only emission_freq )
  then 
  
      value=emission_freq*1
  else
      
  value=emission_freq*1
  end 
  if
   
  Hope this is what 
  you wanted
   
  cozI am anoviceOracle Certifiable DBBS
  
- Original Message - 
From: 
ALEMU Abiy 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, July 02, 2001 1:00 
PM
Subject: Simple SQL Query 
Question

I've a table 
with the following structure and sample data :
 
Station    
Emission_Freq    
Reception_Freq
    
-    
--
STAT1    
192.5    
193.5
STAT2    
193    
STAT2    
194
STAT2    
193.5    
194.5
STAT2    
195
 
 
And I would 
like to select the number of frequencies, sort of count(*), for a given 
station and multiply that value by 2 if the station has Emission frequency 
and reception frequency and multiply by one if the station has only the 
emission frequency or only the reception frequency.  I don't know how 
to use a condition in SQL.  I'm sure that it's possible to do it but I 
don't know how.  Can anybody help me ?

@biy @lemu
[EMAIL PROTECTED]
Database Administration 
Engineer

France
 

RE: Simple SQL Query Question

[ALEMU Abiy]

I'm 
using Oracle 7.3.4, so is it possible to use CASE statements 
?

  -Message d'origine-De : Amar Kumar Padhi 
  [mailto:[EMAIL PROTECTED]]Envoyé : lundi 2 juillet 2001 
  10:57À : Multiple recipients of list 
  ORACLE-LObjet : RE: Simple SQL Query 
  Question
  select count((case 
  when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) 
   
  then 1 else null end)) * 2 +    
  count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) 
   
  then null else 1 end)) * 1 as "total"from am39
  where station = '';
   
  rgds
  amar
  
-Original Message-From: ALEMU Abiy 
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
11:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: Simple SQL Query Question
I've a table 
with the following structure and sample data :
 
Station    
Emission_Freq    
Reception_Freq
    
-    
--
STAT1    
192.5    
193.5
STAT2    
193    
STAT2    
194
STAT2    
193.5    
194.5
STAT2    
195
 
 
And I would 
like to select the number of frequencies, sort of count(*), for a given 
station and multiply that value by 2 if the station has Emission frequency 
and reception frequency and multiply by one if the station has only the 
emission frequency or only the reception frequency.  I don't know how 
to use a condition in SQL.  I'm sure that it's possible to do it but I 
don't know how.  Can anybody help me ?

@biy @lemu
[EMAIL PROTECTED]
Database Administration 
Engineer

France
 

9i Partitioning Option.

[Mark Leith]

Hello all,

Just really a quick one - Does anybody know if partitioning is still a
chargeable option in 9i, or is it now bundled?

Cheers

Mark

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

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

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

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

Re: Exploding the Myths paper

[novicedba]

thanks
got it
read it
many things cleared
will wait for more stuff like that

coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 5:45 AM


> Okay, I've been told that the paper and slides for my presentation
Exploding
> the Myths is now up on the NYOUG site
>
> www.nyoug.org
>
> Rachel
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: novicedba
  INET: [EMAIL PROTECTED]

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

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

[A. Bardeen]

Ian,

Per MetaLink info on the patches:

Reason for Obsolescence
  This patch is being withdrawn because of a
regression of bug 1654631 which is fixed as bug
1814117 . The patch will be made available again with
the new fix included as soon as possible. 


BTW, when the new patch is released it can be applied
over the old patch if that one was already installed.

HTH,

-- Anita


--- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
> Why was it obsoleted?  Did the patch contain a bug?
> 
> Ian MacGregor
> Stanford Linear Acclerator Center
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: A. Bardeen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 29, 2001 4:34 PM
> To: MacGregor, Ian A.; LazyDBA.com Discussion;
> ORACLE-L
> Subject: RE: Gaping holes found in Oracle 8i (patch
> 1654631 info)
> 
> 
> Patch 1654631 has been obsoleted in favor of patch
> 1814117.  1814117 is listed in metalink as
> obsoleted,
> but it will be replaced shortly (expected date is
> Monday, 07/02/2001).
> 
> The patch will be released for the following
> versions:
> 
> 8.1.7.1, 8.1.6.3, 8.1.6.2 and 8.1.6.1.
> 
> For any platforms that have 5 digit patchsets as the
> latest patchset (ex. 8.1.6.3.2 64-bit on HP-UX 11) I
> expect that it will be released for the latest
> patchset.
> 
> These patches will not require passwords, the way
> other PSE's do.
> 
> HTH,
> 
> -- Anita
> 
> 
> 
> 
> --- "MacGregor, Ian A." <[EMAIL PROTECTED]>
> wrote:
> > It is true.  Patches are available via Metalink. 
> > Yesterday the only patches available were for  the
> > latest release levels.  For instance, there is a
> > patch for 8.1.6.3 but not 8.1.6.0 through 8.1.6.2;
> > there is a patch for 8.1.7.1 but not 8.1.7.0.  
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > 
> > -Original Message-
> > From: Thye Hock Gan [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 29, 2001 12:19 AM
> > To: LazyDBA.com Discussion
> > Subject: Re: Gaping holes found in Oracle 8i
> > 
> > 
> > This is not some prank, is it? Do you know the
> link
> > to
> > the patches?
> > 
> > --- Kavi Zaman <[EMAIL PROTECTED]> wrote:
> > > 
> > > 
> > > Guys,
> > > Check this out- 
> > > 
> > > http://www.itnews.com.au/story.cfm?ID=7091#top
> > > 
> > > Any thought please share.
> > > 
> > > Thanks
> > > Kavi Zaman
> > > 
> > > 
> > > 
> > > Oracle documentation is here:
> > >
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > > To unsubscribe: send a blank email to
> > > [EMAIL PROTECTED]
> > > To subscribe:   send a blank email to
> > > [EMAIL PROTECTED]
> > > Visit the list archive:
> > > http://www.LAZYDBA.com/odbareadmail.pl
> > > Tell yer mates about http://www.farAwayJobs.com
> > > By using this list you agree to these
> > > terms:http://www.lazydba.com/legal.html
> > > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.com/
> > 
> > 
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > [EMAIL PROTECTED]
> > To subscribe:   send a blank email to
> > [EMAIL PROTECTED]
> > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > 
> > 
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > [EMAIL PROTECTED]
> > To subscribe:   send a blank email to
> > [EMAIL PROTECTED]
> > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > 
> 
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/


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

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

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

Re: Influencing commit interval of read-only replication's refresh gr

[A. Bardeen]

Tamas,

The purpose of the refresh is to make the snapshot
site identical to the master site as of the point in
time that the refresh began.  As such the refresh is a
single transaction and must either commit or rollback
in its entirety.

You don't specify what version the snapshot site is,
but on O8 you can specify the RBS to use during the
refresh.

The only options I see are:

1.  Increase the RBS and/or RBS tablespace.

2.  Reduce the number of snapshots in the refresh
group.

3.  Reduce the refresh interval

HTH,

-- Anita

--- Szecsy Tamas <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> does some one know of a way to force the refresh
> process of a read-only
> snapshot group to commit at predefined intervals: by
> table, by n number of
> rows or any other way? The problem that we are
> facing is that a refresh
> group has some rapidly changing tables and the
> rollback segment is not big
> enough.
> 
> TIA,
> 
> Tamas Szecsy
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Szecsy Tamas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

Re: Simple SQL Query Question

[novicedba]

you could achieve this using decode
 
 
cozI am anoviceOracle Certifiable DBBS

  - Original Message - 
  From: 
  ALEMU Abiy 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, July 02, 2001 1:00 PM
  Subject: Simple SQL Query Question
  
  I've a table with 
  the following structure and sample data :
   
  Station    
  Emission_Freq    
  Reception_Freq
      
  -    
  --
  STAT1    
  192.5    
  193.5
  STAT2    
  193    
  STAT2    
  194
  STAT2    
  193.5    
  194.5
  STAT2    
  195
   
   
  And I would like 
  to select the number of frequencies, sort of count(*), for a given station and 
  multiply that value by 2 if the station has Emission frequency and reception 
  frequency and multiply by one if the station has only the emission frequency 
  or only the reception frequency.  I don't know how to use a condition in 
  SQL.  I'm sure that it's possible to do it but I don't know how.  
  Can anybody help me ?
  
  @biy @lemu
  [EMAIL PROTECTED]
  Database Administration 
  Engineer
  
  France
   

Re: Simple SQL Query Question

[novicedba]

SELECT 
STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) 
VALUEFROM TEST;
 
STATION    EMISSION_FREQ   
RECEPTION_FREQ 
VALUE-- 
-    
--    
-STAT1  
192.5  
193.5  
385STAT2  
192.5    
192.5STAT2  194   
194STAT2  
193.5  
194.5  
387STAT2  195   
195
 
I did not understand what you meant by 'And I would like to select the number 
of frequencies, sort of count(*), for a given station and multiply that value by 
2 '
so what I have done 
is 
if 

    
the reception_freq is null (that would mean there is only emission_freq 
)
then 

    
value=emission_freq*1
else
    
value=emission_freq*1
end 
if
 
Hope this is what 
you wanted
 
cozI am anoviceOracle Certifiable DBBS

  - Original Message - 
  From: 
  ALEMU Abiy 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, July 02, 2001 1:00 PM
  Subject: Simple SQL Query Question
  
  I've a table with 
  the following structure and sample data :
   
  Station    
  Emission_Freq    
  Reception_Freq
      
  -    
  --
  STAT1    
  192.5    
  193.5
  STAT2    
  193    
  STAT2    
  194
  STAT2    
  193.5    
  194.5
  STAT2    
  195
   
   
  And I would like 
  to select the number of frequencies, sort of count(*), for a given station and 
  multiply that value by 2 if the station has Emission frequency and reception 
  frequency and multiply by one if the station has only the emission frequency 
  or only the reception frequency.  I don't know how to use a condition in 
  SQL.  I'm sure that it's possible to do it but I don't know how.  
  Can anybody help me ?
  
  @biy @lemu
  [EMAIL PROTECTED]
  Database Administration 
  Engineer
  
  France
   

RE: Simple SQL Query Question

[Amar Kumar Padhi]

select count((case when 
(nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) 
 
then 1 else null end)) * 2 +    
count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0) 
 
then null else 1 end)) * 1 as "total"from am39
where station = '';
 
rgds
amar

  -Original Message-From: ALEMU Abiy 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 
  11:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Simple SQL Query Question
  I've a table with 
  the following structure and sample data :
   
  Station    
  Emission_Freq    
  Reception_Freq
      
  -    
  --
  STAT1    
  192.5    
  193.5
  STAT2    
  193    
  STAT2    
  194
  STAT2    
  193.5    
  194.5
  STAT2    
  195
   
   
  And I would like 
  to select the number of frequencies, sort of count(*), for a given station and 
  multiply that value by 2 if the station has Emission frequency and reception 
  frequency and multiply by one if the station has only the emission frequency 
  or only the reception frequency.  I don't know how to use a condition in 
  SQL.  I'm sure that it's possible to do it but I don't know how.  
  Can anybody help me ?
  
  @biy @lemu
  [EMAIL PROTECTED]
  Database Administration 
  Engineer
  
  France
   

RE: Why are my indexes being ignored?

[Raymond Lee Meng Hong]

Correct me if I'm wrong , if you have a index of field and your total of row
is 83000 , you index uniqueness is about 73/83000 only ,if will not have any
much performance if compare with 50% diffrences in values. 



-Original Message-
Sent: Saturday, June 30, 2001 12:51 AM
To: Multiple recipients of list ORACLE-L


You table doesn't have a degree > 1 does it?.  I've seen examples where this
caused a lot of indexes to be ignored.


-Original Message-
Sent: 29 June 2001 16:53
To: Multiple recipients of list ORACLE-L


I'm returning 117 rows.


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

 -Original Message-
Sent:   Friday, June 29, 2001 9:50 AM
To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO
Subject:Re: Why are my indexes being ignored?

"Carle, William T (Bill), NLCIO" wrote:
> 
> Hi,
> 
> I created an index on a table. The table has about 83,000 rows. The
> index is a simple index on one field, 35 different values of the index. I
> analyzed the table and I analyzed the index, trying it both with a
histogram
> and without a histogram. No matter how I do it, it does a full table scan.
> Any ideas why? I know I can use a hint, but it seems to me that it ought
to
> use the index.

how many rows are you returning?  if i remember right, and if i don't
i'm sure i'll be reminded;-), if you return more than a certain % of the
table it does a full table scan even if there are indexes.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
"It's not a bug. It's an undocumented feature"
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

[Saurabh Sharma]

hi,
 
i think u should make use of ocopy 
utility instead of simple copy command. this is provided in 
oracle_home\bin
 
jsu replace copy with 
ocopy.
 
Saurabh Sharma
 
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, June 27, 2001 8:37 
  PM
  Subject: EXECUTING DOS COMMAND IN A 
  STORED PROC?
  
  Hi gurus,
  I want to create a stored procedure to move some 
  files to a different location.
   
  CREATE OR REPLACE PROCEDURE  move_file 
  (file_name varchar2) IS 
  begin
  host copy  C:\file_name.txt D:\file_name.txt;
  end;
  /
   
  But does not recognize COPY command 
  here.
  How can I do that??
   
  Thank you 
   

RE: DBMS_JOB

[A. Bardeen]

Ramon,

When a job is broken the next_date is set to
01/01/4000.

I'm not sure I understand exactly what your initial
request was, but you can alter the next_date and
interval for any job using DBMS_JOB.CHANGE (or by
calling DBMS_JOB.NEXT_DATE and DBMS_JOB.INTERVAL
individually).

For examples of specifying different intervals, see
Note: 1068369.6 "Example:  Using DBMS_JOB.SUBMIT to
Execute Jobs at Regular Intervals"

HTH,

-- Anita

--- Raymond Lee Meng Hong <[EMAIL PROTECTED]>
wrote:
> If order to stop those funny date , can you show me
> the code of your pl/sql
> and let us try to solve it ? Becoz it seen you try
> to add in those error
> date into your next_date ?
> 
> You might need to create a lookup table to key in
> those require date,and let
> it parse to the procedure automatical..
> 
> 
> 
> -Original Message-
> Sent: Saturday, June 30, 2001 6:41 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thanks Ray and Dick,
> 
> This the output, obviously some mistakes(*), how do
> I stop them from
> executing, (take them out)
> 
>   LAST_DATE  NEXT_DATE
>   -- --
> carga_d   29/06/2001 30/06/2001
> mueve_h_f 20/02/2001 01/01/4000*
> carga_d   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl14/03/2001 01/01/4000*
> carga_v_f_s   29/06/2001 06/07/2001
> carga_v_f_m   05/06/2001 05/07/2001
> carga_d   20/03/2001 01/01/4000*
> carga_d   19/03/2001 01/01/4000*
> carga_s   20/03/2001 01/01/4000*
> carga_v   20/03/2001 01/01/4000*
> mueve_h   29/06/2001 30/06/2001
> carga_s   29/06/2001 30/06/2001
> carga_v   29/06/2001 30/06/2001
> carga_h   29/06/2001 30/06/2001
> mueve_h   29/06/2001 30/06/2001
> carga_v_fl29/06/2001 06/07/2001
> carga_v_fl   02/07/2001
> 
> What is the sintax
> to execute the procedures, some every day, some
> every week
> and some two times a week, passing different dates
> automatically as a
> parameter.
> 
> Thanks,
> 
> 
> Ramon Estevez
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ramon Estevez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


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

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

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

RE: Setting PCTFREE & PCTUSED in a Datawarehouse

[paquette stephane]

In a datawarehouse, unless your ETL processes are very
slow and your loading window is quite small, you
should always favor the reading performance over the
loading performance. 
I want to have the maximum rows per block so my
pctfree is always near 0 and pctused high.
You do not delete often in a DW but you truncate
tables and partition. 

 --- "Koivu, Lisa" <[EMAIL PROTECTED]> a
écrit : > Hi Vikas, 
> 
> The docs should have discussed the reason why.  High
> pctused can lead to a
> block going on and off the freelist frequently as
> deletes/inserts are
> processed, and also can leave the amount of free
> space inadequate for a new
> insert (your avg_rowlen comes into play here).  So
> what you'd end up with is
> several blocks on the freelist that don't have
> enough free space for an
> insert, and every time an insert is processed it
> goes thorugh the freelist
> and checks for space in the block.   The performance
> hit comes when too many
> blocks have to be checked for adequate space.  Does
> that make sense?
> 
> Now some people on this list have debated that
> PCTFREE/PCTUSED is so low
> level and that performance really is not affected
> that much.  Of course Ross
> was one of those people ("amen, my brother")
> 
> HTH
> Lisa Koivu
> Data Bored Administrator
> Ft. Lauderdale, FL, USA
> 
> 
> > -Original Message-
> > From:   Vikas Kawatra [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, June 29, 2001 11:42 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Setting PCTFREE & PCTUSED in a
> Datawarehouse
> > 
> > I read in the Oracle docs that setting a high
> PCTUSED ( such as 60/70)
> > would
> > increase the cost of INSERTS to the table. Can
> someone explain this ,
> > pleas
> > e!
> > 
> > thanks
> > 
> > vikas
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Vikas Kawatra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

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

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

sysstat table..

[Saurabh Sharma]

hi all,
 
can anybody explain me what does the 
following statistics means from my sysstat table.
 
redo 
entries  
10476redo 
size   
2851660redo buffer allocation 
retries    
5redo 
wastage    
1044924redo writer latching 
time    
73redo 
writes    
3465redo blocks 
written    
7851redo write 
time    
6583redo log space 
requests  
16redo log space wait 
time   
1438redo log switch 
interrupts    
0redo ordering 
marks   
0
 
 
Saurabh Sharma
 
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

Re: Linux profile - a little offtopic

[Peter McLarty]

Hi
. profile and  its associates for the other shells need only be read only 
for the user. It is common behavior on a production server to have the 
majority of users profiles linked to a central profile file so it is only 
editable by the System Admin. This keeps a potential security hole at bay 
by not allowing users access to the .profiles or whatever you use for the 
user shell.

If the changes to .profile are not changing your shell then you are using a 
different shell. On Linux you will be almost certainly using bash by 
default so you will need to put changes in .bashrc or maybe .bash_profile


HTH
Peter

At 08:55 PM 1/07/2001 -0800, you wrote:


>Kimberly,
>
>Since .profile is of little use unless sourced,
>why make it executable?
>
>Maybe I missed something here, but I've never used
>an executable .profile.
>
>Jared
>
>On Sunday 01 July 2001 11:15, Kimberly Smith wrote:
> > Also, make sure the .profile is executable.  It isn't by default
> > usually.  Also make sure the oracle account is setup to use a shell
> > that the .profile actually applies to.  For example, ksh (my personal
> > favoriate).  C shell uses the .login.
> >
> > -Original Message-
> > Sent: Saturday, June 30, 2001 10:20 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > On June 30, 2001 01:30 pm, Csillag Zsolt wrote:
> > > Hi,
> > >
> > > Since I'd like to install Oracle for Linux, I need to change the
> > > profile for user 'oracle'.
> > >
> > > I edited the .profile file located in /home/oracle folder but it
> > > seems to me that this isn't the file that Linux loads at startup.
> >
> > Take a look at /etc/profile - this is the default system-wide user
> > profile (be aware that all changes to this file will affect all
> > non-root users on the system).
> >
> > Cheers,
> > GC
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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