RE: Common Subquery Elimination in 8.1.7 causes incorrect

[Reardon, Bruce (CALBBAY)]

Larry,

Thanks for the information.
Do you have a bug number reference for the other problem you mention?

Thanks,
Bruce

-Original Message-
Sent: Friday, 6 April 2001 14:45

I would strongly suggest the:

optimizer_features_enable = 8.1.6

because it also cures another problem with 8.1.7 wherein a complex query 
with multiple OR and AND conditions will return the wrong number of rows if 
you are using CBO (and/or any statistics are on the resultant table).

larry

At 07:55 PM 4/5/2001 -0800, you wrote:
>Hi,
>
>There is a note on Metalink (137430.1 reproduced below) describing a
generic
>817 optimiser problem that will result in incorrect results when using
>certain query types.
>
>We are currently running 81511 on NT but testing an upgrade to 81711 on NT
>at the moment.
>
>The note suggests 2 workarounds, and my question to others is
>
>Should we set "optimizer_features_enable = 8.1.6"
>-or-
>should we set "_eliminate_common_subexpr = false"
>
>Which method does the list suggest, and what are the implications of each?
>
>Thanks,
>Bruce Reardon
>mailto:[EMAIL PROTECTED]
>
>
>
>Doc ID:  Note:137430.1
>results
>Type:  ALERT
>Status:  PUBLISHED
>  Content Type:  TEXT/PLAIN
>Creation Date:  23-MAR-2001
>Last Revision Date:  28-MAR-2001
>
>
>   Common Subquery Elimination in 8.1.7 causes incorrect results
>   ~~
>   Versions Affected
>   ~
>   Oracle Server releases 8.1.7.0 and 8.1.7.1
>
>   Fixed in 8.1.7.2 and 9.0.0.0
>
>   Platforms Affected
>   ~~
> GENERIC
>
>   Description
>   ~~~
>   The bug is that rows may be returned when none are expected with the
query
>below.
>   Other queries may return more or less rows than expected depending on
the
>predicates used.
>
>
> select * from tab1
>  where (tab1.col1 = 1 and exists (select * from tab2))
> or (tab1.col1 = 2 and exists (select * from tab3))"
>
>
>There are several variations on this.
>Eg:
>select /*+ ALL_ROWS */ * from tab1
>   where (tab1.col1 = 1 and col1 in (select col1 from tab2))
>  or (tab1.col1 = 2 and col1 in (select col1 from tab3))
>;
>
>
>
>
>   Note:  The use of the two parts of the WHERE clause separated by an OR
>operator,
>   each clause containing a non-correlated subquery.
>
>
>   The problem is that common subquery elimination treats un-correlated
>subqueries
>   as identical even when they are not.
>
>
>
>   Likelihood of Occurrence
>   
>
>   Any time the above construct is used.
>   This construct is common in queries used by some third party
applications
>including
>   People Soft.
>
>   This problem only occurs on database versions 8.1.7.0 and 8.1.7.1.
>   Earlier versions are not affected.
>
>
>   Possible Symptoms
>   ~
>   No error is raised.
>   Unless the user is aware of incorrect results the problem will be
>undetected.
>
>
>
>
>   Workaround
>   ~~
>   As the problem is caused by a new optimizer feature introduced in 8.1.7,
>   the workaround is to set a parameter in the init.ora to disable the
>feature.
>
>
>Either set:
>
>
>   "optimizer_features_enable = 8.1.6"
>   -or-
>   "_eliminate_common_subexpr = false"
>
>
>   Patches
>   ~~~
>   This is expected to be fixed in the 8.1.7.2 Patch Set.
>   The problem is fixed in Oracle9i.
>   No single one off patches are currently available.
>
>
>
>
>   References
>   ~~
>  QUERY RETURNING ROWS IN 8.1.7 WHEN NO ROWS EXPECTED[BUG:1578644]
-- 
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).

RE: (Fwd) RE: MS-DOS commands - list of ??? / Re: WINNT-L Di

[Abdul Aleem]

I have noticed that information passed on by Mr. Pierce is useful, direct,
my question is:

WHICH SEARCH ENGINE DO YOU USE, MR. PIERCE?

Regards,

Aleem

 -Original Message-
Sent:   Wednesday, April 04, 2001 5:06 AM
To: Multiple recipients of list ORACLE-L
Subject:(Fwd) RE:  MS-DOS commands - list of ??? / Re: WINNT-L
Dig

another good one!

--- Forwarded message follows ---
Date sent:  Tue, 3 Apr 2001 16:31:26 -0400
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>

http://www.computerhope.com/msdos.htm

...
>---
>The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft
>international's LISTSERV(R) software.  For subscription/signoff info
>and archives, see http://peach.ease.lsoft.com/archives/winnt-l.html .
>
--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

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

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

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

Urgent !!! - Database Installation

[Wendy Y]

Dear DBAs: 
There might have some one post before, but I can't recall the answer now.
We have completely gone through oracle 8.1.6 installation on window 2000 server. When we run net8 configure assistant, The computer frozen. Then we have to cancel it but listener.ora has been configured. When we use database assistant to create database, we got this problem. We tried many times, all were same error message - ora-12560. 
Could anyone point out what's the problem.Thank you so much. 
WendyDo You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

Re: Histogram Helper

[Binley Lim]

The documentation has under-sold this feature. Even for columns that do not look very 
skewed at all, histograms helps to turn ugly explain-plans to very fast ones. 
Somewhere inside the optimizer, histograms help it decide on sensible join-orders 
amongst other things. You didn't say, but I suspect your dramatic improvement is in 
the different join order.

If you can, compute for table for ALL columns for all indexes (3 alls and leave out 
the indexed keyword). This will do all columns, but may not be feasible because it 
could blow out sys.histgrm$ depending on how many tables/columns/partitions you have. 
Do not specify the buckets -- let the analyze choose. It will vary the number 
depending on what it finds.

If you cannot do all columns, then do indexed plus where-clause columns. For the where 
clause columns, look at the SQL in the v$sqlarea + v$sqltext with high disk_reads and 
buffer_gets. For those ones, parse the SQL from v$sqltext after the from-clause to get 
tokens (words), and lookup dba_tab_columns for valid column_names. From this list and 
dba_ind_columns, you can construct the columns-list to feed the analyze statement. For 
a DW, this is essential to cut down QFHs. I have a procedure to do this if you are 
interested. This may still blow out your sys.histgrm$ - so you will have to apply a 
little local knowledge to cut down on the list.

At the very least, I would do indexed columns for SQL with high 
disk_reads/buffer_gets/executions. This is minimal cost for potentially very high 
gains as you found out.

Have fun.

>>> [EMAIL PROTECTED] 04/06/01 12:20PM >>>
I just experienced an incredibly DRAMATIC performance boost with a
well-placed histogram! Now I'm hungry for "Histogram Helper." I'd like to
analyze the database and identify other possible candidates for histograms.
(Then maybe review the code after that. I'm using CHOOSE optimization with
automatic statistics gathering on all tables and indexes.)

Here's a quote from the Oracle Tuning Guide:
"In general, you should create histograms on columns that are frequently
used in WHERE clauses of queries and have a highly skewed data distribution--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
  INET: [EMAIL PROTECTED]

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

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

[Arn Klammer]

The actual archiving of log files itself should not impact the 
performance of the insert jobs, unless the archiving process is slow enough to 
cause the database to pause while a log is archived so it can be reused.  
The only other reason why the developers wouldn't want it is if the space 
required to store the archived logs impinges on their development space; in that 
case, you'd have a case for getting more storage.  Either way, the 
inability to recover a database due to the absence of logs is far 
worse!
 
-a
>>> [EMAIL PROTECTED] 6/4/2001 14:45:28 
>>>This message has been scanned by 
MAILSweeper.The 
developer application running huge batch inserting data into database,that 
is what they told me, if you are me what you will do?-Original 
Message-TestaSent: Friday, 6 April 2001 11:55 AMTo: Multiple 
recipients of list ORACLE-Lassuming you're the dba, since when does 
the developer dictaterecoverability to a DBA about a database.sounds 
like a role problem there.joeSinardy Xing wrote:>> 
Our Developer prefer the archive off, I can't change that anymore 
:(>> -Original Message-> Sent: Thursday, 5 April 
2001 8:54 PM> To: LazyDBA mailing list>> Turn archiving 
on.>> > -Original Message-> > From: Sinardy 
Xing [mailto:[EMAIL PROTECTED]]> 
> Sent: Thursday, April 05, 2001 4:57 AM> > To: LazyDBA mailing 
list> > Subject: Recovery from noarchive db corrected> 
>> >> > Hi,> >> > My database is 
noarchive mode, what should I do to prevent> > from lossing 
any> > transactions ?> > Like for example incresed the REDO 
buffer to ... (daily buffer)?> > Will this decrese the performance 
?> > any technique to share ?> >> > 
Sinardy> >> > > > Think you know someone 
who can answer the above question?> > Forward it to them!> > 
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> 
>> >>> > Think you know someone who 
can answer the above question? Forward it to> them!> 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>> 
--> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> 
Author: Sinardy Xing>   INET: 
[EMAIL PROTECTED]>> Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051> 
San Diego, California    -- Public 
Internet access / Mailing Lists> 
> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the 
message BODY, include a line containing: UNSUB ORACLE-L> (or the name of 
mailing list you want to be removed from).  You may> also send the 
HELP command for other information (like subscribing).--Joe 
Testa  http://www.oracle-dba.comPerforming 
Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com 
domain, its not going cheap but feel free toask :)--Please see the 
official ORACLE-L FAQ: http://www.orafaq.com--Author: Joseph 
S. Testa  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Sinardy Xing  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).

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

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

www.mimesweeper.com
*

RE: Recovery from noarchive db corrected

[Suhen Pather]

Sinardy,

Who will recover the database in case of a failure?

Turing on archiving would not hinder performance so much.
Proper planning of your backup strategy and db setup will have little
overhead 
on performance of your database.

You cannot sacrifice backups for a marginal increase in performance
especially if
your db is a high transaction processing system.

Regards
Suhen





The developer application running huge batch inserting data into database,
that is what they told me, if you are me what you will do?

-Original Message-
Testa
Sent: Friday, 6 April 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


assuming you're the dba, since when does the developer dictate
recoverability to a DBA about a database.

sounds like a role problem there.

joe

Sinardy Xing wrote:
>
> Our Developer prefer the archive off, I can't change that anymore :(
>
> -Original Message-
> Sent: Thursday, 5 April 2001 8:54 PM
> To: LazyDBA mailing list
>
> Turn archiving on.
>
> > -Original Message-
> > From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 05, 2001 4:57 AM
> > To: LazyDBA mailing list
> > Subject: Recovery from noarchive db corrected
> >
> >
> > Hi,
> >
> > My database is noarchive mode, what should I do to prevent
> > from lossing any
> > transactions ?
> > Like for example incresed the REDO buffer to ... (daily buffer)?
> > Will this decrese the performance ?
> > any technique to share ?
> >
> > Sinardy
> >
> > 
> > Think you know someone who can answer the above question?
> > Forward it to them!
> > 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
> >
> >
>
> 
> Think you know someone who can answer the above question? Forward it to
> them!
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

RE: Recovery from noarchive db corrected

[Sinardy Xing]

The developer application running huge batch inserting data into database,
that is what they told me, if you are me what you will do?

-Original Message-
Testa
Sent: Friday, 6 April 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


assuming you're the dba, since when does the developer dictate
recoverability to a DBA about a database.

sounds like a role problem there.

joe

Sinardy Xing wrote:
>
> Our Developer prefer the archive off, I can't change that anymore :(
>
> -Original Message-
> Sent: Thursday, 5 April 2001 8:54 PM
> To: LazyDBA mailing list
>
> Turn archiving on.
>
> > -Original Message-
> > From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 05, 2001 4:57 AM
> > To: LazyDBA mailing list
> > Subject: Recovery from noarchive db corrected
> >
> >
> > Hi,
> >
> > My database is noarchive mode, what should I do to prevent
> > from lossing any
> > transactions ?
> > Like for example incresed the REDO buffer to ... (daily buffer)?
> > Will this decrese the performance ?
> > any technique to share ?
> >
> > Sinardy
> >
> > 
> > Think you know someone who can answer the above question?
> > Forward it to them!
> > 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
> >
> >
>
> 
> Think you know someone who can answer the above question? Forward it to
> them!
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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

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

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

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

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

[Larry Strickland]

I would strongly suggest the:

optimizer_features_enable = 8.1.6

because it also cures another problem with 8.1.7 wherein a complex query 
with multiple OR and AND conditions will return the wrong number of rows if 
you are using CBO (and/or any statistics are on the resultant table).

larry

At 07:55 PM 4/5/2001 -0800, you wrote:
>Hi,
>
>There is a note on Metalink (137430.1 reproduced below) describing a generic
>817 optimiser problem that will result in incorrect results when using
>certain query types.
>
>We are currently running 81511 on NT but testing an upgrade to 81711 on NT
>at the moment.
>
>The note suggests 2 workarounds, and my question to others is
>
>Should we set "optimizer_features_enable = 8.1.6"
>-or-
>should we set "_eliminate_common_subexpr = false"
>
>Which method does the list suggest, and what are the implications of each?
>
>Thanks,
>Bruce Reardon
>mailto:[EMAIL PROTECTED]
>
>
>
>Doc ID:  Note:137430.1
>results
>Type:  ALERT
>Status:  PUBLISHED
>  Content Type:  TEXT/PLAIN
>Creation Date:  23-MAR-2001
>Last Revision Date:  28-MAR-2001
>
>
>   Common Subquery Elimination in 8.1.7 causes incorrect results
>   ~~
>   Versions Affected
>   ~
>   Oracle Server releases 8.1.7.0 and 8.1.7.1
>
>   Fixed in 8.1.7.2 and 9.0.0.0
>
>   Platforms Affected
>   ~~
> GENERIC
>
>   Description
>   ~~~
>   The bug is that rows may be returned when none are expected with the query
>below.
>   Other queries may return more or less rows than expected depending on the
>predicates used.
>
>
> select * from tab1
>  where (tab1.col1 = 1 and exists (select * from tab2))
> or (tab1.col1 = 2 and exists (select * from tab3))"
>
>
>There are several variations on this.
>Eg:
>select /*+ ALL_ROWS */ * from tab1
>   where (tab1.col1 = 1 and col1 in (select col1 from tab2))
>  or (tab1.col1 = 2 and col1 in (select col1 from tab3))
>;
>
>
>
>
>   Note:  The use of the two parts of the WHERE clause separated by an OR
>operator,
>   each clause containing a non-correlated subquery.
>
>
>   The problem is that common subquery elimination treats un-correlated
>subqueries
>   as identical even when they are not.
>
>
>
>   Likelihood of Occurrence
>   
>
>   Any time the above construct is used.
>   This construct is common in queries used by some third party applications
>including
>   People Soft.
>
>   This problem only occurs on database versions 8.1.7.0 and 8.1.7.1.
>   Earlier versions are not affected.
>
>
>   Possible Symptoms
>   ~
>   No error is raised.
>   Unless the user is aware of incorrect results the problem will be
>undetected.
>
>
>
>
>   Workaround
>   ~~
>   As the problem is caused by a new optimizer feature introduced in 8.1.7,
>   the workaround is to set a parameter in the init.ora to disable the
>feature.
>
>
>Either set:
>
>
>   "optimizer_features_enable = 8.1.6"
>   -or-
>   "_eliminate_common_subexpr = false"
>
>
>   Patches
>   ~~~
>   This is expected to be fixed in the 8.1.7.2 Patch Set.
>   The problem is fixed in Oracle9i.
>   No single one off patches are currently available.
>
>
>
>
>   References
>   ~~
>  QUERY RETURNING ROWS IN 8.1.7 WHEN NO ROWS EXPECTED[BUG:1578644]
>--
>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: Larry Strickland
  INET: [EMAIL PROTECTED]

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

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

[Viraj Luthra]

test message


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

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

Common Subquery Elimination in 8.1.7 causes incorrect results -

[Reardon, Bruce (CALBBAY)]

