date:20021204

Thanks, but I'd rather have a nice shot of Scotch.

:)

Jared





"Stephen Andert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/04/2002 03:39 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Database up longer that host?


Give the man a cigar. (virtual one of course :)

That is what I was looking for and makes unix uptime and db_uptime.sql
report a compatible time frame.

Thanks Jared.

Stephen

>>> [EMAIL PROTECTED] 12/03/02 04:02PM >>>
Try:

col uptime format a40 head 'UPTIME'

select  to_char(sysdate,'hh:miam')
|| ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, '
|| trunc( (sysdate - trunc(sysdate)) *24 ,0)  || ':' -- hours
|| trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', '
-- 
minutes
|| s.user_count || ' users' uptime
from v$instance i, (
select count(*) user_count
from v$session
where username is not null
) s
/





"Stephen Andert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 
 12/02/2002 07:58 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:RE: Database up longer that host?


Govind, 

Actually, what I want it the same format as I have, I just want the
numbers to match (or fall within) the numbers reported by the unix
uptime command for example "up 4 days, 21:08 hours".  In my case, the
unix uptime is saying the host was last restarted after the database
startup_time reported in v$instance. 

Stephen 

>>> [EMAIL PROTECTED] 12/02/02 07:43PM >>>
You may use following query will give you the uptime in hours and in
minutes.

select sysdate, startup_time,
round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes,
round( (sysdate - startup_time) *24 ,0)  uptime_in_hours
from v$instance

SYSDATESTARTUP_TIME   UPTIME_IN_MINUTES UPTIME_IN_HOURS
-- -- - ---
20021202203918 20021202044608   953  16

Hope this is what you wanted.

-Original Message-
Sent: Monday, December 02, 2002 8:34 PM
To: Multiple recipients of list ORACLE-L



On Mon, 2 Dec 2002, Stephane Faroult wrote:

> Stephen Andert wrote:
> >
> > I use a script named db_uptime.sql (I think I got it from the list
here)
> > to calculate how long the database has been up.  The output
compares
> > nicely to the unix uptime command.
>
>I hope that the query doesn't come from the list, because it is
> wrong. The error is to apply floor() before multiplying by 24 or 60
-
> you have tremendous rounding errors.
> My own database has not been up long enough to be 100% sure about it
but
> I believe the following to be correct :

Hi:

Neither of the scripts works for me.  Try this?

select
'Host Name : '||host_name|| chr(10)||
'Instance Name : '||instance_name|| chr(10)||
'Uptime : ' ||floor(xx)||'days '
|| floor( 24 * (xx - floor(xx)) ) || 'hours '
|| round( 60 * (24 * xx - floor(24 * xx))) ||
'minutes '
from (
 select host_name,instance_name ,(sysdate-STARTUP_TIME) xx
 from v$instance
 )
/


Meg Crocker
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Meg Crocker
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: <[EMAIL PROTECTED] 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 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: [EM

DB corruption question

2002-12-04 Thread Nick Wagner




 
With Oracle 8.1.7, 
Solaris 8 OS.  
 
I have a shared 
storage device for storing all my datafiles, control files, redo logs, archive 
logs, etc..  everything except for the ORACLE_HOME and Oracle 
binaries.  
 
If I have the file 
system and database mounted to one machine, and have a fully open, available 
database running.  What happens if someone else tries to mount the same 
files to another machine and start up the same database on it. (No OPS or RAC 
involved)
 
I get the following 
error on the on the second machine...
 
 
SVRMGR> ORACLE instance started.
Total System Global Area 272359584 
bytes
Fixed Size 73888 bytes
Variable Size 88678400 bytes
Database Buffers 183427072 bytes
Redo Buffers 180224 bytes
Database mounted.
SVRMGR> ORA-00283: recovery session canceled due 
to errors
ORA-01122: database file 1 failed verification 
check
ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf'
ORA-01207: file is more recent than controlfile - 
old controlfile
SVRMGR> alter database open
*
ORA-01122: database file 1 failed verification 
check
ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf'
ORA-01207: file is more recent than controlfile - 
old controlfile
SVRMGR> Server Manager complete.
EXITING 1
Unable to start Oracle instance
 
Will this corrupt 
the database?  Will it harm/corrupt the original instance?   What 
happens if someone tries to recover it at this point?  Does it make a 
difference whether its a RAW or cooked file system?
 
Any help is 
appreciated! 
 
Nick

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Scott Stefick

Are you getting a sheet after each exam showing how many you got correct 
for each section and your overall score?  I received that  sheet at the 
testing center after each exam.  Other than that, you won't get anything 
from Oracle until you finish your final exam.  It took me about a month to 
get my packet.

At 01:13 PM 12/4/02 -0800, you wrote:
Lyndon - I have completed 2 of the 5 Oracle8i exams.

Hey - when I took each exam, the testing organization says that I should
receive something from Oracle within a couple of weeks. Got nothing. Should
I be worried?

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


-Original Message-
Sent: Wednesday, December 04, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L


Hey William,

Why are you 40% OCP - does this mean you are an OCA? When did you take your
very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're
a
50% OCP.

--
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey people!
>
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>
> But maybe I'm just naive.
>
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited®
> BIM House
> Crofton Road
> Dun Laoghaire
> Co Dublin
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: 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.com
--
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harpe

RE: ORA-1653: unable to extend table - Why?

2002-12-04 Thread Khedr, Waleed

Sorry, I've just seen these stats:

> > num_freelist_blocks:  2266966
> > avg_space_freelist_blocks: 3895

My message completely contradicts with that fact, so forget about it except
if the statistics are wrong.

Too weird! let's know what you find.

Is it partitioned? What is the extent size?

Waleed


-Original Message-
Sent: Wednesday, December 04, 2002 5:49 PM
To: Multiple recipients of list ORACLE-L


I guess this is reason.

pct_used and pct_free are very closed. after the deletion if the pct_free is
just   below 75% it will join the free list.

Suppose the block header is Y bytes.
And you have pct_free = 10% and pct_used = 75%, this means if a block is 30%
free (70% used) it will have
 (4096 - Y ) * (90 - 70) = less than 800 bytes for insertion before reaching
pct_free.

And you have the average row length = 1895, so most of the allocations will
fail.

The problem is very small block size in comparison to row size and high
pct_used.

For now lower your pct_used.

HTH

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L


1895

-Original Message-
Sent: Wednesday, December 04, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L


What is the average row length?

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L


What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L


Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...


-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L



One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

 

 

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

 

 





Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L


Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presen

RE: Database up longer that host?

2002-12-04 Thread Stephen Andert

Give the man a cigar. (virtual one of course :)

That is what I was looking for and makes unix uptime and db_uptime.sql
report a compatible time frame.

Thanks Jared.

Stephen

>>> [EMAIL PROTECTED] 12/03/02 04:02PM >>>
Try:

col uptime format a40 head 'UPTIME'

select  to_char(sysdate,'hh:miam')
|| ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, '
|| trunc( (sysdate - trunc(sysdate)) *24 ,0)  || ':' -- hours
|| trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', '
-- 
minutes
|| s.user_count || ' users' uptime
from v$instance i, (
select count(*) user_count
from v$session
where username is not null
) s
/

"Stephen Andert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 
 12/02/2002 07:58 PM
 Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:RE: Database up longer that host?

Govind, 

Actually, what I want it the same format as I have, I just want the
numbers to match (or fall within) the numbers reported by the unix
uptime command for example "up 4 days, 21:08 hours".  In my case, the
unix uptime is saying the host was last restarted after the database
startup_time reported in v$instance. 

Stephen 

>>> [EMAIL PROTECTED] 12/02/02 07:43PM >>>
You may use following query will give you the uptime in hours and in
minutes.

select sysdate, startup_time,
round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes,
round( (sysdate - startup_time) *24 ,0)  uptime_in_hours
from v$instance

SYSDATESTARTUP_TIME   UPTIME_IN_MINUTES UPTIME_IN_HOURS
-- -- - ---
20021202203918 20021202044608   953  16

Hope this is what you wanted.

-Original Message-
Sent: Monday, December 02, 2002 8:34 PM
To: Multiple recipients of list ORACLE-L

On Mon, 2 Dec 2002, Stephane Faroult wrote:

> Stephen Andert wrote:
> >
> > I use a script named db_uptime.sql (I think I got it from the list
here)
> > to calculate how long the database has been up.  The output
compares
> > nicely to the unix uptime command.
>
>I hope that the query doesn't come from the list, because it is
> wrong. The error is to apply floor() before multiplying by 24 or 60
-
> you have tremendous rounding errors.
> My own database has not been up long enough to be 100% sure about it
but
> I believe the following to be correct :

Hi:

Neither of the scripts works for me.  Try this?

select
'Host Name : '||host_name|| chr(10)||
'Instance Name : '||instance_name|| chr(10)||
'Uptime : ' ||floor(xx)||'days '
|| floor( 24 * (xx - floor(xx)) ) || 'hours '
|| round( 60 * (24 * xx - floor(24 * xx))) ||
'minutes '
from (
 select host_name,instance_name ,(sysdate-STARTUP_TIME) xx
 from v$instance
 )
/

Meg Crocker
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Meg Crocker
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: <[EMAIL PROTECTED] 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

RE: Are Oracle courses required for Oracle Certification now?

Yah. That's what we do on EnTee/WinTuKee.

Also, on DOS prompt:

oradim -startup -sid= -pfile=

But on EnTee, I think you can't do, at least I couldn't, maybe someone has tried
this and it worked for them 8i on NT4/W2K:

sqlplus /nlolog
connect / as sysdba
startup nomount
create database database_name

can you?

??

-- 
Lyndon Tiu


Quoting Nick Wagner <[EMAIL PROTECTED]>:

> if the DOS command prompt doesn't work, try starting it at the services
> level. 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  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: Export from Oracle 8 to Oracle 7

2002-12-04 Thread Jeremy Pulcifer

Title: RE: Export from Oracle 8 to Oracle 7





Just use an Oracle7 client to do the exp


> -Original Message-
> From: Bartolo, David [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 12:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Export from Oracle 8 to Oracle 7
> 
> 
> Hi all
> 
> Can I export from a Release 8.1.7.0.0 oracle db to a Release 
> 7.1.4.1.1?
> Is there a setting in the export utility to be backward 
> compatible with V7?
> 
> Thanks
> David
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bartolo, 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: ORA-1653: unable to extend table - Why?

2002-12-04 Thread Khedr, Waleed

I guess this is reason.

pct_used and pct_free are very closed. after the deletion if the pct_free is
just   below 75% it will join the free list.

Suppose the block header is Y bytes.
And you have pct_free = 10% and pct_used = 75%, this means if a block is 30%
free (70% used) it will have
 (4096 - Y ) * (90 - 70) = less than 800 bytes for insertion before reaching
pct_free.

And you have the average row length = 1895, so most of the allocations will
fail.

The problem is very small block size in comparison to row size and high
pct_used.

For now lower your pct_used.

HTH

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L

1895

-Original Message-
Sent: Wednesday, December 04, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L

What is the average row length?

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L

freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> w

Re: Are Oracle courses required for Oracle Certification now?

OK. Thanks.

-- 
Lyndon Tiu


Quoting Boris Dali <[EMAIL PROTECTED]>:

> Alan, I think what Lyndon meant is this
> SQLNET.AUTHENTICATION_SERVICES thing on MS Win that
> toggles your ability to connect with the syntax
> described. Comment it out and you might see something
> like ORA-1031
> 
>  --- Alan Davey <[EMAIL PROTECTED]> wrote: > Hi
> Lyndon,
> > 
> > Well I don't know about your setup, but I can
> > connect just fine with the connect string you listed
> > below on Win2K, Oracle 9.2.
> > 
> > -- 
> > 
> > Alan Davey
> > [EMAIL PROTECTED]
> > 212-604-0200  x106
> > 
> > 
> > On 12/4/2002 2:09 PM, Lyndon Tiu
> > <[EMAIL PROTECTED]> wrote:
> > >This is unfortunate or maybe just it's just an
> > urban legend?
> > >
> > >Hands on training, may it be $$$ or self taught at
> > home is necessary. 
> > >But $$$ is
> > >definitely not a requirement.
> > >
> > >I use Oracle at work and do more Oracle at home for
> > my certs. I am 
> > >able to
> > >log-in to Oracle on Linux and Solaris. Oracle
> > WinNT/2K is another 
> > >story since
> > >you cannot really use:
> > >
> > >sqlplus /nolog
> > >connect / as sysdba
> > >startup
> > >
> > >as you would on Unix. Maybe this is what ticked the
> > instructor off 
> > >- a bunch of
> > >Unix Oracle guys can't log into Oracle on NT?
> > >
> > >-- 
> > >Lyndon Tiu
> > >
> > >
> > >Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> > >
> > >> My instructor in a recent Oracle Education class
> > said that there 
> > >were a
> > >> couple of smart alecs that caused quite a stir
> > within Oracle. After
> > >> receiving their OCP, they couldn't log into a
> > database, and claimed 
> > >it was
> > >> because they had never actually used Oracle. The
> > instructor indicated 
> > >that
> > >> the new requirement (9i I believe) would require
> > you to take at 
> > >least one
> > >> class. I asked "do you mean everyone that takes a
> > class from you 
> > >will be
> > >> logging on". He just grinned.
> > >> Dennis Williams
> > >> DBA, 40%OCP
> > >> Lifetouch, Inc.
> > >> [EMAIL PROTECTED] 
> > >> 
> > >> 
> > >> -Original Message-
> > >> Sent: Wednesday, December 04, 2002 11:25 AM
> > >> To: Multiple recipients of list ORACLE-L
> > >> 
> > >> 
> > >> Hey people!
> > >>  
> > >> A friend of mine was just asking me about getting
> > Oracle certified 
> > >(I
> > >> completed the Oracle 8i cerfication exams last
> > year),
> > >> he told me that to his knowledge Oracle requires
> > that you've done 
> > >Oracle
> > >> courses before you can be certified now.
> > >> I knew nothing about this, but can't believe
> > Oracle would so blatantly 
> > >make
> > >> you take their over-priced courses.
> > >>  
> > >> But maybe I'm just naive.
> > >>  
> > >> Cheers,
> > >> Kieran Murray
> > >> CardBASE Technologies Limited® 
> > >> BIM House
> > >> Crofton Road 
> > >> Dun Laoghaire
> > >> Co Dublin 
> > >>  
> > >>  
> > >> -- 
> > >> Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > >> -- 
> > >> Author: Kieran Murray
> > >>   INET: [EMAIL PROTECTED]
> > >> 
> > >> Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > >> San Diego, California-- Mailing list and
> > web hosting services
> > >>
> >
> -
> > >> To REMOVE yourself from this mailing list, send
> > an E-Mail message
> > >> to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and 
> > >in
> > >> the message BODY, include a line containing:
> > UNSUB ORACLE-L
> > >> (or the name of mailing list you want to be
> > removed from).  You 
> > >may
> > >> also send the HELP command for other information
> > (like subscribing).
> > >> -- 
> > >> Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > >> -- 
> > >> Author: 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.com
> > >-- 
> > >Author: Lyndon Tiu
> > >  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 PRO

Re: Export from Oracle 8 to Oracle 7

2002-12-04 Thread Barbara Baker

David:
You always want to use the older export utility when exporting from an older DB version, and use the new import untility to import into the newer database.
To export from an 8.1.7 database, use the export utility from the version 7 database and export using a link to the new database (exp sys/pwd@linkname)
 
I've done this from an 8.1.7 database into a 7.3.4 database.  Don't know that it will work with 7.1.4, but you can try.
Good luck!
Barb
(feel free to call at 303-892-5384)
 "Bartolo, David" <[EMAIL PROTECTED]> wrote:
Hi allCan I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1?Is there a setting in the export utility to be backward compatible with V7?ThanksDavid-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bartolo, DavidINET: [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).Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Cornio, Georgette Ms USACFSC

Title: RE: Are Oracle courses required for Oracle Certification now?



 
I 
have used the service level stuff also, but wanted 
to figure out the DOS Sqlplus stuff,
 so if there is a problem with the 
database,
 and need to do a startup mount or a recovery,
 or do all those nice command level stuff that was in 
svrmgr,
 I have NO idea how you would do those from the service 
level.
 

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 
  16:59To: Multiple recipients of list ORACLE-LSubject: 
  RE: Are Oracle courses required for Oracle Certification 
  now?
  if the DOS command prompt doesn't work, try starting it at the 
  services level. 
  -Original Message- From: 
  Cornio, Georgette Ms USACFSC [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, December 04, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Are Oracle courses required for Oracle Certification 
  now? 
  How do you startup & shutdown the database on NT/W2K 
  ? 
  As I am able to, from the DOS Command Prompt 
  set oracle_sid=orcl sqlplus 
  /nolog connect / as sysdba startup pfile=initorcl.ora or shutdown immediate 
  Just fine, at least with O 9.2 
  -Original Message- Sent: 
  Wednesday, December 04, 2002 14:10 To: Multiple 
  recipients of list ORACLE-L 
  This is unfortunate or maybe just it's just an urban 
  legend? 
  Hands on training, may it be $$$ or self taught at home is 
  necessary. But $$$ is definitely not a requirement. 
  I use Oracle at work and do more Oracle at home for my certs. 
  I am able to log-in to Oracle on Linux and Solaris. 
  Oracle WinNT/2K is another story since 
  you cannot really use: 
  sqlplus /nolog connect / as 
  sysdba startup 
  as you would on Unix. Maybe this is what ticked the instructor 
  off - a bunch of Unix Oracle 
  guys can't log into Oracle on NT? 
  -- Lyndon Tiu 
  Quoting DENNIS WILLIAMS 
  <[EMAIL PROTECTED]>: 
  > My instructor in a recent Oracle Education class said 
  that there were a > couple of smart alecs that 
  caused quite a stir within Oracle. After > 
  receiving their OCP, they couldn't log into a database, and claimed it 
  was > because they had never actually used Oracle. 
  The instructor indicated that > the new requirement 
  (9i I believe) would require you to take at least one > class. I asked "do you mean everyone that takes a class from you 
  will be > logging on". He just grinned. 
  > Dennis Williams > DBA, 
  40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > 
  > > -Original 
  Message- > Sent: Wednesday, December 04, 2002 
  11:25 AM > To: Multiple recipients of list 
  ORACLE-L > > 
  > Hey people! >  
  > A friend of mine was just asking me about getting 
  Oracle certified (I > completed the Oracle 8i 
  cerfication exams last year), > he told me that to 
  his knowledge Oracle requires that you've done Oracle > courses before you can be certified now. > I knew nothing about this, but can't believe Oracle would so 
  blatantly make > you take 
  their over-priced courses. >  > But maybe I'm just naive. >  
  > Cheers, > Kieran 
  Murray > CardBASE Technologies Limited® 
  > BIM House > Crofton 
  Road > Dun Laoghaire > 
  Co Dublin >  >  > -- > 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- 
  > Author: Kieran Murray >   INET: [EMAIL PROTECTED] > > Fat City Network 
  Services    -- 858-538-5051 http://www.fatcity.com > San 
  Diego, California    -- Mailing list 
  and web hosting services > 
  - 
  > To REMOVE yourself from this mailing list, send an 
  E-Mail message > to: [EMAIL PROTECTED] (note 
  EXACT spelling of 'ListGuru') and in > the message 
  BODY, include a line containing: UNSUB ORACLE-L > 
  (or the name of mailing list you want to be removed from).  You 
  may > also send the HELP command for other 
  information (like subscribing). > -- 
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  > -- > Author: 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.com -- 
  Author: Lyndon Tiu   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services

RE: Recipe for application design to run on RAC

2002-12-04 Thread Jamadagni, Rajendra

Title: RE: Recipe for application design to run on RAC





Greg,


FantasyFootball is a different beast and is not hosted on this database. This one deals with live scores and the bottomline ... .

There are only few tables that are shared by both schema, 50% ownership .. hasn't happened yet. We used to see huge global CR issues, but then it turned out to be a AIX issue and Oracle has a workaround for that  (most unlikely parameter db_file_multiblock_read_count needs to be reduced). 

So far what we have seen is undeniably there is global cache traffic, but it isn't like some of our other instances. This way, each side of RAC gets a nice powerful machine to itself, all the resources to itself and is capable of handling at-least 5 times the load we put on it before it breaks a sweat.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!
-Original Message-
From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Recipe for application design to run on RAC



So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-)   I guess thats what I get when I picked a group of guys that are all on the injured reserve

Seriously though--What if 50% of the blocks of data for schema1 are "owned" by db2? do you eventually see where ownership is transferred to the "active" node, reduced cache fusion activity and then transfer of blocks?  Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2

thanks!
Greg



*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.*1

RE: Are Oracle courses required for Oracle Certification now?

I certainly did not get anything after each exam, only after each level. I got
the OCA level certificate and a letter from some Veep two weeks after I
completed the second 9i exam (which I'm happy to say I did before the Sept. 1,
2002 deadline !!!).

-- 
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> Lyndon - I have completed 2 of the 5 Oracle8i exams. 
> 
> Hey - when I took each exam, the testing organization says that I should
> receive something from Oracle within a couple of weeks. Got nothing. Should
> I be worried?
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 1:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey William,
> 
> Why are you 40% OCP - does this mean you are an OCA? When did you take your
> very
> first 9i certification exam? If you took it before Sept. 1, 2002, the
> you're
> a
> 50% OCP.
> 
> -- 
> Lyndon Tiu
> 
> 
> Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> 
> > My instructor in a recent Oracle Education class said that there were a
> > couple of smart alecs that caused quite a stir within Oracle. After
> > receiving their OCP, they couldn't log into a database, and claimed it
> was
> > because they had never actually used Oracle. The instructor indicated
> that
> > the new requirement (9i I believe) would require you to take at least one
> > class. I asked "do you mean everyone that takes a class from you will be
> > logging on". He just grinned.
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, December 04, 2002 11:25 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hey people!
> >  
> > A friend of mine was just asking me about getting Oracle certified (I
> > completed the Oracle 8i cerfication exams last year),
> > he told me that to his knowledge Oracle requires that you've done Oracle
> > courses before you can be certified now.
> > I knew nothing about this, but can't believe Oracle would so blatantly
> make
> > you take their over-priced courses.
> >  
> > But maybe I'm just naive.
> >  
> > Cheers,
> > Kieran Murray
> > CardBASE Technologies Limited® 
> > BIM House
> > Crofton Road 
> > Dun Laoghaire
> > Co Dublin 
> >  
> >  
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Kieran Murray
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 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.com
> -- 
> Author: Lyndon Tiu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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 o

RE: Are Oracle courses required for Oracle Certification now?

When you say at least with O 9.2, does this mean we cannot do this in 8i ?

We have 8i on EnTee and WinTuKee.

Thanks.

-- 
Lyndon Tiu


Quoting "Cornio, Georgette Ms USACFSC" <[EMAIL PROTECTED]>:

> 
> How do you startup & shutdown the database on NT/W2K ?
> 
> As I am able to, from the DOS Command Prompt
> 
> set oracle_sid=orcl
> sqlplus /nolog
> connect / as sysdba
> startup pfile=initorcl.ora or shutdown immediate
> 
> Just fine, at least with O 9.2
> 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 14:10
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is unfortunate or maybe just it's just an urban legend?
> 
> Hands on training, may it be $$$ or self taught at home is necessary. But
> $$$ is
> definitely not a requirement.
> 
> I use Oracle at work and do more Oracle at home for my certs. I am able to
> log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story
> since
> you cannot really use:
> 
> sqlplus /nolog
> connect / as sysdba
> startup
> 
> as you would on Unix. Maybe this is what ticked the instructor off - a
> bunch
> of
> Unix Oracle guys can't log into Oracle on NT?
> 
> -- 
> Lyndon Tiu
> 
> 
> Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> 
> > My instructor in a recent Oracle Education class said that there were a
> > couple of smart alecs that caused quite a stir within Oracle. After
> > receiving their OCP, they couldn't log into a database, and claimed it
> was
> > because they had never actually used Oracle. The instructor indicated
> that
> > the new requirement (9i I believe) would require you to take at least one
> > class. I asked "do you mean everyone that takes a class from you will be
> > logging on". He just grinned.
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, December 04, 2002 11:25 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hey people!
> >  
> > A friend of mine was just asking me about getting Oracle certified (I
> > completed the Oracle 8i cerfication exams last year),
> > he told me that to his knowledge Oracle requires that you've done Oracle
> > courses before you can be certified now.
> > I knew nothing about this, but can't believe Oracle would so blatantly
> make
> > you take their over-priced courses.
> >  
> > But maybe I'm just naive.
> >  
> > Cheers,
> > Kieran Murray
> > CardBASE Technologies Limited® 
> > BIM House
> > Crofton Road 
> > Dun Laoghaire
> > Co Dublin 
> >  
> >  
> > -- 

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Kieran Murray
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 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.com
> -- 
> Author: Lyndon Tiu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Cornio, Georgette Ms USACFSC
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --

RE: Recipe for application design to run on RAC

I know I know (he says jumping up and down) Just did the 9i New Features
class.
 
The answer is "lazy dynamic remastering". Over time, resources are gradually
moved to the instance that is using them.
 
More quotes from the manual:
   Should an instance leave the group, the background processes only
remaster resources from the departing instance.
   Similarly, when a new instance joins the group, the resources are
gradually remastered, adapting to the cluster workload.


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

-Original Message-
Sent: Wednesday, December 04, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L


So when I access the fantasy football league on the espn web site-I go to
schema2 because my team(s) are losing :-)   I guess thats what I get
when I picked a group of guys that are all on the injured reserve
 
 
Seriously though--What if 50% of the blocks of data for schema1 are "owned"
by db2? do you eventually see where ownership is transferred to the "active"
node, reduced cache fusion activity and then transfer of blocks?  Do the
users on schema1 have to use the data on schema2 at all? I'm trying to see
if not only are the users logically partitioned-but if your schemas offer
any data partitioning to align with the schema1 and schema2
 
thanks!
Greg
 

-Original Message-
Sent: Wednesday, December 04, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L



H... it is probably not an good example but we too have a (couple of)
mission critical app (affects on air production) running on 9i RAC. One of
which has two major schema. We logically partitioned the application such
that, for two groups of people 9accessing one schema each) we gave them a
preference. 

