date:20031210

Thanks Raj,

Unfortunately, in my rush to get the kids to school in time, I stuffed the
formatting when my cut 'n' pasting got converted to plain text.

Hope you found it all useful.

Cheers

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 2:49 AM


 Richard's explanation and example from c.d.o.s now has a permanent tinyurl
link ... http://tinyurl.com/yflq if anyone is interested ... this might be
better for bookmarks.

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


 -Original Message-
 Sent: Monday, December 08, 2003 4:29 PM
 To: Multiple recipients of list ORACLE-L


 Hi Yong,

 Saying there are a few errors is being a little kind to Don's Inside
Oracle Indexing article.

 [ rest snipped ]




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


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

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



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

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

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

2003-12-10 Thread Markus Reger

I don't know why they favor MS AD.

As a replacement for tnsname.ora the OID works very well.

We didn't take it because the 3 developers know how to use the tnsnames.ora, the 
clients are all but 3 webbased for html, forms or reports. reports are partially 
created into files than can be downloaded as .pdf's. the 3 other clients were once 
configured manually and left unchanged ever since.

MR

 [EMAIL PROTECTED] 12/09 5:49  
Markus - Thanks for your ideas. Basically our issue isn't Oracle logins, but
Oracle connections (replacing tnsnames.ora). For us, the user doesn't
directly log into Oracle, but the application handles the login for them.
However, I was searching for an alternative to maintaining tnsnames.ora on
each client. I considered the Oracle Names server, but Oracle has announced
this is going away in favor of OID. But my network guys favor MS AD.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

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


NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files.
We had it once, but this was rather tricky to get it working at that time. 
Especially the uploading of certificates thet we made ourselves  ... 
- but we had already a solution to update the OID on a daily/hourly basis
for user authentication. 

We then decided not to use/need it, because we only need IAS authentication
for users 
who have an NOVELL account - about thousand people like employees, students,
parttimers...  

MS AD: 
we don't have it. 
may I propose: you need an interface or procedure - possibly java or even c.

Then configure ORACLE to use this procedure, and update e.g. on an hourly
basis.
You must make up your mind who (MS or OID) administers - esp  changes -
passwords.

kr MR

 [EMAIL PROTECTED] 12/09 3:59  
Markus - Do you use Novell instead of tnsnames.ora as well as authenticating
users? We use MS AD. Any insights as to how your method could be applied to
MS AD?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 09, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L


what we have is an novell ldap with jave plugins used by oracle IAS to
authenticate users. we started once with OID but stayed then with novell.
check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config
script that allows us to use the novell ldap instead of OID. I don't know
this config script by heart. 

later on I wrote a separate authentication routine to identify against
novall ldap. but we decided not to use it since we found a configuration
that did the job for us.

hope this helps. further details must be dug out - if allowed to disclose.

kr mr

 [EMAIL PROTECTED] 12/09 1:54  
You are talking about Novell using LDAP.
I am talking about Oracle using LDAP, especially with enterprise user.

I was told that version 9i or 10g will support only OID as LDAP.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 1:54 PM


 we use some java plugins for novell to contct ldap for authentication.
used more than two years - no problems.
 BUT: we taylored it to our needs - and do NOT use OID at all.
 kr
 mr

  [EMAIL PROTECTED] 12/09 9:59  
 IIRC Oracle is going to support only OID as LDAP.
 You need to set up OID and use a product like DIRXML to propagate updates
 from Novell to OID.

 Yechiel Adar
 Mehish
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, December 08, 2003 4:34 PM


  Hi,
 
  We are in the preliminary analysis of implementing an assurance package
 (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web
 Services and Forms on AIX 5.2).
 
  We are using Novell eDirectory as our LDAP.
 
  I looked on Metalink but did not find much thing. The way I understand
it
 is that you must load the LDAP info into Oracle Internet Directory.
 
  Am I right ?
 
  Anybody using Novell eDirectory integrated with Oracle ?
 
  TIA
 
 
  Stephane Paquette
  Administrateur de bases de donnees
  Database Administrator
  Standard Life
  www.standardlife.ca 
  Tel. (514) 499-7999 poste 7470
  [EMAIL PROTECTED] 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  --
  Author: Stephane Paquette
INET: [EMAIL PROTECTED] 
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).

 --
 Please see the official

Re: leaf node 90-10 splits

Hi Tanel,

I have no idea but if you currently have 9 entries in a leaf block and the
10th entry you're about insert causes this type of split, then 9 entries
(the 90% currently in the existing leaf node) remain and the new entry (10%)
goes into the new leaf node.

A 90-10 (%) split.

Possible with small blocks (say 2K) and large index entries (200ish bytes)
when 2K blocks ruled the Oracle seas.

Like I said I have no real idea but it's my theory and makes a good bed-time
story.

Cheers ;)

Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 12:24 AM


 Hi!

 I wonder why does statistic leaf node 90-10 splits imply that right-hand
 index leaf block is split as 90-10, not 100-0 as it really is. (tested on
 9.2.0.4 W2k).

 Historical reasons?

 Tanel.


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

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



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

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

Antw: RE: PERL?

2003-12-10 Thread Markus Reger

experienced the following things useful - on unix/bsd/linux -
sqlplus /  EOF
connect sys as sysdba
startup 
EOF

things like that can be put into shell scripts - eg as startup scripts, for cron jobs 
doing e.g. reports into .pdf's to store on a webserver,

perl's expect will most likely work like the unix expect. consider autoexpect as a 
beginner.

we have oracle on NT as well. but it will be migrated to solaris and shut down within 
weeks. basically everything that works on unix/linux works in MS as well. if you can 
and want you can install cygwin or unixtools for nt. OR you use perl altogehter - but 
won't find to many tested ready scrits for it. 

my 5c.
kr MReger



 [EMAIL PROTECTED] 12/09 10:29  
On Tue, 9 Dec 2003, Yong Huang wrote:

 Speaking of Perl versus shell, Perl may still be quite primitive in supporting
 two-way communication with an external program e.g. sqlplus. (I have an example
 at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus 
 using IPC::Open2). But I think a KornShell coprocess (not a here document) does
 it nicely, i.e. piping a SQL command in and reading the result back, piping
 another command in, reading again, without exiting your sqlplus session. If you
 use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you
 can send any arbitary SQL command such as explain plan, shutdown... and read
 its output.

I think Perl with Expect.pm could likely do this without much effort. Expect allows 
you to interact with just about anything that uses a terminal. One fun case comes to 
mind. We have this LED sign (think large rectangular array of LEDs), with an 
undocumented serial interface protocol. All that came with it to control it was this 
old DOS program which would talk to the sign over a serial port. So I whipped up a 
Perl script which used Expect to interact with dosemu (a Linux DOS emulator) to run 
the program, which interacted with the sign, all running on Linux. Works pretty good.

Expect.pm is also nice to interact with network hardware that offers telnet/shell 
command interfaces. Interacting with sqlplus via Expect.pm would be pretty easy as 
well, I would think. It basically works like this:

- Spawn the program you want to interact with
- Expect a particular regex of output from the spawned process
- Act based on that output (send commands, run processes, annoy the NT admin with net 
send packets, etc)
- Wash, rinse, repeat.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

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

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

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

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

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

2003-12-10 Thread Nuno Souto

The interesting fact of course is that the beta program
of 10g was announced in newsgroups AFTER it had closed
for all intents and purposes to the general public...

And quite frankly, Oracle could do a LOT WORSE than let
customers like Mogens definitely join.  Just a feeling,
mind you.  If Oracle thinks the good old days of in-house
elites are back, they're dead wrong.

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 

 Generally, the announcements are made at events like OracleWorld,
 through OTN and so forth that the beta program is open.  Depending on
 the release, the program may not even get announced unless it's big
 enough.  IIRC, the beta program for 9.2 was open to only a small number
 of customers and wasn't announced to the world at large, whereas the 10g
 program was announced (again IIRC - it's 4 am for me and I haven't had
 my first coffee yet!) at OracleWorld in San Fran in September?  Of
 course, there are some companies that are almost always invited to join
 the beta program for the database because of the type of customer they
 are and the type of work they do - customers like Amazon, for example,
 may fall into that category.  Customers like Mogens definitely don't.

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

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

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

2003-12-10 Thread Nuno Souto

Amen...

Cheers
Nuno Souto
[EMAIL PROTECTED]

- Original Message - 

 I really do not intend to go with the flow. Fortunately, there are other databases
 and oracle's behavior is motivating me to start giving them serious considerations.

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

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

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

2003-12-10 Thread Nuno Souto

Isn't that what Oracle has always done?
I've got a funny feeling it's gonna start 
biting back really hard...

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 
 guys decide to put out a limited production version? Prolonging the hype
 would not serve any useful purpose, except may  be, to further annoy your
 customers.

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

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

RE: NT - Win2K causes performance degradation..

2003-12-10 Thread Paul Vincent

Hi Mark,

no thoughts specific to Oracle, but I'd recommend using the principle of change only 
one element at a time. I'd say they were unwise to upgrade to W2K, and at the same 
time change their Oracle parameters. If possible, I'd advise they set all their Oracle 
parameters back to their pre-upgrade values, then carry out the same performance 
measures they used to arrive at their was 7/10, is now 3/10 comment. If the 
degradation still exists to the same extent, then, yes, it must be the upgrade that 
produced the problems, and it needs investigating in that light. If they still get 
7/10, then it must have been the changes to the Oracle parameters, not the W2K 
upgrade, that caused the problem.

Changing too many elements simultaneously makes it impossible (or much more difficult) 
to isolate the cause, so you change one element at a time. Basic engineering principle!

Paul

-Original Message-
Mark Leith
Sent: 10 December 2003 09:04
To: Multiple recipients of list ORACLE-L


Hi All,

We've been asked a question from one of our clients that I'm a little
stumped on.

They run an OLTP database (Oracle 8.1.7), and have recently upgraded their
NT machine to Windows 2000, they were running with 2gb of memory, and
upgraded that to 4gb in the process. As they increased physical memory, they
also increased their SGA size  db_block_buffers.

Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was it was 7 out of 10, and is
now 3 out of 10..).

Has anybody else done a system upgrade of this nature that has caused less
than desirable effects? Any pointers as to what to look at? We've requested
some stats (top wait stats etc.) and I'll feed these back as and when I get
them - but I thought I'd throw this out to you guys in the vague hope that
someone has experienced some relatively similar experiences.

Cheers!

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

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

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

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

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

Hmm, so you're telling me you want me to let Larry know your views on
this?  Not this bunny!  :)

The problem in putting out a limited production release is not so much
in putting it out - that's dead easy.  It's in the expectation that some
form of support comes with it usually, and limited production code is
usually limited because it's still beta - hence bugs and so on that need
support resources to address.  Of course, we don't have bugs in our
Production code!  :)

However, I will raise your comments with the Product Management team so
they're aware of them.  Can't promise that will mean anything in the way
of results of course!

As for when you'll see the software, what Larry said at OracleWorld is
still the only official date I've heard.

Pete

Controlling developers is like herding cats.

Kevin Loney, Oracle DBA Handbook

Oh no, it's not.  It's much harder than that!

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Mladen Gogala
Sent: Wednesday, December 10, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L

Pete, I'd like to clarify my position first: I don't have any burning
problem
that would compel me to start testing 10g. I want only to learn the new
features. 
Second, I don't see why would putting a limited production version out
for 
people to learn the new features be so much work. 
Third, inviting distinguished 10g users and allowing them early access
would be
fair and acceptable to me if it didn't last too long, thus making the
advantage too large. 
Having this early start for this long is an annoying blunder, pure and
simple. Oracle 
either shouldn't have announced the product that early or should have
provided some 
software.  Articles, white papers and veiled testimonies by the
privileged ones are not enough.  
I believe you when you say that you don't have much influence because
you really are a 
nice guy. Nevertheless, someone should tell the big guys that putting
out some limited 
production version would be a good thing to do.  If not that, then
please tell us when 
can we expect to see the software.


On 2003.12.09 14:39, Pete Sharman wrote:
 Well, as you'd suspect I don't have any control over these sorts of
 decisions!
 
 I didn't actually see the announcement on OTN, so I'm not sure who the
 email would have gone to.  There was a way Oracle employees could