Hi,

There is a note on Metalink (137430.1 reproduced below) describing a generic
817 optimiser problem that will result in incorrect results when using
certain query types.

We are currently running 81511 on NT but testing an upgrade to 81711 on NT
at the moment.

The note suggests 2 workarounds, and my question to others is

Should we set "optimizer_features_enable = 8.1.6" 
-or- 
should we set "_eliminate_common_subexpr = false" 

Which method does the list suggest, and what are the implications of each?

Thanks,
Bruce Reardon
mailto:[EMAIL PROTECTED]



Doc ID:  Note:137430.1 
results 
Type:  ALERT 
Status:  PUBLISHED 
 Content Type:  TEXT/PLAIN 
Creation Date:  23-MAR-2001 
Last Revision Date:  28-MAR-2001 
 

  Common Subquery Elimination in 8.1.7 causes incorrect results 
  ~~ 
  Versions Affected 
  ~ 
  Oracle Server releases 8.1.7.0 and 8.1.7.1 

  Fixed in 8.1.7.2 and 9.0.0.0 

  Platforms Affected 
  ~~ 
GENERIC 

  Description 
  ~~~ 
  The bug is that rows may be returned when none are expected with the query
below. 
  Other queries may return more or less rows than expected depending on the
predicates used. 


select * from tab1 
 where (tab1.col1 = 1 and exists (select * from tab2)) 
or (tab1.col1 = 2 and exists (select * from tab3))" 


There are several variations on this. 
Eg: 
select /*+ ALL_ROWS */ * from tab1 
  where (tab1.col1 = 1 and col1 in (select col1 from tab2)) 
 or (tab1.col1 = 2 and col1 in (select col1 from tab3)) 
; 
  



  Note:  The use of the two parts of the WHERE clause separated by an OR
operator, 
  each clause containing a non-correlated subquery.
   

  The problem is that common subquery elimination treats un-correlated
subqueries
  as identical even when they are not. 
  


  Likelihood of Occurrence 
   

  Any time the above construct is used. 
  This construct is common in queries used by some third party applications
including 
  People Soft. 

  This problem only occurs on database versions 8.1.7.0 and 8.1.7.1. 
  Earlier versions are not affected. 


  Possible Symptoms 
  ~ 
  No error is raised. 
  Unless the user is aware of incorrect results the problem will be
undetected. 
   

  

  Workaround 
  ~~ 
  As the problem is caused by a new optimizer feature introduced in 8.1.7, 
  the workaround is to set a parameter in the init.ora to disable the
feature. 
   

Either set: 


  "optimizer_features_enable = 8.1.6" 
  -or- 
  "_eliminate_common_subexpr = false" 


  Patches 
  ~~~ 
  This is expected to be fixed in the 8.1.7.2 Patch Set. 
  The problem is fixed in Oracle9i. 
  No single one off patches are currently available. 
   



  References 
  ~~ 
 QUERY RETURNING ROWS IN 8.1.7 WHEN NO ROWS EXPECTED[BUG:1578644]
-- 
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).

Re: Recovery from noarchive db corrected

[Joseph S. Testa]

assuming you're the dba, since when does the developer dictate
recoverability to a DBA about a database.

sounds like a role problem there.

joe

Sinardy Xing wrote:
> 
> Our Developer prefer the archive off, I can't change that anymore :(
> 
> -Original Message-
> Sent: Thursday, 5 April 2001 8:54 PM
> To: LazyDBA mailing list
> 
> Turn archiving on.
> 
> > -Original Message-
> > From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 05, 2001 4:57 AM
> > To: LazyDBA mailing list
> > Subject: Recovery from noarchive db corrected
> >
> >
> > Hi,
> >
> > My database is noarchive mode, what should I do to prevent
> > from lossing any
> > transactions ?
> > Like for example incresed the REDO buffer to ... (daily buffer)?
> > Will this decrese the performance ?
> > any technique to share ?
> >
> > Sinardy
> >
> > 
> > Think you know someone who can answer the above question?
> > Forward it to them!
> > 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
> >
> >
> 
> 
> Think you know someone who can answer the above question? Forward it to
> them!
> 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
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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

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

RE: Recovery from noarchive db corrected

[Sinardy Xing]

Our Developer prefer the archive off, I can't change that anymore :(

-Original Message-
Sent: Thursday, 5 April 2001 8:54 PM
To: LazyDBA mailing list


Turn archiving on.

> -Original Message-
> From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 4:57 AM
> To: LazyDBA mailing list
> Subject: Recovery from noarchive db corrected
>
>
> Hi,
>
> My database is noarchive mode, what should I do to prevent
> from lossing any
> transactions ?
> Like for example incresed the REDO buffer to ... (daily buffer)?
> Will this decrese the performance ?
> any technique to share ?
>
> Sinardy
>
> 
> Think you know someone who can answer the above question?
> Forward it to them!
> 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
>
>


Think you know someone who can answer the above question? Forward it to
them!
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


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

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

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

Histogram Helper

[Steve Orr]

I just experienced an incredibly DRAMATIC performance boost with a
well-placed histogram! Now I'm hungry for "Histogram Helper." I'd like to
analyze the database and identify other possible candidates for histograms.
(Then maybe review the code after that. I'm using CHOOSE optimization with
automatic statistics gathering on all tables and indexes.)

Here's a quote from the Oracle Tuning Guide:
"In general, you should create histograms on columns that are frequently
used in WHERE clauses of queries and have a highly skewed data distribution.
For many applications, it is appropriate to create histograms for all
indexed columns because indexed columns typically are the columns most often
used in WHERE clauses."

Has anyone ever created histograms for all indexed columns as suggested
above? You could query DBA_INDEXES (or DBA_IND_COLUMNS) and create dynamic
SQL as follows: analyze table  compute statistics for all indexed
columns size 10;

Better yet, you could set the "method_opt" parameter of the
DBMS_STATS.GATHER_SCHEMA_STATS procedure to "all indexed columns size 100."
But isn't that brute force? I'm thinking our histogram helper should be a
little more sophisticated by factoring in an analysis of how skewed the data
is using the num_distinct, density, num_buckets, and last_analyzed columns
from dba_tab_columns. Finally, histogram helper should be automated to
ensure our statistics are maintained.

Any ideas or personal experiences with histograms? Any white papers on
implementing and managing histograms?

TIA!
Steve Orr

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

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

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

RE: OT why is there dinosaur statues and evolution of human conciousness

[David Messer]

Sure they're intertwined, that doesn't mean I criticize all of it.  I don't
blame Gates for (apparently) wanting to control the world or monopolize
large portions of it.  I believe that's fairly common among CEO's.  I
criticize his endorsement of a policy - upgrades out the wazoo - that has
led to annoyance for me.  The result being my transformation from customer
and supporter to reluctant user if someone else buys and critic.

The short version - lots of people want to be really rich and rule the
world, the annoying ones have more hecklers.

DM

-Original Message-
Pierce
Sent: Thursday, April 05, 2001 4:31 PM

call me a prematurely cantankerous curmudgeon, but aren't
"making money" and "best ...business strategy" completely
intertwined with all the unsavory product related stuff you
mention (and more, eg "anti-trust")

...


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

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

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

RE: OT why is there dinosaur statues and evolution of human conciousness

[Eric D. Pierce]

call me a prematurely cantankerous curmudgeon, but aren't 
"making money" and "best ...business strategy" completely 
intertwined with all the unsavory product related stuff you 
mention (and more, eg "anti-trust")

hopelessly, relentlessly & unrepentantly holistic,
ep

ps, what really put *me* over the edge was that horrible
K-Mart sweater that Bill Gates wore in the TV commercial
about "innovation" that came out right after the U.S. 
Justice Department started winning.


On 5 Apr 2001, at 14:46, David Messer wrote:

Date sent:  Thu, 05 Apr 2001 14:46:06 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> I hadn't thought of that.
> 
> It's not that I criticize Gate/MS for making money or being the first or
> best to use a particular business strategy.  My income is derive, at least
> in part, from using MS technology.
> 
> My annoyance and disgust is with such things as the MS policy of upgrades.

...


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

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

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

[Tom Pall (E-mail)]

We're in the process of migrating all of our 8.0.5 to 8.1.6
databases over to 8.1.7.1.  We'll be done in a few weeks.
We used 8.1.7.0 on our reporting and other non-money making
databases since it was released.  The few cosmetic
issues we had with 8.1.7.0, like v$buffer_pool_statistics being broken,
appear fixed in 8.1.7.1.  8.1.7 fixed an almost endless number of
bugs we encountered in 8.1.5 and 8.1.6.

Sun/Sparc 2.7.

-Original Message-
Sanmarti
Sent: Thursday, April 05, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L



Hello,

I was wondering how stable the Oracle 8i release 3 is. We plan to move our
DB in production to the latest version.
Has anybody had problems migrating it? I was told by colleges that release 2
looks more stable than the other. How true is that?

Any comments ?

Thanks in advance,
Jordi

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

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

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

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

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

RE: OT RE: Oracle being scalable

[Gogala, Mladen]

You mean, the infamous "Atlanta" database which was showing runners 30ft
tall and 99 yrs. old?
That one was worth remembering it.

-Original Message-
Sent: Thursday, April 05, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


LoL! The "Winter Corporation"? Which databases were included?
 
The Olympics one that IBM did on DB2?
The Terraserver database?
The SETI one?
2500 Transactions per second is the fastest they did? A conservative
estimate of page hits per second ( "transaction" ) for a web site
i know of is 8400/second. 
 
:-) Oh, yea, and How much did Oracle pay Winter for the objective
evaluation?
 
Inquiring minds want to know! :-D

-Original Message-
Sent: Thursday, April 05, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L



> -Original Message- 
> From: Boivin, Patrice J [ mailto:[EMAIL PROTECTED]
 ] 
> 
> Have you seen this? 
> 
> http://www.oracle.com/ip/deploy/database/featurestory/index.ht
  
> ml?wintergrp.h 
> tml 


Interesting. For those of you who haven't read the article, it says that a
survey made by the Winter Corporation showed that the top 10 OLTP databases
on UNIX in the following categories: "Most Data", "Highest Workload", "Most
Rows/Records" were all Oracle databases.

Does anyone know of similar surveys on other platforms? In particular
Windows NT / Windows 2000? 

And how about on the Sinclair, the Tandy, and the Commoder PET? :) 

-- 
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: OT RE: Oracle being scalable

[Eric D. Pierce]

did you see a category for the fastest & biggest IBM mainframe
IMS database communicating using EDI (or whatever that legacy
data communications thingy is called that banks have been using
for decades instead of IP) that runs in a legacy Z80 serial port
simulator mode and boots off 8" floppies while communicating 
out to the operator console in morse code and in via manual
register switches borrowed from a demonstration panel in the 
apollo space museum?

what? only one winner in that category!

regards,
ep

On 5 Apr 2001, at 14:26, Mohan, Ross scribbled with alacrity and cogency:

> ||  No, I just know for a fact they don't write or run the world's largest
> databases, 
> so . 

...


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

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

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

[Zhong Hong]

Title: RE: 8.1.6 vs 8.1.7





I had some problem with external process.


Zhong
It's another beautiful day!



-Original Message-
From: Jordi Sanmarti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
Subject: 8.1.6 vs 8.1.7




Hello,


I was wondering how stable the Oracle 8i release 3 is. We plan to move our
DB in production to the latest version.
Has anybody had problems migrating it? I was told by colleges that release 2
looks more stable than the other. How true is that?


Any comments ?


Thanks in advance,
Jordi


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


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

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

[Jacques Kilchoer]

Title: RE: Dependent objects





>-Original Message-
>From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]
>
>Does anyone have (or know where I can find) a script to identify
> dependencies on a table?  When we make table modifications,
> we would like to be able to run a script that recursively
> identifies dependent objects.  We pulled one from Metalink,
> but it doesn't seem to work.


This is probably not the best or most efficient way, but it's a "quick and dirty" approach. It should give you the correct results as long as you don't have objects that depend on themselves.

create table my_dependencies as select * from dba_dependencies ;
set linesize 120
column parent format a58
column child format a58
define owner = "XXX"
define object = "YYY"
 select
   referenced_type || ' "' || referenced_owner || '"."' ||
  referenced_name || '"' as parent,
   type || ' "' || owner || '"."' || name || '"' as child
  from
    my_dependencies
  start with
    referenced_owner = '&owner'
    and referenced_name = '&object'
  connect by
    referenced_owner = prior owner
    and referenced_name = prior name
    and referenced_type = prior type
union
 select
   referenced_type || ' "' || referenced_owner || '"."' ||
  referenced_name || '"' as parent,
   type || ' "' || owner || '"."' || name || '"' as child
  from
    my_dependencies
  start with
    owner = '&owner'
    and name = '&object'
  connect by
    owner = prior referenced_owner
    and name = prior referenced_name
    and type = prior referenced_type
order by
  1, 2 ;
drop table my_dependencies ;

RE: OT why is there dinosaur statues and evolution of human conciousness

[David Messer]

I hadn't thought of that.

It's not that I criticize Gate/MS for making money or being the first or
best to use a particular business strategy.  My income is derive, at least
in part, from using MS technology.

My annoyance and disgust is with such things as the MS policy of upgrades.
I started out with a 386 based machine running DOS 5 or so and Windows 3.11.
The computer dealer didn't bother to include the original disks and when it
came time to move to the next version of Windows, the upgrade was about half
the price of the full version.  I had registered my software when I got the
computer but that didn't get me a full version of the new software at the
upgrade price.  I got the Upgrade.  When I was, for reasons unknown to me,
unable to start DOS or Windows I had to reformat the hard drive.  Upon
reinstalling, I didn't have a starting version of the software, so the
upgrade didn't do me any good because there was nothing to upgrade.  I
couldn't afford the full version of the new Windows program so I learned the
DOS commands and didn't run any Windows programs.  Eventually, I came up
with the full version of Windows.

Other peeves include the transformation of MS documentation manuals into
advertisements for the product they're supposed to describe.  I don't need
to know how Windows95 is going to take me where I want to go, I need the
manual to tell me how to use the product.

To their credit, MS has unified a great deal of software conventions ("alt +
F then P" brings up a print menu in most windows based programs I know) and
has produced software at low enough price that the general population can
afford it and software that is simple enough that the general population can
use it.

Call it a personal failing on my part but I enjoy pointing out the failings
and shortsightedness of MS and Gates.

Regards,
DM



-Original Message-
Pierce
Sent: Thursday, April 05, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
conciousness / RE: OT : Sinclair was RE: Metalink Again



On 5 Apr 2001, at 11:01, David Messer wrote:

Date sent:  Thu, 05 Apr 2001 11:01:26 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> But, Eric, I'm not out to prove anything.

Never said you were.

By "proof" I meant when two competing pieces of "factual" information
(or references to such) are posted to a public list, then questions
can, and perhaps ought to, be raised as to the veracity/legitimacy of
the sources of the information, and the nature of the "truth claims"
represented by the different perspectives in the argument.


>I'm only trying to show Gates in
> the worst light possible.  My desire to do so derives from working day in
> and day out with Microsoft products.


I'm not exactly a fan of Gates/MS, and don't consider myself in
opposition to your main point, but I would suggest that if one has to
lie, deceive, or misrepresent in order to make the point, then one is
potentially exposing oneself to valid criticisms about a lack of
ethical consistency, and beyond that, the general efficacy of such
tactics.

For background on tendencies toward dysfunctional (self-defeating)
nature of "social change" paradigms (and related tendencies toward
ideological/political oppositionality), I would suggest reading Rabbi
Michael Lerner's book "Surplus Powerlessness" (related commentary at
http://www.tikkun.org/).

As I've said before, I think the sociological backdrop to the debate
about MS has to do with the conflicts in the value systems and "world
views" of:


 1) the (old time) industrial strength technical/engineering "purists"

and

 2) the "populists", unfortunately including Gates, that weren't
afraid to do the messy job involved in taking the technology to
the masses (cheaply).


These "opposites" are obviously an oversimplified representation of
the extreme ends of a spectrum containing more complex elements, and
also mirror pre-existing elements in broader scientific, technical
and business "subcultures".

