Re: IO Topology Anyone???

2003-06-22 Thread Tanel Poder
? Robert -- 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: IO Topology Anyone???

2003-06-23 Thread Tanel Poder
Ah, thank you. I do remember reading about that feature now. I need to find out if this works with Clariion, and how to acccess the data without Oracle Enterprise Mangler. Hi! Check v$map_ views. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel

Re: Oracle E-Business Suit 11 i /Oracle Financials upgrade to 11i course

2003-06-23 Thread Tanel Poder
://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: linux and windows2000 memory allocation

2003-06-23 Thread Tanel Poder
a 4G Dell server, how much of that memory can be made available to the Oracle software? Regards, Patrice. -- 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: What are the type#'s in obj$ ?

2003-06-23 Thread Tanel Poder
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: SMON taking 50% of CPU and certain queries hanging

2003-06-23 Thread Tanel Poder
: 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 yourself

Re: Migrating 8i OPS to RAC 9.2

2003-06-24 Thread Tanel Poder
from 8i to 9i ? If so , how are the Online Redo Log groups individually Migrated from 8i to 9i ? Could NOT find any reference to individual Redo Log groups getting migrated in the Docs. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET

Re: Thanks!! What are the type#'s in obj$ ?

2003-06-24 Thread Tanel Poder
of a disagreement about whether this object really exists. I guess the database wins. Thanks again. Barb --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Check http://www.jlcomp.demon.co.uk/faq/non_exist.html for explanation. Also, I'll include a little sample, how they might

Re: Thanks!! What are the type#'s in obj$ ?

2003-06-24 Thread Tanel Poder
previous versions) Cheers, Tanel. Interesting. I didn't realize that oracle would keep dropped objects as an unused type rather than delete them. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City

Re: Index question

2003-06-24 Thread Tanel Poder
Hi! If you are new to Oracle, it might be easier to use DBA studio (which usually comes with Oracle) or other GUI tool such is Toad (http://www.toadsoft.com/). But if you want to learn how things really work, then open up sqlplus and start experimenting with data dictionary views: select

Re: Statistics problem

2003-06-25 Thread Tanel Poder
') 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: SELECT Output Default Ordering ?

2003-06-25 Thread Tanel Poder
application will fail big time! 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 9.2 RAC on Win2K?

2003-06-25 Thread Tanel Poder
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel

Re: SORT_AREA_SIZE question

2003-06-25 Thread Tanel Poder
Title: Message Hi! At the least the wording is incorrect, a user who *connects* to instance, doesn't allocate any sort memory unless there is a need for sort. And if there's need for 100k, only that much will be allocated. And when the sort is over (and rows returned), the sort memory is

Re: 9i OCP Details

2003-06-25 Thread Tanel Poder
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: SORT_AREA_SIZE question

2003-06-25 Thread Tanel Poder
Hi! Not entirely the truth. In huge reporting/OLAP environments you just can't have that much memory that all sorts are running entirely in memory. What you should look out for are multipass sorts, the ones which require reading and writing the same to disk multiple times. So keep the

Re: SELECT Output Default Ordering ?

2003-06-25 Thread Tanel Poder
should always include an order by clause. Hope this helps. Tom Mercadante Oracle Certified Professional -- 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: 9i OCP Details

2003-06-25 Thread Tanel Poder
advanced classes then pass an all day comprehensive hands on test right? what do they have you do for that test? i heard there are different OCMs? btw, how much does it all cost? From: Tanel Poder [EMAIL PROTECTED] Date: 2003/06/25 Wed PM 02:59:58 EDT To: Multiple recipients of list

Re: nfile parameter problem

2003-06-25 Thread Tanel Poder
, additional processes such are CKPT and SMON will open the file on their time. Happy experimenting! :) -- 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: Index question

