get rid of carriage return in vi

[Sairlao, Chark]

all,

I got this file which conntans ^M in the middle of the line, how do I get
rid of it in vi

thanks

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

find free space under HWM for a table

[Chuan Zhang]

Hi, DBA gurus,

Recently, I will archiving some big tables.  How to find free space under
HWM for a table?

Thanks,

Chuan





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: SQL Cursor Parameter Behavior in 7.x vs 8.x

[Paul Drake]

Larry,

this is a side effect of having query_rewrite_enabled=true as a
possibility.
by allowing query rewrites, the aliases have to be unique across the
query.
I experienced problems with non-unique aliases when migrating from 7.3
to 8.1.

To me, this is not a surprise.

Paul


Larry Elkins wrote:
> 
> Listers,
> 
> Anyone have access to 7.x to test this for me? I had to head out to help a
> former client tune a large "batch" package that headed South on them after
> they went live over the weekend, upgrading from 7.3.4.3 to 8.1.7.1. In the
> case of one SQL statement, the CBO was making a very poor decision regarding
> the driving table. Easy enough to identify and fix after generating a trace
> and running tkprof. I would have liked to play with the statistics gathering
> process to see if we could fix the problem, but, since they were in a hurry,
> I just went with the ORDERED hint.
> 
> But, there was another "bad" SQL statement that jumped out. I will use EMP
> as an example. For whatever reason, the programmer had named a cursor
> parameter the *same* as an actual column name (I know, not very smart on the
> coder's part):
> 
> cursor c1 (empno number) is
> select empno
> from emp e
> where e.empno = empno;
> 
> V8 was treating it as the column equal to itself. Hence, a full table scan
> and returning all rows. In their real life example, the variable was against
> a PK on a table joining back through 3 other tables. Oracle did FTS's on all
> tables and a combination of HJ's and MJ's. And each of those tables had
> millions of rows. And that's the behavior I would expect since there was "no
> criteria" to speak of.
> 
> But, this is a nightly batch process and problems had never been encountered
> before. So, this is making me think that V7 was treating the right side as a
> variable and using the value passed in. Best I remember (I don't have access
> to Metalink right now) various notes warned about the above being erratic --
> how would Oracle know if you meant the column or the variable? And the
> person should never have coded it the way they did. I always prefix my
> parameters with "p_", p_empno for example, and type them to the column. No
> confusion that way. I am curious if someone could test this against V7. For
> all I know, maybe since the "column name" was prefixed with the alias and
> the variable wasn't, they were just getting *lucky* in V7. Or, maybe it is
> truly erratic. And maybe it is still erratic in V8 (though an example I
> wrote exhibited the same behavior). And I left wondering how many other
> cases they might have in their code where a similar coding technique was
> used. Ouch! I hope for their sake there aren't that many ;-)
> 
> Anyway, I'm curious if someone can check this out against V7. Here is an
> example script I ran against 8.1.7 here at home:
> 
>   1  declare
>   2  cursor c1 (empno number) is
>   3  select empno
>   4  from emp e
>   5  where e.empno = empno;
>   6  v_empno number;
>   7  begin
>   8  open c1 (4567);
>   9  fetch c1 into v_empno;
>  10  dbms_output.put_line(to_char(v_empno));
>  11  close c1;
>  12* end;
> SQL> /
> 7369
> 
> PL/SQL procedure successfully completed.
> 
> There is no employee "4567" and the output makes it obvious that the SQL was
> treated as column = column, get all rows. The obvious solution is to avoid
> the ambiguity in how the cursor parameter is named. But I am still
> interested in how the above would be handled against V7.
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How much SGA free?

[Gaja Krishna Vaidyanatha]

Babu & list,

If we are referring to the "free memory" statistic
from v$sgastat, the closer that number is to 0, the
better. If you see a very large number, it indicates
an "overallocation problem" in one or more components
of the shared/large/java pools.

And without getting on the soapbox, there is NO such
thing as an "healthy cache hit ratio". There is only
one thing that is relevant to any Oracle system and it
is "wait events". I have seen 99.98% systems crawl
like snails and 56% systems fly through like grease
lightning.

Moral of the story - Don't worry what your cache hit
ratios are, look at your wait events, go after your
system's bottlenecks, proactively manage the memory
allocation of various components of your SGA and your
PGA, encourage cursor sharing, reduce hard parsing,
reduce soft parsing, encourage "caching session
cursors" and for everyone's health fix those SQL
statements where the whole thing begins.

Cheers,

Gaja

--- orclbabu <[EMAIL PROTECTED]> wrote:
> Seema
> 
> the answer is "it depends"... you need tyo have
> enough space in your sga to
> maintain a healthy hit ratio.
> 
> how high is healthy depends on the nature of
> application.
> 
> Babu
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, July 11, 2001 1:32 PM
> 
> 
> > Hi
> > How much percentage SGA should be free for OLTP
> application?
> > Thanks in advanvce.
> > -Seema
> >
>
_
> > Get your FREE download of MSN Explorer at
> http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: extent management

[Narender Akula]

hi hermanto,
Do a export of table and use improt with indexfile option you will get nice
initial extent with larger
value.
eg: 
imp scott/tiger file=scott.dmp full=y indexfile=tablex.sql

modify the tablex.sql to your needs.
HTH
naren

-Original Message-
Sent: Thursday, 12 July 2001 14:45
To: Multiple recipients of list ORACLE-L


Hi gurus,
I have a problem with the table extent.
Actually, the table extent growth too fast.
Maybe I  set the extent configuration wrong.
So, I have to adjust the next extent almost every two months.
Now the maxextents value already reach 80 (oracle 7.3).
Is there anyone knows about how I should manage the extent of table ?
What I have to do if I have reach 121 maxextents value ?
Thanks before for your kind advise.

Warm Regards,

Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept.
Phone : (0761) - 95529 Ext. 1147 - 1266
HP : 0812-752-3092
"Our greatest glory is not in never falling but in rising every time we
fall" 



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Narender Akula
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: extent management

[Suhen Pather]

Hermanto,

Recreate the table with larger initial and next extent size.
Try not to have too many small extents since it becomes unmanageable
but rather have fewer larger extents.  I try not to have more than 30 or 40
extents.

Performance is not much of a problem with multiple extents but make sure
your 
extent sizes are multiples of multi block read size.

See Steve Adams tip on planning extents.
http://www.ixora.com.au/tips/creation/extents.htm

Suhen




Hi gurus,
I have a problem with the table extent.
Actually, the table extent growth too fast.
Maybe I  set the extent configuration wrong.
So, I have to adjust the next extent almost every two months.
Now the maxextents value already reach 80 (oracle 7.3).
Is there anyone knows about how I should manage the extent of table ?
What I have to do if I have reach 121 maxextents value ?
Thanks before for your kind advise.

Warm Regards,

Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept.
Phone : (0761) - 95529 Ext. 1147 - 1266
HP : 0812-752-3092
"Our greatest glory is not in never falling but in rising every time we
fall" 



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suhen Pather
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

extent management

[Hermanto P]

Hi gurus,
I have a problem with the table extent.
Actually, the table extent growth too fast.
Maybe I  set the extent configuration wrong.
So, I have to adjust the next extent almost every two months.
Now the maxextents value already reach 80 (oracle 7.3).
Is there anyone knows about how I should manage the extent of table ?
What I have to do if I have reach 121 maxextents value ?
Thanks before for your kind advise.

Warm Regards,

Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept.
Phone : (0761) - 95529 Ext. 1147 - 1266
HP : 0812-752-3092
"Our greatest glory is not in never falling but in rising every time we
fall" 



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

TNS:listener failed to start

[Jafar Sadeq]

Hi

I am working on Personal Oracle 7. I created a database alias, then created 
a connection from Oracle Navigator. When I click on the connection, it says 
ORA-12500: TNS:listener failed to start a dedicated server process.

This is what the Oracle help says:

Cause:  The process of starting up a dedicated server process failed. The 
executable could not be found or the environment may be set up incorrectly.
Action: Turn on tracing at the ADMIN level and reexecute the operation. 
Verify that the ORACLE Server executable is present and has execute 
permissions enabled. Ensure that the ORACLE environment is specified 
correctly in LISTENER.ORA. If error persists, contact Worldwide Customer 
Support.

I don't know hot to verify that.

I used the Control Panel on Windows NT to go to the Services list, and 
OracleTNSListener was not started, even though it is to start automatically. 
I tried to start it and it goes:

Could not start OracleTNSListener service on \\SERVER.
Error 2140: An internal Windows NT error occurred.

I would appreciate any help.

Thanks
Jafar
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: SQL Cursor Parameter Behavior in 7.x vs 8.x

[Larry Elkins]

Listers,

Anyone have access to 7.x to test this for me? I had to head out to help a
former client tune a large "batch" package that headed South on them after
they went live over the weekend, upgrading from 7.3.4.3 to 8.1.7.1. In the
case of one SQL statement, the CBO was making a very poor decision regarding
the driving table. Easy enough to identify and fix after generating a trace
and running tkprof. I would have liked to play with the statistics gathering
process to see if we could fix the problem, but, since they were in a hurry,
I just went with the ORDERED hint.

But, there was another "bad" SQL statement that jumped out. I will use EMP
as an example. For whatever reason, the programmer had named a cursor
parameter the *same* as an actual column name (I know, not very smart on the
coder's part):

cursor c1 (empno number) is
select empno
from emp e
where e.empno = empno;

V8 was treating it as the column equal to itself. Hence, a full table scan
and returning all rows. In their real life example, the variable was against
a PK on a table joining back through 3 other tables. Oracle did FTS's on all
tables and a combination of HJ's and MJ's. And each of those tables had
millions of rows. And that's the behavior I would expect since there was "no
criteria" to speak of.

But, this is a nightly batch process and problems had never been encountered
before. So, this is making me think that V7 was treating the right side as a
variable and using the value passed in. Best I remember (I don't have access
to Metalink right now) various notes warned about the above being erratic --
how would Oracle know if you meant the column or the variable? And the
person should never have coded it the way they did. I always prefix my
parameters with "p_", p_empno for example, and type them to the column. No
confusion that way. I am curious if someone could test this against V7. For
all I know, maybe since the "column name" was prefixed with the alias and
the variable wasn't, they were just getting *lucky* in V7. Or, maybe it is
truly erratic. And maybe it is still erratic in V8 (though an example I
wrote exhibited the same behavior). And I left wondering how many other
cases they might have in their code where a similar coding technique was
used. Ouch! I hope for their sake there aren't that many ;-)

Anyway, I'm curious if someone can check this out against V7. Here is an
example script I ran against 8.1.7 here at home:

  1  declare
  2  cursor c1 (empno number) is
  3  select empno
  4  from emp e
  5  where e.empno = empno;
  6  v_empno number;
  7  begin
  8  open c1 (4567);
  9  fetch c1 into v_empno;
 10  dbms_output.put_line(to_char(v_empno));
 11  close c1;
 12* end;
SQL> /
7369

PL/SQL procedure successfully completed.

There is no employee "4567" and the output makes it obvious that the SQL was
treated as column = column, get all rows. The obvious solution is to avoid
the ambiguity in how the cursor parameter is named. But I am still
interested in how the above would be handled against V7.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: view contents of datafile

[Narender Akula]

hi joe,
You can use Tablespace Map in OEM 2.2 (may be 2.1) and also you can
reorganise them.
or you can use TOAD ( tablespace Map).

naren

-Original Message-
Sent: Thursday, 12 July 2001 11:45
To: Multiple recipients of list ORACLE-L


If my tablespace became so big that it had 3 datafiles
and became so fragmented, then I export and import
the whole databse, how can I tell if the REORG only
used up one or two datafiles.

OR is there a utility to see contents of a datafile?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Narender Akula
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: File placement ?????

[Paul Drake]

Janet Linsy wrote:
> 
> Hi,
> 
> I generage a report.txt using utlbstat/utlestat, and
> use www.oraPerf.com to format it.  In the formatted
> report, I saw that "Never split index and data files
> to different sets of disks".  Does that mean I'd
> better put datafile and index file on the same disk?
> Since data file and index file are very large, many
> times I put them on different disks.  Thank you for
> any advice.
> 
> Janet
> 

Janet,

Generalizations just plain suck.
(which is in itself, a generalization ...)

They would be so much better off using "it depends ..." instead of
"never".
I'd be interested in seeing their assumptions, reasoning and results.

If anything, I would tend to think that splitting indexes and data would
help to speed access, provided that *all_other_factors_are_equal*.

Maybe they're big fans of clusters, IOTs and object-type data
structures, where the index and data are stored together.
Maybe they like having everything in RAM, and reading the entire
database into memory at startup.
Maybe they like 1 MB stripe sizes on large RAID 0+1 (or RAID 4) volumes.

If you really think about it - an disk read is a disk read, and it is
most likely that either set of disk won't have the heads above the track
that you want - for a single set of block requests.
Maybe you get lucky, and the blocks are in the buffers on the hard
drives.

But imagine that the current execution path is nested loops, and an
index is driving the query that is accessing the table by rowid. If no
other disk read requests are being answered, with 2 different
tablespaces, and 2 different RAID volumes (on different physical drives)
- neither set of heads are seeking while procesing the query.

Are you running a few massive batch jobs, or hundreds of concurrent
transactions?
What's you OS I/O size, your database block size, are you doing mostly
full_table_scans and hash_joins?

maybe all of the blocks needed in the report that you analyzed were
cached, and physical disk access was not required.

maybe oraperf wants to push SAME with huge write-back caches of NVRAM.

maybe oraperf really likes WAFL and does not care about an OFA-compliant
arrangement.

But I cannot see how the statement "never split index and data files to
differnet sets of disks" could hold true. If you can find one case where
this is not valid, the statement is invalid.

lets see - what if the my current RAID 5 (he he) volume cannot contain
all of the datafiles for my data and index tablespaces datafiles - I
cannot put them on different disk sets - because oraperf.com told me to
never do so? When adding another volume would mean that no rebuild of
the single RAID volume would be required?

Do I have to add drives and rebuild the single RAID 5 volume, instead of
adding additional RAID vols?

I would say that the statement "Never split index and data files to
different sets of disks" invalid.

Of course, additional context is probably needed.
further investigation is probably warranted.
Maybe they're right, and I'm just being a naysayer.

I wonder what the "Gods of Disks" would have to say?

Yes, the statement is FALSE, if you can find a SINGLE example where it
is not TRUE.

time to find my asbestos shorts ...

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: view contents of datafile

[Kevin Lange]

This seems to work for me:


select a.tablespace_name, a.file_name, nvl(b.used,'No')
from dba_data_files a, 
 (select distinct a.file_id "FILE_ID", 'Yes' "USED" from dba_data_files
a, dba_extents b where a.file_id = b.file_id) b
where a.file_id = b.file_id (+)  
order by 1,2 

When I specify a specific set of tablespaces on my system I get :


select a.tablespace_name, a.file_name, nvl(b.used,'No')
from dba_data_files a, 
 (select distinct a.file_id "FILE_ID", 'Yes' "USED" from dba_data_files
a, dba_extents b where a.file_id = b.file_id) b
where a.file_id = b.file_id (+)  
and a.tablespace_name in ('XPRPI','XPRPT')
order by 1,2 

XPRPI   /u07/oradata/DEMO/xprpi02.dbf   No
XPRPI   /u08/oradata/DEMO/xprpi01.dbf   Yes
XPRPT   /u02/oradata/DEMO/xprpi02.dbf   Yes
XPRPT   /u04/oradata/DEMO/xprpt03.dbf   Yes
XPRPT   /u06/oradata/DEMO/xprpt02.dbf   Yes
XPRPT   /u07/oradata/DEMO/xprpt01.dbf   Yes

This is consistant since I just added the first file.



And, yes, there are utilities to look at the datafile.   Oracle's Enterprise
Manager's Performance pack had a tool that will do that 

-Original Message-
Sent: Wednesday, July 11, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L


If my tablespace became so big that it had 3 datafiles
and became so fragmented, then I export and import
the whole databse, how can I tell if the REORG only
used up one or two datafiles.

OR is there a utility to see contents of a datafile?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: GMT

[Marc Perkowitz]

As I usually do on timezone issues, I'm putting in my .02.

Keep in mind that you will need to switch between EDT and EST yourself.
There's nothing for this yet, though I heard rumors of something in 9i.
Anyone heard of anything new with timezones and 9i?

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 4:25 PM


> Thanks Ruth.  The new_time function was exactly what I was looking for!
>
> -Original Message-
> Gramolini
> Sent: Wednesday, July 11, 2001 3:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> This is to the person who asked the question about putting time into GMT.
>
> Here is a script that I got from one of the listers and modified.
>
> select to_char(sysdate,'MMDDYY HH:MI:SS'),
> TO_CHAR(new_time(sysdate,'EDT','GMT'),'MMDDYY HH:MI:SS') from dual;
>
> HTH,
> Ruth
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glenn Travis
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: File placement ?????

[Jack C. Applewhite]

Janet,

I've seen that recommendation, wondered why anyone would make it, and
totally ignored it!   8^)

If forced, I'll jam Control File, Redo Logs, Rollback Seg tablespace, and
Temp tablespace on the same drive, but I'll always put data and indexes on
separate drives.  The arguments for separate drives, IMHO, are far more
compelling than those against.

In our Production DB we've got "regular" data on one set of drives, the
associated LOB segments on another set of drives, the "regular" indexes on
yet another set of drives, and the interMedia indexes (for the LOB columns)
on yet a fourth set of drives.  Given that, I'm trying to figure out a way
to *further* "partition" the interMedia indexes across even *more* drives!
Our performance is excellent, even on "dirty old" Win2k!   ;^)  If we didn't
do this kind of separation, I shudder to think of how slow our queries would
be.  8^(

My recommendation - always separate your data and indexes onto separate
physical drives, even separate controllers, if you can.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Sent: Wednesday, July 11, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L


Hi,

I generage a report.txt using utlbstat/utlestat, and
use www.oraPerf.com to format it.  In the formatted
report, I saw that "Never split index and data files
to different sets of disks".  Does that mean I'd
better put datafile and index file on the same disk?
Since data file and index file are very large, many
times I put them on different disks.  Thank you for
any advice.

Janet

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why this SQL does not work?

[Kevin Lange]

Doh  as the man would say.

Absolutely, how can you have a rownum > or directly equal to a number other
than 1 when by the very nature that can never happen.

If you say = 5 or > , it will never happen without the rest of the data
there to increment the rownum to 5.


-Original Message-
Sent: Wednesday, July 11, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L


Rao,

This snippet from The Fine Manual explains it all... "= 5" or "> 1" will
return 0 rows:
--
Conditions testing for ROWNUM values greater than a positive integer are
always false. For example, this query returns no rows:

SELECT * FROM emp
WHERE ROWNUM > 1;


The first row fetched is assigned a ROWNUM of 1 and makes the condition
false. The second row to be fetched is now the first row and is also
assigned a ROWNUM of 1 and makes the condition false. All rows subsequently
fail to satisfy the condition, so no rows are returned.
--

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Maheswara
Sent: Wednesday, July 11, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L


List,

Following are two SQL statements.  The first SQL statement works OK (where
ROWNUM < 5 is used). The second SQL statement does not return any rows
(where ROWNUM = 5 is used).  This table contains 200 records.

First SQL statement
---
SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM < 5

Second SQL statement

SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM = 5

---
Question:

Why second SQL statement does not work?

I would be thankful for the clarification.

Thanks,

Rao
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

view contents of datafile

[Leyden, Joseph]

If my tablespace became so big that it had 3 datafiles
and became so fragmented, then I export and import
the whole databse, how can I tell if the REORG only
used up one or two datafiles.

OR is there a utility to see contents of a datafile?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How much SGA free?

[Seema Singh]

If hit ratio is good then what should be other consideration for free SGA?



>From: "orclbabu" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: How much SGA free?
>Date: Wed, 11 Jul 2001 14:13:26 -0800
>
>Seema
>
>the answer is "it depends"... you need tyo have enough space in your sga to
>maintain a healthy hit ratio.
>
>how high is healthy depends on the nature of application.
>
>Babu
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Wednesday, July 11, 2001 1:32 PM
>
>
> > Hi
> > How much percentage SGA should be free for OLTP application?
> > Thanks in advanvce.
> > -Seema
> > _
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: orclbabu
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Backup Question

[Kimberly Smith]

I only backup the archive logs and the directory that I put the hot backuped
data files.  The rest really is useless.  

-Original Message-
Sent: Wednesday, July 11, 2001 12:29 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Second RBS in system tablespace

[Stephane Faroult]

"Hillman, Alex" wrote:
> 
> Also you need rollback segment in system when creating database if your
> rollback tablespace is LMT.
> 
> Alex Hillman
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 4:44 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hello,
> 
> SYSTEM rbs is reserved actions against the SYSTEM tablespace.
> 
> There are some mis-conceptions against this issue.
> 
> Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too.
> 
> For example, Recursive transactions,in other words: Oracle kernel
> transactions
> by SYS users, do not always have to use SYSTEM rbs.
> 
> SYSTEM rbs is the last statation if there is no available slot in rbs in
> which
> current user transaction is assigned. So, Oracle kernel does not have to
> compete with user transactions.
> 
> hope this helps...
> 
> Kevin Lange wrote:
> 
> > As a guess I would think it was because the system tablespace is so active
> > with all the queries against the catalog.
> >
> > -Original Message-
> > Sent: Wednesday, July 11, 2001 12:03 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi Everybody
> >
> > I'm running 8.1.7 and i just read that i should have a second rollback
> > segment in the system tablespace.
> > Can someone tell me why this is and how big should i create it?
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: hp
> >   INET: [EMAIL PROTECTED]
> >


Well, in fact the second rollback segment in SYSTEM is a bootstrap
rollback segment. The problem is that if you only have the SYSTEM
tablespace (created by CREATE DATABASE) you cannot use it for DML on
tables in other tablespaces. There used to be a time (not so distant)
when you could not even use it to create rollback segments in another
tablespace, so the only way to proceed was to create this bootstrap
rollback segment RS0 (as small as possible), to put it online, then to
create a number of rollback segments in tablespace RBS (familiar to
anybody who has used Oracle prior to 9i), put them online, put RS0
offline (drop it if you want), and proceed.
  Since now (read 8i) you can use SYSTEM to create rollback segments in
RBS, RS0 is no longer necessary, but many people still create it (it
doesn't hurt).
Note that it is still true that you cannot insert into a table in a
tablespace other than SYSTEM if you only have the rollback segment
SYSTEM online (I have just experienced it on 8.1.7).
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

File placement ?????

[Janet Linsy]

Hi,

I generage a report.txt using utlbstat/utlestat, and
use www.oraPerf.com to format it.  In the formatted
report, I saw that "Never split index and data files
to different sets of disks".  Does that mean I'd
better put datafile and index file on the same disk? 
Since data file and index file are very large, many
times I put them on different disks.  Thank you for
any advice.

Janet

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why this SQL does not work?

[Stephane Faroult]

"Rao, Maheswara" wrote:
> 
> List,
> 
> Following are two SQL statements.  The first SQL statement works OK (where
> ROWNUM < 5 is used). The second SQL statement does not return any rows
> (where ROWNUM = 5 is used).  This table contains 200 records.
> 
> First SQL statement
> ---
> SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM < 5
> 
> Second SQL statement
> 
> SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM = 5
> 
> ---
> Question:
> 
> Why second SQL statement does not work?
> 
> I would be thankful for the clarification.
> 
> Thanks,
> 
> Rao
> [EMAIL PROTECTED]
> 

Rao,

   rownums are computed on the fly. In the first case the first row is
returned, is assigned rownum 1, it matches the condition, so it is
displayed, and so forth until the fifth row which brings everything to
an end. In the second case, since you never display a row # 1, you can
never get a row # 5. To get row 5 out, you must first pull the 4 other
rows out, which you can do by writing (beware, it's beginning to be
subtle) :

 SELECT PROCESSED_DATE
 FROM (SELECT PROCESSED_DATE, ROWNUM NUM
   FROM (SELECT PROCESSED_DATE
 FROM TRADES
 WHERE PROCESSED_STATUS = 0
 ORDER BY ENTRY_DATE)
   WHERE ROWNUM < 6)
 WHERE NUM = 5

 A word of explanation may be helpful. We must get out those £ù%à# 4
rows before the one we are interested in. So we use what you have used
so far and which works, to limit our fetching rows to what is STRICTLY
necessary. However, we just want the last one in the list, so we add the
rownum (renamed num, since rownum is a reserved word, to be able to
referenced it at the outer level) and, since this is an embedded query,
it becomes an almost ordinary column at the outer level and we can
specify our screening condition.

I have never used them (never really felt the necessity), but it is not
impossible that the so-called analytical functions could not be used in
such a case. However, I am pretty confident that what is above must be
close to the most efficient you can get to.

Now an aspirin.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Second RBS in system tablespace

[Hillman, Alex]

Also you need rollback segment in system when creating database if your
rollback tablespace is LMT.

Alex Hillman

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L


Hello,

SYSTEM rbs is reserved actions against the SYSTEM tablespace.

There are some mis-conceptions against this issue.

Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too.

For example, Recursive transactions,in other words: Oracle kernel
transactions
by SYS users, do not always have to use SYSTEM rbs.

SYSTEM rbs is the last statation if there is no available slot in rbs in
which
current user transaction is assigned. So, Oracle kernel does not have to
compete with user transactions.

hope this helps...

Kevin Lange wrote:

> As a guess I would think it was because the system tablespace is so active
> with all the queries against the catalog.
>
> -Original Message-
> Sent: Wednesday, July 11, 2001 12:03 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi Everybody
>
> I'm running 8.1.7 and i just read that i should have a second rollback
> segment in the system tablespace.
> Can someone tell me why this is and how big should i create it?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: hp
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why this SQL does not work?

[Henry Poras]

>From the Oracle docs (SQL Reference)

"For each row returned by a query, the ROWNUM pseudocolumn returns a number
indicating the order in which Oracle selects the row from a table or set of
joined rows. The first row selected has a ROWNUM of 1, the second has 2, and
so on. 
...
Conditions testing for ROWNUM values greater than a positive integer are
always false. For example, this query returns no rows: 

SELECT * FROM emp
WHERE ROWNUM > 1;


The first row fetched is assigned a ROWNUM of 1 and makes the condition
false. The second row to be fetched is now the first row and is also
assigned a ROWNUM of 1 and makes the condition false. All rows subsequently
fail to satisfy the condition, so no rows are returned."

Henry

-Original Message-
Sent: Wednesday, July 11, 2001 6:00 PM
To: Multiple recipients of list ORACLE-L


First guess  There are only 4 rows of data returned ??

Change the first query to

  Where rownum <= 5

and let us know if you actually get that 5th row.  If you did not then I
would say that the queries are both working but there are only 4 rows that
match the criteria.

-Original Message-
Sent: Wednesday, July 11, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L


List,

Following are two SQL statements.  The first SQL statement works OK (where
ROWNUM < 5 is used). The second SQL statement does not return any rows
(where ROWNUM = 5 is used).  This table contains 200 records.

First SQL statement
---
SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM < 5  

Second SQL statement

SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM = 5

---
Question:

Why second SQL statement does not work?

I would be thankful for the clarification.

Thanks,

Rao
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Anyone know what "refresh controlfile command" is?

[Post, Ethan]

Metalink is unusable at the moment and google gets me nada...it's one of the
V$SYSTEM_EVENTS...what is it, what causes it, how often should it occur?

"refresh controlfile command"

- Thanks,
- Ethan Post
- http://www.geocities.com/epost1



--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How much SGA free?

[orclbabu]

Seema

the answer is "it depends"... you need tyo have enough space in your sga to
maintain a healthy hit ratio.

how high is healthy depends on the nature of application.

Babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 1:32 PM


> Hi
> How much percentage SGA should be free for OLTP application?
> Thanks in advanvce.
> -Seema
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orclbabu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why this SQL does not work?

[Regina Harter]

The way I understand it is rownum does not exist until the data set is 
returned.  The first row returned therefore is rownum = 1 because it is the 
first row in the dataset, but you are looking for rownum = 5, so it throws 
that one away.  The next row is returned and again is rownum = 1 because it 
is now the first row in the dataset, but again you are looking for rownum = 
5, so it throws that away too.  And so on and so on.  Basically, it never 
gets to rownum = 5.  So you can use rownum = 1 or rownum < anything more 
than 1, but nothing else.

At 01:44 PM 7/11/01 -0800, you wrote:
>List,
>
>Following are two SQL statements.  The first SQL statement works OK (where
>ROWNUM < 5 is used). The second SQL statement does not return any rows
>(where ROWNUM = 5 is used).  This table contains 200 records.
>
>First SQL statement
>---
>SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM < 5
>
>Second SQL statement
>
>SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM = 5
>
>---
>Question:
>
>Why second SQL statement does not work?
>
>I would be thankful for the clarification.
>
>Thanks,
>
>Rao
>[EMAIL PROTECTED]
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rao, Maheswara
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why this SQL does not work?

[Jack C. Applewhite]

Rao,

This snippet from The Fine Manual explains it all... "= 5" or "> 1" will
return 0 rows:
--
Conditions testing for ROWNUM values greater than a positive integer are
always false. For example, this query returns no rows:

SELECT * FROM emp
WHERE ROWNUM > 1;


The first row fetched is assigned a ROWNUM of 1 and makes the condition
false. The second row to be fetched is now the first row and is also
assigned a ROWNUM of 1 and makes the condition false. All rows subsequently
fail to satisfy the condition, so no rows are returned.
--

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Maheswara
Sent: Wednesday, July 11, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L


List,

Following are two SQL statements.  The first SQL statement works OK (where
ROWNUM < 5 is used). The second SQL statement does not return any rows
(where ROWNUM = 5 is used).  This table contains 200 records.

First SQL statement
---
SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM < 5

Second SQL statement

SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM = 5

---
Question:

Why second SQL statement does not work?

I would be thankful for the clarification.

Thanks,

Rao
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why this SQL does not work?

[orclbabu]

rownum will not work for "rownum = anything_but_1".

this is because rownum is assigend after the cursor is fetched.

oracle fetches the first row and assigns a rownum of 1, checks where rownum
= 5 condition, finds that it is not satisfied and discards the row.
it fetches another row, and since the prev row is discarded this new row
will have a rownum of 1 and so it is also discarded...

thus only if you give rownum = 1 or rownum < x it will work.

the following will not work

rownum = x  where x >1
rownum > x where x > 0

babu

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 4:44 PM


> List,
>
> Following are two SQL statements.  The first SQL statement works OK (where
> ROWNUM < 5 is used). The second SQL statement does not return any rows
> (where ROWNUM = 5 is used).  This table contains 200 records.
>
> First SQL statement
> ---
> SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM < 5
>
> Second SQL statement
> 
> SELECT * FROM
>   (SELECT PROCESSED_DATE
>  FROM TRADES WHERE PROCESSED_STATUS = 0
>   ORDER BY ENTRY_DATE)
>   WHERE ROWNUM = 5
>
> ---
> Question:
>
> Why second SQL statement does not work?
>
> I would be thankful for the clarification.
>
> Thanks,
>
> Rao
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rao, Maheswara
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orclbabu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why this SQL does not work?

[Kevin Lange]

First guess  There are only 4 rows of data returned ??

Change the first query to

  Where rownum <= 5

and let us know if you actually get that 5th row.  If you did not then I
would say that the queries are both working but there are only 4 rows that
match the criteria.

-Original Message-
Sent: Wednesday, July 11, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L


List,

Following are two SQL statements.  The first SQL statement works OK (where
ROWNUM < 5 is used). The second SQL statement does not return any rows
(where ROWNUM = 5 is used).  This table contains 200 records.

First SQL statement
---
SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM < 5  

Second SQL statement

SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM = 5

---
Question:

Why second SQL statement does not work?

I would be thankful for the clarification.

Thanks,

Rao
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Why this SQL does not work?

[Rao, Maheswara]

List,

Following are two SQL statements.  The first SQL statement works OK (where
ROWNUM < 5 is used). The second SQL statement does not return any rows
(where ROWNUM = 5 is used).  This table contains 200 records.

First SQL statement
---
SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM < 5  

Second SQL statement

SELECT * FROM
  (SELECT PROCESSED_DATE
 FROM TRADES WHERE PROCESSED_STATUS = 0
  ORDER BY ENTRY_DATE)
  WHERE ROWNUM = 5

---
Question:

Why second SQL statement does not work?

I would be thankful for the clarification.

Thanks,

Rao
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename alert log

[tpall]

Sorry, I thought one thing and typed another.  We do a mv in each of our
8.1.7.x databases on Sun/Sparc 7&8 and have been doing it for years from
8.0.5 on.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 8:05 AM


> Okay folks, I *knew* I wasn't crazy!  thanks to Anita for finding the post
> that Bruce sent to the list, that had the metalink doc in it
>
> There was also a bug filed on it (which was closed as "not a bug") bug#
> 1388186
>
> It was filed for Solaris so this might just mean that the "feature" is
> Solaris specific, since people here are saying that they haven't seen it
on
> other platforms.
>
> We are on Solaris, but our scripts are written such that we don't rename
the
> alert log so I haven't been able to prove it one way or another.
>
> Rachel
>
> Note:122401.1
> Type:  BULLETIN
> Status: PUBLISHED
> Content Type: TEXT/PLAIN
> Creation Date: 18-OCT-2000
> Last Revision Date: 14-MAY-2001
>
> Problem Description
> ---
>
> The Oracle background processes has an open file descriptor on the
> alert.log.
> When the database is up and running it continually holds this file
> descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to
> 8.1.7.
>
> This poses the question: What if the database is up and the alert.log
> gets too large. Do I have to shutdown the database to release the open
file
> descriptor on the alert.log, then deal with the large alert.log?
>
>
> Solution Description
> 
>
> You are able to copy the alert.log while the database is up and running.
>
> 1) Create an empty file:
>(example: touch nullfile.log)
>
> 2) Replace the old alert.log with the new empty file:
>(example: mv nullfile.log alert.log)
>
> The running database experiences no affects when doing this.
>
>
> Explanation
> ---
>
> Having the continual open file descriptor on the alert.log is intended
> behaviour for the database.
>
>
>
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename alert log

