Re: ONS Install - my life is at an end

[novicedba]

hi ross,
  My boss (well a colleague but I donno anything about the configuration and
he does so he is my boss) at the place where I work has installed Names
server on NT. Will it be of any help?

coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 4:16 AM


> Ok, so no one liked the InterMedia Question, so let's forget that one.
>
> How about this?
>
> ONS, ver817namesctl installs and builds OK, but I cannot get names
(name
> server) to run.if i run the make manually, it claims to be missing
> libnon8.a
>
> Sure enough, it's not on the file system.
>
> Any one run into this? I didnot find anything on MetaRetch, and R'ing the
FM
> did
> not help...
>
> Thanks in advance!
>
> - Ross
> --
> 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: novicedba
  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: Semaphores

[Sakthi , Raj]

Hi KM
ipcs -smb will give you avtive semaphores with sizes
inside oracle use ORADEBUG ipc
Cheers ,
RS
--- Kimberly Smith <[EMAIL PROTECTED]>
wrote:
> Does any one know how to monitor semaphore usage in
> HPUX 11?
> 
> 
> Kimberly Smith
> Database Administrator
> IT Dept. - Fujitsu/GMD
> Phone: (503) 669-6050
> Fax: (503) 669-5705
> Email : [EMAIL PROTECTED]
> 
> -- 
> 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).
 with sizes

__
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: Bug in dbstart Script?

[Jared Still]

Yeah, you should see the one on AIX, it's
a real mess.

Jared

On Thursday 12 July 2001 10:47, mohammed bhatti wrote:
> Folks,
>
> I'm not sure if this applies to any of you, but the
> $ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris 2.6
> appears to have a slight bug in it.  Whenever we
> re-booted, during the system startup, the dbstart
> script is called but none of our databases ever come
> up.  I finally tracked it down to this offending piece
> of code in dbstart:
>
> if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
> '
>  /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
>  print substr($3,1,3)}'`
> ...
> ...
> ...
>
> which I've replaced with this:
>
> if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
> '
>  /Oracle8i Enterprise Edition (Release|Version)/
> {substr($5,1,3) ;
>  print substr($5,1,3)}'`
> ...
> ...
> ...
>
> Our databases come up automatically after a re-boot.
>
> hth someone.
>
> mkb
>
>
> __
> 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: Jared Still
  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).

Oracle Applications Forum

[Rukmini Devi]

Hi All,

   Is there any forum or mailing list for Oracle Applications?

thanks
rukmini

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rukmini Devi
  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: 81714 aborted upgrade and core dumps on NT

[Reardon, Bruce (CALBBAY)]

Solved.
Time for the update and thanks to all for the replies and help.

To answer a question, we were using older versions of clients (more
specifically we are using Microsoft ODBC Driver with a 7.3.4 client and on
separate PCs Forms 4.5) but it turns out the problem is not related to this.

Instead, we were running into bug 1353943 with description "ORA-7445
[FEAD06D0]WHEN PARAMETER SERIAL_REUSE =ALL DURING PL/SQL EXECUTION "
Note that bug 1353943 also seems to effect you when you are using
serial_reuse=SELECT.

Now on NT you do not see the ora-7445 in the alert log.
Instead you get a core dump produced (and under 81714 / NT4 the
core_dump_dest does work for us) and you can get a stack trace from that
showing which Oracle functions were called.

Thanks,
Bruce Reardon


-Original Message-
Sent: Tuesday, 10 July 2001 8:38 

Bruce,

Core dumps are even more of a pain on NT since they
don't generate a helpful trace file as on other
platforms.  You should have a core.log file in one of
the dump directories (core_dump_dest didn't work on
NT, although I've heard it does on 8.1.7+, but haven't
tested it).

There should be a stack trace in it somewhere, but
that's about it.  If you're lucky, it will be unique
enough to help support identify an existing bug.

Yes, I have had cases where enabling tracing prevented
the error from occurring, thereby making it incredibly
difficult to resolve.

HTH,

-- Anita

> Hi,
> I have just had the experience of upgrading to
> 81714, discovering a problem
> in our application that did not show up in any
> testing and having to go back
> to 815.
> 
> The 815 instance is on a different server to the 817
> instance and we still
> have the 817 instance available for further
> troubleshooting.
> 
> This is on NT4.
> 
> With 817, we were getting ora-3113 in the forms
> application and in ODBC
> connections and also seeing ora-03121 as well.
> 
> We got core dump files produced (under 817 they are
> produced on NT) but
> Oracle support does not seem to know how to
> interpret them on NT - has
> anyone had any experience with this?
> 
> No mention of the core dump file was contained
> within the alert log and no
> files were produced in the user dump directory.
> 
> When I turned sql trace on for the session running
> forms, the ora-3113 did
> not occur - has anyone seen behaviour like this
> where SQL Trace will cause
> an ora-3113 to stop occurring?
> 
> All suggestions on what to look for or how to
> interpret NT core dumps are
> welcome.
> 
> Thanks,
> Bruce Reardon
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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 to get the list of tables used in a view?

[Sairlao, Chark]

get it from dba_source




-Original Message-
Sent: Friday, 13 July 2001 13:10
To: Multiple recipients of list ORACLE-L


Greetings,

Is there any dictionary table/view where I can query the name of all the 
tables used by a particular view?

The way I do now is : Query the line containing 'from' in text field of 
dba_views for the specified view.

Is there any other way to get the list of the tables used by a view?


Thanks,
Ashoke



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

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

Re: MINUS--Sql help

[Yosi Greenfield]

Rivandra,

The minus operator is a set operator. It subtracts one
result set from another. That is, the rows from the second
result set that exist in the first result set are removed from
the first result set, and the remaining rows are returned.

To substract one sql numeric result from another, use
sqlplus variables.

col a new_value a_hold
select 15 a from dual;

-- a_hold now contains 15

select 25 - &a_hold from dual;

will provide the desired result.

hth,

Yosi


Ravindra Basavaraja wrote:

> I am writing a SQL query using the MINUS operator.Both the select statements
> return a number result and I
> am trying to get the o/p with the difference of both the queries using the
> MINUS
> between the two select statements.But I am getting the o/p of the first
> query only
> and the displayed result is not the subtracted value.Both select statements
> give
> different number o/p when run individually.What could be wrong.
>
> Is there anything that i am missing to consider when using the MINUS
> operator.
>
> Pls help
>
> Thanks
> Ravindra
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ravindra Basavaraja
>   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: Yosi Greenfield
  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: Problem with performance

[Yosi Greenfield]

Alexander,

All of the performance books you may one day read will tell
you that before you tune waits, first make sure your SQL is
good. That is, run explain plan (or any gui tool that will run
explain plan for you) and make sure the sql is using the
appropriate indexes, etc.

If all that works, then try increasing your buffer cache.

hth,

Yosi


Alexander Ordonez wrote:

> Hi gurus,
>
> I have problem with the performance of the Database
> the user report that db is very slow.
> i check the statistics i get:
>
> free buffer waits in 72774
> buffer busy waits in 171940
>
> this isthe only high..other is normal
>
> the dba shutdown every day in the night for backup
>
> somebody can help me!!!
>
> @lex
> 
>   Lic. Alexander Ordóñez Arroyo
>   Caja Costarricense del Seguro Social
>   Soporte Técnico - División de Informática
>   Telefono: 295-2004, San José, Costa Rica
>   [EMAIL PROTECTED]
>
> 
> UNIX is very user friendly,
> It's just very particular about who it makes friends with.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexander Ordonez
>   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).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  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 to get the list of tables used in a view?

[Deshpande, Kirti]

Ashoke,
 Look in dba_dependencies (or user_dependencies) view. 
 Select related columns for type = 'VIEW' . 

 HTH,

 Regards,

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

> -Original Message-
> From: ASHOKE MANDAL [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 10:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  How to get the list of tables used in a view?
> 
> Greetings,
> 
> Is there any dictionary table/view where I can query the name of all the 
> tables used by a particular view?
> 
> The way I do now is : Query the line containing 'from' in text field of 
> dba_views for the specified view.
> 
> Is there any other way to get the list of the tables used by a view?
> 
> 
> Thanks,
> Ashoke
> 
> 
-- 
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).

RE: How to get the list of tables used in a view?

[Reardon, Bruce (CALBBAY)]

Hi Ashoke,

Under 817 you can use dba_dependencies - their may be other ways as well.

For example:

SQL> create table a (a integer);

Table created.

SQL> create table b (b integer);

Table created.

SQL> create view ab as select * from a,b where a=b;

View created.

SQL> select * from dba_dependencies where  NAME = 'AB';

OWNER  NAME   TYPE REFERENCED_OWNER   REFERENCED_NAME
REFERENCED_T REFERENCED_LINK DEPE
-- --  -- ---
 --- 
USER01 AB VIEW USER01 B
TABLEHARD
USER01 AB VIEW USER01 A
TABLEHARD

2 rows selected.

Searching dba_views.text will be a problem if the table names are split over
more than 1 line in the view definition.

Regards,
Bruce Reardon

-Original Message-
Sent: Friday, 13 July 2001 1:10 

Greetings,

Is there any dictionary table/view where I can query the name of all the 
tables used by a particular view?

The way I do now is : Query the line containing 'from' in text field of 
dba_views for the specified view.

Is there any other way to get the list of the tables used by a view?

Thanks,
Ashoke
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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 to get the list of tables used in a view?

[Joe Testa]

ok its late but off the top of my head, dba_dependencies?

this is only a guess, as I'm heading off to bed and didnt verify it at
all :)

joe
ASHOKE MANDAL wrote:
> 
> Greetings,
> 
> Is there any dictionary table/view where I can query the name of all the
> tables used by a particular view?
> 
> The way I do now is : Query the line containing 'from' in text field of
> dba_views for the specified view.
> 
> Is there any other way to get the list of the tables used by a view?
> 
> Thanks,
> Ashoke
> 
> _
>
-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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

[Hermanto P]

Thanks Suher, it works !!

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" 




-Original Message-
Sent: Thursday, July 12, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L


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).
-- 
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).

Sys object Invalid

[Sinardy]

Hi,

I have 500+ sys objects invalid and my database still running

What hapen to my database ?

Thank you

Best Regards 

Sinardy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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 to get the list of tables used in a view?

[ASHOKE MANDAL]

Greetings,

Is there any dictionary table/view where I can query the name of all the 
tables used by a particular view?

The way I do now is : Query the line containing 'from' in text field of 
dba_views for the specified view.

