RE: test

[Farnsworth, Dave]

>-test...  We have been having mail 
problems.
 
I've only had female problems.
 
;o)
 
Dave

  -Original 
  Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 9:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  test
  test...  We have been having mail problems.
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 
44113

RE: PART2 - Yep.....it's a Monday......

[Farnsworth, Dave]

Title: Yep.it's a Monday..



My 
damager just DTS'ed a bunch of tables that are critical for our web apps to 
work back on themselves.  When he set up the DTS he thought he was going 
from our production box to our test box but did the DTS from production to 
production.   The problem was that he had the tables be deleted as the 
first part of the DTS.  At least I know that my backups work.  Had 
everything restored in about 15 minutes and the web sites are up and 
running.  Yea, I know it is SQL Server but I have to deal with that 
also.  At  least he doesn't mess with my Oracle DB's.  Any other 
Monday stories for today??
 
Dave

  -Original Message-From: Bobak, Mark 
  [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 
  10:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Yep.it's a Monday..
  While doing some SAN work, one of our intrepid Sys 
  Admins unplugged the wrong cable, crashing 20+ production databases at the 
  same time…..Yeah, it's a Monday…..
  So, here I sit, waiting, while they scramble 
  around, re-connecting cables and re-booting boxes…..sigh….I have a feeling 
  lunch will be a little late today…….
  At least I wasn't the one who caused the 
  crash…..;-) 
  Mark J. Bobak 
  Oracle DBA 
  ProQuest Company 
  Ann Arbor, MI 
  "Imagination was given to man to compensate him 
  for what he is not, and a sense of humor was provided to console him for what 
  he is."  --Unknown

RE: Oracle Magazine Awards

[Farnsworth, Dave]

And 
also an increase in the price ot their Oracle license.  
;o)
 
Dave

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, November 
  20, 2003 1:25 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Oracle Magazine Awards
  Congratulations to all the award winners!
   
  Btw, 
  do they get any cash awards or just a piece of paper?
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 
2:05 PMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle Magazine 
AwardsCongratulations 
to the following folks that appeared in the 2003 Editors Choice 
Awards ( I finally received my issue 
of the mag ) Arup Nanda - DBA of 
the Year Tony Jambu - Consultant 
of the Year Mogens Nogaard - 
Educator of the Year Tom Kyte - 
Oracle Book Author of the Year There were many other, I only mentioned those that I have had 
the opportunity to meet and/or 
converse with via email, or sometimes even in person.  ( all of these conditions allow me to drop their 
names when the opportunity arises 
) Congratulations folks! 
( I don't know if all of them 
frequent this list ) Jared 

8.0.5 standard edition

[Farnsworth, Dave]

By any chance does anyone know where I can download this??  Long story but I need to 
downgrade a database from 8.0.5 enterprise to standard edition. The admins can't find 
the standard CD.  I have been looking on oracles site but have not found it yet.   I 
guess I wouldn't expect to since it is a bit outdated.

Thanks,

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

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

RE: IGNORE: Unix Help

[Farnsworth, Dave]

Title: Message



Or was 
it that we just ignored your post?  ;o)
 
Dave

  -Original Message-From: Sujatha Madan 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 
  11:29 PMTo: Multiple recipients of list ORACLE-LSubject: 
  IGNORE: Unix Help
  Sorry ... but I solved it.
   
  Cheers
  Sujatha
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Sujatha MadanSent: Wednesday, 8 October 2003 1:24 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Unix Help
Hi,
 
Sorry for the 
slightly non-Oracle post.
 
I am after a 
UNIX code snippet that will help me copy archive logs to another directory 
BUT not if they already exist. So if only 2 archive logs are generated 
between script runs only the two new ones should copy. I know I can do this 
using sysdate - "time interval"  but I am trying to avoid 
that.
 
Thanks in 
advance,
 
Sujatha 
Madan.

RE: SQLServer resources

[Farnsworth, Dave]

Title: Message



Try 
this site;
 
http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english
 
And 
pick which listserver you want.  The sql2k is a very good list to use as a 
resource.
 
Dave

  -Original Message-From: Cunningham, Gerald 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 
  1:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
  OT: SQLServer resources
  Hi 
  all,
   
  Can anybody point 
  me to a mailing list such as this for SQLServer? (I would be suprised if 
  there's something of ORACLE-L's quality, but you never know!). Or, any other 
  resources on the web? I'm particularly interested in production support 
  (performance tuning, security, backup/recovery, etc.)
   
  Thank you very 
  much!
   
  - 
  Jerry
   

RE: UNSUNSCRIBE ME

[Farnsworth, Dave]

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: Move SQL Server Tables to Oracle

[Farnsworth, Dave]

You 
can always use the SQL Server DTS package to do this.
 
Dave

  -Original Message-From: Gunnar Berglund 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 
  2003 3:00 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Move SQL Server Tables to 
  Oracle
  Hi all,
   
  I need to move some sql server tables to oracle.
   
  Do you have some ideas how to do it. I have no idea ...
   
  rgds
  G
  
  
  Want to chat instantly with your online 
  friends? Get 
  the FREE Yahoo! Messenger

RE: Rman equivalent for MS-SQL server

[Farnsworth, Dave]

This 
beast does not exist.  You can use the Database Maintenance Plans in EM to 
manage your backups.  I have found these to be flaky and prefer writing my 
own custom backup plans in scripts and schedule these as jobs.  >From my 
experience on SQL Server I recommend doing a native SQL Server backup to disk, 
then have the third party backup software pickup those files to 
tape.
Just 
my $.02
 
Dave

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 4:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Rman 
  equivalent for MS-SQL server
  
  Hi good 
  people-
  Does anyone out there know of the 
  equivalent of oracle’s RMAN in MS SQL server environs.
  I’m investigating the possibility 
  of having my SQL server dump the backups direct to a third party tape library 
  –VERITAS to be specific.
   
  Your input on this thread will be 
  highly appreciated.
   
  CSW 
  Simon.

RE: test

[Farnsworth, Dave]

 
Test,TestWe don't need no stinkin test.

  -Original Message-From: Rajesh Dayal 
  [mailto:[EMAIL PROTECTED]Sent: Saturday, September 06, 2003 5:13 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  test
  
  Test  
  
   

RE: Oracle on Win2000

[Farnsworth, Dave]

Hammer, screwdriver and duct tape.
 
;o)

  -Original Message-From: Bala Regupathy 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  12:44 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000
  First time I have got to maintain Oracle 
  databases on Win 2000 server.  What tools do you guys use to 
  get to the server to admin oracle databases ?
   
  Thanks,
   
  Bala.

RE: OT: Hey Jared!!

[Farnsworth, Dave]

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

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

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

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

OT - RE: Tough Oracle DBA experience

[Farnsworth, Dave]

Title: RE: Tough Oracle DBA experience



When 
my son graduates in a couple years I am going back into umpiring and also want 
to become a football ref.  I really miss the umpiring.  Kids ended 
that plan for a while.  Nothing like calling a third strike on a 
guy.
 
Done 
with the OT'ing.
 
Dave

  -Original Message-From: Loughmiller, Greg 
  [mailto:[EMAIL PROTECTED]Sent: Monday, August 25, 2003 
  9:35 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Tough Oracle DBA experience
  hang 
  on... You mean you get *paid* to watch College 
  Football:-)  What a job;-)   
  
   
  I 
  get paid a little bit for college football.. But officiating the game 
  isn't the same as *watching* the game.
   
  Greg
   
   
   
   
   
   -Original 
  Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 
  4:59 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Tough Oracle DBA experience
  
Create a new top 5 list ... it is fun
 
It stinks to be in office on Sat, but it is the start of College 
Football season, and I have to _watch_ the games till 11pm tonight, while 
sitting in office.
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 


  -Original Message-From: Ryan 
  [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 4:49 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Tough Oracle DBA experience
  how about DBAs with attitude problems? DBAs 
  who refuse developers access to v$ views. DBAs who refuse to listen to 
  developers. DBAs who who refuse to explain any decisions to developers. 
  DBAs who are pure production DBAs and have no knowledge of development and 
  cant even write PL/SQL? 
   
  Ive worked with quite a few DBAs who only 
  know a fraction of what they think they do. Same holds true for developers 
  and managers. So its not one way. Attitude is harder to overcome than 
  competence. Someone with a good attitude can learn. Someone who knows and 
  has a bad attitude can be intolerable. 
   
  The worst kind though is the jack of all 
  trades who thinks he/she knows everything about everything yet only knows 
  a little about everything. Those are the worst. 
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list 
ORACLE-L 
Sent: Saturday, August 23, 2003 
4:24 PM
Subject: RE: Tough Oracle DBA 
experience

Top 5 problems ... 
1. Developers (who think they know everything) 
2. Developers (who think, others think they know 
everything) 3. Developers (who think but just 
not coherently) 4. Developers (who DON'T think 
at all) 5. Developers (these work for 
Oracle) 
Raj  
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly 
personal. QOTD: Any clod can have facts, having 
an opinion is an art ! 
-Original Message- From: 
Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, August 23, 2003 9:09 AM 
To: Multiple recipients of list ORACLE-L 
Subject: Tough Oracle DBA experience 
Dear All, 
I am collecting (Just writing in a book ) of all tough 
problems , great issues handled with Oracle 
RDBMS as a DBA. 
Request you kindly send us the Top 5 Problems , 
Difficult scenarios(the most tough problems , 
with solution u did.)you faced so far in your DBA life. 
Hope to see many responses to this , atleast by 
Monday. Thanks a lot. 
Regards Rajuveera 
  

RE: Is there any certification for "Systems Analyst/Designer" ?

[Farnsworth, Dave]

Maybe at www.duhveloper.com
 
;o)

  -Original Message-From: Salaheldin Aboali 
  [mailto:[EMAIL PROTECTED]Sent: Monday, August 18, 2003 8:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Is 
  there any certification for "Systems Analyst/Designer" ?
  Hi all,
   
  Is there any certification for "Systems 
  Analyst/Designer" ?
   
  Regards,Salaheldin

check,check, one, two, three

[Farnsworth, Dave]

: Re:=20
  Struts
   
  Abraham, 
  >>=20
  what is 9iAS platform do in J2EE, sinc we get stand alone OC4J, HTTP, =
etc. to=20
  deploy the JSP, Sevletes and EJB by having JDevloper? =

  The stand=20
  alone OC4J that comes in JDeveloper is there to make it simpler for =
you to=20
  test and debug your application on your development machine. It is not =
meant=20
  to be used for production deployment - If you want to deploy your J2EE =

  applications on Oracle's J2EE container you'll need to license =
Oracle9iAS. If=20
  you just want the J2EE parts of Oracle9iAS you should get the =
Oracle9iAS Java=20
  Edition which includes the J2EE container, HTTP Server, TopLink, =
Enterprise=20
  Manager and 5 seat license for JDeveloper - that's priced at $5,000 =
per CPU.=20
  If you are also interested in adding things like Single-Sign-On =
security,=20
  Reporting etc, look at the other editions of Oracle9iAS. http://www.oracle.com/ip/deploy/ias/index.html?pkgsum.html";>http:=
//www.oracle.com/ip/deploy/ias/index.html?pkgsum.html=20
  
  As far as=20
  the question of whether JDeveloper can produce production applications =
and are=20
  people using it - we have some customers stories on these pages: http://www.oracle.com/ip/develop/ids/customers/index.html?content=
.html">http://www.oracle.com/ip/develop/ids/customers/index.html?content.=
html=20
  and http://www.oracle.com/ip/develop/ids/customers/content2.html";>htt=
p://www.oracle.com/ip/develop/ids/customers/content2.html=20
  
  Regards,=20
  
  Shay.=20
  
  Abraham=20
  Alemu wrote: 
  
 This is a very interesting trend, I =
have to=20
agree that the best I have seen so far in this forum. I want to =
ask the=20
discussants, if I many,  the following based on my perspective =
of=20
beginner in these technologies. Two weeks back I was attending =
one of=20
those classes which Oracle corp. organizes under the name Oracle =
Developer=20
Days. It was in Atlanta, Ga; I drove from =
Florida. J2EE=20
for beginners and J2EE best practice were  part in those =
classes. Most=20
to the presentation was the use of JDeveloper in creating those =
application,=20
and the lab was really effective, I believe. I remember at one =
moment=20
during those classes, when asked how many of us are using Struts =
framework=20
few hands were raised( I mean about 5 from about 150 us). But most =
say=20
without JDEV. Now, I wonder if, Paul  advise us beginners =
in these=20
case, since he wrote several version of books  in JDeveloper. =
Most say=20
JDevloper could create production level J2EE others disagree, where =
is the=20
line in this debate? Bedside Oracle corp at every level tell us to =
go and=20
refer to Sun.com for the details, where is for us Oracle folks these =

techology cross refrence lead us? I mean it is all confusing for =
most of us=20
at this stage.Besides, what is 9iAS platform do in J2EE, sinc we get =
stand=20
alone OC4J, HTTP, etc. to deploy the JSP, Sevletes and EJB by having =

JDevloper? Any advise will be apreciated. Abraham 



Do you Yahoo!? http://us.rd.yahoo.com/evt=3D10469/*http:/sitebuilder.yahoo.com";>=
Yahoo!=20
SiteBuilder - Free, easy-to-use web site design=20
software
  --=20
  - =
Shay=20
  Shmeltzer - Sr. Product Marketing Manager Oracle Corporation=20
   

--=_NextPart_000_010F_01C3627E.C9A4D4D0--


--

End Of ODTUG-JAVA-L Digest -- Volume 2003, Number 227
*

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

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

RE: Re: How to Lock and unlock a table until SP completes

[Farnsworth, Dave]

SP = Stored Procedure

Dave

-Original Message-
Sent: Monday, August 04, 2003 8:34 AM
To: Multiple recipients of list ORACLE-L


what is an 'SP'?
> 
> From: "Tanel Poder" <[EMAIL PROTECTED]>
> Date: 2003/08/04 Mon AM 08:54:31 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: How to Lock and unlock a table until SP completes
> 
> Hi!
> 
> You could also play with set transaction read only, set transaction isolation level 
> serializable or opening all cursors in beginning of SP and only closing them when 
> all work is done to achieve consistency you need. 
> 
> Tanel.
>   - Original Message - 
>   From: WLSH 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Monday, August 04, 2003 9:09 AM
>   Subject: How to Lock and unlock a table until SP completes
> 
> 
>   Dear List:
> 
>   How can I lock and then unlock a table? A SP only runs about 2 sec, but during its 
> execution, sometimes there are more records saved to the table the SP is working on, 
> then the SP confused.  I want to be able to lock a table while the SP is executing, 
> and then by the end, release the lock. Is there a way to do this? How? Can any one 
> give me an example?
> 
>   Thanks
> 
> 
>   Steven
> 
> 
> --
>   Do you Yahoo!?
>   Yahoo! SiteBuilder - Free, easy-to-use web site design software
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

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

RE: Oracle Metalink

[Farnsworth, Dave]

I can get in 
metastink
 
Dave

  -Original 
  Message-From: Shannon St. Dennis 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 11:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Metalink
  please tell me metalink is down and that they haven't 
  revoked my membership!
   
  Shannon St. DennisDatabase AdministratorCity of Regina(306) 
  777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
   
  The degree of normality in a database is inversely proportional to that 
  of its DBA

Number of processors and standard edition

[Farnsworth, Dave]

I am trying to find any info on if there is a maximum number pf processors that a 
server can have and have Oracle standard edition run on it.  Just looking to see if 
there is a cutoff point in the number of processors where I would be forced to go to 
Enterprise Edition of Oracle 8i..  I'm looking through the concepts docs but have not 
yet found this info.

Thanks,

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

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

RE: Oracle 9i refuses to allow client connection -- I need some help.

[Farnsworth, Dave]

Title: Message



Might 
find something in your SID.log.  This is in your 
Oracle_home\admin\bdump directory.  Might also find something in your 
Oracle_home\network\log\listener.log depending on if any tracing is 
enabled.  I used to have this problem.  Found that stopping and 
restarting my listener service a few times a week took care of it.  Also 
adding more memory helped.  I had a TAR with Oracle on this and they 
recommended the stopping and restarting the listener service.  I am on 
windoze though so it may be a platform dependent thing, not like M$ has any 
issues with their OS.  ;o)
 