[tpall]

I don't know if anyone mentioned Solaris.  Running Sun/Sparc Solaris 6&7 and
Oracle 8.1.7.1.  A cron job filed shell script does a cp only, no touch,
then mails the old log to the DBAs.  It works the same way as it did a month
or two ago when we went from 8.0.5 to 8.1.7:  next time Oracle needs to
write something, it creates a new file.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 8:05 AM


> Okay folks, I *knew* I wasn't crazy!  thanks to Anita for finding the post
> that Bruce sent to the list, that had the metalink doc in it
>
> There was also a bug filed on it (which was closed as "not a bug") bug#
> 1388186
>
> It was filed for Solaris so this might just mean that the "feature" is
> Solaris specific, since people here are saying that they haven't seen it
on
> other platforms.
>
> We are on Solaris, but our scripts are written such that we don't rename
the
> alert log so I haven't been able to prove it one way or another.
>
> Rachel
>
> Note:122401.1
> Type:  BULLETIN
> Status: PUBLISHED
> Content Type: TEXT/PLAIN
> Creation Date: 18-OCT-2000
> Last Revision Date: 14-MAY-2001
>
> Problem Description
> ---
>
> The Oracle background processes has an open file descriptor on the
> alert.log.
> When the database is up and running it continually holds this file
> descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to
> 8.1.7.
>
> This poses the question: What if the database is up and the alert.log
> gets too large. Do I have to shutdown the database to release the open
file
> descriptor on the alert.log, then deal with the large alert.log?
>
>
> Solution Description
> 
>
> You are able to copy the alert.log while the database is up and running.
>
> 1) Create an empty file:
>(example: touch nullfile.log)
>
> 2) Replace the old alert.log with the new empty file:
>(example: mv nullfile.log alert.log)
>
> The running database experiences no affects when doing this.
>
>
> Explanation
> ---
>
> Having the continual open file descriptor on the alert.log is intended
> behaviour for the database.
>
>
>
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: GMT