Schema1 users have tns entry for db1 and fail over to db2 
Schema2 users have a preference for db2 with a fail over to db1 

This effectively allows us to do load balance, they don't share too much
data, so traffic through interconnect is manageable. If need be, we just
shutoff listener on one side, and everyone fails over to the other side
while we can perform maintenance. All their applications are written in VB,
JAVA so they handle fail over from within application.

None of the people involved in the design worried about which side of RAC
they will be on and how the DML activity affects etc etc. They designed a
plain application with a good design and it is working fine.

Like I mentioned this is not a good example ... but this is how we did it in
one of our major application. 
Raj 
__ 
Rajendra Jamadagni  MIS, ESPN Inc. 
Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art! 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: ORA-1653: unable to extend table - Why?

Kirti,

Thanks for suggesting the Note, I'm reading it now.  I tried replying to you
directly but my thank you was blocked by your company's spam filter.  I'm
really curious to know what key word flagged it as spam.  Oracle?

Jay

-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L

freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
>

Experiences with global temp tables

2002-12-04 Thread Rick_Cale

Hi All,

Oracle 8.1.6, NT 4.0, Forms/Reports 6i,

Has anyone had any trouble using global temp tables in above environment or
elsewhere where it cause Oracle to complete lock up. Only way
out was to kill oracle.exe...not a good thing. I have found some postings
on MetaLink that may be related supposely fixed in 9i.
Comments please!

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Igor Neyman

Dennis,

IIRC you receive certificate from Oracle only after completion of all 5
exams.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 4:13 PM


Lyndon - I have completed 2 of the 5 Oracle8i exams.

Hey - when I took each exam, the testing organization says that I should
receive something from Oracle within a couple of weeks. Got nothing. Should
I be worried?

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


-Original Message-
Sent: Wednesday, December 04, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L


Hey William,

Why are you 40% OCP - does this mean you are an OCA? When did you take your
very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're
a
50% OCP.

--
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey people!
>
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>
> But maybe I'm just naive.
>
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited®
> BIM House
> Crofton Road
> Dun Laoghaire
> Co Dublin
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: 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.com
--
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

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

Re: how to modify query

2002-12-04 Thread Mark Richard

Harvinder,

Let's see what we can come up with:

insert into t_suspended_txn
select 'A', 'B'
from dual
where exists (select col1 from t_suspended_txn where col2 = 'A')

Although I don't honestly know if "dual" exists in SQL Server (in Oracle
it's a single row, single column table - you could easily create a "dual"
in SQL Server), otherwise:

insert into t_suspended_txn
select distinct 'A', 'B'
from t_suspended_txn where col2 = 'A'

This would work but might do an unnecessarily large sort if t_suspended_txn
contains many rows, otherwise:

insert into t_suspended_txn
select 'A', 'B'
from t_suspended_txn where col2 = 'A' and rownum = 1

Although again, I don't know if SQL Server supports "rownum" as a pseudo
column.

Hopefully I've given enough ideas to find something that works though.

Cheers,
 Mark.




   
   
"Harvinder Singh"  
   
   
aTech.com>  cc:
   
Sent by:Subject: how to modify query   
   
[EMAIL PROTECTED]   
   
   
   
   
   
05/12/2002 06:04   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Hi,