Dave

  -Original Message-From: Wolfe Stephen S GS-11 6 
  MDSS/SGSI [mailto:[EMAIL PROTECTED]Sent: Friday, July 
  25, 2003 6:35 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I 
  need some help.
  I'm an Oracle 
  administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, 
  the
  training has been 
  approved, just hasn't been funded.  
   
  Anyway, the only 
  things I do are add, modify, and reset application users' password via EM and 
  run
  patching scripts via 
  SQL-Plus.  The application I have running on this particular 9i server is 
  TPOCS,
  Third Party Outpatient 
  Collection System -- a billing system for the DoD's Military Health System 
  (MHS).
  Oracle 9i is running 
  on a Windows 2000 server.
   
  Anyway, the TPOCS 
  client is a PowerBuilder client and connects via SQL-Net -- I'm still learning 
  about that
  mechanism.  
  Here's my problem.  Occasionally, Oracle refuses to let any client 
  connect to it -- it does this about
  every 7 to 8 
  days.  It use to do it every 2 days, but the Tier 3 TPOCS helpdesk 
  recommended we increase the 
  ram on the server from 
  512MB to 1GB.  Then the problem started occurring every 7 to 8 
  days.  To make the problem
  go away I reboot the 
  server -- it only takes 10 minutes, however, I feel this a very poor 
  work-around.
   
  Which logs could I 
  look in that would give you guys more information (like an error code) on why 
  Oracle refuses
  client connections and 
  then how would we make this problem go away.  it is becoming a 
  PITA.
   
   
   
   
  v/r 
  Stephen S. Wolfe, GS-11, 
  DAFC Data Services 
  Manager [EMAIL PROTECTED] (813) 827-9974  DSN 651-9974 

Managing Archived Redo Logs

[Farnsworth, Dave]

I finally get to put our 8.1.7 on NT databases into archivelog mode.  We have a third 
party app vendor that would not support us if I did this but I finally convinced them 
that is the way to go and it should not effect the app.  Anyway, I am reading chapter 
7 from the Administrators Guide, Managing Archived Redo Logs.  I know I have to set 
the parameters in the init.ora to achieve automatic archiving;

log_archive_start=true
log_archive_dest_1 = "location=my\disk\drive"
log_archive_format=%%ORACLE_SID%%T%T%S.ARC  -or somthing like that

One thing I don't see in TFM is, do these archived redo logs just keep accumulating in 
the destination directory set in the log_archive_dest_1 parameter?  Do I need to 
create a process to get them to tape and then once on tape, delete these old archive 
redo logs through my process?
I'm just excited to be able to finally go to archivelog mode.  Once I get the basics 
down then I want to investigate using RMAN.

Thanks,

Dave


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

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

Managing Archived Redo Logs

[Farnsworth, Dave]

I finally get to put our 8.1.7 on NT databases into archivelog mode.  We have a third 
party app vendor that would not support us if I did this but I finally convinced them 
that is the way to go and it should not effect the app.  Anyway, I am reading chapter 
7 from the Administrators Guide, Managing Archived Redo Logs.  I know I have to set 
the parameters in the init.ora to achieve automatic archiving;

log_archive_start=true
log_archive_dest_1 = "location=my\disk\drive"
log_archive_format=%%ORACLE_SID%%T%T%S.ARC  -or somthing like that

One thing I don't see in TFM is, do these archived redo logs just keep accumulating in 
the destination directory set in the log_archive_dest_1 parameter?  Do I need to 
create a process to get them to tape and then once on tape, delete these old archive 
redo logs through my process?
I'm just excited to be able to finally go to archivelog mode.  Once I get the basics 
down then I want to investigate using RMAN.

Thanks,

Dave

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

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

SHOW ERRORS not working

[Farnsworth, Dave]

I have a developer that has ALTER ANY PROCEDURE rights.  He changes a procedure, then 
compiles it and it says there are errors.  But when he does a SHOW ERRORS in SQPlus, 
it shows nothing.  If I do the same thing I can see the errors from the compiled 
procedure.  I assume this is a permissions thing but have not been able to figure this 
one out.  Anyone have any ideas on this?

Thanks,

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

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

RE: Windohs - monthly at job

[Farnsworth, Dave]

Title: Message



I 
think it is like this, In a DOS window type;
 
AT 
17:00 /every:1,15 "C:\PATH TO BAT FILE\BAT_FILE_NAME"
 
Not 
positive, but I think it is like this.
 
Dave

  -Original Message-From: Cunningham, Gerald 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 
  11:39 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Windohs - monthly at job
  Hi 
  all,
   
  Does anybody know 
  the syntax to schedule a monthly "at" job on Windows (2000)? I need to 
  schedule a job for the 1st and 15th every month, and would like to avoid the 
  Task Scheduler GUI.
   
  A virtual pint o' 
  Guiness (mm...) for anybody who can help!
   
  Thanks!
   
  - 
  Jerry
   

RE: error reading file

[Farnsworth, Dave]

I see 
the problem.  Looks like your file is empty.
 
;o)
 
Dave

  -Original Message-From: Shishir Kumar Mishra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 02, 2003 5:16 
  AMTo: Multiple recipients of list ORACLE-LSubject: error 
  reading file

RE: Tech meetings

[Farnsworth, Dave]

Preferably to be held at a local 
pub.

  -Original Message-From: M.Godlewski 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 11:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: Tech 
  meetings
  List,
   
  Just wondering if your organization has tech meetings, and what is 
  discussed and what the goals of the meetings are?
   
  I've been asked about this, and was wondering if there is a quick list 
  out there any where.
   
  TIA
   
  
  
  Do you Yahoo!?The New 
  Yahoo! Search - Faster. Easier. Bingo.

RE: Online tech books

[Farnsworth, Dave]

I think he needs to get out more!!  ;o)

Dave

-Original Message-
Sent: Monday, June 30, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L


Have you really read all books you have in your bookcase???

JP


On Monday 30 of June 2003 16:39, you wrote:
> All..
>
> I just returned frm vacation, but I wanted to respond to Jonathan
> Gennick regarding my collection of books.( I managed to delete that
> message) But, Ive taken some pictures of my collection.. Ive actually
> purchaced all the books you see!
> http://162.42.213.232/books/index.html
>
>
> I would just like all to know that my initial recommendation to view
> free books online was not an offer to circumvent actually purchacing the
> books. Personally I prefer to actually have a hard copy in my hand for a
> reference, on the other hand I though the online books may be handy and
> hopefully spur individuals to purchace  books they otherwise may not be
> aware of, and possibly maybe for a struggling fellow who doesnt have a
> dime but has an interest to learn may pick up something worthwhile
>
> Ahhh back to work
>
> Best to all
> bob
>
> > And, more than likely, highly illegal.  I was assume the
> > authors on list list will be contacting their respective publishers?
> >
> > Rich
> >
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> >
> > > -Original Message-
> > > From: Bob Metelsky [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, June 18, 2003 11:04 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Online tech books
> > >
> > >
> > > This was just passed on to me and I'd like to share it wit
> >
> > the list...
> >
> > > http://www.palaydium.net/tech/
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jesse, Rich
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from).  You may also send the HELP command for other
> > information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
On a quiet Night, you can hear the Windows machines reboot.

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

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

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

Good link on Locally Managed Tablespaces

[Farnsworth, Dave]

I want to share this link with the listers.  It is a good article on Oracle locally 
managed tablespaces with some good info for those that are going to migrate to LMT's.

http://databasejournal.com/features/oracle/article.php/10893_2223631_1

Dave

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

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

RE: SORT_AREA_SIZE question

[Farnsworth, Dave]

You want a sorts to disk ratio of 1 percent 
or less.  To find this run this;
 
dispatch> column name format 
a30dispatch> select name, value  2  from 
v$sysstat  3  where name like 'sort%';
 
