RE: missed Anjo's webcast..

[Ivan_Rivera]

Title: RE: missed Anjo's webcast..





I'd pay double the retail for it!


-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: missed Anjo's webcast..



I would also like a copy of that book!


April


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L



Ditto.  Put me down for at least one copy!  


Scott Shafer
San Antonio, TX
210-581-6217



> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: missed Anjo's webcast..
> 
> Cary,
> 
> I'd like to place my pre-order on that book right now please.
> 
> Rachel
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > * * *
> > 
> > Within the next few months, I hope to have completed my book project
> > ("Oracle Response Time Optimization" or some-such). The questions on
> > this list are exceptionally good inspiration for such a project, by
> > the
> > way. When the book is finished, if I still haven't convinced you,
> > then I
> > simply won't have done my job.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


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

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


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I
M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O
M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L
M>2!P
M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I
M;W!Y:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@
M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@
M86=E(&EN(&5R
M871E;'D@8GD@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI
M(&)E96X@
M:71Y(&9O
M;V9T=V%R92!V:7)U6]U(&-A
M(&]W;B!V:7)U
%;G0N#0H 
end


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


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

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

Cache' Database

[Ivan_Rivera]

Title: Cache' Database





Hello all,


I am getting a new contract that will be dealing solely with cache database management.  Does anyone out there have any experiences with cache that they wouldn't mind sharing?  Pro's and con's, good stories, horror stories anything and everything is welcomed. I'd like to see what other oracle dba's have thought about it. I also would like to know if there are any list groups like this for Cache and/or any good websites besides the intersystems site? Thank you all very much. Ivan

RE: Cache' Database

[Ivan_Rivera]

Title: RE: Cache' Database





Thanks guys.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cache' Database



Ivan - This was discussed recently on this list. Here is the discussion for
your convenience.
  
  Support
the Oracle FAQ by supporting our sponsors. Click here! 


RE: RE: Intersystems Cache database


[ Index   ] [
Raw   Message
]



Message-ID:     <[EMAIL PROTECTED]> 


Date:   Fri, 22 Mar 2002 06:43:23 -0800 



I have some past experience with MUMPS - Run like h@#$ and don't look back.


If CACHE=MUMPS it most definitely is false advertising.




Scott Shafer


San Antonio, TX


210-581-6217




"Common sense will not accomplish great things. Simply become insane and


desperate."




> -Original Message-


> From: Norrell, Brian [SMTP:[EMAIL PROTECTED]]


> Sent: Thursday, March 21, 2002 7:23 PM


> To:   Multiple recipients of list ORACLE-L


> Subject:  RE: RE: Intersystems Cache database


> 


> "Hospital" is the key.  Cache was originally developed in the '70 for


> use in medical applications, of course, back then it was known as MUMPS


> before the PR guys got a hold of it.  The UNIX types will tell you that


> any app that has been around for three decades has to have something


> going for it.


> 


> Some of the DBAs around hear played with it, and were not impressed.


> Apparently recovery in the event of any failure was a nightmare.


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 5:14 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> I've heard of them...  Some guys at the last place I was at had used it


> as


> the back end for a lab results viewer at a hospital in the Boston


> area...


> They loved it...  They kept telling me how great it was but I never saw


> it


> in action...  I took most of it with a grain of salt since they were


> developers...  


> 


> As far as the 4 million users go...  If you consider each hospital


> employee


> a "user"...  Of better yet, each patient a "user"...


> 


> :-)


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 5:19 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> Anyone else ever hear about them?  According to the web site that have


> '4


> million users'.  Seems that would have left a mark somewhere at that


> level.


> 


> Dick Goulet


> 


> Reply Separator


> Author: "Jesse; Rich" < [EMAIL PROTECTED]
 >


> Date:   3/21/2002 1:58 PM


> 


> Yeah, like that ain't a plug from someone acting like an Oracle DBA.


> 


> 1)  No signature.


> 2)  Generic e-mail account from a generic mail domain.


> 3)  No recent posts to this list.


> 


> Probably just a Cache salesman...


> 


> Rich Jesse   System/Database Administrator


>  [EMAIL PROTECTED] 
Quad/Tech International, 


Sussex, WI


> USA


> 


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 3:23 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> Hi,


> 


> Does anyone know about the Cache database?  Is it REALLY that


> robust as they claim to be?


> 


>  http://cache.intersys.com/cache/fb/fb_03.html
 


