Re: shell script to send mail

[Paul Drake]

funny.
Tripwire wasn't the only piece of code on that site.
How about this one: 
http://sourceforge.net/projects/lhc/Lame Hash Checker  Doph! - no cvs
commits.

yeah, those pieces that are labeled "pre-alpha" aren't really what
you're looking for.
The important thing is - when the code is up there, you'll be able to
see it, as its a GPL project.
Read the code. If you don't release it, you don't have to use the GPL.
But you can read it - and learn.

That was the point - look at a site that has GPL software. So I didn't
give you a direct hit.
There was that field "SEARCH" on sourceforge.

this one has actual code - and documentation
http://sourceforge.net/projects/integrit/ integrit file verification
system

So maybe you call a C routine like Integrit to get the MD5 hashes- and
wrap it in your shell of choice.
The hash table code that integrit uses has been made into a standalone
library that users can easily use in any
application. 

Getting warm. Getting tired too.

Funny, I just saw an Oracle Banner on sourceforge. 
how do those people at Double-Click figure that kinda stuff out? :P

Is that what the registry key ORACLE_AFFINITY means?

Paul

Viraj Luthra wrote:
> 
> Paul,
> 
> I dont need that software. I need the code to write in my software itself.
> 
> rgds,
> 
> raja
> --
> 
> On Mon, 09 Apr 2001 21:10:52
>  Paul Drake wrote:
> >check out tripwire ... http://sourceforge.net/projects/tripwire/
> >
> >Viraj Luthra wrote:
> >>
> >> Hello all,
> >>
> >> I need help. I need to write a shell script (aix box), when ever some loads a 
>piece of software.
> >>
> >> thanks
> >>
> >> raja
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Paul Drake
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> 
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Viraj Luthra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

Re: DATABASE DESING ISSUE

[Jared Still]

Questions:
 
> router statistics-> some numeric value
What does this data look like?
Is it atomic?  What does the numeric value represent?

>multiple cpu utilization data->again in numeric ,
Same questions as for router statistics

>  ip address..which would be primary key

Do you want to be able to easily search based partial IP?

Will your SQL queries always contain the first octet of the IP
address in the WHERE clause?

e.g. 

  for addresses 208.16.92.134  194.16.44.16 and 132.16.12.154
  would there ever be a search done on the second octet (16 )?

In other words, should the IP be stored in a single column, or
in four columns?

Is IPV6 compatibility important?

These questions must be asked to get an understanding of
how you are trying to use the data.

Jared
  

> i want to search the various cpu util data,memory utilisation data from ip
> address
> becuase each customer i am segregating by ip address


On Monday 09 April 2001 11:58, Nihar wrote:
> HI PPL
>  i need some help on database design stuff.
>
> i am having data given below in one flat file and i want to put in tables.
> can anyone help in designing tables
>
> here is the data the info bout data
>
>
>  my data is about
>  router statistics-> some numeric value
>  date,time,multiple cpu utilization data->again in numeric ,
>  ip address..which would be primary key
> i want to search the various cpu util data,memory utilisation data from ip
> address
> becuase each customer i am segregating by ip address
>
>
>  thanks and regards
>
>
> - NIHAR SANGHVI
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: shell script to send mail

[Viraj Luthra]

Paul,

I dont need that software. I need the code to write in my software itself.

rgds,

raja
--

On Mon, 09 Apr 2001 21:10:52  
 Paul Drake wrote:
>check out tripwire ... http://sourceforge.net/projects/tripwire/
>
>Viraj Luthra wrote:
>> 
>> Hello all,
>> 
>> I need help. I need to write a shell script (aix box), when ever some loads a piece 
>of software. 
>> 
>> thanks
>> 
>> raja
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Paul Drake
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


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

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

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

Re: shell script to send mail

[Paul Drake]

check out tripwire ... http://sourceforge.net/projects/tripwire/

Viraj Luthra wrote:
> 
> Hello all,
> 
> I need help. I need to write a shell script (aix box), when ever some loads a piece 
>of software. 
> 
> thanks
> 
> raja
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

Re: 8.1.6 on NT?

[Paul Drake]

Suhen Pather wrote:
> 
> Ron,
> 
> The 8.1.6 base release is not very stable.
> We found several problems with this release like pga memory leaks.
> 
> Try to load patch 8.1.6.1x patches and then patch to 8.1.6.3
> We use 8.1.6.3.4 patch for Windows NT 4.
> Pretty stable.
> 
> Do not just load 8.1.6.3.x on top of 8.1.6.0, cause there are some patches
> (8.1.6.1.x) which are not included in 8.1.6.3.x.
> 
> You can get the latest patches on Metalink
> 
> HTH
> Suhen
> 

Suhen,

I usually read the release notes pretty thoroughly.
The 8.1.6.3.0 + 8.1.6.3.4 patch set combo is comprehensive.
YOu are correct, in that some parts of the 8.1.6.1.5 set were missed in
8.1.6.3.0.
They'r ein 8.1.6.3.4.
If you installed the 8.1.6.1.x set and then applied the .3.0 set, you
will see that the Univeral installer uninstalls components of the
8.1.6.1.x patch set prior to installing the 8.1.6.3.0 set.

I think that I should have written that as a regular expression.

Paul

> We are having trouble with response time and server crashes on a new Oracle
> 8.1.6 NT database.  Seems like I heard that this release is not very stable.
> Has anyone had any experience with this release?  I have not applied any of
> the patchsets to 8.1.6.  Should I?  If so, can anyone point me to where
> there are on Metalink?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suhen Pather
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

RE: Database / OS monitoring tool

[Deshpande, Kirti]

