RE: Why DDL is not allowed in PL/SQL

[Alroy Mascranghe]

Maybe it is to maintain transaction consistency, bcos the DDLs issue a
commit implicitly. So if u do in the middle of DML-transaction it might mess
up the transaction as a whole.

-Original Message-
Sent: Friday, July 12, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L


Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.

Curious
Sam


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 sort these values 'correctly?' 1.1..1, 1.1..2, 1.1..13

[Jared Still]

On Thursday 11 July 2002 12:46, Jay Weinshenker wrote:
> So imagine I have this series of numbers
> 1.1
> 1.1..1
> 1.1..13
> 1.1..2
> 1.1..3
> and I want them to sort like a human would sort them
>
> 1.1
> 1.1..1
> 1.1..2
> 1.1..3
> 1.1..7
> 1.1..13
> Anyone have sql to accomplish this?

Here ya go.

You will need to login as SYS and 
'grant execute on owa_pattern to the_owner_of_the_function' for this to work.

Jared



drop table t;

create table t(t varchar2(20));
insert into t(t) values('1.1');
insert into t(t) values('1.1..1');
insert into t(t) values('1.1..2');
insert into t(t) values('1.1..3');
insert into t(t) values('1.1..7');
insert into t(t) values('1.1..13');

commit;

create or replace function sortable( data_in varchar2 )
return number
as
   sort_data varchar2(40);
   zero_pad varchar2(5) := '0';
begin

   sort_data := data_in;
   owa_pattern.change(sort_data,'\.+','\.','g');
   owa_pattern.change(sort_data,'\.+',zero_pad,'g');
   sort_data := sort_data || zero_pad;

   return to_number(sort_data);

end;
/

show error function sortable
select t
from t
order by sortable(t)
/





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

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

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

Re: Help me tuning the log file sync wait event

[Jared Still]

You say your log files are on RAID 5?

On a busy database?  

Are your log files all on the same RAID 5 volume?

I'm going to take a SWAG and say that you seriously
need to consider dedicating at least 3 RAID 1 volumes
to nothing but log file usage.

There's a 400-500% write penalty on RAID 5.  It's good
for reads, not so much for writes.

Jared


On Thursday 11 July 2002 20:33, chaos wrote:
> hi, dbas:
>   One of the database i manage face a serious wait event, log file sync.
> This is a big and busy oltp system, and using disk array of Sun T3 with
> raid-5. We are using Veritas QuickIO for datafile and redo log files. The
> pressure on the database is growing fast, and more and more the redo log
> becomes the bottleneck of the database. Here is some data showing the fact:
>
>
>
> 2002/05/03
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync 
> 82,244   92,442   33.68 db file sequential read
>   298,301   80,719   29.41 log file parallel write 
>   81,849   36,989   13.48 db file parallel write   
>   5,427   33,615   12.25 control file parallel write   
>  4,6736,1042.22
>
>
> 2002/05/07
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync  
> 6,352,383   15,785,313   40.09 db file sequential read 
>   26,862,699   12,538,922   31.85 log file parallel write  
>   5,971,2293,990,066   10.13 db file parallel write
>290,4793,164,3918.04 db file scattered read 
> 1,749,137  814,9812.07
>
> 2002/05/21
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync  
> 2,207,6096,688,751   59.47 log file parallel write 
>2,044,9771,385,379   12.32 db file parallel write   
> 103,1551,203,077   10.70 db file sequential read   
>  8,772,9081,088,9229.68 log buffer space   
> 3,284  222,6041.98
>
> 2002/05/28
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync  
> 2,247,585   20,529,779   63.71 db file parallel write  
>  441,0524,377,899   13.59 log file parallel write  
>   1,724,0893,806,535   11.81 db file sequential read   
>  8,854,5252,044,0206.34 enqueue
>78,759  592,4111.84
>
> 2002/07/04
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync  
> 3,838,694   13,158,371   63.28 db file sequential read 
>2,189,8632,401,275   11.55 log file parallel write  
>   3,401,0352,098,018   10.09 db file parallel write
> 97,0861,503,6087.23 enqueue
>71,251  432,7062.08
>
> 2002/07/11
> Top 5 Wait Events
> ~ Wait %
> Total Event   Waits  Time (cs) 
>  Wt Time  
>  --- log file sync
> 453,8629,679,513   68.11 db file sequential read   
>500,1571,660,982   11.69 db file parallel write 
>67,2351,137,0178.00 log file parallel write 
>  163,1801,075,2017.57 log file sequential read 
>  32,012  254,3271.79
>
>
>
>
> As you can see, log file sync is a big bottleneck, and i have to solve this
> prob

Re: Function based indexes

[Jared Still]

I don't think that will work.  If you need this to work in a SQL statement in 
SQL*Plus, what you can do is something like this:

create or replace package types 
as 
type cursorType is ref cursor; 
end; 
/ 

create or replace function sp_ListEmp 
( col_value_in my_table.my_column.%type default 'My Default Value')
return types.cursortype 
as 
l_cursortypes.cursorType; 

begin 

open l_cursor for  select 'x'
from my_table
where my_column = col_value_in;

return l_cursor; 
end; 
/

REM SQL*Plus commands to use a cursor variable 

variable c refcursor 
variable my_bind='testdata'

exec :c := sp_ListEmp(:my_bind)
print c


HTH

Jared

On Thursday 11 July 2002 15:24, Imma C. Rocco wrote:
> Hi,
> I have read that on Oracle 8.1.7 it is possible to create a function based
> index like the one: Create index ind1 on  (substr())
> tabelspace etc
> And if Oracle optimizer is in CBO mode and
> query_rewrite_enabled = true
> query_rewrite_integrity = trusted
> compatible = 8.1.0 or greater
> A statement which has a where clause that involve a substr()
> should use the index.
>
>
> (*)I would like to know if it is also possible to create a function
> based index on a NVL function that involve a bind variable, because
> a have a statement like the one that follow:
> select 'x'
> from 
> where  = nvl(:p_aa, )
>
> This statement perform a full table scan on 
>
> ps: if (*) is possible could you please give an sintax example?
>
> Thanks
> Imma
>
>
>
> _
> Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads
> and NoTaglines --> LYCOS MAIL PLUS.
> http://www.mail.lycos.com/brandPage.shtml?pageId=plus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: Re: Re: Buffer busy waits are 10.96% of non-idle waits

[chaos]

oraora  oraora£¬
hi, i think use bind variable will give better performance, but it has nothing to 
do with the buffer busy wait.Using bind variable will solve the repeated parse and 
thus reduce library latch free wait.
And seperate table and index won't help either. There is a greate thread in 
dbforums.com talking about seperate table and index .
As for the buffer busy wait, i do not have any good idear either.


Good luck!

chaos
[EMAIL PROTECTED]

zhu chao
DBA of Eachnet.com
86-021-32174588-667


ÔÚ 2002-07-11 20:23:00 You wrote:
>Hi Kavitha,
>
>querying v$waitstat gives me the o/p below.
>
>CLASS   COUNT   TIME
>-- -- --
>data block  131525173  225446798
>sort block  0  0
>save undo block 0  0
>segment header   4968  16264
>save undo header0  0
>free list   0  0
>extent map  0  0
>bitmap block0  0
>bitmap index block  0  0
>unused  0  0
>system undo header  0  0
>system undo block   0  0
>undo header  1582 14
>undo block  45965   3008
>
>the data block above belongs to a datafile USERS01.DAT which has
>all the tables and indexes the application uses.
>
>the top 25 SQL statements are always SELECT statements.
>they get executed repeatedly.
>is it b'coz all SQLs are with literals and no bind variables ?
>
>it's a highly read OLTP system.
>
>will not
>-- using bind variables instead of literals
>-- seperating tables and indexes to diferent tabelspace
>
>solve my problem  ?
>
>Regards,
>prem.
>
>
>
>On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote :
>>
>>Hi ,
>>
>>TOAD gives this alarm often. what does it mean ? which view
>>will
>>give me the wait statistics ?
>>
>>Answer :
>>==
>>Please run STATSPACK to if this is one of the top waitevents to
>>check if the percentage of wait - can be treated as problematic
>>one
>>
>>  SELECT p1 "File", p2 "Block", p3 "Reason"
>> FROM v$session_wait
>>WHERE event='buffer busy waits'
>>Repeatedly run the above statement and collect the output. After
>>a period
>>of time sort the results to see which file & blocks are showing
>>contention:
>>
>>
>>" it occurs when a session cannot access a block because it is
>>in
>>use by another session. The two most common causes are
>>insufficient free lists for a table or insufficient rollback
>>segments. "  --- IS THIS THE REASON ?
>>
>>Answer:
>>==
>>   Yes on top of  the wait event could also occur
>>  could also occur  if
>>
>>a. if the application is going against a set of same blocks (hot
>>blocks)
>>
>>Thanks,
>>Kavi
>
>_
>There is always a better job for you at Monsterindia.com.
>Go now http://monsterindia.rediff.com/jobs
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oraora  oraora
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

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

RE: Why DDL is not allowed in PL/SQL

[Suhen Pather]

Sam,

If u r in 8i and above 
You could use

execute immediate 'create table .';

Regards
Suhen

Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.

Curious
Sam


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  INET: [EMAIL PROTECTED]

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

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

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

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

Why DDL is not allowed in PL/SQL

[sam d]

Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.

Curious
Sam


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  INET: [EMAIL PROTECTED]

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

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

Re: Re: Buffer busy waits are 10.96% of non-idle waits

[oraora oraora]

Hi Kavitha,

querying v$waitstat gives me the o/p below.

CLASS   COUNT   TIME
-- -- --
data block  131525173  225446798
sort block  0  0
save undo block 0  0
segment header   4968  16264
save undo header0  0
free list   0  0
extent map  0  0
bitmap block0  0
bitmap index block  0  0
unused  0  0
system undo header  0  0
system undo block   0  0
undo header  1582 14
undo block  45965   3008

the data block above belongs to a datafile USERS01.DAT which has 
all the tables and indexes the application uses.

the top 25 SQL statements are always SELECT statements.
they get executed repeatedly.
is it b'coz all SQLs are with literals and no bind variables ?

it's a highly read OLTP system.

will not
-- using bind variables instead of literals
-- seperating tables and indexes to diferent tabelspace

solve my problem  ?

Regards,
prem.



On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote :
>
>Hi ,
>
>TOAD gives this alarm often. what does it mean ? which view 
>will
>give me the wait statistics ?
>
>Answer :
>==
>Please run STATSPACK to if this is one of the top waitevents to
>check if the percentage of wait - can be treated as problematic 
>one
>
>  SELECT p1 "File", p2 "Block", p3 "Reason"
> FROM v$session_wait
>WHERE event='buffer busy waits'
>Repeatedly run the above statement and collect the output. After 
>a period
>of time sort the results to see which file & blocks are showing
>contention:
>
>
>" it occurs when a session cannot access a block because it is 
>in
>use by another session. The two most common causes are
>insufficient free lists for a table or insufficient rollback
>segments. "  --- IS THIS THE REASON ?
>
>Answer:
>==
>   Yes on top of  the wait event could also occur
>  could also occur  if
>
>a. if the application is going against a set of same blocks (hot 
>blocks)
>
>Thanks,
>Kavi

_
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs

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

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

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

Help me tuning the log file sync wait event

[chaos]

hi, dbas:
One of the database i manage face a serious wait event, log file sync. This is 
a big and busy oltp system, and using disk array of Sun T3 with raid-5. We are using 
Veritas QuickIO for datafile and redo log files. 
The pressure on the database is growing fast, and more and more the redo log becomes 
the bottleneck of the database. 
Here is some data showing the fact: 



2002/05/03
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync  82,244   92,442   33.68
db file sequential read   298,301   80,719   29.41
log file parallel write81,849   36,989   13.48
db file parallel write  5,427   33,615   12.25
control file parallel write 4,6736,1042.22
 

2002/05/07
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync   6,352,383   15,785,313   40.09
db file sequential read26,862,699   12,538,922   31.85
log file parallel write 5,971,2293,990,066   10.13
db file parallel write290,4793,164,3918.04
db file scattered read  1,749,137  814,9812.07

2002/05/21
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync   2,207,6096,688,751   59.47
log file parallel write 2,044,9771,385,379   12.32
db file parallel write103,1551,203,077   10.70
db file sequential read 8,772,9081,088,9229.68
log buffer space3,284  222,6041.98

2002/05/28
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync   2,247,585   20,529,779   63.71
db file parallel write441,0524,377,899   13.59
log file parallel write 1,724,0893,806,535   11.81
db file sequential read 8,854,5252,044,0206.34
enqueue78,759  592,4111.84
 
2002/07/04 
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync   3,838,694   13,158,371   63.28
db file sequential read 2,189,8632,401,275   11.55
log file parallel write 3,401,0352,098,018   10.09
db file parallel write 97,0861,503,6087.23
enqueue71,251  432,7062.08

2002/07/11
Top 5 Wait Events
~ Wait % Total
Event   Waits  Time (cs)   Wt Time
   ---
log file sync 453,8629,679,513   68.11
db file sequential read   500,1571,660,982   11.69
db file parallel write 67,2351,137,0178.00
log file parallel write   163,1801,075,2017.57
log file sequential read   32,012  254,3271.79




As you can see, log file sync is a big bottleneck, and i have to solve this problem. 
I think the best solution maybe convert to dedicated raid1 or single disk with oracle 
multiplex, but this need to rebuild the whole disk array , need too much downtime, and 
with some risk. 
I tried to disable CachedQuick IO on the redo log file, but did not see performance 
gains. 
Veritas Said quick io is as fast as RAW, but i did not tested it before, i wonder 
whether move to raw for redo log will helps? 
It is difficult to modify the application to reduce the frequency of commit, for every 
transaction finishes, it have 

RE: listener configuration on HP serviceguard clusters

[Alexander . Feinstein]

Title: RE: listener configuration on HP serviceguard clusters





Matt,


We have two nodes cluster with three packages; two of them have more than one database.
Oracle software installed on each node. Each listener belongs to node, not to package.
When packaged started on the node it will startup instance(s) and each instance will automatically registered with listener.

In client's TNSNAMES.ORA we use package name, which resolved to proper IP address.


Alex.


-Original Message-
From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject: listener configuration on HP serviceguard clusters



