Re: direct distributed insert causes massive sorting on target, why?

-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). Thanks, Jack Silvey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City

Re: Row Migration

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Thanks, Jack Silvey -- Please see

Re: Rebuilding Indexes...

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

Re: Rebuilding Indexes...

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

Re: Rebuilding Indexes...

] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Thanks, Jack Silvey -- Please see the official

Re: direct distributed insert causes massive sorting on target, why?

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Thanks, Jack Silvey Could you clarify

Re: direct distributed insert causes massive sorting on target, why?

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). Thanks, Jack Silvey Could you clarify what you mean

Re: compile errors

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

direct distributed insert causes massive sorting on target, why?

. Thanks, Jack Silvey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack Silvey 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 Arm Twisting?

send the HELP command for other information (like subscribing). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL

Re: what is wrong with this idea ...

!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Transferring data from one table to another

=== __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: dropping a user's objects

the HELP command for other information (like subscribing). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL

IO wait

: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Re: Myers-Briggs

Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack

Re: How do I check whether a rollback activity is going on

). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack

Re: DBMS_JOB does not run on NT

). __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: SQL query

://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re:killing sessions

). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: Delete query

Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Alter table move command

-- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

RE: Delete query

subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Oracle 8.1.7 function based indexes

the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL

Re: Oracle 8.1.7 function based indexes

and then test some more. hth, Jack --- Jack Silvey [EMAIL PROTECTED] wrote: Imma, First thought is no - oracle implements function-based indexes by using a hidden psuedocolumn to hold the resultant data of the function. Since you would be using a bind variable, it would not be able

Re: How to calculate table size in 8i

: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Re: Exporting stats for a production server to a dev/test server

Jack Silvey jack_silvey@y To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ahoo.com

Re: insert nologging parallel/noparallel and archiving - thanks

and Jared for their help!! Gene --- Jack Silvey [EMAIL PROTECTED] wrote: sorry, meant insert as select, not insert as append --- Jack Silvey [EMAIL PROTECTED] wrote: Gene, This sounds right. __ Do You Yahoo!? Sign up for SBC

Re: Exporting stats for a production server to a dev/test server

). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: resetting sequence numbers

little script that automates this second approach ;-) Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack Silvey Sent: Friday, July 05, 2002 8:03 AM

Re: insert nologging parallel/noparallel and archiving

FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: insert nologging parallel/noparallel and archiving

sorry, meant insert as select, not insert as append --- Jack Silvey [EMAIL PROTECTED] wrote: Gene, This sounds right. Standard insert as append does freelist block checking and generates redo. Parallel DML generates minimial redo, just for the new temp segments being created

Re: the ora certified masters cert, yet again

the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET

report showing free space per tablespace over time

dbmon.dbmon_tablespace_stats) group by tablespace_name order by 1 / good luck, Jack __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack

RE: report showing free space per tablespace over time

=== __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: the ora certified masters cert, yet again

and you can respond yes, and I can jump through some hoops for you too and allow them to say here is an outrageous sum of money to work on our computers. I love this job. jack silvey ocp 7.3, 8.0, 8i, 9i --- Don Granaman [EMAIL PROTECTED] wrote: They aren't - unless it exceeds a non-trivial

Re: the ora certified masters cert, yet again

of which is FILLED with lists of presentations I have given, awards I have gotten for presentations I have given and books I have written if they STILL want me to have OCP on my resume after that, I don't want to work there anyway --- Jack Silvey [EMAIL PROTECTED] wrote: The question

RE: Suggestions on MV Implementation !!!!!!!

=== __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: distributed timeout error

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: the ora certified masters cert, yet again

life than she would without? So it takes a round trip ticket and three days of vacation. Get the company to pay for it or write it off as a business expense. Good investment, easy money, instant credibility to many hiring managers. jack silvey On 19 Jun 2002 at 4:38, Ron

distributed timeout error

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Suggestions on MV Implementation !!!!!!!

for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED

RE: distributed timeout error

send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey

RE: Suggestions on MV Implementation !!!!!!!

of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

the ora certified masters cert, yet again

trip ticket and three days of vacation. Get the company to pay for it or write it off as a business expense. Good investment, easy money, instant credibility to many hiring managers. jack silvey On 19 Jun 2002 at 4:38, Ron Rogers wrote: Date sent:Wed, 19 Jun 2002 04:38:18

RE: sys corrupted in warehouse, sev1 tar open - resolved

on it. Just now cleaning up all the broken indexes from the loads that abended when the db went down. I love this job. Where else do you get to play at work? jack --- Jack Silvey [EMAIL PROTECTED] wrote: All, thanks for the input. Looks like someone implemented

Re: Wait event problems