Check BMC Software's PATROL  http://www.bmc.com
We use it on UNIX / Compaq (Alpha) platforms and I know they have a version
for MS Windows as well.
HTH
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Helmut Daiminger [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 6:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Database / OS monitoring tool
> 
> Hi!
> 
> What software is available that can be used for database and operating
> system (NT/2000) monitoring? It should be capable to email/page
> administrators in case a Windows service fails or Oracle crashes or the
> like.
> 
> Is anybody out there using software like that?
> 
> This is 8.1.6 on Win2k.
> 
> Thanks,
> Helmut
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Helmut Daiminger
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: how to connect thru perl script

[Nihar]

i got nice link for oracle with perl

http://www.aphis.usda.gov/~mmoxcey/scripts/ora_tut/

regards

   
- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com



 
  

-Original Message-
Sent: Tuesday, April 10, 2001 2:33 AM
To: Multiple recipients of list ORACLE-L


Hi DBAs
I am unable to connect to oracle 8.1.7 database thru Perl scripts.Can some 
one help me to what are the steps to check conectivity.The oracle 817 is 
raning on WIN2000.When I am trying to connect I ma getting error ora-12640 
unable to connect
Please help me.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

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

shell script to send mail

[Viraj Luthra]

Hello all,

I need help. I need to write a shell script (aix box), when ever some loads a piece of 
software. How is this possible using unix shell scripting? can some one please send a 
skeleton of it where in I can just put in the environment variables and some text and 
off it goes?

Also will the mail program use the std. internet protocol? I need to say send to an 
internet address, how do i do this?

thanks

raja


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

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

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

RE: Help -- OEM question

[Reardon, Bruce (CALBBAY)]

Andrea,

When OEM console starts up it is asking for an OEM username / password.

The default OEM administrator is sysman with a password of oem_temp.

Do you have the OMS service running on your NT box - I presume you set that
up and pointed it at your chosen management database.

To find out what version of OEM you installed you could open up a NT command
prompt and type "oemctrl status oem"

This works for OEM 2.1 and OEM 2.2, not sure if it works for 2.0.4 and
below.
2.1 came with 8.1.6
2.2 came with 8.1.7
2.0.4 is installed into its own home.

Hope this helps,
Regards,
Bruce

-Original Message-
Sent: Tuesday, 10 April 2001 10:10
To: Multiple recipients of list ORACLE-L


Hi all,

I installed Oracle Enterprise Mananger on NT. Not sure
about the OEM version, how to find it out actually,
without getting the install CD again. When I tries to
connect to a database (805 or 815 on Unix), I got:
VTK-1000: unable to connect to management server SID. 


I pick a database as the management server, and use
that db's login when OEM console askes for
Administrator and Password.  I tried all the logins,
but got the same message all the time.  What am I
missing?

Could anyone give me some suggestion?  Thank you.

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

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

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

RE: 8.1.6 on NT?

[Suhen Pather]

Ron,

The 8.1.6 base release is not very stable.
We found several problems with this release like pga memory leaks.

Try to load patch 8.1.6.1x patches and then patch to 8.1.6.3
We use 8.1.6.3.4 patch for Windows NT 4.
Pretty stable.

Do not just load 8.1.6.3.x on top of 8.1.6.0, cause there are some patches
(8.1.6.1.x) which are not included in 8.1.6.3.x.

You can get the latest patches on Metalink

HTH
Suhen



We are having trouble with response time and server crashes on a new Oracle
8.1.6 NT database.  Seems like I heard that this release is not very stable.
Has anyone had any experience with this release?  I have not applied any of
the patchsets to 8.1.6.  Should I?  If so, can anyone point me to where
there are on Metalink?

Ron Smith
Database Administration
[EMAIL PROTECTED]


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

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

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

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

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

MIB for snmp/Intelligent agent

[Oliver Artelt]

Hi all,

I want to read snmp-values via the intelligent agent (not via OEM). 
Has someone an idea how this mib list (?/network/agent/mibs/*) easily can be 
converted in a classic mib.txt-file? Or I'm totally wrong?
 
oli
-- 
Oliver Artelt
Oracle Certified DBA

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

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

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

RE: Database / OS monitoring tool

[Reardon, Bruce (CALBBAY)]

Helmut,

Many options available from different companies.

I personally use OEM for database monitoring with email and paging
notification.
We have Dell servers and so use Dell's IT Assistant to monitor the servers
(which is SNMP based).

Work out exactly all your requirements - particularly with respect to the
Oracle monitoring, and this help determine which product is best for you
(unless your company already has a standard product and you want to
integrate in with that.

Regards,
Bruce Reardon

-Original Message-
Sent: Tuesday, 10 April 2001 9:20
To: Multiple recipients of list ORACLE-L


Hi!

What software is available that can be used for database and operating
system (NT/2000) monitoring? It should be capable to email/page
administrators in case a Windows service fails or Oracle crashes or the
like.

Is anybody out there using software like that?

This is 8.1.6 on Win2k.

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

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

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

Help -- OEM question

[Andrea Oracle]

Hi all,

I installed Oracle Enterprise Mananger on NT. Not sure
about the OEM version, how to find it out actually,
without getting the install CD again. When I tries to
connect to a database (805 or 815 on Unix), I got:
VTK-1000: unable to connect to management server SID. 


I pick a database as the management server, and use
that db's login when OEM console askes for
Administrator and Password.  I tried all the logins,
but got the same message all the time.  What am I
missing?

Could anyone give me some suggestion?  Thank you.

Andrea

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

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

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

[Dennis Taylor]

At 03:11 PM 4/9/01 -0800, you wrote: 

RE: Quote Of The Day 

I don't get it.  

The Universe is building the programmers, too.  

Is that a bug? 


It's a conflict of interest.




Dennis Taylor

Star light, star bright,
First star I see tonight,
I wish I may, I wish I might,
Oh nuts! It's just a satellite.

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

Re: tirggers

[Kevin Kostyszyn]

So let me see if I have it straight, as long as the keep pool is larger than
the tables and/or objects that I want to put in it, I should be ok?  Also,
sorry about that spelling error earlier, I don't want to be assing tables to
the pool I want to assign them to the pool:)
Kev
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 7:05 PM


> KEEP pool has the same LRU algoritm as default one (maybe there are some
> small differences) - but main thing is that if you assigned to KEEP pool
> objects with combined size > than KEEP pool size (also CR blocks need to
be
> considered) blocks of these objects will be pushed out of KEEP pool - same
> as it was for default pool.
>
> Alex Hillman
>
> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 3:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: tirggers
>
> I agree with that, but don't you assing tables to the keep pool?
> And if
> that is the case and they are all in the keep pool then that would
> leave me
> to believe that they will not get booted from the keep pool until
> the db is
> shutdown and restarted?
> Kev
>
> -Original Message-
> Alex
> Sent: Monday, April 09, 2001 2:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> My understanding was that it will be in the keep pool until database
> close
> or until something else will push it from the pool ( if one has more
> blocks
> for keep pool than keep pool size) - not until session which used
> these
> block ends.
>
> Alex Hillman
>
> -Original Message-
> From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 8:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: tirggers
>
> Once accessed they should stay in memory the duration of the
> session.
>
> >>> [EMAIL PROTECTED] 04/06/01 01:20PM >>>
> I do specify Buffer_pool_keep but I was under the impression
> that
> you needed
> to FTS the tables to get them into memory?
>
> -Original Message-
> Sawmiller
> Sent: Friday, April 06, 2001 9:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Why not just specify BUFFER POOL KEEP in an alter table
> statement?
>
> >>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
> What is the problem to write something like
> Select * from  for all tables that you need or
> if there
> are too
> many such tables - create a new table with names of the
> tables and
> use
> dynamic SQL .
>
> Alex Hillman
>
> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 5:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: tirggers
>
> Hi Intelligent DBA's
> I was wondering if anyone knows how to
> create a
> trigger that
> would fire off
> at database startup time and run a script to do full
> table
> scans on
> several
> tables to get them into the buffer cache keep pool?
> Right
> now I do
> it
> manually and would like to automate the task.
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858)
> 538-5051
> San Diego, California-- Public Internet
> access /
> Mailing
> Lists
>
> 
> To REMOVE yourself from this mailing list, send an
> E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).
> You may
> also send the HELP command for other information
> (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> San Diego, California-- Public Internet access /
> Mailing
> Lists
>
> 
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
> subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Sawmiller
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> San Diego, California-- Public Internet access /
> Mailing
> Lists
>
> 
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> an

Database / OS monitoring tool

[Helmut Daiminger]

Hi!

What software is available that can be used for database and operating
system (NT/2000) monitoring? It should be capable to email/page
administrators in case a Windows service fails or Oracle crashes or the
like.

Is anybody out there using software like that?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

[Mohan, Ross]

Title: RE: Quote Of The Day





I don't get it. 


The Universe is building the programmers, too. 


Is that a bug?


<==>   -Original Message-
<==>   From: Jared Still [mailto:[EMAIL PROTECTED]]
<==>   Sent: Monday, April 09, 2001 6:56 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Fwd: Quote Of The Day
<==>   
<==>   
<==>   
<==>   I don't know who Rich Cook is, but I like him.  ;)
<==>   
<==>   Jared
<==>   
<==>   -
<==>   
<==>   Programming today is a race between software engineers 
<==>   striving to build
<==>    bigger and better idiot-proof programs, and the 
<==>   Universe trying to produce
<==>    bigger and better idiots. So far, the Universe is 
<==>   winning.--Rich Cook
<==>   
<==>   -- 
<==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>   -- 
<==>   Author: Jared Still
<==> INET: [EMAIL PROTECTED]
<==>   
<==>   Fat City Network Services    -- (858) 538-5051  FAX: 
<==>   (858) 538-5051
<==>   San Diego, California    -- Public Internet access / 
<==>   Mailing Lists
<==>   -
<==>   ---
<==>   To REMOVE yourself from this mailing list, send an E-Mail message
<==>   to: [EMAIL PROTECTED] (note EXACT spelling of 
<==>   'ListGuru') and in
<==>   the message BODY, include a line containing: UNSUB ORACLE-L
<==>   (or the name of mailing list you want to be removed 
<==>   from).  You may
<==>   also send the HELP command for other information (like 
<==>   subscribing).
<==>   

RE: Unable to extend TEMP tablespace

[Mohan, Ross]

Title: RE: Unable to extend TEMP tablespace





is it set to pctincrease 0?


is it set to type temporary ( vice permanent? e.g.) 


what does your listener log show at that time?


are you running external ( i.e. cron'ed ) analyzes?


<==>   -Original Message-
<==>   From: Helmut Daiminger [mailto:[EMAIL PROTECTED]]
<==>   Sent: Monday, April 09, 2001 5:46 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Unable to extend TEMP tablespace
<==>   
<==>   
<==>   Hi there!
<==>   
<==>   I'm experiencing strange errors on our production 
<==>   database in the middle of
<==>   the night. From the alert log file:
<==>   
<==>   Mon Apr 09 03:41:33 2001
<==>   ORA-1652: unable to extend temp segment by 64 in tablespace TEMP
<==>   
<==>   The deal is that nobody is accessing our system at 3:40 
<==>   am! No jobs are
<==>   scheduled for that time. Basically there shouldn't 
<==>   anything go on on the
<==>   server.
<==>   
<==>   Is there a way that I can find out what causes this 
<==>   error? What user /
<==>   statement is generating so much temporary data?
<==>   
<==>   Is there a way to coalesce the TEMP tablespace so that 
<==>   orphan temp segments
<==>   get deleted and the usage of the TEMP tablespace isn't 
<==>   always up to 99%?
<==>   
<==>   This is 8.1.6 on Win2k.
<==>   
<==>   Thanks,
<==>   Helmut
<==>   
<==>   
<==>   
<==>   -- 
<==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>   -- 
<==>   Author: Helmut Daiminger
<==> INET: [EMAIL PROTECTED]
<==>   
<==>   Fat City Network Services    -- (858) 538-5051  FAX: 
<==>   (858) 538-5051
<==>   San Diego, California    -- Public Internet access / 
<==>   Mailing Lists
<==>   -
<==>   ---
<==>   To REMOVE yourself from this mailing list, send an E-Mail message
<==>   to: [EMAIL PROTECTED] (note EXACT spelling of 
<==>   'ListGuru') and in
<==>   the message BODY, include a line containing: UNSUB ORACLE-L
<==>   (or the name of mailing list you want to be removed 
<==>   from).  You may
<==>   also send the HELP command for other information (like 
<==>   subscribing).
<==>   

RE: tirggers

[Hillman, Alex]

KEEP pool has the same LRU algoritm as default one (maybe there are some
small differences) - but main thing is that if you assigned to KEEP pool
objects with combined size > than KEEP pool size (also CR blocks need to be
considered) blocks of these objects will be pushed out of KEEP pool - same
as it was for default pool.

Alex Hillman

-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 09, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: tirggers

I agree with that, but don't you assing tables to the keep pool?
And if
that is the case and they are all in the keep pool then that would
leave me
to believe that they will not get booted from the keep pool until
the db is
shutdown and restarted?
Kev

-Original Message-
Alex
Sent: Monday, April 09, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


My understanding was that it will be in the keep pool until database
close
or until something else will push it from the pool ( if one has more
blocks
for keep pool than keep pool size) - not until session which used
these
block ends.

Alex Hillman

-Original Message-
From:   Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 09, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: tirggers

Once accessed they should stay in memory the duration of the
session.

>>> [EMAIL PROTECTED] 04/06/01 01:20PM >>>
I do specify Buffer_pool_keep but I was under the impression
that
you needed
to FTS the tables to get them into memory?

-Original Message-
Sawmiller
Sent: Friday, April 06, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L


Why not just specify BUFFER POOL KEEP in an alter table
statement?

>>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
What is the problem to write something like
Select * from  for all tables that you need or
if there
are too
many such tables - create a new table with names of the
tables and
use
dynamic SQL .

Alex Hillman

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

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

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

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

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


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

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

Fwd: Quote Of The Day

[Jared Still]

I don't know who Rich Cook is, but I like him.  ;)

Jared

-

Programming today is a race between software engineers striving to build
 bigger and better idiot-proof programs, and the Universe trying to produce
 bigger and better idiots. So far, the Universe is winning.--Rich Cook

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

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

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

Re: Report - Installing Oracle on SuSE Linux 7.1

[Jared Still]

After downloading Oracle into 2 large temp files, DA popped up
and error box saying that the temp files were too large.

Go figure.

Jared

On Monday 09 April 2001 11:52, Mark Leith wrote:
> LOL!!!
>
> So what was the problem, as I said in my mail, I use it fairly consistently
> without any errors or problems. I do remember once having to restart an old
> download, where it majically "lost" the temp file stored under it's
> directory structure. I restarted it, and have had no other problems since..
> But yeah, it DOES know how to handle large files, maybe a strange hiccup on
> your system or something?
>
> All in all though Jared, it is a good little product. As you said it was
> "promising", and it is, with the way that it handles the downloads anyway:)
>
> Oh well, sorry..:)
>
> Mark
>
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 03:27
> To: [EMAIL PROTECTED]; Mark Leith
> Subject: Re: Report - Installing Oracle on SuSE Linux 7.1
>
> On Mondy 09 April 2001 04:20, Mark Leith wrote:
> > Jared,
> >
> > Just a quick plug for a product that I use regularly, for downloading (no
>
> I
>
> > don't get commision:0) which can be found at
> > http://www.downloadaccelerator.com
>
> Mark,
>
> Sorry, but Download Accelerator is the product
> that does not know how to deal with very large files.
>
> Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Example of pl/sql

[Gogala, Mladen]

That ersion of truncate will not work because one cannot execute
DDL commands (what "TRUNCATE" is) from PL/SQL.
Here is a code snippet that you can try which has the "TRUNCATE" in it:

declare
cursor csr is select 'truncate table '||table_name trunc from user_tables;
begin
for c in csr 
loop
execute immediate c.trunc;
end loop;
end;
/


This code snippet will truncate all of the tables owned by the user who
executes it
and it will work on 8i only ("EXECUTE IMMEDIATE")

-Original Message-
Sent: Monday, April 09, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L


If you don't want to do a truncate,

delete from my_table;
insert into my_table values(1,2,3);
commit;

>>> [EMAIL PROTECTED] 04/09/01 04:24PM >>>
Actually, TRUNCATE is DDL so you can't just issue it in PL/SQL.  You'd need
to use dbms_sql to issue the truncate.

-Original Message-
Sent: Friday, April 06, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L


If you are asking about a code,

Probably
Begin
   TRUNCATE ...
   INSERT INTO 
   COMMIT
END
In practical this is used for temporary tables I don't know if there is any
other use.

HTH!

Aleem

 -Original Message-
Sent:   Friday, April 06, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Subject:Example of pl/sql

Anyone who  has a good  example on a procedure that first deletes all the
records in a table and then
does an insert?

Roland S

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

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

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

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

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

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

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

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

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

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

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

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

RE: DATABASE DESING ISSUE

[Nihar]

well i need someone who can help me in designing tables..
thanks

   
- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com



 
  

-Original Message-
Mladen
Sent: Tuesday, April 10, 2001 2:00 AM
To: Multiple recipients of list ORACLE-L


Well, a combination of lex, yacc and sqlldr should work for you.
May the force be with you.

-Original Message-
Sent: Monday, April 09, 2001 2:59 PM
To: Multiple recipients of list ORACLE-L


HI PPL
 i need some help on database design stuff.

i am having data given below in one flat file and i want to put in tables.
can anyone help in designing tables

here is the data the info bout data


 my data is about
 router statistics-> some numeric value
 date,time,multiple cpu utilization data->again in numeric ,
 ip address..which would be primary key
i want to search the various cpu util data,memory utilisation data from ip
address
becuase each customer i am segregating by ip address


 thanks and regards


- NIHAR SANGHVI







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

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

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

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

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

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

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

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

[Tom Schruefer]

>Helmut Daiminger - [EMAIL PROTECTED] on 4/9/2001 4:36 PM writes us:

>Hi!
>
>Sorry to ask this question again, but I can't find the old thread that
>already discussed that topic several weeks ago.
>
>What is the Oracle license price per Power Unit? For Enterprise Edition and
>Standard Edition?
>Does th eoperating system matter?

No.

>
>A power unit is MHz * 1.0 for Intel processors and MHz * 1.5 for RISC
>processors, right?
>

Actually its

Number of Computers * Number of Processors * MHZ * 1.0    Intel
Number of Computers * Number of Processors * MHZ * 1.5    RISC
Number of Computers * MIPS * 24 Mainframe Systems


There is a calculator available, the URL is way to long to email.  Go to 
the 
 and at the bottom of the Oracle 8i 
paragraphs there is a link named   Click on 
that.  Search on 
"Universal Power Unit Calculation ",  there you will find a link to the 
power unit calculator.

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


--
Howard County Public School System, Maryland, USA
[EMAIL PROTECTED]

The views expressed in this message do not represent the views of the 
Howard County Public School System, blaa, blaa, blaa.  You get the idea.

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

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

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

[Ron Rogers]

 Brijesh,
 I too have had problems getting Linux Red Hat 7.0 and Oracle 8.1.7.0.1 to load 
properly. I had the same errors and I fillowed the steps from the www.c-cup.com 
narative and also the OTN forum on linux.  It was a hastle to gather the 
upgrade/downgrades and get them working together to make it worth my while. I ended up 
loading Linux Red Hat 6.1 and Oracle 8.1.6. There were no problems and the database 
works well. The next step is to create and publish web pages using that configuration.
  The manuals that are available at Red Hat and Oracle fully explain the steps that 
are suppose to work but I didn't have the time to try all of the combinations. Meta 
link points out a patch that must be loaded to get 8.1.7.0.1 to load and run but the 
URL to the patch is invallid.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/09/01 04:15PM >>>

 Hi 
 I was problem of installing oracle 8i on Linux 7.0.
 The problem came during database creation after net 8
 configuration was sucessful the installation got
 hanged at 80% of database creation Thinking of going
 for mannual installtion I killed the databse
assistant
 wizard and tried to go for mannual databse creation
 however I am not able to bring instance in nomount 
stage also the process hangs and after long time error
comes that end-of-file on commincation channel. I saw
error file also but this did not solve my problem. Can
anyone please help me in solving this problem. The
configuration of my PC is oracle 8.1.6
 128mb RAM
 256 MB swap space
 IBM PIII processor
 
 Regards
 
 Brijesh
 


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

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

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

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

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

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

Unable to extend TEMP tablespace

[Helmut Daiminger]

Hi there!

I'm experiencing strange errors on our production database in the middle of
the night. From the alert log file:

Mon Apr 09 03:41:33 2001
ORA-1652: unable to extend temp segment by 64 in tablespace TEMP

The deal is that nobody is accessing our system at 3:40 am! No jobs are
scheduled for that time. Basically there shouldn't anything go on on the
server.

Is there a way that I can find out what causes this error? What user /
statement is generating so much temporary data?

Is there a way to coalesce the TEMP tablespace so that orphan temp segments
get deleted and the usage of the TEMP tablespace isn't always up to 99%?

This is 8.1.6 on Win2k.

Thanks,
Helmut



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

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

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

[Charlie Mengler]

#!/usr/local/bin/perl -w
#use strict;
use CGI::Carp qw{fatalsToBrowser};
use DBI;
@data_sources = DBI->data_sources('Oracle');
$i = 0;
while (defined $data_sources[$i]) {
  print ("-->$data_sources[$i]\n");
  $i++;
}

The above will display all (valid?) tnsnames.ora entries.

HTH & YMMV!
=
Seema Singh wrote:
> 
> Hi DBAs
> I am unable to connect to oracle 8.1.7 database thru Perl scripts.Can some
> one help me to what are the steps to check conectivity.The oracle 817 is
> raning on WIN2000.When I am trying to connect I ma getting error ora-12640
> unable to connect
> Please help me.
> Thanks
> -Seema
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

[Seema Singh]

Hi DBAs
I am unable to connect to oracle 8.1.7 database thru Perl scripts.Can some 
one help me to what are the steps to check conectivity.The oracle 817 is 
raning on WIN2000.When I am trying to connect I ma getting error ora-12640 
unable to connect
Please help me.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Re: Oracle license prices

[Gene Sais]

Check out this link:

http://store.oracle.com/ 

Gene


>>> [EMAIL PROTECTED] 04/09/01 04:36PM >>>
Hi!

Sorry to ask this question again, but I can't find the old thread that
already discussed that topic several weeks ago.

What is the Oracle license price per Power Unit? For Enterprise Edition and
Standard Edition?
Does th eoperating system matter?

A power unit is MHz * 1.0 for Intel processors and MHz * 1.5 for RISC
processors, right?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

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

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

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

Re: Oracle repository

[David A. Barbour]

Pierre,

Have you looked into CVS(Concurrent Versioning System)?  CVS allows
concurrent editing of sources by several users working on releases built
from a hierarchical set of directories.  It works great and when set up
properly, can make your life (and that of your system administrator) a
whole lot easier by allowing developers to refresh their source code
with previous versions.  All stored procedures and packages can be
loaded by the DBA into production (after testing) from the source
repository.  

It's pretty easy to set up and use.  Check out this link for more info:

http://www.cvshome.org/

Regards,

David A. Barbour
Oracle DBA

[EMAIL PROTECTED] wrote:
> 
> I would be grateful if you can advise me if there are other products than
> Oracle Designer 6i which is able to build automatically a version control
> baseline and track the changes at the packages and stored procedure level.
> 
> My goal is to have in place a control version program which could be used not
> by programmers, but the people from Internal Control dept which will track the
> changes at the level of database level.
> 
> Thanks in advance,
> Pierre
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

[William Beilstein]

If you don't want to do a truncate,

delete from my_table;
insert into my_table values(1,2,3);
commit;

>>> [EMAIL PROTECTED] 04/09/01 04:24PM >>>
Actually, TRUNCATE is DDL so you can't just issue it in PL/SQL.  You'd need
to use dbms_sql to issue the truncate.

-Original Message-
Sent: Friday, April 06, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L


If you are asking about a code,

Probably
Begin
   TRUNCATE ...
   INSERT INTO 
   COMMIT
END
In practical this is used for temporary tables I don't know if there is any
other use.

HTH!

Aleem

 -Original Message-
Sent:   Friday, April 06, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Subject:Example of pl/sql

Anyone who  has a good  example on a procedure that first deletes all the
records in a table and then
does an insert?

Roland S

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

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

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

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

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

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

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

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

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

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

Oracle license prices

[Helmut Daiminger]

Hi!

Sorry to ask this question again, but I can't find the old thread that
already discussed that topic several weeks ago.

What is the Oracle license price per Power Unit? For Enterprise Edition and
Standard Edition?
Does th eoperating system matter?

A power unit is MHz * 1.0 for Intel processors and MHz * 1.5 for RISC
processors, right?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

[Gogala, Mladen]

Well, a combination of lex, yacc and sqlldr should work for you.
May the force be with you.

-Original Message-
Sent: Monday, April 09, 2001 2:59 PM
To: Multiple recipients of list ORACLE-L


HI PPL
 i need some help on database design stuff.

i am having data given below in one flat file and i want to put in tables.
can anyone help in designing tables

here is the data the info bout data


 my data is about
 router statistics-> some numeric value
 date,time,multiple cpu utilization data->again in numeric ,
 ip address..which would be primary key
i want to search the various cpu util data,memory utilisation data from ip
address
becuase each customer i am segregating by ip address


 thanks and regards


- NIHAR SANGHVI







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

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

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

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

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

Oracle8i Installation problem on Linux

[Brijesh Lal]

 Hi 
 I was problem of installing oracle 8i on Linux 7.0.
 The problem came during database creation after net 8
 configuration was sucessful the installation got
 hanged at 80% of database creation Thinking of going
 for mannual installtion I killed the databse
assistant
 wizard and tried to go for mannual databse creation
 however I am not able to bring instance in nomount 
stage also the process hangs and after long time error
comes that end-of-file on commincation channel. I saw
error file also but this did not solve my problem. Can
anyone please help me in solving this problem. The
configuration of my PC is oracle 8.1.6
 128mb RAM
 256 MB swap space
 IBM PIII processor
 
 Regards
 
 Brijesh
 


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

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

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

[Paul Baumgartel]

You can, but the scripts are meant to be run via the GUI installer:  I
changed the system password to "manager" instead and all ran smoothly.


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


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Can you edit the install scripts to change the pasword?  Just curious as I
haven't seen OID yet...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 2:11 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OID installation
> 
> I found the problem.  The OiD schema installation assumes that the
> password
> for "system" is "manager".  If it isn't, the installation doesn't proceed.
> 
> 
> Paul Baumgartel
> InstiPro, Inc.
> [EMAIL PROTECTED]
> 212 813-0829 x103 (office)
> 917 549-4717 (mobile)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

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

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

Re:RE: Parallel index builds can crash

[Mohammad Rafiq]

It is a normal behaviour for parallel query since 7.3.4.
Even table on which index being created has degree > 1 (suppose dgree 4)and 
you create an index on that table, it will create initialy 4 extents of 
initial extent size in target tablespace as well as 4 in temp table space to 
develop that index. However once this job is completed , it will merge into 
one or number of extents as per your storage parameter in target tablespace.
It is true for both creation of index as well as rebuilding index.
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 09 Apr 2001 09:35:42 -0800

Lisa,

 Regrettably I'm not kidding, and neither was OTS.  I'm on HP-UX 10.20 
Oracle
8.0.4.4.0.  According to OTS this is the "normal" behavior for all versions 
of
Oracle, on all platforms, that support parallel query.  On a small index I 
could
see one not noticing, but on what should be a 4 GB index one notices the 
extra 4
GB that goes down the drain!

Dick Goulet


Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 11:02 AM

Hello Dick,

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature

Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]

  NeoMedia

2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com 
www.paperclick.com 
www.qode.com 

P a p e r C l i c k . c o m 



  Enter Your PaperClick Code Here!




-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

 Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace.
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

  Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index.

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP.

   Note:

   When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
   of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an extent of 5MB. When the
query
coordinator process combines the  sorted subindexes, some of the extents
may
be trimmed, and the resulting index may be smallerthan the requested
60MB.


ORA-1652
>From version 7.x, we can create certain objects in parallel, or
unrecoverable.
In order for Oracle to accomplish this, temporary segments are created that
eventually become a permanent part of the object, yet Oracle still refers to

them as temp segments. Thus, most of the time you receive this error, it
will
be referring to the tablespace the object is going to be created in.

Do the following query to find out if you're out of extents:

 select max(blocks), max (bytes) from sys.dba_free_space
   where

RE: Example of pl/sql

[Miller, Jay]

Actually, TRUNCATE is DDL so you can't just issue it in PL/SQL.  You'd need
to use dbms_sql to issue the truncate.

-Original Message-
Sent: Friday, April 06, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L


If you are asking about a code,

Probably
Begin
   TRUNCATE ...
   INSERT INTO 
   COMMIT
END
In practical this is used for temporary tables I don't know if there is any
other use.

HTH!

Aleem

 -Original Message-
Sent:   Friday, April 06, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Subject:Example of pl/sql

Anyone who  has a good  example on a procedure that first deletes all the
records in a table and then
does an insert?

Roland S

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

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

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

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

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

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

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

[Cyril Thankappan]

Hi!

Man , I should say that I am 'surprised'..

 cos we were on WAS 3.0.2
 and had 'severe problems' (the webserver used to hang
  during business hours)
 and Oracle suggested we upgrade to IAS

 how come u are able to 'run' WAS without
 Oracle 'support'
 can u please let me into the secret!

- Original Message --
"Boivin, Patrice J" <[EMAIL PROTECTED]> wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:"Boivin, Patrice J" <[EMAIL PROTECTED]>
Date:Mon, 09 Apr 2001 10:26:29 -0800
Subject:OWS / OAS / iAS cartridge limit

We have an old Oracle Web Server 3.0.1.1 here, with now nine cartridges, and
CPU remains consistently above 95%.  This is a dual 350MHz CPU Dell
PowerEdge 2400.

I am curious now, is there a practical limit to the number of cartridges an
Oracle Web Server can support without some part of it becoming a CPU hog.

Out of curiosity, are there people out there running Oracle web server
setups with eight or more cartridges concurrently?

Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

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




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

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

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

RE: Report - Installing Oracle on SuSE Linux 7.1

[Mark Leith]

LOL!!!

So what was the problem, as I said in my mail, I use it fairly consistently
without any errors or problems. I do remember once having to restart an old
download, where it majically "lost" the temp file stored under it's
directory structure. I restarted it, and have had no other problems since..
But yeah, it DOES know how to handle large files, maybe a strange hiccup on
your system or something?

All in all though Jared, it is a good little product. As you said it was
"promising", and it is, with the way that it handles the downloads anyway:)

Oh well, sorry..:)

Mark

-Original Message-
Sent: Monday, April 09, 2001 03:27
To: [EMAIL PROTECTED]; Mark Leith


On Mondy 09 April 2001 04:20, Mark Leith wrote:
> Jared,
>
> Just a quick plug for a product that I use regularly, for downloading (no
I
> don't get commision:0) which can be found at
> http://www.downloadaccelerator.com
>

Mark,

Sorry, but Download Accelerator is the product
that does not know how to deal with very large files.

Jared

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

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

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

Deallocate unused??

[Raghu Kota]

Dear Friends

For getting my space back from Big Tables Iam using ALTER TABLE table_name 
DEALLOCATE UNUSED. So my question is what exactly above HIGHWATERMARK and 
below HWM??? One table I got 300mg back and some 20mg, Could some body throw 
light on it.

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

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

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

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

RE: tirggers

[Kevin Kostyszyn]

I agree with that, but don't you assing tables to the keep pool?  And if
that is the case and they are all in the keep pool then that would leave me
to believe that they will not get booted from the keep pool until the db is
shutdown and restarted?
Kev

-Original Message-
Alex
Sent: Monday, April 09, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


My understanding was that it will be in the keep pool until database close
or until something else will push it from the pool ( if one has more blocks
for keep pool than keep pool size) - not until session which used these
block ends.

Alex Hillman

-Original Message-
From:   Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 09, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: tirggers

Once accessed they should stay in memory the duration of the
session.

>>> [EMAIL PROTECTED] 04/06/01 01:20PM >>>
I do specify Buffer_pool_keep but I was under the impression that
you needed
to FTS the tables to get them into memory?

-Original Message-
Sawmiller
Sent: Friday, April 06, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L


Why not just specify BUFFER POOL KEEP in an alter table statement?

>>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
What is the problem to write something like
Select * from  for all tables that you need or if there
are too
many such tables - create a new table with names of the tables and
use
dynamic SQL .

Alex Hillman

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

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

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

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

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


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

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

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

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

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

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

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

RE: inserting into DATE colum

[Jamadagni, Rajendra]

Hmmm

Whatever format you insert date into the date column, it is stored with time
portion as well. The format mask would be of use when you RETRIEVE from the
database.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

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

*

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

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

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

[Scott . Shafer]

Can you edit the install scripts to change the pasword?  Just curious as I
haven't seen OID yet...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 2:11 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OID installation
> 
> I found the problem.  The OiD schema installation assumes that the
> password
> for "system" is "manager".  If it isn't, the installation doesn't proceed.
> 
> 
> Paul Baumgartel
> InstiPro, Inc.
> [EMAIL PROTECTED]
> 212 813-0829 x103 (office)
> 917 549-4717 (mobile)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Driving table

[Miller, Jay]

Hi Anup,

You can encourage Oracle to read the tables in a particular order by using
the ORDERED hint.  For example, if you wanted the following query to have
tableb as the driving table:

SELECT /*+ ORDERED */ col1,col2
FROM tableb, tablea, tablec
WHERE ...

Will cause Oracle to read tableb first, followed by tablea, followed by
tablec.  Note that this is exactly the opposite of the order you'd want to
list the tables when using the Rule Based Optimizer.

But you'd only want to do this if you were certain Oracle was choosing an
inferior access path.  Especially in recent releases it usually (but still
not always) chooses the best path.

Jay Miller


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


Hi there ,
Thanks for the reply .

I am in Cost Based Optimizer ( we all will be now a days ) .

Does that mean , if I want to know ( or decide ) while writting the query ,
my
driving table , Its not possible ???
If I have a good idea ( size of data in tables , indexes etc.) about the
tables involved in the join and I want to know before writting the query my
driving table , I do not think I am expecting too much .

Please do reply .

Cheers .

- Anup

===
First question is whether you're in Cost Based or Rule Based optimization.
In RBO you are correct that it will read tables right to left unless
instructed otherwise by a hint.

In CBO, Oracle will choose what it thinks is 'best', which most of the time,
but not all of the time :), will be true.

Jay Miller

-Original Message-
Sent: Friday, April 06, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


Hi friends ,

I have got some query regarding , how the query is exactly executed ??

We always take joins and if we see the plan of the query , there is always
one
main driving table . Some times I get feeling that , in the join the right
most table is the driving table . But that is not always true , this is my
observation from several plans .

In Oracle documentation alos ita mentioned that ( Server Concepts, 815 or
816
: Optimisation of Joins ), "one driving table is selected" , but at least I
cannot makeout which of the several tables will be selected as driving table

What can be the potential criterions of selecting a driving table ?

Please , if you all can throw some light on the same or can redirect to some
document , that would be great .

Cheers ,
Anup Saxena



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

W

Automatic startup/shutdown script for Oracle 9i Application Server

[David Jones]

Dear Gurus:

Does anyone have similar automatic startup/shutdown scripts for Oracle 9i 
Application server which will startup related processes and shutdown them 
gracefully.

Thanks

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

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

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

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

[William Beilstein]

A database table date column always stores the date and time.  For example is the 
current date and time was 09-apr-2001 at 14:23.32 .

INSERT INTO MY_TABLE(MY_DATE) VALUES(SYSDATE);

This would store the entire date and time.

INSERT INTO MY_TABLE(MY_DATE) VALUES(TRUNC(SYSDATE));

This would store the date with a time of 00:00.00;

If you want to insert a date that is formatted in a varchar2 field into a date field 
you would do the following.
insert into TbTABLE values (To_Date('03/09/2001','MM-DD-'), 
  To_Date('03/09/2001','MM/DD/'),
To_Date('03/09/2001 11:11:11','MM/DD/ HH:MI:SS))

>>> [EMAIL PROTECTED] 04/09/01 02:26PM >>>
Helmut,

If you want to insert the date in any format other than 'DD-MON-' or
'DD-MON-YY', you need to specify the date format when you use the to_date
function.

Prakash

-Original Message-
Sent: Monday, April 09, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


Hi!

I have a question concerning inserting data in a DATE column. The deal is
that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
insert DD/MM/ HH:MI:SS in the same column.

How can I handle that?

insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001 11:11:11'))


Do I need to supply formatting information for the date to the insert
statement?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

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

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

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

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

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

DATABASE DESING ISSUE

[Nihar]

HI PPL
 i need some help on database design stuff.

i am having data given below in one flat file and i want to put in tables.
can anyone help in designing tables

here is the data the info bout data


 my data is about
 router statistics-> some numeric value
 date,time,multiple cpu utilization data->again in numeric ,
 ip address..which would be primary key
i want to search the various cpu util data,memory utilisation data from ip
address
becuase each customer i am segregating by ip address


 thanks and regards


- NIHAR SANGHVI







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

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

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

[Mohan, Ross]

Title: RE: RE: Parallel index builds can crash





Wow, Tim, that's the longest "RTFM" I've ever read!


<==>   -Original Message-
<==>   From: Tim Sawmiller [mailto:[EMAIL PROTECTED]]
<==>   Sent: Monday, April 09, 2001 2:02 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Re:RE: Parallel index builds can crash
<==>   
<==>   
<==>   BTW, this is documented in the the Oracle 8 Concepts 
<==>   manual, the chapter on "Parallel Execution" (28 I 
<==>   think), Heading "Parallel DDL", sub heading "Space 
<==>   Management for Parallel DDL".
<==>   
<==>   >>> [EMAIL PROTECTED] 04/09/01 01:35PM >>>
<==>   Lisa,
<==>   
<==>   Regrettably I'm not kidding, and neither was OTS.  
<==>   I'm on HP-UX 10.20 Oracle
<==>   8.0.4.4.0.  According to OTS this is the "normal" 
<==>   behavior for all versions of
<==>   Oracle, on all platforms, that support parallel query.  
<==>   On a small index I could
<==>   see one not noticing, but on what should be a 4 GB index 
<==>   one notices the extra 4
<==>   GB that goes down the drain! 
<==>   
<==>   Dick Goulet
<==>   
<==>   
<==>   Reply Separator
<==>   Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
<==>   Date:   4/9/2001 11:02 AM
<==>   
<==>   Hello Dick, 
<==>   
<==>   YOU ARE KIDDING.  I've done this many times in the past and never
<==>   encountered that type of behavior...  I don't see what 
<==>   version/OS you are
<==>   running?  Was the table partitioned?
<==>   
<==>   And, back by popular demand, is my highly overrated signature
<==>    
<==>   Lisa Rutland Koivu
<==>   Oracle Database Administrator
<==>   [EMAIL PROTECTED] 
<==>    
<==>    NeoMedia
<==>    
<==>   2201 Second St., Suite 600
<==>   Fort Myers, FL 33901, USA
<==>   Phone: 941-337-3434
<==>   Fax: 941-337-3668
<==>   www.neom.com  
<==>   www.paperclick.com  
<==>   www.qode.com  
<==>    
<==>   P a p e r C l i c k . c o m  
<==>    
<==>   
<==>   
<==>    Enter Your PaperClick Code Here!
<==>    
<==>    
<==>   
<==>   
<==>   -Original Message-
<==>   Sent: Monday, April 09, 2001 11:41 AM
<==>   To: Multiple recipients of list ORACLE-L
<==>   
<==>   
<==>   To ALL,
<==>   
<==>   Over the weekend I've been trying to rebuild a VERY 
<==>   large index on a
<==>   data
<==>   warehouse table.  Well in an attempt to get faster 
<==>   processing I invoked the
<==>   parallel option, but the index failed for the one reason 
<==>   I could not easily
<==>   figure out.  I expected the index to be 4 to 5 GB in 
<==>   size when completed,
<==>   but it
<==>   tried to create itself at 8 to 10 GB instead.  Odd I 
<==>   thought until this
<==>   morning
<==>   when I noticed that there was two temporary segments in 
<==>   the target
<==>   tablespace. 
<==>   I submitted a TAR to OTS for an explanation (Attached).  
<==>   Basically if you do
<==>   your index builds in parallel one should expect them to 
<==>   be the estimated
<==>   size
<==>   times the parallel setting.  OOPS!!! :-(  Someone can 
<==>   correct me if they
<==>   know
<==>   otherwise, but I don't remember seeing this in any of 
<==>   the documentation.
<==>   
<==>   BTW: The final index size, now that it did successfully 
<==>   complete, is twice
<==>   what
<==>   I expected (parallel 2).
<==>   
<==>   Dick Goulet
<==>   
<==>   Forward Header_
<==>   Author: [EMAIL PROTECTED] (Oracle Support)
<==>   Date:   4/9/2001 10:33 AM
<==>   
<==>    Hello  Richard,
<==>   
<==>   Creating Indexes in Parallel
<==>   
<==>   Parallel index creation works in much the same way as a 
<==>   table scan with an
<==>   ORDER
<==>   BY clause. The table is randomly sampled and a set of 
<==>   index keys is found
<==>   that
<==>   equally divides the index into the same number of pieces 
<==>   as the degree of
<==>   parallelism(DOP). A first set of query processes scans 
<==>   the table, extracts
<==>   key,
<==>   ROWID pairs, and sends each pair to a process in a 
<==>   second set of query
<==>   processes
<==>   based on key. Each process in the second set sorts the 
<==>   keys and builds an
<==>   index
<==>   in the usual fashion.
<==>   After all index pieces are built, the parallel coordinator simply
<==>   concatenates
<==>   the pieces (which are ordered) to form the final index. 
<==>   
<==>   Parallel local index creation uses a single server set. 
<==>   Each server process
<==>   in
<==>   the set is assigned a table partition to scan, and
<==>   for which to build an index partition. Because half as 
<==>   many server processes
<==>   are
<==>   used for a given DOP, parallel local index
<==>   creation can be run with a higher DOP. 
<==>   
<==> Note: 
<==>   
<==> When creating an index in parallel, the 
<==>   STORAGE clause refers to
<==>   the
<==

RE: inserting into DATE colum

[Cale, Rick T (Richard)]

You only need format for the HH:MI:SS not the others.

Rick

> -Original Message-
> From: Helmut Daiminger [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 2:01 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  inserting into DATE colum
> 
> Hi!
> 
> I have a question concerning inserting data in a DATE column. The deal is
> that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
> insert DD/MM/ HH:MI:SS in the same column.
> 
> How can I handle that?
> 
> insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
> To_Date('03/09/2001'), To_Date('03/09/2001'),
> To_Date('03/09/2001 11:11:11'))
> 
> 
> Do I need to supply formatting information for the date to the insert
> statement?
> 
> This is 8.1.6 on Win2k.
> 
> Thanks,
> Helmut
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Helmut Daiminger
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

[Paul Baumgartel]

I found the problem.  The OiD schema installation assumes that the password
for "system" is "manager".  If it isn't, the installation doesn't proceed.


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


-Original Message-
Sent: Monday, April 09, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L


Hi,
We had this problem too (Solaris 2.7/EE8.1.6, penguin/EE8.17). I've created 
the DB manually (stay in the lower meg-range), erased the echo "Oracle 
Internet Directory Configuration Assistant" lines in the
ldap/postcfg/postcfg 
skript (starting at echo "Creating OiD schema...") and ran it manually.

oli
-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de


[EMAIL PROTECTED] wrote
> I'm looking for help installing Oracle Internet Directory (8.1.7, Sun
> Solaris 2.7).  The software installation goes fine, but once the OID
> Configuration Assistant window comes up, everything stops.  My database
> does use the UTF8 character set.  Any ideas out there?   Thanks.
>
>
>
> Paul Baumgartel
> InstiPro, Inc.
> [EMAIL PROTECTED]
> 212 813-0829 x103 (office)
> 917 549-4717 (mobile)

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

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

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

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

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

Oracle8i Installation problem on Linux

[Brijesh Lal]

Hi 
I was problem of installing oracle 8i on Linux 7.0.
The problem came during database creation after net 8
configuration was sucessful the installation got
hanged at 80% of database creation Thinking of going
for mannual installtion I killed the databse assistant
wizard and tried to go for mannual databse creation
however I am able to bring instance in nomount stage
also the process hangs and after long time error comes
that end-of-file on commincation channel. I saw error
file also but this did not solve my problem. Can
anyone please help me in solving this problem. The
configuration of my PC is
oracle 8.1.6
128mb RAM
256 MB swap space
IBM PIII processor

Regards

Brijesh

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

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

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

RE: tirggers

[Hillman, Alex]

My understanding was that it will be in the keep pool until database close
or until something else will push it from the pool ( if one has more blocks
for keep pool than keep pool size) - not until session which used these
block ends.

Alex Hillman

-Original Message-
From:   Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 09, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: tirggers

Once accessed they should stay in memory the duration of the
session.

>>> [EMAIL PROTECTED] 04/06/01 01:20PM >>>
I do specify Buffer_pool_keep but I was under the impression that
you needed
to FTS the tables to get them into memory?

-Original Message-
Sawmiller
Sent: Friday, April 06, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L


Why not just specify BUFFER POOL KEEP in an alter table statement?

>>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
What is the problem to write something like
Select * from  for all tables that you need or if there
are too
many such tables - create a new table with names of the tables and
use
dynamic SQL .

Alex Hillman

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

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

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

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

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


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

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

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

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

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

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

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

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

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

Re:RE: Parallel index builds can crash

[Tim Sawmiller]

Ugh.  Guess you'll have to reduce the initial size and minextents to try to minimize 
the wasted space.  It's an art, not a science  8-)



>>> [EMAIL PROTECTED] 04/09/01 01:53PM >>>
Lisa,

What do you mean "lie & claim not to"?  I have one EVERY day.

BTW: Tim, it's initial xxx by minextents x.  I had minextents 4, ended up with
8.  Made a real mess of sorts, except now the index is 50% empty.  The behavior
did not make sense since I've user parallel in table creations in the past to
speed matters up & this behavior was not displayed.  It appears to be a
peculiarity with indexes.  

And: Lisa, the parallel slaves divy up the work by rowid's if you look at the
cursor their executing it will say "where rowid < :1" or "where rowid > :1".  In
this case the parallel turds build two indexes, one on the top half & the other
on the bottom half & then join them at the root point.  Pretty slick, except in
my case it took 18+ hours on each run.

Dick Goulet

Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 9:10 AM

On a partitioned table?  If you have a slave for each partition, how would
this be wrong?  Or, less slaves than partitions?

It was pounded into my head not to use parallel with non-partitioned tables
because without partitions the slaves would not know how to divy up the
work.  Seemed to me that it should be smart enough to split it up by
extents, but what do I know.  Any comments?

I never did claim to be that incredibly bright and I did burn quite a few
brain cells over the weekend.  Forgive my ignorance, people !  We all have
our days and then there are those of us who lie and claim not to.


-Original Message-
Sent: Monday, April 09, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L


Well, duh, of course you're going to get 12 pieces, each of initial xxx
size.  How else can it do a parallel creation?  Seems pretty intuitive to
me...but then, I'm a pretty smart guy!
 8-)

>>> [EMAIL PROTECTED] 04/09/01 11:55AM >>>
Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED] 
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query serve

RE: inserting into DATE colum

[Bala, Prakash]

Helmut,

If you want to insert the date in any format other than 'DD-MON-' or
'DD-MON-YY', you need to specify the date format when you use the to_date
function.

Prakash

-Original Message-
Sent: Monday, April 09, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


Hi!

I have a question concerning inserting data in a DATE column. The deal is
that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
insert DD/MM/ HH:MI:SS in the same column.

How can I handle that?

insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001 11:11:11'))


Do I need to supply formatting information for the date to the insert
statement?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

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

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

RE: RE: Parallel index builds can crash

[Boivin, Patrice J]

Larry Ellison kept saying during the iFS webcast that disk is cheap.

Good thing, too!

: )

Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 09, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject:Re:RE: Parallel index builds can crash