Following code works in sql server but IF NOT EXISTS dosn't work in oracle
how can we modify this code so that it should work on both sql server and
oracle

 if not exists (
select
col1
from
t_suspended_txn
where
col2  ='A'
begin
insert into t_suspended_txn
select  'A' ,  'B'
end


Thanks
--Harvinder


<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Richard
  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: Are Oracle courses required for Oracle Certification now?

Hmmm. So it's a config issue then. I will certainly poke around a bit more. See
what happens if you send a Unix person to do a Windows job : >

I'm 100% sure though that setting up Oracle on NT to work like Oracle onUnix is
different so it is still possible that a bunch of OCP Unix Oracle DBA's could
not setup a W2K Oracle database properly - tainting the OCP name in the process,
ouch.

-- 
Lyndon Tiu


Quoting Alan Davey <[EMAIL PROTECTED]>:

> Hi Lyndon,
> 
> Well I don't know about your setup, but I can connect just fine with the
> connect string you listed below on Win2K, Oracle 9.2.
> 
> -- 
> 
> Alan Davey
> [EMAIL PROTECTED]
> 212-604-0200  x106
> 
> 
> On 12/4/2002 2:09 PM, Lyndon Tiu <[EMAIL PROTECTED]> wrote:
> >This is unfortunate or maybe just it's just an urban legend?
> >
> >Hands on training, may it be $$$ or self taught at home is necessary. 
> >But $$$ is
> >definitely not a requirement.
> >
> >I use Oracle at work and do more Oracle at home for my certs. I am 
> >able to
> >log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another 
> >story since
> >you cannot really use:
> >
> >sqlplus /nolog
> >connect / as sysdba
> >startup
> >
> >as you would on Unix. Maybe this is what ticked the instructor off 
> >- a bunch of
> >Unix Oracle guys can't log into Oracle on NT?
> >
> >-- 
> >Lyndon Tiu
> >
> >
> >Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> >
> >> My instructor in a recent Oracle Education class said that there 
> >were a
> >> couple of smart alecs that caused quite a stir within Oracle. After
> >> receiving their OCP, they couldn't log into a database, and claimed 
> >it was
> >> because they had never actually used Oracle. The instructor indicated 
> >that
> >> the new requirement (9i I believe) would require you to take at 
> >least one
> >> class. I asked "do you mean everyone that takes a class from you 
> >will be
> >> logging on". He just grinned.
> >> Dennis Williams
> >> DBA, 40%OCP
> >> Lifetouch, Inc.
> >> [EMAIL PROTECTED] 
> >> 
> >> 
> >> -Original Message-
> >> Sent: Wednesday, December 04, 2002 11:25 AM
> >> To: Multiple recipients of list ORACLE-L
> >> 
> >> 
> >> Hey people!
> >>  
> >> A friend of mine was just asking me about getting Oracle certified 
> >(I
> >> completed the Oracle 8i cerfication exams last year),
> >> he told me that to his knowledge Oracle requires that you've done 
> >Oracle
> >> courses before you can be certified now.
> >> I knew nothing about this, but can't believe Oracle would so blatantly 
> >make
> >> you take their over-priced courses.
> >>  
> >> But maybe I'm just naive.
> >>  
> >> Cheers,
> >> Kieran Murray
> >> CardBASE Technologies Limited® 
> >> BIM House
> >> Crofton Road 
> >> Dun Laoghaire
> >> Co Dublin 
> >>  
> >>  
> >> -- 
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> -- 
> >> Author: Kieran Murray
> >>   INET: [EMAIL PROTECTED]
> >> 
> >> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >> San Diego, California-- Mailing list and web hosting services
> >> -
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
> >in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from).  You 
> >may
> >> also send the HELP command for other information (like subscribing).
> >> -- 
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> -- 
> >> Author: 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.com
> >-- 
> >Author: Lyndon Tiu
> >  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-

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Nick Wagner

Title: RE: Are Oracle courses required for Oracle Certification now?





if the DOS command prompt doesn't work, try starting it at the services level. 


-Original Message-
From: Cornio, Georgette Ms USACFSC
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Are Oracle courses required for Oracle Certification now?




How do you startup & shutdown the database on NT/W2K ?


As I am able to, from the DOS Command Prompt


set oracle_sid=orcl
sqlplus /nolog
connect / as sysdba
startup pfile=initorcl.ora or shutdown immediate


Just fine, at least with O 9.2




-Original Message-
Sent: Wednesday, December 04, 2002 14:10
To: Multiple recipients of list ORACLE-L



This is unfortunate or maybe just it's just an urban legend?


Hands on training, may it be $$$ or self taught at home is necessary. But
$$$ is
definitely not a requirement.


I use Oracle at work and do more Oracle at home for my certs. I am able to
log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story
since
you cannot really use:


sqlplus /nolog
connect / as sysdba
startup


as you would on Unix. Maybe this is what ticked the instructor off - a bunch
of
Unix Oracle guys can't log into Oracle on NT?


-- 
Lyndon Tiu



Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:


> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cornio, Georgette Ms USACFSC
  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-Ma

Re: Oracle 9iR2 on Red Hat 8.0

Thanks Sean.

I installed 9iR2 on both my laptop and a desktop, both
running RH 8.0.

Pretty straightforward, except for the usual failure in linking
intermedia.  I would have thought they would fix that by now.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 12/04/2002 09:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Oracle 9iR2 on Red Hat 8.0



> If you've installed Oracle 9i on RH 8.0, please let me know.
> 
> Also, please let me know of any difficulties and workarounds
> you may have encountered.
> 
> Just put a new 40Gig HD in my laptop, and wondering if I
> can install RH 8.0, or should use 7.2.

Jared:

I put together some notes when I installed 9.2.0 on RH7.3.  I think that 
RH8 is probably similar.

http://iheavy.com/~shull/files/ora9i_inst_notes.txt

HTH,
Sean

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Boris Dali

Alan, I think what Lyndon meant is this
SQLNET.AUTHENTICATION_SERVICES thing on MS Win that
toggles your ability to connect with the syntax
described. Comment it out and you might see something
like ORA-1031

 --- Alan Davey <[EMAIL PROTECTED]> wrote: > Hi
Lyndon,
> 
> Well I don't know about your setup, but I can
> connect just fine with the connect string you listed
> below on Win2K, Oracle 9.2.
> 
> -- 
> 
> Alan Davey
> [EMAIL PROTECTED]
> 212-604-0200  x106
> 
> 
> On 12/4/2002 2:09 PM, Lyndon Tiu
> <[EMAIL PROTECTED]> wrote:
> >This is unfortunate or maybe just it's just an
> urban legend?
> >
> >Hands on training, may it be $$$ or self taught at
> home is necessary. 
> >But $$$ is
> >definitely not a requirement.
> >
> >I use Oracle at work and do more Oracle at home for
> my certs. I am 
> >able to
> >log-in to Oracle on Linux and Solaris. Oracle
> WinNT/2K is another 
> >story since
> >you cannot really use:
> >
> >sqlplus /nolog
> >connect / as sysdba
> >startup
> >
> >as you would on Unix. Maybe this is what ticked the
> instructor off 
> >- a bunch of
> >Unix Oracle guys can't log into Oracle on NT?
> >
> >-- 
> >Lyndon Tiu
> >
> >
> >Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> >
> >> My instructor in a recent Oracle Education class
> said that there 
> >were a
> >> couple of smart alecs that caused quite a stir
> within Oracle. After
> >> receiving their OCP, they couldn't log into a
> database, and claimed 
> >it was
> >> because they had never actually used Oracle. The
> instructor indicated 
> >that
> >> the new requirement (9i I believe) would require
> you to take at 
> >least one
> >> class. I asked "do you mean everyone that takes a
> class from you 
> >will be
> >> logging on". He just grinned.
> >> Dennis Williams
> >> DBA, 40%OCP
> >> Lifetouch, Inc.
> >> [EMAIL PROTECTED] 
> >> 
> >> 
> >> -Original Message-
> >> Sent: Wednesday, December 04, 2002 11:25 AM
> >> To: Multiple recipients of list ORACLE-L
> >> 
> >> 
> >> Hey people!
> >>  
> >> A friend of mine was just asking me about getting
> Oracle certified 
> >(I
> >> completed the Oracle 8i cerfication exams last
> year),
> >> he told me that to his knowledge Oracle requires
> that you've done 
> >Oracle
> >> courses before you can be certified now.
> >> I knew nothing about this, but can't believe
> Oracle would so blatantly 
> >make
> >> you take their over-priced courses.
> >>  
> >> But maybe I'm just naive.
> >>  
> >> Cheers,
> >> Kieran Murray
> >> CardBASE Technologies Limited® 
> >> BIM House
> >> Crofton Road 
> >> Dun Laoghaire
> >> Co Dublin 
> >>  
> >>  
> >> -- 
> >> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >> -- 
> >> Author: Kieran Murray
> >>   INET: [EMAIL PROTECTED]
> >> 
> >> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> >> San Diego, California-- Mailing list and
> web hosting services
> >>
>
-
> >> To REMOVE yourself from this mailing list, send
> an E-Mail message
> >> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and 
> >in
> >> the message BODY, include a line containing:
> UNSUB ORACLE-L
> >> (or the name of mailing list you want to be
> removed from).  You 
> >may
> >> also send the HELP command for other information
> (like subscribing).
> >> -- 
> >> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >> -- 
> >> Author: 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.com
> >-- 
> >Author: Lyndon Tiu
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> >San Diego, California-- Mailing list and
> web hosting services
>
>-
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and 
> >in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from).  You may
> >also send the HELP command for other information
> (like subscribing).
> >
> >
> >
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Alan Davey
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Se

RE: Recipe for application design to run on RAC

2002-12-04 Thread Loughmiller, Greg

Title: RE: Recipe for application design to run on RAC



So 
when I access the fantasy football league on the espn web site-I go to schema2 
because my team(s) are losing :-)   
I guess thats what I get when I picked a group of guys 
that are all on the injured reserve
 
 
Seriously though--What if 50% of the blocks of data for 
schema1 are "owned" by db2? do you eventually see where ownership is transferred 
to the "active" node, reduced cache fusion activity and then transfer of 
blocks?  Do the users on schema1 have to use the data on schema2 at all? 
I'm trying to see if not only are the users logically partitioned-but if your 
schemas offer any data partitioning to align with the schema1 and 
schema2
 
thanks!
Greg
 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 
  2002 2:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Recipe for application design to run on 
  RAC
  H... it is probably not an good example but we too have a 
  (couple of) mission critical app (affects on air production) running on 9i 
  RAC. One of which has two major schema. We logically partitioned the 
  application such that, for two groups of people 9accessing one schema each) we 
  gave them a preference. 
  Schema1 users have tns entry for db1 and fail over to 
  db2 Schema2 users have a preference for db2 with a 
  fail over to db1 
  This effectively allows us to do load balance, they don't 
  share too much data, so traffic through interconnect is manageable. If need 
  be, we just shutoff listener on one side, and everyone fails over to the other 
  side while we can perform maintenance. All their applications are written in 
  VB, JAVA so they handle fail over from within application.
  None of the people involved in the design worried about which 
  side of RAC they will be on and how the DML activity affects etc etc. They 
  designed a plain application with a good design and it is working 
  fine.
  Like I mentioned this is not a good example ... but this is 
  how we did it in one of our major application. Raj __ Rajendra Jamadagni  
      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any 
  opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
  QOTD: Any clod can have facts, but having an opinion 
  is an art!

RE: Ora 29540 error

2002-12-04 Thread Mercadante, Thomas F

Randy,

I don't think the JVM is missing.

try installing the $ORACLE_HOME/plsql/jlib/plsql.jar file using sqlloader.
the class files from this file are what are missing.

hope this helps

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Wednesday, December 04, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L

Install the JVM...see MetaLink Note:156477.1

Jeff Herrick

On Wed, 4 Dec 2002, Randy Pace wrote:

>
> I get the following when trying to use the utl_tcp package on 8.1.7
> database.
>
>
> The following error has occurred:
>
> ORA-29540: class oracle/plsql/net/TCPConnection does not exist
> ORA-06512: at "SYS.UTL_TCP", line 537
> ORA-06512: at "SYS.UTL_TCP", line 199
> ORA-06512: at "SYS.UTL_SMTP", line 102
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
> ORA-06512: at line 5
>
> What is missing from the database in order for that to run?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  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).

Something that might be of use

2002-12-04 Thread Stephen Lee


We often need to refresh test and development databases with exports that
have extent sizing a lot bigger that what we want.  In test and ESPECIALLY
dev, space and file system availability often require us to just  get
something working without regard for performance.  In these cases, extent
sizing in the exports often prevents us from loading even a row-less import
into the test/dev database.  The following C program was written to deal
with those situations.  I have used it enough that I think I can go ahead
and toss it out to the world.  The program is functional but not necessarily
elegant.  Of course, no guarantees about anything are made.  If you make any
improvements, I would be most appreciative if you sent them.

== SNIP == SNIP == SNIP == SNIP == SNIP == SNIP
==

/***
** This was hastily written by Stephen Lee because we've  **
** been needing something like this real bad for a while. **
** If you leave the section that opens the files commented,   **
** then the syntax would be something like:   **
** modify_extents < dumpfile > modified_dump_file **
****
** Even though this has been tested against enough exports**
** that it seems to work OK, I do have some nagging doubts**
** about how universally compatible it is.  I do make some**
** assumptions about the text in an export dump file and  **
** about the size of a character in that file.**
****
** This program changes the INITIAL and NEXT extent size  **
** specification in the dump file to a fixed size.  You can   **
** edit this value in the program, prior to compiling it. **
****
** It is acknowledged that this is a rather bare-bones**
** program, but it needed to written in a hurry.  Enhancement **
** of the program is left as an exercise for the reader.  **
***/

#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 
/** Include the kitchen sink too **/

/* BEGIN MAIN **/

int main (int argc, char **argv, char **envp) {

int in, out, bytes_read, diddle, match = 0, create = 0;
char read_buf[57344], write_buf[65536], diddler;

// Note that the following strings contain a space. That is
important.
char *s0 = "CREATE ";
char *s1 = "ALTER ";
char *s8 = "INITIAL ";
char *s9 = "NEXT ";
int s0_len = strlen(s0);
int s1_len = strlen(s1);
int s8_len = strlen(s8);
int s9_len = strlen(s9);
int i, j0, j1, j8, j9, x, skip = 0;

/***

** Un-comment this section and use the open statements if you want to
hard-code
** the paths, or if you want to use something like argv[1] and argv[2].

if( (in = open("/export/oracle/admin/FTLP/exp/test.dmp", O_RDONLY))
< 0 ) {
printf("\nFailed to open input file.\n");
return 1;
}

if( (out = open("/export/oracle/admin/FTLP/exp/modified.dmp",
O_RDWR|O_CREAT|O_TRUNC)) < 0 ) {
printf("\nFailed to open output file.\n");
return 1;
}
fchmod(out, 0600);


/

/* Use the dup commands if you want to use command-line redirection as
in:
 * program_name < input_file > output_file ***/
in = dup(0);
out = dup(1);

/**
 ** The following loop reads bytes from the input file and copies them to
the output file.
 ** While it is doing this, it is looking for matches to the strings defined
in s0, s1, etc.
 ** S0 and s1 define when we have found the beginning of a CREATE or ALTER
command and
 ** should start looking for the strings INITIAL and NEXT.  When those
strings are found,
 ** and we verify that they are followed by a number, then the numeric data
is replaced by
 ** the new characters.  Then any following numeric data is skipped until we
get to the
 ** next space.  We write the output buffer every time we read a new input
buffer.
 ** We continue this until the entire input file has been read.
 ** The reason for the CREATE and ALTER searches is to throw in a quart or
two of paranoia.
 ** This requires that both strings CREATE/ALTER and INITIAL/NEXT to be
present.  I suppose
 ** there some chance that we could have these strings present, but the line
NOT be a line
 ** that should be modified.  But I think the chance is so small as to be
insignificant.
**/

diddle = j0 = j1 = j8 =

RE: Are Oracle courses required for Oracle Certification now?

Lyndon - I have completed 2 of the 5 Oracle8i exams. 

Hey - when I took each exam, the testing organization says that I should
receive something from Oracle within a couple of weeks. Got nothing. Should
I be worried?

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


-Original Message-
Sent: Wednesday, December 04, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L


Hey William,

Why are you 40% OCP - does this mean you are an OCA? When did you take your
very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're
a
50% OCP.

-- 
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Cornio, Georgette Ms USACFSC


How do you startup & shutdown the database on NT/W2K ?

As I am able to, from the DOS Command Prompt

set oracle_sid=orcl
sqlplus /nolog
connect / as sysdba
startup pfile=initorcl.ora or shutdown immediate

Just fine, at least with O 9.2



-Original Message-
Sent: Wednesday, December 04, 2002 14:10
To: Multiple recipients of list ORACLE-L


This is unfortunate or maybe just it's just an urban legend?

Hands on training, may it be $$$ or self taught at home is necessary. But
$$$ is
definitely not a requirement.

I use Oracle at work and do more Oracle at home for my certs. I am able to
log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story
since
you cannot really use:

sqlplus /nolog
connect / as sysdba
startup

as you would on Unix. Maybe this is what ticked the instructor off - a bunch
of
Unix Oracle guys can't log into Oracle on NT?

-- 
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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.com
-- 
Author: Lyndon Tiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cornio, Georgette Ms USACFSC
  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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Alan Davey

Hi Lyndon,

Well I don't know about your setup, but I can connect just fine with the connect 
string you listed below on Win2K, Oracle 9.2.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 12/4/2002 2:09 PM, Lyndon Tiu <[EMAIL PROTECTED]> wrote:
>This is unfortunate or maybe just it's just an urban legend?
>
>Hands on training, may it be $$$ or self taught at home is necessary. 
>But $$$ is
>definitely not a requirement.
>
>I use Oracle at work and do more Oracle at home for my certs. I am 
>able to
>log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another 
>story since
>you cannot really use:
>
>sqlplus /nolog
>connect / as sysdba
>startup
>
>as you would on Unix. Maybe this is what ticked the instructor off 
>- a bunch of
>Unix Oracle guys can't log into Oracle on NT?
>
>-- 
>Lyndon Tiu
>
>
>Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
>
>> My instructor in a recent Oracle Education class said that there 
>were a
>> couple of smart alecs that caused quite a stir within Oracle. After
>> receiving their OCP, they couldn't log into a database, and claimed 
>it was
>> because they had never actually used Oracle. The instructor indicated 
>that
>> the new requirement (9i I believe) would require you to take at 
>least one
>> class. I asked "do you mean everyone that takes a class from you 
>will be
>> logging on". He just grinned.
>> Dennis Williams
>> DBA, 40%OCP
>> Lifetouch, Inc.
>> [EMAIL PROTECTED] 
>> 
>> 
>> -Original Message-
>> Sent: Wednesday, December 04, 2002 11:25 AM
>> To: Multiple recipients of list ORACLE-L
>> 
>> 
>> Hey people!
>>  
>> A friend of mine was just asking me about getting Oracle certified 
>(I
>> completed the Oracle 8i cerfication exams last year),
>> he told me that to his knowledge Oracle requires that you've done 
>Oracle
>> courses before you can be certified now.
>> I knew nothing about this, but can't believe Oracle would so blatantly 
>make
>> you take their over-priced courses.
>>  
>> But maybe I'm just naive.
>>  
>> Cheers,
>> Kieran Murray
>> CardBASE Technologies Limited® 
>> BIM House
>> Crofton Road 
>> Dun Laoghaire
>> Co Dublin 
>>  
>>  
>> -- 
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> -- 
>> Author: Kieran Murray
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting services
>> -
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from).  You 
>may
>> also send the HELP command for other information (like subscribing).
>> -- 
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> -- 
>> Author: 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.com
>-- 
>Author: Lyndon Tiu
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alan Davey
  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: Single-task message waits

