Index update = Delete + insert ?

[VIVEK_SHARMA]

Is an index Fields' update actually a DELETE  followed by an INSERT of the index row ?

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

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

DCMCTL Utility

[pradeep]

Hi,

Oracle 9iAS Enterprise Manager(EM) tool will return details like
Cluster Name/Instance name and the Corresponding Port number along
with the oracle 9ias Home directory name.

The above mentioned (OEM) is a GUI tool.
What My problem is i want to grep all the details (which Oracle
9iAS Enterprise Manager(OEM) returns) from the Command Prompt.

9iAS provides a tool named Distributed Configuration
Management(DCMCTL) which comes under oracle
9ias/dcm/bin/dcmctl.bat.
Using the various options of DCMCTL,it will return the certain
parameters which i want.But its not returning the port number of
the instances and the home directory name.

My Question is, Is it possible to grep the Details Which i
Want(Oracle 9iAS Instance Name,Corresponding Port Number and the
Home directory) using the DCMCTL tool or oracle provides any other
tool to meet the above mentioned problem.

Remember all these details are available if I am Using the GUI
tool,Oracle 9iAS Enterprise Manager(OEM).I want all these from the
Command Prompt.

Regards,
Pradeep

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

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

vxio:vol_maxio (Veritas) impact on Database performance ?

[VIVEK_SHARMA]

Setting of parameter vxio:vol_maxio (Veritas)

Nature of Application Database = Hybrid in Nature

Application Database undergoing MOSTLY Index Scan Operations (db file
sequential reads). The underlying OS  Call is pread64 .

Qs. Anybody has used the parameter in Production Databases ?
Qs. Is there any known Overhead/down-side with using the parameter ?
Qs. What is the impact on Database performance ?
Qs. What Value may be considered Advisable  ?
Qs. How may the same be Calculated


A SAMPLE ARTICLE FROM ORACLE METALINK :-
*
*
Unix Installation/OS: RDBMS Technical Forum
Displayed below are the messages of the selected thread.
Thread Status: Closed

RDBMS Version: 8.1.6.2
Operating System and Version: solaris 2.6
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

vxio: vol_maxio

What is the recommended setting for vol_maxio (when I am using VxVm and VxFs )
?
When I set to vol_maxio=65535 (which means 32 MB ) the querries runs very fast
. but is it  desirable to set it that high ?
How do I determine the most desirable value ?
what other impacts it might have ?
thanks
syed

-
---



It depends. vol_maxio determines the maximum size of the physical IO that
veritas layer can  handle before breaking up the IO in to multiple IO
requests. If your application uses mostly  sequential read, then the
application will benefit from using bigger vol_maxio value. But having  a
value of 32MB may not provide any benefits. maxphys kernel parameter need to
be increased to  take advantage of the bigger IO size request too. Further,
Oracle has a limit of 1MB for the max  IO size that oracle can issue(at least
in 8i releases). So, any value beyond 1MB may not provide  any benefit.

You also need to look at your disk subsystem. If you have striped disks, then
it is better to  match vol_maxio value and the stripe width. Say, if the
stripe size is 128KB with 4 disks (hence  the stripe width 512KB) then you
want to set your vol_maxio to match 512KB, but not exceeding  1MB.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

Commit boundary <-> Stripe Unit Size Co-relation

[VIVEK_SHARMA]

CASE - If Size of 1 INSERT/UPDATE Statement = 1K & Stripe Unit Size is 128 K ?

How will 1 COMMIT issued after 300 "1K" INSERT/UPDATE Statements DIFFER from 1 COMMIT 
issued after EACH "1K" INSERT/UPDATE Statement with respect to Writing to the 
datafiles on the Underlying Striped Volume ?

If 1 INSERT Statement Data is Written to the 1st Disk (say) of the Striped Volume , 
will a Repeat of the SAME INSERT Statement Write to a Different Underlying Disk of the 
same Striped Volume within the SAME Segment Extent ?

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

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

Re: Blocksize

[Arup Nanda]

It does. But unless you set up initrans and pctfree in such a way that the
block is almost empty, there will be more rows per block if the block size
is more.More rows per block = more chance that tow rows from the same block
are being contended for access = more chance of a buffer busy wait.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 10:29 AM


> That mandates proper initrans and pctfree setting, don't
> you think?
>
> > -Original Message-
> > From: Arup Nanda [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 10, 2003 11:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:
> >
> >
> > Raj,
> >
> > Another consideration is a potential for a buffer busy waits.
> > the larger the
> > block size is, the more the number of rows in an average block. Thsi
> > increases the possibility of a buffer busy wait.
> >
> > HTH.
> >
> > Arup
> >
> >
> > An 8.0.6 ops database being migrated to 9i RAC database on
> > Solaris 8. The
> > 8.0 database had an block size of 2k.  Multiblock read count
> > is 8. This is
> > an OLTP database, all transactions almost always work on a
> > single row. None
> > of the row sizes exceed the block size. Hardly any chained or migrated
> > rows. Now, during this migration, it was recommended to
> > change the block
> > size to 8k. And my concerns are:
> >
> > 1. Would this not increase pinging across the instances? With 9i and
> > interconnect and cache fusion, this should be reduced
> > considerably, so, is
> > it a mute point?
> > 2. This could alter the execution plans of some statements.
> > Would some,
> > maybe a very few of the statements not prefer a full table scan?
> >
> > Any other positive or negative effects of this increase in block size?
> >
> > Thanks
> > One Paranoid DBA
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >
> >
> > _
> > Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arup Nanda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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

Re[2]: Count(*) last 30 seconds

[Sergey Ten]

What could possibly happen is that the table experienced many
deletions followed by bulk inserts, and the value for high water mark
is way off the actual size of the data.

Once bulk insert via direct path load occurs, Oracle does not reuse
blocks in free lists, but allocates new ones instead, advancing the
value of high water mark (HWM).

After deletion the value of HWM doesn't get reset, and new batch
process that loads data advances it again. After several times of
inserting/deleting records, the number of blocks Oracle has to read
while doing full scan is much more than necessary.

It's easy to find out if that's the case. Try

  create table b as select * from a;

where "a" is the "slow" table.

After that try

  select count(*) from b;

and see how long does it take. If it happened quickly, the table "a" needs
to be reorganized.

Tuesday, February 11, 2003, 7:23:41 PM, you wrote:

HKC> Hemant
HKC> At 08:19 AM 11-02-03 -0800, you wrote:
HKC> Hi
HKC> list,
HKC>  
HKC> I issue a select count(*) from mytable and
HKC> last 30 seconds.
HKC>  
HKC> The table has 1,466,196 records and were
HKC> loaded with a batch process, so they are in a countinous
HKC> space.
HKC>  
HKC> I consider that time exagerated.
HKC>  
HKC> The TBS is LMT with a Uniform size of 128
HKC> MB.
HKC>  
HKC> The block size is 8MB, version 9.2.0.1.0 in
HKC> Windows 2000.
HKC>  
HKC> Where should I start looking ???
HKC>  
HKC> TIA
HKC>  
HKC> Ramon E. Estevez
HKC> [EMAIL PROTECTED]
HKC> 809-565-3121
HKC>  

HKC> Hemant K Chitale
HKC> My web site page is : http://hkchital.tripod.com

HKC> -- 
HKC> Please see the official ORACLE-L FAQ: http://www.orafaq.net



-- 
Best regards,
 Sergeymailto:[EMAIL PROTECTED]

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

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

Re: HISTOGRAMS , CBO and OLTP

[Murali Menon]

Thanks Connor.  That is what I understood also, however, Jonathan's mail was slightly missleading.
 Connor McDonald <[EMAIL PROTECTED]> wrote:
There is no correlation between uniqueness and"skewness". For example, you might have uniquevalues: 1,2,3,4,5,...,, and then 100Obviously that last one is an skew value. If you havepredicates on this column along the lines of:where col > ...where col < ...where col between ... and ...then a histogram might be useful, otherwise theoptimizer assumes an even distribution of valuesbetween 1 and 100hthconnor--- Murali Menon <[EMAIL PROTECTED]>wrote: > > Uniqueness indicates that there are less skewed> values correct! Under what circumstances would a> skewed column value for a unique column exist.> > Another question, what about histograms on indexes> itself? If histograms are generated on columns with> skewed values, does it matter wh!
en the indexes are> generated, before or after? Do indexes on these> columns need to be rebuilt.> > Thanks> > > > > > Jonathan Lewis <[EMAIL PROTECTED]>wrote:> > It's worth mentioning a frequently overlooked> point that even if a column has a unique > constraint (whether or not declared and/or> supported by an index) then if it has a> skewed pattern of values the optimiser> can use a histogram to optimise a queries> that target a range.> > (NB The grammar suggests that the word > "not" was intended as the last word of the > first line of (b) below).> > > Regards> > Jonathan Lewis> http://www.jlcomp.demon.co.uk> > Coming soon one-day tutorials:> Cost Based Optimisation> Trouble-shooting and Tuning> Indexing Strategies> (see http://www!
.jlcomp.demon.co.uk/tutorial.html )> > UK___March 19th> USA_(FL)_May 2nd> > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html )> > USA_(CA, TX)_August> > > The Co-operative Oracle Users' FAQ> http://www.jlcomp.demon.co.uk/faq/ind_faq.html> > > -Original Message-> To: Multiple recipients of list ORACLE-L > Date: 08 February 2003 10:44> > > >> >b) The number of distinct/duplicate values should> >really be relevant - its whether you will regularly> >need to probe a table using column values that are> >skewed in such a way as to have the optimizer make> >poor assumptions about their distribution.> >> > > -- > Please see the official ORACLE-L FAQ:> http://www.orafaq.net> -- > Autho!
r: Jonathan Lewis> INET: [EMAIL PROTECTED]> > Fat City Network Services -- 858-538-5051> http://www.fatcity.com> San Diego, California -- Mailing list and web> hosting services>-> To REMOVE yourself from this mailing list, send an> E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of> 'ListGuru') and in> the message BODY, include a line containing: UNSUB> ORACLE-L> (or the name of mailing list you want to be removed> from). You may> also send the HELP command for other information> (like subscribing).> > > > -> Do you Yahoo!?> Yahoo! Mail Plus - Powerful. Affordable. Sign up now =Connor McDonaldweb: http://www.oracledba.co.ukweb: http://www.oaktable.netemail: connor_m!
[EMAIL PROTECTED]"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?iso-8859-1?q?Connor=20McDonald?=INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day

Re: Count(*) last 30 seconds

[Hemant K Chitale]

You are doing Full-Table-Scans.
1.  What's the average row length ?  How many columns does the
table have ?
2.  How many "consistent gets" does the count(*) cause ?
[ie, how many blocks does it actually have to read ?]
3.  Are all these Physical Reads ?  Is the DB_CACHE_SIZE large
enough to hold most of the
blocks ?  What is the query-run-time if you re-run the query
immediately again ?
Hemant
At 08:19 AM 11-02-03 -0800, you wrote:
Hi
list,
 
I issue a select count(*) from mytable and
last 30 seconds.
 
The table has 1,466,196 records and were
loaded with a batch process, so they are in a countinous
space.
 
I consider that time exagerated.
 
The TBS is LMT with a Uniform size of 128
MB.
 
The block size is 8MB, version 9.2.0.1.0 in
Windows 2000.
 
Where should I start looking ???
 
TIA
 
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
 

Hemant K Chitale
My web site page is : 
http://hkchital.tripod.com


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

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

Re: dump.sql

[Arup Nanda]

Tim,

Sometimes Oracle people do put the names of the original authors on the 
MetaLink site. Way before MetaLink turned up in the internet the way it's 
now, Oracle Support used to be on a CompuServe Forum "orasupport". I used to 
contribute articles to that and they did put it up there with my name as the 
author. After the creation of MetaLink, one (only one, though) of the 
articles was put on MetaLink (Note 37906.1); and guess what, my name was 
there, with a very strict disclaimer that it was from a customer and should 
be used at the user's own risk.

In this case, I suppose the same policy could have been followed. However, 
the circumstances were different - I contributed the article on my own 
volition and in this case they lifted Jared's code. What might have 
happened, I only speculate, they assigned some "bright" support engineer to 
write the script. Instead of writing, the lazy engineer simply lifted the 
code from Jared's site and declared as his/her own. Naturally he couldn't 
have asked for Jared's permission, that would have tantamounted to admitting 
not writing it him/herself. And s/he must have been so lazy that s/he 
couldn't even rewrite the scripts.

Again, this is purely my speculation. But that's what must have happened.

Arup






From: "Tim Gorman" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: dump.sql
Date: Tue, 11 Feb 2003 13:16:57 -0800

There has been a fair amount of discussion about it - on this list, on 
other
lists, in SELECT magazine, etc.  Jared has a perfect right to be annoyed
that use has been taken but attribution was not given.  I post a bunch of
things on my website and that's all I ask, explicitly, at the top of the
page.

To be honest, I suspect that what has happened is that the matter has come
to the attention of the folks who manage MetaLink content.  They likely
queried the lawyers at Oracle about what to do, getting the response, "No
way!  Do not allow an individual's name to remain on anything in the
MetaLink Knowledge Base for any reason".  And, "By the way, do not even
communicate with the individual as that might provide basis for some sort 
of
claim or lien"...

...or some kind of surreal legalistic garbage like that...

Just my guesses, but that's probably what happens when the worlds of
"share-ware" and "capitalized intellectual property" collide.  In one 
world,
it's about bad manners and grounds for serious disrespect.  In the other
world, it's about limiting liability, potential litigation, and "no blood,
no foul; get up off the floor and keep playing"...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 10:19 AM


> Tim,
>
> Besides it is available on Metalink, accessable to those users who are
> holding valid support licence and Jared is just pointing to that
direction.
> There is nothing wrong in it as far as copyright is concerned. There is 
no
> theft involved of any sort as Jared did not claim ownership of that 
script
> either
>
> Regards
> Rafiq
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Mon, 10 Feb 2003 20:33:55 -0800
>
> This has nothing to do with copyrights, patents, reputation, or IP.  
It's
a
> script.  It was posted on the internet.  Nothing more than a case of bad
> manners.
>
> There is no disservice in not tilting at this particular windmill.  You
owe
> Jared an apology.
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, February 10, 2003 12:38 PM
>
>
>  > Hi Jared,
>  > I think a letter to the Redwood Shores police
>  > department alleging IP theft and asking them to investigate
>  > may be effective.
>  >
>  > I believe copyright in it's current business model is dead
>  > but since everyone's reputation is based on their copyrights
>  > you can not allow this theft to continue.
>  >
>  > If you do you are doing a disservice to everyone.
>  >
>  >
>  > Dave
>  >
>  > Jared wrote ...
>  > >
>  > > It may also be found at:
>  > >
>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=1050919.6
>  > >
>  > > Yes, it's back, still without credit.
>  > >
>  > > Please, no 'piracy' emails to Oracle about it.
>  > >
>  > > Jared
>  >
>  > --
>  > Dave Morgan
>  > Operations Manager, Rigskills Canada
>  > Canada's Geographical Oilfield Services Locator
>  > http://www.rigskills.ca
>  > [EMAIL PROTECTED]
>  > 403 399 2442
>  > --
>  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>  > --
>  > Author: Dave Morgan
>  >   INET: [EMAIL PROTECTED]
>  >
>  > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>  > San Diego, California-- Mailing list and web hosting services
>  > -
>  > To REMOVE yourself from 

Re: 8.1.7.4 to 9.2

[chao_ping]

Rishi.Jain,
If downtime is allowed, I would like choose exp/imp.This full reorg 
the database and you can fully utilize new features like segment management auto, 
which cannot be changed after tablespace is created.And Exp/imp is more safe than 
mig.But mig is much faster than exp/imp.





Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-02-11 12:39:00 ,you wrote£º===

>Guru's
>
>We are planning to move to 9i from 8.1.7.4 in the near future. The two
>options we are considering are
>
>a) Migration from 8.1.7 to 9.2
>b) Install 9i and then use export , import to get the data from version 8i.
>
>If my memory serves me right I remember reading an article somewhere which
>says that we could not use all the new features of 9i if we went ahead with
>the migration path.
>
>Could you please provide your inputs as to which way is better than the
>other with pros and cons of both.
>
>Thanks in advance.
>
>Rishi.
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: 
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

= = = = = = = = = = = = = = = = = = = =




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

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

Re: RE: RE: Oracle TEMPORARY SEGMENT

[chao_ping]

Whittle Jerome Contr NCI,
1.Temporary tablespace in oracle8i+ does not need coalesce, and Oracle do not 
deallocate used sort extents. This is a feature.
2.There is no pctincrease parameter in TEMPORARY tablespace.
SQL> /
 create temporary tablespace test_tmp tempfile '/home/oracle/temp.dd' size 10m default 
storage(pctincrease 0)
   *