Lisa,

Regrettably I'm not kidding, and neither was OTS.  I'm on HP-UX
10.20 Oracle
8.0.4.4.0.  According to OTS this is the "normal" behavior for all
versions of
Oracle, on all platforms, that support parallel query.  On a small
index I could
see one not noticing, but on what should be a 4 GB index one notices
the extra 4
GB that goes down the drain! 

Dick Goulet


Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 11:02 AM

Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS
you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index
on a
data
warehouse table.  Well in an attempt to get faster processing I
invoked the
parallel option, but the index failed for the one reason I could not
easily
figure out.  I expected the index to be 4 to 5 GB in size when
completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until
this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically
if you do
your index builds in parallel one should expect them to be the
estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if
they
know
otherwise, but I don't remember seeing this in any of the
documentation.

BTW: The final index size, now that it did successfully complete, is
twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan
with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is
found
that
equally divides the index into the same number of pieces as the
degree of
parallelism(DOP). A first set of query processes scans the table,
extracts
key,
ROWID pairs, and sends each pair to a process in a second set of
query
processes
based on key. Each process in the second set sorts the keys and
builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server
process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server
processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause
refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage
during
index
creation because each process starts with an extent of 5MB. When
the
query
coordinator process combines the  sorted subindexes

RE: inserting into DATE colum

