Re: [Q] wait time /lob def

://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Re: [Q] wait time /lob def

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

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

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

Re: [Q] wait time on stat

://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

Re: [Q] wait time /lob def

caching for LOBs in system level, although I've done some research on them lately (on 10g as well). Or are you talking about OCI LOB caching here? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services

Re: [Q] wait time /lob def

YES YES --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Do you have any LOBs defined with the nocache nologging attribute ? This was what I initially thought would be the problem, but then I thought, in case of nocache lobs you should see direct path writes (lob) a lot

Re: When does Oracle use 'Index Fast Scan'

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

Re: Re: When does Oracle use 'Index Fast Scan'

scans. any ideas? I rarely ever find this to be an optimal index access method for anything. From: Tanel Poder [EMAIL PROTECTED] Date: 2004/01/27 Tue AM 11:19:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: When does Oracle use 'Index Fast Scan' Another

Re: rman expired vs obsolete

://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

Re: ROWID PROBLEM

Title: RE: alter table rename error Maybe the problem is with your capital letters?! Tanel. - Original Message - From: Waleed Haggagy To: Multiple recipients of list ORACLE-L Sent: Sunday, January 25, 2004 5:19 PM Subject: ROWID PROBLEM HI ALL.. I

Re: ORA-904 after table rename

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network

Re: AQ

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

Re: ORA-904 after table rename

To: Multiple recipients of list ORACLE-L On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter

Re: Re[2]: Oracle vs Mysql

monopoly. I wonder whether this Linus needs a security blanket to carry around. Or did you mean Väinämöinen, a really wise guy from finnish mythology? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services

Re: ORA-904 after table rename

20, 2004 3:25 PM To: Multiple recipients of list ORACLE-L On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First

Re: (Non)Unique Index Vs Unique Constraint

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

free performance tuning books @ Veritas

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

Re: Strange Query Result,... urgent please

(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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: What is Hash Join?

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network

Re: Checkpoint ...

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services

Re: Checkpoint ...

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

Re: Checkpoint ...

. I got too carried away with not-s here... Anyway, the idea is that only few structures in datafile header are frozen during backup mode, but some may change as usual. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat

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

Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2). $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd (.orapwd must contain one line, the password) Tanel.

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

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

Re: Oracle vs Mysql

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

Re: Oracle vs Mysql

One more thing which you can tell your boss: MySQL and Oracle are not comparable, at least not with any trustworthy results. (the same goes with MySQL and DB2 or Access and SQL server...) Tanel. - Original Message - From: Mujeeb Chowdhry To: Multiple recipients of list

Re: Disk capacity planning

Hi! I don't remember any documents other than Oracle documentation by heart, but would like to make one point here: Disk capacity planning is not only predicting how many Mega/Giga/Terabytes you'll need in certain point of time, planning also includes requires IOPS prediction, also IO

Re: Heap

In last few weeks, there have been several discussions about Oracle's memory management heap structures as well. Search the archives, visit www.ixora.com.au , and read Steve's book. Tanel. - Original Message - From: bhabani s pradhan To: Multiple recipients of list

Re: Shared Pool fragmentation

dba_object_size only shows some fixed calculations from stored code (how big is the code segment etc..), but it doesn't show how much memory a loaded object actually uses in shared pool. If you want to know library cache usage, use v$db_object_cache or x$kglob directly. If you want to know

Re: Should we stop analyzing?

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

Re: A STRANGE QUERY

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

Re: why would enable constraint cause a delete to wait on library cache lock?

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

Re: Suggestions Needed: Latch free - library cache

the knowledge that roles and usernames are kept in the same base table... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Backups in a DW Environment

in mind in this case, that there might not be enough room for allocating additional ITL entries in a block, so you should use INITRANS for setting minimum number of entries a block has. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL

Re: Suggestions Needed: Latch free - library cache

session set current_schema=schema', though that might become unwieldy with a large number of users, or when forced to work with an app that connects/disconnects repeatedly. Jared On Sat, 2004-01-10 at 10:24, Tanel Poder wrote: Hi! If you intend to use roles to simplify privilege

Re: Re: table reorganizations