2002-12-04 Thread Jesse, Rich

Hey Cary,

No magic bullet?  I was afraid you were going to say that.  :)

I see that there are some parsing issues from the first of many 10046
traces.  Most of these high-parsing statements are generated by Oracle when
a Context index is used in a query.  The good news, if TKPROF output can be
believed, is that the total time spent in all parses is 35 seconds out of 52
minutes elapsed, so I hadn't planned on spending any more time here.

As for the one-row-at-a-time manipulation part, well...  Implicit cursors
within cursors within cursors.  We've removed a few where we could, but
unfortunately a rewrite probably isn't going to happen for this project.
We're still learning to be good SQL coders while dealing with crappy data
layouts from the 80s.

Thanks for your input!  And thanks for the 10046 paper on hotsos.com!  :)
Rich


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

> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 12:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> Rich,
> 
> Well, at least we've cleared up the "whether." Now the 
> question turns to
> the "why."
> 
> Once you have identified a program's dominant response time 
> contributor,
> solving any optimization problem degenerates to a very simple 
> strategy:
> 
> 1. Reduce the number of times the dominant contributor's services are
> required.
> 2. Reduce the duration per service call of the dominant contributor.
> 
> I expect that #2 will be difficult to do in this case, because I'd
> expect that the single-task driver is probably the fastest conceivable
> way that two pieces of client-server code can communicate 
> (they're after
> all in the same executable). Your leverage is probably #1. 
> It's the old
> adage:
> 
>   Q: What's the fastest way to do X?
> 
>   A: Don't.
> 
> Find out whether your process is making more database calls than it
> needs to be making. Investigate the usual suspects: SQL that 
> doesn't use
> bind variables and therefore has to be parsed more often than 
> it should
> be parsed, one-row-at-a-time manipulation instead of using arrays and
> bulk features, and so on.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
> 
> 
> -Original Message-
> Rich
> Sent: Wednesday, December 04, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> Hey Cary,
> 
> "Yes" and "Yes".  Which brings me back to my original 
> question:  How do
> I go
> about tracking down "single-task message" waits?
> 
> Thanks!
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI
> USA
> 
> > -Original Message-
> > From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 04, 2002 10:14 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Single-task message waits
> > 
> > 
> > If...
> > 
> > 1) you're collecting time consumption data for ONLY the 
> > session you care
> > about, AND
> > 
> > 2) you're collecting the data for a time interval [t0,t1] 
> > that includes
> > ONLY response time that you care about eliminating,
> > 
> > ...then the waits are worth investigating.
> > 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Export from Oracle 8 to Oracle 7

2002-12-04 Thread Bartolo, David

Hi all

Can I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1?
Is there a setting in the export utility to be backward compatible with V7?

Thanks
David

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bartolo, 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: ORA-1653: unable to extend table - Why?

1895

-Original Message-
Sent: Wednesday, December 04, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L

What is the average row length?

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L

freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> w

RE: ORA-1653: unable to extend table - Why?

2002-12-04 Thread Khedr, Waleed

What is the average row length?

Waleed

-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L

freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn

Slightly Off Topic Question

2002-12-04 Thread KENNETH JANUSZ




I need some help running an Oracle education 
CDROM.
 
I am taking the 9i Certification course via CDROM for 
1Z0-007.
 
I attempt to start the installed CDROM with Start/ Run.  
I go to the D: drive and it automatically selects autorun.exe.  When I hit 
run is asks if I want help?  If I say no, then nothing happens.  If I 
say yes it goes to the Duckware web site so I can download winopen.exe.  I 
downloaded this file.  So how do I use winopen.exe?  There are no 
instructions in the literature on how do this.  Also, how do I use I.E. in 
kiosk mode?  I tried the instructions from Duckware and it didn't 
work.
 
I'm using I.E. 6.0.
 
Thanks much and have a good day,
 
Ken Janusz

how to modify query

2002-12-04 Thread Harvinder Singh

Title: Ora 29540 error



Hi,
 
Following code works in sql server but IF NOT EXISTS dosn't work in 
oracle
how 
can we modify this code so that it should work on both sql server and 
oracle  if not exists 
(
select 
col1
from 
t_suspended_txn 
where col2  ='A'  begin
insert into 
t_suspended_txn
select  'A' ,  'B'  
end
 
Thanks
--Harvinder

RE:

2002-12-04 Thread Stephen Lee


I got to thinking a little more about this.

If you have an oraInventory directory under your product directory, I think
you need to back that one up too ... at least it wouldn't hurt.


-Original Message-
Sent: Wednesday, December 04, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L


I believe that is the easiest/cleanest way to restore from patches esp. when
you don't know what those patches contain.  
-Original Message- 
Sent: Tuesday, December 03, 2002 2:21 PM 
To: Multiple recipients of list ORACLE-L 


Gurus, 
I was just given a project to maintain a Computerized Maintenance 
Management System.  When I asked the companies support staff how to roll 
back patches in the backend Oracle Database (Ver. 8174), they said that 
there was no way to do this.  I'm guessing I could use logminer just incase 
a patch doesn't work.  Would this be a good solution, or are there other 
(better) ways of safeguarding myself when it comes to patching?  Obviously, 
I will be applying the patches to a test instance first, but I don't want 
to have to go back to restore from a backup if the patch causes unexpected 
issues. 
TIA! 


** 
Scott Stefick 
UNIX Systems Administrator 
Oracle Certified Professional DBA 
Wm. Rainey Harper College 
847.925.6130 
** 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
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.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Are Oracle courses required for Oracle Certification now?

This is unfortunate or maybe just it's just an urban legend?

Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is
definitely not a requirement.

I use Oracle at work and do more Oracle at home for my certs. I am able to
log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since
you cannot really use:

sqlplus /nolog
connect / as sysdba
startup

as you would on Unix. Maybe this is what ticked the instructor off - a bunch of
Unix Oracle guys can't log into Oracle on NT?

-- 
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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.com
-- 
Author: Lyndon Tiu
  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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Jeremy Pulcifer

Title: RE: Are Oracle courses required for Oracle Certification now?





> From: Kieran Murray [mailto:[EMAIL PROTECTED]]
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've 
> done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so 
> blatantly make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray


Why are you surprised? Remember that this program is run out of Oracle University. They've a vested interest in getting folks into their classes.

From : http://www.oracle.com/education/certification/


Hands-On Course Requirement 


Beginning September 1, 2002, Oracle University will require that all candidates pursuing the Oracle9i DBA Certified Professional credential must attend one instructor-led course either inclass or online to receive certified status. To meet the requirement, candidates must attend a course offered at an Oracle University center or at an Oracle Authorized Education Center or Partner.

RE: SLA Trigger/Procedure

Don't forget to handle connection attempts that hang and never return.

Jared





"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/03/2002 02:04 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: SLA Trigger/Procedure


I agree what is needed is something very generic that could monitor the
uptime of pretty much any process.  After giving this more thought and
always liking to keep things simple here is the direction I might 
eventually
head.  The logic below would result in a log file that shows all 
unscheduled
outage periods.  You would have to ensure it runs at regular intervals.

(NOT VERY PRETTY, BUT SIMPLE ENOUGH)

Files Required:

* Control file that has crontab like entries which define periods that are
either outages or times when database is expected to be running.

Script Workings:

* Run command/script which returns 0 or 1 (0=thingy not running, 1=thingy
running) use separate command/script to log into database, grep for 
process
etc...

If (( 0 ))
   check control file to see if thingy should be running
   if suppose to be running
   store time & trigger flag (cat time to flag file)
   if not suppose to be running
   if flag
  unscheduled outage was triggered but has rolled into an 
scheduled
outage period
  log start and end time for outage
  reset flag
   fi
   fi
else
   if flag 
  thingy is back up
  log start and end time for outage
  reset flag
   fi
fi
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Single-task message waits

2002-12-04 Thread Cary Millsap

Rich,

Well, at least we've cleared up the "whether." Now the question turns to
the "why."

Once you have identified a program's dominant response time contributor,
solving any optimization problem degenerates to a very simple strategy:

1. Reduce the number of times the dominant contributor's services are
required.
2. Reduce the duration per service call of the dominant contributor.

I expect that #2 will be difficult to do in this case, because I'd
expect that the single-task driver is probably the fastest conceivable
way that two pieces of client-server code can communicate (they're after
all in the same executable). Your leverage is probably #1. It's the old
adage:

Q: What's the fastest way to do X?

A: Don't.

Find out whether your process is making more database calls than it
needs to be making. Investigate the usual suspects: SQL that doesn't use
bind variables and therefore has to be parsed more often than it should
be parsed, one-row-at-a-time manipulation instead of using arrays and
bulk features, and so on.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- Hotsos Clinic 101, Jan 7-9 Knoxville
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas


-Original Message-
Rich
Sent: Wednesday, December 04, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L

Hey Cary,

"Yes" and "Yes".  Which brings me back to my original question:  How do
I go
about tracking down "single-task message" waits?

Thanks!
Rich


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

> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> If...
> 
> 1) you're collecting time consumption data for ONLY the 
> session you care
> about, AND
> 
> 2) you're collecting the data for a time interval [t0,t1] 
> that includes
> ONLY response time that you care about eliminating,
> 
> ...then the waits are worth investigating.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  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: Are Oracle courses required for Oracle Certification now?

Hey William,

Why are you 40% OCP - does this mean you are an OCA? When did you take your very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're a
50% OCP.

-- 
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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.com
-- 
Author: Lyndon Tiu
  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: Ora 29540 error

2002-12-04 Thread Jeff Herrick

Install the JVM...see MetaLink Note:156477.1

Jeff Herrick

On Wed, 4 Dec 2002, Randy Pace wrote:

>
> I get the following when trying to use the utl_tcp package on 8.1.7
> database.
>
>
> The following error has occurred:
>
> ORA-29540: class oracle/plsql/net/TCPConnection does not exist
> ORA-06512: at "SYS.UTL_TCP", line 537
> ORA-06512: at "SYS.UTL_TCP", line 199
> ORA-06512: at "SYS.UTL_SMTP", line 102
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
> ORA-06512: at line 5
>
> What is missing from the database in order for that to run?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  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: Recipe for application design to run on RAC

2002-12-04 Thread Jamadagni, Rajendra

Title: RE: Recipe for application design to run on RAC

H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference.

Schema1 users have tns entry for db1 and fail over to db2
Schema2 users have a preference for db2 with a fail over to db1

This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application.

None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine.

Like I mentioned this is not a good example ... but this is how we did it in one of our major application.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

*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.*1

RE: ORA-1653: unable to extend table - Why?

Yes, these are definitely the questions to be asking.

And some of the freelist blocks are being written to since we had another
insert run night before last and the number of freelist blocks declined
somewhat although more extents were also claimed in the new datafile.

So sometimes it's writing to the freelist blocks and sometimes it isn't.

I'm confused.

Jay 

-Original Message-
Sent: Tuesday, December 03, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L

Hmm...Why didn't they ask for your buffer cache hit ratio?

Seriously, I've pondered this and it comes down to a question. What would
cause a transaction not to use blocks on the freelist? If a transaction
cannot use these blocks, then it must allocate new space. If the transaction
is set up so as to allocate space above the HWM, we have the same scenario.
Are there transactions that are allocating blocks off the freelist? How deep
will a transaction read the freelist to find an open block before giving up
and allocating space? Are the inserts of such size that they would not fit
into the space in the blocks on the freelist?

I don't know the answers, but it seems that the questions may offer some
clues. I can't wait to find out the real answer!

-Original Message-
Sent: Tuesday, December 03, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> O

RE: ORA-1653: unable to extend table - Why?

MAXTRANS is set to 255.

Thanks anyway :)

-Original Message-
Sent: Wednesday, December 04, 2002 3:54 AM
To: Multiple recipients of list ORACLE-L


Hmm...not sure if this is what's biting you, but if you're out of ITL
slots on the block, Oracle will move to the next block on the free
list.  If all the blocks on the free list have filled ITLs, Oracle will
add an extent to the free list.  I don't suppose you have MAXTRANS set
to 1 or some other very low number?  If so, and with concurrent inserts
happening, it's possible that you could be allocating more blocks to the
free list, even if there are tons of blocks already on the free list,
simply due to the ITL shortage.  (Note that this is why you'll never see
mode 4 TX enqueue waits on insert to a table.) 

If MAXTRANS isn't really low, and if you're not doing direct-load
(APPEND hint) inserts, then I'm stumped.

-Mark