If anybody out there is using HP ServiceGuard for 
non-OPS/RAC, I would be interested to know how you 
configure the listeners.  Do you use the machine IP address 
or the package address in the listener.ora (or do you not 
have a listener.ora and use dynamic registration) 
One of the sys admins here instists that the following 
scenerio will not work. 
three nodes - two with one package each (containing Oracle) 
and one standby node. 
When the first package fails over to the standby node, it 
starts a listener using no listener.ora file, allowing the 
instances to dynamically register.  When the second package 
fails over to the standby node, it does not start a 
listener.  
All client tnsnames.ora files use package names for HOST. 
Do the instances in the second package register successfully 
with the listener and can clients connect to them? 
 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Enter any 11 digit prime number to continue. 

Re: DOS Script for pop up question ?

[Jared . Still]

> You could use utility "choice.exe" 

Well thank you Igor,  that brings back unpleasant memories
from years ago of writing length .BAT scripts with all the convoluted
logic that goes with it.  :)

Jared






"Igor Neyman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/11/2002 02:33 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: DOS Script for pop up question ?


You could use utility "choice.exe" (I think it comes with NT Resource 
Kit).
Here is an example of the batch file:

echo off
choice /c:YN Do you want to Continue ?
if errorlevel 2 goto end 

rem do whatever you need here
...
..
:end
echo End of processing.


Obviously "N" answer returns "errorlevel 2".


Igor Neyman, OCP DBA
[EMAIL PROTECTED]
 


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


> All,
> 
> I have a DOS batch file. In between this script, I
> would like to add user interactive question.
> 
> Ex: Do you want to Continue [Y/N]?
> 
> Once they hit "Y", it will continue rest of the batch
> file.
> 
> Could someone able to help me out as per the above
> requirement?
> 
> Thanks,
> Bob
> 
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bob Robert
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Error on aplication server HTTP..

[Mario Henley Becerril Geldis]

 Hi..


  I install application server for linux on a RH 7.3, but whe i try run
apachectl start this say:

  .../oradav/lib/mod_oradav.so into server: libclntsh.so.9.0: can't load 
shared object file: NO Such file or directory. 

  any ideas..???


  





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

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

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

[Reardon, Bruce (CALBBAY)]

David,
Have a look at the session_info column in v$logmnr_contents

This includes machine, terminal, osuser + OS program

Whether this will tell you what user logs in from which computer will depend-
eg do your users share usernames, do they have generic OS logins, do you have an app 
server, and so on

HTH,
Bruce Reardon

-Original Message-
Sent: Friday, 12 July 2002 9:58

Ramon,

I know how to setup LogMiner to run.  My question is if LogMiner can tell me
where an user is logging in from what computer?

Thanks,
David

-Original Message-
Sent: Thursday, July 11, 2002 4:15 PM

Nguyen,

1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
2) Create the dictonary file
Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
3) Reset the list and create a new one
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.new);
4) Add more redos to analyze
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.addfile);
5) Perform the analysis
Execute
DBMS_LOGMNR.START_LOGMNR(dictionary=>'d:\directorio\dictionary');
6) Do a select from the V$LOGMNR_CONTENTS

HTH
Ramon
- Original Message -
Sent: Thursday, July 11, 2002 12:48 PM

> Using LogMiner to read redo log, how do I tell a transaction is modified
by
> which user and where user logins from like what columns in LogMiner should
> tell me this kind of information?
>
> Thanks,
> David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

Re: How to?

[Joe Testa]

David, all you can get is whats in v$logmnr_contents.

so if session_info has anything worthwhile, you'd be good, otherwise out 
of luck, machine is not a field in v$logmnr_contents, its only part of 
v$session.

joe


Nguyen, David M wrote:

>Ramon,
>
>I know how to setup LogMiner to run.  My question is if LogMiner can tell me
>where an user is logging in from what computer?
>
>Thanks,
>David
>
>-Original Message-
>Sent: Thursday, July 11, 2002 4:15 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Nguyen,
>
>1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
>2) Create the dictonary file
>Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
>3) Reset the list and create a new one
>Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
>dbms_logmnr.new);
>4) Add more redos to analyze
>Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
>dbms_logmnr.addfile);
>5) Perform the analysis
>Execute
>DBMS_LOGMNR.START_LOGMNR(dictionary=>'d:\directorio\dictionary');
>6) Do a select from the V$LOGMNR_CONTENTS
>
>HTH
>
>Ramon
>
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, July 11, 2002 12:48 PM
>
>
>  
>
>>Using LogMiner to read redo log, how do I tell a transaction is modified
>>
>>
>by
>  
>
>>which user and where user logins from like what columns in LogMiner should
>>tell me this kind of information?
>>
>>Thanks,
>>David
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Nguyen, David M
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>>
>>
>
>  
>

-- 
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: listener configuration on HP serviceguard clusters

[Mandar A. Ghosalkar]

Title: listener configuration on HP serviceguard clusters



Matt,
 
i hv 2 
nodes in hp mc/sg non-ops config. each hving production instances. also each 
providing failover for other node.
 
:( 
7.3.4 on 10.2
 
each 
has it own listner listener_${ORACLE_SID}
 
Node 
1:
listener: LISTENER_SID1 on 1555
 
Node 
2:

listener: LISTENER_SID2 on 1556
 
We use package address(name) in the 
listener.ora
 
When failover happens for either node onto 
standby node, cant u start different listener for each failedover instance. 

 
hth
Mandar

  -Original Message-From: Adams, Matthew (GEA, MABG, 
  088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 11, 
  2002 2:15 PMTo: Multiple recipients of list 
  ORACLE-LSubject: listener configuration on HP serviceguard 
  clusters
  If anybody out there is using HP ServiceGuard for 
  non-OPS/RAC, I would be interested to know how you 
  configure the listeners.  Do you use the machine IP 
  address or the package address in the listener.ora (or 
  do you not have a listener.ora and use dynamic 
  registration) 
  One of the sys admins here instists that the following 
  scenerio will not work. 
  three nodes - two with one package each (containing 
  Oracle) and one standby node. 
  When the first package fails over to the standby node, it 
  starts a listener using no listener.ora file, allowing 
  the instances to dynamically register.  When the 
  second package fails over to the standby node, it does 
  not start a listener.  
  All client tnsnames.ora files use package names for 
  HOST. 
  Do the instances in the second package register successfully 
  with the listener and can clients connect to 
  them? 
   Matt Adams - GE Appliances - 
  [EMAIL PROTECTED] Enter any 11 digit prime number 
  to continue. 

RE: How to?

[Nguyen, David M]

Ramon,

I know how to setup LogMiner to run.  My question is if LogMiner can tell me
where an user is logging in from what computer?

Thanks,
David

-Original Message-
Sent: Thursday, July 11, 2002 4:15 PM
To: Multiple recipients of list ORACLE-L


Nguyen,

1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
2) Create the dictonary file
Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
3) Reset the list and create a new one
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.new);
4) Add more redos to analyze
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.addfile);
5) Perform the analysis
Execute
DBMS_LOGMNR.START_LOGMNR(dictionary=>'d:\directorio\dictionary');
6) Do a select from the V$LOGMNR_CONTENTS

HTH

Ramon



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:48 PM


> Using LogMiner to read redo log, how do I tell a transaction is modified
by
> which user and where user logins from like what columns in LogMiner should
> tell me this kind of information?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: DOS Script for pop up question ?

[Reardon, Bruce (CALBBAY)]

Bob,

Is it really a DOS batch file or is it 95 or NT4 or W2K / XP - or does it need to run 
on all of them?
This is important as the options vary.

Anyway, below is a copy of a post I made in March 2002 describing some of the options:

HTH,
Bruce Reardon

"In W2K it is easy, you can use set/p - type set/? to get the help and see below.
H:\>set/p  fred=[input value for fred]
[input value for fred]oracleis?

H:\>echo %fred%
oracleis?

H:\>


Or you can call sqlplus and have sqlplus do the prompting and then have it host out to 
the bat file and pass in the parameters.
Or you could Perl or a Unix emulator or I imagine their are many shareware / freeware 
utilities.

Under NT4 other options are not easy and I have listed a number of ways and links that 
show how you can achieve this:

Or from a Tom Lavedas posting on the newsgroup alt.msdos.batch.nt
(dated Tue, 05 Jun 2001 09:04:04 -0400  entitled "prompting for a parameter"
"
Old problem - batches were initially assumed to run unattended -
therefore, there was no need for user interaction.  However, in the
PC/Windows environment, they are useful for scripting many redundant
tasks, even some that require/benefit user interaction.
 
MS finally added recognized this fact by adding the /P (prompt)
functionality to the SET statement in Win 2000 (but not before that).
So, if you are in a pure Win 2000 environment, type SET/? at a command
prompt to get information on the use of the /P switch.
 
If you are using NT 4 or are in a mixed NT/2000 environment, there is no
'perfect' solution.  I have been interested in the subject of user input
for a long time and have developed and collected various techniques,
which I offer for your consideration:
 
1.  Get a third party utility like, Strings.com from PC Magazine,
(e.g. see ftp://ftp.zdnet.com/pcmag/1992/1222/strings.zip) -
recently reported to be broken in NT.  A third party utility is
probably the most viable solution for use in Win NT, though
AFAIK all of the little utilities out there were written for
the original DOS (pre-NT).  See http://www.Simtel.net
 
2.  Another NT approach, posted by Bennett Benson, is explained at
this link:  http://www.jsiinc.com/TIP0300/rh0323.htm
[this doesn't seem to be working as at 1-Mar-2002]
 
3.  Write a Win Script Host script using the InputBox function
(requires Win 98, Win NT 4.0, IE 5 or a free download from MS),
 
For example ...
 
  Dim Input
  Input = InputBox("Enter your name")
  MsgBox ("You entered: " & Input)
 
(see http://msdn.microsoft.com/scripting/default.htm to get
started)
 
4.  A variation on the theme of 3 above is a hybrid WSH script/batch
function
 
:: InWSH.bat - A WSH/Batch hybrid string input routine.
:: Requires Windows Script Host version 1.0 or later.
:: Use optional command line argument UCASE to convert
:: input to all uppercase or LCASE for lowercase.
:: With WSH V2+, EVAL allows math operations, as well.
:: Tom Lavedas <[EMAIL PROTECTED]>
:: http://www.pressroom.com/~tglbatch/
 @echo off
  Set _T=%temp%\~tmp
  echo Set oFS=CreateObject("Scripting.FileSystemObject")>%_T%.vbs
  Echo oFS.OpenTextFile("CON",2).Write "Enter a string: ">>%_T%.vbs
  echo S=%1(Trim(oFS.OpenTextFile("CON",1).Readline))>>%_T%.vbs
  echo Wscript.Echo "set Input="+CStr(S)>>%_T%.vbs
  cscript.exe //nologo %_T%.vbs > %_T%.bat
  for %%v in (%_T%.bat del) do call  %%v %_T%.???
  set _T=
  % For Example % echo You typed %Input%
 
  If you call this with a single command line parameter of Ucase or
  LCase, it will return the string input by the user in the
  appropriate case.  If you have WSH v5.1+ and use EVAL as the command
  line argument, it will do math operations as well, as in 
 
C:\> inwsh eval
Enter a string: 11 * 12
You typed 132
 
  This approach will work with Win 98 and Win 2000 and probably NT
  right out of the box.
 
5.  In Win2K the following works:
 
  SET /P variable=[promptString]
 
6. Finally, this NT specific approach, originally given by Walter
   Zachery, improved and supplied by Clay Calvert, 
 
  @echo off
  echo.
  echo Enter Input:
  for /f "tokens=*" %%a in (
'format/f:160 a: ^|find "..."') do set Input=%%a
  set Input=%Input:~30%
 
  This approach will spin the floppy drive, but won't change
  anything.  The drive does not need to be occupied.
---
 
Tom Lavedas http://www.pressroom.com/~tglbatch/
"


I have seen a web site showing how to do it using label (similar to the format 
command).
 
You Can also use choice command - available from 
ftp://ftp.microsoft.com/Services/TechNet/Windows/msdos/RESKIT/suppdisk/choice.com

And from another alt.msdos.batch.nt posting:
"
Date:   Tue, 20 Feb 2001 16:28:40 -0800 
...
Here's one way that will work in WinNT4.0.  If you are using Win2000,
you can use 'SET /P' instead.
 
==begin file C:\c

faster refreshes of Datamarts;Shareplex;ETL;Asynchronous Replication

[Mandar A. Ghosalkar]

Hello guys,

i was wondering if any of ull use Quest Shareplex for Datawarehouse ETL and/or 
Reporting instance.

i am creating a data mart/reporting instance. The source database is a 7.3.4 on HP-ux 
10.2

The destination(development) is 9i on Win2k. Still not figured out the platform for 9i 
(production).

1. has anyone used Shareplex to transfer logs from 7.3.4 to 9i on different platforms.
2. i havent worked with replication. are there sites which use readonly snapshots for 
creating reporting databases between different db versions. is it feasible and 
recommendable?
3. i am going to use direct path exp and also try to get exp compiled as single task. 
are there any success stories by making exp as single task.
4. The developers want to try out asynchronous replication on few of our large tables.

any tricks ull use to refresh reporting/datamarts having different versions. if the 
source had been 8/9 i would hv tried PEL or transportable tablespaces, but with 7.3.4 
as sources i am short of ideas.

TIA
Mandar

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

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

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

Function based indexes

[Imma C. Rocco]

Hi,
I have read that on Oracle 8.1.7 it is possible to create a function based index like 
the one: 
Create index ind1 on  (substr())
tabelspace etc
And if Oracle optimizer is in CBO mode and 
query_rewrite_enabled = true
query_rewrite_integrity = trusted
compatible = 8.1.0 or greater
A statement which has a where clause that involve a substr() should use 
the index.


(*)I would like to know if it is also possible to create a function 
based index on a NVL function that involve a bind variable, because 
a have a statement like the one that follow:
select 'x'
from 
where  = nvl(:p_aa, )

This statement perform a full table scan on 

ps: if (*) is possible could you please give an sintax example?

Thanks
Imma



_
Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads
and NoTaglines --> LYCOS MAIL PLUS.
http://www.mail.lycos.com/brandPage.shtml?pageId=plus 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Imma  C. Rocco
  INET: [EMAIL PROTECTED]

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

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

RE: killing sessions

[Post, Ethan]

I think the best thing to do is explain potential problems with this type of
access to the right people, document everyone's opinions in the matter then
give them what they want and do it smartly.  Create a way to kill sessions
from a menu or stored procedure that logs the actions etc...so you can blame
the right person when they kill the wrong session.  Of course it wouldn't be
too hard to exclude the background sessions from the list of possible
options. 

Ethan Post
perotdba (AIM), epost1 (Yahoo)



-Original Message-
Sent: Thursday, July 11, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L


It looks like job security :)

-Original Message-
Sent: Thursday, July 11, 2002 3:47 PM
To: Multiple recipients of list ORACLE-L


Joe,

Once you open this door, you will never get it closed.  Next they will want
to modify the table structures.

What are you going to do thie first time they kill an Oracle Background
session?

I agree with Dick.  Don't do it.  Make them call you.

Tom Mercadante
Oracle Certified Professional

-- 
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: Oracle 9.2 spfile catch 22

[Charlie Mengler]

I was migrating a V7.3.4.5 to V9.2 and the wizard does NOT create a
new initSID.ora which is R2 compliant; only a spfileSID.ora file. My 
solution was to write a simple SQL query which generated a spool file, 
initSID.ora, which contained the parameter name and values where the 
value was not the default value. This certainly saved my bacon.

"Deshpande, Kirti" wrote:
> 
> I would get the DB to function the way I want first using init.ora. Then
> switch to SPFILE from init.ora, while preserving a copy of working init.ora
> file.
> 
> Also, when a parameter is changed dynamically with SCOPE=both or spfile, I
> recreate my init.ora file as the backup.
> 
> SPFILE concept is good and it is required for reaching the goal of 'no dba
> required', but it is still far from being 'ready for prime time'.
> 
> I stopped using SPFILE with a couple of my databases when I was able to add
> db_cache_size to an spfile that already had db_block_buffers (two mutually
> exclusive parameters). The next restart of the DB failed. It was good that I
> had kept the init.ora file. I have not installed 9.2 yet, so I do now know
> if such things are verified beforehand and prevented.
> 
> HTH,
> 
> - Kirti
> 
> > -Original Message-
> > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, July 11, 2002 12:49 PM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Oracle 9.2 spfile catch 22
> >
> > Thanks to everyone for the ideas on the init.ora. You were correct that
> > the
> > answer is indeed with spfile. Now I have discovered a catch-22.
> >
> > Oracle 9.2, Solaris
> >
> > 1. If spfile is created with LOG_ARCHIVE_START = true,
> >   database will not start. Receive the error
> > ORA-00439 feature not enabled: Managed Standby
> > 2. Creating the spfile with LOG_ARCHIVE_START = false works and the
> > database
> > starts. Issuing
> >   ALTER SYSTEM ARCHIVE LOG START
> > works, but it isn't changed in the spfile, so the next time Oracle is
> > bounced, the archiver doesn't start.
> >
> > This is starting to smell like a bug, but I thought I'd run it past the
> > list
> > on the off-chance someone else has gotten archiving turned on for 9.2.
> > Thanks.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: 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).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: Replicating a user across DBs

[DENNIS WILLIAMS]

Rich - I have been very busy today, so I'm probably not reading something
correctly. If you have a user schema in one database, you must manually
create that userid in the other database, but then you can use export to
move all the objects to the other database. Import will create the objects
if they don't exist. Hopefully that responds to your question, but I
apologize if I haven't read it correctly.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, July 11, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Hey all,

In 8.1.7, is there a way to easily replicate a user from one DB (e.g.
"development") to another (e.g. "production")?  I can export all the objects
in the schema, but export/import won't recreate the schema in the import DB.

I've been using OEM to create a script (reverse engineered from "Create
like..."), but the resulting script requires editing and the assignment of a
resource plan doesn't always play nice, either.

There has got to be a better way...

TIA!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Replicating a user across DBs

[Jesse, Rich]

Well, almost.  Yes, that's what I want to do.  It's the manual recreate of
the user that bugs me.  Perhaps I shouldn't have used the word
"replicate"...

The thing that gets me is under 8i, there's no easy way to "GRANT SELECT ON
schema_a.table TO schema_b" from a DBA account.  I've been using a
(undocumented?) procedure called DMBS_SYS_SQL.PARSE_AS_USER to get the job
done (thanks to Kevin Percival!), but I was hoping someone had streamlined
this trainwreck of a manual procedure.

Thanks, but I'm off to a suite Miller Park to drink beer and break the fan
boycott.  Hey, I'm not that much of a baseball fan anyway, and it's still
over a month until Lord Football rises to his Autumnal Throne.  ;D

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

> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 3:46 PM
> To: '[EMAIL PROTECTED]'
> Cc: Jesse, Rich
> Subject: RE: Replicating a user across DBs
> 
> 
> Rich - I have been very busy today, so I'm probably not 
> reading something
> correctly. If you have a user schema in one database, you 
> must manually
> create that userid in the other database, but then you can 
> use export to
> move all the objects to the other database. Import will 
> create the objects
> if they don't exist. Hopefully that responds to your question, but I
> apologize if I haven't read it correctly.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Replicating a user across DBs
> 
> 
> Hey all,
> 
> In 8.1.7, is there a way to easily replicate a user from one DB (e.g.
> "development") to another (e.g. "production")?  I can export 
> all the objects
> in the schema, but export/import won't recreate the schema in 
> the import DB.
> 
> I've been using OEM to create a script (reverse engineered 
> from "Create
> like..."), but the resulting script requires editing and the 
> assignment of a
> resource plan doesn't always play nice, either.
> 
> There has got to be a better way...
> 
> TIA!
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
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: DOS Script for pop up question ?

[James J. Morrow]

Bob Robert wrote:
> 
> All,
> 
> I have a DOS batch file. In between this script, I
> would like to add user interactive question.
> 
> Ex: Do you want to Continue [Y/N]?
> 
> Once they hit "Y", it will continue rest of the batch
> file.
> 
> Could someone able to help me out as per the above
> requirement?
> 
> Thanks,
> Bob

Well, the simplest answer would be to use the "Pause" command.  This assumes, of
course, that you don't really care what key they press...
simply:

echo "Hit Control-C to abort or..."
pause

Will return:

"Hit Control-C to abort or..."
"Press any key to continue"

I'm pretty sure that the DOS "batch" language doesn't have any "get keystroke"
functionality built-in.  However, the "CMD" language might.

A search on google for "dos cmd batch get"
(http://www.google.com/search?sourceid=navclient&q=dos+cmd+batch+get) yields
this link:

http://www.simtel.iif.hu/pub/msdos/batchutl/

Which has a whole slew of MS-DOS based utilities.  I'm sure one of them would
have a little *.exe that would read a line or a character from stdin.

Additionally, you could consider "Cygnus for Windows" (aka "Cygwin") available
through redhat.com.  Cygwin is a Windows tool that gives you Unix
functionality.  Including some of the popular unix shells for scripting (Bash,
Tcsh).  This product (free, as in beer) provides the same functionality as the
(much more expensive) MKS Toolkit (available from MKS Software...
http://www.mks.com).  The MKS toolkit is required for Oracle Applications 11i on
MS Windows NT/2000.  

http://freshmeat.net/projects/cygwin/?topic_id=45%2C74
or
http://cygwin.com

-- James

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
McKinney, TX, USA

"The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man."  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

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

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

Re: Buffer busy waits are 10.96% of non-idle waits

[Kavitha Muthukumaren]

Hi ,

TOAD gives this alarm often. what does it mean ? which view will
give me the wait statistics ?

Answer :
==
Please run STATSPACK to if this is one of the top waitevents to
check if the percentage of wait - can be treated as problematic one

 SELECT p1 "File", p2 "Block", p3 "Reason"
FROM v$session_wait
   WHERE event='buffer busy waits'
Repeatedly run the above statement and collect the output. After a period
of time sort the results to see which file & blocks are showing
contention:


" it occurs when a session cannot access a block because it is in
use by another session. The two most common causes are
insufficient free lists for a table or insufficient rollback
segments. "  --- IS THIS THE REASON ?

Answer:
==
  Yes on top of  the wait event could also occur
 could also occur  if

a. if the application is going against a set of same blocks (hot blocks)

Thanks,
Kavi



oraora oraora wrote:

> Guys,
>
> " Buffer busy waits are 10.96% of non-idle waits "
>
> TOAD gives this alarm often. what does it mean ? which view will
> give me the wait statistics ?
>
> " it occurs when a session cannot access a block because it is in
> use by another session. The two most common causes are
> insufficient free lists for a table or insufficient rollback
> segments. "  --- IS THIS THE REASON ?
>
> what should be the value of this , i mean , the safe limits ?
>
> How do i approach and solve this issue ?
> kindly enlighten me.
>
> TIA.
> _
> There is always a better job for you at Monsterindia.com.
> Go now http://monsterindia.rediff.com/jobs
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:;Kavitha
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Kavitha Muthukumaren
end:vcard

Re: DOS Script for pop up question ?

[Igor Neyman]

You could use utility "choice.exe" (I think it comes with NT Resource Kit).
Here is an example of the batch file:

echo off
choice /c:YN Do you want to Continue ?
if errorlevel 2 goto end 

rem do whatever you need here
...
..
:end
echo End of processing.


Obviously "N" answer returns "errorlevel 2".


Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


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


> All,
> 
> I have a DOS batch file. In between this script, I
> would like to add user interactive question.
> 
> Ex: Do you want to Continue [Y/N]?
> 
> Once they hit "Y", it will continue rest of the batch
> file.
> 
> Could someone able to help me out as per the above
> requirement?
> 
> Thanks,
> Bob
> 
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bob Robert
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re:PL/Sql Error Handling Package

[dgoulet]

Hanah,

This is one procedure out of an entire package, but it works for us.

procedure oracle_err(message in varchar2, status out number, mailing_list in
varchar2 default 'NONE' ) is
   file_hndl utl_file.file_type;
   luser varchar2(40);
   sname varchar2(40);
   sn varchar2(7);
   fname varchar2(40);
   err_date varchar2(20);
   begin
   status := sqlcode;
   if(status < 0) then 
  select user, name, to_char(err_file_sqnc.nextval),
to_char(sysdate,'DD-MON- HH24:MI')
  into luser, sname, sn, err_date
  from oracle_server;
  fname := 'oracle'||sn||'.err';
  file_hndl := utl_file.fopen(utl_home,fname,'a');
  utl_file.putf(file_hndl, 'Oracle Error Report from %s\n%s\n', sname,
err_date);
  utl_file.putf(file_hndl, 'Error: %s\nLocation: %s', sqlerrm, message);
  utl_file.fflush(file_hndl);
  utl_file.fclose(file_hndl);
  rollback;
  if(mailing_list != 'NONE') then
cron_mail_list(mailing_list, fname, 'Oracle Procedure Error');
  end if;
   end if;
   end;

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/11/2002 12:52 PM

Amy one have any decent stanard error handling packages or link to advice on
creating such a  package?

Thanks,

Hannah
-- 
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: 
  INET: [EMAIL PROTECTED]

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

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

[Ramon E. Estevez]

Nguyen,

1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
2) Create the dictonary file
Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
3) Reset the list and create a new one
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.new);
4) Add more redos to analyze
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.addfile);
5) Perform the analysis
Execute
DBMS_LOGMNR.START_LOGMNR(dictionary=>'d:\directorio\dictionary');
6) Do a select from the V$LOGMNR_CONTENTS

HTH

Ramon



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:48 PM


> Using LogMiner to read redo log, how do I tell a transaction is modified
by
> which user and where user logins from like what columns in LogMiner should
> tell me this kind of information?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re:RE: larry want to take over your e-mai

[dgoulet]

Hannah,

Friday is tomorrow, settle down everything will be all right.  It's just his
Bill complex showing through, you know that MicroSoft mantra, "We will be
everything to everyone."  I'm still waiting for that piece of Windows software
that insures my coffee cup remains full.  At least the Oracle based one I
developed warns me when it's half full and does not GPF in the process. :-)

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/11/2002 9:18 AM

THAT DOES IT.  I am starting training on DB2 right away (Yeah - I can actually
AFFORD to no $2000 requirements!!).  I want a DB that KNOWS its a DB and not
an all-purpose quagmire of inter-related but not really related junk just
because Larry has a Bill complex!

Oracle and CHEAP cannot be used in the same sentence!  Must have been a
misquote...surpised they dont need a 5000 named user license!


Argh.. mental meltdown in process.  One... two deep breath Is it
Friday yet?

Hannah




-- 
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: 
  INET: [EMAIL PROTECTED]

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

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

listener configuration on HP serviceguard clusters

[Adams, Matthew (GEA, MABG, 088130)]

Title: listener configuration on HP serviceguard clusters





If anybody out there is using HP ServiceGuard for
non-OPS/RAC, I would be interested to know how you
configure the listeners.  Do you use the machine IP address
or the package address in the listener.ora (or do you not 
have a listener.ora and use dynamic registration)


One of the sys admins here instists that the following
scenerio will not work.


three nodes - two with one package each (containing Oracle)
and one standby node.


When the first package fails over to the standby node, it 
starts a listener using no listener.ora file, allowing the
instances to dynamically register.  When the second package
fails over to the standby node, it does not start a
listener.  


All client tnsnames.ora files use package names for HOST.


Do the instances in the second package register successfully 
with the listener and can clients connect to them?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Enter any 11 digit prime number to continue.

Re: connect as internal

[Kavitha Muthukumaren]

Hi Mitchell,

what is different  between those 3 login

1. sqlplus system login, connect as internal
Answer:
  when you are doing this you are user 'sys'
  because you have changed from system to being
  'internal'
   connect internal - technically is user 'sys', and is the way
  of authenticating to the database

2. sqlplus system/manager login
  Answer:
  when you are doing this you are user 'system'


3. sqlplus system login , connect system as sysdba
  Answer:
when you are doing this you are user 'system'
you have given 'system' sysdba privilege ( which
'system' can perform everything which is allowed for
sysdba privilege + on-top of the privileges that it already has)
importantly by logging this way 'system' can never be
   equal to 'connect internal'

Thanks,
Kavi


mitchell wrote:

> Hi
>
> I just view readme about installing Oracle Patch on Oralce 8.1.6
>
> One thing mentioned as Invoke sqlplus, connect as internal  and
> run
> catalog
> catproc
> etc ..
>
> I wonder why Connect as internal.
>
> what is different  between those 3 login
>
> 1. sqlplus system login, connect as internal
> 2. sqlplus system/manager login
> 3. sqlplus system login , connect system as sysdba
>
> Thanks in advance
>
> Mitchell
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mitchell
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:;Kavitha
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Kavitha Muthukumaren
end:vcard

Re:DOS Script for pop up question ?

[dgoulet]

Bob,

