RE: freebie. Summarize Oracle Listener logs

get to it when I get home. if somebody optimizes it, cleans it up,finds a flaw..., let me know so I can update it. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: freebie. Summarize Oracle Listener logs

Sorry - meant to send just to Steve Please ignore -Original Message- Hallas, John, Tech Dev Sent: 05 January 2004 11:19 To: Multiple recipients of list ORACLE-L Steve, I have an awk script which does something similar - see code and example below However I can put your file on my

RE: Code Conversion from MSSQL into Oracle

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

RE: shareplex: datatype unsupported

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services

RE: A quick note

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

RE: how to check 32 or 64 bit?

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

RE: translate, replace...?

') 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: Hallas, John, Tech Dev

RE: translate, replace...?

of list ORACLE-L Looks like you've got one too many REPLACEs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Wednesday, September 17, 2003 11:00 AM To: Multiple recipients of list ORACLE-L IA, The following code should be close to what you want

RE: How can I measure my DB performance.

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

RE: get sid (session id) and serial#?

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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 on Win2000

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

RE: Some posts not showing up

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

RE: Permissions error

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

RE: Permissions error

: Permission denied Did some permissions get corrupted. I am able to connect using sqlplus from my oracle account. This happens when I try to connect from a different account. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET

RE: get sid (session id) and serial#?

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Congratulations Arup (DBA of the Year)

, 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED

RE: number of active members in this list

: 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network

RE: speeding up conventional path sqlldr

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

RE: SharePlex

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

RE: SharePlex

the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: sar

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: Hallas

RE: 8.1.7.4 interim patch management strategy

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

RE: Extproc setup Q?

) ) ) TIA Jack van Zanen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: faq broke? -- Other options

, 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED

RE: rman legato 32 vs 64 bit conflict.

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

RE: any script to parse alert log ?!

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat

RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues

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

RE: dbms_stats via dbms_job - syntax question

parameters, or not. It seems like you need naming. I used CHR(39) to get quotes around schema name. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Tuesday, June 10, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Listers, Looking for a bit

RE: Deleting Statspack tables.

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: dbms_stats via dbms_job - syntax question SOLVED

, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Tuesday, June 10, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Listers, Looking for a bit of help with the syntax to submit a dbms_stats run via dbms_jobs The following syntax works fine to run

RE: Re: Rule Based Optimizer

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

RE: Urgent: Need Oradim.exe for version 8.1.6

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

dbms_stats via dbms_job - syntax question

',10,FALSE,'CASCADE=TRUE'); but that fails to run Has anybody got any ideas. I seem to recall Connor McDonald having some information about this on his web site but it doesn't appaer to exist any more John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas

RE: 9.2.0.3 online index builds resolved (we hope)

