IMP 8.1.6 to 8.1.7 DB

[Bunyamin K. Karadeniz]

I have an export(full) of 8.1.6 and I wonder if it 
is ok to import it to 8.1.7 ?
 
Thakn you 

RE: How to locate who dropped a view using log miner?

[MacGregor, Ian A.]

Have you thought of writing a trigger to capture the drops.  See chapter 13 Of the 
Application Developers Guide Fundamentals

Ian

-Original Message-
Sent: Tuesday, August 07, 2001 8:11 PM
To: Multiple recipients of list ORACLE-L


Hi listers,

I know most of you will advice me to turn audit on, but I like the hard way better. 
I've been able to locate who drops tables based on dml operations on fixed tables.
According to note 93370.1 from Oracle, the hint for locating who dropped a table is to 
look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e,
SQL> select scn from v$logmnr_contens
2  where operation = 'DELETE' and seg_name = 'COL$'
3  intersect
4  select scn from v$logmnr_contents
5  where operation = 'DELETE' and seg_name = 'OBJ$'
6  intersect
7  select scn from v$logmnr_contents
8  where operation = 'DELETE' and seg_name = 'TAB$';

After this, I will get the SCN that holds drop table statements. 

**
Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and 
alike, from DROP TABLE statements?
**

I know this is a question related to oracle internal values so any help would be 
greatly appreciated.

Salu2

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

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

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

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

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

RE: Unix and Oracle

[Sinardy]

Hi Yosi,

I have a problem in displaying the content like
for Counter = 0 with quite alot of officers with buy and sell

How can I join "buy and sell in the same row in my report" while they are in
diffrent row in my database
for example

Officer   count(*) for buy  count (*) for sell
20  10

Thank you


Sinardy


-Original Message-
Greenfield
Sent: Wednesday, 8 August 2001 1:46 PM
To: Multiple recipients of list ORACLE-L


How in the world did you come up with a subject line
of 'Unix and Oracle?'

I can't help you get that counter column on top of the buy
and sell header line, you may want to put its column to the
left of Officer, and maybe BREAK on it to not print duplicate
values. And you may have to change some formatting
to get the columns how and where you want them, and you
can try using the TTITLE command to print column headers
and not print column headers themselves (SET HEAD OFF).

All that said, as far as the SQL is concerned, here:

SELECT  counter, officer,
sum ( decode ( type,  'BUY', 1, 0) * Price ) Buy,
sum ( decode ( type,  'SELL', 1, 0) * Price ) Sell
FROMsome_table
GROUP BY counter, officer
/

hth,

Yosi



Sinardy wrote:

> Hi all,
>
> I have a table with 3 columns which are Counter, Officer, TYPE, PRICE,
> Counter number 4
> TYPE is only contain either Sell or Buy
> Officer number 4
> price number 11
>
> I want to spool out report with SQL to be like this
> example
>
> Counter : 0
> -Buy-   -Sell-
> Officer
> ==
> 10  11
> 12  13
> 1212 0   1
> 1213 0   0
>
> Total   22  25
>
> I have a problem combining buy and sell column can someone help me please
>
> Thank you
>
> 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).

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

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

Re: connection times...

[Suzy Vordos]

Are these JDBC connections?  8i has a bug with MTS that causes
dispatchers to hang when using JDBC thin connections.  Search Metalink
for Bug 1684600.  We've experienced this problem with both 8.1.5 & 8.1.7
on Solaris 2.7.

Richard Huntley wrote:
> 
> Anyone know of some quick checks to perform or places to start looking when
> it starts to take more than 20 seconds to connect to the database to
> determine what is causing the problem?  We're using MTS, Solaris 2.6,
> v8.1.5...
> 
> TIA,
> Richard Huntley
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SUMMARY: BIG PROBLEM

[Suzy Vordos]

Yep, that was me :)  I left Qwest (formerly U S WEST) last year, one day
after my 19 year anniversary.  No regrets, my new job challenges my
skills and keeps me busy (but leaves little time for beer).  Geesh, here
it is August and I'm finally reading oracle-l from June...


John Kanagaraj wrote:
> 
> Ed,
> 
> >Yea Right!! :)  Might try and get something going with TUSC.
> 
> Don't the BeanCounters and Damagement know that this would probably cost
> more than retaining that other DBA??! (Was that Suzy Vordos at QWest?)
> Another pointy-haired decision IMHO.
> 
> Apologies in advance to TUSCers in this list...
> 
> John Kanagaraj
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Unix and Oracle

[Yosi Greenfield]

How in the world did you come up with a subject line
of 'Unix and Oracle?'

I can't help you get that counter column on top of the buy
and sell header line, you may want to put its column to the
left of Officer, and maybe BREAK on it to not print duplicate
values. And you may have to change some formatting
to get the columns how and where you want them, and you
can try using the TTITLE command to print column headers
and not print column headers themselves (SET HEAD OFF).

All that said, as far as the SQL is concerned, here:

SELECT  counter, officer,
sum ( decode ( type,  'BUY', 1, 0) * Price ) Buy,
sum ( decode ( type,  'SELL', 1, 0) * Price ) Sell
FROMsome_table
GROUP BY counter, officer
/

hth,

Yosi



Sinardy wrote:

> Hi all,
>
> I have a table with 3 columns which are Counter, Officer, TYPE, PRICE,
> Counter number 4
> TYPE is only contain either Sell or Buy
> Officer number 4
> price number 11
>
> I want to spool out report with SQL to be like this
> example
>
> Counter : 0
> -Buy-   -Sell-
> Officer
> ==
> 10  11
> 12  13
> 1212 0   1
> 1213 0   0
>
> Total   22  25
>
> I have a problem combining buy and sell column can someone help me please
>
> Thank you
>
> 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).

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

Unix and Oracle

[Sinardy]

Hi all,

I have a table with 3 columns which are Counter, Officer, TYPE, PRICE, 
Counter number 4
TYPE is only contain either Sell or Buy
Officer number 4
price number 11

I want to spool out report with SQL to be like this
example

Counter : 0
-Buy-   -Sell-
Officer
==
10  11
12  13
1212 0   1
1213 0   0

Total   22  25


I have a problem combining buy and sell column can someone help me please


Thank you

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

Re: sqlloader stops

[Yosi Greenfield]

How about using some GUI tool (or even SQL) to see what
SQL its running, if any, and what counters and waits are
incrementing...

Good luck, keep in touch :-)

Yosi


[EMAIL PROTECTED] wrote:

> Thanks Yosi.
> No, that is not the case..:-(
>
> -Original Message-
> Sent: Tuesday, August 07, 2001 5:37 PM
> To: Multiple recipients of list ORACLE-L
>
> Silly ol' me. Are you out of space in your archive log destination?
>
> This is like a guessing game. :-)
>
> [EMAIL PROTECTED] wrote:
>
> > Hi List,
> > I have another problem.
> > I have a process that loads multiple (~ 20 ) files through sqlloader.  It
> > works fine on other servers.  There is this one server that is giving me a
> > hard time.  It loads 3 files and then stops.  I commented out the third
> call
> > to sqlloader thinking may be there is something wrong with a third text
> > file.  It loaded 3 files again and stopped on the forth one.
> > There is nothing in alert log (no errors).  Also, there is enough space on
> > the drive where the logs are going.
> > Oracle 7.3.4 on NT.
> > If anyone has any idea please let me know...
> >
> > Lyuda Hoska
> > (703)797-8656
>
> --
> 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).
> --
> 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).

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

How to locate who dropped a view using log miner?

[Mario Alberto Ramos Arellano]

Hi listers,

I know most of you will advice me to turn audit on, but I like the hard way better. 
I've been able to locate who drops tables based on dml operations on fixed tables.
According to note 93370.1 from Oracle, the hint for locating who dropped a table is to 
look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e,
SQL> select scn from v$logmnr_contens
2  where operation = 'DELETE' and seg_name = 'COL$'
3  intersect
4  select scn from v$logmnr_contents
5  where operation = 'DELETE' and seg_name = 'OBJ$'
6  intersect
7  select scn from v$logmnr_contents
8  where operation = 'DELETE' and seg_name = 'TAB$';

After this, I will get the SCN that holds drop table statements. 

**
Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and 
alike, from DROP TABLE statements?
**

I know this is a question related to oracle internal values so any help would be 
greatly appreciated.

Salu2

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 locate who dropped a view using log miner?

[Joe Testa]

and you might not find anything.

I'll reiterate, logminer in 8.1.5-.7 is version 1.0, anything of version
1.0 is full of bugs(and logminer has its own share), and does not have
full functionality.

here is the short version.

a DDL statement like drop table, does do DML against underlying tables
that end in $.

tab$, col$, etc.

In an advanced logminer class i teach, you can SOMETIMES find when a
table was dropped based on DML against the data dictionary but NOT
always, why??

well chained/migrated rows is only noted as operation = INTERNAL and you
get NO redo or undo SQL.

I'm not saying logminer is hard to use, but its a bit more than, 

start logminer and look for undo SQL in the v$logmnr_contents view.

joe

-- 
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: Private vs. Public Rollback Segments

[Sinardy]

Hi all,

I think we can create a big private rollback segment for huge transaction
when we need one or two.


Sinardy

-Original Message-
Sent: Wednesday, 8 August 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can someone explain the benefit of using a private rollback segment?  The
only advantage I can see is having more control over what rollback segments
actually come on line when the instance is started.  The drawback is you
have to use the rollback_segments parameter in the parameter file which we
know a lot of newbies miss.  It seems like the easiest way to go is just use
public segments, even in non-parallel server situations and then you don't
have to worry about the rollback_segments parameter.

- Ethan
- http://www.geocities.com/epost1


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


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

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

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

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

RE: How to locate who dropped a view using log miner?

[Tatireddy, Shrinivas (MED, Keane)]

Title: RE: How to locate who dropped a view using log miner?



Hi
 
I dont 
find any records in v$logmnr_contents even if i dropped tables /views. Should i 
enable any parameter and restart db to get records.
 