invite
 customers to be part of the beta program, sp presumably your sales rep
 didn't think you were important enough to be on the program.  ;)
 
 Seriously, before Jared tells us to take this conversation offline,
let
 me make a couple of final points on this:
 
 1.  From Oracle's perspective, the beta program is an enormous amount
of
 work, and requires a lot of ongoing management of the customers
 involved.  For that reason, the beta program is not really designed to
 be open to everyone.
 
 2.  If you think you really have a valid interest in being on the beta
 program for future releases and are prepared to put in the work that's
 involved with the beta program (logging bugs, testing new
functionality
 and so on), let me know and I can send you information on how to join
 future beta programs as they occur.  Since the beta proposals are
 actually voted on, a compelling case will help with actually getting
on
 the beta program.
 
 3.  If you are simply interested in playing with the new features,
 rather than seriously stress testing them, then I probably can't help
 you.  Decisions on early adopter sorts of programs that are set up
to
 handle people who want to play are beyond my level at Oracle.
 
 As for Mogens, I know he's on the beta program.  I got him there,
along
 with a few of the other Oakies.  It was a suggestion I came up with
 because if we can get people like Mogens, Cary, Jonathan and Steve
(who
 are the four I suggested to Development) to say what a wonderful
product
 10g is, then that's a really telling statement.  I'm not sure that any
 of them have said it yet, though!  :)
 
 Pete
 
 Controlling developers is like herding cats.
 
 Kevin Loney, Oracle DBA Handbook
 
 Oh no, it's not.  It's much harder than that!
 
 Bruce Pihlamae, long-term Oracle DBA
 
 
 -Original Message-
 Mladen Gogala
 Sent: Wednesday, December 10, 2003 5:40 AM
 To: Multiple recipients of list ORACLE-L
 
 There was an announcement on the OTN, but nobody replied to email. 
 When reading this list, I get impression that quite a few people 
 were able to get the software so far and that the shroud of secrecy
 over the whole thing is maintained in order for them to gain advantage
 over the rest of customers. Anyway, Christmas is almost here. When do
 the rest us, not so important customers, get to see 10g? Speaking of
 Mogens, I believe that he has 10g. 
 Whatever the intention was, it was a marketing blunder. As a customer,
 I'm
 less then happy with the impossibility of getting to know 10g despite
 the
 multitude of materials posted about it. I even tried to get 10g CDs
from
 my oracle sales rep. but

Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

2003-12-10 Thread Hybart, Clive

Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password






Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails.

However sqlplus using the same connection syntax Connect username/[EMAIL PROTECTED] is fine.

Any ideas, peeps ?

Re: rebuilding indexes - sure to cause a ruckus

Hi Yong,

One thing I should have mentioned when I posted my epic is that it not
only attempts to correct the numerous technical errors in the article but
also attempts to answer the various questions the article raises but totally
fails to address. What I find most astonishing about the article is that the
author confesses at the conclusion he has no idea when and why an index
rebuild is beneficial. And as the author doesn't know, then surely it must
all be so difficult, a scientific-less phenomenon.

If I can convince anyone who makes it through my email that this isn't
rocket science, then it's been worth the bandwidth.

BTW, does anyone know what a rocket scientist refers to when they say Hey,
this is all quite easy, it sure ain't ? ?

Cheers ;)

Richard

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 5:44 AM


 Thanks, Richard. I'll read your long message more carefully later. I like
your
 statement that rebuilding an index or not is not rocket science. One needs
to
 measure the performance before and after the rebuild and make a conclusion
 himself. Many times we discuss performance issues and get very technical
and
 sophisticated, without showing experimental results! Having been a science
 researcher before, I'd like to emphasize that facts speak louder than
theories.
 There may be 10,000 24x7 databases in the world that don't easily allow
even
 testing an index rebuild. But there may be 100 times more production
databases
 in the world that are not 24x7. The individual DBA needs to do his control
 study and conclude, using experts' opinions as reference.

 Yong Huang



 __
 Do you Yahoo!?
 New Yahoo! Photos - easier uploading and sharing.
 http://photos.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Yong Huang
   INET: [EMAIL PROTECTED]

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



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

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

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

2003-12-10 Thread Mark Leith

Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password



Hi 
there Clive! :)

Are 
you getting any specific errors - and if so, what are they? 

Cheers
Mark


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, 
  CliveSent: 10 December 2003 10:39To: Multiple recipients 
  of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i 
  (Zos 390) due to invalid
  Since upgrading our mainframe database to 
  9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe 
  fails. However sqlplus using the same 
  connection syntax "Connect username/[EMAIL PROTECTED]" is fine. 
  Any ideas, peeps ?

Re: rebuilding indexes - sure to cause a ruckus

2003-12-10 Thread K Gopalakrishnan

Richard:

I think that is the simple way of questioning other person's capacity.

Remember this statment (borrowed from some one !!)

If you are telling something is simple,
you are questioning the other person's intelligence !!'


KG

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

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

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

2003-12-10 Thread Hately, Mike (LogicaCMG)

Clive,
during the upgrade has the global_names parameter somehow been changed from
false to true?
This would cause the connection to be refused if the link name does not
match the global_name for the target database.
 
Cheers,
Mike Hately

-Original Message-
On Behalf Of Hybart, Clive
Sent: 10 December 2003 10:39
To: Multiple recipients of list ORACLE-L



Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a
Unix box (8.1.7.0) and the mainframe fails. 
However sqlplus using the same connection syntax Connect
username/[EMAIL PROTECTED] is fine. 
Any ideas, peeps ? 




E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  INET: [EMAIL PROTECTED]

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

RE: A brief detour....;-)

So much printing ... no wonder we have a lot of dead trees now !!!

wide grin
Raj

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


-Original Message-
Sent: Tuesday, December 09, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L


Back in the early 80's at school we had a towers of hanoi running in PL/1 
On Nixdorf 8820, a teletype with matrix printer, printing out the full 
configuration after every move you made

Regards, Carel-Jan


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

RE: rebuilding indexes - sure to cause a ruckus

Richard, I found it immensely useful, that's why I created the tinyurl and went to 
c.d.o.s and read the whole thread, from first to last post. (man those people need to 
learn to weed out old comments in the replies).

This is what I love about this forum, it comes with huge amount of knowledge, eager 
members who are ready to educate and learn, add a dash of rhetoric and a right amount 
of fun. In other words a perfect combination.

Thanks for your explanation.
Raj

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


-Original Message-
Sent: Wednesday, December 10, 2003 4:15 AM
To: Multiple recipients of list ORACLE-L


Thanks Raj,

Unfortunately, in my rush to get the kids to school in time, I stuffed the formatting 
when my cut 'n' pasting got converted to plain text.
Hope you found it all useful.

Cheers

Richard

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

OT Re: Re: rebuilding indexes - sure to cause a ruckus

2003-12-10 Thread Guido Konsolke

Hi Richard,

I think, there are 2 candidates for an answer.
1life (nothing is more difficult)
2...love (ever tried to read your madam's thoughts?) ;-)

Corrections welcome (as always).

Cheers,
Guido

 [EMAIL PROTECTED] 10.12.2003  11.39 Uhr 
(snip)
If I can convince anyone who makes it through my email that this isn't
rocket science, then it's been worth the bandwidth.
BTW, does anyone know what a rocket scientist refers to when they say Hey,
this is all quite easy, it sure ain't ? ?

Cheers ;)

Richard


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

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

Re: rebuilding indexes - sure to cause a ruckus

Terse ?

You haven't heard me terse until youhear me
trying to get the kids to sleep at night.

Don got it easy ;)

- Original Message -

From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L

Sent: Wednesday, December 10, 2003 8:14
AM
Subject: Re: rebuilding indexes - sure to
cause a ruckus
And in case you miss it in
Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform
operations that modify the index(es), and perform block dumps of the index as you go. You can see
exactly what Oracle is doing with the
index. Jared

Yong Huang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/09/2003 11:44 AM
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc:

Subject:Re: rebuilding indexes - sure
to cause a ruckusThanks, Richard. I'll read your long message more
carefully later. I like yourstatement that rebuilding an index or not is
not rocket science. One needs tomeasure the performance before and after
the rebuild and make a conclusionhimself. Many times we discuss
performance issues and get very technical andsophisticated, without
showing experimental results! Having been a scienceresearcher before, I'd
like to emphasize that facts speak louder than theories.There may be
10,000 24x7 databases in the world that don't easily allow eventesting an
index rebuild. But there may be 100 times more production databasesin the
world that are not 24x7. The individual DBA needs to do his controlstudy
and conclude, using experts' opinions as reference.Yong
Huang__Do you
Yahoo!?New Yahoo! Photos - easier uploading and
sharing.http://photos.yahoo.com/-- Please see the official
ORACLE-L FAQ: http://www.orafaq.net-- Author: Yong
HuangINET: [EMAIL PROTECTED]Fat City Network Services
-- 858-538-5051 http://www.fatcity.comSan Diego, California
-- Mailing list and web hosting
services-To
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing
list you want to be removed from). You mayalso send the HELP command
for other information (like
subscribing).

RE: Oracle AS 10g

2003-12-10 Thread Boivin, Patrice J

OTN seems to say that it will be in the Database 10g, not in OAS 10g.  I'm
curious about the new OEM as well, given the chats on the list about it.

I notice they posted Developer Server 10g, and a preview of Jdeveloper 10g
this morning.

Patrice.

-Original Message-
Sent: December 10, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


Anyone know if this includes the new OEM 4.0 ?

mvg/regards

Jo






Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/09/2003 18:14
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle AS 10g


Has been posted for HP/UX and Solaris on OTN.

http://otn.oracle.com/software/products/ias/devuse.html

I don't see Windows in their certification matrix, but they mention Red 
Hat
linux 2.1.  No SuSE.

http://otn.oracle.com/software/products/ias/files/as-certification-904.html

Maybe they will update this later.

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

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



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

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

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

RE: Oracle AS 10g

2003-12-10 Thread Boivin, Patrice J

Here I am correcting myself again... The full-edition of OAS includes the
OEM.

Patrice.

-Original Message-
Sent: December 10, 2003 8:29 AM
To: '[EMAIL PROTECTED]'


OTN seems to say that it will be in the Database 10g, not in OAS 10g.  I'm
curious about the new OEM as well, given the chats on the list about it.

I notice they posted Developer Server 10g, and a preview of Jdeveloper 10g
this morning.

Patrice.

-Original Message-
Sent: December 10, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


Anyone know if this includes the new OEM 4.0 ?

mvg/regards

Jo






Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/09/2003 18:14
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle AS 10g


Has been posted for HP/UX and Solaris on OTN.

http://otn.oracle.com/software/products/ias/devuse.html

I don't see Windows in their certification matrix, but they mention Red 
Hat
linux 2.1.  No SuSE.

http://otn.oracle.com/software/products/ias/files/as-certification-904.html

Maybe they will update this later.

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

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



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

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

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

Re: rebuilding indexes - sure to cause a ruckus

Hi KG,

O, you've got me thinking here !!

I'm not too sure that I've really questioned anyone's intelligence. I've
always measured someone's intelligence by:

1. How quickly the can learn and absorb new information
2. How much they know and appreciate the work of David Bowie

A quick check of the Oxford Dictionary describes the word intelligence as
mental ability to learn and understand things (although interestingly,
there's no mention of DB).

I guess the issue I have is that if intelligent people are told and feed
incorrect information (and Don's article has it's share of incorrect
information) then fundamentally it's one's knowledge that I begin
questioning. Unfortunately, I believe there are a lot of intelligent people
in the Oracle community who have a questionable knowledge of Oracle (or
aspects of Oracle) as a direct result of the poor quality of information
that people absorb (be it books, training courses, web-articles, etc..). And
undoubtedly many of these people that write substandard materials in turn
have picked up flawed knowledge due to the quality of their readings,
education and lack of proper research.

As I mentioned Knowledge is the key that unlocks the door of doubt. If you
have no doubts about something, it by definition becomes simple !!

Unfortunately, if you're presented with the wrong information, you get
access to the wrong key ;)