ERROR at line 1:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE


Elapsed: 00:00:00.04


[oracle@ish3 oracle]$ sql

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 11 23:31:50 2003

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


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> alter tablespace temp default storage(pctincrease 0);
alter tablespace temp default storage(pctincrease 0)
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE






Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-02-11 08:39:00 ,you wrote£º===

>Hi,
>
>It does work on temporary (that are truly temporary and not permanent) tablespaces in 
>7.3.4 and 8.1.7. I use it when I don't want to wait for SMON to clean things up. Just 
>yesterday one our 'power users' ran SQL that selected from two tables with no join 
>between them. The resulting Cartesian set would have been over 3 billion records. The 
>same SQL also had a complex group by clause to eliminate all the duplicate records he 
>just created. It locked up after many hours because it filled the 1.2 GB TEMP 
>tablespace. I killed the process and ran my SQL to clean out the temp tablespace 
>quickly. BTW: I rewrote his SQL properly and it took less than a minute to return the 
>1036 records. 
>
>Jerry Whittle
>ASIFICS DBA
>NCI Information Systems Inc.
>[EMAIL PROTECTED]
>618-622-4145
>
>> -Original Message-
>> From:chao_ping [SMTP:[EMAIL PROTECTED]]
>> 
>> Whittle Jerome Contr NCI,
>>  I think your sql should not work on a really TEMPORARY tablespace, and 
>temporary tablespace do not need to be cleaned either.
>> 
>> Regards
>> zhu chao
>> msn:[EMAIL PROTECTED]
>> www.happyit.net
>> www.cnoug.org(China Oracle User Group)
>> 
>> === 2003-02-11 06:49:00 ,you wrote£º===
>> 
>> >Hi,
>> >
>> >This is what I use to clean up a temp tablespace. The tablespace is named 'temp' 
>and it is normally set to PCTINCREASE of 10. You will need to insert the correct 
>values for your temp tablespace. Altering the tablespace a little wakes us SMON which 
>will clean things up if it can.
>> >
>> >alter tablespace temp default storage(pctincrease 0);
>> >alter tablespace temp default storage(pctincrease 10);
>> >
>> >50Mb seems rather small for a temp tablespace.
>> >
>> >Jerry Whittle
>> >ASIFICS DBA
>> >NCI Information Systems Inc.
>> >[EMAIL PROTECTED]
>> >618-622-4145
>> >
>> >> -Original Message-
>> >> From: Zabair Ahmed [SMTP:[EMAIL PROTECTED]]
>> >> 
>> >> Is their any way of identifying which user/process is holding onto a temporary 
>segment. I've got a 50Mb temporary tablespace and there is a temporary segment which 
>is 47Mb which is not being freed up by SMON.
>> >> 
>> >> And, if i can't identify who is holding onto this TEMP segment, is their a way 
>in which I can delete it and stop the alert log being flooded with ORA-1652.
>> >> 
>> >> As I say the SMON is failing to clean up this TEMP segment and it's been 
>on-going for a number of days and I don't have the option of bouncing the database.
>> >> 
>> >> Oracle 8.1.7.3 on HP-UX 11.
>> >> 
>> >> TIA 
>> 

= = = = = = = = = = = = = = = = = = = =




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

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

Re: copyright

[Tim Gorman]

Dave,

I'm not saying that what they did is OK.  But I don't see scripts posted on
the internet as IP, plain and simple.

You referenced my script;  I posted it there purposely for people to
download and use.  On my website, I request downloaders to provide
attribution by keeping my name in the script, but I don't claim any legal
right to force them to do so.  Please notice the lack of the word
"copyright" in the script.  Removing my name from the script would simply be
bad manners and irritating to me, nothing more...

Jared had a copyright notice on the script?  I'm not a lawyer, but a
defensible copyright requires more than simply saying so, doesn't it?  Kind
of like a "no trespassing" sign on your property;  you had better have the
plattes and surveys to back your assertion of ownership in court, else you
risk countersuit.  Same with a copyright;  you have to prove that you really
wrote it, didn't copy it from someone else, etc, etc, etc.  Life is too
short for all that...

Also, I did not say that the battle was futile nor did I say that illegal
actions should not be fought.  I simply don't believe that what happened
enters the realm of litigation.  My reference to "tilting at windmills" was
not meant to convey an image of futility;  it was meant to convey someone
who is attacking misguidely, while under delusion.  I simply do not believe
that IP theft occurred here, merely bad etiquette and bad manners (which I
find far more offensive).

Further, I think that any discussion of intellectual property neccesitates
more humility.  Surely, nothing that any of us does is truly original.  I am
constantly reminded of two sayings:  "If I have seen further it is because I
stand on the shoulders of giants" and "Look, listen, and learn;  for an
original mistake is as rare as an original idea".  Intellectual property is
deeper than simply slapping the word "copyright" on everything one has
written.  There is a code of honor surrounding the use of material written
by others.  Codes of honor can be broken by anyone without honor, any minute
of any day, legally.  It is only those with that sense of honor who would
not dream of betraying that trust.  I might be naive, but I believe the
entire free software movement is based on that sense of honor.  Can you
imagine what would happen to the world if GNU suddenly demanded payment?
Not a world I want to inhabit...

I do not wish to debate this any further -- you have your view, I have mine.
End of story.

The entire reason for my response to you was not to provoke you, nor to earn
your enmity, nor to debate property law.  Rather, I was irritated that Jared
would be branded as "doing a disservice" to anyone because he did not agree
that there were bigger ramifications.  I requested an apology from you on
his behalf, and I believe you have done so.  End of story.

Peace.  Unskyld.  Back to work...

-Tim

- Original Message -
To: <[EMAIL PROTECTED]>; "Oracle RDBMS Community Forum"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 12:06 PM


> Hi Tim,
> A few thoughts,
>
> >It's a script
> - Oracle RDBMS is a bunch of scripts
> >It was posted on the internet
> - Oracle is available on the internet
>
> Does this mean I can download Oracle, place it on
> my website legally, call it notoracle and sell it?
>
> Or 
>
> I found this script on the web
>
> #!/bin/ksh
>
#===
=
> # File: oramem.sh
> # Type: UNIX korn-shell script
> # Author:   Tim Gorman, Sagelogix Inc.
> # Date: 28jun02
> #
> # Description:
> #
> #   This shell script utilizes the "pmap -x" command to total up the
> #   total amount of virtual memory used by all of the Oracle server
> #   processes (both "background" and "foreground") belonging to a
> #   database instance.
> #
> # Modifications:
> # TGorman 28jun02 written for Solaris 2.8
>
> How about if I put this on my website after I remove
> all references to yourself and SageLogix and claim to be the
> author?
>
> How about if I rewrite in bourne sh, keep all the references
> and post it?
>
> The first is definitely illegal, the second might be, (you don't
> explicitly give permission to copy the script, but accepted practise
> in the area is that attribution is enough). You will definitely be
> unhappy with the first, you might be proud you were attributed
> in the second.
>
> Some basic facts, Jared wrote it, Jared owns the copyright. The
> fact that he makes it publically available is irrelevant. Oracle is
> using his work, without attribution in a paid service. (Metalink, from
> which the page is now unavailable, gee I wonder why).
>
> A copyright is intellectual property, removal of a copyright notice
> is illegal. Consult SageLogix's lawyers, mine would have loved to
> work for Jared, would have done it on contigency basis. Bad manners
> is not an acceptable legal defence.
>
> This has everything to do

Re: 8.1.7.4 to 9.2

[Hemant K Chitale]

I created a new database in 9i and used export/import so that I could
  a.  Reorganise all the file systems / mount-points and file-naming 
convention
  b.  Create Locally Managed Tablespaces [incl SYSTEM] with Auto Allocation
and Automatic Segment Space Management

Point b. is what you would be looking for with Export/Import.

Of course, you must have enough downtime available to Export-Create-Import

Hemant

At 12:39 PM 11-02-03 -0800, you wrote:
Guru's

We are planning to move to 9i from 8.1.7.4 in the near future. The two
options we are considering are

a) Migration from 8.1.7 to 9.2
b) Install 9i and then use export , import to get the data from version 8i.

If my memory serves me right I remember reading an article somewhere which
says that we could not use all the new features of 9i if we went ahead with
the migration path.

Could you please provide your inputs as to which way is better than the
other with pros and cons of both.

Thanks in advance.

Rishi.


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

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


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

test - pls Ignore

[Basavaraja, Ravindra]

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

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

Re: How to send/receive email through pl/sql ??

[Connor McDonald]

I asumme you've tested sending email from the command
line or equivalent tool on the box using the same
settings (ie localhost,25) as your mailserver.

Cheers
Connor

 --- Janet Linsy <[EMAIL PROTECTED]> wrote: > Hi, I
have the following code. it compiles fine and
> runs successfully.  But when I checked email in
> [EMAIL PROTECTED], I didn't get any mail.  I'm testing on
> the same machine (win2000, 817).  Anybody knows why?
> 
> Thank you in advance.
> 
> 
> create or replace PROCEDURE send_test_message
> IS
> mailhostVARCHAR2(64) := 'localhost';
> sender  VARCHAR2(64) := '[EMAIL PROTECTED]';
> recipient   VARCHAR2(64) := '[EMAIL PROTECTED]';
> mail_conn  utl_smtp.connection;
> BEGIN
> mail_conn := utl_smtp.open_connection(mailhost,
> 25);
> utl_smtp.helo(mail_conn, mailhost);
> utl_smtp.mail(mail_conn, sender);
> utl_smtp.rcpt(mail_conn, recipient);
> -- If we had the message in a single string, we
> could
> collapse
> -- open_data(), write_data(), and close_data() into
> a
> single call to data().
> utl_smtp.open_data(mail_conn);
> utl_smtp.write_data(mail_conn, 'This is a test
> message.' || chr(13));
> utl_smtp.write_data(mail_conn, 'This is line 2.'
> || chr(13));
> utl_smtp.close_data(mail_conn);
> utl_smtp.quit(mail_conn);
> EXCEPTION
> WHEN OTHERS THEN
>-- Insert error-handling code here
>NULL;
> END;
> /
> 
> __
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Janet Linsy
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

Re: HISTOGRAMS , CBO and OLTP

[Connor McDonald]

There is no correlation between uniqueness and
"skewness".  For example, you might have unique
values: 1,2,3,4,5,...,, and then 100

Obviously that last one is an skew value.  If you have
predicates on this column along the lines of:

where col > ...
where col < ...
where col between ... and ...

then a histogram might be useful, otherwise the
optimizer assumes an even distribution of values
between 1 and 100


hth
connor

 --- Murali Menon <[EMAIL PROTECTED]> wrote: > 
> Uniqueness indicates that there are less skewed
> values correct! Under what circumstances would a
> skewed column value for a unique column exist.
> 
> Another question, what about histograms on indexes
> itself?  If histograms are generated on columns with
> skewed values, does it matter when the indexes are
> generated, before or after?  Do indexes on these
> columns need to be rebuilt.
> 
> Thanks
> 
>  
> 
>  
> 
>  Jonathan Lewis <[EMAIL PROTECTED]> wrote:
> 
> It's worth mentioning a frequently overlooked
> point that even if a column has a unique 
> constraint (whether or not declared and/or
> supported by an index) then if it has a
> skewed pattern of values the optimiser
> can use a histogram to optimise a queries
> that target a range.
> 
> (NB The grammar suggests that the word 
> "not" was intended as the last word of the 
> first line of (b) below).
> 
> 
> Regards
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
> Coming soon one-day tutorials:
> Cost Based Optimisation
> Trouble-shooting and Tuning
> Indexing Strategies
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
> 
> UK___March 19th
> USA_(FL)_May 2nd
> 
> 
> Next Seminar dates: 
> (see http://www.jlcomp.demon.co.uk/seminar.html )
> 
> USA_(CA, TX)_August
> 
> 
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L 
> Date: 08 February 2003 10:44
> 
> 
> >
> >b) The number of distinct/duplicate values should
> >really be relevant - its whether you will regularly
> >need to probe a table using column values that are
> >skewed in such a way as to have the optimizer make
> >poor assumptions about their distribution.
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Jonathan Lewis
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
> 
> -
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now 

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

Re:OEM 4

[J. Laurindo Chiappa]

And what about all that talk in this group (some time ago) , all the hope in making 
OEM a better product, this is the result ? 
A version what DEMANDS the install of that dinosaur-size, no-brain,  unmanageable 9iAS 
?? Crap, crap, a pile of crap.

*** REPLY SEPARATOR  ***

On 24/01/03 at 09:48 [EMAIL PROTECTED] wrote:

>Sounds pretty interesting, IF your in a completely Oracle environment!  On the
>other hand if you don't have 9IAS you may be out in the cold.
>
>Dick Goulet
>
>Reply Separator
>Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
>Date:   1/24/2003 5:11 AM
>
>Oracle just posted an item, they announced the next version of the OEM.
>http://196.30.226.221/sections/enterprise/2003/0301240730.asp?A=TES
>are%20Testing&T=Section&O=FPSH> &S=Software%20Testing&T=Section&O=FPSH
>
> 
>
>I checked on OTN, nothing is available for download there.
> 
>Patrice Boivin 
>Systems Analyst (Oracle Certified DBA) 
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes 
>Technology Services| Services technologiques 
>Informatics Branch | Direction de l'informatique 
>Maritimes Region, DFO  | Région des Maritimes, MPO 
>
>E-Mail: [EMAIL PROTECTED] 
>
>
>
>
>
>
>RE: Program name in v$ views
>
>
>
>Oracle
>
>just posted an item, they announced the next version of the 
>OEM.
>size=2>
>href="http://196.30.226.221/sections/enterprise/2003/0301240730.asp?A=TES&S=
>Software%20Testing&T=Section&O=FPSH">http://196.30.226.221/sections/ente
>rprise/2003/0301240730.asp?A=TES&S=Software%20Testing&T=Section&O=FP
>SH
> 
>I 
>checked on OTN, nothing is available for download there.
>size=2> 
>
>Patrice Boivin face="Courier New" size=2>Systems Analyst (Oracle Certified DBA) 
>Systems Admin & Operations | Admin. et 
>Exploit. des systèmes Technology 
>Services    | Services 
>technologiques Informatics 
>Branch | Direction de 
>l'informatique Maritimes Region, 
>DFO  | Région des Maritimes, MPO 
>E-Mail: [EMAIL PROTECTED] 
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: 
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).



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

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

RE: utf8

[MacGregor, Ian A.]

Title: Message



How 
about
 
insert 
into   ()  values 
(CHR(2122));
 
Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  
  -Original Message-From: Steve Main 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 2:44 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  utf8
  Hello 
  List,
   
  I have 
  built a database with a character set of UTF8 and I'm 
  trying
  to 
  insert character code 2122 "(TM) Trademark".  I'm 
  having
  trouble 
  coming up with a way to do this.
   
  anyone 
  had to deal with this before?
   
  Thanks
   
  Steve
   
   

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Jeremy Pulcifer]

Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it





> From: Lyndon Tiu [mailto:[EMAIL PROTECTED]] 
> 
> 
> Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> 
> > Lyndon
> >    To me, being a DBA is more an attitude than an HR 
> position. Study 
> > what DBAs do and that will carry you forward.
> >    I don't see what having a BSCS has to do with it. And I speak as
> > someone
> > who has done a lot of computer science at the graduate level.
> >    During the dark days, prepare, so when the industry picks up
> > again, you
> > are in a position to ride the surging wave.
> > 
> 
> B.Sc. more from the standpoint of getting your foot into that door. I
> don't think it actually helps you get the job done, only that it will
> get you the job in the first place. Even junior position DBA require a
> B.Sc. (those that I've read).


Bollocks. Don't believe it. How many job descriptions are actually written by the hiring managers? (hint: not many, if any)

I've not more than a half-dozen college credits to my name. Never have gone more than a coupla weeks without a job since I quit trying to pretend a college education was the end-all/be-all of education. Rarely if ever even comes up in the hiring process.

Several times it's actually impressed interviewers when I tell them I'm self-educated.


> As far as the wave is concerned, it's getting too crowded at the
> crest. Too many people wannbea DBA.


But only a few of those are any good at it. Those that are good at it will stick; B of Sci or not.

RE: [new info] Redhat Advanced Server Dev Edition - RAC

[Post, Ethan]

FYI, I am headed to Mogens RAC or Not to RAC presentation at the hotsos
symposium, let you know what I learn!

-Original Message-
Sent: Tuesday, February 11, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L



This is all cool technology, and fun stuff to play with.

It all begs the questions, 

"How many of us work for a business that actually need this?"

"Are they willing to pay $400/user $20k/CPU above the cost
of Oracle 9i EE to use it?"

"Are they willing to pay the extra overhead required to maintain it?"

I'm not sure the ROI is there for many of us.  Though downtime
at our business is somewhat expensive, I think that a failover
system or even standby database will provide adequate coverage
for us, which is indeed a hot topic here right now, after our Dell
SAN put us out of business for 36 hours.  

RAC wouldn't have helped much there.  Niether would a cluster
for that matter.  Standby DB would have been perfect.

This whole push of RAC by Oracle reminds me very much of the
mlife phone campaign by ATT.  Do you really need to take pictures
with your phone?  And what is the point of sending text messages
to someone elses phone when you could just call them?

ATT needs you to buy this stuff, because they have it for sale.

I see RAC in  a similar light.  Do you need RAC?  Oracle needs
you to 'need' it, because they need some reason for you to
spend more money on their product.

Jared



On Saturday 08 February 2003 21:23, Richard Ji wrote:
> To those who are interested in running RAC on Linux.
> I know we have been talking about RAC on linux lately.  This is great news
> Redhat has made a special developer's edition for their Advanced Server
> which
> only costs $60!  So we don't have to shell out $699 for a copy of RHAS 2.1
> to play with RAC.
>
> http://www.redhat.com/software/advancedserver/developer/
>
> Have fun.
>
> Richard Ji
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

RE: Oracle License for Training

[Weiss, Rick]

A question for the DBA Gods on this list:

Is it worth the time/effort to download MySQL and learn it?  Is there going
to be a viable (meaning $$) market for the product in the future? Or should
I leave all the egg$ in the Oracle basket?

Musing for fun and profit.

Rick Weiss

-Original Message-
Sent: Tuesday, February 11, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L


MS SQL costing less than Oracle is only partly true.

If you load up MS with the extras that constitute a std
feature set on Oracle, Oracle is very competitive.

Been lots of comparisons on that.

Now PostgreSQL and MySQL, those *are* less expensize than 
MS SQL and Oracle.  :)

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

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