[Vadim Gorbounov]

Hello, Helmut,

As far as I understand, you have a set of string-formatted data
intended to be stored as DATE datatype. If these strings have different
formats, you have to specify the format in sql sentence:

1. String has DD/MM/ format:
insert into tbtable(fldDate) values ( to_date( ,
'DD/MM/'));

2. String has DD/MM/ HH:MI:SS format:
insert into tbtable(fldDate) values ( to_date( ,
'DD/MM/ HH:MI:SS'));

The only condition -  should match format pattern.
Internaly Oracle stores DATA type in the same format in both cases.
Format pattern could be omitted, if it is default format of the
session (easy to find select sysdate from dual;)

Best regards,
Vadim Gorbounov
Oracle DBA 

-Original Message-
Sent: Monday, April 09, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


Hi!

I have a question concerning inserting data in a DATE column. The deal is
that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
insert DD/MM/ HH:MI:SS in the same column.

How can I handle that?

insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001 11:11:11'))


Do I need to supply formatting information for the date to the insert
statement?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

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

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

No Subject

[Brijesh Lal]

 
 

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

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

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

OWS / OAS / iAS cartridge limit

[Boivin, Patrice J]

We have an old Oracle Web Server 3.0.1.1 here, with now nine cartridges, and
CPU remains consistently above 95%.  This is a dual 350MHz CPU Dell
PowerEdge 2400.