Cheers

Richard

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 10:09 PM


 Richard:

 I think that is the simple way of questioning other person's capacity.

 Remember this statment (borrowed from some one !!)

 If you are telling something is simple,
 you are questioning the other person's intelligence !!'


 KG

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

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



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

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

Re: Oracle8i and oracle9i in the same machine

2003-12-10 Thread Yechiel Adar




Oracle use the selected home as default.
You can see you default home in:
start-programs-oracle installation 
products-home selector.

If you want to run scripts on the other home you need to 
add: 
set oracle_home=c:\oracle\ora92 (for example) at the start 
of your script.

Yechiel AdarMehish

  - Original Message - 
  From: 
  Mauricio Vélez 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 10, 2003 12:29 
  AM
  Subject: Oracle8i and oracle9i in the 
  same machine
  
  Hi everybody
  I have been running oracle817 since long time on WindowsNTNow I 
  installed Oracle9i on the same machine and I cannot use both at the same 
  time.
  How can I resolve this problem
  regards,
  Mauricio
  
  
  
  Do you Yahoo!?New 
  Yahoo! Photos - easier uploading and sharing

RE: Creating the Java System

2003-12-10 Thread Mercadante, Thomas F

Mark  Mike,

Thanks for the replies.  They both were right on the mark.  The full removal
did the trick.

thanks again

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, December 09, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L


Thomas,

This error seems to vaguely ring a bell.

You may try:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_
database_id=NOTp_id=209870.1

Hope that's helpful.

-Mark


-Original Message-
Sent: Tuesday, December 09, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


gee thanks.

where do you live?  I'll meet you at your car.  I'll be the one with the
baseball bat.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, December 09, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


I would advise full export and then executing create database controlfile
reuse
datafile.logfile... command before initjvm and everything will work.
On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote:
 All,
 
 I am attempting to install the Java system in a 9.2 database on Sun
Solaris.
 This is a db that I migrated up to 9.2 from 8.1.7.
 
 I am getting the following:
 
 SQL create or replace java system
   2  /
 create or replace java system
 *
 ERROR at line 1:
 ORA-00604: error occurred at recursive SQL level 2
 ORA-01422: exact fetch returns more than requested number of rows
 ORA-06512: at line 11
 
 I get this when I run the initjvm.sql text.  Java_Shared_Pool is at 32 M.
 
 Thanks for any ideas.
 
 Tom Mercadante
 Oracle Certified Professional
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

Mladen Gogala
Oracle DBA



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

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

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

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

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

tuning for throughput vs. tuning for response time

2003-12-10 Thread ryan_oracle

Has anyone else notice that these two can be somewhat different? In a high transaction 
system, I typiucal try to reduce LIOs when I write queries.

For last 6-8 months, Ive been doing alot of ETL and nightly batch data loads. Ive 
found that there are times when I can improve response time by 20-30%(which can be 
significant in a batch process) and at the same time increasing LIOs by the same 
amount. Ive found this to be the case with large index fast full scans. Unfortunately, 
I forgot to save the test cases. Im not concerned about scaling up users here. 

Has anyone else noticed this? 

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

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

RE: Documenting databases

2003-12-10 Thread Thater, William






  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09, 2003 
  7:19 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Documenting databases
  The internal stuff can be documented 
  with OraSnap. Just google for it. 
  It's free, detailed, and easy to setup and automate. 
  Jared [Shrek]
  and 
  produces nice pretty html pages that damagement can look at in their 
  browser.
  
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA
  "I'm 
  going to work my ticket if I can..." -- Gilwell song
   
  [EMAIL PROTECTED]
  
  Breakthrough: It finally booted on the first 
try.

RE: rebuilding indexes - sure to cause a ruckus

2003-12-10 Thread Thater, William

Richard Foote  scribbled on the wall in glitter crayon:

 BTW, does anyone know what a rocket scientist refers to when they say
 Hey, this is all quite easy, it sure ain't ? ?

the only two i know use theoretical physics.;-)

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Nothing can move faster than light. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

Re: Documenting databases

2003-12-10 Thread Ron Rogers

Alan,
 When I started working at my present job there was zip,nada,zilch..
for database documentation. I started with the basics of:
describe every table.
describe the table data source location and provider and method of
loading the data into the table.
describe who or how the data in the table is used.
document the database creation (create scripts to create the database,
tablespaces,tables,triggers,etc..) and keep the scripts updated as
conditions change. I periodically burn a CDROM with the scripts in case
of a hardware failure and after a lot of changes in the scripts ( like
year end work for the next year's tables)
Describe the packages and objects  that are used in the database (non
Oracle created).
create a daily/weekly/monthly(as you feel you are comfortable with) 
tablespace usage report to plan on new storage needs.
In all cases document every thing. or CYA 
I hope this will get you started and remember that database
documentation is an ever ending task.
Ron

 [EMAIL PROTECTED] 12/09/2003 5:49:25 PM 





Recently our database manager has asked us to do the
unthinkable
document our databases!  To make matters worse, and without our input,
he
went ahead and created a schema and put it in an Access database
(using
tables to make it look like a speadsheet).  Either we use his idea or
come
up with something else.
So, I thought I'd ask everyone on the list how you do it.  Text
files?
In a database (oracle, or other)?   Spreadsheets?  What are the pros
and
cons?  Etc


Thanks,

Alan


Alan Aschenbrenner
Oracle DBA
IHS Group
[EMAIL PROTECTED] 

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

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

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

RE: A brief detour....;-)

2003-12-10 Thread Karniotis, Stephen

Good morning all:

  Well some good news, especially for April Wells.  I could not find the
TSO/CLIST version of the workshop (we removed it from the class and replaced
it with another complicated workshop from the Data Structures and PL/I
Exercise handbook), however, I think I found the PL/I version.  I will have
to wait until next week when our instructors are back from Europe and I will
ping them.

  Jared:  Given that we don't like attachments, any ideas on how to post
this thing?  Reply direct to me.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
Carel-Jan Engel
Sent:   Tuesday, December 09, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: A brief detour;-)

Back in the early 80's at school we had a towers of hanoi running in PL/1 
On Nixdorf 8820, a teletype with matrix printer, printing out the full 
configuration after every move you made

Regards, Carel-Jan

-- There will always be another 10 last bugs --

  At 07:24 9-12-03 -0800, you wrote:
Hate to say this but you are a bit late.  I had my students at University
and here at Compuware create three to four different versions of the
Tower's
of Hanoi solution in PL/SQL.  Used PL/SQL tables, stack processing,
recursion (yes it can be done), and others.  I also had (yep had - lost
this) one for both PL/I and TSO/CLIST Dialog Manager  VMS DCL.  I actually
created screens where you could dynamically choose the number of pegs and
pieces.  It also verified that you were putting smaller pieces on top of
larger ones (one of the core rules for Tof H).

Isn't programming great?

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

  -Original Message-
Bobak, Mark
Sent:   Monday, December 08, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject:A brief detour;-)

So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who
has
over 100 different implementations of the Towers of Hanoi solution, each in
a different language.  Since he didn't have one in PL/SQL, I decided to
write one.

Here it is:
create or replace package hanoi
is
from_peg  constant number := 1;
to_pegconstant number := 3;
using_peg constant number := 2;

procedure play(n number);

end hanoi;
/
create or replace package body hanoi
is

procedure do_hanoi(n number, from_peg number, to_peg number, using_peg
number)
is
begin
 if(n  0) then
 do_hanoi(n-1,from_peg, using_peg, to_peg);
 dbms_output.put_line('move '||from_peg||' -- '||to_peg);
 do_hanoi(n-1, using_peg, to_peg, from_peg);
 end if;
end;
procedure play(n number)
is
begin
 do_hanoi(n, from_peg, to_peg, using_peg);
end;
end;
/

This concludes this public service announcement.  We now return you to our
regularly scheduled programming.

-Mark

PS  Yes, it's a slow day;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bobak, Mark
   INET: [EMAIL PROTECTED]

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

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

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

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

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

RE: A brief detour....;-)

2003-12-10 Thread Carel-Jan Engel

Apologies..

Carel-Jan

-- There will allways be another 10 last bugs --

 So much printing ... no wonder we have a lot of dead trees now !!!

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


 -Original Message-
 Sent: Tuesday, December 09, 2003 5:09 PM
 To: Multiple recipients of list ORACLE-L


 Back in the early 80's at school we had a towers of hanoi running in PL/1
 On Nixdorf 8820, a teletype with matrix printer, printing out the full
 configuration after every move you made

 Regards, Carel-Jan


 **
 This e-mail message is confidential, intended only for the named
 recipient(s) above and may contain information that is privileged,
 attorney work product or exempt from disclosure under applicable law. If
 you have received this message in error, or are not the named
 recipient(s), please immediately notify corporate MIS at (860) 766-2000
 and delete this e-mail message from your computer, Thank you.
 **5
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Jamadagni, Rajendra
   INET: [EMAIL PROTECTED]

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


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

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

RE: NT - Win2K causes performance degradation..

2003-12-10 Thread Goulet, Dick

Mark,

I have not done a MicroSlop upgrade, but I have in the past upped the SGA size 
and gotten when I really did not want, which was database performance degradation.  
You might ask them to check the pagefile size.  If it's system maintained or too small 
funny things do happen.  BTW: My rule of thumb with Win2K is pagefile size = physical 
memory *1.5.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, December 10, 2003 4:04 AM
To: Multiple recipients of list ORACLE-L


Hi All,

We've been asked a question from one of our clients that I'm a little
stumped on.

They run an OLTP database (Oracle 8.1.7), and have recently upgraded their
NT machine to Windows 2000, they were running with 2gb of memory, and
upgraded that to 4gb in the process. As they increased physical memory, they
also increased their SGA size  db_block_buffers.

Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was it was 7 out of 10, and is
now 3 out of 10..).

Has anybody else done a system upgrade of this nature that has caused less
than desirable effects? Any pointers as to what to look at? We've requested
some stats (top wait stats etc.) and I'll feed these back as and when I get
them - but I thought I'd throw this out to you guys in the vague hope that
someone has experienced some relatively similar experiences.

Cheers!

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

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

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

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

Re: NT - Win2K causes performance degradation..

2003-12-10 Thread Jared Still

Mark,

This is pure speculation, as you didn't provide any particulars.

Upgrading to Win2k is not likely the culprit, or at least, I have
experienced any kind of problem in moving a database from NT - Win2k.

When they upgraded the memory, by just now much did they increase
db_block_buffers?

If increased too much, they could be spending a lot of time 
waiting on latches, as there may be too much memory to 
search through.

As always, excellent advice may be had from Steve Adams:
http://www.ixora.com.au/q+a/pool.htm

Also, when upgrading to 4G of memory, did they set the /3GB switch?

Unless you do, there is only 2G of memory available to Oracle,
and if you increase the size of the SGA too much and start
excessive paging...

HTH

Jared

On Wed, 2003-12-10 at 01:04, Mark Leith wrote:
 Hi All,
 
 We've been asked a question from one of our clients that I'm a little
 stumped on.
 
 They run an OLTP database (Oracle 8.1.7), and have recently upgraded their
 NT machine to Windows 2000, they were running with 2gb of memory, and
 upgraded that to 4gb in the process. As they increased physical memory, they
 also increased their SGA size  db_block_buffers.
 
 Since they've upgraded they have noticed a significant decrease in
 performance (the way it was described to me was it was 7 out of 10, and is
 now 3 out of 10..).
 
 Has anybody else done a system upgrade of this nature that has caused less
 than desirable effects? Any pointers as to what to look at? We've requested
 some stats (top wait stats etc.) and I'll feed these back as and when I get
 them - but I thought I'd throw this out to you guys in the vague hope that
 someone has experienced some relatively similar experiences.
 
 Cheers!
 
 Mark
 
 ===
  Mark Leith | T: +44 (0)1905 330 281
  Sales  Marketing  | F: +44 (0)870 127 5283
  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
 ===
http://www.cool-tools.co.uk
Maximising throughput  performance
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Mark Leith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


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

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

RE: Windows clustering???

2003-12-10 Thread nelson . petersen

