Diff. execution plans

MAXIMO.COA_NDX1 INDEX [RANGE SCAN] Why do we see different exec. plans - one for SQL Plus (and Sql Navigator, also) and another for JDBC connection? Any hints, please? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Barac INET: [EMAIL PROTECTED]

Re: Parallel Query Server died

Kool, now some cyber funeral will take place... - Original Message - From: shuan.tay(PCI¾G¸R³Ô) To: Multiple recipients of list ORACLE-L Sent: Friday, May 30, 2003 11:19 Subject: Parallel Query Server died Dear all DBAs,   What should i check for this error?

SunCluster 3. 0 Veritas File system RAC

, Vladimir Barac

Oracle options

Hello   Could anyone please tell how to find out whether following options are actually initialized   Oracle SpatialOracle interMediaOracle Visual Information RetrievalOracle Text   V$OPTION is not of any use, except "Parallel Server" and "Java" all other parameters are "TRUE", which is not

Db. Upgrade Assistant - any bad stories?

Hi   I'm about to upgrade 8.1.7 db to 9.2 db.   Platform is AIX.   "Database Upgrade Assistant" is going to be used. Does anyone have any bad experience with this oracle tool? Or the whole process is straight forward?   Thanks, Vladimir Barac

Loaded options - finding out

t V$OPTION is returning "true" for everything, although I know I DIDN'T loaded everything.   Thanks Vladimir Barac  

AIX 5L - what is it?

Hello to everyone   I see two options for 9i download at "technet" site - "AIX" and "AIX based 5L systems".   What does that difference mean?   How do I find out whether server is one or the other?   Thanks,   Vladimir Barac

Find out thread in RAC session

Good day to everyone   How do I find under which thread is my current session running in 9i RAC?   Vladimir Barac

Tru64 CFS - Sun UFS

I'm going to administer Sun based RAC.   So far I had experience with Tru64 based RAC.   Are there any advantages / disadvantages in using UFS on Sun?   Thanks, Vladimir Barac  

JDK_HOME - Do we need damn JDK_HOME?

is going to be used without any fancy options beside partitioning. Clients are good old Forms and Reports...   Thanks, Vladimir Barac

RAC recomended books

What books are "recomended reading" for RAC?   Especially Tru64 based RAC?   Beside paper books, are there any good web pages (beside metalink, of course) that are dealing with RAC?   Thanks, Vladimir Barac  

RAC 9i - renamin files

we have no raw devices. Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: hw info on Tru64 system

e 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: Vladimir Bar

OT: hw info on Tru64 system

Good day to everyone   How do I find hardware info on Tru64 machine?   Available RAM, number of CPUs...?   Thanks in advance, Vladimir Barac

Re: OT: Cron not working

> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may &g

OT: Cron not working

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

RMAN, recatalog backup set

ace" script. So, RMAN info is nonexistant.   Thanks, Vladimir Barac

Fw: Greeting

  <>

RMAN scripts - archived logs

Good day to everyone   Would somenone share their scripts used to backup archived logs using RMAN 8.1.7? The more complex, the better...   Thanks, Vladimir Barac

RMAN archived log

Oracle 8.1.7   RMAN with no catalog db, only controlfile is used...   How do I remove entries from V$ARCHIVED_LOG;   After "backup archivelog all delete input", files are deleted from disk, and their status "deleted" in v$archived_log is set to "YES". But I want to completely remove entries

HP OmniB. + RMAN 8i

?   Thanks, Vladimir Barac  

Re: how many records will be keep in v$log_history?

g 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). > > -- Pl

National characters and UTL_FILE

Hello to everyone   I want to write national characters (Central European) to ASCII file, by using utl_file.   UTL_FILE is called within unix script, and afterwards ascii file (after applying "unix2dos") is sent as an attachment (by using "uuenview"). Both NLS_CHARACTERSET (EE8ISO8859P2) para

Re: ECM / BCV / hot backup

Thanks a lot!   These advices will give me touch of seriousness at client's site...   Regards, Vladimir Barac   - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 14:48 Subject: Re: ECM / BCV

Re: ECM / BCV / hot backup

RMAN instead.  The RMAN user's guide describes exactly this scenario... - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 5:03 AM Subject: ECM / BCV / hot backup Go

ECM / BCV / hot backup