I think that part of the reason that the tech elites and "purists"
may hate Gates so much is because they realized, to late, that they
lost a great opportunity make a lot of money in the mass market
because of the limitations that their "purist" engineering/tech
aesthetic placed on their entreprenurial vision & reach. In the era
when "big iron" and extremely expensive software reigned supreme, the
"purist" aesthetic proved to be very successful, but it wasn't
universally competitive once the feasibility of a "mass market"
approach emerged.

Ironically, the value systems of tech purists tend to align with
libertarianism (which I personally think is virtuous, at least when
seen from the perspective of a
progressive/integrative/univeralist/constructivist evolutionary model
of human conciousness based on the emergence of
transformational/transcendent archetypes, such as Ken Wilber's),
whereas PC technology essentially originally came from the great
state sponso

speaking of Dr. Paul Dorsey / (Fwd) RE: Where to handle referential integrity and other data

[Eric D. Pierce]

Warning, the following comments (presumably in short form) are from 
somone who not only has a Phd, but a minor in philosophy. :)

ep

--- Forwarded message follows ---
Date sent:  Thu, 05 Apr 2001 14:40:29 -0800
T o : < O D T U G - D E V 2 K - L @ f a t c i t y . c o m > 
F r o m :  " P a u l   D o r s e y "   < p d o r s e y @ d u l c i a n . c o m > 

I have stopped being surprised by depth of the stupidity exhibited by people
in this industry.
The development team quote mentioned in your post sounds like a good
candidate for an addition to my top ways to guarantee project failure
poster.
This is right up there with the comment: "I broke my PC's cup holder."

And people wonder why the industry suffers from a 70% project failure rate.

Paul Dorsey
Dulcian, Inc.


Hi!

Even if you make the Business Rule about the unpaid bills, I doubt if that
can or would be enforced; else we would hardly be having this thread. I just
had a development team tell me they would not trust to put anything into
Oracle and become tied to it. Rather write all the stuff in the preferred
language of the day (a flavour of Java). **and** these folks have made a
business decision to use Designer as the Tool.


>From: "Openshaw, Michael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ODTUG-DEV2K-L <[EMAIL PROTECTED]>
>Subject: RE: Where to handle referential integrity and other data
>Date: Thu, 05 Apr 2001 12:06:21 -0800
>
>Sell the time?  If you are *not* going to take advantage of the new
>capability of each version of software, then why migrate?
>(and that is a serious question.  Many migrations are done simply to be on
>the latest version, not for any specific business need).
>
>As to selling referential integrity, tell the decision makers that you'll
>program the system so that every unpaid bill whose customer gets deleted is
>taken out of their paycheck.
>
>*Every* system I've ever investigated that did not have referential
>integrity in the database had substantial 'orphan' record problems.
>
> > -Original Message-
> > From:   Gabriel Galanternik [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, April 05, 2001 2:41 PM
> > To: Multiple recipients of list ODTUG-DEV2K-L
> > Subject:RE: Where to handle referential integrity and other data
> >
> > first, my stand. I think that referential integrity in the db is a must,
> > but, let's play devil's lawyer:
> > what about systems migrated from oracle 6? there you have no
>constraints.
> > then you migrated to earlier oracle 7, with no stored programs and so,
> > now, you, maybe, are at new 8i db.
> > you also migrated your applications from forms2 to forms3, then to
> > developer
> > 1.x and so on.
> >
> > How you sell the time needed to implement referential integrity at db
>when
> > you lived without them so many years...?
> > I expect no answers, just to say that there some things you can't fight
> > against.
> >
> > just my .02
> > Gabriel Galanternik
> > Tesis OyS
> > Republica Argentina
> >
> > - Original Message -
> > To: Multiple recipients of list ODTUG-DEV2K-L
> > Sent: Tuesday, April 03, 2001 7:15 PM
> >
> >
> > I think you are all being way to subtle in your opinions.
> > I think that anyone who does not use referential integrity in the DB is
> > wrong.
> > To build data checking into the applications and not in the database is
> > professional misconduct.
> > If the project fails, this would constitute legal evidence of
> > incompetence.
> > Under no circumstances should you EVER contemplate only using
>application
> > based data error checking.
> >
> > There are many good arguments for this, most of which have been well and
> > eloquently stated on this thread.
> >
> > That said, I want to take issue with the opinion that you then build the
> > same logic in the applications in order to provide humane error
>messages.
> > I
> > think a much better approach is to have the error checking done only in
> > the
> > DBMS and to trap the error message and then to replace the bad message
> > with
> > a better one.
> >
> > Paul (ever the subtle one) Dorsey
> > Dulcian, Inc.
> >
> >
> >
> >
> >
> > -Original Message-
> > Lindberg
> > Sent: Tuesday, April 03, 2001 3:36 PM
> > To: Multiple recipients of list ODTUG-DEV2K-L
> >
> >
> > I have always been a fan of database integrity.  Oracle is a fantastic
> > database and I feel that utilizing the features it has built-in is a big
> > plus.
> >
> > Robert Lindberg
> > Sr. Systems Analyst
> > Wilsonart International
> > 254-207-2831
> >
> > >>> "Cantieri, Cathy M." <[EMAIL PROTECTED]> 04/03/01 02:31PM >>>
> >
> >
> > I am wondering what the popular opinion is on data checking -- whether
>to
> > build referential integrity and other data checking into the database or
> > to
> > handle it in the front end application?
> >
> > I have been going along building as much referential integrity, db
> > triggers,
> > procedures, views to secure the data in th

RE: Query question

[Jordi Sanmarti]

I presume, your query is running out of indexes. Run the explain plan and
check if Oracle performs any full scan into a table.
Then, create an index for that particular case. If for any reason, Oracle
doesn't use the index created, apply a hint ( /+ /) into your SQL, meaning
that your going to force the engine to use it as a part of your execution
plan.

If the above still without working, I suggest to check your query, you might
be able to reformulate your query by analyzing the product Cartesian that
would return to you.

HTH,
Jordi

-Original Message-
From:   Mukesh Ghildiyal [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, April 05, 2001 02:26 PM
To: Multiple recipients of list ORACLE-L
Subject:Query question

Hello gurus
please help

I am running following query
This takes forever to complete.

select pay.gl_date from
noetix_sys.noetix_current_period off
  2  ,gl.gl_sets_of_books sob, gl.gl_periods per,
  3  ar.ar_payment_schedules_all pay
  4  where
  5  pay.gl_date between per.start_date and
per.end_date
  6  and per.period_set_name||'' =sob.period_set_name
  7  and per.period_type = sob.accounted_period_type
  8  and sob.set_of_books_id=26
  9  and off.application_id=222
 10  and off.period_type=sob.accounted_period_type
 11* and off.set_of_books_id=26

Now if I takeout following line 

and off.period_type=sob.accounted_period_type

it works

the column  "off.period_type" and 
"sob.acoount_period_type" are both not null
varchar2(15)  type.

Could anybody has some idea, why its doing that.

thank you very much


Please help

mcg

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mukesh Ghildiyal
  INET: [EMAIL PROTECTED]

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

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

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

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

[Norwood Bradly A]

Title: FW: Dependent objects



A 
couple of them here...
 
http://www.timonions.com
-Original Message-From: Yttri, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 3:46 
PMTo: Multiple recipients of list ORACLE-LSubject: FW: 
Dependent objects
Hi - 
Does anyone have (or know where I can find) a script to identify 
dependencies on a table?  When we make table modifications, we would like 
to be able to run a script that recursively identifies dependent objects.  
We pulled one from Metalink, but it doesn't seem to work.
Thanks - Lisa 

RE: OT RE: Oracle being scalable

[Mohan, Ross]

Title: RE: OT RE: Oracle being scalable





> Inquiring minds want to know! 
You must not be very inquisitive. :>)


||  No, I just know for a fact they don't write or run the world's largest databases, 
so . 


You should check out their website. http://wintercorp.com/


||  already haveit's a marketing shell.


List of sponsers: EMC; HP; IBM; Informix; Microsoft; NCR; NetGenesis; Oracle; Sun; Sybase. 


||  Yes, "sponsors" provide free food and drinks for the marketing boys, and.



List of program partners: Amdahl; Bull Information Sys.; Computer Associates; CCA; Data General; Compaq; Gemstone; Hitachi Data Systems; HOPS; Objectivity; Object Design; O2; Quantum; Seagate; SGI; Software AG; Symbios; Unisys.

||  ...partners provide hardware support for deals on advertising.


Here's a quote from the site: 
"SBC Communications, Inc. (www.sbc.com), with a database size of 10.5 TB, was the largest site in the program and led all entrants in the category of Decision Support Systems (DSS), Database Size, All Platforms... A five-time Grand Prize winner in this year's program, SBC uses NCR Corporation database management system and server products and an LSI Logic Storage Systems, Inc. storage solution." 

NCwho?


||  NCR. They make a unix, too. Or used to. NCRUnix. It had a perl-driven optimizer script for running
database servers. Pretty innovative. Surprise McNealy hasn't "discovered" it and put it on Solaris, yet.
I think they stopped supporting it and are focusing on their Teradata systems. They are ALOT faster and bigger.


Here another:
"Winter Corporation announced today that two Microsoft Corporation customers have won Grand Prizes in Database Scalability Program 2000. Among the winners are LifeMinders, Inc., an online direct marketing firm based in Herndon, Va., and Inmar Technology Solutions, Inc., an e-business solutions provider headquartered in Winston-Salem, N.C. LifeMinders, which utilizes Microsoft's SQL Server for DBMS, a Dell Corporation server and an EMC Corporation storage solution, led all NT-based decision support systems in number of rows/records. Inmar, which partners with Microsoft for SQL Server DBMS and IBM for server and storage support, led all NT-based decision support systems in peak workload."

||  So, could Microsoft win in a category MOST RECORDS ON UNIX?  Could DB2, which runs fastest on mainframes ( AFAIK ) win in a category MOST TRANSACTIONS ON UNIX?.

There are SO MANY SPECIAL CATEGORIES, that "EVERYBODY IS A WINNER".  It's like a kids' birthday party, where the hired clown gives everyone a free balloon toy. LOL!

"Oracle! Winner of Most Records in an Oracle Database!!!"


WOW!



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross
Sent: Thursday, April 05, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
Subject: OT RE: Oracle being scalable



LoL! The "Winter Corporation"? Which databases were included?


The Olympics one that IBM did on DB2?
The Terraserver database?
The SETI one?
2500 Transactions per second is the fastest they did? A conservative
estimate of page hits per second ( "transaction" ) for a web site
i know of is 8400/second. 


:-) Oh, yea, and How much did Oracle pay Winter for the objective evaluation?


Inquiring minds want to know! :-D
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle being scalable



> -Original Message- 
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] 
> 
> Have you seen this? 
> 
> http://www.oracle.com/ip/deploy/database/featurestory/index.ht 
> ml?wintergrp.h 
> tml 



Interesting. For those of you who haven't read the article, it says that a survey made by the Winter Corporation showed that the top 10 OLTP databases on UNIX in the following categories: "Most Data", "Highest Workload", "Most Rows/Records" were all Oracle databases.

Does anyone know of similar surveys on other platforms? In particular Windows NT / Windows 2000? 
And how about on the Sinclair, the Tandy, and the Commoder PET? :) 

What does _allow_read_only_corruption do?

[Tom Pall (E-mail)]

Yes,

I know it's a hidden parameter that should only be used at the advice
of counsel and Oracle Support.

But has anyone used it?  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall (E-mail)
  INET: [EMAIL PROTECTED]

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

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

help - ora-12560

[Wendy Y]

DBAs: There might have some one post before, but I can't recall the answer now.
We have completely gone through oracle 8.1.6 installation on window 2000 server. When we run net8 configure assistant, The computer frozen. Then we have to cancel it but listener.ora has been configured. When we use database assistant to create database, we got this problem. We tried many times, all were same. Could anyone point out what's the problem.Thank you so much. 
 WendyDo You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: why is there dinosaur statues and evolution of human concious

[Eric D. Pierce]

dude-

oh, that's right!

here is the short version:

   "i'm sick of all these pissy people that don't
have anything better to do than repeat the
same old boring, trivial, predictable complaints 
about Bill Gates when they could be repeating
more interesting, informative, educational ones."


is that better? probably not! :0

ep


On 5 Apr 2001, at 13:20, Adams, Matthew wrote:


> I've said it before and I'll say it again.  
> 
> Eric, you have entirely too much free time on your
> hands. ;)


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

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

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

[Hillman, Alex]

What is the problem to write something like 
Select * from  for all tables that you need or if there are too
many such tables - create a new table with names of the tables and use
dynamic SQL .

Alex Hillman

-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 05, 2001 5:28 PM
To: Multiple recipients of list ORACLE-L
Subject:tirggers

Hi Intelligent DBA's
I was wondering if anyone knows how to create a trigger that
would fire off
at database startup time and run a script to do full table scans on
several
tables to get them into the buffer cache keep pool?  Right now I do
it
manually and would like to automate the task.

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

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

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

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

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

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

8.1.6 vs 8.1.7

[Jordi Sanmarti]

Hello,

I was wondering how stable the Oracle 8i release 3 is. We plan to move our
DB in production to the latest version.
Has anybody had problems migrating it? I was told by colleges that release 2
looks more stable than the other. How true is that?

Any comments ?

Thanks in advance,
Jordi

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

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

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

[Mohan, Ross]

Title: RE: why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again



Keep it up, EP. I 
read every word. 
 
Even understand 
most of them! 

  -Original Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 5:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  why is there dinosaur statues and evolution of human 
  concious
  I've said it before and I'll say it again.  
  Eric, you have entirely too much free time on your 
  hands. ;) 
   Matt Adams - GE Appliances - 
  [EMAIL PROTECTED] Doing linear scans over an 
  associative array is like   trying to club 
  someone to death with a loaded Uzi.  
  - Larry Wall (creator of Perl) 
  > -Original Message- > 
  From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 5:00 PM > To: Multiple recipients of list ORACLE-L > Subject: why is there dinosaur statues and evolution of 
  human > conciousness / RE: OT : Sinclair was RE: 
  Metalink Again > > 
  > > On 5 Apr 2001, at 
  11:01, David Messer wrote: > > Date sent:  
    Thu, 05 Apr 2001 11:01:26 -0800 
  > 
  To: 
    Multiple recipients of list ORACLE-L 
  > <[EMAIL PROTECTED]> > > > But, Eric, I'm not out to prove 
  anything.  > > 
  Never said you were. > > 
  By "proof" I meant when two competing pieces of "factual" information 
  > (or references to such) are posted to a public 
  list, then questions > can, and perhaps ought to, 
  be raised as to the veracity/legitimacy of > the 
  sources of the information, and the nature of the "truth claims" 
  > represented by the different perspectives in the 
  argument. > > 
  > >I'm only trying to show Gates in 
  > > the worst light possible.  My desire to do so 
  derives from > working day in > > and day out with Microsoft products. > > > I'm not 
  exactly a fan of Gates/MS, and don't consider myself in > opposition to your main point, but I would suggest that if one has 
  to > lie, deceive, or misrepresent in order to make 
  the point, then one is > potentially exposing 
  oneself to valid criticisms about a lack of > 
  ethical consistency, and beyond that, the general efficacy of such 
  > tactics. > 
  > For background on tendencies toward dysfunctional 
  (self-defeating) > nature of "social change" 
  paradigms (and related tendencies toward > 
  ideological/political oppositionality), I would suggest reading Rabbi 
  > Michael Lerner's book "Surplus Powerlessness" 
  (related commentary at > http://www.tikkun.org/). > > As I've said before, I think the 
  sociological backdrop to the debate > about MS has 
  to do with the conflicts in the value systems and "world > views" of: > > >  1) the (old time) industrial 
  strength technical/engineering "purists" > 
  > and > >  2) the "populists", unfortunately including Gates, that 
  weren't > afraid to do the 
  messy job involved in taking the technology to > the masses (cheaply). > > > These 
  "opposites" are obviously an oversimplified representation of > the extreme ends of a spectrum containing more complex elements, 
  and > also mirror pre-existing elements in broader 
  scientific, technical > and business 
  "subcultures". > > I 
  think that part of the reason that the tech elites and "purists" 
  > may hate Gates so much is because they realized, 
  to late, that they > lost a great opportunity make 
  a lot of money in the mass market > because of the 
  limitations that their "purist" engineering/tech > 
  aesthetic placed on their entreprenurial vision & reach. In the era 
  > when "big iron" and extremely expensive software 
  reigned supreme, the > "purist" aesthetic proved to 
  be very successful, but it wasn't > universally 
  competitive once the feasibility of a "mass market" > approach emerged. > > Ironically, the value systems of tech purists tend to align with 
  > libertarianism (which I personally think is 
  virtuous, at least when > seen from the perspective 
  of a > 
  progressive/integrative/univeralist/constructivist evolutionary model 
  > of human conciousness based on the emergence of 
  > transformational/transcendent archetypes, such as 
  Ken Wilber's), > whereas PC technology essentially 
  originally came from the great > state sponsored 
  "establishmentarian" science and technology > 
  development efforts in the space program and defense establishment. 
  > > > On the other hand, as various people have pointed out, I could be 
  > completely full of cr*p. :) > > > 
  (apologies in advance to the old timers for duplication of info) 
  > > regards, > ep > > 
  > -- > Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce 
  >   INET: [EMAIL PROTECTED] > > Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051 
  > San Diego, 
  California    -- Public Internet access 
  / Mailing Lists > 
  -