Is there any other way to get the list of the tables used by a view?


Thanks,
Ashoke



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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHOKE MANDAL
  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: find free space under HWM for a table

[Chuan Zhang]

Thanks for all your reply.

I am still confused about getting free space or blocks under HWM for a
table.

Let me first list something here for clarification. If something wrong,
please correct it.


1. dbms_space:

UNUSED_SPACE Procedure Returns information about unused space in an object.
To my understanding,  these unused space could be both above and under HWM.

FREE_BLOCKS Procedure Returns information about free blocks in an object.
Again, these free blocks include blocks above and under HWM.

>From this dbms_space package, you cannot simply get the free space or blcoks
under HWM.


2. dba_segments

blocks: Size, in Oracle blocks, of the segment.

3. dba_tables (analyzed)
blocks: Number of used data blocks in the table
empty_blocks: Number of empty (never used) data blocks in the table. It
seems above the HWM.

>From the above, you cannot get the free blocks under HWM. I define the "free
blocks" as " blocks are blocks which are never used or once used but later
released because of mass deleting"

Much appreciated for your reply.
Thanks,

Chuan






- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 6:55 PM


> REMEMBER that empty_blocks represent the amount of
> blocks above the HWM. The only way to know the blocks
> below the HWM is with this select:
>
>
> on 7.X select count(distinct
> substr(rowid,15,4)||substr(rowid,1,8)) from
> &owner..&table_name.;
>
> on 8.X select count( distinct substr(rowid,1,15)) from
> &owner..&table_name.;
>
> This gives you the real space occupy by a segment or
> as I said the amount of blocks below the HWM. Then
> with the db_block_size you can infer the value in
> bytes.
>
> Regards.
>
> --- Vladimir Begun <[EMAIL PROTECTED]>
> wrote:
> > on Jul 11, 2001 at 11:30:18PM, Chuan Zhang wrote:
> > > Hi, DBA gurus,
> > >
> > > Recently, I will archiving some big tables.  How
> > to find free space under
> > > HWM for a table?
> >
> > Do analyze and then you can calculate it:
> >
> >  dba_segments.blocks - dba_tables.empty_blocks - 1
> >
> > Be aware the blocks which are below HWM can be empty
> > because of preallocation or delete activities.
> >
> > --
> > Vladimir Begun   | echo
> > "Congratulations.  You aren't running
> > http://vbegun.net/   | Eunice."
> > http://vbegun.net/wap/   |  -- Larry Wall
> > in Configure from
> > [EMAIL PROTECTED]|  the perl
> > distribution
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Vladimir Begun
> >   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).
>
>
> =
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : 541149816062
>
> __
> 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: Christian Trassens
>   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: 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: Order By Position and UNION

[Larry Elkins]

Thanks for the response. I'm wondering if it has always been like that or if
it changed with a recent version -- don't know since I have always used
positional notation going back to V5 when I started using Oracle (and yes, I
know people go back further than that -- that's not the point I was trying
to make). Taking your example further, if I alias each column (in your case
alias deptno and locid as empno), it will still work if I refer to empno in
the ORDER BY. Not that our queries make much sense ;-)

Anyway, I think it's obvious why I used OT in the subject line -- we are
talking about some trivial things here ;-) But, there is still the curiosity
factor that made me want to know if it has always been this way or if this
behavior was introduced in a particular version or point release. For
example, in-line views were "there" in 7.1 but not official until 7.2 (I
think those are the correct versions, it's been a while).

OK, I did a deja search since this is bugging me and at one point, based on
posts I pulled up and the examples they provided, you were *required* to use
positional. And as we see PL/SQL sometimes lagging SQL, there also were
mentions of where referring to a column name was supported in SQL but not in
PL/SQL, and references to in earlier versions where positional was required
in both. But, none of the posts happened to mention what version of the DB.

So I now know that I'm not crazy, that positional was mandatory at some
point. It's interesting what the manuals say and your examples showing the
difference between unioning 2 or 3 selects, and then what happens with
aliasing all to be the same. I'll stick with positional to be safe.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Larry,

You can use column name if you only have two statements with your set
operators.  However, any more than that you must user positional.  See
below.


 1  select empno, ename from emp
 2  union
 3  select deptno, dname from dept
 4  union
 5  select locid, room from location
 6* order by empno
SQL> /
order by empno
*
ERROR at line 6:
ORA-00904: invalid column name


SQL> select empno, ename from emp
 2  union
 3  select deptno, dname from dept
 4  union
 5  select locid, room from location
 6  order by 1
 7  /

EMPNO ENAME
-- --
   10 ACCOUNTING
   20 RESEARCH
   30 SALES
   40 OPERATIONS
   45 101
   46 202
   47 103
   48 105
   49 105
   50 404
   51 421
   52 211
   53 424
   54 402
   55 433
   56 217
   57 222
 7369 SMITH
 7499 ALLEN
 7521 WARD
 7566 JONES
 7654 MARTIN
 7698 BLAKE
 7782 CLARK
 7788 SCOTT
 7839 KING
 7844 TURNER
 7876 ADAMS
 7900 JAMES
 7902 FORD
 7934 MILLER

31 rows selected.

SQL>

-- 
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).

Off Topic - Sap Lists ?

[Rajaram]

Please excuse me.
I just need some info about any SAP lists any one of you might know. There 
are many lists out there - but I dont to which one is a good one. I am 
looking for a SAP - Technical discussion list.

TIA,
Raj


NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  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: sqlplus question ???

[Yosi Greenfield]

Yes, there is. You'll get at least 5 replies for this, 'cause
it's an easy one, but maybe I'll be first.

Sum computes on breakpoints, so you have to set the
sum (which you did) and also set the breakpoint (which
you did not).

Add

break on report

to the sql file.

Good luck,

yosi

Andrea Oracle wrote:

> Hi all,
>
> I have these in sqlplus:
> set pagesize 999
> Set linesize 100
> Col file_name format a50
> Col bytes format 999,999,999,999
> compute sum of bytes on report
> select file_name, bytes from dba_data_files order by
> file_name;
>
> The query returns all the data files back, but it did
> NOT show the sum of the bytes.  Is there anything I
> forgot to set?  Thank you.
>
> Andrea
>
> __
> 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

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

[Gaja Krishna Vaidyanatha]

Hi Steve & list,

Sorry for the delay in posting, the day job tends to
take over life quite a bit. My comments to yours
below.

Hope it helps,

Gaja

--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> Hi Gaja (AKA "oraperfman"),
> 

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

Flattery will get you nowhere;-)


> 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? 
> 

Sure, the performance of the NetApp. Filers is pretty
good if you configure it right. Pay heed to some of
the basics in DBA101 - such as separate DATA from
INDX. This can be done with their volume manager and I
urge you to do that. Separation of write-intensive
components on separate volumes will also help.
Creating one huge volume with all the disks and not
separating contending components can and will cause
disk-level "head thrashing". This will cause I/O
bottlenecks regardless of your storage vendor.


> 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?

Thanks for the kind words about the book. Could not
have done it without Kirti's support and efforts. 

Yes, RAID3/4 primarily caters to applications that
perform bulk sequential reads with a few number of
users. But, with the WAFL (Write Anywhere File Layout,
referring to the act of writing filesystem meta-data
blocks anywhere in the file) architecture, the
overhead associated with the management of writes to
stripes of data within the RAID4 volume is greatly
minimized.

Very briefly, the write-anywhere design allows WAFL to
operate efficiently by scheduling multiple writes to
the same RAID stripe (when applicable) to minimize the
write penalty incurred with updating blocks
independently and repeatedly in a RAID stripe. This
along with the fact that NFS write requests are
grouped, scheduled and then written in a meaningful
order, makes it a very viable solution even in
"write-intensive OLTP environments". However, the
optimal configuration of the network segment on which
the Filer is put, is quintessential to optimal
performance. Follow NetApp's recommendations for that
and you should be fine.


> 
> Waiting for your next book,
> Steve Orr
> 
Oh don't go there now, I am just getting back my life
after 6 months...;-)

Cheers,

Gaja

> 
> -Original Message-
> From: Gaja Krishna Vaidyanatha
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 7:22 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: I have a clarification
> 
> 
> 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




=
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

RE: alert log is not capturing all errors

[lhoska]

Thank you 
John.

  -Original Message-From: John Carlson 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 5:56 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  alert log is not capturing all errors
  The alert log does not capture anything it considers 
  to be a user error.
   
  HTH,
  John
  >>> [EMAIL PROTECTED] 07/12/01 12:35PM 
  >>>Hi List,I have encountered a little strange 
  incident.  Here is a brief:I ran a package which runs every day early 
  in the morning.  I create a logof the process through the spool 
  command.Today my package didn't run.  It had an error saying 'ERROR 
  at line 1: ORA-04068: existing state of packages has been discarded' 
  .  Anyway, not abig deal.  I think I eliminated the 
  error.The thing that puzzles me is that error IS NOT in the alert 
  log.  I had animpression that alert log would capture ALL of the 
  errors occurring on thesystem.  Isn't it the case?Thank you for 
  your support.Lyuda Hoska-- 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-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: Oracle Support

[Deshpande, Kirti]

I too had a very good experience the day before. 
Called OWS over the phone.. (liked their new classical music, BTW) with
Priority-1 call. 
Got an analyst within 5 minutes. He knew what he was talking about and
resolved the problem within the next 20 minutes. He called back after an
hour later to make sure the database was up and okay and asked my permission
to close the TAR. 
BTW, he was from Colorado Springs support center and I had called during the
normal business hours in the US (Central time zone)... 

Hope they keep improving... 


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

> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 2:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle Support
> 
> Because there has been come moaning and groaning about Oracle Support, I
> just want to say that one Oracle Technician helped me fix a problem in two
> minutes.
> 
> Great!  I am very happy.
> 
> 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]  
> 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).

RE: sqlplus question ???

[Seley, Linda]

Add a 

break on report

Linda

-Original Message-
Sent: Thursday, July 12, 2001 5:46 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I have these in sqlplus:
set pagesize 999
Set linesize 100
Col file_name format a50
Col bytes format 999,999,999,999
compute sum of bytes on report
select file_name, bytes from dba_data_files order by
file_name;

The query returns all the data files back, but it did
NOT show the sum of the bytes.  Is there anything I
forgot to set?  Thank you.

Andrea




__
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: Andrea Oracle
  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: Seley, Linda
  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: sqlplus question ???

[Vergara, Michael (TEM)]