Good morning/afternoon/evening to everyone...     I'm about to "configure"  oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows     1. put all tablespaces into backup mode (db is in arch. mode),   2. sleep   3. do the split   4. take out tablespaces of backup mod

Archived logs backup

Hi!   I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed...   Within script how do I skip archived log file that is being written by oracle?   Thanks, Vladimir Barac  

Suse 7.1 Oracle 8.1.7

file system support files over 2GB in size?     Thanks, Vladimir Barac

Re: Anybody There?

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

Re: Anybody There?

You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services

Drop snapshot & ORA-03113 - part 2

DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Ne

Drop snapshot & ORA-03113

- but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac

Tao of backup

For those who are not enlightened yet   http://www.taobackup.com    

How long did job run?

Hello to everyone   Is it possible to find LAST execution time of a job?   DBA_JOBS has column TOTAL_TIME, but I need something like "last time".   Thanks

AIX related

Hi!   How to find out number of CPU's and ammount of RAM on AIX machine?   Thanks, Vladimir

NFS and arch. logs revisited...

Hi!   Query     select name, isdefault, value from v$parameter where name like '%log%'   gave me following results... NAME   ISDEFAULT VALUE-- - ---log_archive_dest_1 

Response file - example needed

would replace somebody's directories with appropriate ones... Thanks in advance... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Calif

LOG_ARCHIVE_DEST and NFS

Hello to everyone!   In order to duplicate archived logs to other machine, I have to add new log_archive_dest parameter, which points to NFS mount point. No, I can't avoid that...   I would like to hear bad stories, good stories, rants, recomendations, tricks'n'tips... about nfs combined with

Replication - truncate not propagating

Hi!   I have noticed something...   Deletes are propagating from master site to the snapshots. Everything works like charm, as it is supposed.   But... truncate of master table IS NOT seen in snapshot table. I don't really expect snapshot to be truncated, of course, but I expect it to be em

RAC related info

Hi, everyone! Does anybody have links related to 9i RAC on Tru unix? Advices, trick'n'tips, FAQ's, case studies... Beside technet and metalink, of course. Thank you in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladim

ORA-00904 revisited, found something

(job, ownerid, owner) as SELECT j$.job, u$.user#, j$.powner FROM sys.job$ j$, sys.user$ u$ WHERE j$.powner = u$.name -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 5

Re: ORA-00904 invalid column name and export

From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 ente

ORA-00904 invalid column name and export

00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- A

Yesterday's date - unix question

Good morning / afternoon / evening... How to find yesterday's date in unix? Yes, I know how to find it by using env. variables, sql*plus, redirecting output and so on... But I need pure unix solution. Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafa

Re: Activating replication

Well, I was thinking about replicatin related sys-owned procedures only!!! Actual data replication is on behalf of my own planning, of course! I don't expect catrep.sql to quess my thoughts and do job instead of me! Regards, Vladimir Barac - Original Message - To: "Multiple

Activating replication

Hi   Oracle 8.1.7 EE   both Win2000 and Solaris   Is running catrep.sql really, really, really all that is needed to activate replication in 8i?    

ORA-600 during replication

What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network

Locked rows - finding out

://www.orafaq.com -- Author: Vladimir Barac - posao 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

DUAL related

For those who want to optimize "select from dual", look at the following link... http://www.oracledba.co.uk/tips/dual_speed.htm Regards, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat Ci

Unix related - need some info

als... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pub

Replication - Oracle 9i - problem

n option is present. Platform is 9i on Win2000. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

Sites worth visiting

For those who don't know yet... www.oracle-base.com www.oracledba.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Calif

Unix shell scripting - cool link

For those who already don't know, go to the site listed bellow.   http://www.injunea.demon.co.uk/index.htm   Great tutorial that deals with shell scripting.

Num. of blocks multiple of 5?

Hi all!I have created tablespace where initial and next extents are same = 128KB.Block size is 4K.After creating test table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks, instead of 32 blocks.Same happened with tablespace where initial = next = 256 and test tableoccupied 6

OT: X Win client

Hi all!   Is there any free (important: free) X client software for NT?   Regards, Vladimir Barac

OT: Sybase

- best practices - worst practices... Feel free to send either docs or links. Thanks in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

ITL, DELAYED BLOCK CLEANOUT

Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT?Thanks