NAME   
VALUE-- -sorts 
(memory)    
283420sorts 
(disk)  
64sorts 
(rows)    
29507963
 
 
the ratio of sorts = 
round((64/283420)*100,3)
ratio of sorts = 0.023%
 
Learned this from the Oracle DBA 101 book, 
one of the best buys I made.
 
Dave

  -Original 
  Message-From: Bart Kersteter 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 
  9:39 AMTo: Multiple recipients of list ORACLE-LSubject: 
  SORT_AREA_SIZE question
  Hello,
   
  I joined this list last week, so I apologize in advance if I'm asking a 
  question that has previously been answered.
   
  I am responsible for a reporting database/data mart that is approximately 
  175 GB.  Our main fact table ranges from 1-14 GB depending upon how far 
  along we are into our financial year.  I have large reports that run full 
  table scans on this table daily.  In an effort to keep as much of the 
  sorting in memory as possible I have specified SORT_AREA_SIZE to be 
  100MB.  Some of the tuning books I am reading now are making me 
  second-guess myself and I am wondering if this is overkill.
   
  Can anyone provide some advice on how large they are setting their 
  SORT_AREA_SIZE values for their DSS systems?  
   
  Thanks in advance,
   
  Bart
   
  

  Please NoteThe 
  information in this E-mail message is legally privilegedand confidential 
  information intended only for the use of theindividual(s) named above. If 
  you, the reader of this message,are not the intended recipient, you are 
  hereby notified that you should not further disseminate, distribute, or 
  forward thisE-mail message. If you have received this E-mail in 
  error,please notify the sender. Thank you
  
  
  

RE: Oracle Clinical

[Farnsworth, Dave]

Must have something to do with Brill Cream.  You know, just put a DAB of it in your 
hair and you're an instant babe magnet.

Dave

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


What's a DAB?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, June 24, 2003 10:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Clinical
> 
> 
> Hi all, 
>  what is Oracle Clinical.
>  I saw some job advertisement Oracle Clinical DAB or programmer.
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: [EMAIL PROTECTED]

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

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

RE: Retreiving data from SQL Server

[Farnsworth, Dave]

You must put double quotes around column names in select and where clauses and it is 
VERY case sensitive.  Note the following query;

select "concontainer" from [EMAIL PROTECTED] where "conID" = 1;

if you tried this with the field of "conid" it would fail.  It's a pain in the butt 
that is how it works.  Be sure to look at the table structures on SQL Server to get 
the proper case of the field names.
Hope this helps.

Dave

-Original Message-
Sent: Tuesday, June 17, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L


Can anyone give me an example of an SQL statement that will retrieve data
from SQL Server.
What is the best way to do this?

Thanks!
Ron Smith
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

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

RE:

[Farnsworth, Dave]

HELP

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



SET ORACLE-L NOMAIL
--
-
Software Engineering
Vattmannstraße 7, 33100 Paderborn
Phone: (+49) 52 51 / 30 1 6333
Fax: (+49) 52 51 / 30 16 399
eMail: [EMAIL PROTECTED]
http://www.unitrade.com
--



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

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

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

RE: any intro statspack docs online?

[Farnsworth, Dave]

check 
these links
 
http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html
 
http://www.oracle.com/oramag/oracle/00-Sep/o50tun.html
 
http://www.oracle.com/oramag/oracle/00-Nov/o60tun.html
 
http://www.oracle.com/oramag/oracle/00-Nov/o60tun_ol.html
 
Dave

  -Original Message-From: Johnson, Michael 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10, 
  2003 12:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: any intro statspack docs 
  online?
  Search MetaLink ... Burleson has a good book "High 
  Performance Tuning with Statspack" .. Tom Kytes Book "One on One" 
   in Chapter 10 also has some good information ..  Look 
  in  your $ORACLE_HOME/rdbms/admin and depending on you version their is a 
  sp*.doc or st*.txt document in there to show you how to set up and 
  use.    Also,   I think Tim Gorman's site has some 
  statspack stuff  in his downloadable library 
  section.
   
  http://www.evdbt.com/
   
  HTH, 
  Mike
   
   
  
-Original Message-From: Yechiel Adar 
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
any intro statspack docs online?
I know it is late but:
 
Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with 
explanation and recommendations.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Thursday, May 22, 2003 5:41 
  PM
  Subject: any intro statspack docs 
  online?
  Ive read the otn stuff and the niemic articles from Oracle 
  mag.anything else? any articles that give a brief intro that 
  includes installation? Id prefer not to dig into the Burleson book. Im 
  really looking for something brief.Not too familiar with tuning 
  wait events, but I 'think' we have some contention problems, and before I 
  create an elaborate routine, Id like to get some metrics. any 
  quick start guide? 
  
  

  
  
  
  
  

  
  Licensing is 
  based on customers honesty 
  basically.
   
  The versions you 
  can download are fully functional with all the 
  options.
  
  Visit 
  our web site at http://www.quantsystems.nl/
   
  -Original 
  Message-From: Joe 
  Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 
  AMTo: Multiple 
  recipients of list ORACLE-LSubject: oracle trialware - features 
  ??
   
  
  Folks, Does "Oracle 
  Enterprise Edition - Trialware" have all the features as that of 
  a licensed one ? Is RMAN fully functional on a trial version of 
  9iR2 ? What makes the difference between these two ? If 
  there is no difference, how does ORACLE prevent people from using it for 
  PRODUCTION ? Read an interesting article about oracle licensing at 
  http://www.vnunet.com/Analysis/1113993 
  and just thought of sharing it with u 
  guys.
  
   
  
  Share your comments 
  Gurus.
  
   
  
  Cheers,
  
  Joe.
  Get 
  advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos 
  Mail

RE: count(*) vs count(0)

[Farnsworth, Dave]

Thanks 
for burying that dead horse Kirti!!
 
;o)
 
 
dave

  -Original Message-From: Kirtikumar Deshpande 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: count(*) vs count(0)
  Vivek, 
  Your same question on LazyDBA list has been answered correctly. 
  
  :) 
   
  - Kirti VIVEK_SHARMA 
  <[EMAIL PROTECTED]> wrote:
  Is 
there a performance equality between COUNT(*) & COUNT(0) ?Is it same 
, indpendent of the Oracle Version ?Forgive the repeat raising , as 
this issue seems to have come before .Thanks-- 
  
  
  
  Do you Yahoo!?Free online 
  calendar with sync to Outlook(TM).

RE: 10i

[Farnsworth, Dave]

Is that the green button that once pushed makes the database "unbreakable"?

-Original Message-
Sent: Friday, May 30, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L


who promoted you to traffic cop?  

this is the only way I'm able to hear about the new green gui button.

-Original Message-
Sent: Thursday, May 29, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


OK everyone.  Traffic cop time.  Everyone that is a beta partner for 10i
MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, please.  We as
partners pushed Oracle for these beta programs.  Conversations like this
only hurt the process.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, May 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject:10i

Got my first look at the 10i beta last night. I can't tell you much about it
except to say that looking at some of the new stuff


h

;-)


While I'm certain many of the new features will not work perfectly for
several releases afterwards, they look very cool!

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

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



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

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

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

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

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

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

RE: is this DBA's only mailing list?

[Farnsworth, Dave]

Yes, 
we even let developers use this list.  Heck, if you want to throw out a 
perl question cuz I bet you'll get an answer.
 
;o)
 
Dave

  -Original Message-From: Ajay K. Garg 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, May 29, 2003 7:46 
  AMTo: Multiple recipients of list ORACLE-LSubject: is 
  this DBA's only mailing list?
  HI everyone
   
  I recently joined the list, and I think it is 
  meant only for DBAs. Is that true?
  Also, can anyone suggest any similar mailing list 
  meant for Oracle developers (that is those working with SQL, PL/SQL, Forms, 
  Oracle apps, etc.) and those who are not DBAs?
   
  Thanks in advance
  Ajay K. Garg
   

RE: dbshut script - shutdown or shutdown immediate

[Farnsworth, Dave]

I also started doing this a couple months ago and have not had a shutdown hang since.

Dave

-Original Message-
Sent: Wednesday, April 02, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L


We do shutdown abort. But we do checkpoint before shutdown abort i.e,

alter system checkpoint;
shutdown abort;

Then, while bringing up, we do 

startup restrict;
shutdown immediate;
startup

Rao

-Original Message-
Sent: Wednesday, April 02, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L


Peter,

I modified to shutdown abort, starup then shutdown immediate.

joan

"Schauss, Peter" wrote:
> 
> I have one Oracle instance which supports an application
> server which always maintains a database connection.
> The UNIX system administrator tells me that this instance always
> hangs when she tries to shut down the system.  The other instances,
> which do not support a 24x7 process shut down properly.
> 
> Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
> is
> connect internal
> shutdown
> 
> Should I modify the script to "shutdown immediate" so that it kills
> any connections?
> 
> Environment is Oracle 8.1.7 /AIX 4.3.3.
> 
> Thanks,
> Peter Schauss
> Northrop Grumman Corporation
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schauss, Peter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: DBLink to SQL Server problem

[Farnsworth, Dave]

Title: RE: DBLink to SQL Server problem



Greg, 
I got it to work.  The Docs only tell you part of the story.  Let me 
know if you need any help in setting this up since I have spent a few days 
trying to get this working.
 