Another way would be to do exchange partition between a single- or multipartition partitioned table and a regular table. Easier than dbms_redefinition and less locking issues than with manual lock swap. Tanel. --- Saatja: Rachel Carmichael [EMAIL PROTECTED] Kuupäev: 09.01.2004 16:14:33 ---

RE: Suggestions Needed: Latch free - library cache

During the Hotsos course I thought I remember hearing that the pool could be too large and that could have a negative impact on the library cache latch.  Am I confusing this with something else (maybe the buffer busy event)?   If true how do you go about determining the optimal size?  

Re: Problem with understanding Optimization methods.

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

Re: Problem with understanding Optimization methods.

timization methods. Tanel, Wouldn't this be expected behaviour when both columns of the table were indexed? Bambi. -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 07, 2004 3:30 PMTo: Multiple recipients of list ORACL

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

generation shouldn't be dependent on redolog size. But in this case yes (Could be an Oracle 9i bug?). Regards Mauricio Vélez Tanel Poder [EMAIL PROTECTED] wrote: Is your system overloaded e.g. there is a continuous queue of transactionswaiting? In that case

Re: Should we stop analyzing?

2- the CBO like any other piece of code, is sometimes buggy? Always, not sometimes Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: OCP Question (Perf Tuning)

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

Re: Any Oracle 9i Data Guard limitations specific to Linux implementations?

') 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: Tanel Poder INET: [EMAIL

Re: ORA-01578 data block corrupted