[Glenn Travis]

Thanks Ruth.  The new_time function was exactly what I was looking for!

-Original Message-
Gramolini
Sent: Wednesday, July 11, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


This is to the person who asked the question about putting time into GMT.

Here is a script that I got from one of the listers and modified.

select to_char(sysdate,'MMDDYY HH:MI:SS'), 
TO_CHAR(new_time(sysdate,'EDT','GMT'),'MMDDYY HH:MI:SS') from dual;

HTH,
Ruth





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How much Buffer busy waits?

[Seema Singh]

Hi
I saw the statistics of buffer busy waits is 10930 in our DB.IS it 
correct?Let me know how much if this value should be in normal DB 
operations?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Backup Question

[Kevin Lange]

And yet another perspective.

Dennis;

Things to keep in mind:
1. Tapes are cheaper than rebuilding all the data by hand.
2. Managers who make decisions to put tape cost more important can
be replaced.

Basic Backup Schedule:
Backed up logs Hourly
Hot Incremental Backup weekly
Cold Backup Monthly

Tape Recovery:
We kept between 1 and 2 months worth of backups on hand.  At the
beginning of each month we deleted all tapes from the month PRIOR to the
last cold backup.  So, at the beginning of each month, we had 1 month of
backups.  Over the next month this grew to 2 months of saves until we hit
the end of the month again and started the deletion process again.