On Tue, 2002-12-03 at 17:09, Fink, Dan wrote:
> Hmm...Why didn't they ask for your buffer cache hit ratio?
> 
> 
> Seriously, I've pondered this and it comes down to a question. What would
> cause a transaction not to use blocks on the freelist? If a transaction
> cannot use these blocks, then it must allocate new space. If the
transaction
> is set up so as to allocate space above the HWM, we have the same
scenario.
> Are there transactions that are allocating blocks off the freelist? How
deep
> will a transaction read the freelist to find an open block before giving
up
> and allocating space? Are the inserts of such size that they would not fit
> into the space in the blocks on the freelist?
> 
> I don't know the answers, but it seems that the questions may offer some
> clues. I can't wait to find out the real answer!
> 
> -Original Message-
> Sent: Tuesday, December 03, 2002 1:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Just for grins, here's the level of support I'm getting on my Oracle TAR:
> 
> --
> You had stated earlier:
> 1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
> num_freelist_blocks: 2266966
> avg_space_freelist_blocks: 3895
> Unless I'm misreading this I should have had over 8Gig available for
> inserts.
> 
> 2/ I've had to add another data file and it has already grown to 600 Meg. 
> 
> If the table is only 600 mb, then there is no way that it can have 8 gb of
> free space. Since you have a lot of blocks with some free space, you may
> want to export and import the table back to re-org the table... 
> --
> 
> Someone should inform these people that a table can consist of more than
one
> datafile...
> 
> 
> -Original Message-
> Sent: Tuesday, December 03, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I had one thought.
> The Freelist parameter for this table is only set to 1.  Is it possible
that
> if it gets tied up with contention for the freelist that it grabs a new
> extent?
> 
> I see that some of these blocks are being written to, the
> num_freelist_blocks is now down to 2095705.  But the new data file has
grown
> to 600 Meg.
> 
> I've opened a TAR to see what Oracle says but I'm not encouraged by the
> first question they sent me (which was asking to query dba_free_space).
> 
> Jay
> 
> -Original Message-
> Sent: Monday, December 02, 2002 6:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> One thing I haven't seen mentioned yet is what degree of parallelism is
> defined for the table?
> What is the next extent size set to?
> If the table is paralleled, EACH parallel worker will grab a next extent
> sized segment. (Been bit by
> this a few times...)
> How many indexes and are they in the same tablespace?
> 
> Ron Thomas
> Hypercom, Inc
> [EMAIL PROTECTED]
> Each new user of a new system uncovers a new class of bugs. -- Kernighan
> 
> 
>  
> 
>   JayMiller@TDWater
> 
>   house.comTo:
> [EMAIL PROTECTED]
> 
>   Sent by: cc:
> 
>   [EMAIL PROTECTED] Subject:  RE: ORA-1653:
> unable to extend table - Why?
> 
>  
> 
>  
> 
>   12/02/2002 02:04
> 
>   PM
> 
>   Please respond to
> 
>   ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> Yep, I agree that coalescing is irrelevant in my current situation.  In
any
> event there was no free space until I added the additional datafile but
> there was the 8gig of space on the freelists.
> 
> Jay
> 
> -Original Message-
> Sent: Friday, November 29, 2002 8:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Richard,
> 
> if pctincrease is zero, and there are a large number of contiguous
> smaller extents, SMON will not automatically coalesce the tablespace.
> However, whether or not SMON does an automatic coalesce, if you need an
> extent that is larger than any of the small ones, Oracle will coalesce
> those smaller extents to

RE:

2002-12-04 Thread Paula_Stankus

Title: RE: 





I believe that is the easiest/cleanest way to restore from patches esp. when you don't know what those patches contain.  

-Original Message-
From: Scott Stefick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject: 



Gurus,


I was just given a project to maintain a Computerized Maintenance 
Management System.  When I asked the companies support staff how to roll 
back patches in the backend Oracle Database (Ver. 8174), they said that 
there was no way to do this.  I'm guessing I could use logminer just incase 
a patch doesn't work.  Would this be a good solution, or are there other 
(better) ways of safeguarding myself when it comes to patching?  Obviously, 
I will be applying the patches to a test instance first, but I don't want 
to have to go back to restore from a backup if the patch causes unexpected 
issues.


TIA!



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

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

I'm barely done with my 9i certification track and I'm hearing of 10i coming out
soon.

All's too fast!

-- 
Lyndon Tiu


Quoting [EMAIL PROTECTED]:

> Peter,
> I don't think a date has been announced yet. 
> When they do state a date they give 6 months notice though
> 
> John
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  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: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Paula_Stankus

Title: RE: Are Oracle courses required for Oracle Certification now?





My understanding it is true for 9i but not for the upgrade test for 9i so I am feverishly getting certified (okay not so feverishly) in 8i so I can do the upgrade path.  Question is:  When do the 8i tests expire?

-Original Message-
From: Kieran Murray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Are Oracle courses required for Oracle Certification now?



Hey people!
 
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his knowledge Oracle requires that you've done Oracle
courses before you can be certified now.
I knew nothing about this, but can't believe Oracle would so blatantly make
you take their over-priced courses.
 
But maybe I'm just naive.
 
Cheers,
Kieran Murray
CardBASE Technologies Limited® 
BIM House
Crofton Road 
Dun Laoghaire
Co Dublin 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  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: Semi-OT: Pics from OracleWorld

2002-12-04 Thread Rachel Carmichael

oh God, remind me to break that camera !


--- [EMAIL PROTECTED] wrote:
> Cool, thanks Connor.
> 
> Next week I will be dining with some of the other erstwhile (other
> than 
> email)
> members of this list, past and present.
> 
> I'm planning to take my Digital Camera, better go pop it into my
> suitcase 
> now.
> 
> Jared
> 
> 
> 
> 
> 
> Connor McDonald <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  12/03/2002 12:34 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Semi-OT: Pics from OracleWorld
> 
> 
> Apologies for the delay (the digital camera died on
> the trip over) so apologies as well for the picture
> quality (all taken with a throwaway disposable
> camera).
> 
> But, here they are... the rough bunch that is the
> Oracle Fatcity-L crew in San Francisco.
> 
> http://www.oracledba.co.uk/sanfran.htm
> 
> Cheers
> Connor
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "GIVE a man a fish and he will eat for a day. But TEACH him how to
> fish, 
> and...he will sit in a boat and drink beer all day"
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 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).

Ora 29540 error

2002-12-04 Thread Randy Pace

Title: Ora 29540 error






I get the following when trying to use the utl_tcp package on 8.1.7 database.



The following error has occurred:


ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 537
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 102
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
ORA-06512: at line 5


What is missing from the database in order for that to run?


Thanks for any help.
Randy R. Pace
Development Team Leader

Accela, Inc.
9662 South 700 East
Sandy
UT, 84070

Tel: 801 495 9300
Fax: 801 495 9301

www.accela.com

RE: Are Oracle courses required for Oracle Certification now?

My instructor in a recent Oracle Education class said that there were a
couple of smart alecs that caused quite a stir within Oracle. After
receiving their OCP, they couldn't log into a database, and claimed it was
because they had never actually used Oracle. The instructor indicated that
the new requirement (9i I believe) would require you to take at least one
class. I asked "do you mean everyone that takes a class from you will be
logging on". He just grinned.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, December 04, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Hey people!
 
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his knowledge Oracle requires that you've done Oracle
courses before you can be certified now.
I knew nothing about this, but can't believe Oracle would so blatantly make
you take their over-priced courses.
 
But maybe I'm just naive.
 
Cheers,
Kieran Murray
CardBASE Technologies Limited® 
BIM House
Crofton Road 
Dun Laoghaire
Co Dublin 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Are Oracle courses required for Oracle Certification now?

You are not required to take the expensive course if:

1) You are upgrading from 7 8 or 8i certification.
2) You took your very first 9i certification exam before Sept 1, 2002
3) You are only shooting for the Associate certification level.

-- 
Lyndon Tiu


Quoting Kieran Murray <[EMAIL PROTECTED]>:

> Hey people!
>  
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly make
> you take their over-priced courses.
>  
> But maybe I'm just naive.
>  
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited® 
> BIM House
> Crofton Road 
> Dun Laoghaire
> Co Dublin 
>  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kieran Murray
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyndon Tiu
  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: ORA-1653: unable to extend table - Why?

The activity is almost all inserts (there is also some minimal update
activity on two CHAR(1) columns later, but it was failing on the inserts).

Looking at it, I'm surprised that I have freelists=1 since so much of the
activity is insert related.  I should probably increase that even if it
doesn't help with this problem since it should improve insert performance.

I guess the next step is to do a 10046 or statspack report the next time the
insert is running.  That might not be for a few weeks though (next time I'm
certain of is 2nd week of January).  

It's not in a LMT, but I am using uniform extents.


Thanks for all the suggestions,
Jay

-Original Message-
Sent: Wednesday, December 04, 2002 7:49 AM
To: Multiple recipients of list ORACLE-L


I always overlook things, so I'll just ask and hope it isn't already on 
the thread: Exactly what kind of activity is going on against this 
wonderful table? Is this table placed in an LMT? If yes, is it a Uniform 
LMT? Could you trace the processes/users doing stuff to the table so 
that we could see if there's contention for ITL slots or other such things?

Mogens

Mark J. Bobak wrote:

>Hmm...not sure if this is what's biting you, but if you're out of ITL
>slots on the block, Oracle will move to the next block on the free
>list.  If all the blocks on the free list have filled ITLs, Oracle will
>add an extent to the free list.  I don't suppose you have MAXTRANS set
>to 1 or some other very low number?  If so, and with concurrent inserts
>happening, it's possible that you could be allocating more blocks to the
>free list, even if there are tons of blocks already on the free list,
>simply due to the ITL shortage.  (Note that this is why you'll never see
>mode 4 TX enqueue waits on insert to a table.) 
>
>If MAXTRANS isn't really low, and if you're not doing direct-load
>(APPEND hint) inserts, then I'm stumped.
>
>-Mark
>
>On Tue, 2002-12-03 at 17:09, Fink, Dan wrote:
>  
>
>>Hmm...Why didn't they ask for your buffer cache hit ratio?
>>
>>
>>Seriously, I've pondered this and it comes down to a question. What would
>>cause a transaction not to use blocks on the freelist? If a transaction
>>cannot use these blocks, then it must allocate new space. If the
transaction
>>is set up so as to allocate space above the HWM, we have the same
scenario.
>>Are there transactions that are allocating blocks off the freelist? How
deep
>>will a transaction read the freelist to find an open block before giving
up
>>and allocating space? Are the inserts of such size that they would not fit
>>into the space in the blocks on the freelist?
>>
>>I don't know the answers, but it seems that the questions may offer some
>>clues. I can't wait to find out the real answer!
>>
>>-Original Message-
>>Sent: Tuesday, December 03, 2002 1:50 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Just for grins, here's the level of support I'm getting on my Oracle TAR:
>>
>>--
>>You had stated earlier:
>>1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
>>num_freelist_blocks: 2266966
>>avg_space_freelist_blocks: 3895
>>Unless I'm misreading this I should have had over 8Gig available for
>>inserts.
>>
>>2/ I've had to add another data file and it has already grown to 600 Meg. 
>>
>>If the table is only 600 mb, then there is no way that it can have 8 gb of
>>free space. Since you have a lot of blocks with some free space, you may
>>want to export and import the table back to re-org the table... 
>>--
>>
>>Someone should inform these people that a table can consist of more than
one
>>datafile...
>>
>>
>>-Original Message-
>>Sent: Tuesday, December 03, 2002 11:54 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>I had one thought.
>>The Freelist parameter for this table is only set to 1.  Is it possible
that
>>if it gets tied up with contention for the freelist that it grabs a new
>>extent?
>>
>>I see that some of these blocks are being written to, the
>>num_freelist_blocks is now down to 2095705.  But the new data file has
grown
>>to 600 Meg.
>>
>>I've opened a TAR to see what Oracle says but I'm not encouraged by the
>>first question they sent me (which was asking to query dba_free_space).
>>
>>Jay
>>
>>-Original Message-
>>Sent: Monday, December 02, 2002 6:14 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>One thing I haven't seen mentioned yet is what degree of parallelism is
>>defined for the table?
>>What is the next extent size set to?
>>If the table is paralleled, EACH parallel worker will grab a next extent
>>sized segment. (Been bit by
>>this a few times...)
>>How many indexes and are they in the same tablespace?
>>
>>Ron Thomas
>>Hypercom, Inc
>>[EMAIL PROTECTED]
>>Each new user of a new system uncovers a new class of bugs. -- Kernighan
>>
>>
>> 
>>
>>  JayMiller@TDWater
>>
>>  house.comTo:
>>[EMAIL PROTECTED]
>>

RE: ORA-1653: unable to extend table - Why?

freelist groups is 1

-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

What is the FREELIST GROUPS for the table?

Waleed

-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L

Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...

-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space wi

Re: Oracle 9iR2 on Red Hat 8.0

2002-12-04 Thread l-oracle


> If you've installed Oracle 9i on RH 8.0, please let me know.
> 
> Also, please let me know of any difficulties and workarounds
> you may have encountered.
> 
> Just put a new 40Gig HD in my laptop, and wondering if I
> can install RH 8.0, or should use 7.2.

Jared:

I put together some notes when I installed 9.2.0 on RH7.3.  I think that 
RH8 is probably similar.

http://iheavy.com/~shull/files/ora9i_inst_notes.txt

HTH,
Sean

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: ORA-1653: unable to extend table - Why?

No triggers, no snapshots.   Thanks for the thougth though.

Jay

-Original Message-
Sent: Tuesday, December 03, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L

Hum.

My last thought would are there triggers or snapshots defined on the table?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/03/2002 08:18

  AM

  Please respond to

  ORACLE-L

Ron,

Good idea, but DEGREE=1

There are two indexes, but they are in a different tablespace (which has
plenty of free space available and did not give an error).

Next extent size is 25M but, as mentioned, it shouldn't have needed a new
extent.

I'm still at a loss...

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

  JayMiller@TDWater

  house.comTo:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?

  12/02/2002 02:04

  PM

  Please respond to

  ORACLE-L

Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay would not have
needed to add a datafile no matter what, if he was not doing a direct
path insert.

As for meeting in person there is a user group meeting on Dec 12
(check www.nyoug.org for details). You can meet me, and more
importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita
Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel

--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> What I mean to say is when there are a lot of contiguous smaller free
> extents.
> Then coalesce will produce a larger free extent so Jay wouldn't have
> to
> add a datafile for his table to grow.
>
> On the automatically coalescing part, I believe SMON will only
> coalesce
> when pctincrease != 0, or has that changed?  My understand could be
> outdated.
> With LMT one doesn't have to worry about it.
>
> Have a Happy Thanksgiving.
>
> PS, I am in New York too, would love to meet you in person some time.
>  Have
> you
> talked to Priscilla lately?
>
> Richard Ji
>
>
> -Original Message-
> Sent: Friday, November 29, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> how would coalescing help even if there were a lot of smaller free
> extents? Oracle would do the coalesce automatically, there would be
> no
> difference between manually coalescing or allowing Oracle to do it
> when
> a new extent was needed.
>
>
> --- Richard Ji <[EMAIL PROTECTED]> wrote:
> > Coalescing might help if there are many smaller free extents
> > that can be coalesced.  But that still doesn't solve Jay's problem.
> > Because he doesn't want the table to extent at all since he just
> > deleted
> > 2 million rows so there are plenty of space within the segment
> > itself.
> > Those free blocks should be used, unless he is doing a direct path
> > insert
> > which will only use space above the HWM.
> >
> > Richard Ji
> >
> > -Original Message-
> > Sent: Friday, November 29, 2002 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > did u coalesced the tablespaces?
> >
> > -Original Message-
> > Sent: sexta-feira, 29 de Novembro de 2002 17:59
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Okay, I can't figure this one out.  Earlier this week I got an
> > ORA-1653:
> > u

