RE: patches

I think I veer towards Yechiel's view here Patrice. I am not sure I have ever heard anyone suggest applying all outstanding relevant patches to a database however much you test first. (To be honest you are not advocating that, just raising the question). Normal policy wherever I have worked is not

RE: process memory utilization

I posted a similar question recently and whilst I received some answers I never did discover an exact way of matching oracle use of memory with unix use of memory. One issue is that when oracle releases memory the unix process does not automatically do the same until the memory is required.

RE: OMF question

There is a OMF related parameter called db_create_online_log_dest_n. This defines where the online redo logs are created. The value n can vary from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log group member. HTH John -Original Message- Sent: 03 December 2002

OT: Toasters

As a bit of light relief John Carry on til the end for the SAP toaster If IBM made toasters ... They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters. If Xerox made toasters

RE: Oracle 8i Certification Will Terminate When???

Peter, I don't think a date has been announced yet. When they do state a date they give 6 months notice though John -Original Message- Sent: 04 December 2002 15:59 To: Multiple recipients of list ORACLE-L I have been looking at the Oracle web site for the termination date of Oracle 8i

RE: ora 3237

Are you using LMT for the tablespace and if so what size extents? I have had that problem when I have defaulted the LMT extent size to 64K (by accident) and I have tried to create extents at 1M HTH John -Original Message- Sent: 10 December 2002 14:14 To: Multiple recipients of list

sqllldr, long datatype and carriage returns - an ugly combinatio

Listers, I have got a number of tables with long columns in them. The text is free-format and contains carriage returns. Some long columns may be empty and others will have varying lengths of data (typical call-centre operator input scenario) there is no end of record marker that is common

RE: sqllldr, long datatype and carriage returns - an ugly combin

Thanks for that Peter and Yechiel, whilst both posts were useful I don't think they really answered my questions. I know I could replace the CR characters but that involves a vast amount of pre-processing (these are very large tables and there are hundreds of them and they are in constant use). It

RE: career questions

Good question Maria and something a lot of us on the list either do, have done or have considered. I have no intention of questioning your abilities but being the sole DBA on a site it is quite easy to be seen as a good dba because the users and your management have nothing to compare against. It

RE: Footprint of 9i

Nearly 4Gb on Solaris 2.8. Pretty much a full selection installed John -Original Message- Sent: 19 December 2002 15:00 To: Multiple recipients of list ORACLE-L On Tru64 5.1 /oracle/app/oracle/product du -sk 9.2.0 4601900 9.2.0 There are multiple DBA's here that have a hand in this,

RE: Indentifying Redundant Indexes

Cary, I assume that using stored outlines will achieve No 2 in your list. Would that not be an easier approach? If you altered the system to have CREATE_STORED_OUTLINES=true and ran for a period when all scripts are likely to be run, say a month so that all month-end processing was completed,

RE: Automatic backup on Oracle 9i -- For Jared

I have never known what lol stood for , I appreciated the general meaning by looking at the context it was used in but know I actually know. I knew that if I perservered long enough with this list long enough I would find something of interest (lol) John -Original Message- Sent: 02

RE: HELP..URGENT....NOT

Dave, Is this the one that you were looking for. I don't recall where I picked it up from but it was probably this list http://www.orakle.com/ John -Original Message- Sent: 16 January 2003 10:29 To: Multiple recipients of list ORACLE-L A while back I posted a link to a website that

RE: Moving tables from one tablespace to another tablespace

As I have found to my cost when you have a database with long columns forget about 90% of Oracle newer functionality. Sqlplus copy is the best workaround (other than exp/imp) Here is a example script set long 4000 set array 5000 copy from user/password@ to user/password@ - insert

RE: OT: Cron not working

Vladimir, I have seen 2 replies to questions today that were less than tactful, yours and one regarding awk ksh If you post a message asking for help and someone tries to help then it is bad manners to be critical of that help. I am replying to this because I also replied to your post with some

RE: Cron not working

Valdimir, Is the cron daemon running ? (ps -ef|grep for cron and you should see a line something like /usr/sbin/cron running as root.) I don't know about the output of crontab -l on Linux but what you have printed is nothing like I have seen on a standard flavour of unix. A sample crontab entry

RE: RMAN - delete obsolete?

Alex, Oracle produce a shell script to do exactly this. It is called $ORACLE_HOME/rdbms/demo/rman1.sh HTH John -Original Message- Sent: 05 February 2003 11:49 To: Multiple recipients of list ORACLE-L Hello List, I think my question is very simple... How to execute RMAN command

RE: Question on set autotrace on statistics

SET AUTOTRACE only reports on DML (select, update,insert , delete) statements. The commands you ran were DDL commands If you notice at the end you did a count of the plan_table and that reported statistics John -Original Message- Sent: 05 February 2003 15:59 To: Multiple recipients of

RE: Skipping a table on import

Craig, Assuming you don't need the tables that you don't want to import the best option is to not export the tables by using a parameter file. (This speeds up the export, reduces the size of the dmp file, saves the backup/ftp time to copy the file to the target system and saves reading through

RE: RMAN question

Helmut, This thread came up a couple of days ago The answers were to use the commands change datafilecopy delete or change backuppiece delete Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate the process from the output of report obsolete HTH John -Original

RE: Skipping a table on import

Jack, I always knew there was a limit on the size of a parfile which I had assumed was a maximum no of tables allowed. However I recently found out that it is a byte limit on the overall file parameter. (It was 8K in 7.x ) Do you not hit this limit with several thousand table names (presumably

RE: Breaking down values in a large table

Thanks Waleed, that is exactly what I wanted. And thanks to all the others who responded John -Original Message- Sent: 11 February 2003 22:54 To: Multiple recipients of list ORACLE-L I hope this helps: -- drop table test_bal ;

RE: Snapshot Too Old Error on Export !!!

Jackson, As you have discovered , the issue is that other transactions are overwriting your read consistent view of the tables. Options could include 1) Running the export at a quite time (sounds like you have tried that but with only partial suucess) 2) Taking a direct export which reduces the

Oracle white papers

Useful white papers and articles on www.nyoug.org under presentation link. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California