Andrea:

You need to ad 'break on report', as in

set pagesize 999
Set linesize 100
Col file_name format a50
Col bytes format 999,999,999,999
compute sum of bytes on report
break on report   <== Here!
select file_name, bytes from dba_data_files order by
file_name;

HTH,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Thursday, July 12, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I have these in sqlplus:
set pagesize 999
Set linesize 100
Col file_name format a50
Col bytes format 999,999,999,999
compute sum of bytes on report
select file_name, bytes from dba_data_files order by
file_name;

The query returns all the data files back, but it did
NOT show the sum of the bytes.  Is there anything I
forgot to set?  Thank you.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Order By Position and UNION

[JRicard982]

Larry,

You can use column name if you only have two statements with your set 
operators.  However, any more than that you must user positional.  See below.


  1  select empno, ename from emp
  2  union
  3  select deptno, dname from dept
  4  union
  5  select locid, room from location
  6* order by empno
SQL> /
order by empno
 *
ERROR at line 6:
ORA-00904: invalid column name


SQL> select empno, ename from emp
  2  union
  3  select deptno, dname from dept
  4  union
  5  select locid, room from location
  6  order by 1
  7  /

 EMPNO ENAME
-- --
    10 ACCOUNTING
    20 RESEARCH
    30 SALES
    40 OPERATIONS
    45 101
    46 202
    47 103
    48 105
    49 105
    50 404
    51 421
    52 211
    53 424
    54 402
    55 433
    56 217
    57 222
  7369 SMITH
  7499 ALLEN
  7521 WARD
  7566 JONES
  7654 MARTIN
  7698 BLAKE
  7782 CLARK
  7788 SCOTT
  7839 KING
  7844 TURNER
  7876 ADAMS
  7900 JAMES
  7902 FORD
  7934 MILLER

31 rows selected.

SQL> 

Problem with performance

[Alexander Ordonez]

Hi gurus,

I have problem with the performance of the Database
the user report that db is very slow.
i check the statistics i get:

free buffer waits in 72774
buffer busy waits in 171940

this isthe only high..other is normal

the dba shutdown every day in the night for backup

somebody can help me!!!


@lex

  Lic. Alexander Ordóñez Arroyo 
  Caja Costarricense del Seguro Social 
  Soporte Técnico - División de Informática 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]


UNIX is very user friendly, 
It's just very particular about who it makes friends with.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexander Ordonez
  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: ONS Install - my life is at an end

[Stephane Faroult]

"Mohan, Ross" wrote:
> 
> Ok, so no one liked the InterMedia Question, so let's forget that one.
> 
> How about this?
> 
> ONS, ver817namesctl installs and builds OK, but I cannot get names (name
> server) to run.if i run the make manually, it claims to be missing
> libnon8.a
> 
> Sure enough, it's not on the file system.
> 
> Any one run into this? I didnot find anything on MetaRetch, and R'ing the FM
> did
> not help...
> 
> Thanks in advance!
> 
> - Ross

Ross,

   I do not have any libnon8.a either on my machine, but I have a
libnoname8.a.

If I were you, I would try
cd $ORACLE_HOME/lib
ln -s libnoname8.a libnon.a

and run 'make' again. Just in case.

-- 
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).

sqlplus question ???

[Andrea Oracle]

Hi all,

I have these in sqlplus:
set pagesize 999
Set linesize 100
Col file_name format a50
Col bytes format 999,999,999,999
compute sum of bytes on report
select file_name, bytes from dba_data_files order by
file_name;

The query returns all the data files back, but it did
NOT show the sum of the bytes.  Is there anything I
forgot to set?  Thank you.

Andrea




__
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: Andrea Oracle
  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: Semaphores

[Scott Shafer]

try: "man ipcs" to get details of the command.

--Scott


Kimberly Smith wrote:
> 
> Does any one know how to monitor semaphore usage in HPUX 11?
>

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: 9i standby

[Hillman, Alex]

Can you tell us please what are specifics in configuring database for such
load.

Alex Hillman

-Original Message-
Sent: Thursday, July 12, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L


Properly designed and configured replication
environments, especially on 8i+, can handle a
phenomenal transaction level.  I've worked with sites
that replicate 20GB+ a day and db performance is
excellent.  On the other hand, I've also worked with
sites that were such a mess that replicating 100MB a
day was an effort.

I think there's just less margin for error in
designing and configuring a replication environment
when you're dealing with that high a transaction load.

My $.02

-- Anita

--- Brian McGraw <[EMAIL PROTECTED]>
wrote:
> Most of the high-volume replicated sites that I have
> heard of over the past few years use Quest's
> Shareplex.  I've had no experience with Clustra.
> 
> Brian
> --
> --
> | Brian McGraw -- Oracle DBA |
> | Central Alabama Oracle Users Group |
> ||
> | mailto:[EMAIL PROTECTED]  |
> | http://bmcgraw.home.mindspring.com |
> --
> 
> David Turner wrote:
> 
> > Thanks. If anyone else knows of anything out there
> for really high volume replication over
> > a WAN it would be appreciated. I was under the
> impression that banks, credit card companies, and
> > telephone companies were replicating there data
> using Oracle but it doesn't look like it.
> > Anyone know what they are using? It also seems
> like for certain apps they would have to
> > use synchronous replicatiion.  Has anyone had any
> experience with Clustra?
> >
> > Dave
> >
> > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE
> TESTA wrote:
> > > Page 61 of Oracle 9i, Data Guard concept.pdf
> > >
> > > says the standby can be in one of 2 states, open
> for read-only or in managed recovery mode.  if its
> open in read only, it can't have logs applied.  I've
> not gotten around to testing that 9i concept yet. 
> although it looks like it will be kewl to flip
> between primary and standby WITHOUT rebuilding :)
> > >
> > > hth, joe
> > >
> > >
> > >
> > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> > >
> > > Anyone know if the standby in 9i can be in
> readonly mode while the logs are
> > > being applied? I've heard about this as being
> the case and also that this isn't
> > > the case.
> > >
> > > Thanks, Dave Turner
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: David Turner
> > >   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: David Turner
> >   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: Brian McGraw
>   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-- 

MINUS--Sql help

[Ravindra Basavaraja]

I am writing a SQL query using the MINUS operator.Both the select statements
return a number result and I
am trying to get the o/p with the difference of both the queries using the
MINUS
between the two select statements.But I am getting the o/p of the first
query only
and the displayed result is not the subtracted value.Both select statements
give
different number o/p when run individually.What could be wrong.

Is there anything that i am missing to consider when using the MINUS
operator.

Pls help

Thanks
Ravindra

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  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: 9i standby

[Stephane Faroult]

"Gogala, Mladen" wrote:
> 
> Replication happens in discrete chunks and there is a distinct possibility
> of losing data if replication was used in banks. Banks and other financial
> institutions are using OPS with EMC or DiskShark (IBM) based remote
> replication


Hmmm. Banks are two different worlds, the staid world of retail banking
and the wild wild one of investment banking.

-- 
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).

ONS Install - my life is at an end

[Mohan, Ross]

Ok, so no one liked the InterMedia Question, so let's forget that one. 

How about this?

ONS, ver817namesctl installs and builds OK, but I cannot get names (name
server) to run.if i run the make manually, it claims to be missing
libnon8.a

Sure enough, it's not on the file system. 

Any one run into this? I didnot find anything on MetaRetch, and R'ing the FM
did
not help...

Thanks in advance!

- Ross
-- 
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).

Re: 9i standby

[Rachel Carmichael]

there are actually two kinds of "standby" that they are talking about in 
9i..

if you use the logminer to generate the SQL for the standby db, then you are 
applying SQL statements to the standby and you can run read-only 
transactions about it.

If you go to oracle online ed, there is a presentation on high availability 
there that you can sign up for (free registration) and it talks about this.

Rachel


>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: 9i standby
>Date: Thu, 12 Jul 2001 12:05:57 -0800
>
>Page 61 of Oracle 9i, Data Guard concept.pdf
>
>says the standby can be in one of 2 states, open for read-only or in 
>managed recovery mode.  if its open in read only, it can't have logs 
>applied.  I've not gotten around to testing that 9i concept yet.  although 
>it looks like it will be kewl to flip between primary and standby WITHOUT 
>rebuilding :)
>
>hth, joe
>
>
>
> >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
>
>Anyone know if the standby in 9i can be in readonly mode while the logs are
>being applied? I've heard about this as being the case and also that this 
>isn't
>the case.
>
>Thanks, Dave Turner
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: David Turner
>   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: 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).

Re: Probelm with W2K large datafile creation

[A. Bardeen]

John,

I'm not aware of any P4 issues like this.  When you
say the process "went away" was the oracle process
still getting CPU time or was it idle?  Any disk
activity?

BTW, there is a nasty bug on 8i on NT/Win2K (bug
1668488) where files that autoextend exactly onto a
4GB boundary cannot be written to or recovered. 
Creating or manually resizing files seems to be OK,
it's only when they autoextend that the bug is
encountered.

HTH,

-- Anita

--- "Shaw, John B" <[EMAIL PROTECTED]> wrote:
> I finally got 8.1.7 installed on the new Dell P4,
> had to manually set the
> path and create a listener thru command line
> interface. When I tried to
> create a tablespace at 8G (one datafile) the process
> went away (went to
> lunch still nothing). Anyone know of a bug in this
> area. A 6G tablespace
> create worked fine, and I could create tablespace
> datafiles this size on P3
> systems. Did a pentium 4 search on metalink and all
> I got was the patch
> stuff.
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Shaw, John B
>   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: 9i standby

[John Lewis]

Any papers/books you can recommend on getting it 'right'?

-Original Message-
Sent: Thursday, July 12, 2001 3:25 PM
To: Multiple recipients of list ORACLE-L


Properly designed and configured replication
environments, especially on 8i+, can handle a
phenomenal transaction level.  I've worked with sites
that replicate 20GB+ a day and db performance is
excellent.  On the other hand, I've also worked with
sites that were such a mess that replicating 100MB a
day was an effort.

I think there's just less margin for error in
designing and configuring a replication environment
when you're dealing with that high a transaction load.

My $.02

-- Anita