If you are not that paranoid as we were then I would suggest reducing the 1
- 2 month range down to 1 - 2 weeks.   Every week you delete the old data 2
weeks ago.  

I guess the key thing to remember is that , after the cold backup, as long
as you can guarantee the cold backup tape is good, then the previous hot and
log backups are superfluous

Kevin


-Original Message-
Sent: Wednesday, July 11, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L


Dennis,
This is the method we've been using for many years.  There has never been a
case where the open datafile has been required for any kind of restore.
However, I can count on one hand the number of times where we had to go to
tape for a database recovery. FWIW

Michael Hand
Polaroid Corp

-Original Message-
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Backup Question

[Koivu, Lisa]

Title: RE: DB Backup Question





Dennis, your sysadmin is right.  He shoudln't have to back up your raw data files, only your backup sets from your hot backups.  I've seen this in practice at my previous position and have validated it as well. 

If you are unsure, have you tried practicing this?  If nothing else it will give you peace of mind. 


HTH
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L
Subject:    DB Backup Question


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: A danger in cloning databases

[Richard Ji]

And I think in a cluster, if you configure the listener process to
be a service, then it has to use the IP as well.

>>> [EMAIL PROTECTED] 07/11/01 03:51PM >>>
Nor is it an option on MPE where the network layer is "primitive" to say the
least.  One HAS to use the actual IP address of the server.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   7/11/2001 10:26 AM

When you run HP ServiceGuard that is not an option.

-Original Message-
Sent: Wednesday, July 11, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Use localhost as hostname in listener.ora and you will never have this
problem.

Alex Hillman

-Original Message-
Sent: Wednesday, July 11, 2001 11:18 AM
To: Multiple recipients of list ORACLE-L


Jay,

Did that several months ago with our HP-MPE box.  The problem was that
we
changed the IP address of the box and brought a new one online, with the old
ones original IP.  Now MPE has NO idea of what a DNS server is so one has to
bury the actual IP address into things like listener.ora and tnsnames.ora.
We
had a pile of this smelly brown matter all over the place the next evening
when
the new development box ran it's nightly processes.  OOPS!!!

Dick Goulet

Reply Separator
Author: "Miller; Jay" <[EMAIL PROTECTED]>
Date:   7/11/2001 6:56 AM

Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP comma

Re: Second RBS in system tablespace

[Danisment Gazi Unal (Unal Bilisim)]

Hello,

SYSTEM rbs is reserved actions against the SYSTEM tablespace.

There are some mis-conceptions against this issue.

Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too.

For example, Recursive transactions,in other words: Oracle kernel transactions
by SYS users, do not always have to use SYSTEM rbs.

SYSTEM rbs is the last statation if there is no available slot in rbs in which
current user transaction is assigned. So, Oracle kernel does not have to
compete with user transactions.

hope this helps...

Kevin Lange wrote:

> As a guess I would think it was because the system tablespace is so active
> with all the queries against the catalog.
>
> -Original Message-
> Sent: Wednesday, July 11, 2001 12:03 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi Everybody
>
> I'm running 8.1.7 and i just read that i should have a second rollback
> segment in the system tablespace.
> Can someone tell me why this is and how big should i create it?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: hp
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Scsi I/O speed

[Kevin Kostyszyn]

They are not, two different controllers.

-Original Message-
Sent: Wednesday, July 11, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Kev,

Make sure that the SCSI CD-ROM or Tape Drive aren't connected to this
controller.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L


Well yeah, all of this makes perfect sense to me.  However, if I am testing
the devices I would assume that the test software is going to send as much
info as it can down the pipe, you know stuff it.  With the Ultra/160 I am
assuming that there is only a 80mb/s drive in there, I never opened it up
and looked, but I will now.  I will use a couple different utilities and see
if the rates are the same.
Also, I know that the drives I have in these machines are all 80mb/s
drives, at least in the other machines, so there shouldn't be any device
that is "bringing" down the rate.  I don't know, but I would love to try and
iprove this rate.
KK

-Original Message-
Sent: Wednesday, July 11, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L


Kevin,

One thing to remember with SCSI...it's not necessarily the speed of the
controller that matters.  The SCSI bus will be slowed down to the speed of
the slowest device in the chain...or on the bus.  For example, if you have a
controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all
running off the same controller...the bus speed will be no more than 40mb/s
(the speed of the slowest device).  Again, that is the theoretical max
speed.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


Hi all,
I was measuring the i/o performance of my scsi drives and I have a
quick
question that maybe someone could shed some light upon.  Currently I am
using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
80mb/s.  Well, when I perform the test all of the machines seem to be
operation at halp of the max speed.  One operates at about 20mb/s read and
write and the others are even slower than that.  Now on the first one, it is
the only HD on the controller, on the others there are two disks.  Even on
my Ultra/160 it seems to be maxing out at 40 read and write.
Am I missing something?  Am I reading this the wrong way?  Help:(

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for ot

RE: export/import object types

[Richard Ji]

Kevin,

Thanks for letting me know that I am not the only one had to
go throught this. :)  Thank God I have VI editor, can't imagine
if I had to use notepad on windows to edit that file.  There are
106 types!

Richard Ji

>>> [EMAIL PROTECTED] 07/11/01 01:15PM >>>
I've experienced and must admit that it is a pain in the arse to deal with:)
KK

-Original Message-
Sent: Wednesday, July 11, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I wonder if anyone has seen this before.

I export an user A, then import it into user B in a different database
and everything is ok.  Then I use the same export file to import into
user C in the same database as user B and all the "CREATE TYPE"
failed because Oracle retains the object id in the export file and when
importing into user C it tries to create them with the same object id
and since user B already has it it failed.  I had to manually delete
the object id from the log and recreate it.

It's not a huge problem since it's rare that I do something like this.
But just wondering why would Oracle retain the object id for TYPE?
It certainly didn't keep the same object id for other objects like table,
etc.

Any thoughts?

Richard Ji

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DB Backup Question

[Gene Sais]

If the db is open and not in hot backup mode, then why bother backing up the 
datafiles.  I opt for backing up system files separate from oracle datafiles.
Gene
>>> [EMAIL PROTECTED] 07/11/01 03:28PM >>>
Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-12564: TNS:connection refused

[A. Bardeen]

Chris,

This is frequently caused by a problem with the
tnsnames.ora (mismatched parentheses, invalid
oracle_home, etc...).  There are several docs on
metalink regarding this error for various
configurations and releases.

As others have suggested, you might also enable net8
tracing as that is most likely to reveal the real
culprit.

HTH,

-- Anita

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> Hello everyone,
> 
> A fellow DBA sent me the below email to forward onto
> the list.  Perhaps
> someone can give us some clues as to what were
> missing??  The original
> message they got was "listener not found" or
> something like that.  So they
> made some updates to the firewall to allow access,
> and now there getting
> ORA-12564.  Many thanks!!!
> 
>
*
> Chris,
>   Is there anything on the listserv about this error:
>  ORA-12564:
> TNS:connection refused.  We are trying to resolve a
> connectivity issue using
> Gauntlet Firewall.  We are trying to connect to a
> database from the
> production server to the development server, both
> are inside the service
> network.
> 
> Michael Rothouse
>
*
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DB Backup Question

[Ruth Gramolini]

We do rman online backups to disk and put just these backups on tape each
day. The sys admin takes care of system backups separately.

Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 3:28 PM


> Hi all,
> We are running into tape capacity problems and unix admin came to me
asking
> if we could skip backing up some drives. Right now we are doing hot
backups
> on all production databases to disk and then the whole server get backed
up
> to tape. Since the backups for open database files are not valid, the unix
> admin asked if we could only backup the drives that has the backup dumps.
> One side of me says this can be done but another nagging side of me is not
> sure about this. So I am posting this to the list and see what other folks
> think of this one.
> Thanks
> Dennis Meng
> Database Administrator
> Focal Communications
> 847-954-8328
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Backup Question

[Miller, Jay]

We don't back up the filesystems that have the live data during our tape
backups.  Since these files are effectively unusable there's no point in
saving them.

Jay Miller

-Original Message-
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DB Backup Question

[Stephane Faroult]

[EMAIL PROTECTED] wrote:
> 
> Hi all,
> We are running into tape capacity problems and unix admin came to me asking
> if we could skip backing up some drives. Right now we are doing hot backups
> on all production databases to disk and then the whole server get backed up
> to tape. Since the backups for open database files are not valid, the unix
> admin asked if we could only backup the drives that has the backup dumps.
> One side of me says this can be done but another nagging side of me is not
> sure about this. So I am posting this to the list and see what other folks
> think of this one.
> Thanks
> Dennis Meng
> Database Administrator
> Focal Communications
> 847-954-8328
> 

Dennis,

  Do not listen to your nagging side, you are totally right. Backing up
the backup is enough.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: Unix tee command

[Oliver Artelt]

tee copies it's standard input both to standard output and the file. You can 
see what it does and have a log file after that.

BTW man tee is faster than putting this onto the list

oli


[EMAIL PROTECTED] wrote:
> I do not understand the difference between these two commands:
> 
>   script_file > log_file
>   script_file | tee log_file
> 
> As I understand, the first runs and redirects its standard output to a log
> file. The second runs and pipes its standard output to the tee command,
> which copies its standard input into its standard output. I have been
> instructed to use the latter, but dont want to do it blindly without
> understanding why.
> 
> Thanks
> Erik
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Erik Williams
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

GMT

[Ruth Gramolini]

This is to the person who asked the question about putting time into GMT.

Here is a script that I got from one of the listers and modified.

select to_char(sysdate,'MMDDYY HH:MI:SS'), 
TO_CHAR(new_time(sysdate,'EDT','GMT'),'MMDDYY HH:MI:SS') from dual;

HTH,
Ruth





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: A danger in cloning databases

[dgoulet]

Nor is it an option on MPE where the network layer is "primitive" to say the
least.  One HAS to use the actual IP address of the server.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   7/11/2001 10:26 AM

When you run HP ServiceGuard that is not an option.

-Original Message-
Sent: Wednesday, July 11, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Use localhost as hostname in listener.ora and you will never have this
problem.

Alex Hillman

-Original Message-
Sent: Wednesday, July 11, 2001 11:18 AM
To: Multiple recipients of list ORACLE-L


Jay,

Did that several months ago with our HP-MPE box.  The problem was that
we
changed the IP address of the box and brought a new one online, with the old
ones original IP.  Now MPE has NO idea of what a DNS server is so one has to
bury the actual IP address into things like listener.ora and tnsnames.ora.
We
had a pile of this smelly brown matter all over the place the next evening
when
the new development box ran it's nightly processes.  OOPS!!!

Dick Goulet

Reply Separator
Author: "Miller; Jay" <[EMAIL PROTECTED]>
Date:   7/11/2001 6:56 AM

Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Se

Re: DB Backup Question

[Joe Frohne]

Hi,

We currently do hot backups to disk and then dump to tape only the
directories that contain all the pices of the hot backups.  We also do a
cold backup once a week to catch all of the O/S type stuff along with
Oracle.

I am assuming that anything else that is Oracle related would be static
enough to get off of the weekly backups should the need arise.  I.E.  Init
files, scripts and the like.

HTH

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  Joe Frohne[EMAIL PROTECTED]
  OCP Database Administratorhttp://www.rawsonoaks.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


On Wed, 11 Jul 2001 [EMAIL PROTECTED] wrote:

> Hi all,
> We are running into tape capacity problems and unix admin came to me asking
> if we could skip backing up some drives. Right now we are doing hot backups
> on all production databases to disk and then the whole server get backed up
> to tape. Since the backups for open database files are not valid, the unix
> admin asked if we could only backup the drives that has the backup dumps.
> One side of me says this can be done but another nagging side of me is not
> sure about this. So I am posting this to the list and see what other folks
> think of this one.
> Thanks
> Dennis Meng
> Database Administrator
> Focal Communications
> 847-954-8328
> 
> 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Scsi I/O speed

[Haskins, Ed]

Kev,

Make sure that the SCSI CD-ROM or Tape Drive aren't connected to this
controller.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L


Well yeah, all of this makes perfect sense to me.  However, if I am testing
the devices I would assume that the test software is going to send as much
info as it can down the pipe, you know stuff it.  With the Ultra/160 I am
assuming that there is only a 80mb/s drive in there, I never opened it up
and looked, but I will now.  I will use a couple different utilities and see
if the rates are the same.
Also, I know that the drives I have in these machines are all 80mb/s
drives, at least in the other machines, so there shouldn't be any device
that is "bringing" down the rate.  I don't know, but I would love to try and
iprove this rate.
KK

-Original Message-
Sent: Wednesday, July 11, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L


Kevin,

One thing to remember with SCSI...it's not necessarily the speed of the
controller that matters.  The SCSI bus will be slowed down to the speed of
the slowest device in the chain...or on the bus.  For example, if you have a
controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all
running off the same controller...the bus speed will be no more than 40mb/s
(the speed of the slowest device).  Again, that is the theoretical max
speed.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


Hi all,
I was measuring the i/o performance of my scsi drives and I have a
quick
question that maybe someone could shed some light upon.  Currently I am
using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
80mb/s.  Well, when I perform the test all of the machines seem to be
operation at halp of the max speed.  One operates at about 20mb/s read and
write and the others are even slower than that.  Now on the first one, it is
the only HD on the controller, on the others there are two disks.  Even on
my Ultra/160 it seems to be maxing out at 40 read and write.
Am I missing something?  Am I reading this the wrong way?  Help:(

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Backup Question

[Hand, Michael T]

Dennis,
This is the method we've been using for many years.  There has never been a
case where the open datafile has been required for any kind of restore.
However, I can count on one hand the number of times where we had to go to
tape for a database recovery. FWIW

Michael Hand
Polaroid Corp

-Original Message-
Sent: Wednesday, July 11, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on NT unattended installation

[JOE TESTA]

Ed thats great no one here has been successful with it(or that 
will at least own up to it) ;)
 
joe
 
>>> [EMAIL PROTECTED] 07/11/01 03:01PM 
>>>
Joe,
 
I've done it for the Oracle 
Client, successfully.  This question was posted on LazyDBA, and a couple 
others responded that they were successful with it.
 
Ed

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on NT unattended installation
  Ed, you've gotten thats to work?, theory is nice, but r/l is 
  what counts
   
  joe
   
  >>> [EMAIL PROTECTED] 07/11/01 02:05PM 
  >>>
  Audrey,
   
  Yes, 
  you can do a silent install.  On a workstation / server that has Oracle 
  installed (NT/2000), go to:
   
  START | PROGRAMS | Oracle Installation Products | 
  Universal Installed Concepts Guide
   
  This 
  is in HTML format and will show you how you can do a silent 
  install.
   
  Ed
  
-Original Message-From: Andrey Bronfin 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle on NT unattended installation
Dear list ! Is 
there a possibility to do an unattended installation of Oracle server 
(8.1.7) on NT (Win2000) ? I mean an 
installation with a script or so without answering questions and clicking 
'Next' during the installation. If there 
is such a possibility for NT , would You please point me to a manual 
? I tried to RTFM and found 
nothing. Thanks a lot in advance. 
Andrey. 

Re[2]: Anybody running 9iAS using Microsoft's IIS

[dgoulet]

Question, If Damagement is afraid of being hacked with Apache why are they so
sure about IIS?  With all of the CERT advisories running around it is rather
obvious that IIS is as open a Swiss Cheese.

Dick Goulet

Reply Separator
Author: "Thater; William" <[EMAIL PROTECTED]>
Date:   7/11/2001 8:56 AM

Luis DeUrioste wrote:
> 
> Fellow LISTERS,
> 
> Is anybody running 9iAS on MicroSoft's IIS ?
> Damagement has reservations on using Apache since it is Open Source. I guess
> they fear hack attacks.
> Any information will be highly appreciated.
> 
> TIA
> 
> Tavo

we tried but never got it working.  we're happy using apache.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
How should I know if it works? That's what Beta testers are for, I only
coded it.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Second RBS in system tablespace

[JOE TESTA]

it has to do with inode #1 never being used in a filesystem, 
no wait, that was a bad joke by the unix guys when they wrote the 
OS.
 
its a good question but only for historical purposes, as its 
not requierd anymore.
 
joe
 
>>> [EMAIL PROTECTED] 07/11/01 03:11PM >>>As a 
guess I would think it was because the system tablespace is so activewith 
all the queries against the catalog.-Original Message-Sent: 
Wednesday, July 11, 2001 12:03 PMTo: Multiple recipients of list 
ORACLE-LHi EverybodyI'm running 8.1.7 and i just read that i 
should have a second rollbacksegment in the system tablespace.Can 
someone tell me why this is and how big should i create it?-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
hp  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Kevin Lange  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

Re: ORA-12564: TNS:connection refused

[JOE TESTA]

have you tried tracing at the admin level(alot of stuff to 
sift thru but interesting reading just the same).
 
Yea, yea i know, only WWCS should tell you to trace at the 
admin level :)
 
joe
 
>>> [EMAIL PROTECTED] 07/11/01 02:06PM 
>>>Hello everyone,A fellow DBA sent me the below email to 
forward onto the list.  Perhapssomeone can give us some clues as to 
what were missing??  The originalmessage they got was "listener not 
found" or something like that.  So theymade some updates to the 
firewall to allow access, and now there gettingORA-12564.  Many 
thanks!!!*Chris,    
Is there anything on the listserv about this error:  
ORA-12564:TNS:connection refused.  We are trying to resolve a 
connectivity issue usingGauntlet Firewall.  We are trying to connect to 
a database from theproduction server to the development server, both are 
inside the servicenetwork.Michael 
Rothouse*-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
Grabowy, Chris  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

DB Backup Question

[dmeng]

Hi all,
We are running into tape capacity problems and unix admin came to me asking
if we could skip backing up some drives. Right now we are doing hot backups
on all production databases to disk and then the whole server get backed up
to tape. Since the backups for open database files are not valid, the unix
admin asked if we could only backup the drives that has the backup dumps.
One side of me says this can be done but another nagging side of me is not
sure about this. So I am posting this to the list and see what other folks
think of this one.
Thanks
Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Second RBS in system tablespace

[Kevin Lange]

As a guess I would think it was because the system tablespace is so active
with all the queries against the catalog.

-Original Message-
Sent: Wednesday, July 11, 2001 12:03 PM
To: Multiple recipients of list ORACLE-L


Hi Everybody

I'm running 8.1.7 and i just read that i should have a second rollback
segment in the system tablespace.
Can someone tell me why this is and how big should i create it?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: hp
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: universal installer question

[JOE TESTA]

as he answers his own question:
 
Doc 103198.1
 
This functionality (a completely character mode install) will be added into 
Oracle 8.2.x.
 
 
dohh, we skipped 8.2, so oracle corp is off the hook for it :)
 
joe
 
>>> [EMAIL PROTECTED] 07/11/01 03:01PM 
>>>
rumor had it at one time that there would be a text based 
installer available again, anyone know what happened to that 
concept?
 
joe
 

RE: Oracle on NT unattended installation

[Haskins, Ed]

Joe,
 
I've done it for the Oracle 
Client, successfully.  This question was posted on LazyDBA, and a couple 
others responded that they were successful with it.
 
Ed

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on NT unattended installation
  Ed, you've gotten thats to work?, theory is nice, but r/l is 
  what counts
   
  joe
   
  >>> [EMAIL PROTECTED] 07/11/01 02:05PM 
  >>>
  Audrey,
   
  Yes, 
  you can do a silent install.  On a workstation / server that has Oracle 
  installed (NT/2000), go to:
   
  START | PROGRAMS | Oracle Installation Products | 
  Universal Installed Concepts Guide
   
  This 
  is in HTML format and will show you how you can do a silent 
  install.
   
  Ed
  
-Original Message-From: Andrey Bronfin 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle on NT unattended installation
Dear list ! Is 
there a possibility to do an unattended installation of Oracle server 
(8.1.7) on NT (Win2000) ? I mean an 
installation with a script or so without answering questions and clicking 
'Next' during the installation. If there 
is such a possibility for NT , would You please point me to a manual 
? I tried to RTFM and found 
nothing. Thanks a lot in advance. 
Andrey. 

Re: How does Oracle store NUMBER datatypes internally?

[A. Bardeen]

See Note: 1031902.6 "How Does Oracle Store Internal
Numeric Data?" for more details.

HTH,

-- Anita

--- Pablo ksksksk <[EMAIL PROTECTED]> wrote:
> Can someone point me a document or something that
> explains how does Oracle store NUMBER datatypes
> internally?
> 
> TIA
> 
>
___
> Do You Yahoo!?
> Yahoo! Messenger: Comunicación instantánea gratis
> con tu gente -
> http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

silent installs via OUI installer

[JOE TESTA]

Doc id 74182.1, last revision jun 8, 2001
 
in there they  say:
 
OUI KEY FEATURES:
 
"In the future, OUI will allow silent installs via a response 
driver, patch application capability, a cancel/resume capability, and the 
ability to rollback to a previous system state."
 
Makes me wonder if its not intended to work.
 
joe
 
 

How much SGA free?

[Seema Singh]

Hi
How much percentage SGA should be free for OLTP application?
Thanks in advanvce.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A danger in cloning databases

[Kimberly Smith]

When you run HP ServiceGuard that is not an option.

-Original Message-
Sent: Wednesday, July 11, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Use localhost as hostname in listener.ora and you will never have this
problem.

Alex Hillman

-Original Message-
Sent: Wednesday, July 11, 2001 11:18 AM
To: Multiple recipients of list ORACLE-L


Jay,

Did that several months ago with our HP-MPE box.  The problem was that
we
changed the IP address of the box and brought a new one online, with the old
ones original IP.  Now MPE has NO idea of what a DNS server is so one has to
bury the actual IP address into things like listener.ora and tnsnames.ora.
We
had a pile of this smelly brown matter all over the place the next evening
when
the new development box ran it's nightly processes.  OOPS!!!

Dick Goulet

Reply Separator
Author: "Miller; Jay" <[EMAIL PROTECTED]>
Date:   7/11/2001 6:56 AM

Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How does Oracle store NUMBER datatypes internally?

[Norrell, Brian]

Without checking the manual (corrections welcome):

