Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread Ryan
ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

When does Oracle use 'Index Fast Scan'

2004-01-26 Thread Ryan
I have found that the vast majority of time that Oracle chooses this method, my statistics are stale and the query is sub-optimal. One time, Oracle changed from a 'range scan' to this type of scan with a FIRST_ROWS hint and this reduced performance. This is just a full scan of the index,

Re: When does Oracle use 'Index Full Scan'

2004-01-26 Thread Ryan
sorry typo. I mean 'Index Full Scan' - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Monday, January 26, 2004 9:24 PM Subject: When does Oracle use 'Index Fast Scan' I have found that the vast majority of time

Re: fetching long variable in PL/SQL

2004-01-25 Thread Ryan
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL

Re: ROWID PROBLEM

2004-01-25 Thread Ryan
Title: RE: alter table rename error you need to read the documentation. Oracle is supposed to workt his way. otn.oracle.com start with the concepts document. Skip the stuff on java, xml, etc... read the first 10-12 chapters. - Original Message - From: Waleed Haggagy

Re: RE: pga_aggregate_target and a memory leak

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

Re: pga_aggregate_target and a memory leak

2004-01-23 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Ryan
-- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Developer Mailing List

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

any student versions of 'business objects' ab initio or informatica?

2004-01-17 Thread Ryan
Something affordable. These are hot right now and I'd like to learn how to use them. I cant find anything on the web.

Re: any student versions of 'business objects' ab initio or

2004-01-17 Thread Ryan
...on 1/17/04 9:44 AM, Ryan at [EMAIL PROTECTED] wrote: Something affordable. These are hot right now and I'd like to learn how to use them. I cant find anything on the web.

how to hide oracle password from a unix ps -ef | grep?

2004-01-16 Thread Ryan
Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?

Re: What is hash join?

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

named pipes, sql loader and ftps

2004-01-15 Thread Ryan
I was flipping through Tim Gorman's Data Warehouse and he has a short section on using named pipes to kick off sql loader when you send files to your data warehouse with ftps. Ive never used named pipes in Unix? Does it depend on the shell(I only know korn). Anyone do this? With this

Re: powerbuilder in rbo and multiple constraint question...

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

Re: Process consumes CPU and long time to finished

2004-01-15 Thread Ryan
-- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: Oracle vs Mysql

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

Application Server Caching

2004-01-14 Thread Ryan
I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have

Re: Oracle vs Mysql

2004-01-14 Thread Ryan
is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay

Re: ** OCP for 9i requirements

2004-01-13 Thread Ryan
requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought thatthe pre-requisite is "at least one Instructor Led Training".HemantAt 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.comd

Re: ** OCP for 9i requirements

2004-01-12 Thread Ryan
www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday,

Re: Suggestions Needed: Latch free - library cache

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

Re: Backups in a DW Environment

2004-01-10 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Suggestions Needed: Latch free - library cache

2004-01-10 Thread Ryan
maintain the database. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 10, 2004 11:14 AM Ryan: Same named user with large number of connections is not a problem. Things will become bad only IFF the large number of different users

Re: pga workarea and ora-04030

2004-01-10 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Backups in a DW Environment

2004-01-10 Thread Ryan
inserts into newly loaded partitions, or updates that could increase the length of rows? 1 pctfree could be problematic in that case. Jared On Sat, 2004-01-10 at 05:04, Ryan wrote: I can understand the concern about ingesting large amount of data. We ingest about 200 GB a night. To get

Re: pga workarea and ora-04030

2004-01-10 Thread Ryan
BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat

Re: Suggestions Needed: Latch free - library cache

2004-01-09 Thread Ryan
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED

Re: Suggestions Needed: Latch free - library cache

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

Re: Books on rac

2004-01-09 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Backups in a DW Environment

2004-01-09 Thread Ryan
, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City

Re: Books on rac