srinivas

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 07, 2001 9:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  How to locate who dropped a view using log miner?
  take a look at the 
  sys.ind$ table for indexes sys.view$ 
  for views sys.source$ for stored procedures 

  HTH 
  Nick Wagner Quest Software 
  www.quest.com 
  -Original Message- From: Mario 
  Alberto Ramos Arellano [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, August 07, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: How to locate who dropped a view using log miner? 
  
  Hi listers, 
  I know most of you will advice me to turn audit on, but I like 
  the hard way better. I've been able to locate who drops tables based on the 
  dml operations on fixed tables.
  According to note 93370.1 from Oracle, the hint for locating 
  who dropped a table is to look for a DELETE operation on SYS.COL$, SYS.OBJ$ 
  and SYS.TAB$. I.e,
  SQL> select scn from v$logmnr_contens  2  where operation = 'DELETE' and seg_name = 'COL$' 
   3  intersect  4  
  select scn from v$logmnr_contents  5  where 
  operation = 'DELETE' and seg_name = 'OBJ$'  6  intersect  7  select 
  scn from v$logmnr_contents  8  where 
  operation = 'DELETE' and seg_name = 'TAB$'; 
  After this, I will get the SCN that holds drop table 
  statements. 
  ** Challenge Question, how 
  can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and alike, from DROP 
  TABLE statements? ** 
  I know this is a question related to oracle internal values so 
  any help would be greatly appreciated. 
  Salu2 
  Mario Alberto Ramos 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: Mario Alberto Ramos Arellano   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (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: Optimizer Mode......how to choose the right one?

[Veronica Levin]

what may be the differences between using this clause and not using it?

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: deepak thapliyal [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 05:41 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?


try analyzing using the "for all indexed columns"
clause .. 


--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> You probably already thought of this, but I hope you
> aren't analyzing the
> SYS schema?  This can cause terrible performance
> problems.
> 
> Jay Miller
> 
> -Original Message-
> Sent: Tuesday, August 07, 2001 12:06 PM
> To: Multiple recipients of list ORACLE-L
> 
> ...
> 
> I tried FIRST_ROWS, analyzing the tables, but users
> claimed that performance
> was getting worse, so I chaged it to Choose. Always
> analyzing the tables
> 
> but, everytime I analyze the tables, performance
> gets worse.
> Is this a normal behavior?
> 
> Any advice will be welcome!
> 
> thanks is advance,
> 
> Saludos, 
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: deepak thapliyal
  INET: [EMAIL PROTECTED]

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

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

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

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

Private vs. Public Rollback Segments

[Post, Ethan]

Can someone explain the benefit of using a private rollback segment?  The
only advantage I can see is having more control over what rollback segments
actually come on line when the instance is started.  The drawback is you
have to use the rollback_segments parameter in the parameter file which we
know a lot of newbies miss.  It seems like the easiest way to go is just use
public segments, even in non-parallel server situations and then you don't
have to worry about the rollback_segments parameter.

- Ethan
- http://www.geocities.com/epost1 

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

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

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

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

RE: How to locate who dropped a view using log miner?

[Nick Wagner]

Title: RE: How to locate who dropped a view using log miner?





take a look at the 


sys.ind$ table for indexes
sys.view$ for views
sys.source$ for stored procedures


HTH


Nick Wagner
Quest Software
www.quest.com



-Original Message-
From: Mario Alberto Ramos Arellano [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
Subject: How to locate who dropped a view using log miner?



Hi listers,


I know most of you will advice me to turn audit on, but I like the hard way better. I've been able to locate who drops tables based on the dml operations on fixed tables.

According to note 93370.1 from Oracle, the hint for locating who dropped a table is to look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e,

SQL> select scn from v$logmnr_contens
 2  where operation = 'DELETE' and seg_name = 'COL$'
 3  intersect
 4  select scn from v$logmnr_contents
 5  where operation = 'DELETE' and seg_name = 'OBJ$'
 6  intersect
 7  select scn from v$logmnr_contents
 8  where operation = 'DELETE' and seg_name = 'TAB$';


After this, I will get the SCN that holds drop table statements. 


**
Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and alike, from DROP TABLE statements?
**


I know this is a question related to oracle internal values so any help would be greatly appreciated.


Salu2


Mario Alberto Ramos


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


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

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

Optimizer Question

[MacGregor, Ian A.]

Suppose I have two tables.

SQL> describe test
 NameNull?Type
 ---  
 NVALUE  NOT NULL NUMBER(2)

SQL> describe test2
 NameNull?Type
 ---  
 NVALUE   NUMBER(2)
 CVALUE   VARCHAR2(10)

with the following keys

SQL> l
  1  select a.constraint_name, r_constraint_name, b.column_name, constraint_type 
  2  user_constraints a, user_cons_columns b
  3  where a.constraint_name = b.constraint_name
  4  and a.table_name = b.table_name
  5  and a.table_name in ('TEST', 'TEST2')
  6* order by 2 desc
SQL> /

CONSTRAINT_NAMER_CONSTRAINT_NA COLUMN_NAME C
-- --- --- -
TEST_PKNVALUE  P
TEST2_FK   TEST_PK NVALUE  R

and the primary key is enforced via a unique index.

You issue the following  query

 select a.nvalue, a.cvalue from
 test2 a, test b
 where a.nvalue = b.nvalue(+)

Oracle  explain plan is 

 0  SELECT STATEMENT Optimizer=CHOOSE
 10   NESTED LOOPS (OUTER)
 21 TABLE ACCESS (FULL) OF 'TEST2'
 31 INDEX (UNIQUE SCAN) OF 'TEST_PK' (UNIQUE)

---
Why does Oracle even look at  the  test_pk index?  All vaues returned by the query are 
from one table?  The outer join says to print out the rows from test2 reguardless of 
whether a matching row is found in test1.  The outer join would have to check  test in 
case there are more duplicate join keys which match the join key in test2; except that 
the field in test 1 is uniquely indexed, and Oracle knows that.

If a natural join is requested

select a.nvalue, a.cvalue from
test2 a, test b
where a.nvalue = b.nvalue


The plan  is

  0  SELECT STATEMENT Optimizer=CHOOSE
  10   NESTED LOOPS
  21 TABLE ACCESS (FULL) OF 'TEST'
  31 TABLE ACCESS (BY INDEX ROWID) OF 'TEST2'
  43   INDEX (RANGE SCAN) OF 'TEST2_FK' (NON-UNIQUE)


Again why does it look at test.  A natural join  does have to make sure the join keys 
are in both tables.  However Oracle knows via the constraints that  whatever key 
exists in TEST2 must exist in TEST.  It also knows because of the unique index
on TEST(nvalue)  table that it doesn't need to consider the possiblility of duplicate 
keys.

The above is trivial.  However  there are times when Oracle's behavior can be very 
frustrating.  Imagine TEST and TEST2 
with more columns, and a great many rows, imagine a view joining them, imagine the 
performance increase if Oracle would join the tables in the view only when necessary.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]







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

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

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

Re: computer history stories - Now: Age discrimination?

[Babette Turner-Underwood]

Speaking of beer. My husband had his IQ tested
AFTER he discovered beer and whiskey. A few years
later he gave up the stuff and his IQ went up remarkably.
Perhaps IQ is just a measure of sobreity ? ;-)

- Babette

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 11:22 AM


> M...beer
> I think your sort of bringing up that whole nature nurture issue, good
lord
> that's a tough one.  I would tend to agree that a person could have a high
> IQ, or a high ability to learn, but if they are not in an environment that
> promotes learning then they may not fullfill their abilities.  On the
other
> hand, someone in an environement that doesn't promote learning could still
> take upon themselves to educate themselves.
> (and don't knock any spelling errors, I am well aware of the fact that I
> can't spell!)
> KK
>
> -Original Message-
> Walt
> Sent: Tuesday, August 07, 2001 11:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I thought IQ was related to the culture one grows up in, not something
> you're born with.
>
> In other words, if you're white and raised in a middle/upper-class
> environment your chance at doing well on an IQ test are orders of
magnitude
> greater than for other people.
>
> I, of course, did very well on an IQ test when I was a teenager. Then I
> discovered beer and, well, things have gone, um, a bit downhill since
then.
>
> --Walt Weaver
>   Bozeman, Montana, USA
>
> -Original Message-
> Sent: Monday, August 06, 2001 1:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Yes, people are "born" with IQ, not smarts.
>
> I also believe you can alter your IQ slightly.
>
> From what I understand (which may be wrong) is IQ is simply how many
gallon
> tank you were blessed with.
> It does not measure how much you filled this tank.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>

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

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

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

RE: ORA-12546 TNS:permission denied

[Sujatha Madan]

Hi,

I am installing a program that requires root to create/alter a database. I
know this is not "correct" but there is no way around this. I actually
solved the problem by applying 775 permissions to directories higher up in
the order. This seems to have solved the problem.

Thanks for your help anyway.

Sujatha

-Original Message-
Sent: Tuesday, 7 August 2001 9:51 PM
To: Multiple recipients of list ORACLE-L


having root run oracle is a bad thing(it might even be coded to not
allow it).,

and did you mean 12546, the 12456 error makes no sense to me at all.

who were you when you installed the software? you should have been
oracle.

the ONLY thing root ever needs to do is run root.sh at beg/end of
install, then root should never touch anything with oracle again.(ok
there is that stupid agent thing).

joe

Sujatha Madan wrote:
> 
> Hi,
> 
> My UNIX skills are next to nothing...but I am trying to set up an Oracle
> database on a HP-UX system. I have managed to do most things except one
> thing.
> 
> I need the root user to be able to run svrmgrl and create/modify a
database
> and objects within the database.
> 
> I have added the root user to the dba group and set the appropriate Oracle
> environment variables in "root's" .profile file, however whenever I invoke
> svrmgrl I get a ORA 12456 error.
> 
> Could someone please help me!
> 
> Thanks in advance
> 
> Sujatha Madan

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Over seas online demo

[Post, Ethan]

I provided another reply to the wrong post but also check out
www.gotomypc.com, 5 *'s.  If you use 256 color, the right sound codec, 1
frame per second, and nothing more than 800*600 you can get very good
compression, around 500K per minute.  7 MB for a 30 minute demo with audio
ain't bad.  Oh, I only achieved that rate with Windows Media Format, haven't
tried real hard with Real.  Contact me offline if you want.   If I had to
give a live demo of something in 10 minutes through a firewall on any
machine in the network I would use GoToMyPc and a phone call.

- Ethan

>-Original Message-
>From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 4:17 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Over seas online demo
>
>
>Ethan,
>   Yeah I have used that program in the past as well, very 
>cool.  This is
>going to be a live demo, I would consider using Camtasia, but 
>don't those
>files usually get a little large?
>KK
>
>-Original Message-
>Sent: Tuesday, August 07, 2001 6:35 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Kevin,
>
>You might also consider recording the demo using Techsmith's Camtasia
>product www.techsmith.com.  I have used it in the past to 
>record tutorials
>and demos for my web site.  I highly recommend it.  Perhaps 
>you can check
>out also see what http://www.groove.net/ and 
>http://www.webex.com have to
>offer also.
>
>- Ethan
>- http://www.geocities.com/epost1
>
>>-Original Message-
>>From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, August 07, 2001 12:43 PM
>>To: Multiple recipients of list ORACLE-L
>>Subject: OT: Over seas online demo
>>
>>
>>Hi all,
>>  Was wondering if anyone knows of any software (bedsides
>>pcanywhere or
>>Citrix) that could be used to give a demo to a company across
>>the ocean.   I
>>know I have seen it before, we went to a url to see a demo, I
>>want to say it
>>was ms netmeeting but I don't think that is right.  any help would be
>>greatly appreciated.
>>
>>Sincerely,
>>Kevin Kostyszyn
>>DBA
>>Dulcian, Inc
>>www.dulcian.com
>>[EMAIL PROTECTED]
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Kevin Kostyszyn
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>>
>
>---
>-
>--
>This e-mail is intended for the use of the addressee(s) only 
>and may contain
>privileged, confidential, or proprietary information that is 
>exempt from
>disclosure under law.  If you have received this message in 
>error, please
>inform us promptly by reply e-mail, then delete the e-mail and 
>destroy any
>printed copy.   Thank you.
>
>===
>=
>==
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Post, Ethan
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>

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

RE: How to determine checkpoint rate?

[Hillman, Alex]

I began indiscriminantly delete OT messages. Too much. 

Alex Hillman

-Original Message-
Sent: Tuesday, August 07, 2001 6:57 PM
To: Multiple recipients of list ORACLE-L


One more idea, set up www.gotomypc.com on a computer and allow the client
access from one of their machines.  They will be able to see everything you
are doing.  I use it and it is excellent.  It requires no software for the
client and you could have it running in as little as 5-10 minutes.

- Ethan

Good to see Jonathan Lewis posting!  Now if we can only get Steve back!
Perhaps a little too much OT now and then?

>-Original Message-
>From: Post, Ethan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 2:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: How to determine checkpoint rate?
>
>
>I am trying to locate a stat that is incremented every time a 
>checkpoint
>occurs.  I see a few checkpoint related stats in V$SYSTAT but 
>none seem high
>enough to match the number of checkpoints that have occurred 
>as a result of
>log switches, log checkpoint timeouts.  Am I mistaken on this? 
> Is there
>somewhere I can determine the total number of checkpoints that 
>have occurred
>since system startup?
>
>Thanks,
>Ethan
>http://www.geocities.com/epost1
>


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


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

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

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

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

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

Re: How to locate who dropped a view using log miner?

[Joe Testa]

you're making things way too hard.

logminer is in its infancy at best up thru 8.1.7(its a tad bit better in
9i 

and if all goes well, i'll be doing a talk on it at IOUG 2002


How do you handle when things go south and only internal shows as the
operation, you're stuck at best.

joe
Mario Alberto Ramos Arellano wrote:
> 
> Hi listers,
> 
> I know most of you will advice me to turn audit on, but I like the hard way better. 
>I've been able to locate who drops tables based on the dml operations on fixed tables.
> According to note 93370.1 from Oracle, the hint for locating who dropped a table is 
>to look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e,
> SQL> select scn from v$logmnr_contens
>  2  where operation = 'DELETE' and seg_name = 'COL$'
>  3  intersect
>  4  select scn from v$logmnr_contents
>  5  where operation = 'DELETE' and seg_name = 'OBJ$'
>  6  intersect
>  7  select scn from v$logmnr_contents
>  8  where operation = 'DELETE' and seg_name = 'TAB$';
> 
> After this, I will get the SCN that holds drop table statements.
> 
> **
> Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and 
>alike, from DROP TABLE statements?
> **
> 
> I know this is a question related to oracle internal values so any help would be 
>greatly appreciated.
> 
> Salu2
> 
> Mario Alberto Ramos
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mario Alberto Ramos Arellano
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

-- 
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: Optimizer Mode......how to choose the right one?

[deepak thapliyal]

try analyzing using the "for all indexed columns"
clause .. 


--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> You probably already thought of this, but I hope you
> aren't analyzing the
> SYS schema?  This can cause terrible performance
> problems.
> 
> Jay Miller
> 
> -Original Message-
> Sent: Tuesday, August 07, 2001 12:06 PM
> To: Multiple recipients of list ORACLE-L
> 
> ...
> 
> I tried FIRST_ROWS, analyzing the tables, but users
> claimed that performance
> was getting worse, so I chaged it to Choose. Always
> analyzing the tables
> 
> but, everytime I analyze the tables, performance
> gets worse.
> Is this a normal behavior?
> 
> Any advice will be welcome!
> 
> thanks is advance,
> 
> Saludos, 
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: deepak thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 locate who dropped a view using log miner?

[Mario Alberto Ramos Arellano]

Hi listers,

I know most of you will advice me to turn audit on, but I like the hard way better. 
I've been able to locate who drops tables based on the dml operations on fixed tables.
According to note 93370.1 from Oracle, the hint for locating who dropped a table is to 
look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e,
SQL> select scn from v$logmnr_contens
 2  where operation = 'DELETE' and seg_name = 'COL$'
 3  intersect
 4  select scn from v$logmnr_contents
 5  where operation = 'DELETE' and seg_name = 'OBJ$'
 6  intersect
 7  select scn from v$logmnr_contents
 8  where operation = 'DELETE' and seg_name = 'TAB$';

After this, I will get the SCN that holds drop table statements. 

**
Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and 
alike, from DROP TABLE statements?
**

I know this is a question related to oracle internal values so any help would be 
greatly appreciated.

Salu2

Mario Alberto Ramos

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Veronica Levin]

It's correct, 
I've only analyzed the schema where the data of the application is stored.
Thanks for your comment!

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: Miller, Jay [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 04:21 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?


You probably already thought of this, but I hope you aren't analyzing the
SYS schema?  This can cause terrible performance problems.

Jay Miller

-Original Message-
Sent: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L

...

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Over seas online demo

[Kevin Kostyszyn]

Ethan,
Yeah I have used that program in the past as well, very cool.  This is
going to be a live demo, I would consider using Camtasia, but don't those
files usually get a little large?
KK

-Original Message-
Sent: Tuesday, August 07, 2001 6:35 PM
To: Multiple recipients of list ORACLE-L


Kevin,

You might also consider recording the demo using Techsmith's Camtasia
product www.techsmith.com.  I have used it in the past to record tutorials
and demos for my web site.  I highly recommend it.  Perhaps you can check
out also see what http://www.groove.net/ and http://www.webex.com have to
offer also.

- Ethan
- http://www.geocities.com/epost1

>-Original Message-
>From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 12:43 PM
>To: Multiple recipients of list ORACLE-L
>Subject: OT: Over seas online demo
>
>
>Hi all,
>   Was wondering if anyone knows of any software (bedsides
>pcanywhere or
>Citrix) that could be used to give a demo to a company across
>the ocean.   I
>know I have seen it before, we went to a url to see a demo, I
>want to say it
>was ms netmeeting but I don't think that is right.  any help would be
>greatly appreciated.
>
>Sincerely,
>Kevin Kostyszyn
>DBA
>Dulcian, Inc
>www.dulcian.com
>[EMAIL PROTECTED]
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


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


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

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

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

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

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

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

Upgrade problem

[Connie Milliken]

Trying to do an upgrade from 8.0.5 o 8.1.6 on HPUX 11.  When I start up
the
installer, it says Initializing Java Virtual Machine ..
Warning: Missing Charsets in String to Font Set Conversion
Warning:  Cannot convert string "dt-interface user-medium-r-normal-s * *
* *
to type font set"

Any ideas on what this means and how to fix it?

(I have NLS_LANG and ORA_NLS33 and ORACLE_HOME set to the new directory)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 determine checkpoint rate?

[Post, Ethan]

One more idea, set up www.gotomypc.com on a computer and allow the client
access from one of their machines.  They will be able to see everything you
are doing.  I use it and it is excellent.  It requires no software for the
client and you could have it running in as little as 5-10 minutes.

- Ethan

Good to see Jonathan Lewis posting!  Now if we can only get Steve back!
Perhaps a little too much OT now and then?

>-Original Message-
>From: Post, Ethan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 2:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: How to determine checkpoint rate?
>
>
>I am trying to locate a stat that is incremented every time a 
>checkpoint
>occurs.  I see a few checkpoint related stats in V$SYSTAT but 
>none seem high
>enough to match the number of checkpoints that have occurred 
>as a result of
>log switches, log checkpoint timeouts.  Am I mistaken on this? 
> Is there
>somewhere I can determine the total number of checkpoints that 
>have occurred
>since system startup?
>
>Thanks,
>Ethan
>http://www.geocities.com/epost1
>

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

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

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

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

Testing posting to Oracle-L list...

[Denmark Weatherburne]

Hi DBA's,

I joined previously, but for some reason my membership was not activated.
I've joined again and I'm checking if my membership is registered now.

Regards,

Denmark W.


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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Over seas online demo

[Post, Ethan]

Kevin,

You might also consider recording the demo using Techsmith's Camtasia
product www.techsmith.com.  I have used it in the past to record tutorials
and demos for my web site.  I highly recommend it.  Perhaps you can check
out also see what http://www.groove.net/ and http://www.webex.com have to
offer also. 

- Ethan 
- http://www.geocities.com/epost1

>-Original Message-
>From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 12:43 PM
>To: Multiple recipients of list ORACLE-L
>Subject: OT: Over seas online demo
>
>
>Hi all,
>   Was wondering if anyone knows of any software (bedsides 
>pcanywhere or
>Citrix) that could be used to give a demo to a company across 
>the ocean.   I
>know I have seen it before, we went to a url to see a demo, I 
>want to say it
>was ms netmeeting but I don't think that is right.  any help would be
>greatly appreciated.
>
>Sincerely,
>Kevin Kostyszyn
>DBA
>Dulcian, Inc
>www.dulcian.com
>[EMAIL PROTECTED]
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>

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

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

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

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

Re: free up datafile space problem ???

[Jonathan Lewis]

I think you may find that your 'hwm' comment is a
version dependent thing, and a restriction on RMAN
which always seems to back up to the tablespace
'hwm'.

Certainly from 8.0.5 onwards, I have reduced
file sizes before setting tablespaces readonly
by fiddling about with:
alter table move
alter index rebuild
and then resizing data files downwards.



Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 21:50


its like the high water mark in a table but its at the datafile side
instead.

if any block in the datafile has ever had data in it, you can't shrink
it below that point.

hth, joe


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Miller, Jay]

You probably already thought of this, but I hope you aren't analyzing the
SYS schema?  This can cause terrible performance problems.

Jay Miller

-Original Message-
Sent: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L

...

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

Oracle for Unix Clients, LD_LIBRARY_PATH and Its Impact on Other

[MacGregor, Ian A.]

This environment variable is usually not set in UNIX.  However Oracle executables 
require a directory list be passed to the runtime linker; thus when setting up the 
Oracle environment one often  has something akin to the following

setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:/usr/openwin/lib:$ORACLE_HOME/ctx/lib


When a user places such a line or a similar one  in a  .cshrc or a .login file it can 
cause other programs not to run.
The normal procedure of tacking the Oracle required elements  onto the end of a path 
are not effective.

Do other sites  have this problem.   I have thought about employing a wrapper the gist 
of it would look like

#!/bin/sh

ORACLE_HOME=/usr/oracle
export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:$ORACLE_HOME/ctx/lib
export LD_LIBRARY_PATH
TWO_TASK=slac_tcp
export TWO_TASK
tool=`basename $0`
exec $ORACLE_HOME/bin/$tool "$@"


The file would be called something like orawrapper, and  there would be linked files 
named for each executable.  

The other method would be to change how Oracle is linked, that is to incliude the -R 
option and specify the directory search path.

 The first is more flexible  I could specify character sets  and such.  Am I the only 
one who has this problem?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



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

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

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

RE: Precise

[Aponte, Tony]

Title: RE: Precise






First a disclaimer (since this is going to sound like a love feast).  I do not have any ties to Precise Software Solutions nor do I receive any material gain from your purchasing decision.

We've been using it since day one of its release.  It has many of the features common to most application monitoring tools.  What those other tools can't do is prevent themselves from impacting the database.  Precise/SQL takes snapshots of the memory that makes up the SGA and interprets the internal data structures.  It doesn't need to connect and select from x$ or v$ tables and views.  This allows you to crank up the sampling interval to sub-seconds without any impact on your live instance; let me repeat that, without any impact.  If you've ever tried to execute those public-domain scripts to get Worst Offender SQL, Most Waits, V$SESSION_WAIT, etc. you know what I mean.  Then there is all of the nice filtering/capture/graphing/printing to boot.  We got our ROI on the first day we installed the tool.  We were able to detect an intermittent problem that kept eluding us.  The condition occurred so quickly that we couldn't catch it via V$ mere mortal methods, or was so severe that the database hung.  We cranked up the sampling interval to something like 50 times per second to catch the problem.  We have a very complicated environment, from the DBA perspective (150+ databases, home-grown as well as PeopleSoft, Siebel, Retek packages, OLTP, DW, warehouse fulfillment, web-deployed Forms/Reports, ASP, JSP, OAS 4.8, an much more) and without this tool we wouldn't be able to turn around performance issues as quickly as we do.  Oh, and BTW, support is top-notch. These folks really got their act together.

On the down side you ask?  Pricing; eclectic user interface (if you're used to the Windows UI); another tool to manage; SQL tuning support for hints is cumbersome (we cut-n-paste into SQLLab and move on); you'll have to learn to tune from the resource consumption and wait time perspectives.  None of these are real show-stoppers, even pricing when you factor your increased productivity.

I didn't forget Pulse.  We have release 2.1.  Wait for the next release.  'Nuff said.


HTH


Tony Aponte


-Original Message-

From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]

Sent: Tuesday, August 07, 2001 6:15 AM

To: Multiple recipients of list ORACLE-L

Subject: Precise



Is no-one on this list using Precise SQL or Precise Pulse?.  Has anyone

"heard" of them or evaluated them?.



Sean :)


Rookie Data Base Administrator

Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K

[0%] OCP Oracle8i DBA

[0%] OCP Oracle9i DBA

  

Organon (Ireland) Ltd.

E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]


Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA


"Nobody loves me but my mother... and she could be jivin' too."  - BB King


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: O'Neill, Sean

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(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: negative value for buffer cache hit ratio

[K Gopalakrishnan]

Hi,

Generally speaking.. HIT RATIOS does not give the true
picture always. I have seen databases performing
extremely good with 50% and bad databases with 99% hit
ratio.

You should never decide the database performance based
on hit ratio and 90% hit ratio does not mean that 90%
of the data is ALWAYS read from the cache. It
translates in to something like this..A block is read
(consistent get) 9-10 times before written to disk..

You should check your system wide wait statistics for
better tuning..




--- Ramon Estevez <[EMAIL PROTECTED]>
wrote:
> Hi,
> 
> My misses is
> 
> MISS_RATE
> -
> 0.68%
> 
> Is that good or bad, Oracle 8.0.5 Standard Edition,
> Windows 2000.
> 
> Is there a 8.1.7 Standard Edition Version ?
> 
> Ramon Estevez
> [EMAIL PROTECTED]
> 
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Over seas online demo

[Kevin Kostyszyn]

Hey all,
Just wanted to say thanks to everyone that replied to my question.  I am
going to go with a product from Centrinow.com, seems to do the job well and
it's free!!!
Thanks again.
KK

-Original Message-
Michael
Sent: Tuesday, August 07, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L


Yes, NetMeeting can be used for that purpose.  Some of the Oracle Education
sites use it for classwork exercises.

--Michael

-Original Message-
Sent: Tuesday, August 07, 2001 3:43 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Was wondering if anyone knows of any software (bedsides pcanywhere
or
Citrix) that could be used to give a demo to a company across the ocean.   I
know I have seen it before, we went to a url to see a demo, I want to say it
was ms netmeeting but I don't think that is right.  any help would be
greatly appreciated.

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

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

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

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

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

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

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

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

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

RE: sqlloader stops

[lhoska]

Thanks Yosi.
No, that is not the case..:-(

-Original Message-
Sent: Tuesday, August 07, 2001 5:37 PM
To: Multiple recipients of list ORACLE-L


Silly ol' me. Are you out of space in your archive log destination?

This is like a guessing game. :-)


[EMAIL PROTECTED] wrote:

> Hi List,
> I have another problem.
> I have a process that loads multiple (~ 20 ) files through sqlloader.  It
> works fine on other servers.  There is this one server that is giving me a
> hard time.  It loads 3 files and then stops.  I commented out the third
call
> to sqlloader thinking may be there is something wrong with a third text
> file.  It loaded 3 files again and stopped on the forth one.
> There is nothing in alert log (no errors).  Also, there is enough space on
> the drive where the logs are going.
> Oracle 7.3.4 on NT.
> If anyone has any idea please let me know...
>
> Lyuda Hoska
> (703)797-8656

-- 
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).
-- 
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: Optimizer Mode......how to choose the right one?

[Christian Trassens]

If u can persuade them, create better ones. F.e.:

Issue this query to look for better indexes:

select u.name || '.' || ot.name "TABLE",
   oi.name "INDEX",
   ic.pos# "POS",
   c.name "COLUMN",
   h.distcnt "DIST VAL"
from sys.user$ u,
 sys.obj$ ot,
 sys.obj$ oi,
 sys.hist_head$ h,
 sys.col$ c,
 sys.icol$ ic,
 sys.ind$ i
where i.cols > 1
  and i.obj# = ic.obj#
  and i.bo# = ic.bo#
  and i.bo# = c.obj#
  and ic.col# = c.col#
  and i.bo# = h.obj#
  and ic.col# = h.col#
  and ot.obj# = i.bo#
  and oi.obj# = i.obj#
  and u.user# = ot.owner#
  and exists (select null
  from sys.icol$ ic2,
   sys.hist_head$ h2,
   sys.icol$ ic3,
   sys.hist_head$ h3
  where ic2.obj# = ic.obj#
and ic2.bo# = ic.bo#
and ic2.bo# = h2.obj#
and ic3.obj# = ic.obj#
and ic3.bo# = ic.bo#
and ic3.bo# = h3.obj#
and ic2.col# = h2.col#
and ic3.col# = h3.col#
and ic2.pos# > ic3.pos#
and h2.distcnt > h3.distcnt)
order by 1, 2, 3
/

This it will tell you if the index could be better in
another sequence of fields.

Salu2.


--- Veronica Levin <[EMAIL PROTECTED]> wrote:
> what would you do with an application that has 3 GB
> of data and 6 GB of
> indexes
> developers keep telling me that they can't get rid
> of any index because they
> use them all. how can I prove wich indexes are
> never used??
> 
> Saludos, 
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> 
> 
> -Mensaje original-
> De: Christian Trassens [mailto:[EMAIL PROTECTED]]
> Enviado el: Martes, 07 de Agosto de 2001 01:26 p.m.
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Optimizer Mode..how to choose the
> right one?
> 
> 
> NEVER change an optimizer since the application have
> some time working with it. I should leave it in
> CHOOSE
> and then analyze what are doing the transactions.
> 
> Look up the worst events through v$system_Event or
> from time to time through v$session_wait. Issue an
> utlbstat/utlestat or statspack. Then when you know
> which is the worst wait. Maybe "db file scattered
> read" or most of the times "enqueue" or "latch free"
> and sometimes a huge amount of "db file sequential
> read" because of bad indexes. 
> 
> Look up the indexes. Doing that consider their
> clustering_factor, their blevel and the most
> important
> thing their selectivity. ETC.
> 
> 
> --- Veronica Levin <[EMAIL PROTECTED]> wrote:
> > Morning listers!
> > 
> > I am having performance problems with this
> database,
> > transactions ar running
> > very slow and I am not sure if I have choose the
> > right optimizer mode... 
> > 
> > AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real
> > Memory, 
> > 500 MB SGA, 70 concurrent users, mostly OLTP
> > transactions.
> > 
> > I have tunned init parameters the best I can we
> the
> > resources I have:
> > 
> > db_files = 70
> > db_writers = 4
> > db_file_multiblock_read_count = 16
> > db_block_buffers = 57600
> > db_block_size = 8192
> > shared_pool_size = 157286400
> > processes = 200
> > dml_locks = 1500
> > log_buffer = 655360
> > sequence_cache_entries = 800
> > sequence_cache_hash_buckets = 89
> > log_checkpoint_interval = 8
> > optimizer_mode=CHOOSE
> > session_cached_cursors =  300
> > sort_area_size=1048576
> > hash_area_size=262144
> > hash_multiblock_io_count=4
> > hash_join_enabled=TRUE
> > always_anti_join=HASH
> > job_queue_processes=8
> > 
> > 35 rollback segments, inital 1MB, next 1MB,
> optimal
> > 30 MB
> > 8 multiplexed redologs, 30 MB each
> > 
> > I tried FIRST_ROWS, analyzing the tables, but
> users
> > claimed that performance
> > was getting worse, so I chaged it to Choose.
> Always
> > analyzing the tables
> > 
> > but, everytime I analyze the tables, performance
> > gets worse.
> > Is this a normal behavior?
> > 
> > Any advice will be welcome!
> > 
> > thanks is advance,
> > 
> > Saludos, 
> > Veronica Levin Enriquez
> > Administrador AIX
> > Compañía Cervecera de Nicaragua
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Veronica Levin
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (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 PROTECT

RE: negative value for buffer cache hit ratio

[Ramon Estevez]

Hi,

My misses is

MISS_RATE
-
0.68%

Is that good or bad, Oracle 8.0.5 Standard Edition, Windows 2000.

Is there a 8.1.7 Standard Edition Version ?

Ramon Estevez
[EMAIL PROTECTED]


---

Christopher
Thanks. This script ran from 7.3.4 to 8.1.6 with following result...
I hope misses less than 1% is not bad...Any comment

SQL> select to_char(100 * misses / (logical - physical + misses), '9990.00')
||
  2  '%' miss_rate
  3from ( select total_waits  misses
  4from sys.v_$system_event
  5   where event = 'db file sequential read'),
  6 ( select value  physical
  7 from sys.v_$sysstat
  8where name = 'physical reads'),
  9 ( select sum(value)  logical
10 from sys.v_$sysstat
11where name like '%consistent read gets'
12   or name = 'db block gets');

MISS_RATE
-
0.90%

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 12:23:02 -0800

I assume you have 8.1.7, since 8.1.7 they changed things back to how it was
done in 7.3.4.

This script works for 7.3.4 and 8.1.7/9.0.1

select to_char(100 * misses / (logical - physical + misses), '9990.00') ||
'%' miss_rate
   from ( select total_waits  misses
   from sys.v_$system_event
  where event = 'db file sequential read'),
( select value  physical
from sys.v_$sysstat
   where name = 'physical reads'),
( select sum(value)  logical
from sys.v_$sysstat
   where name like '%consistent read gets'
  or name = 'db block gets');


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Ran this query under 8i(HP-UX 11)


SQL> show user
USER is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
   2from ( select total_waits  misses
   3from sys.v_$system_event
   4  where event = 'db file sequential read' ),
   5   ( select sum(dbbget + conget - pread)  hits
   6   from sys.x_$kcbwds
   7 where inst_id = userenv('Instance') )
   8  /
  from sys.x_$kcbwds
   *
ERROR at line 6:
ORA-00942: table or view does not exist

Under 7.3.4.5 (HP-UX 10.20)
SQL> show user
user is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
   2from ( select total_waits  misses
   3from sys.v_$system_event
   4  where event = 'db file sequential read' ),
   5   ( select sum(dbbget + conget - pread)  hits
   6   from sys.x_$kcbwds
   7 where inst_id = userenv('Instance') )
   8  /

where inst_id = userenv('Instance') )
*
ERROR at line 7:
ORA-02003: invalid USERENV parameter

So what is wrong?
Regards



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 10:13:51 -0800

Try this more accurate query:

select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  miss_rate
from ( select total_waits  misses
from sys.v_$system_event
  where event = 'db file sequential read' ),
   ( select sum(dbbget + conget - pread)  hits
   from sys.x_$kcbwds
 where inst_id = userenv('Instance') )
/

Also, send the actual values if this query still leads to similar results.

The difference here is it takes in account of direct writes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache
hit
ratio"
4   FROM   v$sysstat a;

buffer cache hit ratio
--
   -52.99284

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

Fat City Network Services-- (858) 538-5051  FAX: 

Re: sqlloader stops

[Yosi Greenfield]

Silly ol' me. Are you out of space in your archive log destination?

This is like a guessing game. :-)