--- Brian McGraw <[EMAIL PROTECTED]>
wrote:
> Most of the high-volume replicated sites that I have
> heard of over the past few years use Quest's
> Shareplex.  I've had no experience with Clustra.
> 
> Brian
> --
> --
> | Brian McGraw -- Oracle DBA |
> | Central Alabama Oracle Users Group |
> ||
> | mailto:[EMAIL PROTECTED]  |
> | http://bmcgraw.home.mindspring.com |
> --
> 
> David Turner wrote:
> 
> > Thanks. If anyone else knows of anything out there
> for really high volume replication over
> > a WAN it would be appreciated. I was under the
> impression that banks, credit card companies, and
> > telephone companies were replicating there data
> using Oracle but it doesn't look like it.
> > Anyone know what they are using? It also seems
> like for certain apps they would have to
> > use synchronous replicatiion.  Has anyone had any
> experience with Clustra?
> >
> > Dave
> >
> > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE
> TESTA wrote:
> > > Page 61 of Oracle 9i, Data Guard concept.pdf
> > >
> > > says the standby can be in one of 2 states, open
> for read-only or in managed recovery mode.  if its
> open in read only, it can't have logs applied.  I've
> not gotten around to testing that 9i concept yet. 
> although it looks like it will be kewl to flip
> between primary and standby WITHOUT rebuilding :)
> > >
> > > hth, joe
> > >
> > >
> > >
> > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> > >
> > > Anyone know if the standby in 9i can be in
> readonly mode while the logs are
> > > being applied? I've heard about this as being
> the case and also that this isn't
> > > the case.
> > >
> > > Thanks, Dave Turner
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: David Turner
> > >   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: David Turner
> >   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: Brian McGraw
>   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 List

OT: Order By Position and UNION

[Larry Elkins]

Listers,

<<>>

For compound queries (containing set operators UNION, INTERSECT, MINUS, or
UNION ALL), the ORDER BY clause must use positions, rather than explicit
expressions.

<<>>

Now, against an 8.1.7 DB on WIN2K:

SQL> select deptno, loc from dept
  2  union
  3  select empno, ename from emp
  4  order by deptno --<< DEPTNO, not 1
  5  /

DEPTNO LOC
-- -
10 NEW YORK
20 DALLAS
30 CHICAGO
40 BOSTON
  7369 SMITH
  7499 ALLEN


I've always used positional notation in the ORDER BY on my queries using set
operators, and, the snippet from the SQL manual still says you have to. The
9i manual at tahiti contains the same statement regarding positional
notation. Now I've got someone telling me they *think* they were using
expressions even back in 7.x. Now I'm going to play it safe and continue to
use positional notation, but, I was wondering if anyone has any insight into
this. I hadn't tried expressions in V7 and was curious if it was accepted
even back then. Is this simply a documentation bug? There have been lots of
enhancements to Oracle's SQL over the last few years so I could see them
missing something.

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: alert log is not capturing all errors

[John Carlson]

The alert log does not capture anything it considers to 
be a user error.
 
HTH,
John
>>> [EMAIL PROTECTED] 07/12/01 12:35PM 
>>>Hi List,I have encountered a little strange incident.  
Here is a brief:I ran a package which runs every day early in the 
morning.  I create a logof the process through the spool 
command.Today my package didn't run.  It had an error saying 'ERROR at 
line 1: ORA-04068: existing state of packages has been discarded' .  
Anyway, not abig deal.  I think I eliminated the error.The thing 
that puzzles me is that error IS NOT in the alert log.  I had 
animpression that alert log would capture ALL of the errors occurring on 
thesystem.  Isn't it the case?Thank you for your 
support.Lyuda Hoska-- 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-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: alert log is not capturing all errors

[John Lewis]

You may be thinking of Sybase. 
That is one neat feature about it.

  >>> [EMAIL PROTECTED] 07/12/01 12:35PM 
  >>>Hi List,I have encountered a little strange 
  incident.  Here is a brief:I ran a package which runs every day early 
  in the morning.  I create a logof the process through the spool 
  command.Today my package didn't run.  It had an error saying 'ERROR 
  at line 1: ORA-04068: existing state of packages has been discarded' 
  .  Anyway, not abig deal.  I think I eliminated the 
  error.The thing that puzzles me is that error IS NOT in the alert 
  log.  I had animpression that alert log would capture ALL of the 
  errors occurring on thesystem.  Isn't it the case?Thank you for 
  your support.Lyuda Hoska-- 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-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: 9i standby

[A. Bardeen]

Properly designed and configured replication
environments, especially on 8i+, can handle a
phenomenal transaction level.  I've worked with sites
that replicate 20GB+ a day and db performance is
excellent.  On the other hand, I've also worked with
sites that were such a mess that replicating 100MB a
day was an effort.

I think there's just less margin for error in
designing and configuring a replication environment
when you're dealing with that high a transaction load.

My $.02

-- Anita

--- Brian McGraw <[EMAIL PROTECTED]>
wrote:
> Most of the high-volume replicated sites that I have
> heard of over the past few years use Quest's
> Shareplex.  I've had no experience with Clustra.
> 
> Brian
> --
> --
> | Brian McGraw -- Oracle DBA |
> | Central Alabama Oracle Users Group |
> ||
> | mailto:[EMAIL PROTECTED]  |
> | http://bmcgraw.home.mindspring.com |
> --
> 
> David Turner wrote:
> 
> > Thanks. If anyone else knows of anything out there
> for really high volume replication over
> > a WAN it would be appreciated. I was under the
> impression that banks, credit card companies, and
> > telephone companies were replicating there data
> using Oracle but it doesn't look like it.
> > Anyone know what they are using? It also seems
> like for certain apps they would have to
> > use synchronous replicatiion.  Has anyone had any
> experience with Clustra?
> >
> > Dave
> >
> > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE
> TESTA wrote:
> > > Page 61 of Oracle 9i, Data Guard concept.pdf
> > >
> > > says the standby can be in one of 2 states, open
> for read-only or in managed recovery mode.  if its
> open in read only, it can't have logs applied.  I've
> not gotten around to testing that 9i concept yet. 
> although it looks like it will be kewl to flip
> between primary and standby WITHOUT rebuilding :)
> > >
> > > hth, joe
> > >
> > >
> > >
> > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> > >
> > > Anyone know if the standby in 9i can be in
> readonly mode while the logs are
> > > being applied? I've heard about this as being
> the case and also that this isn't
> > > the case.
> > >
> > > Thanks, Dave Turner
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: David Turner
> > >   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: David Turner
> >   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: Brian McGraw
>   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 EX

Semaphores

[Kimberly Smith]

Does any one know how to monitor semaphore usage in HPUX 11?


Kimberly Smith
Database Administrator
IT Dept. - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [EMAIL PROTECTED]

-- 
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: 9i standby

[Gogala, Mladen]

Replication happens in discrete chunks and there is a distinct possibility
of losing data if replication was used in banks. Banks and other financial
institutions are using OPS with EMC or DiskShark (IBM) based remote
replication
facilities. I know that Oxford Health Plans uses 4-way parallel server for 
both data safety and performance reasons.

-Original Message-
Sent: Thursday, July 12, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L


Thanks. If anyone else knows of anything out there for really high volume
replication over
a WAN it would be appreciated. I was under the impression that banks, credit
card companies, and 
telephone companies were replicating there data using Oracle but it doesn't
look like it.
Anyone know what they are using? It also seems like for certain apps they
would have to
use synchronous replicatiion.  Has anyone had any experience with Clustra?

Dave


On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote:
> Page 61 of Oracle 9i, Data Guard concept.pdf 
> 
> says the standby can be in one of 2 states, open for read-only or in
managed recovery mode.  if its open in read only, it can't have logs
applied.  I've not gotten around to testing that 9i concept yet.  although
it looks like it will be kewl to flip between primary and standby WITHOUT
rebuilding :)
> 
> hth, joe
> 
> 
> 
> >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> 
> Anyone know if the standby in 9i can be in readonly mode while the logs
are
> being applied? I've heard about this as being the case and also that this
isn't
> the case. 
> 
> Thanks, Dave Turner
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: David Turner
>   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: David Turner
  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: rman question

[Janardhana Babu]

Title: RE: rman question






You may try duplicate database with the dbname the same as test database using RMAN. 


You may need to use the tag command while backing up sothat you can specify the tag while restoring, but, if more than one backupset available with the same tag (it is in most cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list.

  


-Original Message-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject: rman question



Hi Dear List,


We are using unix shell script to cold backup our production right now
and ftp the backupset to the test machine refresh the testing instance
once a week.
My question is if I decide to use rman instead shell script. How it
works with cold backup? Can I using rman catalog to restore a production
database to test database? Can I restore obsolete backups to another
machine using rman? Sometimes we have to restore old backups on the test
machine to debug a production problem.


Thanks a lot.


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

rman question

[Joan Hsieh]

Hi Dear List,

We are using unix shell script to cold backup our production right now
and ftp the backupset to the test machine refresh the testing instance
once a week.
My question is if I decide to use rman instead shell script. How it
works with cold backup? Can I using rman catalog to restore a production
database to test database? Can I restore obsolete backups to another
machine using rman? Sometimes we have to restore old backups on the test
machine to debug a production problem.

Thanks a lot.

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  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: 9i standby

[Janardhana Babu]

How to restore the online logs 
in case of failover? Is there any mechanism available to restore to the point of 
failure? I believe standby database only applies archived logs (Assuming we 
can't archive the current logs in case of failure). 
 
Thanks.

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 1:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  9i standby
  Page 61 of Oracle 9i, Data Guard concept.pdf 
   
  says the standby can be in one of 2 states, open for 
  read-only or in managed recovery mode.  if its open in read only, it 
  can't have logs applied.  I've not gotten around to testing that 9i 
  concept yet.  although it looks like it will be kewl to flip between 
  primary and standby WITHOUT rebuilding :)
   
  hth, joe
   
  >>> [EMAIL PROTECTED] 07/12/01 03:26PM 
  >>>Anyone know if the standby in 9i can be in readonly mode 
  while the logs arebeing applied? I've heard about this as being the case 
  and also that this isn'tthe case. Thanks, Dave Turner-- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: David 
  Turner  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: 9i standby

[Brian McGraw]

Most of the high-volume replicated sites that I have heard of over the past few years 
use Quest's Shareplex.  I've had no experience with Clustra.

Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--

David Turner wrote:

> Thanks. If anyone else knows of anything out there for really high volume 
>replication over
> a WAN it would be appreciated. I was under the impression that banks, credit card 
>companies, and
> telephone companies were replicating there data using Oracle but it doesn't look 
>like it.
> Anyone know what they are using? It also seems like for certain apps they would have 
>to
> use synchronous replicatiion.  Has anyone had any experience with Clustra?
>
> Dave
>
> On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote:
> > Page 61 of Oracle 9i, Data Guard concept.pdf
> >
> > says the standby can be in one of 2 states, open for read-only or in managed 
>recovery mode.  if its open in read only, it can't have logs applied.  I've not 
>gotten around to testing that 9i concept yet.  although it looks like it will be kewl 
>to flip between primary and standby WITHOUT rebuilding :)
> >
> > hth, joe
> >
> >
> >
> > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> >
> > Anyone know if the standby in 9i can be in readonly mode while the logs are
> > being applied? I've heard about this as being the case and also that this isn't
> > the case.
> >
> > Thanks, Dave Turner
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David Turner
> >   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: David Turner
>   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: Brian McGraw
  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: 9i standby

