Bye...

2004-01-30 Thread Jared . Still
bye...

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Jared . Still
The Windows service implements Oracle's VOS ( virtual OS ) This is not noticed on *versions, as there is no separate step. See James Morle's book 'Scaling Oracle 8i'. Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/30/2004 07:44 AM  Please respond to ORACL

Re: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as

2004-01-30 Thread Jared . Still
essage - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, January 30, 2004 5:44 PM > Jared Still  scribbled on the wall in glitter crayon: > > > A repost of a previous message. > > > > This is the last day for this address folks.

Re: [Q] wait time /lob def

2004-01-29 Thread Jared . Still
That is an interesting use of an alternate block size Jonathan. "Jonathan Lewis" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/29/2004 09:59 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                

RE: UNION ALL Query: Riddle

2004-01-29 Thread Jared Still
mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other info

[Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as of

2004-01-29 Thread Jared Still
subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network

Re: [Q] wait time on stat

2004-01-28 Thread Jared Still
ED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE your

RE: UNION ALL Query: Riddle

2004-01-28 Thread Jared Still
-- 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 &#x

Re: measuring TPM

2004-01-28 Thread Jared . Still
My reply would be something along the lines of "A transaction as you would like it to be measured is  best measured in the application.  I can provide you with IO per minute, broken down into reads and writes, and a number of other statistics." What they are asking for cannot be measured from d

RE: !!Please Read - Oracle-L is moving!!

2004-01-28 Thread Jared . Still
You sir, have obviously never done this. I have.  :) Nor read my first post on the matter. No, it would not be easier, not by a long shot. This is free service, so my thinking is, share the workload. Jared <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/27/2004 11:49 PM  Please re

Re: UNION ALL Query: Riddle

2004-01-27 Thread Jared . Still
Q:  What does "different results" mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What about doing it without the parallel hints?  The tables aren't so big that it would take a long time to find out. Jared "Pillai, Ra

Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread Jared . Still
Of course you also need to consider the application. Will there be large number of users? Does this query run often, or just occasionally? Scalability comes into play, and a method that requires fewer oracle resources ( latches ) is preferable, if possible. Jared David Hau <[EMAIL PROT

Re: Problem with jobs

2004-01-27 Thread Jared Still
rt file it doesnt appear nothing related > with the jobs. > > > > So early at morning I have to run the jobs manually > > > > Im thinking on shutdown down database but I want It to be the last > option. > > > > I hope you can help me > > > >

! READ THIS - Oracle-L@fatcity.com is shutting down as of 1/31/2004

2004-01-26 Thread Jared Still
/maillist.html Thanks for reading. Jared ( List Owner ) -- 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

Re: String manipulation

2004-01-26 Thread Jared . Still
Here is an example for you. You might want to spend some more time studying the instr() function in the SQL manual to understand how this works.  :) define t = 'mystr1~mystr2~mystr3' var t varchar2(30) begin    select '&&t' into :t from dual; end; / select    substr(:t,1,instr(:t,'~')-1) t1

Re: What to look for in STATSPACK report

2004-01-26 Thread Jared . Still
                               look for in STATSPACK report > > Jared, > > I played YAPPPACK quite often some time ago. I like it very much. But > somehow I failed to generate the gif file from the csv file as sample > shown. Can someone shade me some light on this? I tied ve

Re: ROWID PROBLEM

2004-01-25 Thread Jared Still
RANDOM TIMES > IN TIME FIELD !!! > > THAT HAPPEND WITH ME IN ONE TABLE ONLY > > > > WALEED HAGGAGY -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Jared . Still
Seriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list.  This one's days are limited to about 10. <[E

Re: Oracle 8.1.7 can only use the first 15th indexes?

2004-01-23 Thread Jared . Still
Ah, we've discussed this system a couple times in the past. Jared PS. Ok, ya'll move to the new list now, ya hear! Tim Gorman <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/22/2004 08:24 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L