Lee, This is an idle wait event, meaning that the query process is waiting on instructions from the client. Usually this process is benign, but sometimes can indicate that the feeding process is not providing data in a timely fashion. hth, jack silvey --- Robertson Lee - lerobe [EMAIL

RE: set sort_area_size, sort_retained_size,hash_area_size but sti

Paula, what is the size of your hash_area_size, sort_area_size, and sort_area_retained_size? what does your explain plan look like? hashes, sort/merge, or nested loops? do you have a lot of parallel to parallel, parallel to serial in your plans? jack silvey --- [EMAIL PROTECTED] wrote

Re: Wait event problems

, meaning that the query process is waiting on instructions from the client. Usually this process is benign, but sometimes can indicate that the feeding process is not providing data in a timely fashion. hth, jack silvey --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All

warehouse gets very strange - sys corrupted - sev1 tar

: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

sys corrupted in warehouse, sev1 tar open

: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

RE: sys corrupted in warehouse, sev1 tar open - resolved

All, thanks for the input. Looks like someone implemented a login trigger. haven't seen the code yet, but I would venture a guess he used the unsupported alter system set current_schema=x. sometimes you live and learn, sometimes you just live! thx, jack silvey --- Hately Mike [EMAIL

RE: sys corrupted in warehouse, sev1 tar open - resolved

to play at work? jack --- Jack Silvey [EMAIL PROTECTED] wrote: All, thanks for the input. Looks like someone implemented a login trigger. haven't seen the code yet, but I would venture a guess he used the unsupported alter system set current_schema=x. sometimes you live

Re: URGENT: Vendor App locked me out of my Prod DB Pls Advise

smack a couple of those sessions at the UNIX level and login right quick. make sure beforehand that this will not lead to data corruption or anything nasty like that. and if it does, have a heart to heart with your manager about this app. hth, jack silvey --- [EMAIL PROTECTED] wrote: I

Re: ldap info

. The LDAP was accessed by the Java processes and gathered the password and username from it to login to the database. hth, jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about

Re: ldap info

is, it's free. and we don't need another oracle license etc etc etc and even better, it wouldn't be MY responsibility to maintain :) Rachel --- Jack Silvey [EMAIL PROTECTED] wrote: my last gig was senior DBA at an internet travel shop, and we used LDAP to authenticate users. Since

RE: ldap info

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: buffer cache

by this query. hth, jack silvey select e.owner||'.'||e.segment_name segment_name, sum(cnt) all_buffers, sum(hot) hot_buffers, sum(tch) touches from ( select min(file#||'.'||dbablk) fb, count(*) cnt, sum(decode(lru_flag, 8, 1, 0)) hot, sum(tch) tch from

grant access to another user's objects?

of another way? thx, jack silvey __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City

RE: using a lot of temporary tablespace with large sort area size

Paula, With so much data, Oralce (or Oracle, if you prefer) might be hash joining your tables and writing temp hash segments. What is your hash_area_size? jack silvey --- [EMAIL PROTECTED] wrote: Guys, Have 20Gb and 16CPUS available on host. Need to do large full-table scans/joins

Re: Mysterious Deadlock

? how many procs are trying to insert/delete/update it at once? are ALL dying, or just some? jack silvey --- Walter K [EMAIL PROTECTED] wrote: We have an application that is periodically encountering what appears to be a self-deadlock. Only one session is listed and it holds an exclusive

Re: Mysterious Deadlock

procs are trying to insert/delete/update it at once? are ALL dying, or just some? jack silvey --- Walter K [EMAIL PROTECTED] wrote: We have an application that is periodically encountering what appears to be a self-deadlock. Only one session is listed and it holds

unable to split a partition in parallel

of some sort, however. Otherwise, perhaps the pq procs cannot write, but have never had problems with our PQ procs writing before and have done many parallel CTAS to this tablespace. thanks, jack silvey __ Do You Yahoo!? Yahoo! - Official partner

custom DD views to allow users to see source without needing exe rights

during object name resolution, it would probably use these views instead of the data dictionary views. This worked. The two views that I customized are below - feel free to use. jack silvey ALL_ARGUMENTS: select u.name owner, /* OWNER */ nvl(a.procedure$,o.name) object_name, /* OBJECT_NAME

RE: partition tables

error. To change pctfree you will have to rebuild the table. hth, jack silvey -Original Message- Sent: Thursday, May 30, 2002 8:59 PM To: Multiple recipients of list ORACLE-L Hi All , We are thinking of converting one of huge table in to partition table . What is best way

Re: How to grant privileges on all the tables of owner1 to owner2?

'||v_sql); execute immediate v_sql; exception when others then dbms_output.put_line ('problem with '||v_sql); end; end loop; end; / jack silvey --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Greetings, Here is the scenario. I have 2 users(owner1, owner2) in an oracle database. owner1

Re: rebuilding indexes

? sometimes, this can cause an index glucose spike and tend to make it store more fat in the leaf blocks, especially around the middle of the index, but sometimes on the hips too. Perhaps you are not doing DDL on the table enough, and so the index is not getting enough exercise. hth, jack silvey

RE: Jr.DBA, Mid level DBA, Sr.DBA

The jr thinks that she knows. The mid knows that she knows. The sr knows that she knows not. Awareness of ignorance is the mark of true knowledge. I like cake. jack silvey --- Fink, Dan [EMAIL PROTECTED] wrote: I agree, the Jr. DBA must focus on learning. Mid DBA...is still learning. Many

Re: rebuilding indexes

to [EMAIL PROTECTED] for details. --- Rachel Carmichael [EMAIL PROTECTED] wrote: I'm sure it's #6 :) --- Jack Silvey [EMAIL PROTECTED] wrote: Matt, 1) Storage parameter changes? Do you specify storage at the index or tablespace (or top partition) level?pctfree go up? initrans go up

Re: UPGRADE

://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Re: Undocumented Parameters

in handy on occasion. Did I say be careful? Might want to buff up the resume before you start acting like the Mad Hidden Parameter Scientist. ;) jack silvey -- -- -- author: jack silvey -- about: shows hidden and non-hidden parameters

RE: Statistical sampling and representative stats collection

tom, This is interesting. How did you determine max distribution and uniform distribution? Did you use standard deviation and variance? regards, jack silvey --- Terrian, Tom [EMAIL PROTECTED] wrote: John, I know in a previous job, we determined that histograms where not worth

parallel dml and set transaction quirk

the transaction statement, the query spawned off 24 processes and finished in 16 minutes. /jack silvey __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http

Bitmap vs btree - how to tell? how to test?

, /jack __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Data Warehouse experts, a simple question for you| Outdated?

- Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Statistical sampling and representative stats collection

- From: Jack Silvey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: Statistical sampling and representative stats collection Hi all, Did some investigation about statistical sampling this weekend since we

RE: Data Warehouse experts, a simple question for you| Outdated?

=== __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Statistical sampling and representative stats collection

Information Network Jack Silvey jack_silvey@y

Re: Statistical sampling and representative stats collection

to consider. Cherie Machler Oracle DBA Gelco Information Network Jack Silvey

dbms_stats issues on 8i

is to delete stats with DBMS_STATS.DELETE_TABLE_STATS and then use ANALYZE. There are others, like the DESC index problem that I did not research, just noted in passing. /jack silvey __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http

RE: Data Warehouse experts, a simple question for you| Outdated?

-L FAQ: http://www.orafaq.com -- === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL

Re: Data Warehouse experts, a simple question for you

? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: Data Warehouse experts, a simple question for you

I second that emotion. the guy that wrote it is a PhD and owns Red Brick or something. totally knows what he is talking about. One of my top five books, best warehousing book by far I have ever read. /jack silvey --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4

Re: Data Warehouse experts, a simple question for you

I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel

Re: Data Warehouse experts, a simple question for you

on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books

RE: Data Warehouse experts, a simple question for you

ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Statistical sampling and representative stats collection

? /jack silvey __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Statistical sampling and representative stats collection

. This of course is a pie in the sky mathematical model, but seems like a reasonable place to start with testing. Input? Input? Buhler? Buhler? /jack silvey __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com

RE: Partition Exchange

!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: I/O EVENTS

=== __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Telephone Alerts

scripts and contact the user with succes or failure # Jack Silvey #---Oracle variable section --- export ORACLE_SID=iron export ORACLE_HOME=/u01/app/oracle/product/8.1.7 #---shell variable section --- SCRIPTPATH=/u01/app/oracle/admin/iron/scripts SQLPATH=$SCRIPTPATH/sql SCRIPTNAME=$SQLPATH/$1

ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

that TOAD can use dba_source, but they have not had luck with this (might be a default role thing, have not verified). Opinions or other options? Jack Silvey __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please

Re: Cannot import--URGENT

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: script to show heirarchical list of object dependencies for a

= referenced_type start with referenced_owner = upper('1') and referenced_name = upper('2') and owner is not null / good luck, jack silvey __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see

Re: DBA_EXTENTS problem

). __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: DBA_EXTENTS problem

subscribing). __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network

Re: too low optimizer_index_cost_adj causing bizarre index choice

or more |and reran the query, it returned the appropriate FTS |plan. | |hth, | |Jack Silvey | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: DBA_EXTENTS problem

. Thanks, Babu === message truncated === __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL

script to show heirarchical list of object dependencies for a given object

start with referenced_owner = upper('1') and referenced_name = upper('2') and owner is not null / good luck, jack silvey __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ

Re: script to show heirarchical list of object dependencies for a given

the adult diaper? Doing a little CYA? Jared Jack Silvey [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/09/2002 04:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:script to show

Re: too low optimizer_index_cost_adj causing bizarre index choice

). __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

  1   2   >