Moving Intell. Agent Ports?

[David A. Owens]

Anyone have any luck in reassigning the dbsnmp 
process to use different port numbers than the default 1748 and 1754?  

 
The setup:
 
OMS and OEM 2.2 install on NT 
box, -->  Ora 8.1.6 w/ Intell Agent installed on AIX
 
The unix box has 3rd party apps that do not 
allow ports 1748 and 1754 open but instead I have listed in the snmp_rw.ora file 
on unix:
 
dbsnmp.address=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=new_port_number))) 
dbsnmp.spawnaddress=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=another_port_number))) 

I bounced the Agent and did:
 
netstat -an | grep 11900
netstat -an | grep 11910
 
add the Agent was listening!  Fine.  I go 
to the Windoze NT box and do:
 
tnsping 
(ADDRESS=(PROTOCOL=TCP)(PORT=11900)(HOST=MTW2))
 
It comes back with < 300ms
 
I fire up OEM Console and try to discover the 
unix box.
 
But all I get is VNI-4044  (failed to 
discover).  I added the above line to snmp_rw.ora on the NT box but no 
good result.  There must be a way to configure the OMS to 
communicate with the IAgent on the non-standard port numbers.  I can't 
believe these ports are hardcoded are they?
 
   David Owens    
<[EMAIL PROTECTED]>   
Certified Oracle DBA   (603) 635-8770
 
 

RE: killing a thread

[Helmut Daiminger]

Hi!

ORAKILL is only available on Windows NT/2000. Because Oracle uses a thread
based architecture on Windows and all threads run within the same
"oracle.exe".

On UNIX, Oracle is process based and you can kill the corresponding process.


hth,
Helmut


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais
> Sent: Thursday, April 05, 2001 02:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: killing a thread
>
>
> I can't find it either.  Is the script you meant?
>
> $ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl
>
> >>> [EMAIL PROTECTED] 04/05/01 12:16PM >>>
> I didn't see this in my $ORACLE_HOME/bin.  Is this platform specific?
>
> -Original Message-
> Sent: Thursday, April 05, 2001 1:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
>  There is a utility called orakill, this will kill the
> session. U can find
> the executable in $ORACLE_HOME/bin directory. This is very
> useful utility.
>
> Try it.
> --
>
> On Wed, 04 Apr 2001 12:36:08
>  Kevin Kostyszyn wrote:
> >did you try alter system kill session immediate?
> >
> >-Original Message-
> >Eric
> >Sent: Wednesday, April 04, 2001 3:11 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Is there a way to kill (other than kill session) a thread
> that is doing an
> >insert - nologging?
> >
> >I have tried "alter system kill session" to no avail.  It
> gives me the
> >message
> >"marked for kill" but the process continues to hang.
> >
> >The process has a row exclusive lock with a lock type of
> TM(dml).  There
> are
> >no rows in the table that is being inserted into.
> >
> >Any ideas?
> >
> >Thanks,
> >Eric
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Chesebro, Eric
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access /
> Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Kevin Kostyszyn
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access /
> Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
>
>
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: C.S.Venkata Subramanian
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>

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

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

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

RE: failed to extent to the next

[Jacques Kilchoer]

Title: RE: failed  to extent to the next





> -Original Message-
> From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
> 
> I used to use this script detect the tablespace fail to 
> extent to the next
> and sent email to me everyday. It works fine. However, the 
> other dba think
> next extent is not good enough to get quick responds since we 
> have so much
> volume transactions going on. He want to detect the 
> tablespace can't extent
> to the  next 12 extents. I tried couple ways, (bytes * 12) 
> but that result
> not 100% correct. Thanks in advance if someone can share your ideas.


What do you mean by "not 100% correct"? How do you know? Have you considered the pct_increase factor for the next_extent?

RE: OT RE: Oracle being scalable

[Steve Orr]

Title: RE: Oracle being scalable



> Inquiring minds 
want to know! 
You must not be very 
inquisitive. :>)
You should check out their website. http://wintercorp.com/
 
List of sponsers: EMC; HP; IBM; Informix; Microsoft; 
NCR; NetGenesis; Oracle; Sun; Sybase. 
 
List of program partners: Amdahl; Bull Information 
Sys.; Computer Associates; CCA; Data General; Compaq; Gemstone; Hitachi Data 
Systems; HOPS; Objectivity; Object Design; O2; Quantum; Seagate; SGI; Software 
AG; Symbios; Unisys.
 
Here's a quote from the site: 
"SBC Communications, Inc. (www.sbc.com), with a 
database size of 10.5 TB, was the largest site in the program and led all 
entrants in the category of Decision Support Systems (DSS), Database Size, All 
Platforms... A five-time Grand Prize winner in this year's program, SBC uses NCR 
Corporation database management system and server products and an LSI Logic 
Storage Systems, Inc. storage solution." 
 
NCwho?
 
Here another:
"Winter Corporation announced today that two Microsoft 
Corporation customers have won Grand Prizes in Database Scalability Program 
2000. Among the winners are LifeMinders, Inc., an online direct marketing firm 
based in Herndon, Va., and Inmar Technology Solutions, Inc., an e-business 
solutions provider headquartered in Winston-Salem, N.C. LifeMinders, which 
utilizes Microsoft’s SQL Server for DBMS, a Dell Corporation server and an EMC 
Corporation storage solution, led all NT-based decision support systems in 
number of rows/records. Inmar, which partners with Microsoft for SQL Server DBMS 
and IBM for server and storage support, led all NT-based decision support 
systems in peak workload."
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Thursday, April 05, 2001 12:35 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT RE: Oracle being scalable
  LoL! The "Winter 
  Corporation"? Which databases were included?
   
  The Olympics one 
  that IBM did on DB2?
  The Terraserver 
  database?
  The SETI 
  one?
  2500 Transactions 
  per second is the fastest they did? A 
  conservative
  estimate of page 
  hits per second ( "transaction" ) for a web site
  i know of is 
  8400/second. 
   
  :-) Oh, yea, and 
  How much did Oracle pay Winter for the objective 
  evaluation?
   
  Inquiring minds 
  want to know! :-D
  
-Original Message-From: Jacques Kilchoer 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
2:41 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Oracle being scalable
> -Original Message- > 
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] 
> > Have you seen 
this? > > http://www.oracle.com/ip/deploy/database/featurestory/index.ht 
> ml?wintergrp.h > tml 

Interesting. For those of you who haven't read the article, 
it says that a survey made by the Winter Corporation showed that the top 10 
OLTP databases on UNIX in the following categories: "Most Data", "Highest 
Workload", "Most Rows/Records" were all Oracle databases.
Does anyone know of similar surveys on other platforms? In 
particular Windows NT / Windows 2000? 
And how about on the Sinclair, the Tandy, and the Commoder 
PET? :) 

OT off topic: MetaStink

[Kevin Kostyszyn]

Hi all,
I was just complaining about metastink outloud and my boss heard me.  He
laughed out loud, props to Ross, and then showed me an article he wrote.  I
figured some of you would be interested in reading it.  For those of you who
know Dr.Paul Dorsey you will be surprised, he is usually so soft spoken and
never bashes on anybody:)
http://www.nyoug.org/presdent.htm

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

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

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

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

RE: Dependent objects

[Glenn Travis]

Here's a good script I use;

rem user_dep_obj.sql
rem Object Dependency Listing

set numwidth 3
set wrap on
set verify off
set recsep off
set feedback off
set space 2
set newpage 0
set pagesize 58
set linesize 80
set tab off

accept object_name prompt "Enter the name of the Object: "

break on today
column today new_value _DATE
select to_char(sysdate, 'mm/dd/yy') today
from dual;

clear breaks

ttitle left '&&object_name..dependencies.lis '  right 'Printed: ' _DATE skip
1 -
   center 'Dependencies Listing' skip 1 -
center 'For Object: &&object_name' skip 2;

btitle skip 2 center 'Page ' SQL.PNO

break on r_name skip 1

column r_name format a80
column name   format a80
column r_link format a80

set heading off

spool &&object_name..dependencies.lis

select   decode(referenced_type, 'NON-EXISTENT', '.', referenced_type)
 || ' ' || referenced_owner || '.' || referenced_name r_name,
 'is referenced by: ' || type || ' ' || name name,
 'Referenced Link: ' || decode(referenced_link_name, null,
'none',
 referenced_link_name) r_link
from user_dependencies
where referenced_name like upper('&&object_name%')
order by 1,2;

spool off
prompt
prompt
prompt * Output in &&object_name..dependencies.lis *
prompt
prompt
quit

-Original Message-
Sent: Thursday, April 05, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L


Hi -
Does anyone have (or know where I can find) a script to identify
dependencies on a table?  When we make table modifications, we would like to
be able to run a script that recursively identifies dependent objects.  We
pulled one from Metalink, but it doesn't seem to work.
Thanks -
Lisa

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

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

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

[Adams, Matthew (GEA, 088130)]

Title: RE: why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again





I've said it before and I'll say it again.  


Eric, you have entirely too much free time on your
hands. ;)



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)



> -Original Message-
> From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 5:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: why is there dinosaur statues and evolution of human
> conciousness / RE: OT : Sinclair was RE: Metalink Again
> 
> 
> 
> On 5 Apr 2001, at 11:01, David Messer wrote:
> 
> Date sent:    Thu, 05 Apr 2001 11:01:26 -0800
> To:   Multiple recipients of list ORACLE-L 
> <[EMAIL PROTECTED]>
> 
> > But, Eric, I'm not out to prove anything.  
> 
> Never said you were. 
> 
> By "proof" I meant when two competing pieces of "factual" information 
> (or references to such) are posted to a public list, then questions 
> can, and perhaps ought to, be raised as to the veracity/legitimacy of 
> the sources of the information, and the nature of the "truth claims" 
> represented by the different perspectives in the argument.
> 
> 
> >I'm only trying to show Gates in
> > the worst light possible.  My desire to do so derives from 
> working day in
> > and day out with Microsoft products.
> 
> 
> I'm not exactly a fan of Gates/MS, and don't consider myself in 
> opposition to your main point, but I would suggest that if one has to 
> lie, deceive, or misrepresent in order to make the point, then one is 
> potentially exposing oneself to valid criticisms about a lack of 
> ethical consistency, and beyond that, the general efficacy of such 
> tactics.
> 
> For background on tendencies toward dysfunctional (self-defeating) 
> nature of "social change" paradigms (and related tendencies toward 
> ideological/political oppositionality), I would suggest reading Rabbi 
> Michael Lerner's book "Surplus Powerlessness" (related commentary at 
> http://www.tikkun.org/).
> 
> As I've said before, I think the sociological backdrop to the debate 
> about MS has to do with the conflicts in the value systems and "world 
> views" of:
> 
> 
>  1) the (old time) industrial strength technical/engineering "purists"
> 
> and 
> 
>  2) the "populists", unfortunately including Gates, that weren't
> afraid to do the messy job involved in taking the technology to
> the masses (cheaply).
> 
> 
> These "opposites" are obviously an oversimplified representation of 
> the extreme ends of a spectrum containing more complex elements, and 
> also mirror pre-existing elements in broader scientific, technical 
> and business "subcultures".
> 
> I think that part of the reason that the tech elites and "purists" 
> may hate Gates so much is because they realized, to late, that they 
> lost a great opportunity make a lot of money in the mass market 
> because of the limitations that their "purist" engineering/tech 
> aesthetic placed on their entreprenurial vision & reach. In the era 
> when "big iron" and extremely expensive software reigned supreme, the 
> "purist" aesthetic proved to be very successful, but it wasn't 
> universally competitive once the feasibility of a "mass market" 
> approach emerged.
> 
> Ironically, the value systems of tech purists tend to align with 
> libertarianism (which I personally think is virtuous, at least when 
> seen from the perspective of a 
> progressive/integrative/univeralist/constructivist evolutionary model 
> of human conciousness based on the emergence of 
> transformational/transcendent archetypes, such as Ken Wilber's), 
> whereas PC technology essentially originally came from the great 
> state sponsored "establishmentarian" science and technology 
> development efforts in the space program and defense establishment.
> 
> 
> On the other hand, as various people have pointed out, I could be 
> completely full of cr*p. :)
> 
> 
> (apologies in advance to the old timers for duplication of info)
> 
> regards,
> ep
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

tirggers

[Kevin Kostyszyn]

Hi Intelligent DBA's
I was wondering if anyone knows how to create a trigger that would fire off
at database startup time and run a script to do full table scans on several
tables to get them into the buffer cache keep pool?  Right now I do it
manually and would like to automate the task.

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

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

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

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

Re: Oracle start/stop scripts on AIX

[Gene Sais]

AIX 4.3.3 listing below.  All the directories are empty.  The rc script appears to 
follow the linux world, local startup stuff.  Guess I am stuck w/ the IBM way :).

sp2f1n05:/etc/rc.d>ls -alr
total 88
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc9.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc8.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc7.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc6.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc5.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc4.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc3.d
drwxr-xr-x   2 root system   512 Mar 21 17:43 rc2.d
-r-xr--r--   1 root system  1564 Mar 20 10:59 rc


>>> [EMAIL PROTECTED] 04/05/01 04:06PM >>>

I have worked on 4.3.3 AIX boxes recently, and none
had /etc/rc.d installed.

Jared

On Wed, 4 Apr 2001, Ram Kumar wrote:

> AIX had started using the /etc/rc.d setup since 4.3.3.
> I think AIX 5L may incorporate most of the UNIX/LINUX generic
> features missing from its previous versions.
>
> Ram
>
>
>  Date: Mon, 2 Apr 2001 10:02:17 -0700 (PDT)
>
> On Mon, 2 Apr 2001, Raghu Kota wrote:
>
> >AIX has same startup and shudwon scripts like Solaris.
>
> No, it doesn't.  On Solaris you will find the familiar
> /etc/rc.d setup.  AIX does not use this, but rather
> relies exclusively on inittab and a single klunky
> shell script.
>
> Jared
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Ram Kumar
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


Jared Still
[EMAIL PROTECTED] 


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

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

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

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

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

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

Re: Oracle start/stop scripts on AIX

[Gene Sais]

Yes, I just upgraded to AIX 4.3.3 from 4.3.2.  They are there, however there are no 
symbolic links to the rc#.d directories.  Leads me to believe that IBM is getting 
ready.  So far I don't think IBM's shutdown & startup scripts use the rc.d scripts.  I 
will research further.

>>> [EMAIL PROTECTED] 04/05/01 04:06PM >>>

I have worked on 4.3.3 AIX boxes recently, and none
had /etc/rc.d installed.

Jared

On Wed, 4 Apr 2001, Ram Kumar wrote:

> AIX had started using the /etc/rc.d setup since 4.3.3.
> I think AIX 5L may incorporate most of the UNIX/LINUX generic
> features missing from its previous versions.
>
> Ram
>
>
>  Date: Mon, 2 Apr 2001 10:02:17 -0700 (PDT)
>
> On Mon, 2 Apr 2001, Raghu Kota wrote:
>
> >AIX has same startup and shudwon scripts like Solaris.
>
> No, it doesn't.  On Solaris you will find the familiar
> /etc/rc.d setup.  AIX does not use this, but rather
> relies exclusively on inittab and a single klunky
> shell script.
>
> Jared
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Ram Kumar
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


Jared Still
[EMAIL PROTECTED] 


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

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

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

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

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

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

RE: killing a thread

[Gene Sais]

I can't find it either.  Is the script you meant?

$ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl

>>> [EMAIL PROTECTED] 04/05/01 12:16PM >>>
I didn't see this in my $ORACLE_HOME/bin.  Is this platform specific?

-Original Message-
Sent: Thursday, April 05, 2001 1:00 AM
To: Multiple recipients of list ORACLE-L


 There is a utility called orakill, this will kill the session. U can find
the executable in $ORACLE_HOME/bin directory. This is very useful utility.

Try it.
--

On Wed, 04 Apr 2001 12:36:08  
 Kevin Kostyszyn wrote:
>did you try alter system kill session immediate?
>
>-Original Message-
>Eric
>Sent: Wednesday, April 04, 2001 3:11 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there a way to kill (other than kill session) a thread that is doing an
>insert - nologging?
>
>I have tried "alter system kill session" to no avail.  It gives me the
>message
>"marked for kill" but the process continues to hang.
>
>The process has a row exclusive lock with a lock type of TM(dml).  There
are
>no rows in the table that is being inserted into.
>
>Any ideas?
>
>Thanks,
>Eric
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Chesebro, Eric
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>-- 
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

failed to extent to the next

[Joan Hsieh]

Hi Listers,

I used to use this script detect the tablespace fail to extent to the next
and sent email to me everyday. It works fine. However, the other dba think
next extent is not good enough to get quick responds since we have so much
volume transactions going on. He want to detect the tablespace can't extent
to the  next 12 extents. I tried couple ways, (bytes * 12) but that result
not 100% correct. Thanks in advance if someone can share your ideas.

Joan

SELECT seg.owner
  ,seg.segment_name
  ,seg.segment_type  SEG_TYPE
  ,seg.tablespace_name
  ,t.next_extent
  ,max(f.bytes) largest_space
  ,count(f.bytes) num_free
FROM   sys.dba_segments seg
  ,sys.dba_tables   t
  ,sys.dba_free_space f
WHERE  seg.segment_type = 'TABLE'
ANDseg.segment_name = t.table_name
ANDseg.owner= t.owner
ANDt.tablespace_name = f.tablespace_name
ANDNOT EXISTS
   (select tablespace_name
from   dba_free_space free
where  free.tablespace_name = t.tablespace_name
andbytes   >= t.next_extent)
GROUP BY  seg.owner
 ,seg.segment_name
 ,seg.segment_type
 ,seg.tablespace_name
 ,t.next_extent
UNION
SELECT seg.owner
  ,seg.segment_name
  ,seg.segment_type SEG_TYPE
  ,seg.tablespace_name
  ,DECODE (seg.segment_type,'CLUSTER',c.next_extent)
  ,max(f.bytes) largest_space
  ,count(f.bytes) num_free
FROM   sys.dba_segments seg
  ,sys.dba_clusters c
  ,sys.dba_free_space f
WHERE  seg.segment_type = 'CLUSTER'
ANDseg.segment_name = c.cluster_name
ANDseg.owner= c.owner
ANDc.tablespace_name = f.tablespace_name
ANDNOT EXISTS
(select tablespace_name
 from   dba_free_space free
 where  free.tablespace_name = c.tablespace_name
 andbytes   >= c.next_extent)
GROUP BY  seg.owner
 ,seg.segment_name
 ,seg.segment_type
 ,seg.tablespace_name
 ,c.next_extent
UNION
SELECT seg.owner
  ,seg.segment_name
  ,seg.segment_type
  ,seg.tablespace_name
  ,DECODE (seg.segment_type,'INDEX',i.next_extent)
  ,max(f.bytes) largest_space
  ,count(f.bytes) num_free
FROM   sys.dba_segments seg
  ,sys.dba_indexes  i
  ,sys.dba_free_space f
WHERE  seg.segment_type = 'INDEX'
ANDseg.segment_name = i.index_name
ANDseg.owner= i.owner
ANDi.tablespace_name = f.tablespace_name
ANDNOT EXISTS
(select tablespace_name
 from   dba_free_space free
 where  free.tablespace_name = i.tablespace_name
 andbytes   >= i.next_extent)
GROUP BY  seg.owner
 ,seg.segment_name
 ,seg.segment_type
 ,seg.tablespace_name
 ,i.next_extent

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

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

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

why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again

[Eric D. Pierce]

On 5 Apr 2001, at 11:01, David Messer wrote:

Date sent:  Thu, 05 Apr 2001 11:01:26 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> But, Eric, I'm not out to prove anything.  

Never said you were. 

By "proof" I meant when two competing pieces of "factual" information 
(or references to such) are posted to a public list, then questions 
can, and perhaps ought to, be raised as to the veracity/legitimacy of 
the sources of the information, and the nature of the "truth claims" 
represented by the different perspectives in the argument.


>I'm only trying to show Gates in
> the worst light possible.  My desire to do so derives from working day in
> and day out with Microsoft products.


I'm not exactly a fan of Gates/MS, and don't consider myself in 
opposition to your main point, but I would suggest that if one has to 
lie, deceive, or misrepresent in order to make the point, then one is 
potentially exposing oneself to valid criticisms about a lack of 
ethical consistency, and beyond that, the general efficacy of such 
tactics.

For background on tendencies toward dysfunctional (self-defeating) 
nature of "social change" paradigms (and related tendencies toward 
ideological/political oppositionality), I would suggest reading Rabbi 
Michael Lerner's book "Surplus Powerlessness" (related commentary at 
http://www.tikkun.org/).

As I've said before, I think the sociological backdrop to the debate 
about MS has to do with the conflicts in the value systems and "world 
views" of:


 1) the (old time) industrial strength technical/engineering "purists"

and 

 2) the "populists", unfortunately including Gates, that weren't
afraid to do the messy job involved in taking the technology to
the masses (cheaply).


These "opposites" are obviously an oversimplified representation of 
the extreme ends of a spectrum containing more complex elements, and 
also mirror pre-existing elements in broader scientific, technical 
and business "subcultures".

I think that part of the reason that the tech elites and "purists" 
may hate Gates so much is because they realized, to late, that they 
lost a great opportunity make a lot of money in the mass market 
because of the limitations that their "purist" engineering/tech 
aesthetic placed on their entreprenurial vision & reach. In the era 
when "big iron" and extremely expensive software reigned supreme, the 
"purist" aesthetic proved to be very successful, but it wasn't 
universally competitive once the feasibility of a "mass market" 
approach emerged.

Ironically, the value systems of tech purists tend to align with 
libertarianism (which I personally think is virtuous, at least when 
seen from the perspective of a 
progressive/integrative/univeralist/constructivist evolutionary model 
of human conciousness based on the emergence of 
transformational/transcendent archetypes, such as Ken Wilber's), 
whereas PC technology essentially originally came from the great 
state sponsored "establishmentarian" science and technology 
development efforts in the space program and defense establishment.


On the other hand, as various people have pointed out, I could be 
completely full of cr*p. :)


(apologies in advance to the old timers for duplication of info)

regards,
ep


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

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

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

FW: Dependent objects

[Yttri, Lisa]

Title: FW: Dependent objects





Hi -


Does anyone have (or know where I can find) a script to identify dependencies on a table?  When we make table modifications, we would like to be able to run a script that recursively identifies dependent objects.  We pulled one from Metalink, but it doesn't seem to work.

Thanks -
Lisa

RE: Query question

[Bala, Prakash]

Mukesh, did you check the explain plan for both queries?

-Original Message-
Sent: Thursday, April 05, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Hello gurus
please help

I am running following query
This takes forever to complete.

select pay.gl_date from
noetix_sys.noetix_current_period off
  2  ,gl.gl_sets_of_books sob, gl.gl_periods per,
  3  ar.ar_payment_schedules_all pay
  4  where
  5  pay.gl_date between per.start_date and
per.end_date
  6  and per.period_set_name||'' =sob.period_set_name
  7  and per.period_type = sob.accounted_period_type
  8  and sob.set_of_books_id=26
  9  and off.application_id=222
 10  and off.period_type=sob.accounted_period_type
 11* and off.set_of_books_id=26

Now if I takeout following line 

and off.period_type=sob.accounted_period_type

it works

the column  "off.period_type" and 
"sob.acoount_period_type" are both not null
varchar2(15)  type.

Could anybody has some idea, why its doing that.

thank you very much


Please help

mcg

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mukesh Ghildiyal
  INET: [EMAIL PROTECTED]

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

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

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

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

[jkstill]

I have worked on 4.3.3 AIX boxes recently, and none
had /etc/rc.d installed.

Jared

On Wed, 4 Apr 2001, Ram Kumar wrote:

> AIX had started using the /etc/rc.d setup since 4.3.3.
> I think AIX 5L may incorporate most of the UNIX/LINUX generic
> features missing from its previous versions.
>
> Ram
>
>
>  Date: Mon, 2 Apr 2001 10:02:17 -0700 (PDT)
>
> On Mon, 2 Apr 2001, Raghu Kota wrote:
>
> >AIX has same startup and shudwon scripts like Solaris.
>
> No, it doesn't.  On Solaris you will find the familiar
> /etc/rc.d setup.  AIX does not use this, but rather
> relies exclusively on inittab and a single klunky
> shell script.
>
> Jared
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ram Kumar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


Jared Still
[EMAIL PROTECTED]


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

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

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

RE: Query question

[Jacques Kilchoer]

Title: RE: Query question





> -Original Message-
> From: Mukesh Ghildiyal [mailto:[EMAIL PROTECTED]]
> 
> I am running following query
> This takes forever to complete.
> 
> select pay.gl_date from
> noetix_sys.noetix_current_period off
>   2  ,gl.gl_sets_of_books sob, gl.gl_periods per,
>   3  ar.ar_payment_schedules_all pay
>   4  where
>   5  pay.gl_date between per.start_date and
> per.end_date
>   6  and per.period_set_name||'' =sob.period_set_name
>   7  and per.period_type = sob.accounted_period_type
>   8  and sob.set_of_books_id=26
>   9  and off.application_id=222
>  10  and off.period_type=sob.accounted_period_type
>  11* and off.set_of_books_id=26
> 
> Now if I takeout following line 
> 
> and off.period_type=sob.accounted_period_type
> 
> it works
> 
> the column  "off.period_type" and 
> "sob.acoount_period_type" are both not null
> varchar2(15)  type.
> 
> Could anybody has some idea, why its doing that.



Have you looked at the "explain plan" for the two queries? If not, you should probably do so.

Re: killing a thread

[Terry Ball]

I don't see an orakill in the $ORACLE_HOME/bin directory for either AIX
or SUN at 8.1.6.  Are you sure?

Terry

Vadim Gorbounov wrote:

>  Hi, It WAS for windows until 8.1.x, i believe. There is a kill in
> UNIX, no need for special utility. How to use:select spid from
> v$process, v$session where paddr=addr and sid = ;then orakill
>  thread will terminate...HTHVadim GorbounovOracle DBA
>
>  -Original Message-
>  From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
>  Sent: Thursday, April 05, 2001 12:57 PM
>  To: Multiple recipients of list ORACLE-L
>  Subject: RE: killing a thread
>
>  I thought that was only for windows machines?  Anyway, how
>  do you use it?Kev
>
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>   Behalf Of Koivu, Lisa
>   Sent: Thursday, April 05, 2001 12:17 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: killing a thread
>
>   I didn't see this in my $ORACLE_HOME/bin.  Is this
>   platform specific?
>
>   -Original Message-
>   From: C.S.Venkata Subramanian
>   [mailto:[EMAIL PROTECTED]]
>   Sent: Thursday, April 05, 2001 1:00 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: killing a thread
>
>There is a utility called orakill, this will kill
>   the session. U can find the executable in
>   $ORACLE_HOME/bin directory. This is very useful
>   utility.
>
>   Try it.
>   --
>
>   On Wed, 04 Apr 2001 12:36:08
>Kevin Kostyszyn wrote:
>   >did you try alter system kill session immediate?
>   >
>   >-Original Message-
>   >Eric
>   >Sent: Wednesday, April 04, 2001 3:11 PM
>   >To: Multiple recipients of list ORACLE-L
>   >
>   >
>   >Is there a way to kill (other than kill session)
>   a thread that is doing an
>   >insert - nologging?
>   >
>   >I have tried "alter system kill session" to no
>   avail.  It gives me the
>   >message
>   >"marked for kill" but the process continues to
>   hang.
>   >
>   >The process has a row exclusive lock with a lock
>   type of TM(dml).  There are
>   >no rows in the table that is being inserted into.
>
>   >
>   >Any ideas?
>   >
>   >Thanks,
>   >Eric
>   >--
>   >Please see the official ORACLE-L FAQ:
>   http://www.orafaq.com
>   >--
>   >Author: Chesebro, Eric
>   >  INET: [EMAIL PROTECTED]
>   >
>   >Fat City Network Services-- (858) 538-5051
>   FAX: (858) 538-5051
>   >San Diego, California-- Public Internet
>   access / Mailing Lists
>
>   
>
>   >To REMOVE yourself from this mailing list, send
>   an E-Mail message
>   >to: [EMAIL PROTECTED] (note EXACT spelling of
>   'ListGuru') and in
>   >the message BODY, include a line containing:
>   UNSUB ORACLE-L
>   >(or the name of mailing list you want to be
>   removed from).  You may
>   >also send the HELP command for other information
>   (like subscribing).
>   >
>   >--
>   >Please see the official ORACLE-L FAQ:
>   http://www.orafaq.com
>   >--
>   >Author: Kevin Kostyszyn
>   >  INET: [EMAIL PROTECTED]
>   >
>   >Fat City Network Services-- (858) 538-5051
>   FAX: (858) 538-5051
>   >San Diego, California-- Public Internet
>   access / Mailing Lists
>
>   
>
>   >To REMOVE yourself from this mailing list, send
>   an E-Mail message
>   >to: [EMAIL PROTECTED] (note EXACT spelling of
>   'ListGuru') and in
>   >the message BODY, include a line containing:
>   UNSUB ORACLE-L
>   >(or the name of mailing list you want to be
>   removed from).  You may
>   >also send the HELP command for other information
>   (like subscribing).
>   >
>
>   Get 250 color business cards for FREE! at Lycos
>   Mail
>
>   ttp://mail.lycos.com/freemail/vistaprint_index.html
>
>   --
>   Please see the official ORACLE-L FAQ:
>   http://www.orafaq.com
>   --
>   Author: C.S.Venkata Subramanian
> INET: [EMAIL PROTECTED]
>
>   Fat City Network Services-- (858) 538-5051
>   FAX: (858) 538-5051
>   San Diego, California-- Public Internet
>   access / Mailing Lists
>
>   ---

RE: OT RE: Select won't work for view create

[Kevin Kostyszyn]

Yeah 
but it makes you look so cool, smooth and important!!!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Thursday, April 05, 2001 3:12 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT RE: Select won't work for view 
  create
  Yea 
  right!  Someone in the office of our new parent company had too much time 
  on his hands...
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:47 
PMTo: Multiple recipients of list ORACLE-LSubject: OT 
RE: Select won't work for view create
Yea, I noticed 
that. 
 
Lisa musta gotta 
raise. 
 
(congrats!)

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Select won't work for view create
  Now that is one fancy signature!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: Select won't work for view 
create
Hi Dan, 
 