Dave

  -Original Message-From: Loughmiller, Greg 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 
  2003 10:14 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: DBLink to SQL Server 
  problem
  since you are going to sqlserver - I wonder if you need to 
  place the following on the object/database 
  ... from 
  ..@msql 
  I haven't seen the doc you mention(and forgive me if this is 
  redundant info you know)-but SQL has the concept of multiple databases within 
  the "instance", and each DB has a "DBO" account..
  select .  from 
  [EMAIL PROTECTED] 
  Just a thought-but would be interested in knowing the solution 
  when you are able to get this working.. I just came across a project where we 
  may need to do this here..
  greg 
  -Original Message----- From: 
  Farnsworth, Dave [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, April 02, 2003 9:34 AM To: Multiple recipients of list ORACLE-L Subject: DBLink to SQL Server problem 
  I created a DBLink to a SQL Server database following DocID: 
  114820.1.  It seemed to work fine until I tried a real query.  If I 
  do something like a SELECT COUNT(*) or SELECT * it works fine;
  tdispach> select count(*) from [EMAIL PROTECTED]; 
  
   COUNT(*) - 
   1207 
  But if I try to select on a specific field or have a WHERE 
  clause specifying a filed I get this; 
  tdispach> select mpp_id from [EMAIL PROTECTED]; 
  select mpp_id from [EMAIL PROTECTED]    * ERROR at 
  line 1: ORA-00904: invalid column name 
  I know that the column name is correct so something else is 
  not translating properly.  I tried a fully qualified column name of 
  MANPOWERPROFILE.MPP_ID and that got the same error.  I don't see any 
  setting in my DSN that could effect this.  Anyone have any ideas, hunches 
  or clues?
  Thanks, 
  Dave -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: Farnsworth, Dave   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: DBLink to SQL Server problem

[Farnsworth, Dave]

Thanks Igor.  I figured it out.  I need double quotes around the column name and it 
works.  Didn't see that mentioned in TFM.

  1* select "mpp_id" from [EMAIL PROTECTED]
tdispach> select "mpp_id" from [EMAIL PROTECTED] where "mpp_id" = 'LESS';

mpp_id

LESS

Thanks,

Dave

-Original Message-
Sent: Wednesday, April 02, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


Dave,

SQL Server is case-sensitive, when it comes to table names, column names.
When stored in SQL Server data dictionary, they aren't converted into
upper-case, as it is with Oracle (unless you use quotes around names).
So, try to use the exact "case" when specifying field names (as they are
stored in SQL Server data dictionary).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:34 AM


> I created a DBLink to a SQL Server database following DocID: 114820.1.  It
seemed to work fine until I tried a real query.  If I do something like a
SELECT COUNT(*) or SELECT * it works fine;
>
> tdispach> select count(*) from [EMAIL PROTECTED];
>
>  COUNT(*)
> -
>  1207
>
> But if I try to select on a specific field or have a WHERE clause
specifying a filed I get this;
>
> tdispach> select mpp_id from [EMAIL PROTECTED];
> select mpp_id from [EMAIL PROTECTED]
>*
> ERROR at line 1:
> ORA-00904: invalid column name
>
> I know that the column name is correct so something else is not
translating properly.  I tried a fully qualified column name of
MANPOWERPROFILE.MPP_ID and that got the same error.  I don't see any setting
in my DSN that could effect this.  Anyone have any ideas, hunches or clues?
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


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

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

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

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

DBLink to SQL Server problem

[Farnsworth, Dave]

I created a DBLink to a SQL Server database following DocID: 114820.1.  It seemed to 
work fine until I tried a real query.  If I do something like a SELECT COUNT(*) or 
SELECT * it works fine;

tdispach> select count(*) from [EMAIL PROTECTED];

 COUNT(*)
-
 1207

But if I try to select on a specific field or have a WHERE clause specifying a filed I 
get this;

tdispach> select mpp_id from [EMAIL PROTECTED];
select mpp_id from [EMAIL PROTECTED]
   *
ERROR at line 1:
ORA-00904: invalid column name

I know that the column name is correct so something else is not translating properly.  
I tried a fully qualified column name of MANPOWERPROFILE.MPP_ID and that got the same 
error.  I don't see any setting in my DSN that could effect this.  Anyone have any 
ideas, hunches or clues?

Thanks,

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

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

RE: Virus warning

[Farnsworth, Dave]

I got one of those also.  Looks like we got plunged!!

-Original Message-
Sent: Wednesday, April 02, 2003 6:14 AM
To: Multiple recipients of list ORACLE-L


Just got a virus warning from our scanning company that a message from
the list might be infected. It was entitled "Re: The real estate
plunger"

Craig


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

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

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

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

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

RE: alert log file

[Farnsworth, Dave]

You 
can rename the alert log or move it.  Oracle will create a new one the next 
time it has to write to it.  You don't need to bounce the 
DB.
 
Dave

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54 
  AMTo: Multiple recipients of list ORACLE-LSubject: alert 
  log file
  for  one of the db over here  alert log 
  is biggg .Looks like its never been truncated or backup .
  Is it a problem if i just move this alert log 
  file to another directory , will oracle create a new alert log file 
  ?
  Do I need to bounce db ?
   
  btw its 8.1.6 ( hp-ux )
  -ak
   

RE: Unable to connect to OMS on Redhat 8.0 server.

[Farnsworth, Dave]

>-Is 8:50 AM too early for beer?

Not in Wisconsin!!

-Original Message-
Sent: Wednesday, March 26, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L


Good luck.  We've had nothing but problems trying to use that config.  As
far as we could tell, the DB was fine.  It was the external Java stuff that
didn't work, specifically OMS.  It would be fine for a connect or two, then
crash, then not want to restart.

And of course, since there are no FREE Linuxes "supported" (That has GOT to
change -- what's the point of going to Linux if I have to pay for it, Oracle
Corp???  I'd rather stick with Solaris, which ironically is free on Sun's
hardware.) for 9iR2, you're probably S.O.L., like us.

  Is 8:50 AM too early for beer???


Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Tuesday, March 25, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L


I have installed oracle 9.2.0.3 on Redhat 8.0. 
Then I used the emca to create the oem database and repository. 
I started oms (oemctl start oms user/pass) 
I can connect to the console from the Linux box but when I try to launch the
console from my 2000 laptop. (version 9.2.0)
I get the following. java.lang.NullPointerException 
Any help would be great. 
Thanks, 
Bill Jonte 
IT - Technical Services 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

RE: Anybody using QlikView BI tools?

[Farnsworth, Dave]

Cognos, like Oracle are pricing themselves out of the market.

Dave

-Original Message-
Sent: Saturday, March 15, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L


After management learned the cost of Cognos PowerPlay, they decided to look 
at QlikView from QlikTech (Sweeden).

I would be interested in hearing from anybody that has had experience with 
this BI tool.  Pro and con issues are welcome.


Thx - Don


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

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

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

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

RE: Perl Book

[Farnsworth, Dave]

http://www.oreilly.com/catalog/oracleperl/
 
Play your cards right and you may even get 
an autographed copy.  ;o)
 
Dave

  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 8:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: OTC: 
  Perl Book
  Looks like I have a need write a Perl program to access a database.  
  Any suggestions on a good book.
   
   
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204

RE: I am an idiot - WAS -deadlock problem

[Farnsworth, Dave]

I'm having a blonde moment.  It was a permissions issue.  The table was in a different 
users schema.  DUH.

Dave
-Original Message-
Sent: Monday, March 10, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L



Does it have foreign keys?

"Farnsworth, Dave" wrote:
> 
> I am trying to do a TRUNCATE TABLE My_Table but keep getting this error;
> 
> A self-deadlock among DDL and parse locks
> is detected. In most cases, this self-deadlock
> is handled internally.
> This should be reported to Oracle Support
> ONLY IF an error is signalled back to the
> user on a command-line or screen.
> The following information may aid in finding
> the problem.
> ORA-04020: deadlock detected while trying to lock object DFARNSWORTH.REGION_ZIPS
> 
> This is in my test environment and there should not be anything else locking the 
> table.  Any ideas??
> 
> Thanks,
> 
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

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

deadlock problem

[Farnsworth, Dave]

I am trying to do a TRUNCATE TABLE My_Table but keep getting this error;

A self-deadlock among DDL and parse locks
is detected. In most cases, this self-deadlock
is handled internally.
This should be reported to Oracle Support
ONLY IF an error is signalled back to the
user on a command-line or screen.
The following information may aid in finding
the problem.
ORA-04020: deadlock detected while trying to lock object DFARNSWORTH.REGION_ZIPS

This is in my test environment and there should not be anything else locking the 
table.  Any ideas??

Thanks,

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

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

RE: Is there any user group forum for SQL Server?

[Farnsworth, Dave]

Try this one out.

http://www.sswug.org/listservers.asp

Dave

-Original Message-
Sent: Monday, March 03, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L


Hi All,

As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if there is any 
such group for SQL Server also.

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

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

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

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

RE: Dealing with 3rd Party Applications

[Farnsworth, Dave]

Jeff,

Has this product been reliable for you to use without doing anything funny to the 
database?

Dave

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


Hi,

So my boss comes over this morning and tells me that the users are having a
performance problem with a 3rd party application that have recently began
using.  This is an oracle database where they bought the software and had
the system admin install the software which included the vendors instruction
of creating and setting up the database (basically use the defaults).  It is
an Oracle 8.1.7 database on Windows 2000.  He wants me to find out "if you
can create some indexes or something", etc. (he likes to give solutions
before the cause if discovered). 

Anyway,  I decide to take a look at it.  The performance they are
complaining about is when they log into the application it takes about a
minute for their initial screen (which includes a list of values) to appear.
I use the tool that someone posted here a while ago, SQL Monitor from
www.fastalgo.com, and find that during the time the user is waiting for the
first screen the application is executing a sql statement about 2200 times.

The SQL is:  SELECT PARENTID FROM PROC_  WHERE PROCEDUREID=:1
The bind variable is different for each execution with appears to be the
procedureid values from the table proc_.  Table proc_ has 2203 rows.
I check the executions for the sql text in v$sqlarea.  Executions = 58,825.
(aha, I think this is the problem).
I explain plan the query and find that it is using the primary key index.

My tuning skills are still pretty basic.  Since I have no control over the
application is there anything I can do to increase the performance of
running the query thousands of times?

Also how do you usually deal with 3rd party application issues like this?
95% of our databases/applications are from 3rd party vendors and it's a pain
trying to get them performing better.

Thanks,
Jeff Eberhard




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

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

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

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

RE: U2 Databases

[Farnsworth, Dave]

I had Unidata at my last job.

Dave

-Original Message-
Sent: Wednesday, February 26, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L


Does anybody out there use "U2" databases?

http://www.theregister.co.uk/content/53/29457.html

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

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

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

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

RE: Skill Sets - This may be a dumb question

[Farnsworth, Dave]

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

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

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

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

RE: Skill Sets - This may be a dumb question

[Farnsworth, Dave]

Title: Skill Sets - This may be a dumb question



Simple, eliminate the married couple.  Then you 
should have your pick of jobs.
 
Dave

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 25, 2003 
  10:34 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Skill Sets - This may be a dumb question
  Hello everyone, 
  Well I've been "reassigned".  I was 
  responsible for the completely messed up Peoplesoft Oracle/AIX environment but 
  management here decided that it was more important to separate a husband and 
  wife that both work in the same department, and assigned one of them to be 
  primary support in this environment instead of me.  (sshh:  The new 
  person who is primary doesn't know a thing about Unix.)  My primary job 
  is now suppossed to be data modeling and data warehouse/mart design, moving on 
  into Problematica (er, Informatica) development into a Sql Server 
  database.  I will not be the admin on the Sql Server database.  My 
  new boss referred to this as "database architecture".  ??  
  What?  They have already decided what they want done and just want 
  someone to take the pretty pictures and implement them with unrealistic 
  deadlines.
  The main reason why I am upset is because it seems 
  to me that data modeling is such a "soft" skill.  I am concerned about 
  keeping my skills up to date and keeping my hands in an Oracle environment, 
  whether it's a mess or not.  Seems to me that data modeling alone isn't 
  something that can land you a new job or really spiff up your resume.  I 
  think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, 
  Project, crap like that) is more what employers search for, and is what HR 
  depts can easily deal with. 
  Am I wrong?  This job pays well and working 
  for a huge company has it's benefits, if you can deal with the bureaucracy 
  similar to what is described in the 1st paragraph.  And I know in this 
  market I am just lucky to have a job.  
  And please tell me if I'm whining.  I may just 
  need a KITA.  Who knows anymore... 
  Lisa Koivu Oracle Drink Beer Again Fairfield 
  Resorts, Inc. 5259 Coconut Creek 
  Parkway Ft. Lauderdale, FL, USA  
  33063 Office: 954-935-4117  
  Fax:    954-935-3639 
  Cell:    954-683-4459 
  "The sender 
  believes that this E-Mail and any attachments were free of any virus, worm, 
  Trojan horse, and/or malicious code when sent. This message and its 
  attachments could have been infected during transmission.  By reading the 
  message and opening any attachments, the recipient accepts full responsibility 
  for taking proactive and remedial action about viruses and other defects. The 
  sender's business entity is not liable for any loss or damage arising in any 
  way from this message or its attachments."-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: 
  [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, California -- Mailing list and web hosting 
  services - 
  To REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from). You may also send the HELP command for other 
  information (like subscribing). 

RE: REQUEST FOR BUSINESS RELATIONSHIP / NEXT OF KIN

[Farnsworth, Dave]

e subscribing).

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

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

RE: Service startup on Windows 2000 fails

[Farnsworth, Dave]

I cannot trust my network admins.  They do crap without any notification.  They will 
make a change and then I will spend the next day trying to figure out what happened.  
Their typical response is "Oh, we didn't know that the databases would be affected".  
DO NOT TRUST NETWORK ADMINS.  And from my time working in IS I have found that network 
admins have no communication skills.  These are NT guys.  I had better luck with unix 
network admins though.  Go figure.

Dave

-Original Message-
Sent: Wednesday, February 19, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L


Lyndon, I wish I knew what caused the problem.  And I have no idea how the monkey that 
broke it solved the problem.  I think it had something to do with removing folder 
shares, but I'm not sure.  

I am so busy whipping out volumes of pl/sql code that I can't stop to understand why.  
I have to figure out how to smooth over the fact that we lost one day in our already 
tight schedule that is making it necessary for me to work from home at night (DSL + 
VPN = FUN! Sometimes.)

Cut, Paste, Test, Kill.  Lather, rinse, repeat.  

Wish I could just leave work and "get pissed out of my tree."

Mrs. Monkey.

  

-Original Message-
Sent: Wednesday, February 19, 2003 2:30 PM
To: [EMAIL PROTECTED]; Koivu, Lisa


Please tell us what caused the problem and how you solved it.