A little off topic, but whatever.  Try WinBatch from  WilsonWare
(http://www.winbatch.com/).  A very nice product that allows you to do the alert
boxes and a whole lot more.  Not too expensive either.

Dick Goulet

Reply Separator
Author: Bob Robert <[EMAIL PROTECTED]>
Date:   7/11/2002 12:37 PM

All,

I have a DOS batch file. In between this script, I
would like to add user interactive question.

Ex: Do you want to Continue [Y/N]?

Once they hit "Y", it will continue rest of the batch
file.

Could someone able to help me out as per the above
requirement?

Thanks,
Bob



__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Robert
  INET: [EMAIL PROTECTED]

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

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

PL/Sql Error Handling Package

[johanna . doran]

Amy one have any decent stanard error handling packages or link to advice on creating 
such a  package?

Thanks,

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

Replicating a user across DBs

[Jesse, Rich]

Hey all,

In 8.1.7, is there a way to easily replicate a user from one DB (e.g.
"development") to another (e.g. "production")?  I can export all the objects
in the schema, but export/import won't recreate the schema in the import DB.

I've been using OEM to create a script (reverse engineered from "Create
like..."), but the resulting script requires editing and the assignment of a
resource plan doesn't always play nice, either.

There has got to be a better way...

TIA!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: Active sql

[Ramon E. Estevez]

Thanks very much Jamadagni,

It works fine.

Another question, I issued a huge select, ran the script and it appeared.  I
cancelled the select
and it still showed up in the result script like for more than 3 minutes,
exited the session and
dissapeared.

Is this the normal behavior ??

Tks I am satisfied with the solution.

Ramon




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 1:00 PM


> decode(kglobtyp,0,'CURSOR',7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE',
> 11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY','OTHER')
>
> Raj
> __
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -Original Message-
> Sent: Thursday, July 11, 2002 1:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Jamadagni,
>
> Tks for the help.
>
> After creating the xviews it worked fine for function, packages,
procedures.
>
> I want to include SQL statements also.  Was checking
> but just return numbers, that explain the decode.
>
> select distinct kglobtyp from X_$KGLOB
>
>   KGLOBTYP
> --
>  0
>  1
>  2
>  3
>  4
>  5
>  6
>  7
>  8
>  9
> 10
>
>
> What is the number for SQL statements ??? or
>
> Which one is the table of description for the numbers in the X_$KGLOB view
?
>
> TIA
>
> Ramon
>
>
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 3:26 PM
>
>
> > http://www.ixora.com.au/scripts/sql/create_xviews.sql
> >
> > Raj
> > __
> > Rajendra Jamadagni MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> >
> > -Original Message-
> > Sent: Wednesday, July 03, 2002 3:44 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Jamadagni
> >
> > I am getting an error
> >
> >   sys.X_$KSUSE  s
> >   *
> > ERROR at line 12:
> > ORA-00942: table or view does not exist
> >
> > Tested on 8.1.7 and 9.0.1 and the same error.
> >
> > What script should I run to create that table or view ?
> >
> > TIA
> >
> > Ramon
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 03, 2002 1:13 PM
> >
> >
> > > prompt  Currently Executing Packages 
> > > SELECT
> > >   substr(DECODE(o.kglobtyp,
> > > 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13,
> > > 'CLASS'),1,15)  "TYPE",
> > >   substr(o.kglnaown,1,30)  "OWNER",
> > >   substr(o.kglnaobj,1,30)  "NAME",
> > >   s.indx  "SID",
> > >   s.ksuseser  "SERIAL"
> > > FROM
> > >   sys.X_$KGLOB  o,
> > >   sys.X_$KGLPN  p,
> > >   sys.X_$KSUSE  s
> > > WHERE
> > >   o.inst_id = USERENV('Instance') AND
> > >   p.inst_id = USERENV('Instance') AND
> > >   s.inst_id = USERENV('Instance') AND
> > >   o.kglhdpmd = 2 AND
> > >   o.kglobtyp IN (7, 8, 9, 12, 13) AND
> > >   p.kglpnhdl = o.kglhdadr AND
> > >   s.addr = p.kglpnses
> > > ORDER BY 1, 2, 3
> > > /
> > >
> > >
> > > Courtsy of Steve Adams.
> > >
> > > Raj
> > > __
> > > Rajendra Jamadagni  MIS, ESPN Inc.
> > > Rajendra dot Jamadagni at ESPN dot com
> > > Any opinion expressed here is personal and doesn't reflect that of
ESPN
> > Inc.
> > >
> > > QOTD: Any clod can have facts, but having an opinion is an art!
> > >
> > > -Original Message-
> > > Sent: Wednesday, July 03, 2002 11:39 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi gurus,
> > >
> > > Is there any way to know which SQL statement or procedure or package
is
> > > running actually.
> > >
> > > I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get
> the
> > > statement, the user but this process had already finished, it was just
> in
> > > the SGA.
> > >
> > > What I want to know is who is actually running something in the DB.
> > >
> > > TIA
> > >
> > >
> > > Ramon E. Estevez
> > > [EMAIL PROTECTED]
> > > 809-565-3121
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ramon E. Estevez
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containi

RE: OT - Oracle U. defends OCP title

[Khedr, Waleed]

I think this will be very competitive!

-Original Message-
Sent: Thursday, July 11, 2002 4:31 PM
To: Multiple recipients of list ORACLE-L


>From when MS started offering ORACLE Certified Professional exams :-)

"Khedr, Waleed" <[EMAIL PROTECTED]> wrote:

>I will take my OCP from MS!
>
>-Original Message-
>Sent: Thursday, July 11, 2002 2:39 PM
>To: Multiple recipients of list ORACLE-L
>
>
>http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci8379
6
>4,00.html
>
>
>JP
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Jan Pruner
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Khedr, Waleed
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


__
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.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

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

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

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

Re[2]:killing sessions

[dgoulet]

Well, without getting into specifics.  We had an individual who had a "problem"
with others in the department.  Now you & I know that many times in development
we create monsters.  That's what the environment is for after all, create what
you think the user wanted & see how badly it behaves.  Well this person's
solution to the problem was to kill off other sessions that were viewed as
resource hogs.  Nuf Said??

Dick Goulet

Reply Separator
Author: Jack Silvey <[EMAIL PROTECTED]>
Date:   7/11/2002 11:46 AM

Dick,

interesting. tell us why it was such a mess.

regards,

jack


--- [EMAIL PROTECTED] wrote:
> NO, they want their session killed, then they can
> call.  I did allow this a few
> years ago.  It turned into a real mess, PERIOD.
> 
> Dick Goulet
> 
> Reply
> Separator
> Author: Joe Armstrong-Champ
> <[EMAIL PROTECTED]>
> Date:   7/11/2002 10:51 AM
> 
> We have developers who occassionally want to be able
> to kill their
> sessions in a dev instance. We are concerned about
> giving them alter
> system priviledge and were wondering what people do
> about this. Is there
> any other way they can do this? Do some shops allow
> certain users to do
> this with some training? 
> 
> Thanks.
> Joe 
> 
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Joe Armstrong-Champ
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

[Deshpande, Kirti]

I would get the DB to function the way I want first using init.ora. Then
switch to SPFILE from init.ora, while preserving a copy of working init.ora
file. 

Also, when a parameter is changed dynamically with SCOPE=both or spfile, I
recreate my init.ora file as the backup. 

SPFILE concept is good and it is required for reaching the goal of 'no dba
required', but it is still far from being 'ready for prime time'. 

I stopped using SPFILE with a couple of my databases when I was able to add
db_cache_size to an spfile that already had db_block_buffers (two mutually
exclusive parameters). The next restart of the DB failed. It was good that I
had kept the init.ora file. I have not installed 9.2 yet, so I do now know
if such things are verified beforehand and prevented. 

HTH,

- Kirti 

> -Original Message-
> From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle 9.2 spfile catch 22
> 
> Thanks to everyone for the ideas on the init.ora. You were correct that
> the
> answer is indeed with spfile. Now I have discovered a catch-22.
> 
> Oracle 9.2, Solaris
> 
> 1. If spfile is created with LOG_ARCHIVE_START = true,
>   database will not start. Receive the error
> ORA-00439 feature not enabled: Managed Standby
> 2. Creating the spfile with LOG_ARCHIVE_START = false works and the
> database
> starts. Issuing 
>   ALTER SYSTEM ARCHIVE LOG START 
> works, but it isn't changed in the spfile, so the next time Oracle is
> bounced, the archiver doesn't start.
> 
> This is starting to smell like a bug, but I thought I'd run it past the
> list
> on the off-chance someone else has gotten archiving turned on for 9.2.
> Thanks.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

DOS Script for pop up question ?

[Bob Robert]

All,

I have a DOS batch file. In between this script, I
would like to add user interactive question.

Ex: Do you want to Continue [Y/N]?

Once they hit "Y", it will continue rest of the batch
file.

Could someone able to help me out as per the above
requirement?

Thanks,
Bob



__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Robert
  INET: [EMAIL PROTECTED]

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

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

[csp2201]

>From when MS started offering ORACLE Certified Professional exams :-)

"Khedr, Waleed" <[EMAIL PROTECTED]> wrote:

>I will take my OCP from MS!
>
>-Original Message-
>Sent: Thursday, July 11, 2002 2:39 PM
>To: Multiple recipients of list ORACLE-L
>
>
>http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci83796
>4,00.html
>
>
>JP
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Jan Pruner
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Khedr, Waleed
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


__
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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

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

RE: killing sessions

[Khedr, Waleed]

It looks like job security :)

-Original Message-
Sent: Thursday, July 11, 2002 3:47 PM
To: Multiple recipients of list ORACLE-L


Joe,

Once you open this door, you will never get it closed.  Next they will want
to modify the table structures.

What are you going to do thie first time they kill an Oracle Background
session?

I agree with Dick.  Don't do it.  Make them call you.

Tom Mercadante
Oracle Certified Professional


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


We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

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

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

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

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

RE: Plagiarism?

[Grabowy, Chris]

searchdatabase link points to non existent page.  Did they pull it??

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


http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.html

http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql

Humm...my money is on Steve as the original author.

- Ethan
-- 
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: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

RE: Plagiarism?

[Cary Millsap]

Looks like the searchdatabase copy has disappeared already.

Not many things in this life are certain, but I'll guarantee you one
thing: if there's a script at Ixora with Steve Adams' name on it, then
that script was written by Steve Adams. 


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

Upcoming events:
- Hotsos Clinic, Jul 23-25 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Ethan
Sent: Thursday, July 11, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.htm
l

http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql

Humm...my money is on Steve as the original author.

- Ethan
-- 
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: Cary Millsap
  INET: [EMAIL PROTECTED]

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

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

RE: killing sessions

[Mercadante, Thomas F]

Joe,

Once you open this door, you will never get it closed.  Next they will want
to modify the table structures.

What are you going to do thie first time they kill an Oracle Background
session?

I agree with Dick.  Don't do it.  Make them call you.

Tom Mercadante
Oracle Certified Professional


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


We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

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

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

How to sort these values 'correctly?' 1.1..1, 1.1..2, 1.1..13

[Jay Weinshenker]

So imagine I have this series of numbers
1.1
1.1..1
1.1..13
1.1..2
1.1..3
and I want them to sort like a human would sort them

1.1
1.1..1
1.1..2
1.1..3
1.1..7
1.1..13
Anyone have sql to accomplish this?

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

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

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

Re:killing sessions

[Jack Silvey]

Dick,

interesting. tell us why it was such a mess.

regards,

jack


--- [EMAIL PROTECTED] wrote:
> NO, they want their session killed, then they can
> call.  I did allow this a few
> years ago.  It turned into a real mess, PERIOD.
> 
> Dick Goulet
> 
> Reply
> Separator
> Author: Joe Armstrong-Champ
> <[EMAIL PROTECTED]>
> Date:   7/11/2002 10:51 AM
> 
> We have developers who occassionally want to be able
> to kill their
> sessions in a dev instance. We are concerned about
> giving them alter
> system priviledge and were wondering what people do
> about this. Is there
> any other way they can do this? Do some shops allow
> certain users to do
> this with some training? 
> 
> Thanks.
> Joe 
> 
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Joe Armstrong-Champ
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

killing sessions

[JOE TESTA]

Not sure of your experience with pl/sql but how about this:
 
 
a stored procedure, takes 2 parms, serial and sid.
 
validation in the stored proc matches the logged in user against the 
username in v$session.
 
if the names match, dynamic sql(ddl) to do the alter command to kill the 
session.
 
I've done this in the past but its been about 7 years ago.
 
joe
 

RE: killing sessions

[Rodrigues, Bryan]

If your environment is mts be very careful about killing sessions. In some
cases the killed session does not die until the instance is stopped and
started.

Bryan Rodrigues
DBA
Elcom Inc.

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


We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

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

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

Plagiarism?

[Post, Ethan]

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.html

http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql

Humm...my money is on Steve as the original author.

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

ORA 4031 Error Occuring With Large shared_pool_size = 200 MB

[VIVEK_SHARMA]

