Diff. execution plans
Hello to everyone Info: - oracle 9.0.1.4 64bit on Solaris 8 - Sun Fire 15000 Here is the query select * from glcomponents where (glorder = 1 and compvalue in ( select glcomp02 from chartofaccounts where glaccount like '01-_-__-__-__-___-___%' and (disabled is null or disabled = 'N' ) and orgid = 'KNPC' ) ); When I execute this query within SQL*Plus, it is finished for less than secon. This is execution plan Elapsed: 00:00:04.01 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=617 Card=374 Bytes=4 3010) 10 HASH JOIN (SEMI) (Cost=617 Card=374 Bytes=43010) 21 TABLE ACCESS (FULL) OF 'GLCOMPONENTS' (Cost=16 Card=374 Bytes=26928) 31 TABLE ACCESS (FULL) OF 'CHARTOFACCOUNTS' (Cost=596 Card= 19589 Bytes=842327) When that query goes trough JDBC Thin Client, this is the execution plan which takes 4 minutes!!! (output from Ent. Manager) 5 SELECT STATEMENT 4 NESTED LOOPS [SEMI] 1 MAXIMO.GLCOMPONENTS TABLE ACCESS [FULL] 3 MAXIMO.CHARTOFACCOUNTS TABLE ACCESS [BY INDEX ROWID] 2 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] 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 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 also send the HELP command for other information (like subscribing).
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? "ORA-12805: parallel query server died unexpectedly" The SQL statement was running well before. There's nothing in the alert log about this error. I'm using Oracle 8.1.6 on Redhat 7.2. Thanks and have a nice day.
SunCluster 3. 0 Veritas File system RAC
Anyone using this configuration? Since I would like to avoid raw partitions, I was thinking of recomending Veritas File system... Is it certified / working? Anyone working with such combo? I will fire metalink page soon, but would like to have some input from listers! Thanks, 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 true! Thanks, Vladimir Barc
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
Good day to everyone How do I find what options are actually loaded into database? Not only installed, but loaded? For example, I may choose "Spatial" in Or. Installer, but later I may create basic database (catalog.sql and catproc.sql) without any option... It seems that 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?
Good day to everyone I'm installing 9.2 on Tru64. And I'm asked to provide JDK_HOME... Since I'm not going to install HTTP server or use any Java within database or with database, do I need to set JDK_HOME? I left it blank... Will there be any problem? Database 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
How do you rename files in RAC databases? When dealing with single instance db 1. shutdown 2. startup mount 3. copy file to new location using OS util. 4. alter database rename file... 5 startup. But now we have gsdctl, srvctl... So, what is the procedure ti rename file? We are using Tru64, so 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 services - 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 also send the HELP command for other information (like subscribing).
Re: hw info on Tru64 system
Kool! Thanks... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 16:33 > > psrinfo -v > > vmstat -P > > > -Original Message- > How do I find hardware info on Tru64 machine? > > Available RAM, number of CPUs...? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > 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 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 > also send the HELP command for other information (like subscribing). > > -- 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 - 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 also send the HELP command for other information (like subscribing).
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
Oh, really? I'm not beginner... Anyway, thanks... Solution was weird... When I deleted /var/log/cron file, then touched /var/log/cron and then started cron - everything went back to normal. Why the f&(#$^%* it wasn't working, I don't understabd... /var/log/cron was small (~30k), "df -k /var/log" gave me about 1 Gig of free space... Yet, cron was not working... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 04, 2003 13:23 > $ps xea | grep crond > > Will show you if the cron process is running or not > > -rje > > > VB> Hello to everyone... > > VB> Red Hat 6.2 > > VB> How do I find out what is wrong with cron? From January 15th until today > VB> cron is not working... My (oracle's) crontab file HAS not changed... > > VB> So I went to the /var/log/cron file. Last activity was on January 15th. > VB> Since then no activity has been recorderd. > > VB> If I issue "crontab " and afterwards "crontab -l", there > VB> are lines > > VB> oracle (02/04-11:37:14-7686) REPLACE (oracle) > VB> oracle (02/04-11:37:17-7690) LIST (oracle) > > VB> My job was scheduled on 11:40, however job wasn't executed. > > VB> How do I see whether cron is running or not? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Robert Eskridge > 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 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 > also send the HELP command for other information (like subscribing). > > -- 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 - 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 also send the HELP command for other information (like subscribing).
OT: Cron not working
Hello to everyone... Red Hat 6.2 How do I find out what is wrong with cron? From January 15th until today cron is not working... My (oracle's) crontab file HAS not changed... So I went to the /var/log/cron file. Last activity was on January 15th. Since then no activity has been recorderd. If I issue "crontab " and afterwards "crontab -l", there are lines oracle (02/04-11:37:14-7686) REPLACE (oracle) oracle (02/04-11:37:17-7690) LIST (oracle) My job was scheduled on 11:40, however job wasn't executed. How do I see whether cron is running or not? Thanks -- 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 - 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 also send the HELP command for other information (like subscribing).
RMAN, recatalog backup set
Hi! RMAN 8.1.7, nocatalog option I have two backup sets, placed on disk. Those backup sets contain archived logs. How do I register those sets (and arch. logs they contain) in new controlfile? "New controlfile" is created by "alter database backup controlfile to trace" 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 from V$ARCHIVED_LOG. So, is it possible?
HP OmniB. + RMAN 8i
Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do backup of archived logs. Database itself is backed up to tapes after mirror split, and that is not the problem. Now it is time to do integration mentioned above... Any advices and experiences, scripts? Thanks, Vladimir Barac
Re: how many records will be keep in v$log_history?
MAXLOGHISTORY integer Specify the maximum number of archived redo log files for automatic media recovery with Oracle Parallel Server. Oracle uses this value to determine how much space in the control file to allocate for the names of archived redo log files. The minimum value is 0. The default value is a multiple of the MAXINSTANCES value and depends on your operating system. The maximum value is limited only by the maximum size of the control file. -- Note: This parameter is useful only if you are using Oracle with the Parallel Server option in parallel mode, and archivelog mode enabled. -- - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 11:43 > while creating the instance, parameter MAXLOGHISTORY specifies this... > my guess is that you have to recreate the controlfiles > > > -- > > From: Jim[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Tuesday, December 17, 2002 4:38 PM > > To: Multiple recipients of list ORACLE-L > > Subject: how many records will be keep in v$log_history? > > > > how to modify the default vaule for v$log_history? > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jim > > 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 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 > > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > 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 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 > 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-- 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 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 also send the HELP command for other information (like subscribing).
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) parameters are same within script (env.variable) and database. But, instead of those specific letters I receive mail with useless content. I have then tried binary ftp of ASCII file, but to no avail. I'm entering and reading those characters trough Forms with no problem at all. So, is it possible to write CE characters (DOS extended character set actually) into ascii file? Regional settings at Windows client (where mail or ftp are received) are appropriate (meaning, they are not set as USA...)...
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 / hot backup
Do backup controlfile before step #1 and make
sure that it is swept up by Omniback during step #6.
There is no need for step #2.
Don't forget that step #6 also has to back up
archivelogs as well as datafiles and the controlfile backup.
---
Better yet, do use 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
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
mode,
5. alter system switch
logfile,
6. let the Omni Back do it's
job.
Anu do's and don't's regarding
EMC/Oracle combination?
Re: ECM / BCV / hot backup
What do you mean by
make sure that it is swept up by Omniback during
step #6.
?
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 05, 2002
14:48
Subject: Re: ECM / BCV / hot backup
Do backup controlfile before step #1 and make
sure that it is swept up by Omniback during step #6.
There is no need for step #2.
Don't forget that step #6 also has to back up
archivelogs as well as datafiles and the controlfile backup.
---
Better yet, do use 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
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
mode,
5. alter system switch
logfile,
6. let the Omni Back do it's
job.
Anu do's and don't's regarding
EMC/Oracle combination?
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 mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
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
Good day to everyone * After installing 8.1.7 on Suse 7.1 there is glibc patch from technet that has to be applied... No problems here... But, after applying 8.1.7.4 patch do I have to run glibc patch once again? * Does Suse 7.1 (and it's utilities tar, gzip...) together with ext3 file system support files over 2GB in size? Thanks, Vladimir Barac
Re: Anybody There?
Pa napisi adresu ondfa na koju da posaljem! :) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 18:38 > I haven't recieved anything from this list since friday evening. I know > there usually isn't as much traffic on the weekend, but there is some. And > there has been nothing at all this morning either. > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ball, Terry > 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 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 > 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-- 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 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 also send the HELP command for other information (like subscribing).
Re: Anybody There?
Previous mail, sent by me, was a mistake... Should have replied to someone else... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 18:38 > I haven't recieved anything from this list since friday evening. I know > there usually isn't as much traffic on the weekend, but there is some. And > there has been nothing at all this morning either. > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ball, Terry > 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 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 > 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-- 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 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 also send the HELP command for other information (like subscribing).
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 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 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 also send the HELP command for other information (like subscribing).
Drop snapshot & ORA-03113
Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - 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 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 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 also send the HELP command for other information (like subscribing).
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 FALSE location=/export/home/oracle/app/oracle/admin/p815/arch mandatorylog_archive_dest_2 TRUE location=/oralog_g mandatorylog_archive_dest_3 TRUElog_archive_dest_4 TRUElog_archive_dest_5 TRUElog_archive_dest_state_1 TRUE enablelog_archive_dest_state_2 TRUE enablelog_archive_dest_state_3 TRUE enablelog_archive_dest_state_4 TRUE enablelog_archive_dest_state_5 TRUE enablelog_archive_max_processes TRUE 1log_archive_min_succeed_dest TRUE 2log_archive_trace TRUE 0 But archived logs keep popping up in dest_1 but not in the dest_2? dest_2 is NFS directory. Why is it so?
Response file - example needed
Linux Oracle 8.1.7.2 EE I have to upgrade oracle version to 8.1.7.4, but there is huge problem (for me, at least)... X software is completely removed from linux box. Why is it so, is completely out of scope of this mail... So, I need some basic response file (or complete one, if possible). I 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, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
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 oracle. NFS uses UDP protocol, which is stateless (or it was stateless when I learnt about it). Is there any way to make NFS to use TCP protocol? Sun Solaris, Oracle 8i EE. Remote file systemis on Linux.
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 empty (trunace is essentially delete). So, is this bug or feature? What is logic behind it, if it is feature?
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: Vladimir Barac 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 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 also send the HELP command for other information (like subscribing).
ORA-00904 revisited, found something
After doing some tracing alter system set events '904 trace name errorstack forever'; on database which is being exported (8.1.7.0) with exp8.1.7.2, trace file said to me that there is problem with SYS.EXU8JBQ... Then, I have compared catexp.sql from both versions and found... gues what? Views EXU8BJQ are pretty different on 8.1.7.0 and 8.1.7.2 !!! Isn't that weird? After database versions difference is at fourth digit!!! So, is it safe to run catexp from 8.1.7.2 on 8.1.7.0? Here is part of catexp 8.1.7.2 REM REM Job Queues REM CREATE OR REPLACE VIEW exu8jbq (job, ownerid, owner, lowner, cowner, next_date, flag, interval#, what, nlsenv, env, instance) AS SELECT j$.job, u$.user#, j$.powner, j$.lowner, j$.cowner, to_char(j$.next_date, '-MM-DD:HH24:MI:SS'), decode(j$.flag,1,'TRUE',0,'FALSE'), replace(j$.interval#,'''',''''''), replace(j$.what,'''',''''''), replace(j$.nlsenv,'''',''''''), j$.env, j$.field1 FROM sys.job$ j$, sys.user$ u$ WHERE j$.powner = u$.name Here is catexp from 8.1.7.0 REM REM Job Queues REM CREATE OR REPLACE view exu8jbq (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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
Re: ORA-00904 invalid column name and export
Title: RE: ORA-00904 invalid column name and export 1. No enough space for exports... 2. All exports are on some large drive (linux box) from where exports go to the tape... 3. No f&!$^% decent shell scripting available on NT... - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 16, 2002 3:13 PM Subject: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -Original Message- 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 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-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 -- 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 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 also send the HELP command for other information (like subscribing).
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 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-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 -- 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 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 also send the HELP command for other information (like subscribing).
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.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 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 also send the HELP command for other information (like subscribing).
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 recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 4:53 PM > not even close > > read the docs... all that running catrep does is load the stored > procedures you will need to use. > > You need to decide on > > multi-master vs materialized view replication > if materialized view: >read-only, updateable, writeable > > synchronous or asynchronous > > and that's just to determine which kind of replication you want to be > running. Then you actually have to implement it. > > Rachel > > --- Vladimir Barac - posao <[EMAIL PROTECTED]> wrote: > > 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? > > > > > > > > > __ > 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: Rachel Carmichael > 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 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 > also send the HELP command for other information (like subscribing). > -- 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-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
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
Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1 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 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 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 also send the HELP command for other information (like subscribing).
Locked rows - finding out
Hello listers By quering V$LOCK or V$LOCKED_OBJECT I may find which tables are locked. How do I see rowids of rows that are locked? And how do I see into what rollback segment is being used by transaction that placed locks on those rows? -- 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-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
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 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 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 also send the HELP command for other information (like subscribing).
Unix related - need some info
Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by "ps", but what aditional parameters I have to provide? At a first glance, output of "man ps" vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... 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-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
Replication - Oracle 9i - problem
During install of Oracle9i EE software, I have checked "replication" option. Afterwards, when I run "Database Configuration Assistant" there is no check box related to replication??? When I run "Oracle Installer" after the install, it confirms that replication 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-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
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, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
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 65 instead of 64 blocks.Why is this happening?Regards
OT: X Win client
Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac
OT: Sybase
Question for dual - dbms dba people. Beside Oracle, I have some Sybase stuff to do. And I'm sure that there are some of you that do know something about Sybase. Do you have any documents that deal with: - tricks'n'tips - do's and dont's - introductions - backups - 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
ITL, DELAYED BLOCK CLEANOUT
Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT?Thanks