2003-06-25 Thread Tanel Poder
Hi! Hm, what happened to insert hints.. such APPEND, PARALLEL, NOLOGGING etc..? I would avoid this "dbasupport" site, it has written *a lot* of crap before. Checkthis for example(Tom Kyte's comments on an dbasupport article :)

Re: How to get user's IP address?

2003-06-25 Thread Tanel Poder
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: SORT_AREA_SIZE question

2003-06-25 Thread Tanel Poder
: 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 Services

Re: Re: 9i OCP Details

2003-06-26 Thread Tanel Poder
to take 2 advanced classes then pass an all day comprehensive hands on test right? what do they have you do for that test? i heard there are different OCMs? btw, how much does it all cost? From: Tanel Poder [EMAIL PROTECTED] Date: 2003/06/25 Wed PM 02:59:58 EDT

Re: nfile parameter problem

2003-06-26 Thread Tanel Poder
$ By the way, additional processes such are CKPT and SMON will open the file on their time. Happy experimenting! :) -- 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: redo log maintenance

2003-06-26 Thread Tanel Poder
Title: redo log maintenance Hi! You won't be affecting anycurrent redolog negatively, you simply get an error, but the normal work continues as usual... tnl. - Original Message - From: Goulet, Dick To: Multiple recipients of list ORACLE-L Sent: Friday, June 27,

Re: Dedicated Server problem ORA-03113

2003-06-28 Thread Tanel Poder
://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: Production Database stays up; copies will not recover

2003-07-01 Thread Tanel Poder
Do you see only one distinct change#? Note that if you got read only tablespaces, then it's ok to see more than one distinct change#'s, but for read write's it should be the same. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL

Re: Production Database stays up; copies will not recover

2003-07-01 Thread Tanel Poder
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: Drop Tablespace

2003-07-01 Thread Tanel Poder
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: Drop Tablespace

2003-07-01 Thread Tanel Poder
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 percent increase higher than 0 in 817?

2003-07-02 Thread Tanel Poder
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: create imp and exp Oracle as single-task binaries?

2003-07-02 Thread Tanel Poder
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: service name, sid ..

2003-07-03 Thread Tanel Poder
Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create controlfile). You can have several databases with same db_name in one server, there is no restriction. SID - When we actually want to open and

Re: Questions on java

2003-07-04 Thread Tanel Poder
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://www.fatcity.com San

Re: service name, sid ..

2003-07-07 Thread Tanel Poder
- From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, July 03, 2003 10:49 AM Subject: Re: service name, sid .. Hi! There's actually more: db_name - identifies database name, has to be the same what is stated

Re: salary question

2003-07-08 Thread Tanel Poder
180% on cars. After adding that, you add the 25% VAT. So $10K becomes $35K. Heh, that's probably one of the reasons why you got *so many* bikes inCopenhagen ;) Tanel.

Re: Oracle DW Implementation

2003-07-08 Thread Tanel Poder
Title: Message Hi! Do you really base your decision on input from here? People, businesses, requirements, yadda-yadda, are so different, that you probably won't find any truth from here. I was *lucky* to inherit several DWs up to 2TBs few years ago on Oracle 8.0.4.0.0, on Windows NT 4.0

Re: update about 100K records

2003-07-09 Thread Tanel Poder
(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: something appears to be funny with ROWNUM

2003-07-09 Thread Tanel Poder
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: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Tanel Poder
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://www.fatcity.com

Re: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Tanel Poder
(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: Restricting access via sqlplus

2003-07-09 Thread Tanel Poder
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-- Mailing list

Re: Restricting access via sqlplus

2003-07-09 Thread Tanel Poder
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Tanel Poder [mailto:[EMAIL

Re: RULE hint

2003-07-09 Thread Tanel Poder
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: RULE hint

2003-07-09 Thread Tanel Poder
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 services

Re: trigger and LogMiner

2003-07-10 Thread Tanel Poder
://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: High availability and upgrades

2003-07-10 Thread Tanel Poder
Hi! Is this your own-written app? If you want performance, control and no-data-loss reliability: 1) Have 2 completely independent databases 2) Have your application servers multiplex all DML requests to both database servers That means, if your client inserts something, then app

Re: High availability and upgrades

2003-07-10 Thread Tanel Poder
to error and failure to me. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Is this your own-written app? If you want performance, control and no-data-loss reliability: 1) Have 2 completely independent databases 2) Have your application servers multiplex all DML requests to both