I am curious now, is there a practical limit to the number of cartridges an
Oracle Web Server can support without some part of it becoming a CPU hog.

Out of curiosity, are there people out there running Oracle web server
setups with eight or more cartridges concurrently?

Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Parallel index builds can crash

[Mohan, Ross]

Title: RE: RE: Parallel index builds can crash





use a storage clause of INITIAL/DEGREE.


that should create universal joy. 


<==>   -Original Message-
<==>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
<==>   Sent: Monday, April 09, 2001 1:36 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Re:RE: Parallel index builds can crash
<==>   
<==>   
<==>   Lisa,
<==>   
<==>   Regrettably I'm not kidding, and neither was OTS.  
<==>   I'm on HP-UX 10.20 Oracle
<==>   8.0.4.4.0.  According to OTS this is the "normal" 
<==>   behavior for all versions of
<==>   Oracle, on all platforms, that support parallel query.  
<==>   On a small index I could
<==>   see one not noticing, but on what should be a 4 GB index 
<==>   one notices the extra 4
<==>   GB that goes down the drain! 
<==>   
<==>   Dick Goulet
<==>   
<==>   
<==>   Reply Separator
<==>   Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
<==>   Date:   4/9/2001 11:02 AM
<==>   
<==>   Hello Dick, 
<==>   
<==>   YOU ARE KIDDING.  I've done this many times in the past and never
<==>   encountered that type of behavior...  I don't see what 
<==>   version/OS you are
<==>   running?  Was the table partitioned?
<==>   
<==>   And, back by popular demand, is my highly overrated signature
<==>    
<==>   Lisa Rutland Koivu
<==>   Oracle Database Administrator
<==>   [EMAIL PROTECTED]
<==>    
<==>    NeoMedia
<==>    
<==>   2201 Second St., Suite 600
<==>   Fort Myers, FL 33901, USA
<==>   Phone: 941-337-3434
<==>   Fax: 941-337-3668
<==>   www.neom.com  
<==>   www.paperclick.com  
<==>   www.qode.com  
<==>    
<==>   P a p e r C l i c k . c o m  
<==>    
<==>   
<==>   
<==>    Enter Your PaperClick Code Here!
<==>    
<==>    
<==>   
<==>   
<==>   -Original Message-
<==>   Sent: Monday, April 09, 2001 11:41 AM
<==>   To: Multiple recipients of list ORACLE-L
<==>   
<==>   
<==>   To ALL,
<==>   
<==>   Over the weekend I've been trying to rebuild a VERY 
<==>   large index on a
<==>   data
<==>   warehouse table.  Well in an attempt to get faster 
<==>   processing I invoked the
<==>   parallel option, but the index failed for the one reason 
<==>   I could not easily
<==>   figure out.  I expected the index to be 4 to 5 GB in 
<==>   size when completed,
<==>   but it
<==>   tried to create itself at 8 to 10 GB instead.  Odd I 
<==>   thought until this
<==>   morning
<==>   when I noticed that there was two temporary segments in 
<==>   the target
<==>   tablespace. 
<==>   I submitted a TAR to OTS for an explanation (Attached).  
<==>   Basically if you do
<==>   your index builds in parallel one should expect them to 
<==>   be the estimated
<==>   size
<==>   times the parallel setting.  OOPS!!! :-(  Someone can 
<==>   correct me if they
<==>   know
<==>   otherwise, but I don't remember seeing this in any of 
<==>   the documentation.
<==>   
<==>   BTW: The final index size, now that it did successfully 
<==>   complete, is twice
<==>   what
<==>   I expected (parallel 2).
<==>   
<==>   Dick Goulet
<==>   
<==>   Forward Header_
<==>   Author: [EMAIL PROTECTED] (Oracle Support)
<==>   Date:   4/9/2001 10:33 AM
<==>   
<==>    Hello  Richard,
<==>   
<==>   Creating Indexes in Parallel
<==>   
<==>   Parallel index creation works in much the same way as a 
<==>   table scan with an
<==>   ORDER
<==>   BY clause. The table is randomly sampled and a set of 
<==>   index keys is found
<==>   that
<==>   equally divides the index into the same number of pieces 
<==>   as the degree of
<==>   parallelism(DOP). A first set of query processes scans 
<==>   the table, extracts
<==>   key,
<==>   ROWID pairs, and sends each pair to a process in a 
<==>   second set of query
<==>   processes
<==>   based on key. Each process in the second set sorts the 
<==>   keys and builds an
<==>   index
<==>   in the usual fashion.
<==>   After all index pieces are built, the parallel coordinator simply
<==>   concatenates
<==>   the pieces (which are ordered) to form the final index. 
<==>   
<==>   Parallel local index creation uses a single server set. 
<==>   Each server process
<==>   in
<==>   the set is assigned a table partition to scan, and
<==>   for which to build an index partition. Because half as 
<==>   many server processes
<==>   are
<==>   used for a given DOP, parallel local index
<==>   creation can be run with a higher DOP. 
<==>   
<==> Note: 
<==>   
<==> When creating an index in parallel, the 
<==>   STORAGE clause refers to
<==>   the
<==>   storage of each of the   subindexes created by the 
<==>   query server
<==>   processes.
<==>   Therefore, an index created with an INITIAL
<==> of 5MB and a DOP of 12 consumes at least 60MB 
<==>   of storage during
<==>   

How can you have 2 default_domain's in sqlnet.ora

[Ruth Gramolini]

Dear Guru's,

We have to have some of our users also be users on another system.  The
folks who are running this system said we should add another
NAMES.DEFAULT_DOMAIN= NEW_DOMAIN
 to our sqlnet.ora for these users.

The default_domain is already specified in their sqlnet.ora as the domain
for our databases.  How can we point to both domains?

Any help will be greatly appreciated.

Ruth B. Gramolini
ORACLE & DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

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

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

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

Re:RE: Parallel index builds can crash

[Tim Sawmiller]

BTW, this is documented in the the Oracle 8 Concepts manual, the chapter on "Parallel 
Execution" (28 I think), Heading "Parallel DDL", sub heading "Space Management for 
Parallel DDL".

>>> [EMAIL PROTECTED] 04/09/01 01:35PM >>>
Lisa,

Regrettably I'm not kidding, and neither was OTS.  I'm on HP-UX 10.20 Oracle
8.0.4.4.0.  According to OTS this is the "normal" behavior for all versions of
Oracle, on all platforms, that support parallel query.  On a small index I could
see one not noticing, but on what should be a 4 GB index one notices the extra 4
GB that goes down the drain! 

Dick Goulet


Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 11:02 AM

Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED] 
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an extent of 5MB. When the
query
coordinator process combines the  sorted subindexes, some of the extents
may
be trimmed, and the resulting index may be smallerthan the requested
60MB.  


ORA-1652
>From version 7.x, we can create certain objects in parallel, or
unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to

them as temp segments. Thus, most of the time you receive this error, it
will 
be referring to the tablespace the object is going to be created in. 

Do the following query to find out if you're out of extents: 
  
select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 
For example, The above query may return:
 SQL> blocks  bytes 
 614312,580,864  
 
Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks
and 
Oracle needs a contiguous block of free space of 6144 to create an object. 
 
You may have a lot of free space in separate blocks in your tablespace, but
if 
it is not contiguous, Oracle cannot use it. All

inserting into DATE colum

[Helmut Daiminger]

Hi!

I have a question concerning inserting data in a DATE column. The deal is
that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
insert DD/MM/ HH:MI:SS in the same column.

How can I handle that?

insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001 11:11:11'))


Do I need to supply formatting information for the date to the insert
statement?

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

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

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

[dgoulet]

Lisa,

What do you mean "lie & claim not to"?  I have one EVERY day.

BTW: Tim, it's initial xxx by minextents x.  I had minextents 4, ended up with
8.  Made a real mess of sorts, except now the index is 50% empty.  The behavior
did not make sense since I've user parallel in table creations in the past to
speed matters up & this behavior was not displayed.  It appears to be a
peculiarity with indexes.  

And: Lisa, the parallel slaves divy up the work by rowid's if you look at the
cursor their executing it will say "where rowid < :1" or "where rowid > :1".  In
this case the parallel turds build two indexes, one on the top half & the other
on the bottom half & then join them at the root point.  Pretty slick, except in
my case it took 18+ hours on each run.

Dick Goulet

Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 9:10 AM

On a partitioned table?  If you have a slave for each partition, how would
this be wrong?  Or, less slaves than partitions?

It was pounded into my head not to use parallel with non-partitioned tables
because without partitions the slaves would not know how to divy up the
work.  Seemed to me that it should be smart enough to split it up by
extents, but what do I know.  Any comments?

I never did claim to be that incredibly bright and I did burn quite a few
brain cells over the weekend.  Forgive my ignorance, people !  We all have
our days and then there are those of us who lie and claim not to.


-Original Message-
Sent: Monday, April 09, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L


Well, duh, of course you're going to get 12 pieces, each of initial xxx
size.  How else can it do a parallel creation?  Seems pretty intuitive to
me...but then, I'm a pretty smart guy!
 8-)

>>> [EMAIL PROTECTED] 04/09/01 11:55AM >>>
Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED] 
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an e

Re: ORA-07446

[Natasha Batson]

I'll agree with Kevin on that one.
Check if you have a parameter listed in the init.ora with no value assigned.

Natasha
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 12:54 PM


Open up and double check your pfile, there may be an error in it.  At least
that's my feeling.
Kevin

-Original Message-
Sent: Monday, April 09, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7

Trying to do a startup pfile=whatever nomount
and get error
ORA-07466
sdnfy : bad value ' ' for parameter

Any ideas what is wrong?

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

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

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

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

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

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

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

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

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

RE: ORA-07446

[Daniel Harron]

try

startup nomount pfile=full_path\pfile

-Daniel

-Original Message-
Sent: Monday, April 09, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7

Trying to do a startup pfile=whatever nomount 
and get error
ORA-07466
sdnfy : bad value ' ' for parameter

Any ideas what is wrong?

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

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

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


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

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

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

[dgoulet]

Lisa,

Regrettably I'm not kidding, and neither was OTS.  I'm on HP-UX 10.20 Oracle
8.0.4.4.0.  According to OTS this is the "normal" behavior for all versions of
Oracle, on all platforms, that support parallel query.  On a small index I could
see one not noticing, but on what should be a 4 GB index one notices the extra 4
GB that goes down the drain! 

Dick Goulet


Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   4/9/2001 11:02 AM

Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an extent of 5MB. When the
query
coordinator process combines the  sorted subindexes, some of the extents
may
be trimmed, and the resulting index may be smallerthan the requested
60MB.  


ORA-1652
>From version 7.x, we can create certain objects in parallel, or
unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to

them as temp segments. Thus, most of the time you receive this error, it
will 
be referring to the tablespace the object is going to be created in. 

Do the following query to find out if you're out of extents: 
  
select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 
For example, The above query may return:
 SQL> blocks  bytes 
 614312,580,864  
 
Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks
and 
Oracle needs a contiguous block of free space of 6144 to create an object. 
 
You may have a lot of free space in separate blocks in your tablespace, but
if 
it is not contiguous, Oracle cannot use it. Allocating extents requires that

there be a contiguous block of free space. 


SOLUTION:  
1. Add a datafile to the tablespace  
2. Adjust the storage parameters of the object you are trying to create. 
   Parameters to look at: init

RE: Parallel index builds can crash

[Koivu, Lisa]

Title: RE: Parallel index builds can crash





On a partitioned table?  If you have a slave for each partition, how would this be wrong?  Or, less slaves than partitions?

It was pounded into my head not to use parallel with non-partitioned tables because without partitions the slaves would not know how to divy up the work.  Seemed to me that it should be smart enough to split it up by extents, but what do I know.  Any comments?

I never did claim to be that incredibly bright and I did burn quite a few brain cells over the weekend.  Forgive my ignorance, people !  We all have our days and then there are those of us who lie and claim not to.


-Original Message-
From: Tim Sawmiller [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Parallel index builds can crash



Well, duh, of course you're going to get 12 pieces, each of initial xxx size.  How else can it do a parallel creation?  Seems pretty intuitive to me...but then, I'm a pretty smart guy!

 8-)


>>> [EMAIL PROTECTED] 04/09/01 11:55AM >>>
Hello Dick, 


YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?


And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED] 
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 



 Enter Your PaperClick Code Here!
 
 



-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L



To ALL,


    Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.


BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).


Dick Goulet


Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM


 Hello  Richard,


Creating Indexes in Parallel


Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 


Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 


  Note: 


  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an extent of 5MB. When the
query
coordinator process combines the  sorted subindexes, some of the extents
may
be trimmed, and the resulting index may be smaller    than the requested
60MB.  



ORA-1652
From version 7.x, we can create certain objects in parallel, or
unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to


them as temp segments. Thus, most of the time you receive this error, it
will 
be referring to the tablespace the object is going to be created in. 


Do the following query to find out if you're out of extents: 
  
    select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 

Re: OID installation

[Oliver Artelt]

Hi,
We had this problem too (Solaris 2.7/EE8.1.6, penguin/EE8.17). I've created 
the DB manually (stay in the lower meg-range), erased the echo "Oracle 
Internet Directory Configuration Assistant" lines in the ldap/postcfg/postcfg 
skript (starting at echo "Creating OiD schema...") and ran it manually.

oli
-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de