Byte 1: number of bytes for storage (# of digits divided by 2)
Byte 2: where the decimal goes (not sure of exact format)
Byte 3-x: pairs of digits

1576.89
gets stored something akin to:
decimal:4 2(4?) 15 76 89
HEX:04 02 0f 4c 59

The key point is the pairing of digits into values in the range of 0 to 99
that waste minimal space in the byte while being quick to retrieve in human
readable format.  The big drawback here is that almost every mathematical
function is more cumbersome in this notation, and therefore slower.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Wednesday, July 11, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L


Can someone point me a document or something that
explains how does Oracle store NUMBER datatypes
internally?

TIA

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Norrell, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Installation oracle through responsefile

[Jared . Still]

So far, I have not heard of any successes with this.

I've not been able to make it work either.

Jared



   
 
"Jay Hostetter"
 
   
tions.com>cc:  
 
Sent by:  Subject: Re: Installation oracle 
through  responsefile
[EMAIL PROTECTED]   
 
   
 
   
 
07/11/01 05:25 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Has ANYBODY ever been able to successfully use a response file?  Please
share the secret with us!

Thanks,



Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA

>>> [EMAIL PROTECTED] 07/10/01 04:35PM >>>
With WWS help, we have tried the non-interactive installation. We have
NEVER gotten it to succeed.

Terry

Brijesh Lal wrote:

> Hi All
>
> I am trying to install oracle 8.16 in non-interactive
> mode(silent) mode. However installation does not
> proceed and fails
> I am giving following command
> runInstaller -silent -responsefile /oracle/response/
> ee_typical.rsp
> However in /tmp/silentInstall.log I get following
> error
>
> No forced value specified for the variable
> ORACLE_HOME, associated with
> property ToLocation, in dialog
> oracle.sysman.oii.oiif.oiifw.OiifwInstLocWCDE
>
> This silent installation was unsuccessful.
> Warning :*** Alert: Do you really want to exit? ***
>
> I have done following setting in ee_typical.rsp
> UNIX_GROUP_NAME="dba"
>
> #FROM_LOCATION;String;Used in Dialog
> #Full path for the products.jar file.
> FROM_LOCATION="/data1/cdrom1/stage/products.jar"
>
> #ORACLE_HOME;String;Used in Dialog
> ORACLE_HOME="/oracle/product/8.1.5"
>
> Can anyone please help in solving this problem
> Thanks for the help in advance
>
> Regards
>
> Brijesh
scribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-12564: TNS:connection refused

[Jon Walthour]

Chris:

That's odd because you're not supposed to be able to see this
error message. Why don't you turn on tracing and do what you
were doing again. Then see what the trace file yields in terms
of more information.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/11/01 2:06:02 PM
>

>Hello everyone,
>
>A fellow DBA sent me the below email to forward onto the list.
 Perhaps
>someone can give us some clues as to what were missing??  The
original
>message they got was "listener not found" or something like
that.  So they
>made some updates to the firewall to allow access, and now there
getting
>ORA-12564.  Many thanks!!!
>
>*
>Chris,
>   Is there anything on the listserv about this error:  ORA-12564:
>TNS:connection refused.  We are trying to resolve a connectivity
issue using
>Gauntlet Firewall.  We are trying to connect to a database from
the
>production server to the development server, both are inside
the service
>network.
>
>Michael Rothouse
>*
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Grabowy, Chris
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). 
You may
>also send the HELP command for other information (like subscribing).
>


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: can i place online redologs with oracle engine ?

[Miller, Jay]

Hi, 

That's exactly what we did when we moved to a new box and got to design the
disk layout however we liked.  
Getting the redo logs to not be striped with the datafiles enabled us to
more than double transaction load in load testing (to such an extent that I
started getting Checkpoint Not Complete errors and had to increase the log
file size).

Jay Miller

-Original Message-
Sent: Friday, July 06, 2001 6:51 AM
To: Multiple recipients of list ORACLE-L


infact i should have been more clearer 
offcourse i can place them on any disk..the reason i asked was...

how much IO does the root + oracle engine do when an instance is running...?


and given no other choice, i plan to place them with root+oracle rather than
with some data or indexes. 



> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 05, 2001 7:54 PM
> To:   Rahul; Multiple recipients of list ORACLE-L
> Subject:  Re:can i place online redologs with oracle engine ?
> 
> Rahul,
> 
> You can put them just about anywhere you want, but since they tend to
> be a
> high IO item you may end up paying a price.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:can i place online redologs with oracle engine ?
> Author: Rahul <[EMAIL PROTECTED]>
> Date:   7/5/2001 1:16 AM
> 
> > list, 
> > i cannot spare a separate drive for the redologs,
> > can i place the online logs with the same drive as
> > the solaris + oracle engine  ? 
> > (m,y solaris and oralce are also on the same drive) 
> > 
> > TIA
> > 
> > Rahul
> > 
> > 
> > 
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rahul
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unusable indexes : why ?

[Koivu, Lisa]

Title: RE: Unusable indexes : why ?





Stephane, I had this happen to me previously. 
Did you by chance use an /*+ APPEND */ hint?  That was another possible culprit that was mentioned to me. Did you move the table ?  ALTER TABLE ... MOVE ...  ??

Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA
"The dba that impersonates directors"




-Original Message-
From:   paquette stephane [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 11, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
Subject:    Unusable indexes : why ?


Hi,


Oracle 816, I just had 13 unusable indexes (btree and
bitmap).
I have no partition and no sql*loader load so how come
those 13 indexes are unusable ?




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


___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

universal installer question

[JOE TESTA]

rumor had it at one time that there would be a text based 
installer available again, anyone know what happened to that 
concept?
 
joe
 

RE: Scsi I/O speed

[Kevin Kostyszyn]

Well yeah, all of this makes perfect sense to me.  However, if I am testing
the devices I would assume that the test software is going to send as much
info as it can down the pipe, you know stuff it.  With the Ultra/160 I am
assuming that there is only a 80mb/s drive in there, I never opened it up
and looked, but I will now.  I will use a couple different utilities and see
if the rates are the same.
Also, I know that the drives I have in these machines are all 80mb/s
drives, at least in the other machines, so there shouldn't be any device
that is "bringing" down the rate.  I don't know, but I would love to try and
iprove this rate.
KK

-Original Message-
Sent: Wednesday, July 11, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L


Kevin,

One thing to remember with SCSI...it's not necessarily the speed of the
controller that matters.  The SCSI bus will be slowed down to the speed of
the slowest device in the chain...or on the bus.  For example, if you have a
controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all
running off the same controller...the bus speed will be no more than 40mb/s
(the speed of the slowest device).  Again, that is the theoretical max
speed.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


Hi all,
I was measuring the i/o performance of my scsi drives and I have a
quick
question that maybe someone could shed some light upon.  Currently I am
using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
80mb/s.  Well, when I perform the test all of the machines seem to be
operation at halp of the max speed.  One operates at about 20mb/s read and
write and the others are even slower than that.  Now on the first one, it is
the only HD on the controller, on the others there are two disks.  Even on
my Ultra/160 it seems to be maxing out at 40 read and write.
Am I missing something?  Am I reading this the wrong way?  Help:(

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A danger in cloning databases

[Miller, Jay]

Immediately after this happened I thought of that and removed all other
entries from tnsnames.ora so database links wouldn't work (and of course
changed the reference for the local entry).

-Original Message-
Sent: Wednesday, July 11, 2001 1:03 PM
To: Multiple recipients of list ORACLE-L


And watch out for any database links that points to other production
servers.

>>> [EMAIL PROTECTED] 07/11/01 12:27PM >>>
Another thing to watch are the dbms_job entries, especially ones which
interact with other databases.  For example  a job which pulls data from
another database and writes back to that database the success of its
efforts.  If this job were to run in the clone, it might perform this task
before the "real" database does.  Jobs such as these should first check to
see that they are running on the proper database before executing.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, July 11, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-12564: TNS:connection refused

[Grabowy, Chris]

Hello everyone,

A fellow DBA sent me the below email to forward onto the list.  Perhaps
someone can give us some clues as to what were missing??  The original
message they got was "listener not found" or something like that.  So they
made some updates to the firewall to allow access, and now there getting
ORA-12564.  Many thanks!!!

*
Chris,
Is there anything on the listserv about this error:  ORA-12564:
TNS:connection refused.  We are trying to resolve a connectivity issue using
Gauntlet Firewall.  We are trying to connect to a database from the
production server to the development server, both are inside the service
network.

Michael Rothouse
*
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unusable indexes : why ?

[Sakthi , Raj]

Did anyone do alter table <> MOVE ?
--- paquette stephane <[EMAIL PROTECTED]>
wrote:
> Hi,
> 
> Oracle 816, I just had 13 unusable indexes (btree
> and
> bitmap).
> I have no partition and no sql*loader load so how
> come
> those 13 indexes are unusable ?
> 
> 
> 
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
> 
>
___
> Do You Yahoo!? -- Pour faire vos courses sur le Net,
> 
> Yahoo! Shopping : http://fr.shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sakthi , Raj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unusable indexes : why ?

[Gogala, Mladen]

Did you move the tables around?

-Original Message-
Sent: Wednesday, July 11, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L


Hi,

Oracle 816, I just had 13 unusable indexes (btree and
bitmap).
I have no partition and no sql*loader load so how come
those 13 indexes are unusable ?



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

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on NT unattended installation

[JOE TESTA]

Ed, you've gotten thats to work?, theory is nice, but r/l is 
what counts
 
joe
 
>>> [EMAIL PROTECTED] 07/11/01 02:05PM 
>>>
Audrey,
 
Yes, 
you can do a silent install.  On a workstation / server that has Oracle 
installed (NT/2000), go to:
 
START 
| PROGRAMS | Oracle Installation Products | Universal Installed Concepts 
Guide
 
This 
is in HTML format and will show you how you can do a silent 
install.
 
Ed

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on NT unattended installation
  Dear list ! Is 
  there a possibility to do an unattended installation of Oracle server (8.1.7) 
  on NT (Win2000) ? I mean an installation 
  with a script or so without answering questions and clicking 'Next' during the 
  installation. If there is such a 
  possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey. 

Re: OT: Unix tee command

[Jared . Still]

The second one copies output to the log file.

It still appears on your screen as well.

Jared



   

Erik Williams  

   
wnco.com>cc:   

Sent by: Subject: OT: Unix tee command 

[EMAIL PROTECTED] 

om 

   

   

07/11/01 07:12 

AM 

Please respond 

to ORACLE-L

   

   





I do not understand the difference between these two commands:

   script_file > log_file
   script_file | tee log_file

As I understand, the first runs and redirects its standard output to a log
file. The second runs and pipes its standard output to the tee command,
which copies its standard input into its standard output. I have been
instructed to use the latter, but dont want to do it blindly without
understanding why.

Thanks
Erik


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Anybody running 9iAS using Microsoft's IIS

[Boivin, Patrice J]

They are using IIS because they are worried about hackers?

I wonder how they reached this conclusion.

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:   Luis DeUrioste [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 11, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Anybody running 9iAS using Microsoft's IIS 

Fellow LISTERS,

Is anybody running 9iAS on MicroSoft's IIS ?
Damagement has reservations on using Apache since it is Open Source.
I guess
they fear hack attacks.
Any information will be highly appreciated.

TIA

Tavo << File: Card for Luis Octavio de Urioste >> 
--
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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on NT unattended installation

[Haskins, Ed]

Title: Oracle on NT unattended installation



Audrey,
 
Yes, 
you can do a silent install.  On a workstation / server that has Oracle 
installed (NT/2000), go to:
 
START 
| PROGRAMS | Oracle Installation Products | Universal Installed Concepts 
Guide
 
This 
is in HTML format and will show you how you can do a silent 
install.
 
Ed

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on NT unattended installation
  Dear list ! Is 
  there a possibility to do an unattended installation of Oracle server (8.1.7) 
  on NT (Win2000) ? I mean an installation 
  with a script or so without answering questions and clicking 'Next' during the 
  installation. If there is such a 
  possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey. 

Re: Rename alert log

[Rachel Carmichael]

I think you might possibly lose messages. but I also think that the risk is 
worth it if you don't want to do the delete.


>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Rename alert log
>Date: Wed, 11 Jul 2001 08:32:58 -0800
>
>Thanks Rachel.  I agree.  But I am still troubled by one thing.  If I do 
>adopt this
>method.  What if after I copy the alert.log and before null it, Oracle 
>writes
>something (a line or two) to the alert.log?  It seems that I will lose 
>those
>messages.
>
>What do you think?
>
> >>> [EMAIL PROTECTED] 07/11/01 11:47AM >>>
>My take on this is... if modifying the script won't hurt anything, do so.
>I'd rather do MORE than less when it comes to being proactive with Oracle.
>
>
> >From: "Richard Ji" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Rename alert log
> >Date: Wed, 11 Jul 2001 06:30:26 -0800
> >
> >I knew you weren't crazy, Rachel. :)
> >
> >So far this "feature" hasn't worked for me.  I have been moving
> >the alert.log and let Oracle create a new one since 8.0.5 and now
> >on 8.1.7 when I was unware of this "feature".  Now that I read about
> >it I am troubled.  Oh I am on Solaris 7 and 8 BTW.
> >
> >Hmmm...  I am pondering whether I should modify my script or not.
> >
> > >>> [EMAIL PROTECTED] 07/11/01 09:05AM >>>
> >Okay folks, I *knew* I wasn't crazy!  thanks to Anita for finding the 
>post
> >that Bruce sent to the list, that had the metalink doc in it
> >
> >There was also a bug filed on it (which was closed as "not a bug") bug#
> >1388186
> >
> >It was filed for Solaris so this might just mean that the "feature" is
> >Solaris specific, since people here are saying that they haven't seen it 
>on
> >other platforms.
> >
> >We are on Solaris, but our scripts are written such that we don't rename
> >the
> >alert log so I haven't been able to prove it one way or another.
> >
> >Rachel
> >
> >Note:122401.1
> >Type:  BULLETIN
> >Status: PUBLISHED
> >Content Type: TEXT/PLAIN
> >Creation Date: 18-OCT-2000
> >Last Revision Date: 14-MAY-2001
> >
> >Problem Description
> >---
> >
> >The Oracle background processes has an open file descriptor on the
> >alert.log.
> >When the database is up and running it continually holds this file
> >descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to
> >8.1.7.
> >
> >This poses the question: What if the database is up and the alert.log
> >gets too large. Do I have to shutdown the database to release the open 
>file
> >descriptor on the alert.log, then deal with the large alert.log?
> >
> >
> >Solution Description
> >
> >
> >You are able to copy the alert.log while the database is up and running.
> >
> >1) Create an empty file:
> >(example: touch nullfile.log)
> >
> >2) Replace the old alert.log with the new empty file:
> >(example: mv nullfile.log alert.log)
> >
> >The running database experiences no affects when doing this.
> >
> >
> >Explanation
> >---
> >
> >Having the continual open file descriptor on the alert.log is intended
> >behaviour for the database.
> >
> >
> >
> >
> >_
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: A danger in cloning databases