At a production Site Following Error Occuring many Times Daily 
Now the init ora parameters are according to what was suggested. the Shared pool is 
200M. Still we are getting the following error:
Message : 002: DATABASE ERROR - sqlcode = [-] Operation: [S]
Message - [scr_udf.cxx,3508](OCI:ofen):[-18]:Error during record fetch,(ORA-0403
1: unable to allocate 4176 bytes of shared memory ("shared pool","unknown object
","sga heap","library cache"))
Oracle 8.1.7.2.0
AIX 5.1
Machine eServer P690 regatta

Qs What could be the Solutions to the Above ? 
Could this be BUG Number 1397603  Fixed in some Higher Patch Version ?

Seemingly Setting _db_handles_cached to 1 from the default Value of  5  is a 
Workaround .
_db_handles_cached  = Buffer handles cached each process

Question - Is the parameter Safe to Set ? 
Once Set , while unsetting the Same is there anything that needs to be Done ?

NOTE - 
NO Trace Files Dumped in the USER_DUMP_DEST & BACKGROUND_DUMP_DEST
NO Error messages in alert_$SID.log
cursor_sharing=EXACT

Thanks

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

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

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

[Khedr, Waleed]

I will take my OCP from MS!

-Original Message-
Sent: Thursday, July 11, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci83796
4,00.html


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

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

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

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

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

Re: runInstaller - ruinInstaller? RUINstaller?

[Eric D. Pierce]

On 11 Jul 2002 at 0:43, Don Granaman wrote:

Date sent:  Thu, 11 Jul 2002 00:43:18 -0800
RUINstaller?
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>

> There have been times when I would have paid extra for ...
>  (2) a reliable and consistent way to create a listing of
> EXACTLY what was installed (e.g. the long-defunct "instver").


Don't know about "reliability", but I did see an 
option in the 8.1.7 installer that generates a huge 
file containing details about each oracle component 
that is installed.

after starting the installer, click:

"installed products | save as"

here is what it looks like:


> INVENTORY CONTENTS OF (deleted machine name/ip#):
> 
>   Independent Products
> Oracle Universal Installer 1.7.1.9.0
>   Java Runtime Environment 1.1.7.30
> Oracle Remote Configuration Agent 8.1.7.0.0
>   OraNT817
> Oracle8i Enterprise Edition 8.1.7.0.0
>   Oracle8i Server 8.1.7.0.0
> Net8 Server 8.1.7.0.0
>   Net8 Client 8.1.7.0.0
> Assistant Common Files 8.1.7.0.0
>   Required Support Files 8.1.7.0.0
> Net8 Required Support Files 8.1.7.0.0
> NLS Required Support Files 8.1.7.0.0
> Oracle Core Required Support Files 8.1.7.0.0
> Platform Required Support Files 8.1.7.0.0
> PL/SQL Required Support Files 8.1.7.0.0
> Precompiler Required Support Files 8.1.7.0.0
> Parser Generator Required Support Files 8.1.7.0.0
> SSL Required Support Files 8.1.7.0.0
> Agent Required Support Files 8.1.7.0.0
> Oracle Client Required Support Files 8.1.7.0.0
> Oracle Trace Required Support Files 8.1.7.0.0
> RDBMS Required Support Files 8.1.7.0.0
> LDAP Required Support Files 8.1.7.0.0
>{Java Runtime Environment 1.1.7.30} 
>   Oracle help For Java 3.1.8.0.0a
> Extended Windowing Toolkit 3.3.6.0.0a
> Net8 Assistant 8.1.7.0.0
>   Net8 Configuration Assistant 8.1.7.0.0
> Assistant Common Files 8.1.7.0.0
>   Required Support Files 8.1.7.0.0
> Net8 Required Support Files 8.1.7.0.0
> NLS Required Support Files 8.1.7.0.0
> Oracle Core Required Support Files 8.1.7.0.0
> Platform Required Support Files 8.1.7.0.0
> PL/SQL Required Support Files 8.1.7.0.0
> Precompiler Required Support Files 8.1.7.0.0
> Parser Generator Required Support Files 8.1.7.0.0
> SSL Required Support Files 8.1.7.0.0
> Agent Required Support Files 8.1.7.0.0
> Oracle Client Required Support Files 8.1.7.0.0
> Oracle Trace Required Support Files 8.1.7.0.0
> RDBMS Required Support Files 8.1.7.0.0
> LDAP Required Support Files 8.1.7.0.0
>{Java Runtime Environment 1.1.7.30} 
>   Oracle help For Java 3.1.8.0.0a
> Extended Windowing Toolkit 3.3.6.0.0a
>   Assistant Common Files 8.1.7.0.0

...



regards,
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: Enqueue deadlock

[Jared . Still]

You can't really avoid them, unless of course your database is down.

If what you really mean is that you're application is frequently waiting 
on enqueue locks, then you need to find out why that is happening.

A common reason is that foreign keys are created without supporting
indexes.  Another reason is poor locking strategy.  e.g. different 
sections
of the code are locking the same tables in different orders. 

Yet another reason is a poorly designed application that locks table
row(s) for update during user think time ( or lunch time ). 

HTH

Jared





"Shishir Kumar Mishra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/11/2002 04:43 AM
Please respond to ORACLE-L

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


Hi !
 How to avoid  enqueue locks ?
 
 
regards... 
Shishir Kumar Mishra
Agni Software (P) Ltd.
www.agnisoft.com
--
Vidya Dadaati Viniyam
--
 
 


-- 
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: killing sessions

[Jesse, Rich]

Nope.  Not a chance.  Although you could make a small app/procedure that
would help prevent them from making a mistake and killing off the wrong
process, audit the process, and execute it through another schema that would
have the privs.

HTH!  GL!  :)

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


> -Original Message-
> From: Joe Armstrong-Champ [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 1:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: killing sessions
> 
> 
> We have developers who occassionally want to be able to kill their
> sessions in a dev instance. We are concerned about giving them alter
> system priviledge and were wondering what people do about 
> this. Is there
> any other way they can do this? Do some shops allow certain 
> users to do
> this with some training? 
> 
> Thanks.
> Joe 
-- 
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:killing sessions

[dgoulet]

NO, they want their session killed, then they can call.  I did allow this a few
years ago.  It turned into a real mess, PERIOD.

Dick Goulet

Reply Separator
Author: Joe Armstrong-Champ <[EMAIL PROTECTED]>
Date:   7/11/2002 10:51 AM

We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

[Ji, Richard]

You can write a stored procedure that does the kill of a session
and grant them execute only privilege to the stored procedure.

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


We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

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

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

Re: sequential reads/scattered reads

[Jared . Still]

Are you actually experiencing a performance problem?

Are users complaining? 

If not, then don't worry about it, find something else to do.  :)

If so, ( and this has already been stated to you I think ) check
the wait times, don't worry about doing a lot of I/O. 

If you don't know how to check the wait times, there have been
a number of web sites and papers already suggested.  I'm just
chiming in to help impress on you that there are a lot of misconceptions
about tuning.

RAID 5 is fine for some databases.  If you're doing mostly reads, it's
actually pretty good.

Jared





"oraora  oraora" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/11/2002 04:33 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:sequential reads/scattered reads


Guys,

Querying my v$session_wait shows 10 rows each DB FILE SEQUENTIAL 
READ and DB FILE SCATTERED READ.

manuals explain it all b'coz of I/O.

there are 33 tables and 110 indexes in the same USERS tablespace 
with only one datafile USERS01.DAT of size 12GB.

it's physically laid out in D:\oracle\data.
but the hard disk capacity is 100GB with 8 disk heads and RAID5.

will not moving the tables and indexes to seperate tablespace 
reduce I/O traffic ? my manager here says that since it is 
configured with RAID5 and 8 disk heads , it's not a problem.

is it so ? is he right ?
plz. clarify me. i need to explain him.
it's urgent.he is sitting on my head.

TIA.
_
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs

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

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

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

[Igor Neyman]

Dennis,

Did you specify "scope=both" when running "alter system "?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 1:48 PM


> Thanks to everyone for the ideas on the init.ora. You were correct that
the
> answer is indeed with spfile. Now I have discovered a catch-22.
>
> Oracle 9.2, Solaris
>
> 1. If spfile is created with LOG_ARCHIVE_START = true,
> database will not start. Receive the error
> ORA-00439 feature not enabled: Managed Standby
> 2. Creating the spfile with LOG_ARCHIVE_START = false works and the
database
> starts. Issuing
> ALTER SYSTEM ARCHIVE LOG START
> works, but it isn't changed in the spfile, so the next time Oracle is
> bounced, the archiver doesn't start.
>
> This is starting to smell like a bug, but I thought I'd run it past the
list
> on the off-chance someone else has gotten archiving turned on for 9.2.
> Thanks.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

killing sessions

[Joe Armstrong-Champ]

We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training? 

Thanks.
Joe 

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

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

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

[Jan Pruner]

http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci837964,00.html


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

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

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

More on the OCP priceing

[Ron Rogers]

List,
 Received this from the searchdatabase.com site about Oracle defending
the OCP pricing.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LEAD STORY

ORACLE U. DEFENDS OCP TITLE | SearchDatabase
Defending their new DBA certification requirement against critics who
say it's costly and unnecessary, Oracle described the move as part of
a new strategy to ensure that only top-shelf candidates receive the
company's stamp of approval. 

For the full details, click:
http://www.searchdatabase.com/originalContent/0,289142,sid13_gci837964,00.html


FOR MORE INFORMATION:

Check out our Featured Topic on database certifications:
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci754839,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Interesting read
ROR mª¿ªm
--
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: Oracle Warehouse Builder

[BALA,PRAKASH (Non-HP-USA,ex1)]

Kevin,

In terms of functionality, it's good. But since it is Java based, you need
256MB+ on your desktop/laptop for it to run properly. You also need the
Oracle Gateway if you want OWB to access non-Oracle databases.

HTH!

Prakash

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


Top of the Morning!

I've been tasked by my boss's PHB with performing a pro/con evaluation of
Oracle Warehouse Builder without having the benefit of actually installing
or using the product. 

I would greatly appreciate hearing about any real-world experience Warehouse
Builder -- both pro & con.

TIA
Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




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

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

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

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

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

RE: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Sof

[BALA,PRAKASH (Non-HP-USA,ex1)]

Vivek,

Per my understanding from Tuning 101 book, your 2nd option is better.

Check out this white paper from Gaja:

http://www.quest.com/whitepapers/Raid1.pdf

Prakash

-Original Message-
Sent: Thursday, July 11, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L
Software Raid 1 ?



For performance , Which Option is better :-

Given 6 Internal FCAL Hard Disks ?
1) Creating 1 Volume with Software RAID 1+0 OR 
2) Creating 3 Volumes of Software RAID 1 , Each Volume Containing 2 Disks &
Manually Spreading the Database 
across the 3 Volumes ?

Solaris 8
Machine V880 model

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

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

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

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

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

RE: Where is Oracle 9.2 init.ora?

[Khedr, Waleed]

I checked this on my 9.2 Oracle on win2k:

1- Database is up and running
2- There is no init.ora
3- show parameters indicate a parameter called spfile
4- checked v$parameter and found spfile is defined by default to
spfile.ora
5- renamed the file spfile.
6- shutdown the database.
7- try to restart the database.
8- It failed saying can not find init.ora
9- Copied spfile to init.ora
10- restart the database.
11- Failed. It complains about the file format (it's binary).
12- Let's rename spfile file back to its original name.
12- Now we have a wrong init.ora and correct spfile.
13- restart the database.
14- Database is up and no errors. It never complains about the format of
init.ora which indicates that it checks first for spfile
if it's there it restarts the database without reading init.ora. If
there is no spfile then Oracle tries to use init.ora.
15- I used to edit spfile in 9.01 on Solaris using vi and it worked.


Regards,

Waleed


-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?

I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.

I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.

Any insights from someone that has turned archiving on with 9.2 would be
appreciated.

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

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

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

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

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

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

RE: Active sql

[Jamadagni, Rajendra]

decode(kglobtyp,0,'CURSOR',7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE', 
11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY','OTHER') 

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

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


-Original Message-
Sent: Thursday, July 11, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Jamadagni,

Tks for the help.

After creating the xviews it worked fine for function, packages, procedures.

I want to include SQL statements also.  Was checking
but just return numbers, that explain the decode.

select distinct kglobtyp from X_$KGLOB

  KGLOBTYP
--
 0
 1
 2
 3
 4
 5
 6
 7
 8
 9
10


What is the number for SQL statements ??? or

Which one is the table of description for the numbers in the X_$KGLOB view ?

TIA

Ramon





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


> http://www.ixora.com.au/scripts/sql/create_xviews.sql
>
> Raj
> __
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -Original Message-
> Sent: Wednesday, July 03, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Jamadagni
>
> I am getting an error
>
>   sys.X_$KSUSE  s
>   *
> ERROR at line 12:
> ORA-00942: table or view does not exist
>
> Tested on 8.1.7 and 9.0.1 and the same error.
>
> What script should I run to create that table or view ?
>
> TIA
>
> Ramon
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 1:13 PM
>
>
> > prompt  Currently Executing Packages 
> > SELECT
> >   substr(DECODE(o.kglobtyp,
> > 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13,
> > 'CLASS'),1,15)  "TYPE",
> >   substr(o.kglnaown,1,30)  "OWNER",
> >   substr(o.kglnaobj,1,30)  "NAME",
> >   s.indx  "SID",
> >   s.ksuseser  "SERIAL"
> > FROM
> >   sys.X_$KGLOB  o,
> >   sys.X_$KGLPN  p,
> >   sys.X_$KSUSE  s
> > WHERE
> >   o.inst_id = USERENV('Instance') AND
> >   p.inst_id = USERENV('Instance') AND
> >   s.inst_id = USERENV('Instance') AND
> >   o.kglhdpmd = 2 AND
> >   o.kglobtyp IN (7, 8, 9, 12, 13) AND
> >   p.kglpnhdl = o.kglhdadr AND
> >   s.addr = p.kglpnses
> > ORDER BY 1, 2, 3
> > /
> >
> >
> > Courtsy of Steve Adams.
> >
> > Raj
> > __
> > Rajendra Jamadagni  MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> > -Original Message-
> > Sent: Wednesday, July 03, 2002 11:39 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi gurus,
> >
> > Is there any way to know which SQL statement or procedure or package is
> > running actually.
> >
> > I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get
the
> > statement, the user but this process had already finished, it was just
in
> > the SGA.
> >
> > What I want to know is who is actually running something in the DB.
> >
> > TIA
> >
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

Oracle 9.2 spfile catch 22

[DENNIS WILLIAMS]

Thanks to everyone for the ideas on the init.ora. You were correct that the
answer is indeed with spfile. Now I have discovered a catch-22.

Oracle 9.2, Solaris

1. If spfile is created with LOG_ARCHIVE_START = true,
database will not start. Receive the error
ORA-00439 feature not enabled: Managed Standby
2. Creating the spfile with LOG_ARCHIVE_START = false works and the database
starts. Issuing 
ALTER SYSTEM ARCHIVE LOG START 
works, but it isn't changed in the spfile, so the next time Oracle is
bounced, the archiver doesn't start.

This is starting to smell like a bug, but I thought I'd run it past the list
on the off-chance someone else has gotten archiving turned on for 9.2.
Thanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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

order by in subquery workaround

[Baker, Barbara]

> Solaris 2.6 
> Oracle RDBMS v8.0.5.2.1 
> 
List:
I'm trying to run a retrofit of statspack on an 8.0.5 database.  (ya, I
know.  upgrading would actually be easier)
The statspack stuff came from an 8.1.7 install I have on the same box.  

The spreport.sql report encounters errors in the "order by" clause.  The
problem is that you can't do an "order by" on a subquery before version
8.1.something-or-other

I know there's some kind of work around for this.  I had something to do
with a hint.  Even after 3 cups of coffee, I can't remember what it is.

Can anyone help?
Thanks!
Barb

here are the errors:

Shared Pool StatisticsBegin   End
   --  --
 Memory Usage %:   75.99   70.05
% SQL with executions>1:   21.95   48.60
  % Memory for SQL w/exec>1:   11.28   21.84
   order by time desc, waits desc
   *
ERROR at line 24:
ORA-00907: missing right parenthesis




pmon timer  1,184  1,177 355,304   3001
0.2
  -
  order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value,
st.piece
  *
ERROR at line 41:
ORA-00907: missing right parenthesis


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

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

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

RE: CA sues Quest Software for code theft

[Boivin, Patrice J]

Well they're doing at least one thing right.

: )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, July 11, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: CA sues Quest Software for code theft

Ahhh...yeah...that's a reason to keep CA around...the free posters.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

RE: larry want to take over your e-mai

[johanna . doran]

THAT DOES IT.  I am starting training on DB2 right away (Yeah - I can actually AFFORD 
to no $2000 requirements!!).  I want a DB that KNOWS its a DB and not an 
all-purpose quagmire of inter-related but not really related junk just because Larry 
has a Bill complex!

Oracle and CHEAP cannot be used in the same sentence!  Must have been a 
misquote...surpised they dont need a 5000 named user license!


Argh.. mental meltdown in process.  One... two deep breath Is it Friday 
yet?

Hannah




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

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

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

How to?

[Nguyen, David M]

Using LogMiner to read redo log, how do I tell a transaction is modified by
which user and where user logins from like what columns in LogMiner should
tell me this kind of information?

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

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

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

RE: CA sues Quest Software for code theft

[Grabowy, Chris]

Great minds think alike...

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


http://www.tusc.com   :)

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

> -Original Message-
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 10:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
> 
> 
> Hey!  Where are we going to get free data dictionary posters 
> if CA dies?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Active sql

[Ramon E. Estevez]

Jamadagni,

Tks for the help.

After creating the xviews it worked fine for function, packages, procedures.

I want to include SQL statements also.  Was checking
but just return numbers, that explain the decode.

select distinct kglobtyp from X_$KGLOB

  KGLOBTYP
--
 0
 1
 2
 3
 4
 5
 6
 7
 8
 9
10


What is the number for SQL statements ??? or

Which one is the table of description for the numbers in the X_$KGLOB view ?

TIA

Ramon





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


> http://www.ixora.com.au/scripts/sql/create_xviews.sql
>
> Raj
> __
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -Original Message-
> Sent: Wednesday, July 03, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Jamadagni
>
> I am getting an error
>
>   sys.X_$KSUSE  s
>   *
> ERROR at line 12:
> ORA-00942: table or view does not exist
>
> Tested on 8.1.7 and 9.0.1 and the same error.
>
> What script should I run to create that table or view ?
>
> TIA
>
> Ramon
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 03, 2002 1:13 PM
>
>
> > prompt  Currently Executing Packages 
> > SELECT
> >   substr(DECODE(o.kglobtyp,
> > 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13,
> > 'CLASS'),1,15)  "TYPE",
> >   substr(o.kglnaown,1,30)  "OWNER",
> >   substr(o.kglnaobj,1,30)  "NAME",
> >   s.indx  "SID",
> >   s.ksuseser  "SERIAL"
> > FROM
> >   sys.X_$KGLOB  o,
> >   sys.X_$KGLPN  p,
> >   sys.X_$KSUSE  s
> > WHERE
> >   o.inst_id = USERENV('Instance') AND
> >   p.inst_id = USERENV('Instance') AND
> >   s.inst_id = USERENV('Instance') AND
> >   o.kglhdpmd = 2 AND
> >   o.kglobtyp IN (7, 8, 9, 12, 13) AND
> >   p.kglpnhdl = o.kglhdadr AND
> >   s.addr = p.kglpnses
> > ORDER BY 1, 2, 3
> > /
> >
> >
> > Courtsy of Steve Adams.
> >
> > Raj
> > __
> > Rajendra Jamadagni  MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> > -Original Message-
> > Sent: Wednesday, July 03, 2002 11:39 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi gurus,
> >
> > Is there any way to know which SQL statement or procedure or package is
> > running actually.
> >
> > I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get
the
> > statement, the user but this process had already finished, it was just
in
> > the SGA.
> >
> > What I want to know is who is actually running something in the DB.
> >
> > TIA
> >
> >
> > Ramon E. Estevez
> > [EMAIL PROTECTED]
> > 809-565-3121
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramon E. Estevez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

RE: Problem with sequence and row cache lock

[Thomas Jeff]

Title: RE: Problem with sequence and row cache lock





Thanks for the reply, but it seems to be the problem you're describing is exactly
what sequences are there for - to prevent serialization and eliminate this type
of waiting.


The sequences is ORDERED, BTW.


-Original Message-
From: Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Problem with sequence and row cache lock


ORDER or NOORDER?  If the sequence is not cached then Oracle has to find
the last number generated and generate the next one.  If the sequence is
ordered (default) then Oracle must satisfy the first request for NEXTVAL
before it can go on to the next request.  If order is not important try
NOORDER and see if the locks don't go away.



   
    Thomas Jeff    
    
    @tce.com>    <[EMAIL PROTECTED]>    
    Sent by: root    cc:   
 Subject: Problem with sequence and row cache  
 lock  
    07/11/2002 
    11:43 AM   
    Please 
    respond to 
    ORACLE-L   
   
   







I noticed some statements hung with respect to selecting from a sequence.
The sequence is not cached nor pinned.  At any rate, these processes appear
to be piling up, waiting to acquire a data dictionary lock.


Why would this be the case?


Username SPID O/S User    Process Sid, Ser#    Logon
Idle
  --- --  
--- --
ECM  37872    vignette    20427   211,22415    07-10-02
11:37  20:26:58
ECM  36428    vignette    21387   181,29256    07-10-02
11:56  20:23:45
ECM  28044    vignette    29813   17,4904  07-11-02
08:05  0:0:0
ECM  53278    vignette    28240   44,8865  07-11-02
07:53  0:0:0
ECM  83916    vignette    21164   228,857  07-10-02
11:52  20:25:49
ECM  32162    vignette    22132   54,54828 07-10-02
12:08  20:23:1


  SID HASH_VALUE SQL_TEXT
O/S User
- --

---
   44 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
   54 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  108 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  181 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  211 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  228 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette


   SID EVENT   P1TEXT  P1 P2TEXT    P2 P3TEXT
P3
- --- --- -  --
   44 row cache lock  cache id    13 mode    0 request
5
   54 cache id    13 mode    0 request
5
  108 cache id    13 mode    0 request
5
  228 cache id    13 mode    0 request
5
  211 cache id    13 mode    0 request
5
  181 cache id    13 mode    0 request
5


 SID TY    ID1    ID2  LMODE    REQUEST  CTIME  BLOCK
- -- -- -- -- -- -- --
   54 TX 262215 292550  6  0  74738  0
   54 TM  50215  0  3  0  74746  0
  181 TX 262203 292536  6  0  74750  0
  181 TM  50215  0  3  0  74755  0
  181 TO  38012  1  3  0  77372  0
  181 TO  38013  1  3  0  77372  0
  181 TO  38011  1  3  0  77290  0
  211 TX 589862 289307  6  0  74982  0
  211 TM  50215  0  3  0  74982  0
  21

Re: sequential reads/scattered reads

[Tim Gorman]

This is the kind of knee-jerk reaction that folks have to think harder
about.  Having data tablespaces and index tablespaces on the same "physical"
device (is it really a "physical" device, or is it a "logical" device?) does
not equal I/O contention.  Maybe (just maybe) on your laptop or desktop, but
not on properly configured current storage subsystems.  The "conventional
wisdom" to separate tables and indexes to separate tablespaces is not based
on performance considerations, but rather on availability considerations.
I/O to tables and I/O to indexes are vastly different.  The idea that tables
and indexes need to be segregated to separate I/O devices in all cases is a
myth, and an expensive one.

Please use the information available in this forum and on websites such as
www.oraperf.com, www.hotsos.com, www.orapub.com, www.ixora.com.au,
www.miracleas.dk, www.oaktable.net, www.jlcomp.demon.co.uk, and even
www.evdbt.com to interpret the information readily available in the V$ views
to determine the exact cause and location of I/O contention.  Improving I/O
performance consists both of reducing the "amount of I/O requests" as well
as reducing the "cost per I/O request".  Reducing the amount of I/O is SQL
tuning;  reducing the cost per I/O involves optimizing the I/O subsystem.
In the vast majority of cases, the very best improvement that can be
expected in reducing the cost per I/O is 10-50% (i.e. incremental
improvement) at best, which is of course dependent on where you are starting
from and where you can afford to get to.  In contrast, reducing the volume
of I/O requests by tuning SQL statements can provide performance
improvements ranging anywhere from 1% to infinity, with the majority of
improvements tending toward infinity.  If you were going to put your scarce
money behind one or the other approach, which would you pursue?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 8:18 AM


>
> If you can move the indexes to a separate physical device (and their own
> tablespace/datafile) then you will reduce I/O contention.  If the
> tablespace/datafile is on the same RAID device then you will be using the
> same r/w heads and you will not reduce I/O contention.
>
>
>
> oraora
> oraora   To: Multiple recipients of
list ORACLE-L
> 
> @rediffmail.ccc:
> om>  Subject: sequential
reads/scattered reads
> Sent by: root
>
>
> 07/11/2002
> 07:33 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> Guys,
>
> Querying my v$session_wait shows 10 rows each DB FILE SEQUENTIAL
> READ and DB FILE SCATTERED READ.
>
> manuals explain it all b'coz of I/O.
>
> there are 33 tables and 110 indexes in the same USERS tablespace
> with only one datafile USERS01.DAT of size 12GB.
>
> it's physically laid out in D:\oracle\data.
> but the hard disk capacity is 100GB with 8 disk heads and RAID5.
>
> will not moving the tables and indexes to seperate tablespace
> reduce I/O traffic ? my manager here says that since it is
> configured with RAID5 and 8 disk heads , it's not a problem.
>
> is it so ? is he right ?
> plz. clarify me. i need to explain him.
> it's urgent.he is sitting on my head.
>
> TIA.
> _
> There is always a better job for you at Monsterindia.com.
> Go now http://monsterindia.rediff.com/jobs
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  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 Day
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please

RE: RE: sequential reads/scattered reads

[Johnson, Michael]

Are you sure that these are the ones that are slowing
the system down ?   Did you try to find out at  what
time of the day the system is really slow and execute
your wait/event queries at that time ? Did you get
a slice of 10046 data when the application was actually
running slow ?You could be looking at waits which
are not really the problem. 

FWIW !

Mike

-Original Message-
Sent: Thursday, July 11, 2002 8:26 AM
To: Multiple recipients of list ORACLE-L


Cary Millsap,

i selected the top 25 SQL statements in the system over various 
periods . all are SELECT statements only waiting for reads.

querying v$session_wait also shows more than 10 records each for 
DB FILE SCATTERED READS and DB FILE SEQUENTIAL READS.does not it 
mean that it's b'coz of I/O contention ? i am not sure .

this is on RAID set up.
will not seperating my tables and indexes to seperate tablespace 
help me ?


guide me Cary.it's really urgent.
i am novice DBA.


On Thu, 11 Jul 2002 Cary Millsap wrote :
>Moving stuff around won't reduce I/O traffic, it'll just spread 
>it
>around across different devices.
>
>Don't focus on how much I/O your system does, focus on how much 
>*time*
>an important process spends *doing* I/O. It's Amdahl's Law: If 
>you
>improve I/O latencies by 50%, but your program spends only 2% of 
>its
>response time doing I/O, then your program's response time will 
>improve
>by only 1%.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.

_
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs

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

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

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

[Grabowy, Chris]

Ahhh...yeah...that's a reason to keep CA around...the free posters.

-Original Message-
Sent: Thursday, July 11, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L


but it's not "free" from TUSC.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:09 PM


> TUSC.
>
> So it would not be a tragedy.  :P
>
> Chris
>
> -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey!  Where are we going to get free data dictionary posters if CA dies?
>
> That would be a tragedy.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
>  -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
>
> True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.
Very
> disappointed in what Quest did with their perf tuning tools.
>
> At least TOAD is still standalone.
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 3:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:CA sues Quest Software for code theft
> >
> >
> > Busted or being hogged on?  Probably something old Platinum
> > had cooking on the
> > back burner & that CA was going to trash.  Of course they
> > can't have anyone make
> > money on their trash now can they?  Send CA to chapter 13 as
> > fast as one can.
> > We'll all be better off.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: "James Howerton" <[EMAIL PROTECTED]>
> > Date:   7/10/2002 12:10 PM
> >
> > Busted...
> >
> > Software vendor Computer Associates International is suing competitor
> > Quest
> > Software, alleging that Quest stole code and trade secrets from a CA
> > product.
> >
> > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Buffer busy waits are 10.96% of non-idle waits

[Bunyamin Karadeniz]

Read the below carefuly.
Do not forget that any ratio of an event to idle events is not considerable.
You must consider it if you see the wait in the top 5 wait event list in
statspack report.
If the time waited for buffer waits is in a considerable rate acoording to
other waits then you must tune it.

Here is a detailed explanation of buffer busy waits.

This event is caused by:
? multiple sessions requesting the same block (i.e., one or more sessions
are waiting for a process to read the requested block into the buffer cache)
? multiple sessions waiting for a change to complete for the same block
(only one process at a time can write to the block, so other processes have
to wait for that buffer to become available)

If buffer busy waits is high, determine which blocks are being accessed
concurrently and if the blocks are being read or changed through
V$SESSION_WAIT and V$WAITSTAT.

V$SESSION_WAIT will show the file#, block# and id (where id represents the
status of the buffer busy wait event).
? file# - data file number containing the block being read
? block# - block number being waited on
? id - buffer busy wait event:
? 1013/1014 - block is being read by another session
? 1012/1016 - block is being modified