[EMAIL PROTECTED] wrote
> I'm looking for help installing Oracle Internet Directory (8.1.7, Sun
> Solaris 2.7).  The software installation goes fine, but once the OID
> Configuration Assistant window comes up, everything stops.  My database
> does use the UTF8 character set.  Any ideas out there?   Thanks.
>
>
>
> Paul Baumgartel
> InstiPro, Inc.
> [EMAIL PROTECTED]
> 212 813-0829 x103 (office)
> 917 549-4717 (mobile)

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

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

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

RE: ORA-07446

[Kevin Kostyszyn]

Open up and double check your pfile, there may be an error in it.  At least
that's my feeling.
Kevin

-Original Message-
Sent: Monday, April 09, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7

Trying to do a startup pfile=whatever nomount
and get error
ORA-07466
sdnfy : bad value ' ' for parameter

Any ideas what is wrong?

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

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

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

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

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

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

RE: Parallel index builds can crash

[Tim Sawmiller]

Well, duh, of course you're going to get 12 pieces, each of initial xxx size.  How 
else can it do a parallel creation?  Seems pretty intuitive to me...but then, I'm a 
pretty smart guy!
 8-)

>>> [EMAIL PROTECTED] 04/09/01 11:55AM >>>
Hello Dick, 

YOU ARE KIDDING.  I've done this many times in the past and never
encountered that type of behavior...  I don't see what version/OS you are
running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED] 
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 


 Enter Your PaperClick Code Here!
 
 


-Original Message-
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a
data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed,
but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this
morning
when I noticed that there was two temporary segments in the target
tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated
size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they
know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice
what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an
ORDER
BY clause. The table is randomly sampled and a set of index keys is found
that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts
key,
ROWID pairs, and sends each pair to a process in a second set of query
processes
based on key. Each process in the second set sorts the keys and builds an
index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply
concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process
in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes
are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to
the
storage of each of the   subindexes created by the query server
processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during
index
creation because each process starts with an extent of 5MB. When the
query
coordinator process combines the  sorted subindexes, some of the extents
may
be trimmed, and the resulting index may be smallerthan the requested
60MB.  


ORA-1652
>From version 7.x, we can create certain objects in parallel, or
unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to

them as temp segments. Thus, most of the time you receive this error, it
will 
be referring to the tablespace the object is going to be created in. 

Do the following query to find out if you're out of extents: 
  
select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 
For example, The above query may return:
 SQL> blocks  bytes 
 614312,580,864  
 
Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks
and 
Oracle needs a contiguous block of free space of 6144 to create an object. 
 
You may have a lot of free space in separate blocks in your tablespace, but
if 
it is not contiguous, Oracle cannot use it. Allocating extents requires that

there be a contiguous block of free space. 


SOLUTION:  
1. Add a datafile to the tablespace  
2. Adjust the storage parameters of the object you are trying to create. 
   Parameters to look at: initial extent, next extent, pct increase. 
3. If you have a lot of free space in that tablespace, but the it is  
   very fragmented, you may want to consider rebuilding the tablespace. 
4. Enable AUTOEXTEND for the datafile 


 

 - Also,  Please reviewVia met

Re: skipping the java.sh step in database create

[Connor McDonald]

Certainly - in fact if you're using the database
config assistant, then not selecting the 'jserver'
option will result in there not being a java.sh
at all...

hth
connor

--- Ben Poels <[EMAIL PROTECTED]> wrote: > Hi,
> 
> If you are not using anything to do with Java is it
> then
> safe to skip running the java.sh script that
> dbassist
> creates during database creation in Oracle 8.1.7?
> This step takes forever and uses a lot of System
> tablespace.
> 
> 
> Ben Poels
> Queen's University
> Kingston, Ontario
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ben Poels
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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


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

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

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

Re: Report 2.5, how to bring up ' 0 ' when sql query returns null ?

[Viktor]

Hey,

Go to Metalink site and enter 29736.1 in the search
box.

Hopefully, that document will help you.

--- "Hsu, Anthony C., ,CPMS"
<[EMAIL PROTECTED]> wrote:
> Hi friends,
> 
> I would appreciate that if anyone can share the idea
> to
> bring up ' 0' after SQL query returns null in Report
> 2.5 ?
> What I mean is in Report 2.5,  if I have four SQL
> queries and each query
> will returns each quarterly data and I need to
> display ' 0' even though
> there
> is no records return for the 2nd quarter.
> 
> 
> My report now can display data like below and the
> SQL query is
> /*   select count(rain_days), count(sunshine_days)
> from weather
>  where  quarter='2'  */  and the return is null
> 
> quarter   qtr1qtr3qtr4
> 
> 
> rain days #   20   15 25
> 
> sunshine days#10   15  5
> 
> 
> 
> 
> 
> I want to have report can display like below even
> though my SQL query
> /*select count(rain_days), count(sunshine_days)
> from weather
>   where  quarter='2'*/
> returns null
> 
> quarter   qtr1qtr2qtr3qtr4
> 
> 
> rain days #   20   0   15 25
> 
> sunshine days#10   0   15  5
> 
> 
> Thanks.
> 
> 
> 
>  
> 
>  
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hsu, Anthony C., ,CPMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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

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

Re: 8.1.6 vs 8.1.7

[Connor McDonald]

I can only comment on 8.1.6.2 vs 8.1.7 - and we found
the latter to be slightly better (in terms of number
of ora-600's and ora-7445's).  Its quite possible that
8.1.6.3 and above are more stable - but subjectively,
it would appear that many bugs encountered in 8.1.7.0
always are listed in Metalink as "fixed in 8.1.7.2" so
this may be a good one to target...

hth
connor

--- Jordi Sanmarti <[EMAIL PROTECTED]> wrote: > 
> Hello,
> 
> I was wondering how stable the Oracle 8i release 3
> is. We plan to move our
> DB in production to the latest version.
> Has anybody had problems migrating it? I was told by
> colleges that release 2
> looks more stable than the other. How true is that?
> 
> Any comments ?
> 
> Thanks in advance,
> Jordi
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jordi Sanmarti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

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


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

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

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

RE: Error-00103 While Creating Type

[Gogala, Mladen]

Test is a reserved word. Use TEST_1 and everything will be all right.

-Original Message-
Sent: Saturday, April 07, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

When I execute the following code on Oracle 8i release 3 (8.1.7)

CREATE OR REPLACE TYPE
Test (
 Emp_Name  VARCHAR2(30),
 Emp_Desgn VARCHAR2(30),
 Emp_Addrs  VARCHAR2(50) );

It gives error 
   "Type created with compilation errors". 

The All_Errors view indicates Error-00103 at line 2 position 6

"Encountered symbol '(' when expecting ; is authid as compress compiled
wrapped'

TIA

Regards,

Aleem

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

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

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

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

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

RE: RMAN-06004 Error

[Raj Gopalan]

Thanks Natasha. I have more than 400 Backup pieces. I will try and limit it
less than 99.

Regards
Raj

-Original Message-
Sent: 09 April 2001 17:06
To: Multiple recipients of list ORACLE-L


Raj

This might be related to bug# 1311017 where there is a limit of 99 backup
pieces. How many backup
pieces do you have?  Have you placed an iTAR with OTS?

Regards
Natasha

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


DBAs,

I have taken DB backup using RMAN. The backup completed successfully. When I
execute list backupset, I am getting the following error

RMAN> list backupset;

RMAN-03022: compiling command: list
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: list
RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL:
nume
ric or value error: number precision too large
ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052
ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729
ORA-06512: at line 1

This is the first time I am using RMAN and I could not find anything to sort
out this issue in metalink.

Any Idea what could be the cause?

Thanks

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

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

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

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

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

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

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

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

[Feng, Jun]

Deinstall the product and reinstall it. You may also configure OID manually.

Jun

-Original Message-
Sent: Monday, April 09, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I'm looking for help installing Oracle Internet Directory (8.1.7, Sun
Solaris 2.7).  The software installation goes fine, but once the OID
Configuration Assistant window comes up, everything stops.  My database does
use the UTF8 character set.  Any ideas out there?   Thanks.



Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

[Mohan, Ross]

Title: RE: OFF TOPIC: How to control NT services from Solaris?





MKS toolset?


David Korn's Unix toolset?


<==>   -Original Message-
<==>   From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
<==>   Sent: Monday, April 09, 2001 12:16 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: OFF TOPIC: How to control NT services from Solaris?
<==>   
<==>   
<==>   All of my Oracle instances run on Solaris.
<==>   Now I need to interoperate with application server s/w 
<==>   (IIS) running on NT.
<==>   
<==>   I'm looking for some automated mechanism to invoke a 
<==>   batch job on the NT
<==>   box from a script that runs on Solaris. Specifically 
<==>   when the shutdown
<==>   script for Oracle gets run on Solaris, I'd like to be 
<==>   able to shutdown
<==>   a service that runs on NT. Conversely, after the Oracle 
<==>   instance starts,
<==>   I need to be able to start a service on the NT system.
<==>   
<==>   What is a clean & automated way to accomplish these goals?
<==>   Code samples would be GREATLY appreciated.
<==>   
<==>   TIA & HAND!
<==>   
<==>   -- 
<==>   Charlie Mengler   Maintenance Warehouse  
<==>   [EMAIL PROTECTED]  10641 Scripps Summit Ct   
<==>   858-831-2229  San Diego, CA 92131    
<==>   The future is here. It is just not evenly distributed.
<==>   -- 
<==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>   -- 
<==>   Author: Charlie Mengler
<==> INET: [EMAIL PROTECTED]
<==>   
<==>   Fat City Network Services    -- (858) 538-5051  FAX: 
<==>   (858) 538-5051
<==>   San Diego, California    -- Public Internet access / 
<==>   Mailing Lists
<==>   -
<==>   ---
<==>   To REMOVE yourself from this mailing list, send an E-Mail message
<==>   to: [EMAIL PROTECTED] (note EXACT spelling of 
<==>   'ListGuru') and in
<==>   the message BODY, include a line containing: UNSUB ORACLE-L
<==>   (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: Histogram Helper -- Follow up

[Deshpande, Kirti]

Hi Steve,
Thanks for posting this. It is a great help. 
Now, you are the 'Histogram' expert on the list and I have your e-mail
address in my personal address book ;)
I have not yet run Steve A's script on my databases.  
But it is definitely in the plans. 
Thanks again for all the testing and for sharing your results. 

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