r the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Hallas, John, Tech Dev (B INET: [EMAIL PROTECTED] (B (BFat City Networ

RE: Function Based Index - Not Used ???

: 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network

RE: alter table add

or procedure .It can't find that column . is it a bug ? 8.1.6. hp-ux -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Anyone whom could explain this?

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

RE: certifications was Re: Remote DBA

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

RE: Oracle Job Task Analysis

: 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network

RE: Backup Strategy

: 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network

RE: Backup Strategy

: Hallas, John, Tech Dev 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: Is Anybody Out There - Pink Floyd

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

RE: Re: OCP

-- Author: Hallas, John, Tech Dev 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: Convertion from Figures to Words

Title: RE: Convertion from Figures to Words I can get the following to work with a date format but I cannot see how to do it with just plain numbers. If nobody else comes up with an answer then I suppose you could use DECODE or populate a reference table with each number and it's alphabetic

RE: Archiving Data Strategies.

Title: RE: Archiving Data Strategies. As you say Ian partitioning is a obvious answer as I imagine the billing data will be quite easy to range partition using dates. However why go to 9i, 8i has many partitioning options and it may be an easier upgrade as well as a leap that management

RE: Make first character Versal

Title: RE: Make first character Versal The following sql gives the first character of a column. I am sorry but I don't know what you mean by VERSAL select substr(version,1,1) from database_control John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 27

RE: Concatenating formated number and date doesn't work

Title: RE: Concatenating formated number and date doesn't work Well spotted Catherine. I got it working by wrapping an LTRIM round the TO_CHAR(12345,'099') line John -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 08:18 To:

RE: Cronjob misbehaving

Title: RE: Cronjob misbehaving It looks as if your ORACLE_HOME is not being set up. Try either or both of the following 1) Amend your cron job to look like the following (I assume you are running this as user oracle) 0 5 * * * su - oracle 'usr/scripts/recompile.sh'

RE: Oracle Certification Upgrade 8 to 8i

Title: RE: Oracle Certification Upgrade 8 to 8i Manoj I am in the same situation and looking at the IZO-020 exam as well. It is 8 that is due to retire , IZO-020 is an 8i exam. You have plenty of time to take the exam. John -Original Message- From: Manoj Jain [mailto:[EMAIL

RE: More info on sql query running slow

Title: RE: More info on sql query running slow The query in itself seems quite well optimised in my opinion, although 30 seconds does seem quite long relative to what is possible. What I do not understand is why the query uses the PCON_CMPY_FK index on the PHY_CONTRACTS table when that

RE: cannot create bitmap index feature not enabled

Title: RE: cannot create bitmap index feature not enabled Try granting the query_rewrite and query_rewrite_enabled (check spelling first) privileges to the user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March 2002 14:28 To: Multiple recipients of

RE: cannot create bitmap index feature not enabled

Title: RE: cannot create bitmap index feature not enabled Forget my previous reply regarding query_rewrite privileges - I misread it as a FBI question not a BMI one - enough of these TLA BFN! John -Original Message- From: Joe Raube [mailto:[EMAIL PROTECTED]] Sent: 20 March

RE: Identification of tables NOT being used in the System.

Title: RE: Identification of tables NOT being used in the System. There was a note previously on a similar theme which I have posted below. The dba_tab_modifications does not show when a table has been selected from which could be a problem for reference data type table which can easily be

RE: Free scripts

Title: RE: Free scripts I use Tim Onion's site which has a comprehensive listing of basic DBA scripts and there is also a zip file to download the lot in one go. www.timonions.com John -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 22:54

RE: Poll Questions

Title: RE: Poll Questions I agree the work involved in creating a representative subset of data , complete with full RI in place can be quite significant. I know there are tools in place that do some of the work (Checkmate by BitybyBit and Quest have one - data factory I think) but these

RE: RE: Time for a reorg?

Title: RE: RE: Time for a reorg? Thanks Dick, I think what you are saying ties in exactly with my post on the matter John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 13:53 To: Multiple recipients of list ORACLE-L Subject: Re:RE: Time

RE: Time for a reorg?

Title: RE: Time for a reorg? Having a sulk Mark? :-) There may be a number of factors involved here 1) Database well designed and managed and reorganisation does not become a problem 2) Regular use of alter table move and rebuild index reduces/removes the need to reorg 3) LMT and well

RE: Anyone use V$SESSION_LONGOPS ???

Title: RE: Anyone use V$SESSION_LONGOPS ??? There have been a few posts today which are repeat posts from a few days ago -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:53 To: Multiple recipients of list ORACLE-L Subject: RE: Anyone use

RE: local partition index question

Title: RE: local partition index question This subject nicely raises an question(s) I have. We have some tables complete with PK and FK's referencing them. We have now added a create_timestamp column to the tables and wish to partition the tables using the range (create_timestamp). No

RE: problem in creating control file?

Are you sure the sid is set to the new sid (TEST2) and also add a SET command in the first line CREATE CONTROLFILE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG HTH John -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 11:48To:

RE: Number / 0