2004-01-09 Thread Ryan
on rac "all the other non-Ault books from Rampant are total trash." That's a pretty strong statement, Ryan! Mine is a non-Ault Rampant book; does it count, too? Before you trash the book and commit the statement, can I interest you in at least taking a look at it?

Re: Backups in a DW Environment

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

Re: Backups in a DW Environment

2004-01-09 Thread Ryan
Subject: 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

Re: DBA position

2004-01-08 Thread Ryan
Title: RE: DBA position alot of companies put tons of stuff in job reqs. You dont know what is really important to them until you apply. This includes degree, experience, and all the buzzwords. This happens all the time. - Original Message - From: April Wells To:

test

2004-01-07 Thread Ryan
switched emails. just testing.

Re: Re[2]: another OCP question -- help me guys

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

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
://www.orafaq.net -- Author: Ryan 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: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Hotsos' Classes

2004-01-07 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

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

2004-01-07 Thread Ryan
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: data warehouse vs regular database??

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

Re: Suggestions Needed: Latch free - library cache

2004-01-07 Thread Ryan
latch free waits typically mean your not using bind variables. Im not a wait event expert here. So I'm sure it can mean something else also. - Original Message - From: Tracy Rahmlow To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 07, 2004 5:39

Re: Suggestions Needed: Latch free - library cache

2004-01-07 Thread Ryan
Title: Message how do you limit excessive soft parsing? - Original Message - From: Bobak, Mark To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 07, 2004 5:59 PM Subject: RE: Suggestions Needed: Latch free - library cache Tracy, What

Re: Suggestions Needed: Latch free - library cache

2004-01-07 Thread Ryan
://www.orafaq.net -- Author: Ryan 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: OCP Question (Perf Tuning)

2004-01-06 Thread Ryan
a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Ryan
BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat

Re: Bug with automatic undo management?

2004-01-06 Thread Ryan
to see if I can get the same error. Daniel Fink Goulet, Dick wrote: Ryan, I agree with OTS. If you had dropped the rollback segment(s) before creating the object then you'd probably never have seen the error. I have found that SCN's do get cached by your session and sometimes don't

Re: Price is right

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

oaktable people

2004-01-05 Thread Ryan
Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: oaktable people

2004-01-05 Thread Ryan
, January 05, 2004 6:49 PM Subject: 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/

Re: oaktable people

2004-01-05 Thread Ryan
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 t

Re: Job question

2004-01-04 Thread Ryan
FAQ: http://www.orafaq.net -- Author: Ryan 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

Re: anyone use pipelined functions?