-- 
Lyndon Tiu


Quoting "Koivu, Lisa" <[EMAIL PROTECTED]>:

> Hi Wayne, 
>  
> Thanks so much for responding.  
>  
> I guess my lack of knowledge of Windows 2000 administration has
> just bit me in the ass.  A description of a paintbrush-style change
> applied to our servers by the network support people in another
> office is what completely and totally HOSED services on two
> development boxes.  Of course, a communication went out to a list
> of people that *didn't* include me or my boss, or the people who
> actually support my servers here in Ft. Lauderdale.  
>  
> GR  I screamed at the guy ( what? me? NO! ) and it will not
> happen again. 
>  
> The really sad part is that I wouldn't know what permissions need
> to be where and why.  Add that to the very long list of things to
> investigate between whipping out stupid pl/sql code and changing
> diapers. 
>  
> Anyway everything is back and I am happy again. 
>  
> I hope everyone has a better day than me. 
>  
> Mrs. Monkey
>  


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

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

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

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

RE: Know 1 database, know them all?

[Farnsworth, Dave]

Either the person knows sybase and SQL Server or the drugs kicked in.  Much of the 
theory is similar but there are enough differences that only RTFMing and experience 
can help.  I do SQL Server, Oracle and now am learning DB2.  They all claim to be 
ANSI92 compliant.  The problem is that they each have a different interpretation of 
ANSI92.

-Original Message-
Sent: Saturday, February 15, 2003 7:39 PM
To: Multiple recipients of list ORACLE-L


I overheard one guy mention that once you learn one database, you know them
all.  Is this true?  Or was he just talking about the theory behind the db?

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

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

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

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

RE: Ora-00600 fun

[Farnsworth, Dave]

8.1.7 on NT.  Got it fixed though.

Thanks,

dave


-Original Message-
Sent: Friday, February 14, 2003 6:21 AM
To: Farnsworth, Dave; [EMAIL PROTECTED]


OS and version?

Possibilities from Metalink:

  Increase the SHMMAX kernel parameter to 2139095040 (2Gb-8Mb).
  See note 70240.1

Jay

>>> [EMAIL PROTECTED] 02/14/03 06:33AM >>>
After my nightly cold backup and during the database startup I got this error;

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga 
heap,THREAD RECOVERY)

The database mounts but does not startup.  I already filed a TAR with Oracle but was 
wondering if any of you might have a clue on this one.  This is suppose to happen on 
Monday, not Friday.

Thanks,

Dave

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

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





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

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

WOO HOO, FIXED IT - WAS - RE: Ora-00600 fun

[Farnsworth, Dave]

Someone suggested a reboot so I figured I would start by just shutting down the Oracle 
database service.  I restarted the service and the database is up and running.  You 
gotta love the windoze OS.  When in doubt reboot the service or the server.

Dave

-Original Message-
Sent: Friday, February 14, 2003 5:34 AM
To: Multiple recipients of list ORACLE-L


After my nightly cold backup and during the database startup I got this error;

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga 
heap,THREAD RECOVERY)

The database mounts but does not startup.  I already filed a TAR with Oracle but was 
wondering if any of you might have a clue on this one.  This is suppose to happen on 
Monday, not Friday.

Thanks,

Dave

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

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

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

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

Ora-00600 fun

[Farnsworth, Dave]

After my nightly cold backup and during the database startup I got this error;

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga 
heap,THREAD RECOVERY)

The database mounts but does not startup.  I already filed a TAR with Oracle but was 
wondering if any of you might have a clue on this one.  This is suppose to happen on 
Monday, not Friday.

Thanks,

Dave

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

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

RE: Ora-1001

[Farnsworth, Dave]

RE: Newbie to Oracle DBA

[Farnsworth, Dave]

This 
will keep you busy.  Enjoy.
 
http://web.singnet.com.sg/~petermag/oracle.html
 
Dave

  -Original Message-From: Santosh Varma 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 12, 2003 
  4:09 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Newbie to Oracle DBA
  Hello 
  list,
   
   I wanted to know of some 
  good sites where i can learn the basics as well as advanced DBA topics. Could 
  anybody help me out ?
   
  
  
  Thanks and Regards,
  Santosh
   

NEVER MIND - WAS - RE: SQL Plus Environment

[Farnsworth, Dave]

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

Dave

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


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

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

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

Thanks,

Dave

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

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

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

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

SQL Plus Environment

[Farnsworth, Dave]

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

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

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

Thanks,

Dave

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

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

FW: Oracle Desupport Services Announces New Desupport Advisories and Notices

[Farnsworth, Dave]

--FYI--

Dave

-Original Message-
Sent: Friday, February 07, 2003 6:12 PM
To: Farnsworth, Dave
and Notices


This e-mail contains priority desupport information and is being sent to MetaLink 
users as a service from Desupport Services.

The following new desupport notices and advisories have been approved and published 
for your review for the months of September, October and November:

3rd-Party Product Advisory:
Microsoft Windows Millennium Edition - MetaLink Doc ID: 217980.1

Business Intelligence Analytical Applications:
Oracle Financial Analyzer (OFA) 6.3.2 -MetaLink Doc ID: 216921.1
Oracle Financial Analyzer (OFA) 6.3.0 & 6.3.1 MetaLink Doc ID:216919.1
Oracle Sales Analyzer (OSA) 6.3.2 MetaLink Doc ID: 216923.1
Oracle Sales Analyzer (OSA) 6.3.0 & 6.3.1 MetaLink Doc ID:216922.1

E-Business Suite Desupport Notices:
Oracle Exchange 6.2.1 - MetaLink Doc ID: 211762.1

Gateways Desupport Notices:
Oracle Procedural Gateway for APPC 9.0.1 -MetaLink DocID: 211763.1
Oracle Transparent Gateway for DB2 8.1.7 -MetaLink Doc ID: 217678.1
Oracle Transparent Gateway for DB2/400 8.1.7 - MetaLink DocID: 217676.1
Oracle Transparent Gateway for DRDA 9.0.1 -MetaLink DocID: 211766.1
Oracle Procedural Gateway for IBM MQSeries 9.0.1 - MetaLink Doc ID: 211764.1

Internet Products Desupport Notices:
Oracle9i Application Server 1.0.2.1 -MetaLink Doc ID: 210966.1
Oracle9i Application Server 1.0.2.0 -MetaLink Doc ID: 210965.1

Java Products Desupport Notices:
JDBC for JDK 1.1.x MetaLink Doc ID: 221298.1

Access to details regarding these desupport notices and advisories are available on 
MetaLink (http://metalink.oracle.com) under the News & Notes section of the My 
Headlines page. You can also view all desupport updates from the Certify and 
Availability section of MetaLink.. From the MetaLink main menu, select Certify & 
Availability ==> "1. View Certifications by Product" ==> "Desupport Notices".

Please forward all desupport related questions to [EMAIL PROTECTED]

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

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

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

[Farnsworth, Dave]

got it

Thanks,

Dave

-Original Message-
Sent: Friday, February 07, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
an


Dave

Just add one more line before to shutdown abort...


alter system checkpoint;
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE

Regards
Rafiq





Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 07 Feb 2003 07:28:43 -0800

I do my cold backups at a time when the system is not being used.  In the 
future I want to learn RMAN for hot backups but for now I do the following;

SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE

You mention about checkpointing, how can I do a checkpoint in my script 
before the SHUTDOWN ABORT?

Thanks,

Dave

-Original Message-
Sent: Thursday, February 06, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
an


Let me throw in my 2 cents worth on this topic. There are two problems with 
SHUTDOWN ABORT that I have experienced in the past.

1. Before 9i (it appears to be fixed in 9i) if you inserted data in a table, 
then did a shutdown abort, if after restarting the database, you tried to 
truncate the table while the database was performing recovery on that table, 
the database would crash.

2. Assume that you have applications that are dynamically doing things like 
adding and dropping tablespaces. WHat happens if the app is in the middle of 
such an operation and it's in the middle of writing new records to the 
control file. What is the result if you shutdown abort in the middle of this 
write, before it's complete. We experienced a situation like this earlier 
this week.

I've always been opposed to shutdown abort unless you are certain that you 
have checkpointed and that there are no user sessions operating on the 
database.

Cheers!


RF

-Original Message-
Rajendra
Sent: Monday, February 03, 2003 9:01 AM
To: Multiple recipients of list ORACLE-L
an



When we do cold backups, our script issues 'shutdown immediate', if within 3 
minutes the db is not shut down, we cancel and issue 'shutdown abort'. In 
either case, we (again issue) startup/shutdown to make it clean before 
taking backup.

We don't worry about users connecting, as during cold backup window, the 
listeners are shutdown. For us it is a circus (kind of) because our 
production DBs talk to each other, so we have to follow a specific seq of 
shutdown/startup.

So far we haven't encountered any major issues because of 'shutdown abort' 
... (heavily knocking on the wood !!)
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!



_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

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

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

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

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

RE: dump.sql

[Farnsworth, Dave]

Try this link.

http://www.cybcon.com/~jkstill/util/

Dave

-Original Message-
Sent: Friday, February 07, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L


Where can I get then latest version of Jared's legendary script?

Or is there a better alternative script  for dumping and reloading table
data?

John

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

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

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

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

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

[Farnsworth, Dave]

Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and



I do 
my cold backups at a time when the system is not being used.  In the future 
I want to learn RMAN for hot backups but for now I do the 
following;
 
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE
 
You 
mention about checkpointing, how can I do a checkpoint in my script before 
the SHUTDOWN ABORT?
 
Thanks,
 
Dave

  -Original Message-From: Robert Freeman 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 
  10:54 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris 
  an
  Let 
  me throw in my 2 cents worth on this topic. There are two problems with 
  SHUTDOWN ABORT that I have experienced in the past.
   
  1. 
  Before 9i (it appears to be fixed in 9i) if you inserted data in a table, then 
  did a shutdown abort, if after restarting the database, you tried to truncate 
  the table while the database was performing recovery on that table, the 
  database would crash. 
   
  2. 
  Assume that you have applications that are dynamically doing things like 
  adding and dropping tablespaces. WHat happens if the app is in the middle of 
  such an operation and it's in the middle of writing new records to the control 
  file. What is the result if you shutdown abort in the middle of this write, 
  before it's complete. We experienced a situation like this earlier this 
  week.
   
  I've 
  always been opposed to shutdown abort unless you are certain that you have 
  checkpointed and that there are no user sessions operating on the 
  database.
   
  Cheers!
   
   
  RF
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, 
RajendraSent: Monday, February 03, 2003 9:01 AMTo: 
Multiple recipients of list ORACLE-LSubject: RE: re SHUTDOWN 
ABORT -- was RE: Debate on rc commands Solaris an
When we do cold backups, our script issues 'shutdown 
immediate', if within 3 minutes the db is not shut down, we cancel and issue 
'shutdown abort'. In either case, we (again issue) startup/shutdown to make 
it clean before taking backup.
We don't worry about users connecting, as during cold backup 
window, the listeners are shutdown. For us it is a circus (kind of) because 
our production DBs talk to each other, so we have to follow a specific seq 
of shutdown/startup.
So far we haven't encountered any major issues because of 
'shutdown abort' ... (heavily knocking on the wood !!) Raj __ 
Rajendra Jamadagni  
    MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any 
opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion 
is an art! 

Oracle Training

[Farnsworth, Dave]

I have been told that I will finally get a budget for some training and want to get 
some in Oracle.  I see that Learning Tree has some classes.  Do you guys have any 
recommendations to links to point me to other sources for classes.  Everything I have 
learned has been from RTFM and books from some of this lists esteemed members.  
Sometimes it is nice to have a class to move to the next level quicker than from 
reading.  Any recommendations will be great.

Thanks,

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

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

RE: Disaster Recovery

[Farnsworth, Dave]

>-I'm thinking some type of crib sheet with useful commands for that DR
>-situation might be useful too.

This is one of my main ways that I survive, I really like cheat sheets.  Also have a 
$50 bill in the folder to go buy beer afterwards, you'll need it.  ;o)

Dave

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


We're in the process of updating our DR plan and adding some more detail
!.  So I've been racking the auld grey matter and  trying to identify a
list of useful hardcopy documents which would be really useful for DR.  The
type of documents you store in a folder at home and bring along should the
sh#t hit the fan.   What I've come up with so far is:

[1]  Over view diagram of server showing disk config details and locations
of various key database files.  This doc also includes high level server
spec and IP info.
[2]  Relevant Technical Operating Procedures. 
[3]  Log forms for DB restore and backup.
[4]  List of dirs per server included in tape backup schedule.
[5]  List of backups per server including info on backup dirs and locations
of log files.
[6]  List of scheduled jobs on each server, time, freq, command line to
submit.
[7]  Copy of DR plan and Technical manual for primary production system on
CD.

The following get backed up disk-to-disk T,W,Th,F,S and are included on tape
incremental:
Binary and text dumps of control file.
Script which creates dynamic script to run offline database backups.
Disk to disk backup of database.
Archived redo logs. 

I'm thinking some type of crib sheet with useful commands for that DR
situation might be useful too.

So what else would you as a DBA like to have in this folder to support a
smooth and efficient as possible DR?.  

Oh yeah our SLA is that we recover DB as was at time of last working day
(M-F) backup.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

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

RE:

[Farnsworth, Dave]

try this link.  It's a "feature" of Oracle.

http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html

Dave

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


Hi Listers,

I'm new in DBA's job. I want to ask what is 'statspack' ? does it a third
party program from oracle or a script. Where I can find the information
about 'statspack' ? or if it is a script would you please to share with me ?
Thank you in advance for your help. Every comments and clues would be very
appreciated.

Rgrds,

Sony

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

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

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

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

RE: The lightbulb goes on - WAS-Debate on rc commands Solaris and Oracle

[Farnsworth, Dave]

Ok, so I changed my cold backup script lastnight so it does this;

connect internal/amianidiot
shutdown abort
startup restrict
shutdown normal
exit

It then does the abort and the startup and then the shutdown normal but then I get 
this and my database hangs;

Shutting down instance (normal)
License high water mark = 10
Fri Jan 31 03:05:35 2003
SHUTDOWN: waiting for logins to complete.

So now I was totally ready to go postal, but then rational thinking prevailed so I 
RTFMed.  I then come across this in the FM;

Typically, all users with the CREATE SESSION system privilege can connect to an open 
database. Opening a database in restricted mode allows database access only to users 
with both the CREATE SESSION and RESTRICTED SESSION system privilege; only database 
administrators should have the RESTRICTED SESSION system privilege

So my question is, should all users be created with the system privilege of CREATE 
SESSION and only I get the RESTRICTED SESSION in addition?  Am I reading this 
correctly that for the STARTUP RESTRICT to work all users need to have the CREATE 
SESSION privilege?  We have some third party replication software that is trying to 
make a connection to Oracle every 5 seconds and I think this was the culprit.  It DID 
NOT have the CREATE SESSION but it does now so I am curious as to if the database will 
shutdown tonight.  Did I actually learn something??

Thanks,

Dave(iamanidiot)  :o)