V$WAITSTAT will show the block classes and the number of times waited for
each. Different actions may be taken for each block class to alleviate
contention.  Tuning priorities should be oriented toward the classes that
contribute the highest wait time percentage.

segment header waits
Each segment has one segment header block.  There are basically two types of
segments -- data and index.  The following is a brief discussion on causes
for segment header blocks based on the data structures they contain:
? Problem: A high insert rate on a table with insufficient transaction free
lists results in a bottleneck.
? Solution: Increase free list groups.  For databases running in exclusive
mode, this recommendation may also circumvent the issue of a small block
size constraining the number of available free lists.
? Problem: Under heavy insert activity, a table's High Water Mark (HWM) is
constantly updated.  This may be due to running out of blocks on the free
lists and need to replenish it by allocating new blocks.  The default value
for incrementing the HWM is 5, which may be insufficient on a busy system or
for the average insert size.
? Solution: This value can be increased up to 255 through the undocumented
init.ora parameter, _BUMP_HIGHWATER_MARK_COUNT.  Caution: this parameter
determines how many blocks to allocate per free list when bumping up the
HWM.  Therefore, this can grow a table very quickly if it has a high number
of free lists.  For example, if there are 100 free lists and
_bump_highwater_mark_count=100, then this may quickly add up to 1 free
blocks to the segment.
? Problem: Constantly inserting new entries into the extent map within the
segment header because extent sizes are too small.
? Solution: Increase the size of each extent.  Although ORACLE7 release 7.3
allows an object to have unlimited extents, it is better to have a small
number of very large extents than to have a large number of small extents.


 Data block waits
 The data block class is used to store data (index or table data).  Here are