[Hillman, Alex]

Use localhost as hostname in listener.ora and you will never have this
problem.

Alex Hillman

-Original Message-
Sent: Wednesday, July 11, 2001 11:18 AM
To: Multiple recipients of list ORACLE-L


Jay,

Did that several months ago with our HP-MPE box.  The problem was that
we
changed the IP address of the box and brought a new one online, with the old
ones original IP.  Now MPE has NO idea of what a DNS server is so one has to
bury the actual IP address into things like listener.ora and tnsnames.ora.
We
had a pile of this smelly brown matter all over the place the next evening
when
the new development box ran it's nightly processes.  OOPS!!!

Dick Goulet

Reply Separator
Author: "Miller; Jay" <[EMAIL PROTECTED]>
Date:   7/11/2001 6:56 AM

Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: I have a clarification

[dgoulet]

Guy,

If I understand the Network Appliance sales droids correctly WAFL stands for
Write Anywhere File Layout.  In practice that means that the filer writes your
data to the first available block on the file system irrespective of where the
file's other blocks are.  This could be in the same sector of the same disk, or
on a different drive and in a different sector altogether.  The point is that
you as a user don't care, it's just one ENORMOUS, and dynamically expandable,
disk drive.  It is suppose to be extremely fast (I'm using one right now for NT
files) although I can't say I've seen any kind of difference.  One other point
with NetApp is that they accept the data (writing it to flash ram) and lot you
get on with your life, then they write the data to disk and calculate the raid
checksum (or whatever else they call it today) later after your gone.

Dick Goulet

Reply Separator
Author: "Guy Hammond" <[EMAIL PROTECTED]>
Date:   7/11/2001 9:21 AM

Slightly off topic, but would anyone care to comment on the advantages
and disadvantages of WAFL versus something like HP AutoRAID?

Thanks,

g



-Original Message-
Sent: Wednesday, July 11, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


BTW, got your book... great job!! You make mention of NetApp and RAID4
in
your book. You say RAID4 is like RAID3 (except it's block level parity)
so I
assume it performs like RAID3 which you state is better for DSS but not
as
good for OLTP. NetApp claims to have overcome RAID4 performance issues
with
their wafl architecture. Any feedback on this?

Waiting for your next book,
Steve Orr
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How does Oracle store NUMBER datatypes internally?

[Pablo ksksksk]

Can someone point me a document or something that
explains how does Oracle store NUMBER datatypes
internally?

TIA

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: Why default domain?

[dgoulet]

I have to agree with Rich,  We've used ONS from 7.3, 8.0, and now 8.1 and their
never down, unless something catastrophic happens.  But then we've got a cluster
of 4 ONS servers, 2 at each campus for redundancy purposes.

Dick Goulet

Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   7/11/2001 7:57 AM

Wow!  Your ONS is frequently down?  What version and what server?  I've been
running ONS on an 8.0.5.0.1 DB on OpenVMS for 419 days with the only
interruption being a planned IP Class-B-to-Class-C upgrade on the network
(Note: The SERVER didn't need rebooting -- just the networking!).  Our
backup ONS is on my Windohs Tuke workstation and is up and down, depending
on the wind direction apparently.  All clients use ONS only.  Our main DB
server has local naming as an "Oh Shitzu" backup so that DBMS_JOBs and such
on that server don't need external naming resolution, should they require a
link to another server.

BTW, we also don't currently use default domains, but I'll probably change
that at some point, seeing as Oracle tools like OEM practically shove it
down your throat .

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


-Original Message-
Sent: Tuesday, July 10, 2001 22:30
To: Multiple recipients of list ORACLE-L


In short, I don't. I use local resolution (as our ONS is frequently down and
unreliable) and none of my aliases have domain names attached to them. In my
sqlnet.ora, the entries about default domain, etc. are all commented out.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Scsi I/O speed

[Haskins, Ed]

Kevin,

One thing to remember with SCSI...it's not necessarily the speed of the
controller that matters.  The SCSI bus will be slowed down to the speed of
the slowest device in the chain...or on the bus.  For example, if you have a
controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all
running off the same controller...the bus speed will be no more than 40mb/s
(the speed of the slowest device).  Again, that is the theoretical max
speed.

Ed

-Original Message-
Sent: Wednesday, July 11, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


Hi all,
I was measuring the i/o performance of my scsi drives and I have a
quick
question that maybe someone could shed some light upon.  Currently I am
using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
80mb/s.  Well, when I perform the test all of the machines seem to be
operation at halp of the max speed.  One operates at about 20mb/s read and
write and the others are even slower than that.  Now on the first one, it is
the only HD on the controller, on the others there are two disks.  Even on
my Ultra/160 it seems to be maxing out at 40 read and write.
Am I missing something?  Am I reading this the wrong way?  Help:(

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: I have a clarification

[Orr, Steve]

THANKS Kevin,

Yeah, I read those papers but I wanted a real life "testimonial" like you
gave to make sure there wasn't any WAFL waffling.

Steve


-Original Message-
Sent: Wednesday, July 11, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


Steve;
  We use netapp filers at our current location.   I really like them myself.
>From a backup point of view, we only take our databases down for about 5
minutes each night and still get a full cold backup.  

On the netapp you just stop the DB, make a new snapshot, and then restart
the DB.  At this point, you can backup the snapshot and logs.  This is
truely a full copy of the database.  If anything happens, and it has in the
past, you restore from the snapshot, apply the logs, and you are back.

I can not give you direct performance numbers.  But, so far, our 37
instances are running find from an IO point of view.  We do not see any IO
performance hits out of the ordinary.

Their WAFL technology does appear to work well with the database.

Have you had a chance to read thru their TECHNICAL LIBRARY online ??

http://www.netapp.com/tech_library/index_db.html#O

This brings you to their papers on Oracle.

Kevin

-Original Message-
Sent: Wednesday, July 11, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


Hi Gaja (AKA "oraperfman"),

Why search google when I can just ask you? :-)

We had some NetApp sales drones here last week and they made tremendous
claims about their performance with Oracle. The sales engineer claims to
have been an Oracle DBA for a few years and he made a compelling case but I
haven't been able to get any performance feedback from current DBA's with
NetApp filers in production. Do you have anything you can share as regards
Oracle I/O performance on NetApp Filers which are a RAID4 implementation? 

BTW, got your book... great job!! You make mention of NetApp and RAID4 in
your book. You say RAID4 is like RAID3 (except it's block level parity) so I
assume it performs like RAID3 which you state is better for DSS but not as
good for OLTP. NetApp claims to have overcome RAID4 performance issues with
their wafl architecture. Any feedback on this?

Waiting for your next book,
Steve Orr


-Original Message-
Sent: Wednesday, July 11, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L


Peter & list,

NFS 2.0 and up is TCP-based and hence has the required
reliability to support "acks and error checking" of
network I/O calls. Having said that the only vendor
that I am aware of where NFS-mounted filesystems is
"certified by Oracle" for an Oracle database is
Network Appliance. In the case of NetApp. because it
is a NAS (Network Attached Storage) device and the
filesystem is maintained and supported on the Filer
rather than on the "host". In a very simplistic sense,
the host has a pointer to the NAS device on which the
filesystem is maintained. For more information on NAS
or anything else I urge you to search on
www.google.com.

And yes, you can hookup the NetApp. Filer to a Sun
Solaris box for sure. Don't know about Linux, but you
can check NetApp's website to verify that.

Cheers,

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed

RE: export/import object types

[Kevin Kostyszyn]

I've experienced and must admit that it is a pain in the arse to deal with:)
KK

-Original Message-
Sent: Wednesday, July 11, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I wonder if anyone has seen this before.

I export an user A, then import it into user B in a different database
and everything is ok.  Then I use the same export file to import into
user C in the same database as user B and all the "CREATE TYPE"
failed because Oracle retains the object id in the export file and when
importing into user C it tries to create them with the same object id
and since user B already has it it failed.  I had to manually delete
the object id from the log and recreate it.

It's not a huge problem since it's rare that I do something like this.
But just wondering why would Oracle retain the object id for TYPE?
It certainly didn't keep the same object id for other objects like table,
etc.

Any thoughts?

Richard Ji

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Date / Time

[Gillies, Garry]

Title: RE: Date / Time





Here is my attempt to display the difference between two dates in the format
:::
The two dates are dt1 and dt2
If dt1 is later than dt2 then result returned as negative.
It should work for differences of +/- 99 days - to increase the range,
change '09' at the end of the first line to the size desired.


to_char(trunc(greatest(dt2,dt1) - least(dt2,dt1)) * sign(dt2 - dt1),'09') ||
   ':' ||
   to_char(to_date(1,'J') + (greatest(dt2,dt1) - least(dt2,dt1)) ,'HH24:MI:SS')




Regards


Garry


-Original Message-
From: Scott Canaan [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2001 15:12
To: Multiple recipients of list ORACLE-L
Subject: Re: Date / Time



Sajid,
    Unfortunately, I ran into the same problem.  I didn't find anything to do
it for me, either, so I had to write the pl/sql code.  It is very long and
messy, but can be done.  When I did it, I didn't even attempt the days
notation.  Here is the code that I wrote:


    date_diff := trans_cur.modified_date - last_date;
    date_diff_tot := trans_cur.modified_date - first_date;
    SELECT decode( trunc( date_diff * 24),0,
  to_char( trunc( date_diff * 1440), 'FM90') || ':' ||
  to_char( round( date_diff * 86400) - trunc( date_diff
    * 1440) * 60,'FM00'),
  to_char( trunc( date_diff * 24),'FM90') || ':' ||
  to_char( trunc( date_diff * 1440 - trunc( date_diff *
24)
    * 60),'FM00') || ':' ||
  to_char( round( date_diff * 86400 - trunc( date_diff
    * 1440) * 60), 'FM00')),
  decode( trunc( date_diff_tot * 24), 0,
  to_char( trunc( date_diff_tot * 1440),'FM90') || ':' ||


  to_char( round( date_diff_tot * 86400)
    - trunc( date_diff_tot * 1440) * 60,'FM00'),
  to_char( trunc( date_diff_tot * 24),'FM90') || ':' ||
  to_char( trunc( date_diff_tot * 1440
    - trunc( date_diff_tot * 24) * 60),'FM00') || ':' ||
  to_char( round( date_diff_tot * 86400
    - trunc( date_diff_tot * 1440) * 60), 'FM00'))
    INTO elapsed_1, elapsed_2
    FROM dual;


I hope this helps.


Sajid Iqbal wrote:


> Hello All
>
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
>
> If I do "select date1 - date2", the result is : 12.0194907
>
> Is there a function that will turn the number of days into something more
> legible?  Ideally i'd like to do ;
>
> "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work.  Is
> there a solution other than writing a complex function myself which will
> have to * by 24, / by 60 and substr etc to get the different bits of the
> number?
>
> Please CC any replies directly to me at [EMAIL PROTECTED]
>
> Thanks in advance,
> Saj.
>
> --
> Sajid Iqbal
> Database Team Leader
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sajid Iqbal
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer



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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

All internet traffic to this site is 
automatically scanned for viruses 
and vandals.

RE: OT - interviewing your superior(fun question)

[Miller, Jay]

I don't usually read the OT posts but I glanced at this while deleting
stuff.  Apologies if anyone already supplied the correct quote.

What Al Gore said was 'While in the Senate I played a major role in creating
the internet'.  Apparently he was a major sponsor a author of the bills that
transformed arpanet into the more commercially oriented internet.

I used to have links that traced the evolution of that entirely truthful
quote to 'I invented the internet' but dropped most of them after the
election.  I could probably track them down again in the unlikely event
anyone was interested :).  I think it was Wired magazine that first used the
word 'invented'.

Jay Miller

-Original Message-
Sent: Thursday, June 21, 2001 11:25 PM
To: Multiple recipients of list ORACLE-L


Yes, the statement is different, but just based on the words in the
sentence. "Playing a role in inventing"!=  "inventing".  Odd thing
about words: they mean something.

Hell, I play a role in the community on this listserv. 
I am certain Jared and Esteemed Company would make the 
semantic mistake of thinking I AM the community on this listserv. 

Unless, of course, I were in Florida, where votes don't count. 

JUST KIDDING! God Bless the Appointed President, and the
minority that voted for him!

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/21/2001 6:28 PM

And this statement is ANY better???  I use "Software that Powers the
Internet" therefore I guess I, in a way, run the darn thing. :) God
bless
the electoral college!

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Thursday, June 21, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L


nope, he said

"I played a role in inventing the Internet"

-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L


I thought he invented the internet.  Just ask him.  The best line was "I
knew Jack Kennedy and You are no Jack Kennedy" said by Loyd Benson to
Dan
Quayle. 


>>> [EMAIL PROTECTED] 06/21/01 05:13PM >>>
:), actually if you parrot Gore, it would be

"I played a role in inventing certifications".

The devil is in forgetting the details!


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Speaks, Chuck W.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat Cit

Re: Scsi I/O speed

[Paul Drake]

Kevin Kostyszyn wrote:

> Hi all,
> I was measuring the i/o performance of my scsi drives and I have a quick
> question that maybe someone could shed some light upon.  Currently I am
> using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
> 80mb/s.  Well, when I perform the test all of the machines seem to be
> operation at halp of the max speed.  One operates at about 20mb/s read and
> write and the others are even slower than that.  Now on the first one, it is
> the only HD on the controller, on the others there are two disks.  Even on
> my Ultra/160 it seems to be maxing out at 40 read and write.
> Am I missing something?  Am I reading this the wrong way?  Help:(
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]

Kevin,

download SandraSoft's benchmarking tools - download.com is a good place to start.
There is quite a difference between SCSI controller interface speeds and actual
trasfer speeds between the OS and the physical hard drive. The Interface speed is a
theoretical max, and is more important when configuring several drives on a single
controller channel - e.g. RAID 0, 0+1, 5, etc.
If you have 4 drives on a channel configured as a 4 drive RAID 0 volume, the
controller channel SCSI interface speed could be the rate-limiting-factor. (e.g. 4
drives with an *average* transfer rate of 25 MB/sec = 100 MB/sec > 80 MB/sec).

As there is a cache on the hard drive (2-4 MB is customary) and could be a cache on
the RAID contoller (128 MB - 4 GB?) the channel should be saturated during memory to
memory transfers (after negotiation for the transfer has taken place) - short bursts
which are then slowed by the subsequent access of the phyiscal media.

Typical sustained read/write speeds are on the order of 30 MB/sec on the latest and
greatest 10,000 RPM drives.
The fastest sustained read/write I've seen is here - is for the 15,000 RPM Seagate
Cheetah - close to 50 MB/sec on the outer tracks
http://www.storagereview.com/articles/200105/20010510ST373405LW_1.html

Interfacespeed (MB/sec)
SCSI
Ultra Wide UW  40
Ultra2 WideU2W 80
Ultra160   U160   160
Ultra320   U320   320

IDE
UDMA-33ATA-4   33
UDMA-66ATA-5   66
Ultra ATA  ATA-6  100

Most likely, seek time will dominate transfer time unless you hike the operating
system IO_size up from 64 KB.

this site looks like fun: http://www.storagereview.com/cgi-bin/bench_compare.pl

remember - little 'b' is bits, big 'B' is Bytes.
This is extremely important if you happen to look at NAS - using Gigabit Ethernet
for shared storage.

Paul

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

[Miller, Jay]

That's what we do too.
This is the command to do it:

ln -sn $ORACLE_HOME/bin/sqlldr $ORACLE_HOME/bin/sqlload

-Original Message-
Sent: Monday, July 09, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


Ken,
   Earlier versions had sqlldr and sqlload as copies of the same code.  I
think sqlload was a link in 8.0.x. Now with 8i it's gone. You can create the
link if you do not wish to change the existing code. We did just that since
Developers did not want to change their scripts. 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Fowler, Kenneth R [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 11:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr
> 
> List,
> 
> I am currently working on migrating an application from Oracle 7.3 to
> Oracle
> 8.1.6.2 (This is on Solaris 2.6).  One of the shell scripts makes use of
> sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not
> on
> the 8.1.6.2 server.  On the 7.3 server it looks like there are two
> directory
> entries, one for sqlload and one for sqlldr...
> 
> orapps1 $ ls -al | grep sql
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlldr
> -rwxr-x--x   2 oracle   dba  3612900 Oct  3  1997 sqlload
> 
> On the 8.1.6.2 server there is just sqlldr.  I am wondering if the sqlload
> link is something that has been dropped from newer versions? or has
> someone
> manually applied the link to the 7.3 server?
> 
> Thanks,
> Ken
> _
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:[EMAIL PROTECTED]
> 
> 
> 
> LEGAL NOTICE
> Unless expressly stated otherwise, this message is confidential and may be
> privileged. It is intended for the addressee(s) only. Access to this
> E-mail by anyone else is unauthorized. If you are not an addressee, any
> disclosure or copying of the contents of this E-mail or any action taken
> (or not taken) in reliance on it is unauthorized and may be unlawful. If
> you are not an addressee, please inform the sender immediately.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fowler, Kenneth R
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A danger in cloning databases

[Paul Drake]

unique passwords in listener.ora files prevents this.

Kimberly Smith wrote:

> Been there, done that;-)
>
> -Original Message-
> Sent: Wednesday, July 11, 2001 7:57 AM
> To: Multiple recipients of list ORACLE-L
>
> Many of you probably know this already, but it took me by surprise (and
> caused no end of grief) so I thought I'd warn people.
>
> I cloned our 8.0.4 production database onto another machine for some testing
> we were doing (copy of entire Oracle filesystem, copied hot backup over) and
> started it up with no problems.
>
> What I didn't realize when I ran my shutdown script (which also stops the
> listener) was that I hadn't changed the hostname in listener.ora.  It
> stopped the listener on the production box!
>
> Had you asked me before this happened I wouldn't have expected it to work
> that way, but a number of irate users and managers testify to the fact that
> it does.  I restarted the listener as soon as anyone thought to notify me of
> the problem (it says something about the processes here that it was 45
> minutes after I restarted the listener that that our Help Desk contacted me
> me about the problem, I first heard about it from a developer).
>
> Sigh, learn something new every day.
> Hope someone out there benefits from my mistake.
>
> Jay Miller
> --

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Exceeding Open Cursors.. too many rows in v$open_cursors