[EMAIL PROTECTED] wrote:

> Hi List,
> I have another problem.
> I have a process that loads multiple (~ 20 ) files through sqlloader.  It
> works fine on other servers.  There is this one server that is giving me a
> hard time.  It loads 3 files and then stops.  I commented out the third call
> to sqlloader thinking may be there is something wrong with a third text
> file.  It loaded 3 files again and stopped on the forth one.
> There is nothing in alert log (no errors).  Also, there is enough space on
> the drive where the logs are going.
> Oracle 7.3.4 on NT.
> If anyone has any idea please let me know...
>
> Lyuda Hoska
> (703)797-8656

-- 
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: Optimizer Mode......how to choose the right one?

[Veronica Levin]

what would you do with an application that has 3 GB of data and 6 GB of
indexes
developers keep telling me that they can't get rid of any index because they
use them all. how can I prove wich indexes are never used??

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: Christian Trassens [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 01:26 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Optimizer Mode..how to choose the right one?


NEVER change an optimizer since the application have
some time working with it. I should leave it in CHOOSE
and then analyze what are doing the transactions.

Look up the worst events through v$system_Event or
from time to time through v$session_wait. Issue an
utlbstat/utlestat or statspack. Then when you know
which is the worst wait. Maybe "db file scattered
read" or most of the times "enqueue" or "latch free"
and sometimes a huge amount of "db file sequential
read" because of bad indexes. 

Look up the indexes. Doing that consider their
clustering_factor, their blevel and the most important
thing their selectivity. ETC.


--- Veronica Levin <[EMAIL PROTECTED]> wrote:
> Morning listers!
> 
> I am having performance problems with this database,
> transactions ar running
> very slow and I am not sure if I have choose the
> right optimizer mode... 
> 
> AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real
> Memory, 
> 500 MB SGA, 70 concurrent users, mostly OLTP
> transactions.
> 
> I have tunned init parameters the best I can we the
> resources I have:
> 
> db_files = 70
> db_writers = 4
> db_file_multiblock_read_count = 16
> db_block_buffers = 57600
> db_block_size = 8192
> shared_pool_size = 157286400
> processes = 200
> dml_locks = 1500
> log_buffer = 655360
> sequence_cache_entries = 800
> sequence_cache_hash_buckets = 89
> log_checkpoint_interval = 8
> optimizer_mode=CHOOSE
> session_cached_cursors =  300
> sort_area_size=1048576
> hash_area_size=262144
> hash_multiblock_io_count=4
> hash_join_enabled=TRUE
> always_anti_join=HASH
> job_queue_processes=8
> 
> 35 rollback segments, inital 1MB, next 1MB, optimal
> 30 MB
> 8 multiplexed redologs, 30 MB each
> 
> I tried FIRST_ROWS, analyzing the tables, but users
> claimed that performance
> was getting worse, so I chaged it to Choose. Always
> analyzing the tables
> 
> but, everytime I analyze the tables, performance
> gets worse.
> Is this a normal behavior?
> 
> Any advice will be welcome!
> 
> thanks is advance,
> 
> Saludos, 
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: Veronica Levin
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Mohammad Rafiq]