> 


> Thanks.


> -- 


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


> -- 


> Author: Jesse, Rich


>   INET:  [EMAIL PROTECTED]  


> 


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051


> San Diego, California    -- Public Internet access / Mailing Lists


> 


> To REMOVE yourself from this mailing list, send an E-Mail message


> to:  [EMAIL PROTECTED]   (note EXACT
spelling of 'ListGuru') and 


in


> the message BODY, include a line containing: UNSUB ORACLE-L


> (or the name of mailing list you want to be removed from).  You may


> also send the HELP command for other information (like subscribing).


> -- 


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


> -- 


> Author: 


>   INET:  [EMAIL PROTECTED]  


> 


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051


> San Diego, California    -- Public Internet access / Mailing Lists


> 


> To REMOVE yourself from this mailing list, send an E-Mail message


> to:  [EMAIL PROTECTED]   (note EXACT
spelling of 'ListGu

RE: Creating Scott/Tiger

[Ivan_Rivera]

Title: RE: Creating Scott/Tiger





The why not run the SCOTT.sql script in the RDBMS\admin directory. That's the script to just create scott, and the table emp, dept and salgrade with their data. That's the original script If I remember correctly. Sorry for coming into the convo so late.

-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 4:43 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Creating Scott/Tiger



There are differences in the two scripts as I recall. The sqlplus demo
scripts
do not build the scott account, and only build the basic dept, emp tables
with
some data.


The utlsampl.sql script is much more encompassing, creating users
scott, adams, jones, clark and blake, granting privs, creating tables
with pk's and fk's. Much more complete.


RF


Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)


The avalanche has begun, It is too late for the pebbles to vote.




-Original Message-
Sent: Friday, August 30, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L



Hi Jonathan


> I need to create the Scott/Tiger schema in Oracle9i. Does anyone
> recall off the top of their head just where the script to do this is
> located?


The creation script can usually be found in
${ORACLE_HOME}/sqlplus/demo/demobld.sql


Regards
Dale
--
Need instant schema documentation? Check out the DDL to HTML generator in
the free DataBee DBATool. http://www.DataBee.com/dt_home.htm


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


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

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


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

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

RE: financial problems with fatcity.com

[Ivan_Rivera]

Title: RE: financial problems with fatcity.com





Alex, that is an excellent idea! I second that notion. 