Including properties in URL string

2002-12-04 Thread Vaughn, Rick

I have a need to use a Secure Thin JDBC Connection from a 3rd party product
to a Oracle 9i database.  The 3rd party product will only allow me to
specify a URL, User and Password for the connection.  So, I would like to be
able to specify a URL like the following:


jdbc:oracle:thin:@myhost:1521:mydb?user=abc&password=xyz&oracle.net.encrypti
on_client=REQUIRED

But, if I attempt this I get the following error:

java.sql.SQLException:  invalid arguments in call

When working with other JDBC drivers in the past I have been able to pass
properties in the URL String, but the Oracle driver doesn't appear to allow
this.

Is it possible to pass properties in the URL String when using the Oracle
JDBC thin driver?  Perhaps I'm not using the correct syntax!

Thanks,
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vaughn, Rick
  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 Table from Full Backup

2002-12-04 Thread Jeremy Pulcifer

Title: RE: Import Table from Full Backup





> From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]]
> 
> 
> I'd agree that you can achieve the same result. I think I'd 
> argue that it's
> not a feature of RMAN though.
> I can also take that restored table, spool it a text file and 
> edit it using
> MS Word but I wouldn't claim that RMAN can generate Word files.


*roll eyes*


> Mind you, this is probably word class pedantry on my part =)


As the question was can it be done, not is it a feature of, I'd say, yes indeed ;-)

Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Kieran Murray

Hey people!
 
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his knowledge Oracle requires that you've done Oracle
courses before you can be certified now.
I knew nothing about this, but can't believe Oracle would so blatantly make
you take their over-priced courses.
 
But maybe I'm just naive.
 
Cheers,
Kieran Murray
CardBASE Technologies Limited® 
BIM House
Crofton Road 
Dun Laoghaire
Co Dublin 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  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 8i Certification Will Terminate When???

2002-12-04 Thread Ora NT DBA

I went to the Oracle Certification page and looked at the NEWS
and the FAQ.  Both had mentions of the retirement of various tracks
but neither mentioned the retirement of the 8i track.  The abscense
of an announcement on the official web site would indicate to me that
it has not been announced yet.

John

Peter Barnett wrote:


I have been looking at the Oracle web site for the
termination date of Oracle 8i certification tests. 
There is nothing there.  Only Oracle 8.  Rumor has had
it that there is a termination date. 

Does anyone have an authoritative answer?

=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
 




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ora NT DBA
 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: Semi-OT: Pics from OracleWorld

Cool, thanks Connor.

Next week I will be dining with some of the other erstwhile (other than 
email)
members of this list, past and present.

I'm planning to take my Digital Camera, better go pop it into my suitcase 
now.

Jared





Connor McDonald <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/03/2002 12:34 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Semi-OT: Pics from OracleWorld


Apologies for the delay (the digital camera died on
the trip over) so apologies as well for the picture
quality (all taken with a throwaway disposable
camera).

But, here they are... the rough bunch that is the
Oracle Fatcity-L crew in San Francisco.

http://www.oracledba.co.uk/sanfran.htm

Cheers
Connor

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, 
and...he will sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 8i Certification Will Terminate When???

2002-12-04 Thread John.Hallas

Peter,
I don't think a date has been announced yet. 
When they do state a date they give 6 months notice though

John

-Original Message-
Sent: 04 December 2002 15:59
To: Multiple recipients of list ORACLE-L


I have been looking at the Oracle web site for the
termination date of Oracle 8i certification tests. 
There is nothing there.  Only Oracle 8.  Rumor has had
it that there is a termination date. 

Does anyone have an authoritative answer?

=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <[EMAIL PROTECTED]
  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: Toasters

I saw a video clip on our National News show here in Canada last night ("The
National"), they talked about corruption at Enron, etc.

Apparently the accounting consulting firms are still lobbying to let them
continue negotiating consulting contracts with firms they are supposed to be
auditing at arms' length.

The news item included a video from Enron, which emphasized that integrity
was their prime motivator, and you see the top 3 executives in the video who
have since been indicted.  I am probably naive, it was surprising to see
people act normally (even proudly) as if nothing untoward was taking place.

If you are interested and can view video clips, you can go to
http://www.cbc.ca/news/ and look in the right-hand column, under
"Multimedia" to see the clips.

Regards,
Patrice Boivin (Canada)

-Original Message-
Sent: Wednesday, December 04, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


And

And... if Enron had made toasters...  The toast would have come out crooked,
and later 'magically' shred itself into croutons! 

:> Shiva

-Original Message-
Sent: Wednesday, December 04, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L


As a bit of light relief
John



Carry on til the end for the SAP toaster
If IBM made toasters ... They would want one big toaster where people bring
bread to be submitted for overnight toasting. IBM would claim a worldwide
market for five, maybe six toasters. 
If Xerox made toasters ... You could toast one-sided or double-sided.
Successive slices would get lighter and lighter. The toaster would jam your
bread for you. 
If Radio Shack made toasters ... The staff would sell you a toaster, but not
know anything about it. Or you could buy all the parts to build your own
toaster. 
If Oracle made toasters ... They'd claim their toaster was compatible with
all brands and styles of bread, but when you got it home you'd discover the
Bagel Engine was still in development, the Croissant Extension was three
years away, and that indeed the whole appliance was just blowing smoke. 
If Sun made toasters ... The toast would burn often, but you could get a
really good cuppa Java. 
Does DEC still make toasters?... They made good toasters in the '80s, didn't
they? 
If Hewlett-Packard made toasters ... They would market the Reverse Toaster,
which takes in toast and gives you regular bread. 
If Tandem made toasters ... You could make toast 24 hours a day, and if a
piece got burned the toaster would automatically toast you a new one. 
If Thinking Machines made toasters ... You would be able to toast 64,000
pieces of bread at the same time. 
If Cray made toasters ... They would cost $16 million but would be faster
than any other single-slice toaster in the world. 
If the NSA made toasters ... Your toaster would have a secret trap door that
only the NSA could access in case they needed to get at your toast for
reasons of national security. 
If Sony made toasters ... The ToastMan, which would be barely larger than
the single piece of bread it is meant to toast, can be conveniently attached
to your belt. 
If Timex made toasters ... They would be cheap and small quartz-crystal
wrist toasters that take a licking and keep on toasting. 
If Fisher Price made toasters ... "Baby's First Toaster" would have a
hand-crank that you turn to toast the bread that pops up like a
Jack-in-the-box. 
And, of course: If Microsoft made toasters ... Every time you bought a loaf
of bread, you would have to buy a toaster. You wouldn't have to take the
toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh
15000 pounds (hence requiring a reinforced steel countertop), draw enough
electricity to power a small city, take up 95% of the space in your kitchen,
would claim to be the first toaster that lets you control how light or dark
you want your toast to be, and would secretly interrogate your other
appliances to find out who made them. Everyone would hate Microsoft
toasters, but nonetheless would buy them since most of the good bread only
works with their toasters. 
If Apple made toasters ... It would do everything the Microsoft toaster
does, but 5 years earlier. 
If SAP made toasters, the manual to run the toaster would be approximately
10,000 pages long. The toaster would come with 2,500 switches which would
all have to be set in an exact pattern and in a precise sequence in order to
toast specific kinds of bread. Each pattern would be established by SAP's
experts as the "Best Practices" method of toasting that kind of bread. It
would take a team of basis and functional contractors about 1 year to
configure the toaster in the best manner, and then another 6 months to test
it. In the mean time, your entire family would need to attend extensive
training classes on how to use the new toaster. In order to support end
users and consultants, MIT would establish a list-serv for people to post
questions and answers regarding toaster set-up and operation. Of course, the
online h

RE: Single-task message waits

2002-12-04 Thread Jesse, Rich

Hey Cary,

"Yes" and "Yes".  Which brings me back to my original question:  How do I go
about tracking down "single-task message" waits?

Thanks!
Rich


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

> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> If...
> 
> 1) you're collecting time consumption data for ONLY the 
> session you care
> about, AND
> 
> 2) you're collecting the data for a time interval [t0,t1] 
> that includes
> ONLY response time that you care about eliminating,
> 
> ...then the waits are worth investigating.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Open Source Security Comes Under Fire

Okay, since I provided the original remark that provoked this line of
discussion, let me clarify. The organization I was asking whether they were
a shill for Microsoft is the Aberdeen Group, the people that did the report
that made Microsoft look great and Linux look bad. I don't think it matters
which news organization reports the findings, since Aberdeen is a fairly
prominent organization. I did a search and found the name of the
organizations that Oracle had investigated. Here is the news excerpt:

Oracle hired Investigative Group International to probe two research
organizations, the Independence Institute and the National Taxpayers Union.
The company sought to verify links between Microsoft and the organizations
during its antitrust trial--and even tried to buy trash from another
research group with close ties to Microsoft. 
Oracle told Bloomberg News today it discovered that the two organizations
were misrepresenting themselves as independent advocacy groups when they
were in fact funded by Microsoft. Oracle said the company hired the
detective agency because the organizations were releasing studies supporting
Microsoft during the antitrust trial. The financial ties between the
organizations were reported by The Wall Street Journal and The Washington
Post. 

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

-Original Message-
Sent: Wednesday, December 04, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L

Rodd,

Where do you see evidence that Ziff-Davis is owned by Microsoft?

The links seem to lead to a UK publishing firm.

www.ziffdavis.com --> http://www.willisstein.com/ --> www.emac.com 

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent: Wednesday, November 27, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L

Go figure.  This was published on a ZiffDavis news site.  ZD is either
majority or wholly owned by Microsoft.  Do you suppose there might be a
bit of a slant there?

Rodd Holman

On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> Patrice - Amazing how these things happen. A few weeks ago a report listed
> Microsoft products as among the worst security risks. Microsoft
immediately
> attacked the report. Then by an amazing coincidence, an "impartial"
> organization releases a report stating that Microsoft's greatest
competitor,
> the "free" people, are actually the greatest security risk. 
> Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
> hired the private eye to get some proof that they were just shills for
> Microsoft, and the guy was caught dumpster diving?
> 
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI.
>  
>  
> http://www.eweek.com/article2/0,3959,720533,00.asp
> 
> Regards,
> 
> 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] 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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
--

RE: Single-task message waits

2002-12-04 Thread Cary Millsap

If...

1) you're collecting time consumption data for ONLY the session you care
about, AND

2) you're collecting the data for a time interval [t0,t1] that includes
ONLY response time that you care about eliminating,

...then the waits are worth investigating.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- Hotsos Clinic 101, Jan 7-9 Knoxville
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas


-Original Message-
Rich
Sent: Wednesday, December 04, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L

But since my case is a single package running, there's no end-user
interaction.  If I understand you correctly, then I'm only collecting
response time.  I guess I never thought of it in those terms for
non-interactive executions.  If that's the case, then aren't the waits
worth
investigating?  Or am I off track here?

Just trying to get a handle on this in case a miracle happens and I
actually
get to attend a Hotsos Clinic... :)

Thanks,
Rich


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

> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 9:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> But if a so-called idle event is consuming end-user response 
> time, then
> it *is* something to worry about. The problem with the so-called idle
> events is that when you see lots of time rack up to them in
> v$system_event, you can't know whether the time has tallied there
> because of end-user inactivity or because of some other 
> reason... So in
> the context where you've collected diagnostic data to include both
> end-user response time and end-user idle time, you *have to* 
> ignore the
> "idle events"; you have no other choice.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
> 
> 
> -Original Message-
> Gopalakrishnan
> Sent: Tuesday, December 03, 2002 6:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> Rick:
> 
> ANjo Kolk classifies this wait event under one of
> the IDLE wait events.i.e nothing to worry if you
> see them in excessive.
> 
> Best Regards,
> K Gopalakrishnan
> 
> 
> 
> 
> -Original Message-
> Sent: Tuesday, December 03, 2002 3:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey all,
> 
> Does anyone have an idea as to how to tackle "single-task" 
> message waits
> on
> 8.1.7?  The most I could find on this is that it may have to do with
> Context
> indexes, which are referenced in the massive package I'm helping test
> with a
> developer.
> 
> I'd really like to drop the amount of waits I'm seeing on this because
> it
> accounts for ~300-400ms/sec wait according to Spotlight.  I 
> had a 10046
> trace running too, but I'm having problems setting max_dump_file_size
> for
> another process, so I only have 10MB worth of logfile (about 3 minutes
> of a
> 30 minute process).  But that's another post.  :)
> 
> TIA,
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI
> USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  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 8i Certification Will Terminate When???

2002-12-04 Thread Peter Barnett

I have been looking at the Oracle web site for the
termination date of Oracle 8i certification tests. 
There is nothing there.  Only Oracle 8.  Rumor has had
it that there is a termination date. 

Does anyone have an authoritative answer?

=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  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: Toasters

2002-12-04 Thread Baswannappa, Shiva

And

And... if Enron had made toasters...  The toast would have come out crooked,
and later 'magically' shred itself into croutons! 

:> Shiva

-Original Message-
Sent: Wednesday, December 04, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L


As a bit of light relief
John



Carry on til the end for the SAP toaster
If IBM made toasters ... They would want one big toaster where people bring
bread to be submitted for overnight toasting. IBM would claim a worldwide
market for five, maybe six toasters. 
If Xerox made toasters ... You could toast one-sided or double-sided.
Successive slices would get lighter and lighter. The toaster would jam your
bread for you. 
If Radio Shack made toasters ... The staff would sell you a toaster, but not
know anything about it. Or you could buy all the parts to build your own
toaster. 
If Oracle made toasters ... They'd claim their toaster was compatible with
all brands and styles of bread, but when you got it home you'd discover the
Bagel Engine was still in development, the Croissant Extension was three
years away, and that indeed the whole appliance was just blowing smoke. 
If Sun made toasters ... The toast would burn often, but you could get a
really good cuppa Java. 
Does DEC still make toasters?... They made good toasters in the '80s, didn't
they? 
If Hewlett-Packard made toasters ... They would market the Reverse Toaster,
which takes in toast and gives you regular bread. 
If Tandem made toasters ... You could make toast 24 hours a day, and if a
piece got burned the toaster would automatically toast you a new one. 
If Thinking Machines made toasters ... You would be able to toast 64,000
pieces of bread at the same time. 
If Cray made toasters ... They would cost $16 million but would be faster
than any other single-slice toaster in the world. 
If the NSA made toasters ... Your toaster would have a secret trap door that
only the NSA could access in case they needed to get at your toast for
reasons of national security. 
If Sony made toasters ... The ToastMan, which would be barely larger than
the single piece of bread it is meant to toast, can be conveniently attached
to your belt. 
If Timex made toasters ... They would be cheap and small quartz-crystal
wrist toasters that take a licking and keep on toasting. 
If Fisher Price made toasters ... "Baby's First Toaster" would have a
hand-crank that you turn to toast the bread that pops up like a
Jack-in-the-box. 
And, of course: If Microsoft made toasters ... Every time you bought a loaf
of bread, you would have to buy a toaster. You wouldn't have to take the
toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh
15000 pounds (hence requiring a reinforced steel countertop), draw enough
electricity to power a small city, take up 95% of the space in your kitchen,
would claim to be the first toaster that lets you control how light or dark
you want your toast to be, and would secretly interrogate your other
appliances to find out who made them. Everyone would hate Microsoft
toasters, but nonetheless would buy them since most of the good bread only
works with their toasters. 
If Apple made toasters ... It would do everything the Microsoft toaster
does, but 5 years earlier. 
If SAP made toasters, the manual to run the toaster would be approximately
10,000 pages long. The toaster would come with 2,500 switches which would
all have to be set in an exact pattern and in a precise sequence in order to
toast specific kinds of bread. Each pattern would be established by SAP's
experts as the "Best Practices" method of toasting that kind of bread. It
would take a team of basis and functional contractors about 1 year to
configure the toaster in the best manner, and then another 6 months to test
it. In the mean time, your entire family would need to attend extensive
training classes on how to use the new toaster. In order to support end
users and consultants, MIT would establish a list-serv for people to post
questions and answers regarding toaster set-up and operation. Of course, the
online help would randomly pop up in German. But once it was running, you'd
get the best toast in the world.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-5