RE: Breaking down values in a large table

[Khedr, Waleed]

I hope this helps:

--
drop table test_bal ;
--
-- create a sample table
--
create table test_bal( my_pk number);
--
-- Insert sample data
--
begin
for i in 100..21000 loop
  insert into test_bal values (i);
end loop;
end;

--
select  b.rows_cnt as table_rows_cnt, 
c.mrownum  as acc_rows_cnt, 
c.my_pkas bucket_end_inclusive, 
ceil(c.mrownum * 4/ b.rows_cnt) as bucket_id 
 from (select a.*,rownum mrownum 
 from (select my_pk 
from test_bal 
order by 1) a) c, 
  (select count(*) rows_cnt from test_bal) b
where ceil((c.mrownum + 1)* 4/ b.rows_cnt) > ceil( c.mrownum * 4/
b.rows_cnt);

--

Regards,

Waleed


-Original Message-
Sent: Tuesday, February 11, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


Listers,
I have a table of 125M rows (not partitioned) which I am exporting. I want
to break the export into 4 dmp files using the query command on the pk
column.
 
I am looking at how the best way of finding the values of the PK (number)
which are at 25%, 50% and 75% ish for the table so that I can get 4 evenly
sized exports
 
My query line in the parameter file will be along the lines of where 
1)   log_no < xx
2)   log_no >= xx and < yy
3)   log_no >= yy and < zz
4)   log_no >= zz
 
I am thinking of a sql something like the following
 
Select /*+  index ffs(table_name index_name) */
Log_no , floor(log_no / 4), count(*)
>From table_name group by floor(log_no / 4), log_no
 
Version is 8.1.7.1
 
Can anybody help please
 
Thanks
 
John
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

utf8

[Steve Main]

Title: Message



Hello 
List,
 
I have 
built a database with a character set of UTF8 and I'm trying
to insert 
character code 2122 "(TM) Trademark".  I'm having
trouble 
coming up with a way to do this.
 
anyone had 
to deal with this before?
 
Thanks
 
Steve
 
 

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> Lyndon
>To me, being a DBA is more an attitude than an HR position.
> Study what
> DBAs do and that will carry you forward.
>I don't see what having a BSCS has to do with it. And I speak as
> someone
> who has done a lot of computer science at the graduate level.
>During the dark days, prepare, so when the industry picks up
> again, you
> are in a position to ride the surging wave.
> 

B.Sc. more from the standpoint of getting your foot into that door. I
don't think it actually helps you get the job done, only that it will
get you the job in the first place. Even junior position DBA require a
B.Sc. (those that I've read).

As far as the wave is concerned, it's getting too crowded at the
crest. Too many people wannbea DBA.

-- 
Lyndon Tiu

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

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

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting Jeremy Pulcifer <[EMAIL PROTECTED]>:
> > > I take it from your reply that 1) your not the primary DBA
> and
> > > 
> > 
> > I work with Oracle and PostGreSQL, but not as a DBA. I'm a 
> > "wannabe" DBA but will most probably never be a real DBA since:
> > 
> > 1) I do not have B.Sc. in Comp. Sci.
> 
> Ha! Just stop putting your education on your resume.

Good idea. Maybe I should just stop putting anything on my resume,
maybe that will catch some attention.

> 
> > 2) I got into Hi-Tech right after the bubble burst.
> 
> ?
> 
> What's that to do with becoming a DBA?
> 

Too many other experienced DBA's running around jobless.

> > But I do admin(solely me and me alone) exactly one PostGreSQL 
> > development soon to be a production database so does that 
> > make me a DBA?
> 
> If you say so. Seriously.
> 

Self-proclaimed "I am my own" DBA!!

-- 
Lyndon Tiu

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

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

RE: Re[2]: [new info] Redhat Advanced Server Dev Edition - RAC

[Jared . Still]

Simple: 

RAC = $60k per CPU.

Standby = $40k per CPU.

Jared






DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/11/2003 01:54 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Re[2]: [new info] Redhat Advanced Server Dev Edition - RAC


Dick
   How is the standby database cheaper? I understood from previous list
discussions that you had to license the standby server as well.
   As the hardware and O/S become commodities, I think Oracle would like 
to
avoid becoming a commodity. Commodity prices are low, as any farmer can 
tell
you. 
   But the further issue is "how do Oracle DBAs avoid becoming a
commodity?". Maybe the next question coming is "why should we pay more for 
a
DBA when we're getting the computer and software so cheap?"

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


-Original Message-
Sent: Tuesday, February 11, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


Jared,

I don't know about the rest of the list members, but the company I 
work
for
would like to have the technology but without the additional license
expense. 
Therefore were going to do the standby database thing instead of RAC.  Now
if
your into using Linux with low end PC's then maybe you can justify it.  I
don't
know, it gives me the whillies when the software costs more than the
hardware
and OS combined.

Dick Goulet

Reply Separator
Author: Jared Still <[EMAIL PROTECTED]>
Date:   2/11/2003 8:29 AM


This is all cool technology, and fun stuff to play with.

It all begs the questions, 

"How many of us work for a business that actually need this?"

"Are they willing to pay $400/user $20k/CPU above the cost
of Oracle 9i EE to use it?"

"Are they willing to pay the extra overhead required to maintain it?"

I'm not sure the ROI is there for many of us.  Though downtime
at our business is somewhat expensive, I think that a failover
system or even standby database will provide adequate coverage
for us, which is indeed a hot topic here right now, after our Dell
SAN put us out of business for 36 hours. 

RAC wouldn't have helped much there.  Niether would a cluster
for that matter.  Standby DB would have been perfect.

This whole push of RAC by Oracle reminds me very much of the
mlife phone campaign by ATT.  Do you really need to take pictures
with your phone?  And what is the point of sending text messages
to someone elses phone when you could just call them?

ATT needs you to buy this stuff, because they have it for sale.

I see RAC in  a similar light.  Do you need RAC?  Oracle needs
you to 'need' it, because they need some reason for you to
spend more money on their product.

Jared



On Saturday 08 February 2003 21:23, Richard Ji wrote:
> To those who are interested in running RAC on Linux.
> I know we have been talking about RAC on linux lately.  This is great 
news
> Redhat has made a special developer's edition for their Advanced Server
> which
> only costs $60!  So we don't have to shell out $699 for a copy of RHAS 
2.1
> to play with RAC.
>
> http://www.redhat.com/software/advancedserver/developer/
>
> Have fun.
>
> Richard Ji
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Oracle License for Training

[Jared . Still]

MS SQL costing less than Oracle is only partly true.

If you load up MS with the extras that constitute a std
feature set on Oracle, Oracle is very competitive.

Been lots of comparisons on that.

Now PostgreSQL and MySQL, those *are* less expensize than 
MS SQL and Oracle.  :)

Jared






Lyndon Tiu <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/11/2003 12:14 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Oracle License for Training


Quoting Ora NT DBA <[EMAIL PROTECTED]>:
> Hi  All,
> 
> This conversation didn't start out in dealing with educational 
> institutions, it
> started out as a group that wants to use it to make money.
> 
> Oracle is making every effort to work with legitimate education 
> institutions.  The
> Oracle Academic Initiative does exactly what you describe. 
> Institutions 
> pay  a
> small fee (500.00 I think) they are have access to ALL Oracle
> Software 
> for use in
> instruction.  They also have access to Oracle University Curriculum
> if 
> desired.
> 
> more information can be found at:
> http://oai.oracle.com
> 

Sounds good. It's not that expensive! I wonder if Oracle instructors
cost more than MS SQL instructors that's why most schools (where I
am)offer MS SQL?

-- 
Lyndon Tiu




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

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

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[DENNIS WILLIAMS]

Lyndon
   To me, being a DBA is more an attitude than an HR position. Study what
DBAs do and that will carry you forward.
   I don't see what having a BSCS has to do with it. And I speak as someone
who has done a lot of computer science at the graduate level.
   During the dark days, prepare, so when the industry picks up again, you
are in a position to ride the surging wave.

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


-Original Message-
Sent: Tuesday, February 11, 2003 3:38 PM
To: Multiple recipients of list ORACLE-L


Quoting [EMAIL PROTECTED]:

> Lyndon,
> 
> I take it from your reply that 1) your not the primary DBA and
> 

I work with Oracle and PostGreSQL, but not as a DBA. I'm a "wannabe"
DBA but will most probably never be a real DBA since:

1) I do not have B.Sc. in Comp. Sci.

2) I got into Hi-Tech right after the bubble burst.

But I do admin(solely me and me alone) exactly one PostGreSQL
development soon to be a production database so does that make me a DBA?

> 2) everyone
> is using Personal Oracle or Standard edition on their desktop. 
> Sounds like one
> heck of a mess.
>

More like people are developing software on a database running on
development machines.

Look at the number of [Re]'s on the subject line of this email!!!


-- 
Lyndon Tiu

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

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

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

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Jeremy Pulcifer]

Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it





> From: Lyndon Tiu [mailto:[EMAIL PROTECTED]] 
> 
> 
> Quoting [EMAIL PROTECTED]:
> 
> > Lyndon,
> > 
> > I take it from your reply that 1) your not the primary DBA and
> > 
> 
> I work with Oracle and PostGreSQL, but not as a DBA. I'm a 
> "wannabe" DBA but will most probably never be a real DBA since:
> 
> 1) I do not have B.Sc. in Comp. Sci.


Ha! Just stop putting your education on your resume.


> 2) I got into Hi-Tech right after the bubble burst.


?


What's that to do with becoming a DBA?


> But I do admin(solely me and me alone) exactly one PostGreSQL 
> development soon to be a production database so does that 
> make me a DBA?


If you say so. Seriously.


> > 2) everyone
> > is using Personal Oracle or Standard edition on their desktop.
> > Sounds like one
> > heck of a mess.
> >
> 
> More like people are developing software on a database running on
> development machines.


The best advice I can give, in this case: develop a set of db create scripts, make sure they are bullet-proof and that configurations are automated, and release them to the developer public. Then you won't have to fix all of the teeny-weenie db's on them dev boxes.

> Look at the number of [Re]'s on the subject line of this email!!!


Re-re-re-re-re-re-re-re-spect, gotta gettabit...

RE: Re[2]: [new info] Redhat Advanced Server Dev Edition - RAC

[DENNIS WILLIAMS]

Dick
   How is the standby database cheaper? I understood from previous list
discussions that you had to license the standby server as well.
   As the hardware and O/S become commodities, I think Oracle would like to
avoid becoming a commodity. Commodity prices are low, as any farmer can tell
you. 
   But the further issue is "how do Oracle DBAs avoid becoming a
commodity?". Maybe the next question coming is "why should we pay more for a
DBA when we're getting the computer and software so cheap?"

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


-Original Message-
Sent: Tuesday, February 11, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


Jared,

I don't know about the rest of the list members, but the company I work
for
would like to have the technology but without the additional license
expense. 
Therefore were going to do the standby database thing instead of RAC.  Now
if
your into using Linux with low end PC's then maybe you can justify it.  I
don't
know, it gives me the whillies when the software costs more than the
hardware
and OS combined.

Dick Goulet

Reply Separator
Author: Jared Still <[EMAIL PROTECTED]>
Date:   2/11/2003 8:29 AM


This is all cool technology, and fun stuff to play with.

It all begs the questions, 

"How many of us work for a business that actually need this?"

"Are they willing to pay $400/user $20k/CPU above the cost
of Oracle 9i EE to use it?"

"Are they willing to pay the extra overhead required to maintain it?"

I'm not sure the ROI is there for many of us.  Though downtime
at our business is somewhat expensive, I think that a failover
system or even standby database will provide adequate coverage
for us, which is indeed a hot topic here right now, after our Dell
SAN put us out of business for 36 hours.  

RAC wouldn't have helped much there.  Niether would a cluster
for that matter.  Standby DB would have been perfect.

This whole push of RAC by Oracle reminds me very much of the
mlife phone campaign by ATT.  Do you really need to take pictures
with your phone?  And what is the point of sending text messages
to someone elses phone when you could just call them?

ATT needs you to buy this stuff, because they have it for sale.

I see RAC in  a similar light.  Do you need RAC?  Oracle needs
you to 'need' it, because they need some reason for you to
spend more money on their product.

Jared



On Saturday 08 February 2003 21:23, Richard Ji wrote:
> To those who are interested in running RAC on Linux.
> I know we have been talking about RAC on linux lately.  This is great news
> Redhat has made a special developer's edition for their Advanced Server
> which
> only costs $60!  So we don't have to shell out $699 for a copy of RHAS 2.1
> to play with RAC.
>
> http://www.redhat.com/software/advancedserver/developer/
>
> Have fun.
>
> Richard Ji
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Oracle License for Training

[Lyndon Tiu]

Quoting Ora NT DBA <[EMAIL PROTECTED]>:

> You are WRONG! The Oracle Academic Initiative has 100's of members.
>  In 
> California
> there are more than 200.
> 

I should move to Californiaa.

-- 
Lyndon Tiu

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

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

Re: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting [EMAIL PROTECTED]:

> Lyndon,
> 
> I take it from your reply that 1) your not the primary DBA and
> 

I work with Oracle and PostGreSQL, but not as a DBA. I'm a "wannabe"
DBA but will most probably never be a real DBA since:

1) I do not have B.Sc. in Comp. Sci.

2) I got into Hi-Tech right after the bubble burst.

But I do admin(solely me and me alone) exactly one PostGreSQL
development soon to be a production database so does that make me a DBA?

> 2) everyone
> is using Personal Oracle or Standard edition on their desktop. 
> Sounds like one
> heck of a mess.
>

More like people are developing software on a database running on
development machines.

Look at the number of [Re]'s on the subject line of this email!!!


-- 
Lyndon Tiu

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

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

Re: rootpre.sh

[Joan Hsieh]

David,

We got same problem. Here is a work around for that 

  The error message "crash: not found" may appear during execution of 
  rootpre.sh on AIX 5. This warning may be ignored. Alternatively, the 
  warning can be avoided by creating the following script and renaming
it 
  to "/usr/sbin/crash": 

  #!/bin/ksh 
  read input 
  if [ X"$input" = Xle ]; then 
  echo lke | /usr/sbin/kdb | \ 
  /usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n Name: 
  %s\n\n",$2,$6)} 
  fi 

  OR 

  You can be avoid "./rootpre.sh[199]:crash:not found" 
  error by the following, 

  line:199 
  PKEXT_PATH=`echo le | crash | grep pw | awk '{print $2}'` 

  change to: 
  PKEXT_PATH=`echo lke | kdb | grep pw | awk '{print $6}'` 

  I hope that helps. 

Joan