Christopher
Thanks. This script ran from 7.3.4 to 8.1.6 with following result...
I hope misses less than 1% is not bad...Any comment

SQL> select to_char(100 * misses / (logical - physical + misses), '9990.00') 
||
  2  '%' miss_rate
  3from ( select total_waits  misses
  4from sys.v_$system_event
  5   where event = 'db file sequential read'),
  6 ( select value  physical
  7 from sys.v_$sysstat
  8where name = 'physical reads'),
  9 ( select sum(value)  logical
10 from sys.v_$sysstat
11where name like '%consistent read gets'
12   or name = 'db block gets');

MISS_RATE
-
0.90%

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 12:23:02 -0800

I assume you have 8.1.7, since 8.1.7 they changed things back to how it was
done in 7.3.4.

This script works for 7.3.4 and 8.1.7/9.0.1

select to_char(100 * misses / (logical - physical + misses), '9990.00') ||
'%' miss_rate
   from ( select total_waits  misses
   from sys.v_$system_event
  where event = 'db file sequential read'),
( select value  physical
from sys.v_$sysstat
   where name = 'physical reads'),
( select sum(value)  logical
from sys.v_$sysstat
   where name like '%consistent read gets'
  or name = 'db block gets');


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Ran this query under 8i(HP-UX 11)


SQL> show user
USER is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
   2from ( select total_waits  misses
   3from sys.v_$system_event
   4  where event = 'db file sequential read' ),
   5   ( select sum(dbbget + conget - pread)  hits
   6   from sys.x_$kcbwds
   7 where inst_id = userenv('Instance') )
   8  /
  from sys.x_$kcbwds
   *
ERROR at line 6:
ORA-00942: table or view does not exist

Under 7.3.4.5 (HP-UX 10.20)
SQL> show user
user is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
   2from ( select total_waits  misses
   3from sys.v_$system_event
   4  where event = 'db file sequential read' ),
   5   ( select sum(dbbget + conget - pread)  hits
   6   from sys.x_$kcbwds
   7 where inst_id = userenv('Instance') )
   8  /

where inst_id = userenv('Instance') )
*
ERROR at line 7:
ORA-02003: invalid USERENV parameter

So what is wrong?
Regards



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 10:13:51 -0800

Try this more accurate query:

select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  miss_rate
from ( select total_waits  misses
from sys.v_$system_event
  where event = 'db file sequential read' ),
   ( select sum(dbbget + conget - pread)  hits
   from sys.x_$kcbwds
 where inst_id = userenv('Instance') )
/

Also, send the actual values if this query still leads to similar results.

The difference here is it takes in account of direct writes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache
hit
ratio"
4   FROM   v$sysstat a;

buffer cache hit ratio
--
   -52.99284

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

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

To REMOVE yourself from this mailing list, se

How to determine checkpoint rate?

[Post, Ethan]

I am trying to locate a stat that is incremented every time a checkpoint
occurs.  I see a few checkpoint related stats in V$SYSTAT but none seem high
enough to match the number of checkpoints that have occurred as a result of
log switches, log checkpoint timeouts.  Am I mistaken on this?  Is there
somewhere I can determine the total number of checkpoints that have occurred
since system startup?

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

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

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

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

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

RE: sqlloader stops

[lhoska]

My impression is the ERRORS parameter is set for each single load not number
of loads.
No, there is no bad file.  Thanks David.

-Original Message-
Sent: Tuesday, August 07, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Just a stab here...

Check the .bad files to see if you are getting any data rows kicked out due
to errors.  If so, you might be exceeding the ERRORS parameter by the time
you finish the third file.

HTH.

David Wagoner
DBA


-Original Message-
Sent: Tuesday, August 07, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L

Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.  It
works fine on other servers.  There is this one server that is giving me a
hard time.  It loads 3 files and then stops.  I commented out the third call
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know... 

Lyuda Hoska
(703)797-8656

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

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

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

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

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

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

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

Re: negative value for buffer cache hit ratio

[K Gopalakrishnan]

Welcome Jonathan,

I think most of the counter are limited by ub4maxval
and that makes the negative hit ratio.

Welcome again !


--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
> 
> It is possible that after 4 months your stats
> have wrapped around the ( ? 64 bit ?) limit
> value for your platform.  Check the actual
> values from v$sysstat to see if some of them
> have gone negative or appear to be
> 'counting backwards'.
> 



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: sqlloader stops

[David Wagoner]

Just a stab here...

Check the .bad files to see if you are getting any data rows kicked out due
to errors.  If so, you might be exceeding the ERRORS parameter by the time
you finish the third file.

HTH.

David Wagoner
DBA


-Original Message-
Sent: Tuesday, August 07, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L

Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.  It
works fine on other servers.  There is this one server that is giving me a
hard time.  It loads 3 files and then stops.  I commented out the third call
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know... 

Lyuda Hoska
(703)797-8656

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: free up datafile space problem ???

[DBarbour]

Janet,

You can only reduce the datafile by the amount of contiguous free space at
the end of the datafile.  Back up your DB before you try any of this.  I
never play with tablespace and datafiles without a current backup.  Use
alter tablespace coalesce, then query dba_free_space, dba_data_files and
dba_segments to see how much reduction you can get.  If you've got a bunch
of free space sandwiched in between used space, you're going to have to do
an export/import to reorg the tablespace and significantly reduce the
datafile size(s).

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Janet Linsy
   
  
hoo.com> cc:   
   
Sent by: Subject: free up datafile space problem 
???  
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
08/07/2001 
   
01:40 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Hi all,

I have a data file of 2G and the free bytes is
1,413,079, the used bytes is only 683,829.  I like to
resize it.  When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value


But apparently, the file does NOT contain data beyond
1000M.  Am I missing something?

Thank you.

Janet

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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




-- 
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: negative value for buffer cache hit ratio

[Christopher Spence]

I assume you have 8.1.7, since 8.1.7 they changed things back to how it was
done in 7.3.4.

This script works for 7.3.4 and 8.1.7/9.0.1

select to_char(100 * misses / (logical - physical + misses), '9990.00') ||
'%' miss_rate
  from ( select total_waits  misses
  from sys.v_$system_event
 where event = 'db file sequential read'),
   ( select value  physical
   from sys.v_$sysstat
  where name = 'physical reads'),
   ( select sum(value)  logical
   from sys.v_$sysstat
  where name like '%consistent read gets' 
 or name = 'db block gets');


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Ran this query under 8i(HP-UX 11)


SQL> show user
USER is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
  2from ( select total_waits  misses
  3from sys.v_$system_event
  4  where event = 'db file sequential read' ),
  5   ( select sum(dbbget + conget - pread)  hits
  6   from sys.x_$kcbwds
  7 where inst_id = userenv('Instance') )
  8  /
 from sys.x_$kcbwds
  *
ERROR at line 6:
ORA-00942: table or view does not exist

Under 7.3.4.5 (HP-UX 10.20)
SQL> show user
user is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
  2from ( select total_waits  misses
  3from sys.v_$system_event
  4  where event = 'db file sequential read' ),
  5   ( select sum(dbbget + conget - pread)  hits
  6   from sys.x_$kcbwds
  7 where inst_id = userenv('Instance') )
  8  /

   where inst_id = userenv('Instance') )
   *
ERROR at line 7:
ORA-02003: invalid USERENV parameter

So what is wrong?
Regards



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 10:13:51 -0800

Try this more accurate query:

select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  miss_rate
   from ( select total_waits  misses
   from sys.v_$system_event
 where event = 'db file sequential read' ),
  ( select sum(dbbget + conget - pread)  hits
  from sys.x_$kcbwds
where inst_id = userenv('Instance') )
/

Also, send the actual values if this query still leads to similar results.

The difference here is it takes in account of direct writes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
   2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
   3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache 
hit
ratio"
   4   FROM   v$sysstat a;

buffer cache hit ratio
--
  -52.99284

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

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

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

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

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

RE: Over seas online demo

[Jenkins, Michael]

Yes, NetMeeting can be used for that purpose.  Some of the Oracle Education
sites use it for classwork exercises.

--Michael

-Original Message-
Sent: Tuesday, August 07, 2001 3:43 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Was wondering if anyone knows of any software (bedsides pcanywhere
or
Citrix) that could be used to give a demo to a company across the ocean.   I
know I have seen it before, we went to a url to see a demo, I want to say it
was ms netmeeting but I don't think that is right.  any help would be
greatly appreciated.

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: PARTITION attache to SYNONYM

[Jonathan Lewis]

Which version of Oracle ?
I got a 600 error when trying to create a partition
when using a public synonym instead of the
table_name on 8.1.7.0

Have a look in dba_segments for segment_name  = 'your table name'
and segment_name = 'your synonym', check especially the OWNER
in case something very strange has happened.


Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 19:57


|Hi All,
| Wondering if anyone has seen anything like this. I have
|filed a TAR.
|
| When adding next month's partition to a table a synonym was
| used accidently. However, the partition was created and shows
| up  in dba_tab_partitions. However, I cannot modify of drop the
| partition.
|
| ALTER TABLE synonym_name drop PARTITION partition_name;
| returns no such table
|
| ALTER TABLE table_name drop PARTITION partition_name;
| returns no such partition.
|
| I have built another structure to hold the data but does anyone
| know the consequences if I dorp the ysnonym.
|
|TIA
|Dave
|
|
|--
|Dave Morgan
|DBA, Cybersurf
|Office: 403 777 2000 ext 284
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Dave Morgan
|  INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing
Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be 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: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Over seas online demo

[Daniel Curry]

VNC is a useful, free, yet insecure option.

Another would be Dameware (www.dameware.com).  I use Dameware in the
office and in my home.  The price is reasonable, it is considerably more
secure, and will install the remote agent on the server as a service,
provided you give it the right login information.  A very nice tool for
Windows remote display.  

If you are using a Win2000 server as the host, a simpler measure would
be to use MS Terminal Services.

I hope you find this information helpful.

Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889

 -Original Message-
Sent:   Tuesday, August 07, 2001 12:43 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: Over seas online demo

Hi all,
Was wondering if anyone knows of any software (bedsides
pcanywhere or
Citrix) that could be used to give a demo to a company across the ocean.
I
know I have seen it before, we went to a url to see a demo, I want to
say it
was ms netmeeting but I don't think that is right.  any help would be
greatly appreciated.

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

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

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

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


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Jonathan Lewis]

It is possible that after 4 months your stats
have wrapped around the ( ? 64 bit ?) limit
value for your platform.  Check the actual
values from v$sysstat to see if some of them
have gone negative or appear to be
'counting backwards'.


Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 19:52


|
|Dear gurus !
|I have a negative value for buffer cache hit ratio in my DB which is
up for
|some 4 months .
|Any ideas why ?
|Thanks in advance.
|
|SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
|  2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
|  3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer
cache hit
|ratio"
|  4   FROM   v$sysstat a;
|
|buffer cache hit ratio
|--
| -52.99284
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Andrey Bronfin
|  INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing
Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be 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: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 stop a killed session bothering me ?

[Christian Trassens]