> -Original Message-
> From: Steve Orr [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 10:46 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Histogram Helper -- Follow up
> 
> THANKS for all your feedback. To sum up the thread and my conclusions...
> 
> >I had fair amount of success using Histograms for all indexed columns. I
> >have been using it since 7.3.4.x version. However, histograms do not
> offer
> >any help if the SQL uses bind variables.  Most of our application code
> does
> >use bind variables and hence does not benefit from this really neat
> feature.
> >- Kirti Deshpande
> 
> Thanks Kirti and good point however this is what I found in the Oracle
> Docs:
> "Histograms are NOT useful for columns with the following characteristics:
> ALL, yes ALL [emphasis mine] predicates on the column use bind
> variables..."
> The query in question only needed one bind variable but the same column
> appeared elsewhere in the WHERE clause so the histograms helped.
> 
> >The documentation has under-sold this feature. Even for columns that do
> not
> >look very skewed at all, histograms helps to turn ugly explain-plans to
> very
> >fast ones. Somewhere inside the optimizer, histograms help it decide on
> >sensible join-orders amongst other things. You didn't say, but I suspect
> >your dramatic improvement is in the different join order.
> 
> >If you can, compute for table for ALL columns for all indexes (3 alls and
> >leave out the indexed keyword). This will do all columns, but may not be
> >feasible because it could blow out sys.histgrm$ depending on how many
> >tables/columns/partitions you have. Do not specify the buckets -- let the
> >analyze choose. It will vary the number depending on what it finds.
> >Author: Binley LimINET: [EMAIL PROTECTED]
> 
> Here's what I did:
> execute DBMS_STATS.CREATE_STAT_TABLE('RZUPROD','RZUSTATS','P2PTBL128K');
> execute DBMS_STATS.GATHER_SCHEMA_STATS( -
>   ownname=> 'RZUPROD', -
>   method_opt => 'FOR ALL INDEXED COLUMNS SIZE 100', -
>   cascade=> TRUE, -
>   options=> 'GATHER', -
>   stattab=> 'RZUSTATS', -
>   statid => '1' );
> 
> I figured I could judge the impact on the data dictionary by storing the
> statistical results in my own table first. When I reviewed the table I
> could
> see the stats but I had a heck of a time trying to figure out where the
> histogram data was. (It's a funky table.) Eventually it dawned on me...
> this
> nice procedure from Oracle does store the stats in your own table... WITH
> THE EXCEPTION OF THE HISTOGRAM DATA! Thanks a lot Oracle. The purpose of
> this procedure is to get the results from an analyze without affecting the
> dictionary. Nothing in the docs about histograms being the exception.
> Luckily the schema didn't have a ton of tables and indexes so the impact
> was
> acceptable. After tracing through catalog.sql and sql.bsq I concluded the
> data was stored in the SYS.HIST_HEAD$ and HISTGRM$ tables with HISTGRM$ in
> the C_OBJ#_INTCOL# cluster. Total storage came to just over 2MB so no
> prob.
> A word to the wise, if you're going to do histograms on all columns or all
> indexed columns, first figure out how many columns that is then guess how
> many rows will be generated and calculate the storage requirements based
> on
> the column definitions you'll find in sql.bsq. The best you can do is
> guestimate because you don't know how many buckets will be created for a
> given column. You might want to limit the buckets to 10 on the first pass.
> Or better yet, use Steve Adams' fantastic script! Here's Steve's comments:
> 
> >Good idea, but unfortunately the table statistics and the basic column
> >statistics (called single-bucket histograms) that are available if you
> only
> >analyze the table are not sufficient to determine whether the
> distribution
> >of values for any column is uniform or skewed. That means that we cannot
> do
> >this with a data dictionary query; we will have to scan the table.
> >Based on your suggestion I have written "consider_histogram.sql" at
> >http://www.ixora.com.au/scripts/query_opt.htm#consider_histogram...
> 
> THANKS! Great script. That's exactly what I had in mind and I was prepared
> to take on the task but I went home for the evening and in your email this
> morning I found that you had already done it all! And better than I could
> have done as I was entertaining PL/SQL. Great technique with inline views
> and CASE expressions! In your script comments you wrote:
> -- Author:Steve Adams -- based a suggestion fro

Report 2.5, how to bring up ' 0 ' when sql query returns null ?

[Hsu, Anthony C., ,CPMS]

Hi friends,

I would appreciate that if anyone can share the idea to
bring up ' 0' after SQL query returns null in Report 2.5 ?
What I mean is in Report 2.5,  if I have four SQL queries and each query
will returns each quarterly data and I need to display ' 0' even though
there
is no records return for the 2nd quarter.


My report now can display data like below and the SQL query is
/*   select count(rain_days), count(sunshine_days) from weather
 where  quarter='2'  */  and the return is null

quarter qtr1qtr3qtr4


rain days # 20   15 25

sunshine days#  10   15  5





I want to have report can display like below even though my SQL query
/*select count(rain_days), count(sunshine_days) from weather
  where  quarter='2'*/
returns null

quarter qtr1qtr2qtr3qtr4


rain days # 20   0   15 25

sunshine days#  10   0   15  5


Thanks.



 

 


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

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

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

Re: RMAN-06004 Error

[Natasha Batson]

Raj

This might be related to bug# 1311017 where there is a limit of 99 backup
pieces. How many backup
pieces do you have?  Have you placed an iTAR with OTS?

Regards
Natasha

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


DBAs,

I have taken DB backup using RMAN. The backup completed successfully. When I
execute list backupset, I am getting the following error

RMAN> list backupset;

RMAN-03022: compiling command: list
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: list
RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL:
nume
ric or value error: number precision too large
ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052
ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729
ORA-06512: at line 1

This is the first time I am using RMAN and I could not find anything to sort
out this issue in metalink.

Any Idea what could be the cause?

Thanks

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

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

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

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

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

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

OFF TOPIC: How to control NT services from Solaris?

[Charlie Mengler]

All of my Oracle instances run on Solaris.
Now I need to interoperate with application server s/w (IIS) running on NT.

I'm looking for some automated mechanism to invoke a batch job on the NT
box from a script that runs on Solaris. Specifically when the shutdown
script for Oracle gets run on Solaris, I'd like to be able to shutdown
a service that runs on NT. Conversely, after the Oracle instance starts,
I need to be able to start a service on the NT system.

What is a clean & automated way to accomplish these goals?
Code samples would be GREATLY appreciated.

TIA & HAND!

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

[Nihar]

you can use NT's at command.
just say at /?..u will get the list of options



   
- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com



 
  

-Original Message-
Dayal
Sent: Monday, April 09, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Some days back I remember someone mentioning
about crontab on NT. 
Please pass that utility directly to me. Appreciate 
your help.

TIA,
Rajesh
[EMAIL PROTECTED] 


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

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

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

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

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

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

ORA-07446

[John Dunn]

Oracle 8.1.7

Trying to do a startup pfile=whatever nomount 
and get error
ORA-07466
sdnfy : bad value ' ' for parameter

Any ideas what is wrong?

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

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

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

[Koivu, Lisa]

Title: RE: Parallel index builds can crash





Hello Dick, 


YOU ARE KIDDING.  I've done this many times in the past and never encountered that type of behavior...  I don't see what version/OS you are running?  Was the table partitioned?

And, back by popular demand, is my highly overrated signature
 
Lisa Rutland Koivu
Oracle Database Administrator
[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 



 Enter Your PaperClick Code Here!
 
 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Subject: Parallel index builds can crash



To ALL,


    Over the weekend I've been trying to rebuild a VERY large index on a data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed, but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this morning
when I noticed that there was two temporary segments in the target tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they know
otherwise, but I don't remember seeing this in any of the documentation.


BTW: The final index size, now that it did successfully complete, is twice what
I expected (parallel 2).


Dick Goulet


Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM


 Hello  Richard,


Creating Indexes in Parallel


Parallel index creation works in much the same way as a table scan with an ORDER
BY clause. The table is randomly sampled and a set of index keys is found that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts key,
ROWID pairs, and sends each pair to a process in a second set of query processes
based on key. Each process in the second set sorts the keys and builds an index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply concatenates
the pieces (which are ordered) to form the final index. 


Parallel local index creation uses a single server set. Each server process in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 


  Note: 


  When creating an index in parallel, the STORAGE clause refers to the
storage of each of the   subindexes created by the query server processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during index
creation because each process starts with an extent of 5MB. When the query
coordinator process combines the  sorted subindexes, some of the extents may
be trimmed, and the resulting index may be smaller    than the requested 60MB.  



ORA-1652
From version 7.x, we can create certain objects in parallel, or unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to 
them as temp segments. Thus, most of the time you receive this error, it will 
be referring to the tablespace the object is going to be created in. 


Do the following query to find out if you're out of extents: 
  
    select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 
For example, The above query may return:
 SQL> blocks  bytes 
 6143    12,580,864  
 
Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks and 
Oracle needs a contiguous block of free space of 6144 to create an object. 
 
You may have a lot of free space in separate blocks in your tablespace, but if 
it is not contiguous, Oracle cannot use it. Allocating extents requires that 
there be a contiguous block of free space. 



SOLUTION:  
1. Add a datafile to the tablespace  
2. Adjust the storage parameters of the object you are trying to create. 
   Parameters to look at: initial extent, next extent, pct increase. 
3. If you have a lot of free space in that tablespace, but the it is  
   very fragmented, you may want to consider rebuilding the tablespace. 
4. Enable AUTOEXTEND for the datafile 



 


 - Also,  Please reviewVia metalink (Metalink - - >technical
library- - >reach with note#)
Title:  ORA-016

RE: Histogram Helper -- Follow up

[Steve Orr]

THANKS for all your feedback. To sum up the thread and my conclusions...

>I had fair amount of success using Histograms for all indexed columns. I
>have been using it since 7.3.4.x version. However, histograms do not offer
>any help if the SQL uses bind variables.  Most of our application code does
>use bind variables and hence does not benefit from this really neat
feature.
>- Kirti Deshpande

Thanks Kirti and good point however this is what I found in the Oracle Docs:
"Histograms are NOT useful for columns with the following characteristics:
ALL, yes ALL [emphasis mine] predicates on the column use bind variables..."
The query in question only needed one bind variable but the same column
appeared elsewhere in the WHERE clause so the histograms helped.

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

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

Here's what I did:
execute DBMS_STATS.CREATE_STAT_TABLE('RZUPROD','RZUSTATS','P2PTBL128K');
execute DBMS_STATS.GATHER_SCHEMA_STATS( -
ownname=> 'RZUPROD', -
method_opt => 'FOR ALL INDEXED COLUMNS SIZE 100', -
cascade=> TRUE, -
options=> 'GATHER', -
stattab=> 'RZUSTATS', -
statid => '1' );

I figured I could judge the impact on the data dictionary by storing the
statistical results in my own table first. When I reviewed the table I could
see the stats but I had a heck of a time trying to figure out where the
histogram data was. (It's a funky table.) Eventually it dawned on me... this
nice procedure from Oracle does store the stats in your own table... WITH
THE EXCEPTION OF THE HISTOGRAM DATA! Thanks a lot Oracle. The purpose of
this procedure is to get the results from an analyze without affecting the
dictionary. Nothing in the docs about histograms being the exception.
Luckily the schema didn't have a ton of tables and indexes so the impact was
acceptable. After tracing through catalog.sql and sql.bsq I concluded the
data was stored in the SYS.HIST_HEAD$ and HISTGRM$ tables with HISTGRM$ in
the C_OBJ#_INTCOL# cluster. Total storage came to just over 2MB so no prob.
A word to the wise, if you're going to do histograms on all columns or all
indexed columns, first figure out how many columns that is then guess how
many rows will be generated and calculate the storage requirements based on
the column definitions you'll find in sql.bsq. The best you can do is
guestimate because you don't know how many buckets will be created for a
given column. You might want to limit the buckets to 10 on the first pass.
Or better yet, use Steve Adams' fantastic script! Here's Steve's comments:

>Good idea, but unfortunately the table statistics and the basic column
>statistics (called single-bucket histograms) that are available if you only
>analyze the table are not sufficient to determine whether the distribution
>of values for any column is uniform or skewed. That means that we cannot do
>this with a data dictionary query; we will have to scan the table.
>Based on your suggestion I have written "consider_histogram.sql" at
>http://www.ixora.com.au/scripts/query_opt.htm#consider_histogram...

THANKS! Great script. That's exactly what I had in mind and I was prepared
to take on the task but I went home for the evening and in your email this
morning I found that you had already done it all! And better than I could
have done as I was entertaining PL/SQL. Great technique with inline views
and CASE expressions! In your script comments you wrote:
-- Author:  Steve Adams -- based a suggestion from Steve Orr
Well at least I got to do something  :-) Thanks again Bro, er, Mate. :-)

One final (edited) gem from Cherie...
>I too experienced dramatic improvement when using a couple of histograms on
>very heavily skewed columns. The main thing with histograms is that you
need
>to keep them updated. I experimented with creating histograms on all
indexed
>columns. Didn't hurt anything but didn't help anything unless the data was
>skewed. I've posted several times in the past about histograms and recieved
>very few replies. That leads me to believe that not many people are using
or
>are interested in histograms. I don't see them heavily emphasized at
>conferences or in books.

Well said Cherie and I couldn't agree more. So when you present this topic
at the nex

OID installation

[Paul Baumgartel]

I'm looking for help installing Oracle Internet Directory (8.1.7, Sun
Solaris 2.7).  The software installation goes fine, but once the OID
Configuration Assistant window comes up, everything stops.  My database does
use the UTF8 character set.  Any ideas out there?   Thanks.



Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

Parallel index builds can crash

[dgoulet]

To ALL,

Over the weekend I've been trying to rebuild a VERY large index on a data
warehouse table.  Well in an attempt to get faster processing I invoked the
parallel option, but the index failed for the one reason I could not easily
figure out.  I expected the index to be 4 to 5 GB in size when completed, but it
tried to create itself at 8 to 10 GB instead.  Odd I thought until this morning
when I noticed that there was two temporary segments in the target tablespace. 
I submitted a TAR to OTS for an explanation (Attached).  Basically if you do
your index builds in parallel one should expect them to be the estimated size
times the parallel setting.  OOPS!!! :-(  Someone can correct me if they know
otherwise, but I don't remember seeing this in any of the documentation.

BTW: The final index size, now that it did successfully complete, is twice what
I expected (parallel 2).

Dick Goulet

Forward Header_
Author: [EMAIL PROTECTED] (Oracle Support)
Date:   4/9/2001 10:33 AM

 Hello  Richard,

Creating Indexes in Parallel

Parallel index creation works in much the same way as a table scan with an ORDER
BY clause. The table is randomly sampled and a set of index keys is found that
equally divides the index into the same number of pieces as the degree of
parallelism(DOP). A first set of query processes scans the table, extracts key,
ROWID pairs, and sends each pair to a process in a second set of query processes
based on key. Each process in the second set sorts the keys and builds an index
in the usual fashion.
After all index pieces are built, the parallel coordinator simply concatenates
the pieces (which are ordered) to form the final index. 

Parallel local index creation uses a single server set. Each server process in
the set is assigned a table partition to scan, and
for which to build an index partition. Because half as many server processes are
used for a given DOP, parallel local index
creation can be run with a higher DOP. 

  Note: 

  When creating an index in parallel, the STORAGE clause refers to the
storage of each of the   subindexes created by the query server processes.
Therefore, an index created with an INITIAL
  of 5MB and a DOP of 12 consumes at least 60MB of storage during index
creation because each process starts with an extent of 5MB. When the query
coordinator process combines the  sorted subindexes, some of the extents may
be trimmed, and the resulting index may be smallerthan the requested 60MB.  


ORA-1652
>From version 7.x, we can create certain objects in parallel, or unrecoverable.  
In order for Oracle to accomplish this, temporary segments are created that 
eventually become a permanent part of the object, yet Oracle still refers to 
them as temp segments. Thus, most of the time you receive this error, it will 
be referring to the tablespace the object is going to be created in. 

Do the following query to find out if you're out of extents: 
  
select max(blocks), max (bytes) from sys.dba_free_space  
  where  tablespace_name = ''; 
 
For example, The above query may return:
 SQL> blocks  bytes 
 614312,580,864  
 
Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks and 
Oracle needs a contiguous block of free space of 6144 to create an object. 
 
You may have a lot of free space in separate blocks in your tablespace, but if 
it is not contiguous, Oracle cannot use it. Allocating extents requires that 
there be a contiguous block of free space. 


SOLUTION:  
1. Add a datafile to the tablespace  
2. Adjust the storage parameters of the object you are trying to create. 
   Parameters to look at: initial extent, next extent, pct increase. 
3. If you have a lot of free space in that tablespace, but the it is  
   very fragmented, you may want to consider rebuilding the tablespace. 
4. Enable AUTOEXTEND for the datafile 


 

 - Also,  Please reviewVia metalink (Metalink - - >technical
library- - >reach with note#)
Title:  ORA-01652: estimate space needed to create index




 - Also further researched and found: 
Abstract:   INDEX BUILD FAIL WITH PARALLEL DEGREE > 1



 - is there any ora-7445 and core dump file in udump directory?
 - is there an internal error (ora-600) trace file?

Please update the tar via metalink.
 Thank you,
Oracle Support Services.
 
  
  
Have you tried MetaLink?   
Search our technical libraries, create/review/update your TARs at:   
http://metalink.oracle.com 


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

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

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

RMAN-06004 Error

[Raj Gopalan]

DBAs,

I have taken DB backup using RMAN. The backup completed successfully. When I
execute list backupset, I am getting the following error

RMAN> list backupset;

RMAN-03022: compiling command: list
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: list
RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL:
nume
ric or value error: number precision too large
ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052
ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729
ORA-06512: at line 1

This is the first time I am using RMAN and I could not find anything to sort
out this issue in metalink.

Any Idea what could be the cause?

Thanks

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

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

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

Materialised view

[paquette stephane]

On Oracle 816/Solaris 5.7, I'm trying to refresh fast
a mview without success: ORA-12032.
It's a mview with single table aggregate, I've
followed all the restrictions in the doc (I'm having a
mview log, count is present,... )

I can refresh force but it's doing a complete not a
fast refresh.

Anybody ?


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

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

Re: Report - Installing Oracle on SuSE Linux 7.1

[Jared Still]

On Mondy 09 April 2001 04:20, Mark Leith wrote:
> Jared,
>
> Just a quick plug for a product that I use regularly, for downloading (no I
> don't get commision:0) which can be found at
> http://www.downloadaccelerator.com
>

Mark,

Sorry, but Download Accelerator is the product
that does not know how to deal with very large files.

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

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

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

Re: Report - Installing Oracle on SuSE Linux 7.1

[Jared Still]

For you insomniacs out there:

Filesystem:

I used extfs2.  I haven't used ReiersFS before and 
didn't feel like experimenting on this box.  It's a new
box and I just want it to work with a minumum of
fussing about.  :)

All datafiles ( including logs Paul ) are straight filesystem.
Once again, I just wanted to have this up and running.

Here's a df:

sherlock:~ # df -kl
Filesystem   1k-blocks  Used Available Use% Mounted on
/dev/hda1  3099108   1141192   1800484  39% /
/dev/hda3  1035660 56412926636   6% /home
/dev/hda4 19550644   1378864  17178564   8% /u01
/dev/hdb3 22649848   1530332  19968864   8% /u02
/dev/hda2  5162564   1975740   2924564  41% /usr
/dev/hdb2  5162564676272   4224032  14% /zips
/dev/hdc658198658198 0 100% /var/adm/mount   

dmesg?: sorry, that's a little too much for a mail list post. :)

Kernel is 2.2.18

Box specifics:

CPU:  933 mhz Pentium
RAM: 512 Meg  133 mhz

Hard Drives: 2 WD 30 Gig  7200 RPM

CD Drives:  
   1 42x  Read Only Drive
   1  Plextor 12x10x32 CDRW

Did I forget anything?  ;)

Jared

On Monday 09 April 2001 00:18, Paul Drake wrote:
> Jared,
>
> So - did your use ReiserFS for your datafiles?
> did you go raw for the online redo logs?
> Stick with extfs2 for your boot partition?
> did you use the 2.2.18 or the 2.4.1 kernel
> how much ram in the box, # of hard drives?
>
> how about posting the dmesg and maybe a df?
>
> insomniac minds want to know :)
>
> Paul
>
> Jared Still wrote:
> > As promised, here are my experiences installing Oracle on
> > SuSE Linux 7.1
> >
...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re:v$session and v$process -- Simple one

[Pablo ksksksk]

Thanks Dick,

may be your right, it could be the same user (same
unix pid) with two sessions.

thanks again



--- [EMAIL PROTECTED] escribió: > Looks to me like
you've either got two users
> connected to the database from
> Windows or one user with two sessions.  And if I'm
> not totally mistaken I
> believe that 'OraUser' is a generic entry when the
> client computer does not have
> it's computer name set.
> 
> Dick Goulet
> 
> Reply
> Separator
> Subject:v$session and v$process -- Simple one
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> <[EMAIL PROTECTED]>
> Date:   4/6/2001 8:45 AM
> 
> Hello List,
> 
> I've a simple question.
> Why do I see this output when I execute the
> following
> query:
> 
> SQL> l
>   1  select a.USERNAME,a.SPID "unix
> pid",b.SID,b.serial#,b.osuser,b.program,a.program
>   2  from v$process a, v$session b
>   3  where a.spid='&unixpid'
>   4* and a.addr=b.paddr
> SQL> 
> 
> 
> 
> USERNAMEunix pidSID   SERIAL# OSUSER
> --- - - -
> ---
> PROGRAM 
> PROGRAM
> 
> 
> oracle  18463   102  1954
> OraUser
> C:\ORAWIN\BIN\F45RUN.EXE
> oracle@fincons (TNS V1-V2)
> 
> oracle  18463   142  1263
> OraUser
> C:\ORAWIN\BIN\F45RUN.EXE
> oracle@fincons (TNS V1-V2)
> 
> 
> Why does it show me 2 oracle SIDs ???
> 
> This happens only on some unixpids.
> 
> TIA
> 
> 
> 
>
___
> Do You Yahoo!?
> Envía mensajes instantáneos y recibe alertas de
> correo con 
> Yahoo! Messenger - http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


___
Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con 
Yahoo! Messenger - http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle License Question

[nlzanen1]

Hi

It depends:

If your current license is based on UPU and all your hardware is licensed
than no problem to set up another instance on one of the existing machines.

If your current license is named users and no new named users (for instance
a department that previously never used ORACLE) will be added than no
problemo.

If your current license is concurrent devices/users (OLD LICENSE) and you
do not go over the total number of concurrent devices/users after adding
the new instance than no problem

You can always call your friendly neighbourhood store and talk to your
sales rep directly.

Met vriendelijke groet,

Jacob van Zanen
(Oracle DBA) Informatie Systemen

Ernst & Young
Informatie & Communicatie Technologie

Kantoor Gouda
Tel.: 0182 575316 (intern: 923 316)
Fax: 0182 536311
E-mail: [EMAIL PROTECTED]



   
  
"Andor Gyula"  
  
 
macc.hu> cc:   
  
Sent by: Subject: Oracle License Question  
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
09-04-2001 
  
12:35  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Hi Gurus !

Do I need another license if I want to set up a new  instance? I mean
leaglly.. :)

Thanks in advance

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

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

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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, i

RE: 8.1.6 on NT?

[Kevin Kostyszyn]

I have several different instances of 8.1.6 on NT.  I haven't had any
problems with it at all, except for one instance but I think that those
errors have more to do with the rest of the machine not the installation of
Oracle.
Kevin

-Original Message-
L.
Sent: Monday, April 09, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L


We are having trouble with response time and server crashes on a new Oracle
8.1.6 NT database.  Seems like I heard that this release is not very stable.
Has anyone had any experience with this release?  I have not applied any of
the patchsets to 8.1.6.  Should I?  If so, can anyone point me to where
there are on Metalink?

Ron Smith
Database Administration
[EMAIL PROTECTED]


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

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

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

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

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

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

RE: newbie Q: what is the maximum number of logfile member per gr

[Anderson, Brian]

Look in docs for CREATE DATABASE command, maxlogfiles and maxlogmembers are
defined at database creation and stored in the control files.  To change it
you must recreate control files.  

You probably don't want to oversize this by much, as the control files grow
to leave space for the log entries.


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


> -Original Message-
> From: Dulce L. Cajigas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 4:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: newbie Q: what is the maximum number of logfile member per
> group?
> 
> 
> We tried adding an additional member to an existing group but an error
> message told us that we can not add another member becoz the 
> maximum is 2
> only.  What file should i check to see where it was set up initially.
> 
> thank you so much and hoping for an answer.
> 
> dulce
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dulce L. Cajigas
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

Re: Last modification

[Tim Sawmiller]

Nope, nope, and nope.  To have this feature, you will have to add such columns 
yourself, and maintain them, probably by triggers.

>>> [EMAIL PROTECTED] 04/09/01 09:10AM >>>


I'd like to know when one record had been modified ... Is there a hidden
column with that information ? A special table associating the rowid with a
date ? Anything else ???

Thanks

L.A.


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

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

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

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

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

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

[paquette stephane]

Oracle Enterprise Manager 2.2 Change Management Pack
can do that kind of thing

--- [EMAIL PROTECTED] wrote:
> I would be grateful if you can advise me if there
> are other products than 
> Oracle Designer 6i which is able to build
> automatically a version control 
> baseline and track the changes at the packages and
> stored procedure level. 
> 
> My goal is to have in place a control version
> program which could be used not 
> by programmers, but the people from Internal Control
> dept which will track the 
> changes at the level of database level.
> 
> Thanks in advance,
> Pierre
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


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

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

Re: 8.1.6 on NT?

[Paul Drake]

ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81patchsets/81634/

Ron,

The only problems that I've seen are auto-start related, and were fixed
in 8.1.6.1.5.

hth,

Paul

"Smith, Ron L." wrote:
> 
> We are having trouble with response time and server crashes on a new Oracle
> 8.1.6 NT database.  Seems like I heard that this release is not very stable.
> Has anyone had any experience with this release?  I have not applied any of
> the patchsets to 8.1.6.  Should I?  If so, can anyone point me to where
> there are on Metalink?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> --
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

RE: tirggers

[Biddell, Ian]

Kevin,

In Oracle 8.1.6 you can have a database trigger as:

create database trigger  AFTER STARTUP (or something like that)

which fires when the database is opened.
So you could fire off a procedure to pin objects, eg it's good for pinning
things like sys.standard or other packages at startup.

Ian

-Original Message-
Sent: Monday, 9 April 2001 23:01
To: Multiple recipients of list ORACLE-L


That's basically what I am doing at this time.  I was just curious whether
or not there was a database trigger that could fire off once the instance
was started.  Thanks for all of the help and input people.
Sincerely
Kevin

-Original Message-
Sent: Monday, April 09, 2001 6:10 AM
To: Multiple recipients of list ORACLE-L


That's right, Oracle seems to pull in all blocks needed to satisfy the query
you send, which makes sense.. So if you do a select * from your_table; it
should pull everything in to the buffer. One thing that you do have to
consider, is that there is enough space in your KEEP buffer pool to store
all of these tables..

Back to the root of your message though Kevin, could you not just write a
script, that does a select * from your_tables, and execute this at start-up?

How large are these tables also, AFAIK the KEEP buffer pool should really be
used for smaller, lookup or code tables..

HTH

Mark


-Original Message-
Kostyszyn
Sent: Sunday, April 08, 2001 10:00
To: Multiple recipients of list ORACLE-L


If you fts the tables, won't Oracle just place them into the Keep pool
because it will think that it needs them?
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 8:55 AM


> Alex,
>
> Further testing has proved that only the blocks needed to satisfy the
query
> are loaded, and not the entire table.
>
> I can post the details if you wish, but there's your answer:)
>
> Mark
>
> -Original Message-
> Alex
> Sent: Friday, April 06, 2001 06:27
> To: Multiple recipients of list ORACLE-L
>
>
> Looks like oracle reads into keep buffer pool only blocks that it needed
but
> then keep it there. Would be intersting to know if let say table has more
> then 1 block and access is using indexes - so oracle needs to read only 1
> block - will be all table loaded into keep buffer pool or only block
needed
> to satisfy query.
>
> Alex Hillman
>
> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: tirggers
>
> I thought that as well Tim, but wasn't sure whether Oracle loads the
> table
> at startup even if this is specified in the storage clause. The
> following
> test seems to show that it doesn't though:
>
> SQL> create table DUMMY_TABLE (id number(3), dummy varchar2(5))
>   2 storage(BUFFER_POOL KEEP);
>
> Table created.
>
> SQL> select DATA_OBJECT_ID, OBJECT_TYPE
>   2from USER_OBJECTS
>   3  where OBJECT_NAME = 'DUMMY_TABLE';
>
> DATA_OBJECT_ID OBJECT_TYPE
> -- --
>  26408 TABLE
>
> SQL> select count(*) buffers
>   2from V$BH
>   3  where OBJD = 26408;
>
>BUFFERS
> --
>  1
>
> SQL> connect internal/password
> Connected.
> SQL> shutdown immediate;
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area   73701404 bytes
> Fixed Size75804 bytes
> Variable Size  56770560 bytes
> Database Buffers   16777216 bytes
> Redo Buffers  77824 bytes
> Database mounted.
> Database opened.
> SQL> connect mark/password
>
> SQL> select count(*) buffers
>   2from V$BH
>   3  where OBJD = 26408;
>
>BUFFERS
> --
>  0
>
> SQL> select * from DUMMY_TABLE;
>
> no rows selected
>
> SQL> select count(*) buffers
>   2from V$BH
>   3  where OBJD = 26408;
>
>BUFFERS
> --
>  1
>
> Not sure on the trigger though, PL/SQL is not one of my strong
> points :)
>
> Mark
>
> -Original Message-
> Sawmiller
> Sent: Friday, April 06, 2001 02:07
> To: Multiple recipients of list ORACLE-L
>
>
> Why not just specify BUFFER POOL KEEP in an alter table statement?
>
> >>> [EMAIL PROTECTED] 04/05/01 05:56PM >>>
> What is the problem to write something like
> Select * from  for all tables that you need or if there
> are too
> many such tables - create a new table with names of the tables and
> use
> dynamic SQL .
>
> Alex Hillman
>
> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 5:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: tirggers
>
> Hi Intelligent DBA's
> I was wondering if anyone knows how to create a
> trigger that
> would fire off
> at database startup time and run a script to do full table
> scans on
> several
> tables to get them into the buffer cache keep pool?  Right
> now I do
> it
> manually and

