Re: Week - Date function!

[Vladimir Begun]

Hello!

Sesi Odury wrote:
> Given a week between (1 - 52) for a particular year can we get all the
> dates within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can get all 7 days/dates of the week.
DEFINE yr=1998
DEFINE wk=5
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
 , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
  FROM sys.dual
/
Ranges can be used in case one does not have a possibility to use FBI, for
example.
The statement below is a bit more complicated. This one does a simple
check and returns nothing in case week number is out of range.
DEFINE yr=1998
DEFINE wk=53
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
 , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
  FROM sys.dual
 WHERE TO_NUMBER(
 TO_CHAR(
   TO_DATE('3112&yr', 'DDMM')
 + DECODE(TO_CHAR(TO_DATE('3112&yr', 'DDMM'), 'IW')
 , '01', -7
   ,  0
   )
 , 'IW'
 )
   ) >= &wk
   AND &wk > 0
/
HTH[, if I did not make a mistake].
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 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: Urgent: restore from hot backup w/o archivelogs

[Babette Turner-Underwood]

Well If you don't mind possibly destroying the
database you are trying to restore, you can use:

alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1';

We had a strange failure / recovery situation and I was given
this command. The description posted in the TAR was:


"A data block SCN is ahead of the current SCN.
The ORA-600 [2662] occurs when an SCN is compared
to the dependent SCN (which is stored in a UGA variable).
If the SCN is strictly less than the dependent SCN, then we signal
the ORA-600 [2662] internal error, and print out the SCN, the dependent SCN,
and the dependent SCN block."

*** this can corrupt the database ***

I later used it in another case, where the Sys Admin had
restored the wrong version or combination of files and
used level 100 instead of 1 to do a bigger increase.
This was on a test instance and I didn't want to rebuild
if I had a way around in the meantime.

- Babette

-Original Message-
Chitale
Sent: Thursday, March 27, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L



Well,

My mind seems to have stopped working now.  Can you do an
ALTER DATABASE OPEN RESETLOGS if log switches have occurred
and some of the database files have been updated
between the first ALTER TABLESPACE  BEGIN BACKUP
and the last ALTER TABLESPACE  END BACKUP wouldn't
you get
   ORA-01194: file 1 needs more recovery to be consistent
Do you issue an ALTER DATABASE OPEN RESETLOGS without
even attempting a RECOVER DATABASE UNTIL CANCEL ?


Or does it work if  *ALL* the Tablespaces are put in BACKUP mode and the
hot backup is
provided to you without archive logs, irrespective of the number of archive
logs generated
and NOT work if the Tablespaces are in BACKUP mode sequentially ?

Hemant

At 11:14 AM 26-03-03 -0800, you wrote:
>Well thanx a lot, Rachel and Jose.
>
>At 12 midnight the mind seems to have stopped working
>
>:-)
>
>Regards
>Naveen
>
>-Original Message-
>Sent: Thursday, March 27, 2003 12:21 AM
>To: Multiple recipients of list ORACLE-L
>
>
>alter database open resetlogs;
>
>you won't be able to apply the archived logs he sends over later on
>(yes Jeremiah I know there is a way to recover through a resetlogs but
>they will be doing work against the database in the interim!)
>
>but if data loss is not a problem, that's the way to go
>
>Rachel
>--- Naveen Nahata <[EMAIL PROTECTED]> wrote:
> > I have got a set of datafiles backed up from the client but he didn't
> > send me
> > the required archive logs
> >
> > now for testing purpose we need to get the DB up at our site but the
> > archive
> > logs are not there, the client will send the same but it will take
> > time
> >
> > Is there any way to get the DB up without applying the archive logs
> >
> > DATA LOSS IS NOT A PROBLEM
> >
> > Regards
> > Naveen
> >
> >
>__
[snipped]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babette Turner-Underwood
  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: optimal set up of tablespaces on disks??

[Jared Still]

It depends:

for maximum IO on redo, with mirrored redo logs:

4 2 x 36 RAID 1 for redo

1 2 x 36 for archive logs

1 2 x 36 for executables

2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable )

If you choose not to let oracle mirror the redo logs, you could
take four of those drives and add:

1 4 x 36 RAID 10.

It really depends on your requirements.  Do you need more room
for data?  Is this OLTP, DW, Hybrid?

Anyway, this is a starting point.

You would be wise to purchase and study 'Oracle Performance Tuning 101',
available at an Amazon.com near you.

Jared



On Friday 28 March 2003 15:43, Peter R wrote:
> Hi Friends,
>
> Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX
> 5L, Would you guys suggest best way of arranging tablespaces across disks!!
> I have tablespaces like rbs,temp,tools,index,data etc.
> expecting with RAID
>
> 2 x 36.4 gb  RAID-I
> 26 x 36.4 gb RAID -I + 0
>
> Any ideas will greately appreciated.
> peter.
>
>
>
>
>
> _
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: Unable to lock file

[Charlie_Mengler]

I strongly suspect the problem involves environmental variables.
One way to test this is from your interactive session do -
env | sort -o /tmp/int.env
Within your cron script do
env | sort -o /tmp/cron.env
Next do
cd /tmp
diff int.env cron.env
Then make you cron environment match your interactive environment.


HTH & YMMV

HAND!




   
  
  "Bahar, Rivaldi  
  
  (BBASSI-CHQ)"To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  <[EMAIL PROTECTED]cc:
   
  assi.com>Subject:  RE: Unable to lock file   
  
  Sent by: 
  
  [EMAIL PROTECTED]
   
   
  
   
  
  03/28/2003 02:03 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




The error is not specific to that database.
At other time, the same error occured when starting other database.
(I shutdown some small databases for daily cold backup).
That's my question too, so far, why I'm able to start manually
at daytime. May be less number of locks ?

Thanks.


-Original Message-
Sent: Friday, March 28, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway.
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error.
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







***

Re: OEM 4

[Gaja Krishna Vaidyanatha]

John,

EM 4.0 is currently in "beta" and is available only to
customers who are part of the "beta program".

Cheers,

Gaja


--- John Weatherman <[EMAIL PROTECTED]>
wrote:
> Hi all,
> 
> Is anyone aware of when OEM 4 will be available. 
> I've been looking around
> on Metalink and can't seem to find anything about
> it.  It was used at the
> Oracle Tech Day here in Greensboro this week and the
> web interface looks to
> have been really improved.
> 
> TIA,
> 
> John P Weatherman
> Oracle Database Administrator
> Replacements, Ltd.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
> -

=


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  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: Followup to jobs not running

[Steve Perry]

You may have already got the answer, but if your job is selecting candidate
tables or schemas from "dba_tables" or dba_???, then you have to grant
select on them to system specifically. System gets the select privilege from
the role DBA and not directly.

I have a similar job that runs under a different user than sys. and I had to
grant select on dba_tables to 
grant analyze any to 

Steve


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:29 PM


> Yes.  System is the job owner/creator.
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
>
>
> -Original Message-
> Sent: Friday, March 28, 2003 2:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Privileges should be granted to the user, who created the job.
> Was it "system"?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 28, 2003 2:13 PM
>
>
> > I changed the job_queue_processes (thanks Barbara), and the jobs all
> started running, but they are not successful from within the job_queue.
> They are jobs to gather schema stats using dbs_stats and are run as the
> system user.  I can run the what of the jobs within sqlplus successfully,
> but whether I run the job manually or the job_queue runs the job, it is
> still failing.  The error I see is insuffient privileges, but I have tried
> specifically granting execute on dbms_stats to system.  Is there anything
> else I should look for?
> >
> > Terry Ball, DBA
> > Birch Telecom
> > Work: 816-300-1335
> > FAX:  816-300-1800
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > 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.net
> --
> Author: Igor Neyman
>   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: 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.net
-- 
Author: Steve Perry
  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: Oracle Grid,Streams

[Pete Sharman]

I think you're confusing something here, or maybe that's just the way the
title of your email reads.  Oracle has technology that fits in the grid
computing paradigm, and Streams is obviously part of that.  But there is no
"Oracle Grid" product that you can buy that I'm aware of.  Have you looked
at the marketing bumph at
http://otn.oracle.com/products/oracle9i/grid_computing/content.html?  That
might clarify things for you somewhat. And yes, there are customers who have
implemented Streams successfully.  

If you want more details about how Oracle fits in the grid computing space,
contact me offline and I can point you to the right contacts in Oracle.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


Hi List

What are the Pros and Cons of the above?. Has anyone in the industry
implemented the above successfully?.  Are there any pitfalls / restrictions
to using the above technology?

TIA

GovindanK
-- 
*
*YOU SHOULD TREAT OTHERS THE WAY YOU WANT TO BE TREATED - MAHATMA GANDHI*
*



__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Pete Sharman
  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: Week - Date function!

[Jared Still]

Maybe a slight improvement.  I borrowed heavily from Jonathan
Gennicks pivot table article for this.  :)

http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html

select x.d
from (
   select to_date(rownum, 'DDD') d,
   to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
   from TABLE(pivot_package.pivot(365))
) x
where x.week = &week_num
/

The package and types appear below.

This doesn't seem to know how to deal with the 53rd week in
the year.  I stayed home sick today, and just don't seem to be
motivated enough to fix that last bit.

Jared

drop package pivot_package;
drop type pivot_table;
drop type pivot_row;


CREATE OR REPLACE TYPE pivot_row AS OBJECT (
   x NUMBER
);
/

CREATE OR REPLACE TYPE pivot_table
   AS TABLE OF pivot_row;
/

CREATE OR REPLACE PACKAGE pivot_package AS
FUNCTION pivot (num_rows IN NUMBER)
   RETURN pivot_table
   PARALLEL_ENABLE PIPELINED;
END;
/

CREATE OR REPLACE PACKAGE BODY pivot_package AS
   FUNCTION pivot (num_rows IN NUMBER)
   RETURN pivot_table PARALLEL_ENABLE PIPELINED IS
 outrow pivot_row := pivot_row (0);
  BEGIN
 FOR x IN 1..num_rows LOOP
outrow.x := x;
PIPE ROW(outrow);
 END LOOP;
 RETURN;
  END;
END;
/



On Friday 28 March 2003 06:38, Stephane Faroult wrote:
> SQL> l
>   1  select x.d
>   2  from (select to_date(rownum, 'DDD') d,
>   3   to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
>   4from all_objects
>   5where rownum < 366) x
>   6* where x.week = &week_num
>
> You may have a problem with leap years, but it's basically the idea.
> Anything smarter, somebody ?
>
> >Given a week between (1 - 52) for a particular year
> >can we get all the dates within that week. Is there
> >a function to do this
> >in SQL???
> >
> >Thanks a lot.
> >
> >Regards
> >Sesi
> >--
>
> Regards,
>
> Stephane Faroult
> Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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).

optimal set up of tablespaces on disks??

[Peter R]

Hi Friends,

Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 
5L, Would you guys suggest best way of arranging tablespaces across disks!! 
I have tablespaces like rbs,temp,tools,index,data etc.
expecting with RAID

2 x 36.4 gb  RAID-I
26 x 36.4 gb RAID -I + 0
Any ideas will greately appreciated.
peter.




_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter R
 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: copying datafile nt4-w2k

[Jared Still]

Yes, the database is down while doing this.

Opening the database and creating a controlfile works,
but I really didn't expect recovery on an 8.0 database 
to work with 8i executables.

Jared

On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote:
> Presuming this is a cold backup. I recall trying it about a year or so ago
> with a hot backup and had a problem with recovery not knowing when to stop
> - it kept wanting more log files.
>
> >>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>
>
> Certainly possible.
>
> I'm currently copying 8.0 files on NT to Win2k servers with
> 8.1.7 installed.  Rebuild the controlfile, open the database
> and upgrade.  Works great.
>
> Jared
>
> On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:
> > hi all
> >
> > We are planning an upgrade from NT4 to W2K.
> > I am considering to create a new instance on another server with W2K
> > installed and copying the datafiles
> > from the server with NT4 on it.
> > Is this possible ? Or do i have to use the exp/imp strategy ?
> >
> > thanks
> >
> > vr.gr.
> > Geo Kor
> > Sr. System Engineer I&DM Db
> > RDW Voertuiginformatie en -toelating
> > Holland


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: Unable to lock file

[Nelson, Allan]

On HP you must rebuild the kernel for the change to take effect.

Allan

-Original Message-
Sent: Friday, March 28, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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).



This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received

RE: Unable to lock file

[Nelson, Allan]

You get this when another process has a lock on the file.  Are you sure your shutdown 
was clean?

Allan
-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi






This e-mail, including any attachments, may include confidential and/or proprietary 
information,
and is intended for use only by the person or entity to which it is addressed.  If the 
reader of this
e-mail is not the intended recipient, or his or her authorized agent, the reader is 
hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly 
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this message 
and delete
this e-mail immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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).



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete 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: Nelson, Allan
  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: Oracle encouraging Linux software developers

[Nelson, Allan]

They have already ported HPUX to Itanium and are offering servers with it.

Allan

-Original Message-
Sent: Thursday, March 27, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L


Patrice
Brings up an interesting issue. Last info I had, HP wasn't funding a new
generation of chips. Instead they seemed to be betting on the Intel Itanium
(along with many other vendors). Simple math says that Intel has a lot more
money to fund chip development than the Unix vendors, and each new
generation of chips requires a magnitude greater investment. Presumably they
could port HP/UX to Itanium, but I believe Sun with Solaris is the only firm
holdout against Linux. Now, the bigger question, in my mind, is what
happened to the Itanium and where does that leave vendors like HP/UX?



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, March 27, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L


Interesting... whatever happened to HP/UX?
 
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services| Services technologiques 
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO 

E-Mail: [EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L



So your interpretation would be: Oracle is not so much pushing Linux at the
expense of Microsoft, but ensuring their dominance in the emerging Linux
database market. Though of course a strong Linux market will also be a
market in which presumably Microsoft will not try to compete with Oracle,
unless Microsoft decides to port SQL Server to Linux.


> -Original Message- 
> From: DENNIS WILLIAMS [ mailto:[EMAIL PROTECTED]
 ] 
> 
> Jacques - We often don't realize that at end-user sites we look at the 
> immediate computer marketplace. Any vendor that did that 
> would be out of 
> business in a couple of years. A vendor, like Oracle, must 
> predict where the 
> the market will be in a couple of years. About two years ago 
> the META Group 
> predicted that in about 5 years most servers sold would be 
> running one of 
> three operating systems: 
> 1. Windows 
> 2. Linux 
> 3. Solaris 
>  
> As near as I can tell, they are on the mark. The other Unix 
> vendors are 
> showing signs of shifting to Linux. Obviously they won't announce that 
> directly since they need to keep selling computers today. 
>  From Oracle's point of view, they don't care who is the 
> winner, just 
> that Oracle is the leading database, and not something like MySQL. 
> ... 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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).



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete 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: Nelson, Allan
  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).

Oracle Grid,Streams

[mail2gkatteri]

Hi List

What are the Pros and Cons of the above?. Has anyone in the industry
implemented the above successfully?.  Are there any pitfalls / restrictions to using 
the above technology?

TIA

GovindanK
-- 
*
*YOU SHOULD TREAT OTHERS THE WAY YOU WANT TO BE TREATED - MAHATMA GANDHI*
*



__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Unable to lock file

[Bahar, Rivaldi (BBASSI-CHQ)]

The error is not specific to that database.
At other time, the same error occured when starting other database.
(I shutdown some small databases for daily cold backup).
That's my question too, so far, why I'm able to start manually 
at daytime. May be less number of locks ?

Thanks.


-Original Message-
Sent: Friday, March 28, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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).



This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of t

Re: OEM 4

[oracle]

Having read the article promoting OEM 4 in Oracle Magazine - which I assume is at 
least  a couple of weeks out of date by the time it arrives in the "backward" EU,   I 
naively raised a software request TAR on Metalink.

A couple of days later I got an apologetic message from Oracle Customer Services to 
the effect that the product was not yet available. 

Vapourware. A new policy from Oracle.

(I also think the new numbering scheme is a bit strange given that I was told just 
last week by our distributor for Oracle that the database, AS and Apps were supposed 
to line up in the future.)

Cheers, 

John Thomas

[EMAIL PROTECTED] wrote:
> I'll ask the Oracle person that's doing a presentation here in Phoenix
> at the AZORA meeting next week.  
> 
> Stephen 
> 
> >>> [EMAIL PROTECTED] 03/28/03 08:13AM >>>
> Hi all,
> 
> Is anyone aware of when OEM 4 will be available.  I've been looking
> around
> on Metalink and can't seem to find anything about it.  It was used at
> the
> Oracle Tech Day here in Greensboro this week and the web interface
> looks to
> have been really improved.
> 
> TIA,
> 
> John P Weatherman
> Oracle Database Administrator
> Replacements, Ltd.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> -- 
> Author: John Weatherman
>   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: Stephen Andert
>   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: 
  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: Unable to lock file

[DENNIS WILLIAMS]

Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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).



This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.

RE: Unable to lock file

[Bahar, Rivaldi (BBASSI-CHQ)]

Another question,
After change the kernel parameter (thru kmtune), to make the 
change take effect, do we need to relink the unix or just shutdown
/ reboot the machine ?

Thanks.

-Original Message-
Sent: Friday, March 28, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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).



This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list

RE: Followup to jobs not running

[Jamadagni, Rajendra]

Title: RE: Followup to jobs not running





login as sys and grant analyze any table to system.


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Ball, Terry [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 28, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Followup to jobs not running



Yes.  System is the job owner/creator.


Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800



-Original Message-
Sent: Friday, March 28, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L



Privileges should be granted to the user, who created the job.
Was it "system"?


Igor Neyman, OCP DBA
[EMAIL PROTECTED]




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:13 PM



> I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user.  I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing.  The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system.  Is there anything
else I should look for?
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> 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.net
-- 
Author: Igor Neyman
  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: 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).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Unable to lock file

[Bahar, Rivaldi (BBASSI-CHQ)]

Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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).


This e-mail, including any attachments, may include confidential and/or proprietary 
information,
and is intended for use only by the person or entity to which it is addressed.  If the 
reader of this
e-mail is not the intended recipient, or his or her authorized agent, the reader is 
hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly 
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this message 
and delete
this e-mail immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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

RE: Followup to jobs not running

[Ball, Terry]

That did not help.  It takes longer to error out, but it is still failing.  I can set 
the same jobs up for the sys user and they run without problems.  I am not sure why 
the system user is the owner of the jobs and since I am the only DBA here this 
afternoon, I will have to wait until next week to find out if there is a reason for 
not moving them to sys.

If anyone else has any ideas, I am still open to suggestions.

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800


-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 1:42 PM
To: Ball, Terry



GRANT ANALYZE ANY TO SYSTEM;




   
  
  "Ball, Terry"
  
  <[EMAIL PROTECTED]>To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED] Subject:  Followup to jobs not running 
   
   
  
   
  
  03/28/2003 11:13 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user.  I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing.  The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system.  Is there anything
else I should look for?

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
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.net
-- 
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).

RE: Followup to jobs not running

[Ball, Terry]

Yes.  System is the job owner/creator.

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800


-Original Message-
Sent: Friday, March 28, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


Privileges should be granted to the user, who created the job.
Was it "system"?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:13 PM


> I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user.  I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing.  The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system.  Is there anything
else I should look for?
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> 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.net
-- 
Author: Igor Neyman
  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: 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).

Re: import problem - newbie question

[Darrell Landrum]

LeRoy,

Even though you start your import as system, when the process starts to
import tables owned by (for example) 'appuser' it will switch to that
user.  What I'm thinking is that you should create the user in advance
of starting the import and give the user adequate tablespace quota.
I may be missing something on this and perhaps someone else will
correct if so, but this is what I would try if it were me.

Darrell


>>> [EMAIL PROTECTED] 03/28/03 11:03AM >>>
I am exporting data from production to test database.  I receive error
of 'no privledges on tablespace'.  I dropped the user from the test
box
and trying import full from the schema export I created.   Not sure
what
I am doing wrong.  I am running 8.1.7 on Unix.

imp system/* file=uwsa.dmp log=import.log full=y ignore=y

LeRoy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: LeRoy Kemnitz
  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: Darrell Landrum
  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).

SCN scheme 3

[Ehresmann, David]

List, does anybody know what this means:

SCN scheme 3

It occurs it the alert log upon startup.
thanks,

David Ehresmann  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ehresmann, David
  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: index on null column

[Darrell Landrum]

AK,
I'd still do some testing with a bitmap index on that column.
You have 1,000,000 records.  500 records have value in that column. 
That means the absolute most distinct values in that column  is 501. 
This is at least one criteria for bitmap candidacy.
What I see in testing is select * from table where A = 'some value' can
use the bitmap index.  Also I see select * from table where A is null
also uses the bitmap index.
I'm definitely not saying this as 'end all', just saying it might be
worth playing with.



Darrell Landrum
Database Administrator
Zale Corporation

>>> [EMAIL PROTECTED] 03/28/03 09:59AM >>>
It means if I do a query with where clause with A=:x its going to go
for
index .
Does oracle go to table if :x is null. It looks like it does . ???



-ak




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 6:33 PM


> AK
>Yes, it will benefit the non-null records. Just remember that the
null
> values aren't indexes.
>
>
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
>
> -Original Message-
> Sent: Thursday, March 27, 2003 5:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a table with column A. there are 100 records in table out
of
> which 500o records has not null in column A rest are null.
> if i created an index on A, will it benefit .
>
> thanks,
> ak
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: DENNIS WILLIAMS
>   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: AK
  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: Darrell Landrum
  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: Followup to jobs not running

[Igor Neyman]

Privileges should be granted to the user, who created the job.
Was it "system"?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:13 PM


> I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user.  I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing.  The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system.  Is there anything
else I should look for?
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> 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.net
-- 
Author: Igor Neyman
  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).

*Oracle DBA with 8i, OPS, and some SQL Server exp. needed-Los

[OraStaff]

Los Angeles area company (Torrance) needs an Oracle / SQL DBA to join their
IT staff.
This person will be the Oracle DBA and will be a backup for the SQL Server DBA.

*Candidates in the  Greater Los Angeles area will be given first priority.
There are no relocation expenses provided, however if a qualifed candidate
is within 4-5 hours driving distance of Torrance and willing to pay their own 
interview and relocation expenses, they will be considered.

Salary Range: $85-95K.. depends on experience.

Please do not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

*Requirements:
-BSCS degree
-Combination of 4+ years Oracle 8i and/or 9i DBA experience.
-MUST have Oracle Parallel Server (OPS) or Informatica experience.
-Solid skills in logical and physical database design database tuning,
 data backup, recovery, security processes / procedures,etc
-Knowledge/experience with SQL Server 7.0 and 2000 DBA experience is a big plus.
-Data Warehouse experience is a plus.
-U.S. citizenship or permanent residency is required.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/LA area/DBA/Bob

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the position described above- if it is not a match for your skills.
Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: OraStaff
  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: create interMedia index problem

[gmei]

Hi:

The problem has been fixed. It turned out that we have very big storage
clause for "isistore". All these Intermedia tables will be created when
InterMedia index gets created. So it would try to allocate six 1000M initial
extents. And we don't have that many empty block in RESINDEX tablespace.

begin
ctx_ddl.create_preference('isistore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE',
 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE',
 'tablespace RESINDEX  storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)');
end;

So I run the following to reduce the initial setting to 100M. After that
everything is OK.

begin
-- ctx_ddl.create_preference('isistore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE',
 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE',
 'tablespace RESINDEX  storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE',
'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)');
end;


Guang

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L

Guang,

Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform
Extents of less than 3 database blocks?  If so, that's your problem.
InterMedia indexes consist of some LOB segments and those require extents
of at least 3 database blocks - at least in 8i.

If not, I don't know.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]


  Guang Mei
  <[EMAIL PROTECTED]>To:   Multiple recipients
of list ORACLE-L
  Sent by:  <[EMAIL PROTECTED]>
  [EMAIL PROTECTED] cc:
   Subject:  create interMedia
index problem

  03/27/2003 10:53
  PM
  Please respond to
  ORACLE-L



Hi:

I have this problem on our production server and I don't know too much
about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8.

[EMAIL PROTECTED]> desc DRUGDATA;
 Name  Null?Type
 - 

 IDNOT NULL NUMBER
 DRUGREPID NOT NULL NUMBER
 FIELD NOT NULL NUMBER
 TEXT   VARCHAR2(4000)
 DRUGTERMID NUMBER
 DATATYPEIDNOT NULL NUMBER
 ADD_FILE  NOT NULL VARCHAR2(32)
 ADD_DATE  NOT NULL DATE
 DEL_FILE   VARCHAR2(32)
 DEL_DATE   DATE
 STATUSNOT NULL CHAR(1)
 ORDERBY   NOT NULL NUMBER

[EMAIL PROTECTED]> select count(*) from DRUGDATA;

  COUNT(*)
--
 0


TABLESPACE_NAME  USED-Kb ALLOC-KbUSED%  SEGS  >EXT  >NEXTEXT
 --- --- -- - - 
DATA   3,000   1,048,576 .3 1 1  504
INDEXES   10,664,424  14,680,064   72.6   48011  693,080
PERFSTAT 105,728   2,097,1525.056   150  128
PROTEOME 164,872   1,048,576   15.75219   25,600
RBS5,131,360   8,388,608   61.2 6   8002,048
RESCTX43,832   6,803,456 .66628  504
RESDATA   34,470,408  46,137,344   74.7   361  2319 
RESINDEX  41,046,376  69,206,016   59.3   300  1063  512,000
SYSTEM74,320 153,600   48.4   401   1151,120
T

Re: snapshot too old

[Jose Luis Delgado]

AK...

this happens with LONG queries too...

this means that you do not have enough rollback
segments...

or...

that they are very small...

HTH
JL

--- AK <[EMAIL PROTECTED]> wrote:
> why a select statement can give snapshot too old
> erorr .
> there is no update , yes but its a long running
> query .
> what is fix for this ?
> 
> -ak


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  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: copying datafile nt4-w2k

[Jeffrey Beckstrom]

Presuming 
this is a cold backup. I recall trying it about a year or so ago with 
a hot backup and had a problem with recovery not knowing when to stop - it kept 
wanting more log files.>>> [EMAIL PROTECTED] 3/28/03 1:43:41 
PM >>>Certainly possible.I'm currently copying 8.0 
files on NT to Win2k servers with8.1.7 installed.  Rebuild the 
controlfile, open the databaseand upgrade.  Works 
great.JaredOn Friday 28 March 2003 03:28, [EMAIL PROTECTED] 
wrote:> hi all>> We are planning an upgrade from NT4 to 
W2K.> I am considering to create a new instance on another server with 
W2K> installed and copying the datafiles> from the server with NT4 
on it.> Is this possible ? Or do i have to use the exp/imp strategy 
?>> thanks>> vr.gr.> Geo Kor> Sr. 
System Engineer I&DM Db> RDW Voertuiginformatie en -toelating> 
Holland-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jared 
Still  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Followup to jobs not running

[Ball, Terry]

I changed the job_queue_processes (thanks Barbara), and the jobs all started running, 
but they are not successful from within the job_queue.  They are jobs to gather schema 
stats using dbs_stats and are run as the system user.  I can run the what of the jobs 
within sqlplus successfully, but whether I run the job manually or the job_queue runs 
the job, it is still failing.  The error I see is insuffient privileges, but I have 
tried specifically granting execute on dbms_stats to system.  Is there anything else I 
should look for?

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).

Re: copying datafile nt4-w2k

[Jared Still]

Certainly possible.

I'm currently copying 8.0 files on NT to Win2k servers with
8.1.7 installed.  Rebuild the controlfile, open the database
and upgrade.  Works great.

Jared

On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:
> hi all
>
> We are planning an upgrade from NT4 to W2K.
> I am considering to create a new instance on another server with W2K
> installed and copying the datafiles
> from the server with NT4 on it.
> Is this possible ? Or do i have to use the exp/imp strategy ?
>
> thanks
>
> vr.gr.
> Geo Kor
> Sr. System Engineer I&DM Db
> RDW Voertuiginformatie en -toelating
> Holland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: OT: uuencode adding characters

[Chris Berry]

From: "Saira Somani" <[EMAIL PROTECTED]>
Can you give me a hint? So I use Perl to rid the file of these
characters and then uuencode it and then use mail utility to send to
people? Won't uuencode do the same thing again and add those characters
back?
I haven't used uuencode, but basically what you need to do is:
1) Generate the file
2) Run uuencode
3) Clean it up with perl script
4) Email it
If you want to send me a copy of the uuencoded file, I'd be happy to take a 
look at it.  Your perl code will look something like this:

#!perl

open INPUT_FILE, "outfile.txt";
while () {
   ®ex
}
close INPUT_FILE;
close OUTPUT_FILE;
sub regex {
}
Where the regex subroutine will contain the code which finds and eliminates 
the nasty characters you want to remove.  If you're a minimalist, you could 
probably rewrite the whole thing to be a single inline statement using perl 
-p -i -e

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 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: snapshot too old

[DENNIS WILLIAMS]

AK
Take a look at this. It explains it better than I could.
http://home.clara.net/dwotton/dba/snapshot2.htm
 
 


Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, March 28, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L


why a select statement can give snapshot too old erorr .
there is no update , yes but its a long running query .
what is fix for this ?
 
-ak

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: Configuring Oracle with RAID and OFA

[Jared Still]

We back this up daily, with an additional archive log backup.

The amount of space dedicated to redo is due to the size of
the disks, 36 gig.  Not much I can do about that.  Now that I
think of it, might be a good idea to setup so that archive logs
will go to redo disks should the archive disk fill up for some 
reason.

Not great for performance, but poor performance is always
better than none at all.  :)

Jared

On Thursday 27 March 2003 13:28, Niall Litchfield wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> > Jared Still
> > Sent: 27 March 2003 15:59
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Configuring Oracle with RAID and OFA
> >
> >
> >
> > We're installing a new SAN at this moment.
> >
> > I get to specify the disks I want.
> >
> > 4 RAID1 disks for redo
> > 1 RAID1 for archive logs
> > 1 RAID1 for executables
> > 5 RAID10's of ~100 gig each for data.
> >
> > Ahh,  life is good.  ;)
>
> How often do you backup? You seem to have 4 times the amount of space
> (and indeed number of devices) dedicated to redo that you do for
> archives? Not that I could exacty call it a bad setup you understand :(
> (whats the emoticon for rampant jealousy again)
>
> Niall
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: Oracle Jobs not restarting after upgrade

[Ball, Terry]

That was it.  Thanks.

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800


-Original Message-
Sent: Friday, March 28, 2003 12:24 PM
To: Ball, Terry


Terry:
Any chance the job_queue_processes parameter got set
to 0 on the new database??

Barb

--- "Ball, Terry" <[EMAIL PROTECTED]> wrote:
> Date: Fri, 28 Mar 2003 09:08:40 -0800
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> From: "Ball, Terry" <[EMAIL PROTECTED]>
> Subject: Oracle Jobs not restarting after upgrade
> 
> Solaris 5.8  Oracle 8.1.6 upgrade to 9.2
> 
> We are testing an upgrade of Oracle from 8.1.6 to
> 9.2.  There are several oracle jobs scheduled on
> this DB.  Before we started the upgrade, all the
> jobs were broken (execute dbms_job.broken(201,
> true).  The upgrade to 8.1.7 was done and then the
> migrate/upgrade to 9.2.0 was done.  The jobs were
> then unbroken execute dbms_job.broken(201, false). 
> But the jobs are not running.  A select shows that
> the jobs are no longer broken, but is also shows
> that the last date they ran was just before the
> upgrade, with the next_date showing as the time it
> would have been scheduled before the upgrade.  (I.e,
> if it ran on the first and was a daily job, it's
> next_date would be the second).  We have tried
> issuing a change for the next date, but all that
> does is show a new next_date, it does not make the
> jobs run.
> 
> Is there a way to make these jobs start running
> again.  I have looked in the manuals, but either I
> am missing something obvious, or am not looking in
> the right place.  Any help or suggestions are
> appreciated.  TIA.
> 
> 
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> 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).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).

snapshot too old

[AK]

why a select statement can give snapshot too old 
erorr .
there is no update , yes but its a long running 
query .
what is fix for this ?
 
-ak

RE: Oracle Jobs not restarting after upgrade

[Spears, Brian]

Check you have the init.ora parameters set up in your new DB

Brian

-Original Message-
Sent: Friday, March 28, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


dbms_job.run ?

-Original Message-
Sent: 28 March 2003 17:09
To: Multiple recipients of list ORACLE-L


Solaris 5.8  Oracle 8.1.6 upgrade to 9.2

We are testing an upgrade of Oracle from 8.1.6 to 9.2.  There are several
oracle jobs scheduled on this DB.  Before we started the upgrade, all the
jobs were broken (execute dbms_job.broken(201, true).  The upgrade to 8.1.7
was done and then the migrate/upgrade to 9.2.0 was done.  The jobs were then
unbroken execute dbms_job.broken(201, false).  But the jobs are not running.
A select shows that the jobs are no longer broken, but is also shows that
the last date they ran was just before the upgrade, with the next_date
showing as the time it would have been scheduled before the upgrade.  (I.e,
if it ran on the first and was a daily job, it's next_date would be the
second).  We have tried issuing a change for the next date, but all that
does is show a new next_date, it does not make the jobs run.

Is there a way to make these jobs start running again.  I have looked in the
manuals, but either I am missing something obvious, or am not looking in the
right place.  Any help or suggestions are appreciated.  TIA.


Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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.net
-- 
Author: Nicoll, Iain
  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: Spears, Brian
  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: may not be necessary -- was RE: Oracle DB Backups on SAN with

[Sarnowski, Chris]

We use the 'shadow mirror' process on a Hitachi SAN (with
Oracle 8.1.7 on Solaris 8 and Veritas VxFS) successfully to refresh
our development db without a suspend, or even hot backup mode.

After the hair that I didn't pull out turned gray (though
I am not willing to detail the incompetence on a semi-public
list), we got the hardware/file system set up correctly and
we have done this several times with no trouble.

One issue I had with Hitachi support was that they insisted I
had to suspend the database at the time of the split when we
were seeing data corruption that was clearly unrelated to Oracle
behavior. It turned out to be low level misconfiguration, I believe
at the Veritas file system level. I never got a satisfactory
explanation.

Here is my current (possibly inaccurate) understanding of the
process. I would be more than happy to be corrected on any of
the details.

The shadow mirror process is 'atomic' in the sense that there is
some kind of journaling so that when the mirror is split, it is
done so that the shadow is a copy of the disk at a particular
time, so it looks like the disk would look after a crash or a
shutdown abort. Oracle crash recovery has worked as advertised,
which is sufficient for our development db needs. If we do get a
bad mirror, we would be able to resync and resplit quickly. But
as I said, we've done this without incident at least 8 or 9
times. The only times we've had to resync and resplit were due
to human error.

If you are using Shadow mirror, and this is for backup purposes,
you may want the extra security of hot backup. But the mirror
split should not cause split blocks, so I'm not sure that it
would actually do much for you. To be honest, I haven't thought
through all the ramifications of using this as a backup method.

If you're not using Shadow mirror, but some other mirror method,
the above may not apply.

Hope this helps.
-Chris

> -Original Message-
> From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 27, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: may not be necessary -- was RE: Oracle DB Backups on SAN with
> 
> 
> 
> Jeremiah / Deborah,
> 
> My understanding is/was that the Snapshot creation wasn't 
> atomic -- it can 
> take "a little bit of time"
> and, therefore, it becomes necessary to suspend I/O.
> Now, I haven't had a chance yet to speak to the Sun/Hitachi 
> engineers and I 
> am going
> by what management has understood and conveyed to me -- that 
> the database must
> be "quiesced".  Hopefully, next week, I will be allowed to 
> speak to the 
> engineers before
> they set up the SAN.
> 
> Reading Oracle's documentation in the Backup and Recovery guide
> "Using the Oracle8i SUSPEND/RESUME functionality, you can 
> suspend I/O to 
> the database, then split the mirror and make a backup of the 
> split mirror. 
> This feature, which complements the hot backup functionality, 
> allows you to 
> quiesce the database so that no new I/O can be performed. You 
> can then 
> access the suspended database to make backups without I/O 
> interference.
> Note: Some RAID devices benefit from suspending writes while 
> the split 
> operation is occurring; your RAID vendor can advise you on 
> whether your 
> system would benefit from this feature.
> "
> and
> "After a successful database suspension, you can back up the 
> database to 
> disk or break the mirrors. Because suspending a database does 
> not guarantee 
> immediate termination of I/O, Oracle recommends that you precede the 
> SUSPEND statement with a BEGIN BACKUP statement to place the 
> tablespaces in 
> hot backup mode.
> 
> You must use conventional operating system backup methods to 
> back up split 
> mirrors. RMAN cannot make database backups or copies because these 
> operations require reading the datafile headers. After the 
> database backup 
> is finished or the mirrors are re-silvered, then you can 
> resume normal 
> database operations using the RESUME statement.
> 
> Backing up a suspended database without splitting mirrors can 
> cause an 
> extended database outage because the database is inaccessible 
> during this 
> time. If backups are taken by splitting mirrors, however, 
> then the outage 
> is nominal. The outage time depends on the size of cache to 
> flush, the 
> number of datafiles, and the time required to break the mirror
> "
> 
> I did get the impression that a SUSPEND was necessary.
> 
> However, I have read a Hitachi document at
> http://www.hds.com/pdf/ods.pdf
> and I think that a SUSPEND is not mandatory.
> 
> I will come back to the list when I get more information from 
> the Sun/Hitachi
> engineers and see the scripts/script-templates that they will 
> be providing.
> 
> Hemant
> 
> 


LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. 
It is intended for the addressee(s) only. Access to this e-mail by anyone else is 
unauthorized. If you are not an addressee,

Re: utl_smtp error

[Chris Berry]

From: Joan Hsieh <[EMAIL PROTECTED]>
Thanks for explantion. I asked the smtp mail admin. He said
The relays are running Exim-4.10. Is that help?
What is it you're trying to mail from the database?

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 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: Oracle Jobs not restarting after upgrade

[Nicoll, Iain]

dbms_job.run ?

-Original Message-
Sent: 28 March 2003 17:09
To: Multiple recipients of list ORACLE-L


Solaris 5.8  Oracle 8.1.6 upgrade to 9.2

We are testing an upgrade of Oracle from 8.1.6 to 9.2.  There are several
oracle jobs scheduled on this DB.  Before we started the upgrade, all the
jobs were broken (execute dbms_job.broken(201, true).  The upgrade to 8.1.7
was done and then the migrate/upgrade to 9.2.0 was done.  The jobs were then
unbroken execute dbms_job.broken(201, false).  But the jobs are not running.
A select shows that the jobs are no longer broken, but is also shows that
the last date they ran was just before the upgrade, with the next_date
showing as the time it would have been scheduled before the upgrade.  (I.e,
if it ran on the first and was a daily job, it's next_date would be the
second).  We have tried issuing a change for the next date, but all that
does is show a new next_date, it does not make the jobs run.

Is there a way to make these jobs start running again.  I have looked in the
manuals, but either I am missing something obvious, or am not looking in the
right place.  Any help or suggestions are appreciated.  TIA.


Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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.net
-- 
Author: Nicoll, Iain
  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: Oracle Jobs not restarting after upgrade

[Jamadagni, Rajendra]

Title: RE: Oracle Jobs not restarting after upgrade





Run them manually for the first time, or try dropping and recreating them.


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Ball, Terry [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 28, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Jobs not restarting after upgrade



Solaris 5.8  Oracle 8.1.6 upgrade to 9.2


We are testing an upgrade of Oracle from 8.1.6 to 9.2.  There are several oracle jobs scheduled on this DB.  Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true).  The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done.  The jobs were then unbroken execute dbms_job.broken(201, false).  But the jobs are not running.  A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade.  (I.e, if it ran on the first and was a daily job, it's next_date would be the second).  We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run.

Is there a way to make these jobs start running again.  I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place.  Any help or suggestions are appreciated.  TIA.


Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Re: oracle job

[Igor Neyman]

I don't think, that job calling stored procedure from the 
package gets invalidated (at least according to my 
experience: I was recompiling packages and didn't have anything to do with the 
jobs calling stored procedures from recompiled packages, unless call to the 
stored procedure changed, like new or different types of parameters passed to 
stored procedure).
The only issue here: make sure, that job is not running, when 
you are recompiling the package.
 
Igor Neyman, OCP DBA[EMAIL PROTECTED]  
 
 

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, March 28, 2003 11:43 
  AM
  Subject: RE: oracle job
  
  if you compile package spec, then all dependent objects will be 
  invalid, if you compile package body, then there will be no 
  invalids.
   
  Raj
  - 
  Rajendra dot Jamadagni at espn dot 
  com Any views expressed here are 
  strictly personal. QOTD: Any clod 
  can have facts, having an opinion is an art !! 
  
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:04 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
oracle job
8.1.6
 
-ak

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, March 27, 2003 3:28 
  PM
  Subject: RE: oracle job
  
  Which version "rubs" the job?
  
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 
2:29 PMTo: Multiple recipients of list 
ORACLE-LSubject: oracle job
If the package which is going to be rub by 
oracle job gets compiled , does it invalids the job also ?
 
thanks,
-ak

Oracle Jobs not restarting after upgrade

[Ball, Terry]

Solaris 5.8  Oracle 8.1.6 upgrade to 9.2

We are testing an upgrade of Oracle from 8.1.6 to 9.2.  There are several oracle jobs 
scheduled on this DB.  Before we started the upgrade, all the jobs were broken 
(execute dbms_job.broken(201, true).  The upgrade to 8.1.7 was done and then the 
migrate/upgrade to 9.2.0 was done.  The jobs were then unbroken execute 
dbms_job.broken(201, false).  But the jobs are not running.  A select shows that the 
jobs are no longer broken, but is also shows that the last date they ran was just 
before the upgrade, with the next_date showing as the time it would have been 
scheduled before the upgrade.  (I.e, if it ran on the first and was a daily job, it's 
next_date would be the second).  We have tried issuing a change for the next date, but 
all that does is show a new next_date, it does not make the jobs run.

Is there a way to make these jobs start running again.  I have looked in the manuals, 
but either I am missing something obvious, or am not looking in the right place.  Any 
help or suggestions are appreciated.  TIA.


Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).

Re: utl_smtp error

[Joan Hsieh]

Chris,

Thanks for explantion. I asked the smtp mail admin. He said
The relays are running Exim-4.10. Is that help?

Joan

Chris Berry wrote:
> 
> >From: Joan Hsieh <[EMAIL PROTECTED]>
> >Chris,
> >you got me, what MTA stand for?
> 
> Mail Transfer Agent, its the program that uses SMTP to send or recieve mail.
>   Examples:
> 
> Sendmail
> Courier
> Postfix
> Exim
> qmail
> MS Exchange
> 
> Don't confuse this with an MUA (mail user agent) which allows you to compose
> and read email without using telnet manually.  Examples:
> 
> Mutt
> Pine
> Mozilla
> Outlook
> 
> If you're getting smtp errors, perhaps your MTA is misconfigured,
> unavailable, overloaded, etc.  SMTP stands for Simple Mail Transfer
> Protocol.
> 
> Chris Berry
> [EMAIL PROTECTED]
> Systems Administrator
> JM Associates
> 
> "Without change, something sleeps inside us, and seldom awakens.  The
> sleeper must awaken." -- Duke Leto Atreides
> 
> _
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Berry
>   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: Joan Hsieh
  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).

import problem - newbie question

[LeRoy Kemnitz]

I am exporting data from production to test database.  I receive error
of 'no privledges on tablespace'.  I dropped the user from the test box
and trying import full from the schema export I created.   Not sure what
I am doing wrong.  I am running 8.1.7 on Unix.

imp system/* file=uwsa.dmp log=import.log full=y ignore=y

LeRoy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: LeRoy Kemnitz
  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: oracle job

[Jamadagni, Rajendra]

if you compile package spec, then all dependent objects will be invalid, 
if you compile package body, then there will be no invalids.
 
Raj
- 
Rajendra dot Jamadagni at espn dot 
com Any views expressed here are 
strictly personal. QOTD: Any clod can 
have facts, having an opinion is an art !! 

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  oracle job
  8.1.6
   
  -ak
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, March 27, 2003 3:28 
PM
Subject: RE: oracle job

Which version "rubs" the job?

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 
  2:29 PMTo: Multiple recipients of list 
  ORACLE-LSubject: oracle job
  If the package which is going to be rub by 
  oracle job gets compiled , does it invalids the job also ?
   
  thanks,
  -ak
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Intermedia tag "<" problem

[Luc Demanche]

Thank you Peter and Jan.

Luc
--- "Hitchman, Peter" <[EMAIL PROTECTED]>
wrote:
> Hi,
> You will have to change your input data and replace
> the "<" with "<".
> This is one of the standard 5 XML entity references.
> Really you need to make
> sure that you have no double quotes, single quotes,
> less than , greater than
> or ampersands in your data and if you do replace
> then with the appropriate
> entity reference:
> 
> & -> &
> " -> "
> ' -> '
> < -> <
> > -> >
> 
> Regards
> 
> Pete
> 
> -Original Message-
> Sent: 28 March 2003 14:34
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gurus,
> 
> We are working with Intermedia Text 8.1.6.
> We created a intermedia index on a search field.  We
> also created 2 sections in this field.
> 
> Table name : S01
> Filed name : S01_search
> Sections name : SY,MAN
> 
> Here is an example of data in this field:
> CyanePhibro Energy  *
> This example works fine.  
> 
> But we have a problem when there is a "<" character
> in
> the data. 
> 
> Intermedia thinks it's a new tag and tries to find a
> section but it cannot.
> Exemple:
> Cyane < 10 Phibro Energy  *
> 
> Question :  
> 1- Should we do something with the "<" in our data ?
> 
> TIA 
> Luc
> 
> 
> 
> =
> Luc Demanche
> [EMAIL PROTECTED]
> 
> __
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Luc Demanche
>   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).
> 
> 
>
**
> This email and any files transmitted with it are
> confidential and
> intended solely for the use of the individual or
> entity to whom they
> are addressed. If you have received this email in
> error please notify
> the system manager.
> 
> This footnote also confirms that this email message
> has been swept by
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
>
**
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Hitchman, Peter
>   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).
> 


=
Luc Demanche
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Luc Demanche
  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: Configuring Oracle with RAID and OFA

[Jesse, Rich]

I *knew* I should have explained that more.  I had some verbage that I just
deleted for the sake of simplicity.  And it sounded much more impressive by
leaving things hanging...  :)

After talking with the contractor that I worked with in setting this up, I
was wrong about our physical layout.  I was thinking it was a 6-wide
mirrored stripe for the 6GB of datafiles.  That would be silly.  It's
11-wide.  Yes.  That's 22 total disks for just the datafiles.  A full Photon
(11 drives on the front, 11 on back).  The redos and archives and their
respective mirrors are spread across another 10 on a D1000.  32 disks in
all.  Da-roo-ul, da-roo-ul.

Our hotbacks are nothing special.  We use a home-grown, partially
plagarized, simple shell/SQL script combo that serially puts each tablespace
into backup mode, copies the underlying datafiles *to another disk*, then
ends the backup.  Pretty generic stuff.  The key is that our hotbacks are
disk-to-disk.  Why disk-to-disk instead of disk-to-tape for us?

1)  Cost.  We currently use OmniBack and a custom program for tape backups
across HP/UX and Solaris, and we may be moving towards Tivoli.  OmniBack and
Tivoli charge at least 5 figures for their Oracle, and the custom tape
backup we have would have to use a script similar to the one we use for
disk-to-disk.  If we throw even 4 figures at systems for more disks, we're
still ahead of the game dollar-wise.  I won't get back into the SAN argument
for the sake of brevity.  I should add that our DBs are relatively small in
the Oracle World.  Our largest is our 28GB ERP system.

2)  Reliability.  To subvert to the Old Milwaukee commericals: Boys, it
don't get no better than this.  There's no worry about whether or not the
latest patch on the backup software will work with this version or that
version of Oracle.

3)  Simplicity.  Set TS for backup, copy files, end TS backup.  K.I.S.S.
(no, not the Gene Simmons kind)  See "Reliability".

4)  Control.  For each platform and each system, we have complete control
over how and when the hotbacks work.

5)  Potential speed of recovery.  I'd consider this a by-product advantage
of disk-to-disk rather than a selling point because for us the disks are on
the same system as the database, giving less weight to this point.

I've been writing too long on this -- need to get back to work!  Hopefully,
this will explain my previous message a little better.  :)


Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Thursday, March 27, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L


Rich,

How did you manage to take hot backups in 90 seconds for 6 GB db size?

If you could shed light on the technique, it would be helpful to us.  We
might also consider your approach, if feasible on our systems.

TIA,

Rao

-Original Message-
Sent: Thursday, March 27, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


FWIW, we've got an 8.1.7 system set up on Solaris8.  The whole whopping 6GB
of datafiles are spread across a 6-wide RAID 0+1, with redos and archives on
their own 0+1s.

Our hotbacks take 90 seconds.

OTOH, our 28GB ERP system on an HP AutoRAID 12H takes over 2.5 hours.  I'd
like to be done with that in 7 minutes, extrapolating from our other system,
not to mention the performance increase for our users (system-wide waits
average in the 100s during the day due to physical I/O, but that's a whole
other kettle of worms).

:)


Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: Which process is taking up so much CPU???

[DENNIS WILLIAMS]

Thanks Jeremiah. My bad. T early on Friday.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote:

> Fermin
>Add this line to your init.ora file.
> timed_statistics = true
>Then shutdown, startup your Oracle instance.

I would hasten to point out that this parameter can be set dynamically
using alter system from at least 8.1.x forward.  Thus, restarting the
instance is unnecessary and only reduces availability.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

> -Original Message-
> Sent: Friday, March 28, 2003 6:24 AM
> To: Multiple recipients of list ORACLE-L
> 
>   I wonder where I should set TIMED STATISTICS = TRUE, if any of you
> has the time to answer I'd be grateful, but I will look for it in the
docs.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  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: DENNIS WILLIAMS
  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: oracle job

[AK]

8.1.6
 
-ak

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, March 27, 2003 3:28 
  PM
  Subject: RE: oracle job
  
  Which version "rubs" the job?
  
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:29 
PMTo: Multiple recipients of list ORACLE-LSubject: 
oracle job
If the package which is going to be rub by 
oracle job gets compiled , does it invalids the job also ?
 
thanks,
-ak

Re: core dump for tkprof

[AK]

It's 8.1.6 db .  I ran tkprof succesfully on 
same box with same version 3 days back . But now it's geting core dump  
.
 
-ak
 

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, March 27, 2003 3:28 
  PM
  Subject: RE: core dump for tkprof
  
  remove a line that starts with APPNAME or something like that ... in 
  the very beginning of the trace file.
   
  Raj
  
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:49 
PMTo: Multiple recipients of list ORACLE-LSubject: 
core dump for tkprof
when I am trying to execute tkprof on 10046 
output file ( level 8 ) , i am getting core dump .
any idea why ?
 
thanks,
ak

RE: Unable to lock file

[DENNIS WILLIAMS]

Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  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: DENNIS WILLIAMS
  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: index on null column

[AK]

It means if I do a query with where clause with A=:x its going to go for
index .
Does oracle go to table if :x is null. It looks like it does . ???



-ak




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 6:33 PM


> AK
>Yes, it will benefit the non-null records. Just remember that the null
> values aren't indexes.
>
>
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Thursday, March 27, 2003 5:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a table with column A. there are 100 records in table out of
> which 500o records has not null in column A rest are null.
> if i created an index on A, will it benefit .
>
> thanks,
> ak
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   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: AK
  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: Intermedia tag "<" problem

[Hitchman, Peter]

Hi,
You will have to change your input data and replace the "<" with "<".
This is one of the standard 5 XML entity references. Really you need to make
sure that you have no double quotes, single quotes, less than , greater than
or ampersands in your data and if you do replace then with the appropriate
entity reference:

& -> &
" -> "
' -> '
< -> <
> -> >

Regards

Pete

-Original Message-
Sent: 28 March 2003 14:34
To: Multiple recipients of list ORACLE-L


Hi Gurus,

We are working with Intermedia Text 8.1.6.
We created a intermedia index on a search field.  We
also created 2 sections in this field.

Table name : S01
Filed name : S01_search
Sections name : SY,MAN

Here is an example of data in this field:
CyanePhibro Energy  *
This example works fine.  

But we have a problem when there is a "<" character in
the data. 

Intermedia thinks it's a new tag and tries to find a
section but it cannot.
Exemple:
Cyane < 10 Phibro Energy  *

Question :  
1- Should we do something with the "<" in our data ?

TIA 
Luc



=
Luc Demanche
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Luc Demanche
  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).


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hitchman, Peter
  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).

OEM 4

[John Weatherman]

Hi all,

Is anyone aware of when OEM 4 will be available.  I've been looking around
on Metalink and can't seem to find anything about it.  It was used at the
Oracle Tech Day here in Greensboro this week and the web interface looks to
have been really improved.

TIA,

John P Weatherman
Oracle Database Administrator
Replacements, Ltd.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Weatherman
  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: veritas backup via RMAN troubles

[Ed Bittel]

Title:  veritas backup via RMAN troubles









I had a remarkably similar experience a
few months ago with Legato NetWorker and performed all of the steps you listed
with the same results.  The problem turned out to be very simple. 
The SA installed the 64-bit version of the Legato Networker client because it
is a 64-bit server.  However, we were running a 32-bit version of Oracle
on it.   Installing the 32-bit client solved the problem.  

 

I am mentioning this since your post did
not indicate if you are using 64-bit Oracle on that server. 

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Testa,
Joe
Sent: Wednesday,
 March 26, 2003 1:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: veritas backup via RMAN
troubles

 

 

AIX 5.1, oracle 9ir2(9.2.0.1),   veritas
4.5 

followed instructions for installing veritas on disk,
got the agent, did NOT relink oracle executable, but ran the oracle install
script so the link from /usr/openv/netbackup/bin/libobk.a64 is linked to
$ORACLE_HOME/lib/libobk.a

Set(and unset multiple times), LIBPATH,
LD_LIBRARY_PATH. 

Continue to get ORA-27211 Failed to load media
management library. 

Been thru RMAN chapters multiple times, I'm totally
out of ideas(and read every damn document on metalstink about this error).

I've also tried to use the dummy MML library and that
works fine. 

What the heck am I doing wrong? 

thanks, joe 

RE: Which process is taking up so much CPU???

[K Gopalakrishnan]

ALTER SYSTEM SET TIMED_STATISTICS=TRUE;

You don't need to bounce the database ;)

Best Regards,
K Gopalakrishnan




-Original Message-
WILLIAMS
Sent: Friday, March 28, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L


Fermin
   Add this line to your init.ora file.
timed_statistics = true
   Then shutdown, startup your Oracle instance.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 28, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L



Thank you all for your help.

I wonder where I should set TIMED STATISTICS = TRUE, if any of you
has the time to answer I'd be grateful, but I will look for it in the docs.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
  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: DENNIS WILLIAMS
  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: Fermin Bernaus Berraondo
  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: DENNIS WILLIAMS
  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: K Gopalakrishnan
  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 i

RE: big disks..OFA??

[DENNIS WILLIAMS]

Peter
   Welcome to the modern DBA's challenge. 
- Consider RAID
- Pay attention to your cache size (battery-backed, of course)
- Test
- Eternally the System administrator would prefer you to use fewer devices,
makes his/her life easier. The DBA wants many devices. Negotiate. Share.
- What performance is required of this database? As was discussed yesterday
on this list, a lower-performance database will be okay on a single device.
Put control files, redo on separate devices. If really good performance /
high transaction rates are required, then lobby for more devices.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L


Hi Friends


Now a days the disks are coming with 36/73Gb sizes for AIX, How can I make 
small filesystems to put data and indexes separately?? Although I have 
FastT700 controller, Is it okay putting all dbf files under one filesytem?? 
Does it affect performance, How about putting rbs/temp/redo?? Do I need to 
put under different filesystems?? Suppose I have two controller, How can I 
know, How many channels are there??

I have 25Gb table, what is the methodology for setting initial and next
extents?? My DB is OLTP its conitousely growing on AIX 5L with Oracle 817.


TIA
peter.





_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter R
  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: DENNIS WILLIAMS
  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: Which process is taking up so much CPU???

[Jeremiah Wilton]

On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote:

> Fermin
>Add this line to your init.ora file.
> timed_statistics = true
>Then shutdown, startup your Oracle instance.

I would hasten to point out that this parameter can be set dynamically
using alter system from at least 8.1.x forward.  Thus, restarting the
instance is unnecessary and only reduces availability.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

> -Original Message-
> Sent: Friday, March 28, 2003 6:24 AM
> To: Multiple recipients of list ORACLE-L
> 
>   I wonder where I should set TIMED STATISTICS = TRUE, if any of you
> has the time to answer I'd be grateful, but I will look for it in the docs.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  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: Week - Date function!

[DENNIS WILLIAMS]

Stephane
   There are days when I just feel lucky if I can understand your code, let
alone come up with something smarter. 

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


SQL> l
  1  select x.d
  2  from (select to_date(rownum, 'DDD') d,
  3   to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
  4from all_objects
  5where rownum < 366) x
  6* where x.week = &week_num

You may have a problem with leap years, but it's basically the idea.
Anything smarter, somebody ?

>
>Given a week between (1 - 52) for a particular year
>can we get all the dates within that week. Is there
>a function to do this 
>in SQL???
>
>Thanks a lot.
>
>Regards
>Sesi
>-- 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: DENNIS WILLIAMS
  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: Which process is taking up so much CPU???

[DENNIS WILLIAMS]

Fermin
   Add this line to your init.ora file.
timed_statistics = true
   Then shutdown, startup your Oracle instance.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L



Thank you all for your help.

I wonder where I should set TIMED STATISTICS = TRUE, if any of you
has the time to answer I'd be grateful, but I will look for it in the docs.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fermin Bernaus Berraondo
  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: DENNIS WILLIAMS
  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: Fermin Bernaus Berraondo
  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: DENNIS WILLIAMS
  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: Week - Date function!

[Stephane Faroult]

SQL> l
  1  select x.d
  2  from (select to_date(rownum, 'DDD') d,
  3   to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
  4from all_objects
  5where rownum < 366) x
  6* where x.week = &week_num

You may have a problem with leap years, but it's basically the idea. Anything smarter, 
somebody ?

>
>Given a week between (1 - 52) for a particular year
>can we get all the dates within that week. Is there
>a function to do this 
>in SQL???
>
>Thanks a lot.
>
>Regards
>Sesi
>-- 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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).

Intermedia tag "<" problem

[Luc Demanche]

Hi Gurus,

We are working with Intermedia Text 8.1.6.
We created a intermedia index on a search field.  We
also created 2 sections in this field.

Table name : S01
Filed name : S01_search
Sections name : SY,MAN

Here is an example of data in this field:
CyanePhibro Energy  *
This example works fine.  

But we have a problem when there is a "<" character in
the data. 

Intermedia thinks it's a new tag and tries to find a
section but it cannot.
Exemple:
Cyane < 10 Phibro Energy  *

Question :  
1- Should we do something with the "<" in our data ?

TIA 
Luc



=
Luc Demanche
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Luc Demanche
  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: Which process is taking up so much CPU???

[CP]

Alter system set timed_statistics=true;
or/and - init.ora - timed_statistics=true
HTH
CP
[EMAIL PROTECTED] wrote:

   Thank you all for your help.

   I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???
Fermin
  The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L


   I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.
   I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.
   Thank you for your answers!

Fermin.

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CP
 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).

Week - Date function!

[Sesi Odury]

Hi,
 

Given a week between (1 - 52) for a particular year can we get all the dates within 
that week. Is there a function to do this 
in SQL???

Thanks a lot.

Regards
Sesi
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sesi Odury
  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: create interMedia index problem

[JApplewhite]

Guang,

Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform
Extents of less than 3 database blocks?  If so, that's your problem.
InterMedia indexes consist of some LOB segments and those require extents
of at least 3 database blocks - at least in 8i.

If not, I don't know.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



   

  Guang Mei

  <[EMAIL PROTECTED]>To:   Multiple recipients of list 
ORACLE-L  
  Sent by:  <[EMAIL PROTECTED]>
 
  [EMAIL PROTECTED] cc:
 
   Subject:  create interMedia index 
problem   
   

  03/27/2003 10:53 

  PM   

  Please respond to

  ORACLE-L 

   

   





Hi:

I have this problem on our production server and I don't know too much
about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8.

[EMAIL PROTECTED]> desc DRUGDATA;
 Name  Null?Type
 - 

 IDNOT NULL NUMBER
 DRUGREPID NOT NULL NUMBER
 FIELD NOT NULL NUMBER
 TEXT   VARCHAR2(4000)
 DRUGTERMID NUMBER
 DATATYPEIDNOT NULL NUMBER
 ADD_FILE  NOT NULL VARCHAR2(32)
 ADD_DATE  NOT NULL DATE
 DEL_FILE   VARCHAR2(32)
 DEL_DATE   DATE
 STATUSNOT NULL CHAR(1)
 ORDERBY   NOT NULL NUMBER

[EMAIL PROTECTED]> select count(*) from DRUGDATA;

  COUNT(*)
--
 0


TABLESPACE_NAME  USED-Kb ALLOC-KbUSED%  SEGS  >EXT  >NEXTEXT
 --- --- -- - - 
DATA   3,000   1,048,576 .3 1 1  504
INDEXES   10,664,424  14,680,064   72.6   48011  693,080
PERFSTAT 105,728   2,097,1525.056   150  128
PROTEOME 164,872   1,048,576   15.75219   25,600
RBS5,131,360   8,388,608   61.2 6   8002,048
RESCTX43,832   6,803,456 .66628  504
RESDATA   34,470,408  46,137,344   74.7   361  2319 
RESINDEX  41,046,376  69,206,016   59.3   300  1063  512,000
SYSTEM74,320 153,600   48.4   401   1151,120
TEMP  10,224,960  10,240,000   99.9 1  20455,000
YPD   12,769,224  16,777,216   76.1   249 #  292,976

TABLESPACE_NAME  USED-Kb ALLOC-KbUSED%  SEGS  >EXT  >NEXTEXT
 --- --- -- - - 
YPDCUST0   1,048,576 .0 0 00

Then I ran

create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT)
 indextype is ctxsys.context
parameters ('LEXER ctxsys.ISILEX WORDLIST ctxsys.ISIWORDLIST
STOPLIST ctxsys.ISISTOP storage isistore memory 50M');

I got

create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-2: interMedia Text error:
DRG-50857: oracle error in drixtab.create_index_tables
ORA-01658: unable to create INITIAL extent for segment in tablespace
RESINDEX
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1

and I got from alert_log file:

ORA-1652: unable to extend temp segment by 128000 in tablespace
RESINDEX

I did coalesce on all tablespace and added another 2G datafile on RESINDEX
tablespace, I still got t

RE: index on null column

[Jamadagni, Rajendra]

Title: RE: index on null column





Here is an idea ...


Create a function that returns NULL if the value is null or any other acceptable value that can be ignored. And the function should return valid values otherwise. Then create a function based index on this and see if that helps you.

To put in other words, you are merely indexing a subset of rows that match your criteria, while ignoring others that you don't want to deal with.

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 27, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: index on null column



AK
   Yes, it will benefit the non-null records. Just remember that the null
values aren't indexes.




Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L



I have a table with column A. there are 100 records in table out of
which 500o records has not null in column A rest are null.
if i created an index on A, will it benefit .
 
thanks,
ak


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Which process is taking up so much CPU???

[Fermin Bernaus Berraondo]

Thank you all for your help.

I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the 
time to answer I'd be grateful, but I will look for it in the docs.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fermin Bernaus Berraondo
  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: DENNIS WILLIAMS
  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: Fermin Bernaus Berraondo
  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: OT: uuencode adding characters

[Saira Somani]

Chris,

Can you give me a hint? So I use Perl to rid the file of these
characters and then uuencode it and then use mail utility to send to
people? Won't uuencode do the same thing again and add those characters
back?

Thanks!

-Original Message-
Berry
Sent: March 27, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L

>From: "Saira Somani" <[EMAIL PROTECTED]>
>AIX 4.3.3
>ORACLE 8.1.7.0.0
>
>I have a spooled report from an SQL script which I am e-mailing, also
>from a script using the uuencode utility.
>
>The spooled report looks fine but once it is e-mailed, it looks funny
>with carriage return characters added everywhere (I have line feeds in
>the report for ease of readability). I think maybe the uuencode is
>messing it up(?)
>
>Users of this report will likely open it up in Notepad and get confused
>- or worse, complain.
>
>Anyone else have the same issues?

No, but you could easily write a perl script to clean it up, take about
3 
lines of code.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  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: Saira Somani
  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: OT: uuencode adding characters

[Saira Somani]

Thanks. I guess this would be a good time to learn Perl :)


-Original Message-
Berry
Sent: March 27, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L

>From: "Saira Somani" <[EMAIL PROTECTED]>
>AIX 4.3.3
>ORACLE 8.1.7.0.0
>
>I have a spooled report from an SQL script which I am e-mailing, also
>from a script using the uuencode utility.
>
>The spooled report looks fine but once it is e-mailed, it looks funny
>with carriage return characters added everywhere (I have line feeds in
>the report for ease of readability). I think maybe the uuencode is
>messing it up(?)
>
>Users of this report will likely open it up in Notepad and get confused
>- or worse, complain.
>
>Anyone else have the same issues?

No, but you could easily write a perl script to clean it up, take about
3 
lines of code.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  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: Saira Somani
  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).

copying datafile nt4-w2k

[GKor]

hi all

We are planning an upgrade from NT4 to W2K.
I am considering to create a new instance on another server with W2K
installed and copying the datafiles
from the server with NT4 on it. 
Is this possible ? Or do i have to use the exp/imp strategy ?

thanks

vr.gr.
Geo Kor
Sr. System Engineer I&DM Db
RDW Voertuiginformatie en -toelating 
Holland



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: Database Modeling- Normalization - Dinosaurs or What?

[April Wells]

Hi Stefan

On the Data Warehouse project, the technical lead didn't understand Oracle.
She was a mainframe programmer and once, in another job, she used VSAM
files.  WE don't support VSAM files, but she wanted to use them anyway...
take data out of Oracle on Unix, pipe it to the mainframe to do some
Tranformations (in the ETL), pipe it BACK to Unix and load it in to the
Oracle tables... because that's how she knew how to do it... and the
technical lead should know everything about EVERY detail of how the project
is implimented.

We are doing better... After I got told to sit down and shut up in a couple
meetings, and lectured for 2 hours on my attitude in meetings being less
than helpful, I quit going and started just rejecting what wouldn't work
after they had spent hours or days writing it.

They are starting to consider (not use in most cases, but consider) stored
procedures.

I don't look on it (most of the time) so much as Purgatory, but as a
personal challenge.  Besides, I have done IMS (DB/DC) and know that
Purgatory is having virtual bi-directional pointers interconnecting 6
"tables" in every imaginable configuration, one of them with the only thing
that makes it unique in the world being a sequece number and load routines
that don't remember where they were in the file when the operators restart
the process after an abend.

April 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/28/2003 4:23 AM

Hi
 
What I don't understand is: If your development department want to go
with a VSAM like approach, why do they invest in Oracle. Why not just
get a zSeries and stick to VSAM or IMS ?
 
PS: Your working environment sounds like an actual implementation of
Purgatory
 
Regards,
Stefan
 

Stefan Jahnke 
Consultant 
BOV Aktiengesellschaft 
Voice: +49 201 - 4513-298 
Fax: +49 201 - 4513-149 
mailto: [EMAIL PROTECTED] 
Please remove nospam to contact me via email. 

visit our website: http://www.bov.de   
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
  

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient
schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]  .

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht
unter fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde
bitten wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz
die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und
Aeusserungen ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must
decline all legal responsibility for the validity of the statements and
comments given above.

-Ursprüngliche Nachricht-
Von: April Wells [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. März 2003 14:09
An: Multiple recipients of list ORACLE-L
Betreff: RE: Database Modeling- Normalization - Dinosaurs or What?


Hi Paula
 
Hey... I live in your world.
 
Our "data warehouse" was designed by someone who had never dealt with
ANYTHING relational... but based it on VSAM files and tried to make the
leap.
We have a table with 873 columns in our data warehouse... they call it a
FACT table.  It has client name and address (well... they are "facts",
right... ?).
 
You don't have foreign keys... we don't have PRIMARY keys.  We call
unique indexes primary keys... but after 10 years of not understanding
why queries didn't return data that made sense, they allowed me to put
not null constraints on the columns in the unique index (when I told
them that they either do that or they answer to the clients).
Historically, the DBAs in this company have done little more than
implement what programmers designed and then tried to make it work.
They WON'T use stored procedures, they don't understand them.  THEY
write code that sits in files on the OS and call those "programs" via
shell scripts.  They heard once that it was faster that way in Oracle 2
and so it must be still true, cause COBOL never changes so Oracle must
not change.
 
The part I like best, though, is... we have a ONE column table with ONE
row... SystemDate... because they can't figure how to get sysdate from
dual into a variable and use it in their programs... so they start their
data warehouse load run with a truncate to that table, and an insert of
the date passed in from the OS so they can load the DW tables.
 
DON'T stop fighting.  I think that is what they want.  I have been told
(in meetings where I have been requested for my DBA input) to sit down
and shut up unless I am asked a question when I tried to point out
things like... you can't have 1500 columns in a table no matter how fast
it will make the queries fly... you can't have table names of 72
characters for descriptive sake... you really can'

AW: Database Modeling- Normalization - Dinosaurs or What?

[Stefan Jahnke]

Title: RE: Database Modeling- Normalization - Dinosaurs or What?



Hi
 
What I 
don't understand is: If your development department want to go with a VSAM like 
approach, why do they invest in Oracle. Why not just get a zSeries and stick to 
VSAM or IMS ?
 
PS: 
Your working environment sounds like an actual implementation of 
Purgatory
 
Regards,
Stefan
 
Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via 
email. 
visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp 

Sicherheitsluecken mit 
IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter 
+49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet 
versandte E-Mails leicht unter fremden Namen  erstellt oder manipuliert 
werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass  wir zu 
Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden 
Erklaerungen und Aeusserungen ausschliessen.
As you are probably aware, e-mails sent 
via the Internet can easily be copied or manipulated by third parties. For this 
reason we would ask for your understanding that, for your own protection and 
ours, we must decline all legal responsibility for the validity of the 
statements and comments given above.

  -Ursprüngliche Nachricht-Von: April Wells 
  [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 25. März 2003 
  14:09An: Multiple recipients of list ORACLE-LBetreff: 
  RE: Database Modeling- Normalization - Dinosaurs or What?
  Hi 
  Paula
   
  Hey... I live in your world.
   
  Our 
  "data warehouse" was designed by someone who had never dealt with ANYTHING 
  relational... but based it on VSAM files and tried to make the 
  leap.
  We 
  have a table with 873 columns in our data warehouse... they call it a FACT 
  table.  It has client name and address (well... they are "facts", 
  right... ?).
   
  You 
  don't have foreign keys... we don't have PRIMARY keys.  We call unique 
  indexes primary keys... but after 10 years of not understanding why queries 
  didn't return data that made sense, they allowed me to put not null 
  constraints on the columns in the unique index (when I told them that they 
  either do that or they answer to the clients).  Historically, the DBAs in 
  this company have done little more than implement what programmers designed 
  and then tried to make it work.  They WON'T use stored procedures, they 
  don't understand them.  THEY write code that sits in files on the OS and 
  call those "programs" via shell scripts.  They heard once that it was 
  faster that way in Oracle 2 and so it must be still true, cause COBOL never 
  changes so Oracle must not change.
   
  The 
  part I like best, though, is... we have a ONE column table with ONE row... 
  SystemDate... because they can't figure how to get sysdate from dual into a 
  variable and use it in their programs... so they start their data warehouse 
  load run with a truncate to that table, and an insert of the date passed in 
  from the OS so they can load the DW tables.
   
  DON'T stop fighting.  I think that is what they want.  I have 
  been told (in meetings where I have been requested for my DBA input) to sit 
  down and shut up unless I am asked a question when I tried to point out things 
  like... you can't have 1500 columns in a table no matter how fast it will make 
  the queries fly... you can't have table names of 72 characters for descriptive 
  sake... you really can't call a column DATE just because that is what is in 
  it, an arbitrary date...  Make them hear you even if they don't 
  listen.  Be the biggest pain they can imagine, eventually it will slowly 
  start to pay off, because eventually they will realize (again VERY slowly) 
  that you are right.  It is how I got the reputation of being a DBA (Dat 
  Bi#$h April)
   
  April 
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 
2003 6:14 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Database Modeling- Normalization - Dinosaurs 
or What?
Guys, 
The emphasis in many places I have worked is developing 
quick and dirty systems as quickly as possible and working with developers 
that don't seem to have very much understanding of Relational Database 
Theory but who prefer to program using flat files in relational databases - 
calling it "object-oriented" when it truly is not.  Let us just say 
that it is highly denormalized.  As a DBA I care about data integrity, 
extensibility and scalability but the up and coming esp. SQL Server 
developer types seem to operate in a world where this doesn't matter - just 
buy more hardware, denormalize to make the programming easier, etc.  

I have been losing this battle.  
S

RE: Oracle connection through Crystal Reports

[Grant Allen]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Juan
> Antonio Félix Sarabia
> Sent: Thursday, March 27, 2003 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle connection through Crystal Reports
>
>
> Hi All.
> I´m trying to connect to a oracle database 8i for using it
> with crystal
> reports 9.
>
> I have win2000 professional, I tried to use 'CR Oracle ODBC
> Driver 4.10' but
> it appears a error system with the number 126 when i try to do a test
> connection. The message is something like that 'can´t load
> driver ...'. I
> tried to use 'More Data Sources' option in Crystal reports but it not
> appears the option to choose an oracle data source.
>
> I have installed oracle SQL *Net Client 2.3.2.1.6A because i
> use Oracle
> developer 2000.
>
> would somebody help me please ?
>
> Thanks.

Juan,

Your crystal reports bin directory (or equivalent) is probably not on the
path.  Add it, and it should work.

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  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: Which process is taking up so much CPU???

[Mark Leith]

Tim,

I think you may be right actually! :) I have a sub directory that contains
the scripts that you zipped up on your site, this script seemed to have
found it's way in to my main "SQL" directory, and as it didn't have any
notes on author I plain forgot. It was indeed called SessionTopCPU.sql. All
comments/praises to Tim! ;)

Welcome back to the list by the way! :)

Cheers

Mark

-Original Message-
Sent: 27 March 2003 17:14
To: Multiple recipients of list ORACLE-L


Hey, it could well be one of mine (or something derived from the same source
as I started with) - got all the same words, syntax and style as something I
call SessionTopCPU and use to be available off my web site. I think the
original inspiration was from Dave Ensor, but I no longer use the report and
have long since forgotten almost everything about it (ie I won't be of much
help in answering questions).

_
Tim Onions
Head of Oracle and Web Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
Tel: +44.1684.312364
http://www.speechmachines.com



-Original Message-
Sent: 27 March 2003 15:59
To: Multiple recipients of list ORACLE-L


Prompt
Prompt Show total CPU and statement CPU for current session (requires TIMED
STATISTICS = TRUE)
Prompt

set verify off
col UNAM format a20  word  heading 'User'
col STMT format a56  word  heading 'Statement'
col RUNT format a08  word  heading 'CPU Time'
col ltim format a20 word heading 'Logon Time'
col etim format a20 word heading 'Connect Time'
col PROG format a30 word heading 'Program|Client Terminal Details'
col SID  format a10 word heading 'SID/|Serial#'
col DR   format 9 heading 'Disk Reads'
col BG   format 9 heading 'Buffer Gets'
col EX   format 9 heading 'Executions'
col rsecs format 999,999,999.00 heading "CPU time|(seconds)"
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Onions
  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: Mark Leith
  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: Oracle encouraging Linux software developers

[Grant Allen]

> IBM is loudly touting how much money they will be spending on
> Linux. Has
> anyone seen any sales statistics for DB2 on non-IBM
> platforms? I feel that
> IBM has a challenge to convince buyers to consider DB2 on Linux.
>
>
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]

Dennis,

Humourously ... at least in Oz, the number one Unix platform for DB2 is
Solaris.  IBM will probably turn this around ... they are being quite clever
with the 5L releases of AIX, by enabling compatibility with both AIX and
Linux binaries.  So they feed you a little Linux box, wait for you to decide
you need something bigger, ease you on to an AIX 5L box still running your
linux code (but now you're paying AIX licencing), and then roll in with the
usual IBM steamroller.

That said, I've just had a free 3-day training course from them, so nothing
like biting the hand that feeds, so to speak :-)

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  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: OT: PLSQL question, JAVA, JDBC

[Chip]

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:986230504001

Have Fun :)

Darrell Landrum wrote:

I'd take a look on http://java.sun.com, there are some great forums
there.  Also try http://devtrends.oracle.com.
 

[EMAIL PROTECTED] 03/27/03 11:03AM >>>
   

Hi list, this is a question for JAVA/PLSQL
programmers.
I need to pass an array object from my code in Java
using JDBC to a stored procedure in Oracle. I do not
know how to do that, could you give me a call example
so I can figure out how to achieve this ?
TIA
Gabriel Aragon
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com 
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
 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: Oracle Licences Req on Intel Xeon CPU

[Chip]

http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp
has a link to an article that has the BIOS requirement
for logical CPU numbering (and start-up order).
Note: since Windows 2000 Server does support
up to four CPU's, the task manager does display
4 CPU's on a hyperthreaded dual XEON computer.
Have Fun :)

david hill wrote:

Yes Redhat Advanced Server 2.1 does support hyperthreading.
Its not to bad either. I ran some tests and we get about a 15% 
increase in performance with hyperthreading turned on.



-Original Message-
From: Michael Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Licences Req on Intel Xeon CPU
2000 only shows 2 CPUs because it cannot take advantage hyperthreading.
From what I have read (Intel's website, some others), hyperthreading
requires both BIOS and OS support to be utilized.  Currently, XP and the
newer Linux releases are all that I have seen that will take advantage of
it.
My research on this was fairly light since I was just after can Redhat
Advanced Server support it, but I do remember seeing that W2K would not.
--
Michael Brown   Glen Raven, Inc./Info Services
Senior Oracle DBA   1831 N. Park Ave
Phone: (336)586-1146Glen Raven, NC 27217
Fax: (336)586-1382  [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 26, 2003 3:44 AM
To: Multiple recipients of list ORACLE-L
Depending on the OS, Microsoft has different CPU counts.  The Windows
2000 family
counts each hyper thread as 1 CPU.  In contrast, Windows XP and Windows
2003 Server
count each CPU instead of each hyper thread.  Thus, the task manager in
Windows XP
Professional show 4 CPU's (on a dual XEON CPU computer with hyper 
threading
enabled) while Windows 2000 Professional only shows 2 CPU's in the task
manager.

Have Fun :)

[EMAIL PROTECTED] wrote:

>Hi all
>
>For those that are running or intending on running Oracle on
>Intel's Xeon CPU, the following information may be of interest to you.
>
>The Xeon CPU has a feature called Hyper Threading with double the number
>of registers.   This feature when turned will present to the Operating
>Systems an additional virtual CPU.  As far as the O/S is concern, it
>looks like there are _two_ CPUs.  What does this mean to your software
>licensing?
>
>Microsoft says that it is one CPU.  What does Oracle say?
>
>Well, it depends on who you speak to and what day of the week it is.
>Seriously, you will need to get some confirmation in writing from your
>account manager the next time you purchase Oracle S/w for Intel's Xeon
>
>ta
>tony
>
> _    / |Tony Jambu, Database&Web Consultant
>  /_  _/_ __ /  |Wizard Consulting Pty Ltd
> /(_)/ )(_/ \_/(///(/_)/_(  |IOUG's Select Asia-Pacific Tech. Editor
> \___/  |EMAIL: TJambu @ wizard.cx  (REMOVE 
Spaces from
email )
>|PHONE: +61-419-TJAMBU(852628)
>
>
>



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
  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: Chip
 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: Hotsos Clinic 101 Feedback

[Chip]

Attending a Hotsos Clinic and Hotsos Symposium was very worthwhile. If 
an employer
cannot afford the training time, flexing work hours (or using vacation) 
may be possible.

Note: if you do attend a Hotsos event on your own time,
your company name can be removed from your name tag ;)
Looks like some Hotsos Clinics have been scheduled in 4 countries:
Apr 8 - 10 Chicago, IL, USA
May 13 - 15 London area, UK
Jun 2 - 4 Reykjavik, Iceland
Jun 10 -12 Ottawa, ON, CA
Aug 12 - 14 Denver, CO, USA
Personally, I enjoy listening and learning from Cary, Jeff, and Gary.

Have Fun :)

Michael Brown wrote:

I've taken it twice (one of the first public classes and again the when they
started offering the reduced alumni rate), and stand by my quote on Hotsos's
website.
"If you have the time to take a class, take the Hotsos Clinic.  It was the
absolute best performance tuning resource that I have ever invested time
in."
Of course, I would change "tuning" to "optimization" since we are making
tuning a dirty word.
For those of you who were not at the Hotsos Symposium in Dallas, you missed
a fantastic conference.  You should make your plans to be in Las Vegas next
year.
I am not affiliated in any way with Hotsos, just am impressed by both the
knowledge Cary and Jeff have and their ability to convey it to others.
--
Michael Brown   Glen Raven, Inc./Info Services
Senior Oracle DBA   1831 N. Park Ave
Phone: (336)586-1146Glen Raven, NC 27217
Fax: (336)586-1382  [EMAIL PROTECTED]
-Original Message-
Stefick
Sent: Wednesday, March 26, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
I haven't taken it yet, but I am signed up for the Chicago Clinic on April
8-10Can't Wait!  I've heard really good things about it.
At 08:04 AM 3/26/03 -0800, you wrote:
 

Anybody take this course before.  Any comments, good or bad.  Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
 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).
   



**
Scott Stefick
Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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: Chip
 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).