-Original Message-
Sent: Thursday, January 30, 2003 7:15 AM
To: Multiple recipients of list ORACLE-L



I'll echo that sentiment.

'shutdown abort', 'startup restrict' was a regular part of my
shutdown scripts beginning in 1994 with 7.0.16, as 
'shutdown immediate' wasn't all that reliable, even in situations
where it should have worked.

Jared

On Wednesday 29 January 2003 15:53, John Kanagaraj wrote:
> Rao,
>
> And where did you read that 'shutdown abort' is not recommended? This is
> another myth that has been busted a while ago. A shutdown abort followed by
> a startup restrict and a normal shutdown is the way to go when dealing with
> rogue sessions that open a connection and never shutdown. In such cases, a
> shutdown immediate will _never_ return (certainly not within your 5 to 10
> minutes). I have been using this method for more than 8 years now -
> starting at 7.0.16 fyi. The trick in this case is to script it into the rc
> commands.
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> I don't know what the future holds for me, but I do know who holds my
> future!
>
> ** The opinions and statements above are entirely my own and not those of
> my employer or clients **
>
>
> -Original Message-
> Sent: Wednesday, January 29, 2003 11:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Paula,
>
> Shutdown abort is not recommended as the file checkpointing is not done
> during shutdown abort.  If you need to perform shutdown abort, then, it is
> preferred to bring up the db with startup restrict (so that the users
> wouldn't connect) and then, cleanly shutdown the db and bring it up again.
>
> Tell to your sys admins. that shutdown immediate would take some time
> (about 5 to 10 minutes) depending on the activity on your db.  They would
> have to wait for that much time before calling a DBA during system boots.
>
> Rao
>
> -Original Message-
> Sent: Wednesday, January 29, 2003 11:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> System Administrator says he doesn't trust that the rc commands will stop
> if the database doesn't want to shutdown and even if it does would want to
> shutdown with scripts beforehand so that a DBA could connect and resolve
> the issue.  Other DBA says this is all wrong and rc commands should include
> shutdown immediate of database.  In the past I had setup 2 processes in the
> system scripts for the sys admin - shutdown immediate - wait  shutdown
> abort - on a read-only DSS system which of course allows some room for this
> type of activity.  I kind of would want to know if a database was going to
> be shutdown with an abort esp. in OLTP system and do it myself.
>
>
>
> - any ideas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

RE: "Take Care of your DBAs"

[Farnsworth, Dave]

http://digilander.libero.it/caricacell/

-Original Message-
Sent: Friday, January 31, 2003 6:25 AM
To: Multiple recipients of list ORACLE-L


Oh, just to hard to resist!

I like meat too! 

HELP

Back to Oracle (stuff anyway)..

-Original Message-
Barger
Sent: 31 January 2003 00:49
To: Multiple recipients of list ORACLE-L


Is there ANY way we can STOP this dumb thread  Is
life that friggen dull for you people?  Do you need
someone to come in and hose your systems so you will
have something to do?

How many 'me too' posts can I generate from this??? 
How many 'me too' posts can be generated from this
statement:  "I like meat"

Rant off,
back to ORACLE!



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Barger
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: "Take Care of your DBAs"

[Farnsworth, Dave]

I prefer 12 oz curls myself.

Dave

-Original Message-
Sent: Thursday, January 30, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


Average age for a DBA? I'm 42 and I am a jogger (3-4 miles a day), I play
hoops.
Sometimes I go rollerskating to Central Park, in New York City or skating.
Did I
mention that I enjoy playing Ping-Pong? 

> -Original Message-
> From: Glenn Stauffer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 30, 2003 1:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: "Take Care of your DBAs"
> 
> 
> On Thu, 2003-01-30 at 10:09, Gogala, Mladen wrote:
> > > 
> > > It's nice to have four seasons.
> > > 
> > 
> > As long as the temperature doesn't drop under 60 during any 
> of those four
> > seasons.
> > Four feet of snow? Here in CT, we had few inches and the 
> traffic collapsed.
> > What do you drive? Sherman tank?
> > -- 
> 
> If the temperature doesn't drop below 60, where do you go 
> cross country
> skiing?  To some, summer is a space between winters.  Now, summer does
> make for a better commute - my hour and fifteen can quickly turn into
> three in winter!
> 
> As for DBA's not exercising, I'd be interested in knowing if it is a
> generational thing.  Depending on the season, I bicycle, 
> kayak (sea), or
> ski for fun and, sometimes, exercise and do so relatively often.  I
> probably see more people engaged in similar activities who 
> are in their
> mid-late 30's, 40's and 50's than in their 20's and early 30's.  I
> wonder what the average age is for Oracle DBA's?
> 
> -- 
> Glenn Stauffer
> Swarthmore College
> Swarthmore, PA
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Glenn Stauffer
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

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

RE: "Take Care of your DBAs"

[Farnsworth, Dave]

>-where do you go cross country skiing?  To some, summer is a space between winters

Glenn, you da man!!

Dave(hoping for more snow)

-Original Message-
Sent: Thursday, January 30, 2003 12:01 PM
To: Multiple recipients of list ORACLE-L


On Thu, 2003-01-30 at 10:09, Gogala, Mladen wrote:
> > 
> > It's nice to have four seasons.
> > 
> 
> As long as the temperature doesn't drop under 60 during any of those four
> seasons.
> Four feet of snow? Here in CT, we had few inches and the traffic collapsed.
> What do you drive? Sherman tank?
> -- 

If the temperature doesn't drop below 60, where do you go cross country
skiing?  To some, summer is a space between winters.  Now, summer does
make for a better commute - my hour and fifteen can quickly turn into
three in winter!

As for DBA's not exercising, I'd be interested in knowing if it is a
generational thing.  Depending on the season, I bicycle, kayak (sea), or
ski for fun and, sometimes, exercise and do so relatively often.  I
probably see more people engaged in similar activities who are in their
mid-late 30's, 40's and 50's than in their 20's and early 30's.  I
wonder what the average age is for Oracle DBA's?

-- 
Glenn Stauffer
Swarthmore College
Swarthmore, PA

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

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

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

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

RE: "Take Care of your DBAs"

[Farnsworth, Dave]

Title: RE: "Take Care of your DBAs"



Me 
offended, not possible.  Maybe the offender, but not 
offended.
Yea, 
yea I know, take this to the OT list so we can take it straight to the 
gutter!
 
Dave

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 
  9:21 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: "Take Care of your DBAs"
  Hi Dennis, Point taken.  Most of us can't feed ourselves 
  on our physical abilities...  my point was that most of the people I have 
  met in IT are not into regular exercise of any type and thought I was crazy 
  for going running over lunch. 
  Sorry I did not mean to offend anyone in any way.  I'll 
  tape my trap shut now. 
  -Original Message- From: 
  DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, January 29, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: "Take Care of your DBAs" 
  Lisa - Some of us became DBAs because we realized we would 
  never be able to feed our families on our physical 
  abilities. 
  Dennis Williams DBA, 40%OCP 
  Lifetouch, Inc. [EMAIL PROTECTED]   
  
  -Original Message- Sent: 
  Wednesday, January 29, 2003 3:55 PM To: Multiple 
  recipients of list ORACLE-L 
  I used to play Ping Pong with the sysadmins and the app 
  architect...  aahh, the glory dotcom days when I 
  could bring my dog to work :) 
  Most of the dba's I have met are not into physical activity 
  and exercise. 
  -Original Message-  
  ] Sent: Wednesday, January 29, 2003 2:49 PM 
  To: Multiple recipients of list ORACLE-L 
  
  "shooting hoops"?  Just out of curiosity, how many people 
  on the list have a 
  group of DBAs at their company that they shoot hoops with? 
    Some good points, some 
  odd ones.  I'll echo Patrice's sigh (as someone who enjoys both parts of the job).   
  Jay   -Original Message- Sent: Wednesday, 
  January 29, 2003 7:34 AM To: Multiple recipients of 
  list ORACLE-L 
  Here's that "development DBA" alias again.   sigh.   
  Pat. 
  -Original Message- Sent: 
  Wednesday, January 29, 2003 7:54 AM To: Multiple 
  recipients of list ORACLE-L 
  Thanks for this article.  I will forward to damagement. 
    Dave 
  -Original Message- Sent: 
  Tuesday, January 28, 2003 3:24 PM To: Multiple 
  recipients of list ORACLE-L 
  http://careerlink.devx.com/articles/hc0199/hc0199.asp 
    
  < http://careerlink.devx.com/articles/hc0199/hc0199.asp 
   
  >  
  Interesting article I stumbled across.   Best 
  quote:  "Stay Out of your DBA's 
  Face"!    WELL PUT! 
  Lisa Koivu Oracle Database 
  Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net   
  -- Author:   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
    San 
  Diego, California    -- Mailing list 
  and web hosting services - 
  To REMOVE yourself from this mailing list, send an 
  E-Mail message to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in the message BODY, 
  include a line containing: UNSUB ORACLE-L (or the name 
  of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). 
  
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: DENNIS WILLIAMS   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: Debate on rc commands Solaris and Oracle