are you referencing public synonyms in your 
statement? 
 



  
  

  
  
  Lisa 
  Rutland KoivuOracle 
  Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, 
  #G104
  Ft. 
  Lauderdale, FL 33319
  Phone: 
  954.484.3191
  Fax: 
  954.484.2933
  www.neom.comwww.paperclick.comwww.qode.com
  

  

   
  
  
  

  

   
   
 

  -Original Message-From: Dasko, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 
  2001 12:36 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Select won't work for view 
  create
  I have a select that works fine.  
  However, it doesn't work fine when I try to create a view of the 
  result set.  There is nothing particularly fancy about the query, 
  just a plethora of outer joins from the main table to the secondary 
  tables.  I get an error back about one of the tables not 
  existing, but like I said, it works as a select, just not as a create 
  view as ... 
   
  FWIW Oracle 8.0.6 on 
DG-UX
   
  Dan

OT RE: Oracle being scalable

[Mohan, Ross]

Title: RE: Oracle being scalable



LoL! The "Winter 
Corporation"? Which databases were included?
 
The Olympics one 
that IBM did on DB2?
The Terraserver 
database?
The SETI 
one?
2500 Transactions 
per second is the fastest they did? A 
conservative
estimate of page 
hits per second ( "transaction" ) for a web site
i know of is 
8400/second. 
 
:-) Oh, yea, and 
How much did Oracle pay Winter for the objective evaluation?
 
Inquiring minds 
want to know! :-D

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
  2:41 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle being scalable
  > -Original Message- > 
  From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] 
  > > Have you seen this? 
  > > http://www.oracle.com/ip/deploy/database/featurestory/index.ht 
  > ml?wintergrp.h > tml 
  
  Interesting. For those of you who haven't read the article, it 
  says that a survey made by the Winter Corporation showed that the top 10 OLTP 
  databases on UNIX in the following categories: "Most Data", "Highest 
  Workload", "Most Rows/Records" were all Oracle databases.
  Does anyone know of similar surveys on other platforms? In 
  particular Windows NT / Windows 2000? 
  And how about on the Sinclair, the Tandy, and the Commoder 
  PET? :) 

Re: Re: Re: bFILES & Recovery Manager

[Cyril Thankappan]

hi

thanx
- Original Message --
[EMAIL PROTECTED] wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:[EMAIL PROTECTED]
Date:Wed, 04 Apr 2001 13:24:12 -0800
Subject:Re: Re: bFILES & Recovery Manager 


On 4 Apr 2001, Cyril  Thankappan wrote:

> Hello!
>
>  Does recovery MANAGER support bfiles?
>   if so any idea when Oracle plans to support them?
>
>  THanx
>

I don't know, but I doubt it.

Jared


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

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

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

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




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

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

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

Query question

[Mukesh Ghildiyal]

Hello gurus
please help

I am running following query
This takes forever to complete.

select pay.gl_date from
noetix_sys.noetix_current_period off
  2  ,gl.gl_sets_of_books sob, gl.gl_periods per,
  3  ar.ar_payment_schedules_all pay
  4  where
  5  pay.gl_date between per.start_date and
per.end_date
  6  and per.period_set_name||'' =sob.period_set_name
  7  and per.period_type = sob.accounted_period_type
  8  and sob.set_of_books_id=26
  9  and off.application_id=222
 10  and off.period_type=sob.accounted_period_type
 11* and off.set_of_books_id=26

Now if I takeout following line 

and off.period_type=sob.accounted_period_type

it works

the column  "off.period_type" and 
"sob.acoount_period_type" are both not null
varchar2(15)  type.

Could anybody has some idea, why its doing that.

thank you very much


Please help

mcg

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mukesh Ghildiyal
  INET: [EMAIL PROTECTED]

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

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

skipping the java.sh step in database create

[Ben Poels]

Hi,

If you are not using anything to do with Java is it then
safe to skip running the java.sh script that dbassist
creates during database creation in Oracle 8.1.7?
This step takes forever and uses a lot of System tablespace.


Ben Poels
Queen's University
Kingston, Ontario

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

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

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

Re: SQL QUERY HELP

[Allan Davis Sahadeo]

Try this.

select empcode, empname, sal, 
decode(to_char(trunc((nvl(sal,0)+1)/5001)),'0','A','B') NewCol
from emp 
/

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 1:40 PM


> Hi Gurus
> I have following data in table emp
> empcode  empname   SAL
> a001 X 2000
> b001 Y 4000
> c001 A 5000
> d001 C 8000
> If sal is >=5000 there will be another columns grade and print A else B
> The outout would be like
> empcode  empname   SALGrade
> a001 X 2000B
> b001 Y 4000B
> c001 A 5000A
> d001 C 8000A
> Please help how can i write such query.
> Thanks
> -Seema
> 
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: SQL QUERY HELP

[Jacques Kilchoer]

Title: RE: SQL QUERY HELP 





> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
> 
> I have following data in table emp
> empcode  empname   SAL
> a001 X 2000
> b001 Y 4000
> c001 A 5000
> d001 C 8000
> If sal is >=5000 there will be another columns grade and 
> print A else B
> The outout would be like
> empcode  empname   SAL    Grade
> a001 X 2000    B
> b001 Y 4000    B
> c001 A 5000    A
> d001 C 8000    A
> Please help how can i write such query.



SQL> select sal, decode (sign (sal - 5000), 0, 'A', 1, 'A', 'B') as grade
  2  from t ;


   SAL G
-- -
  4000 B
  5000 A
  6000 A


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: OT RE: Select won't work for view create

[Koivu, Lisa]

Yea 
right!  Someone in the office of our new parent company had too much time 
on his hands...

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:47 
  PMTo: Multiple recipients of list ORACLE-LSubject: OT 
  RE: Select won't work for view create
  Yea, I noticed 
  that. 
   
  Lisa musta gotta 
  raise. 
   
  (congrats!)
  
-Original Message-From: Kevin Kostyszyn 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Select won't work for view create
Now that is one fancy signature!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Select won't work for view 
  create
  Hi Dan, 
   
  are you referencing public synonyms in your 
  statement? 
   
  
  
  


  


Lisa 
Rutland KoivuOracle 
Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104
Ft. 
Lauderdale, FL 33319
Phone: 
954.484.3191
Fax: 
954.484.2933
www.neom.comwww.paperclick.comwww.qode.com

  

  
 



  

  
 
 
   
  
-Original Message-From: Dasko, Dan 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
12:36 PMTo: Multiple recipients of list 
ORACLE-LSubject: Select won't work for view 
create
I have a select that works fine.  However, 
it doesn't work fine when I try to create a view of the result 
set.  There is nothing particularly fancy about the query, just a 
plethora of outer joins from the main table to the secondary 
tables.  I get an error back about one of the tables not existing, 
but like I said, it works as a select, just not as a create view as 
... 
 
FWIW Oracle 8.0.6 on DG-UX
 
Dan

RE: OT : Sinclair was RE: Metalink Again

[David Messer]

But, Eric, I'm not out to prove anything.  I'm only trying to show Gates in
the worst light possible.  My desire to do so derives from working day in
and day out with Microsoft products.

Regards,
DM

-Original Message-
Pierce
Sent: Thursday, April 05, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L



On 5 Apr 2001, at 9:47, David Messer wrote:

> Sounds like denial after the fact to me.  If you believe these quotes:

That is certainly a possibility, but not "proven". The site
you cite obviously is not a bona fide journalistic/historical/research
site, and the content would easily fail any fair standard
for objectivity, much less an academic one, for legitimate
research presentation/methods.

>
> http://www.geocities.com/SiliconValley/Vista/8009/bill.gates.quotes.html
>
> it's easy to think he changes his tune allot.

That is the impression I also get. but that doesn't strictly
"disprove" the veracity of the claim on the other site that
the "640 k" quote is an urban legend.

In addition, it is quite possible that the "640 k" quote, if
seen in the larger context of what Gates was talking about
at the time, isn't quite as silly as it looks on a surface
level, and is probably not much more silly than what most
other computer industry "leaders" were saying.

when I put "640k gates" ito www.google.com, there were
several sites that came up that gave a lot of historical
detail, including references to what other people in the
early PC industry said, many in the main "hobby" magazines
such as Byte/etc about the potential longevity of various
architectures and so forth, and there were obviously just as
many amateurs trying to pass themselves off as experts in
order to make money duping the public as is the case now
days. They just had't refined the technique as much.

I personally wouldn't want to write off the level of Gates'
evil to anything as trivial as the "640 k"quote, it deserves
much deeper and more prudent consideration. :)

regards,
ep


>
> -Original Message-
> Pierce
> Sent: Wednesday, April 04, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> according to the following, the "640k" quote is an urban legend:
>
>   http://www.urbanlegends.com/celebrities/bill.gates/gates_memory.html

...


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

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

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


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

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

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

[Dasko, Dan]

Title: RE: Select won't work for view create



That 
was the problem.  Thanks.
 
Dan

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
  2:31 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Select won't work for view create
  >-Original Message- >From: Dasko, Dan [mailto:[EMAIL PROTECTED]] 
  > >I have a select that works 
  fine.  However, it doesn't > work fine when I 
  try to create a view of the result set. > There is 
  nothing particularly fancy about the query, just >a 
  plethora of outer joins from the main table to the secondary tables. 
  > I get an error back about one of the tables not 
  existing, but like I >said, it works as a select, 
  just not as a create view as ... > >FWIW Oracle 8.0.6 on DG-UX 
  To create a view, access to the table has to be granted 
  directly, not via a role. Have you checked for that? 
  If you have access via a role, you would be able to 
  select, but not create view. See example below. 
  
  SQL> -- CREATING USER X SQL> 
  create user x identified by x default tablespace users temporary 
  tablespace temp ; User 
  created. SQL> grant create session, create table to 
  x ; Grant succeeded. SQL> 
  alter user x quota unlimited on users ; User 
  altered. 
  SQL> -- CREATING USER Y SQL> 
  create user y identified by y default tablespace users temporary 
  tablespace temp ; User 
  created. SQL> grant create session, create view to 
  y ; Grant succeeded. SQL> 
  create role fory ; Role created. SQL> grant fory to y; Grant 
  succeeded. 
  SQL> -- X CREATES TABLES SQL> -- 
  Y WILL HAVE ACCESS TO T1 DIRECTLY SQL> -- Y WILL 
  HAVE ACCESS TO T2 VIA ROLE SQL> connect x/x@ 
  Connected. SQL> create table t1 (n 
  number, d date) ; Table created. SQL> create table t2 (n number, v varchar2 (30)) ; Table created. SQL> grant select on t1 to y 
  ; Grant succeeded. SQL> 
  grant select on t2 to fory ; Grant succeeded. 
  
  SQL> -- Y CREATES VIEWS SQL> -- 
  Y IS ABLE TO CREATE A VIEW ON T1 BUT NOT ON T2 SQL> 
  -- Y CAN SELECT ON T2 SQL> connect 
  y/y@jrktest Connected. SQL> 
  create view v1 as select n, d from x.t1 ; View 
  created. SQL> create view v2 as   2  select a.n, a.d, b.v   
  3  from x.t1 a, x.t2 b   4  where a.n = 
  b.n ; from x.t1 a, x.t2 b    
  * ERROR at line 3: ORA-00942: 
  table or view does not exist SQL> select * from 
  x.t2 ; no rows selected 
  -- Jacques R. Kilchoer 
  (949) 754-8816 Quest Software, 
  Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. 
  http://www.quest.com 
  _This 
  e-mail message has been scanned for the presence of all known computer viruses 
  by the MessageLabs Virus Control Center. However, it is still recommended that 
  you use local virus scanning software to monitor for the presence of viruses. 
  

RE: OT : Sinclair was RE: Metalink Again

[Jacques Kilchoer]

Title: RE: OT : Sinclair was RE: Metalink Again





> -Original Message-
> From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> > it's easy to think he changes his tune allot.
> 
> That is the impression I also get. but that doesn't strictly 
> "disprove" the veracity of the claim on the other site that
> the "640 k" quote is an urban legend.