Yes upon startup. When you kill and the session
doesn't leave their locks and changes its serial# as a
few of its symptons, PMON take charge.
--- "A. Bardeen" <[EMAIL PROTECTED]> wrote:
> Jim,
> 
> No, since 7.3 SMON does the rollback in the
> background
> upon startup.  If a user session attempts to access
> a
> row that is part of an uncommitted transaction  that
> needs rolling back then that user session will take
> over the rollback of that transaction.
> 
> HTH,
> 
> -- Anita
> 
> --- "HAWKINS, JAMES W [IT/1000]"
> <[EMAIL PROTECTED]> wrote:
> > If you did a "shutdown abort", wouldn't you still
> > have to wait for the
> > rollback to happen during instance recovery on the
> > startup?  I've never
> > tried this - I usually just suffer through the
> > rollback.
> > 
> > Jim
> > 
> > __
> > Jim Hawkins
> > Oracle Database Administrator
> > Data Management Center of Expertise
> > 
> > Pharmacia Corporation
> > 800 North Lindbergh Blvd.
> > St. Louis, Missouri  63167
> > (314) 694-4417
> > 
> > [EMAIL PROTECTED]
> > 
> > 
> > -Original Message-
> > Sent: Tuesday, August 07, 2001 8:21 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > You should wait for PMON ending its job of
> rollback
> > the transaction of that killed session. Since one
> of
> > the releases of 8i that duty is a new one for the
> > SMON. 
> > 
> > You have few options. If you are in a hurry, you
> > could
> > do shutdown abort. First issue an alter system
> > checkpoint; just in case a maybe possible recover
> > problem later. You see that it is a little risky.
> > With
> > a shutdown immediate, you might wait a lot. Even
> > that
> > you could afford it because of the dangerous of
> the
> > abort option. The other is to issue through
> svrmgrl
> > or
> > sqlplus depending on the release an 
> > 
> > oradebug wakeup  on
> > the release>
> > 
> > However there is a little chance that with this
> you
> > could hurry the PMON for the rollback of the
> > transaction.
> > 
> > You can see how much work the PMON or SMON have to
> > do
> > through v$transaction:
> > 
> > select b.sid,a.used_ublk from v$transaction
> > a,v$session b
> > where addr=taddr and b.status='KILLED';
> > 
> > 
> > Regards.
> > 
> > 
> > --- Andrey Bronfin <[EMAIL PROTECTED]>
> > wrote:
> > > Dear all !
> > > I have killed a session while it was populating
> a
> > > big table.
> > > Now the session is marked KILLED in v$session.
> > > It's serial# is keeping being incremented , so i
> > > assume that a rollback (of
> > > rows inserted into that big table by that
> session)
> > > is going on there in the
> > > background.
> > > This rollback runs for several hours already
> > > preventing me from DMLing that
> > > big table.
> > > Is there a way to stop that rollback / drop /
> > > truncate that table ?
> > > Thanks a lot in advance .
> > > Andrey.
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > -- 
> > > Author: Andrey Bronfin
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- (858) 538-5051 
> > FAX:
> > > (858) 538-5051
> > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > >
> >
>

> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (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!?
> > Make international calls for as low as $.04/minute
> > with Yahoo! Messenger
> > http://phonecard.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: HAWKINS, JAMES W [IT/1000]
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-

Re: Precise

[Stefan Moeding]

Hi!

O'Neill, Sean writes:

> Is no-one on this list using Precise SQL or Precise Pulse?.  Has anyone
> "heard" of them or evaluated them?.

We are using Precise/SQL for over a year now.  I like the ability to
find any correlation between a statement, the calling users, the calling
sessions, the host user or machine, the program used and the resources
consumed (CPU, I/Os on different data files, locks, ...).  It also
includes a performance warehouse which keeps instance statistics and
a history for schema changes. It is also possible to keep execution
plans in the warehouse and monitor changes over time, but we haven't
set this up yet.

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

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

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

sqlloader stops

[lhoska]

Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.  It
works fine on other servers.  There is this one server that is giving me a
hard time.  It loads 3 files and then stops.  I commented out the third call
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know...  

Lyuda Hoska
(703)797-8656

-- 
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: OT: Over seas online demo

[Rodd Holman]

Kevin,
Try VNC.  It works across multiple platforms and has a web interface.

http://www.uk.research.att.com/vnc/index.html

On 07 Aug 2001 11:43:20 -0800, Kevin Kostyszyn wrote:
> Hi all,
>   Was wondering if anyone knows of any software (bedsides pcanywhere or
> Citrix) that could be used to give a demo to a company across the ocean.   I
> know I have seen it before, we went to a url to see a demo, I want to say it
> was ms netmeeting but I don't think that is right.  any help would be
> greatly appreciated.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: free up datafile space problem ???

[Glenn Travis]

I just sent this to the other list...

Here is a quick script to list the tablespace/datafiles and their higwater
marks, as well as generate the resize commands;

--begin script
col blksz new_value blksz noprint;
col tablespace_name for a20 heading "Tablespace|Name";
col file_name for a50 heading "File|Name";
col file_id for 999 heading "File|Id";
col file_size for 999,999.99 heading "File|Size MB";
col file_hw for 999,999.99 heading "HighWater|Size MB";
set linesize 132;
set verify off;

select value blksz from v$parameter where lower(name) = 'db_block_size';
select a.tablespace_name, b.file_name, b.file_id, b.bytes/1024/1024
file_size,
((c.max_blockid+a.blocks) * &blksz)/1024/1024 file_hw
from dba_extents a, dba_data_files b ,
(select file_id, max(block_id) max_blockid from dba_extents group by
file_id) c
where a.file_id=b.file_id
and a.file_id=c.file_id
and a.block_id = c.max_blockid
order by 1,2;

-- Create resize file
prompt Listing resize commands...
prompt

set pagesize 0;
select 'alter database datafile '||||b.file_name||||' resize
'||round(((c.max_blockid+a.blocks) * &blksz)/1024/1024)||'M ;'
from dba_extents a, dba_data_files b ,
(select file_id, max(block_id) max_blockid from dba_extents group by
file_id) c
where a.file_id=b.file_id
and a.file_id=c.file_id
and a.block_id = c.max_blockid;

quit
--end script

-Original Message-
Sent: Tuesday, August 07, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I have a data file of 2G and the free bytes is
1,413,079, the used bytes is only 683,829.  I like to
resize it.  When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value


But apparently, the file does NOT contain data beyond
1000M.  Am I missing something?

Thank you.

Janet

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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

-- 
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: negative value for buffer cache hit ratio

[K Gopalakrishnan]

Nothing is wrong in your database.

You don't have the required X_$ views created. Change
X_$ to X$ or create X_$ views as select * from X$
views.





=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Code Red

[Kevin Kostyszyn]

Thanks!
KK

-Original Message-
Patrice J
Sent: Tuesday, August 07, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


http://tds.diamondcs.com.au/html/intro.htm


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 07, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Code Red

Patrice,
I have a friend downstairs who said I should use Fprot to
get rid of this
rogue web page, I am going to download it now.  I am interested in
this
TDS-3 program, can I get that at downloads.com or is it somewhere
else?
KK

-Original Message-
Patrice J
Sent: Tuesday, August 07, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


Update your virus checking software.  Patch your software and your
OS as far
as you can.  Re. NT use PatchWork as well (
http://grc.com/pw/patchwork.htm
  ), it catches things the
Microsoft
Windows Update seems to overlook.

You may want to get a trojan detector like tds-3 to catch trojans
like
CodeRed II.  There are many trojan detectors posted on the 'net.
Beware of
free ones. Stay clear of anything on servers in countries that do
not
recognize copyright laws, or who might be actively financing
hackers!
Sounds obvious but sometimes people don't think about this when they
are
following links on the Web.  Look at where a link leads (bottom
status bar
if using IE) before you click.

You also need something that is current.  Anything that hasn't been
updated
in the last year is probably useless.

It seems to me that now we need:

A virus / worm checker
A trojan horse detector
A firewall.

Only one component missing, and you could be in trouble.

The trouble with code red was that it went through port 80, which is
left
open by firewalls because that is the port used for HTTP pages
(WWW).
Closing that would mean no one could access Web pages.  So firewalls
won't
help you re. things like that.  You can now go through any ports
that are
left open, and there is software out there to detect ports that were
left
open.

Life is getting complicated!

For trojan detection I like TDS-3 because with some plug-ins, you
can send a
message right back to the people who are probing your system using a
trojan.
TDS-3 also scans all the processes running in memory, and it comes
with
interesting process descriptions for some of those obscure NT
services.
This is from first glance, I am running the shareware version at
home.  I
have a month to make up my mind and pay up...

For home, ZoneAlarm (firewall) is free.  I like it because it tells
you when
programs are trying to access your machine via ports going in, or
out.  So
if a program on your machine wants to access the 'net, you can see
which
program is trying to do that and you can decide whether to let it do
that or
not.  Sometimes it's hard to decide, though, e.g. distributed COM -
should I
let that thing send info out of my computer to the 'net?  It's a
built-in
component of Windows, but I don't know.  (btw the author says he
programs
only in assembly language)

Re. virus checking F-Prot has a shareware version, that's free as
long as
you don't mind re-installing it now and again.  I am probably going
to buy
it eventually.  I don't know how to compare the effectiveness of
these,
though.  Some are more popular out there but to my mind it doesn't
mean that
they are ideal, esp. when marketing and mass advertising through the
media
is involved.  I haven't seen any honest reviews of virus checking
software,
I don't know where to look.

I set up ZoneAlarm and TDS-3 on my machine at home and was surprised
to see
what is going on.  With ZoneAlarm you can get the owner for a
particular IP
range, so you can see who is trying to ping or intrude on your
machine.  A
colleague here says he is on cable modem, and that is even worse
than DSL in
terms of hacking activity, he showed me a log where he was a target
every
ten minutes on average for a prolonged period of time.  He uses
BlackIce
Defender.  Korean and university servers are the most common that I
see in
use as launchpads.  It doesn't mean that's where the probes and that
attacks
are coming from though.  T1, Cable and DSL users are most at risk,
but
dial-up clients are vulnerable as well as long as they remain
connected.  I
   

RE: computer history stories - Now: Age discrimination?

[Eric D. Pierce]

[via oracle-l digest]
--

> From: Henry Poras <[EMAIL PROTECTED]>
> Date: Mon, 6 Aug 2001 15:44:26 -0400 
> Subject: RE: computer history stories - Now: Age discrimination?

...
> E are you out there?

A lot of people seem to think so!

ep

didn't some famous person such as Mae West say
"you can lead a horse to water,
but not a horticulture." ???


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: computer history stories - Now: Age discrimination?

[Eric D. Pierce]

[via oracle-l digest] 
--

> From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> Date: Mon, 06 Aug 2001 18:22:47 +
> Subject: RE: computer history stories - Now: Age discrimination?

> ... My IQ is not low, yet I CANNOT
> for the life of me learn physics 

That is because you don't hate the humanities, or at least 
not enough. :)

> or data communications. 

You need a wearable computer to do that.

ep

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: computer history stories - Now: Age discrimination?

[Chaim . Katz]

With reference to the postings about quick learning and all that, I remembered a
story: There was a Talmudist - no job and no money. His wife confronted him. It
bothered her that she alone was worrying about their situation and he didn't
seem concerned at all. "Not true", he says, "I just worry faster than you. What
you worry in a day, I worry in a few seconds."

Chaim


-- 
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: Installing Oracle 9i

[Page, Bruce]

Have at least that if you are creating the database during your install.  Otherwise 
you will be switching logs real quick.  You might change it back after the initial 
database creation though.


> -Original Message-
> From: Eca Eca [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 1:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Installing Oracle 9i
> 
> 
> 
> Friends :
> 
> I am installing the database Oracle 9i.
> And it have suggested a parameter value 100mb for redo log file.
> 
> I am confused with this value, i think it is too big.
> 
> The blocksize is 8192
> Connections simultaneous is 100
> 
> Where am I doing any mistake ?
> 
> 
> Eriovaldo
> [EMAIL PROTECTED]
> 
> 
> _
> Seja avisado de novas mensagens do Hotmail e use o 
> comunique-se com seus 
> amigos com o MSN Messenger em http://messenger.msn.com.br
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Eca Eca
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Page, Bruce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 stop a killed session bothering me ?

[Christopher Spence]

Doing a shutdown abort is hardly dangerous.

Granted, it is not as clean as shutdown normal or shutdown abort, but it is
not dangerous.

All it does is severe the connections.  When the instance comes up, it goes
through and starts rolling back looking through rbs and redo logs.

I look at shutdown abort lightly, I perfer not to do it and I avoid it, but
if I need to do it, I do it without hesitation and without concern I am in
danger.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 9:21 AM
To: Multiple recipients of list ORACLE-L


You should wait for PMON ending its job of rollback
the transaction of that killed session. Since one of
the releases of 8i that duty is a new one for the
SMON. 

You have few options. If you are in a hurry, you could
do shutdown abort. First issue an alter system
checkpoint; just in case a maybe possible recover
problem later. You see that it is a little risky. With
a shutdown immediate, you might wait a lot. Even that
you could afford it because of the dangerous of the
abort option. The other is to issue through svrmgrl or
sqlplus depending on the release an 

oradebug wakeup 

However there is a little chance that with this you
could hurry the PMON for the rollback of the
transaction.

You can see how much work the PMON or SMON have to do
through v$transaction:

select b.sid,a.used_ublk from v$transaction
a,v$session b
where addr=taddr and b.status='KILLED';


Regards.


--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> Dear all !
> I have killed a session while it was populating a
> big table.
> Now the session is marked KILLED in v$session.
> It's serial# is keeping being incremented , so i
> assume that a rollback (of
> rows inserted into that big table by that session)
> is going on there in the
> background.
> This rollback runs for several hours already
> preventing me from DMLing that
> big table.
> Is there a way to stop that rollback / drop /
> truncate that table ?
> Thanks a lot in advance .
> Andrey.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

OT: Over seas online demo

[Kevin Kostyszyn]

Hi all,
Was wondering if anyone knows of any software (bedsides pcanywhere or
Citrix) that could be used to give a demo to a company across the ocean.   I
know I have seen it before, we went to a url to see a demo, I want to say it
was ms netmeeting but I don't think that is right.  any help would be
greatly appreciated.

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

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

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

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

RE: Code Red

[Boivin, Patrice J]

http://tds.diamondcs.com.au/html/intro.htm
 

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 07, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Code Red

Patrice,
I have a friend downstairs who said I should use Fprot to
get rid of this
rogue web page, I am going to download it now.  I am interested in
this
TDS-3 program, can I get that at downloads.com or is it somewhere
else?
KK

-Original Message-
Patrice J
Sent: Tuesday, August 07, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


Update your virus checking software.  Patch your software and your
OS as far
as you can.  Re. NT use PatchWork as well (
http://grc.com/pw/patchwork.htm
  ), it catches things the
Microsoft
Windows Update seems to overlook.

You may want to get a trojan detector like tds-3 to catch trojans
like
CodeRed II.  There are many trojan detectors posted on the 'net.
Beware of
free ones. Stay clear of anything on servers in countries that do
not
recognize copyright laws, or who might be actively financing
hackers!
Sounds obvious but sometimes people don't think about this when they
are
following links on the Web.  Look at where a link leads (bottom
status bar
if using IE) before you click.

You also need something that is current.  Anything that hasn't been
updated
in the last year is probably useless.

It seems to me that now we need:

A virus / worm checker
A trojan horse detector
A firewall.

Only one component missing, and you could be in trouble.

The trouble with code red was that it went through port 80, which is
left
open by firewalls because that is the port used for HTTP pages
(WWW).
Closing that would mean no one could access Web pages.  So firewalls
won't
help you re. things like that.  You can now go through any ports
that are
left open, and there is software out there to detect ports that were
left
open.

Life is getting complicated!

For trojan detection I like TDS-3 because with some plug-ins, you
can send a
message right back to the people who are probing your system using a
trojan.
TDS-3 also scans all the processes running in memory, and it comes
with
interesting process descriptions for some of those obscure NT
services.
This is from first glance, I am running the shareware version at
home.  I
have a month to make up my mind and pay up...

For home, ZoneAlarm (firewall) is free.  I like it because it tells
you when
programs are trying to access your machine via ports going in, or
out.  So
if a program on your machine wants to access the 'net, you can see
which
program is trying to do that and you can decide whether to let it do
that or
not.  Sometimes it's hard to decide, though, e.g. distributed COM -
should I
let that thing send info out of my computer to the 'net?  It's a
built-in
component of Windows, but I don't know.  (btw the author says he
programs
only in assembly language)