"Ehresmann, David" wrote:
> 
> I am trying to run rootpre.sh.  My admin just upgrade the kernel to 64-bit.
> We were running 32-bit on this box and everything was fine.  No Oracle
> software is running.  I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L
> when I got this trying to run rootpre.sh.
> This is what I get when I run:
> #./rootpre.sh
> Installing kernel extension...
> 
> Oracle Kernel Ext...
> Copyright
> 
> Kernel Extension Version: 3
> 
> nkext ver: 3
> ./rootpre.sh[199]: crash: not found.
> 
> is not loaded : 1
> No post-wait kernel is loaded on the machine.
> 
> Copying new kernel extension.
> 
> Oracle Kernel Extension Loader for AIX
> Copyright.
> 
> Kernel Extension Version: 3
> SYS_SINGLELOAD: Exec format error
> kmid: 0 (0x0)
> path '/etc/pw-syscall'
> libpath:''
> 
> Configuring Asynchronous I/O...
> Asynchronous I/O is already defined
> 
> thanks,
> David Ehresmann
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

RE: Oracle License for Training

[Schilling, Ben]

The Madison (Wisconsin) Area Technical College has several Oracle classes
available.  Some of them are in their CIS-Certificate in Oracle Database
Administration Associate Curriculum.

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


All I can speak for are the schools in my area (Dallas, TX). A few of the
community colleges teach Oracle and SMU teaches it, but in each case, it is
continuing education, not part of a Computer science degree. It's the same
class as at Oracle education, i.e. no grades, not tests, everyone passes
that shows up.
 
But then, I'm not sure a degree in Computer science should target a
particular vendors product. 
 
Keith

- Original Message - 
To: Multiple recipients of list ORACLE-L   
Sent: Tuesday, February 11, 2003 1:55 PM

You are WRONG! The Oracle Academic Initiative has 100's of members.  In
California
there are more than 200.

John

[EMAIL PROTECTED]   wrote:


Quoting Markus Reger  ">  <[EMAIL PROTECTED]>:



  

I have to manage MySQL and ORACLE for the web likewise.

There seems to be a strong tendency towards MySQL if people newly

enter the area of webpresence, students or profs doesn't make a

difference.







For web work. MySQL is very popular (Together with PHP).



For everything else, Access is usually the intro if developing dektop

apps. MS SQL if the intro is a bit higher end (non-desktop

applications). DB2 is also an intro in some schools.



You never see Oracle as the intro DB in any school (a real school as

in University, College, High School not those $$$ making diploma mills).



  


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

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

RE: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting Nick Wagner <[EMAIL PROTECTED]>:

> Two words - Speed and Performance.  
>
 
gotcha. Thanks.

-- 
Lyndon Tiu

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

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

Re: Re[2]: Oracle License for Training

[Lyndon Tiu]

Quoting [EMAIL PROTECTED]:

> Most schools up here in New England start you off with Access, then
> M$ Sql and
> then Oracle before you graduate.  They also teach VB before C
> before Java.  It
> helps to start small grow into the real world.
> 

You have a point.

Although I think Java (and .Net) should be thought before C since C is
harder.

-- 
Lyndon Tiu

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

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

Re[2]: [new info] Redhat Advanced Server Dev Edition - RAC

[dgoulet]

Jared,

I don't know about the rest of the list members, but the company I work for
would like to have the technology but without the additional license expense. 
Therefore were going to do the standby database thing instead of RAC.  Now if
your into using Linux with low end PC's then maybe you can justify it.  I don't
know, it gives me the whillies when the software costs more than the hardware
and OS combined.

Dick Goulet

Reply Separator
Author: Jared Still <[EMAIL PROTECTED]>
Date:   2/11/2003 8:29 AM


This is all cool technology, and fun stuff to play with.

It all begs the questions, 

"How many of us work for a business that actually need this?"

"Are they willing to pay $400/user $20k/CPU above the cost
of Oracle 9i EE to use it?"

"Are they willing to pay the extra overhead required to maintain it?"

I'm not sure the ROI is there for many of us.  Though downtime
at our business is somewhat expensive, I think that a failover
system or even standby database will provide adequate coverage
for us, which is indeed a hot topic here right now, after our Dell
SAN put us out of business for 36 hours.  

RAC wouldn't have helped much there.  Niether would a cluster
for that matter.  Standby DB would have been perfect.

This whole push of RAC by Oracle reminds me very much of the
mlife phone campaign by ATT.  Do you really need to take pictures
with your phone?  And what is the point of sending text messages
to someone elses phone when you could just call them?

ATT needs you to buy this stuff, because they have it for sale.

I see RAC in  a similar light.  Do you need RAC?  Oracle needs
you to 'need' it, because they need some reason for you to
spend more money on their product.

Jared



On Saturday 08 February 2003 21:23, Richard Ji wrote:
> To those who are interested in running RAC on Linux.
> I know we have been talking about RAC on linux lately.  This is great news
> Redhat has made a special developer's edition for their Advanced Server
> which
> only costs $60!  So we don't have to shell out $699 for a copy of RHAS 2.1
> to play with RAC.
>
> http://www.redhat.com/software/advancedserver/developer/
>
> Have fun.
>
> Richard Ji
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

Re: dump.sql

[Tim Gorman]

There has been a fair amount of discussion about it - on this list, on other
lists, in SELECT magazine, etc.  Jared has a perfect right to be annoyed
that use has been taken but attribution was not given.  I post a bunch of
things on my website and that's all I ask, explicitly, at the top of the
page.

To be honest, I suspect that what has happened is that the matter has come
to the attention of the folks who manage MetaLink content.  They likely
queried the lawyers at Oracle about what to do, getting the response, "No
way!  Do not allow an individual's name to remain on anything in the
MetaLink Knowledge Base for any reason".  And, "By the way, do not even
communicate with the individual as that might provide basis for some sort of
claim or lien"...

...or some kind of surreal legalistic garbage like that...

Just my guesses, but that's probably what happens when the worlds of
"share-ware" and "capitalized intellectual property" collide.  In one world,
it's about bad manners and grounds for serious disrespect.  In the other
world, it's about limiting liability, potential litigation, and "no blood,
no foul; get up off the floor and keep playing"...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 10:19 AM


> Tim,
>
> Besides it is available on Metalink, accessable to those users who are
> holding valid support licence and Jared is just pointing to that
direction.
> There is nothing wrong in it as far as copyright is concerned. There is no
> theft involved of any sort as Jared did not claim ownership of that script
> either
>
> Regards
> Rafiq
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Mon, 10 Feb 2003 20:33:55 -0800
>
> This has nothing to do with copyrights, patents, reputation, or IP.  It's
a
> script.  It was posted on the internet.  Nothing more than a case of bad
> manners.
>
> There is no disservice in not tilting at this particular windmill.  You
owe
> Jared an apology.
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, February 10, 2003 12:38 PM
>
>
>  > Hi Jared,
>  > I think a letter to the Redwood Shores police
>  > department alleging IP theft and asking them to investigate
>  > may be effective.
>  >
>  > I believe copyright in it's current business model is dead
>  > but since everyone's reputation is based on their copyrights
>  > you can not allow this theft to continue.
>  >
>  > If you do you are doing a disservice to everyone.
>  >
>  >
>  > Dave
>  >
>  > Jared wrote ...
>  > >
>  > > It may also be found at:
>  > >
>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=1050919.6
>  > >
>  > > Yes, it's back, still without credit.
>  > >
>  > > Please, no 'piracy' emails to Oracle about it.
>  > >
>  > > Jared
>  >
>  > --
>  > Dave Morgan
>  > Operations Manager, Rigskills Canada
>  > Canada's Geographical Oilfield Services Locator
>  > http://www.rigskills.ca
>  > [EMAIL PROTECTED]
>  > 403 399 2442
>  > --
>  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>  > --
>  > Author: Dave Morgan
>  >   INET: [EMAIL PROTECTED]
>  >
>  > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>  > San Diego, California-- Mailing list and web hosting services
>  > -
>  > To REMOVE yourself from this mailing list, send an E-Mail message
>  > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>  > the message BODY, include a line containing: UNSUB ORACLE-L
>  > (or the name of mailing list you want to be removed from).  You may
>  > also send the HELP command for other information (like subscribing).
>  >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
>INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
> _
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: M Rafiq
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --

RE: Re[2]: copyright

[Stephen Lee]

>
> my reply would be "Have a ball!!"
> 

"Dirty deeds.  Done dirt cheap!"

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

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

RE: Oracle License for Training

[DENNIS WILLIAMS]

Lyndon - Lost cause. Everybody is already teaching a lot of Microsoft
products. But Oracle benefits because there is a cachet from being the
"high-end" product. Cray Computer was good at exploiting that.

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


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


Quoting Ora NT DBA <[EMAIL PROTECTED]>:
> Hi  All,
> 
> This conversation didn't start out in dealing with educational 
> institutions, it
> started out as a group that wants to use it to make money.
> 
> Oracle is making every effort to work with legitimate education 
> institutions.  The
> Oracle Academic Initiative does exactly what you describe. 
> Institutions 
> pay  a
> small fee (500.00 I think) they are have access to ALL Oracle
> Software 
> for use in
> instruction.  They also have access to Oracle University Curriculum
> if 
> desired.
> 
> more information can be found at:
> http://oai.oracle.com
> 

Sounds good. It's not that expensive! I wonder if Oracle instructors
cost more than MS SQL instructors that's why most schools (where I
am)offer MS SQL?

-- 
Lyndon Tiu

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

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

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

Re[2]: Oracle License for Training

[dgoulet]

Most schools up here in New England start you off with Access, then M$ Sql and
then Oracle before you graduate.  They also teach VB before C before Java.  It
helps to start small grow into the real world.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   2/11/2003 12:14 PM

Quoting Ora NT DBA <[EMAIL PROTECTED]>:
> Hi  All,
> 
> This conversation didn't start out in dealing with educational 
> institutions, it
> started out as a group that wants to use it to make money.
> 
> Oracle is making every effort to work with legitimate education 
> institutions.  The
> Oracle Academic Initiative does exactly what you describe. 
> Institutions 
> pay  a
> small fee (500.00 I think) they are have access to ALL Oracle
> Software 
> for use in
> instruction.  They also have access to Oracle University Curriculum
> if 
> desired.
> 
> more information can be found at:
> http://oai.oracle.com
> 

Sounds good. It's not that expensive! I wonder if Oracle instructors
cost more than MS SQL instructors that's why most schools (where I
am)offer MS SQL?

-- 
Lyndon Tiu

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

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

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

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

Re: Oracle License for Training

[Keith Moore]

All I can speak for are the schools in my area 
(Dallas, TX). A few of the community colleges teach Oracle and SMU teaches it, 
but in each case, it is continuing education, not part of a Computer science 
degree. It's the same class as at Oracle education, i.e. no grades, not tests, 
everyone passes that shows up.
 
But then, I'm not sure a degree in Computer science 
should target a particular vendors product. 
 
Keith

  - Original Message - 
  From: 
  Ora NT 
  DBA 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, February 11, 2003 1:55 
  PM
  Subject: Re: Oracle License for 
  Training
  You are WRONG! The Oracle Academic Initiative has 100's of 
  members.  In Californiathere are more than 200.John[EMAIL PROTECTED] wrote:
  Quoting Markus Reger <[EMAIL PROTECTED]>:

  
I have to manage MySQL and ORACLE for the web likewise.
There seems to be a strong tendency towards MySQL if people newly
enter the area of webpresence, students or profs doesn't make a
difference.


For web work. MySQL is very popular (Together with PHP).

For everything else, Access is usually the intro if developing dektop
apps. MS SQL if the intro is a bit higher end (non-desktop
applications). DB2 is also an intro in some schools.

You never see Oracle as the intro DB in any school (a real school as
in University, College, High School not those $$$ making diploma mills).

  
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

8.1.7.4 to 9.2

[Rishi . Jain]

Guru's

We are planning to move to 9i from 8.1.7.4 in the near future. The two
options we are considering are

a) Migration from 8.1.7 to 9.2
b) Install 9i and then use export , import to get the data from version 8i.

If my memory serves me right I remember reading an article somewhere which
says that we could not use all the new features of 9i if we went ahead with
the migration path.

Could you please provide your inputs as to which way is better than the
other with pros and cons of both.

Thanks in advance.

Rishi.


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

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

RE: Re[2]: Re[2]: RMAN: I don't trust it

[Nick Wagner]

Title: RE: Re[2]: Re[2]: RMAN: I don't trust it





Two words - Speed and Performance.  


-Original Message-
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: Re[2]: RMAN: I don't trust it



Quoting [EMAIL PROTECTED]:


> Lyndon,
> 
> True, an export file is peculiar to Oracle.  The difference
> between a
> commercial database and an open source one.  IBM and MicroSludge do
> the same. 
> The functional purpose though is the same.


Question:


Why a binary file? More efficient? I find the plain text output more
useful and easy to store. Recovery is easier as well, just cut and
past the relevant lines of script and run it.


-- 
Lyndon Tiu


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


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

Re[2]: copyright

[dgoulet]

Dave,

There are a few folks running around this world, me included, who really
don't care if you or anyone else begs, borrows, or steals the scripts/source
code we've written so long as they either server a purpose or lead to something
better.  Assuming I'm Tim, my reply would be "Have a ball!!"

Dick Goulet

Reply Separator
Author: Dave Morgan <[EMAIL PROTECTED]>
Date:   2/11/2003 10:56 AM

Hi Tim,
A few thoughts,

>It's a script
- Oracle RDBMS is a bunch of scripts
>It was posted on the internet
- Oracle is available on the internet

Does this mean I can download Oracle, place it on
my website legally, call it notoracle and sell it?

Or 

I found this script on the web

#!/bin/ksh
#
# File: oramem.sh
# Type: UNIX korn-shell script
# Author:   Tim Gorman, Sagelogix Inc.
# Date: 28jun02
#
# Description:
#
#   This shell script utilizes the "pmap -x" command to total up the
#   total amount of virtual memory used by all of the Oracle server
#   processes (both "background" and "foreground") belonging to a
#   database instance.
#
# Modifications:
# TGorman 28jun02 written for Solaris 2.8

How about if I put this on my website after I remove
all references to yourself and SageLogix and claim to be the
author?

How about if I rewrite in bourne sh, keep all the references
and post it?

The first is definitely illegal, the second might be, (you don't 
explicitly give permission to copy the script, but accepted practise 
in the area is that attribution is enough). You will definitely be 
unhappy with the first, you might be proud you were attributed 
in the second.

Some basic facts, Jared wrote it, Jared owns the copyright. The
fact that he makes it publically available is irrelevant. Oracle is
using his work, without attribution in a paid service. (Metalink, from
which the page is now unavailable, gee I wonder why). 

A copyright is intellectual property, removal of a copyright notice
is illegal. Consult SageLogix's lawyers, mine would have loved to 
work for Jared, would have done it on contigency basis. Bad manners
is not an acceptable legal defence.

This has everything to do with copyrights, patents, and theft.
Personally, I think it adds to Jared's reputation but what happens 
if this is not challenged and 5 years from now they
come back at Jared and say you are distributing one of our scripts?
Defending oneself in that situation would be impossible.

Tilting at windmills. Protesting illegal actions taken by large 
corporations is futile? Standing up for ones rights is pointless?

Come to Canada where we know how to treat monopolies ;-) Badly

An apology, for protecting his intellectual capital, especially
since the offending page has (again) been removed. OK. 

Jared, if I have interfered unseemingly in your life I am sorry,
but I think minor issues like this can hve very wide ramifications.
However, this belief does not give me to right to interfere.
I did not email Oracle, the only comment was to this forum.

Dave

> 
>  From: "Tim Gorman" <[EMAIL PROTECTED]>
>  Date: Mon, 10 Feb 2003 21:12:17 -0700
>  Subject: Re: dump.sql
> 
> This has nothing to do with copyrights, patents, reputation, or IP.
> It's a
> script.  It was posted on the internet.  Nothing more than a case of bad
> manners.
> 
> There is no disservice in not tilting at this particular windmill.  You
> owe
> Jared an apology.
> 
> --

-- 
Dave Morgan
Operations Manager, Rigskills Canada
Canada's Geographical Oilfield Services Locator
http://www.rigskills.ca
[EMAIL PROTECTED]
403 399 2442
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

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

Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[dgoulet]

Lyndon,

I take it from your reply that 1) your not the primary DBA and 2) everyone
is using Personal Oracle or Standard edition on their desktop.  Sounds like one
heck of a mess.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   2/11/2003 12:03 PM

Quoting [EMAIL PROTECTED]:
> Beacuse it's proprietary.  Any dunce can create a flat ascii
> text file,
> which probably accounts for the wide audience it gets.  But it
> takes a PHD to
> read a binary one.  BTW: IBM and M$'s dump files are binary as
> well.
> 
> Also, Oracle's default installation does scale, although not as
> well as it
> should.  And to boot that's the reason your boss pays you.  Look at
> as job
> justification.

Vendor Lock-in.

I hate it when default installs of Oracle complains it does not have
enough shared pool after about 30 connections and a small 10,000 entry
database with no pl/sql stored procedures.