RE: Installing Oracle 8.1.6 Client on Solaris without x-windows

[Johan [EMAIL PROTECTED]]

Title: RE: Installing Oracle 8.1.6 Client on Solaris without x-windows



Thanx! 
This buggers up my day, but still - thanx

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, April 09, 2001 1:05 
  PMTo: 'Johan Locke@iCommerce '; 'Multiple recipients of list 
  ORACLE-L 'Subject: RE: Installing Oracle 8.1.6 Client on Solaris 
  without x-windows
   This would be great, but I think the glory days of DIY 
  are gone daddy gone. 
  I'd love to hear a success story otherwise from the list, 
  though. The most i've heard is that it can be scripted 
  to run in the background from a previous successful 
  install. 
  -Original Message- From: Johan 
  Locke@iCommerce To: Multiple recipients of list 
  ORACLE-L Sent: 4/9/2001 6:35 AM Subject: Installing Oracle 8.1.6 Client on Solaris without 
  x-windows 
  Hi All 
  Is there a way to install the client on Solaris without 
  running a x-windows session? 
  (i.e. all from command prompt) 
  Regards JL 
  Kind Regards Johan Locke 
  http://www.JohanLocke.co.za Certified Oracle 8 & 8i DBA Certified 
  Oracle Developer  
      
      
  Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] 
  http://www.didata.com 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: Johan Locke@iCommerce   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing).