using oracle 817 driver against oracle 92 database

2004-01-26 Thread Gurelei
? thanks Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services

how do I interpret this in bstat/estat

2004-01-20 Thread Gurelei
the statspack, but I haven't switched to it yet). TIA Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET

how do I interpret this in bstat/estat

2004-01-20 Thread Gurelei
the statspack, but I haven't switched to it yet). TIA Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET

Re: how do I interpret this in bstat/estat

2004-01-20 Thread Gurelei
!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

ora-1555 under automatic undo management

2004-01-15 Thread Gurelei
://www.orafaq.net -- Author: Gurelei 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

what is free buffer scans

2003-08-20 Thread Gurelei
a different name? thanks Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network

low number of free buffers in the buffer cache

2003-08-19 Thread Gurelei
or can I just ignore it. TIA Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City

Re: ora 1575?

2003-08-14 Thread Gurelei
default PCTINCREASE non-zero, thus attacting SMON to do coalescing? If so, I'd suggest going to locally-managed tablespaces if at all possible... on 8/12/03 12:44 PM, Gurelei at [EMAIL PROTECTED] wrote: Hi all: I'm seeing the ora-01575 error in the alert logfile

ora 1575?

2003-08-14 Thread Gurelei
you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: ora 1575?

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

Re: ora 1575?

2003-08-14 Thread Gurelei
of dictionary-managed tablespaces? * do these DMT's have default PCTINCREASE non-zero, thus attacting SMON to do coalescing? If so, I'd suggest going to locally-managed tablespaces if at all possible... on 8/12/03 12:44 PM, Gurelei at [EMAIL PROTECTED] wrote

optimizer parameters in Oracle 9.2

2003-07-30 Thread Gurelei
://www.orafaq.net -- Author: Gurelei 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: optimizer parameters in Oracle 9.2

2003-07-30 Thread Gurelei
: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: optimizer parameters in Oracle 9.2 Hi all: I have been reading on the optimizer_ parameters for Oracle 9i - optimizer_max_permutation, optimizer_index_caching

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread Gurelei
, but already 10G is looming and it's summer and the weather is nicesigh... on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] wrote: Rich, thanks a lot. I just finished reading Tim's paper and it is truly enjoyable reading. I'm going to test his advices in a few

alter table exchage partition moves statistics?

2003-07-30 Thread Gurelei
__ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

convert a b-tree index into a bitmap index

2003-07-23 Thread Gurelei
Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

IOT

2003-07-17 Thread Gurelei
__ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

how do I test a restore of a raw device?

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

Re: tunning an index built

2003-07-09 Thread Gurelei
buffer cache. Parameter name should be something like NBUF. On 2003.07.08 17:29, Gurelei wrote: Hi. I'm trying to tune an index build. The table currently has about 65mil rows and I'm building a unique index, which takes about 55min to finish. The table size

tunning an index built

2003-07-08 Thread Gurelei
to 800M, sort area to 50M thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services

RE: tunning an index built

2003-07-08 Thread Gurelei
: http://www.orafaq.net -- Author: Gurelei 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: tunning an index built

2003-07-08 Thread Gurelei
and not those of my employer or clients ** -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: tunning an index built Hi. I'm trying to tune an index build. The table

enable fk into exceptions

2003-07-07 Thread Gurelei
: http://www.orafaq.net -- Author: Gurelei 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

how to pass a parameter to a MS Access path-through query running against Oracle

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

RE: MS Access as a front-end to Oracle DB

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

MS Access as a front-end to Oracle DB

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

copy a datafile to a raw device

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

RE: copy a datafile to a raw device

2003-06-19 Thread Gurelei
] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: exchange partition in 9.2

2003-06-17 Thread Gurelei
duplicate rows for the PK constraint. There is a Metalink note on that. Does the table have a PK enforced by a locally partitioned unique index? Any global indexes? What options did you have on the exchange partition statement? -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED

exchange partition in 9.2

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

change a LMTS parameters

2003-06-13 Thread Gurelei
Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

How to use rPerf to estimate a partitioned server capabilities

2003-03-31 Thread Gurelei
://www.orafaq.net -- Author: Gurelei 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: the number of concurrent queries

2003-03-24 Thread Gurelei
__ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: the number of concurrent queries

2003-03-24 Thread Gurelei
with that? thanks Gene __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei

Re: Weekly aggregates

2003-03-21 Thread Gurelei
! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

the number of concurrent queries

2003-03-21 Thread Gurelei
, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: the number of concurrent queries

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

RE: the number of concurrent queries

2003-03-21 Thread Gurelei
! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Weekly aggregates

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

RE: Weekly aggregates

2003-03-20 Thread Gurelei
://www.orafaq.net -- Author: Gurelei 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: update 30mil rows - thanks

2003-02-26 Thread Gurelei
Chao, Connor, Sanjay, cary, mark, richard: Thanks for your input. I didn't think of creating a new table and then renaming it as many of you suggested this may take les time. thank you all very much Gene --- chao_ping [EMAIL PROTECTED] wrote: Gurelei, I suggest your create your

update 30mil rows

2003-02-25 Thread Gurelei
running 8.1.7.4 thanks for any advice. __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City

OEM-related *.osc files

2003-02-24 Thread Gurelei
__ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

what does INACTIVE session do?

2003-02-06 Thread Gurelei
INACTIVE sessions. What is the explanaion here? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL

Oracle 7.3 recovery

2003-02-04 Thread Gurelei
: Gurelei 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

ora -1002

2003-01-07 Thread Gurelei
any ideas? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network

RE: ora -1002

2003-01-07 Thread Gurelei
have any ideas? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED

UNDO segments in 9.2

2003-01-07 Thread Gurelei
help Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services

ora 3237

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

rename and BMC backup

2002-12-05 Thread Gurelei
- Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

how do I calculate the Oracle's usage

2002-11-25 Thread Gurelei
://www.orafaq.com -- Author: Gurelei 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: how do I calculate the Oracle's usage

2002-11-25 Thread Gurelei
On Mon, 25 Nov 2002, Gurelei wrote: I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides

Re: low buffer hit ratio

2002-11-15 Thread Gurelei
the bhr to 95%. Thanks for your help Gene __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED

RE: low buffer hit ratio

2002-11-15 Thread Gurelei
: Gurelei - What do you mean by a low buffer hit ratio for a SQL statement? BHR is measured for the system, not for an individual query. Why have you singled this query out for attention? Are there complaints about its performance? Does it hit more blocks that other queries on your system

low buffer hit ratio

2002-11-14 Thread Gurelei
__ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

BMC's dtoarchmon goes to lunch

2002-11-05 Thread Gurelei
-- Author: Gurelei 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

Orace setting on NT

2002-10-07 Thread Gurelei
variable is the way to do it on UNIX.) thanks for any help Gene __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL

Can I do this in Oracle 8i?

2002-09-27 Thread Gurelei
SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

ORA-19587

2002-09-26 Thread Gurelei
://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Why does my insert creates so many logs?

2002-09-19 Thread Gurelei
on the dba_tables set to Yes. thanks Gene __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network

RE: Why does my insert creates so many logs?

2002-09-19 Thread Gurelei
need to be logged. I think that the redo generated due to this should not be very large though. Hope this helps. Viral Desai From: Gurelei [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Why does my insert creates so

Why does my insert creates so many logs?

2002-09-18 Thread Gurelei
: Gurelei 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-Mail

Re: Why does my insert creates so many logs?

2002-09-18 Thread Gurelei
subscribing). __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

BMC Backtrack until_cancel

2002-09-10 Thread Gurelei
Backtrack? thank you Gene __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat

BMC Obacktrack

2002-09-05 Thread Gurelei
- Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

ora 14130 when doing an alter table exchange partition

2002-08-19 Thread Gurelei
idea what may be wrong here? thanks Gene __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network

RE: what is wrong with this idea ... - thanks

2002-08-16 Thread Gurelei
for your responses. Gene __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services

what is wrong with this idea ...

2002-08-14 Thread Gurelei
://www.orafaq.com -- Author: Gurelei 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: insert nologging parallel/noparallel and archiving

2002-08-14 Thread Gurelei
are always logged, even in PDML and append modes. __ 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: Gurelei INET: [EMAIL PROTECTED] Fat

RE: what is wrong with this idea ...

2002-08-14 Thread Gurelei
; The duhveloper can then: select parent_pk_column, get_child_status(parent_pk_column) from parent_table; Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 9:19 AM

RE: what is wrong with this idea ...

2002-08-14 Thread Gurelei
between four separate columns or a single column with concatenated values? __ 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: Gurelei INET

Re: insert nologging parallel/noparallel and archiving

2002-08-14 Thread Gurelei
may provide some help __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Compatibility martix on Metalink

2002-08-02 Thread Gurelei
!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Compatibility martix on Metalink - Thanks

2002-08-02 Thread Gurelei
Thanks you, Dennis, Stephen and Chandesh. I found it. Gene --- Gurelei [EMAIL PROTECTED] wrote: Hi, I remember being able to find a compatibility matrix on Oracle MEtalink with the info of which Oracle version is running under which OS. LAtely, I haven't been able to locate it. Can

Delete performance

2002-08-01 Thread Gurelei
segments. Is this a good idea to try? thanks for any info Gene __ 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: Gurelei INET: [EMAIL PROTECTED

How do I check whether a rollback activity is going on

2002-07-15 Thread Gurelei
tables? thakns gene __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services

RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]

2002-07-10 Thread Gurelei
also send 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: Gurelei INET

Re: insert nologging parallel/noparallel and archiving - thanks

2002-07-08 Thread Gurelei
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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

insert nologging parallel/noparallel and archiving

2002-07-05 Thread Gurelei
__ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

suggestion for a class/book

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

a simple question about FKs

2002-06-18 Thread Gurelei
Gene __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Database restore question

2002-06-13 Thread Gurelei
Gene __ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858

partial restore of a database

2002-06-12 Thread Gurelei
__ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

explain plan question

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

Re: explain plan question

2002-06-06 Thread Gurelei
Peter, Charile: Sore area size is 5 times more in prod DB, shared pool is larger in dev, db_block_buffers in dev is twice the size in prod. I guess this answers my question. thanks Gene --- Peter Gram [EMAIL PROTECTED] wrote: Gurelei Are the parameter's the same ? sort* hash

is this a valid scenario?

2002-06-06 Thread Gurelei
__ 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

alter table move resets NEXT?

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

OS patches required by Oracle

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

Re: extents allocation in parallel load

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

Re: extents allocation in parallel load

2002-05-15 Thread Gurelei
: Gurelei 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

extents allocation in parallel load

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

Re: extents allocation in parallel load

2002-05-14 Thread Gurelei
://www.orafaq.com -- Author: Gurelei 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: extents allocation in parallel load

2002-05-14 Thread Gurelei
Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

data warehousing desing - to denormalize or not to denormalize - that is the question

2002-05-10 Thread Gurelei
: http://www.orafaq.com -- Author: Gurelei 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: data warehousing desing - to denormalize or not to denormalize - that

2002-05-10 Thread Gurelei
to this philosphy. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/10/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:data warehousing desing - to denormalize

RE: data warehousing desing - to denormalize or not to denormaliz

2002-05-10 Thread Gurelei
is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

unknown value

2002-05-07 Thread Gurelei
-- Author: Gurelei 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

oiconnect fails

2002-04-30 Thread Gurelei
__ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

groupping and percentages

2002-04-30 Thread Gurelei
://www.orafaq.com -- Author: Gurelei 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

index status misleading?

2002-04-26 Thread Gurelei
You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

  1   2   >