I have learned just as much if not more from this list than the average $40-80 dba book out there (101 tuning and dba excluded, I've just ordered practical 8i and await that one). I think we can easily come up with the $500 a month figure, and that's this list alone. If you sum up all the rest of the lists...Bruce may be able to bring it down to 6 bucks a year maybe.

12 bucks a yearsh*t (Ladies forgive me here, I'm just a young buck trying to make a point) I've spent more than that for a lap dance and that was only to have someone rub an @ss on me, where you all have saved MY @SS literally more than once!!! This list is invaluable.  Put me down for 12 bucks a year. Ivan 

ps. I by no means wanted to offend anyone, if so I am sorry and please forgive me. ;) Long Live the List!
-Original Message-
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Subject: financial problems with fatcity.com



I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.


Alex Hillman


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


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

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

Off topic Perlesque question

[Ivan_Rivera]

Title: Off topic Perlesque question





I know this is off topic but if I can get grab you perl guru's ear for second I'd greatly appreciate it.  First I'd like to ask for a better place to post these types of questions.  A perl list would be ideal but my boss has explicitly said I can join no more lists - my mail box is getting too big :(.

os (I know here's the fundamental problem) : Win2K
perl: ActiveState 5.6.1.630
Microsoft C++ Visual Studio 6.0


Ok now to the problem.  I am having trouble using cpan to install certain modules/Bundles.
I have been able to use ppm to install most of the modules I need but there are still 7-10 that I believe need to be done through the cpan interface.  The problem I am having with cpan is when it's ready to compile the code it never works because of make problems.  

I have tried to download nmake instead to see if that would work but to no avail.  I am making the correct changes in the config.pm file where it says make='blah blah'  but the command is always bombing out and thus if no make test it will not continue the real make.  Has anyone else had this problem or know how to fix it? What else can I do?

I believe that the problem is in the syntax that cpan is using to compile things is not compatible with the windows version of make. The readme I used suggested to download nmake and use that but again the syntax seems different. 

In the cpan error I see it doing:  make -f blah blah
but the windows make help command shows all arguments should be like '/A' and I havent seen an argument for force.  Does anyone know of a make out there for windows that behaves as unix in terms of syntax?  

My ultimate goal is to get slashcode to run on this machine for a web site but have to do it on a windows machine.  I am terribly lost and don't know what to do next or where to look. Any advice would help thanks. Sorry for being so lengthy and off topic I don't know where I can post this and still be able to get a reply. Wish I could join an additional list.

Is there any file I can edit so that every time cpan calls for 'make -f' I can substitute it with a syntax my nmake command will accept? Thank you very much. Ivan

RE: 9i new features, the saga continues?

[Ivan_Rivera]

I'm interested in it too.  I'm a lurker 
but a lurker that's still interested if that means anything.

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 
  9:33 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: 9i new features, the saga continues?
  Yes, I am *still* interested Joe.
   
  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!
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 
9:14 AMTo: Multiple recipients of list 
ORACLE-LSubject: 9i new features, the saga 
continues?
Ok life has slowed down some and i've got some free time to potentially 
pickup the 9i new features saga i did about 6 months ago.
 
Anyone still interested?
 
The next on the list was 9i data guard.
 
joe
 

Clusters and IOT's

[Ivan_Rivera]

Greetings to all.
  
I have to teach a small dba class tonight and we will be covering clusters and 
index organized tables. I am a young dba and have never used or managed either 
on.  Can some one please give me some real world examples of when its ideal 
to use these.  Also which tends to be better, hash clusters or index 
clusters. Any real world advice about these would be helpful. Thanks allot. Ivan 
Rivera

RE: Clusters and IOT's

[Ivan_Rivera]

Title: RE: Clusters and IOT's





Thanks to all those who replied. I can see using IOT's but I don't find much practicality in clusters. Later everyone. Have a great weekend. Ivan

CURSOR_SHARING = FORCE ques.

[Ivan_Rivera]

Title: CURSOR_SHARING = FORCE ques.





Gurus


Well the boss is now getting on my back for me to upgrade my OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, but work is insisting that I do.  So now I'm studying the upgrade book and it's sparked up a couple of questions regarding cursor_sharing = force.

1) I've heard a bunch of negative things (like bugs) regarding using this feature, was this just with 8.1.6 or is it still buggy?

2) Anyone out there using it?  Does it give that much better performance gains?  It seems to me like it's not worth implementing.

3)Can the guys playing with 9i out there verify if this is buggy in 9i?


Thanks to all.
Ivan Rivera 

RE: CURSOR_SHARING = FORCE ques.

[Ivan_Rivera]

Title: RE: CURSOR_SHARING = FORCE ques.






Thanks to all who responded. I've gotten mixed reviews, basically it's great as long as it's working right (no bugs). I wonder how it works on 9i? Thanks again everyone. Ivan

Help, processes won't die

[Ivan_Rivera]

Title: Help, processes won't die