[David Turner]

Thanks. If anyone else knows of anything out there for really high volume replication 
over
a WAN it would be appreciated. I was under the impression that banks, credit card 
companies, and 
telephone companies were replicating there data using Oracle but it doesn't look like 
it.
Anyone know what they are using? It also seems like for certain apps they would have to
use synchronous replicatiion.  Has anyone had any experience with Clustra?

Dave


On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote:
> Page 61 of Oracle 9i, Data Guard concept.pdf 
> 
> says the standby can be in one of 2 states, open for read-only or in managed 
>recovery mode.  if its open in read only, it can't have logs applied.  I've not 
>gotten around to testing that 9i concept yet.  although it looks like it will be kewl 
>to flip between primary and standby WITHOUT rebuilding :)
> 
> hth, joe
> 
> 
> 
> >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>
> 
> Anyone know if the standby in 9i can be in readonly mode while the logs are
> being applied? I've heard about this as being the case and also that this isn't
> the case. 
> 
> Thanks, Dave Turner
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: David Turner
>   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: David Turner
  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).

Possible DBA position in Washington, DC

[tday6]

Just in case anybody in the DC area is thinking about a new position:

We are competing for a contract that will be awarded Sept. 25th.

Looking for a production Oracle DBA 8i on Windows 2000.  Needs to know
PL/SQL (lots of triggers) and comfortable with database design and
development.  Don't need Forms or Reports.

Needs to be able to pass a security clearance (past 15 years).

Work site is in downtown DC, easily Metro accessible.

Small company, full-time, permanent employee.

If you'd like to explore it, e-mail me directly.

-- 
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: How much Buffer busy waits?

[Mohammad Rafiq]

Mladen,
You are still s young although you always give an impression that 
you are to old.However welcome back with your quick 
responses
One of your fan..
Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 12 Jul 2001 11:08:03 -0800

That is the best guess so far. Question of Buffer Busy Waits, universe and
everything

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



42

On Thu, Jul 12, 2001 at 07:20:38AM -0800, Gogala, Mladen wrote:
 > It should be  1101961.
 >
 > -Original Message-
 > Sent: Wednesday, July 11, 2001 5:13 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > 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
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
   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).

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

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

[Stephane Faroult]

Seema Singh wrote:
> 
> Hi
> One of production database showing waits in v$waitstat like
> CLASS   COUNT
> undo header 300
> and undo block 38
> I saw in v$rollstat and found wraps in rollback segment.
> But I haven't see contention in rollback segment.What is the group view?
> Can I increase extent size or not?
> Thanks
> -Seema

Seema,

   It's not a matter of extent size, it's a sheer matter of number of
rollback segments. You do not have enough, and transactions are
scrambling for slots (if you have ever passed through a busy airport,
you get the picture. You need more runways).
  Official figure is one for about 4 concurrent active transactions, up
to 50.
-- 
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: how to check BG process in WIN2000

[A. Bardeen]

Seema,

On NT/Win2K all of the Oracle processes are
implemented as threads within a single OS process. 
You'll need something like QSLICE (part of the NT
resource kit, not sure about Win2K) to view the
individual threads.

Not knowing the info that you're seeking, is
V$BGPROCESS of any help?

HTH,

-- Anita

--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> How to check Oracle background processes in WIN2000.
> Like ps -ef |grep smon in unix
> 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).


__
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).

Probelm with W2K large datafile creation

[Shaw, John B]

I finally got 8.1.7 installed on the new Dell P4, had to manually set the
path and create a listener thru command line interface. When I tried to
create a tablespace at 8G (one datafile) the process went away (went to
lunch still nothing). Anyone know of a bug in this area. A 6G tablespace
create worked fine, and I could create tablespace datafiles this size on P3
systems. Did a pentium 4 search on metalink and all I got was the patch
stuff.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw, John B
  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).

ROLLBACK

[Seema Singh]

Hi
One of production database showing waits in v$waitstat like
CLASS   COUNT
undo header 300
and undo block 38
I saw in v$rollstat and found wraps in rollback segment.
But I haven't see contention in rollback segment.What is the group view?
Can I increase extent size or not?
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: 9i standby

[Gogala, Mladen]

I don't think so. My understanding was that you may open
the standby in read only mode, but I don't think that
you can have the database open in the read only mode
and apply logs at the same time. Not before oracle 12j,
anyway.

-Original Message-
Sent: Thursday, July 12, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L



Anyone know if the standby in 9i can be in readonly mode while the logs are
being applied? I've heard about this as being the case and also that this
isn't
the case. 

Thanks, Dave Turner
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  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: 9i standby

[JOE TESTA]

Page 61 of Oracle 9i, Data Guard concept.pdf 
 
says the standby can be in one of 2 states, open for read-only 
or in managed recovery mode.  if its open in read only, it can't have logs 
applied.  I've not gotten around to testing that 9i concept yet.  
although it looks like it will be kewl to flip between primary and standby 
WITHOUT rebuilding :)
 
hth, joe
 
>>> [EMAIL PROTECTED] 07/12/01 03:26PM 
>>>Anyone know if the standby in 9i can be in readonly mode 
while the logs arebeing applied? I've heard about this as being the case and 
also that this isn'tthe case. Thanks, Dave Turner-- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: David 
Turner  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: [Q] which desugner tool better?

[Jon Baker]

Title: RE: [Q] which desugner tool better?





oracle designer over embarcadero any day.  cheaper and more robust, with additional useful products (they are all bundled into the Internet Developer Suite).  and it is not tied to the nic card for licensing.

i've heard cases supporting both sides in the designer and er-win argument.  have not worked with er-win, so i cannot rightfully give any information.





-Original Message-
From: ef 8454 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject: [Q] which desugner tool better?



can anyone give me some ideal about which designer tool better (ER win, 
Oracle designer or Embarcadero)?
What I need to know is functions, user interface, price and 



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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ef 8454
  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: get rid of carriage return in vi

[Mohammad Rafiq]

Following tip from UGU:

STRING STRIPPING

Remove all ^M and other control characters from file ABC

strings ABC > ABC-good

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 12 Jul 2001 06:00:52 -0800

if it is on unix i would run dos2unix on that file

-Original Message-
Chark
Sent: Thursday, July 12, 2001 3:36 AM
To: Multiple recipients of list ORACLE-L


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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Uday C Basavaraj
   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: Mohammad Rafiq
  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 to check BG process in WIN2000

[Tom Schruefer]

I would be interested in that as well, I was able to do that in OS2, 
Win2000 should have caught up by now.

You can verify that the background processes have started though.  Go to 
the "Event Viewer" from the "Admin Tools" menu/folder (found in Programs 
and/or Control Panels) and select "Application Log".  BTW, as I found out 
after messing with Win2000, these logs can fill up and prevent required 
services from launching.

>Jon Walthour - [EMAIL PROTECTED] on 7/12/2001 3:08 PM writes us:

>
>Seema:
>
>As far as I know, all the Oracle background processes on Windows
>NT/2000 run under the oracle executable. So, in Task Manager,
>for example, all you can see is the resource usage of oracle.exe,
>not of the individual processes. The only way I know to monitor
>the individual Oracle processes on NT/2000 is from within the
>database.
>
>Hope this helps.
>
>--
>
>Jon Walthour, OCDBA
>Oracle DBA
>Computer Horizons
>Cincinnati, Ohio
>
>>--- Original Message ---
>>From: "Seema Singh" <[EMAIL PROTECTED]>
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Date: 7/12/01 2:40:58 PM
>>
>
>>Hi
>>How to check Oracle background processes in WIN2000.
>>Like ps -ef |grep smon in unix
>>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).
>>
>
>
>-- 
>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).
>


--
Howard County Public School System, Maryland, USA
[EMAIL PROTECTED]

The views expressed in this message do not represent the views of the 
Howard County Public School System, blaa, blaa, blaa.  You get the idea.

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

[Mohan, Ross]

Thanks for the translate, Chris. 

I must have had too little caffeine this morning!

-Original Message-
Sent: Thursday, July 12, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Buzzwords are great.

There are a few good raid papers on my site that cover some of those he
mentioned.

w/t is write through cache
w/b is write back cache

Write back cache is basically battery backed up memory on the raid
controller to provide exceptially high transactional rates.

Stripe size is the size used when creating arrays, it detirmines how the
scsi controller writes out to disks in stripes.

OS block size is the obvious.

Command tagging is when you allow the OS to send multiple scsi commands to
the controller to execute parallel.  This in theory reduces the need to
awknowledge each request and execute it.

Disconnect/reconnect support is another feature that allows the disk to
disconnect to from the system when handling a load of requests.  This
generally reduces the bus utiliization.


This is a very brief run down of the things mentioned.

HTH,



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


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


Ross,
I love computers and I love tinckering with them to make them run
sweetly, but I don't have a friggen CLUE about what you just wrote!:)  Point
me to the mythical paper where all of this vast knowledge and buzzwords came
from and I will dive in:) KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo drivers for
i/o bus-related hwcheck w/t vice w/b cache, look at stripe stride vice
os block size.

Ross

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


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

[Q] which desugner tool better?

[ef 8454]

can anyone give me some ideal about which designer tool better (ER win, 
Oracle designer or Embarcadero)?
What I need to know is functions, user interface, price and 


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

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

alert log is not capturing all errors

[lhoska]

Hi List,
I have encountered a little strange incident.  Here is a brief:
I ran a package which runs every day early in the morning.  I create a log
of the process through the spool command.
Today my package didn't run.  It had an error saying 'ERROR at line 1: 
ORA-04068: existing state of packages has been discarded' .  Anyway, not a
big deal.  I think I eliminated the error.
The thing that puzzles me is that error IS NOT in the alert log.  I had an
impression that alert log would capture ALL of the errors occurring on the
system.  Isn't it the case?
Thank you for your support.