Re: Recipe for application design to run on RAC

2002-12-04 Thread Boris Dali

Whoa! Tim, thanks a lot for sharing this. Quite an
insight.

So SELECTs are not a concern. INSERTs are a "come and
see DBA" thing (physical design issue).
DELETEs are relatively infrequent and many get
translated into UPDATE (logical as opposed to physical
delete).

Application "partitioning" as you clearly explained in
your email... Would it be closer to a logical or
physical design?
Seems like something that data modeler/architect
should be aware of. So in a sense all modeler needs to
worry about is UPDATEs as far as future physical
implementation for RAC is concerned?

The reason I get stuck on "phys vs logical" here is
because client I am with has a clear separation
between the two.
It's not only different people that deal with it, but
in fact different vendors.

Some background (I probably should've included it in
my original post):
Mission critical system to replace around 30 small
in-house developed apps and do some business
re-engineering as we go :(
Data modeling is done by one vendor, development by
another (don't ask), DB support and maintenance are
left for internal DBA staff

One of the conditions that CTO office "mentioned" to
the modeling company is to keep HA requirements (not
really defined yet - but that's another story) in
mind.
Ok, they turn around bring the data model and declare
that they not only "kept it in mind", but in fact
their model is "RAC aware".
Well I can't describe how happy damanagement is - such
a successful choice they made (to pick this particular
company)! 
But the curious side of me wonders how this data model
is different from the one designed for a single node
DB?

And another thing. Tim, you explained clearly how
application should be assessed for non-RAC to RAC
migration.
In my case however application exists mostly on paper
(not taking into account these 30 micky mouse apps -
the new system suppose to cover much more than that).

1) I guess simulation would be one way to estimate
SQL statements of the app and make a decision on
whether it can scale on RAC well or not.
(And BTW simulation might be worth the trouble
irrespective of whether we use RAC or we don't)
But frankly so far I've seen prototyping or simulation
for the sake of sizing, capacity planning,
understanding DML and query profiles, critical tx,
memory footprint required etc, etc... only in James
Moorle book :( 
That is not prototyping for the sake of "getting
client involved at the early development stages" -
that's been done with all new apps here. And not
benchmarking of already existing application, but the
one that hasn't been developed yet.

2) More importantly simulation is obviously the most
expensive of all alternatives. Analytical modeling of
some sort would be much more welcomed by damanagement.

What would be your take on this? How new essentially
designed from scratch app can be assessed if it can
scale well on RAC?

Thanks again for your help!

 --- Tim Gorman <[EMAIL PROTECTED]> wrote: > To be
more precise, the real problems in
> application-partitioning for
> OPS/RAC are UPDATE, SELECT ... FOR UPDATE, and
> DELETE statements due to
> their WHERE clauses...
> 
> A SELECT statement does not force exclusive access
> to a database block and
> so does not directly cause contention for a block in
> OPS/RAC.  An INSERT
> statement also does not cause contention on tables
> because the use of
> FREELIST GROUPS can keep blocks utilized by
> different instances separate
> from one another.  If the INSERT is inserting a
> monotonically-ascending data
> value into an associated index, then contention on
> the highest-value leaf
> block can be reduced by using REVERSE indexes.  If
> the INSERT is not
> inserting monotonically-ascending data values into
> any indexes, then
> contention during parallel cache management between
> indexes should be
> minimal.
> 
> So SELECTs are inherently benign and INSERT
> operations can be controlled
> with mechanisms to prevent inter-instance contention
> for blocks.
> 
> It is the UPDATE, SELECT ... FOR UPDATE, and DELETE
> statements which truly
> require consideration in making an OPS/RAC-based
> application scaleable.  If
> these statements, which operate on database blocks
> according to their
> respective WHERE clauses generated by application
> logic, do not have some
> form of "awareness" of assignment of certain data
> values to specific
> database instances, then one can expect problems in
> scaling.  Neither OPS
> nor RAC has any mechanism to minimize contention
> between instances for block
> buffers (as with INSERT statements), so it is up to
> the application itself
> (which controls the generation of the WHERE clause)
> to "segregate" the
> application somehow.  Whether it is by major
> application module (i.e. "sales
> and marketing" versus "order entry and inventory"
> versus "general ledger",
> etc) as Boris had illustrated, or by some other
> mechanism (i.e. all
> customers whose names start with A-M on one node,
> all w

RE: Import Table from Full Backup

2002-12-04 Thread tim

The 9i RMAN method is nicer, as the DUPLICATE TARGET
DATABASE command now has a SKIP TABLESPACES clause...

> Both RMAN and manual methods exist but they're
> tacky...Basically you create a new database, recover
> just the appropriate datafiles, export the data and
> then do what you want with it...
> 
> hth
> connor
> 
>  --- "Hately, Mike (NESL-IT)"
> <[EMAIL PROTECTED]> wrote: > Hi,
> > you can recover a tablespace to a point in time.
> > That's the only option you
> > would have using RMAN.
> > 
> > Regards,
> > Mike Hately
> > 
> > -Original Message-
> > Sent: 04 December 2002 11:54
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I think that SQLBackTrack from Precise can restore a
> > table from a backup.
> > Of course you will need to backup with it, not Rman.
> > 
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > Sent: Saturday, November 30, 2002 12:39 AM
> > 
> > 
> > > Hi Listers,
> > > Is it true that I can do an import of a table from
> > a full backup that was
> > > done with RMAN?
> > > That was a comment I heard today and doesn't make
> > sense to me,
> > > any comments?
> > >
> > > Saludos,
> > > Veronica Levin Enriquez
> > > Compañía Cervecera de Nicaragua
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Veronica Levin
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > San Diego, California-- Mailing list and
> > web hosting services
> > >
> >
> --
> > > --- To REMOVE yourself from this mailing list,
> > send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Yechiel Adar
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> --
> > --- To REMOVE yourself from this mailing list,
> > send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Hately, Mike (NESL-IT)
> >   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).
> >  
> 
> > Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "GIVE a man a fish and he will eat for a day. But TEACH
> him how to fish, and...he will sit in a boat and drink
> beer all day" 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com -- 
> 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.com
-- 
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 fro

RE: Single-task message waits

2002-12-04 Thread Jesse, Rich

But since my case is a single package running, there's no end-user
interaction.  If I understand you correctly, then I'm only collecting
response time.  I guess I never thought of it in those terms for
non-interactive executions.  If that's the case, then aren't the waits worth
investigating?  Or am I off track here?

Just trying to get a handle on this in case a miracle happens and I actually
get to attend a Hotsos Clinic... :)

Thanks,
Rich


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

> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 9:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> But if a so-called idle event is consuming end-user response 
> time, then
> it *is* something to worry about. The problem with the so-called idle
> events is that when you see lots of time rack up to them in
> v$system_event, you can't know whether the time has tallied there
> because of end-user inactivity or because of some other 
> reason... So in
> the context where you've collected diagnostic data to include both
> end-user response time and end-user idle time, you *have to* 
> ignore the
> "idle events"; you have no other choice.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
> 
> 
> -Original Message-
> Gopalakrishnan
> Sent: Tuesday, December 03, 2002 6:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> Rick:
> 
> ANjo Kolk classifies this wait event under one of
> the IDLE wait events.i.e nothing to worry if you
> see them in excessive.
> 
> Best Regards,
> K Gopalakrishnan
> 
> 
> 
> 
> -Original Message-
> Sent: Tuesday, December 03, 2002 3:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hey all,
> 
> Does anyone have an idea as to how to tackle "single-task" 
> message waits
> on
> 8.1.7?  The most I could find on this is that it may have to do with
> Context
> indexes, which are referenced in the massive package I'm helping test
> with a
> developer.
> 
> I'd really like to drop the amount of waits I'm seeing on this because
> it
> accounts for ~300-400ms/sec wait according to Spotlight.  I 
> had a 10046
> trace running too, but I'm having problems setting max_dump_file_size
> for
> another process, so I only have 10MB worth of logfile (about 3 minutes
> of a
> 30 minute process).  But that's another post.  :)
> 
> TIA,
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI
> USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Open Source Security Comes Under Fire

Ok, thanks.

After trying to follow the trail of owners, I think tracking who owns what
is a full-time job...

Pat.

-Original Message-
Sent: Wednesday, December 04, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


David Coursey, one of their Editors/Columnists made the disclaimer some
time back when he was comparing different software offerings of some
type.  He mentioned that MS had some type of ownership in them or their
parent company.  I don't recall which.

Rodd

On Wed, 2002-12-04 at 08:03, Boivin, Patrice J wrote:
> Rodd,
> 
> Where do you see evidence that Ziff-Davis is owned by Microsoft?
> 
> The links seem to lead to a UK publishing firm.
> 
> www.ziffdavis.com --> http://www.willisstein.com/ --> www.emac.com
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 3:27 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Go figure.  This was published on a ZiffDavis news site.  ZD is either
> majority or wholly owned by Microsoft.  Do you suppose there might be a
> bit of a slant there?
> 
> Rodd Holman
> 
> On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> > Patrice - Amazing how these things happen. A few weeks ago a report
listed
> > Microsoft products as among the worst security risks. Microsoft
> immediately
> > attacked the report. Then by an amazing coincidence, an "impartial"
> > organization releases a report stating that Microsoft's greatest
> competitor,
> > the "free" people, are actually the greatest security risk. 
> > Somebody refresh my memory -- wasn't it the Aberdeen Group that
Larry
> > hired the private eye to get some proof that they were just shills for
> > Microsoft, and the guy was caught dumpster diving?
> > 
> > 
> > 
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Wednesday, November 27, 2002 8:24 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > FYI.
> >  
> >  
> > http://www.eweek.com/article2/0,3959,720533,00.asp
> > 
> > Regards,
> > 
> > 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] 
> > 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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).

Ora-600 [2103] (oracle 8172/aix 4.3.3.0)

2002-12-04 Thread Stephane Paquette

Hi,

We've hit Ora-600 [2103] on a production database
(oracle 8172/aix 4.3.3.0).

We already have aix patch IX 81863.

According to Oracle support, it's caused by IO
contention. 

Anybody has faced this one ?

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  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 Table from Full Backup

Sorry, as Kirti pointed to me the product belong to BMC.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 1:53 PM


> I think that SQLBackTrack from Precise can restore a table from a backup.
> Of course you will need to backup with it, not Rman.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Saturday, November 30, 2002 12:39 AM
>
>
> > Hi Listers,
> > Is it true that I can do an import of a table from a full backup that
was
> > done with RMAN?
> > That was a comment I heard today and doesn't make sense to me,
> > any comments?
> >
> > Saludos,
> > Veronica Levin Enriquez
> > Compañía Cervecera de Nicaragua
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Veronica Levin
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  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: Open Source Security Comes Under Fire

2002-12-04 Thread Rodd Holman

David Coursey, one of their Editors/Columnists made the disclaimer some
time back when he was comparing different software offerings of some
type.  He mentioned that MS had some type of ownership in them or their
parent company.  I don't recall which.

Rodd

On Wed, 2002-12-04 at 08:03, Boivin, Patrice J wrote:
> Rodd,
> 
> Where do you see evidence that Ziff-Davis is owned by Microsoft?
> 
> The links seem to lead to a UK publishing firm.
> 
> www.ziffdavis.com --> http://www.willisstein.com/ --> www.emac.com
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 3:27 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Go figure.  This was published on a ZiffDavis news site.  ZD is either
> majority or wholly owned by Microsoft.  Do you suppose there might be a
> bit of a slant there?
> 
> Rodd Holman
> 
> On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> > Patrice - Amazing how these things happen. A few weeks ago a report listed
> > Microsoft products as among the worst security risks. Microsoft
> immediately
> > attacked the report. Then by an amazing coincidence, an "impartial"
> > organization releases a report stating that Microsoft's greatest
> competitor,
> > the "free" people, are actually the greatest security risk. 
> > Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
> > hired the private eye to get some proof that they were just shills for
> > Microsoft, and the guy was caught dumpster diving?
> > 
> > 
> > 
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Wednesday, November 27, 2002 8:24 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > FYI.
> >  
> >  
> > http://www.eweek.com/article2/0,3959,720533,00.asp
> > 
> > Regards,
> > 
> > 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] 
> > 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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 Table from Full Backup

2002-12-04 Thread Hately, Mike (NESL-IT)

I'd agree that you can achieve the same result. I think I'd argue that it's
not a feature of RMAN though.
I can also take that restored table, spool it a text file and edit it using
MS Word but I wouldn't claim that RMAN can generate Word files.

Mind you, this is probably word class pedantry on my part =)

Cheers,
Mike
-Original Message-
Sent: 04 December 2002 13:34
To: Multiple recipients of list ORACLE-L


In order to use rman to restore a single table you have to restore the
tablespace to a clone and then export the table you need and import it to
the 'real' database.  So yes, it can be done!

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, November 30, 2002 12:39 AM


> Hi Listers,
> Is it true that I can do an import of a table from a full backup that was
> done with RMAN?
> That was a comment I heard today and doesn't make sense to me,
> any comments?
>
> Saludos,
> Veronica Levin Enriquez
> Compañía Cervecera de Nicaragua
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately, Mike (NESL-IT)
  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:

2002-12-04 Thread Whittle Jerome Contr NCI

Title: RE: 






Red Buttons is a fine comedian and actor. He won an Academy Award and Golden Globe. Still I can't see how he can HELP in this case.

Oh - you said Button not Buttons.

Nevermind.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From:   Jeremy Pulcifer [SMTP:[EMAIL PROTECTED]]

The answer to your problem: The Red Button. You're welcome!

-Original Message-
From: Tinu !@#!^% [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 3:29 AM
To: Multiple recipients of list ORACLE-L
Subject:



HELP

RE: Import Table from Full Backup

2002-12-04 Thread Connor McDonald

Both RMAN and manual methods exist but they're
tacky...Basically you create a new database, recover
just the appropriate datafiles, export the data and
then do what you want with it...

hth
connor

 --- "Hately, Mike (NESL-IT)"
<[EMAIL PROTECTED]> wrote: > Hi,
> you can recover a tablespace to a point in time.
> That's the only option you
> would have using RMAN.
> 
> Regards,
> Mike Hately
> 
> -Original Message-
> Sent: 04 December 2002 11:54
> To: Multiple recipients of list ORACLE-L
> 
> 
> I think that SQLBackTrack from Precise can restore a
> table from a backup.
> Of course you will need to backup with it, not Rman.
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Sent: Saturday, November 30, 2002 12:39 AM
> 
> 
> > Hi Listers,
> > Is it true that I can do an import of a table from
> a full backup that was
> > done with RMAN?
> > That was a comment I heard today and doesn't make
> sense to me,
> > any comments?
> >
> > Saludos,
> > Veronica Levin Enriquez
> > Compañía Cervecera de Nicaragua
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Veronica Levin
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hately, Mike (NESL-IT)
>   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).
>  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: Open Source Security Comes Under Fire