Re: High availability and upgrades

2003-07-10 Thread Tanel Poder
is an art ! -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 10, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: High availability and upgrades It is our own application. That's an interesting approach, thanks! --- Tanel Po

Re: any script to parse alert log ?!

2003-07-10 Thread Tanel Poder
, 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

Re: High availability and upgrades

2003-07-10 Thread Tanel Poder
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: Copying database from vxfs to ufs

2003-07-10 Thread Tanel Poder
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: full usefullness of CURRENT OF ???

2003-07-11 Thread Tanel Poder
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: Security, private vs. public synonyms and contention data di

2003-07-11 Thread Tanel Poder
Title: RE: Security, private vs. public synonyms and contention data dictionary A lot of people have posted messages like: "I have several applications in my DB, but I can't create new public synonyms for my new app, because public synonym with that name already exists!". So, this should be

Re: Performance problems VMS 8i

2003-07-15 Thread Tanel Poder
-- 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: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread Tanel Poder
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: should you seperate indexes from tables in seperate datafiles?

2003-07-15 Thread Tanel Poder
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: should you seperate indexes from tables in seperate datafiles?

2003-07-15 Thread Tanel Poder
but other wiser people might want to comment on it.. 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

Re: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread Tanel Poder
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: SGA question

2003-07-15 Thread Tanel Poder
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: security without using different usernames

2003-07-15 Thread Tanel Poder
Title: RE: upgrade to AIX 5 Ryan, It's alter session set current_schema = name; Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 1:29 AM Subject: security without using different usernames I

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-15 Thread Tanel Poder
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: RAC or Oracle Fail Safe

2003-07-16 Thread Tanel Poder
, 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

Re: listener

2003-07-16 Thread Tanel Poder
Hi! Your databases actually have to register with your listener on remote machine. Your databases have to have tnsnames.ora configured with entry for listener location as well and your instances' REMOTE_LISTENER parameter has to specify the tns alias for listener location. That way

Re: Another OCP slant...

2003-07-17 Thread Tanel Poder
Title: RE: Another OCP slant... Hi! Why did you take 8 + 1 tests for 8 and 8i DBA? 5 + 1 should have been enough? Back in summer of 1999 when I wen't to EOUG yearly conference, Oracle promoted their OCP exams there and let people take their exams free. I thouht, what the heck, let's give

Re: DBMS_REPAIR Package