Lyuda Hoska
-- 
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: URGENT ORA-03113

[Mohammad Rafiq]

In some unix flavour(HP-10.20) 32 bit, it should not exceed 1.75GB ...This 
is as per Oracle Support..I think there was a mail few days back about this 
problem...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 12 Jul 2001 05:05:27 -0800



Helen:

Try reducing your SHMMAX kernel parameter to under 4GB and see
if that works.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

 >--- Original Message ---
 >From: Helen rwulfjeq <[EMAIL PROTECTED]>
 >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 >Date: 7/12/01 6:45:22 AM
 >

 > Hi ALL:
 >Anybody has any luck to install oracle 8.1.7 on Solaris 8. I
installed 8.1.5 on same OS without any problem. When I run dbassist
, I got ORA-03113 error message. Actually It happened when you
execute the command:
 >startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora"
 >I checked previous messages. Someone suggested to reduce the
size of kernel SHMM (I don't remember). I just follow the recommanded
parameters to modify /etc/system. I have no idea how large I
should set the sizes of the parameters.
 >How can I check the bits of OS or ORACLE like (64 bits or 32
bits). IT IS URGENT. I really appreciate your help. I have to
get it done ASAP. It is 4:45am (US CT). I was almost sleepless.
Thank you so much.
 >H.L.
 >
 >
 >
 >-
 >Do You Yahoo!?
 >Get personalized email addresses from Yahoo! Mail - only $35
a year!
 >http://personal.mail.yahoo.com/
 >


--
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).

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

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

9i standby

[David Turner]

Anyone know if the standby in 9i can be in readonly mode while the logs are
being applied? I've heard about this as being the case and also that this isn't
the case. 

Thanks, Dave Turner
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  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: List of installed patches?

[Gene Sais]

There used to be a command under OH/bin called inspdvers.

>>> [EMAIL PROTECTED] 07/12/01 02:31PM >>>
You have the Oracle script owhat or the command what.
However most of the times it doesn't work this way.
Therefore you must identify the library that was
applied. With the library you get the object file.
This can be done with the README.. Then
issue an:

ar -xv  

Compare the two sizes of the object file. If they have
the same size, you "win".

Regards.


--- Glenn Travis <[EMAIL PROTECTED]> wrote:
> How can I find out what patches are installed in my
> Oracle Installation?  (I
> searched metalink, but only found references to
> Oracle Apps).
> 
> Oracle 8.1.6
> Sun Sparc Solaris 8
> 
> 
> -- 
> 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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
Phone : 541149816062

__
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: Christian Trassens
  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).

Oracle Support

[Boivin, Patrice J]

Because there has been come moaning and groaning about Oracle Support, I
just want to say that one Oracle Technician helped me fix a problem in two
minutes.

Great!  I am very happy.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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: Bug in dbstart Script?

[Keith Moore]

I've seen something similar. I installed the Java option and it changed the 
text from "PL/SQL Release 8.1.6.0.0" to "JServer Release 8.1.6.0.0", which 
broke dbstart.

At 09:47 AM 7/12/2001 -0800, you wrote:
>Folks,
>
>I'm not sure if this applies to any of you, but the
>$ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris 2.6
>appears to have a slight bug in it.  Whenever we
>re-booted, during the system startup, the dbstart
>script is called but none of our databases ever come
>up.  I finally tracked it down to this offending piece
>of code in dbstart:
>
>if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
>'
>  /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
>  print substr($3,1,3)}'`
>...
>...
>...
>
>which I've replaced with this:
>
>if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
>'
>  /Oracle8i Enterprise Edition (Release|Version)/
>{substr($5,1,3) ;
>  print substr($5,1,3)}'`
>...
>...
>...
>
>Our databases come up automatically after a re-boot.
>
>hth someone.
>
>mkb
>
>
>__
>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: mohammed bhatti
>   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: Keith Moore
  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 to check BG process in WIN2000

[Jon Walthour]

Seema:

As far as I know, all the Oracle background processes on Windows
NT/2000 run under the oracle executable. So, in Task Manager,
for example, all you can see is the resource usage of oracle.exe,
not of the individual processes. The only way I know to monitor
the individual Oracle processes on NT/2000 is from within the
database.

Hope this helps.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: "Seema Singh" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/12/01 2:40:58 PM
>

>Hi
>How to check Oracle background processes in WIN2000.
>Like ps -ef |grep smon in unix
>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).
>


-- 
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: How much Buffer busy waits?

[Gogala, Mladen]

That is the best guess so far. Question of Buffer Busy Waits, universe and
everything

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



42

On Thu, Jul 12, 2001 at 07:20:38AM -0800, Gogala, Mladen wrote:
> It should be  1101961.
> 
> -Original Message-
> Sent: Wednesday, July 11, 2001 5:13 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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: rollback gen

[Deshpande, Kirti]

Well... . DDL will generate small amount of rollback for changes in the data
dictionary... 
See this:
SQL> select usn, writes from v$rollstat;
 USN  WRITES
   -- --
0716
  2   1472
SQL> get f1.sql
1  create table mytable (mycol number)
2  storage(initial 1M next 1M maxextents 10 pctincrease 0 )
3* tablespace users
SQL> /
Table created.
SQL> select usn, writes from v$rollstat;
 USN WRITES
   -- --
0716
2   3273
SQL>drop table mytable;
Table dropped.
SQL>select usn, writes from v$rollstat;
 USN WRITES
   -- --
0716
2   3781

Regards,

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

> -Original Message-
> From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 9:56 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: rollback gen
> 
> no
> 
> -Original Message-
> Sent: 12 July 2001 14:51
> To: Multiple recipients of list ORACLE-L
> 
> 
> will a ddl statement generate rollback.
> 
> eg: create table or alter table or drop table ...
> 
> thnx in adv.
> 
> svs
> 
> __
> 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
> 
-- 
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).

RE: How much Buffer busy waits?

[Gogala, Mladen]

Well, my SSN is the Sort_Area_Size, my drivers license is number of enqueue
locks
configured on the system,

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


OK, I get credit for a good guess... so what's your social security number,
your driver's license number, your visa and mastercard numbers, and your
oracle sys and UNIX root passwords?  ;-) 

Beware of identity theft... 
Now where's the sticky I had on my monitor with all the passwords...


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


Yes, I was born on January 10th, 1961.

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


Is that your birthday?

-Original Message-
Sent: Thursday, July 12, 2001 9:21 AM
To: Multiple recipients of list ORACLE-L


It should be  1101961.

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


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).
-- 
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).
-- 
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: 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).
-- 
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: 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 PR

how to check BG process in WIN2000

[Seema Singh]

Hi
How to check Oracle background processes in WIN2000.
Like ps -ef |grep smon in unix
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: List of installed patches?

[Christian Trassens]

You have the Oracle script owhat or the command what.
However most of the times it doesn't work this way.
Therefore you must identify the library that was
applied. With the library you get the object file.
This can be done with the README.. Then
issue an:

ar -xv  

Compare the two sizes of the object file. If they have
the same size, you "win".

Regards.


--- Glenn Travis <[EMAIL PROTECTED]> wrote:
> How can I find out what patches are installed in my
> Oracle Installation?  (I
> searched metalink, but only found references to
> Oracle Apps).
> 
> Oracle 8.1.6
> Sun Sparc Solaris 8
> 
> 
> -- 
> 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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
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: Christian Trassens
  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: Bug in dbstart Script?

[Christian Trassens]

YES, it is the bug number: 1154931. I didn't believe
it as you now.


--- mohammed bhatti <[EMAIL PROTECTED]> wrote:
> Folks,
> 
> I'm not sure if this applies to any of you, but the
> $ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris
> 2.6
> appears to have a slight bug in it.  Whenever we
> re-booted, during the system startup, the dbstart
> script is called but none of our databases ever come
> up.  I finally tracked it down to this offending
> piece
> of code in dbstart:
> 
> if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit |
> awk
> '
>  /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
>  print substr($3,1,3)}'`
> ...
> ...
> ...
> 
> which I've replaced with this:
> 
> if test -f $ORACLE_HOME/bin/svrmgrl; then
>  VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit |
> awk
> '
>  /Oracle8i Enterprise Edition (Release|Version)/ 
> {substr($5,1,3) ;
>  print substr($5,1,3)}'`
> ...
> ...
> ...
> 
> Our databases come up automatically after a re-boot.
> 
> hth someone.
> 
> mkb
> 
> 
> __
> 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: mohammed bhatti
>   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).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
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: Christian Trassens
  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]

thank you very much for your help Chris!:)
KK

-Original Message-
Spence
Sent: Thursday, July 12, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L


www.vampired.net

Write-back cache is much faster.

Basically the OS sends an IO request to the controller, it places the change
in the battery backed up memory and responds complete to the OS.
At this point the transaction is done.  Later (ussually seconds) the IO is
written to the disks.  This proves to provide very fast response time due to
the quick return to the OS, it also proves very quick as IO is handled in
larger chunks which takes advantage of the higher IO rates as well as
provides very good use of the stripe size to fully utiliize the stripe width
of a volume rather than sending it small IO's and only using few disks.

Write-through simply means the controller will not claim transaction
complete until the disks have stored the information.
This is generally due to the lack of battery backed up ram.
Battery backuped ram gives you the protection of power loss to finish the
transactions on startup.  Which is why you can give the quick return to the
OS safely.

There are a few articles on my site on Raid which covers a lot of scsi
technology.
You will find them all under Concepts sections under Articles.
The RAID Awakinging is a good article that covers write-back cache if I
remember correctly.



-Original Message-
Sent: Thursday, July 12, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L


Thanks Chris!
I will have to look at your site, what is the URL?  Is there
information to check on w/b w/t cache settings?  Isn't one of them better
than the other? Also, this is not a RAID system, just a couple of SCSI's
hangin out and being beat on. KK

-Original Message-
Spence
Sent: Thursday, July 12, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Buzzwords are great.

There are a few good raid papers on my site that cover some of those he
mentioned.

w/t is write through cache
w/b is write back cache

Write back cache is basically battery backed up memory on the raid
controller to provide exceptially high transactional rates.

Stripe size is the size used when creating arrays, it detirmines how the
scsi controller writes out to disks in stripes.

OS block size is the obvious.

Command tagging is when you allow the OS to send multiple scsi commands to
the controller to execute parallel.  This in theory reduces the need to
awknowledge each request and execute it.