Title: RE: Number / 0 Sinardy You are trying to create a function based index. To do so you need the query rewrite privilege The index will still fail with a divide by 0 error (don't know why you are dividing by zero) AS USER create index wrong_logic on john(income/0) * ERROR at line

RE: vxfs File System full - it's not, and it's not Oracle (I don'

Title: RE: vxfs File System full - it's not, and it's not Oracle (I don't think) David, Why does the SA say it is an Oracle issue? The error message shown refers to a LV that is full (allegedly) that happens to contain some files owned by the oracle user. Sorry if I am being a bit dense but

RE: Function based indexes

Sergey, I did a quick test which indicates that no special path is mentioned when using a FBI, instead the execution plan will show that an index is being used, which it would not do if a FBI had not been set up. The example below shows what I mean HTH John SQL create index

RE: Pinning Packages in the Shared Pool??

Title: RE: Pinning Packages in the Shared Pool?? John, I understand this still to be true or at least I have never heard anything to oppose it. Looking at the latest book I have purchased (101 Performance Tuning) the authors do talk about the principle and state many database administrators

RE: SQL Loader:How to load data with carriage return embedded

Arul, Interesting problem. We had a similar situation and used AWK instead after a bit of head-scratching. The following code worked for us BEGIN{ FS="`" first=0 } { if (substr($1,1,3)=="KB0"){ -- to identify each new record which starts with those letters

RE: ORA-27072

Have a word with your sysadmin. See if I can find out what/who is using that file Are all datafiles/control files and redo log etc owned by the same user (Oracle) and with the same permissions Seems odd that it appears to be random across a number of files HTH John -Original

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Subject: Woopeee

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql

RE: 8i and Veritas NetBackup

Title: RE: 8i and Veritas NetBackup The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John Hi, In order for RMAN to work with a third party backup product the third party vendor writes an interface to an Oracle supplied API and

RE: OPS DBA work (was dumb question)

Title: Message Bjorn, I don't have any issues with what you say - in fact it really agrees mostly with what I stated. You have added 2 important factors though, better application knowledge and use of raw file systems. I use Compaq Tru64 so that does not require raw files systems but

OPS DBA work (was dumb question)

Title: Message Shreeni, The mangement of a OPS system does not require any extra skills or facilities. Areas that are different or need more attention from a standalone instance include the following : Management and tuning of internode communication. Specifically reducing the level of

RE: How to find out what caused job to fail?

Title: How to find out what caused job to fail? How bizarre. Roland asked a question about where does he find alert log trace files (answer = select name,value from v$parameter where name like '%dest%') or check your init.ora file at least 10 minutes before this message came to me. I

RE: Rman again. Long screen output removed

Title: RE: Rman again. Long screen output removed Jack, Your date format is set until time 'to_date(''29012002094700'',''ddmmhh24miss'')'; whereas one that works for me and matches the documentation is set until time to_date('18-SEP-2001 01:00:00','dd-mon- HH24:MI:SS'); Note

RE: Web site of messages

Title: RE: Web site of messages I also found this site by searching Google for Oracle-L http://faqchest.dynhost.com/prgm/oracle-l/ -Original Message- From: Marin Dimitrov [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 08:00 To: Multiple recipients of list ORACLE-L Subject: Re: Web

Alter system check datafiles

Title: Alter system check datafiles Paul Sherman wrote 'I tried an 'alter system check datafiles' I had never come across that command before and looked at the documentation which states that 'in a distributed database system, such as an Oracle Parallel Server environment, updates an

RE: RTFM questions (formally RE: PL/SQL)

Title: RE: RTFM questions (formally RE: PL/SQL) Kevin, I am afraid your post shows a distinct lack of ambition. :-) No flames please John -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 08:50 To: Multiple recipients of list ORACLE-L Subject:

RE: Rman again. Long screen output removed/SOLVED

/SOLVED Hi All, It was an Oraclebug. The only , very workable, workaround Oracle could come up with is to set NLS_DATE_FORMAT at Unix level and use : set time until 'string'; (STRING BEING IN THE FORMAT OF NLS-DATE_FORMAT AT UNIX LEVEL) 9.0.2 is supposedly fixed. Jack Hallas John

RE: Query

Title: RE: Query Short for machine John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 12:50 To: Multiple recipients of list ORACLE-L Subject: RE: Query What is: m/c ??? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED]

RE: COPY vs. OCOPY on NT

Title: RE: COPY vs. OCOPY on NT Try http://www.speakeasy.org/~jwilton/oracle/hot-backup.html for a view on this John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 09:20 To: Multiple recipients of list ORACLE-L Subject: RE: COPY vs.

RE: RMAN and ORA 8.1.7 on NT/W2K

Title: RE: RMAN and ORA 8.1.7 on NT/W2K Allen, I am sure you can continue in the same manner as before if you wish. I am no NT expert but we are using hot backups on a variety of Unix and NT servers using 8.1.7. We also have some RMAN backups as well. Carry on with the hot backups and then

RE: Unix script

Title: RE: Unix script Basis of a script added into yours below. Note I am only checking to see if there is a PMON proces up - maybe best to make a sqlplus connection and read v$instance or something and exit if it fails. Really very poor but will give you something to work on. What I

RE: auditing tables

Title: RE: auditing tables Auditing is a definite overhead but the degree varies depending on what auditing is set up and how many transactions you have. Auditing can tell you who did what to a table (IUD etc). What it will not do is store before and after values. If that is what you want

RE: More Rman q's

Title: RE: More Rman q's Jack, TEST3 instance should be exactly as you stated, an Oracle instance with no datafiles as yet. What I think I was meaning regarding the names of the objects is that the format is Rman catalogue = catalogue Source database = target new database = auxilliary.

RE: Sqlloader

Title: RE: Sqlloader See the following note sent on 4/12/01 - it should assist John Try the following example: TMD=`date '+%Y/%m/%d'` TMS=`date '+%Y%m%d%H%M%S'` sqlplus -s internal whisky set verif off pages 0 echo off feed off term off lines 200 spool

RE: Re: How can I tell if a procedure/package is running?

Title: RE: Re: How can I tell if a procedure/package is running? Sinardy, This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well. There was a thread around 30/10/01 with the appropriate title 'How can I tell if

RE: pinning objects

Title: RE: pinning objects I wrote a database tuning document a while ago and the notes below are from the section on pinning. I do recall that the final comment re the difference betwen pinning and keeping was from a Steve Adams response to a question on this list. The library cache forms

RE: login/exit problems

Title: RE: login/exit problems There was a problem with Oracle Trace being set in some V7 instances. A couple of files grew quite large. STOP PRESS just checked on Metalink and found note 45482.1 This suggest checking the $ORACLE_HOME/otrace/admin directory for a file process.dat and see if

RE: Becoming a DBA questions

Title: RE: Becoming a DBA questions Mark, Why do you sound so suprised Mark? £120 / hour - wouldn't get out of bed for that. As Lee says he is either very lucky, specialised or both. Wherever the job is in the UK I will undercut by £10/hour :-) John -Original Message- From:

RE: Problem Granting Roles

Title: RE: Problem Granting Roles What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created. get the user to select from the full table name sys.x and see what happens. -Original Message-

RE: XP Professional 9i

Title: RE: XP Professional 9i I think it is our problem actually because the majority of questions you ask could be answered quite easily by looking at the manual or using Metalink. Is your company just a one or 2 man band or is it a reasonably sized company. If so I would have thought that

RE: Exp / Imp Utility Questions

Title: RE: Exp / Imp Utility Questions 1) You cannot have read the docs to well not to know the answer to Q1 Hint - look at the ignore parameter to imp 2) It all depends if the triggers have been run once to change the data that is now in the conversion db. You may have a trigger that adds 1

RE: unused blocks BELOW HWM - Thanks

Title: RE: unused blocks BELOW HWM - Thanks I agree with your reasoning Dennis. I have long felt that one of the problems with the list is that the original raiser of the question should have some sort of responsibility for summarising the various responses and posting a short summarised

RE: Deinstalling JServer

Title: RE: Deinstalling JServer Cherie - see the post below from sunilshivappa - 12/11/01 John +++ rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then

RE: Anybody have an opinion on!

Title: RE: Anybody have an opinion on! Dick, Your boss wasn't having a dig at you was he :-) John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 13:00 To: Multiple recipients of list ORACLE-L Subject: Anybody have an opinion on! Folks,

Serial# changes when rolling back

Title: Serial# changes when rolling back Jared,Deepak I did not see a reply on this. From a brief experiment I don't see the serial# changing when rolling back a transaction. The code posted by Jared certainly works as the number of blocks to rollback reduces as the job nears completion. If

RE: The Oracle List Archive?

Title: The Oracle List Archive? Hi Eva, Try the following link to access the archives. http://www.fatcity.com/ListGuru/login.php I can't remember where you get the password from (I think it might be blank) - it validates on your e-mail address I believe John -Original

RE: nomount

Title: RE: nomount Is this some sort of OCP test for us listers?? -Original Message- From: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 12:20 To: Multiple recipients of list ORACLE-L Subject: nomount Hi Anyone now which 2 V$ views can be accessed while in

RE: tablespace in backup mode

Title: RE: tablespace in backup mode Charlie Select status from V$backup. If status = 'ACTIVE' then tablespace in hot backup mode HTH John -Original Message- From: Charlie Mengler [mailto:[EMAIL PROTECTED]] Sent: 10 December 2001 14:26 To: Multiple recipients of list ORACLE-L

RE: LUHN formula

Title: RE: LUHN formula LUHN? -Original Message- From: Joe LaCascio [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 18:29 To: Multiple recipients of list ORACLE-L Subject: LUHN formula Hey folks, I don't want to reinvent the wheel if I don't have to. Does anyone have a LUHN

  1   2   >