Now you've got me going, Rich.

After 15 years of VMS we're being forced to use UNIX (HP-UX 11i) just
because
the application we want to use doesn't run on VMS.  
(Developers needed to re-write the app for VMS.  Marketing needed so the
developers will be paid
 and the company will be profitable.)

It's taking me a little while to become accustomed to CaSe SenSiTIvitY.
(VMS's revenge on case sensitivity?  Font-size *and* font-set sensitivity!)

Clustering is just something we've taken for granted.
We do run Oracle on VMS (since 1999) and have not had the up-time 
mentioned in that INQ article.

Keeping the cluster up is a lot easier than keeping an instance up!

Nelson

-Original Message-
Sent: Tuesday, December 09, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


I'm guessing they're not running Oracle on this VMS cluster.  I really liked
the part about the most difficult part was explaining to managers why it
was unnecessary to shut systems down, even during the physical relocation.

http://www.theinquirer.net/?article=13002

Imagine if DEC had any marketing...

Rich

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

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

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

RE: Re: Documenting databases

2003-12-10 Thread Stephane Faroult

Alan,

  The IT departments of several sites, hitherto fairly independent, have all been 
brought under a single roof at one of my customers and as a result a lot of databases 
have fallen into the herd of databases we had to manage there.
IMHO the key point to inventory is automation; if you don't automate, it will never 
stay up-to-date.
  First of all, get hold of some platform for scripting.
VERY VERY SMALLI don't know perl,/VERY VERY SMALLMICROSCOPIC I don't even plan 
to learn it any soon/MICROSCOPIC and as I feel comfortable with ksh, sed, awk and 
the like I jumped on a Unix platform, but your choice may be different.
  The first challenge in our case was to build an inventory of databases (asking 
people is totally unreliable); I have used scripts from Tim Gorman which you will find 
on his site (http://www.evdbt.com) - from a security paper, which I have reworked to 
suit my case. The idea was to probe the network (fortunately all servers are supposed 
to follow a special address pattern) and check for listeners, and send the lsnrctl 
stat command. This helps you identify servers, listeners, and instances. A suitable 
schema was built into a database (Oracle, but see below) to store this; note that 
relationships are sometimes not very simple, since a same instance can be served by 
several listeners.
Next step was to secure a foothold into each database to execute inventory queries (it 
has been a good opportunity to check security too). DBSNMP/DBSNMP is a good bet. 
Actually, we created a special MONITOR account on each database, with only the minimum 
rights required.
Everyday a script runs, which checks V$DATABASE, V$INSTANCE, V$LICENCE, V$VERSION (the 
only place BTW when you find some indication about which OS you are running on), 
getting information and updating it if required. Storage is of course checked as well. 
Database links are collected too. We have a PHP application displaying all the 
information (with the refresh date), conveniently crossed (for instance, we list for 
each database the dblinks to the database as well as the dblinks from the database). 
We have some summary PDF reports (storage, databases per OS, per version, etc.) which 
are printed every week. We are also linking to a (static) inventory of applications.
  It's still work in progress. We have recently added a connection test every 15mn to 
check database availability (trying a non-existent user. If we don't get ORA-1917 we 
try to ping the server and tnsping the listener to pinpoint the reason for the problem 
- of course we skip the other databases on the server if we can't ping it) and compute 
some availability percentage figure. We also intend to collect some metrics at regular 
intervals to have an idea about the load.
  I have nothing against using Access to store the data; in fact, some of the ideas 
were borrowed from another customer where the repository is a Sybase database (TCL 
scripts do a full inventory of both the Sybase and Oracle databases - several hundreds 
of them). But, once again, do it AUTOMATICALLY.

HTH

Stephane Faroult


- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 09 Dec 2003 15:34:32





Dan,

That's a good idea for documenting structures
inside the database.
However, my database manager wants more high level
info:  database name /
host, oracle version, listeners, applications that
use it, cron job
descriptions and times, main schemas and what they
are used for, lists of
developers names that access the databse, etc...

Alan



   
   
   
  Daniel Hanks 
   
   
  [EMAIL PROTECTED]   To: 
 Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]  
  c.com   cc: 
   
   
  Sent by:
Subject:  Re: Documenting databases

  [EMAIL PROTECTED]
   
   
  .com 
   
   
   
   
   
   
   
   
  12/09/2003 04:09 
   
   
  PM

RE: Documenting databases

Alan - First the bad news. Obviously you can't automatically get all that
information, but then you knew that. 
   The good news. I think you'll find that information to be very valuable.
I try to collect that myself. A spreadsheet or Access database is probably
as good a way as any. If you have a help desk, they may be able to store
this information as a configuration (or CI) in their tool. Another piece of
data to consider is the database links.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 09, 2003 5:35 PM
To: Multiple recipients of list ORACLE-L






Dan,

That's a good idea for documenting structures inside the database.
However, my database manager wants more high level info:  database name /
host, oracle version, listeners, applications that use it, cron job
descriptions and times, main schemas and what they are used for, lists of
developers names that access the databse, etc...

Alan



 

  Daniel Hanks

  [EMAIL PROTECTED]To:   Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]   
  c.com   cc:

  Sent by: Subject:  Re: Documenting
databases 
  [EMAIL PROTECTED]

  .com

 

 

  12/09/2003 04:09

  PM

  Please respond to

  ORACLE-L

 

 





On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote:

 Recently our database manager has asked us to do the unthinkable
 document our databases!  To make matters worse, and without our input, he
 went ahead and created a schema and put it in an Access database (using
 tables to make it look like a speadsheet).  Either we use his idea or
come
 up with something else.
 So, I thought I'd ask everyone on the list how you do it.  Text
files?
 In a database (oracle, or other)?   Spreadsheets?  What are the pros and
 cons?  Etc


How about in each database itself.

COMMENT ON TABLE|COLUMN tab|tab.col IS '...'

comes to mind. It's simplistic, yes, but at least you don't have to
remember where you put your documentation...

HTH,

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

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

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



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

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

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

RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

2003-12-10 Thread Hybart, Clive

Title: Message



Usual 
ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the 
same login

  
  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 
  11:59To: Multiple recipients of list ORACLE-LSubject: 
  RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to 
  invalid
  Hi 
  there Clive! :)
  
  Are 
  you getting any specific errors - and if so, what are they? 
  
  
  Cheers
  Mark
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Hybart, 
CliveSent: 10 December 2003 10:39To: Multiple 
recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 
(Unix) and 9i (Zos 390) due to invalid
Since upgrading our mainframe database to 
9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe 
fails. However sqlplus using the same 
connection syntax "Connect username/[EMAIL PROTECTED]" is fine. 
Any ideas, peeps ?

RE: NT - Win2K causes performance degradation..

2003-12-10 Thread Stephen.Lee


Might also be they bumped shared_pool way up and they aren't using bind
variables?

 -Original Message-
 
 When they upgraded the memory, by just now much did they increase
 db_block_buffers?
 
 If increased too much, they could be spending a lot of time 
 waiting on latches, as there may be too much memory to 
 search through.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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

Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

2003-12-10 Thread Thomas Day


How are you resolving your aliases on the unix box and on your client?  Are
you using onames for both (check your sqlnet.ora at both locations) or are
you using local copies of tnsnames.ora? (or some other method).



   

  Hybart, Clive  

  clive.hybartTo:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @metoffice.com  cc: 

  Sent by: Subject: Dblink fails between 8.1.7 
(Unix) and 9i (Zos 390) due to invalid  
  ml-errors

   

   

  12/10/2003 05:39 

  AM   

  Please respond   

  to ORACLE-L  

   

   





Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a
Unix box (8.1.7.0) and the mainframe fails.
However sqlplus using the same connection syntax Connect
username/[EMAIL PROTECTED] is fine.
Any ideas, peeps ?




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

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

Re: leaf node 90-10 splits

Hi, Tanel,

Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2
documentation. If the index is on strictly monotonically increasing numbers,
won't a new node be added to the right without a block split?

Yong Huang

 I wonder why does statistic leaf node 90-10 splits imply that right-hand
 index leaf block is split as 90-10, not 100-0 as it really is. (tested on
 9.2.0.4 W2k).

 Historical reasons?

 Tanel.

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

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

RE: PERL?

Dan,

If I were to use Expect.pm in Perl, I would program in Expect directly. If we
can have one less layer of wrapping, why not? On the other hand, sqlplus is not
an application that insists on terminal input as telnet does. So you can use a
shell here document or coprocess to talk to it; Expect is an overkill. (Some
people use Expect to simply ftp files without knowing that ftp -n allows you to
use a here document; an Expect ftp script is necessary only if you need to
respond differently to each of the ftp errors).

Yong Huang

Daniel Hanks wrote:

I think Perl with Expect.pm could likely do this without much effort. Expect
allows you to interact with just about anything that uses a terminal. One fun
case comes to mind. We have this LED sign (think large rectangular array of
LEDs), with an undocumented serial interface protocol. All that came with it to
control it was this old DOS program which would talk to the sign over a serial
port. So I whipped up a Perl script which used Expect to interact with dosemu
(a Linux DOS emulator) to run the program, which interacted with the sign, all
running on Linux. Works pretty good.

Expect.pm is also nice to interact with network hardware that offers
telnet/shell command interfaces. Interacting with sqlplus via Expect.pm would
be pretty easy as well, I would think. It basically works like this:

- Spawn the program you want to interact with
- Expect a particular regex of output from the spawned process
- Act based on that output (send commands, run processes, annoy the NT admin
with net send packets, etc)
- Wash, rinse, repeat.

-- Dan

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

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

RE: PERL?

Jared,

Thanks for correcting me that shutdown is a sqlplus command. I wanted to make
the point that piping strings to sqlplus can do more than Perl DBI can. (But
Perl DBI has advantages in many cases)

Yong Huang

[EMAIL PROTECTED] wrote:

All *SQL* commands will work work with the DBI.

'SHUTDOWN' is not a SQL command, it is a sqlplus command, and therefor will 
not work with the DBI.

This has been checked into, and Oracle does not make this functionality
available
via OCI, so shutting down  and starting a database on *nix requires sqlplus.

Here is one of the few instances where Win32 makes things easier than on *nix:
Oracle can be stopped and started via a service, which means you can easily
shut it down via the command line, and via the Win32 Perl module
Win32::Service.

If you want in depth discussion on this check the archives for the dbi-users
list.

I don't recall where the archives are, but the list is found at lists.perl.org.

Jared

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

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

Re: Documenting databases

I used to document database objects (including columns) with the COMMENT
commands. I stopped doing that because I think it unnecessarily increases the
size of data dictionary. It's just a little, though.

Yong Huang

Daniel Hanks wrote:

How about in each database itself.

COMMENT ON TABLE|COLUMN tab|tab.col IS '...'

comes to mind. It's simplistic, yes, but at least you don't have to remember
where you put your documentation...

HTH,

-- Dan

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

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

RE: Oracle Data Guard

Hi, Guang,

Look up SDU and TDU in Oracle documentation Network configuration. You set them
in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to
modify some procotol-specific parameters. In addition, in your client
application, you can choose a sensible array fetch size, such as arraysize in
sqlplus (in fact, sqlplus arraysize changes more than just network data chunk
size). You can't magically increase the network transfer rate by lowering
network latency. But you can indirectly increase the rate by other means, such
as buffering slightly more data in one chunk.

Yong Huang

Guang Mei wrote:

I have never worked on Network stuff. But is there any easy parameters we
could set in sqlnet.ora so that we could increase the DB performance by
increase the network transfer rate (without doing anything else)? BTW my
sqlnet.ora (on a Sun Box) has only two lines:
...
NAMES.DEFAULT_DOMAIN = incyte.com
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)



Guang

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

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

char is going away?

2003-12-10 Thread Gene Gurevich

Hi all:

Someone told me that Oracle is planning to retire char
variable and therefore they need to be replaced by
varchar2. Has anyone heard anything about it?

thanks

Gene

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

RE: char is going away?

Gene
   Was another part of the rumor that Oracle was going to retire SQL
standard compatibility?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, December 10, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


Hi all:

Someone told me that Oracle is planning to retire char
variable and therefore they need to be replaced by
varchar2. Has anyone heard anything about it?

thanks

Gene

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: char is going away?

2003-12-10 Thread Mercadante, Thomas F

Gene,

I remember Oracle saying that char was going away - about 6 years ago.
That's when they created varchar and varchar2.

Is this a new rumor?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 10, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi all:

Someone told me that Oracle is planning to retire char
variable and therefore they need to be replaced by
varchar2. Has anyone heard anything about it?

thanks

Gene

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: char is going away?

Another myth ... maybe. I also heard that in 9i DBA will be no longer needed.

Raj

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


-Original Message-
Sent: Wednesday, December 10, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi all:

Someone told me that Oracle is planning to retire char
variable and therefore they need to be replaced by
varchar2. Has anyone heard anything about it?

thanks

Gene


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: char is going away?

Not as long as DB2 has it. Oracle needs to be compatible, in order
for the people to convert. In addition to that, CHAR has some properties 
which VARCHAR2 does not. CHAR is fixed size, blank padded and oracle probably
wouldn't want to break ancient mainframe COBOL programs, because people would
stick to DB2 because of that. I believe that is a malicious rumor spread by
the panicking liberals.

On 12/10/2003 11:09:27 AM, Gene Gurevich wrote:
 Hi all:
 
 Someone told me that Oracle is planning to retire char
 variable and therefore they need to be replaced by
 varchar2. Has anyone heard anything about it?
 
 thanks
 
 Gene
 
 __
 Do you Yahoo!?
 Free Pop-Up Blocker - Get it now
 http://companion.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Gene Gurevich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

Mladen Gogala
Oracle DBA



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

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

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

Re: char is going away?

2003-12-10 Thread Jonathan Gennick

Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote:
GG Someone told me that Oracle is planning to retire char
GG variable and therefore they need to be replaced by
GG varchar2. Has anyone heard anything about it?

I've not heard anything like this. I'm skeptical that it's
true. The ANSI standard defines a fixed-length type
analogous to CHAR, so phasing out CHAR would seem to take
Oracle in a direction *away* from the standard, and that
seems out-of-character. Lately, Oracle seems to have
emphasized compliance with the SQL standard.

Would it even make sense to dispense with CHAR? I admit,
I've never found it too useful, but I'm sure there are
applications that use it. Any phase-out would surely need to
take place over a very long period of time.

What good reasons might an application have to use and
depend on CHAR variables?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

RE: char is going away?



-Original Message-
Sent: Wednesday, December 10, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L


Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED])
wrote:
GG Someone told me that Oracle is planning to retire char
GG variable and therefore they need to be replaced by
GG varchar2. Has anyone heard anything about it?

I've not heard anything like this. I'm skeptical that it's
true. The ANSI standard defines a fixed-length type
analogous to CHAR, so phasing out CHAR would seem to take
Oracle in a direction *away* from the standard, and that
seems out-of-character. Lately, Oracle seems to have
emphasized compliance with the SQL standard.

Would it even make sense to dispense with CHAR? I admit,
I've never found it too useful, but I'm sure there are
applications that use it. Any phase-out would surely need to
take place over a very long period of time.

What good reasons might an application have to use and
depend on CHAR variables?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

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

24 x 7 x 365

2003-12-10 Thread Tracy Rahmlow


Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks
American Express made the following
 annotations on 12/10/2003 09:41:15 AM
--
**

 "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited.  If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments.  Thank you."

**


==

RE: char is going away?

Jonathan
   My understanding is that VARCHAR2 is not even a SQL standard, and some
databases don't handle VARCHAR very efficiently, so if you are trying to
sell a product that can adapt to several databases besides Oracle, you might
stick to CHAR.
   If your application is COBOL-based, using CHAR simplifies things quite a
bit. Especially if you sell your application to many sites that want to use
Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah
it wastes a bit of disk space.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, December 10, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L


Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED])
wrote:
GG Someone told me that Oracle is planning to retire char
GG variable and therefore they need to be replaced by
GG varchar2. Has anyone heard anything about it?

I've not heard anything like this. I'm skeptical that it's
true. The ANSI standard defines a fixed-length type
analogous to CHAR, so phasing out CHAR would seem to take
Oracle in a direction *away* from the standard, and that
seems out-of-character. Lately, Oracle seems to have
emphasized compliance with the SQL standard.

Would it even make sense to dispense with CHAR? I admit,
I've never found it too useful, but I'm sure there are
applications that use it. Any phase-out would surely need to
take place over a very long period of time.

What good reasons might an application have to use and
depend on CHAR variables?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

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

RE: Documenting databases

2003-12-10 Thread Michael Milligan

Alan,

That sounds like a good candidate for a simple database application written
in PL/SQL. Create a schema and model your app. It shouldn't require too many
tables. Since you have Oracle and non-oracle information to store, most of
the Oracle information could be extracted from the data dictionary
automatically to update your app. You would only have to manually update the
non-Oracle information.

Mike

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  INET: [EMAIL PROTECTED]

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

RE: accounting software

Grace
   Take a look at Lawson Software -- http://www.lawson.com

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-Original Message-
Sent: Tuesday, December 09, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L



can anyone recommend accounting software for mid-range distribution company 
that uses oracle as database? 

Best Regards,
Grace Lim
Suy Sing Comm'l Corp 

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

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

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

RE: 24 x 7 x 365









Well, first
thing that needs to be noted is that 24 x 7 x 365 indicates
uptime for 7 years, which always gives me a chuckle when people say it. Mind you, Ive been guilty of
saying it too! J



And probably
the second thing that needs to be said is that no single product addresses true
HA requirements. RAC is no
different to that. It provides
machine failover capability, and while it can be stretched to a certain extent
to give the illusion of site failover capability, you would still need someone
like DataGuard to address issues such as human error correction. 



And probably
the third thing that needs to be said is that its not just a technology
thing. If you dont have
robust change control, for example, a simple coding error can ensure you dont
meet your availability requirements.



Shameless
plug And probably the fourth thing that needs to be said is that its
all covered in one of my papers at RMOUG Training Days next February, Real
Business Continuity with Oracle10g /Shameless plug. J





Pete



Controlling developers is like herding
cats.

Kevin Loney, Oracle DBA Handbook

Oh no, it's not. It's much harder than that!

Bruce Pihlamae, long-term Oracle DBA



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tracy
Rahmlow
Sent: Thursday, December 11, 2003
3:44 AM
To: Multiple recipients of list
ORACLE-L
Subject: 24 x 7 x 365




Hello, 
Our
company would like to know whether or not Oracle supports true 24x7x365
availability for an oltp database. We currently are using the 8.1.7
enterprise edition. Does an architecture exist whereby we can upgrade the
database and/or operating system and not cause an outage? Will RAC solve
this issue? Are there any other areas of concerns that I should be
thinking about? For example, analyzing with the validate clause and its
impacts on the transaction system. Thanks 

American Express made the following
annotations on 12/10/2003 09:41:15 AM
--
**

This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not the
intended recipient, any disclosure, copying, use, or distribution of the
information included in this message and any attachments is prohibited. If you
have received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank
you.

**


==

RE: char is going away?

You mean you still need a DBA in 9i?!!?   :)

Pete

Controlling developers is like herding cats.

Kevin Loney, Oracle DBA Handbook

Oh no, it's not.  It's much harder than that!

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 3:35 AM
To: Multiple recipients of list ORACLE-L

Another myth ... maybe. I also heard that in 9i DBA will be no longer
needed.

Raj


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


-Original Message-
Sent: Wednesday, December 10, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


Hi all:

Someone told me that Oracle is planning to retire char
variable and therefore they need to be replaced by
varchar2. Has anyone heard anything about it?

thanks

Gene



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

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

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

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

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

RE: Could not run export utility from cron job

2003-12-10 Thread Simpson, Ken

-Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Nguyen, David M
 Sent: Wednesday, December 10, 2003 12:24 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Could not run export utility from cron job

 I am able to run export utility from CLI manually but when I schedule
it to run from cron job on SUN Solaris8 it fails to  run as it does not
recognize exp command.  Does someone have any idea?  Below is the
command I run export manually.
 $exp user/password tables.dmp
 Thanks,
 David  

I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the Oracle environment set and therefor exp is not in your PATH.

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

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

Re: leaf node 90-10 splits


On 9i:

select * from v$statname
where name like '%leaf%';








Yong Huang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/10/2003 07:39 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: leaf node 90-10 splits


Hi, Tanel,

Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2
documentation. If the index is on strictly monotonically increasing numbers,
won't a new node be added to the right without a block split?

Yong Huang

 I wonder why does statistic leaf node 90-10 splits imply that right-hand
 index leaf block is split as 90-10, not 100-0 as it really is. (tested on
 9.2.0.4 W2k).

 Historical reasons?

 Tanel.

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
 INET: [EMAIL PROTECTED]

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

Re: Documenting databases


Indeed, my todo list includes an item for automating RDA on several servers.

The problem is, that RDA is rather difficult to automate, at least on Windoze.

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/09/2003 05:24 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Documenting databases


Don't know if this has been mentioned or if it does enough of what you're 
looking for but you can pick up something called RDA (remote diagnostic 
agent) from Oracle that'll give you an overview of OS setup, Network, 
performance (very high level), and RDBMS info. And the result is web-a-fied 
which might please your manager. I forget whether I found this in metalink or 
technet...

Kip


|The internal stuff can be documented with OraSnap.

|Just google for it. It's free, detailed, and easy to setup and automate.

|Jared






|[EMAIL PROTECTED]
|Sent by: [EMAIL PROTECTED]
| 12/09/2003 03:34 PM
| Please respond to ORACLE-L

 
|To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|cc:
|Subject:Re: Documenting databases






|Dan,

|  That's a good idea for documenting structures inside the database.
|However, my database manager wants more high level info: database name /
|host, oracle version, listeners, applications that use it, cron job
|descriptions and times, main schemas and what they are used for, lists of
|developers names that access the databse, etc...

|Alan



 
|   Daniel Hanks
|   [EMAIL PROTECTED]To:Multiple
|recipients of list ORACLE-L [EMAIL PROTECTED]
|   c.com  cc:
|   Sent by: Subject: Re: Documenting
|databases
|   [EMAIL PROTECTED]
|   .com
 
 
|   12/09/2003 04:09
|   PM
|   Please respond to
|   ORACLE-L
 
 




|On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote:

|   Recently our database manager has asked us to do the unthinkable
| document our databases! To make matters worse, and without our input,
|he
| went ahead and created a schema and put it in an Access database (using
| tables to make it look like a speadsheet). Either we use his idea or
|come
| up with something else.
|   So, I thought I'd ask everyone on the list how you do it. Text
|files?
| In a database (oracle, or other)?  Spreadsheets? What are the pros and
| cons? Etc
|

|How about in each database itself.

|COMMENT ON TABLE|COLUMN tab|tab.col IS '...'

|comes to mind. It's simplistic, yes, but at least you don't have to
|remember where you put your documentation...

|HTH,

|-- Dan
|
|  Daniel Hanks - Systems/Database Administrator
|  About Inc., Web Services Division
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.net
|--
|Author: Daniel Hanks
| INET: [EMAIL PROTECTED]

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



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

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


Content-type: text/html; charset=us-ascii


brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font
br
brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font
br
brfont size=2 face=sans-serifJared/font
brfont size=2 face=sans-serifbr
/font
br
br
br
table width=100%
tr valign=top
td
tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font
brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font
pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font
brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font
br
tdfont size=1 face=Arialnbsp; nbsp; nbsp; nbsp; /font
brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L lt;[EMAIL

Re: NT - Win2K causes performance degradation..

2003-12-10 Thread Paul Drake

Mark,

My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver(and domain controller, web server, print server, etc) until you tell it otherwise.

This is much improved in w2k3 server - where you tell it what you want it to be.

A good sysadmin would have set the OS to "optimize throughput for network applications" which would have turned off the filesystem caching. Ok, its only one radio button to select, so an MSCE could set it also.

Surprisingly enough, in W2K Server - changing this setting does not require a reboot, although I don't know if the changes take effect until after a system restart. That's not the sort of thing that I usually test, as NT4 had me trained to reboot afterwards.

the other thing may be, that the boot.ini no longer supports the /3GB or /PAEswitches as Jared mentioned - but that should not cause the symptoms you are reporting.

hth.

PaulMark Leith [EMAIL PROTECTED] wrote:
Hi All,We've been asked a question from one of our clients that I'm a littlestumped on.They run an OLTP database (Oracle 8.1.7), and have recently upgraded theirNT machine to Windows 2000, they were running with 2gb of memory, andupgraded that to 4gb in the process. As they increased physical memory, theyalso increased their SGA size db_block_buffers.Since they've upgraded they have noticed a significant decrease inperformance (the way it was described to me was "it was 7 out of 10, and isnow 3 out of 10"..).Has anybody else done a system upgrade of this nature that has caused lessthan desirable effects? Any pointers as to what to look at? We've requestedsome stats (top wait stats etc.) and I'll feed these back as and when I getthem - but I thought I'd throw this out to you guys in the vague hope thatsomeone
has experienced some relatively similar experiences.Cheers!Mark===Mark Leith | T: +44 (0)1905 330 281Sales Marketing | F: +44 (0)870 127 5283Cool Tools UK Ltd | E: [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising throughput performance---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mark LeithINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Ma!
il
messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: char is going away?


On 12/10/2003 12:44:26 PM, Jesse, Rich wrote:
 Did I mention that this application also RELIES on the OCI bug that allows a
 date column to contain a zero (as opposed to the zero-date) that can't be
 done thru normal SQL?

That is, probably, because your application supports conversion to stardate.
Beam me up, Rich.

Mladen Gogala
Oracle DBA



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

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

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

Pipelined functions

Title: Pipelined functions






I have a question related to pipelined functions ...


I have a function which performs a task in a loop. I have piped messages at the beginning and end of the loop and expect them to appear as soon as they are piped. But there seems to be a difference of opinion between oracle's and my definition of as soon as. I see these messages appear after 2/3 loops instead of each loop. 

Does anyone know why this should happen? Any way to trace the piped messages? 10046 doesn't cut it for me. BTW this is 9202. I did search for Metalink for bugs but didn't find any obvious ones. Anyone know the internals (or heard any rumors) of pipelining ... like is there a buffer size, when reached messages are output? something like that?

Raj



Rajendra dot Jamadagni at nospamespn dot com

All Views expressed in this email are strictly personal.

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


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

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

2003-12-10 Thread Denny Koovakattu


  They will think differently after Mogens comes out with the Do you really
need 10g presentation ;)

-- 
Denny Koovakattu 


Quoting Nuno Souto [EMAIL PROTECTED]:

 The interesting fact of course is that the beta program
 of 10g was announced in newsgroups AFTER it had closed
 for all intents and purposes to the general public...
 
 And quite frankly, Oracle could do a LOT WORSE than let
 customers like Mogens definitely join.  Just a feeling,
 mind you.  If Oracle thinks the good old days of in-house
 elites are back, they're dead wrong.
 
 Cheers
 Nuno Souto
 [EMAIL PROTECTED]
 - Original Message - 
 
  Generally, the announcements are made at events like OracleWorld,
  through OTN and so forth that the beta program is open.  Depending on
  the release, the program may not even get announced unless it's big
  enough.  IIRC, the beta program for 9.2 was open to only a small number
  of customers and wasn't announced to the world at large, whereas the 10g
  program was announced (again IIRC - it's 4 am for me and I haven't had
  my first coffee yet!) at OracleWorld in San Fran in September?  Of
  course, there are some companies that are almost always invited to join
  the beta program for the database because of the type of customer they
  are and the type of work they do - customers like Amazon, for example,
  may fall into that category.  Customers like Mogens definitely don't.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Nuno Souto
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 



This message was sent using IMP, the Internet Messaging Program.

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

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

long raw risk

2003-12-10 Thread Piet de Visser

Group, 

I have just been given a project / database
where a vendor will implement a table 
with a LONG RAW field in it.

Oracle manuals state clearly that this datatype 
is outdated and should be replaced by BLOB,
I quoted the manuals to vendor-support, but they
will not move on this. 

From the looks of it, the table with the LR field
will become the largest table in the system, with
well over a billion records in it after the 1st yr.

My main worry is inefficiency in retrieving 
records from the table, and most importantly, 
I cannot partition a table with long/longraw 
columns in it.

On first tests, the LRs are 1K, whereas
the record-without-LR is avg 66 bytes.
In real-life, the LR is probably bigger still.

Quesions:
 - Is there a real performance-risk ?
   Up to now, I always managed to offload LONG/BLOBs
   into separate tables or into LOB-storage clauses,  
   but I see now way to do that here.
 - Given the LongRaw datatype, what are my best 
   defences against (potential) performance problems.

Anyone been-there-done-that ?

Regards, 

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

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

RE: char is going away?

Dennis,

According to my copy of 'A Guide To SQL Standard (Author: C. J. Date), 4th ed, pp292, 
section 19.4

CHARACTER(n) - fixed length string of exactly n characters (n  0)
VARYING(n)   - varying length string of up to n characters (n  0)

So, I guess it is.
Raj

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


-Original Message-
Sent: Wednesday, December 10, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L


Jonathan
   My understanding is that VARCHAR2 is not even a SQL standard, and some
databases don't handle VARCHAR very efficiently, so if you are trying to
sell a product that can adapt to several databases besides Oracle, you might
stick to CHAR.
   If your application is COBOL-based, using CHAR simplifies things quite a
bit. Especially if you sell your application to many sites that want to use
Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah
it wastes a bit of disk space.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

RE: char is going away?

2003-12-10 Thread Jesse, Rich

How's about applications written in ancient awful 4GLs like PowerHouse that
do not handle variable length fields (aka columns) in their own files, and
therefore do not directly support them in relational DBs either?

Did I mention that this application also RELIES on the OCI bug that allows a
date column to contain a zero (as opposed to the zero-date) that can't be
done thru normal SQL?

SELECT TO_CHAR(lastused,'') FROM mytables;

TO_CHAR(
-
2003


2003
2002


H...I forgot about that in testing our 9i upgrade...

Rich


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


-Original Message-
Sent: Wednesday, December 10, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L


Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED])
wrote:
GG Someone told me that Oracle is planning to retire char
GG variable and therefore they need to be replaced by
GG varchar2. Has anyone heard anything about it?

I've not heard anything like this. I'm skeptical that it's
true. The ANSI standard defines a fixed-length type
analogous to CHAR, so phasing out CHAR would seem to take
Oracle in a direction *away* from the standard, and that
seems out-of-character. Lately, Oracle seems to have
emphasized compliance with the SQL standard.

Would it even make sense to dispense with CHAR? I admit,
I've never found it too useful, but I'm sure there are
applications that use it. Any phase-out would surely need to
take place over a very long period of time.

What good reasons might an application have to use and
depend on CHAR variables?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Parentheses and joins

2003-12-10 Thread Jonathan Gennick

I looking for a good, simple example of when parentheses
matter when writing a join query using the new, SQL92 join
syntax. For example, I could write:

SELECT *
FROM county y JOIN city c
 ON y.county_id = c.county_id
 JOIN attraction a
 ON c.city_id = a.city_id;

and I could use parens to clarify the join order:

SELECT *
FROM (county y JOIN city c
 ON y.county_id = c.county_id)
 JOIN attraction a
 ON c.city_id = a.city_id;

I could even force a different join order:

SELECT *
FROM county y JOIN (city c
 JOIN attraction a
 ON c.city_id = a.city_id)
 ON y.county_id = c.county_id;

I'm struggling to come up with a good example of when you
might *need* to use parens. I'm not having a really good day
today. In fact, I'm having a really, really bad day, so
maybe I'm not thinking too clearly, but so far I'm unable to
come up with a good example to demonstrate the necessity of
parentheses. Can anyone help me out with this?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

Re[2]: char is going away?

2003-12-10 Thread Jonathan Gennick

DW If your application is COBOL-based, using CHAR
DW simplifies things quite a bit.

True enough. I'd forgotten about COBOL. The semantics of
COBOL's PIC X fields match up pretty closely (exactly?) to
SQL CHAR fields.

DWMy understanding is that VARCHAR2 is not even a SQL standard

The keyword VARCHAR2 is not in the standard, but a
variable-length type is. I think the standard uses CHARACTER
VARYING, or something like that. I don't have time to look
it up right now.

DB2 uses VARCHAR, without the 2. I'm not sure why Oracle
is so outspoken against that same keyword. I'd be interested
in finding out.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

RE: Could not run export utility from cron job

2003-12-10 Thread Ron Cetnar

Ken:

When running from cron the user's .profile does not get executed.  So your
ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment.
So on the line that you want to execute the export.  Before the exp command
add . ~/.profile  (without the double quotes) exp user/password
tables.dmp.  This will execute the .profile first, set your environments and
then do the export.


Ron
*** 
Ron Cetnar 
Supervising Programmer/Analyst/Oracle DBA 
ITS - University Applications Development 

State University of New York at Albany 
MSC 100 
1400 Washington Ave 
Albany, NY 1 

Email: [EMAIL PROTECTED] 
Work: (518) 437-4535 
Fax:   (518) 437-4540 

*** 


-Original Message-
Sent: Wednesday, December 10, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L

-Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Nguyen, David M
 Sent: Wednesday, December 10, 2003 12:24 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Could not run export utility from cron job


 I am able to run export utility from CLI manually but when I schedule
it to run from cron job on SUN Solaris8 it fails to  run as it does not
recognize exp command.  Does someone have any idea?  Below is the
command I run export manually.
 $exp user/password tables.dmp
 Thanks,
 David  

I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the Oracle environment set and therefor exp is not in your PATH.

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

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

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

RE: Re[2]: char is going away?

Oracle has varchar and varchar2 both ... 

tfm
The VARCHAR2 subtypes below have the same range of values as their base type. For 
example, VARCHAR is just another name for VARCHAR2.

STRING
VARCHAR

You can use these subtypes for compatibility with ANSI/ISO and IBM types.

Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of 
PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate 
datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 
rather than VARCHAR.
/tfm

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm#10824

HTH
Raj

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


-Original Message-
Sent: Wednesday, December 10, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L


DW If your application is COBOL-based, using CHAR
DW simplifies things quite a bit.

True enough. I'd forgotten about COBOL. The semantics of
COBOL's PIC X fields match up pretty closely (exactly?) to
SQL CHAR fields.

DWMy understanding is that VARCHAR2 is not even a SQL standard

The keyword VARCHAR2 is not in the standard, but a
variable-length type is. I think the standard uses CHARACTER
VARYING, or something like that. I don't have time to look
it up right now.

DB2 uses VARCHAR, without the 2. I'm not sure why Oracle
is so outspoken against that same keyword. I'd be interested
in finding out.

Best regards,

Jonathan Gennick --- Brighten the corner where you are


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: Could not run export utility from cron job

2003-12-10 Thread Bricklen Anderson

Simpson, Ken wrote:
I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the Oracle environment set and therefor exp is not in your PATH.
Ken
How about adding the line:
source path_to_your_profile/.(bash_)profile
to the shell script that runs exp?
Unfortunately, I'm not in a position to test this where I am right this 
minute.

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

Re: Could not run export utility from cron job

How about setting it up to execute in 10 minutes? Testing things this minute
isn't exactly the point with cron.
On 12/10/2003 02:09:24 PM, Bricklen Anderson wrote:
 Simpson, Ken wrote:
  
  I'm pretty sure that jobs running out of cron do not source in .profile
  so you probably don't
  have the Oracle environment set and therefor exp is not in your PATH.
  
  Ken
 
 How about adding the line:
 source path_to_your_profile/.(bash_)profile
 to the shell script that runs exp?
 
 Unfortunately, I'm not in a position to test this where I am right this 
 minute.
 
 -- 
 PresiNET Systems
 http://www.PresiNET.com
 Online Demo: https://www.presinet.com/secure/login
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Bricklen Anderson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

Mladen Gogala
Oracle DBA



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

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

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

RE: 24 x 7 x 365