I need some assistance ASAP.  Our nightly batch process seems to have hung up for some strange reason (ok no biggie my boss says kill it and start it again).  The problem is I have killed the processes both in oracle (sid, serial#) and also in unix. Now I can't see the processes in unix but in oracle they have a status of killed but are still holding the resources. My thinking is telling me the pmon is not waking up or not doing it's job. How can one manually tell a process to wake up. Any help will be greatly appreciated. 

OS Solaris 7
Oracle 8.0.6.3


Thanks. Ivan

RE: Help, processes won't die

[Ivan_Rivera]

Title: RE: Help, processes won't die





Thanks to all that have replied.  I ended up having to bounce the db.  I just did a startup force which I know does an abort, I probly should have tried an immediate first.  I'll be tracking this process (batch) tonight and make sure that nothing else goes wrong. I believe it had something to do with our gateway and too many ORA-2063's happening. I'm going to research into what going on with the informix db's that pump the info into the oracle box. Thanks again to all. This list is the BOMB!

RE: OT -- suggestions to ensure nerdiness in potential IT staff

[Ivan_Rivera]

Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff





I have to agree with Kevin, this thread is great. However it makes me feel like I really am in the wrong profession, at the wrong time in the wrong place :( . 

In 1981 I was 5 years old and I've never really touched a computer until about 3 years ago, let alone know any of the answers to any of those questions.

You guys are great! I have learned so much from this list.  Not only the technical stuff but learning about the IT and dba culture from you all is invaluable!  I went to school for psych, so some of this old school talk that us young ones would hear from college cis professors I unfortunately never received, much less the knowledge of that curriculum.

I am speechless when I step back and look at this list and realize how diverse this list really is.  I mean we have list members from so many parts of the world and from so many different walks of life.  Who would have ever thought that this young Puerto Rican punk from the 'hood would have anything in common with you all? 

I can see us all now at a bar after an oracle event, me in my baggy jeans, timberland boots, Iceberg shirt, etc. enjoying beers with you all. Everyone enjoying and sharing a common bond (dba, oracle) that brings us all together.  Most of you all's peers wouldn't even look our way or have two words for me and my friends in our natural environment. But I think I'd feel just as comfortable around you all as I do at a block party in Bed-Stuy or chilling with some of my friends in Liberty City, Miami.

All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD LOVE FOR YALL! (translation: I hold you all in high esteem and greatly admire and respect you all). Thanks for everything. Ivan  

RE: OT -- suggestions to ensure nerdiness in potential IT staff

[Ivan_Rivera]

Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff





Sorry for the last email, I didn't mean to send it to the list.  If anyone by chance read the whole thing and has any questions, feedback or advice I welcome it all. Again sorry for the long message. Ivan

RE: OT -- suggestions to ensure nerdiness in potential IT staff

[Ivan_Rivera]

Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff





Famous...I hope at least recognized by my deeds.  It's funny this is coming up, I am currently in the middle of starting a dream of mine. 

Basically I am starting a non profit organization designed to teach these hot in demand IT skills to a resource this country has overlooked-young inner city minorities. I know there are people already trying to do similar stuff and oracle has there program they're working on with high schools, but I feel that my business plan and ideas will be superior to what's currently out there, not to mention that I will have an execution plan these kids will latch onto, different from the traditional high school setting they're tired of. 

I feel that I am an example of what I can do with them, as I said I didn't go to college for CIS, am not a super brain, but I had an interest in computers and also a hunger to make a good living (legally).  In the span of three years I have fully changed around my life.  I now make good money (I am currently putting my sister through college) and am living a great clean life. Oracle literally kept me out of jail (no need to go into specifics)! 

I feel this IT route is a new alternative for inner city youth to make it out of the 'hood. This is a more realistic manner to a good life than the traditional routes of making it big in: sports,music,entertainment or going the wrong route and getting into dealing drugs. I am living just as good as most of the drug dealers I know or have come in contact with and being realistic here, these guys are looked up to by the younger kids in the neighborhood.  As a kid I always looked up to them and still see the same thing going on today. If I can get these kids to see a different way to attain the same possessions the dealers have (for the most part, that's what it boils down to-money and material objects) and get some in the IT field, I've done my job.

I have been teaching the DBA track here at FSU for the last in preparation for the stated above goal and have started to recruit people for the board and also to teach. Today, in fact I received the conformation that I have been given education consent from the New York State Department of Education (yes!), next comes the 501(c) and I'll be quitting my job hoping to get this thing off the ground. In fact Rachel I have had you in mind to ask to join my board but haven't approach or asked the board for input until I was 'official'. Sorry for ranting, any advice (good or bad) will be greatly appreciated. Thanks. Ivan 

RE: UWIN and Oracle

[Ivan_Rivera]

Title: RE: UWIN and Oracle





Have you made sure that your path variable is set correctly? If I recall I was able to use all of the oracle command line tools through uwin. Please double check your .profile file and make sure that your oracle bin directory is included. Or you can check to see if it will work at all by explicitly going to the correct directory (cd /C/orant/bin or whatever) and type ./sqlplus or ./svrmgrl . This is assuming version 8 or 8i as there is no svrmgrl in 9i. HTH. Ivan

-Original Message-
From: Anjan Thakuria [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Subject: UWIN and Oracle



Hi Gurus,


Any body got any experience using UWIN on NT with oracle. I can't seem
to do anything like starting sqlplus, svrmgrl or lsnrctl..


Any hints/suggestions will be most welcome. I am trying out the eval of
ver2.9.



Thanks


Anjan

OT: Web Logic Server

[Ivan_Rivera]

Title: OT: Web Logic Server





Greetings to all.


Are there any Web Logic Guru's out there? Does anyone know of any forums/lists or url's that deal with web logic issues. Searching google seems to only point to bea's site. Anyone out there running 4.5.1?  We're having some complications here that I just can't figure out and searching and reading from docs.bea.com isn't helping. Thanks

RE: Info=> Help tuning the SGA...

[Ivan_Rivera]

Title: RE: Info=> Help tuning the SGA...





Looking at the scripts you are querying the best advice I would give is close and put away Niemiec's Book (Oracle Performance Tuning tips and techniques)!  It has some use, but if you are new to tuning and you said this is a learning process for you, then learn it correct the first time not the old "classical" way (takes way too long and not worth learning bad habits you'd have to break later).  Trust me on this one. 

Next go and buy Oracle Performance Tuning 101. Now...go...buy!  IMHO it's worth every penny. Then get your free memberships from www.orapub.com and www.hotsos.com ,download every paper and article you can get for free and whatever free tools also.  READ THESE, the read em again.  That book and these two sites alone will put you on the right track to correct performance tuning/management and I guarantee you'll get way more bang for your tuning buck, not to mention the time you'll save and the bad habits you'll leave behind. Also check out www.vampired.net and www.ixora.com.au and any other list member sites/books (Jonathan Lewis, Guy Harrison). I don't mean to seem like I'm brown nosing the members of this list, but they really know their sh*t.

RE: Extents size.

[Ivan_Rivera]

Title: RE: Extents size.





Why is that?  And would that only count for an object in a dictionary managed tablespace?  Would the time/speed it takes for drops and truncates really matter as far as performance is concerned? What I mean is who would set storage specs for objects with the speed it takes for truncates and drops of that object in mind?  It would seem to me that if an object is getting dropped or truncated that often that speed should be an issue, there are bigger problems at hand. Guru's correct me if I'm wrong please. Later, Ivan 

-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Extents size.



Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year back by 
a list member on that.


Regards


MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800


That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.


The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L


May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.




-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L



Hello,


I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).