You can say that again about Bill Gates changing his tune a lot! I never got the $1000 he was supposed to send me after I forwarded his e-mail to 1000 people. :(

RE: avoiding ora-1652 on temp tablespace

[Scott . Shafer]

Start running explain plan for your queries.  Sounds like you have a
cartesian product somewhere in the code...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Seley, Linda [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:41 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  avoiding ora-1652 on temp tablespace
> 
> We recently released a new version of our software and suddenly we're
> blowing out our temp tablespace.  The previous version never complained at
> 1000m.  The new version is choking on 2500m.  I don't want to keep adding
> space, although that's the conventional wisdom.  I want to find the query
> or queries that are being pigs and get the developers to fix 'em!  
>  
> By the time I get notification that there's been an ora-1652 I can't find
> much info in the system.  All of the currently running queries are small,
> we only have 20 users connected at any time, v$sort_usage is empty, and
> v$sort_segment shows one segment taking the full 2500m.  I also can't turn
> on tracing, these 20 users are persistent and trace files will fill up in
> no time.  Our entire database is VERY small, only about 60m!  
>  
> Any advice on how to catch these queries?  The ora-1652 errors are
> occuring about a week apart so it isn't practical for me to personally
> babysit the database. 
>  
> Thanks!
>  
> Linda
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle being scalable

[Jacques Kilchoer]

Title: RE: Oracle being scalable





> -Original Message-
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> 
> Have you seen this?
> 
> http://www.oracle.com/ip/deploy/database/featurestory/index.ht
> ml?wintergrp.h
> tml



Interesting. For those of you who haven't read the article, it says that a survey made by the Winter Corporation showed that the top 10 OLTP databases on UNIX in the following categories: "Most Data", "Highest Workload", "Most Rows/Records" were all Oracle databases.

Does anyone know of similar surveys on other platforms? In particular Windows NT / Windows 2000?


And how about on the Sinclair, the Tandy, and the Commoder PET? :)

RE: Oracle being scalable

[Glasrot, Nechama]

thank you ... i finally got it

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


-Original Message-
Sent: Thursday, April 05, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L


The e-mail system chopped up the link, you have to edit it and put the tml
back in... unless the page has actually disappeared...  You can also get to
it from the www.oracle.com main page, it's one of the links.

Pat.

> -Original Message-
> From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 1:12 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Oracle being scalable
> 
> that page has been moved ... colour me surprised!
> 
> Nechama Glasrot
> Oracle DBA
> Seisint, Inc.
> 6601 Park of Commerce Blvd. 
> Boca Raton, Florida 33487 
> nglasrot @seisint.com   
> Direct 561.999.3977
> Main 561.999.4400
> Fax 561.999.4695
>  
> 
> 
> -Original Message-
> Sent: Thursday, April 05, 2001 11:27 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Have you seen this?
> 
> http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp
> .h
> tml
> 
> Regards,
> 
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> This transmission may contain information that is privileged, confidential
> and exempt from disclosure under applicable law.
> If you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the information contained
> herein (including any reliance thereon) is STRICTLY PROHIBITED.
> If you received this transmission in error, please immediately contact the
> sender and destroy the material in its entirety, whether in electronic or
> hard copy format.
> Thank you
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Glasrot, Nechama
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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


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


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

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

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

RE: Select won't work for view create

[Jacques Kilchoer]

Title: RE: Select won't work for view create





>-Original Message-
>From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
>
>I have a select that works fine.  However, it doesn't
> work fine when I try to create a view of the result set. 
> There is nothing particularly fancy about the query, just 
>a plethora of outer joins from the main table to the secondary tables. 
> I get an error back about one of the tables not existing, but like I 
>said, it works as a select, just not as a create view as ... 
> 
>FWIW Oracle 8.0.6 on DG-UX



To create a view, access to the table has to be granted directly, not via a
role. Have you checked for that? If you have access via a role, you would be
able to select, but not create view.
See example below.


SQL> -- CREATING USER X
SQL> create user x identified by x default tablespace users temporary
tablespace temp ;
User created.
SQL> grant create session, create table to x ;
Grant succeeded.
SQL> alter user x quota unlimited on users ;
User altered.


SQL> -- CREATING USER Y
SQL> create user y identified by y default tablespace users temporary
tablespace temp ;
User created.
SQL> grant create session, create view to y ;
Grant succeeded.
SQL> create role fory ;
Role created.
SQL> grant fory to y;
Grant succeeded.


SQL> -- X CREATES TABLES
SQL> -- Y WILL HAVE ACCESS TO T1 DIRECTLY
SQL> -- Y WILL HAVE ACCESS TO T2 VIA ROLE
SQL> connect x/x@
Connected.
SQL> create table t1 (n number, d date) ;
Table created.
SQL> create table t2 (n number, v varchar2 (30)) ;
Table created.
SQL> grant select on t1 to y ;
Grant succeeded.
SQL> grant select on t2 to fory ;
Grant succeeded.



SQL> -- Y CREATES VIEWS
SQL> -- Y IS ABLE TO CREATE A VIEW ON T1 BUT NOT ON T2
SQL> -- Y CAN SELECT ON T2
SQL> connect y/y@jrktest
Connected.
SQL> create view v1 as select n, d from x.t1 ;
View created.
SQL> create view v2 as
  2  select a.n, a.d, b.v
  3  from x.t1 a, x.t2 b
  4  where a.n = b.n ;
from x.t1 a, x.t2 b
   *
ERROR at line 3:
ORA-00942: table or view does not exist 
SQL> select * from x.t2 ;
no rows selected


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

avoiding ora-1652 on temp tablespace

[Seley, Linda]

We 
recently released a new version of our software and suddenly we're blowing out 
our temp tablespace.  The previous version never complained at 
1000m.  The new version is choking on 2500m.  I don't want to keep 
adding space, although that's the conventional wisdom.  I want to find the 
query or queries that are being pigs and get the developers to fix 'em!  

 
By the 
time I get notification that there's been an ora-1652 I can't find much 
info in the system.  All of the currently running queries are small, we 
only have 20 users connected at any time, v$sort_usage is empty, and 
v$sort_segment shows one segment taking the full 2500m.  I also can't turn 
on tracing, these 20 users are persistent and trace files will fill up in no 
time.  Our entire database is VERY small, only about 60m!  

 
Any 
advice on how to catch these queries?  The ora-1652 errors are occuring 
about a week apart so it isn't practical for me to personally babysit the 
database. 
 
Thanks!
 
Linda

RE: killing a thread

[Vadim Gorbounov]

Title: RE: killing a thread



Hi, 

 
It WAS 
for windows until 8.1.x, i believe. There is a kill in UNIX, no need for special 
utility. How to use:
 
select 
spid from v$process, v$session where paddr=addr and sid = 
;
 
then 

 
orakill  
 
thread 
will terminate...
 
HTH
Vadim 
Gorbounov
Oracle 
DBA
 
 

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 12:57 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  killing a thread
  I 
  thought that was only for windows machines?  Anyway, how do you use 
  it?
  Kev
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
Thursday, April 05, 2001 12:17 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: killing a thread
I didn't see this in my $ORACLE_HOME/bin.  Is this 
platform specific? 
-Original Message- From: 
C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, April 05, 2001 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: killing a thread 
 There is a utility called orakill, this will kill the 
session. U can find the executable in $ORACLE_HOME/bin directory. This is 
very useful utility.
Try it. -- 
On Wed, 04 Apr 2001 12:36:08   Kevin Kostyszyn wrote: >did you try 
alter system kill session immediate? > 
>-Original Message- >Eric >Sent: Wednesday, April 04, 2001 
3:11 PM >To: Multiple recipients of list 
ORACLE-L > > 
>Is there a way to kill (other than kill session) a 
thread that is doing an >insert - 
nologging? > >I have 
tried "alter system kill session" to no avail.  It gives me the 
>message >"marked for kill" 
but the process continues to hang. > 
>The process has a row exclusive lock with a lock type 
of TM(dml).  There are >no rows in the table 
that is being inserted into. > >Any ideas? > >Thanks, >Eric >-- >Please see the official ORACLE-L 
FAQ: http://www.orafaq.com >-- >Author: Chesebro, Eric 
>  INET: [EMAIL PROTECTED] > >Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051 >San Diego, 
California    -- Public Internet 
access / Mailing Lists > 
>To REMOVE yourself from this mailing list, send an 
E-Mail message >to: [EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in >the message 
BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from).  
You may >also send the HELP command for other 
information (like subscribing). > 
>-- >Please see the official 
ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kevin Kostyszyn 
>  INET: [EMAIL PROTECTED] > >Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051 >San Diego, 
California    -- Public Internet 
access / Mailing Lists > 
>To REMOVE yourself from this mailing list, send an 
E-Mail message >to: [EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in >the message 
BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from).  
You may >also send the HELP command for other 
information (like subscribing). > 
Get 250 color business cards for FREE! at Lycos Mail 
http://mail.lycos.com/freemail/vistaprint_index.html 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet 
access / Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the 
name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like 
subscribing). 

RE: OT : Sinclair was RE: Metalink Again

[Eric D. Pierce]

On 5 Apr 2001, at 9:47, David Messer wrote:

> Sounds like denial after the fact to me.  If you believe these quotes:

That is certainly a possibility, but not "proven". The site 
you cite obviously is not a bona fide journalistic/historical/research
site, and the content would easily fail any fair standard 
for objectivity, much less an academic one, for legitimate 
research presentation/methods.

> 
> http://www.geocities.com/SiliconValley/Vista/8009/bill.gates.quotes.html
> 
> it's easy to think he changes his tune allot.

That is the impression I also get. but that doesn't strictly 
"disprove" the veracity of the claim on the other site that
the "640 k" quote is an urban legend.

In addition, it is quite possible that the "640 k" quote, if
seen in the larger context of what Gates was talking about 
at the time, isn't quite as silly as it looks on a surface 
level, and is probably not much more silly than what most
other computer industry "leaders" were saying. 

when I put "640k gates" ito www.google.com, there were
several sites that came up that gave a lot of historical
detail, including references to what other people in the 
early PC industry said, many in the main "hobby" magazines
such as Byte/etc about the potential longevity of various
architectures and so forth, and there were obviously just as
many amateurs trying to pass themselves off as experts in
order to make money duping the public as is the case now 
days. They just had't refined the technique as much.

I personally wouldn't want to write off the level of Gates'
evil to anything as trivial as the "640 k"quote, it deserves
much deeper and more prudent consideration. :)

regards,
ep


> 
> -Original Message-
> Pierce
> Sent: Wednesday, April 04, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> according to the following, the "640k" quote is an urban legend:
> 
>   http://www.urbanlegends.com/celebrities/bill.gates/gates_memory.html

...


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

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

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

OT RE: Select won't work for view create

[Mohan, Ross]

Yea, I noticed that. 

 
Lisa musta gotta 
raise. 
 
(congrats!)

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Select won't work for view create
  Now 
  that is one fancy signature!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Select won't work for view 
create
Hi 
Dan, 
 
are you referencing public synonyms in your 
statement? 
 



  
  

  
  
  Lisa 
  Rutland KoivuOracle 
  Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104
  Ft. 
  Lauderdale, FL 33319
  Phone: 
  954.484.3191
  Fax: 
  954.484.2933
  www.neom.comwww.paperclick.comwww.qode.com
  

  

   
  
  
  

  

   
   
 

  -Original Message-From: Dasko, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
  12:36 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Select won't work for view 
  create
  I have a select that works fine.  However, 
  it doesn't work fine when I try to create a view of the result set.  
  There is nothing particularly fancy about the query, just a plethora of 
  outer joins from the main table to the secondary tables.  I get an 
  error back about one of the tables not existing, but like I said, it works 
  as a select, just not as a create view as ... 
   
  FWIW Oracle 8.0.6 on DG-UX
   
  Dan

RE: What kind of date format?

[CC Harvest]

Prakash,
   Thanks for the email. I think I will have to try 
to create one varchar2 field, then drop it after the
data loaded.

Thanks,

Chris

--- "Bala, Prakash" <[EMAIL PROTECTED]> wrote:
> Chris,
> 
> Since Oracle cannot handle milliseconds, one of my
> colleaque wrote a stored
> procedure to manipulate the date and then dump the
> sybase data into a flat
> file and used sqlldr to load into Oracle. 
> 
> Another solution will be load this date into a
> varchar2 column and use a
> combination of substr and to_date to ignore the
> milliseconds. Will that
> work?
> 
> Prakash
> 
> -Original Message-
> Sent: Wednesday, April 04, 2001 9:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I used bcp to get the database from a sybase
> database,
> and plan to load the data back to Oracle. The only
> problem is that I got the following defualt date
> format from Sybase:
> Apr  3 2001 10:29:47:000AM
> 
> What's the corresponding date format in Oracle?
> ('Mon  dd  hh:mi:ss:???AM')
> 
> And did anyone migrate the database from Sybase or
> SQL
> Server to Oracle before?
> 
> Thanks,
> 
> Chris 
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: CC Harvest
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: Bala, Prakash
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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 email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

[Jack C. Applewhite]

Dan,
 
To 
create a view on a table, you must have Select granted directly to your User, 
not just via a Role, which works for Selects.
 
Maybe 
that's it.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Dasko, DanSent: 
  Thursday, April 05, 2001 11:36 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Select won't work for view 
  create
  I 
  have a select that works fine.  However, it doesn't work fine when I try 
  to create a view of the result set.  There is nothing particularly fancy 
  about the query, just a plethora of outer joins from the main table to the 
  secondary tables.  I get an error back about one of the tables not 
  existing, but like I said, it works as a select, just not as a create view as 
  ... 
   
  FWIW 
  Oracle 8.0.6 on DG-UX
   
  Dan

Re: Exp/imp into different version

[Cherie_Machler]

Connie,

Yes it is.  As a matter of fact it is part of a documented upgrade method
outline in the Server Migration Guide.

Cherie Machler
Gelco Information Network


   

Connie 

Milliken To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: Exp/imp into different version   

Sent by:   

root@fatcity.  

com

   

   

04/05/01   

11:25 AM   

Please 

respond to 

ORACLE-L   

   

   





Is is possible to take a full database export from Oracle 8.0.5/HPUX and
import it into Oracle 8.1.6/HPUX?

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

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

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



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

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

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

Rollback segments not shrinking

[Nicoll, Iain (metering)]

Can anyone tell me why we would get "unable to extend" errors in rollback
but the segments will shrink when done manually - I thought that rollback
segments would shrink when not used if another rollback segment needed the
extents.

We're way back on 7.3.4 on Solaris.

Cheers

Iain Nicoll
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (metering)
  INET: [EMAIL PROTECTED]

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

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

[Steve Orr]

With 
apologies to Oracle Corporation... 


 
Hope they don't sue me. ;-)
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin KostyszynSent: 
  Thursday, April 05, 2001 10:27 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Select won't work for view 
  create
  Now 
  that is one fancy signature!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Select won't work for view 
create
Hi 
Dan, 
 
are you referencing public synonyms in your 
statement? 
 



  
  

  
  
  Lisa 
  Rutland KoivuOracle 
  Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104
  Ft. 
  Lauderdale, FL 33319
  Phone: 
  954.484.3191
  Fax: 
  954.484.2933
  www.neom.comwww.paperclick.comwww.qode.com
  

  

   
  
  
  

  

   
   
 

  -Original Message-From: Dasko, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
  12:36 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Select won't work for view 
  create
  I have a select that works fine.  However, 
  it doesn't work fine when I try to create a view of the result set.  
  There is nothing particularly fancy about the query, just a plethora of 
  outer joins from the main table to the secondary tables.  I get an 
  error back about one of the tables not existing, but like I said, it works 
  as a select, just not as a create view as ... 
   
  FWIW Oracle 8.0.6 on DG-UX
   
  Dan
 image001.gif

SQL QUERY HELP

[Seema Singh]

Hi Gurus
I have following data in table emp
empcode  empname   SAL
a001 X 2000
b001 Y 4000
c001 A 5000
d001 C 8000
If sal is >=5000 there will be another columns grade and print A else B
The outout would be like
empcode  empname   SALGrade
a001 X 2000B
b001 Y 4000B
c001 A 5000A
d001 C 8000A
Please help how can i write such query.
Thanks
-Seema


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

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

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

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

RE: Oracle being scalable

[Paul Baumgartel]

his email formatting broke the line in two, just add the "tml" to the ".h"
and you'll get there


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Thursday, April 05, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L


Did you really mean the error page?  RBG

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 11:26 AM


> Have you seen this?
>
>
http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h
> tml
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: OT : Sinclair was RE: Metalink Again

[David Messer]

Sounds like denial after the fact to me.  If you believe these quotes:

http://www.geocities.com/SiliconValley/Vista/8009/bill.gates.quotes.html

it's easy to think he changes his tune allot.

-Original Message-
Pierce
Sent: Wednesday, April 04, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L


according to the following, the "640k" quote is an urban legend:

  http://www.urbanlegends.com/celebrities/bill.gates/gates_memory.html


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

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

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


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

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

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

Re: OT : Sinclair was RE: Metalink Again

[Terry Ball]