Disconnect/reconnect support is another feature that allows the disk to
disconnect to from the system when handling a load of requests.  This
generally reduces the bus utiliization.


This is a very brief run down of the things mentioned.

HTH,



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



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


Ross,
I love computers and I love tinckering with them to make them run
sweetly, but I don't have a friggen CLUE about what you just wrote!:)  Point
me to the mythical paper where all of this vast knowledge and buzzwords came
from and I will dive in:) KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo drivers for
i/o bus-related hwcheck w/t vice w/b cache, look at stripe stride vice
os block size.

Ross

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


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 

RE: Scsi I/O speed

[Christopher Spence]

www.vampired.net

Write-back cache is much faster.

Basically the OS sends an IO request to the controller, it places the change
in the battery backed up memory and responds complete to the OS.
At this point the transaction is done.  Later (ussually seconds) the IO is
written to the disks.  This proves to provide very fast response time due to
the quick return to the OS, it also proves very quick as IO is handled in
larger chunks which takes advantage of the higher IO rates as well as
provides very good use of the stripe size to fully utiliize the stripe width
of a volume rather than sending it small IO's and only using few disks.

Write-through simply means the controller will not claim transaction
complete until the disks have stored the information.
This is generally due to the lack of battery backed up ram.
Battery backuped ram gives you the protection of power loss to finish the
transactions on startup.  Which is why you can give the quick return to the
OS safely.

There are a few articles on my site on Raid which covers a lot of scsi
technology.
You will find them all under Concepts sections under Articles.
The RAID Awakinging is a good article that covers write-back cache if I
remember correctly.



-Original Message-
Sent: Thursday, July 12, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L


Thanks Chris!
I will have to look at your site, what is the URL?  Is there
information to check on w/b w/t cache settings?  Isn't one of them better
than the other? Also, this is not a RAID system, just a couple of SCSI's
hangin out and being beat on. KK

-Original Message-
Spence
Sent: Thursday, July 12, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Buzzwords are great.

There are a few good raid papers on my site that cover some of those he
mentioned.

w/t is write through cache
w/b is write back cache

Write back cache is basically battery backed up memory on the raid
controller to provide exceptially high transactional rates.

Stripe size is the size used when creating arrays, it detirmines how the
scsi controller writes out to disks in stripes.

OS block size is the obvious.

Command tagging is when you allow the OS to send multiple scsi commands to
the controller to execute parallel.  This in theory reduces the need to
awknowledge each request and execute it.

Disconnect/reconnect support is another feature that allows the disk to
disconnect to from the system when handling a load of requests.  This
generally reduces the bus utiliization.


This is a very brief run down of the things mentioned.

HTH,



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



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


Ross,
I love computers and I love tinckering with them to make them run
sweetly, but I don't have a friggen CLUE about what you just wrote!:)  Point
me to the mythical paper where all of this vast knowledge and buzzwords came
from and I will dive in:) KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo drivers for
i/o bus-related hwcheck w/t vice w/b cache, look at stripe stride vice
os block size.

Ross

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


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* tra

RE: Why this SQL does not work? - Thank You All

[Kevin Lange]

You are welcome.

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


I thank all the people that took time to clear the question.

Kevin Lange
babu
Jack C. Applewhite
Regina Harter
Henry Poras 
Stephane Faroult

I thank all of the above. Your timely response helped me in clearing the
question from my developers.

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).

Bug in dbstart Script?

[mohammed bhatti]

Folks,

I'm not sure if this applies to any of you, but the
$ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris 2.6
appears to have a slight bug in it.  Whenever we
re-booted, during the system startup, the dbstart
script is called but none of our databases ever come
up.  I finally tracked it down to this offending piece
of code in dbstart:

if test -f $ORACLE_HOME/bin/svrmgrl; then
 VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
'
 /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
 print substr($3,1,3)}'`
...
...
...

which I've replaced with this:

if test -f $ORACLE_HOME/bin/svrmgrl; then
 VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
'
 /Oracle8i Enterprise Edition (Release|Version)/ 
{substr($5,1,3) ;
 print substr($5,1,3)}'`
...
...
...

Our databases come up automatically after a re-boot.

hth someone.

mkb


__
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: mohammed bhatti
  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]

Thanks Chris!
I will have to look at your site, what is the URL?  Is there information to
check on w/b w/t cache settings?  Isn't one of them better than the other?
Also, this is not a RAID system, just a couple of SCSI's hangin out and
being beat on.
KK

-Original Message-
Spence
Sent: Thursday, July 12, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Buzzwords are great.

There are a few good raid papers on my site that cover some of those he
mentioned.

w/t is write through cache
w/b is write back cache

Write back cache is basically battery backed up memory on the raid
controller to provide exceptially high transactional rates.

Stripe size is the size used when creating arrays, it detirmines how the
scsi controller writes out to disks in stripes.

OS block size is the obvious.

Command tagging is when you allow the OS to send multiple scsi commands to
the controller to execute parallel.  This in theory reduces the need to
awknowledge each request and execute it.

Disconnect/reconnect support is another feature that allows the disk to
disconnect to from the system when handling a load of requests.  This
generally reduces the bus utiliization.


This is a very brief run down of the things mentioned.

HTH,



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



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


Ross,
I love computers and I love tinckering with them to make them run
sweetly, but I don't have a friggen CLUE about what you just wrote!:)  Point
me to the mythical paper where all of this vast knowledge and buzzwords came
from and I will dive in:) KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo drivers for
i/o bus-related hwcheck w/t vice w/b cache, look at stripe stride vice
os block size.

Ross

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


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 F

RE: Scsi I/O speed

[Christopher Spence]

Buzzwords are great.

There are a few good raid papers on my site that cover some of those he
mentioned.

w/t is write through cache
w/b is write back cache

Write back cache is basically battery backed up memory on the raid
controller to provide exceptially high transactional rates.

Stripe size is the size used when creating arrays, it detirmines how the
scsi controller writes out to disks in stripes.

OS block size is the obvious.

Command tagging is when you allow the OS to send multiple scsi commands to
the controller to execute parallel.  This in theory reduces the need to
awknowledge each request and execute it.

Disconnect/reconnect support is another feature that allows the disk to
disconnect to from the system when handling a load of requests.  This
generally reduces the bus utiliization.


This is a very brief run down of the things mentioned.

HTH,



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


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


Ross,
I love computers and I love tinckering with them to make them run
sweetly, but I don't have a friggen CLUE about what you just wrote!:)  Point
me to the mythical paper where all of this vast knowledge and buzzwords came
from and I will dive in:) KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo drivers for
i/o bus-related hwcheck w/t vice w/b cache, look at stripe stride vice
os block size.

Ross

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


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 PROTECTE

List of installed patches?

[Glenn Travis]

How can I find out what patches are installed in my Oracle Installation?  (I
searched metalink, but only found references to Oracle Apps).

Oracle 8.1.6
Sun Sparc Solaris 8


-- 
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).

RE: How much Buffer busy waits?

[Seema Singh]

8.1.5

>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How much Buffer busy waits?
>Date: Thu, 12 Jul 2001 08:16:18 -0800
>
>What's the version of the database, Mladen??
>
>- Kirti Deshpande
>   Verizon Information Services
>http://www.superpages.com
>
> > -Original Message-
> > From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, July 12, 2001 10:21 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: How much Buffer busy waits?
> >
> > It should be  1101961.
> >
> > -Original Message-
> > Sent: Wednesday, July 11, 2001 5:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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).
> > --
> > 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).
>--
>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).

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

[Guy Hammond]

I think he could create a brand new instance with Oradim, then just edit
the initSID.ora file to point to his old control files. If the layout of
the  file systems are identical, this should work. Off the top of my
head.

g



-Original Message-
Sent: Tuesday, July 10, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L
Subject: 


Registry, services?

OH wait must be an NT thing, sorry, i was having an acid flashback that
unix 
was going down the tubes.

Sorry, joe

Coed-naked Database Administration
Find 'em fragmented, leave 'em coalesced.




>>>[EMAIL PROTECTED] 07/10/01 01:26PM >>>
Hello,
I need to recreate a database, basically make a complete copy of one of
the
existing databases on a new server.  My networking people already copied
all
datafiles, control file, log files, init file, etc to the target server.
They also reproduced operating system directory structure.
What I need to do is to make the second part of the task work, create
the
database, services, etc and make it run.
I have not done it before and if I was doing it I would probably do
export/import type of thing but the higher ups would like to have it
done
this way.
One of the people has an idea suggesting just recreating the registry
setting by exporting it from the existing machine to the new one.
The other option is to reinstall Oracle but I am not sure how to make it
to
accept existing physical components(datafiles, control file, etc).
If someone has a suggestion I would greatly appreciate it.
Thank you in advance.

Lyuda Hoska

--
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).

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph Testa
  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: 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: Why this SQL does not work? - Thank You All

[Rao, Maheswara]

I thank all the people that took time to clear the question.

Kevin Lange
babu
Jack C. Applewhite
Regina Harter
Henry Poras 
Stephane Faroult

I thank all of the above. Your timely response helped me in clearing the
question from my developers.

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: Re: rollback gen

[Jon Walthour]

Nicholas:

Some DDL (CTAS in particular and other commands that are not
exclusively DDL) will generate rollback. The rollback is due
to the data dictionary changes incurred in creating the new table
and extent allocation. If you're not sure, check it out. Just
do a simple test to confirm it.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: Nicholas Tufar <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/12/01 12:01:36 PM
>

>On Thu, 12 Jul 2001, kommareddy sreenivasa wrote:
>
>> will a ddl statement generate rollback.
>> 
>> eg: create table or alter table or drop table ...
>
>As far as I know, no. DDL statements do not generate
>rollback. You have to take a full backup after any DDL.
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Nicholas Tufar
>  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: How much Buffer busy waits?

[Orr, Steve]

OK, I get credit for a good guess... so what's your social security number,
your driver's license number, your visa and mastercard numbers, and your
oracle sys and UNIX root passwords?  ;-) 

Beware of identity theft... 
Now where's the sticky I had on my monitor with all the passwords...


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


Yes, I was born on January 10th, 1961.

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


Is that your birthday?

-Original Message-
Sent: Thursday, July 12, 2001 9:21 AM
To: Multiple recipients of list ORACLE-L


It should be  1101961.

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


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).
-- 
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).
-- 
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: 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).
-- 
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).

RE: Second RBS in system tablespace

[Nikolay Kumanov]