2003-12-10 Thread Whittle Jerome Contr NCI

Title: RE: 24 x 7 x 365






As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-)


Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]

Sent: Wednesday, December 10, 2003 10:44 AM

To: Multiple recipients of list ORACLE-L

Subject: 24 x 7 x 365



Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database.  We currently are using the 8.1.7 enterprise edition.  Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage?  Will RAC solve this issue?  Are there any other areas of concerns that I should be thinking about?  For example, analyzing with the validate clause and its impacts on the transaction system.  Thanks

Could not run export utility from cron job

2003-12-10 Thread Nguyen, David M

Title: Could not run export utility from cron job






I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually.

$exp user/password tables.dmp

Thanks,
David

Re:Re: two oracle pl/sql programmers needed (50k/yr)

2003-12-10 Thread system manager

In Austin,   Texas
--
Original Message
Date: Tue, 09 Dec 2003 06:14:30 -0800

System Manager:

Where are these positions located geographically?

Me


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 7:44 AM


 
 please send an email to me,if you're interested.
 
 _
 Free email with personality! Over 200 domains!
 http://www.MyOwnEmail.com
 Looking for friendships,romance and more?
 http://www.MyOwnFriends.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: system manager
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

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

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


_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

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

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

Configuring Veritas Netbackup Question

2003-12-10 Thread Dwayne Cox

I apologize for this *basic* question but I have searched the manuals, 
Robert Freeman's RMAN book and MetaLink as well as Googled and cannot 
find the answer.  I know its something simple.

We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2.  It has been 
backing up our netowrk for a couple years without a problem.  We 
recently purchased the license for the Oracle module and installed 
(activated) it (actually, the SA did this while I watched).

The database server is a separate Linux (same version) box and the 
client seems to have been installed.

Anyway, I go through the steps to configure Netbackup (setting up a 
policy, media, etc).  All looks good.  I create a test script for rman 
(based on one I know works).  When I attempt to run a test backup and I 
get the message 'Unable to get data from client polar from server 
phoenix.  status 104'.

What am I missing?  How do I access the client from the host?  I noticed 
the host server does not have Oracle installed (tnsnames, etc.) so my 
first thought was to do that but wanted to make sure I was right before 
I went to the SA to do this.

Thanks for your help!

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

Re: char is going away?


On 12/10/2003 11:34:36 AM, Jamadagni, Rajendra wrote:
 Another myth ... maybe. I also heard that in 9i DBA will be no longer needed.
 
 Raj

And it became reality. DBA jobs were outsourced. The only necessary people
belong to the damagement. Oracle 10g will create the need for fewer IS professionals
and more magazine reading damagers.

Mladen Gogala
Oracle DBA



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

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

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

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

I think he's skipping that one to go direct to Do you really need
Oracle?   :)

Pete

Controlling developers is like herding cats.

Kevin Loney, Oracle DBA Handbook

Oh no, it's not.  It's much harder than that!

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Denny Koovakattu
Sent: Thursday, December 11, 2003 4:04 AM
To: Multiple recipients of list ORACLE-L


  They will think differently after Mogens comes out with the Do you
really
need 10g presentation ;)

-- 
Denny Koovakattu 


Quoting Nuno Souto [EMAIL PROTECTED]:

 The interesting fact of course is that the beta program
 of 10g was announced in newsgroups AFTER it had closed
 for all intents and purposes to the general public...
 
 And quite frankly, Oracle could do a LOT WORSE than let
 customers like Mogens definitely join.  Just a feeling,
 mind you.  If Oracle thinks the good old days of in-house
 elites are back, they're dead wrong.
 
 Cheers
 Nuno Souto
 [EMAIL PROTECTED]
 - Original Message - 
 
  Generally, the announcements are made at events like OracleWorld,
  through OTN and so forth that the beta program is open.  Depending
on
  the release, the program may not even get announced unless it's big
  enough.  IIRC, the beta program for 9.2 was open to only a small
number
  of customers and wasn't announced to the world at large, whereas the
10g
  program was announced (again IIRC - it's 4 am for me and I haven't
had
  my first coffee yet!) at OracleWorld in San Fran in September?  Of
  course, there are some companies that are almost always invited to
join
  the beta program for the database because of the type of customer
they
  are and the type of work they do - customers like Amazon, for
example,
  may fall into that category.  Customers like Mogens definitely
don't.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Nuno Souto
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 



This message was sent using IMP, the Internet Messaging Program.

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

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

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

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

Re: 24 x 7 x 365

You mean 2004/02/31, the 31st of February?
On 12/10/2003 02:19:34 PM, Whittle Jerome Contr NCI wrote:
 As 2004 is a Leap Year, in February you have a one day window of opportunity to do 
 upgrades.  ;-)
 
 Jerry Whittle
 ASIFICS DBA
 NCI Information Systems Inc.
 [EMAIL PROTECTED]
 618-622-4145
 
  -Original Message-
  From:   Tracy Rahmlow [SMTP:[EMAIL PROTECTED]
  Sent:   Wednesday, December 10, 2003 10:44 AM
  To: Multiple recipients of list ORACLE-L
  Subject:24 x 7 x 365
  
  
  Hello, 
  Our company would like to know whether or not Oracle supports true 24x7x365 
  availability for an oltp database.  We currently are using the 8.1.7 enterprise 
  edition.  Does an architecture exist whereby we can upgrade the database and/or 
  operating system and not cause an outage?  Will RAC solve this issue?  Are there 
  any other areas of concerns that I should be thinking about?  For example, 
  analyzing with the validate clause and its impacts on the transaction system.  
  Thanks 
  
 

Mladen Gogala
Oracle DBA



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

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

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

RE: Could not run export utility from cron job

2003-12-10 Thread Guang Mei

Title: Could not run export utility from cron job



You 
need to load user's .profile in your cronjob (to set ENVs), becuase the unix 
user who executes cronjob does not have it's profile loaded.

HTH.

Guang

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David 
  MSent: Wednesday, December 10, 2003 12:24 PMTo: Multiple 
  recipients of list ORACLE-LSubject: Could not run export utility 
  from cron job
  I am able to run export 
  utility from CLI manually but when I schedule it to run from cron 
  job on SUN Solaris8 it fails to run as it does not recognize 
  exp command. Does someone have any idea? Below is the command I run export 
  manually.
  $exp user/password 
  tables.dmp
  Thanks,David

RE: Could not run export utility from cron job

2003-12-10 Thread Gary W. Parker

Title: Could not run export utility from cron job



Make 
sure that you source your environment variables in the script. At the 
least, set the $PATH variable to include the Oracle bin 
directory.

Jobs 
executing from CRON do not automatically source the .profile when they kick 
off.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David 
  MSent: Wednesday, December 10, 2003 11:24 AMTo: Multiple 
  recipients of list ORACLE-LSubject: Could not run export utility 
  from cron job
  I am able to run export 
  utility from CLI manually but when I schedule it to run from cron 
  job on SUN Solaris8 it fails to run as it does not recognize 
  exp command. Does someone have any idea? Below is the command I run export 
  manually.
  $exp user/password 
  tables.dmp
  Thanks,David

Re: char is going away?

2003-12-10 Thread KENNETH JANUSZ

Probably by Howard Dean and Bertie Gore.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 10:34 AM


 Not as long as DB2 has it. Oracle needs to be compatible, in order
 for the people to convert. In addition to that, CHAR has some properties
 which VARCHAR2 does not. CHAR is fixed size, blank padded and oracle
probably
 wouldn't want to break ancient mainframe COBOL programs, because people
would
 stick to DB2 because of that. I believe that is a malicious rumor spread
by
 the panicking liberals.

 On 12/10/2003 11:09:27 AM, Gene Gurevich wrote:
  Hi all:
 
  Someone told me that Oracle is planning to retire char
  variable and therefore they need to be replaced by
  varchar2. Has anyone heard anything about it?
 
  thanks
 
  Gene
 
  __
  Do you Yahoo!?
  Free Pop-Up Blocker - Get it now
  http://companion.yahoo.com/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Gene Gurevich
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 

 Mladen Gogala
 Oracle DBA



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

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

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



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

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

RE: long raw risk

2003-12-10 Thread John Flack

The reason that vendors often use LONG RAW is that that datatype meets the ANSI SQL 
standard, while BLOB doesn't.  That way, they can use the same DDL against most SQL 
databases.  Sometimes you can modify the vendor's DDL before or during installation.  
Sometimes you can re-create a table right after installation, as long as the columns 
have the same name and a compatible datatype (and BLOB is somewhat compatible with 
LONG RAW) - but I'd test this thoroughly before I'd go production.

There is a performance risk, but it can be minimized, especially if your vendor lets 
you change what tablespace will be used for the table and its indexes.  I'd put it in 
a tablespace away from the rest of the tables.

-Original Message-
Sent: Wednesday, December 10, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


Group, 

I have just been given a project / database
where a vendor will implement a table 
with a LONG RAW field in it.

Oracle manuals state clearly that this datatype 
is outdated and should be replaced by BLOB,
I quoted the manuals to vendor-support, but they
will not move on this. 

From the looks of it, the table with the LR field
will become the largest table in the system, with
well over a billion records in it after the 1st yr.

My main worry is inefficiency in retrieving 
records from the table, and most importantly, 
I cannot partition a table with long/longraw 
columns in it.

On first tests, the LRs are 1K, whereas
the record-without-LR is avg 66 bytes.
In real-life, the LR is probably bigger still.

Quesions:
 - Is there a real performance-risk ?
   Up to now, I always managed to offload LONG/BLOBs
   into separate tables or into LOB-storage clauses,  
   but I see now way to do that here.
 - Given the LongRaw datatype, what are my best 
   defences against (potential) performance problems.

Anyone been-there-done-that ?

Regards, 

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

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

rogue SYS connections

2003-12-10 Thread Vordos, Suzy


Solaris 2.8 Oracle 8.1.7.0.  We have session auditing enabled, and see rogue 
connections as SYS from several remote databases.  The os_user of the remote system is 
always oracle and there are several different remote hosts involved.

I can't figure out how they are gaining access this way.  Our SYS password is set to a 
random string, not the default, and we change it frequently.   There are no 
corresponding telnet sessions indicating access is local from our server, and we also 
change our oracle password frequently.   

I know the listener has vulnerabilities and we should apply those patches, but want to 
be sure we don't have an obvious configuration problem that is allowing these 
connections.   Any ideas?

-- init.ora
remote_login_passwordfile=NONE
remote_os_authent=FALSE

-- sqlnet.ora 
sqlnet.authentication_services=(NONE)

Here is a snippet from the audit trail:

-- sys.aud$
select timestamp#, userid, userhost, terminal, action# returncode,
comment$text from sys.aud$
where userid = 'SYS';

DEC-09-03 15:13:10   SYS UNKNOWN   101
Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.19
2.236)(PORT=63519))

-- dba_audit_session
select username,os_username,action_name action,terminal,timestamp,returncode
from dba_audit_session
where username = 'SYS';

USERNAME OS_USERNAME  ACTION TERMINAL   TIMESTAMP  RETURNCODE
  -- -- -- --
SYS  oracle   LOGOFF UNKNOWNDEC-09-03 15:13:10  0

-- listener log
09-DEC-2003 15:13:10 * 
(CONNECT_DATA=(SID=mnet03bP)(CID=(PROGRAM=)(HOST=hpcad200)(USER=oracle))) * 
(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.192.236)(PORT=63519)) * establish * mnet03bP * 0

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

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

RE: Could not run export utility from cron job

have you _sourced_ your .profile? cron won't do it automatically for you.

Raj

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

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: 24 x 7 x 365

2003-12-10 Thread ryan_oracle

i was at an oracle group meeting and one of the RAC specialists at oracle was talking.
he said that that kind of thing 'can' be done, but is incredibly expensive. you need
redundancy and fail safes like crazy.

any time you do an upgrade, bad things may happen.

From: Tracy Rahmlow [EMAIL PROTECTED]
Date: 2003/12/10 Wed AM 11:44:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: 24 x 7 x 365