Regards,


Thanh-truc Nguyen


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


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

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


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

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


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

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



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


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


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

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

RE: Extents size.

[Ivan_Rivera]

Title: RE: Extents size.





This thread has been very interesting and causing me to learn and go read some more.  Which leads me to my next question.  Does anyone have any good papers or urls that will discuss and explain all of the base data dictionary tables: fet$, uet$, etc.? Or anyone have a data model of how all of the tables relate.  I've only been in this long enough to feel comfortable with the data dictionary tables and v$views and have never delved into learning about the base tables, maybe it's time I do some serious studying. If anyone can point me into the right direction as far as learning this topic, I'd really appreciate it. Thanks. Ivan

-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 6:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Extents size.



As far as DDL is concerned ,Yes. I have seen Dataware House application(not 
a good design) that dropping/truncating tables with lot of extents takes 
longer time because of extent management. Such code must take into account 
no of extents of such objects. If those objects are created with proper 
sizing then it will perform better for any DDL.
Regards



MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:15:30 -0800


Why is that?  And would that only count for an object in a dictionary
managed tablespace?  Would the time/speed it takes for drops and truncates
really matter as far as performance is concerned? What I mean is who would
set storage specs for objects with the speed it takes for truncates and
drops of that object in mind?  It would seem to me that if an object is
getting dropped or truncated that often that speed should be an issue, there
are bigger problems at hand. Guru's correct me if I'm wrong please. Later,
Ivan


-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L



Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by


a list member on that.


Regards


MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800


That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.


The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L


May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.




-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L



Hello,


I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).


Regards,


Thanh-truc Nguyen


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


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

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


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

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


Fat City Network Servi

RE: Toad vs SQL Navigator

[Ivan_Rivera]

Title: RE: Toad vs SQL Navigator





We have sqlnav here at my site, it's cool and all but pretty expensive.  I really liked ezsql and am sad to see it go away (damn shame).  I have a question, since it's no longer available for sale how illegal would it be for me to obtain a key from someone to use it?  I mean I'd love to pay the 100 bucks for it, but there seems no way to get it and I don't want to pay for toad. 

Lets say some independent record company/band makes a great album and then 2 years later the band breaks up and the company dissolves.  Since there are no means for me to purchase the album anymore,  is it illegal to get a copy from a friend to enjoy it?

Instead of sqlnav I'd recommend getting pl/sql developer from Allround Automations www.allroundautomations.nl.  I first heard about it from Christopher Spence and when I checked it out myself it does everything that sqlnav will do.  The great thing is that it's only 150 bucks!  I'm sure there might be a couple of features in SQLNav that pl/sql developer lacks but IMHO it definitely wouldn't justify the price difference. Later, Ivan