Re. virus checking F-Prot has a shareware version, that's free as
long as
you don't mind re-installing it now and again.  I am probably going
to buy
it eventually.  I don't know how to compare the effectiveness of
these,
though.  Some are more popular out there but to my mind it doesn't
mean that
they are ideal, esp. when marketing and mass advertising through the
media
is involved.  I haven't seen any honest reviews of virus checking
software,
I don't know where to look.

I set up ZoneAlarm and TDS-3 on my machine at home and was surprised
to see
what is going on.  With ZoneAlarm you can get the owner for a
particular IP
range, so you can see who is trying to ping or intrude on your
machine.  A
colleague here says he is on cable modem, and that is even worse
than DSL in
terms of hacking activity, he showed me a log where he was a target
every
ten minutes on average for a prolonged period of time.  He uses
BlackIce
Defender.  Korean and university servers are the most common that I
see in
use as launchpads.  It doesn't mean that's where the probes and that
attacks
are coming from though.  T1, Cable and DSL users are most at risk,
but
dial-up clients are vulnerable as well as long as they remain
connected.  I
sent e-mails to some ISPs to complain, but they don't appear to care
what
people are doing with their net connections, it

Re: free up datafile space problem ???

[Ron Rogers]

Janet,
 Possibly there were other tables in the tablespace using space in the datafile and 
then some tables were deleted leaving the tablespace fragmented. To completely clean 
the tablespace and free the space you have to export the contents of the tablespace( 
all tables), drop the tables, coalesce the tablespace, then recreate the tables, 
import the data and check the grants on the tables, Your tablespace should be 
contiguous and allow you to shrink the datafile to a smaller space. 
ROR mª¿ªm
>>> [EMAIL PROTECTED] 08/07/01 02:40PM >>>
Hi all,

I have a data file of 2G and the free bytes is 
1,413,079, the used bytes is only 683,829.  I like to
resize it.  When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value


But apparently, the file does NOT contain data beyond
1000M.  Am I missing something?

Thank you.

Janet

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED] 

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Srini . Chavali]

Kirti, Audrey,
I was under the impression that negative numbers are caused by the numbers
wrapping around i.e., the database has been up for a while and the
statistics pile up and eventually exceed the defined format (e.g. value of
1000+ for a format of 9(3) - to use old COBOL representation !). Makes
sense ?
I have seen his before. If you bounce the database, all will be well !
Srini Chavali
Oracle DBA
Cummins Inc




"Deshpande, Kirti" <[EMAIL PROTECTED]>@fatcity.com on 08/07/2001
01:13:52 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Andrey,
 I am not into cache hit ratios, but got curious about your negative value.

 So I casually searched Metalink for 'negative value for hit ratio'. And
got
a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread.
You may want to check it out, there seems to be a new formula for hit ratio
computation in 8i/9i.

HTH,

Regards,

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

> -Original Message-
> From:   Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
> Sent:   Tuesday, August 07, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: negative value for buffer cache hit ratio
>
>
> Dear gurus !
> I have a negative value for buffer cache hit ratio in my DB which is up
> for
> some 4 months .
> Any ideas why ?
> Thanks in advance.
>
> SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
>   2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
>   3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache
> hit
> ratio"
>   4   FROM   v$sysstat a;
>
> buffer cache hit ratio
> --
>  -52.99284
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: computer history stories - Now: Age discrimination?

[Eric D. Pierce]

[via oracle-l digest] 

--

 From: "Farnsworth, Dave" <[EMAIL PROTECTED]>
 Date: Mon, 6 Aug 2001 13:01:42 -0500 
 Subject: RE: computer history stories - Now: Age discrimination?

>  Most people have a nerd stigma when thry think about physicists,
> but as a group, physicists are some of the more humble and nice
> group of people who tend to have a great love for their work.  

Just be careful with them, they all secretly, sometimes overtly, 
hate the humanities.

regards,
ep
(former fertilizer salesman who got an honorary
Ph.Dirt for being out standing in my field one day)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Mohammad Rafiq]

Ran this query under 8i(HP-UX 11)


SQL> show user
USER is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  
miss_rate
  2from ( select total_waits  misses
  3from sys.v_$system_event
  4  where event = 'db file sequential read' ),
  5   ( select sum(dbbget + conget - pread)  hits
  6   from sys.x_$kcbwds
  7 where inst_id = userenv('Instance') )
  8  /
 from sys.x_$kcbwds
  *
ERROR at line 6:
ORA-00942: table or view does not exist

Under 7.3.4.5 (HP-UX 10.20)
SQL> show user
user is "SYS"
SQL> select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  
miss_rate
  2from ( select total_waits  misses
  3from sys.v_$system_event
  4  where event = 'db file sequential read' ),
  5   ( select sum(dbbget + conget - pread)  hits
  6   from sys.x_$kcbwds
  7 where inst_id = userenv('Instance') )
  8  /

   where inst_id = userenv('Instance') )
   *
ERROR at line 7:
ORA-02003: invalid USERENV parameter

So what is wrong?
Regards



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 10:13:51 -0800

Try this more accurate query:

select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  miss_rate
   from ( select total_waits  misses
   from sys.v_$system_event
 where event = 'db file sequential read' ),
  ( select sum(dbbget + conget - pread)  hits
  from sys.x_$kcbwds
where inst_id = userenv('Instance') )
/

Also, send the actual values if this query still leads to similar results.

The difference here is it takes in account of direct writes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
   2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
   3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache 
hit
ratio"
   4   FROM   v$sysstat a;

buffer cache hit ratio
--
  -52.99284

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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/intl.asp

-- 
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: Optimizer Mode......how to choose the right one?

[Christian Trassens]

NEVER change an optimizer since the application have
some time working with it. I should leave it in CHOOSE
and then analyze what are doing the transactions.

Look up the worst events through v$system_Event or
from time to time through v$session_wait. Issue an
utlbstat/utlestat or statspack. Then when you know
which is the worst wait. Maybe "db file scattered
read" or most of the times "enqueue" or "latch free"
and sometimes a huge amount of "db file sequential
read" because of bad indexes. 

Look up the indexes. Doing that consider their
clustering_factor, their blevel and the most important
thing their selectivity. ETC.


--- Veronica Levin <[EMAIL PROTECTED]> wrote:
> Morning listers!
> 
> I am having performance problems with this database,
> transactions ar running
> very slow and I am not sure if I have choose the
> right optimizer mode... 
> 
> AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real
> Memory, 
> 500 MB SGA, 70 concurrent users, mostly OLTP
> transactions.
> 
> I have tunned init parameters the best I can we the
> resources I have:
> 
> db_files = 70
> db_writers = 4
> db_file_multiblock_read_count = 16
> db_block_buffers = 57600
> db_block_size = 8192
> shared_pool_size = 157286400
> processes = 200
> dml_locks = 1500
> log_buffer = 655360
> sequence_cache_entries = 800
> sequence_cache_hash_buckets = 89
> log_checkpoint_interval = 8
> optimizer_mode=CHOOSE
> session_cached_cursors =  300
> sort_area_size=1048576
> hash_area_size=262144
> hash_multiblock_io_count=4
> hash_join_enabled=TRUE
> always_anti_join=HASH
> job_queue_processes=8
> 
> 35 rollback segments, inital 1MB, next 1MB, optimal
> 30 MB
> 8 multiplexed redologs, 30 MB each
> 
> I tried FIRST_ROWS, analyzing the tables, but users
> claimed that performance
> was getting worse, so I chaged it to Choose. Always
> analyzing the tables
> 
> but, everytime I analyze the tables, performance
> gets worse.
> Is this a normal behavior?
> 
> Any advice will be welcome!
> 
> thanks is advance,
> 
> Saludos, 
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Veronica Levin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: Code Red

[Kevin Kostyszyn]

Patrice,
I have a friend downstairs who said I should use Fprot to get rid of this
rogue web page, I am going to download it now.  I am interested in this
TDS-3 program, can I get that at downloads.com or is it somewhere else?
KK

-Original Message-
Patrice J
Sent: Tuesday, August 07, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


Update your virus checking software.  Patch your software and your OS as far
as you can.  Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm
  ), it catches things the Microsoft
Windows Update seems to overlook.

You may want to get a trojan detector like tds-3 to catch trojans like
CodeRed II.  There are many trojan detectors posted on the 'net.  Beware of
free ones. Stay clear of anything on servers in countries that do not
recognize copyright laws, or who might be actively financing hackers!
Sounds obvious but sometimes people don't think about this when they are
following links on the Web.  Look at where a link leads (bottom status bar
if using IE) before you click.

You also need something that is current.  Anything that hasn't been updated
in the last year is probably useless.

It seems to me that now we need:

A virus / worm checker
A trojan horse detector
A firewall.

Only one component missing, and you could be in trouble.

The trouble with code red was that it went through port 80, which is left
open by firewalls because that is the port used for HTTP pages (WWW).
Closing that would mean no one could access Web pages.  So firewalls won't
help you re. things like that.  You can now go through any ports that are
left open, and there is software out there to detect ports that were left
open.

Life is getting complicated!

For trojan detection I like TDS-3 because with some plug-ins, you can send a
message right back to the people who are probing your system using a trojan.
TDS-3 also scans all the processes running in memory, and it comes with
interesting process descriptions for some of those obscure NT services.
This is from first glance, I am running the shareware version at home.  I
have a month to make up my mind and pay up...

For home, ZoneAlarm (firewall) is free.  I like it because it tells you when
programs are trying to access your machine via ports going in, or out.  So
if a program on your machine wants to access the 'net, you can see which
program is trying to do that and you can decide whether to let it do that or
not.  Sometimes it's hard to decide, though, e.g. distributed COM - should I
let that thing send info out of my computer to the 'net?  It's a built-in
component of Windows, but I don't know.  (btw the author says he programs
only in assembly language)

Re. virus checking F-Prot has a shareware version, that's free as long as
you don't mind re-installing it now and again.  I am probably going to buy
it eventually.  I don't know how to compare the effectiveness of these,
though.  Some are more popular out there but to my mind it doesn't mean that
they are ideal, esp. when marketing and mass advertising through the media
is involved.  I haven't seen any honest reviews of virus checking software,
I don't know where to look.

I set up ZoneAlarm and TDS-3 on my machine at home and was surprised to see
what is going on.  With ZoneAlarm you can get the owner for a particular IP
range, so you can see who is trying to ping or intrude on your machine.  A
colleague here says he is on cable modem, and that is even worse than DSL in
terms of hacking activity, he showed me a log where he was a target every
ten minutes on average for a prolonged period of time.  He uses BlackIce
Defender.  Korean and university servers are the most common that I see in
use as launchpads.  It doesn't mean that's where the probes and that attacks
are coming from though.  T1, Cable and DSL users are most at risk, but
dial-up clients are vulnerable as well as long as they remain connected.  I
sent e-mails to some ISPs to complain, but they don't appear to care what
people are doing with their net connections, it seems they just want to sell
memberships.  In many cases they want you to prove that damage was done,
someone trying to invade your machine is not illegal.  The irony is that if
someone ever succeeded, I probably wouldn't have the information I would
need to lodge a formal complaint.  I gave up trying to get ISPs to clamp
down, better to prevent these attempts from succeeding than to try to stop
the behaviour.

It's easy to become paranoid...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] 


-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 07

RE: completely off-topic question... [Tintin rules!!!!!!!!]

[Eric D. Pierce]

[via digest]

> RE: completely off-topic question...

On Saturday 04 August 2001 16:25, Rachel Carmichael wrote:
>
> 
>
> I am NOT a fan of Tolkein. 

   http://www.tintin.com

( http://www.tintin.be/fr/index.html )

Gloriously imperialistic.

_Tintin in Tibet_ is considered by many to be the high point,
when Herge was exploring transcendant themes:

http://www.tintin.com/uk/alb_fr/tibet_fr.html

---

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 stop a killed session bothering me ?

[Christian Trassens]

MaybeHowever in my experience a shutdown abort and
startup was most of the times quickier than shutdown
immediate and wait for the unfinished rollback.
Remember that one thing is recover because of the
abort and another thing is to rollback managed by the
parameter cleanup_rollback_entries and in the wakeup
frecuency of PMON. Even though pay now or pay later
sometimes is true. :)


--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> gee, I thought it was "pay Oracle now AND pay Oracle
> later" :)
> 
> 
> >From: "Page, Bruce" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: RE: how to stop a killed session bothering
> me ?
> >Date: Tue, 07 Aug 2001 07:16:08 -0800
> >
> >Pay Oracle now or pay Oracle later
> >
> > > If you did a "shutdown abort", wouldn't you
> still have to wait for the
> > > rollback to happen during instance recovery on
> the startup?
> > > I've never
> > > tried this - I usually just suffer through the
> rollback.
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Page, Bruce
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> >San Diego, California-- Public Internet
> access / Mailing Lists
>
>
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(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/intl.asp
> 
> -- 
> 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).


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

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: Weird -904 Problem

[Christian Trassens]

Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.

Regards. 
--- Jyoti N <[EMAIL PROTECTED]> wrote:


Hi,
I got a similar problem in my test database while
trying to do an export.Opened a tar with Oracle , but
not much luck yet. 
I get the following error:
EXP-8: ORACLE error 904
encounteredORA-00904: invalid column
nameEXP-0: Export terminated
unsuccessfully.
No idea why this happened?I am not sure if this is
connected to the 904 mentioned here.
Rgds,
Jyoti
 







 



