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

] 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. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going

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

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 ORACLE-L

Bye...

bye...

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

for 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: UNION ALL Query: Riddle

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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

Re: [Q] wait time /lob def

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: Subject:Re: [Q] wait time

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

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: measuring TPM

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

RE: UNION ALL Query: Riddle

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: [Q] wait time on stat

Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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

Re: Problem with jobs

__ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- 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

Re: When does Oracle use 'Index Fast Scan'

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

Re: UNION ALL Query: Riddle

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, Rajesh

Re: What to look for in STATSPACK report

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 statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK

Re: String manipulation

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 ,

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

/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: ROWID PROBLEM

!!! 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-5051 http://www.fatcity.com San Diego, California-- Mailing list

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

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

Re: What to look for in STATSPACK report

don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases

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

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 [EMAIL

RE: Help - 9ias broke - hostname was changed

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.

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

] 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] You can unsubscribe from

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

down. At this time, I don't know for how long the Oracle-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 email to [EMAIL

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

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: !!Please Read - Oracle-L is

Re: How to get unique value using AWK?

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] cc:

Re: test please ignore

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 ignore Test new oracle-l --

Re: What to look for in STATSPACK report

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 statspack at Mogens company site, www.miracleas.dk. It is called

Re: What to look for in STATSPACK report

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 statspack at Mogens company site

Re: FW: Disk capacity planning

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: Subject:

Re: pga_aggregate_target and a memory leak

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: help

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 To:

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

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] You can unsubscribe

Re: NEW LYRICS TO BEATLES SONGS - OT but nice

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. Jared

Re: Spool to Excel File

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: [EMAIL

Re: OT: Developer Mailing List

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: Developer Mailing List Hi Folks,

RE: Spool to Excel File

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: Parallel Query determined by?

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: What to look for in STATSPACK report

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: SYS Privilege

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: Subject:

RE: Oracle vs Mysql

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

Re: Oracle vs Mysql

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

Re: OS authentication; remote login; domain qualification

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: Reset sequence at midnight

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. :( actually the

List problems

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-5051

Re: read-only simple snapshot/materialised view refresh

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 recipients of list

Re: Reset sequence at midnight

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: Cold Fusion and Bind Variables

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:RE: Cold Fusion and Bind Variables

Import foibles

. 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: http://www.orafaq.net -- Author: Jared Still INET

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

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:Multiple

SQL Server DBA Position

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

Cold Fusion and Bind Variables

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

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

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

RE: Backups in a DW Environment

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: Export / Import Question

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

Re: Suggestions Needed: Latch free - library cache

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

Re: Backups in a DW Environment

for archive logging. Any thoughts? mohammed Hope this helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still

Re: Books on rac

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. You

Re: Books on rac

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 To:

RE: RAC setup on linux

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 To:

Re: Any way to syncronize sequences between database?

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: Subject:Any way

Re: Backups in a DW Environment

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: ORACLE-L Digest -- Volume 2004, Number 008 (Out of Office

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Should we stop analyzing?

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

Re: A free sql analysis tool

://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 Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

DBA position

http://careers.lifetouch.com/Job.asp?Job_id=1050seas=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: Jared

RE: Should we stop analyzing?

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

Re: Trigger Question

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 see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL

Re: Should we stop analyzing?

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

RE: Trigger Question

://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

Re: data warehouse vs regular database??

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat

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

-- Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: table reorganizations

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

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

on the fact that it values version specific syntax over DBA/Developer principles is right on the money IMO. Niall -- 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

RE: Upgrade

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: Upgrade

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: (long) Top level heaps/subheaps

-- 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

Re: (long) Top level heaps/subheaps

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 of how Oracle works Most

Re: oracle client on PC's

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

Re: (long) Top level heaps/subheaps

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

DBA tasks

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: Convert to Locally-Managed Tablespaces

-- 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

RE: oracle client on PC's

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:[EMAIL PROTECTED] Sent

RE: ora1652 question...

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: Job question

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: stress testing

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Convert to Locally-Managed Tablespaces

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

Re: oaktable people

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 [EMAIL

Re: oaktable people

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: oaktable people oh yeah. James Morle

Re: oaktable people

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 PROTECTED] cc:

HOTSOS Conference

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-5051

Re: Convert to Locally-Managed Tablespaces

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City

Re: OFA document

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Cache a table

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

Re: stress testing

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 PROTECTED]

Re: order by

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Should we stop analyzing?

problems, they should be analyzed case by case and at that time the possibility that newer statistics will change the access plan and improve the performance should be explored. Jared -- Author: Jared Still INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: Has anyone used this Perl Module? Oracle-Trace-1.06

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

Re: Has anyone used this Perl Module? Oracle-Trace-1.06

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: SQL*net message from client severly impact the Parse call of an

[EMAIL PROTECTED] for clarification. -- 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: undotbs01.dbf just keeps growing

-- 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

  1   2   3   4   5   6   7   8   9   10   >