date:20010706




Hi,
If you can cd to a single directory and list all of your files then it means
that all of your files are in a single filesystem probably (unless you've been
VERY clever) sharing the same disks.
I agree with the suggestion that you can create links to the datafiles from a
central directory but that needs maintenance for each file added.
If you have an OFA compliant structure then ls  /u*/oradata/db_name1/*.dbf
will give you the names of your datafiles.

Regards,

Mike Hately



|+
||  Lord, David -|
||  CS  |
||  David.Lord@ha|
||  yscsg.com|
|||
||  07/06/01 09:45|
||  AM|
||  Please respond|
||  to ORACLE-L   |
|||
|+
  |
  ||
  |   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: RE: OFA (Optimal Flexible Architecture) in practice |
  |




Well, you could always put a directory of symbolic links under your
$ORACLE_BASE.

Regards
David Lord

-Original Message-
Sent: 06 July 2001 01:25
To: Multiple recipients of list ORACLE-L


Does anyone use OFA as their company standard?  If so, are there any
complaints about it's structure?  For example, the commingling of different
database subdirectories under a given mount point?
e.g..
/u02/oradata/db_name1/userdata01.dbf
/u02/oradata/db_name2/userdata01.dbf
/u03/oradata/db_name1/userdata02.dbf
/u03/oradata/db_name2/userdata02.dbf
You cannot cd to a given subdirectory, ls -ltR | more to see all the
datafiles associated with a given database.  Instead, from / you have to ls
-ltR | grep db_name1 to scan the full file system.  Seems like there should
be a better way.
Any input, pro or con, is appreciated.
Thanks, Linda






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

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

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

xdk

2001-07-06 Thread Guy Hammond


Hi,

Does anyone know where I can get the Oracle 8i version of the Java XDK
version 2.0? Oracle, in their infinite wisdom, have decided to only make
the 9i version available on TechNet now. Looking for 8.1.7 versions,
they say, click there, but the page it links to doesn't exist! Nice QA
there.

I wonder how fast people are upgrading to 9i. I know that there's plenty
of Oracle 7.3.x and 8.0.x still in production, and 8i underwhelmed a lot
of people (altho' I liked it). Hmmm.

Thanks,

g


--
Guy Hammond
AVT Technologies
12-16 Westland Place
London N1 7LP UK

Email: [EMAIL PROTECTED]
Office: +44 (0) 207 454 1224
Mobile: +44 (0) 7966 164687

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

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

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

RE: can i place online redologs with oracle engine ?

2001-07-06 Thread Rahul


infact i should have been more clearer 
offcourse i can place them on any disk..the reason i asked was...

how much IO does the root + oracle engine do when an instance is running...?


and given no other choice, i plan to place them with root+oracle rather than
with some data or indexes. 



 --
 From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, July 05, 2001 7:54 PM
 To:   Rahul; Multiple recipients of list ORACLE-L
 Subject:  Re:can i place online redologs with oracle engine ?
 
 Rahul,
 
 You can put them just about anywhere you want, but since they tend to
 be a
 high IO item you may end up paying a price.
 
 Dick Goulet
 
 Reply Separator
 Subject:can i place online redologs with oracle engine ?
 Author: Rahul [EMAIL PROTECTED]
 Date:   7/5/2001 1:16 AM
 
  list, 
  i cannot spare a separate drive for the redologs,
  can i place the online logs with the same drive as
  the solaris + oracle engine  ? 
  (m,y solaris and oralce are also on the same drive) 
  
  TIA
  
  Rahul
  
  
  
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rahul
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

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

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

RE: OT Bears

2001-07-06 Thread Robertson Lee - lerobe


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again 

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

RE: OT Bears

2001-07-06 Thread Mark Leith


Closest I've ever come to a bear was when I was on holiday a few weeks ago
in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
cage.. Not the same as seeing them in their natural environment at all I
guess..:)

The one truly amazing animal they had there though was the worlds only
(known) albino gorilla!! Now THAT is a site to see!! He looks like a big
hairy old man..

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 12:11
To: Multiple recipients of list ORACLE-L


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: can i place online redologs with oracle engine ?




Hi,

There's very little I/O done to the ORACLE_HOME unless you've chosen to store
and database files under it.
As for Unix, it would depend on how your filesystems are alocated. Steer clear
of /tmp and you should be OK but don't let anything fill up any 'OS'
filesystems such as /, /var etc.

Cheers,

Mike Hately



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

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

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

Re: RULE versus CHOOSE

2001-07-06 Thread Jon Walthour


 Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ?

There's a world of difference between them. Using the Cost-Based Optimizer
(CBO) versus Rule-Based is like using a GPS system to navigate a city you've
not been to in a while versus your own vague memories of it. In the latter
case, you may only remember a few ways around and things may have changed
dramatically. With the former, the current or near-current situation is
always known if used properly.

 Qs.2 Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
 having Any Statistics Existent on the Application Tables , Indexes ?

Using CHOOSE without analyzing the relevant schemas is the same as using
RULE because Oracle has no current map of the terrain to utilize. So, it
falls back on the standard rules.

 Qs.3 Are there any Disadvantages with Using RULE in 8.1.7.0 ?

Tons IMHO. Not in 8.1.7 in particular, but in general. Most databases are
constantly changing with the addition, changing and removing of data. What
the CBO offers is a roadmap to that changing data. Remember with the CBO
that it is only as good as your statistics. In sites I work at, I recommend
that relevant schemas are analyzed nightly to keep things current (btw,
never analyze SYS). In conjunction with that, we create and update
histograms on relevant columns in the application schemas to handle skewed
data distributions.

 Qs.4 In Choose mode are there any Commonly known Standard Important
 Statistics' Fields/Values which can be Looked at to understand why
  optimizer took a particular path ?
 What Causes a Path to be Chosen in CHOOSE , we are largely ignorant
 about .

This is difficult to explain and quite complex. There surely is a better
authority than I to answer this here and MetaLink could probably enlighten
you as well.

 NOTE - At a Customer's Database , Our Development Section Head wants to
 set optmizer_mode=RULE  keep it so . His Reasons :-
 - The path of the optimizer is more predictable when set to RULE
 - Any under-performance Issues would be Handled by Giving HINTS etc
 rather than Allowing the Optimizer to Choose / Compute it's own Path
 which may be a BAD One .
 - A Correct Path being Taken Today may in Time get Automatically Changed
 to a Worse Path somewhere in future (with the Stats getting OLD etc.) .
 - Lastly his Team will Take Responsibility for Any Performance Issues
 arising out of a Code underperforming .

See what I said above about the changing face of data in a database. And
what happens when his team changes? Are they always going to be there to
handle the performance issues and keep on top of them? A correct path being
taken today may in time get automatically changed is exactly the reason as
far as I'm concerned to use the CBO. It takes the guesswork out of most
query optimization if used properly.

 Qs Are there Any Best practices Documents / Links on RULE vs. CHOOSE ?

I'm sure there are many other, but the biggies I work with are (1) analyze
relevant schemas regularly, (2) create/maintain histograms on columns that
have skewed data distributions and (3) don't analyze SYS.

 Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule Or
 Still Endeavour to persist for optimizer_mode=CHOOSE ?

I would say persist in your argument for CHOOSE. The biggest reason to do it
now IMHO is that, according to Oracle, RULE is going to be desupported in
the near future. CHOOSE will soon be the default.

Anyone with more experience than I here, please chime in.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio



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

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

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

Please help!! - Error 472

2001-07-06 Thread Denham Eva


Hi Gurus

Please could you shed some light.
Server is a Compaq Proliant 8500 - RAID 5
Oracle 8.1.6
Windows 2000
The new changes to the system is - I have converted to the MTS listener
service(server), one day ago.
Just a short while ago - the database is still warm - she crashed with the
following error:
In the sidCKPT.TRC file

Windows thread id: 1980, image: ORACLE.EXE

*** 2001-07-06 11:47:06.125
*** SESSION ID:(4.1) 2001-07-06 11:47:06.093
error 472 detected in background process

and in the sidALT.LOG

Thread 1 advanced to log sequence 24136
  Current log# 1 seq# 24136 mem# 0: E:\ORACLE\ORADATA\MAXTFMC\REDO01.LOG
Fri Jul 06 11:47:05 2001
DBW0: terminating instance due to error 472

This is the first time I have ever seen such a error. Has anyone else
experienced it.

Thanks in advance
Denham


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

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

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

RE: OT Bears

2001-07-06 Thread April Wells


Northern Minnesota is a great place to see bears.  Bears running down the
side of the road, bears in your back yard, bears rifling your stuff when you
are camping, and on a warm late summer evening you can go to the Vince Shute
Wildlife preserve (http://www.americanbear.org/) and see the bears up close
and personal like... THAT is a neat thing to see.

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


Closest I've ever come to a bear was when I was on holiday a few weeks ago
in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
cage.. Not the same as seeing them in their natural environment at all I
guess..:)

The one truly amazing animal they had there though was the worlds only
(known) albino gorilla!! Now THAT is a site to see!! He looks like a big
hairy old man..

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 12:11
To: Multiple recipients of list ORACLE-L


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

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

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

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



The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable

RE: RULE versus CHOOSE - sorry it's long

2001-07-06 Thread Koivu, Lisa

Title: RE: RULE versus CHOOSE - sorry it's long





Hi Vivek, comments inline. List, please correct me if I am wrong. 


-Original Message-
From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 1:56 AM
To: Multiple recipients of list ORACLE-L
Subject: RULE versus CHOOSE


Database = Oracle 8.1.7.0.0 on SunOS 5.6 .
Current Database Size = 20 GB 
This is only a Test One  the Live Production will be a BIGGER (100 GB)
One .
OPTIMIZER_MODE = RULE  NO Statistics Exist Currently 


Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ?
[Lisa Koivu] 
Choose invokes the cost based optimizer (CBO). If the optimizer_goal = RULE, it is rule, period (RBO). 


Qs.2 Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
having Any Statistics Existent on the Application Tables , Indexes ?
[Lisa Koivu] 
Well, that equates to rule, I believe. However, if anyone does something like put statistics on an index somewhere and forget to delete them, and that index is used in a query, your optimizer will change to CBO and you may end up with unexpected query plans. I also believe that degree  1 will invoke CBO. (not exactly sure?) 

 
If Statistics are DELETED on ALL Objects , yet with optmizer_mode = 
CHOOSE , does it behave in Exactly the Same manner as having
optmizer_mode set to RULE Or are there Still Some Advantages which can
be Reaped ?
[Lisa Koivu] 
Same as answer above.


Qs.3 Are there any Disadvantages with Using RULE in 8.1.7.0 ?
[Lisa Koivu] 
Can't comment specifically on that, I haven't had the opportunity to play with 8.1.7


Qs.4 In Choose mode are there any Commonly known Standard Important
Statistics' Fields/Values which can be Looked at to understand why
optimizer took a particular path ? 
What Causes a Path to be Chosen in CHOOSE , we are largely ignorant
about .
[Lisa Koivu] 
Read up on histograms and exactly what the statistics mean (DBA_TABLES, etc). With CBO it isn't always exactly clear why it did what it did - for example, I have tried in the past to eliminate all FTS's from a query. CBO did not like that, it wanted to FTS at least one table. That's one thing you will find in CBO - it will favor FTS's more so than RBO. 

NOTE - At a Customer's Database , Our Development Section Head wants to
set optmizer_mode=RULE  keep it so . His Reasons :-
- The path of the optimizer is more predictable when set to RULE 
[Lisa Koivu] 
Well, yes. There is a published list of steps RBO will take to try to determine the query plan. 
- Any under-performance Issues would be Handled by Giving HINTS etc
rather than Allowing the Optimizer to Choose / Compute it's own Path
which may be a BAD One . 
[Lisa Koivu] 
Well, have you tried it? Some view hints as hard-coding. However, in some cases it is warranted.


- A Correct Path being Taken Today may in Time get Automatically Changed
to a Worse Path somewhere in future (with the Stats getting OLD etc.) .
[Lisa Koivu] 
You avoid this by keeping your statistics fresh at all times. You may have to mess with the statistics for any skewed columns (again, this is histograms) but the bottom line is stale statistics mean sub-optimal query plans. I believe there's a package called DBMS_STATS that will monitor your objects for stale statistics. I don't know what the threshold is for determining if statistics are stale, I haven't investigated this package. However, there's also a school of thought that says ANY change to your data renders the statistics invalid, period. Also, deleting statistics from an object and following this step with analyzing the object renders much better behavior. Don't ask why... it's just another quirk (list, correct me if I am wrong)

- Lastly his Team will Take Responsibility for Any Performance Issues
arising out of a Code underperforming .
[Lisa Koivu] 
Well, that's a challenge. Tuning your top ten bad statements should be an ongoing task... Are they qualified to do this? are there any SQL tuning experts on his team? 

Qs Are there Any Best practices Documents / Links on RULE vs. CHOOSE ?
[Lisa Koivu] 
CBO is best suited for DSS environment, where FTS is common and is not viewed as evil. CBO has several features built into it that exploit a proper star schema design and deliver plans more suited to the volume of data (index combining, etc.) I have yet to see an OLTP or hybrid-type system running successfully on CBO, but then again I have only been looking at this closely over the last three years. Maybe the list can shed mroe light on this question. 

Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule Or
Still Endeavour to persist for optimizer_mode=CHOOSE ?
[Lisa Koivu] 
I can tell you that just analyzing everything, setting optimizer_goal = CHOOSE and restarting the app most likely will not work. Moving to CBO will involve a certain amount of trial and error, with you and the support team learning why CBO does what it does, what can be done differently in the schemas/sql statements, etc. In short, it can be

RE: RULE versus CHOOSE

2001-07-06 Thread Terrian, Tom


Jon,

Great write up.

Several times you mentioned creating Histograms for skewed data distributions.
I am just curious if you have ever studied the performance impact with and
without them?  We used to maintain histograms but when we studied the
performance impact (with and without them) we determined that there was very
little benefit with histograms.  The down side with them is that they
drastically increased the amount of time it took to analyze the tables at night.
We decided to do without them.  Have you ever studied their benefits verse
drawbacks?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Friday, July 06, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L


 Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ?

There's a world of difference between them. Using the Cost-Based Optimizer
(CBO) versus Rule-Based is like using a GPS system to navigate a city you've
not been to in a while versus your own vague memories of it. In the latter
case, you may only remember a few ways around and things may have changed
dramatically. With the former, the current or near-current situation is
always known if used properly.

 Qs.2 Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
 having Any Statistics Existent on the Application Tables , Indexes ?

Using CHOOSE without analyzing the relevant schemas is the same as using
RULE because Oracle has no current map of the terrain to utilize. So, it
falls back on the standard rules.

 Qs.3 Are there any Disadvantages with Using RULE in 8.1.7.0 ?

Tons IMHO. Not in 8.1.7 in particular, but in general. Most databases are
constantly changing with the addition, changing and removing of data. What
the CBO offers is a roadmap to that changing data. Remember with the CBO
that it is only as good as your statistics. In sites I work at, I recommend
that relevant schemas are analyzed nightly to keep things current (btw,
never analyze SYS). In conjunction with that, we create and update
histograms on relevant columns in the application schemas to handle skewed
data distributions.

 Qs.4 In Choose mode are there any Commonly known Standard Important
 Statistics' Fields/Values which can be Looked at to understand why
  optimizer took a particular path ?
 What Causes a Path to be Chosen in CHOOSE , we are largely ignorant
 about .

This is difficult to explain and quite complex. There surely is a better
authority than I to answer this here and MetaLink could probably enlighten
you as well.

 NOTE - At a Customer's Database , Our Development Section Head wants to
 set optmizer_mode=RULE  keep it so . His Reasons :-
 - The path of the optimizer is more predictable when set to RULE
 - Any under-performance Issues would be Handled by Giving HINTS etc
 rather than Allowing the Optimizer to Choose / Compute it's own Path
 which may be a BAD One .
 - A Correct Path being Taken Today may in Time get Automatically Changed
 to a Worse Path somewhere in future (with the Stats getting OLD etc.) .
 - Lastly his Team will Take Responsibility for Any Performance Issues
 arising out of a Code underperforming .

See what I said above about the changing face of data in a database. And
what happens when his team changes? Are they always going to be there to
handle the performance issues and keep on top of them? A correct path being
taken today may in time get automatically changed is exactly the reason as
far as I'm concerned to use the CBO. It takes the guesswork out of most
query optimization if used properly.

 Qs Are there Any Best practices Documents / Links on RULE vs. CHOOSE ?

I'm sure there are many other, but the biggies I work with are (1) analyze
relevant schemas regularly, (2) create/maintain histograms on columns that
have skewed data distributions and (3) don't analyze SYS.

 Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule Or
 Still Endeavour to persist for optimizer_mode=CHOOSE ?

I would say persist in your argument for CHOOSE. The biggest reason to do it
now IMHO is that, according to Oracle, RULE is going to be desupported in
the near future. CHOOSE will soon be the default.

Anyone with more experience than I here, please chime in.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio



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

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

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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Farnsworth, Dave


orastaff wrote:

We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working
with
other recruiters for Phoenix companies. 

Is this some super secret job or what???

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


If you're interested in a great opportunity, then consider this position in
Phoenix, AZ 
with a leading company that needs an Oracle DBA to join its' I.T. staff.
We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working with
other recruiters for Phoenix companies. 

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

* Requirements:
- A degree in C.S. or equivalent
- 3+ yrs Oracle DBA experience is needed
- Strong Unix
- Application development experience; Unix scripting; C or Perl languages 
  are desirable
- Must have good communication skills 
 -U.S. citizenship or permanent residency required


This position is with a  company that offers :
* Quality Work Environment
* Base salary up to 75K-firm +excellent benefits
* Financial Stability
* Some Relocation Assistance

NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume to:

Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
* Please use job code: One/Phoenix/DBA/Carlos

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law
OraStaff, Inc-The Proven Connection To Oracle Opportunity



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

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

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

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

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

Re: OT Bears

2001-07-06 Thread Terry Ball


When I was growing up, my family went to Yellowstone Park almost every year.
This was in the days before some idiot gave LSD to the bears.  The bears would
come right up to the cars.  Saw lots of them right next to the car window.  (Dad
would NOT let us roll the windows down enough for Mr. Bear to get his head in).
One year we saw a total of 67 bears.  Most from a distance, but a dozen or so
close up.

Terry

Mark Leith wrote:

 Closest I've ever come to a bear was when I was on holiday a few weeks ago
 in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
 cage.. Not the same as seeing them in their natural environment at all I
 guess..:)

 The one truly amazing animal they had there though was the worlds only
 (known) albino gorilla!! Now THAT is a site to see!! He looks like a big
 hairy old man..

 -Original Message-
 Lee - lerobe
 Sent: Friday, July 06, 2001 12:11
 To: Multiple recipients of list ORACLE-L

 A bit touristy I know but I had a marvellous holiday about 2 years ago now
 in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
 Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
 and spent 2 days watching grizzlies during the Salmon run. No guns were
 carried at any time (just pepper sprays) and we got really close to the
 bears.

 Thinking of doing it again

 Lee

 -Original Message-
 Sent: 05 July 2001 21:06
 To: Multiple recipients of list ORACLE-L

 Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
 WW Well, we have remote access from home too, but it might be convenient to
 be
 WW able to do this stuff while I'm running from a grizzly in the Absarokas.

 I hope I never have the opportunity to run from a grizzly. I
 once bumped (not literally) into a black bear while hiking.
 Mr. Bear just ignored me, though I was pretty spooked by
 the encounter.

 Best regards,

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

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

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

 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Robertson Lee - lerobe
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: OT Bears


I love nature and animals, but I think the only place on ever want to see a
bear is either on the Discovery Channel or in a Zoo.  I have nightmares
about bears, I know, it's pathetic.
KK

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

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

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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread akuerten



Is the NSA maybe located there??

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

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

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

Re: OFA (Optimal Flexible Architecture) in practice


Hagedorn, Linda wrote:
 
 Does anyone use OFA as their company standard?  If so, are there any
 complaints about it's structure?  For example, the commingling of
 different database subdirectories under a given mount point?

yes i do use it, and have used it here and at other companies.  and i
don't understand your ls comment.  if i have :

/u02/app/oracle/d1/oradata 

and do an ls -alsR i see everything i need.  so folks what am i doing
wrong?;-)

i find it easy to work with, easy to find everything for a given
database, and easy to do backups with.

--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
one ping to rule them all, one ping to find them, one ping to bring them
all, and in the darkness bind them.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

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

strange explain plan

2001-07-06 Thread Gene Gurevich


Hi.

This is a second attempt. My first Email never got
posted.

I have the following query:

select a1.MBR_TYP_CDE MBR_TYP_CDE,
 (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD ))  
DISTINCTALLMERCHCO
 from MDSS_STAR.NOVUS_NETWRK_MBR_D a1
group by a1.MBR_TYP_CDE

The explain plan for it is as follows:


0-0-5898 1.5898 SELECT STATEMENTSQL1 Cost = 5898
1-0-1  2.1 SORT GROUP BY
2-1-1   3.1 SORT GROUP BY
3-2-14.1 SORT GROUP BY
4-3-1 5.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D


It has three group by's and the query fails with
0ra-0600 [15851]. 

when I create a new table as select * from the old
table the plan changes:

0-0-9721 1.9721 SELECT STATEMENTSQL1 Cost = 9721
1-0-1  2.1 SORT GROUP BY
2-1-1   3.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D_TMP

and the query works. Does anyone have any guess as to
what is going on?

thank you for any help

Gene

=


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

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

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

2001-07-06 Thread April Wells


Maybe it's Palo Verde Nuclear Power Station.

-Original Message-
Sent: Friday, July 06, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L



Is the NSA maybe located there??

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

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

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



The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.

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

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

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

RE: OT Bears

2001-07-06 Thread Robertson Lee - lerobe


Won't go to zoos on principal !!

nuff said.


-Original Message-
Sent: 06 July 2001 13:05
To: Multiple recipients of list ORACLE-L


Closest I've ever come to a bear was when I was on holiday a few weeks ago
in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
cage.. Not the same as seeing them in their natural environment at all I
guess..:)

The one truly amazing animal they had there though was the worlds only
(known) albino gorilla!! Now THAT is a site to see!! He looks like a big
hairy old man..

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 12:11
To: Multiple recipients of list ORACLE-L


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

Re: Please help!! - Error 472

2001-07-06 Thread nlzanen1



Hi


I don't know if you have access to metalink or not, but there are quite a
few documents there about bugs relating to error 472 (some are in
combination with mts). Have a look there.


Jack


   
  
Denham Eva 
  
[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
za  cc: (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)  
Sent by: Subject: Please help!! - Error 472
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
06-07-2001 
  
14:20  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Hi Gurus

Please could you shed some light.
Server is a Compaq Proliant 8500 - RAID 5
Oracle 8.1.6
Windows 2000
The new changes to the system is - I have converted to the MTS listener
service(server), one day ago.
Just a short while ago - the database is still warm - she crashed with the
following error:
In the sidCKPT.TRC file

Windows thread id: 1980, image: ORACLE.EXE

*** 2001-07-06 11:47:06.125
*** SESSION ID:(4.1) 2001-07-06 11:47:06.093
error 472 detected in background process

and in the sidALT.LOG

Thread 1 advanced to log sequence 24136
  Current log# 1 seq# 24136 mem# 0: E:\ORACLE\ORADATA\MAXTFMC\REDO01.LOG
Fri Jul 06 11:47:05 2001
DBW0: terminating instance due to error 472

This is the first time I have ever seen such a error. Has anyone else
experienced it.

Thanks in advance
Denham


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

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

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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its

Oracle9i on Suse Linux

2001-07-06 Thread Jonathan Gennick


I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB
swap), and ran into a bit of a snag. The install ran fine
until the end when the database creation assistant attempted
to start the seed database. At that point I received an
ORA-03113: End of File on Communication Channel error, and
my Linux box froze up. Having Linux freeze up is a pretty
rare event in itself, but I'm really wondering what caused
the error. After rebooting, I was able to run the database
creation assistant, create another database, and start that
one. I then tried to manually start the seed database, and
received the same ORA-03113 error. Could this somehow be
related to memory? Was it too much to have the installer and
the creation assistant running at the same time?

A couple of other oddities I noticed:

During the install, I was asked to specify a location for
a JDK. I dutifully created a directory and typed in its
path, but the installer never actually put any files into
it. Why did it ask me for a directory that it wasn't going
to use?

When I run the oraenv script, it doesn't create an
ORACLE_HOME environment variable. Instead of adding
$ORACLE_HOME/bin to my path, it adds the full path to the
bin directory. Is $ORACLE_HOME going away?

Best regards,

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

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

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

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

RULE versus CHOOSE - Basic Qs.

2001-07-06 Thread VIVEK_SHARMA



Qs. Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
having Any Statistics Existent on the Application Tables , Indexes ?

Qs With NO Statistics Existant on ALL Objects , yet with optmizer_mode =

CHOOSE , does it mean that RULE (RBO) will be Used ?

Following Excerpts seem to imply the Same that RBO will be Used if NO
Statistics Exist but with Optimizer mode set to CHOOSE


EXCERPTS from a Doc. Paper #169  :-

Determining which optimizer to use:

Determining which optimizer will be used to evaluate each query depends
on several factors and can be set at either the instance level, session
level or query level.
Instance Level:
OPTIMIZER_MODE - This parameter sets the default optimization behavior
for the entire Oracle instance.

*CHOOSE - the default OPTIMIZER_MODE, differs determining which
optimizer to use until each query is evaluated. If any table
participating in a query has had statistics collected on it's data the
CBO will be used to evaluate the query. For this reason it is essential
for all tables in a query to have statistics collected or none of them
have statistics collected.


Oracle's Cost Based Optimizer:


*If table statistics are missing or old the CBO can make bad decisions.
If statistics are missing Oracle can only guess what data might be in
the table.

THANKS SO MUCH ALL


 -Original Message-
 From: Jackson Andy - andjac [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, July 06, 2001 1:28 PM
 To:   LazyDBA.com Discussion
 Subject:  RE: RULE versus CHOOSE
 
 
 I would strongly resist anyone who wanted to run a v8 database with
 RULE
 based optimization for the following reasons:
 
 - The CBO is aware of new Oracle features and can generate execution
 paths
 for them, eg partition elimination
 - The CBO is much better now than it used to be but in situations
 where you
 need a guaranteed execution path you can always use hints.
 - Development of the RBO stopped with v7 and Oracle peridocially make
 noises
 as though they will drop it in the future
 - The only part of the database that should use the RBO is the data
 dictionary
 
 The CBO is only as good as the database stats so you have to keep them
 as up
 to date as possible, even if it means a performance hit whilst the
 analyze
 command is running, a 10% estimation should be sufficient.
 
 There is lots of stuff on Metalink about this.
 
 Cheers
 Andy Jackson
 
 -Original Message-
 From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 06, 2001 5:51 AM
 To: LazyDBA.com Discussion
 Subject: RULE versus CHOOSE
 
 
 Database = Oracle 8.1.7.0.0 on SunOS 5.6 .
 Current Database Size = 20 GB 
 This is only a Test One  the Live Production will be a BIGGER (100
 GB)
 One .
 OPTIMIZER_MODE = RULE  NO Statistics Exist Currently 
 
 Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ?
 
 Qs.2 Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
 having Any Statistics Existent on the Application Tables , Indexes ?
 
 If Statistics are DELETED on ALL Objects , yet with optmizer_mode = 
 CHOOSE , does it behave in Exactly the Same manner as having
 optmizer_mode set to RULE Or are there Still Some Advantages which can
 be Reaped ?
 
 Qs.3 Are there any Disadvantages with Using RULE in 8.1.7.0 ?
 
 Qs.4 In Choose mode are there any Commonly known Standard Important
 Statistics' Fields/Values which can be Looked at to understand why
 optimizer took a particular path ? 
 What Causes a Path to be Chosen in CHOOSE , we are largely ignorant
 about .
 
 NOTE - At a Customer's Database , Our Development Section Head wants
 to
 set optmizer_mode=RULE  keep it so . His Reasons :-
 - The path of the optimizer is more predictable when set to RULE 
 - Any under-performance Issues would be Handled by Giving HINTS etc
 rather than Allowing the Optimizer to Choose / Compute it's own Path
 which may be a BAD One . 
 - A Correct Path being Taken Today may in Time get Automatically
 Changed
 to a Worse Path somewhere in future (with the Stats getting OLD etc.)
 .
 - Lastly his Team will Take Responsibility for Any Performance Issues
 arising out of a Code underperforming .
 
 Qs Are there Any Best practices Documents / Links on RULE vs. CHOOSE ?
 
 Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule Or
 Still Endeavour to persist for optimizer_mode=CHOOSE ?
 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

Re: OT Bears

2001-07-06 Thread Stephane Faroult


Mark Leith wrote:
 
 Closest I've ever come to a bear was when I was on holiday a few weeks ago
 in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
 cage.. Not the same as seeing them in their natural environment at all I
 guess..:)

  Your going to Spain to see bears rather than bulls is a good sign of
the times ...

--
Regards,

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

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

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

RE: RE: RULE versus CHOOSE

2001-07-06 Thread Jon Walthour




Tom:

I never did any official benchmark studies, per se. I studied
the CBO/histograms about 4 months ago when we were converting
an app over from Oracle 7 to 8i. The new version of the app had
queries that were very different from its earlier version and
so performance on 8i as compared to 7 was dramatically worse.
Of course, the app owners blamed the database. In the course
of my defense of the db, I discovered that the data (being primarily
composed of case studies) was severely skewed to the more recent
dates (i.e., the further back you went, the sparser the number
of cases). I discovered that the optimizer was doing a lot of
range scans for queries when it should have been doing full table
scans according to the CBO thresholds. Histograms on certain
date fields throughout the schema dropped times on certain large
report queries from 30 minutes to under 2.

That's all I know. I can't give you an hard empirical evidence,
just anecdotal evidence that, when properly used, histograms
do seem to have dramatic impacts.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio


--- Original Message ---
From: Terrian, Tom [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/6/01 9:20:24 AM


Jon,

Great write up.

Several times you mentioned creating Histograms for skewed data
distributions.
I am just curious if you have ever studied the performance impact
with and
without them?  We used to maintain histograms but when we studied
the
performance impact (with and without them) we determined that
there was very
little benefit with histograms.  The down side with them is
that they
drastically increased the amount of time it took to analyze
the tables at night.
We decided to do without them.  Have you ever studied their
benefits verse
drawbacks?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 




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

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

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

image in database

2001-07-06 Thread milind ambegaoker


Dear mailing list,
how to store an image in the database from a form
written in Java servlets ?
Also how to retrive the image from the database ?
Thanks in advance


Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?milind=20ambegaoker?=
  INET: [EMAIL PROTECTED]

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

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

RE: OT: Learning Curve for Informatica ETL Products

2001-07-06 Thread Farnsworth, Dave


This is true, unless of course it is running on Ardent's UniData or Universe
database.  That is something else to work with.

Dave

-Original Message-
Sent: Friday, July 06, 2001 1:15 AM
To: Multiple recipients of list ORACLE-L



Larry,

I took several training courses last year for one of their
competitors products, Ardent Datastage, though it's called
something else now.

Anyway, they're very similar, we evaluated Informatica also.

They are both very powerful products.  If my experience with
the Ardent products is any indication, you shouldn't have any
trouble learning these tools.

The technology underneath is not anything special, their power
lies in their management and organizational abilities.  Building
ETL processes with these tools is much easier than doing it
all with an editor and a command line.

Complex tasks still require programming, but it's within their
IDE and easily managed.  I'm not normally a fan of GUI tools
but good ETL tools are an exception.

Jared


On Thursday 05 July 2001 17:07, Larry Elkins wrote:
 Listers,

 For any of you who use Informatica ETL products such as PowerMart and/or
 PowerCenter, how steep is the learning curve for these products? I know
 there are lots of variables such as how quickly does the person pick up
new
 things, are we talking about learning the basics and doing simple tasks,
 or, doing advanced things, etc. For example, with some products, one can
 quickly learn to perform basic functions, but, there can be a steep
 learning curve to perform advanced functions.

 Just curious about the complexity and ease/difficulty of getting up to
 speed on these tools.

 Regards,

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

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

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

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

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

sqlplus command

2001-07-06 Thread milind ambegaoker


Dear mailing list,
is it possible to execute SQLPLUS commands from
subprograms like procedures and functions ?
If possible pl. send me how to do it  ?
If not please tell me why and alternate way
as i want to write sub programs(procedures) that would
generate reports on the SQL prompt by using the
SQLPLUS formatting commands.


Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?milind=20ambegaoker?=
  INET: [EMAIL PROTECTED]

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

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

RE: OT: Just chatter about Wireless costs and PocketDBA


I agree, I love my Palm:)

-Original Message-
Smith
Sent: Thursday, July 05, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L


But you can play games on them.  I actually used to think the same way until
the company agreed to by me one.  Since I use Outlook so much they are
actually
quite nice to have.  Now, instead of carrying a day timer I carry a Palm.
Makes
life easier for me.  Now I am going to go get the software to hook it up
to my GPS.

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


Ross,

What I was talking about is the added expense of wireless connectivity
for a
PDA.  Personally I don't own a PDA and have no desire to do so.

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   7/5/2001 11:19 AM

While i don't shared  DG's feelings
about the size and resource consumption
of the PocketDBA, I do share his feelings about the cost of the wireless
access.

Around here, Ricochet for the Palm PDA
runs about 50$ a month or so. What bullsh*t!

When I get wireless for an additional 10$ a month, I'll jump at it.

Until then, if my company thinks RF'ing in with my PDA is any different than
coming in with T1+ speed broadband, i
am sure they'll let me know



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


Where I am the amount is zero as we all have remote access from home
already.
What one can quantify is the amount of extra $ it costs for a VPN dial-up
line
vs. the wireless connectivity this monster requires.  Now that comes to
something (what I am not privy to), so good-bye PocketDBA.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/5/2001 10:21 AM


If only it were this simple:

 ..quantify the amount of time and money their companies would
save if their DBAs.could remotely...
 remove from the database a user who is running a command that is
holding up the system.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002





Grabowy,


Chris   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
cgrabowy@fcgcc:


.comSubject: OT: Ari and his
company
have been noted in InfoWorld...
Sent by:


root@fatcity.


com








07/05/2001


01:01 PM


Please


respond to


ORACLE-L












Ari and his company have been noted in InfoWorld...


EPHRAIM SCHWARTZ  Wireless World InfoWorld.com


Thursday, July 5, 2001

REDUCING THE COST OF DBAS

Posted at June 29, 2001 01:01 PM PST Pacific


I'LL LEAVE IT to my readers to quantify the amount of
time and money their companies would save if their
DBAs (database administrators) could remotely, and
wirelessly, make changes to their databases. Imagine
the efficiencies in not having to call a DBA back to
the office to add table space to a database, look at
what indexes exist and modify table structures, give a
new password to a user who has forgotten it, or remove
from the database a user who is running a command that
is holding up the system.

You can accomplish these and many other corrective
measures using the application PocketDBA, available
from the company of the same name.

I spoke with Ari Kaplan, CEO and co-founder of
PocketDBA, in Chicago. His background includes 10
years at Oracle, where he oversaw the implementation
of some of the largest Oracle database deployments in
the world, such as Hallmark's Web site and Merck's
entire order-entry and inventory system. Kaplan
believes his company's wireless DBA package is more
robust than Oracle's own desktop Enterprise Manager.

PocketDBA, which can currently be implemented on a Palm
OS device and will soon be available for Pocket PCs,
will appear for Microsoft's SQL Server and IBM's DB2
next year.

Go to http://www.pocketdba.com for a demo.

Fed up with ActiveSync

Remember two weeks ago when I said that I did not want
work-arounds to my problem in which ActiveSync did not
recognize the USB ports on three separate computers
(see Wireless World, June 18)? Here's a typical
example of the e-mails I've received that prove my point.

I had a similar but intermittent problem with my iPaq
using ActiveSync on a Toshiba laptop, one reader
wrote. I installed the Compaq ROM BIOS update last
month and haven't seen the problem since.

The update is Version 1.77, and you can download it from
http://www.compaq.com/support/files/handhelds/us/download/9820.html.
Also ActiveSync 3.1 (Build 9587) has some fixes for USB
support. Build 9587 is available at

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Koivu, Lisa

Title: RE: * Oracle DBA Needed in Phoenix..





Cheap! Cheap Cheap Cheap 
$75,000? To move across the country with MINIMAL relo? 
Are they kidding??


I hope this isn't our parent company


Happy Friday everyone!
Lisa, the anti-recruiter ninja


-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: * Oracle DBA Needed in Phoenix..


orastaff wrote:


We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working
with
other recruiters for Phoenix companies. 


Is this some super secret job or what???


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



If you're interested in a great opportunity, then consider this position in
Phoenix, AZ 
with a leading company that needs an Oracle DBA to join its' I.T. staff.
We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working with
other recruiters for Phoenix companies. 


This is a full time staff position so no sub-contractors or third parties
please.


Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.


* Requirements:
- A degree in C.S. or equivalent
- 3+ yrs Oracle DBA experience is needed
- Strong Unix
- Application development experience; Unix scripting; C or Perl languages 
 are desirable
- Must have good communication skills 
-U.S. citizenship or permanent residency required



This position is with a company that offers :
 * Quality Work Environment
 * Base salary up to 75K-firm +excellent benefits
 * Financial Stability
 * Some Relocation Assistance
 
NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.


For immediate consideration, please send your resume to:


Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
* Please use job code: One/Phoenix/DBA/Carlos


We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law
OraStaff, Inc-The Proven Connection To Oracle Opportunity




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


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

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


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

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

RE: OT: Ari and his company have been noted in InfoWorld.


Actually, I have Ari's product.  I have to admit, it is a pretty neat little
tool.  The idea is that you don't need to lug around a laptop with a
wireless Ricochet modem.  Yeah, that would be a much better combination, you
could ultimately do more in a shorter amount of time.  But, with my Palm
VIIx and PocketDBA I can accomplish just about as much without having to get
out of bed, turn on the computer, dial up, and then VPN or Pc Anywhere!!
KK

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

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

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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Jim Conboy




Preferably with no close friends or relatives, nobody to notice if you 
just...disappear.

Jim [EMAIL PROTECTED] 07/06/01 09:10AM 
orastaff wrote:We would like to submit someone 
who is a renter and who is interestedin Phoenix but has not applied to 
Phoenix companies and is not workingwithother recruiters for 
Phoenix companies. Is this some super secret job or 
what???-Original Message-Sent: Thursday, July 05, 
2001 3:15 PMTo: Multiple recipients of list ORACLE-LIf you're 
interested in a great opportunity, then consider this position inPhoenix, AZ 
with a leading company that needs an Oracle DBA to join its' I.T. 
staff.We would like to submit someone who is a renter and who is 
interestedin Phoenix but has not applied to Phoenix companies and is not 
working withother recruiters for Phoenix companies. This is a full 
time staff position so no sub-contractors or third 
partiesplease.Please do not call or send a resume if you are not in 
the U.S. and/or need sponsorship.* Requirements:- A degree in 
C.S. or equivalent- 3+ yrs Oracle DBA experience is needed- Strong 
Unix- Application development experience; Unix scripting; C or Perl 
languages  are desirable- Must have good communication skills 
-U.S. citizenship or permanent residency requiredThis position 
is with a company that offers 
: 
* Quality Work 
Environment 
* Base salary up to 75K-firm +excellent 
benefits 
* Financial 
Stability 
* Some Relocation 
Assistance 
NO sub contracting positions available.PLEASE do not send your resume if 
you are not in the United States.For immediate consideration, 
please send your resume to:Email: [EMAIL PROTECTED]Phone: 
1-800-549-8502. * Please use job code: One/Phoenix/DBA/CarlosWe pay 
referral fees.So please contact me if you know of anyone who would be 
qualified/interestedin the posiitiondescribed above- if it is not a 
match for your skills.Thanks,Bill LawOraStaff, Inc-"The Proven 
Connection To Oracle Opportunity"-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: OraStaff INET: [EMAIL PROTECTED]Fat City 
Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).--Please see the official ORACLE-L 
FAQ: http://www.orafaq.com--Author: 
Farnsworth, Dave INET: [EMAIL PROTECTED]Fat City 
Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

RE: OT: Learning Curve for Informatica ETL Products

2001-07-06 Thread paquette stephane


I do not know your background, congratulations if you
were able to develop performant mappings. But it's not
the case on most clients I've seen where average
developper were developping with the ETL tool. 

I'm sure that an experienced DBA with a good knowledge
of its working environnement and who has always
performance, ease of maintenance and robustness in his
mind, could develop good mappings. 

In the real life, the development is done by people
with a medium knowledge of SQL, a weak knowledge of
tuning and the rdbms and with 3-4 years of experience.


Stephane 
 --- Khedr, Waleed [EMAIL PROTECTED] a écrit :
 Actually I do not know what is hard about learning
 Informatica or Sagent!
 
 In my opinion it's a toy.
 
 It's very easy and nothing is difficult to learn.
 
 Sagent is more intuitive than Informatica but
 Informatica engine might be
 more stable.
 
 Regards,
 
 Waleed
 
 -Original Message-
 Sent: Friday, July 06, 2001 5:31 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi,
 
 We're currently using Powermart. I'm not developping
 the mappings but I'm checking what the developpers
 are
 doing. I've used Sagent tool a little bit and at a
 client we've developped the ETL tool ourselves. 
 
 Powermart is not an easy tool to learn.
 
 At my request, we finally have an Informatica
 consultant in house to look at what we've done so
 far
 (yesterday and today). Like all tools, you can do
 things by yourself but you can't achieve performance
 without an expert. 
 
 There are things you want to do in Oracle and not in
 the ETL tool so you have some choices to do. I like
 to
 put some intellingence in the metadata and have the
 programs to act accordingly to what the metadata
 contains. The developpers could not figure out how
 to
 do this, the Informatica consultant will show us
 that
 this afternoon. 
 
 So bottom-line, it is not an easy tool to learn. 
 
 
 Also, you really need a 21 inches screen to work
 with
 Powermart.
 
 Stephane 
 
  --- Larry Elkins [EMAIL PROTECTED] a écrit : 
 Listers,
  
  For any of you who use Informatica ETL products
 such
  as PowerMart and/or
  PowerCenter, how steep is the learning curve for
  these products? I know
  there are lots of variables such as how quickly
 does
  the person pick up new
  things, are we talking about learning the basics
 and
  doing simple tasks, or,
  doing advanced things, etc. For example, with some
  products, one can quickly
  learn to perform basic functions, but, there can
 be
  a steep learning curve
  to perform advanced functions.
  
  Just curious about the complexity and
  ease/difficulty of getting up to speed
  on these tools.
  
  Regards,
  
  Larry G. Elkins
  [EMAIL PROTECTED]
  
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Larry Elkins
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 


  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be
 removed
  from).  You may
  also send the HELP command for other information
  (like subscribing). 
 
 
 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]
 

___
 Do You Yahoo!? -- Pour faire vos courses sur le Net,
 
 Yahoo! Shopping : http://fr.shopping.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

Re: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Cherie_Machler



Peter,

It probably means that they're willing to relocate someone
but don't want to pay a ton of money to relocate someone
who owns a house.  There can be more than $10,000 worth
of closing costs, moving costs, guarantee to buy your house
if it doesn't sell, etc.

Renters are simpler and cheaper to relocate.

Chere


   
   
Peter  
   
fbsdq@yahoo.To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
com cc:   
   
Sent by: Subject: Re: * Oracle DBA Needed in 
Phoenix..
root@fatcity.  
   
com
   
   
   
   
   
07/05/01   
   
05:17 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   






On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying:


. . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote:
. . . .|O We would like to submit someone who is a renter and who is
interested
. . . .|O in Phoenix but has not applied to Phoenix companies and is not
working with
. . . .|O other recruiters for Phoenix companies.
. . . .|
. . . .|Now why in the world would any of this matter?
   They are trying to get more people into Phoenix, and they
have invested in apartment buildings.

But seriously that is kinda weird.

. . . .|
www.nul.cjb.net
www.FreeBSD.org



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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




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

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

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

RE: OT: Learning Curve for Informatica ETL Products

2001-07-06 Thread Khedr, Waleed


Actually I do not know what is hard about learning Informatica or Sagent!

In my opinion it's a toy.

It's very easy and nothing is difficult to learn.

Sagent is more intuitive than Informatica but Informatica engine might be
more stable.

Regards,

Waleed

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


Hi,

We're currently using Powermart. I'm not developping
the mappings but I'm checking what the developpers are
doing. I've used Sagent tool a little bit and at a
client we've developped the ETL tool ourselves. 

Powermart is not an easy tool to learn.

At my request, we finally have an Informatica
consultant in house to look at what we've done so far
(yesterday and today). Like all tools, you can do
things by yourself but you can't achieve performance
without an expert. 

There are things you want to do in Oracle and not in
the ETL tool so you have some choices to do. I like to
put some intellingence in the metadata and have the
programs to act accordingly to what the metadata
contains. The developpers could not figure out how to
do this, the Informatica consultant will show us that
this afternoon. 

So bottom-line, it is not an easy tool to learn. 


Also, you really need a 21 inches screen to work with
Powermart.

Stephane 

 --- Larry Elkins [EMAIL PROTECTED] a écrit : 
Listers,
 
 For any of you who use Informatica ETL products such
 as PowerMart and/or
 PowerCenter, how steep is the learning curve for
 these products? I know
 there are lots of variables such as how quickly does
 the person pick up new
 things, are we talking about learning the basics and
 doing simple tasks, or,
 doing advanced things, etc. For example, with some
 products, one can quickly
 learn to perform basic functions, but, there can be
 a steep learning curve
 to perform advanced functions.
 
 Just curious about the complexity and
 ease/difficulty of getting up to speed
 on these tools.
 
 Regards,
 
 Larry G. Elkins
 [EMAIL PROTECTED]
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Larry Elkins
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

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

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

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

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

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

RE: OFA (Optimal Flexible Architecture) in practice

2001-07-06 Thread Loughmiller, Greg


We used OFA with a small modification..

We used raw devices for the data files of the tablespaces.  Then we built
symbolic links to all of the necessary devices from a core directory. Those
sym links were placed in a single directory off the $ORACLE_BASE. 

For example, all of the sym links would be in the following:
$ORACLE_BASE/links/dbname

It worked well for us...  This may not fit the requirements of other
shops...

Greg


-Original Message-
Sent: Thursday, July 05, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L


Does anyone use OFA as their company standard?  If so, are there any
complaints about it's structure?  For example, the commingling of
different database subdirectories under a given mount point?

e.g..

/u02/oradata/db_name1/userdata01.dbf
/u02/oradata/db_name2/userdata01.dbf
/u03/oradata/db_name1/userdata02.dbf
/u03/oradata/db_name2/userdata02.dbf

You cannot cd to a given subdirectory, ls -ltR | more to see all the
datafiles associated with a given database.  Instead, from / you
have to ls -ltR | grep db_name1 to scan the full file system.  Seems
like there should be a better way.

Any input, pro or con, is appreciated.

Linda,

The point of OFA is to spread out the database over different drives 
for performance reasons.  For example, you might want to separate 
indexes from data.  Would what you are proposing allow for multiple 
drives?

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

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

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

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

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

Range partition

2001-07-06 Thread Bala, Prakash


Hello,

Oracle 8.1.7 on Sun Solaris

Scenario: We have a table where we store the consolidated weekly numbers on
the number of disconnects, reconnects, transfers etc. Our business week is
from Wednesday to Tuesday and so each week has a number assigned to it.
Also, the week doesn't span across months. So we have a total of 63 weeks
for 2001. The table stucture is as follows:

 activity_year  number(4),
 week_num   number(2),
 company_code   varchar2(10),
 channel_code   varchar2(20),
 spectrum_code  varchar2(4),
 subscriber_codevarchar2(6),
 bopnumber(10),
 initial_addnumber(10),
 volun_disc number(10),
 involun_disc   number(10).

I need to partition this table in such a way that the data for a given year
and week number should go to a specific partition. Searched Metalink and
Oracle docs but didn't get an answer.

Is there a way to accomplish this without adding a date column to this
table?

TIA

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

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

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

RE: OT: Just chatter about Wireless costs and PocketDBA

2001-07-06 Thread TCarlson



LOL!

Todd Carlson
Oracle 8i Certified DBA
Bunge North America


   
  
   
  
   Robertson To: Multiple recipients of list ORACLE-L  
  
Lee - lerobe [EMAIL PROTECTED]
  
lerobe@acxiocc:   
  
m.co.uk Subject: RE: OT: Just chatter about   
  
   Sent by:  Wireless costs and PocketDBA  
  
root@fatcity.  
  
com
  
   
  
   
  
   07/06/2001  
  
10:56 AM   
  
   Please  
  
respond to 
  
ORACLE-L   
  
   
  
   
  




Look out, you may go blind !!

:-)

-Original Message-
Sent: 06 July 2001 14:57
To: Multiple recipients of list ORACLE-L


I agree, I love my Palm:)

-Original Message-
Smith
Sent: Thursday, July 05, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L


But you can play games on them.  I actually used to think the same way
until
the company agreed to by me one.  Since I use Outlook so much they are
actually
quite nice to have.  Now, instead of carrying a day timer I carry a Palm.
Makes
life easier for me.  Now I am going to go get the software to hook it up
to my GPS.

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


Ross,

What I was talking about is the added expense of wireless connectivity
for a
PDA.  Personally I don't own a PDA and have no desire to do so.

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   7/5/2001 11:19 AM

While i don't shared  DG's feelings
about the size and resource consumption
of the PocketDBA, I do share his feelings about the cost of the wireless
access.

Around here, Ricochet for the Palm PDA
runs about 50$ a month or so. What bullsh*t!

When I get wireless for an additional 10$ a month, I'll jump at it.

Until then, if my company thinks RF'ing in with my PDA is any different
than
coming in with T1+ speed broadband, i
am sure they'll let me know



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


Where I am the amount is zero as we all have remote access from home
already.
What one can quantify is the amount of extra $ it costs for a VPN dial-up
line
vs. the wireless connectivity this monster requires.  Now that comes to
something (what I am not privy to), so good-bye PocketDBA.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/5/2001 10:21 AM


If only it were this simple:

 ..quantify the amount of time and money their companies would
save if their DBAs.could remotely...
 remove from the database a user who is running a command that is
holding up the system.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002





Grabowy,


Chris   To: Multiple recipients of
list
ORACLE-L [EMAIL PROTECTED]
cgrabowy@fcgcc:


.comSubject: OT: Ari and his
company
have been noted in InfoWorld...
Sent by:


root@fatcity.


com








07/05/2001


01:01 PM


Please


respond to


ORACLE-L












Ari and his company have been noted in InfoWorld...


EPHRAIM SCHWARTZ  Wireless World InfoWorld.com


Thursday, July 5, 2001

REDUCING THE COST OF DBAS

Posted at June 29, 2001 01:01 PM PST Pacific


I'LL LEAVE IT to my readers to quantify the amount of
time and money their companies would save if their
DBAs (database administrators) could

Using data dictionary tables to manage application

2001-07-06 Thread Johnson Poovathummoottil


Hi All,

Our Application design group is designing an
application which looks in to data ditionary tables
for roles granted to the user who logs in and decide
which web pages he can view.

The only problem we foresee is the if oracle changes
the data dictionary then the application too needs
change.

Has anyone does this before?
Any hidden problems seen due to this?

We have suggested them to create another table to do
this instead of the oracle table. 



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

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

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

RE: OT: Just chatter about Wireless costs and PocketDBA

2001-07-06 Thread Robertson Lee - lerobe


Look out, you may go blind !!

:-)

-Original Message-
Sent: 06 July 2001 14:57
To: Multiple recipients of list ORACLE-L


I agree, I love my Palm:)

-Original Message-
Smith
Sent: Thursday, July 05, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L


But you can play games on them.  I actually used to think the same way until
the company agreed to by me one.  Since I use Outlook so much they are
actually
quite nice to have.  Now, instead of carrying a day timer I carry a Palm.
Makes
life easier for me.  Now I am going to go get the software to hook it up
to my GPS.

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


Ross,

What I was talking about is the added expense of wireless connectivity
for a
PDA.  Personally I don't own a PDA and have no desire to do so.

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   7/5/2001 11:19 AM

While i don't shared  DG's feelings
about the size and resource consumption
of the PocketDBA, I do share his feelings about the cost of the wireless
access.

Around here, Ricochet for the Palm PDA
runs about 50$ a month or so. What bullsh*t!

When I get wireless for an additional 10$ a month, I'll jump at it.

Until then, if my company thinks RF'ing in with my PDA is any different than
coming in with T1+ speed broadband, i
am sure they'll let me know



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


Where I am the amount is zero as we all have remote access from home
already.
What one can quantify is the amount of extra $ it costs for a VPN dial-up
line
vs. the wireless connectivity this monster requires.  Now that comes to
something (what I am not privy to), so good-bye PocketDBA.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/5/2001 10:21 AM


If only it were this simple:

 ..quantify the amount of time and money their companies would
save if their DBAs.could remotely...
 remove from the database a user who is running a command that is
holding up the system.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002





Grabowy,


Chris   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
cgrabowy@fcgcc:


.comSubject: OT: Ari and his
company
have been noted in InfoWorld...
Sent by:


root@fatcity.


com








07/05/2001


01:01 PM


Please


respond to


ORACLE-L












Ari and his company have been noted in InfoWorld...


EPHRAIM SCHWARTZ  Wireless World InfoWorld.com


Thursday, July 5, 2001

REDUCING THE COST OF DBAS

Posted at June 29, 2001 01:01 PM PST Pacific


I'LL LEAVE IT to my readers to quantify the amount of
time and money their companies would save if their
DBAs (database administrators) could remotely, and
wirelessly, make changes to their databases. Imagine
the efficiencies in not having to call a DBA back to
the office to add table space to a database, look at
what indexes exist and modify table structures, give a
new password to a user who has forgotten it, or remove
from the database a user who is running a command that
is holding up the system.

You can accomplish these and many other corrective
measures using the application PocketDBA, available
from the company of the same name.

I spoke with Ari Kaplan, CEO and co-founder of
PocketDBA, in Chicago. His background includes 10
years at Oracle, where he oversaw the implementation
of some of the largest Oracle database deployments in
the world, such as Hallmark's Web site and Merck's
entire order-entry and inventory system. Kaplan
believes his company's wireless DBA package is more
robust than Oracle's own desktop Enterprise Manager.

PocketDBA, which can currently be implemented on a Palm
OS device and will soon be available for Pocket PCs,
will appear for Microsoft's SQL Server and IBM's DB2
next year.

Go to http://www.pocketdba.com for a demo.

Fed up with ActiveSync

Remember two weeks ago when I said that I did not want
work-arounds to my problem in which ActiveSync did not
recognize the USB ports on three separate computers
(see Wireless World, June 18)? Here's a typical
example of the e-mails I've received that prove my point.

I had a similar but intermittent problem with my iPaq
using ActiveSync on a Toshiba laptop, one reader
wrote. I installed the Compaq ROM BIOS update last
month and haven't seen the problem since.

The update is Version 1.77, and you can download it from

Re: Oracle9i on Suse Linux




Jonathan,

I saw almost exactly the same thing with 512MB , 512MB swap, Suse Linux 7.1
also..
Some stuff that springs to mind:
Did you dynamically change the SHMMAX setting before the install and if so, did
you make the same change once the machine had rebooted?
When you're prompted for the JDK location don't you specify the location of the
Blackdown JDK files?

This is from memory with no way to check so excuse any mistakes =)

Regards,

Mike


|+---
||  Jonathan |
||  Gennick  |
||  jonathan@gen|
||  nick.com|
||   |
||  07/06/01 |
||  03:35 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: Multiple recipients of list ORACLE-L |
  |   [EMAIL PROTECTED]   |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: Oracle9i on Suse Linux  |
  |




I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB
swap), and ran into a bit of a snag. The install ran fine
until the end when the database creation assistant attempted
to start the seed database. At that point I received an
ORA-03113: End of File on Communication Channel error, and
my Linux box froze up. Having Linux freeze up is a pretty
rare event in itself, but I'm really wondering what caused
the error. After rebooting, I was able to run the database
creation assistant, create another database, and start that
one. I then tried to manually start the seed database, and
received the same ORA-03113 error. Could this somehow be
related to memory? Was it too much to have the installer and
the creation assistant running at the same time?

A couple of other oddities I noticed:

During the install, I was asked to specify a location for
a JDK. I dutifully created a directory and typed in its
path, but the installer never actually put any files into
it. Why did it ask me for a directory that it wasn't going
to use?

When I run the oraenv script, it doesn't create an
ORACLE_HOME environment variable. Instead of adding
$ORACLE_HOME/bin to my path, it adds the full path to the
bin directory. Is $ORACLE_HOME going away?

Best regards,

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

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

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

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




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

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

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

Standby Database

2001-07-06 Thread Richard Huntley


Just wondering if anyone sees any problems with creating a second instance
and DB on a standby database server that would be used for reporting
querying against a small dataset???  Running the standby DB in read only
mode is not an option since I'm applying archived logs every 10 minutes.  If
anyone knows of any issues with doing this, could you please let me know.

TIA,
Richard Huntley

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

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

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

2001-07-06 Thread Mercadante, Thomas F

Title: RE: * Oracle DBA Needed in Phoenix..

Lisa,
imitating a bird...

"Cheap! Cheap Cheap Cheap
"

next
will be "I taught I taw a puddy-tat"

Tom Mercadante Oracle Certified Professional

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Friday, July 06, 2001 9:57
AMTo: Multiple recipients of list ORACLE-LSubject: RE: *
Oracle DBA Needed in Phoenix..
Cheap! Cheap Cheap Cheap
$75,000? To move
across the country with MINIMAL relo? Are they kidding??
I hope this isn't our parent
company
Happy Friday everyone!
Lisa, the anti-recruiter
ninja

-Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 9:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: * Oracle DBA Needed in Phoenix..
orastaff wrote:
We would like to submit someone who is a
renter and who is interested in
Phoenix but has not applied to Phoenix companies and is not working
with other recruiters for Phoenix companies.
Is this some super secret job or
what???
-Original Message- Sent: Thursday, July 05, 2001 3:15 PM To: Multiple recipients of list ORACLE-L
If you're interested in a great opportunity, then
consider this position in Phoenix, AZ
with a leading company that needs an
Oracle DBA to join its' I.T. staff. We
would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix
companies and is not working with other
recruiters for Phoenix companies.
This is a full time staff position so no
sub-contractors or third parties please.
Please do not call or send a resume if you are
not in the U.S. and/or need sponsorship.
* Requirements: - A degree in C.S. or equivalent -
3+ yrs Oracle DBA experience is needed -
Strong Unix - Application development
experience; Unix scripting; C or Perl languages are desirable - Must have
good communication skills -U.S.
citizenship or permanent residency required
This position is with a company that offers
:
* Quality Work Environment
* Base salary up to 75K-firm +excellent benefits
* Financial Stability
* Some Relocation Assistance
NO sub contracting positions
available. PLEASE do not send your resume
if you are not in the United States.
For immediate consideration, please send
your resume to:
Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/Phoenix/DBA/Carlos
We pay referral fees. So please contact me if you know of anyone who would be
qualified/interested in the
posiitiondescribed above- if it is not a match for your skills.
Thanks, Bill
Law OraStaff, Inc-"The Proven Connection
To Oracle Opportunity"
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff
INET: [EMAIL PROTECTED]
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 San Diego, California --
Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also send the HELP command for other information (like
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Author:
Farnsworth, Dave INET:
[EMAIL PROTECTED]
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 San Diego, California --
Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also send the HELP command for other information (like
subscribing).

RE: Range partition

2001-07-06 Thread Khedr, Waleed


Your partition key would be activity_year,week_num

-Original Message-
Sent: Friday, July 06, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


Hello,

Oracle 8.1.7 on Sun Solaris

Scenario: We have a table where we store the consolidated weekly numbers on
the number of disconnects, reconnects, transfers etc. Our business week is
from Wednesday to Tuesday and so each week has a number assigned to it.
Also, the week doesn't span across months. So we have a total of 63 weeks
for 2001. The table stucture is as follows:

 activity_year  number(4),
number(2),
 company_code   varchar2(10),
 channel_code   varchar2(20),
 spectrum_code  varchar2(4),
 subscriber_codevarchar2(6),
 bopnumber(10),
 initial_addnumber(10),
 volun_disc number(10),
 involun_disc   number(10).

I need to partition this table in such a way that the data for a given year
and week number should go to a specific partition. Searched Metalink and
Oracle docs but didn't get an answer.

Is there a way to accomplish this without adding a date column to this
table?

TIA

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

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

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

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

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

RE: OT: Just chatter about Wireless costs and PocketDBA


Ahhh yesI knew someone would say that:)  Get your minds out of the
gutter dba's:)
KK

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L


Look out, you may go blind !!

:-)

-Original Message-
Sent: 06 July 2001 14:57
To: Multiple recipients of list ORACLE-L


I agree, I love my Palm:)

-Original Message-
Smith
Sent: Thursday, July 05, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L


But you can play games on them.  I actually used to think the same way until
the company agreed to by me one.  Since I use Outlook so much they are
actually
quite nice to have.  Now, instead of carrying a day timer I carry a Palm.
Makes
life easier for me.  Now I am going to go get the software to hook it up
to my GPS.

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


Ross,

What I was talking about is the added expense of wireless connectivity
for a
PDA.  Personally I don't own a PDA and have no desire to do so.

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   7/5/2001 11:19 AM

While i don't shared  DG's feelings
about the size and resource consumption
of the PocketDBA, I do share his feelings about the cost of the wireless
access.

Around here, Ricochet for the Palm PDA
runs about 50$ a month or so. What bullsh*t!

When I get wireless for an additional 10$ a month, I'll jump at it.

Until then, if my company thinks RF'ing in with my PDA is any different than
coming in with T1+ speed broadband, i
am sure they'll let me know



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


Where I am the amount is zero as we all have remote access from home
already.
What one can quantify is the amount of extra $ it costs for a VPN dial-up
line
vs. the wireless connectivity this monster requires.  Now that comes to
something (what I am not privy to), so good-bye PocketDBA.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/5/2001 10:21 AM


If only it were this simple:

 ..quantify the amount of time and money their companies would
save if their DBAs.could remotely...
 remove from the database a user who is running a command that is
holding up the system.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002





Grabowy,


Chris   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
cgrabowy@fcgcc:


.comSubject: OT: Ari and his
company
have been noted in InfoWorld...
Sent by:


root@fatcity.


com








07/05/2001


01:01 PM


Please


respond to


ORACLE-L












Ari and his company have been noted in InfoWorld...


EPHRAIM SCHWARTZ  Wireless World InfoWorld.com


Thursday, July 5, 2001

REDUCING THE COST OF DBAS

Posted at June 29, 2001 01:01 PM PST Pacific


I'LL LEAVE IT to my readers to quantify the amount of
time and money their companies would save if their
DBAs (database administrators) could remotely, and
wirelessly, make changes to their databases. Imagine
the efficiencies in not having to call a DBA back to
the office to add table space to a database, look at
what indexes exist and modify table structures, give a
new password to a user who has forgotten it, or remove
from the database a user who is running a command that
is holding up the system.

You can accomplish these and many other corrective
measures using the application PocketDBA, available
from the company of the same name.

I spoke with Ari Kaplan, CEO and co-founder of
PocketDBA, in Chicago. His background includes 10
years at Oracle, where he oversaw the implementation
of some of the largest Oracle database deployments in
the world, such as Hallmark's Web site and Merck's
entire order-entry and inventory system. Kaplan
believes his company's wireless DBA package is more
robust than Oracle's own desktop Enterprise Manager.

PocketDBA, which can currently be implemented on a Palm
OS device and will soon be available for Pocket PCs,
will appear for Microsoft's SQL Server and IBM's DB2
next year.

Go to http://www.pocketdba.com for a demo.

Fed up with ActiveSync

Remember two weeks ago when I said that I did not want
work-arounds to my problem in which ActiveSync did not
recognize the USB ports on three separate computers
(see Wireless World, June 18)? Here's a typical
example of the e-mails I've received that prove my point.

I had a similar but intermittent problem with my iPaq
using ActiveSync on

Re: Oracle9i on Suse Linux

2001-07-06 Thread Jared Still



Jonathan,

SuSE 7.1 uses glibc 2.2, while previous versions used
version 2.1.  You can find the location of the patch to
fix this on both www.suse.com and at MetaLink.

Sorry, can't help with the other stuff, though I did
have problems with Java.  There's some MetaLink stuff
about that too.

Jared

On Friday 06 July 2001 07:35, Jonathan Gennick wrote:
 I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB
 swap), and ran into a bit of a snag. The install ran fine
 until the end when the database creation assistant attempted
 to start the seed database. At that point I received an
 ORA-03113: End of File on Communication Channel error, and
 my Linux box froze up. Having Linux freeze up is a pretty
 rare event in itself, but I'm really wondering what caused
 the error. After rebooting, I was able to run the database
 creation assistant, create another database, and start that
 one. I then tried to manually start the seed database, and
 received the same ORA-03113 error. Could this somehow be
 related to memory? Was it too much to have the installer and
 the creation assistant running at the same time?

 A couple of other oddities I noticed:

 During the install, I was asked to specify a location for
 a JDK. I dutifully created a directory and typed in its
 path, but the installer never actually put any files into
 it. Why did it ask me for a directory that it wasn't going
 to use?

 When I run the oraenv script, it doesn't create an
 ORACLE_HOME environment variable. Instead of adding
 $ORACLE_HOME/bin to my path, it adds the full path to the
 bin directory. Is $ORACLE_HOME going away?

 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Batch updates

2001-07-06 Thread O'Neill, Sean


I'd appreciate hearing from folk what solutions there are for the
following scenario.  Users with laptops want to be able to input data whilst
not connected to database for subsequent upload to database.  Apart from
developing PL/SQL code to realise this functionality with associated
integrity checks etc. are there other possible (3rd party) solutions?

If database was small enough there has been some notion of copying database
to laptop and subsequently re-synchronising when connecting to central
database.  Are there solutions out there for this?

I've a sneaking suspicion the solution to this is hidden in the caverns of
my memory but it ain't coming out!

Thanx in advance for anyone who takes time to reply :)


Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King

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

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

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

2001-07-06 Thread akuerten



May they bought you already, keep the HP example in mind...




Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 06.07.2001
15:56:40

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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




Cheap!  Cheap Cheap Cheap 
$75,000?  To move across the country with MINIMAL relo?
Are they kidding??

I hope this isn't our parent company

Happy Friday everyone!
Lisa, the anti-recruiter ninja

   -Original Message-
   From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
   Sent:   Friday, July 06, 2001 9:11 AM
   To: Multiple recipients of list ORACLE-L
   Subject:    RE: * Oracle DBA Needed in Phoenix..

   orastaff wrote:

   We would like to submit someone who is a renter and who is interested
   in Phoenix but has not applied to Phoenix companies and is not working
   with
   other recruiters for Phoenix companies.

   Is this some super secret job or what???

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

   If you're interested in a great opportunity, then consider this position
   in
   Phoenix, AZ
   with a leading company that needs an Oracle DBA to join its' I.T. staff.
   We would like to submit someone who is a renter and who is interested
   in Phoenix but has not applied to Phoenix companies and is not working
   with
   other recruiters for Phoenix companies.

   This is a full time staff position so no sub-contractors or third
   parties
   please.

   Please do not call or send a resume if you are not in the U.S. and/or
   need
   sponsorship.

   * Requirements:
   - A degree in C.S. or equivalent
   - 3+ yrs Oracle DBA experience is needed
   - Strong Unix
   - Application development experience; Unix scripting; C or Perl
   languages
     are desirable
   - Must have good communication skills
    -U.S. citizenship or permanent residency required

   This position is with a  company that offers :
       * Quality Work Environment
       * Base salary up to 75K-firm +excellent benefits
       * Financial Stability
       * Some Relocation Assistance

   NO sub contracting positions available.
   PLEASE do not send your resume if you are not in the United States.

   For  immediate consideration, please send your resume to:

   Email: [EMAIL PROTECTED]
   Phone: 1-800-549-8502.
   * Please use job code: One/Phoenix/DBA/Carlos

   We pay referral fees.
   So please contact me if you know of anyone who would be
   qualified/interested
   in the posiition described above- if it is not a match for your skills.
   Thanks,
   Bill Law
   OraStaff, Inc-The Proven Connection To Oracle Opportunity


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

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

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





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

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

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

Re: OT: Learning Curve for Informatica ETL Products

2001-07-06 Thread Jared Still



I just gave it disk space and largely ignored it.

Never had a problem with it.

Jared


On Friday 06 July 2001 06:46, Farnsworth, Dave wrote:
 This is true, unless of course it is running on Ardent's UniData or
 Universe database.  That is something else to work with.

 Dave

 -Original Message-
 Sent: Friday, July 06, 2001 1:15 AM
 To: Multiple recipients of list ORACLE-L



 Larry,

 I took several training courses last year for one of their
 competitors products, Ardent Datastage, though it's called
 something else now.

 Anyway, they're very similar, we evaluated Informatica also.

 They are both very powerful products.  If my experience with
 the Ardent products is any indication, you shouldn't have any
 trouble learning these tools.

 The technology underneath is not anything special, their power
 lies in their management and organizational abilities.  Building
 ETL processes with these tools is much easier than doing it
 all with an editor and a command line.

 Complex tasks still require programming, but it's within their
 IDE and easily managed.  I'm not normally a fan of GUI tools
 but good ETL tools are an exception.

 Jared

 On Thursday 05 July 2001 17:07, Larry Elkins wrote:
  Listers,
 
  For any of you who use Informatica ETL products such as PowerMart and/or
  PowerCenter, how steep is the learning curve for these products? I know
  there are lots of variables such as how quickly does the person pick up

 new

  things, are we talking about learning the basics and doing simple tasks,
  or, doing advanced things, etc. For example, with some products, one can
  quickly learn to perform basic functions, but, there can be a steep
  learning curve to perform advanced functions.
 
  Just curious about the complexity and ease/difficulty of getting up to
  speed on these tools.
 
  Regards,
 
  Larry G. Elkins
  [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: OT: friday rambelings....

2001-07-06 Thread JOE TESTA




for the weakest link, depends on how the DBAs are up 
against. Duhvelopers?, Damagement.

now dont all you developers get offended, unless of course the 
title fits :)

bye all, i'm off to camping for the weekend, no cell, no 
pager, no laptop, first time in like 7 years, i'll be totally disconnected, just 
me, my family, friends, tent, fire and beer.

joe

 [EMAIL PROTECTED] 07/06/01 12:27PM 
having watched both weakest link and who wants to be i 
wonder how theDBA crowd would fair on them?--Bill "Shrek" 
Thater Certifiable ORACLE DBATelergy, 
Inc. 
[EMAIL PROTECTED]~~You 
gotta program like you don't need the money,You gotta compile like you'll 
never get hurt,You gotta run like there's nobody watching,It's gotta 
come from the heart if you want it to 
work.~~one ping to rule them 
all, one ping to find them, one ping to bring themall, and in the darkness 
bind them.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Thater, 
William INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

Re: Where is the lock?

2001-07-06 Thread Chaim . Katz




Sean,

A  lock would normally go away when the database is shut down, but if the
problem was in the application (or the users), the lock would probably come
right back again.
Check In v$lock  for type  TX  locks with lmode=6 . These are exclusive row
locks caused by updates or select for update, inserts or deletes.  If you see
any of these you're on the right path.  (The column ctime shows how long the
lock was held in seconds)

The session thats reporting the error might not have any rows in v$lock, because
they  probably did a select for update nowait. In otherwords they checked to see
if the row they wanted to update was locked and because it was,  they returned
control to the interactive user instead of requesting a lock. You could check
the row_wait_obj# in v$session which will have the object id of the table that
the select for update was issued against. Sessions that didn't wait will have a
value of  -1 , sessions that did wait will have the  object_id in dba_objects.

Run-away sessions are less common now than they used to be. I guess when you
shut down the database, if you stopped the Oracle service (NT) or killed all the
oracle processes you would be sure that there aren't any of them around (unless
it was coming over a db link?)

Hope this is a bit of help to you.

Chaim




O'Neill, Sean [EMAIL PROTECTED] on 07/05/2001 11:55:55 AM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)




On of our applications is reporting a problem trying to access on a record
in a table.  The application is reporting that a transaction is reserved for
update.  The app in question hung whilst working on the record a few days
ago.  I'm not convinced that this is an Oracle problem, i.e. a row lock of
some sort, as I've had a peek at DB level via v$lock and v_$locked_object,
v$access but can't seem to find any locks on the table in question.  If it
is an Oracle lock of some type how can I identify it?.  The database gets
shutdown every night for COLD backups but the app prog in question is
reporting problem for number of days now.  Is it possible that some session
might still be haunting around?.

Would appreciate any advice/help on this one folks?.


Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
 
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King

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

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

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






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

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

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

Re[2]: OFA (Optimal Flexible Architecture) in practice

2001-07-06 Thread dgoulet


IMHO I think you all have got the reasons for OFA somewhat backwards.  Back in
the older days one had one and only one version of Oracle running on a
particular machine at one time.  This made upgrading/migrating or running a new
version in test while the older one was still running production absolutely
impossible or at least very difficult.  The idea around OFA is that you have one
or more Oracle home directories off of Oracle base and all of your data files
elsewhere.  Now when it comes time to upgrade you just shutdown, backup the
datafile area, move a couple of init or cfg files, startup, run the scripts
required, shutdown  backup the same directory(s) again.

Dick Goulet

Reply Separator
Author: Tim Gardner [EMAIL PROTECTED]
Date:   7/5/2001 5:15 PM

Does anyone use OFA as their company standard?  If so, are there any
complaints about it's structure?  For example, the commingling of
different database subdirectories under a given mount point?

e.g..

/u02/oradata/db_name1/userdata01.dbf
/u02/oradata/db_name2/userdata01.dbf
/u03/oradata/db_name1/userdata02.dbf
/u03/oradata/db_name2/userdata02.dbf

You cannot cd to a given subdirectory, ls -ltR | more to see all the
datafiles associated with a given database.  Instead, from / you
have to ls -ltR | grep db_name1 to scan the full file system.  Seems
like there should be a better way.

Any input, pro or con, is appreciated.

Linda,

The point of OFA is to spread out the database over different drives 
for performance reasons.  For example, you might want to separate 
indexes from data.  Would what you are proposing allow for multiple 
drives?

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

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

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

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

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

Re: Oracle9i on Suse Linux




Jared,

Oracle 9i is certified with Suse 7.1 out of the box. It specifically needs the
2.4.4 kernel and glibc 2.2.
There should be no need for any patches.

Regards,
Mike




|+---
||  Jared Still  |
||  jkstill@cybc|
||  on.com  |
||   |
||  07/06/01 |
||  04:41 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: Re: Oracle9i on Suse Linux  |
  |





Jonathan,

SuSE 7.1 uses glibc 2.2, while previous versions used
version 2.1.  You can find the location of the patch to
fix this on both www.suse.com and at MetaLink.

Sorry, can't help with the other stuff, though I did
have problems with Java.  There's some MetaLink stuff
about that too.

Jared

On Friday 06 July 2001 07:35, Jonathan Gennick wrote:
 I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB
 swap), and ran into a bit of a snag. The install ran fine
 until the end when the database creation assistant attempted
 to start the seed database. At that point I received an
 ORA-03113: End of File on Communication Channel error, and
 my Linux box froze up. Having Linux freeze up is a pretty
 rare event in itself, but I'm really wondering what caused
 the error. After rebooting, I was able to run the database
 creation assistant, create another database, and start that
 one. I then tried to manually start the seed database, and
 received the same ORA-03113 error. Could this somehow be
 related to memory? Was it too much to have the installer and
 the creation assistant running at the same time?

 A couple of other oddities I noticed:

 During the install, I was asked to specify a location for
 a JDK. I dutifully created a directory and typed in its
 path, but the installer never actually put any files into
 it. Why did it ask me for a directory that it wasn't going
 to use?

 When I run the oraenv script, it doesn't create an
 ORACLE_HOME environment variable. Instead of adding
 $ORACLE_HOME/bin to my path, it adds the full path to the
 bin directory. Is $ORACLE_HOME going away?

 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Index Behaviour

2001-07-06 Thread Dave Leach


Hi,

In the following query membno is a Non Unique Indexed field:

select surnam from basic where membno  10.

Whether the table is analyzed or not the Explain Plan still shows a Full
Table Scan unless I specify a Hint to use the Index.  Using the index is
more costly so I would expect CBO to always do a FTS unless the hint is
specified.  But without a hint why does RBO do a FTS and ignore the index?

Platform NT
Version 8.1.7.0.0
Optimizer Mode is Choose:

Many thanks for any replies

Dave Leach

PS.  Like the Bear stories, being brought up in London we miss out on all
this.



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

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

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

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

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

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

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

Re: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread kjanusz


With our current economic conditions it's a buyer's 
market.  
 
 Peter,
 
 It probably means that they're willing to relocate someone
 but don't want to pay a ton of money to relocate someone
 who owns a house.  There can be more than $10,000 worth
 of closing costs, moving costs, guarantee to buy your house
 if it doesn't sell, etc.
 
 Renters are simpler and cheaper to relocate.
 
 Chere
 
 
  
 
 Peter
 
 fbsdq@yahoo.To: Multiple recipients of list 
 ORACLE-L [EMAIL PROTECTED]  
 com cc: 
 
 Sent by: Subject: Re: * Oracle DBA Needed in 
 Phoenix..
 root@fatcity.
 
 com  
 
  
 
  
 
 07/05/01 
 
 05:17 PM 
 
 Please   
 
 respond to   
 
 ORACLE-L 
 
  
 
  
 
 
 
 
 
 
 
 On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying:
 
 
 . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote:
 . . . .|O We would like to submit someone who is a renter and who is
 interested
 . . . .|O in Phoenix but has not applied to Phoenix companies and is not
 working with
 . . . .|O other recruiters for Phoenix companies.
 . . . .|
 . . . .|Now why in the world would any of this matter?
They are trying to get more people into Phoenix, and they
 have invested in apartment buildings.
 
 But seriously that is kinda weird.
 
 . . . .|
 www.nul.cjb.net
 www.FreeBSD.org
 
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Peter
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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


Mercadante, Thomas F wrote:
 
 Lisa, imitating a bird...
 
 Cheap!  Cheap Cheap Cheap  
 
 
 next will be I taught I taw a puddy-tat

i DID, i did see a puddy-tat!;-)

--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
one ping to rule them all, one ping to find them, one ping to bring them
all, and in the darkness bind them.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

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

RE: strange explain plan

2001-07-06 Thread Dave Leach


Gene,

This is not much help I'm afraid but are the statistics etc on both the old
and new table at the same stage (preferrable both up to date)?.  

I've tried to recreate this on NT with no success, 

keep me informed.

Dave Leach
-Original Message-
Sent: 06 July 2001 14:36
To: Multiple recipients of list ORACLE-L


Hi.

This is a second attempt. My first Email never got
posted.

I have the following query:

select a1.MBR_TYP_CDE MBR_TYP_CDE,
 (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD ))  
DISTINCTALLMERCHCO
 from MDSS_STAR.NOVUS_NETWRK_MBR_D a1
group by a1.MBR_TYP_CDE

The explain plan for it is as follows:


0-0-5898 1.5898 SELECT STATEMENTSQL1 Cost = 5898
1-0-1  2.1 SORT GROUP BY
2-1-1   3.1 SORT GROUP BY
3-2-14.1 SORT GROUP BY
4-3-1 5.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D


It has three group by's and the query fails with
0ra-0600 [15851]. 

when I create a new table as select * from the old
table the plan changes:

0-0-9721 1.9721 SELECT STATEMENTSQL1 Cost = 9721
1-0-1  2.1 SORT GROUP BY
2-1-1   3.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D_TMP

and the query works. Does anyone have any guess as to
what is going on?

thank you for any help

Gene

=


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 above information is confidential to the addressee and may be 
privileged.  Unauthorised access and use is prohibited.

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

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

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

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

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

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

Re: Range partition

2001-07-06 Thread JOE TESTA




a multi-key partition will not work for you or am i missing 
something in the question?

joe, living on the bleeding edge trying to get stupid 
management server of OEM to work for 9i :)
 [EMAIL PROTECTED] 07/06/01 10:26AM 
Hello,Oracle 8.1.7 on Sun SolarisScenario: We 
have a table where we store the consolidated weekly numbers onthe number of 
disconnects, reconnects, transfers etc. Our business week isfrom Wednesday 
to Tuesday and so each week has a number assigned to it.Also, the week 
doesn't span across months. So we have a total of 63 weeksfor 2001. The 
table stucture is as 
follows:activity_year 
number(4),week_num 
number(2),company_code 
varchar2(10),channel_code 
varchar2(20),spectrum_code 
varchar2(4),subscriber_code 
varchar2(6),bop 
number(10),initial_add 
number(10),volun_disc 
number(10),involun_disc 
number(10).I need to partition this table in such a way that the 
data for a given yearand week number should go to a specific partition. 
Searched Metalink andOracle docs but didn't get an answer.Is there a 
way to accomplish this without adding a date column to 
thistable?TIAPrakash-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Bala, Prakash INET: [EMAIL PROTECTED]Fat 
City Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

OT: friday rambelings....


having watched both weakest link and who wants to be  i wonder how the
DBA crowd would fair on them?

--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
one ping to rule them all, one ping to find them, one ping to bring them
all, and in the darkness bind them.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

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

Re: sqlplus command

2001-07-06 Thread Yosi Greenfield


Milind,

You can't do sqlplus from procedures. There are some ways
to get output from pl/sql. One is to use the dbms_output package,
which does send output to a sqlplus session if you have set
serveroutput on.

Another idea that's used might be to put your output lines into
a staging table, each record containing a field with the sequence
number of that line in the output. Then when the procedure
finishes populating that table, simply select the data from the
staging table. (Oracle 8i global temporary tables are good for
that too.)

Good luck,

y


milind ambegaoker wrote:

 Dear mailing list,
 is it possible to execute SQLPLUS commands from
 subprograms like procedures and functions ?
 If possible pl. send me how to do it  ?
 If not please tell me why and alternate way
 as i want to write sub programs(procedures) that would
 generate reports on the SQL prompt by using the
 SQLPLUS formatting commands.

 
 Do You Yahoo!?
 For regular News updates go to http://in.news.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?milind=20ambegaoker?=
   INET: [EMAIL PROTECTED]

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

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


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

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

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

Re: Standby Database

2001-07-06 Thread JOE TESTA




Rich, no problems other than, the "performance" issue, if they 
are hitting it hard and oracle lags in trying to post the logs to the standby 
database.

other than that it should be fine.

Joe

 [EMAIL PROTECTED] 07/06/01 11:27AM 
Just wondering if anyone sees any problems with creating a 
second instanceand DB on a standby database server that would be used for 
reportingquerying against a small dataset??? Running the standby DB in 
read onlymode is not an option since I'm applying archived logs every 10 
minutes. Ifanyone knows of any issues with doing this, could you 
please let me know.TIA,Richard Huntley-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard 
Huntley INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

Re: Using data dictionary tables to manage application

2001-07-06 Thread paquette stephane


I have use Oracle data dictionnary tables and packages
. Just make sure you encapsulate them with views and
your own packages in order to be more independant.


 --- Johnson Poovathummoottil [EMAIL PROTECTED] a
écrit :  Hi All,
 
 Our Application design group is designing an
 application which looks in to data ditionary tables
 for roles granted to the user who logs in and decide
 which web pages he can view.
 
 The only problem we foresee is the if oracle changes
 the data dictionary then the application too needs
 change.
 
 Has anyone does this before?
 Any hidden problems seen due to this?
 
 We have suggested them to create another table to do
 this instead of the oracle table. 
 
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Johnson Poovathummoottil
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

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

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

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

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

RE: Range partition

2001-07-06 Thread Bala, Prakash


Waleed, I have already tried this approach. The data didn't go to the right
partition. Oracle is just using the first column to determine the partition.

Thanks
Prakash

-Original Message-
Sent: Friday, July 06, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L


Your partition key would be activity_year,week_num

-Original Message-
Sent: Friday, July 06, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


Hello,

Oracle 8.1.7 on Sun Solaris

Scenario: We have a table where we store the consolidated weekly numbers on
the number of disconnects, reconnects, transfers etc. Our business week is
from Wednesday to Tuesday and so each week has a number assigned to it.
Also, the week doesn't span across months. So we have a total of 63 weeks
for 2001. The table stucture is as follows:

 activity_year  number(4),
number(2),
 company_code   varchar2(10),
 channel_code   varchar2(20),
 spectrum_code  varchar2(4),
 subscriber_codevarchar2(6),
 bopnumber(10),
 initial_addnumber(10),
 volun_disc number(10),
 involun_disc   number(10).

I need to partition this table in such a way that the data for a given year
and week number should go to a specific partition. Searched Metalink and
Oracle docs but didn't get an answer.

Is there a way to accomplish this without adding a date column to this
table?

TIA

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

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

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

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

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

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

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

Rollback usage


Hi All,
Does anyone have a script or know of a way to determine which user is using
which rollback segment?  I had a developer issue a set transaction before
she started a migration and I wanted to see if I could make sure that she
was using the proper rollback segment.  Thanks a lot:)

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

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

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

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

RE: Rollback usage

2001-07-06 Thread Terrian, Tom


I believe that I got this off of this list a while back...

clear columns
column rbs format A7 heading 'RBS'
column ora_usr format a10
column program format a39
column sid format 
select r.name rbs,
   s.sid  SID,
   substr(osuser,1,10) os_user,
   nvl(s.username, ' -- ') ora_usr,
   s.program 
from v$lock l, v$session s, v$rollname r
where l.sid = s.sid(+) and
  trunc(l.id1(+)/65536) = r.usn  and
  l.type(+) = 'TX' and
  l.lmode (+) = 6
order by r.name;



Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Friday, July 06, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L


Hi All,
Does anyone have a script or know of a way to determine which user is
using
which rollback segment?  I had a developer issue a set transaction before
she started a migration and I wanted to see if I could make sure that she
was using the proper rollback segment.  Thanks a lot:)

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

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

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

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

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

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

RE: Standby Database

2001-07-06 Thread Jack C. Applewhite


Richard,

As long as the 2nd instance doesn't interfere with the application of
archived redo logs to the standby, I don't see a problem.

I routinely use the extra CPU available on our standby server (Win2K) to zip
up exports from production and other, similar tasks that would otherwise put
extra load on our production server.

Jack


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


-Original Message-
Huntley
Sent: Friday, July 06, 2001 10:28 AM
To: Multiple recipients of list ORACLE-L


Just wondering if anyone sees any problems with creating a second instance
and DB on a standby database server that would be used for reporting
querying against a small dataset???  Running the standby DB in read only
mode is not an option since I'm applying archived logs every 10 minutes.  If
anyone knows of any issues with doing this, could you please let me know.

TIA,
Richard Huntley


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

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

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

notification of password expiration?

2001-07-06 Thread Paul Sheahan





Hello all,

Can anyone share any ideas on this?
 We 
have a procedure in our Oracle databases that forces a user to change there 
password after x number of days. This password procedure also forces them 
to use num-alpha characters. Our lead Oracle admin turned off the 
procedure because Oracle was not notifying users when their password was going 
to expire and once it did it would not let them in.I was hoping that 
with 8i there would be some improvements to the way Oracle handled expiring 
passwords. Does anyone know or use a workaround for this? We would like to 
set password expiration of 60 days on Oracle accounts but they need some type of 
notification so they aren't locked out

Thanks,
Paul

Re: How to implement and use DBMS_STATS?

2001-07-06 Thread Rachel Carmichael

Don Burleson just released (via Oracle Press) and entire BOOK on using 
STATSPACK.

From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How to implement and use DBMS_STATS?
Date: Fri, 06 Jul 2001 08:20:56 -0800

OK, enough is enough.  For a month now, I've been researching on how one is
supposed to implement and use the DBMS_STATS package.  The FMs I R'd, 
Oracle
8.1.7's Designing and Tuning for Performance and Supplied PL/SQL 
Packages
Reference, give the syntax and some very weak and incomplete examples, but
fail to define how a DBA is actually supposed to USE the package in
day-to-day operation.

And Oracle Support just keeps pointing me back to inane and unrelated
articles in MetaClink.

Can anyone point out a website or a good book with a chapter on using
DBMS_STATS for CBO?  Specifically, some good examples, some definitions
(when are stats considered stale?), what is the scope of
GATHER_DATABASE_STATS (does it stat SYS???), under what circumstances
GATHER_TABLE, GATHER_SCHEMA, and GATHER_DATABASE are to be used, and
generally how the hell one goes about implementing this.  I've now got less
than two weeks to figure it out!

And if you know this, where did you learn it?  Even my Oracle Perf Tuning
Class student guide mentions the package, says to use it, but then points 
to
the syntax-only Oracle docs for more info.  sigh

Frustratedly yours,
Rich Jesse  System/Database Administrator 
(wannabe?)
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice

2001-07-06 Thread Kip . Bryant


This was my memory as well.  I thought separating archive, redo, indexes, data
and so on predated OFA.  Also, I read through the comments pretty quickly but I
thought Oracle discouraged the use of symbolic links for data files.  I've seen
this done without trouble but isn't there some potential error that this might
trigger?  Seems to me there was some traffic on the list for this a while
back...

Ready to be wrong,
Kip

|IMHO I think you all have got the reasons for OFA somewhat backwards.  Back in
|the older days one had one and only one version of Oracle running on a
|particular machine at one time.  This made upgrading/migrating or running a new
|version in test while the older one was still running production absolutely
|impossible or at least very difficult.  The idea around OFA is that you have one
|or more Oracle home directories off of Oracle base and all of your data files
|elsewhere.  Now when it comes time to upgrade you just shutdown, backup the
|datafile area, move a couple of init or cfg files, startup, run the scripts
|required, shutdown  backup the same directory(s) again.

|Dick Goulet

|Reply Separator
|Author: Tim Gardner [EMAIL PROTECTED]
|Date:   7/5/2001 5:15 PM

|Does anyone use OFA as their company standard?  If so, are there any
|complaints about it's structure?  For example, the commingling of
|different database subdirectories under a given mount point?
|
|e.g..
|
|/u02/oradata/db_name1/userdata01.dbf
|/u02/oradata/db_name2/userdata01.dbf
|/u03/oradata/db_name1/userdata02.dbf
|/u03/oradata/db_name2/userdata02.dbf
|
|You cannot cd to a given subdirectory, ls -ltR | more to see all the
|datafiles associated with a given database.  Instead, from / you
|have to ls -ltR | grep db_name1 to scan the full file system.  Seems
|like there should be a better way.
|
|Any input, pro or con, is appreciated.

|Linda,

|The point of OFA is to spread out the database over different drives
|for performance reasons.  For example, you might want to separate
|indexes from data.  Would what you are proposing allow for multiple
|drives?

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

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

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

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

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

Re: Batch updates

2001-07-06 Thread Yosi Greenfield


We briefly thought of using Oracle Lite. It uses a subset of
replication and advanced queueing to do its magic. It looked
like it might have worked.

But, as we wanted to sell a product, Oracle Lite licensing
added like 300 bucks a seat to the product, so the boss
decided not to go with it.

Of course, 6 months later, that department is now dead,
there is NO product, including no product that would have
cost an extra 300 bucks.

Yosi

Guy Hammond wrote:

 Does Oracle Lite do this? I remember attending a seminar where Oracle
 were talking about running Lite on PDAs to support sales force
 automation. They could take orders and check inventory on their PDAs,
 query contacts and itineraries, etc, then it would replicate to real
 Oracle in one batch when they connected to dial-up every day. There was
 a mechanism for reconciling conflicts, for example if you had 100 units
 in stock, salesman A sold 50 and B sold 60, maybe customer A would get
 45 units and B 55 until new inventory was ready. That sort of thing.

 g

 -Original Message-
 Sent: Friday, July 06, 2001 4:41 PM
 To: Multiple recipients of list ORACLE-L

 I'd appreciate hearing from folk what solutions there are for the
 following scenario.  Users with laptops want to be able to input data
 whilst
 not connected to database for subsequent upload to database.  Apart from
 developing PL/SQL code to realise this functionality with associated
 integrity checks etc. are there other possible (3rd party) solutions?

 If database was small enough there has been some notion of copying
 database
 to laptop and subsequently re-synchronising when connecting to central
 database.  Are there solutions out there for this?

 I've a sneaking suspicion the solution to this is hidden in the caverns
 of
 my memory but it ain't coming out!

 Thanx in advance for anyone who takes time to reply :)

 Sean :)

 Rookie Data Base Administrator
 [0%] OCP Oracle8i DBA
 [0%] OCP Oracle9i DBA
  
 Organon (Ireland) Ltd.
 E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

 Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

 Nobody loves me but my mother... and she could be jivin' too.  - BB
 King

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

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

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

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


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

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

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

RE: RULE versus CHOOSE

2001-07-06 Thread Dennis Taylor


See http://www.sucs.swan.ac.uk/~arthur/jargon/html/The-Jargon-Lexicon.html


At 09:20 AM 7/6/01 -0800, you wrote:
Jon 

Great Answers Indeed .

What does IMHO stand for though ?

Thanks Again so much .

Vivek


 -Original Message-
 Sent: Friday, July 06, 2001 8:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
  Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ?
 
 There's a world of difference between them. Using the Cost-Based
 Optimizer
 (CBO) versus Rule-Based is like using a GPS system to navigate a city
 you've
 not been to in a while versus your own vague memories of it. In the
 latter
 case, you may only remember a few ways around and things may have
 changed
 dramatically. With the former, the current or near-current situation
 is
 always known if used properly.
 
  Qs.2 Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT
  having Any Statistics Existent on the Application Tables , Indexes ?
 
 Using CHOOSE without analyzing the relevant schemas is the same as
 using
 RULE because Oracle has no current map of the terrain to utilize.
 So, it
 falls back on the standard rules.
 
  Qs.3 Are there any Disadvantages with Using RULE in 8.1.7.0 ?
 
 Tons IMHO. Not in 8.1.7 in particular, but in general. Most databases
 are
 constantly changing with the addition, changing and removing of data.
 What
 the CBO offers is a roadmap to that changing data. Remember with the
 CBO
 that it is only as good as your statistics. In sites I work at, I
 recommend
 that relevant schemas are analyzed nightly to keep things current
 (btw,
 never analyze SYS). In conjunction with that, we create and update
 histograms on relevant columns in the application schemas to handle
 skewed
 data distributions.
 
  Qs.4 In Choose mode are there any Commonly known Standard Important
  Statistics' Fields/Values which can be Looked at to understand why
   optimizer took a particular path ?
  What Causes a Path to be Chosen in CHOOSE , we are largely ignorant
  about .
 
 This is difficult to explain and quite complex. There surely is a
 better
 authority than I to answer this here and MetaLink could probably
 enlighten
 you as well.
 
  NOTE - At a Customer's Database , Our Development Section Head wants
 to
  set optmizer_mode=RULE  keep it so . His Reasons :-
  - The path of the optimizer is more predictable when set to RULE
  - Any under-performance Issues would be Handled by Giving HINTS etc
  rather than Allowing the Optimizer to Choose / Compute it's own Path
  which may be a BAD One .
  - A Correct Path being Taken Today may in Time get Automatically
 Changed
  to a Worse Path somewhere in future (with the Stats getting OLD
 etc.) .
  - Lastly his Team will Take Responsibility for Any Performance
 Issues
  arising out of a Code underperforming .
 
 See what I said above about the changing face of data in a database.
 And
 what happens when his team changes? Are they always going to be there
 to
 handle the performance issues and keep on top of them? A correct path
 being
 taken today may in time get automatically changed is exactly the
 reason as
 far as I'm concerned to use the CBO. It takes the guesswork out of
 most
 query optimization if used properly.
 
  Qs Are there Any Best practices Documents / Links on RULE vs. CHOOSE
 ?
 
 I'm sure there are many other, but the biggies I work with are (1)
 analyze
 relevant schemas regularly, (2) create/maintain histograms on columns
 that
 have skewed data distributions and (3) don't analyze SYS.
 
  Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule
 Or
  Still Endeavour to persist for optimizer_mode=CHOOSE ?
 
 I would say persist in your argument for CHOOSE. The biggest reason to
 do it
 now IMHO is that, according to Oracle, RULE is going to be desupported
 in
 the near future. CHOOSE will soon be the default.
 
 Anyone with more experience than I here, please chime in.
 
 --
 
 Jon Walthour, OCDBA
 Oracle DBA
 Computer Horizons
 Cincinnati, Ohio
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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



Dennis Taylor

A contented man is one who enjoys the scenery along the detours.

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

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

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice


On Fri, 6 Jul 2001,[EMAIL PROTECTED] scribbled on the wall in glitter...:

-This was my memory as well.  I thought separating archive, redo, indexes, data
-and so on predated OFA.  Also, I read through the comments pretty quickly but I
-thought Oracle discouraged the use of symbolic links for data files.  I've seen
-this done without trouble but isn't there some potential error that this might
-trigger?  Seems to me there was some traffic on the list for this a while
-back...
-
-Ready to be wrong,
-Kip

too bad Cary isn't on the list to tell us what he had in mind when he designed
it.  anybody got his email address to forward him the question?;-)


--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
one ping to rule them all, one ping to find them, one ping to bring them all, and in 
the darkness bind them.

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

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

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

Re: Oracle9i on Suse Linux




9i?  I must have been thinking of my 8i install.

Sorry.

Jared



   
   
MHately@etech- 
   
uk.com   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
Sent by: cc:   
   
[EMAIL PROTECTED]   Subject: Re: Oracle9i on Suse Linux   
   
om 
   
   
   
   
   
07/06/01 09:52 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   






Jared,

Oracle 9i is certified with Suse 7.1 out of the box. It specifically needs
the
2.4.4 kernel and glibc 2.2.
There should be no need for any patches.

Regards,
Mike




|+---
||  Jared Still  |
||  jkstill@cybc|
||  on.com  |
||   |
||  07/06/01 |
||  04:41 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  
|

  |
|
  |   To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]  |
  |   cc: (bcc: Mike Hately/ETECH)
|
  |   Subject: Re: Oracle9i on Suse Linux
|
  
|






Jonathan,

SuSE 7.1 uses glibc 2.2, while previous versions used
version 2.1.  You can find the location of the patch to
fix this on both www.suse.com and at MetaLink.

Sorry, can't help with the other stuff, though I did
have problems with Java.  There's some MetaLink stuff
about that too.

Jared

On Friday 06 July 2001 07:35, Jonathan Gennick wrote:
 I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB
 swap), and ran into a bit of a snag. The install ran fine
 until the end when the database creation assistant attempted
 to start the seed database. At that point I received an
 ORA-03113: End of File on Communication Channel error, and
 my Linux box froze up. Having Linux freeze up is a pretty
 rare event in itself, but I'm really wondering what caused
 the error. After rebooting, I was able to run the database
 creation assistant, create another database, and start that
 one. I then tried to manually start the seed database, and
 received the same ORA-03113 error. Could this somehow be
 related to memory? Was it too much to have the installer and
 the creation assistant running at the same time?

 A couple of other oddities I noticed:

 During the install, I was asked to specify a location for
 a JDK. I dutifully created a directory and typed in its
 path, but the installer never actually put any files into
 it. Why did it ask me for a directory that it wasn't going
 to use?

 When I run the oraenv script, it doesn't create an
 ORACLE_HOME environment variable. Instead of adding
 $ORACLE_HOME/bin to my path, it adds the full path to the
 bin directory. Is $ORACLE_HOME going away?

 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com *
http://MetalDrums.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: OT Bears

2001-07-06 Thread Marc Perkowitz


Keep in mind that many many animals only still exist at all because of zoos.
And unfortunately that will continue to be more and more true in the future.
I much prefer my animals wild as well, but I'd rather see them then not see
them at all.

Marc Perkowitz.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 9:16 AM


 Won't go to zoos on principal !!

 nuff said.


 -Original Message-
 Sent: 06 July 2001 13:05
 To: Multiple recipients of list ORACLE-L


 Closest I've ever come to a bear was when I was on holiday a few weeks ago
 in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
 cage.. Not the same as seeing them in their natural environment at all I
 guess..:)

 The one truly amazing animal they had there though was the worlds only
 (known) albino gorilla!! Now THAT is a site to see!! He looks like a big
 hairy old man..

 -Original Message-
 Lee - lerobe
 Sent: Friday, July 06, 2001 12:11
 To: Multiple recipients of list ORACLE-L


 A bit touristy I know but I had a marvellous holiday about 2 years ago now
 in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
 Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight
!!)
 and spent 2 days watching grizzlies during the Salmon run. No guns were
 carried at any time (just pepper sprays) and we got really close to the
 bears.

 Thinking of doing it again

 Lee

 -Original Message-
 Sent: 05 July 2001 21:06
 To: Multiple recipients of list ORACLE-L


 Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
 WW Well, we have remote access from home too, but it might be convenient
to
 be
 WW able to do this stuff while I'm running from a grizzly in the
Absarokas.

 I hope I never have the opportunity to run from a grizzly. I
 once bumped (not literally) into a black bear while hiking.
 Mr. Bear just ignored me, though I was pretty spooked by
 the encounter.

 Best regards,

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

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

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


 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Robertson Lee - lerobe
   INET: [EMAIL PROTECTED]

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

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

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

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

export in cron


I beleave I asked this question already but did not get any answers.

If I run export from cron and somehow userid is incorrect or dump file name
is incorrect ( let say somebody renamed directory) - process of export is
stopped. Is it possible to catch this situation in the same script that
called export and if not - how to catch it?

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

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

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

DBMS_JOB

2001-07-06 Thread Mitchell


Dear DBAs

I have submitted a job to run at a time but never  go. I had to send
dbms_job.run(jobno) and then the job will run at defined interval.

My question is
1.  I have to exec dbms_job.run(jobno) everytime to init the the new job.
2.  What is real meaning for JOB_QUEUE_PROCESSES and  JOB_QUEUE_INTERVAL at
initdb.ora

Mitchell

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

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

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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread ef 8454

$75,000 is pretty good.  Our company (in Washington, DC) just hire a ORACLE 
DBA.  He claimed he have OCP
certificate and ONLY asked $60,000.

From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: * Oracle DBA Needed in Phoenix..
Date: Fri, 06 Jul 2001 07:35:30 -0800

Lisa, imitating a bird...

Cheap!  Cheap Cheap Cheap  

next will be I taught I taw a puddy-tat

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Friday, July 06, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L

Cheap!  Cheap Cheap Cheap 
$75,000?  To move across the country with MINIMAL relo?
Are they kidding??

I hope this isn't our parent company

Happy Friday everyone!
Lisa, the anti-recruiter ninja

   -Original Message-
Sent:   Friday, July 06, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L

   orastaff wrote:

   We would like to submit someone who is a renter and who is
interested
 in Phoenix but has not applied to Phoenix companies and is not working
 with
 other recruiters for Phoenix companies.

   Is this some super secret job or what???

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

   If you're interested in a great opportunity, then consider this
position in
Phoenix, AZ
with a leading company that needs an Oracle DBA to join its' I.T. staff.
We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working with
other recruiters for Phoenix companies.

   This is a full time staff position so no sub-contractors or third
parties
please.

   Please do not call or send a resume if you are not in the U.S.
and/or need
sponsorship.

   * Requirements:
- A degree in C.S. or equivalent
- 3+ yrs Oracle DBA experience is needed
- Strong Unix
- Application development experience; Unix scripting; C or Perl languages
   are desirable
- Must have good communication skills
  -U.S. citizenship or permanent residency required

   This position is with a  company that offers :
 * Quality Work Environment
 * Base salary up to 75K-firm +excellent benefits
 * Financial Stability
 * Some Relocation Assistance

NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.

   For  immediate consideration, please send your resume to:

   Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502.
* Please use job code: One/Phoenix/DBA/Carlos

   We pay referral fees.
So please contact me if you know of anyone who would be 
qualified/interested

in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law
OraStaff, Inc-The Proven Connection To Oracle Opportunity

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

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

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

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

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

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

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

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

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

RE: OT: friday rambelings....




Mmfriends, family, 
tent, fire and beer:)

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Friday, 
  July 06, 2001 12:53 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: OT: friday rambelings
  for the weakest link, depends on how the DBAs are up 
  against. Duhvelopers?, Damagement.
  
  now dont all you developers get offended, unless of course 
  the title fits :)
  
  bye all, i'm off to camping for the weekend, no cell, no 
  pager, no laptop, first time in like 7 years, i'll be totally disconnected, 
  just me, my family, friends, tent, fire and beer.
  
  joe
  
   [EMAIL PROTECTED] 07/06/01 12:27PM 
  having watched both weakest link and who wants to be i 
  wonder how theDBA crowd would fair on them?--Bill "Shrek" 
  Thater Certifiable ORACLE DBATelergy, 
  Inc. 
  [EMAIL PROTECTED]~~You 
  gotta program like you don't need the money,You gotta compile like you'll 
  never get hurt,You gotta run like there's nobody watching,It's gotta 
  come from the heart if you want it to 
  work.~~one ping to rule 
  them all, one ping to find them, one ping to bring themall, and in the 
  darkness bind them.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  Thater, William INET: [EMAIL PROTECTED]Fat City Network 
  Services -- (858) 538-5051 FAX: (858) 538-5051San 
  Diego, California -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like subscribing).

RE: Range partition

2001-07-06 Thread Bala, Prakash


I tried that but it didn't work. Oracle is just using the first column to
determine the partition.

Prakash

-Original Message-
Sent: Friday, July 06, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L


Can't you use a composed range key.

 --- Bala, Prakash [EMAIL PROTECTED] a
écrit :  Hello,
 
 Oracle 8.1.7 on Sun Solaris
 
 Scenario: We have a table where we store the
 consolidated weekly numbers on
 the number of disconnects, reconnects, transfers
 etc. Our business week is
 from Wednesday to Tuesday and so each week has a
 number assigned to it.
 Also, the week doesn't span across months. So we
 have a total of 63 weeks
 for 2001. The table stucture is as follows:
 
  activity_year  number(4),
  week_num   number(2),
  company_code   varchar2(10),
  channel_code   varchar2(20),
  spectrum_code  varchar2(4),
  subscriber_codevarchar2(6),
  bopnumber(10),
  initial_addnumber(10),
  volun_disc number(10),
  involun_disc   number(10).
 
 I need to partition this table in such a way that
 the data for a given year
 and week number should go to a specific partition.
 Searched Metalink and
 Oracle docs but didn't get an answer.
 
 Is there a way to accomplish this without adding a
 date column to this
 table?
 
 TIA
 
 Prakash
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Bala, Prakash
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

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

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

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

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

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

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

RE: Rollback usage


Wow thank you:)  I knew it had to exist.
KK

-Original Message-
Tom
Sent: Friday, July 06, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L


I believe that I got this off of this list a while back...

clear columns
column rbs format A7 heading 'RBS'
column ora_usr format a10
column program format a39
column sid format 
select r.name rbs,
   s.sid  SID,
   substr(osuser,1,10) os_user,
   nvl(s.username, ' -- ') ora_usr,
   s.program 
from v$lock l, v$session s, v$rollname r
where l.sid = s.sid(+) and
  trunc(l.id1(+)/65536) = r.usn  and
  l.type(+) = 'TX' and
  l.lmode (+) = 6
order by r.name;



Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Friday, July 06, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L


Hi All,
Does anyone have a script or know of a way to determine which user is
using
which rollback segment?  I had a developer issue a set transaction before
she started a migration and I wanted to see if I could make sure that she
was using the proper rollback segment.  Thanks a lot:)

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

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

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

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

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

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

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

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

SAP R3 and Locally Managed Tablespaces



In working with our SAP consultant, I've discovered that SAP may not
yet support the use of LMT's on Oracle.  Yes I know that SAP should
not really care about this, but SAP seems to care about a number of
things that would be best left to the DBA.

Does anyone have experience with SAP and LMT's?

TIA

Jared


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

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

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

RE: Accessing Oracle and MVS/CICS (IMS) data sources

2001-07-06 Thread Chan, Millie


We don't have CICS, but we have IMS on the mainframe and we have BMC's
ChangeDataMove to capture changes in IMS and move the changes on to UNIX
Oracle data base.  We also have IMS online transactions communicating with
Unix Oracle data bases thru Neon's Shadow Web Server which runs on the
mainframe.
Millie Chan
Rutgers, The State University of New Jersey
Administrative Computing Services
65 Davidson Road
Piscataway, NJ 08855
Tel: (732)445-5433
EMAIL: [EMAIL PROTECTED]
 


-Original Message-
Sent: Friday, July 06, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L


Hi

Here at Queen's University we have a number of legacy systems
based on IMS databases running under MVS with CICS as the
transaction manager. We have requirements for applications which
need to access/update data in our newer Oracle based systems and
the legacy systems at the same time. We are looking at products
like IBM's WebSphere , 9iAS, WebLogic, etc.

If anyone has had to this I would be grateful for any war stories,
tips, information that you might have to pass on.
Thanks,

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

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

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

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

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

RE: OT Bears

2001-07-06 Thread Orr, Steve


Bears become a problem when they get too familiar with man and when man
intrudes into the bear realm and is not familiar with bear behavior. When
bears get too familiar with man the rangers sometimes have to destroy them.
Sometimes the Yosemite rangers helicopter problem bears to the Yolla Bolly
Wilderness, one of my favorite hiking areas in CA. The rangers told me it
was the least backpacked wilderness area per square mile in the continental
US so don't tell anybody about it. I had a few close encounters of the bear
kind there, including a bear eating a dead horse in a camp ground... I
shoo'd him away by throwing rocks at him. Black bears are generally very
predictable but Griz are another story... no telling what's on their mind
and they can turn in an instant. The rumor is that Griz have mamed or killed
more than authorities want to admit. Griz up here are extending their range
out of the Yellowstone so you need to be careful. I have remote properties
and a private cabin north of the Yellowstone so I always take protection...
forget the pepper spray and pack a .44 Magnum! A co-worker told me that Griz
won't bother you if you're in a group of 5 or more but I don't really want
to test the theory. 

Steve Orr, respectful friend of the bear.
Bozeman, MT


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


Northern Minnesota is a great place to see bears.  Bears running down the
side of the road, bears in your back yard, bears rifling your stuff when you
are camping, and on a warm late summer evening you can go to the Vince Shute
Wildlife preserve (http://www.americanbear.org/) and see the bears up close
and personal like... THAT is a neat thing to see.

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


Closest I've ever come to a bear was when I was on holiday a few weeks ago
in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
cage.. Not the same as seeing them in their natural environment at all I
guess..:)

The one truly amazing animal they had there though was the worlds only
(known) albino gorilla!! Now THAT is a site to see!! He looks like a big
hairy old man..

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 12:11
To: Multiple recipients of list ORACLE-L


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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

Re[2]: Range partition

2001-07-06 Thread dgoulet


Joe,

My thought exactly.  Normally we think of partitioning in a linear fashion,
namely one table broken up into pieces that should stack one on top of the
other.  But two dimension partitioning is possible using the multi-key method. 
Only problem that I'm aware of, through 8.1.6 is that you cannot have a default
partition.

Dick Goulet

Reply Separator
Author: JOE TESTA [EMAIL PROTECTED]
Date:   7/6/2001 8:20 AM

a multi-key partition will not work for you or am i missing something in the
question?

joe, living on the bleeding edge trying to get stupid management server of OEM
to work for 9i :)


 [EMAIL PROTECTED] 07/06/01 10:26AM 
Hello,

Oracle 8.1.7 on Sun Solaris

Scenario: We have a table where we store the consolidated weekly numbers on
the number of disconnects, reconnects, transfers etc. Our business week is
from Wednesday to Tuesday and so each week has a number assigned to it.
Also, the week doesn't span across months. So we have a total of 63 weeks
for 2001. The table stucture is as follows:

activity_year  number(4),
week_num   number(2),
company_code   varchar2(10),
channel_code   varchar2(20),
spectrum_code  varchar2(4),
subscriber_codevarchar2(6),
bopnumber(10),
initial_addnumber(10),
volun_disc number(10),
involun_disc   number(10).

I need to partition this table in such a way that the data for a given year
and week number should go to a specific partition. Searched Metalink and
Oracle docs but didn't get an answer.

Is there a way to accomplish this without adding a date column to this
table?

TIA

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

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

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

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type content=text/html; charset=iso-8859-1
META content=MSHTML 5.50.4522.1800 name=GENERATOR/HEAD
BODY style=MARGIN-TOP: 2px; FONT: 6pt MS Sans Serif; MARGIN-LEFT: 2px
DIVFONT size=1a multi-key partition will not work for you or am i missing 
something in the question?/FONT/DIV
DIVFONT size=1/FONTnbsp;/DIV
DIVFONT size=1joe, living on the bleeding edge trying to get stupid 
management server of OEM to work for 9i :)/FONT/DIV
DIVBRBRgt;gt;gt; [EMAIL PROTECTED] 07/06/01 10:26AM 
gt;gt;gt;BRHello,BRBROracle 8.1.7 on Sun SolarisBRBRScenario: We 
have a table where we store the consolidated weekly numbers onBRthe number of 
disconnects, reconnects, transfers etc. Our business week isBRfrom Wednesday 
to Tuesday and so each week has a number assigned to it.BRAlso, the week 
doesn't span across months. So we have a total of 63 weeksBRfor 2001. The 
table stucture is as 
follows:BRBRactivity_yearnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb
sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
number(4),BRweek_numnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs
p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
number(2),BRcompany_codenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
varchar2(10),BRchannel_codenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb
sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
varchar2(20),BRspectrum_codenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n
bsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
varchar2(4),BRsubscriber_codenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
varchar2(6),BRbopnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb
sp;nbsp;nbsp;nbsp; 
number(10),BRinitial_addnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
number(10),BRvolun_discnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
number(10),BRinvolun_discnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp
;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 
number(10).BRBRI need to partition this table in such a way that the 
data for a given yearBRand week number should go to a specific partition. 
Searched Metalink andBROracle docs but didn't get an answer.BRBRIs there a

way to accomplish this without adding a date column to 
thisBRtable?BRBRTIABRBRPrakashBR-- BRPlease see the official 
ORACLE-L FAQ:

RE: notification of password expiration?

2001-07-06 Thread Vergara, Michael (TEM)




Oh man...have I been dealing with this 
lately!

We had a similar problem. We had a security audit 
come in and ask us
how often the users changed passwords. The honest 
answer of 'to my
knowledge they never have' did not sit well 
with them. Go figure.

So first we set up user profiles. We control the 
aging of accounts
and format of passwords through these profiles. 
Now...how to notify
the users? We have instances ranging from 7.3.4 
through 8.1.6 (and
soon 8.1.7).

We created an 8.1.6 instance for administrative 
purposes on one of our
central servers. In this database is a table 
called SEND_EMAIL, which
records TO, FROM, SUBJ, TEXT, and SYSDATE. When a 
row is inserted in
this table, a trigger isfired which calls a 
stored PL/SQL procedure
which uses UTL_SMTP to send an e-mail. This table 
can be used for
any e-mails from the database - not just password 
messages. One bonus
is that I now have a record of any messages sent from 
the database.

At the client databases, I created a synonym and 
database link which
point to the SEND_EMAIL table. Daily, I have a 
PL/SQL procedure
scan the EXPIRY_DATE field of the DBA_USERS view. 
When a user's
EXPIRY_DATE is within 14 days of SYSDATE, I insert a 
row with a
canned message into the SEND_EMAIL synonym. The 
record goes over
the link, into the table, fires the trigger, executes 
the procedure,
and shazzam an e-mail goes to the 
user.

I tried to genericize my message so I could store the 
same procedure on 
several remote databases. The problem with that 
is I now get tons of 
e-mail saying "What is the ABC 
database? When did I get an account 
there? What machine is it on? Is that the 
PeopleSoft database or the
Data Warehouse?" and stuff like that, so 
I've learned to store the 
generic message from 
the script, and then go in later and modify it 
for
the specificdatabase. 
GRIPEIt seems incredible 
that a user who uses 
adatabase on 
adaily or at least periodic basis 
does not even know the
name of the database, but 
oh well...that's life./GRIPE

HTH,
Mike
---
===
Michael P. 
Vergara 
| Ive got a PBS mind in an MTV world
Oracle 
DBA 
|
Guidant 
Corporation 
|

  -Original Message-From: Paul Sheahan 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, July 06, 2001 11:01 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  notification of password expiration?
  
  Hello all,
  
  Can anyone share any ideas on this?
   We 
  have a procedure in our Oracle databases that forces a user to change there 
  password after x number of days. This password procedure also forces 
  them to use num-alpha characters. Our lead Oracle admin turned off the 
  procedure because Oracle was not notifying users when their password was going 
  to expire and once it did it would not let them in.I was hoping 
  that with 8i there would be some improvements to the way Oracle handled 
  expiring passwords. Does anyone know or use a workaround for this? We 
  would like to set password expiration of 60 days on Oracle accounts but they 
  need some type of notification so they aren't locked out
  
  Thanks,
  Paul

RE: export in cron

2001-07-06 Thread Tirumala, Surendra


If I understood what you want clearly,
In the same shell script, immediately after export command,have some grep
command to look for errors in
export log file.Depending on the sucess/failure($?) of grepping, have
commands
to do whatever you want.

hth,
Suren

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


I beleave I asked this question already but did not get any answers.

If I run export from cron and somehow userid is incorrect or dump file name
is incorrect ( let say somebody renamed directory) - process of export is
stopped. Is it possible to catch this situation in the same script that
called export and if not - how to catch it?

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

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

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

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

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

2001-07-06 Thread Scott Shafer


www.hotsos.com

--- Thater, William [EMAIL PROTECTED] wrote:
 On Fri, 6 Jul 2001,[EMAIL PROTECTED] scribbled
 on the wall in glitter...:
 
 -This was my memory as well.  I thought separating
 archive, redo, indexes, data
 -and so on predated OFA.  Also, I read through the
 comments pretty quickly but I
 -thought Oracle discouraged the use of symbolic
 links for data files.  I've seen
 -this done without trouble but isn't there some
 potential error that this might
 -trigger?  Seems to me there was some traffic on
 the list for this a while
 -back...
 -
 -Ready to be wrong,
 -Kip
 
 too bad Cary isn't on the list to tell us what he
 had in mind when he designed
 it.  anybody got his email address to forward him
 the question?;-)
 
 
 --
 Bill Shrek Thater   Certifiable ORACLE DBA
 Telergy, Inc.[EMAIL PROTECTED]
 ~~
 You gotta program like you don't need the money,
 You gotta compile like you'll never get hurt,
 You gotta run like there's nobody watching,
 It's gotta come from the heart if you want it to
 work.
 ~~
 one ping to rule them all, one ping to find them,
 one ping to bring them all, and in the darkness bind
 them.
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Thater, William
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

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

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

RE: OT Bears

2001-07-06 Thread Kimberly Smith


A joke that has been going around the office the last couple of days kind of
fits with this.  Not that bears have anything to do with Oracle but I am
just
coming off a 36 hour downtime in which I upgraded two Oracle databases,
complete
reconfigured another one, and getting tired of waiting for the network to
come
up, simply moved a server from one data center to another so I could finish
work
on it.  We actually rolled it by some people with out them even noticing.
We are talking
about the HP K-class plus two disk array's.  Kind of funny.  Simply not in a
working mode today.

How can you tell if you are being attacked by a black bear or a grizzly?
If, when you climb up a tree it follows you up, its a black bear.  If it
just knocks the tree down, its a grizzly.

-Original Message-
Sent: Friday, July 06, 2001 11:42 AM
To: Multiple recipients of list ORACLE-L


Bears become a problem when they get too familiar with man and when man
intrudes into the bear realm and is not familiar with bear behavior. When
bears get too familiar with man the rangers sometimes have to destroy them.
Sometimes the Yosemite rangers helicopter problem bears to the Yolla Bolly
Wilderness, one of my favorite hiking areas in CA. The rangers told me it
was the least backpacked wilderness area per square mile in the continental
US so don't tell anybody about it. I had a few close encounters of the bear
kind there, including a bear eating a dead horse in a camp ground... I
shoo'd him away by throwing rocks at him. Black bears are generally very
predictable but Griz are another story... no telling what's on their mind
and they can turn in an instant. The rumor is that Griz have mamed or killed
more than authorities want to admit. Griz up here are extending their range
out of the Yellowstone so you need to be careful. I have remote properties
and a private cabin north of the Yellowstone so I always take protection...
forget the pepper spray and pack a .44 Magnum! A co-worker told me that Griz
won't bother you if you're in a group of 5 or more but I don't really want
to test the theory. 

Steve Orr, respectful friend of the bear.
Bozeman, MT


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


Northern Minnesota is a great place to see bears.  Bears running down the
side of the road, bears in your back yard, bears rifling your stuff when you
are camping, and on a warm late summer evening you can go to the Vince Shute
Wildlife preserve (http://www.americanbear.org/) and see the bears up close
and personal like... THAT is a neat thing to see.

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


Closest I've ever come to a bear was when I was on holiday a few weeks ago
in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a
cage.. Not the same as seeing them in their natural environment at all I
guess..:)

The one truly amazing animal they had there though was the worlds only
(known) albino gorilla!! Now THAT is a site to see!! He looks like a big
hairy old man..

-Original Message-
Lee - lerobe
Sent: Friday, July 06, 2001 12:11
To: Multiple recipients of list ORACLE-L


A bit touristy I know but I had a marvellous holiday about 2 years ago now
in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to
Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!)
and spent 2 days watching grizzlies during the Salmon run. No guns were
carried at any time (just pepper sprays) and we got really close to the
bears.

Thinking of doing it again

Lee

-Original Message-
Sent: 05 July 2001 21:06
To: Multiple recipients of list ORACLE-L


Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to
be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.

I hope I never have the opportunity to run from a grizzly. I
once bumped (not literally) into a black bear while hiking.
Mr. Bear just ignored me, though I was pretty spooked by
the encounter.

Best regards,

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

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

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

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

RE: Standby Database Replication

2001-07-06 Thread Janardhana Babu





I need to implement the 
standby database for the Txn. Proc. Prod. system. I have a few doubts. If the 
failure/disaster happens to prod DB, and can't open the DB, then How to transfer 
the contents of online logs to standby database? My logs would switch once every 
hour, and so, I would lose atleast one hour worth of data if I need to activate 
the standby database. Is there any solution for this?

My second question would be: 
Temporary network failures are quite common here. We use Veritas Netbackup to 
backup using RMAN. Archived logs would be deleted after the backup as the 
archived logs quickly fill up the diskspace. How to keep atleast one copy of the 
archived logs on a seperate bigger disk permanently, atleast one week without 
being deleted by RMAN backup script. I tried defining 
LOG_ARCHIVE_DEST_3as optional location in init.ora. But these files are 
also being deleted by RMAN backup script along with Mandatory archived logs. We 
would like RMAN backup script to delete the Archived logs from Mandatory 
location after the backups are done, but at the same time retain the Optional 
location archived logs. Is there any way to do this? Restoring from tape would 
be time consuming and so looking for a solution to retain one copy of the 
Archived logs on disk.

My third question would be: Is 
anyone using Veritas Volume Replicator or similar product to recover the DB 
until the last transaction without production DB downtime, in case of disaster? 
Iam thinking of this product, but not sure this would solve the disaster 
Recovery problem until last transaction with no prod. down time. 


Any help would be 
appreciated.

Thanks,
-- Janardhana 
Babu


  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, July 06, 2001 9:46 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Standby Database
  Rich, no problems other than, the "performance" issue, if 
  they are hitting it hard and oracle lags in trying to post the logs to the 
  standby database.
  
  other than that it should be fine.
  
  Joe
  
   [EMAIL PROTECTED] 07/06/01 11:27AM 
  Just wondering if anyone sees any problems with creating a 
  second instanceand DB on a standby database server that would be used for 
  reportingquerying against a small dataset??? Running the standby DB 
  in read onlymode is not an option since I'm applying archived logs every 
  10 minutes. Ifanyone knows of any issues with doing this, could you 
  please let me know.TIA,Richard Huntley-- Please see 
  the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  Richard Huntley INET: [EMAIL PROTECTED]Fat City 
  Network Services -- (858) 538-5051 FAX: (858) 
  538-5051San Diego, California -- 
  Public Internet access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like subscribing).

RE: export in cron


Problem is that when export is stopped it does not return control to the
script.

Alex Hillman

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


If I understood what you want clearly,
In the same shell script, immediately after export command,have some grep
command to look for errors in
export log file.Depending on the sucess/failure($?) of grepping, have
commands
to do whatever you want.

hth,
Suren

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


I beleave I asked this question already but did not get any answers.

If I run export from cron and somehow userid is incorrect or dump file name
is incorrect ( let say somebody renamed directory) - process of export is
stopped. Is it possible to catch this situation in the same script that
called export and if not - how to catch it?

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

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

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

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

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

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

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

RE: How to implement and use DBMS_STATS?


He asked about DBMS_STATS - not STATSPACK. I do not know any other source
except docs and metalink describing DBMS_STATS. 

Alex Hillman

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


Don Burleson just released (via Oracle Press) and entire BOOK on using 
STATSPACK.




From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How to implement and use DBMS_STATS?
Date: Fri, 06 Jul 2001 08:20:56 -0800

OK, enough is enough.  For a month now, I've been researching on how one is
supposed to implement and use the DBMS_STATS package.  The FMs I R'd, 
Oracle
8.1.7's Designing and Tuning for Performance and Supplied PL/SQL 
Packages
Reference, give the syntax and some very weak and incomplete examples, but
fail to define how a DBA is actually supposed to USE the package in
day-to-day operation.

And Oracle Support just keeps pointing me back to inane and unrelated
articles in MetaClink.

Can anyone point out a website or a good book with a chapter on using
DBMS_STATS for CBO?  Specifically, some good examples, some definitions
(when are stats considered stale?), what is the scope of
GATHER_DATABASE_STATS (does it stat SYS???), under what circumstances
GATHER_TABLE, GATHER_SCHEMA, and GATHER_DATABASE are to be used, and
generally how the hell one goes about implementing this.  I've now got less
than two weeks to figure it out!

And if you know this, where did you learn it?  Even my Oracle Perf Tuning
Class student guide mentions the package, says to use it, but then points 
to
the syntax-only Oracle docs for more info.  sigh

Frustratedly yours,
Rich Jesse  System/Database Administrator 
(wannabe?)
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

RE: SAP R3 and Locally Managed Tablespaces


Maybe in the versions that they sertified LMT bugs were not fixed yet. What
DB version do you use and on what platform?

Alex Hillman

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



In working with our SAP consultant, I've discovered that SAP may not
yet support the use of LMT's on Oracle.  Yes I know that SAP should
not really care about this, but SAP seems to care about a number of
things that would be best left to the DBA.

Does anyone have experience with SAP and LMT's?

TIA

Jared


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

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

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

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

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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Boivin, Patrice J


Sounds like the kind of thing I would do.

Then, months later, you realize that you are the lowest paid person in the
department or on the site...

Sigh

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   ef 8454 [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, July 06, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: * Oracle DBA Needed in Phoenix..

$75,000 is pretty good.  Our company (in Washington, DC) just hire a
ORACLE 
DBA.  He claimed he have OCP
certificate and ONLY asked $60,000.


From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: * Oracle DBA Needed in Phoenix..
Date: Fri, 06 Jul 2001 07:35:30 -0800

Lisa, imitating a bird...

Cheap!  Cheap Cheap Cheap  


next will be I taught I taw a puddy-tat



Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Friday, July 06, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L



Cheap!  Cheap Cheap Cheap 
$75,000?  To move across the country with MINIMAL relo?
Are they kidding??

I hope this isn't our parent company

Happy Friday everyone!
Lisa, the anti-recruiter ninja

   -Original Message-
Sent:   Friday, July 06, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L

   orastaff wrote:

   We would like to submit someone who is a renter and who is
interested
 in Phoenix but has not applied to Phoenix companies and is not
working
 with
 other recruiters for Phoenix companies.

   Is this some super secret job or what???

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


   If you're interested in a great opportunity, then consider
this
position in
Phoenix, AZ
with a leading company that needs an Oracle DBA to join its' I.T.
staff.
We would like to submit someone who is a renter and who is
interested
in Phoenix but has not applied to Phoenix companies and is not
working with
other recruiters for Phoenix companies.

   This is a full time staff position so no sub-contractors or
third
parties
please.

   Please do not call or send a resume if you are not in the
U.S.
and/or need
sponsorship.

   * Requirements:
- A degree in C.S. or equivalent
- 3+ yrs Oracle DBA experience is needed
- Strong Unix
- Application development experience; Unix scripting; C or Perl
languages
   are desirable
- Must have good communication skills
  -U.S. citizenship or permanent residency required


   This position is with a  company that offers :
 * Quality Work Environment
 * Base salary up to 75K-firm +excellent benefits
 * Financial Stability
 * Some Relocation Assistance

NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.

   For  immediate consideration, please send your resume to:

   Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502.
* Please use job code: One/Phoenix/DBA/Carlos

   We pay referral fees.
So please contact me if you know of anyone who would be 
qualified/interested

in the posiition described above- if it is not a match for your
skills.
Thanks,
Bill Law
OraStaff, Inc-The Proven Connection To Oracle Opportunity



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

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


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

RE: * Oracle DBA Needed in Phoenix..

2001-07-06 Thread Gene Sais


Your company is either cheap or your new dba has no clue.  DC is one of the highest 
paying locales in the USA.  Now if you said 75k was not bad in Florida, I would agree 
(companies in florida are cheap), unless you were a contractor of course.

 [EMAIL PROTECTED] 07/06/01 02:41PM 
$75,000 is pretty good.  Our company (in Washington, DC) just hire a ORACLE 
DBA.  He claimed he have OCP
certificate and ONLY asked $60,000.


From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: * Oracle DBA Needed in Phoenix..
Date: Fri, 06 Jul 2001 07:35:30 -0800

Lisa, imitating a bird...

Cheap!  Cheap Cheap Cheap  


next will be I taught I taw a puddy-tat



Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Friday, July 06, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L



Cheap!  Cheap Cheap Cheap 
$75,000?  To move across the country with MINIMAL relo?
Are they kidding??

I hope this isn't our parent company

Happy Friday everyone!
Lisa, the anti-recruiter ninja

   -Original Message-
Sent:   Friday, July 06, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L

   orastaff wrote:

   We would like to submit someone who is a renter and who is
interested
 in Phoenix but has not applied to Phoenix companies and is not working
 with
 other recruiters for Phoenix companies.

   Is this some super secret job or what???

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


   If you're interested in a great opportunity, then consider this
position in
Phoenix, AZ
with a leading company that needs an Oracle DBA to join its' I.T. staff.
We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not working with
other recruiters for Phoenix companies.

   This is a full time staff position so no sub-contractors or third
parties
please.

   Please do not call or send a resume if you are not in the U.S.
and/or need
sponsorship.

   * Requirements:
- A degree in C.S. or equivalent
- 3+ yrs Oracle DBA experience is needed
- Strong Unix
- Application development experience; Unix scripting; C or Perl languages
   are desirable
- Must have good communication skills
  -U.S. citizenship or permanent residency required


   This position is with a  company that offers :
 * Quality Work Environment
 * Base salary up to 75K-firm +excellent benefits
 * Financial Stability
 * Some Relocation Assistance

NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.

   For  immediate consideration, please send your resume to:

   Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502.
* Please use job code: One/Phoenix/DBA/Carlos

   We pay referral fees.
So please contact me if you know of anyone who would be 
qualified/interested

in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law
OraStaff, Inc-The Proven Connection To Oracle Opportunity



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

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

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

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

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


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

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

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

RE: * Oracle DBA Needed in Phoenix..



$60K and OCP.

Hmm

Can you say 'no experience'?

Jared





   
   
ef 8454  
   
ef8454@hotmai   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
l.com   cc:   
   
Sent by: Subject: RE: * Oracle DBA Needed in 
Phoenix..
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
07/06/01 11:41 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




$75,000 is pretty good.  Our company (in Washington, DC) just hire a ORACLE

DBA.  He claimed he have OCP
certificate and ONLY asked $60,000.










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

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

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

RE: Index Behaviour

2001-07-06 Thread Mercadante, Thomas F


Dave,

I think  is like using the NOT operator, thus an index can not be used.  

Think about it - your asking the optimizer to find records in the index that
are not there - nothing to really search on - so it does a FTS.

Now if you did

select surnam from basic where membno between 0 and 9 
 ormembno between 10 and 1

it might work as expected.

hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, July 06, 2001 12:53 PM
To: Multiple recipients of list ORACLE-L


Hi,

In the following query membno is a Non Unique Indexed field:

select surnam from basic where membno  10.

Whether the table is analyzed or not the Explain Plan still shows a Full
Table Scan unless I specify a Hint to use the Index.  Using the index is
more costly so I would expect CBO to always do a FTS unless the hint is
specified.  But without a hint why does RBO do a FTS and ignore the index?

Platform NT
Version 8.1.7.0.0
Optimizer Mode is Choose:

Many thanks for any replies

Dave Leach

PS.  Like the Bear stories, being brought up in London we miss out on all
this.



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

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

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

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

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

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

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

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

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

2001-07-06 Thread Rachel Carmichael

[EMAIL PROTECTED]

From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Re[2]: OFA (Optimal Flexible Architecture) in practice
Date: Fri, 06 Jul 2001 10:26:28 -0800

On Fri, 6 Jul 2001,[EMAIL PROTECTED] scribbled on the wall in 
glitter...:

-This was my memory as well.  I thought separating archive, redo, indexes, 
data
-and so on predated OFA.  Also, I read through the comments pretty quickly 
but I
-thought Oracle discouraged the use of symbolic links for data files.  
I've seen
-this done without trouble but isn't there some potential error that this 
might
-trigger?  Seems to me there was some traffic on the list for this a while
-back...
-
-Ready to be wrong,
-Kip

too bad Cary isn't on the list to tell us what he had in mind when he 
designed
it.  anybody got his email address to forward him the question?;-)

--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
one ping to rule them all, one ping to find them, one ping to bring them 
all, and in the darkness bind them.

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

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

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

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

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

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

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

Re: export in cron