Re: What to look for in STATSPACK report

2004-01-23 Thread Jared . Still
K quite often some time ago. I like it very much. But > somehow I failed to generate the gif file from the csv file as sample > shown. Can someone shade me some light on this? I tied very hard to > make > the graphs from the csv file but just don't know how. > > Thanks, &

Re: OT: Solaris: Finding the cause for disk space growth

2004-01-23 Thread Jared . Still
One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with sor

Re: What to look for in STATSPACK report

2004-01-22 Thread Jared . Still
te often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: > > Y

Re: What to look for in STATSPACK report

2004-01-22 Thread Jared . Still
much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: > > You will find a utility add on for stat

Re: test please ignore

2004-01-22 Thread Jared . Still
oops! wrong list, eh?   :) "EPS - DBA (Group)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/22/2004 11:39 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        test please igno

Re: How to get unique value using AWK?

2004-01-22 Thread Jared . Still
And please notice that no sorting of the input is required, unlike awk|sort|uniq Jared Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/22/2004 08:54 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>      

RE: !!Please Read - Oracle-L is moving!!

2004-01-22 Thread Jared . Still
Give it a little time, you'll get it. Jared "Arnold, Sandra" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/22/2004 11:49 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        RE

Re: !!Please Read - Oracle-L is moving!!

2004-01-22 Thread Jared . Still
cribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site -  http://www.freelists.org/login.html

Re: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

2004-01-22 Thread Jared Still
le-L archives at > fatcity.com > will be available. > > Instruction for subscribing to the new list are at the end of the > message. > > I look forward to seeing you all at [EMAIL PROTECTED] > > Jared Still > > -- > > to subscribe: > send

!!Please Read - Oracle-L is moving!!

2004-01-21 Thread Jared Still
to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED]

RE: help

2004-01-21 Thread Jared . Still
LOL!! Ok, Ashish, the problem is you sent 'help'  to the list address. Send HELP to [EMAIL PROTECTED] and all will be well. Ok, now back to work everyone. Jared "Odland, Brad" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/21/2004 07:59 AM  Please respond to ORACLE-L            

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Jared . Still
Kirti, you're back! Must have finished the book.  :) Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Did you try increasing P_A_T to a larger number?   Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting.   Also, did

Re: FW: Disk capacity planning

2004-01-21 Thread Jared . Still
See the "Ratio Modeling" paper at Orapub.com It is a quick and dirty method for capacity planning. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]  01/21/2004 01:34 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc

Re: Parallel Query determined by?

2004-01-20 Thread Jared . Still
No other replies yet, so here goes. First of all, what does it really mean when you say: users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait". Are these end users, or developers?  Seems rather curious that users would be mentioning this. Second, what % of

RE: Spool to Excel File

2004-01-20 Thread Jared . Still
> If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Didn't realize. In any case, Perl is a much superior tool for this.  The SpreadSheet::WriteExcel module  allow you to write to individual pages in a workbook. Jared

Re: OT: Developer Mailing List

2004-01-20 Thread Jared . Still
There is no other list similar to this one. Mark Burgess <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/20/2004 01:29 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        OT: Deve

Re: Spool to Excel File