>From: Christian Trassens
<[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Weird -904 Problem 
>Date: Tue, 07 Aug 2001 06:06:26 -0800 
> 
>Do you create the table with any
strange symbol or in 
>lowercase or mixing lower and upper or
within 
>spaces..?, As f.e.: 
> 
>create table weird ( "Weird Field"
NUMBER ); 
> 
>Regards. 
> 
>--- "Carle, William T (Bill), NLCIO"
<[EMAIL PROTECTED]>
>wrote: 
> > Howdy, 
> > 
> > I had an interesting situation
today. The 
> > application was trying to 
> > insert rows into a table and was
getting a -904 
> > error for invalid column. 
> > The actual problem was that the
tablespace 
> > containing the indexes was full 
> > and the index was unable to
extend. That was in the 
> > alert log. However, when 
> > doing a tkprof on their sql
statements, it showed 
> > every sql statement 
> > getting a -904. It doesn't seem
like it should do 
> > that. Has anyone seen this 
> > before? 
> > 
> > 
> > Bill Carle 
> > AT&T 
> > Database Administrator 
> > 816-995-3922 
> > [EMAIL PROTECTED] 
> > 
> > -- 
> > Please see the official ORACLE-L
FAQ: 
> > http://www.orafaq.com 
> > -- 
> > Author: Carle, William T (Bill),
NLCIO 
> > INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services --
(858) 538-5051 FAX: 
> > (858) 538-5051 
> > San Diego, California -- Public
Internet 
> > access / Mailing Lists 
> > 
>

> > To REMOVE yourself from this
mailing list, send an 
> > E-Mail message 
> > to: [EMAIL PROTECTED] (note
EXACT spelling of 
> > 'ListGuru') and in 
> > the message BODY, include a line
containing: UNSUB 
> > ORACLE-L 
> > (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!? 
>Make international calls for as low as
$.04/minute with Yahoo! Messenger 
>http://phonecard.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). 
Get your FREE
download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Jyoti N
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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] (not

RE: Code Red

[Boivin, Patrice J]

Update your virus checking software.  Patch your software and your OS as far
as you can.  Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm
  ), it catches things the Microsoft
Windows Update seems to overlook.

You may want to get a trojan detector like tds-3 to catch trojans like
CodeRed II.  There are many trojan detectors posted on the 'net.  Beware of
free ones. Stay clear of anything on servers in countries that do not
recognize copyright laws, or who might be actively financing hackers!
Sounds obvious but sometimes people don't think about this when they are
following links on the Web.  Look at where a link leads (bottom status bar
if using IE) before you click. 

You also need something that is current.  Anything that hasn't been updated
in the last year is probably useless.

It seems to me that now we need:

A virus / worm checker
A trojan horse detector
A firewall.

Only one component missing, and you could be in trouble.

The trouble with code red was that it went through port 80, which is left
open by firewalls because that is the port used for HTTP pages (WWW).
Closing that would mean no one could access Web pages.  So firewalls won't
help you re. things like that.  You can now go through any ports that are
left open, and there is software out there to detect ports that were left
open.  

Life is getting complicated!

For trojan detection I like TDS-3 because with some plug-ins, you can send a
message right back to the people who are probing your system using a trojan.
TDS-3 also scans all the processes running in memory, and it comes with
interesting process descriptions for some of those obscure NT services.
This is from first glance, I am running the shareware version at home.  I
have a month to make up my mind and pay up...  

For home, ZoneAlarm (firewall) is free.  I like it because it tells you when
programs are trying to access your machine via ports going in, or out.  So
if a program on your machine wants to access the 'net, you can see which
program is trying to do that and you can decide whether to let it do that or
not.  Sometimes it's hard to decide, though, e.g. distributed COM - should I
let that thing send info out of my computer to the 'net?  It's a built-in
component of Windows, but I don't know.  (btw the author says he programs
only in assembly language)

Re. virus checking F-Prot has a shareware version, that's free as long as
you don't mind re-installing it now and again.  I am probably going to buy
it eventually.  I don't know how to compare the effectiveness of these,
though.  Some are more popular out there but to my mind it doesn't mean that
they are ideal, esp. when marketing and mass advertising through the media
is involved.  I haven't seen any honest reviews of virus checking software,
I don't know where to look.

I set up ZoneAlarm and TDS-3 on my machine at home and was surprised to see
what is going on.  With ZoneAlarm you can get the owner for a particular IP
range, so you can see who is trying to ping or intrude on your machine.  A
colleague here says he is on cable modem, and that is even worse than DSL in
terms of hacking activity, he showed me a log where he was a target every
ten minutes on average for a prolonged period of time.  He uses BlackIce
Defender.  Korean and university servers are the most common that I see in
use as launchpads.  It doesn't mean that's where the probes and that attacks
are coming from though.  T1, Cable and DSL users are most at risk, but
dial-up clients are vulnerable as well as long as they remain connected.  I
sent e-mails to some ISPs to complain, but they don't appear to care what
people are doing with their net connections, it seems they just want to sell
memberships.  In many cases they want you to prove that damage was done,
someone trying to invade your machine is not illegal.  The irony is that if
someone ever succeeded, I probably wouldn't have the information I would
need to lodge a formal complaint.  I gave up trying to get ISPs to clamp
down, better to prevent these attempts from succeeding than to try to stop
the behaviour.

It's easy to become paranoid...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 07, 2001 2:27 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Code Red

Yeah, that's what I read.  I had applied the patch and I don't have
Code red
or Code Red II, however it appears that I have something else.  It
doesn't
seem to have worked but it looks like someone tried to deface our
web

RE: Installing Oracle 9i

[Jesse, Rich]

For us, on 8.1.7.1 with 90MB redologs and about 120-150 connections (100-150
avg TPM), we get log switches every two hours during the day and about every
10-15 minutes during the nightly processing.  I guess ideal is to switch
every 30 minutes or so, but we needed to compromise because of the nightly
batches, so I went with a 90MB redo.

Good luck!

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

-Original Message-
Sent: Tuesday, August 07, 2001 13:49
To: Multiple recipients of list ORACLE-L


100mb for redo log file is not that big?  Not big if your environment is
heavy in OLTP.



-Original Message-
Sent: Tuesday, August 07, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L



Friends :

I am installing the database Oracle 9i.
And it have suggested a parameter value 100mb for redo log file.

I am confused with this value, i think it is too big.

The blocksize is 8192
Connections simultaneous is 100

Where am I doing any mistake ?


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

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

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

Re: free up datafile space problem ???

[JOE TESTA]

its like the high water mark in a table but its at the 
datafile side instead.
 
if any block in the datafile has ever had data in it, you 
can't shrink it below that point.
 
hth, joe
 
>>> [EMAIL PROTECTED] 08/07/01 02:40PM 
>>>Hi all,I have a data file of 2G and the free bytes is 
1,413,079, the used bytes is only 683,829.  I like toresize 
it.  When I issue:alter database 
datafile'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize1000M, I 
got:ERROR at line 1:ORA-03297: file contains used data beyond 
requestedRESIZE valueBut apparently, the file does NOT contain 
data beyond1000M.  Am I missing something?Thank 
you.Janet__Do 
You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! 
Messengerhttp://phonecard.yahoo.com/-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Janet 
Linsy  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-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: Weird -904 Problem

[Christian Trassens]

Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.

Regards. 


--- Jyoti N <[EMAIL PROTECTED]> wrote:


Hi,
I got a similar problem in my test database while
trying to do an export.Opened a tar with Oracle , but
not much luck yet. 
I get the following error:
EXP-8: ORACLE error 904
encounteredORA-00904: invalid column
nameEXP-0: Export terminated
unsuccessfully.
No idea why this happened?I am not sure if this is
connected to the 904 mentioned here.
Rgds,
Jyoti
 







 