(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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: OCP Question (Perf Tuning)

even mention the real life situation too much, except in really misleading cases... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: ora1652 question...

Fewcomments inline: 1. Easier, but requires a bounce : Add the following event into init.ora event="1652 trace name processstate level 10" You can use alter system and dbms_system.set_ev in combination to force an event for all new and existing sessions, without a bounce (alter system

Re: Re[2]: OCP Question (Perf Tuning)

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network

Re: Problem with understanding Optimization methods.

(sorry for long post again) No, but there's an order by clause on COL3 and apparently an index as well, so RBO thinks it's cheaper to read keys+rows in order using index full scan than reading all rows and sorting them. Note that optimizer needs to know that all table's rows have

Re: OSUSER v 9.2.0.2 on linux

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: ora1652 question...

(repost) Fewcomments inline: 1. Easier, but requires a bounce : Add the following event into init.ora event="1652 trace name processstate level 10" You can use alter system and dbms_system.set_ev in combination to force an event for all new and existing sessions, without a bounce (alter

Fw: Problem with understanding Optimization methods.

(I suspect my last post didn't go through - sorry for long repost again) No, but there's an order by clause on COL3 and apparently an index as well, so RBO thinks it's cheaper to read keys+rows in order using index full scan than reading all rows and sorting them. Note that optimizer needs

Re: table reorganizations

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

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

Is your system overloaded e.g. there is a continuous queue of transactionswaiting? In that case, with bigger redologs, full checkpoints happen less frequently, allowing database to work faster, thus generating more redo. But, othervise, the archive generation shouldn't be dependent on

Re: Suggestions Needed: Latch free - library cache

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

Re: Convert to Locally-Managed Tablespaces

Hi I am curious - why are you forced to keep segments in specifically named tablespaces. This Concorde XAL application has an internal repository which stores information about physical segment structures (as tablespace name, initial next extent etc). And it can start reorganizing segments

Re: recreable/freeable chunks

Hi, I planned this answer a short one, but... Could you explain what is recreatable /freeable chunks and once recreatable chunks is removed from memory where it is kept. Memory allocations from shared pool heap or its subheaps are done in chunks. When allocating a chunk from shared pool

Re: recreable/freeable chunks

://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: (long) Top level heaps/subheaps

Well, a heap is just a bunch of memory (allocated incontiguous extents) and you can practically allocate any size of chunk of memory from it (with some restrictions). A regular heap has freelist and LRU list mechanismsfor managing space init as well as memory allocation/releasing routines

Re: pga workarea and ora-04030

, go with Jonathan's recommendation and try to allocate a large PL/SQL table to test whether it fails. Btw, is your batch job running in serial mode or with parallel slaves? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED

Re: recreable/freeable chunks

and recurrent unpinned recreatable chunks or is there just one, with two, transient and recurrent, ends? Thanks, Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: 11.5.8 AIX database tier clone issue

Title: 11.5.8 AIX database tier clone issue Did you try to relink all executables using adadmin first? Tanel. - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 06, 2004 4:59 PM Subject: 11.5.8 AIX database

Re: 11.5.8 AIX database tier clone issue

Title: 11.5.8 AIX database tier clone issue Also, is your context.xml file ok, did you edit it using context editor or manually? Tanel. - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 06, 2004 4:59 PM

Re: sql trace - forward attribution

$SESSION_CONNECT_INFO view. CLIENT_IDENTIFIER in V$SESSION might show something as well, if mid-tier is configured to pass client id to server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: 11.5.8 AIX database tier clone issue

-Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 06, 2004 10:40 AMTo: Multiple recipients of list ORACLE-LSubject: Re: 11.5.8 AIX database tier clone issue Did you try to relink all executables using adadmin first? Tanel

Re: Progress of an index rebuild

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

Re: sql trace - forward attribution

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

Re: sql trace - forward attribution

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

Re: sql trace - forward attribution

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Convert to Locally-Managed Tablespaces

will remain there, despite your conversions (of course, smaller extents might be able to use some of this fragmented space later on). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Convert to Locally-Managed Tablespaces

tablespaces 7) get index definitions out of exportfile and modify them to add parallel nologging (with big sort area size) 8) rebuild indexes 9) do a full backup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network

Re: HOTSOS Conference

, 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: Tanel Poder INET: [EMAIL PROTECTED] Fat

Re: OFA document

, 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: Tanel Poder INET: [EMAIL PROTECTED] Fat

Re: rman restore question

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

Re: stress testing

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

Re: max 5% of pga_aggregate_target for a single serial session

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

Re: rman restore question

dbms_backup_restore to manually extract your files from orphan backupsets (Note 60545.1) Tanel. - Original Message - To: [EMAIL PROTECTED]; Tanel Poder [EMAIL PROTECTED] Cc: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 3:55 AM Tanel, Do

Re: Should we stop analyzing?

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

Re: Apps 11.5.9 Disater Recovery Site

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

Re: Should we stop analyzing?

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

Re: is it possible to force different 'types' of index scans?

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

Re: increase in amount of redo comparing oracle 7 and 9

No, you insert 1 rows to your table in 9i, but only 6319 in 7.3. Also, obj$ has probably more (filled)columns in 9i compared to 7.3. Redo structure has changed between these versions, undo most likely as well. There are several other issues which might affect redo size such is

Re: Should we stop analyzing?

Title: RE: Should we stop analyzing? In 9i you could use optimizer_dynamic_sampling for such "work" tables Tanel. - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 30, 2003 6:09 PM Subject:

Re: Should we stop analyzing?

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

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

for specific query, last_output_rows shows rowcount for last execution of a query. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Should we stop analyzing?

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City

Re: Re: help with estimate row count from asktom

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network

Re: max 5% of pga_aggregate_target for a single serial session

ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: Should we stop analyzing?

actually with this parameter description I pointed you to, there were pointers to perf tuning guide: quote about optimizer_dynamic_sampling parameter You control dynamic sampling with the OPTIMIZER_DYNAMIC_SAMPLING parameter, which can be set to a value from 0 to 10. A value of 0 means

Re: Re:Re: recreate constraints script - URGENT

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

Re: recreate constraints script - URGENT

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services

Re: rman restore question

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

Re: max 5% of pga_aggregate_target for a single serial session

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

Re: rman restore question

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

Re: Apps 11.5.9 Disater Recovery Site

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services

Re: Apps 11.5.9 Disater Recovery Site

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

Re: Exporting a partition with transport tablespace

') 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: Tanel Poder INET

Re: RE: large pl/sql table sucking up all memory on a server

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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: RE: large pl/sql table sucking up all memory on a server

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

Re: SQL CASE Statement

://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

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

Hi! Comments below: let me be clearer. I need to return an estimate of the number of rows for 'pagination'. The user will page through 25 rows a time, but wants an estimate on the total number of rows returned. I want to avoid counts. tom kytes book says to use v$sql_plan, but how do i

  1   2   3   4   5   6   7   8   9   >