Rodd,

Where do you see evidence that Ziff-Davis is owned by Microsoft?

The links seem to lead to a UK publishing firm.

www.ziffdavis.com --> http://www.willisstein.com/ --> www.emac.com 

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent: Wednesday, November 27, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L


Go figure.  This was published on a ZiffDavis news site.  ZD is either
majority or wholly owned by Microsoft.  Do you suppose there might be a
bit of a slant there?

Rodd Holman

On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote:
> Patrice - Amazing how these things happen. A few weeks ago a report listed
> Microsoft products as among the worst security risks. Microsoft
immediately
> attacked the report. Then by an amazing coincidence, an "impartial"
> organization releases a report stating that Microsoft's greatest
competitor,
> the "free" people, are actually the greatest security risk. 
> Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry
> hired the private eye to get some proof that they were just shills for
> Microsoft, and the guy was caught dumpster diving?
> 
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 27, 2002 8:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> FYI.
>  
>  
> http://www.eweek.com/article2/0,3959,720533,00.asp
> 
> Regards,
> 
> 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] 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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 Table from Full Backup

2002-12-04 Thread Ruth Gramolini

In order to use rman to restore a single table you have to restore the
tablespace to a clone and then export the table you need and import it to
the 'real' database.  So yes, it can be done!

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 6:53 AM


I think that SQLBackTrack from Precise can restore a table from a backup.
Of course you will need to backup with it, not Rman.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, November 30, 2002 12:39 AM


> Hi Listers,
> Is it true that I can do an import of a table from a full backup that was
> done with RMAN?
> That was a comment I heard today and doesn't make sense to me,
> any comments?
>
> Saludos,
> Veronica Levin Enriquez
> Compañía Cervecera de Nicaragua
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: SLA Trigger/Procedure

So do a select from a view based on sys.x$dual. That does not have cause
LIO.
I checked a few months ago.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 4:32 PM


> and that select 'PING' from dual is very costly. I believe Gaja, Cary,
> Anjo, and a few others (who were nice enough to include me on the
> thread)  determined that before 9i Oracle takes about 5 LIOs to do a
> select "anything" from dual. I think it went down to either 3 or 4 in
> 9i but that's still VERY costly.
>
> Dan Fink has that discussion summarized on his site:
>
> http://www.optimaldba.com/internals/oraint_dual.html
>
>
> Rachel
> --- Mark Leith <[EMAIL PROTECTED]> wrote:
> > Yup, got that covered :)
> >
> > If I may add another point. When dealing with SLA's, you not only
> > have to
> > "show" that the database has been servicing users that are connected
> > (showing database uptime), but also that users can also *connect* to
> > the
> > database as well (the listener is servicing requests).
> >
> > If you were to go about this with a trigger/procedure that inserts in
> > to a
> > table, then this doesn't show that the database was available to
> > "everybody".
> >
> > Typically what we do with monitoring tools is a "connect on ping", so
> > when
> > we are checking availability of a database we do a full connect, then
> > "select 'PING' from dual;". If there are any errors along the way we
> > search
> > for the error code, and deal with the appropriate alerts (TNS =
> > Listener
> > "problem", ORA = Database "problem").
> >
> > Of course, the problem with doing it this way, is that you are going
> > to have
> > to write platform dependant scripts (batches for NT, shell type
> > scripts for
> > Unix), and not have a "one for all" with a database based solution.
> >
> > Go buy a tool. Let it write to a table/file, alert you AND make the
> > coffee
> > for when you get there! ;)
> >
> > Mark
> >
> > ===
> >  Mark Leith | T: +44 (0)1905 330 281
> >  Sales & Marketing  | F: +44 (0)870 127 5283
> >  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
> > ===
> >http://www.cool-tools.co.uk
> >Maximising throughput & performance
> >
> > -Original Message-
> > Richard
> > Sent: 03 December 2002 02:14
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Perhaps there is a "poor mans" way of doing this.  The startup
> > trigger
> > could fire a procedure that inserts a row into a table and then
> > sleeps for
> > 1 minute before doing the same again.  Effectively it would create a
> > ping
> > in the table, which you could then analyze / graph to display
> > uptimes.
> >
> > The next logical step would be to increase the intelligence of the
> > procedure.  The table storing the statistic could consist of two
> > columns -
> > uptime and downtime.  When the startup trigger fires it creates a new
> > row
> > in the table with both uptime and downtime set to sysdate.  It then
> > sleeps
> > for a minute before updating downtime for the most recent record
> > (either
> > remember a primary key or search for max(uptime)).  This would be
> > much
> > easier to understand when the database was stopped / started.
> >
> > Of course depending on your accuracy requirement, granularity could
> > be
> > changed to every 5 minutes, 10 minutes, whatever.
> >
> > Hopefully that gives some ideas though.  Of course the 3rd party
> > monitors
> > that Jared mentions are worth considering if the database is
> > considered
> > critical.  In that case the number one requirement is probably the
> > ability
> > to page / SMS / email when it sees the database is down.
> >
> > Regards,
> >  Mark.
> >
> >
> >
> >
> > Jared.Still@ra
> > disys.comTo: Multiple recipients
> > of list
> > ORACLE-L <[EMAIL PROTECTED]>
> > Sent by: cc:
> > [EMAIL PROTECTED]   Subject: Re: SLA
> > Trigger/Procedure
> > om
> >
> >
> > 03/12/2002
> > 12:13
> >
> > Please respond
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> > Ethan,
> >
> > That records the startup times, but does not record the time
> > that the database was unavailable.
> >
> > What's needed is a 3rd party monitor that is not dependent
> > on the database being up to record metrics.
> >
> > Jared
> >
> >
> >
> >
> >
> > "Post, Ethan" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> >  12/02/2002 02:33 PM
> >  Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject:SLA Trigger/Procedure
> >
> >
> > Just a thought here for a script I think would be handy but I haven't
> > had
>

RE: Import Table from Full Backup

2002-12-04 Thread Hately, Mike (NESL-IT)

Hi,
you can recover a tablespace to a point in time. That's the only option you
would have using RMAN.

Regards,
Mike Hately

-Original Message-
Sent: 04 December 2002 11:54
To: Multiple recipients of list ORACLE-L


I think that SQLBackTrack from Precise can restore a table from a backup.
Of course you will need to backup with it, not Rman.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, November 30, 2002 12:39 AM


> Hi Listers,
> Is it true that I can do an import of a table from a full backup that was
> done with RMAN?
> That was a comment I heard today and doesn't make sense to me,
> any comments?
>
> Saludos,
> Veronica Levin Enriquez
> Compañía Cervecera de Nicaragua
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately, Mike (NESL-IT)
  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: Help with Java

Alex - And the funny part is that the person who nailed the solution, Steve
Ollig, also works for us and isn't a part of our official Java initiative.
Do you think he'll ever get good enough to be sent to Java training?

-Original Message-
Sent: Tuesday, December 03, 2002 4:20 PM
To: Multiple recipients of list ORACLE-L


My condolences to you.

On Tue, 3 Dec 2002, DENNIS WILLIAMS wrote:

> John - I forwarded your message to one of our newly-trained Java
> programmers. He replied with:
>The code is incomplete, how are they handling the connection.
>Obviously the while loops are messing each other up.
>There are multiple ways of handling this.
>If I see the complete code I can be more specific.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, December 03, 2002 12:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All,
>
> I am beginning the journey into JAVA and have hit an odd behavior
> (well, probably not, but I can't see any reason for it).  I am
> building a list of tablespaces and the datafiles that belong to them.
> The open to the database is working fine.  When I use:
>
>  ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM   dba_tablespaces " +
> "WHERE  contents = 'PERMANENT'"
>   );
>
>   while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
>   }
>   myTablespace.close();
>
> I am generating a list of tablespaces and the output is as expected.
> When I add a second result set, the first datafile of the first tablespace
> returns and then the program completes:
>
>  ResultSet myTablespaces = myStatement.executeQuery(
> "SELECT tablespace_name " +
> "FROM   dba_tablespaces " +
> "WHERE  contents = 'PERMANENT'"
>   );
>   while (myTablespaces.next()) {
> // retrieve the user from the row in the ResultSet using the
> // getString() method
> ct = ct + 1;
> String tablespace = myTablespaces.getString(1);
> System.out.println("Tablespace " + ct + " is: " + tablespace);
>
> ResultSet myDataFiles = myStatement.executeQuery(
>   "SELECT file_name " +
>   "FROM   dba_data_files " +
>   "WHERE  tablespace_name = '" + tablespace + "'"
> );
>
> while (myDataFiles.next()) {
>   String filename = myDataFiles.getString(1);
>   System.out.println("  " + filename);
> }
> myDataFiles.close();
>   }
>   myTablespaces.close();
>
>
> Anybody with some Java experience have any insite?
>
> As always, TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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.com
> --
> 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.com
-- 
Author: Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858

Re: ORA-1653: unable to extend table - Why?

2002-12-04 Thread Mogens Nørgaard

I always overlook things, so I'll just ask and hope it isn't already on 
the thread: Exactly what kind of activity is going on against this 
wonderful table? Is this table placed in an LMT? If yes, is it a Uniform 
LMT? Could you trace the processes/users doing stuff to the table so 
that we could see if there's contention for ITL slots or other such things?

Mogens

Mark J. Bobak wrote:

Hmm...not sure if this is what's biting you, but if you're out of ITL
slots on the block, Oracle will move to the next block on the free
list.  If all the blocks on the free list have filled ITLs, Oracle will
add an extent to the free list.  I don't suppose you have MAXTRANS set
to 1 or some other very low number?  If so, and with concurrent inserts
happening, it's possible that you could be allocating more blocks to the
free list, even if there are tons of blocks already on the free list,
simply due to the ITL shortage.  (Note that this is why you'll never see
mode 4 TX enqueue waits on insert to a table.) 

If MAXTRANS isn't really low, and if you're not doing direct-load
(APPEND hint) inserts, then I'm stumped.

-Mark

On Tue, 2002-12-03 at 17:09, Fink, Dan wrote:
 

Hmm...Why didn't they ask for your buffer cache hit ratio?


Seriously, I've pondered this and it comes down to a question. What would
cause a transaction not to use blocks on the freelist? If a transaction
cannot use these blocks, then it must allocate new space. If the transaction
is set up so as to allocate space above the HWM, we have the same scenario.
Are there transactions that are allocating blocks off the freelist? How deep
will a transaction read the freelist to find an open block before giving up
and allocating space? Are the inserts of such size that they would not fit
into the space in the blocks on the freelist?

I don't know the answers, but it seems that the questions may offer some
clues. I can't wait to find out the real answer!

-Original Message-
Sent: Tuesday, December 03, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L


Just for grins, here's the level of support I'm getting on my Oracle TAR:

--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I should have had over 8Gig available for
inserts.

2/ I've had to add another data file and it has already grown to 600 Meg. 

If the table is only 600 mb, then there is no way that it can have 8 gb of
free space. Since you have a lot of blocks with some free space, you may
want to export and import the table back to re-org the table... 
--

Someone should inform these people that a table can consist of more than one
datafile...


-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


I had one thought.
The Freelist parameter for this table is only set to 1.  Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?

I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705.  But the new data file has grown
to 600 Meg.

I've opened a TAR to see what Oracle says but I'm not encouraged by the
first question they sent me (which was asking to query dba_free_space).

Jay

-Original Message-
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L



One thing I haven't seen mentioned yet is what degree of parallelism is
defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent
sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan




 JayMiller@TDWater

 house.comTo:
[EMAIL PROTECTED]

 Sent by: cc:

 [EMAIL PROTECTED] Subject:  RE: ORA-1653:
unable to extend table - Why?





 12/02/2002 02:04

 PM

 Please respond to

 ORACLE-L









Yep, I agree that coalescing is irrelevant in my current situation.  In any
event there was no free space until I added the additional datafile but
there was the 8gig of space on the freelists.

Jay

-Original Message-
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L


Richard,

if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those smaller extents to make the one you need. so Jay woul

Re: move some records of some tables

Hello Murat

Export has a parameter Query that allow you to specify selection criteria
for exporting a subset of records from the table. Import also has parameter
Ignore=y and then the import ignore the error of the create table statement
and append the imported records into an existing table.

So you can export the selected records only from your tables and import them
to the seconds DB.

HTH

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 1:43 PM


> Hi,
>
>   what's the best method to move some rows of some tables of a user
> from one database to another database on another server? I need a step by
> step document to achieve this.
>
> Thanks,
> Murat
>
>
> --
> Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda
ozel
> haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen
mesaji
> geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet
Hizmetleri
> Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic
bir
> hukuksal sorumlulugu kabul etmez.
>
> This  e-mail  communication  is intended for the private use of the
persons
> named  above.  If  you  received  this message in error, please
immediately
> notify  the  sender  and  delete  it  from  your  system.  Rt.Net
Internet
> Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal
responsibility
> for the contents of this message.
> --
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MURAT BALKAS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  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: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

Title: RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

You
can also register with the Boston Globe to get an e-mail listing Oracle job ads
in the Boston area.
I use
it as a gauge of how well things are going in the market south of the
border.
At one
point there were a dozen or more Oracle positions (about a year and half ago),
about 3 -6 months ago I actually received some blank e-mails, things seem
to be picking up a bit again, I am seeing 4 - 6 per e-mail
now.
Regards,
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-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 7:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Sr. Oracle DBA Position- Must be 8i and 9i Certified-
Does a 24x7 DB demand a higher salary than a 9am-5pm DB?

-Original Message- From:
OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

Great opportunity for a Sr. Oracle DBA with 8i AND 9i
certification to join this software industry leader in Charlotte, North Carolina.
Base salary is in the 90-120K range and depends on
experience.
Relocation Assistance is provided.
PLEASE Do Not send your resume for this position UNLESS you
have the skills outlined below for this
position.
Please Do Not send your resume unless you have a stable work
history. Candidates whose work history includes
frequent job changes connot be considered.
If you are employed by a consulting company you must have a
long term project history.
This is a full time staff position so no sub-contractors or
third parties please.
NO H-1B candidates please.
Interested candidates will be required to complete a company
questionnaire that must be submitted with the
resume.
*Description of duties: Production
support of operations required to maintain 7x24 database/application availability. Logical
Design and Physical Design in support of Production/Development
Database operations and support in
Solaris/Linux ORACLE 8i/9i environment. Essential
Functions: Backup/recovery, RMAN, Performance tuning, Shell scripting in Korn and Bourne Shells. ORACLE Internet Directory,
ORACLE Enterprise Manager, development/documentation
of standards and procedures. ORACLE DBA duties to
include user management data exports and imports, writing ORACLE scripts, general monitoring of system performance.
Assisting users with SQL and PL/SQL needs in
day-to-day operations and implementation of logical
designs.
* Requirements: -Oracle 8i and 9i
Certification -7+Years in IT -5+ years of Production Oracle DBA experience..including 8i and
9i -Knowledge of OPS/RAC, OEM -Proficient with SQL, PL/SQL, unix shell scritping -Expert understanding of Oracle architecture -Full understanding of Database concepts -Knowledge of relational database design -Must
be a Self-starter.
For immediate consideration, please email your resume as an
attachment to:
OraStaff, Inc. Email:
[EMAIL PROTECTED] Phone: 1-800-549-8502.
Please Use Job Code: One/Charlotte/Certified
DBA/Carol
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.com --
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: Import Table from Full Backup