I then have to go around fixing everyone's init.ora because none has a
clue why Oracle would complain about not having enough memeory when
the machine it runs on has 2GB of memory - and it's not even my job to
do this tweaking (it's someone else who went to Oracle class for $$$
company paid and still does not know), it just so happens I know how
to fix it that's why I get called to fix it.

-- 
Lyndon Tiu

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

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

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

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

Re: NEVER MIND - WAS - RE: SQL Plus Environment

[Suzy Vordos]

Set SQLPATH, then login.sql and all of your other .sql scripts can be in
whatever directory location(s) you prefer.

"Farnsworth, Dave" wrote:
> 
> I fixed it.  I decided if the DBS directory was not created by the Oracle install 
>than I will go and create the directory for Oracle.  I then dropped my login.sql into 
>the directory, fired up SQLPlus and my login.sql worked.  Maybe I should of just sent 
>a HELP instead.  ;o)
> 
> Dave
> 
> -Original Message-
> Sent: Tuesday, February 11, 2003 12:22 PM
> To: Multiple recipients of list ORACLE-L
> 
> I want to set up a glogin.sql and a login.sql.  I am reading the manual and I find 
>this.  Oh yea. I'm on 8.1.7 on NT.
> 
> When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and 
>GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory.
> If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape 
>sequences.
> See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide 
>and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and 
>GLOGIN.SQL files.
> 
> I can find the glogin.sql on my client PC and have edited it to my liking.  But I 
>cannot find the login.sql and I do not have the DBS directory.  I see a DBS directory 
>on the server but not on the client.  Am I missing something or does login.sql not 
>exist on 8.1.7.
> 
> Thanks,
> 
> Dave
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

Re: Breaking down values in a large table

[Jared . Still]

Er, I mean, 'filesize'.






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 02/11/2003 10:39 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Breaking down values in a large table


John,

use the 'volsize' parameter.

Look at 'exp help=y'

Jared






"John Hallas" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/11/2003 06:19 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc: 
Subject:Breaking down values in a large table


Listers,
I have a table of 125M rows (not partitioned) which I am exporting. I want 

to break the export into 4 dmp files using the query command on the pk 
column.
 
I am looking at how the best way of finding the values of the PK (number) 
which are at 25%, 50% and 75% ish for the table so that I can get 4 evenly 

sized exports
 
My query line in the parameter file will be along the lines of where 
1)   log_no < xx
2)   log_no >= xx and < yy
3)   log_no >= yy and < zz
4)   log_no >= zz
 
I am thinking of a sql something like the following
 
Select /*+  index ffs(table_name index_name) */
Log_no , floor(log_no / 4), count(*)
>From table_name group by floor(log_no / 4), log_no
 
Version is 8.1.7.1
 
Can anybody help please
 
Thanks
 
John
 
 


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

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




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

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

RE: Count(*) last 30 seconds

[Ramon E. Estevez]

Title: Message




Tks 
to all of you for your help.
 
The 
table has a PK that is formed by 11 fields of 13 that the table has.  This 
table is for a DW system.
 
This 
the only one in the table.
 
I 
analyze the table again, had done it before using 
dbms_stats.gather_schema_stats, and the time went down to 7 
seconds.
 
And 
there is no difference between count(*) and count(1), the same results with both 
of them.
 
tks 
to all
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Koivu, LisaSent: 
  Tuesday, February 11, 2003 11:40 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Count(*) last 30 seconds
  well, have you traced the statement yet?  That's 
  where to start, with autotrace.
   
  My 
  count(*) which executes a FTS (in a load to mitigate any ORA-1555 error) 
  takes 15 minutes to count 50 million rows.
   
  
  Lisa 
  Koivu Tired, Tired, 
  Tired. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. 
  Lauderdale, FL, USA  33063 Office: 
  954-935-4117  Fax:    
  954-935-3639 Cell:    
  954-683-4459 
  
-Original Message-From: Ramon E. Estevez 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 
2003 11:19 AMTo: Multiple recipients of list 
ORACLE-LSubject: Count(*) last 30 seconds
Hi 
list,
 
I issue a 
select count(*) from mytable and last 30 seconds.
 
The table has 
1,466,196 records and were loaded with a batch process, so they are in 
a countinous space.
 
I consider 
that time exagerated.
 
The TBS is LMT 
with a Uniform size of 128 MB.
 
The block size 
is 8MB, version 9.2.0.1.0 in Windows 2000.
 
Where should I 
start looking ???
 
TIA
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
809-565-3121
 

Re: Oracle License for Training

[Lyndon Tiu]

Quoting Ora NT DBA <[EMAIL PROTECTED]>:
> Hi  All,
> 
> This conversation didn't start out in dealing with educational 
> institutions, it
> started out as a group that wants to use it to make money.
> 
> Oracle is making every effort to work with legitimate education 
> institutions.  The
> Oracle Academic Initiative does exactly what you describe. 
> Institutions 
> pay  a
> small fee (500.00 I think) they are have access to ALL Oracle
> Software 
> for use in
> instruction.  They also have access to Oracle University Curriculum
> if 
> desired.
> 
> more information can be found at:
> http://oai.oracle.com
> 

Sounds good. It's not that expensive! I wonder if Oracle instructors
cost more than MS SQL instructors that's why most schools (where I
am)offer MS SQL?

-- 
Lyndon Tiu

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

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

RE: Identifying Long Running SQL's

[DENNIS WILLIAMS]

Please ignore that reply. Not a time warp, but I was going through some old
emails, became confused and replied to it (probably gave the same reply as a
year ago).

-Original Message-
Sent: Tuesday, February 11, 2003 1:58 PM
To: '[EMAIL PROTECTED]'


Helen - Do you use STATSPACK included free with Oracle? Part of the standard
is several pages each listing the most inefficient SQL code by several
criteria.

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


-Original Message-
Sent: Friday, February 08, 2002 12:59 AM
To: Multiple recipients of list ORACLE-L


Does anyone have a script that can identify the most inefficient SQL code
running in the application
ranking from least to most efficient?



Helen J Mitchell
Oracle Database Administrator
E - [EMAIL PROTECTED]

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

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

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

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

[Lyndon Tiu]

Quoting Keith Moore <[EMAIL PROTECTED]>:

> Oracle makes money there too. I teach Oracle classes at a community
> college.
> They pay a fee to Oracle and use the same books, powerpoint slides,
> etc.
> It's the exact same class, just taught by someone other than
> Oracle. It's
> amazing that more people don't take these classes instead of
> through Oracle
> education. They are significantly cheaper. But, they are mainly
> night
> classes, so maybe most businesses don't like that.
> 

Good news to me, although I would say ain't enough of this because I
can't seem to find one where I live. 

All I see are MS SQL classes all over the place. 

The school where I graduated from offers MS SQL. I ask them about
Oracle and they gave me an answer - "We teach SQL using MS SQL.".

-- 
Lyndon Tiu

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

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

Re: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting [EMAIL PROTECTED]:
> Beacuse it's proprietary.  Any dunce can create a flat ascii
> text file,
> which probably accounts for the wide audience it gets.  But it
> takes a PHD to
> read a binary one.  BTW: IBM and M$'s dump files are binary as
> well.
> 
> Also, Oracle's default installation does scale, although not as
> well as it
> should.  And to boot that's the reason your boss pays you.  Look at
> as job
> justification.

Vendor Lock-in.

I hate it when default installs of Oracle complains it does not have
enough shared pool after about 30 connections and a small 10,000 entry
database with no pl/sql stored procedures.

I then have to go around fixing everyone's init.ora because none has a
clue why Oracle would complain about not having enough memeory when
the machine it runs on has 2GB of memory - and it's not even my job to
do this tweaking (it's someone else who went to Oracle class for $$$
company paid and still does not know), it just so happens I know how
to fix it that's why I get called to fix it.

-- 
Lyndon Tiu

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

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

Re: Oracle License for Training

[Ora NT DBA]

You are WRONG! The Oracle Academic Initiative has 100's of members.  In California
there are more than 200.

John

[EMAIL PROTECTED] wrote:

  Quoting Markus Reger <[EMAIL PROTECTED]>:

  
  
I have to manage MySQL and ORACLE for the web likewise.
There seems to be a strong tendency towards MySQL if people newly
enter the area of webpresence, students or profs doesn't make a
difference.


  
  
For web work. MySQL is very popular (Together with PHP).

For everything else, Access is usually the intro if developing dektop
apps. MS SQL if the intro is a bit higher end (non-desktop
applications). DB2 is also an intro in some schools.

You never see Oracle as the intro DB in any school (a real school as
in University, College, High School not those $$$ making diploma mills).

  

RE: Identifying Long Running SQL's

[DENNIS WILLIAMS]

Helen - Do you use STATSPACK included free with Oracle? Part of the standard
is several pages each listing the most inefficient SQL code by several
criteria.

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


-Original Message-
Sent: Friday, February 08, 2002 12:59 AM
To: Multiple recipients of list ORACLE-L


Does anyone have a script that can identify the most inefficient SQL code
running in the application
ranking from least to most efficient?



Helen J Mitchell
Oracle Database Administrator
E - [EMAIL PROTECTED]

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

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

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

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

Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

[dgoulet]

Lyndon,

Beacuse it's proprietary.  Any dunce can create a flat ascii text file,
which probably accounts for the wide audience it gets.  But it takes a PHD to
read a binary one.  BTW: IBM and M$'s dump files are binary as well.

Also, Oracle's default installation does scale, although not as well as it
should.  And to boot that's the reason your boss pays you.  Look at as job
justification.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   2/11/2003 10:34 AM

Quoting [EMAIL PROTECTED]:

> Lyndon,
> 
> True, an export file is peculiar to Oracle.  The difference
> between a
> commercial database and an open source one.  IBM and MicroSludge do
> the same. 
> The functional purpose though is the same.

Question:

Why a binary file? More efficient? I find the plain text output more
useful and easy to store. Recovery is easier as well, just cut and
past the relevant lines of script and run it.

-- 
Lyndon Tiu

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

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


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

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

Re: Oracle License for Training

[Ora NT DBA]

Hi  All,

This conversation didn't start out in dealing with educational institutions,
it 
started out as a group that wants to use it to make money. 

Oracle is making every effort to work with legitimate education institutions.
 The 
Oracle Academic Initiative does exactly what you describe.  Institutions
pay  a
small fee (500.00 I think) they are have access to ALL Oracle Software for
use in 
instruction.  They also have access to Oracle University Curriculum if desired.

more information can be found at:
http://oai.oracle.com

Regards,
John 

[EMAIL PROTECTED] wrote:

  Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

  
  
Richard - How do you think the Oracle Education division would
react to this
proposal? ;-) 
   Never underestimate the power of corporate politics. But
seriously a
large organization succeeds to the extent that it can look at the
long-term
good of the organization. Overall I think Oracle Corp. has a pretty
good
track record in this respect, and that has contributed to its
excellent
growth. Who knows, maybe Oracle will consider your idea. It seems
that
Microsoft has a different business model for education. I don't
think
Microsoft teaches any classes directly, but just certifies
training
organizations and instructors.


  
  
The point here is to allow people easier access to Oracle knowledge,
through courses you can pick up at your local community college. 

What Oracle is doing right now is stifling this.

  

RE: Trolling for ideas

[DENNIS WILLIAMS]

Jerry - Thanks for your reply. Yes Jeff Herrick did reply, and even
explained why it would be futile in this specific situation. 

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


-Original Message-
Sent: Tuesday, February 11, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis,

"Does anyone know how to turn on client-side SQL*Net tracing?"

Did anybody get back to you on this? Set these paramters in your
sqlnet.ora file on the client you want to trace:

TRACE_LEVEL_CLIENT = support
trace_file_client=abfp_trace.txt
trace_directory_client=c:\orant\net80\admin



- Jerry



-Original Message-
Sent: Monday, February 10, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L


Does anyone know how to turn on client-side SQL*Net tracing?

Jeff - Thanks for your idea. We were able to find the sqlnet.log file,
which I was unable to find previously. It does have the TNS-12560 error
you predicted. The network guys think they have the switch port
hard-coded to 100Mb/s full duplex, but are checking further.
   However, in the sqlnet.log, it says PROTOCOL=BEQ. Does anyone have
any idea where that is coming from? In the tnsnames.ora file we have
TCP. In the documentation it looks like BEQ is used when the listener
and server are on the same node. It is true that both the listener and
server are on the same Alpha server, so is this message normal?

Thanks to everyone for the great ideas that you have provided on this
issue.

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


-Original Message-
Sent: Thursday, February 06, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L



Dennis

Is there an sqlnet.log file tossed up on the VB client that has a
TNS-12203 (unable to connect to destination) error?

If so, make sure that the switch port the Alpha is plugged into has been
hard-coded to 100Mb/s full duplex.

"Friends don't let friends auto-negotiate"

Known problem with Alpha/Cisco gear...

Just a shot in the dark...but this solved a lot of Maximo crash issues
for us.


Cheers


Jeff Herrick

On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote:

> I have a developer that wrote a VB program using ADO, connecting to 
> Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for 
> hours each night, and sometimes receives an ORA-03113 end-of-file on 
> communication channel. Not consistently, just sporadically, and at 
> varying amounts of time. I have been unable to find anything in the 
> server logs. We have
traced
> the program and the error occurs during different SQL statements. 
> Followed most of the tips I've located on solving ORA-03113 errors. I 
> am coming to the conclusion that maybe the only solution will be to 
> upgrade Oracle and hope that solves the problem. Unfortunately we can 
> only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? 
> Thanks.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).
>

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

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

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

RE: RE: Oracle TEMPORARY SEGMENT

[M Rafiq]

Jerry,

It was just for update. True temporary tablespace cannot be created using 
datafile(dictionery managed) but tempfile which is allowable by locally 
managed tablespace. I just tried to create it with datafile but it gave me 
error.

Here, on this list we are learning everyday something new from each other.

Have a nice day

Regards
Rafiq





To: <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Date: Tue, 11 Feb 2003 13:11:11 -0600

Rafiq,

I'm not using locally managed tablespaces just yet. If the definition of  
'truly temporary'  includes locally managed tablespace, then you are 
correct.

Thanks for keeping me on the straight and narrow.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

> -Original Message-
> From:	M Rafiq [SMTP:[EMAIL PROTECTED]]
>
> Jerry,
>
> Your sql will never run on Temp tablespace 'that are truly temporary' in
> 8.1.7
>
> Just see the results
>
> Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.2.0 - Production
>
> SQL> alter tablespace temp default storage(pctincrease 10);
> alter tablespace temp default storage(pctincrease 10)
> *
> ERROR at line 1:
> ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
>
> If you use temporary_data_files(truly temp tablespace)for temp tablespace
> with locally managed tablespace , this will not work...
>
> Regards
> Rafiq
>


_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

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

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

RE: rootpre.sh

[Ehresmann, David]

That is what Oracle is 
saying.  That you need a 32-bit kernel extension to run 64bit 
Oracle.
thanks,
David 
Ehresmann

  -Original 
  Message-From: Scott Behrens 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11, 2003 
  12:56 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: rootpre.sh
  David,
     I haven't installed Oracle 8.1.7 or 9.2 to AIX 
  5.1 yet, but thanks 
  to a data storage interrupt kernel panic on a 5.1 box, I do 
  know 
  that 'crash' has been replaced by 'kdb' for examining crash 
  dumps.  
  So, rootpre.sh is going to break on the 
  line 
    'PKEXT_PATH='echo le | crash | blah blah 
  blah...'
  I think the question is - do you need the post-wait kernel
  extension at AIX 5.1?   
   
  I don't know about Oracle 8.1.7, but the 9.2 Installation Guide
  (p. 2-35) says:  "For Oracle9i 9.2.0.1.0 on AIX 5L, the 
functon
  and performance benefits of the Oracle post-wait kernel 
  extension are incorporated into the AIX kernel.  Oracle 9i
  9.2.0.1.0 on AIX 5L does not require the Oracle post-wait 
  kernel extension to be loaded."
   
  (This begs the question as to whether I still would need to run 
  
  rootpre.sh for asyncronous I/O configuration.  Presumably, I 
  could use smit to configure async I/O.) 
   
  It seems to me I read somewhere that 8.1.7 still requires a
  32-bit kernel extension and therefore, you may not be able
  to run a 64-bit AIX kernel with 8.1.7.  
   
  Scott
  >>> [EMAIL PROTECTED] 2/11/03 12:59:53 PM 
  >>>I am trying to run rootpre.sh.  My admin just upgrade the 
  kernel to 64-bit.We were running 32-bit on this box and everything was 
  fine.  No Oraclesoftware is running.  I am going to install 
  64-bit 8.1.7 Ent Ed for AIX 5.1Lwhen I got this trying to run 
  rootpre.sh.This is what I get when I run:#./rootpre.sh Installing 
  kernel extension... Oracle Kernel Ext... Copyright 
  Kernel Extension Version: 3 nkext ver: 3 
  ./rootpre.sh[199]: crash: not found. is not loaded : 1 No 
  post-wait kernel is loaded on the machine. Copying new kernel 
  extension. Oracle Kernel Extension Loader for AIX 
  Copyright. Kernel Extension Version: 3 
  SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path 
  '/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... 
  Asynchronous I/O is already defined thanks,David 
  Ehresmann    -- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net-- Author: 
  Ehresmann, David  INET: [EMAIL PROTECTED]Fat City 
  Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like 