[Farnsworth, Dave]

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

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

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

RE: Debate on rc commands Solaris and Oracle

[Farnsworth, Dave]

I guess I'll go with this method since I have a couple of cold backups that hang on 
the SHUTDOWN IMMEDIATE and will remain hung until I rectify the situation.  I have had 
TAR's on this but this could not be resolved.  I'm just more confident to see others 
doing this.  Does anyone have this problem on a non-windoze platform??  It seems like 
I only see windoze users having this problem.

Thanks,

Dave

-Original Message-
Sent: Thursday, January 30, 2003 7:15 AM
To: Multiple recipients of list ORACLE-L



I'll echo that sentiment.

'shutdown abort', 'startup restrict' was a regular part of my
shutdown scripts beginning in 1994 with 7.0.16, as 
'shutdown immediate' wasn't all that reliable, even in situations
where it should have worked.

Jared

On Wednesday 29 January 2003 15:53, John Kanagaraj wrote:
> Rao,
>
> And where did you read that 'shutdown abort' is not recommended? This is
> another myth that has been busted a while ago. A shutdown abort followed by
> a startup restrict and a normal shutdown is the way to go when dealing with
> rogue sessions that open a connection and never shutdown. In such cases, a
> shutdown immediate will _never_ return (certainly not within your 5 to 10
> minutes). I have been using this method for more than 8 years now -
> starting at 7.0.16 fyi. The trick in this case is to script it into the rc
> commands.
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> I don't know what the future holds for me, but I do know who holds my
> future!
>
> ** The opinions and statements above are entirely my own and not those of
> my employer or clients **
>
>
> -Original Message-
> Sent: Wednesday, January 29, 2003 11:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Paula,
>
> Shutdown abort is not recommended as the file checkpointing is not done
> during shutdown abort.  If you need to perform shutdown abort, then, it is
> preferred to bring up the db with startup restrict (so that the users
> wouldn't connect) and then, cleanly shutdown the db and bring it up again.
>
> Tell to your sys admins. that shutdown immediate would take some time
> (about 5 to 10 minutes) depending on the activity on your db.  They would
> have to wait for that much time before calling a DBA during system boots.
>
> Rao
>
> -Original Message-
> Sent: Wednesday, January 29, 2003 11:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> System Administrator says he doesn't trust that the rc commands will stop
> if the database doesn't want to shutdown and even if it does would want to
> shutdown with scripts beforehand so that a DBA could connect and resolve
> the issue.  Other DBA says this is all wrong and rc commands should include
> shutdown immediate of database.  In the past I had setup 2 processes in the
> system scripts for the sys admin - shutdown immediate - wait  shutdown
> abort - on a read-only DSS system which of course allows some room for this
> type of activity.  I kind of would want to know if a database was going to
> be shutdown with an abort esp. in OLTP system and do it myself.
>
>
>
> - any ideas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

RE: STATSPACK

[Farnsworth, Dave]

I believe that an 8.1.7 statspack can run on an Oracle8 or higher database.

Dave

-Original Message-
Sent: Wednesday, January 29, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L


 Hello everyone,

I hope this is a quick question.  Can you run 8.1.7 Statspack on an 8.0.6.3
instance?

Thanks in advance,
Ruth

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

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

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

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

Perl scripts for hot backup

[Farnsworth, Dave]

Here is a link that I found for a Perl script for hot backups.  Just have seen a bunch 
of chatter about perl on the list lately so just wanted to throw this out in case 
someone finds it useful.

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci857677,00.html

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

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

RE: "Take Care of your DBAs"

[Farnsworth, Dave]

Title: "Take Care of your DBAs"



Thanks 
for this article.  I will forward to damagement.
 
Dave

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28, 2003 
  3:24 PMTo: Multiple recipients of list ORACLE-LSubject: 
  "Take Care of your DBAs"
  http://careerlink.devx.com/articles/hc0199/hc0199.asp 
  
  Interesting article I stumbled across.   
  Best quote:  "Stay Out of your DBA's Face"!    WELL 
  PUT! 
  Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

RE: Slightly OT: Development Vs. Production DBA

[Farnsworth, Dave]

>-realizing that marketing people are a different species
>-that will never know their needs in advance.

Amen brother, Amen

-Original Message-
Sent: Tuesday, January 28, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L


Ranganath
You are getting some excellent responses to your question (which I consider
very "on topic"). We had a good discussion on this list previously. I went
to Google and entered fatcity production dba and was able to pick up the
thread.
   As to your question of OLTP vs. DSS situations, I think the differences
are more subtle. I thing OLTP environments are more standard than DSS
environments. Our DSS is more relaxed since it is a weekly load. Sunday and
Monday are the critical days. Some of it is attitude, not being a
normalization bigot, realizing that marketing people are a different species
that will never know their needs in advance.

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


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 2:29 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I would like to know the differences between Development and
Production DBA w.r.t. Roles and Responsibilities, Scope etc.  Is there any
difference in the role(s) played by a DBA in OLTP and DSS environments?
Your invaluable viewpoints in this regard is most welcome.

Thanks and Regards,

Ranganath
WARNING: The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee.  Access to this message
by anyone else is unauthorised.  If you are not the intended recipient, any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in reliance on it, is prohibited and may be unlawful.
Please immediately contact the sender if you have received this message in
error. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishnaswamy, Ranganath
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Statspack recomendations.

[Farnsworth, Dave]

Don Burleson has a book called "Oracle9i High-Performance Tuning with STATSPACK".  
Check out the link below.

http://www.dba-oracle.com/books.htm

Dave

-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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

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

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

RE: Query Tuning Documentation

[Farnsworth, Dave]

Go have a beer, relax and re-read it.  Get him Kirti!!

;o)

Dave

-Original Message-
Sent: Thursday, January 23, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I have the Oracle Performance Tuning 101 book and I have been reading the Performance 
Tuning Guide on OTN, however, I found its explanation of when to use messages and how 
to write queries extremely terse. Are there any websites or books which focus strictly 
on query tuning that provide more in depth explanations and examples? 

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

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

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

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

RE: senior oracle dba

[Farnsworth, Dave]

-The Senior DBA position, is more of a management-type role.

More Damagement!!

Dave

-Original Message-
Sent: Thursday, January 23, 2003 7:14 AM
To: Multiple recipients of list ORACLE-L


Very good point.  I know where I work, HR classifies DBA as an analyst for pay 
reasons.  The Senior DBA position, is more of a management-type role.  More money, 
more management responsibilities but less actual DBA work.

-D-


-- 
Dwayne Cox
Oracle Database Administrator
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608

email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.


On Wed, 22 Jan 2003 11:08:07 -0800
DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:

> Bp, 
>Often where the term "Senior DBA" comes up is with company HR
> departments. It isn't usual for we DBAs to greet each other with "Hi, I'm a
> senior DBA". I agree with Mark's comments, but just wanted to point out this
> other aspect to the issue. Sometimes HR people use this as a method for
> categorizing people in terms of making sense out of salaries. HR criteria
> may have nothing to do with what you are thinking of. Personally I often
> can't understand HR criteria.
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, January 22, 2003 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Mark ,
> Thanks for the reply . I think learning is a never ending process ,
> specially in IT industry where new version of software is out before 30%
> adapts the previous version .But is there a line which can be drawn ? No one
> knows everything . But experience tells where to look for proper things and
> what plannings and cautions to be taken before adapting any change .
> 
> -Bp



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

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

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

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

Uncle Larry's new pricing scheme.

[Farnsworth, Dave]

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

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

RE: ORA-2289 - anyone?

[Farnsworth, Dave]

Try this;

GRANT DROP ANY SEQUENCE TO "luser_name"

Or if you don't want to mess around;

GRANT ALTER ANY SEQUENCE TO "luser_name"

Dave

-Original Message-
Sent: Tuesday, January 21, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Let me try this one more time. We are running Oracle 8.1.7 and I
received an ORA-2289 as indicated below.

Does anyone out there think he/she might be able to help me? Or at least
point me in the right direction.

Thanks again.
Saira

-Original Message-
Somani
Sent: January 20, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L

Hi all,

I'm new at this game and am running into this Oracle error in our
training environment. 

I have searched on the web and the archives but I am not sure about a
resolution to this issue. Any comments/insights would be appreciated.

After investigating the issue, I found that there is a crash when trying
to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other
temporary tables. 

Here are the errors:

biora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_work_item_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_work_load_err_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470  > Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470  > Error code = 2289.

Here is the description of the 2289 error:

// *Cause: The specified sequence does not exist, or the user does
// not have the required privilege to perform this operation.
// *Action: Make sure the sequence name is correct, and that you have
//  the right to perform the desired operation on this sequence.

 CUNAME:cu4
 STATUS:-255
 NATERR:-1
 ERRMSG:
 PRGSQL:INSERT INTO tmp_asn_ship
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.
[EMAIL PROTECTED]
 

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

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

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

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

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

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

RE: SqlServer and Oracle on the Same NT Box

[Farnsworth, Dave]

Tom,

Works for me.  I have Oracle 8.0.5 running on the same server as SQL Server 2000.  The 
main thing to watch for is how the two databases compete for system resources.  If 
both are going to small and have nonintensive apps you should be fine.

Dave(OT'er)

-Original Message-
Sent: Tuesday, January 21, 2003 7:19 AM
To: Multiple recipients of list ORACLE-L


All,

Has anyone installed and run SqlServer and Oracle on the same NT box?  I've
heard mixed rumors that either you can or cannot do it.  Both databases
would be very small with very few transactions.

thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, January 21, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L


I would say that tora may be a little excessive for a "regular" user.. How
about a simple php / jsp type interface? Of course, you would have to
develop this yourself..

-Original Message-
Sent: 21 January 2003 09:09
To: Multiple recipients of list ORACLE-L


hi

try this one, it's a freeware tool called Tora
http://www.globecom.se/tora/

 <>

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

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

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

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

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

RE: HELP..URGENT....NOT

[Farnsworth, Dave]

Title: Message



YES 
YES YES YES YES YES YES YES YES YES YES YES YES 
YES
 
That's the 
one!!
 
Thanks,
 
Dave

  -Original Message-From: Sherman, Edward 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 8:35 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  HELP..URGENTNOT
  Dave,
  Was it this one?>>> You might be able to find what you need at this 
  site.>>> http://web.singnet.com.sg/~petermag/oracle.html>>> Dave>>>-Original 
  Message->>>Sent: Tuesday, October 22, 2002 8:39 
  PM>>>To: Multiple recipients of list 
  ORACLE-L>>>S>>>Hi,>>>Does anyone know of any web site that contains 
  materials about performance tuning of SQL (oracle or any other database) ? 
  TIA>>>Regds,>>>New Bee
  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 5:29 AMTo: Multiple 
  recipients of list ORACLE-LSubject: HELP..URGENTNOTA while 
  back I posted a link to a website that has hundreds of Oracle links.  
  It's a site that is good for Unix and Windoze bigots, pick your flavor.  
  Well, I lost my hard drive and my internet favorites.  If anyone has that 
  link that I posted I would greatly appreciate it if you can now post it cuz I 
  cannot remember the name of it.ThanksDave--Please see 
  the official ORACLE-L FAQ: http://www.orafaq.net--Author: 
  Farnsworth, Dave  INET: [EMAIL PROTECTED]Fat 
  City Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from).  You may also send the HELP command for 
  other information (like subscribing).

RE: HELP..URGENT....NOT

[Farnsworth, Dave]

>-Obvious solution -- drink more beer.

Best tip I've read all day, I will take your advice.

Dave

-Original Message-
Sent: Thursday, January 16, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L


Dave:
Sorry about your drive.
Obvious solution -- drink more beer.
Barb

--
You might be able to find what you need at this site.

http://web.singnet.com.sg/~petermag/oracle.html

Dave


--- "Farnsworth, Dave"
<[EMAIL PROTECTED]> wrote:
> A while back I posted a link to a website that has
> hundreds of Oracle links.  It's a site that is good
> for Unix and Windoze bigots, pick your flavor. 
> Well, I lost my hard drive and my internet
> favorites.  If anyone has that link that I posted I
> would greatly appreciate it if you can now post it
> cuz I cannot remember the name of it.
> 
> Thanks
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

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

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

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