Actually, there is more than one.  There are at least three in Omaha, NE
along.  (Maybe more, but I don't drive by any others on a regular basis.

Terry

"Schilling, Ben" wrote:

> There is still have at least one Sinclair gas station left.  It's near the
> intersection of Interstate 90 and U.S. Highway 151 in Madison Wisconsin.
>
> -Original Message-
> Sent: Wednesday, April 04, 2001 5:27 PM
> To: Multiple recipients of list ORACLE-L
>
> I thought it was a green dinosaur on their signs,
> maybe they were just faded.
>
> 
>  Brian L. Anderson
>  Flunky/SA/DBA/DERT
>  Darton College
>  [EMAIL PROTECTED]
> 
>
> > And I thought it was an old oil company. Their gas station
> > symbol was a
> > dinosaur (not to be confused with "put a tiger in your
> > tank"). I vaguely
> > recall the Sinclair exhibit at the 1967 World's Fair, and I
> > still have a
> > blue plastic model of one of their dinosaurs.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anderson, Brian
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schilling, Ben
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Terry Ball
  INET: [EMAIL PROTECTED]

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

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

[Kevin Kostyszyn]

Now 
that is one fancy signature!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Select won't work for view 
  create
  Hi 
  Dan, 
   
  are 
  you referencing public synonyms in your statement? 
   
  
  
  


  


Lisa 
Rutland KoivuOracle 
Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104
Ft. 
Lauderdale, FL 33319
Phone: 
954.484.3191
Fax: 
954.484.2933
www.neom.comwww.paperclick.comwww.qode.com

  

  
 



  

  
 
 
   
  
-Original Message-From: Dasko, Dan 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 
12:36 PMTo: Multiple recipients of list 
ORACLE-LSubject: Select won't work for view 
create
I 
have a select that works fine.  However, it doesn't work fine when I 
try to create a view of the result set.  There is nothing particularly 
fancy about the query, just a plethora of outer joins from the main table to 
the secondary tables.  I get an error back about one of the tables not 
existing, but like I said, it works as a select, just not as a create view 
as ... 
 
FWIW Oracle 8.0.6 on DG-UX
 
Dan

RE: killing a thread

[Kevin Kostyszyn]

Title: RE: killing a thread



I 
thought that was only for windows machines?  Anyway, how do you use 
it?
Kev

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Thursday, April 05, 2001 12:17 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: killing a thread
  I didn't see this in my $ORACLE_HOME/bin.  Is this 
  platform specific? 
  -Original Message- From: 
  C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, April 05, 2001 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: killing a thread 
   There is a utility called orakill, this will kill the 
  session. U can find the executable in $ORACLE_HOME/bin directory. This is very 
  useful utility.
  Try it. -- 
  On Wed, 04 Apr 2001 12:36:08   Kevin Kostyszyn wrote: >did you try 
  alter system kill session immediate? > 
  >-Original Message- >Eric >Sent: Wednesday, April 04, 2001 
  3:11 PM >To: Multiple recipients of list 
  ORACLE-L > > 
  >Is there a way to kill (other than kill session) a thread 
  that is doing an >insert - nologging? 
  > >I have tried "alter system 
  kill session" to no avail.  It gives me the >message >"marked for kill" but the 
  process continues to hang. > >The process has a row exclusive lock with a lock type of 
  TM(dml).  There are >no rows in the table that 
  is being inserted into. > >Any ideas? > >Thanks, >Eric >-- >Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com >-- >Author: Chesebro, Eric 
  >  INET: [EMAIL PROTECTED] > >Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051 
  >San Diego, 
  California    -- Public Internet access 
  / Mailing Lists > 
  >To REMOVE yourself from this mailing list, send an E-Mail 
  message >to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in >the message BODY, 
  include a line containing: UNSUB ORACLE-L >(or the 
  name of mailing list you want to be removed from).  You may 
  >also send the HELP command for other information (like 
  subscribing). > >-- 
  >Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  >-- >Author: Kevin 
  Kostyszyn >  INET: [EMAIL PROTECTED] 
  > >Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051 
  >San Diego, 
  California    -- Public Internet access 
  / Mailing Lists > 
  >To REMOVE yourself from this mailing list, send an E-Mail 
  message >to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in >the message BODY, 
  include a line containing: UNSUB ORACLE-L >(or the 
  name of mailing list you want to be removed from).  You may 
  >also send the HELP command for other information (like 
  subscribing). > 
  Get 250 color business cards for FREE! at Lycos Mail 
  http://mail.lycos.com/freemail/vistaprint_index.html 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 
    INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: Oracle being scalable

[Anderson, Brian]

move the tml back up to the .h (wintergrp.html)
> >
> >
> http://www.oracle.com/ip/deploy/database/featurestory/index.ht
> ml?wintergrp.h
> > tml
> >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

Oracle and Support????

[Ron Rogers]

I was browsing the OTN site under the Support heading and I finally realized why the 
ITARs, Metalink, and Phone contacts are in the state they are in. They want you to 
become an "Oracle's Remote Support Services" customer and then they won't have to deal 
with the troups in the trenches
 ROR mª¿ªm

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

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

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

Re: tkprof for 10046 event

[K Gopalakrishnan]

Hi !

I have not seen any tool for formatting the wait event
stats. Steve Adams has some script in his book
(Oracle8i Internal Sevices page -16).

You can write a similar script and explore the trace
files. 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

Select won't work for view create

[Dasko, Dan]

I have 
a select that works fine.  However, it doesn't work fine when I try to 
create a view of the result set.  There is nothing particularly fancy about 
the query, just a plethora of outer joins from the main table to the secondary 
tables.  I get an error back about one of the tables not existing, but like 
I said, it works as a select, just not as a create view as 
... 
 
FWIW 
Oracle 8.0.6 on DG-UX
 
Dan

RE: Oracle being scalable

[Ed . Haskins]

When you click on the link...add 'tml'(as in ,html) to the URL...it was cut
off on the hyperlink provided!

Ed Haskins
Oracle DBA
Verizon Wireless


-Original Message-
Sent: Thursday, April 05, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L


Did you really mean the error page?  RBG

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 11:26 AM


> Have you seen this?
>
>
http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h
> tml
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: tkprof for 10046 event

[Steve Adams]

Hi Steve,

I've not checked recently, but Guy Harrison used to have one on his web site.

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


-Original Message-
Sent: Friday, 6 April 2001 1:52
To: Multiple recipients of list ORACLE-L


Hi,

When setting event 10046 at level 8 it produces a trace file with wait
events. Does anyone have a utility like tkprof which summarises the trace
file to show a summary of wait events and timings per sql statement?

Thanks,

Steve Wilkes
___
Oracle DBA
npower
email:[EMAIL PROTECTED] 

=
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
gpupower.co.uk or [EMAIL PROTECTED]

This outgoing e-mail (and any attachments) has been checked
(using Sophos Sweep 3.44 + patches) before leaving us (UK 08457 353637),
and has been found to be clean from any virus infection.

=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wilkes, 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: Steve Adams
  INET: [EMAIL PROTECTED]

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

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

Exp/imp into different version

[Connie Milliken]

Is is possible to take a full database export from Oracle 8.0.5/HPUX and
import it into Oracle 8.1.6/HPUX?

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

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

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

RE: Exp/imp into different version

[Anderson, Brian]

Sure is.


 Brian L. Anderson
 Flunky/SA/DBA/DERT
 Darton College
 [EMAIL PROTECTED]


> -Original Message-
> From: Connie Milliken [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Exp/imp into different version
> 
> 
> Is is possible to take a full database export from Oracle 
> 8.0.5/HPUX and
> import it into Oracle 8.1.6/HPUX?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Connie Milliken
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

RE: Select won't work for view create

[Koivu, Lisa]

Hi 
Dan, 
 
are 
you referencing public synonyms in your statement? 
 



  
  

  
  
  Lisa 
  Rutland KoivuOracle Database 
  Administrator[EMAIL PROTECTED]4850 N. 
  State Rd. 7, #G104
  Ft. 
  Lauderdale, FL 33319
  Phone: 
  954.484.3191
  Fax: 
  954.484.2933
  www.neom.comwww.paperclick.comwww.qode.com
  

  

   
  
  
  

  

   
   
 

  -Original Message-From: Dasko, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 12:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Select won't work for view create
  I 
  have a select that works fine.  However, it doesn't work fine when I try 
  to create a view of the result set.  There is nothing particularly fancy 
  about the query, just a plethora of outer joins from the main table to the 
  secondary tables.  I get an error back about one of the tables not 
  existing, but like I said, it works as a select, just not as a create view as 
  ... 
   
  FWIW 
  Oracle 8.0.6 on DG-UX
   
  Dan

RE: Oracle being scalable

[Boivin, Patrice J]

The e-mail system chopped up the link, you have to edit it and put the tml
back in... unless the page has actually disappeared...  You can also get to
it from the www.oracle.com main page, it's one of the links.

Pat.

> -Original Message-
> From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 1:12 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Oracle being scalable
> 
> that page has been moved ... colour me surprised!
> 
> Nechama Glasrot
> Oracle DBA
> Seisint, Inc.
> 6601 Park of Commerce Blvd. 
> Boca Raton, Florida 33487 
> nglasrot @seisint.com   
> Direct 561.999.3977
> Main 561.999.4400
> Fax 561.999.4695
>  
> 
> 
> -Original Message-
> Sent: Thursday, April 05, 2001 11:27 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Have you seen this?
> 
> http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp
> .h
> tml
> 
> Regards,
> 
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> This transmission may contain information that is privileged, confidential
> and exempt from disclosure under applicable law.
> If you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the information contained
> herein (including any reliance thereon) is STRICTLY PROHIBITED.
> If you received this transmission in error, please immediately contact the
> sender and destroy the material in its entirety, whether in electronic or
> hard copy format.
> Thank you
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Glasrot, Nechama
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

Re: Select won't work for view create

[Pat Hildebrand]

> 
> I have a select that works fine.  However, it doesn't work fine when I try
> to create a view of the result set.  There is nothing particularly fancy
> about the query, just a plethora of outer joins from the main table to the
> secondary tables.  I get an error back about one of the tables not existing,
> but like I said, it works as a select, just not as a create view as ... 
>  

I had a problem like this and it turned out that it had nothing to do
with the tables. I had accidently put the file name in the create
script instead of the view name. :(


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

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

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

[Steve Orr]

no... the url got wrapped. Make sure you have ".html" on the end.

-Original Message-
Nechama
Sent: Thursday, April 05, 2001 9:12 AM
To: Multiple recipients of list ORACLE-L


that page has been moved ... colour me surprised!

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



-Original Message-
Sent: Thursday, April 05, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Have you seen this?

http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h
tml

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


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

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

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


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


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

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

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

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

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

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

[Glasrot, Nechama]

that page has been moved ... colour me surprised!

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


-Original Message-
Sent: Thursday, April 05, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Have you seen this?

http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h
tml

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


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

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

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


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


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

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

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

Re: Optimizer Question/Puzzle

[Connor McDonald]

When you've got plenty of rows on you're driving
table, then using an EXISTS clause will typically mean
an index lookup for everyone of those rows, where as
the sort-merge is overcoming that by "brute force" so
to speak...

Its also important to realise that the 'cost' figure
cannot be used ACROSS different queries.  Its used to
rank different access paths within an optimisation of
a single query. 

hth
connor

--- Surjit Sharma <[EMAIL PROTECTED]> wrote: > Hi
> 
> I have running the  following two queries. If you
> look at the first query the cost is 37181 and takes
> about 16 minutes to run on (3CPUs Aplha Tru 64
> Unix  Oracle 8.0.5) whereas the second query (cost
> 561) which I thought would have run lot faster does
> not come back as quick (in fact I killed the query
> in the end).
> 
> Both the tables are analyzed and have statistics. I
> am really puzzled about the cost opimtimizer here.
> 
> Looking for some insight from all the gurus out
> there.
> 
> 1) Takes 16 minutes ..
> update add_comp_2000 a
>set
>
household_kinship_key=decode(residents_category_key,1,1,2,4)
>where residents_category_key in (1,2)
>and address_link in  (select  address_link
> from my_temp20 b
>)
> 
> 
> UPDATE STATEMENT Optimizer=CHOOSE (Cost=37181
> Card=3395612 Bytes=118846420)
>   UPDATE OF ADD_COMP_2000
> MERGE JOIN (Cost=37181 Card=3395612
> Bytes=118846420)
>   SORT (JOIN) (Cost=11915 Card=3395612
> Bytes=74703464)
> TABLE ACCESS (FULL) OF ADD_COMP_2000
> (Cost=561 Card=3395612
> Bytes=74703464)
>   SORT (JOIN) (Cost=25266 Card=5164102
> Bytes=67133326)
> VIEW (Cost=12934 Card=5164102
> Bytes=67133326)
>   SORT (UNIQUE) (Cost=12934 Card=5164102
> Bytes=67133326)
> TABLE ACCESS (FULL) OF MY_TEMP20
> (Cost=602 Card=5164102
> Bytes=67133326)
> 
> 2)  Update add_comp_2000 a
>set
>
household_kinship_key=decode(residents_category_key,1,1,2,4)
>where residents_category_key in (1,2)
>and exists  (select  address_link from
> my_temp20 b where
> a.address_link = b.address_link
>)
> 
> UPDATE STATEMENT Optimizer=CHOOSE (Cost=561
> Card=169781 Bytes=3735182)
>   UPDATE OF ADD_COMP_2000
> FILTER
>   TABLE ACCESS (FULL) OF ADD_COMP_2000 (Cost=561
> Card=169781
> Bytes=3735182)
>   INDEX (RANGE SCAN) OF TEMP20_ADD_LINK
> (NON-UNIQUE) (Cost=1 Card=1
> Bytes=13)
> 
> Takes forever ...
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Surjit Sharma
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

[Ruth Gramolini]

Did you really mean the error page?  RBG

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 11:26 AM


> Have you seen this?
>
>
http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h
> tml
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

PCTUSED??

[Raghu Kota]

Hi Friends

I am wondering you people can give me indepth about How storage is 
manipulated in frequent inserts and occationally mass delete!! works. My 
problem here is I have 20G table with 15G Indexes!!! We deleted 98,99 data!! 
So I want to avail that deleted space. How can I do that with out Export or 
any reoraganization??? Right now Iam using 40% as PCTUSED, SO last time I 
deleted some data, I used some space from deleted rows?? Actually what space 
Iam using Is it really using from deleted according to Oracle If its 
fall below PCTUSED and blocks referencing freelist so on???BTW my version is 
7.3.4 on AIX.

I appreciate your comments very much.
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).

RE: killing a thread

[Koivu, Lisa]

Title: RE: killing a thread





I didn't see this in my $ORACLE_HOME/bin.  Is this platform specific?


-Original Message-
From: C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:00 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: killing a thread



 There is a utility called orakill, this will kill the session. U can find the executable in $ORACLE_HOME/bin directory. This is very useful utility.

Try it.
--


On Wed, 04 Apr 2001 12:36:08  
 Kevin Kostyszyn wrote:
>did you try alter system kill session immediate?
>
>-Original Message-
>Eric
>Sent: Wednesday, April 04, 2001 3:11 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there a way to kill (other than kill session) a thread that is doing an
>insert - nologging?
>
>I have tried "alter system kill session" to no avail.  It gives me the
>message
>"marked for kill" but the process continues to hang.
>
>The process has a row exclusive lock with a lock type of TM(dml).  There are
>no rows in the table that is being inserted into.
>
>Any ideas?
>
>Thanks,
>Eric
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Chesebro, Eric
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>



Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]


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

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

RE: What kind of date format?

[Bala, Prakash]

Chris,

Since Oracle cannot handle milliseconds, one of my colleaque wrote a stored
procedure to manipulate the date and then dump the sybase data into a flat
file and used sqlldr to load into Oracle. 

Another solution will be load this date into a varchar2 column and use a
combination of substr and to_date to ignore the milliseconds. Will that
work?

Prakash

-Original Message-
Sent: Wednesday, April 04, 2001 9:56 PM
To: Multiple recipients of list ORACLE-L


I used bcp to get the database from a sybase database,
and plan to load the data back to Oracle. The only
problem is that I got the following defualt date
format from Sybase:
Apr  3 2001 10:29:47:000AM

What's the corresponding date format in Oracle?
('Mon  dd  hh:mi:ss:???AM')

And did anyone migrate the database from Sybase or SQL
Server to Oracle before?

Thanks,

Chris 

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: OT : Sinclair was RE: Metalink Again

[Kevin Kostyszyn]

Sweet Minneapolis!  i did that drive once when I moved back to Jersey.  Whoa
what a drive!!

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L



Ben,
I can vouch for that one - I gassed up there last Saturday while driving
from New Jersey to Minneapolis ( a loong drive)
stayed overnight in Madison , a very nice town. Went into a little brewpub
near the capitol, E  Wilson street ?? - i forget

Brian





"Schilling, Ben" <[EMAIL PROTECTED]>@fatcity.com on 04/05/2001
09:35:27 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



There is still have at least one Sinclair gas station left.  It's near the
intersection of Interstate 90 and U.S. Highway 151 in Madison Wisconsin.

-Original Message-
Sent: Wednesday, April 04, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L


I thought it was a green dinosaur on their signs,
maybe they were just faded.


 Brian L. Anderson
 Flunky/SA/DBA/DERT
 Darton College
 [EMAIL PROTECTED]


> And I thought it was an old oil company. Their gas station
> symbol was a
> dinosaur (not to be confused with "put a tiger in your
> tank"). I vaguely
> recall the Sinclair exhibit at the 1967 World's Fair, and I
> still have a
> blue plastic model of one of their dinosaurs.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

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

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



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

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

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

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

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

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

tkprof for 10046 event

[Wilkes, Steve]

Hi,

When setting event 10046 at level 8 it produces a trace file with wait
events. Does anyone have a utility like tkprof which summarises the trace
file to show a summary of wait events and timings per sql statement?

Thanks,

Steve Wilkes
___
Oracle DBA
npower
email:[EMAIL PROTECTED] 

=
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
gpupower.co.uk or [EMAIL PROTECTED]

This outgoing e-mail (and any attachments) has been checked
(using Sophos Sweep 3.44 + patches) before leaving us (UK 08457 353637),
and has been found to be clean from any virus infection.

=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wilkes, 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: BLOB vs. B-File

[Connor McDonald]

If you're looking for a rule of thumb, I generally
work by

"Large size, small volume of files" = BFILE
"Small size, large volume of files" = BLOB

basically on the premise that databases are great for
handling large volumes of small pieces of data, and
file systems are good for a small volume of large
pieces of data

hth
connor

--- "Yttri, Lisa" <[EMAIL PROTECTED]> wrote: > Hi
everyone -
> 
> I'm looking for some information based on your
> experiences.  We have an
> application that has large objects to store.  They
> are wondering which way
> would be better - to store them as BLOBs within the
> database, or as bfiles
> outside the database.  My instincts tell me BLOBs
> would be better, but I
> have no actual facts to base this on.
> 
> Does anyone have any information or know of any
> documentation I could review
> that might help define the differences - re. coding
> programs to access the
> objects, performance, administration, etc.?
> 
> Thanks -
> Lisa
> 


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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