subscribing).

Re: Oracle License for Training

[Keith Moore]

Oracle makes money there too. I teach Oracle classes at a community college.
They pay a fee to Oracle and use the same books, powerpoint slides, etc.
It's the exact same class, just taught by someone other than Oracle. It's
amazing that more people don't take these classes instead of through Oracle
education. They are significantly cheaper. But, they are mainly night
classes, so maybe most businesses don't like that.

Keith

>
> The point here is to allow people easier access to Oracle knowledge,
> through courses you can pick up at your local community college.
>
> What Oracle is doing right now is stifling this.
>
> --
> Lyndon Tiu
>



The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged 
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

interMedia Textkey (DRG-10826)

[Gary Chambers]

All...

I'm running Oracle 8.1.6 on Solaris 8.

Will someone please help me understand the Textkey parameter in
the ctx_doc.themes function?  I am receiving a DRG-10826 error on:

exec
ctx_doc.themes('ctx_webdocs', 1, 'MYTHEMES', 1, full_themes => TRUE);

The index is on a BLOB column that, for the moment, contains only
textual data (not that it really matters, anyway).  I don't understand
the relation of the textkey to the table.

TIA!!

Gary Chambers

//--
// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--

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

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

RE: RE: Oracle TEMPORARY SEGMENT

[Whittle Jerome Contr NCI]

Title: RE: RE: Oracle TEMPORARY SEGMENT






Rafiq,

I'm not using locally managed tablespaces just yet. If the definition of  'truly temporary'  includes locally managed tablespace, then you are correct.

Thanks for keeping me on the straight and narrow.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From:   M Rafiq [SMTP:[EMAIL PROTECTED]]

Jerry,

Your sql will never run on Temp tablespace 'that are truly temporary' in 

8.1.7

Just see the results

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production

With the Partitioning option

JServer Release 8.1.7.2.0 - Production

SQL> alter tablespace temp default storage(pctincrease 10);

alter tablespace temp default storage(pctincrease 10)

*

ERROR at line 1:

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

If you use temporary_data_files(truly temp tablespace)for temp tablespace  

with locally managed tablespace , this will not work...

Regards

Rafiq

RE: Count(*) last 30 seconds

[Richard Ji]

It used to be different, but Oracle has long optimized count(*)
so it all does the same thing now.  What version of the doc did
you read this from?

Richard

-Original Message-
Sent: Tuesday, February 11, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Because Oracle documentation says that count(1) has better performance than 
count(*).
I do not know why is it so. WIll it make clear some guru on this list?

JP

On Tuesday 11 February 2003 18:59, you wrote:
> Why use count(1) instead of count(*)?  They all does the same thing.
> So does count(primary key).
>
> Richard Ji
>
> -Original Message-
> Sent: Tuesday, February 11, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
>
> JP
>
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

Re: copyright

[Dave Morgan]

Hi Tim,
A few thoughts,

>It's a script
- Oracle RDBMS is a bunch of scripts
>It was posted on the internet
- Oracle is available on the internet

Does this mean I can download Oracle, place it on
my website legally, call it notoracle and sell it?

Or 

I found this script on the web

#!/bin/ksh
#
# File: oramem.sh
# Type: UNIX korn-shell script
# Author:   Tim Gorman, Sagelogix Inc.
# Date: 28jun02
#
# Description:
#
#   This shell script utilizes the "pmap -x" command to total up the
#   total amount of virtual memory used by all of the Oracle server
#   processes (both "background" and "foreground") belonging to a
#   database instance.
#
# Modifications:
# TGorman 28jun02 written for Solaris 2.8

How about if I put this on my website after I remove
all references to yourself and SageLogix and claim to be the
author?

How about if I rewrite in bourne sh, keep all the references
and post it?

The first is definitely illegal, the second might be, (you don't 
explicitly give permission to copy the script, but accepted practise 
in the area is that attribution is enough). You will definitely be 
unhappy with the first, you might be proud you were attributed 
in the second.

Some basic facts, Jared wrote it, Jared owns the copyright. The
fact that he makes it publically available is irrelevant. Oracle is
using his work, without attribution in a paid service. (Metalink, from
which the page is now unavailable, gee I wonder why). 

A copyright is intellectual property, removal of a copyright notice
is illegal. Consult SageLogix's lawyers, mine would have loved to 
work for Jared, would have done it on contigency basis. Bad manners
is not an acceptable legal defence.

This has everything to do with copyrights, patents, and theft.
Personally, I think it adds to Jared's reputation but what happens 
if this is not challenged and 5 years from now they
come back at Jared and say you are distributing one of our scripts?
Defending oneself in that situation would be impossible.

Tilting at windmills. Protesting illegal actions taken by large 
corporations is futile? Standing up for ones rights is pointless?

Come to Canada where we know how to treat monopolies ;-) Badly

An apology, for protecting his intellectual capital, especially
since the offending page has (again) been removed. OK. 

Jared, if I have interfered unseemingly in your life I am sorry,
but I think minor issues like this can hve very wide ramifications.
However, this belief does not give me to right to interfere.
I did not email Oracle, the only comment was to this forum.

Dave

> 
>  From: "Tim Gorman" <[EMAIL PROTECTED]>
>  Date: Mon, 10 Feb 2003 21:12:17 -0700
>  Subject: Re: dump.sql
> 
> This has nothing to do with copyrights, patents, reputation, or IP.
> It's a
> script.  It was posted on the internet.  Nothing more than a case of bad
> manners.
> 
> There is no disservice in not tilting at this particular windmill.  You
> owe
> Jared an apology.
> 
> --

-- 
Dave Morgan
Operations Manager, Rigskills Canada
Canada's Geographical Oilfield Services Locator
http://www.rigskills.ca
[EMAIL PROTECTED]
403 399 2442
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

Re: rootpre.sh

[Scott Behrens]

David,
   I haven't installed Oracle 8.1.7 or 9.2 to AIX 
5.1 yet, but thanks 
to a data storage interrupt kernel panic on a 5.1 box, I do 
know 
that 'crash' has been replaced by 'kdb' for examining crash 
dumps.  
So, rootpre.sh is going to break on the 
line 
  'PKEXT_PATH='echo le | crash | blah blah 
blah...'
I think the question is - do you need the post-wait kernel
extension at AIX 5.1?   
 
I don't know about Oracle 8.1.7, but the 9.2 Installation Guide
(p. 2-35) says:  "For Oracle9i 9.2.0.1.0 on AIX 5L, the functon
and performance benefits of the Oracle post-wait kernel 
extension are incorporated into the AIX kernel.  Oracle 9i
9.2.0.1.0 on AIX 5L does not require the Oracle post-wait 
kernel extension to be loaded."
 
(This begs the question as to whether I still would need to run 
rootpre.sh for asyncronous I/O configuration.  Presumably, I 
could use smit to configure async I/O.) 
 
It seems to me I read somewhere that 8.1.7 still requires a
32-bit kernel extension and therefore, you may not be able
to run a 64-bit AIX kernel with 8.1.7.  
  
Scott
>>> [EMAIL PROTECTED] 2/11/03 12:59:53 PM 
>>>I am trying to run rootpre.sh.  My admin just upgrade the 
kernel to 64-bit.We were running 32-bit on this box and everything was 
fine.  No Oraclesoftware is running.  I am going to install 64-bit 
8.1.7 Ent Ed for AIX 5.1Lwhen I got this trying to run rootpre.sh.This 
is what I get when I run:#./rootpre.sh Installing kernel extension... 
Oracle Kernel Ext... Copyright Kernel 
Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not 
found. is not loaded : 1 No post-wait kernel is loaded on the 
machine. Copying new kernel extension. Oracle Kernel Extension 
Loader for AIX Copyright. Kernel Extension Version: 3 
SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path 
'/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... 
Asynchronous I/O is already defined thanks,David 
Ehresmann    -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: 
Ehresmann, David  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Count(*) last 30 seconds

[JayMiller]

Does it take the same amount of time if you run the count(*) a second time
(i.e., might it reading the entire table from disk the first time)?

Jay Miller

-Original Message-
Sent: Tuesday, February 11, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

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

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

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

RE: Trolling for ideas

[Cunningham, Gerald]

Hi Dennis,

"Does anyone know how to turn on client-side SQL*Net tracing?"

Did anybody get back to you on this? Set these paramters in your
sqlnet.ora file on the client you want to trace:

TRACE_LEVEL_CLIENT = support
trace_file_client=abfp_trace.txt
trace_directory_client=c:\orant\net80\admin



- Jerry



-Original Message-
Sent: Monday, February 10, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L


Does anyone know how to turn on client-side SQL*Net tracing?

Jeff - Thanks for your idea. We were able to find the sqlnet.log file,
which I was unable to find previously. It does have the TNS-12560 error
you predicted. The network guys think they have the switch port
hard-coded to 100Mb/s full duplex, but are checking further.
   However, in the sqlnet.log, it says PROTOCOL=BEQ. Does anyone have
any idea where that is coming from? In the tnsnames.ora file we have
TCP. In the documentation it looks like BEQ is used when the listener
and server are on the same node. It is true that both the listener and
server are on the same Alpha server, so is this message normal?

Thanks to everyone for the great ideas that you have provided on this
issue.

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


-Original Message-
Sent: Thursday, February 06, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L



Dennis

Is there an sqlnet.log file tossed up on the VB client that has a
TNS-12203 (unable to connect to destination) error?

If so, make sure that the switch port the Alpha is plugged into has been
hard-coded to 100Mb/s full duplex.

"Friends don't let friends auto-negotiate"

Known problem with Alpha/Cisco gear...

Just a shot in the dark...but this solved a lot of Maximo crash issues
for us.


Cheers


Jeff Herrick

On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote:

> I have a developer that wrote a VB program using ADO, connecting to 
> Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for 
> hours each night, and sometimes receives an ORA-03113 end-of-file on 
> communication channel. Not consistently, just sporadically, and at 
> varying amounts of time. I have been unable to find anything in the 
> server logs. We have
traced
> the program and the error occurs during different SQL statements. 
> Followed most of the tips I've located on solving ORA-03113 errors. I 
> am coming to the conclusion that maybe the only solution will be to 
> upgrade Oracle and hope that solves the problem. Unfortunately we can 
> only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? 
> Thanks.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).
>

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

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

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

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

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

RE: AW: RMAN: I don't trust it

[Lyndon Tiu]

Quoting Richard Ji <[EMAIL PROTECTED]>:

> Why should the default be scalable?  Please tell me, how does
> Oracle know
> how many CPU, Memory, the type of IO system, transaction volume and
> whether
> it's OLTP or DSS, on and on...  Every database application is
> different.
> Scalability means different things to different database
> environments.
> And editing init.ora is not how you achive scalability.  Some of
> the tuning
> solution might come down to change a init parameter but most of
> them aren't.


I got this from the idea from "Why should default OS installs be
secure?" Most Linux and even MS are making their OS more secure by
default right after a fresh install. 

Why can't Databases be like that (more scalable)? Can't it be more
intelligent? Can't it figure out on it's own how many cpu and how much
memory it runs on? Can't it figure out on it's own that a temp
tablespace for sorting is being used all the time while there is a 1GB
of free extra memory available for sorting and that it should increase
sort memeory space dynamically?

Database tuning should be made more automatic - somewhat like Oracle's
locally managed tablespace feature.

Perhaps this is the way databases should go - intelligent self-tuning.
It will be hard to accomplish but is possible. Hopefully, we will get
there (slowly) one day.

-- 
Lyndon Tiu

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

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

RE: AW: RMAN: I don't trust it

[Richard Ji]

Geez, I think we are getting further and further from the original topic
now.
Let's stop or start a new thread.
So are you saying MS's got a better backup/recovery than Oracle because
it only requires one day of training, or something else?  Sorry I missed
your point.

-Original Message-
Sent: Tuesday, February 11, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L


you really want to go there?  compare MS SQL's backup & recovery training to
Oracle's.
 
MS: 1 day of the 5 day intro admin class

Oracle: more than a day of the 5 day 9i Admin II class - and you have 5 days
in Admin I before that

used to be worse - was a separate 3 day course in Oracle land.

of course M$ can't take the credit for that - they didn't design that RDBMS.
got it from Sybase ;)

-Original Message-
Sent: Tuesday, February 11, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L


I agree that HSql is not meant to compete with Oracle or Postgresql.
But then is Postgresql meant to compete with Oracle?  I don't think so.
My point of bring HSql in is to show that you aren't comparing the
samething.
It would make more sense say to compare the diffculty of backup/recovery
between Oracle, DB2, MS SQL, because these databases are in the same playing
field.

Richard Ji

-Original Message-
Sent: Tuesday, February 11, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Hi

I just posted that as reply to your question about hsql (what is it ?).
But you're right here, it is not very scalable and also not meant to compete
with Oracle or PostgreSQL.

Enjoy your day,

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED].

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 16:54
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it


Quoting Stefan Jahnke <[EMAIL PROTECTED]>:

> Hi Lyndon
> 
> hsql == HypersonicSQL. It's a pure Java, lightweight database
> server. Not
> suitable for large amounts of data, more the way to go if you're
> looking for
> an SQL database to embed into your Java app.
> 

I thought we were talking about Oracle and Postgresql here? hsql is
not scalable means I'd rather use Access.

-- 
Lyndon Tiu

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

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


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

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

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

RE: SQL Plus Environment

[Koivu, Lisa]

Hi Dave, 

Here's how mine is set up (SqlPlus client 8.1.7)

$oracle_home\bin\login.sql, fires when I log in
Calls a mylogin.sql file complete with path. 

login.sql Looks like this

@c:\oracle\ora81\sqlplus\admin\mylogin.sql
set linesize 2000
column name format a40
column column format a20

mylogin.sql looks like this

set pause off
set termout off
SET ARRAYSIZE 3
column dbsid new_value dbsid noprint
select global_name  dbsid from
global_name;
column dbusr new_value dbusr noprint
select user dbusr from dual;
set sqlprompt '(&dbsid-&dbusr)>'
set termout on
UNDEF DBSID
UNDEF DBUSR

set linesize 100
set pagesize 100


HTH, and have a great day.  Tell everyone on OT hello.

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117  
Fax:954-935-3639
Cell:954-683-4459


-Original Message-
Sent: Tuesday, February 11, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L


I want to set up a glogin.sql and a login.sql.  I am reading the manual and I find 
this.  Oh yea. I'm on 8.1.7 on NT.

When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL 
is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. 
If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape 
sequences. 
See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide 
and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and 
GLOGIN.SQL files. 

I can find the glogin.sql on my client PC and have edited it to my liking.  But I 
cannot find the login.sql and I do not have the DBS directory.  I see a DBS directory 
on the server but not on the client.  Am I missing something or does login.sql not 
exist on 8.1.7.

Thanks,

Dave

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

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

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

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

RE: Oracle License for Training

[Lyndon Tiu]

Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> Richard - How do you think the Oracle Education division would
> react to this
> proposal? ;-) 
>Never underestimate the power of corporate politics. But
> seriously a
> large organization succeeds to the extent that it can look at the
> long-term
> good of the organization. Overall I think Oracle Corp. has a pretty
> good
> track record in this respect, and that has contributed to its
> excellent
> growth. Who knows, maybe Oracle will consider your idea. It seems
> that
> Microsoft has a different business model for education. I don't
> think
> Microsoft teaches any classes directly, but just certifies
> training
> organizations and instructors.
> 

The point here is to allow people easier access to Oracle knowledge,
through courses you can pick up at your local community college. 

What Oracle is doing right now is stifling this.

-- 
Lyndon Tiu

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

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

Re: Count(*) last 30 seconds

[Jan Pruner]

Because Oracle documentation says that count(1) has better performance than 
count(*).
I do not know why is it so. WIll it make clear some guru on this list?

JP

On Tuesday 11 February 2003 18:59, you wrote:
> Why use count(1) instead of count(*)?  They all does the same thing.
> So does count(primary key).
>
> Richard Ji
>
> -Original Message-
> Sent: Tuesday, February 11, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
>
> JP
>
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

RE: [Q] how to check object or role grant to public?

[Charu Joshi]

Hi,

You want to check the views:
DBA_ROLE_PRIVS, DBA_SYS_PRIVS, DBA_TAB_PRIVS, ROLE_SYS_PRIVS,
ROLE_ROLE_PRIVS.