>From: Christian Trassens
<[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Weird -904 Problem 
>Date: Tue, 07 Aug 2001 06:06:26 -0800 
> 
>Do you create the table with any
strange symbol or in 
>lowercase or mixing lower and upper or
within 
>spaces..?, As f.e.: 
> 
>create table weird ( "Weird Field"
NUMBER ); 
> 
>Regards. 
> 
>--- "Carle, William T (Bill), NLCIO"
<[EMAIL PROTECTED]>
>wrote: 
> > Howdy, 
> > 
> > I had an interesting situation
today. The 
> > application was trying to 
> > insert rows into a table and was
getting a -904 
> > error for invalid column. 
> > The actual problem was that the
tablespace 
> > containing the indexes was full 
> > and the index was unable to
extend. That was in the 
> > alert log. However, when 
> > doing a tkprof on their sql
statements, it showed 
> > every sql statement 
> > getting a -904. It doesn't seem
like it should do 
> > that. Has anyone seen this 
> > before? 
> > 
> > 
> > Bill Carle 
> > AT&T 
> > Database Administrator 
> > 816-995-3922 
> > [EMAIL PROTECTED] 
> > 
> > -- 
> > Please see the official ORACLE-L
FAQ: 
> > http://www.orafaq.com 
> > -- 
> > Author: Carle, William T (Bill),
NLCIO 
> > INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services --
(858) 538-5051 FAX: 
> > (858) 538-5051 
> > San Diego, California -- Public
Internet 
> > access / Mailing Lists 
> > 
>

> > To REMOVE yourself from this
mailing list, send an 
> > E-Mail message 
> > to: [EMAIL PROTECTED] (note
EXACT spelling of 
> > 'ListGuru') and in 
> > the message BODY, include a line
containing: UNSUB 
> > ORACLE-L 
> > (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!? 
>Make international calls for as low as
$.04/minute with Yahoo! Messenger 
>http://phonecard.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). 
Get your FREE
download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Jyoti N
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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] (n

Re: Weird -904 Problem

[Christian Trassens]

Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.

Regards. 


--- Jyoti N <[EMAIL PROTECTED]> wrote:


Hi,
I got a similar problem in my test database while
trying to do an export.Opened a tar with Oracle , but
not much luck yet. 
I get the following error:
EXP-8: ORACLE error 904
encounteredORA-00904: invalid column
nameEXP-0: Export terminated
unsuccessfully.
No idea why this happened?I am not sure if this is
connected to the 904 mentioned here.
Rgds,
Jyoti
 







 



>From: Christian Trassens
<[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Weird -904 Problem 
>Date: Tue, 07 Aug 2001 06:06:26 -0800 
> 
>Do you create the table with any
strange symbol or in 
>lowercase or mixing lower and upper or
within 
>spaces..?, As f.e.: 
> 
>create table weird ( "Weird Field"
NUMBER ); 
> 
>Regards. 
> 
>--- "Carle, William T (Bill), NLCIO"
<[EMAIL PROTECTED]>
>wrote: 
> > Howdy, 
> > 
> > I had an interesting situation
today. The 
> > application was trying to 
> > insert rows into a table and was
getting a -904 
> > error for invalid column. 
> > The actual problem was that the
tablespace 
> > containing the indexes was full 
> > and the index was unable to
extend. That was in the 
> > alert log. However, when 
> > doing a tkprof on their sql
statements, it showed 
> > every sql statement 
> > getting a -904. It doesn't seem
like it should do 
> > that. Has anyone seen this 
> > before? 
> > 
> > 
> > Bill Carle 
> > AT&T 
> > Database Administrator 
> > 816-995-3922 
> > [EMAIL PROTECTED] 
> > 
> > -- 
> > Please see the official ORACLE-L
FAQ: 
> > http://www.orafaq.com 
> > -- 
> > Author: Carle, William T (Bill),
NLCIO 
> > INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services --
(858) 538-5051 FAX: 
> > (858) 538-5051 
> > San Diego, California -- Public
Internet 
> > access / Mailing Lists 
> > 
>

> > To REMOVE yourself from this
mailing list, send an 
> > E-Mail message 
> > to: [EMAIL PROTECTED] (note
EXACT spelling of 
> > 'ListGuru') and in 
> > the message BODY, include a line
containing: UNSUB 
> > ORACLE-L 
> > (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!? 
>Make international calls for as low as
$.04/minute with Yahoo! Messenger 
>http://phonecard.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). 
Get your FREE
download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Jyoti N
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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] (n

RE: ORA-00600 on Production DB - Need advice/Still Searching

[Hillman, Alex]

What about TWO_TASK env. variable? Is it set?

Alex Hillman

-Original Message-
Sent: Tuesday, August 07, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


David,

What is your setting for LARGE_POOL and have you tried
decreasing it?

Also, this is frequently caused by 3rd party software,
such as AutoSecure, that does additional
authorization.  

Also check to ensure that user "oracle" (or whatever
user you're using to start the db) has not been
removed from the "dba" group in the /etc/group file.

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
> 
> Denny/Kirti,
> 
> Thanks for the replies.  The bug finder is kinda
> cool.  I'd already been
> through about one third of the entries it found, but
> I looked through the
> rest.  No real help.  Can't log in to shut down the
> DB.  Whether I try
> svrmgrl or sqlplus, I get asked for a password or
> told I have insufficient
> privileges.  There aren't any additional trace
> files.  Here's the output of
> the ulimit -a command:
> qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a
> time(seconds)unlimited
> file(blocks) unlimited
> data(kbytes) 196608
> stack(kbytes)196608
> memory(kbytes)   unlimited
> coredump(blocks) 4194303
> nofiles(descriptors) 2048
> 
> kmtune shows me the following:
> maxssiz  0X0C00
> maxssiz_64bit   0x4000
> swapmem_on   0
> dbc_max_pct  50
> 
> Total physical and swap meory (from top) is:
> Memory: 364536K (264244K) real, 423812K (340152K)
> virtual, 6453348K free
> 
> 
> 
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
> 
> 
> 
> 
>  
> Denny Koovakattu
> 
>  
> <[EMAIL PROTECTED]>
>  To: [EMAIL PROTECTED]  
>  
> Sent by:
>  cc:
>  
> [EMAIL PROTECTED] 
>  Subject: Re: ORA-00600 on Production DB - Need
> advice
> .tenet.edu  
> 
>  
> 
> 
>  
> 
> 
>  
> 08/06/2001 12:44 PM 
> 
>  
> 
> 
>  
> 
> 
>  
> 
> 
> 
> 
> Hi David,
> 
>   To get the proper output for ulimit, use
> 
>   /usr/bin/ulimit -a
> 
> or
>   sh ulimit -a
> 
> Also the following information should help in trying
> to debug the problem.
> 
> 1. Total Physical Memory
> 2. Total Disk Swap Configured
> 3. The output of kmtune or the kernel parameters
> maxdsiz, maxdsiz_64bit,
> swapmem_on, dbc_max_pct
> 4. The output of ulimit (Use /usr/bin/ulimit -a )
> 
>   Have you tried restarting the database ?
> 
> Regards,
> Denny
> 
> [EMAIL PROTECTED] wrote:
> >
> > Mondays, gotta love em, they make Fridays worth
> the wait.  I've got Ta
> > production database (8.1.7, HP-UX 11.0 - 64 bit)
> that started throwing an
> > ora-600 when users try to log in.  I've created a
> TAR (3 hours ago), but
> > haven't gotten any response.  Here's the error:
> >
> > ERROR:
> > ORA-00600: internal error code, arguments:
> [kzckini: nzdsi_i], [28750],
> [],
> > [],
> > [], [], [], [
> >
> > Metalink has a couple of messages stating that
> this is an OS problem
> > related to the ulimit size, availability of
> virtual memory, and the
> ability
> > to create a pga.  Suggested remedy is to increase
> the ulimit.   My SA has
> > dismissed this as a cause.  I've knocked all the
> users off, but still
> can't
> > log in.  When I run ulimit I get the following:
> >  qe2n1:
> /u001/app/oracle/product/8.1.7/dbs>>ulimit
> >  4194303
> >
> > Any suggestions?
> >
> > David A. Barbour
> > Oracle DBA, OCP
> > AISD
> > 512-414-1002
> 
>
_
> 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: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

RE: Installing Oracle 9i

[Wong, Bing]

100mb for redo log file is not that big?  Not big if your environment is
heavy in OLTP.



-Original Message-
Sent: Tuesday, August 07, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L



Friends :

I am installing the database Oracle 9i.
And it have suggested a parameter value 100mb for redo log file.

I am confused with this value, i think it is too big.

The blocksize is 8192
Connections simultaneous is 100

Where am I doing any mistake ?


Eriovaldo
[EMAIL PROTECTED]


_
Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus 
amigos com o MSN Messenger em http://messenger.msn.com.br

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Christian Trassens]

1.- Go to this link of Steve Adam's site:

http://www.ixora.com.au/scripts/cache.htm

You gonna find a script to estimate the miss rate of
the buffer cache based on the assumptions that certain
operations are not well compute by statistics as
direct path operations.

2.- From 8.X you should rely on
v$buffer_pool_statistics from the script
$ORACLE_HOME/rdbms/admin/catperf.sql accounting on the
several pools you could have.

3.- Remember that even on 8.X, when the database has
been opened for a long time and have had a lot of
transactions, the value of statistics gets so big that
reaches the maximum value and then begins from 0
again. This usually happens with 7.X.

Regards. 
--- "Deshpande, Kirti" <[EMAIL PROTECTED]>
wrote:
> Andrey,
>  I am not into cache hit ratios, but got curious
> about your negative value. 
> 
>  So I casually searched Metalink for 'negative value
> for hit ratio'. And got
> a hit on 'MROC: I am receiving a negative Buffer
> Cache hit ratio' thread.
> You may want to check it out, there seems to be a
> new formula for hit ratio
> computation in 8i/9i. 
> 
> HTH,
> 
> Regards,
> 
> - Kirti Deshpande 
>   Verizon Information Services
>http://www.superpages.com
> 
> > -Original Message-
> > From:   Andrey Bronfin
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 07, 2001 12:51 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:negative value for buffer cache hit ratio
> 
> > 
> > 
> > Dear gurus !
> > I have a negative value for buffer cache hit ratio
> in my DB which is up
> > for
> > some 4 months .
> > Any ideas why ?
> > Thanks in advance.
> > 
> > SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical
> reads',value,0)) /
> >   2   (SUM(DECODE(a.name,'consistent
> gets',value,0)) +
> >   3   SUM(DECODE(a.name,'db block
> gets',value,0) * 100 "buffer cache
> > hit
> > ratio"
> >   4   FROM   v$sysstat a;
> > 
> > buffer cache hit ratio
> > --
> >  -52.99284
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Andrey Bronfin
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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


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

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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).

free up datafile space problem ???

[Janet Linsy]

Hi all,

I have a data file of 2G and the free bytes is 
1,413,079, the used bytes is only 683,829.  I like to
resize it.  When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value


But apparently, the file does NOT contain data beyond
1000M.  Am I missing something?

Thank you.

Janet

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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

No Subject

[Ingrid Diefenbach]

SET ORACLE-L MAIL




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Installing Oracle 9i

[Christopher Spence]

Depends on your transaction size, and how often you are filling the logs,
start off with 10 - 20mb, and see what you get.  Ideally you want a log
switch every 30 minutes, less if you are concerned about replication and
instance recovery time.  They are easy to increase/descrease without
restarting the instance, if they are too small, all you do is loose
performance, and you can always fix that by adjusting the settings to fix
it.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:58 PM
To: Multiple recipients of list ORACLE-L



Friends :

I am installing the database Oracle 9i.
And it have suggested a parameter value 100mb for redo log file.

I am confused with this value, i think it is too big.

The blocksize is 8192
Connections simultaneous is 100

Where am I doing any mistake ?


Eriovaldo
[EMAIL PROTECTED]


_
Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus 
amigos com o MSN Messenger em http://messenger.msn.com.br

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: negative value for buffer cache hit ratio

[Deshpande, Kirti]

Andrey,
 I am not into cache hit ratios, but got curious about your negative value. 

 So I casually searched Metalink for 'negative value for hit ratio'. And got
a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread.
You may want to check it out, there seems to be a new formula for hit ratio
computation in 8i/9i. 

HTH,

Regards,

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

> -Original Message-
> From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 12:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  negative value for buffer cache hit ratio 
> 
> 
> Dear gurus !
> I have a negative value for buffer cache hit ratio in my DB which is up
> for
> some 4 months .
> Any ideas why ?
> Thanks in advance.
> 
> SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
>   2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
>   3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache
> hit
> ratio"
>   4   FROM   v$sysstat a;
> 
> buffer cache hit ratio
> --
>  -52.99284
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: negative value for buffer cache hit ratio

[Christopher Spence]

Try this more accurate query:

select  to_char(100 * misses / (hits + misses), '9990.00') || '%'  miss_rate
  from ( select total_waits  misses
  from sys.v_$system_event
where event = 'db file sequential read' ),
 ( select sum(dbbget + conget - pread)  hits
 from sys.x_$kcbwds
   where inst_id = userenv('Instance') )
/

Also, send the actual values if this query still leads to similar results.

The difference here is it takes in account of direct writes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
  2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
  3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache hit
ratio"
  4   FROM   v$sysstat a;

buffer cache hit ratio
--
 -52.99284

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

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

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

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

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

Re:Help needed

[dgoulet]

There are two things you can do:

1) turn Oracle auditing on for ddl statements to see who's doing them.
2) if you know the username where things are being messed up, you could
revoke the create session privilege & find out who screams.

I'd also look at that table and see who has index privileges on it or if anyone
has create, delete, or alter any index privileges.  You might check as to who
has the dba role.  Revoking it may bring the culprit out of hiding.

Dick Goulet

Reply Separator
Author: "Deewaker G.V." <[EMAIL PROTECTED]>
Date:   8/7/2001 12:00 AM

HI DBA Guru's

It has been a painful process for me everytime when I change the password of
the user in ORACLE.. The reason is simple Some one is trying to play
with the tables and change the INDEXS... delete the synonyn... and so on...
I just want to know how do I come to know either or all of this..
The pc name who was connected.
The time when he/she executed the process
What was the command given to execute the same..

Pls... Guruji's help me...

with warm regards,

Deewaker G. V.

Baazee.com India Pvt. Ltd.
*: 4611323 Extn: 216
Fax : 4611324

 <> 






Help needed 



HI DBA Guru's


It has been a painful process for
me everytime when I change the password of the user in ORACLE.. The reason is
simple Some one is trying to play with the tables and change the INDEXS...
delete the synonyn... and so on... I just want to know how do I come to know
either or all of this..

The pc name who was
connected.
The time when he/she executed the
process
What was the command given to
execute the same..


Pls... Guruji's help me...


with warm regards,


Deewaker G. V.


Baazee.com India Pvt. Ltd.
(: 4611323 Extn: 216
Fax : 4611324


 <>





 
 Deewaker G.V..vcf

RE: Optimizer Mode......how to choose the right one?

[Veronica Levin]

Most of the transactions are select, and updates..

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: Wong, Bing [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 11:43 a.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?


What type of transactions are running, update, insert, delete, or select?

-Original Message-
Sent: Tuesday, August 07, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings are very poor.

I have a good article on my site www.vampired.net under Performance which is
a great discussion about making the CBO work for you and not against you.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, in

Installing Oracle 9i

[Eca Eca]

Friends :

I am installing the database Oracle 9i.
And it have suggested a parameter value 100mb for redo log file.

I am confused with this value, i think it is too big.

The blocksize is 8192
Connections simultaneous is 100

Where am I doing any mistake ?


Eriovaldo
[EMAIL PROTECTED]


_
Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus 
amigos com o MSN Messenger em http://messenger.msn.com.br

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

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

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

PARTITION attache to SYNONYM

[Dave Morgan]

Hi All,
Wondering if anyone has seen anything like this. I have
filed a TAR.

When adding next month's partition to a table a synonym was
used accidently. However, the partition was created and shows
up  in dba_tab_partitions. However, I cannot modify of drop the
partition.

ALTER TABLE synonym_name drop PARTITION partition_name;
returns no such table

ALTER TABLE table_name drop PARTITION partition_name;
returns no such partition.

I have built another structure to hold the data but does anyone
know the consequences if I dorp the ysnonym.

TIA
Dave


-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

multimaster replication

[Andrey Bronfin]

Dear gurus !
Finally , they caught me  ;-(
I need to implement multimaster replication (asynchronous) among 2
databases.
A couple of general questions before i start :
 - Is it a must for the 2 DBs to be of the same version (release) ?
 - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ?
 - Do U have to replicate among 2 schemas with the same names ?
 - Are there any general bugs / issues ? Something to be aware of ?
 - And , the most important , i'd be very happy if u , gurus , could send me
some scripts , how-tos , manuals , articles , your thoughts - simply
anything related to advanced replication.
Many thanks in advance.
Andrey.


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

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

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

negative value for buffer cache hit ratio

[Andrey Bronfin]

Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months .
Any ideas why ?
Thanks in advance.

SQL>  SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
  2   (SUM(DECODE(a.name,'consistent gets',value,0)) +
  3   SUM(DECODE(a.name,'db block gets',value,0) * 100 "buffer cache hit
ratio"
  4   FROM   v$sysstat a;

buffer cache hit ratio
--
 -52.99284

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Wong, Bing]

If the transaction having problem is a SELECT statement and does SORT, then
I think the sort_area_size is too small.   

Can you show us the SQL?




-Original Message-
Sent: Tuesday, August 07, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L


Hi there,

Unfortunately you can't just throw things like FIRST_ROWS at a select
statement to make it run faster. The person who wrote the statement should
have taken into account such things as:

a) Size of tables, ordering, which is the driving table
b) Indexes, are the being used, running statements through explain plan will
show you where the bottlenecks are...failing that TKPROF will identify
potential problem areas with your database.
c) Size of queries, joins etc.

Too many developers do not write code to be efficient, as long as it returns
the correct values it doesn't matter whether it takes 2 minutes or  2
hours...

I've spent a number of hours/days/weeks/months tidying up poorly optimised
code, it's an absolute nightmare for the DBAs and it doesn't look good on
the developers.

Cheers,
Kev.
(a cheesed off developer...not a DBA!)


__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 07 August 2001 17:06
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Veronica Levin]

thanks Christopher, I'll take a look and let you know,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: Christopher Spence [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 10:56 a.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?


Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings are very poor.

I have a good article on my site www.vampired.net under Performance which is
a great discussion about making the CBO work for you and not against you.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Wong, Bing]

What type of transactions are running, update, insert, delete, or select?

-Original Message-
Sent: Tuesday, August 07, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings are very poor.

I have a good article on my site www.vampired.net under Performance which is
a great discussion about making the CBO work for you and not against you.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Optimizer Mode......how to choose the right one?

[Christopher Spence]

If you are using 8.x + I would recommend looking at Statspack over
utilbstat.
It comes installed with 816+ and available for download on 8.x+.

It is fairly easy to configure and a great utility.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 12:48 PM
To: Multiple recipients of list ORACLE-L


1)  How often do you rebuild your indexes?
2)  What does your utlb and utle report say?
3)  Have you done any explain plans or tkprofs on your sql code?
Sql may not be using indexes.  
4)  Try using a hint of rule on your sql code to see if it runs better that
way
5)  Do you have a lot of chaining going on.
6)  Do you have enough rollback segments and are they sized right
7)  what are the size of your redo logs and how often are you check
pointing?
8)  Do you have auditing turned on.?  A lot of tracing going on?

Best would be to run utlb and utle reports.  I would send you to
www.perfmon.com to get a quick analysis but this site has been under
construction for several days and I don't know of another site that will
analyze this reports.

Someone else may know of another site that analyzes utlb/utle reports.

kathy

-Original Message-
Sent: Tuesday, August 07, 2001 9:06 AM
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing). Confidential This e-mail
and any files transmitted with it are the property of Belkin Components
and/or its affiliates, are confidential, and are intended solely for the use
of the individual or entity to whom this e-mail is addressed.  If you are
not one of the named recipients or otherwise have reason to believe that you
have received this e-mail in error, please notify the sender and delete this
message immediately from your computer. Any other use, retention,
dissemination, forwarding, printing or copying of this e-mail is strictly
prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

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

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

RE: Optimizer Mode......how to choose the right one?

[Christopher Spence]

When using first rows, you force the cost based optimizer, in which the
order of the tables does not matter.

Order of the tables only matters when using the ORDERED hint or using rbo
AND there is a tie ranking.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

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: Tuesday, August 07, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Hi there,

Unfortunately you can't just throw things like FIRST_ROWS at a select
statement to make it run faster. The person who wrote the statement should
have taken into account such things as:

a) Size of tables, ordering, which is the driving table
b) Indexes, are the being used, running statements through explain plan will
show you where the bottlenecks are...failing that TKPROF will identify
potential problem areas with your database.
c) Size of queries, joins etc.

Too many developers do not write code to be efficient, as long as it returns
the correct values it doesn't matter whether it takes 2 minutes or  2
hours...

I've spent a number of hours/days/weeks/months tidying up poorly optimised
code, it's an absolute nightmare for the DBAs and it doesn't look good on
the developers.

Cheers,
Kev.
(a cheesed off developer...not a DBA!)


__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 07 August 2001 17:06
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Code Red

[Kevin Kostyszyn]

Yeah, that's what I read.  I had applied the patch and I don't have Code red
or Code Red II, however it appears that I have something else.  It doesn't
seem to have worked but it looks like someone tried to deface our website.
It's just a message that says "f--k the us government and f--k poisonbox",
not sure what to do with it yet.
KK

-Original Message-
Brian
Sent: Tuesday, August 07, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


The worm is just memory resident, so a reboot should get rid of it, BUT
without the patch, you'll get it right back.

The problem for the new version is it deposits a trojan backdoor on your
server.
Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus
scanners are releasing versions also.  Check with your anti-virus site.

> -Original Message-
> From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 11:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Code Red
>
>
> So does anyone know how to get rid of the virus if you got it?
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: OT : Way OT

[Yosi Greenfield]

My guess is that everyone's got too much time on their hands these days...

The market'll pick up, and the list will soften up.

I hope, on both counts.

Yosi


Kevin Kostyszyn wrote:

> Wow!!! You're correct sir!!:)
> KK
>
> -Original Message-
> Thomas F
> Sent: Monday, August 06, 2001 2:42 PM
> To: Multiple recipients of list ORACLE-L
>
> Wow!
>
> you can tell we are approaching a full moon.  this list is getting a bit
> nasty!
>
> Tom Mercadante
> {Very Humble} Oracle Certified Professional
> --

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