some reasons for data block waits:
? Problem: multiple sessions could be requesting the same block from disk
(this could actually happen for each block class).  Only one session will do
the read from disk, and the other sessions will be waiting for the block to
be placed into the buffer cache.  The other sessions will be waiting on the
buffer busy wait event (1014).
? Solution: the buffer cache may be too small to keep the current working
set in memory.  Enlarging the buffer cache (db_block_buffers) can help.
Another option is to use buffer pools to reduce the number of buffers an
object can occupy in the buffer cache.  For example, we may effectively
limit the number of buffers that a randomly accessed large table can occupy
in the buffer cache by placing it in the recycle pool.
? Problem: multiple sessions are going after rows in the same block because
it contains so many rows.
? Solution: reduce the number of rows per block (i.e., modify
pctfree/pctused settings).  This is a space for time tradeoff.  The table
will use more space, but 'buffer busy waits' will be reduced.
? Problem: multiple sessions are trying to insert into the same block
because there is only one free list (or insufficient free lists).
? Solution: adding multiple free lists to the object will increase the
number of heads of free lists, thus the contention point can be distributed
over the free lists, reducing the number of buffer busy waits.

Free list block waits
This statistic measures contention for "free list group" blocks.  Some
documentation and tuning scripts claim that waits on this block class
indicate that the number of free lists need to be increased for some
objects.  Most databases that run in exclusi

Re: CA sues Quest Software for code theft

[KENNETH JANUSZ]

TUSC doesn't advertise a Data Dictionary poster on it's web site, only V$
Views for Oracle9i.   And, they are not free.

My $0.02 worth,

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:28 AM


> http://www.tusc.com   :)
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 11, 2002 10:54 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: CA sues Quest Software for code theft
> >
> >
> > Hey!  Where are we going to get free data dictionary posters
> > if CA dies?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

Re: Where is Oracle 9.2 init.ora?

[Jonathan Gennick]

On Thu, 11 Jul 2002 07:43:27 -0800, you wrote:

>For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
>init.ora file?

By default, Oracle reads init parms from the new SPFILE. You need to
use new ALTER DATABASE (or is it ALTER SYSTEM?) syntax now in order to
change parameter settings. 

Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

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

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

Re:RE: CA sues Quest Software for code theft

[dgoulet]

Only for those sad few who have become CA zombies.

Dick Goulet

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   7/11/2002 7:53 AM

Hey!  Where are we going to get free data dictionary posters if CA dies?

That would be a tragedy.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L

True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.  Very
disappointed in what Quest did with their perf tuning tools.

At least TOAD is still standalone.

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 3:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:CA sues Quest Software for code theft
> 
> 
> Busted or being hogged on?  Probably something old Platinum 
> had cooking on the
> back burner & that CA was going to trash.  Of course they 
> can't have anyone make
> money on their trash now can they?  Send CA to chapter 13 as 
> fast as one can. 
> We'll all be better off.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "James Howerton" <[EMAIL PROTECTED]>
> Date:   7/10/2002 12:10 PM
> 
> Busted...
> 
> Software vendor Computer Associates International is suing competitor
> Quest
> Software, alleging that Quest stole code and trade secrets from a CA
> product.
> 
> http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

[Grabowy, Chris]

So I guess Ken is voting to keep CA around...:)

-Original Message-
Sent: Thursday, July 11, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L


I just checked their web site and the only poster they have is - V$ Views
for Oracle9i.

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:09 AM


> TUSC.
>
> So it would not be a tragedy.  :P
>
> Chris
>
> -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey!  Where are we going to get free data dictionary posters if CA dies?
>
> That would be a tragedy.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
>  -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
>
> True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.
Very
> disappointed in what Quest did with their perf tuning tools.
>
> At least TOAD is still standalone.
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 3:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:CA sues Quest Software for code theft
> >
> >
> > Busted or being hogged on?  Probably something old Platinum
> > had cooking on the
> > back burner & that CA was going to trash.  Of course they
> > can't have anyone make
> > money on their trash now can they?  Send CA to chapter 13 as
> > fast as one can.
> > We'll all be better off.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: "James Howerton" <[EMAIL PROTECTED]>
> > Date:   7/10/2002 12:10 PM
> >
> > Busted...
> >
> > Software vendor Computer Associates International is suing competitor
> > Quest
> > Software, alleging that Quest stole code and trade secrets from a CA
> > product.
> >
> > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Problem with sequence and row cache lock

[Thomas Day]

ORDER or NOORDER?  If the sequence is not cached then Oracle has to find
the last number generated and generate the next one.  If the sequence is
ordered (default) then Oracle must satisfy the first request for NEXTVAL
before it can go on to the next request.  If order is not important try
NOORDER and see if the locks don't go away.


   

Thomas Jeff

<[EMAIL PROTECTED]>

Sent by: rootcc:   

 Subject: Problem with sequence and row 
cache  
 lock  

07/11/2002 

11:43 AM   

Please 

respond to 

ORACLE-L   

   

   







I noticed some statements hung with respect to selecting from a sequence.
The sequence is not cached nor pinned.  At any rate, these processes appear
to be piling up, waiting to acquire a data dictionary lock.

Why would this be the case?

Username SPID O/S User    Process Sid, Ser#    Logon
Idle
  --- --  
--- --
ECM  37872    vignette    20427   211,22415    07-10-02
11:37  20:26:58
ECM  36428    vignette    21387   181,29256    07-10-02
11:56  20:23:45
ECM  28044    vignette    29813   17,4904  07-11-02
08:05  0:0:0
ECM  53278    vignette    28240   44,8865  07-11-02
07:53  0:0:0
ECM  83916    vignette    21164   228,857  07-10-02
11:52  20:25:49
ECM  32162    vignette    22132   54,54828 07-10-02
12:08  20:23:1

  SID HASH_VALUE SQL_TEXT
O/S User
- --

---
   44 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
   54 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  108 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  181 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  211 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette
  228 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL
vignette

   SID EVENT   P1TEXT  P1 P2TEXT    P2 P3TEXT
P3
- --- --- -  --
   44 row cache lock  cache id    13 mode    0 request
5
   54 cache id    13 mode    0 request
5
  108 cache id    13 mode    0 request
5
  228 cache id    13 mode    0 request
5
  211 cache id    13 mode    0 request
5
  181 cache id    13 mode    0 request
5

 SID TY    ID1    ID2  LMODE    REQUEST  CTIME  BLOCK
- -- -- -- -- -- -- --
   54 TX 262215 292550  6  0  74738  0
   54 TM  50215  0  3  0  74746  0
  181 TX 262203 292536  6  0  74750  0
  181 TM  50215  0  3  0  74755  0
  181 TO  38012  1  3  0  77372  0
  181 TO  38013  1  3  0  77372  0
  181 TO  38011  1  3  0  77290  0
  211 TX 589862 289307  6  0  74982  0
  211 TM  50215  0  3  0  74982  0
  211 TO  38013  1  3  0  78470  0
  211 TO  38011  1  3  0  78459  0
  211 TO  38012  1  3  0  78470  0
  228 TX 327747 290803  6  0  74885  0
  228 TM  50215  0  3  0  74887  0
  228 TO  38012  1  3  0  77463  0
  228 TO  38013  1  3

Re: Where is Oracle 9.2 init.ora?

[Ron Rogers]

Dennis,
 the info you are looking for can be found in the IOUG "Select Nov
2001" magazine. 
" Spfile is a new form of the INIT.ORA file, which is a binary file.
the default location is in $ORACLE_HOME/dbs/spfileSID.ora. The spfile
contains all of the initialization parameters that are currently set in
the online database. When setting a dynamic initialization parameter,
you have the option of setting it's scope, i.e. Memory memory only,
spfile only, or both.
The spfile can be recreated from the pfile and vice versa.
=== ALTER SYSTEM SET parameter
===COMMENT='This is the reason for setting it'
===SCOPE=[MEMORY,SPFILE,BOTH];
The default behavior is to use the SPFILE instead of the pfile.
===CREATE SPFILE[=''] FROM PFILE[='...']
===CREATE PFILE[='...'] FROM SPFILE[='']

additional information can be found in
V$SPFILE
V$SPPARAMETER
V$PARAMETER &
V$PARAMETER2"
 From what I have read and understand you have to "activate" the
changes in the pfile by creating the spfile and then bouonce the DB to
activate it.
HTH
ROR mª¿ªm

>>> [EMAIL PROTECTED] 07/11/02 12:09PM >>>
GOTCHA!

The dbca also created an "SP" file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.

HTH & YMV!


DENNIS WILLIAMS wrote:
> 
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
> init.ora file?
> 
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
> original init.ora file. Then I discovered that Oracle is not reading
the new
> init.ora. The database starts fine, with no errors. I tried moving
the
> init.ora file back to the original pfile location, but it is still
not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
> have made other changes and they are not taking effect either.
> 
> I have searched the documentation, and while there is the new SPFILE,
there
> is no indication how this might affect my problem.
> 
> Any insights from someone that has turned archiving on with 9.2 would
be
> appreciated.
> 
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler  Maintenance Warehouse 

[EMAIL PROTECTED] 10641 Scripps Summit
Ct.
858-831-2229 San Diego, CA 92131   

Lack of planning on your part doesn't constitute an emergency on my
part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED] 

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

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

[Igor Neyman]

but it's not "free" from TUSC.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:09 PM


> TUSC.
>
> So it would not be a tragedy.  :P
>
> Chris
>
> -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey!  Where are we going to get free data dictionary posters if CA dies?
>
> That would be a tragedy.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
>  -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
>
> True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.
Very
> disappointed in what Quest did with their perf tuning tools.
>
> At least TOAD is still standalone.
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 3:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:CA sues Quest Software for code theft
> >
> >
> > Busted or being hogged on?  Probably something old Platinum
> > had cooking on the
> > back burner & that CA was going to trash.  Of course they
> > can't have anyone make
> > money on their trash now can they?  Send CA to chapter 13 as
> > fast as one can.
> > We'll all be better off.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: "James Howerton" <[EMAIL PROTECTED]>
> > Date:   7/10/2002 12:10 PM
> >
> > Busted...
> >
> > Software vendor Computer Associates International is suing competitor
> > Quest
> > Software, alleging that Quest stole code and trade secrets from a CA
> > product.
> >
> > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Re: sequential reads/scattered reads

[Thomas Day]

If your D partition is just a logical device then, 'No'.  Only moving to a
different physical device will reduce I/O contention.


   

oraora 

oraora   To: Multiple recipients of list ORACLE-L  



@rediffmail.ccc:   

om>  Subject: Re: Re: sequential 
reads/scattered   
Sent by: rootreads 

   

   

07/11/2002 

11:28 AM   

Please 

respond to 

ORACLE-L   

   

   





Thanx Thomas .

i am pretty new to RAID.
will not moving my tables and indexes to seperate tablespace
reduce my i/o ?

my h/w setup is:

there is a logical partition D:
of size 80GB with RAID5.

is it enough that i move to seperate tablespace ?
os should i create another partition like D: and put my files
there ?

i am novice DBA . plz. guide me Thomas.



On Thu, 11 Jul 2002 Thomas Day wrote :
>
>If you can move the indexes to a separate physical device (and
>their own
>tablespace/datafile) then you will reduce I/O contention.  If
>the
>tablespace/datafile is on the same RAID device then you will be
>using the
>same r/w heads and you will not reduce I/O contention.
>
>
>
> oraora
> oraora   To: Multiple
>recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> @rediffmail.ccc:
> om>  Subject: sequential
>reads/scattered reads
> Sent by: root
>
>
> 07/11/2002
> 07:33 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Guys,
>
>Querying my v$session_wait shows 10 rows each DB FILE
>SEQUENTIAL
>READ and DB FILE SCATTERED READ.
>
>manuals explain it all b'coz of I/O.
>
>there are 33 tables and 110 indexes in the same USERS
>tablespace
>with only one datafile USERS01.DAT of size 12GB.
>
>it's physically laid out in D:\oracle\data.
>but the hard disk capacity is 100GB with 8 disk heads and
>RAID5.
>
>will not moving the tables and indexes to seperate tablespace
>reduce I/O traffic ? my manager here says that since it is
>configured with RAID5 and 8 disk heads , it's not a problem.
>
>is it so ? is he right ?
>plz. clarify me. i need to explain him.
>it's urgent.he is sitting on my head.
>
>TIA.
>_
>There is always a better job for you at Monsterindia.com.
>Go now http://monsterindia.rediff.com/jobs
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858)
>538-5051
>San Diego, California-- Public Internet access / Mailing
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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 Day
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858)
>538-5051
>San Diego, California-- Public Internet access / Mailing
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You
>may
>also send the HELP command for other information (like
>subscribing).

___

Re: Where is Oracle 9.2 init.ora?

[Igor Neyman]

Not sure about default pfile location, so I'm specifying it explicitly on db
startup.
As for SPFILE, the default location on Unix is $ORACLE_HOME/dbs (while on NT
it is $ORACLE_HOME/database).
So, if you create SPFILE in this default directory, than you don't have to
specify it on startup.
To create SPFILE in default directory, use: "create spfile from pfile=.'
(notice, there is no spfile specification, so Oracle will create it in
default folder using default file name).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:43 AM


> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
> original init.ora file. Then I discovered that Oracle is not reading the
new
> init.ora. The database starts fine, with no errors. I tried moving the
> init.ora file back to the original pfile location, but it is still not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but
I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: CA sues Quest Software for code theft

[KENNETH JANUSZ]

I just checked their web site and the only poster they have is - V$ Views
for Oracle9i.

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:09 AM


> TUSC.
>
> So it would not be a tragedy.  :P
>
> Chris
>
> -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey!  Where are we going to get free data dictionary posters if CA dies?
>
> That would be a tragedy.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
>  -Original Message-
> Sent: Thursday, July 11, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
>
> True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.
Very
> disappointed in what Quest did with their perf tuning tools.
>
> At least TOAD is still standalone.
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 3:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:CA sues Quest Software for code theft
> >
> >
> > Busted or being hogged on?  Probably something old Platinum
> > had cooking on the
> > back burner & that CA was going to trash.  Of course they
> > can't have anyone make
> > money on their trash now can they?  Send CA to chapter 13 as
> > fast as one can.
> > We'll all be better off.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: "James Howerton" <[EMAIL PROTECTED]>
> > Date:   7/10/2002 12:10 PM
> >
> > Busted...
> >
> > Software vendor Computer Associates International is suing competitor
> > Quest
> > Software, alleging that Quest stole code and trade secrets from a CA
> > product.
> >
> > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: CA sues Quest Software for code theft