You can refer the 'Oracle 8i reference' for description of these.

Regards,
Charu.

-Original Message-
Sent: Tuesday, February 11, 2003 6:26 PM
To: Multiple recipients of list ORACLE-L

e have ORACLE 8.1.7 on SUN erver.  My question are:

  1. how to check which object or role are grant to public (from DBA)?
 (e.g. grant select on tax to public)

  2. How to check which object or role are grant to which users?

Thanks.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

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

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

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

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

RE: Count(*) last 30 seconds

[Toepke, Kevin M]

With Oracle 6 and sometimes in Oracle 7 one count was faster than the other.


With Oracle 8.0+ you'll see that count(1) == count(*) == count(unique
column) == count(not null column) 

Don't believe me? Try it. 

-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L


Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(). 

Sunil Nookala
DBA
Dell Corp.



-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

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

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


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

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

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

RE: Oracle License for Training

[Lyndon Tiu]

Quoting Markus Reger <[EMAIL PROTECTED]>:

> I have to manage MySQL and ORACLE for the web likewise.
> There seems to be a strong tendency towards MySQL if people newly
> enter the area of webpresence, students or profs doesn't make a
> difference.
> 

For web work. MySQL is very popular (Together with PHP).

For everything else, Access is usually the intro if developing dektop
apps. MS SQL if the intro is a bit higher end (non-desktop
applications). DB2 is also an intro in some schools.

You never see Oracle as the intro DB in any school (a real school as
in University, College, High School not those $$$ making diploma mills).

-- 
Lyndon Tiu

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

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

NEVER MIND - WAS - RE: SQL Plus Environment

[Farnsworth, Dave]

I fixed it.  I decided if the DBS directory was not created by the Oracle install than 
I will go and create the directory for Oracle.  I then dropped my login.sql into the 
directory, fired up SQLPlus and my login.sql worked.  Maybe I should of just sent a 
HELP instead.  ;o)

Dave

-Original Message-
Sent: Tuesday, February 11, 2003 12:22 PM
To: Multiple recipients of list ORACLE-L


I want to set up a glogin.sql and a login.sql.  I am reading the manual and I find 
this.  Oh yea. I'm on 8.1.7 on NT.

When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL 
is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. 
If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape 
sequences. 
See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide 
and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and 
GLOGIN.SQL files. 

I can find the glogin.sql on my client PC and have edited it to my liking.  But I 
cannot find the login.sql and I do not have the DBS directory.  I see a DBS directory 
on the server but not on the client.  Am I missing something or does login.sql not 
exist on 8.1.7.

Thanks,

Dave

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

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

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

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

RE: Count(*) last 30 seconds

[Rachel Carmichael]

If I remember correctly, there was a discussion here a while ago (like
a few years) on which was faster and I believe (caffeine levels are
low, so memory could be faulty) that it was determined that it made no
difference which you used.

This was pre 9i so things could have changed.


--- [EMAIL PROTECTED] wrote:
> Interestingly enough, I haven't seen an official statement on
> count(*) being
> slower than count(). 
> 
> Sunil Nookala
> DBA
> Dell Corp.
> 
> 
> 
> -Original Message-
> Sent: Tuesday, February 11, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
>   1. create unique index or primary key   AND update statistics of the
> table
>   2. use count(1) instead of count(*)
> 
> JP
> 
> On Tuesday 11 February 2003 17:19, you wrote:
> > Hi list,
> >
> > I issue a select count(*) from mytable and last 30 seconds.
> >
> > The table has 1,466,196 records and were loaded with a batch
> process, so
> > they are in a countinous space.
> >
> > I consider that time exagerated.
> >
> > The TBS is LMT with a Uniform size of 128 MB.
> >
> > The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
> >
> > Where should I start looking ???
> >
> > TIA
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121
> 
> -- 
>  Pruner Jan
>[EMAIL PROTECTED]
>  http://jan.pruner.cz/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: Looking for simple monitor script dbup.bat

[Husak, Orysia - Perot]

sorry my script is a UNIX script!

Orysia Husak
Database Management Services
perotsystems - CHW Phoenix
(602) 307-2896
(602) 300-9752 (Cell)


-Original Message-
Sent: Thursday, February 06, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L


Could you post it to the list?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 12:14 PM


> Bob,
> I have a very simple script which checks to see if the database is up and
> open. I've emailed you the script.
> 
> Orysia Husak
> Database Management Services
> PEROTSYSTEMS
> (602) 307-2896
> cell: (602) 300-9752
> 
> 
> -Original Message-
> Sent: Thursday, February 06, 2003 9:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Good morning everyone Win2k pro, oracle 8.17
> 
> Ive been investigating a simple monitor script which will email me if
> the database is not available. I need this to be as simple as possible
> (ideally a batch file)
> 
> Ive come across this on orafaq
> http://www.orafaq.net/scripts/win/isdbup.txt
> 
> But dosnt seem to work. If you pass an incorrect sid, or file parameters
> the script just hangs
> 
> I have a modified version 
> ##
> Rem dbup.bat
> @echo off
> set ORACLE_SID=locdb
> sqlplus internal/pw@%ORACLE_SID% @C:\conn.sql 
> 
> if {%ERRORLEVEL%} == {0} (
>echo Database %ORACLE_SID% is available
> ) else (
>echo Database %ORACLE_SID% is NOT available
> )
> ##
> 
> [conn.sql]
> set echo off feed off pages 0  
> -- whenever sqlerror exit sql.sqlcode
> WHENEVER SQLERROR EXIT 1
> select * from global_name;   
> exit ;
> ##
> 
> Although this works (gets into the error level) AFTER you hit enter to
> walk throough the errors
> The script gets stuck on Errors Such as 
> If the db is down
> ERROR:
> ORA-01034: ORACLE not available
> Enter user-name:
> ERROR:
> ORA-01017: invalid username/password; logon denied
> 
> Or if I pass and invalid sid, (I can live with only passing valid sids)
> but how can I get sql+ to exit out of the error if in fact the db is not
> up
> I think Ive tried all variations of SQLERROR 
> 
> http://lina.cli.di.unipi.it:8000/WG73-doc/sqlplus/sp33/ch646.html
> 
> Any ideas for the gurus??? 
> 
> Many thanks
> bob
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bob Metelsky
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Husak, Orysia - Perot
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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


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

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

RE: Count(*) last 30 seconds

[Sutton, Reed]

Unfortunately I don't have the reference in front of my right now, but I
believe the optimizer has a built in way to understand a count(*) and it is
just as fast or faster than count(column_name).

-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L


Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(). 

Sunil Nookala
DBA
Dell Corp.



-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

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

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


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

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

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

Re: Breaking down values in a large table

[Jared . Still]

John,

use the 'volsize' parameter.

Look at 'exp help=y'

Jared






"John Hallas" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/11/2003 06:19 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Breaking down values in a large table


Listers,
I have a table of 125M rows (not partitioned) which I am exporting. I want 
to break the export into 4 dmp files using the query command on the pk 
column.
 
I am looking at how the best way of finding the values of the PK (number) 
which are at 25%, 50% and 75% ish for the table so that I can get 4 evenly 
sized exports
 
My query line in the parameter file will be along the lines of where 
1)   log_no < xx
2)   log_no >= xx and < yy
3)   log_no >= yy and < zz
4)   log_no >= zz
 
I am thinking of a sql something like the following
 
Select /*+  index ffs(table_name index_name) */
Log_no , floor(log_no / 4), count(*)
>From table_name group by floor(log_no / 4), log_no
 
Version is 8.1.7.1
 
Can anybody help please
 
Thanks
 
John
 
 


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

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

Re: Re[2]: Re[2]: RMAN: I don't trust it

[Lyndon Tiu]

Quoting [EMAIL PROTECTED]:

> Lyndon,
> 
> True, an export file is peculiar to Oracle.  The difference
> between a
> commercial database and an open source one.  IBM and MicroSludge do
> the same. 
> The functional purpose though is the same.

Question:

Why a binary file? More efficient? I find the plain text output more
useful and easy to store. Recovery is easier as well, just cut and
past the relevant lines of script and run it.

-- 
Lyndon Tiu

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

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

RE: rootpre.sh

[Ehresmann, David]

I just found out from Oracle support that you can't run Oracle 8.1.7 64-bit
on AIX 64-bit.  Is this true and has anyone ever done it?

Thanks.
David Ehresmann.

-Original Message-
Sent: Tuesday, February 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L


I am trying to run rootpre.sh.  My admin just upgrade the kernel to 64-bit.
We were running 32-bit on this box and everything was fine.  No Oracle
software is running.  I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L
when I got this trying to run rootpre.sh.
This is what I get when I run:
#./rootpre.sh 
Installing kernel extension... 

Oracle Kernel Ext... 
Copyright 

Kernel Extension Version: 3 

nkext ver: 3 
./rootpre.sh[199]: crash: not found. 

is not loaded : 1 
No post-wait kernel is loaded on the machine. 

Copying new kernel extension. 

Oracle Kernel Extension Loader for AIX 
Copyright. 

Kernel Extension Version: 3 
SYS_SINGLELOAD: Exec format error 
kmid: 0 (0x0) 
path '/etc/pw-syscall' 
libpath:'' 

Configuring Asynchronous I/O... 
Asynchronous I/O is already defined 

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

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

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

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

Re: [Q] how to check object or role grant to public?

[Rachel Carmichael]

look at dba_tab_privs for object grants (this will include stored
procedures)

look at dba_role_privs for roles

and read the manuals, you'd be amazed at how many questions can be
answered by doing that


--- dist cash <[EMAIL PROTECTED]> wrote:
> 
> e have ORACLE 8.1.7 on SUN erver.  My question are:
> 
>   1. how to check which object or role are grant to public (from
> DBA)?
>  (e.g. grant select on tax to public)
> 
>   2. How to check which object or role are grant to which users?
> 
> Thanks.
> 
> 
> 
> 
> 
> 
> 
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: dist cash
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

How to send/receive email through pl/sql ??

[Janet Linsy]

Hi, I have the following code. it compiles fine and
runs successfully.  But when I checked email in
[EMAIL PROTECTED], I didn't get any mail.  I'm testing on
the same machine (win2000, 817).  Anybody knows why? 
Thank you in advance.


create or replace PROCEDURE send_test_message
IS
mailhostVARCHAR2(64) := 'localhost';
sender  VARCHAR2(64) := '[EMAIL PROTECTED]';
recipient   VARCHAR2(64) := '[EMAIL PROTECTED]';
mail_conn  utl_smtp.connection;
BEGIN
mail_conn := utl_smtp.open_connection(mailhost,
25);
utl_smtp.helo(mail_conn, mailhost);
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
-- If we had the message in a single string, we could
collapse
-- open_data(), write_data(), and close_data() into a
single call to data().
utl_smtp.open_data(mail_conn);
utl_smtp.write_data(mail_conn, 'This is a test
message.' || chr(13));
utl_smtp.write_data(mail_conn, 'This is line 2.'
|| chr(13));
utl_smtp.close_data(mail_conn);
utl_smtp.quit(mail_conn);
EXCEPTION
WHEN OTHERS THEN
   -- Insert error-handling code here
   NULL;
END;
/

__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

RE: Updating error

[Weiss, Rick]

David:

I would say that there is a foreign key on the originating_carrier column
and the value 0110 does not exist in the parent table.

Rick Weiss

-Original Message-
Sent: Tuesday, February 11, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L


I attempt to update a record and receive following error.  How do I fix it?

update trunkgroup 
set originating_carrier = 0110,trunkgroup_id2 = 606,'
where trunkgroup_id = '0TWPAAEDS0' and gateway_id = 'GAAA0';


ERROR at line 1:

ORA-02291: integrity constraint (DBIMPL.CARRIER_FK9) violated - parent key
not found

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

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

RE: [new info] Redhat Advanced Server Dev Edition - RAC

[John Kanagaraj]

Joe,

Moving a 11i environment to RAC to 'fix' performance issues will only worsen
it IMHO. Apps 11i is a complex beast, with a lot of cross-functional queries
as well as a hard-hit central set of tables belong to the AOL. You can bet
that there will be a ton of cross-instance pinging - albeit over the wire -
if the divvying up is not done carefully..

Just my 2c - and I may soon be available for tuning such a 11i instance
(hint! hint!)

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my
future! 

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Joseph S Testa [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 9:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: [new info] Redhat Advanced Server Dev Edition - RAC
> 
> 
> I'm with Mike on this one, except I was just told earlier this morning
> that the current client I'm at wants to move the 11i apps to RAC.  DO
> they need it, nope, do they want it, yep(and have basically 
> already cut
> the check for the cost of RAC(since its on sale till end of month) :)
> 
> So the experiment that I'll be starting next week will 
> probably become a
> reality in the next 60 days. :)
> 
> joe
> 
> 
> > I don't know anyone who needs it but Oracle is behind it and that
> means that
> > sooner or later they'll start to shift licenses. I'd be 
> foolish to ignore
> > the chance to experiment with RAC at home for £150 (I had a 
> lot of the kit
> > already) rather than pay Oracle £1158 for a 3 day RAC 
> course (plus the
> loss
> > of 3 days income).
> > Add on to that the amount I've learned about the linux 
> kernel and the fact
> > that frankly a firewire disk is just generally useful to have around
> > (backups/temporary storage for video or music) and I think 
> I'd be a mug to
> > do otherwise.
> > 
> > So no, I don't work for a company that needs this but in 
> the near future I
> > may.
> > 
> > Cheers,
> > Mike
> > 
> > -Original Message-
> > Sent: 11 February 2003 16:30
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > This is all cool technology, and fun stuff to play with.
> > 
> > It all begs the questions, 
> > 
> > "How many of us work for a business that actually need this?"
> > 
> > "Are they willing to pay $400/user $20k/CPU above the cost
> > of Oracle 9i EE to use it?"
> > 
> > "Are they willing to pay the extra overhead required to 
> maintain it?"
> > 
> > I'm not sure the ROI is there for many of us.  Though downtime
> > at our business is somewhat expensive, I think that a failover
> > system or even standby database will provide adequate coverage
> > for us, which is indeed a hot topic here right now, after our Dell
> > SAN put us out of business for 36 hours.  
> > 
> > RAC wouldn't have helped much there.  Niether would a cluster
> > for that matter.  Standby DB would have been perfect.
> > 
> > This whole push of RAC by Oracle reminds me very much of the
> > mlife phone campaign by ATT.  Do you really need to take pictures
> > with your phone?  And what is the point of sending text messages
> > to someone elses phone when you could just call them?
> > 
> > ATT needs you to buy this stuff, because they have it for sale.
> > 
> > I see RAC in  a similar light.  Do you need RAC?  Oracle needs
> > you to 'need' it, because they need some reason for you to
> > spend more money on their product.
> > 
> > Jared
> > 
> > 
> > 
> **
> >  
> > The information contained in this e-mail is confidential and 
> > intended only for the use of the addressee. If the reader of 
> > this message is not the addressee, you are hereby notified 
> > that you have received this e-mail in error and you must not 
> > copy, disseminate, distribute, use or take any action as a 
> > result of the information contained in it.
> > 
> > If you have received this e-mail in error, please notify 
> > [EMAIL PROTECTED] (UK 01384 275454) and delete it 
> > immediately from your system.
> > 
> > Neither Npower nor any of the other companies in the 
> > Innogy group from whom this e-mail originates accept any 
> > responsibility for losses or damage as a result of any viruses 
> > and it is your responsibility to check attachments (if any) for 
> > viruses.
> > Npower Limited
> > Registered office: Windmill Hill Business Park, Whitehill 
> > Way, Swindon SN5 6PB. Registered in England and Wales: 
> > number 3653277
> > This e-mail may be sent on behalf of a member of the Innogy 
> > group of companies.
> > 
> **
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Hately, Mike (NESL-IT)
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fa

Re: [Q] how to check object or role grant to public?

[Suzy Vordos]

dba_tab_privs
dba_role_privs
dba_sys_privs

dist cash wrote:
> 
> e have ORACLE 8.1.7 on SUN erver.  My question are:
> 
>   1. how to check which object or role are grant to public (from DBA)?
>  (e.g. grant select on tax to public)
> 
>   2. How to check which object or role are grant to which users?
> 
> Thanks.
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: dist cash
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

Re:RE: AW: RMAN: I don't trust it

[dgoulet]

Richard,

In theory, yes it can.  Would I want to push a postgresql database that
hard, maybe not.  But I will agree with Lyndon, it is a very nice open source
db.

Dick Goulet

Reply Separator
Author: Richard Ji <[EMAIL PROTECTED]>
Date:   2/11/2003 8:43 AM

Well no.  Since you are comparing Postgresql with Oracle, why
can't I compare it with HSql or any other database for that matter.
And is postgresql scalable compare to Oracle?  Can it handle my
Terabyte database?

-Original Message-
Sent: Tuesday, February 11, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L


Quoting Stefan Jahnke <[EMAIL PROTECTED]>:

> Hi Lyndon
> 
> hsql == HypersonicSQL. It's a pure Java, lightweight database
> server. Not
> suitable for large amounts of data, more the way to go if you're
> looking for
> an SQL database to embed into your Java app.
> 

I thought we were talking about Oracle and Postgresql here? hsql is
not scalable means I'd rather use Access.

-- 
Lyndon Tiu

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

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

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

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

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

SQL Plus Environment

[Farnsworth, Dave]

I want to set up a glogin.sql and a login.sql.  I am reading the manual and I find 
this.  Oh yea. I'm on 8.1.7 on NT.

When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL 
is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. 
If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape 
sequences. 
See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide 
and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and 
GLOGIN.SQL files. 

I can find the glogin.sql on my client PC and have edited it to my liking.  But I 
cannot find the login.sql and I do not have the DBS directory.  I see a DBS directory 
on the server but not on the client.  Am I missing something or does login.sql not 
exist on 8.1.7.

Thanks,

Dave

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

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

Re: [Q] how to check object or role grant to public?

[Thomas Day]

This asks for two parameters, the userid and the db_link.  If you leave the
db_link blank then it looks for the userid on the present database.  To
check for public give auserid of public.  Slice and dice to fit your needs.

-- Posted by Jacques Kilchoer <[EMAIL PROTECTED]> on ORACLE-L
set linesize 200
set pages 500
set verify off
column sort_id noprint
column priv_type format a31
column priv format a59
column grantable heading "ADM" format a3
column default_role heading "DEF" format a3
 select
  1 as sort_id,
  'ROLE' as priv_type,
  a.granted_role as priv,
  a.admin_option as grantable,
  a.default_role as default_role
   from
sys.dba_role_privs&&link   a
   where
grantee = upper('&&enter_username')
union
 select
  2 as sort_id,
 'SYS PRIV' as priv_type,
 b.privilege as priv,
 b.admin_option as grantable,
 null as default_role
  from
   sys.dba_sys_privs&&link  b
 where
  grantee = upper('&&enter_username')
union
 select
  5 as sort_id,
  'TAB PRIV (ROLE "' || c.granted_role || '")' as priv_type,
 d.privilege || ' on "' || d.owner ||
  '"."' || d.table_name || '"'
   as priv,
 d.grantable as grantable,
 c.default_role as default_role
  from
   sys.dba_role_privs&&link  c,
   sys.dba_tab_privs&&link  d
  where
   c.grantee = upper('&&enter_username')
   and d.grantee = c.granted_role
union
 select
  7 as sort_id,
  'COL PRIV (ROLE "' || e.granted_role || '")' as priv_type,
  f.privilege || ' on "' || f.owner ||
  '"."' || f.table_name || '" ("' || f.column_name || '")'
   as priv,
  f.grantable as grantable,
  e.default_role as default_role
 from
  sys.dba_role_privs&&link  e,
  sys.dba_col_privs&&link  f
 where
   e.grantee = upper('&&enter_username')
   and f.grantee = e.granted_role
union
 select
  4 as sort_id,
  'TAB PRIV' as priv_type,
  g.privilege || ' on "' || g.owner ||
   '"."' || g.table_name || '"'
as priv,
  g.grantable as grantable,
  null as default_role
 from
  sys.dba_tab_privs&&link  g
 where
  g.grantee = upper('&&enter_username')
union
 select
  6 as sort_id,
  'COL PRIV' as priv_type,
  h.privilege || ' on "' || h.owner ||
   '"."' || h.table_name || '" ("' || h.column_name || '")'
as priv,
  h.grantable as grantable,
  null as default_role
 from
  sys.dba_col_privs&&link  h
 where
  h.grantee = upper('&&enter_username')
union
 select
  3 as sort_id,
   'SYS PRIV (ROLE "' || i.granted_role || '")' as priv_type,
   j.privilege as priv,
   j.admin_option as grantable,
   i.default_role as default_role
 from
  sys.dba_role_privs&&link  i,
  sys.dba_sys_privs&&link  j
 where
  i.grantee = upper('&&enter_username')
  and j.grantee = i.granted_role
order by 1, 2, 3 ;

undefine enter_username
undefine link
clear columns
set linesize 80
set verify on




   

  "dist cash"  

  
  @hotmail.com>cc: 

  Sent by: rootSubject: [Q] how to check object or 
role grant to public?   
   

   

  02/11/2003 12:49 

  PM   

  Please respond   

  to ORACLE-L  

   

   






e have ORACLE 8.1.7 on SUN erver.  My question are:

  1. how to check which object or role are grant to public (from DBA)?
 (e.g. grant select on tax to public)

  2. How to check which object or role are grant to which users?

Thanks.








_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

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

Fat City Network Services-- 858-538-5051

RE: AW: RMAN: I don't trust it

[STEVE OLLIG]

you really want to go there?  compare MS SQL's backup & recovery training to
Oracle's.
 
MS: 1 day of the 5 day intro admin class

Oracle: more than a day of the 5 day 9i Admin II class - and you have 5 days
in Admin I before that

used to be worse - was a separate 3 day course in Oracle land.

of course M$ can't take the credit for that - they didn't design that RDBMS.
got it from Sybase ;)