Hello,
Our company would like to know whether or not Oracle supports true
24x7x365 availability for an oltp database. We currently are using the
8.1.7 enterprise edition. Does an architecture exist whereby we can
upgrade the database and/or operating system and not cause an outage? Will
RAC solve this issue? Are there any other areas of concerns that I should
be thinking about? For example, analyzing with the validate clause and
its impacts on the transaction system. Thanks
American Express made the following
annotations on 12/10/2003 09:41:15 AM
--
**

This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information included
in this message and any attachments is prohibited. If you have received this
communication in error, please notify us by reply e-mail and immediately and
permanently delete this message and any attachments. Thank you.

Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks
American Express made the following
annotations on 12/10/2003 09:41:15 AM
--
**

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."

Re: Configuring Veritas Netbackup Question

2003-12-10 Thread Ron Rogers

Dwayne,
 Doesn't the Veritas backup exec Oracle client perform a HOT backup
of the database? If that is the case then the RMAN backup is performed
differently that the hot backup. Read the script that the Oracle client
uses to see what is happening.

I may be off base with this version of backup exec but it is as I
understood the client.
Ron

 [EMAIL PROTECTED] 12/10/2003 2:24:33 PM 
I apologize for this *basic* question but I have searched the manuals,

Robert Freeman's RMAN book and MetaLink as well as Googled and cannot 
find the answer.  I know its something simple.

We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2.  It has
been 
backing up our netowrk for a couple years without a problem.  We 
recently purchased the license for the Oracle module and installed 
(activated) it (actually, the SA did this while I watched).

The database server is a separate Linux (same version) box and the 
client seems to have been installed.

Anyway, I go through the steps to configure Netbackup (setting up a 
policy, media, etc).  All looks good.  I create a test script for rman

(based on one I know works).  When I attempt to run a test backup and I

get the message 'Unable to get data from client polar from server 
phoenix.  status 104'.

What am I missing?  How do I access the client from the host?  I
noticed 
the host server does not have Oracle installed (tnsnames, etc.) so my 
first thought was to do that but wanted to make sure I was right before

I went to the SA to do this.

Thanks for your help!

Sign,
Dwayne aka Frustrated One


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

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

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

Re: Parentheses and joins


Jonathan,

I didn't realize that parentheses would affect to optimizer to change the join order.

A little experimentation shows that it can indeed be done.

For anyone that wants to see it, the joins are below.

I learn something every day around here.

Jared

select
 e.ename
 , e.empno
 , d.dname
 , m.ename
from
 scott.emp e
 join scott.dept d on d.deptno=e.deptno
 join scott.emp m on m.empno=e.mgr
/


select
 e.ename
 , e.empno
 , d.dname
 , m.ename
from
 scott.dept d join
 (scott.emp e join scott.emp m on m.empno=e.mgr)
 on d.deptno = e.deptno
/


select
 e.ename
 , e.empno
 , d.dname
 , m.ename
from
 scott.emp m join
 (scott.emp e join scott.dept d on e.deptno=d.deptno)
 on m.mgr = e.empno
/








Jonathan Gennick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/10/2003 10:54 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Parentheses and joins


I looking for a good, simple example of when parentheses
matter when writing a join query using the new, SQL92 join
syntax. For example, I could write:

SELECT *
FROM county y JOIN city c
   ON y.county_id = c.county_id
   JOIN attraction a
   ON c.city_id = a.city_id;

and I could use parens to clarify the join order:

SELECT *
FROM (county y JOIN city c
   ON y.county_id = c.county_id)
   JOIN attraction a
   ON c.city_id = a.city_id;

I could even force a different join order:

SELECT *
FROM county y JOIN (city c
   JOIN attraction a
   ON c.city_id = a.city_id)
   ON y.county_id = c.county_id;

I'm struggling to come up with a good example of when you
might *need* to use parens. I'm not having a really good day
today. In fact, I'm having a really, really bad day, so
maybe I'm not thinking too clearly, but so far I'm unable to
come up with a good example to demonstrate the necessity of
parentheses. Can anyone help me out with this?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

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

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

Re: rogue SYS connections

2003-12-10 Thread Ron Rogers

Suzy,
 Do you use RMAN to perform backups? Do you use a catalog with RMAN?
Rman uses sys to perform the connections to the target database.

Just a thought,
Ron

 [EMAIL PROTECTED] 12/10/2003 3:09:33 PM 

Solaris 2.8 Oracle 8.1.7.0.  We have session auditing enabled, and see
rogue connections as SYS from several remote databases.  The os_user of
the remote system is always oracle and there are several different
remote hosts involved.

I can't figure out how they are gaining access this way.  Our SYS
password is set to a random string, not the default, and we change it
frequently.   There are no corresponding telnet sessions indicating
access is local from our server, and we also change our oracle password
frequently.   

I know the listener has vulnerabilities and we should apply those
patches, but want to be sure we don't have an obvious configuration
problem that is allowing these connections.   Any ideas?

-- init.ora
remote_login_passwordfile=NONE
remote_os_authent=FALSE

-- sqlnet.ora 
sqlnet.authentication_services=(NONE)

Here is a snippet from the audit trail:

-- sys.aud$
select timestamp#, userid, userhost, terminal, action# returncode,
comment$text from sys.aud$
where userid = 'SYS';

DEC-09-03 15:13:10   SYS UNKNOWN   
   101
Authenticated by: DATABASE; Client address:
(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.19
2.236)(PORT=63519))

-- dba_audit_session
select username,os_username,action_name
action,terminal,timestamp,returncode
from dba_audit_session
where username = 'SYS';

USERNAME OS_USERNAME  ACTION TERMINAL   TIMESTAMP 
RETURNCODE
  -- -- --
--
SYS  oracle   LOGOFF UNKNOWNDEC-09-03 15:13:10 
0

-- listener log
09-DEC-2003 15:13:10 *
(CONNECT_DATA=(SID=mnet03bP)(CID=(PROGRAM=)(HOST=hpcad200)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.192.236)(PORT=63519)) * establish *
mnet03bP * 0

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

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

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

Re: Configuring Veritas Netbackup Question


You can get some better diagnostic information by doing the following on the client box:


cd /usr/openv/netbackup/logs 
./mkdirs.sh

if the following directories were not created by the script, create them:

/usr/openv/netbackup/logs/user_ops/dbext/oracle
/usr/openv/netbackup/logs/user_ops/dbext/logs

The oracle directory will have some logs with detailed info.

If you just created the directories, you will of course need to 
make another backup attempt first.

HTH

Jared










Dwayne Cox [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/10/2003 11:24 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Configuring Veritas Netbackup Question


I apologize for this *basic* question but I have searched the manuals, 
Robert Freeman's RMAN book and MetaLink as well as Googled and cannot 
find the answer. I know its something simple.

We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been 
backing up our netowrk for a couple years without a problem. We 
recently purchased the license for the Oracle module and installed 
(activated) it (actually, the SA did this while I watched).

The database server is a separate Linux (same version) box and the 
client seems to have been installed.

Anyway, I go through the steps to configure Netbackup (setting up a 
policy, media, etc). All looks good. I create a test script for rman 
(based on one I know works). When I attempt to run a test backup and I 
get the message 'Unable to get data from client polar from server 
phoenix. status 104'.

What am I missing? How do I access the client from the host? I noticed 
the host server does not have Oracle installed (tnsnames, etc.) so my 
first thought was to do that but wanted to make sure I was right before 
I went to the SA to do this.

Thanks for your help!

Sign,
Dwayne aka Frustrated One


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

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

Re: 24 x 7 x 365

Tracy, both OPS (8i) and RAC (9i)support independent node shutdown.
Both support listener based load balancing so that incoming connections
will be evenly spread on all nodes. That still doesn't give you the true
24 x 7 x 365 availability. For that, you need two replicated copies of the 
database, both in OPS/RAC mode. The problem with a single OPS/RAC database 
is that it has to be shut down for the database upgrade. You cannot have
both 8i and 9i instances accessing the same database at the same time,
which means that in the case of the database upgrade, all databases in
the cluster must be brought down. The only way for production database
to remain available after all clustered instances have been brought down
is the existence of another copy of your production database, on separate
cluster. It is foreseeable that there will be some data discrepancies 
after the primary configuration is upgraded and brought back online, which
means that you must have symmetric replication set up in such a way that 
your instances can be quickly synchronized. 
Please, be aware that both configurations, the primary and secondary one
must be clustered, because if the secondary database is not clustered,
then the instance accessing it becomes the single point of failure, which
is what needs to be avoided at all costs.
Also, you may decide to limit the meaning of 24 x 7 x 365 availability and
decide that the spare configuration will be available in read-only mode 
while you are upgrading the primary configuration. That would be the case
for a physical standby and playing with EMC BCV-s. In that case, you do not
need to set up symmetric replication, because there are no data changes (database 
is in the read-only mode) but the guys doing upgrade are limited by the time 
that business may tolerate the database being in the read-only mode. Given
the organization you work for, I surmise that a) your database is larger then 10MB
and b) that you need it to be fully accessible to the fullest extent of the 
24 x 7 x 365 phrase. That probably means that having read-only database for the 
full two hours is not acceptable. You will need replication. Those two databases
should be physically separated in case of catastrophic failure (things that never
happen, like big power-grid blackouts, passenger jets crashing into skyscrapers or
forest wildfires scorching suburb or two of a major urban area). Of course, network
connections must be redundant as well. That would be the true 24 x 7 x 365 
availability,
but the price tag is really a major number, much more then most companies are willing
to spend. Given all the infrastructure and real estate, the price tag probably comes 
close to 8 zeros range, which is probably what those guys that were hand-picked to
test 10g make annually.

On 12/10/2003 11:44:25 AM, Tracy Rahmlow wrote:
 Hello,
 Our company would like to know whether or not Oracle supports true 
 24x7x365 availability for an oltp database.  We currently are using the 
 8.1.7 enterprise edition.  Does an architecture exist whereby we can 
 upgrade the database and/or operating system and not cause an outage? Will 
 RAC solve this issue?  Are there any other areas of concerns that I should 
 be thinking about?  For example, analyzing with the validate clause and 
 its impacts on the transaction system.  Thanks
 American Express made the following
  annotations on 12/10/2003 09:41:15 AM
 --
 **
 
  This message and any attachments are solely for the intended recipient and may 
 contain confidential or privileged information. If you are not the intended 
 recipient, any disclosure, copying, use, or distribution of the information included 
 in this message and any attachments is prohibited.  If you have received this 
 communication in error, please notify us by reply e-mail and immediately and 
 permanently delete this message and any attachments.  Thank you.
 
 **
 
 
 ==
 

Mladen Gogala
Oracle DBA



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

Re: Configuring Veritas Netbackup Question

2003-12-10 Thread Dwayne Cox

Brian,

Netbackup does indeed have to be linked to Oracle.  I performed this and 
it seemed to go well (no obvious error messages).

-DC-

Spears, Brian wrote:
Dwayne Cox,

 Don't know if this is the same problem, but I did run into this and the there had to be a re-linking
 and a softlink set for a library if I remember correctly. Just an idea 
to check. I know this stuff is a bugger till you get it working.
Brian
-Original Message-
Dwayne Cox
Sent: Wednesday, December 10, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L
I apologize for this *basic* question but I have searched the manuals, 
Robert Freeman's RMAN book and MetaLink as well as Googled and cannot 
find the answer.  I know its something simple.

We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2.  It has been 
backing up our netowrk for a couple years without a problem.  We 
recently purchased the license for the Oracle module and installed 
(activated) it (actually, the SA did this while I watched).

The database server is a separate Linux (same version) box and the 
client seems to have been installed.

Anyway, I go through the steps to configure Netbackup (setting up a 
policy, media, etc).  All looks good.  I create a test script for rman 
(based on one I know works).  When I attempt to run a test backup and I 
get the message 'Unable to get data from client polar from server 
phoenix.  status 104'.

What am I missing?  How do I access the client from the host?  I noticed 
the host server does not have Oracle installed (tnsnames, etc.) so my 
first thought was to do that but wanted to make sure I was right before 
I went to the SA to do this.

Thanks for your help!

Sign,
Dwayne aka Frustrated One

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

RE: Re[2]: char is going away?