Alex is talking about the case when the rollback tablespace is locally
managed. Bug 1176609. Once I stumbled upon it, that's why I remember it
well.


Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH
47, Tsarigradsko chaussee, Sofia 1504, Bulgaria
phone: +(359-2)4339-643, fax: +(359-2)946-1286
mailto:[EMAIL PROTECTED]

"Show me a completely smooth operation and I'll show you someone who's
covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse:
Dune"



-Original Message-
Posted At: Thursday, July 12, 2001 6:36 PM
Posted To: Oracle
Conversation: Second RBS in system tablespace


Alex ,
Not necessarily . All you have to do is build a
rollback segment in the rollback TBS and bring it
online . 
Cheers,
RS
--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> Also you need rollback segment in system when
> creating database if your
> rollback tablespace is LMT.
> 
> Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nikolay Kumanov
  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: URGENT ORA-03113

[Helen rwulfjeq]

 Hi ALL
Thank you for all of your responses. I made it working now. What I did is to change couple of semaphone parameters by modifying /etc/system file.
Thank you again. I will take a rest now.
L.H.
  Helen rwulfjeq <[EMAIL PROTECTED]> wrote: 

I tried this but didn't work. Thank you so much. 
H.L. 
  Jon Walthour <[EMAIL PROTECTED]> wrote: 
Helen:Try reducing your SHMMAX kernel parameter to under 4GB and seeif that works.--Jon Walthour, OCDBAOracle DBAComputer HorizonsCincinnati, Ohio>--- Original Message --->From: Helen rwulfjeq <[EMAIL PROTECTED]>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Date: 7/12/01 6:45:22 AM>> Hi ALL:>Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened when youexecute the command:>startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora">I checked previous messages. Someone suggested to reduce thesize of kernel SHMM (I don't remember). I just follow the recommandedparameters to modify /etc/system. I have no i!
!
! ! dea how large Ishould set the sizes of the parameters.>How can I check the bits of OS or ORACLE like (64 bits or 32bits). IT IS URGENT. I really appreciate your help. I have toget it done ASAP. It is 4:45am (US CT). I was almost sleepless.Thank you so much.>H.L.->Do You Yahoo!?>Get personalized email addresses from Yahoo! Mail - only $35a year!>http://personal.mail.yahoo.com/>-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jon WalthourINET: [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 in!
!
! ! the message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).


Do You Yahoo!?Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!http://personal.mail.yahoo.com/

RE: Scsi I/O speed

[Kevin Kostyszyn]

Ross,
I love computers and I love tinckering with them to make them run sweetly,
but I don't have a friggen CLUE about what you just wrote!:)  Point me to
the mythical paper where all of this vast knowledge and buzzwords came from
and I will dive in:)
KK

-Original Message-
Sent: Thursday, July 12, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


also, consider turning OFF command tag queueingcheck mobo
drivers for i/o bus-related hwcheck w/t vice w/b cache, look
at stripe stride vice os block size.

Ross

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


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).
--
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: 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 l

RE: How much Buffer busy waits?

[Deshpande, Kirti]

What's the version of the database, Mladen?? 

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

> -Original Message-
> From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 10:21 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How much Buffer busy waits? 
> 
> It should be  1101961.
> 
> -Original Message-
> Sent: Wednesday, July 11, 2001 5:13 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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).
> -- 
> 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).
-- 
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).

RE: x$table

[Guy Hammond]

I think I read once that the X$ tables correspond directly to the C
structs and other data structures used by the Oracle kernel itself, or
maybe that's in the murky depths one level below X$. I don't know of any
situations in which it would be "safe" to attempt to manipulate them. In
fact, unless you're sure what you're doing, stick to DBA_ and above! :0)

g



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


hi list

what is x$ tables and what do they storre rather than
v$ tables.

reg/svs

__
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: kommareddy sreenivasa
  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: 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: URGENT ORA-03113

[Gogala, Mladen]

metalink.oracle.com

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



Hi Ray: 


Thanks. How can I get information about Doc ID: 17613.1 . Also there are
banches of semaphore related parameters. Any guidance to do that?





  Ray Stell <[EMAIL PROTECTED]> wrote: 


On Thu, Jul 12, 2001 at 02:45:22AM -0800, Helen rwulfjeq wrote:
> 
> Hi ALL:
> Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed
8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113
error message. Actually It happened when you execute the command:
> startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora"
> I checked previous messages. Someone suggested to reduce the size of
kernel SHMM (I don't remember). I just follow the recommanded parameters to
modify /etc/system. I have no idea how large I should set the sizes of the
parameters.
> How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS
URGENT. I really appreciate your help. I have to get it done ASAP. It is
4:45am (US CT). I was almost sleepless. Thank you so much.
> H.L.
-- 

Doc ID: 17613.1 seems to have a tria! ! ge for the situation.


another comment from metalink:
Both times I've had the problem it was semaphore related (i.e. not enough).
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
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 Y! ! ahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year!
http://personal.mail.yahoo.com/
 

-- 
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: How much Buffer busy waits?

[Orr, Steve]

Is that your birthday?

-Original Message-
Sent: Thursday, July 12, 2001 9:21 AM
To: Multiple recipients of list ORACLE-L


It should be  1101961.

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


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).
-- 
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).
-- 
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).

RE: view contents of datafile

[Hand, Michael T]

Joe,

I am reading between the lines here, so bear with me.
I think you will be disappointed with the results.  Oracle (8.0.x at least)
will assign extents in a round robin fashion across all online datafiles in
a tablespace.  All three files will have some extents in them.  The only
solution (well, there may be others) is to include a step to drop and
recreate the tablespace after the export.  And, assuming you export with
compress=y, you can create empty tables in the rebuilt tablespace, and know
before you import rows if the tablespace is large enough.

Mike Hand
Polaroid Corp.

-Original Message-
Sent: Wednesday, July 11, 2001 7: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: 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: rollback gen

[Nicholas Tufar]

On Thu, 12 Jul 2001, kommareddy sreenivasa wrote:

> will a ddl statement generate rollback.
> 
> eg: create table or alter table or drop table ...

As far as I know, no. DDL statements do not generate
rollback. You have to take a full backup after any DDL.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicholas Tufar
  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: x$table

[Naik, Kevin K]

Title: RE: x$table





v$ objects are not tables, they are views based on the x$ tables.
The x$ tables are your data dictionary tables, they store meta data (data about data in the db)


-Original Message-
From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]]
Sent: 12 July, 2001 15:51
To: Multiple recipients of list ORACLE-L
Subject: x$table



hi list


what is x$ tables and what do they storre rather than
v$ tables.


reg/svs


__
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: kommareddy sreenivasa
  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).





__
Disclaimer and 
confidentiality note
Everything in this e-mail and 
any attachments relating to the official business of Standard Bank Investment 
Corporation (Stanbic) is proprietary to the company. It is confidential, legally 
privileged and protected by law. Stanbic does not own and endorse any other 
content. Views and opinions are those of the sender unless clearly stated as 
being that of Stanbic. 
The person addressed in the 
e-mail is the sole authorised recipient. Please notify the sender immediately if 
it has unintentionally reached you and do not read, disclose or use the content 
in any way.

Stanbic can not assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference.
 ___

Re: How much Buffer busy waits?

[Ray Stell]

42

On Thu, Jul 12, 2001 at 07:20:38AM -0800, Gogala, Mladen wrote:
> It should be  1101961.
> 
> -Original Message-
> Sent: Wednesday, July 11, 2001 5:13 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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: URGENT ORA-03113

[Helen rwulfjeq]

 I tried this but didn't work. Thank you so much.
H.L.
  Jon Walthour <[EMAIL PROTECTED]> wrote: 
Helen:Try reducing your SHMMAX kernel parameter to under 4GB and seeif that works.--Jon Walthour, OCDBAOracle DBAComputer HorizonsCincinnati, Ohio>--- Original Message --->From: Helen rwulfjeq <[EMAIL PROTECTED]>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Date: 7/12/01 6:45:22 AM>> Hi ALL:>Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened when youexecute the command:>startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora">I checked previous messages. Someone suggested to reduce thesize of kernel SHMM (I don't remember). I just follow the recommandedparameters to modify /etc/system. I have no i!
!
dea how large Ishould set the sizes of the parameters.>How can I check the bits of OS or ORACLE like (64 bits or 32bits). IT IS URGENT. I really appreciate your help. I have toget it done ASAP. It is 4:45am (US CT). I was almost sleepless.Thank you so much.>H.L.->Do You Yahoo!?>Get personalized email addresses from Yahoo! Mail - only $35a year!>http://personal.mail.yahoo.com/>-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jon WalthourINET: [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 in!
!
the message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!http://personal.mail.yahoo.com/

Re: RE: get rid of carriage return in vi

[Jackson Dumas]

If it's in unix then just edit it by vi the file then type
:g/^M/s///g , where you get ^M by pressing CNTRL v & m at the same
time. That should help.

On Thu, 12 Jul 2001 06:00:52 -0800 Uday C Basavaraj
([EMAIL PROTECTED]) wrote:

>if it is on unix i would run dos2unix on that file
>
>-Original Message-
>Chark
>Sent: Thursday, July 12, 2001 3:36 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Uday C Basavaraj
>  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).


Mid-year intake! Enrol NOW & stand a chance to win 25% discount
http://www.milpark.co.za
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jackson Dumas
  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 Buffer busy waits?

[Gogala, Mladen]

Yes, I was born on January 10th, 1961.

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


Is that your birthday?

-Original Message-
Sent: Thursday, July 12, 2001 9:21 AM
To: Multiple recipients of list ORACLE-L


It should be  1101961.

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


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).
-- 
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).
-- 
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: 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: get rid of carriage return in vi

[Ramasamy, Baskar]

How did you that file. I guess it is b'cos of ftp the file. If you setup the
file transfer mode as ascii before ftp from another server

Baskar

-Original Message-
Sent: 12 July 2001 15:01
To: Multiple recipients of list ORACLE-L


if it is on unix i would run dos2unix on that file

-Original Message-
Chark
Sent: Thursday, July 12, 2001 3:36 AM
To: Multiple recipients of list ORACLE-L


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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Uday C Basavaraj
  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: Ramasamy, Baskar
  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

[Sakthi , Raj]

Alex ,
Not necessarily . All you have to do is build a
rollback segment in the rollback TBS and bring it
online . 
Cheers,
RS
--- "Hillman, Alex" <[EMAIL PROTECTED]>
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]
> >
> > 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).


__
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 lin