2003-12-31 Thread Ryan
(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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Re: getting estimate of result set from v$sql_plan

2003-12-29 Thread Ryan
ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Re: getting estimate of result set from v$sql_plan

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

Re: pl/sql open cursor question

2003-12-28 Thread Ryan
://www.orafaq.net -- Author: Ryan 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

Re: pl/sql open cursor question

2003-12-28 Thread Ryan
I thought just the execution plan was shared? I thought the definition of a cursor, was the memory area used to store the data. That data does not stay persistent in memory with a cursor for loop it closes. correct me if Im wrong? - Original Message - From: Peter Gram

Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

2003-12-27 Thread Ryan
containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services

Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

2003-12-27 Thread Ryan
FAQ: http://www.orafaq.net -- Author: Ryan 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

Re: pga_aggregate_target

2003-12-26 Thread Ryan
Anyone have problems with pga_aggregate_target on Solaris. Richard Foote wrote the following about HP-Unix.

Re: stress tests for a scale to 30,000 users

2003-12-22 Thread Ryan
(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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: stress tests for a scale to 30,000 users

2003-12-22 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Delete vs. truncate to free up spaces.

2003-12-22 Thread Ryan
a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network

sql_trace when using middle tier connection pooling

2003-12-22 Thread Ryan
Our middle tier opens several dedicated connections. SQL statements are issued through these dedicated connections. If Im running a stress test and I want to trace... what is the best method to use? Just use a logon trigger and trace every session? then dig through it to look at the top

Re: 24 x 7 x 365

2003-12-13 Thread Ryan
i was just in the bookstore. are you the one who wrote the new RAC book? you do realize the whole thing word for word is in a .pdf on otn? - Original Message - From: Murali Vallath To: Multiple recipients of list ORACLE-L Sent: Saturday, December 13, 2003 10:09

Re: Who are certified Oracle Masters?

2003-12-11 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Ryan
-- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Ryan
://www.orafaq.net -- Author: Ryan 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: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Ryan
anyone know how it compares to oracle? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:34 PM http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Ryan
/TopTenWinners.a sp Maybe they should rename the product Petadata. If they did, then its a good thing that they didn't name it "TeraFile". PdJonathan Gennick [EMAIL PROTECTED] wrote: Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R

10g stuff on otn

2003-12-10 Thread Ryan
they list the new application server and the new developer suite as '10g', but then say 9.0.4 next to it? so are they really new versions or just minor upgrades to the 9i version?

Re: CPU Capacity Planning

2003-12-07 Thread Ryan
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
://www.orafaq.net -- Author: Ryan 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

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
the deer in the head lights look. Little bit at a time. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:39 PM Well said, Ryan! I have about the same number of instances, all on Sun. Development responsibilities also. One

Re: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING

2003-12-03 Thread Ryan
ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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

Re: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING

2003-12-03 Thread Ryan
BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED

Re: Writing a delay in PL/SQL?

2003-11-29 Thread Ryan
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED

Re: an article comparing Oracle to other databases

2003-11-27 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: an article comparing Oracle to other databases

2003-11-27 Thread Ryan
assumed it was true. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 1:24 PM So is MySQL, supposedly. These things are usually very subjective, and rarely objective. Jared On Thu, 2003-11-27 at 08:49, Ryan wrote

Re: what is oracle rdb?

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

Re: Re: explain plan conundrum

2003-11-04 Thread Ryan
:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: explain plan conundrum Hi, Ryan, Where's the 20 billion rows? There's 1 G rows and 20 G bytes. What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for TABLE2? Did you analyze using

question parallel query used by SMON

2003-10-31 Thread Ryan
Im studying for the backup and recovery exam. One quesiton from self test software states that SMON will use parallel query when it detects a dread transaction with a 'large number' of rollback blocks. my questions: 1. is the number of parallel query slaves it uses based on my parallel

Re: What happened to Howard Rogers ?

2003-10-26 Thread Ryan
is after all the land that can patent clicking :(. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 25 October 2003 23:14 To: Multiple recipients of list ORACLE-L Subject: Re: What happened to Howard Rogers

Re: What happened to Howard Rogers ?

2003-10-25 Thread Ryan
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Refresh option for Materialized view , want to use it during refresh - for

2003-10-24 Thread Ryan
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL

Re: Refresh option for Materialized view , want to use it during refresh - for

2003-10-24 Thread Ryan
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Oracle pricing ain't going down

2003-10-23 Thread Ryan
Edition One pricing is what Std Edition should be selling at IMO. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down

Re: Oracle pricing ain't going down

2003-10-23 Thread Ryan
. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is the microsoft,. sybase, and ibm database pricing

Re: index full scan over an index fast full scan in an analytic function?

2003-10-23 Thread Ryan
-- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: Oracle pricing ain't going down

2003-10-23 Thread Ryan
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is the microsoft,. sybase, and ibm database pricing? anyone know

Re: Oracle pricing ain't going down

2003-10-22 Thread Ryan
(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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: OT: How to call unix shell scripts from 'C'?

2003-10-22 Thread Ryan
(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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Your new book

2003-10-22 Thread Ryan
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL

Re: who writes the OCP tests?

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

Re: Performance tuning book

2003-10-21 Thread Ryan
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Performance tuning book

2003-10-21 Thread Ryan
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Transportable tablespaces

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

  1   2   >