[Guy Hammond]

You need to explicitly close JDBC statements.

http://technet.us.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_47
_

This one got me too once :0)

g


-Original Message-
Sent: Wednesday, July 11, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L


We are closing some cursors thru PLSQL scripts and thru JDBC as well.
Every
time we run one script the cursors are not getting closed . Instead they
are
shown as inactive in v$open_cursors table . Next time you run the same
transction in the same session it makes those cursors as active but adds
more rows into the open cursors table. So if execute the same script
10times
in a row I am exceeding the max limit of open cursors and eventually get
a
message :java.sql.SQLException: ORA-01000: maximum open cursors exceeded
.

Any idea how to over come this issue..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unusable indexes : why ?

[gregory . t . norris]

Move any tables via ALTER TABLE ... MOVE recently?

> -Original Message-
> From: stephane.paquette [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 11:27 AM
> To: ORACLE-L; stephane.paquette
> Subject: Unusable indexes : why ?
> 
> 
> Hi,
> 
> Oracle 816, I just had 13 unusable indexes (btree and
> bitmap).
> I have no partition and no sql*loader load so how come
> those 13 indexes are unusable ?
> 
> 
> 
> =
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> [EMAIL PROTECTED]
> 
> ___
> Do You Yahoo!? -- Pour faire vos courses sur le Net, 
> Yahoo! Shopping : http://fr.shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?paquette=20stephane?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: I have a clarification

[Guy Hammond]

Slightly off topic, but would anyone care to comment on the advantages
and disadvantages of WAFL versus something like HP AutoRAID?

Thanks,

g



-Original Message-
Sent: Wednesday, July 11, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


BTW, got your book... great job!! You make mention of NetApp and RAID4
in
your book. You say RAID4 is like RAID3 (except it's block level parity)
so I
assume it performs like RAID3 which you state is better for DSS but not
as
good for OLTP. NetApp claims to have overcome RAID4 performance issues
with
their wafl architecture. Any feedback on this?

Waiting for your next book,
Steve Orr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A danger in cloning databases

[Richard Ji]

And watch out for any database links that points to other production servers.

>>> [EMAIL PROTECTED] 07/11/01 12:27PM >>>
Another thing to watch are the dbms_job entries, especially ones which interact with 
other databases.  For example  a job which pulls data from another database and writes 
back to that database the success of its efforts.  If this job were to run in the 
clone, it might perform this task before the "real" database does.  Jobs such as these 
should first check to see that they are running on the proper database before 
executing.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, July 11, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: unable to allocate 4096 bytes of shared memory - HELP!!!!

[Kimberly Smith]

There is a bug in 8.1.7 in which the connect/disconnect causes a memory leak
in the shared pool.  You need to patch to 8.1.7 and then apply a bug fix.
Not
sure what the bug number is but its up there on the ftp site.  It took me
approximately
10 hours to get the first page regarding this issue after the upgrade.
Course,
if they provided me with a test box we would have found the bug before
moving
it to production.  I am a little bitter about the whole thing still.  

-Original Message-
Sent: Wednesday, July 11, 2001 6:12 AM
To: Multiple recipients of list ORACLE-L


John,

Increase the Shared_Pool_Size parameter in the INIT.ORA file, and restart
the database.
I would suggest an increase of at least 50%.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L


We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
follows :

It appears to be related to dbms_job

Can any one help?

John

Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
ORA-12012: error on auto execute of job 11223917

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","SERVER
_PRINTER_RESET","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Sun Jul  8 23:52:14 2001
Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp1_19492_prtgh1.trc:

ORA-12012: error on auto execute of job 11227622
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","SERVER
_RECEPTION","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Anybody running 9iAS using Microsoft's IIS

[Thater, William]

Luis DeUrioste wrote:
> 
> Fellow LISTERS,
> 
> Is anybody running 9iAS on MicroSoft's IIS ?
> Damagement has reservations on using Apache since it is Open Source. I guess
> they fear hack attacks.
> Any information will be highly appreciated.
> 
> TIA
> 
> Tavo

we tried but never got it working.  we're happy using apache.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
How should I know if it works? That's what Beta testers are for, I only
coded it.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Scsi I/O speed

[JDonson]

Your questions are good ones...

Driver issues may exist.

Contact adaptec, or scsi card maker.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A danger in cloning databases

[Kimberly Smith]

Been there, done that;-)

-Original Message-
Sent: Wednesday, July 11, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.

I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up with no problems.

What I didn't realize when I ran my shutdown script (which also stops the
listener) was that I hadn't changed the hostname in listener.ora.  It
stopped the listener on the production box!

Had you asked me before this happened I wouldn't have expected it to work
that way, but a number of irate users and managers testify to the fact that
it does.  I restarted the listener as soon as anyone thought to notify me of
the problem (it says something about the processes here that it was 45
minutes after I restarted the listener that that our Help Desk contacted me
me about the problem, I first heard about it from a developer).

Sigh, learn something new every day.
Hope someone out there benefits from my mistake.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Second RBS in system tablespace

[hp]

Hi Everybody

I'm running 8.1.7 and i just read that i should have a second rollback
segment in the system tablespace.
Can someone tell me why this is and how big should i create it?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: hp
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).