-Original Message-
Sent: Tuesday, February 11, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L


I agree that HSql is not meant to compete with Oracle or Postgresql.
But then is Postgresql meant to compete with Oracle?  I don't think so.
My point of bring HSql in is to show that you aren't comparing the
samething.
It would make more sense say to compare the diffculty of backup/recovery
between Oracle, DB2, MS SQL, because these databases are in the same playing
field.

Richard Ji

-Original Message-
Sent: Tuesday, February 11, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Hi

I just posted that as reply to your question about hsql (what is it ?).
But you're right here, it is not very scalable and also not meant to compete
with Oracle or PostgreSQL.

Enjoy your day,

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED].

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 16:54
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it


Quoting Stefan Jahnke <[EMAIL PROTECTED]>:

> Hi Lyndon
> 
> hsql == HypersonicSQL. It's a pure Java, lightweight database
> server. Not
> suitable for large amounts of data, more the way to go if you're
> looking for
> an SQL database to embed into your Java app.
> 

I thought we were talking about Oracle and Postgresql here? hsql is
not scalable means I'd rather use Access.

-- 
Lyndon Tiu

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

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


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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.c

RE: AW: RMAN: I don't trust it

[Richard Ji]

Why should the default be scalable?  Please tell me, how does Oracle know
how many CPU, Memory, the type of IO system, transaction volume and whether
it's OLTP or DSS, on and on...  Every database application is different.
Scalability means different things to different database environments.
And editing init.ora is not how you achive scalability.  Some of the tuning
solution might come down to change a init parameter but most of them aren't.

Richard Ji

-Original Message-
Sent: Tuesday, February 11, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L


Quoting Richard Ji <[EMAIL PROTECTED]>:

I wonder how scalable PostGreSQL is by default using default configs?

I know Oracle in it's default configuration ain't scalable. Funny
cause I know certain companies use Oracle thinking this is the
solution to their database scalability problem. Only to be surprised
when the DB stops working and then finding out later that the init.ora
file needs to be edited for scalability. Oracle does not scale itself.
It needs to be configured to scale. Why isn't Oracle scalable by default? 

-- 
Lyndon Tiu

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

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

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

RE: [new info] Redhat Advanced Server Dev Edition - RAC

[Koivu, Lisa]

Welcome to Corporate America, where damagers who have never written a code in the last 
decade (if ever) and have been promoted beyond their competence level make decisions 
about what is best for their systems and applications.  DBA's and the like are little 
peeon grunts that do the work.  Who cares what they have to say or what they need to 
do their jobs.  

A quote from one of the marketing VP's here from his meeting with a consulting company 
who was doing a crap job maintaining a "data warehouse" for them, after he made the 
decision to sign the contract for another three years and several million dollars:  
"That was a nice lunch, wasn't it?"

How I miss working for a software company.

That is all.

Lisa Koivu
Oracle Sleep Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117  
Fax:954-935-3639
Cell:954-683-4459


-Original Message-
Sent: Tuesday, February 11, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L


I'm with Mike on this one, except I was just told earlier this morning
that the current client I'm at wants to move the 11i apps to RAC.  DO
they need it, nope, do they want it, yep(and have basically already cut
the check for the cost of RAC(since its on sale till end of month) :)

So the experiment that I'll be starting next week will probably become a
reality in the next 60 days. :)

joe


> I don't know anyone who needs it but Oracle is behind it and that
means that
> sooner or later they'll start to shift licenses. I'd be foolish to ignore
> the chance to experiment with RAC at home for £150 (I had a lot of the kit
> already) rather than pay Oracle £1158 for a 3 day RAC course (plus the
loss
> of 3 days income).
> Add on to that the amount I've learned about the linux kernel and the fact
> that frankly a firewire disk is just generally useful to have around
> (backups/temporary storage for video or music) and I think I'd be a mug to
> do otherwise.
> 
> So no, I don't work for a company that needs this but in the near future I
> may.
> 
> Cheers,
> Mike
> 
> -Original Message-
> Sent: 11 February 2003 16:30
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> This is all cool technology, and fun stuff to play with.
> 
> It all begs the questions, 
> 
> "How many of us work for a business that actually need this?"
> 
> "Are they willing to pay $400/user $20k/CPU above the cost
> of Oracle 9i EE to use it?"
> 
> "Are they willing to pay the extra overhead required to maintain it?"
> 
> I'm not sure the ROI is there for many of us.  Though downtime
> at our business is somewhat expensive, I think that a failover
> system or even standby database will provide adequate coverage
> for us, which is indeed a hot topic here right now, after our Dell
> SAN put us out of business for 36 hours.  
> 
> RAC wouldn't have helped much there.  Niether would a cluster
> for that matter.  Standby DB would have been perfect.
> 
> This whole push of RAC by Oracle reminds me very much of the
> mlife phone campaign by ATT.  Do you really need to take pictures
> with your phone?  And what is the point of sending text messages
> to someone elses phone when you could just call them?
> 
> ATT needs you to buy this stuff, because they have it for sale.
> 
> I see RAC in  a similar light.  Do you need RAC?  Oracle needs
> you to 'need' it, because they need some reason for you to
> spend more money on their product.
> 
> Jared
> 
> 
> **
>  
> The information contained in this e-mail is confidential and 
> intended only for the use of the addressee. If the reader of 
> this message is not the addressee, you are hereby notified 
> that you have received this e-mail in error and you must not 
> copy, disseminate, distribute, use or take any action as a 
> result of the information contained in it.
> 
> If you have received this e-mail in error, please notify 
> [EMAIL PROTECTED] (UK 01384 275454) and delete it 
> immediately from your system.
> 
> Neither Npower nor any of the other companies in the 
> Innogy group from whom this e-mail originates accept any 
> responsibility for losses or damage as a result of any viruses 
> and it is your responsibility to check attachments (if any) for 
> viruses.
> Npower Limited
> Registered office: Windmill Hill Business Park, Whitehill 
> Way, Swindon SN5 6PB. Registered in England and Wales: 
> number 3653277
> This e-mail may be sent on behalf of a member of the Innogy 
> group of companies.
> **
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hately, Mike (NESL-IT)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --

Re[2]: Re[2]: RMAN: I don't trust it

[dgoulet]

Lyndon,

True, an export file is peculiar to Oracle.  The difference between a
commercial database and an open source one.  IBM and MicroSludge do the same. 
The functional purpose though is the same.

Dick Goulet

Reply Separator
Author: Lyndon Tiu <[EMAIL PROTECTED]>
Date:   2/11/2003 7:44 AM

Quoting [EMAIL PROTECTED]:
> pg_dump equals export in Oracle. Actually "pg_dump all" =
> "export full=y". 
> It's just a syntax difference.  And if you have a full export all
> you need to to
> recreate the database is create the system tablespace.  And yes it
> is easy with
> Oracle, if you keep it simple.

WRONG!!!

---
>From Oracle9i Database Utilities Part No. A90192-01 page 1-2:

An Export file is an Oracle binary-format dump file that is typically
located on disk
or tape. The dump files can be transferred using FTP or physically
transported (in
Before Using Export
the case of tape) to a different site. The files can then be used with
the Import utility
to transfer data between databases that are on systems not connected
through a
network. The files can also be used as backups in addition to normal
backup
procedures.
Export dump files can only be read by the Oracle Import utility. The
version of the
Import utility cannot be earlier than the version of the Export
utility used to create
the dump file.
---

The Export file is not equal to pg_dump's output simply because
pg_dump's output is an actual plain text sql script that you can edit
with a plain text editor (i.e. vi), or simply run in a different SQL
based database. Export dump files are binary and are proprietary only
to Oracle (i.e. no other database understands it unless you convert it
first with some automagic third-party utility).

-- 
Lyndon Tiu

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

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


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

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

RE: Oracle License for Training

[Markus Reger]

I have to manage MySQL and ORACLE for the web likewise.
There seems to be a strong tendency towards MySQL if people newly enter the area of 
webpresence, students or profs doesn't make a difference.

PLEASE spare me the pain: I *DO* know the differences between ORACLE and MySQL. (... 
at least some of them)

It was just a remark about tendencies.

Apologies for any typing mistakes I failed to notice.


Markus Reger

Oracle Applications DBA
Webmaster
MBC

University for Music and Performing Art
Vienna
>>> [EMAIL PROTECTED] 02/11/03 18:55 PM >>>
Quoting Richard Ji <[EMAIL PROTECTED]>:

> I totally agree.  I alway thought Oracle should just give it
> away to class rooms.  The more people knows Oracle, they will
> want to use it at their work.  At a small, mid size company is
> often the tech guy who will have a big saying over what
> technology
> to use.
> 

But of course, Oracle does not know this. They are sitting on their
laurels thinking they are "THE" Database. They will lose the lower end
of the market and get pushed upmarket till there is no more room to go.

-- 
Lyndon Tiu

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

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


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

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

Updating error

[Nguyen, David M]

I attempt to update a record and receive following error.  How do I fix it?

update trunkgroup 
set originating_carrier = 0110,trunkgroup_id2 = 606,'
where trunkgroup_id = '0TWPAAEDS0' and gateway_id = 'GAAA0';


ERROR at line 1:

ORA-02291: integrity constraint (DBIMPL.CARRIER_FK9) violated - parent key
not found


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

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

RE: Count(*) last 30 seconds

[Richard Ji]

Why use count(1) instead of count(*)?  They all does the same thing.
So does count(primary key).

Richard Ji

-Original Message-
Sent: Tuesday, February 11, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
1. create unique index or primary key   AND update statistics of the
table
2. use count(1) instead of count(*)

JP

On Tuesday 11 February 2003 17:19, you wrote:
> Hi list,
>
> I issue a select count(*) from mytable and last 30 seconds.
>
> The table has 1,466,196 records and were loaded with a batch process, so
> they are in a countinous space.
>
> I consider that time exagerated.
>
> The TBS is LMT with a Uniform size of 128 MB.
>
> The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
>
> Where should I start looking ???
>
> TIA
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121

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

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

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

rootpre.sh

[Ehresmann, David]

I am trying to run rootpre.sh.  My admin just upgrade the kernel to 64-bit.
We were running 32-bit on this box and everything was fine.  No Oracle
software is running.  I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L
when I got this trying to run rootpre.sh.
This is what I get when I run:
#./rootpre.sh 
Installing kernel extension... 

Oracle Kernel Ext... 
Copyright 

Kernel Extension Version: 3 

nkext ver: 3 
./rootpre.sh[199]: crash: not found. 

is not loaded : 1 
No post-wait kernel is loaded on the machine. 

Copying new kernel extension. 

Oracle Kernel Extension Loader for AIX 
Copyright. 

Kernel Extension Version: 3 
SYS_SINGLELOAD: Exec format error 
kmid: 0 (0x0) 
path '/etc/pw-syscall' 
libpath:'' 

Configuring Asynchronous I/O... 
Asynchronous I/O is already defined 

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

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

RE: AW: RMAN: I don't trust it

[Richard Ji]

It does sound like a database command, doesn't it?
There are a quite a few open source database out there,
depends on what you need, they might just do the job as good
as any others.

-Original Message-
Sent: Tuesday, February 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L


Quoting Richard Ji <[EMAIL PROTECTED]>:

> Well no.  Since you are comparing Postgresql with Oracle, why
> can't I compare it with HSql or any other database for that
> matter.

You can compare anything here. 

I misunderstood hsql as an Oracle command/script/package (new?,
hidden?, secret??) that I have never encountered before. That's why I
freaked out when someone mentioned "You can do this with that... !" I
did not get the point that hsql is a different database.

Anyways. It's good to know there is another database out there.

Thanks.

-- 
Lyndon Tiu

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

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

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