[Jesse, Rich]

http://www.tusc.com   :)

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

> -Original Message-
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 10:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CA sues Quest Software for code theft
> 
> 
> Hey!  Where are we going to get free data dictionary posters 
> if CA dies?
-- 
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: Where is Oracle 9.2 init.ora?

[Conboy, Jim]

Dennis-

With 9i you have the option of using init.ora or the spfile.  DBs created with the 
assistant I think use spfile by default.  To make the change you want, issue the ALTER 
SYSTEM blah blah SCOPE BOTH to make the change both immediate and permanent.  SCOPE 
MEMORY changes it immediately but only until reboot, SCOPE SPFILE changes the 
initialization file but won't take effect until reboot.

Jim

-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?

I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.

I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.

Any insights from someone that has turned archiving on with 9.2 would be
appreciated.

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

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

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

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

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

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

Re: Where is Oracle 9.2 init.ora?

[Paul Baumgartel]

Dennis, IIRC, the dbca creates an spfile in $ORACLE_HOME/dbs, and
startup reads that by default.  If you make changes in init.ora, you'd
have to create a new spfile for them to be recognized.  With 9.x, the
preferred way to change parameters is via ALTER SYSTEM...SCOPE...,
which makes the change directly to the spfile.

HTH,

Paul Baumgartel
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
> 
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> the
> original init.ora file. Then I discovered that Oracle is not reading
> the new
> init.ora. The database starts fine, with no errors. I tried moving
> the
> init.ora file back to the original pfile location, but it is still
> not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> true, but I
> have made other changes and they are not taking effect either.
> 
> I have searched the documentation, and while there is the new SPFILE,
> there
> is no indication how this might affect my problem.
> 
> Any insights from someone that has turned archiving on with 9.2 would
> be
> appreciated.
> 
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

larry want to take over your e-mai

[Adams, Matthew (GEA, MABG, 088130)]

Title: larry want to take over your e-mai





Ok, I just used the subject line to get your attention.
From today's copy of InformationWeek's daily e-mail.
--


** Oracle Takes On Microsoft's E-Mail


Oracle CEO Larry Ellison says he wants to exploit the security 
vulnerabilities and high price of Microsoft's E-mail software by 
selling customers a new package based on Oracle's database. 


In an interview at a meeting of financial analysts at Oracle's 
headquarters Wednesday in Redwood Shores, Calif., Ellison said 
the Oracle Collaboration Suite--due this year--will be more 
secure, reliable, and virus-free than Microsoft's Exchange and 
Outlook products. And it will be cheaper, he says. "Microsoft has 
never had to compete on price for Exchange and Outlook, but now 
they have to compete on price, security, reliability, and 
features."


Oracle's Collaboration Suite will deliver E-mail via Outlook, but 
run Oracle 9i as its database, instead of Exchange. Oracle plans 
to charge $450,000 for 5,000 users, about a third of what 
Microsoft charges, says Ellison. Oracle's product will let users 
store documents, E-mail, voice mail, and data files in Oracle 9i, 
and search for them by date and keyword. "That's [Bill] Gates' 
long-term strategy, but we have it all now," Ellison says. 


Josh Greenbaum, an analyst at Enterprise Applications Consulting, 
says Oracle still has to prove that it can safeguard E-mail 
messages and address lists from hackers as well as it protects 
business data. - Steve Konicki 

My gut reaction? I don't think so, not after the 
debacle know as Oracle*Mail.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Enter any 11 digit prime number to continue.

RE: CA sues Quest Software for code theft

[Grabowy, Chris]

TUSC.

So it would not be a tragedy.  :P

Chris

-Original Message-
Sent: Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Hey!  Where are we going to get free data dictionary posters if CA dies?

That would be a tragedy.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: CA sues Quest Software for code theft

True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.  Very
disappointed in what Quest did with their perf tuning tools.

At least TOAD is still standalone.

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 3:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:CA sues Quest Software for code theft
> 
> 
> Busted or being hogged on?  Probably something old Platinum 
> had cooking on the
> back burner & that CA was going to trash.  Of course they 
> can't have anyone make
> money on their trash now can they?  Send CA to chapter 13 as 
> fast as one can. 
> We'll all be better off.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "James Howerton" <[EMAIL PROTECTED]>
> Date:   7/10/2002 12:10 PM
> 
> Busted...
> 
> Software vendor Computer Associates International is suing competitor
> Quest
> Software, alleging that Quest stole code and trade secrets from a CA
> product.
> 
> http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Re: sequential reads/scattered reads

[Ganesh Raja]

Hi,

Moving to different Tablespaces will not do u any good.

To learn more there was big List of Disscussion on... 

Comp.databases.oracle.server [ Google Groups http://groups.google.com ]

You can go and seasrch there seperating Tables and Indexes.

HTH

Best Regards, 
Ganesh R 
Tel  : +971 (4)  397 3337  Ext 420 
Fax  : +971 (4)  397 6262 
HP   : +971 (50) 745 6019 
== 
Live to learn... forget... and learn again. 
==


-Original Message-
oraora
Sent: Thursday, July 11, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


Thanx Thomas .

i am pretty new to RAID.
will not moving my tables and indexes to seperate tablespace 
reduce my i/o ?

my h/w setup is:

there is a logical partition D:
of size 80GB with RAID5.

is it enough that i move to seperate tablespace ?
os should i create another partition like D: and put my files 
there ?

i am novice DBA . plz. guide me Thomas.



On Thu, 11 Jul 2002 Thomas Day wrote :
>
>If you can move the indexes to a separate physical device (and
>their own
>tablespace/datafile) then you will reduce I/O contention.  If 
>the
>tablespace/datafile is on the same RAID device then you will be 
>using the
>same r/w heads and you will not reduce I/O contention.
>
>
>
> oraora
> oraora   To: Multiple 
>recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> @rediffmail.ccc:
> om>  Subject: sequential 
>reads/scattered reads
> Sent by: root
>
>
> 07/11/2002
> 07:33 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Guys,
>
>Querying my v$session_wait shows 10 rows each DB FILE
>SEQUENTIAL
>READ and DB FILE SCATTERED READ.
>
>manuals explain it all b'coz of I/O.
>
>there are 33 tables and 110 indexes in the same USERS
>tablespace
>with only one datafile USERS01.DAT of size 12GB.
>
>it's physically laid out in D:\oracle\data.
>but the hard disk capacity is 100GB with 8 disk heads and
>RAID5.
>
>will not moving the tables and indexes to seperate tablespace reduce 
>I/O traffic ? my manager here says that since it is configured with 
>RAID5 and 8 disk heads , it's not a problem.
>
>is it so ? is he right ?
>plz. clarify me. i need to explain him.
>it's urgent.he is sitting on my head.
>
>TIA.
>_
>There is always a better job for you at Monsterindia.com.
>Go now http://monsterindia.rediff.com/jobs
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 
>538-5051
>San Diego, California-- Public Internet access / Mailing 
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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 Day
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 
>538-5051
>San Diego, California-- Public Internet access / Mailing 
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You 
>may
>also send the HELP command for other information (like 
>subscribing).

_
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs

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

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

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

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

Fat City Network Services-- (858) 538-5

Re:Where is Oracle 9.2 init.ora?

[dgoulet]

Dennis,

Oracle created the SPFILE which is not humanly readable.  There should be an
alter database/system command that does the change for you.  According to what I
heard at Oratechs 2000 editing the init.ora file is now longer effective.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   7/11/2002 7:43 AM

For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?

I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.

I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.

Any insights from someone that has turned archiving on with 9.2 would be
appreciated.

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

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

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

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

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

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

RE: Where is Oracle 9.2 init.ora?

[John Weatherman]

Dennis,

Do you see a spfile?  Are you starting the database via a tool like OEM?  If
the spfile is out there, Oracle gives it preferance.  Try recreating it from
the pfile and see if your change "takes" or just get rid of it and start
things on the server and see how that does.

HtH,

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?

I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.

I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.

Any insights from someone that has turned archiving on with 9.2 would be
appreciated.

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

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

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

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

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

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

Re: Where is Oracle 9.2 init.ora?

[Charlie Mengler]

GOTCHA!

The dbca also created an "SP" file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.

HTH & YMV!


DENNIS WILLIAMS wrote:
> 
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
> init.ora file?
> 
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
> original init.ora file. Then I discovered that Oracle is not reading the new
> init.ora. The database starts fine, with no errors. I tried moving the
> init.ora file back to the original pfile location, but it is still not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
> have made other changes and they are not taking effect either.
> 
> I have searched the documentation, and while there is the new SPFILE, there
> is no indication how this might affect my problem.
> 
> Any insights from someone that has turned archiving on with 9.2 would be
> appreciated.
> 
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: CA sues Quest Software for code theft

[Boivin, Patrice J]

Hey!  Where are we going to get free data dictionary posters if CA dies?

That would be a tragedy.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: CA sues Quest Software for code theft

True, but I hope the CA/Platinum code wasn't Quest Central for Oracle.  Very
disappointed in what Quest did with their perf tuning tools.

At least TOAD is still standalone.

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 3:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:CA sues Quest Software for code theft
> 
> 
> Busted or being hogged on?  Probably something old Platinum 
> had cooking on the
> back burner & that CA was going to trash.  Of course they 
> can't have anyone make
> money on their trash now can they?  Send CA to chapter 13 as 
> fast as one can. 
> We'll all be better off.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "James Howerton" <[EMAIL PROTECTED]>
> Date:   7/10/2002 12:10 PM
> 
> Busted...
> 
> Software vendor Computer Associates International is suing competitor
> Quest
> Software, alleging that Quest stole code and trade secrets from a CA
> product.
> 
> http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

Problem with sequence and row cache lock

[Thomas Jeff]

Title: Problem with sequence and row cache lock





I noticed some statements hung with respect to selecting from a sequence.   
The sequence is not cached nor pinned.  At any rate, these processes appear 
to be piling up, waiting to acquire a data dictionary lock.   


Why would this be the case?   



Username SPID O/S User    Process Sid, Ser#    Logon   Idle
  --- --   --- --
ECM  37872    vignette    20427   211,22415    07-10-02 11:37  20:26:58
ECM  36428    vignette    21387   181,29256    07-10-02 11:56  20:23:45
ECM  28044    vignette    29813   17,4904  07-11-02 08:05  0:0:0
ECM  53278    vignette    28240   44,8865  07-11-02 07:53  0:0:0
ECM  83916    vignette    21164   228,857  07-10-02 11:52  20:25:49
ECM  32162    vignette    22132   54,54828 07-10-02 12:08  20:23:1   


  SID HASH_VALUE SQL_TEXT O/S User
- --  ---
   44 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette
   54 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette
  108 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette
  181 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette
  211 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette
  228 4074667660 SELECT TNE_SPAREPART_LIST_TEMP_SEQ.NEXTVAL   FROM DUAL   vignette   



   SID EVENT   P1TEXT  P1 P2TEXT    P2 P3TEXT    P3
- --- --- -  --
   44 row cache lock  cache id    13 mode    0 request    5
   54 cache id    13 mode    0 request    5
  108 cache id    13 mode    0 request    5
  228 cache id    13 mode    0 request    5
  211 cache id    13 mode    0 request    5
  181 cache id    13 mode    0 request    5    


 SID TY    ID1    ID2  LMODE    REQUEST  CTIME  BLOCK
- -- -- -- -- -- -- --
   54 TX 262215 292550  6  0  74738  0
   54 TM  50215  0  3  0  74746  0
  181 TX 262203 292536  6  0  74750  0
  181 TM  50215  0  3  0  74755  0
  181 TO  38012  1  3  0  77372  0
  181 TO  38013  1  3  0  77372  0
  181 TO  38011  1  3  0  77290  0
  211 TX 589862 289307  6  0  74982  0
  211 TM  50215  0  3  0  74982  0
  211 TO  38013  1  3  0  78470  0
  211 TO  38011  1  3  0  78459  0
  211 TO  38012  1  3  0  78470  0
  228 TX 327747 290803  6  0  74885  0
  228 TM  50215  0  3  0  74887  0
  228 TO  38012  1  3  0  77463  0
  228 TO  38013  1  3  0  77463  0
  228 TO  38011  1  3  0  77464  0  
    

Where is Oracle 9.2 init.ora?

[DENNIS WILLIAMS]

For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?

I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.

I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.

Any insights from someone that has turned archiving on with 9.2 would be
appreciated.

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

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

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

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

Re: Re: sequential reads/scattered reads

[oraora oraora]

Thanx Thomas .

i am pretty new to RAID.
will not moving my tables and indexes to seperate tablespace 
reduce my i/o ?

my h/w setup is:

there is a logical partition D:
of size 80GB with RAID5.

is it enough that i move to seperate tablespace ?
os should i create another partition like D: and put my files 
there ?

i am novice DBA . plz. guide me Thomas.



On Thu, 11 Jul 2002 Thomas Day wrote :
>
>If you can move the indexes to a separate physical device (and 
>their own
>tablespace/datafile) then you will reduce I/O contention.  If 
>the
>tablespace/datafile is on the same RAID device then you will be 
>using the
>same r/w heads and you will not reduce I/O contention.
>
>
>
> oraora
> oraora   To: Multiple 
>recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> @rediffmail.ccc:
> om>  Subject: sequential 
>reads/scattered reads
> Sent by: root
>
>
> 07/11/2002
> 07:33 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Guys,
>
>Querying my v$session_wait shows 10 rows each DB FILE 
>SEQUENTIAL
>READ and DB FILE SCATTERED READ.
>
>manuals explain it all b'coz of I/O.
>
>there are 33 tables and 110 indexes in the same USERS 
>tablespace
>with only one datafile USERS01.DAT of size 12GB.
>
>it's physically laid out in D:\oracle\data.
>but the hard disk capacity is 100GB with 8 disk heads and 
>RAID5.
>
>will not moving the tables and indexes to seperate tablespace
>reduce I/O traffic ? my manager here says that since it is
>configured with RAID5 and 8 disk heads , it's not a problem.
>
>is it so ? is he right ?
>plz. clarify me. i need to explain him.
>it's urgent.he is sitting on my head.
>
>TIA.
>_
>There is always a better job for you at Monsterindia.com.
>Go now http://monsterindia.rediff.com/jobs
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 
>538-5051
>San Diego, California-- Public Internet access / Mailing 
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail 
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  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 Day
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 
>538-5051
>San Diego, California-- Public Internet access / Mailing 
>Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail 
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You 
>may
>also send the HELP command for other information (like 
>subscribing).

_
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs

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

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

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