-Original Message-
From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Toad vs SQL Navigator



Hi All,


We are looking at purchasing TOAD or SQL Navigator from Quest. I think they
have purchase EZSQL also which I liked(good and cheap). I guess there goal
is to
eliminate the competition.  I have some experience with free version of TOAD
but not with SQL Navigator.
Can someone share there pros/cons,why purchase one over the other, etc. if
they have used both of these products?



Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]


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

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

RE: Sqlloader - important

[Ivan_Rivera]

Title: RE: Sqlloader - important





I think the problem lies in the fact your missing a comma and a single quote:
"DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)"


shouldn't that be: "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)" ?


Later, Ivan


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader - important



Hallo,



Why does this sqlloader ctl file give me this errormessage?


the control file looks like:


load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table  kampanjtyp_kopia
FIELDS TERMINATED BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)



SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated



Thanks in advance


Roland S



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


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

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

RE: How do you change default oracle home?

[Ivan_Rivera]

Title: RE: How do you change default oracle home?





The easiest way I know to do this is to right-click on my computer and then go to the advanced tab -> click on environment variables -> then make sure that your ORACLE_HOME environment variable is set to the same one you chose in the oracle home selector and also that ORACLE_SID is set to the correct sid. HTH. Later, Ivan 

-Original Message-
From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: How do you change default oracle home?



Hi


I have Oracle, 8,8i,9i installed on Win 2k. I want to have 9i as default
oracle home. Where can I do that? I have tried using Oracle Home selector
which was
set to 9i but still defaults to reading service name from 8.0.  Oracle help
says change path environment, variable to have 9i first. That does not work.
I could not find anwwhere is registry to set this.  My ultimate goal is to
run some Pro*C programs and use Ora9i as the default home.


Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]


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

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

RE: Oracle related docs/OCP materials

[Ivan_Rivera]

Have 
you guys checkout out www.freeocp.com 
created by one of our own list members Mr. Ethan Post? 

  -Original Message-From: Arslan Bahar 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 13, 2001 10:25 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle related docs/OCP materials
  these  sites  contain  some 
  resources
   
  www.oraclenotes.com
  http://certcities.com/
  http://www.oraclepower.com/
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Santosh VarmaSent: 
Tuesday, November 13, 2001 9:55 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: Oracle related docs/OCP 
materials
I also found 
the site not useful. it did not have any documentation/tutorials at all. 

regards,Santosh Varma
 

RE:

[Ivan_Rivera]

Title: RE: 





but why?


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:



When and how


Patrice Boivin
Systems Analyst (Oracle Certified DBA)



    -Original Message-
    From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
    Sent:   Tuesday, May 29, 2001 1:41 PM
    To: Multiple recipients of list ORACLE-L
    Subject:    RE: 


    what


    -Original Message-
    Andrea
    Sent: Tuesday, May 29, 2001 11:47 AM
    To: Multiple recipients of list ORACLE-L



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


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


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


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

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

RE: 9i download

[Ivan_Rivera]

Title: RE: 9i download





Paul and all others interested.  Ebay seems to be a great source for used sun boxes, I've also noticed at sun's site they have a new workstation for $999.  Now of course you'd probably need more ram but this setup looks like it can handle and run 9i, etc for testing purposes at home. Hardware guys out there could you determine if this is enough? Thanks. Ivan Rivera

http://store.sun.com/catalog/doc/BrowsePage.jhtml?cid=60357&catfocus=Desktops

list of good links

[Ivan_Rivera]

Title: list of good links





Greeting to all,


My machine got totally hosed and I need to rebuild a new one.  I recall a little while back there was a post with a bunch of links to good dba sites. Can someone please send this to me? Thank you very much. Ivan

RE: list of good links

[Ivan_Rivera]

Title: RE: list of good links





Thanks to all who replied.  You guys are great! (like the cereal). Later, Ivan

Stress Test Apps

[Ivan_Rivera]

Title: Stress Test Apps





Greetings to all.


Does anyone out there know of any free, shareware, open source applications for stress testing a system/database?  Or has anyone created their own or have a set of procedures/methodologies which they use to stress test they'd like to share. I'd really appreciate it.  Or if you know of any good cheap ones out there (yeah right)? Can you please let me know. We're looking at getting Rational's stuff but you can only simulate as many users as you have licenses (sucks!). Much thanks. Ivan Rivera