RE: HELP..URGENT....NOT

[Farnsworth, Dave]

That is not the specific one I had but it looks good.

thanks,

Dave

-Original Message-
Sent: Thursday, January 16, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L


Was this it? http://www.orakle.com/

Greg

-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L


A while back I posted a link to a website that has hundreds of Oracle links.
It's a site that is good for Unix and Windoze bigots, pick your flavor.
Well, I lost my hard drive and my internet favorites.  If anyone has that
link that I posted I would greatly appreciate it if you can now post it cuz
I cannot remember the name of it.

Thanks

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

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

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

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

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

HELP..URGENT....NOT

[Farnsworth, Dave]

A while back I posted a link to a website that has hundreds of Oracle links.  It's a 
site that is good for Unix and Windoze bigots, pick your flavor.  Well, I lost my hard 
drive and my internet favorites.  If anyone has that link that I posted I would 
greatly appreciate it if you can now post it cuz I cannot remember the name of it.

Thanks

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

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

RE: sql run by users

[Farnsworth, Dave]

Here is a script from Lisa Koivu


-- WHOS_Running_What
-- This will list the current users and the current SQL statements
-- From Lisa Koivu - 1/9/03
--
set linesize 200 
column username format a15 
column idle format a10 
column machine format a22 
column terminal format a15 
column program format a15 

select  sid, 
serial#, 
username, 
--  process, 
to_char(logon_time,'DDth - HH24:MI:SS') logon, 
terminal, 
program, 
--  floor(last_call_et/3600)||':'|| 
--   floor(mod(last_call_et,3600)/60)||':'|| 
-- mod(mod(last_call_et,3600),60) IDLE, 
status 
fromv$session 
where   username is not null 
order   by sid 
/ 


column command format a60 
column sid format 99 
column serial# format 99 
SET PAGESIZE 100 

set linesize 120 

SELECT  u.sid, 
u.serial#, 
SUBSTR(u.username,1,12) user_name, 
s.sql_text command 
FROMv$sql s, 
v$session u 
WHERE   s.hash_value = u.sql_hash_value 
AND sql_text not like '%fromv$sql s, v$session u%' 
and u.username is not null 
ORDER BY 
u.sid 
/ 


-Original Message-
Sent: Friday, January 10, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


Dear List,
how to know what sql is being run by a user session.
The problem is all users use the same application
login.
TIA
sarath

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sarath kumar
  INET: [EMAIL PROTECTED]

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

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

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

RE: Some of you may find this useful

[Farnsworth, Dave]

Log on as SYS and run it.  I have it on my 8.1.7 DB.

Dave



-Original Message-
Sent: Friday, January 10, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L


Stephane,
 My creativity has been stumulated, simulated, and mutated.
What version of Oracle are you using?
 x$kglrd ...table or view does no exist on 8.1.7 rel 3
Ron

>>> [EMAIL PROTECTED] 01/10/03 05:03AM >>>
break on proc
column "QUERY" format A40 word_wrapped
select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM
"QUERY"
from x$kglrd
where KGLNAOWN != 'SYS'
order by 1, kgldepno
/

If it doesn't stimulate your creativity I can do nothing for you :-).

Regards,

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

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

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

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

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

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

RE: Orawomen

[Farnsworth, Dave]

Oh it has, and has evolved into a more "spicey" version.

-Original Message-
Sent: Wednesday, January 08, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


I think this should be moved to the OT list.

Thanks,

Jared






Rodd Holman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/08/2003 09:14 AM
 Please respond to ORACLE-L

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


The real key to this issue is not making it a GS requirement, but in 
getting parents off their butts and being parents.  I continually work 
with my kids, especially my daughters (ages 17,16,12) to be individuals 
and go for what they like and find interesting.  Forget the pop culture 
and fashion junk you see in the mags and on the tube!  I encourage them to 
be themselves and find contentment in that.  This whole "Dork Factor" 
thing is out of control with the 10-19 age group, especially among girls.

Rodd Holman
[EMAIL PROTECTED]

Romans 1:16-17 



On Wed, 2003-01-08 at 07:54, Rachel Carmichael wrote:
Dorky rules :)

It's sad that there isn't a requirement for the science/math activities
in the Girl Scouts. The problem is that society in general doesn't show
images of science as being "cool" and definitely doesn't show images of
women as scientists. Or at least, not enough images.


--- [EMAIL PROTECTED] wrote:
> 
> Dennis,
> 
> I think that the article is correct that girls and teens are
> sensitive to
> the "geek stigma factor".Even in our 10-year-old Girl Scout
> troop, the
> girls are already concerned about their images and not being too
> "dorky".
> We have many more girls vote for activities involving animals and
> crafts
> than activities centered on math and science.   The votes are usually
> about
> 8 to 1 with only one or two girls voting to do the math or science
> activities.   Pretty sad, especially considering that the Girl Scouts
> organization tries really hard to push those technical and
> math/science
> programs and make them interesting and fun.
> 
> The 25% number cited in the article for women in the IT sector seems
> pretty
> close to the number that we have show up at our local Oracle User's
> Group
> meeting.   I think that the participation by women in our user's
> group has increased steadily in the last 10 years.
> 
> Perhaps more women are drawn to database work than IT in general as
> it tends to be more administrative than say, programming.
> 
> I'd also have to say that in many cases, being an Oracle DBA can be 
> pretty
> grueling for those with families and for women with families in
> particular.
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> 
> 
> 
> DENNIS WILLIAMS 
>  of list ORACLE-L <[EMAIL PROTECTED]> 
> TOUCH.COM>cc: 
> Sent by:  Subject: Orawomen 
> [EMAIL PROTECTED]  
> 01/07/03 05:11 PM  
> Please respond to ORACLE-L  
> 
> 
> Recently this list had a discussion of female Oracle DBAs. The
> consensus was
> that the numbers were increasing, which I view as a good thing. Here
> is an
> article with industry statistics saying that the number of women in
> IT is decreasing.
> http://itmanagement.earthweb.com/career/article.php/1564501
> Any theories?
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> --


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

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

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

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

RE: Orawomen

[Farnsworth, Dave]

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


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Orawomen

[Farnsworth, Dave]

Title: RE: Orawomen



I have 
encouraged and pushed science on my daughter and son.  My daughter started 
college this year and wants to go into the biological sciences.  I 
periodically have been a guest teacher at our local schools to teach some 
physics and am amazed at the lack of interest in general by the 
females.  And knowing many of the families of these girls I would attribute 
this to the parents.
 
My 
$.02
 
Dave

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 
  8:34 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Orawomen
  Well, it's been a while since I was in college (1999) but I 
  always felt singled out in a class.  Some teachers, that were as old as 
  the hills, truly felt that women should not be in science and did not hesitate 
  to say so.  Other teachers could not keep their eyes off my legs - I had 
  to leave work and go directly to school for years. Never mind complaining, the 
  department didn't care. There was only one woman professor, but she taught 
  advanced AI.  I never got to take any of her classes.  I never saw a 
  female physics or math professor at the university. 
  I had one (male) algebra teacher tell me that "maybe you just 
  shouldn't study math."  However it was a female teacher at a community 
  college that finally got me through 3 quarters calculus.  To this day I 
  credit her with making me feel that I was capable of understanding higher math 
  and pushing me and the whole class to do so.
  I didn't finish my bachelor's, I didn't need to and I didn't 
  need the stress.  But I can see how the declining IT market (no 
  22-year-old CIOs anymore) paired with this kind of treatment in school would 
  push a detail-oriented young woman to study something else.
  Personally I wish I would have become a nurse. 
  Just my 2 cents, for whatever it's worth. 
  Lisa Koivu Oracle No-degree 
  Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 
  -Original Message- From: 
  DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, January 07, 2003 6:11 PM To: Multiple recipients of list ORACLE-L Subject: Orawomen 
  Recently this list had a discussion of female Oracle DBAs. The 
  consensus was that the numbers were increasing, which 
  I view as a good thing. Here is an article with 
  industry statistics saying that the number of women in IT is decreasing. http://itmanagement.earthweb.com/career/article.php/1564501 
  Any theories? 
  Dennis Williams DBA, 40%OCP 
  Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: DENNIS WILLIAMS   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: Orawomen

[Farnsworth, Dave]

I like geek girls!!

Dave

-Original Message-
Sent: Wednesday, January 08, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L



Dennis,

I think that the article is correct that girls and teens are sensitive to
the "geek stigma factor".Even in our 10-year-old Girl Scout troop, the
girls are already concerned about their images and not being too "dorky".
We have many more girls vote for activities involving animals and crafts
than activities centered on math and science.   The votes are usually about
8 to 1 with only one or two girls voting to do the math or science
activities.   Pretty sad, especially considering that the Girl Scouts
organization tries really hard to push those technical and math/science
programs and make them interesting and fun.

The 25% number cited in the article for women in the IT sector seems pretty
close to the number that we have show up at our local Oracle User's Group
meeting.   I think that the participation by women in our user's group has
increased steadily in the last 10 years.

Perhaps more women are drawn to database work than IT in general as it
tends to be more administrative than say, programming.

I'd also have to say that in many cases, being an Oracle DBA can be  pretty
grueling for those with families and for women with families in particular.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
DENNIS WILLIAMS
  

TOUCH.COM>cc:  
  
Sent by:  Subject: Orawomen
  
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
01/07/03 05:11 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Recently this list had a discussion of female Oracle DBAs. The consensus
was
that the numbers were increasing, which I view as a good thing. Here is an
article with industry statistics saying that the number of women in IT is
decreasing. http://itmanagement.earthweb.com/career/article.php/1564501
Any theories?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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





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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, 

RE: FULL TABLE SCAN?

[Farnsworth, Dave]

Title: RE: FULL TABLE SCAN?



It's a 
bit buggy in 8i!

  -Original Message-From: Deshpande, Kirti 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 
  1:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: FULL TABLE SCAN?
  Is 
  that backported to 8i and 7.3 ???  :>)
   
  ;) 
  
   
  Thanks.
   
  - 
  Kirti
  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 
  11:05 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: FULL TABLE SCAN?
  _full_table_scan=FALSE 
  -Original Message- From: Seema 
  Singh [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, January 07, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: FULL TABLE SCAN? 
  Hi How to avoid FULL TABLE 
  SCAN? Thx -seema 
  
  _ 
  MSN 8 with e-mail virus protection service: 2 months FREE* 
  http://join.msn.com/?page=features/virus 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Seema Singh   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: FULL TABLE SCAN?

[Farnsworth, Dave]

Create a meaningful index and keep your stats up to date.

Dave
The OT list rules

-Original Message-
Sent: Tuesday, January 07, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L


Hi
How to avoid FULL TABLE SCAN?
Thx
-seema





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

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

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

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

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

RE: Unix for oracle dba -- Suggest a book ?

[Farnsworth, Dave]

Hallo,

What is manuals?

TIA

-Original Message-
Sent: Monday, January 06, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L



Doesn't anyone read the manuals any more?!

Oracle9i Installation Guide - Unix
  http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
  http://download-east.oracle.com/docs/html/A97297_01/toc.htm




   
  
  "James Damiano"  
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .nh.us>  cc: 
  
  Sent by: Subject:  Re: Unix for oracle dba -- 
Suggest a book ? 
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/06/03 06:28 AM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

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






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

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

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

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

RE: audit user activities

[Farnsworth, Dave]

I seem 
to be drawing a blank on this one.

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 
  8:19 AMTo: Multiple recipients of list ORACLE-LSubject: 
  audit user activities

RE: doubt

[Farnsworth, Dave]

In 
Query Analyzer select the database if interest and then run
 
EXEC 
SP_HELP (really, this is not a joke)  ;o)
 
It 
will list system and user objects within that DB.
 
Dave

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 8:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  doubtDear all,                   
       we use  "select * from tab" to list all objects in a 
  particular user in oracle. could you tell 
  me the equivalent query in sql server ?   
  Regards Jai