2004-01-20 Thread Jared . Still
Strange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared "Mudhalvan, Moovarkku" <[EMAIL PROTECTED]> Sent by: [EMAI

Re: NEW LYRICS TO BEATLES SONGS - OT but nice

2004-01-20 Thread Jared . Still
Please, let's not turn this into a bulletin board. Spontaneous humor in a conversation (thread) is one thing, cutting and pasting completely non-relevant articles is another. For those of you that are non-native English speakers, the one thing... another thing  phrase means "don't do this". Jar

Re: Oracle vs Mysql

2004-01-19 Thread Jared Still
o send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Goulet, Dick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051

RE: Oracle vs Mysql

2004-01-19 Thread Jared . Still
If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect.  The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/19/2004 04:04 PM  Please respond to OR

RE: SYS Privilege

2004-01-19 Thread Jared . Still
If you haven't done so, you need to set the environment variable ORACLE_SID. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/19/2004 03:34 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:

Re: What to look for in STATSPACK report

2004-01-19 Thread Jared Still
istGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: OS authentication; remote login; domain qualification

2004-01-18 Thread Jared Still
gt; > > What I think issue here is, the connection is thru tns-listener and the NT domain > and the server machine are different. > > Is there any solution for this / Is it possible to connect the remote unix DB server > with OS authentication from

Re: Reset sequence at midnight

2004-01-15 Thread Jared . Still
> Did you request the lock in share mode to > request next val ?  This would help to reduce > the contention.  Normal users would then only > queue on the exclusive lock that you would > take for the fix-up. >    lock(shared) >    increment sequence >    release Good point.  No I didn't.  :( ac

Re: Reset sequence at midnight

2004-01-14 Thread Jared . Still
Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request

Re: read-only simple snapshot/materialised view refresh

2004-01-14 Thread Jared . Still
Leng, You didn't mention the frequency of the refresh. I also don't see mention of which database is generating the ora-1555 errors. Jared "Kaing, Leng" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/13/2004 09:34 PM  Please respond to ORACLE-L                 To:        Multiple r

List problems

2004-01-14 Thread Jared Still
shanghaied along the way. I'll let you know when I find out. I am of course, assuming that some of you will get this one... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Import foibles

2004-01-13 Thread Jared Still
is 1 gig file took 10 hours to load. On our speedy linux dev box with fast IO it took quite awhile, though I'm not going to run it again to get the exact timing. And that without indexes or constraints. It's sqlloader from now on. Jared -- Please see the official ORACLE-L FAQ: ht

RE: Cold Fusion and Bind Variables

2004-01-13 Thread Jared . Still
Thanks Suzy, CFQUERYPARM is what he needs. Jared "Vordos, Suzy" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/13/2004 05:34 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        

Cold Fusion and Bind Variables

2004-01-12 Thread Jared . Still
Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importanc

SQL Server DBA Position

2004-01-12 Thread Jared . Still
FYI - I'm forwarding this on Lisa's behalf. Please reply to [EMAIL PROTECTED] - Please do not reply to m Please do not reply to the list. -   My employer, Fairfield Resorts (www.fairfieldresorts.com) is looking to hire a SQL Server DBA with several years' worth of experie

Re: Yep.....it's a Monday......

2004-01-12 Thread Jared . Still
I had an SA do that to my 500G DW once, in the middle of the day. Took a few minutes to figure out why tablespaces were successively going offline... Jared Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/12/2004 08:54 AM  Please respond to ORACLE-L                 To:    

RE: Export / Import Question

2004-01-11 Thread Jared Still
kind. > Opinions, conclusions and other information in this message that do not relate to > the official business of Transurban Infrastructure Developments Limited and CityLink > Melbourne Limited shall be understood as neither given nor endorsed by them. > <<<<<<<&

RE: Backups in a DW Environment

2004-01-11 Thread Jared Still
> Author: mkb > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > ---------

Re: What is the fastest way to dump oracle data into a human

2004-01-11 Thread Jared Still
> 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 service

Re: Backups in a DW Environment

2004-01-10 Thread Jared Still
the > > > BCV split. Also, it's not directly accessed by users > > > for ad-hoc queries. Automated processes access the > > > database and build cubes using Cognos tools. Users > > > access these and not the DB directly. > > > > Any data w

Re: Suggestions Needed: Latch free - library cache

2004-01-10 Thread Jared Still
ing of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ

Re: Backups in a DW Environment

2004-01-09 Thread Jared . Still
The license is for the software that interfaces Veritas NetBackup to RMAN. RMAN has an API and NBU has an API.  The intersection of the 2 will set you back about $1500 US IIRC. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/09/2004 04:39 PM  Please respond to ORACLE-L  

Re: Any way to syncronize sequences between database?

2004-01-09 Thread Jared . Still
see http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html "Smith, Ron L." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/09/2004 11:49 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:      

RE: RAC setup on linux

2004-01-09 Thread Jared . Still
Rich, Before now, I've not heard of setting localhosts to the real IP address. I've only seen it aliased to loopback ( 127.0.0.1 ).  Why would you do otherwise? Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/09/2004 12:39 PM  Please respond to ORACLE-L          

Re: Books on rac

2004-01-09 Thread Jared . Still
Ryan, This kind of post does not belong on this list. The quote from a private email exhibits some rather bad judgement IMO, even if it was anonymously attributed. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/09/2004 02:54 PM  Please respond to ORACLE-L            

Re: Books on rac

2004-01-09 Thread Jared . Still
Ouch! That's a little harsh isn't Ryan? Especially for a public forum. The first Oracle book I bought was by Mike Ault.  It was fairly decent, and was certainly better than just having the manuals.  I no longer have it, as it was Oracle 7 specific. The second book was Gurry and Corrigan's. Yo

RE: Trigger Question

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

Re: Should we stop analyzing?

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

Re: Trigger Question

2004-01-08 Thread Jared Still
> > When an AFTER INSERT trigger is fired (row level) has the row been committed > to the database at this stage? > > If so is it ok to call a package in the trigger that selects that row and > changes some values in the row? > > Thanks, > > N. > -- Please

RE: Should we stop analyzing?

2004-01-08 Thread Jared Still
-- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of ma

DBA position

2004-01-08 Thread Jared Still
http://careers.lifetouch.com/Job.asp?Job_id=1050&seas=Office+%2D+FullTime The domain name may be familiar, a prolific poster on this list happens to be there as well. The location is Minneapolis, MN, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: J

Re: A free sql analysis tool

2004-01-08 Thread Jared Still
10046 SQL trace > > > > http://brainshed.com/software/ > > > > Kind Regards, > > > > > > Hatzistavrou Yannis > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Ne

RE: Should we stop analyzing?

2004-01-08 Thread Jared Still
he name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://w

Re: ORACLE-L Digest -- Volume 2004, Number 008 (Out of Office

2004-01-08 Thread Jared Still
Guru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.oraf

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Jared Still
works as well as what the course notes say will be an even > better investment. > > Of course criticism of the OCP based on the fact that it values version > specific syntax over DBA/Developer principles is right on the money IMO. > > Niall > -- Please see the official ORACL

RE: table reorganizations

2004-01-07 Thread Jared Still
gt; Author: Shrake, Jolene > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To R

Re: Difference on ArchiveLog (I'm rewriting the question)

2004-01-07 Thread Jared Still
gt; I think I'ts not logical that archive size change. > > > > The database I'm working on is oracle 9i and I'is on Windows NT. > > > > Regards > > Mauricio VÃlez > > > > > > ---------

Re: data warehouse vs regular database??

2004-01-07 Thread Jared Still
u want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

RE: ora1652 question...

2004-01-06 Thread Jared Still
gt; Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To R

RE: oracle client on PC's

2004-01-06 Thread Jared Still
Ah, Merant is just down the street, sort of. Maybe they'll loan me one. :) Thanks for the explanation. The concept isn't new, but the terminology is. Jared On Tue, 2004-01-06 at 14:09, Grant Allen wrote: > > -Original Message- > > From: Jared Still [mailto:[EMA

RE: Convert to Locally-Managed Tablespaces

2004-01-06 Thread Jared Still
://www.orafaq.net > > -- > > Author: Tanel Poder > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > -

DBA tasks

2004-01-06 Thread Jared Still
What does a DBA do? What should a DBA do? Interesting short list, or maybe not so short. http://dbasupport.com/oracle/ora9i/resolutions.shtml -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services

Re: (long) Top level heaps/subheaps

2004-01-06 Thread Jared Still
essage BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [E

Re: oracle client on PC's

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

Re: (long) Top level heaps/subheaps

2004-01-06 Thread Jared Still
Yeah I know, did it again. On Tue, 2004-01-06 at 10:19, Mladen Gogala wrote: > The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond. > On 2004.01.06 12:34, Jared Still wrote: > > * to satisfy curiosity > > * to have a better understanding o

RE: (long) Top level heaps/subheaps

2004-01-06 Thread Jared Still
> Sorry for too long post, I'm currently too lazy to do anything useful... > Tanel. > > - Original Message - > To: Multiple recipients of list ORACLE-L > Sent: Tuesday, January 06, 2004 3:49 PM > > > Hi, > I am getting little confussion how th

RE: Upgrade

2004-01-06 Thread Jared Still
ng of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subsc

RE: Upgrade

2004-01-06 Thread Jared Still
age BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMA

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Jared Still
he message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EM

HOTSOS Conference

2004-01-05 Thread Jared Still
esday evening for dinner/drinks if any are interested. Possibly some of you with Dallas connection can recommend a suitable location. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: oaktable people

2004-01-05 Thread Jared . Still
He didn't, but nonetheless I thought it was something that you and others might be interested in. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 04:19 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTE

Re: oaktable people

2004-01-05 Thread Jared . Still
That would be nice.  It's already indispensible. "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 04:19 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        Re: oakta

Re: oaktable people

2004-01-05 Thread Jared . Still
I've heard that Steven Feuerstein has a new book on the way, though I have been unable to find any reference to it. Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/05/2004 02:34 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L

Re: Convert to Locally-Managed Tablespaces

2004-01-05 Thread Jared . Still
On a gig of data, you could easily export the data and re-import into new locally managed tablespaces. An alternative is to use the dbms_space_admin package to convert DD managed tablespaces to locally managed. This is what I will need to use on our systems, as there are about 400 gig of data

RE: stress testing

2004-01-05 Thread Jared Still
ces > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L &

Re: Job question

2004-01-05 Thread Jared Still
(like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

Re: OFA document

2004-01-04 Thread Jared Still
of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 ORACL

Re: stress testing

2004-01-02 Thread Jared . Still
As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/.  The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared "Poras, Henry R." <[EMAIL PROTECT

RE: Cache a table

2004-01-02 Thread Jared . Still
This thread started on 10/21/2003, with a *lot* of comments. No time to read it all, so I'll just work with what appears here. Have considered that this table is simply used a lot and remains in the cache because it belongs there due to frequent access? SQL with high LIO's? Jared Ravi

Re: order by

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

Re: Has anyone used this Perl Module? Oracle-Trace-1.06 (or 1.07)

2003-12-31 Thread Jared . Still
% might expect > that > the next release would be ... today! :-O > > I stumbled into the Oracle-Trace package while > configuring my instance with chkalert/email from > your > 'Perl for Oracle DBAs' book. Chkalert is a cool > program. > > Happy holidays! > >

Re: anyone use pipelined functions?

2003-12-31 Thread Jared . Still
That would be cool if you have time for it. Re the sequence:  is it assigned in a trigger, or directly in the SQL? [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]  12/31/2003 11:19 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECT

Re: anyone use pipelined functions?

2003-12-31 Thread Jared . Still
Fantastic results Adam. You didn't perhaps do interim testing did you, so that you know how much of the benefit was due to the pipelined functions? You made quite a few changes, and a breakdown of the the benefits of each would be interesting to see. Jared [EMAIL PROTECTED] Sent by: [E

RE: undotbs01.dbf just keeps growing

2003-12-31 Thread Jared Still
ng list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other

Re: SQL*net message from client severly impact the Parse call of an

2003-12-31 Thread Jared Still
d 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. -- Please see the official ORA

  1   2   3   4   5   6   7   8   9   10   >