2003-07-17 Thread Tanel Poder
(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

Re: Here comes Oracle10G

2003-07-17 Thread Tanel Poder
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: RAC or Oracle Fail Safe

2003-07-20 Thread Tanel Poder
Title: RE: RAC or Oracle Fail Safe Hi! Of course you have to plan your servers' capacity accordingly, that in the event of node failure, the other node will not get too loaded. When one node crashes, the second one has to deal with queries and transactions of both servers and we must not

Re: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
: 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 yourself

Re: Different Platform

2003-07-20 Thread Tanel Poder
: 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: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
(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: DB shift

2003-07-20 Thread Tanel Poder
: 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: Increase tablespace, which way is better?

2003-07-20 Thread Tanel Poder
Hi! Also, there is (or was?) a tradeoff between size and number of datafiles. Before 8i, ifI recall correctly, all datafile headers had to be physicallyvisited (header SCN changes were written) before a checkpoint could finish. If you got thousands of files, this adds significant

Re: RAID select

2003-07-22 Thread Tanel Poder
, 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

Re: SHOW ERRORS not working

2003-07-22 Thread Tanel Poder
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: LMT Migration

2003-07-22 Thread Tanel Poder
Hi! Make sure your extents are in size or multiples of your block_size*db_file_multiblock_read_count. This might help in performance when doing index fast full scans. Also, if you use striped disks, you might want to match it with stripe width. But number of extents doesn't cause any

Re: Oracle 10G info note

2003-07-22 Thread Tanel Poder
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: How to tell if a given session is coming across a db link?

2003-07-23 Thread Tanel Poder
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: dba age

2003-07-23 Thread Tanel Poder
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: index rebuild

2003-07-23 Thread Tanel Poder
Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L

Re: Managing Archived Redo Logs

2003-07-23 Thread Tanel Poder
). -- 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: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?

2003-07-23 Thread Tanel Poder
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: Index Usage ?!

2003-07-24 Thread Tanel Poder
B -- 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 on linux vs. on windows

2003-07-24 Thread Tanel Poder
Title: Extproc setup Q? Heh-heh, Burleson talking about running Oracle on WINE and IBM dropping AIX.. What a joke... Tanel. - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Thursday, July 24, 2003 3:34 PM Subject:

Re: Oracle on linux vs. on windows

2003-07-24 Thread Tanel Poder
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: Recommendation for cheap HA solution

2003-07-24 Thread Tanel Poder
Title: Recommendation for "cheap" HA solution Hi! When not having any cluster manager, there's 3 main issues what you have to deal with: 1) hearbeat - verifying whether primary node (or other nodes) are alive 2)storage - making failed node's storage accessible to backup node 3)

Re: Timestamps in trace files (and other trace file oddities)

2003-07-24 Thread Tanel Poder
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: Does the client hang or disconnect when the server's

2003-07-24 Thread Tanel Poder
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

Question about the list

2003-07-24 Thread Tanel Poder
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: index not being used

2003-07-25 Thread Tanel Poder
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: Index Usage ?!

2003-07-25 Thread Tanel Poder
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: Index Usage ?!

2003-07-25 Thread Tanel Poder
. * correct me if i'm wrong * Aren't they contradictory ?! So how does case 2 benefit in terms of CPU or memory consumption ? and there is a big diff. in response time between both cases...how ? ...totally confused :( Regards, Jp. 25-07-2003 18:34:23, Tanel Poder [EMAIL PROTECTED] wrote

Re: index not being used

2003-07-25 Thread Tanel Poder
or D.DOCLINKNUM = A.WONO regards Hrishy --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! This plan shows that ICWOIMP is accessed FULL . Actually this table has a Primary Key on WOKEY this is used in JOIN condition . WHy is it not using that index But you also have two

Re: Index Usage ?!

2003-07-25 Thread Tanel Poder
-- 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: Does the client hang or disconnect when the server's

2003-07-25 Thread Tanel Poder
). Tanel Poder tanel.poder.003@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.ee cc: Sent by: Subject: Re: Does the client hang or disconnect when the server's

Re: Question about the list

2003-07-25 Thread Tanel Poder
') 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: Advice needed on dbms_shared_pool value

2003-07-25 Thread Tanel Poder
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: Opinions on Oracle InterConnect

2003-07-25 Thread Tanel Poder
Hi! Yes I believe InterConnect comes with Apps (technically with 9iAS). The plus is that Oracle itself is developing it and it's probably a strategic part in whole E-Business Suite. I believe it's running on Advanced Queuing and Workflow. The problem is, afaik, it's quite fresh product

Re: Question about the list

2003-07-27 Thread Tanel Poder
and mail admin. Don't know why some posts appear before others, could be a simple explanation, could be a very complex one. Not being a mail expert, I don't know which it is. Best ask Bruce if you're curios - [EMAIL PROTECTED] Jared On Thursday 24 July 2003 15:29, Tanel Poder wrote: Hi

Re: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time

2003-07-27 Thread Tanel Poder
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

  1   2   3   4   5   6   7   8   9   >