RE: Does SQL Server have a wait interface?

[Grabowy, Chris]

I believe the Jan edition of SQL Server magazine has an article on this very subject.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 8:35 AM
To: Multiple recipients of list ORACLE-L


anyone know? 

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

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

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

RE: Old thread - trace file location

[Alexander . Feinstein]

Title: RE: Old thread - trace file location





For 9.2 users:


Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs;


Alex.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 21, 2004 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Old thread - trace file location



Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 & 18, 2002. If you are interested, go to Google and enter Oracle-l "backup controlfile to trace". Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, January 21, 2004 11:19 AM
To: Multiple recipients of list ORACLE-L



Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


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

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


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

RE: help

[Jared . Still]

LOL!!

Ok, Ashish, the problem is you sent 'help'  to the list address.

Send HELP to [EMAIL PROTECTED] and all will be well.

Ok, now back to work everyone.

Jared








"Odland, Brad" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/21/2004 07:59 AM
 Please respond to ORACLE-L

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


 
Ashish realizing his time is short he crawls to the terminal and with his last remaining strength double clicks the outlook icon, clicks the new button selects "New Mail Message" button, using the shift key he types H - E - L - P in the message body window and hits send and then CANCEL to stop the spell checker, and then "YES" to send his message anyway. His message careens through the internet as he slumps to the floor as the world goes dark. The world will be safe now if they can break the code are his final thoughts before oblivion takes him.
Minutes later hundreds of Information Systems professionals are reading his message wondering what horror occurred that drove a man to do this. They pause to reflect and then selecting the message in their inbox they press the delete key and go get a fresh cup of coffee.
 
 
-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 

Funny ... Ashish is from "Weight Watchers" and asking for HELP  my advise ... stop starving yourself ... go eat something.
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 

must.resist..temptation.
 
For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. 
 
Live long and prosper.
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish Sahasrabudhe
Sent: 21 January 2004 14:34
To: Multiple recipients of list ORACLE-L
Subject: 

HELP 

Re: Re: pga_aggregate_target and a memory leak

[Kirtikumar Deshpande]

I think it depends on your applications. 

In DSS type environments we are still stuggling to figure out if P_A_T is helping or 
not. Initial
tests are not in P_A_T's favor. 

But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid 
swapping. This
9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has 
over 600 
persistent users. No MTS in use. 

- Kirti 

  


--- [EMAIL PROTECTED] wrote:
> kirti-- would you recommend avoiding pga_aggregate_target for now? 
> > 
> > From: Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > Date: 2004/01/21 Wed PM 02:44:31 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: pga_aggregate_target and a memory leak
> > 
> > Replies in line... 
> > 
> > - Kirti 
> > 
> > --- [EMAIL PROTECTED] wrote:
> > > Kirti, you're back! 
> > 
> > Thanks. Found some slack time from routine DBA work!  
> > 
> > > 
> > > Must have finished the book.  :)
> > 
> > Not yet.. Its tough.. 
> > 
> > 
> > 
> > > 
> > > Re the PGA problems, what was the value for 'over allocation count' in 
> > > v$pgastat?
> > 
> > Actually, I never bothered to look at v$pgastat. Should have.. and will, when we 
> > do some more
> > testing next week..
> > 
> > 
> > > 
> > > Did you try increasing P_A_T to a larger number? 
> > 
> > Yes... 
> > 
> > 
> > > 
> > > Oracle is supposed to grab the memory it needs, if available, regardless 
> > > of
> > > the P_A_T setting. 
> > > 
> > > Also, did your system go in to excessive paging or swapping?
> > 
> > Yes, it did with a large P_A_T. 
> > 
> > 
> > > 
> > > I've been curious as to what the effects would be of having P_A_T too low.
> > 
> > I saw more disk sorts.. 
> > 
> > As time permits, I will play with event 10032, 10033 trace for sorts to see what's 
> > going on.. 
> > 
> > 
> > > 
> > > Oracle is supposed to grab whatever memory it needs.  I'm assuming at this
> > > point that doing so involves a different code path as it needs to alloc 
> > > the memory.
> > > 
> > > Don't know what the cost of that is, haven't tried to test it.
> > > 
> > > It seems likely that the OS was out of memory, regardless of the P_A_T 
> > > value.
> > > 
> > No. The system has 4 GB of physical memory. Over 2GB was free. 
> > 
> > > Jared
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > >  01/21/2004 06:09 AM
> > >  Please respond to ORACLE-L
> > > 
> > >  
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > cc: 
> > > Subject:Re: pga_aggregate_target and a memory leak
> > > 
> > > 
> > > Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 
> > > 4.3.3 and 9.2.0.4 caused
> > > ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) 
> > > were all set to
> > > 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S 
> > > (and S_A_R_S) worked,
> > > however, the disk sorts increased. Finally, Developers chose no hash 
> > > joins, 1GB P_A_T and 'AUTO'
> > > workarea_size_policy... seems to run okay...
> > > 
> > > - Kirti 
> > > 
> > > 
> > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> > > > [EMAIL PROTECTED] wrote:
> > > > > 
> > > > > One of our production DBAs does not want to use pga_aggregate_target 
> > > on a 9.2.0.3 instance due
> > > > to a possible memory leak. The only note on memory leaks and 
> > > pga_aggregate_target I can find on
> > > > metalink is: 334427.995
> > > > > 
> > > > > doesnt seem to apply to pga_aggregate_target. We are on sun solaris. 
> > > Dont know version
> > > > offhand.
> > > > > 
> > > > > he is under the impression that if we patch to 9.2.0.4 this goes away. 
> > > not sure about that
> > > > either...
> > > > > 
> > > > 
> > > > Be careful with pga_aggregate_target. I have very recently seen 

RE: Password management using profiles

[Ana Choto]

Thanks for your reponses.  We're working on make these changes now.

Ana E. Choto
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax  (202) 885-2224


   
 "Spears, Brian"   
 <[EMAIL PROTECTED] 
 rands.com> To 
 Sent by:  Multiple recipients of list 
 [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]> 
 .com   cc 
   
   Subject 
 01/21/2004 02:54  RE: Password management using   
 PMprofiles
   
   
 Please respond to 
 [EMAIL PROTECTED] 
com
   
   




Yup..we just added the functionalty to the verify_password
functionwala.

Brian S.

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 5:59 PM
To: Multiple recipients of list ORACLE-L



You have to check for errors in the ORA-28000 range, for this is the
range that  password problems will use.  Add a check in your connection
section that will propagate any exception encountered. You can also trap
the Oracle errors for password expiration or locked account and display
a more understandable message instead.  This is the way I did it.  Also,
create a function or procedure that checks the EXPIRY_DATE and
ACCOUNT_STATUS in the all_users or dba_users table to determine when the
password will expire or if it has already. The function/procedure then
can raise an exception if the account is within the grace period or
locked.

RWB




Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED] [EMAIL PROTECTED]






[EMAIL PROTECTED]

n.eduTo: [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED]   Subject: Re: Password
management using profiles
ity.com





01/20/2004

02:49 PM

Please respond

to ORACLE-L













We're using pl/sql gateway and the Apache server.  We've set up a
default DAD on the gateway configuration screen, the connect string is
our server name.  Basic authentication, Package/Session Management Type:
Stateless(Reset Package State).

I've tried the profile by setting up a test user and expiring the
account. If I go to sqlplus and log in with the expired user account
sqlplus prompts me for a new password.  I don't have a problem with
that, but you know how users are, they wouldn't figure out why.  And
management wants users to receive a message telling them why they have
to change their passwords without going through the Help Desk.

My guess is that a pl/sql package has to be written so users get their
password check at login time and receive messages such as the number of
days they have before the password expires, or that the password is
actually expired.

Thanks

Ana E. Choto
Systems Programmer
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax  (202) 885-2224



 Mladen Gogala
 <[EMAIL PROTECTED]
 ng.com>
To
 Sent by:  Multiple recipients of list
 [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]>
     .com
cc


Subject
 01/20/2004 03:24  Re: Password management using
 PMprofiles


 Please respond to
 [EMAIL PROTECTED]
com






On 01/20/2004 02:34:45 PM, Ana Choto wrote:
>
>
>
>
> I have set up a profile where the passwords expire in 30 days, 6
> characters minimum, grace period before 

Re: Password management using profiles

[Mladen Gogala]

On 01/21/2004 02:54:25 PM, "Spears, Brian" wrote:
Yup..we just added the functionalty to the verify_password
functionwala.
Brian S.

Brian, are you related to the young lady named Britney and whose
marriage was shorter then the average transaction on my database?
She happens to have the same last name as you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: V$system_event

[Mladen Gogala]

On 01/21/2004 02:29:26 PM, Cary Millsap wrote:
Jolene,

Mladen's answer is a good one. There is also an in-depth discussion  
on
this subject on pp210-217 of the book "Optimizing Oracle  
Performance."
I knew that you will immediately recognize "method C"!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-12540: TNS: internal limit restriction exceeded

[Murali_Pavuloori/Claritas]

I apologise for the wrong error #...it was a typo on my partthe error #
is 12540

Here is the error stack
===
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12540: TNS:internal limit restriction exceeded
  TNS-12560: TNS:protocol adapter error
   TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
===

Murali.





|-+>
| |   "Faan DeSwardt"  |
| |   <[EMAIL PROTECTED]|
| |   et>  |
| |   Sent by: |
| |   [EMAIL PROTECTED]|
| |   .com |
| ||
| ||
| |   01/21/2004 03:09 |
| |   PM   |
| |   Please respond to|
| |   ORACLE-L |
| ||
|-+>
  
>--|
  |
  |
  |   To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   
   |
  |   cc:  
      |
  |   Subject:  Re: ORA-12540: TNS: internal limit restriction exceeded
  |
  
>--|




Murali,

Have you checked the OS event logs like the system log?  Sounds like you
have hit an OS limit.  Please post the rest of the error stack that
followed
the ORA-12450 as this gives more information on what is the root cause of
this failure?  You can find this in the listener.log at the time of the
failure.

-f
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 10:19 AM


>
> Hi All,
>
> We are running 9.2.0.4 on windoze 2000 server and this morning we were
> forced to restart the database server. Users complained about not able to
> connect to database...
> "TNS could not start dedicated server process"...So I tried to connect to
> db using OS authentication...(sqlplus "/ as sysdba") and ran into
> ORA-12540: TNS: internal limit restriction exceeded.
>
> Where is this limit set? Is it possible to change the setting?
>
> Here is some additional information
>
> The application that connects to this db is java based...In the past when
> we were seeing lot of 4030 errors in the alert log, we opened a case with
> oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process
memory
> when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree)
> ]]
>
> Oracle response to the TAR was that there were some memory leaks with
> executing java stored procedures and recommended applying the 9.2.0.4
> patch...which we did ...It did not fix the issue. We have noticed that
> whenever there are many occurances of 4030 in the alert log users run
into
> "TNS could not start dedicated server process" and we are forced to
> restart.
>
> Your help in this matter is greatly appreciated.
>
> Thanks for your time
>
> Murali.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: Murali_Pavuloori/[EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line conta

Re: What gives??

[Stephane Faroult]

[EMAIL PROTECTED] oriole]$  export AWK="awk '{print \$4}'"
[EMAIL PROTECTED] oriole]$ echo ${AWK}
awk '{print $4}'
[EMAIL PROTECTED] oriole]$ cal | awk '{print $4}'

We

7
14
21
28

[EMAIL PROTECTED] oriole]$ cal | ${AWK}
awk: cmd. line:1: '{print
awk: cmd. line:1: ^ Invalid char ''' in expression

[EMAIL PROTECTED] oriole]$ cal | "${AWK}"
bash: awk '{print $4}': command not found
[EMAIL PROTECTED] oriole]$ cal | eval "${AWK}"

We

7
14
21
28

[EMAIL PROTECTED] oriole]$ 


Nikhil Khimani wrote:
> 
> L&G,
> 
> I know there is a simple solution to this .. but I can't think of it right
> now. Any help will be appreciated ...
> 
> Thanks,
> 
> Nikhil
> 
> 
> =
> [ny-nikhil1:/export/home/nkhimani/bin]$ export AWK="awk '{print \$4}'"
> [ny-nikhil1:/export/home/nkhimani/bin]$ echo ${AWK}
> awk '{print $4}'
> [ny-nikhil1:/export/home/nkhimani/bin]$ cal | awk '{print $4}'
> 
> W
> 
> 7
> 14
> 21
> 28
> 
> [ny-nikhil1:/export/home/nkhimani/bin]$ cal | ${AWK}
> awk: syntax error near line 1
> awk: bailing out near line 1
> [ny-nikhil1:/export/home/nkhimani/bin]$
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nikhil Khimani
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

RE: Old thread - trace file location

[DENNIS WILLIAMS]

Okay, I was hallucinating -- and it is only Wednesday! I had been looking
through some old emails yesterday. The thread was on September 17 & 18,
2002. If you are interested, go to Google and enter Oracle-l "backup
controlfile to trace". Elegant solutions were posted by Waleed Khedr,
Richard Markham, and Ron Thomas. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 21, 2004 11:19 AM
To: Multiple recipients of list ORACLE-L


Unless I am hallucinating (always a distinct possibility), there was a
recent discussion on this list about the trace file location when you
perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious
solutions. I didn't think I'd need this, so deleted the postings. Well,
guess what I need that. Could someone who saved some of these forward me the
date and subject? Do it privately to avoid clogging the bandwidth. Thanks.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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

Re: ORA-12540: TNS: internal limit restriction exceeded

[Faan DeSwardt]

Murali,

Have you checked the OS event logs like the system log?  Sounds like you
have hit an OS limit.  Please post the rest of the error stack that followed
the ORA-12450 as this gives more information on what is the root cause of
this failure?  You can find this in the listener.log at the time of the
failure.

-f
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 10:19 AM


>
> Hi All,
>
> We are running 9.2.0.4 on windoze 2000 server and this morning we were
> forced to restart the database server. Users complained about not able to
> connect to database...
> "TNS could not start dedicated server process"...So I tried to connect to
> db using OS authentication...(sqlplus "/ as sysdba") and ran into
> ORA-12540: TNS: internal limit restriction exceeded.
>
> Where is this limit set? Is it possible to change the setting?
>
> Here is some additional information
>
> The application that connects to this db is java based...In the past when
> we were seeing lot of 4030 errors in the alert log, we opened a case with
> oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process memory
> when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree)
> ]]
>
> Oracle response to the TAR was that there were some memory leaks with
> executing java stored procedures and recommended applying the 9.2.0.4
> patch...which we did ...It did not fix the issue. We have noticed that
> whenever there are many occurances of 4030 in the alert log users run into
> "TNS could not start dedicated server process" and we are forced to
> restart.
>
> Your help in this matter is greatly appreciated.
>
> Thanks for your time
>
> Murali.
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   INET: Murali_Pavuloori/[EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

Re: Re: pga_aggregate_target and a memory leak

[ryan.gaffuri]

kirti-- would you recommend avoiding pga_aggregate_target for now? 
> 
> From: Kirtikumar Deshpande <[EMAIL PROTECTED]>
> Date: 2004/01/21 Wed PM 02:44:31 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: pga_aggregate_target and a memory leak
> 
> Replies in line... 
> 
> - Kirti 
> 
> --- [EMAIL PROTECTED] wrote:
> > Kirti, you're back! 
> 
> Thanks. Found some slack time from routine DBA work!  
> 
> > 
> > Must have finished the book.  :)
> 
> Not yet.. Its tough.. 
> 
> 
> 
> > 
> > Re the PGA problems, what was the value for 'over allocation count' in 
> > v$pgastat?
> 
> Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do 
> some more
> testing next week..
> 
> 
> > 
> > Did you try increasing P_A_T to a larger number? 
> 
> Yes... 
> 
> 
> > 
> > Oracle is supposed to grab the memory it needs, if available, regardless 
> > of
> > the P_A_T setting. 
> > 
> > Also, did your system go in to excessive paging or swapping?
> 
> Yes, it did with a large P_A_T. 
> 
> 
> > 
> > I've been curious as to what the effects would be of having P_A_T too low.
> 
> I saw more disk sorts.. 
> 
> As time permits, I will play with event 10032, 10033 trace for sorts to see what's 
> going on.. 
> 
> 
> > 
> > Oracle is supposed to grab whatever memory it needs.  I'm assuming at this
> > point that doing so involves a different code path as it needs to alloc 
> > the memory.
> > 
> > Don't know what the cost of that is, haven't tried to test it.
> > 
> > It seems likely that the OS was out of memory, regardless of the P_A_T 
> > value.
> > 
> No. The system has 4 GB of physical memory. Over 2GB was free. 
> 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> >  01/21/2004 06:09 AM
> >  Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > cc: 
> > Subject:Re: pga_aggregate_target and a memory leak
> > 
> > 
> > Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 
> > 4.3.3 and 9.2.0.4 caused
> > ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) 
> > were all set to
> > 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S 
> > (and S_A_R_S) worked,
> > however, the disk sorts increased. Finally, Developers chose no hash 
> > joins, 1GB P_A_T and 'AUTO'
> > workarea_size_policy... seems to run okay...
> > 
> > - Kirti 
> > 
> > 
> > --- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> > > [EMAIL PROTECTED] wrote:
> > > > 
> > > > One of our production DBAs does not want to use pga_aggregate_target 
> > on a 9.2.0.3 instance due
> > > to a possible memory leak. The only note on memory leaks and 
> > pga_aggregate_target I can find on
> > > metalink is: 334427.995
> > > > 
> > > > doesnt seem to apply to pga_aggregate_target. We are on sun solaris. 
> > Dont know version
> > > offhand.
> > > > 
> > > > he is under the impression that if we patch to 9.2.0.4 this goes away. 
> > not sure about that
> > > either...
> > > > 
> > > 
> > > Be careful with pga_aggregate_target. I have very recently seen a case
> > > (Solaris + 9.2 but I cant't tell you exactly which patch level -
> > > probably the most recent) where two (by the way atrocious) queries
> > > generated by a DSS tool were responding very differently - and in a way
> > > that differences in the queries couldn't explain. From an Oracle
> > > standpoint, stats were roughly the same. Tracing proved that we were
> > > waiting for CPU, and truss that a call to mmap() was the culprit. Why,
> > > no idea. We first switched it (pga_thing) off, no more slow call to
> > > mmap(). However, it was still slow because we hadn't checked
> > > sort_area_size which was ridiculously small. We set sort_area_size to
> > > 10M, still with pga_aggregate_target unset, and once again the same very
> > > slow calls to mmap(). Memory misalignment? Anything else? Not much time
> > > to enquire but it looks like a mine field.
> > > 
> > > -- 
> > > Re

RE: Password management using profiles

[Spears, Brian]

Yup..we just added the functionalty to the verify_password
functionwala.

Brian S.

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 5:59 PM
To: Multiple recipients of list ORACLE-L



You have to check for errors in the ORA-28000 range, for this is the
range that  password problems will use.  Add a check in your connection
section that will propagate any exception encountered. You can also trap
the Oracle errors for password expiration or locked account and display
a more understandable message instead.  This is the way I did it.  Also,
create a function or procedure that checks the EXPIRY_DATE and
ACCOUNT_STATUS in the all_users or dba_users table to determine when the
password will expire or if it has already. The function/procedure then
can raise an exception if the account is within the grace period or
locked.

RWB




Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED] [EMAIL PROTECTED]




 

[EMAIL PROTECTED]

n.eduTo: [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED]   Subject: Re: Password
management using profiles 
ity.com

 

 

01/20/2004

02:49 PM

Please respond

to ORACLE-L

 

 









We're using pl/sql gateway and the Apache server.  We've set up a
default DAD on the gateway configuration screen, the connect string is
our server name.  Basic authentication, Package/Session Management Type:
Stateless(Reset Package State).

I've tried the profile by setting up a test user and expiring the
account. If I go to sqlplus and log in with the expired user account
sqlplus prompts me for a new password.  I don't have a problem with
that, but you know how users are, they wouldn't figure out why.  And
management wants users to receive a message telling them why they have
to change their passwords without going through the Help Desk.

My guess is that a pl/sql package has to be written so users get their
password check at login time and receive messages such as the number of
days they have before the password expires, or that the password is
actually expired.

Thanks

Ana E. Choto
Systems Programmer
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax  (202) 885-2224



 Mladen Gogala
 <[EMAIL PROTECTED]
 ng.com>
To
 Sent by:  Multiple recipients of list
 [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]>
 .com
cc

 
Subject
     01/20/2004 03:24  Re: Password management using
 PMprofiles


 Please respond to
 [EMAIL PROTECTED]
com






On 01/20/2004 02:34:45 PM, Ana Choto wrote:
>
>
>
>
> I have set up a profile where the passwords expire in 30 days, 6 
> characters minimum, grace period before the account locks to 6 days.  
> It works as
> expected when the user logs in to our web site and tries to change
> the
> password.  Users receive error messages whenever their password
> doesn't
> comply with the rules we have set up in the profile.  We use the
> verify_function.
>
> The only problem I have is that when the users go to our web site they
> are
> presented with a login screen.  If their account is locked or
> expired,
> or
> it is within the grace period before the account expires they don't
> receive
> a message to that account.  If the account is expired the login
> screen
> resets and prompts for user id and password over and over.
>
> I have opened a TAR wit Oracle support, but they don't have an answer 
> to that effect.  They say it is an application issue.  I've researched
> everywhere I could think of and everything I have found is the same,
> use
> profiles and the verify_function function.  I've also read the
> documentation regarding password management, but I couldn't find
> anything
> of help.
>
> Our database is 8.1.7.2, and we're in Unix 5.8.  We're using 9iAS 
> release 1.  We have created a DAD to connect to the database.  When 
> users click on
> our link then they see the login screen, just the same way as
> Metalink's.
> Only if they sign on successfully and try to change the password the
> profile works as a charm.
>
> I guess we 

RE: SQL Code release

[Ashish Sahasrabudhe]

Title: SQL Code release



It 
seems we also need to write our own tool.

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 
  2004 11:20 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: SQL Code release
  OEM has such a tool built into it ... we went through a research, ended 
  up writing our own because each environment is different.
   
  Raj
   
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  
-Original Message-From: Ashish Sahasrabudhe 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 
21, 2004 11:10 AMTo: Multiple recipients of list 
ORACLE-LSubject: SQL Code release
Is there a tool available to release same set of DDLs, DMLs, 
PL/SQL code in different database environments like 
QA, Unit Testing, Production Support etc. I guess 
this can done by writing shell or batch scripts. But I am looking for 
a GUI tools to do this. 
Thanks 
  **This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, attorney work product or 
  exempt from disclosure under applicable law. If you have received this message 
  in error, or are not the named recipient(s), please immediately notify 
  corporate MIS at (860) 766-2000 and delete this e-mail message from your 
  computer, Thank 
  you.**4 

Re: pga_aggregate_target and a memory leak

[Kirtikumar Deshpande]

Replies in line... 

- Kirti 

--- [EMAIL PROTECTED] wrote:
> Kirti, you're back! 

Thanks. Found some slack time from routine DBA work!  

> 
> Must have finished the book.  :)

Not yet.. Its tough.. 



> 
> Re the PGA problems, what was the value for 'over allocation count' in 
> v$pgastat?

Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do 
some more
testing next week..


> 
> Did you try increasing P_A_T to a larger number? 

Yes... 


> 
> Oracle is supposed to grab the memory it needs, if available, regardless 
> of
> the P_A_T setting. 
> 
> Also, did your system go in to excessive paging or swapping?

Yes, it did with a large P_A_T. 


> 
> I've been curious as to what the effects would be of having P_A_T too low.

I saw more disk sorts.. 

As time permits, I will play with event 10032, 10033 trace for sorts to see what's 
going on.. 


> 
> Oracle is supposed to grab whatever memory it needs.  I'm assuming at this
> point that doing so involves a different code path as it needs to alloc 
> the memory.
> 
> Don't know what the cost of that is, haven't tried to test it.
> 
> It seems likely that the OS was out of memory, regardless of the P_A_T 
> value.
> 
No. The system has 4 GB of physical memory. Over 2GB was free. 

> Jared
> 
> 
> 
> 
> 
> 
> Kirtikumar Deshpande <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  01/21/2004 06:09 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc: 
> Subject:Re: pga_aggregate_target and a memory leak
> 
> 
> Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 
> 4.3.3 and 9.2.0.4 caused
> ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) 
> were all set to
> 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S 
> (and S_A_R_S) worked,
> however, the disk sorts increased. Finally, Developers chose no hash 
> joins, 1GB P_A_T and 'AUTO'
> workarea_size_policy... seems to run okay...
> 
> - Kirti 
> 
> 
> --- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> > [EMAIL PROTECTED] wrote:
> > > 
> > > One of our production DBAs does not want to use pga_aggregate_target 
> on a 9.2.0.3 instance due
> > to a possible memory leak. The only note on memory leaks and 
> pga_aggregate_target I can find on
> > metalink is: 334427.995
> > > 
> > > doesnt seem to apply to pga_aggregate_target. We are on sun solaris. 
> Dont know version
> > offhand.
> > > 
> > > he is under the impression that if we patch to 9.2.0.4 this goes away. 
> not sure about that
> > either...
> > > 
> > 
> > Be careful with pga_aggregate_target. I have very recently seen a case
> > (Solaris + 9.2 but I cant't tell you exactly which patch level -
> > probably the most recent) where two (by the way atrocious) queries
> > generated by a DSS tool were responding very differently - and in a way
> > that differences in the queries couldn't explain. From an Oracle
> > standpoint, stats were roughly the same. Tracing proved that we were
> > waiting for CPU, and truss that a call to mmap() was the culprit. Why,
> > no idea. We first switched it (pga_thing) off, no more slow call to
> > mmap(). However, it was still slow because we hadn't checked
> > sort_area_size which was ridiculously small. We set sort_area_size to
> > 10M, still with pga_aggregate_target unset, and once again the same very
> > slow calls to mmap(). Memory misalignment? Anything else? Not much time
> > to enquire but it looks like a mine field.
> > 
> > -- 
> > Regards,
> > 
> > Stephane Faroult
> > Oriole Software
> > -- 
> 
> 
> 
> 
> 


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

RE: after the discussion yesterday on db2/mysql/postgresql....

[Goulet, Dick]

Thought PostGreSql smelled a lot like DB2.  And although I agree with their 
definitions on the surface they miss a lot of the underlying capability in Oracle.  
Sure, one "database" per instance, but you can them map multiple applications/schema's 
into that instance.  Makes for a lot less fun when one application needs data from 
another that's in the same instance.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 21, 2004 2:14 PM
To: Multiple recipients of list ORACLE-L


I thought this might be relevant and interesting...

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr
ack=NL-93


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

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

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

RE: V$system_event

[Cary Millsap]

Jolene,

Mladen's answer is a good one. There is also an in-depth discussion on
this subject on pp210-217 of the book "Optimizing Oracle Performance."


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Shrake, Jolene
Sent: Wednesday, January 21, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L


These results don't seem possible.  

I run the following query:
select  ((vse.time_waited/100)/60) time_waited,
((vse.time_waited/vse1.total_time)*100) p_time_waited,
vse.event
fromv$system_event vse,  (select sum(time_waited) total_time from
v$system_event) vse1
where   ((vse.time_waited/100)/60) >= .1
and vse.event not in ('SQL*Net message from client','rdbms ipc
message','pmon timer','smon timer')
order by 2 desc
/

The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX 11.11.

The database has been up since Sunday night after the cold backup.

These results seem too large.  Any thoughts?

  Time Waited % Time
(min)  Waited  Wait Event
  ---  
50,771.542.30 db file sequential read
19,129.29 .86 db file scattered read
15,735.79 .71 latch free
15,321.68 .69 io done
15,248.34 .69 log file sync
14,866.87 .67 buffer busy waits
14,718.91 .67 log file parallel write

Thanks for your help,
Jolene
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Shrake, Jolene
  INET: [EMAIL PROTECTED]

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

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

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

Re: pga_aggregate_target and a memory leak

[Jared . Still]

Kirti, you're back! 

Must have finished the book.  :)

Re the PGA problems, what was the value for 'over allocation count' in v$pgastat?

Did you try increasing P_A_T to a larger number?  

Oracle is supposed to grab the memory it needs, if available, regardless of
the P_A_T setting.  

Also, did your system go in to excessive paging or swapping?

I've been curious as to what the effects would be of having P_A_T too low.

Oracle is supposed to grab whatever memory it needs.  I'm assuming at this
point that doing so involves a different code path as it needs to alloc the memory.

Don't know what the cost of that is, haven't tried to test it.

It seems likely that the OS was out of memory, regardless of the P_A_T value.

Jared








Kirtikumar Deshpande <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/21/2004 06:09 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: pga_aggregate_target and a memory leak


Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused
ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to
'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked,
however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO'
workarea_size_policy... seems to run okay...

- Kirti 


--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > 
> > One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due
> to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on
> metalink is: 334427.995
> > 
> > doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version
> offhand.
> > 
> > he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that
> either...
> > 
> 
> Be careful with pga_aggregate_target. I have very recently seen a case
> (Solaris + 9.2 but I cant't tell you exactly which patch level -
> probably the most recent) where two (by the way atrocious) queries
> generated by a DSS tool were responding very differently - and in a way
> that differences in the queries couldn't explain. From an Oracle
> standpoint, stats were roughly the same. Tracing proved that we were
> waiting for CPU, and truss that a call to mmap() was the culprit. Why,
> no idea. We first switched it (pga_thing) off, no more slow call to
> mmap(). However, it was still slow because we hadn't checked
> sort_area_size which was ridiculously small. We set sort_area_size to
> 10M, still with pga_aggregate_target unset, and once again the same very
> slow calls to mmap(). Memory misalignment? Anything else? Not much time
> to enquire but it looks like a mine field.
> 
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Software
> -- 


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

RE: full recovery

[Rich Holland]

Sorry it took so long to get back to you; I've been caching the list for awhile
and am just starting to catch up.  :-)

Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users
Beware!'

Rich
--
Rich Holland(913) 645-1950SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> DENNIS WILLIAMS
> Sent: Friday, November 07, 2003 3:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: full recovery
> 
> Rich - Could you point to the place where Robert states that bit about
> controlfiles to trace? Thanks.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Friday, November 07, 2003 1:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I believe that an 'alter database backup controlfile to trace' loses the
> RMAN data stored in the control files if you're not using a repository (if I
> remember right from RF's book).
> 
> Since we're not using a repository, we've got controlfile autobackup on (in
> 9i use 'configure controlfile autobackup on').  We dump these disk copies
> via filesystem backups as a safety measure.  We also do a backup database,
> archivelogs, and then control (but all in one step; I'm not sure I'm clear
> on the reason for separating them into three backup sets)
> 
> Rich
> --
> Rich Holland(913) 645-1950SAP Technical Consultant
> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > Behalf Of Mercadante, Thomas F
> > Sent: Friday, October 24, 2003 2:35 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: full recovery
> >
> >
> > AK,
> >
> > First, your normal backup should backup your database in the following
> > order:
> >
> > Database, archivelogs and then control file.  I actually do
> > this in three
> > separate Rman steps.  This is so that the most recent control file is
> > backups up after all of the data.  This allows your to perform an
> > incoimplete-recovery-restore to as late a time as possible.
> > Also, consider
> > adding a database trigger that, upon startup, perform an
> > "alter database
> > backup controlfile to trace;"  Keep a copy of this trace file
> > someplace safe
> > as a sanity check.  You could use it to recreate your
> > controlfiles if all
> > else fails.
> >
> > Your recovery steps are as follows:
> >
> > 1. restore oracle software from tape.
> > 2. restore config files ( init.ora , listener. ora ).
> > 3. startup instance with nomount.
> > 4. run Rman to restore the control file from tape.
> > 5. Alter database mount
> > 6. run Rman to restore database files
> > 7. alter database open resetlogs.
> > 8. perform a brand-new Rman backup (database, logs & controlfile)
> >
> > turn the system back to the users (with many back-pats from
> > management).
> >
> > You should be testing this on a regular basis.
> >
> > Good Luck!
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> > -Original Message-
> > Sent: Friday, October 24, 2003 2:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Here is a scenerio :
> > I am taking full database backup everynight using rman to tape . which
> > includes archive logs and control file. Not using
> > catalog.Also have a backup
> > of complete file system including oracle software and
> > configuration files (
> > init.ora , listener.ora etc.. )
> > I lost the host on a particular day at 12 am afternoon. Now I want to
> > restore this db to latest possible time to another host (
> > with same name )
> >
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rich Holland
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the H

Re[2]: OT : Happy Spring Festival

[Jonathan Gennick]

Wednesday, January 21, 2004, 1:14:25 PM, Goulet, Dick ([EMAIL PROTECTED]) wrote:
GD> 500 below zero. Hell freezes over. Red Sox win the World Series. 

LOL! Hey, that's funny. But you know, Hell freezes every
year here in Michigan (zoom in one notch to see it):

http://www.mapquest.com/maps/map.adp?formtype=search&countryid=250&addtohistory=&country=US&address=&city=hell&state=mi&zipcode=&historyid=&submit=Get+Map

And, oddly enough, Paradise is not only colder, but it gets
far more snow, and more snowmobiles:

http://www.mapquest.com/maps/map.adp?formtype=search&countryid=250&addtohistory=&country=US&address=&city=paradise&state=mi&zipcode=&historyid=&submit=Get+Map

And I won't even get into Christmas, which is only about
four miles from my home:

http://www.mapquest.com/maps/map.adp?formtype=search&countryid=250&addtohistory=&country=US&address=&city=Christmas&state=mi&zipcode=&historyid=&submit=Get+Map

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

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

Re: FW: Disk capacity planning

[Mladen Gogala]

When I worked for Oxford, there was a way to force the application to
either perform or die. The OLTP database was enforcing profiles and  
there was limit of 1500 logical reads per call, because it was
estimated that our typical OLTP application never performs more
then that. If application was unable to achieve that performance, it
wasn't allowed to the production OLTP system. That way, the performance
could be guaranteed.

On 01/21/2004 01:19:26 PM, [EMAIL PROTECTED] wrote:
See the "Ratio Modeling" paper at Orapub.com

It is a quick and dirty method for capacity planning.





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/21/2004 01:34 AM
 Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
        Subject:Re: FW: Disk capacity planning
Mladen,

I agree you can measure how many IOs are being done and how many a
disk
sub-
system, such as those provided by EMC, can perform and still give
"good"
performance. What I meant is that it is hard and some would say
impossible
to
estimate how many IOs per sec a new application will do. A  
combination
of
paper
calculations, testing, experience and looking at comparable systems
will
help
to provide a good estimate.

Cheers,

Chris

Quoting Mladen Gogala <[EMAIL PROTECTED]>:

> Oh, but it is done, you only need to ask. EMC routinely measures  
how

many
> I/Os
> per second can they perform and they even have tools to measure it.
Speaking
> of
> monitoring I/O, there used to be an old OS, which is mostly dead
today
and it
> used
> to have command monitor io/item=queue which would show length of  
the
I/O
> queues
> per device, which was extremely useful, because you could quickly
find
out
> which
> devices are "hot" and which are not.
>
>
> On 2004.01.20 04:19, [EMAIL PROTECTED] wrote:
> > Cary,
> >
> > Good answer. The problem is most people concentrate on bytes
because
it's
> > relatively easy and everyone understands it. IOs per sec is much
harder to
>
> > calculate for a new system and hence it's not normally done.
> >
> > Cheers,
> >
> > Chris Dunscombe
> >
> >
> >
> > Quoting Cary Millsap <[EMAIL PROTECTED]>:
> >
> > > I don't think this one made it through on my first attempt.
> > >
> > >
> > >
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > > Nullius in verba
> > >
> > > Upcoming events:
> > > - Performance <http://www.hotsos.com/training/PD101.html>
Diagnosis
> > > 101: 1/27 Atlanta
> > > - SQL Optimization 101: 2/16 Dallas
> > > - Hotsos Symposium 2004  
<http://www.hotsos.com/events/symposium/2004>
:
> > > March 7-10 Dallas
> > > - Visit www.hotsos.com for schedule details...
> > >
> > > -Original Message-
> > > Sent: Tuesday, January 13, 2004 5:54 PM
> > > To: '[EMAIL PROTECTED]'
> > >
> > >
> > >
> > > Counting bytes is far, far, FAR less important than counting
> > > I/O-per-second (IOps) requirements and making sure that you  
have

enough
> > > total capacity to handle your system's peak I/O loads. Counting
bytes is
> > > important too, but what many people find is that the
byte-counting
> > > exercise will result in the sub-verdict of needing far fewer
disk
drives
> > > than you'll really, truly need.
> > >
> > >
> > >
> > > The way I'd recommend structuring your project is to evaluate
the
> > > following:
> > >
> > >
> > >
> > > -  How many bytes will you need to store your data? How
many
> > > disks is that? Call the answer B.
> > >
> > > -  How many disks will you need to meet your IOps
requirements?
> > > Call the answer P.
> > >
> > > -  How many disks will you need to meet your
availability
> > > requirements? Call the answer A.
> > >
> > > -  (Consider other attributes as necessary, like  
perhaps
I/O
> > > throughput requirements.)
> > >
> > >
> > >
> > > Roughly speaking, the number of disks you'll need to buy is
max(B,
P, A,
> > > .). It's more complicated than that because you'll need to
segment
your
> > > total drive set into sensibly-sized arrays, you'll be able to
buy
some
> > > disks now then some later, and so on, but this is the general
gist.
The
> > > important thing is to have enough hardware to meet *all* of the
> > > constraints you

Re: V$system_event

[Mladen Gogala]

The result depends on the number of sessions. If you have
session A waiting for a 'enqueue lock' for 10 minutes and session
B waiting for the same lock as session A for another 10 minutes,
then the recorded time is 20 minutes, despite the fact that sessions
are waiting concurrently. If you have, say, 500 concurrent sessions,
the numbers will be exorbitant.
V$SYSTEM_EVENT is a summary table and not very useful at that. Your  
query gives you the most important thing:the percentages. The  
percentages tell you that I/O related events ('scattered read' for
table scans and 'sequential read' for index scans) are not taking too
much time, relative to the other events. In other words, you found
another way of calculating BHCR and have significantly advanced  
something that one of the recent books calls "method C".

On 01/21/2004 11:44:25 AM, "Shrake, Jolene" wrote:
These results don't seem possible.

I run the following query:
select  ((vse.time_waited/100)/60) time_waited,
((vse.time_waited/vse1.total_time)*100) p_time_waited,
vse.event
fromv$system_event vse,  (select sum(time_waited) total_time from
v$system_event) vse1
where   ((vse.time_waited/100)/60) >= .1
and vse.event not in ('SQL*Net message from client','rdbms ipc
message','pmon timer','smon timer')
order by 2 desc
/
The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX
11.11.
The database has been up since Sunday night after the cold backup.

These results seem too large.  Any thoughts?

  Time Waited % Time
(min)  Waited  Wait Event
  --- 
50,771.542.30 db file sequential read
19,129.29 .86 db file scattered read
15,735.79 .71 latch free
15,321.68 .69 io done
15,248.34 .69 log file sync
14,866.87 .67 buffer busy waits
14,718.91 .67 log file parallel write
Thanks for your help,
Jolene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shrake, Jolene
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: FW: Disk capacity planning

[Jared . Still]

See the "Ratio Modeling" paper at Orapub.com

It is a quick and dirty method for capacity planning.








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/21/2004 01:34 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: FW: Disk capacity planning


Mladen,

I agree you can measure how many IOs are being done and how many a disk sub-
system, such as those provided by EMC, can perform and still give "good" 
performance. What I meant is that it is hard and some would say impossible to 
estimate how many IOs per sec a new application will do. A combination of paper 
calculations, testing, experience and looking at comparable systems will help 
to provide a good estimate.

Cheers,

Chris


Quoting Mladen Gogala <[EMAIL PROTECTED]>:

> Oh, but it is done, you only need to ask. EMC routinely measures how many
> I/Os
> per second can they perform and they even have tools to measure it. Speaking
> of
> monitoring I/O, there used to be an old OS, which is mostly dead today and it
> used
> to have command monitor io/item=queue which would show length of the I/O
> queues
> per device, which was extremely useful, because you could quickly find out
> which
> devices are "hot" and which are not.
> 
> 
> On 2004.01.20 04:19, [EMAIL PROTECTED] wrote:
> > Cary,
> > 
> > Good answer. The problem is most people concentrate on bytes because it's 
> > relatively easy and everyone understands it. IOs per sec is much harder to
> 
> > calculate for a new system and hence it's not normally done.
> > 
> > Cheers,
> > 
> > Chris Dunscombe
> > 
> > 
> > 
> > Quoting Cary Millsap <[EMAIL PROTECTED]>:
> > 
> > > I don't think this one made it through on my first attempt.
> > > 
> > >  
> > > 
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > > Nullius in verba
> > > 
> > > Upcoming events:
> > > - Performance   Diagnosis
> > > 101: 1/27 Atlanta
> > > - SQL Optimization 101: 2/16 Dallas
> > > - Hotsos Symposium 2004  :
> > > March 7-10 Dallas
> > > - Visit www.hotsos.com for schedule details...
> > > 
> > > -Original Message-
> > > Sent: Tuesday, January 13, 2004 5:54 PM
> > > To: '[EMAIL PROTECTED]'
> > > 
> > >  
> > > 
> > > Counting bytes is far, far, FAR less important than counting
> > > I/O-per-second (IOps) requirements and making sure that you have enough
> > > total capacity to handle your system's peak I/O loads. Counting bytes is
> > > important too, but what many people find is that the byte-counting
> > > exercise will result in the sub-verdict of needing far fewer disk drives
> > > than you'll really, truly need.
> > > 
> > >  
> > > 
> > > The way I'd recommend structuring your project is to evaluate the
> > > following:
> > > 
> > >  
> > > 
> > > -          How many bytes will you need to store your data? How many
> > > disks is that? Call the answer B.
> > > 
> > > -          How many disks will you need to meet your IOps requirements?
> > > Call the answer P.
> > > 
> > > -          How many disks will you need to meet your availability
> > > requirements? Call the answer A.
> > > 
> > > -          (Consider other attributes as necessary, like perhaps I/O
> > > throughput requirements.)
> > > 
> > >  
> > > 
> > > Roughly speaking, the number of disks you'll need to buy is max(B, P, A,
> > > .). It's more complicated than that because you'll need to segment your
> > > total drive set into sensibly-sized arrays, you'll be able to buy some
> > > disks now then some later, and so on, but this is the general gist. The
> > > important thing is to have enough hardware to meet *all* of the
> > > constraints your business will place upon your system.
> > > 
> > >  
> > > 
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > > Nullius in verba
> > > 
> > > Upcoming events:
> > > - Performance   Diagnosis
> > > 101: 1/27 Atlanta
> > > - SQL Optimization 101: 2/16 Dallas
> > > - Hotsos Symposium 2004  :
> > > March 7-10 Dallas
> > > - Visit www.hotsos.com for schedule details..

RE: Healty ratio of index segment size vs table segment size?

[Goulet, Dick]

They appear to be Tango Uniform today!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 21, 2004 12:25 PM
To: Multiple recipients of list ORACLE-L


www.ixora.com.au

there is a script in there that will identify unnecessary redundant indexes. 

for the record, that is one of the best oracle websites out there. Lots of great stuff 
on it. 
> 
> From: Branimir Petrovic <[EMAIL PROTECTED]>
> Date: 2004/01/21 Wed AM 10:39:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Healty ratio of index segment size vs table segment size?
> 
> Wondering if there is a "rule of thumb", quick'n fast but good enough 
> to be used as an indicator, litmus paper so to speak, of overly indexed 
> table(s)...
> 
> Can, better yet - should, sheer size comparison of index versus table 
> segments be used as a reliable pointer to problematic table indexing?
> 
> If it can, what could be considered as average "healthy ratio" above
> which would be prudent to have a closer look and investigate?
> 
> Related to the above dilemma, how "expensive" is to monitor index usage,
> say if script is run against all few hundred indexes on app tables, 
> would the additional load noticeably affect application performance or 
> is it better/safer or may be required to monitor not more than just a 
> few "most suspected" indexes at a time?
> 
> Thoughts, pointers, opinions - appreciated.
> 
> Branimir  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Branimir Petrovic
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

RE: OT : Happy Spring Festival

[Goulet, Dick]

Title: RE: OT : Happy Spring Festival




60 above zero. Floridians turn the heat on. People in New 
England plant gardens. 

50 above zero. Californians shiver uncontrollably. People in New 
England sunbathe. 

40 above zero. Italian and English cars won't start. People in 
New England drive with 
the windows down. 

32 above zero. Distilled water freezes. Moosehead Lake's water 
gets thicker. 


20 above zero. Floridians don coats, thermal underwear, gloves 
and hats. People in 
New England throw on a flannel shirt. 

15 above zero. New York landlords finally turn on the heat. 
People in New England 
have the last cookout before it turns cold. 

Zero. People in Miami die - or return to Cuba. New Englanders 
close the windows. 


10 below zero. Californians go to Mexico. People in New England 
get out their Winter 
coats. 

25 below zero. Hollywood disintegrates. Girl Scouts in New 
England are selling 
cookies door to door. 

40 below zero. Washington DC runs out of hot air. People in New 
England let the dogs 
sleep inside. 

100 below zero. Santa Claus abandons the North Pole. People in 
New England get 
frustrated because "the caah won't staaht". 

275 below zero. All atomic motion stops. (Absolute zero on the 
Kelvin scale).People 
in New England start saying, "cold nuff for ya?" 

500 below zero. Hell freezes over. Red Sox win the World Series. 

 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDA [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  January 21, 2004 10:15 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: OT : Happy Spring 
Festival
  At least you probably have a warm fuzzy feeling about your 
  Patriots going to the supberbowl. 
  -Original Message- From: 
  Mladen Gogala [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, January 21, 2004 8:45 AM 
  To: Multiple recipients of list ORACLE-L Subject: Re: OT : Happy Spring Festival 
  On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: 
  > ... to whomever is concerned ... > > Regards, > 
  > Stephane Faroult > 
  Oriole 
  Spring??? What is "spring"? I live in New England, we have 
  record colds and I dunno what the heck is spring? Is that something like 70 
  degrees? I've heard about that mythical event but at present I'm shoveling 
  snow on -20 degrees. 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Mladen Gogala   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed from).  You 
  may also send the HELP command for other information (like 
  subscribing).

Re: SQL Code release

[eric king]

Title: SQL Code release



checkout tools for www.agileinfosoftware.com, we use 
DataAnalyst to do similiar jobs like yours.
 
Eric
 

  - Original Message - 
  From: 
  Ashish Sahasrabudhe 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 21, 2004 11:09 
  AM
  Subject: SQL Code release
  
  Is there a tool available to release same set of DDLs, DMLs, 
  PL/SQL code in different database environments like 
  QA, Unit Testing, Production Support etc. I guess this 
  can done by writing shell or batch scripts. But I am looking for 
  a GUI tools to do this. 
  Thanks 

RE: 9iAS Calender Servlet

[John Flack]

"Calendar servlet" sounds pretty generic.  What more specifically do you want your 
servlet to do?

If you are writing a PL/SQL Web app with mod_plsql, you might want to look into the 
OWA_UTIL procedure that takes a query and writes a calendar page in HTML.  The query 
includes columns for the dates to be shown on the calendar, text to be shown in the 
cell for each date, and optionally an URL to which the text will be a link. 

-Original Message-
Sent: Wednesday, January 21, 2004 7:45 AM
To: Multiple recipients of list ORACLE-L


Does anybody by chance have any examples for creating a calender servlet
for 9iAS? I have to admit to being a servlet virgin! ;)

Any pointers much apreciated! 

Many thanks

Mark


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

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

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

RE: Oracle 817 client on Windows 2003?

[Ron Thomas]

>From metlink, it looks like the 8.1.7 client is not certified for Windows 2003 
>server.  You should
probably install the 9.2 client on the workstations.  It should ahve no problems 
connecting to the
8.1.7 database on unix.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The box said I needed to have windows 98 or better...So I installed linux."


   
   
  shreepadx.m.vaidy
   
  [EMAIL PROTECTED]  To:   [EMAIL PROTECTED]   
  
  Sent by: cc: 
   
  [EMAIL PROTECTED]    Subject:  RE: Oracle 817 client on 
Windows 2003?   
  .com 
   
   
   
   
   
  01/21/2004 09:59 
   
  AM   
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Hi Michael,

1) You need to ensure that the listener is configured properly.
2) Your tnsnames.ora or namesserver is configured properly.
3) There are no problems in installation of Oracle client,server and
database .

   If the above conditions are satisfied , you should have no problems
in connecting from client to server (database) .
 I am not sure whether it is certified .
 Thanks and regards
Shreepad


-Original Message-
Michael Milligan
Sent: Wednesday, January 21, 2004 9:35 AM
To: Multiple recipients of list ORACLE-L

The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.)
on
Windows 2003. Do you know if it is certified to, or will it do it?

Thanks


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that
any dissemination, distribution or copying of this e-mail is prohibited.
If
you have received this e-mail in error, please notify the sender by
replying
to this message and delete this e-mail immediately.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Milligan
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle 817 client on Windows 2003?

[Reginald . W . Bailey]

Do you mean Windows 2003 Advanced Server?  Check the compatibility matrix
on Metalink.

RWB



Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
[EMAIL PROTECTED]  
 
ngenix.com   To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: Oracle 817 client on Windows 
2003? 
com
  
   
  
   
  
01/21/2004 10:34   
  
AM 
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on
Windows 2003. Do you know if it is certified to, or will it do it?

Thanks


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by
replying
to this message and delete this e-mail immediately.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Milligan
  INET: [EMAIL PROTECTED]

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




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

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

Re: Healty ratio of index segment size vs table segment size?

[ryan.gaffuri]

www.ixora.com.au

there is a script in there that will identify unnecessary redundant indexes. 

for the record, that is one of the best oracle websites out there. Lots of great stuff 
on it. 
> 
> From: Branimir Petrovic <[EMAIL PROTECTED]>
> Date: 2004/01/21 Wed AM 10:39:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Healty ratio of index segment size vs table segment size?
> 
> Wondering if there is a "rule of thumb", quick'n fast but good enough 
> to be used as an indicator, litmus paper so to speak, of overly indexed 
> table(s)...
> 
> Can, better yet - should, sheer size comparison of index versus table 
> segments be used as a reliable pointer to problematic table indexing?
> 
> If it can, what could be considered as average "healthy ratio" above
> which would be prudent to have a closer look and investigate?
> 
> Related to the above dilemma, how "expensive" is to monitor index usage,
> say if script is run against all few hundred indexes on app tables, 
> would the additional load noticeably affect application performance or 
> is it better/safer or may be required to monitor not more than just a 
> few "most suspected" indexes at a time?
> 
> Thoughts, pointers, opinions - appreciated.
> 
> Branimir  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Branimir Petrovic
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Host concurrent program whom call ar60runb

[Hemant K Chitale]

Does your TEST.prog include the environment for ar60runb ?
If it runs as a shell script, does it have $ORACLE_HOME, and $PATH
setup correctly ?
Hemant
At 07:09 AM 21-01-04 -0800, you wrote:
Hi Listers,

I'have registered host concurrent program on Oracle
11.5.9 as TEST.prog which include one line to execute
the ar60runb on command line. Unfortunately this is
does not work for me. The problem is the TEST.prog can
execute any other command or script (shell, Perl,...)
but not ar60runb which I can execute independently.
Could you please help to resolve this problem?

Thanks,

Ben

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kader Ben
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle 817 client on Windows 2003?

[Vaidya, ShreepadX M]

Hi Michael,

1) You need to ensure that the listener is configured properly.
2) Your tnsnames.ora or namesserver is configured properly.
3) There are no problems in installation of Oracle client,server and
database .

   If the above conditions are satisfied , you should have no problems
in connecting from client to server (database) .
I am not sure whether it is certified .
Thanks and regards
Shreepad 


-Original Message-
Michael Milligan
Sent: Wednesday, January 21, 2004 9:35 AM
To: Multiple recipients of list ORACLE-L

The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.)
on
Windows 2003. Do you know if it is certified to, or will it do it?

Thanks


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that
any dissemination, distribution or copying of this e-mail is prohibited.
If
you have received this e-mail in error, please notify the sender by
replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  INET: [EMAIL PROTECTED]

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

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

RE: SQL Code release

[Jamadagni, Rajendra]

Title: SQL Code release



OEM has such a tool built into it ... we went through a research, ended 
up writing our own because each environment is different.
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Ashish Sahasrabudhe 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 
  21, 2004 11:10 AMTo: Multiple recipients of list 
  ORACLE-LSubject: SQL Code release
  Is there a tool available to release same set of DDLs, DMLs, 
  PL/SQL code in different database environments like 
  QA, Unit Testing, Production Support etc. I guess this 
  can done by writing shell or batch scripts. But I am looking for 
  a GUI tools to do this. 
  Thanks **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4

Re: Host concurrent program whom call ar60runb

[Kader Ben]

Hi Hemant,

Many thanks. You are right. It's all about the
variable environments. Now it works fine.

Have nice day.

Ben


--- Hemant K Chitale <[EMAIL PROTECTED]> wrote:
> 
> Does your TEST.prog include the environment for
> ar60runb ?
> If it runs as a shell script, does it have
> $ORACLE_HOME, and $PATH
> setup correctly ?
> Hemant
> At 07:09 AM 21-01-04 -0800, you wrote:
> >Hi Listers,
> >
> >I'have registered host concurrent program on Oracle
> >11.5.9 as TEST.prog which include one line to
> execute
> >the ar60runb on command line. Unfortunately this is
> >does not work for me. The problem is the TEST.prog
> can
> >execute any other command or script (shell,
> Perl,...)
> >but not ar60runb which I can execute independently.
> >
> >Could you please help to resolve this problem?
> >
> >Thanks,
> >
> >Ben
> >
> >
> >__
> >Do you Yahoo!?
> >Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> >http://hotjobs.sweepstakes.yahoo.com/signingbonus
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> >--
> >Author: Kader Ben
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> >San Diego, California-- Mailing list and
> web hosting services
>
>-
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from).  You may
> >also send the HELP command for other information
> (like subscribing).
> 
> Hemant K Chitale
> Oracle 9i Database Administrator Certified
> Professional
> http://hkchital.tripod.com  {last updated 05-Jan-04}
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Hemant K Chitale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  INET: [EMAIL PROTECTED]

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

Re: SQL Code release

[Reginald . W . Bailey]

Sure. You can try the Change Management Pack for Oracle Enterprise Manager
from Oracle. Then there is the bevy of tools from Quest software.
DB Artisan is another.

RWB



Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED]
[EMAIL PROTECTED]


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

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

RE: OT : Happy Spring Festival

[Guang Mei]

Stephane probably meant Chinese New Year, which is tomorrow (1/22/04). This
will be the Year of Monkey.

I live in Boston, the weather has been brutal this winter so far. I cann't
wait for spring to come so I can start to play soccer again.

Guang

-Original Message-
Mladen Gogala
Sent: Wednesday, January 21, 2004 9:45 AM
To: Multiple recipients of list ORACLE-L


On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
> ... to whomever is concerned ...
>
> Regards,
>
> Stephane Faroult
> Oriole

Spring??? What is "spring"? I live in New England, we have record colds
and I dunno what the heck is spring? Is that something like 70 degrees?
I've heard about that mythical event but at present I'm shoveling snow
on -20 degrees.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

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

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

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

Re: Renumber a set of grupped rows?

[Jonathan Lewis]

Although you've had a row-at-a-time version
from someone, you might try something like 
the following if you can't do a "create as
select" to rebuild the original data.

Create table temp
pctfree 0
nologging
as
select 
rowide_rowid,
row_number() over (PARTITION BY DEPTNO order by deptno) x 
from emp;

create unique index t_i on temp(e_rowid);
alter table temp modify e_rowid not null;

update emp e
set
req_id = (
select x from temp t
where t.e_rowid = e.rowid
);

(Just making it up as I go along, so I won't
guarantee that it works).

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 3:04 PM


> Just out of curiocity, and while I am trying to learn about Row_NUMBER(),
> how would you code the following to do an update on the 2nd column?
> 
> >select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x
> >from emp
> 
> thx
> maa

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

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

Re[2]: OT : Happy Spring Festival

[Jonathan Gennick]

Wednesday, January 21, 2004, 9:44:48 AM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG> Spring??? What is "spring"? I live in New England, we have record colds
MG> and I dunno what the heck is spring? Is that something like 70 degrees?
MG> I've heard about that mythical event but at present I'm shoveling snow
MG> on -20 degrees.

Where I live, I'll be cross-country skiing into April. My
first year here I was able to find ice in the woods as late
as May 23:

http://gennick.com/may_ice.html

Actually, some ice lived longer than that, just not the
particular berg I was photographing.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

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

Re:

[Joe Testa]

Raj, bwahahaha, now thats funny :)

joe



Jamadagni, Rajendra wrote:

Funny ... Ashish is from "Weight Watchers" and asking for HELP  my 
advise ... stop starving yourself ... go eat something.
 
Raj
 

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
*From:* Mark Leith [mailto:[EMAIL PROTECTED]
*Sent:* Wednesday, January 21, 2004 9:45 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* RE:
must.resist..temptation.
 
For more help, please dial 999 in the UK, 911 in the US, or open
your phone and dial 712-BEAM-ME-UP for the year 2247.
 
Live long and prosper.
 

-Original Message-
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
*On Behalf Of *Ashish Sahasrabudhe
*Sent:* 21 January 2004 14:34
*To:* Multiple recipients of list ORACLE-L
*Subject:*
HELP

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

RE: cman and oracle names

[Norris, Gregory T [ITS]]

I've used it to allow DB connections through a non-sqlnet-aware firewall, and also to 
enable SSH tunneling of DB sessions.  In the former case the firewall was blocking the 
redirect, although port 1521 itself was open.  In the latter, a redirect would have 
taken us outside the encrypted tunnel.

CMAN doesn't seem particularly featurefull, but it's more than adequate for these type 
of situations.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 8:45 AM
To: Multiple recipients of list ORACLE-L


I sent this last night. Im not sure if it went through. If it did, I apologize for the 
spam. 

Does anyone use CMAN? Its in the certification books(yes I know certification isnt 
very good, but I might as well learn something if Im going to do it), but I dont know 
anyone using it. It strikes me as a poor mans application serve? Or am I missing 
something?

Does anyone use names server? It strikes me as only being useful for client server 
applications or for a large development team where lots of people need Toad and/or 
SQLPlus access to many instances. 

Or have I underestimated its value? 

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

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

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

RE:

[Odland, Brad]

Title: Message



 
Ashish 
realizing his time is short he crawls to the terminal and with his last 
remaining strength double clicks the outlook icon, clicks the new button 
selects "New Mail Message" button, using the shift key he types H - E - L - 
P in the message body window and hits send and then CANCEL to stop the spell 
checker, and then "YES" to send his message anyway. His message careens through 
the internet as he slumps to the floor as the world goes dark. The world will be 
safe now if they can break the code are his final thoughts before oblivion takes 
him.
Minutes later hundreds of Information Systems 
professionals are reading his message wondering what horror occurred that 
drove a man to do this. They pause to reflect and then selecting the message in 
their inbox they press the delete key and go get a fresh cup of 
coffee.
 
 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 
  2004 8:59 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: 
  Funny ... Ashish is from "Weight Watchers" and asking for HELP 
   my advise ... stop starving yourself ... go eat 
  something.
   
  Raj
   
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  
-Original Message-From: Mark Leith 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 
9:45 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: 
must.resist..temptation.
 
For more help, please dial 999 in the UK, 911 in 
the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. 

 
Live long and prosper.
 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Ashish SahasrabudheSent: 21 January 2004 
  14:34To: Multiple recipients of list 
  ORACLE-LSubject: 
  HELP 

Re: ADMIN: Status of list server systems (and update about

[Hemant K Chitale]

Bruce,
You are doing a GREAT job keeping the lists running.
And you seem to have put in some effort in developing/implementing the 
"load balancers"
and then again in retrieving the "squirreled-away" emails.

Thanks.  We appreciate your work.

Regards
Hemant
At 05:39 PM 19-01-04 -0800, you wrote:
Folks --

I have good news and bad news. ;-)  First the good news:

Several people had mentioned that they've sent messages to some lists but 
have not seen the posts arrive back to them.  These messages DID appear in 
the archives though.  This started roughly 12-Jan-2004.  I had previously 
researched this issue but could find no reason for it happening, nor a 
solution.  Up until today, that is.

The cuplrit was one of my load balancers for mailing list traffic.  It was 
handling traffic correctly on some of the machines, but squirreling away 
messages sent to one specific server.  I'd estimate about 1/8th of the 
messages sent to mailing lists since 12-Jan-2004 were not redistributed 
properly.  I have since found and fixed the problem, so this shouldn't 
happen in the future.  I suspect I was only able to re-send a portion of 
the missing messages, so my apologies for anyone who posted a message that 
didn't make it to a list.  Also, my apologies to everyone who has to deal 
with the increased traffic of the old messages, plus current messages, 
plus the inevitable onslaught of re-posts that will occur in the next few 
days.  Please be patient with each other.

So the good news was: problem found, problem fixed, some catch up done, 
shouldn't happen again.

The bad news is that this morning (roughly 7am PST), a construction crew 
near Fat City cut through a section of telecom cable that was critical for 
our connection to the net.  They've been working feverishly on it all day, 
but Fat City was off the net most of the day.  Until about 3pm PST.  I 
believe things are about back to normal right now, but there's always a 
ramp-up time to truly get back to normal.  My apologies to anyone who was 
affected by our downtime.

If you have any questions or concerns about anything, please let me know.

Thanks,
Bruce Bergman
ListMaster, Fat City Hosting
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bruce A. Bergman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Does SQL Server have a wait interface?

[Mark Leith]

Ryan, 

Check out "DBCC SQLPERF(WAITSTATS)", and also take a look at the
"sysprocesses" table - with columns waittype, waittime, lastwaittype and
SPID. Something like:

SELECT spid AS SPID, waittype AS WaitType, waittime AS WaitTime,
lastwaittype AS LastWaitType
  FROM sysprocesses
 WHERE (spid > 50) 
   AND (waittime > 0)

A good comprehensive overview of the wait types is here:

http://sqldev.net/misc/WaitTypes.htm

HTH

Mark

Mark Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk



-Original Message-
[EMAIL PROTECTED]
Sent: 21 January 2004 13:35
To: Multiple recipients of list ORACLE-L


anyone know? 

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

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

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

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

Re: OT : Happy Spring Festival

[KENNETH JANUSZ]

I know what you are talking about.  I lived in New Hampshire when I was in
the US Navy and attended grad. school at the U. of New Hampshire.  February
seemed to be the big snow month.  Not uncommon to get two feet of snow in a
"nor-easter" and have 5-6 feet on the ground - in southern NH.  The roads
looked like you were driving through snow tunnels.

Ken Janusz, CPIM
Now in Minnesota


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 8:44 AM


> On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
> > ... to whomever is concerned ...
> >
> > Regards,
> >
> > Stephane Faroult
> > Oriole
>
> Spring??? What is "spring"? I live in New England, we have record colds
> and I dunno what the heck is spring? Is that something like 70 degrees?
> I've heard about that mythical event but at present I'm shoveling snow
> on -20 degrees.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

Re: Renumber a set of grupped rows?

[Maryann Atkinson]

Just out of curiocity, and while I am trying to learn about Row_NUMBER(),
how would you code the following to do an update on the 2nd column?
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x
from emp
thx
maa
>
> the analytical functions are available in 8i
> (..) wrap then in "execute immediate" within PL/SQL
>
> An update is possible in PL/SQL but it's easier to create a new table and
> swap them around - unless that creates some major headaches for you.


At 08:04 PM 1/20/2004, you wrote:
Maryann

SQL> select deptno, row_number() over (PARTITION BY DEPTNO order by 
deptno) x from emp
 2  ;

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

RE: OT : Happy Spring Festival

[Stefick Ronald S Contr ESC/HRIDA]

Title: RE: OT : Happy Spring Festival





At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl.



-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 21, 2004 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT : Happy Spring Festival



On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
> ... to whomever is concerned ...
> 
> Regards,
> 
> Stephane Faroult
> Oriole


Spring??? What is "spring"? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. 

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


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

RE: 9iAS Calender Servlet

[Chris Stephens]

I did a quick and dirty one in pl/sql.  No security, or checks on content
yet though.

I'd be more than happy to send it to you.

It might be kind of ugly...i've not done a ton of coding.  (something I am
actively working on.

Let me know,
Chris

-Original Message-
Sent: Wednesday, January 21, 2004 6:45 AM
To: Multiple recipients of list ORACLE-L

Does anybody by chance have any examples for creating a calender servlet
for 9iAS? I have to admit to being a servlet virgin! ;)

Any pointers much apreciated! 

Many thanks

Mark


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

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

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

Re: Has anyone done any scalability work on dbms_lock?

[Jonathan Lewis]

Note in-line

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
> Not a worry, it's a workflow app.  A few users but
> not much load, a little volume.  I just need to make sure a
> given sequence of operations is not undertaken by more than
> one user per group (one lock/group) and a table lock is
> way too heavy to do this.  

Sounds like you just need each user to call allocate_unique
on startup to get a group-specific handle, then do a 
request in exclusive mode before doing the job and 
a release on completion. Users will then naturally queue
and resume with minimum lost time.  You could probably
do the thing just as easily by issuing a select for update
against a group-id row in a table - but dbms_lock makes
it easier because it can bypass the normal commit  activity.




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

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

RE:

[Jamadagni, Rajendra]

Title: Message



Funny ... Ashish is from "Weight Watchers" and asking for HELP  
my advise ... stop starving yourself ... go eat something.
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 
  9:45 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: 
  must.resist..temptation.
   
  For 
  more help, please dial 999 in the UK, 911 in the US, or open your phone and 
  dial 712-BEAM-ME-UP for the year 2247. 
   
  Live 
  long and prosper.
   
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Ashish SahasrabudheSent: 21 January 2004 14:34To: 
Multiple recipients of list ORACLE-LSubject: 

HELP 

Re: OT : Happy Spring Festival

[Mladen Gogala]

On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
... to whomever is concerned ...

Regards,

Stephane Faroult
Oriole
Spring??? What is "spring"? I live in New England, we have record colds
and I dunno what the heck is spring? Is that something like 70 degrees?
I've heard about that mythical event but at present I'm shoveling snow
on -20 degrees. 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]

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

RE: Re[2]: Oracle vs Mysql

[Goulet, Dick]

yup
 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Carel-Jan Engel 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 
  5:29 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you 
  wrote:
  I do indeed. Rumor was that 
rpt/rpf was written by Larry himself.Now I understand! I once 
  applied for a job at Oracle, and got asked: What do you think about RPT/RPF. 
  My answer: Probably som hobby-project of one or another developer, which, 
  after demonstration to his boss, was turned into a product. That was a 
  disloyal remark, even in Holland, and I wasn't hired. Anyone used HLI, 
  with Lattice-C?
  Regards, Carel-Jan===If you think 
  education is expensive, try ignorance. (Derek Bok)=== 

RE:

[Mark Leith]

Title: Message



must.resist..temptation.
 
For 
more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 
712-BEAM-ME-UP for the year 2247. 
 
Live 
long and prosper.
 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Ashish SahasrabudheSent: 21 January 2004 14:34To: 
  Multiple recipients of list ORACLE-LSubject: 
  HELP 

Re: Defragmenting a RAID 5 volume?

[Mladen Gogala]

On 01/21/2004 03:04:26 AM, [EMAIL PROTECTED] wrote:

GB.  My question is, can a RAID 5 volume be defragmented? Is it sane,
technically? The volume is 130GB in size...


You are defragmenting a file system, not a volume. Block based file
systems cannot be defragmented, only extent-based file systems
can.   Block based file systems like UFS or SYSV-1K FS do not have
extents,  which means  that the word "fragmentation" doesn't make
sense. You have  superblock, inodes  and data blocks. You don't
have extents. AFAIK NTS is an extent-based file  system and it can
be defragmented. It is questionable,  however, what will you  gain
by defragmenting. If your files have < n extents, their extent
maps are  cached in memory and need not to be  re-read each time
you access files.  Hopefully, you're not using an NT system for
DW, which means that your I/O pattern consists of random
reads/writes, few blocks at a time. Fragmentation  hurts you when
you are doing frequent multiblock reads which are split into
several I/O requests instead of being satisfied by a single large
one.  As defragmenter moves file extents around, database cannot
be accessed,  which essentially means that you must shut down the
instance or it will hang. I don't know how much will you gain, but
yes, you can defragment 130GB file system, even if it's on a Rabid
Array of Inefficient Disks. As they say, size doesn't matter, it's
the magic in the disk.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Parallel Query determined by?

[Kirtikumar Deshpande]

I could not find an Oracle wait event named 'Parellel Sync Wait' (in v$event_name view 
in 7.3.4,
8.1.7.4, 9.2.0.4).  

Precise may be calling something else a 'Parallel Sync Wait', or is smart enough to 
figure this
out when it seems Oracle isn't instrumented for this particular wait(?).  Just 
pondering... 

Does Presice on-line help have any mention of this wait? 
Have you contacted Precise Tech Support? 
 
- Kirti 


--- [EMAIL PROTECTED] wrote:
> No other replies yet, so here goes.
> 
> First of all, what does it really mean when you say:
> 
> users are complaining that Precise is showing a whole lot of time in 
> "Parallel Sync Wait".
> 
> Are these end users, or developers?  Seems rather curious that users would 
> be mentioning this.
> 
> 
> Second, what % of wait time do the Sync Waits contribute to?
> 
> If a small % of total, then there's not much point in spending time on it.
> 
> Third, is this actually causing a performance problem, or is it just 
> appearing
> as a 'trouble' item on some monitor?
> 
> Jared
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
>  01/20/2004 11:29 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc: 
> Subject:Parallel Query determined by?
> 
> 
> I've inherited a system that has a whole lot of indexes set to degree 10 
> and many tables set to 2 & 4.
> 
> The users are complaining that Precise is showing a whole lot of time in 
> "Parallel Sync Wait".
> 
> It is an HP box running 8.1.7.4 with 16 processors. The box is normally 
> not very busy.
> 
> Are there various init.ora settings that help the Parallel servers sync 
> up, or is this just too high a setting?
> 
> I'm suggesting we back of a good many of these things to simply 2 or 4 and 
> then work our way up from there. Some of those indexes set to 10 are only 
> 20 meg and 4 extents. There's no way they are getting 10 on that I would 
> think.
> 
> Can't find a whole lot on Metalink either. Or a good book on 800 gig 
> warehouses using parallel?
> 
> --
> 13308 Thornridge Ct
> Midlothian, VA  23112
> 804-744-1545
>

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

RE: Has anyone done any scalability work on dbms_lock?

[Jamadagni, Rajendra]

if it is single instance you could also use global application contexts ... (alas they 
don't work in RAC across node) ...

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, January 21, 2004 9:10 AM
To: Multiple recipients of list ORACLE-L


- Original Message - 

> On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
> 
> About 15,000 request/release per second
> if you are using an ID

sounds plenty good to me.  Thanks a lot.


> Bear in mind that each request or release will hit the
> enqueue latch a couple of times, so you could get
> contention for the latch in the two high-speed options.

OK.  Will look out for these just in case.


> Bottom line - for high-speed OLTP type of work, I
> don't think you will get away with more than a dozen 
> request/release cycles per transaction.

Not a worry, it's a workflow app.  A few users but
not much load, a little volume.  I just need to make sure a
given sequence of operations is not undertaken by more than
one user per group (one lock/group) and a table lock is
way too heavy to do this.  Forms 9i, so it's not easy to 
fudge it with a C exit and I don't like servlets.
Much better if I can do the lot in PL/SQL.

Thanks again.
Cheers
Nuno Souto
[EMAIL PROTECTED]

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: Has anyone done any scalability work on dbms_lock?

[Nuno Souto]

- Original Message - 
> nuno-- what level are you trying to scale it to?

Not much.  A few hundred users, maybe 20 or so may
need the lock.  However, this app may explode in
# users, so I want to make sure I'm not creating
a "monster".

> how long will you hold the locks?

only long enough to pass a key to a servlet.

>I used it last year because only one process could run at a time.

That's what I want, one process per lock.

> seemed to have similiar over head to 'select for update'.

That's weird?  I thought it didn't involve table access?

> If you look at the PL/SQL Packages book by Fuerstein et al(not a real popular book, 
> but I like it)... there is a nifty
wrapper for DBMS_LOCK. I based my code off of that.
>

Ah yes, I know the book.  May not be popular, but I used it a lot
a while ago and it's solid.  Thanks, will look that up.


Cheers
Nuno Souto
[EMAIL PROTECTED]

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

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

Re: Has anyone done any scalability work on dbms_lock?

[Nuno Souto]

- Original Message - 

> On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
> 
> About 15,000 request/release per second
> if you are using an ID

sounds plenty good to me.  Thanks a lot.


> Bear in mind that each request or release will hit the
> enqueue latch a couple of times, so you could get
> contention for the latch in the two high-speed options.

OK.  Will look out for these just in case.


> Bottom line - for high-speed OLTP type of work, I
> don't think you will get away with more than a dozen 
> request/release cycles per transaction.

Not a worry, it's a workflow app.  A few users but
not much load, a little volume.  I just need to make sure a
given sequence of operations is not undertaken by more than
one user per group (one lock/group) and a table lock is
way too heavy to do this.  Forms 9i, so it's not easy to 
fudge it with a C exit and I don't like servlets.
Much better if I can do the lot in PL/SQL.

Thanks again.
Cheers
Nuno Souto
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Souto
  INET: [EMAIL PROTECTED]

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

Re: pga_aggregate_target and a memory leak

[Kirtikumar Deshpande]

Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 
9.2.0.4 caused
ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to
'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) 
worked,
however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T 
and 'AUTO'
workarea_size_policy... seems to run okay...

- Kirti 


--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > 
> > One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 
> > instance due
> to a possible memory leak. The only note on memory leaks and pga_aggregate_target I 
> can find on
> metalink is: 334427.995
> > 
> > doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know 
> > version
> offhand.
> > 
> > he is under the impression that if we patch to 9.2.0.4 this goes away. not sure 
> > about that
> either...
> > 
> 
> Be careful with pga_aggregate_target. I have very recently seen a case
> (Solaris + 9.2 but I cant't tell you exactly which patch level -
> probably the most recent) where two (by the way atrocious) queries
> generated by a DSS tool were responding very differently - and in a way
> that differences in the queries couldn't explain. From an Oracle
> standpoint, stats were roughly the same. Tracing proved that we were
> waiting for CPU, and truss that a call to mmap() was the culprit. Why,
> no idea. We first switched it (pga_thing) off, no more slow call to
> mmap(). However, it was still slow because we hadn't checked
> sort_area_size which was ridiculously small. We set sort_area_size to
> 10M, still with pga_aggregate_target unset, and once again the same very
> slow calls to mmap(). Memory misalignment? Anything else? Not much time
> to enquire but it looks like a mine field.
> 
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Software
> -- 


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

Re: AQ

[Kirtikumar Deshpande]

Thanks, Tanel.
Sorry, if I caused any confusion.

May be I should have used 'pipe get' event instead of 'SQL*Net message from client' as 
an example,
which of course, should not be ignored in a multi-tier, networked environment. In 
fact, I remove
it, among a  few others, from PERFSTAT.STAT$IDLE_EVENT table, when & if, I use 
Statspack.. 

Cheers!

- Kirti 

--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> I think what Kirti meant here, is that from only database's point of view
> (scope), the "SQL*Net message from client" waits do not indicate any
> database bottlenecks.
> 
> Anyway, when you have network bottleneck, from my experience you usually see
> other SQL*Net message waits, like "more data to/from client" etc as well.
> 
> Tanel.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 20, 2004 6:39 PM
> 
> 
> > However...
> >
> > do not blindly treat SQL*Net messages as Idle waits.  They can be
> > important indicators of networking issues.
> >
> > Stephen
> >
> > >>> [EMAIL PROTECTED] 01/20/04 08:24AM >>>
> > It is defined as below in the Reference Guide:
> >
> > "The session is waiting on an empty OLTP queue (Advanced Queuing) for a
> > message to arrive so that
> > the session can dequeue that message."
> >
> >
> > I would treat it as an Idle Wait, similar to, SQL*Net message from
> > client.
> >
> > - Kirti
> >
> > --- "Ehresmann, David" <[EMAIL PROTECTED]> wrote:
> > >
> > > Is "queue message" an idle or an non-idle wait event?  I have looked
> > through
> > > the docs at tahti and metalink and can't find much info on AQ.  Does
> > anybody
> > > know where there are resources on this topic?
> > >
> > > thanks,
> > >
> > > David Ehresmann
> > >
> > > -- 
> > >
> >

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

RE: Re[2]: Oracle vs Mysql

[Igor Neyman]

I was using Lattice-C on x286.

 



Igor Neyman, OCP DBA

[EMAIL PROTECTED]

 



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carel-Jan
Engel
Sent: Tuesday, January 20, 2004
5:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Re[2]: Oracle vs
Mysql

 

At 03:29 PM 1/20/2004, you wrote:



I do indeed. Rumor was that rpt/rpf was written by
Larry himself.


Now I understand! I once applied for a job at Oracle, and got asked: What do
you think about RPT/RPF. My answer: Probably som hobby-project of one or
another developer, which, after demonstration to his boss, was turned into a
product. That was a disloyal remark, even in Holland, and I wasn't hired. 

Anyone used HLI, with Lattice-C?







Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===

RE: All packages under sys is invalid

[nelson . petersen]

Is sombebody playing with Statspack (spcreate.sql)?
One piece of the install runs dbmspool.sql

Nelson

-Original Message-
Sent: Tuesday, January 20, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L


So what's the recommendation, how can I recompile all the SYS packages?

-Original Message-
Sent: Tuesday, January 20, 2004 10:10 AM
To: Multiple recipients of list ORACLE-L


Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, January 20, 2004 12:45 PM
To: Multiple recipients of list ORACLE-L


so what's the solution?

-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L


Someone is messing with standard package ... so it would seem.

Raj


Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Monday, January 19, 2004 5:01 PM
To: Multiple recipients of list ORACLE-L


All,

I have an strange problem, most of the packages under SYS user are invalid
when I compile it it's compile without error but when I back again the
package still is invalid, anybody have any idea?
Thanks in advance

Hamid Alavi

Office   :  818-737-0526
Cell phone  :  818-416-5095

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

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


**
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
message from your computer, Thank you.

**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

Re: Has anyone done any scalability work on dbms_lock?

[Nuno Souto]

- Original Message - 

> > Or how many lock/release per second.  Or some other
> > idea of how efficient it is?
> Depends on the work done between acquiring the lock and releasing it.

Not really.  I'm asking how many lock/releases can be done 
before the thing starts putting a serious load on the system.
And if the load it imposes is linear.

> When sessions acquire the same lock (as asked), only one session can do
> the work in a given moment. So, it doesn't scale. There will be overhead,
> but that also is relative to the duration of the work done while the lock
> is held.

So, the overhead is MOL linear?  Ie, if the amount of work is very small
and the number of requests is very high, nothing is gonna suddenly
go South?


> Maybe AQ can help, by doing the work asynchronously in the background and
> so lift the serialization from the primary proces(ses)?

The work is very small indeed. No need to background anything.

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

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

Re: All packages under sys is invalid

[Mladen Gogala]

Either re-run catproc or try with utlirp.

On 01/20/2004 12:44:34 PM, Hamid Alavi wrote:
so what's the solution?

-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L
Someone is messing with standard package ... so it would seem.

Raj


Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Monday, January 19, 2004 5:01 PM
To: Multiple recipients of list ORACLE-L
All,

I have an strange problem, most of the packages under SYS user are
invalid
when I compile it it's compile without error but when I back again  
the
package still is invalid, anybody have any idea?
Thanks in advance

Hamid Alavi

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

**
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney
work product or exempt from disclosure under applicable law. If you
have
received this message in error, or are not the named recipient(s),
please
immediately notify corporate MIS at (860) 766-2000 and delete this
e-mail
message from your computer, Thank you.

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

Re: Re: Has anyone done any scalability work on dbms_lock?

[ryan.gaffuri]

nuno-- what level are you trying to scale it to? how long will you hold the locks? I 
used it last year because only one process could run at a time.

seemed to have similiar over head to 'select for update'. If you look at the PL/SQL 
Packages book by Fuerstein et al(not a real popular book, but I like it)... there is a 
nifty wrapper for DBMS_LOCK. I based my code off of that. 


> 
> From: "Carel-Jan Engel" <[EMAIL PROTECTED]>
> Date: 2004/01/21 Wed AM 08:24:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Has anyone done any scalability work on dbms_lock?
> 
> > As in: does it present an inherent or hidden performance
> > problem when a lot of sessions try to lock/release the same
> > lock?
> Will serialize perfectly!
> 
> > Or how many lock/release per second.  Or some other
> > idea of how efficient it is?
> Depends on the work done between acquiring the lock and releasing it.
> 
> >
> > Need to use it in a design, but not sure of any potential
> > performance hits or scalability issues.  Any ideas?
> When sessions acquire the same lock (as asked), only one session can do
> the work in a given moment. So, it doesn't scale. There will be overhead,
> but that also is relative to the duration of the work done while the lock
> is held.
> 
> Maybe AQ can help, by doing the work asynchronously in the background and
> so lift the serialization from the primary proces(ses)?
> 
> 
> Regards, Carel-Jan
> 
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
> 
> >
> > TIA.
> > Cheers
> > Nuno Souto
> > [EMAIL PROTECTED]
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Nuno Souto
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Carel-Jan Engel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Has anyone done any scalability work on dbms_lock?

[ryan.gaffuri]

i think expert one on one has some comments on it. Its in a section referring to 
building your own insert locks. So if a table is locked, the user gets notified. 

I read the book last year. 
> 
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2004/01/21 Wed AM 07:49:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Has anyone done any scalability work on dbms_lock?
> 
> As in: does it present an inherent or hidden performance
> problem when a lot of sessions try to lock/release the same 
> lock?  Or how many lock/release per second.  Or some other
> idea of how efficient it is?
> 
> Need to use it in a design, but not sure of any potential
> performance hits or scalability issues.  Any ideas?
> 
> TIA.
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Nuno Souto
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Has anyone done any scalability work on dbms_lock?

[Jonathan Lewis]

On a light-weight test on 8.1.7.4 at 700MHz on W2000 -

About 15,000 request/release per second
if you are using an ID

About 8,000 request/release per second
if you are using a pre-allocated lock handle

About 800 request/release per second 
if you have to allocate_unique on every request.

Bear in mind that each request or release will hit the
enqueue latch a couple of times, so you could get
contention for the latch in the two high-speed options.
(Forget the low-speed option, allocate_unique does a
commit in mid-stream, which you might be able to hide
with a recursive transaction - but the overheads are
extreme).

Bottom line - for high-speed OLTP type of work, I
don't think you will get away with more than a dozen 
request/release cycles per transaction.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 12:49 PM


> As in: does it present an inherent or hidden performance
> problem when a lot of sessions try to lock/release the same 
> lock?  Or how many lock/release per second.  Or some other
> idea of how efficient it is?
> 
> Need to use it in a design, but not sure of any potential
> performance hits or scalability issues.  Any ideas?
> 
> TIA.
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]

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

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

Re: Has anyone done any scalability work on dbms_lock?

[Carel-Jan Engel]

> As in: does it present an inherent or hidden performance
> problem when a lot of sessions try to lock/release the same
> lock?
Will serialize perfectly!

> Or how many lock/release per second.  Or some other
> idea of how efficient it is?
Depends on the work done between acquiring the lock and releasing it.

>
> Need to use it in a design, but not sure of any potential
> performance hits or scalability issues.  Any ideas?
When sessions acquire the same lock (as asked), only one session can do
the work in a given moment. So, it doesn't scale. There will be overhead,
but that also is relative to the duration of the work done while the lock
is held.

Maybe AQ can help, by doing the work asynchronously in the background and
so lift the serialization from the primary proces(ses)?


Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===

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




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

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

RE: how do I interpret this in bstat/estat

[nelson . petersen]

Gene,

I strongly recommend implementing Statspack.
It is very straight-forward.

Just do it when you have exclusive use of the database, or comment
out the following two lines in ora_rdbms_admin:SPCUSR.SQL  if you have 
these packages already installed.
(We're running 8.1.7 on VMS.  The filenames might be different on your
platform,
 but the documentation gives lots of detail.)


--@@dbmspool
--@@dbmsjob

The docs neglected to mention that it was going to recreate DBMSPOOL and
DBMSJOB, even
thought they were already installed.
This invalidated everything that depends on those two packages!
Yet another way to hang your production instance!

Nelson


-Original Message-
Sent: Tuesday, January 20, 2004 5:04 PM
To: Multiple recipients of list ORACLE-L


Hi.

I am looking at the bstat/estat report and see a high
number of enqueue timeouts in the statistics section
of the report. How do I tackle that? In the Niemec's
book he receoomends increasing the enqueue_resources
parameter. Metalink says that these may be related to
DISTRIBUTED_LOCK_TIMEOUT being exceeded in a
distributed transaction. Comments about changing
ENQUEUE_RESOURCES are ill-founded. But it doesn't make
any recommendations. 
So my question is whether anyone has any practical
suggestions what I can do to address this issue. I am
running Oracle 9203 (yes, I should be usuns the
statspack, but I haven't switched to it yet). 

TIA

Gene


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

RE: bind variables in VB using OO4O

[Prem Khanna J]

Hi John , 

i have mailed a doc . have a look at it .

Regards,
Prem.

>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
>>Does anyone have examples of how to use bind variables in VB 
>>when using
>>OO4O?
>>
>>John

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

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

RE: tnsnames.ora not working ?

[John Flack]

I've seen this sort of thing happen when you have more than one Oracle_Home and client 
tools get confused about which tnsnames.ora file to use.  Fastest solution is to find 
every tnsnames.ora file on the client computer and make sure that they are all 
identical.  Correct solution is usually to make sure that there is only one set of 
network control files and set the TNS_ADMIN environment variable to point at the one 
and only directory that contains them.

I've sometimes had to deinstall all copies of Oracle Net tools and reinstall just one.

-Original Message-
Sent: Tuesday, January 20, 2004 10:49 AM
To: Multiple recipients of list ORACLE-L



Hello,
I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, 
but it seems that the client (ie. sqlplus) wont use it. Whenever I try to 
connect to the service using sqlplus, I got :

$> sqlplus
Enter user-name: [EMAIL PROTECTED]
Enter password: * 
ORA-12154: TNS:could not resolve service name

I tried to add the description to my ~/.tnsnames.ora too with no luck. The 
entry in the tnsnames.ora is:

DEV_DB =
   (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
 )
 (CONNECT_DATA =
   (SERVICE_NAME = dev_db)
 )
   )

(note: I removed the real hostname for privacy/security reason of course)

However, when I use sqlplus using the following way:

$> sqlplus

Enter user-name: 
developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 
1521))(CONNECT_DATA =(SERVICE_NAME = dev_db)))
Enter password: * 

It would work, where all the information from the description is just a 
copy-paste from the tnsnames.ora file.

Is there anything I overlook? Sorry if this is kinda a newbie question. I'm 
still learning my way around this. I'm using Oracle9i on Redhat Linux.

Thanks for any help.

Reuben D. Budiardja
-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
"To be a nemesis, you have to actively try to destroy 
something, don't you? Really, I'm not out to destroy 
Microsoft. That will just be a completely unintentional 
side effect."
 - Linus Torvalds -

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

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

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

RE: ORA-904 after table rename

[Jamadagni, Rajendra]

When required I did it through a logon trigger ... wait I still do it.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Tuesday, January 20, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L


One thing I've been looking for is a way to set a string parameter in
another session, The two you mention handle INTEGER and BOOLEAN.  I want
a way to set TRACEFILE_IDENTIFIER to a string in another session to make
it easier to identify trace files.

Any ideas?

Stephen 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: Oracle 8.1.7 can only use the first 15th indexes?

[Jonathan Lewis]

Data warehouse with bitmap indexes ?

But in OLTP I would assume guilty until
proven innocent.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 9:44 AM


> Let's be realistic:  any table with > 15 indexes
> PROBABLY needs a little bit of a re-design
> exercise?  ;)
> 

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

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

Re: Oracle 8.1.7 can only use the first 15th indexes?

[Nuno Souto]

The first 15 indexes CREATED?
Joking, are they?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 

> I've just been reading a report for one of our systems and it says that Oracle 8.1.7 
> will only use the first 15
indexes created. Any index created after the 15th will be ignored unless specified via 
a hint. Is this correct? I
haven't heard of this before.
>

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

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

Re: Oracle 8.1.7 can only use the first 15th indexes?

[Nuno Souto]

Let's be realistic:  any table with > 15 indexes
PROBABLY needs a little bit of a re-design
exercise?  ;)

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 
> snip
> (I assume the report intended to say the first 15
> indexes on a specific table, 'cos the data dictionary
> alone has rather more than 15 indexes).

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

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

Re: FW: Disk capacity planning

[chris]

Mladen,

I agree you can measure how many IOs are being done and how many a disk sub-
system, such as those provided by EMC, can perform and still give "good" 
performance. What I meant is that it is hard and some would say impossible to 
estimate how many IOs per sec a new application will do. A combination of paper 
calculations, testing, experience and looking at comparable systems will help 
to provide a good estimate.

Cheers,

Chris


Quoting Mladen Gogala <[EMAIL PROTECTED]>:

> Oh, but it is done, you only need to ask. EMC routinely measures how many
> I/Os
> per second can they perform and they even have tools to measure it. Speaking
> of
> monitoring I/O, there used to be an old OS, which is mostly dead today and it
> used
> to have command monitor io/item=queue which would show length of the I/O
> queues
> per device, which was extremely useful, because you could quickly find out
> which
> devices are "hot" and which are not.
> 
> 
> On 2004.01.20 04:19, [EMAIL PROTECTED] wrote:
> > Cary,
> > 
> > Good answer. The problem is most people concentrate on bytes because it's 
> > relatively easy and everyone understands it. IOs per sec is much harder to
> 
> > calculate for a new system and hence it's not normally done.
> > 
> > Cheers,
> > 
> > Chris Dunscombe
> > 
> > 
> > 
> > Quoting Cary Millsap <[EMAIL PROTECTED]>:
> > 
> > > I don't think this one made it through on my first attempt.
> > > 
> > >  
> > > 
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > > Nullius in verba
> > > 
> > > Upcoming events:
> > > - Performance   Diagnosis
> > > 101: 1/27 Atlanta
> > > - SQL Optimization 101: 2/16 Dallas
> > > - Hotsos Symposium 2004  :
> > > March 7-10 Dallas
> > > - Visit www.hotsos.com for schedule details...
> > > 
> > > -Original Message-
> > > Sent: Tuesday, January 13, 2004 5:54 PM
> > > To: '[EMAIL PROTECTED]'
> > > 
> > >  
> > > 
> > > Counting bytes is far, far, FAR less important than counting
> > > I/O-per-second (IOps) requirements and making sure that you have enough
> > > total capacity to handle your system's peak I/O loads. Counting bytes is
> > > important too, but what many people find is that the byte-counting
> > > exercise will result in the sub-verdict of needing far fewer disk drives
> > > than you'll really, truly need.
> > > 
> > >  
> > > 
> > > The way I'd recommend structuring your project is to evaluate the
> > > following:
> > > 
> > >  
> > > 
> > > -  How many bytes will you need to store your data? How many
> > > disks is that? Call the answer B.
> > > 
> > > -  How many disks will you need to meet your IOps requirements?
> > > Call the answer P.
> > > 
> > > -  How many disks will you need to meet your availability
> > > requirements? Call the answer A.
> > > 
> > > -  (Consider other attributes as necessary, like perhaps I/O
> > > throughput requirements.)
> > > 
> > >  
> > > 
> > > Roughly speaking, the number of disks you'll need to buy is max(B, P, A,
> > > .). It's more complicated than that because you'll need to segment your
> > > total drive set into sensibly-sized arrays, you'll be able to buy some
> > > disks now then some later, and so on, but this is the general gist. The
> > > important thing is to have enough hardware to meet *all* of the
> > > constraints your business will place upon your system.
> > > 
> > >  
> > > 
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > > Nullius in verba
> > > 
> > > Upcoming events:
> > > - Performance   Diagnosis
> > > 101: 1/27 Atlanta
> > > - SQL Optimization 101: 2/16 Dallas
> > > - Hotsos Symposium 2004  :
> > > March 7-10 Dallas
> > > - Visit www.hotsos.com for schedule details...
> > > 
> > > -Original Message-
> > > [EMAIL PROTECTED]
> > > Sent: Tuesday, January 13, 2004 12:29 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > >  
> > > 
> > > 
> > > Hi everyone! 
> > > 
> > > Can anybody point me to any good documentation regarding disk capacity
> > > planning? Sharing your experience or approach will also give me so much
> > > help. I'd like to know other people's approach on forecasting the growth
> > > of their databases particularly on determining the (growth) rate of disk
> > > space usage and on deciding when to add and how many disk to add on an
> > > Oracle server. 
> > > 
> > > Thanks in advance. 
> > > 
> > > Best Regards, 
> > > Rhojel
> > > 
> > > 
> > 
> > 
> > Chris Dunscombe
> > 
> > [EMAIL PROTECTED]
> > 
> > - 
> > Everyone should have http://www.freedom2surf.net/ 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: 
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.

Re: Defragmenting a RAID 5 volume?

[Frank B. Hansen]

Hi Rhojel
 
Tjeck out:  http://www.baarf.com/
 
Rgds, Frank

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 21, 2004 9:04 
  AM
  Subject: Defragmenting a RAID 5 
  volume?
  Hello people, 
  We recently experienced a hang in our 
  database server, WIN2k Advanced server with raid 5 for Oracle 817 database 
  files. Examining the perf logs showed 
  that Event 2022 caused the hang: 
  


  

  
  

  


  Event ID: 2022Source: Srv Description: Server 
was unable to find a free connection 144 times in the last 
60 seconds. 
After I examined the alert log, I saw an object trying 
  to extend but fails because the DBF ran out of space. This happened on the 
  time/instance that the server started to stop responding. The DBF is supposed 
  to extend because it is configured to AUTOEXTEND. The available disk space 
  isn't also supposed to constrain the DBF's extension of 64MB, free space of 9+ 
  GB could still accomodate this, obviously. More importantly, this can happen 
  without crashing the server. According to Microsoft's website (http://support.microsoft.com/default.aspx?scid=kb;en-us;245077), possible resolutions are to defragment the disk or 
  allocate more disk space. Disk space is not much of an issue because the 
  volume still has 9+ GB.  My question is, can a RAID 5 volume be 
  defragmented? Is it sane, technically? The volume is 130GB in size... 
  Best regards, Rhojel

Re: Unusable partition index -- working funny

[Jonathan Lewis]

It's probably the case that the trigger fires
the first time - but at parse/optimise time
Oracle had already determined the sequence
of actions needed to execute the statement
based on the then session state, so that sequence
is played out, irrespective of the fact that you
changed the session state in the middle of
the sequence.

By analogy, consider an update to an
updatable join view which defaults to
using a hash join.  If you create a "before
row update" trigger to disable hash joins,
would you expect Oracle to not do a hash
join the first time the statement executes ?


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 12:19 AM


> Hello All,
>   I have a strange problem...
>   I have a table on which i am doing an update. Its a partition table and
>   the local index on the column which is being updated is in an unusable
>   state.
>  I have a database trigger at statement level (before update of col_a for
>  ) where i do an execute immediate ' alter session set
>  skip_unusable_indexes = true';
>
>   i log into sqlplus as the owner of the table and do the following
> 
>
> SQL> connect [EMAIL PROTECTED]
> Enter password: **
> Connected.
> SQL> UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY =
> 1 where
>   2  mortgage_loan_key = 1 and period_key = '30-JUN-03';
> UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY =
> 1166444 where
> *
> ERROR at line 1:
> ORA-01502: index 'NEVADMIN.DM_MORTGAGE_LOAN_HIST_BK13' or partition of
> such
> index is in unusable state
>
> SQL> /
>
> 1 row updated.
> --
-
>
> My question is why does the trigger not fire for the first time...
> When i do the /  i am able to update the table which means the trigger is
> firing the 2nd time.
>
> Any help would be greatly appriciated..
>
> thanks,
>
> sathish.
>

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

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

Re: Oracle 8.1.7 can only use the first 15th indexes?

[Jonathan Lewis]

drop table t1;

create table t1
nologging
pctfree 50
pctused 50
as select
 1 n01,
 1 n02,
 1 n03,
 1 n04,
 1 n05,
 1 n06,
 1 n07,
 1 n08,
 1 n09,
 1 n10,
 1 n11,
 1 n12,
 1 n13,
 1 n14,
 1 n15,
 rownum n16,
 lpad(rownum,10) v1
from all_objects
;

create index i01 on t1(n01);
create index i02 on t1(n02);
create index i03 on t1(n03);
create index i04 on t1(n04);
create index i05 on t1(n05);
create index i06 on t1(n06);
create index i07 on t1(n07);
create index i08 on t1(n08);
create index i09 on t1(n09);
create index i10 on t1(n10);
create index i11 on t1(n11);
create index i12 on t1(n12);
create index i13 on t1(n13);
create index i14 on t1(n14);
create index i15 on t1(n15);
create index i16 on t1(n16);

analyze table t1 estimate statistics;

set autotrace traceonly explain;

select v1 from t1 where n16 = 99;

set autotrace off


The execution path uses I16 on my system.

It would be possible to produced test cases
that failed to use the 16th index, of course,
and some of them could look quite convincingly
as if the 16th index should be used.  But it only
takes one counter-example ...


(I assume the report intended to say the first 15
indexes on a specific table, 'cos the data dictionary
alone has rather more than 15 indexes).



Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


Next public appearance2:
 March 2004 Hotsos Symposium - Keynote
 March 2004 Charlotte NC - OUG Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___February


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 6:19 AM


> Hello again,
>
> I've just been reading a report for one of our systems and it says that
Oracle 8.1.7 will only use the first 15 indexes created. Any index created
after the 15th will be ignored unless specified via a hint. Is this correct?
I haven't heard of this before.
>
>
> TIA,
>
> Leng.
>
> --
> Leng Kaing
> Email: [EMAIL PROTECTED]
> Phone: +61-3-9203-7589
> Mobile: +61-417-371-348
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Kaing, Leng
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

RE: Spool to Excel File

[waibals]

Hi Thomas-
Pretty interested in your method!! I tried it out but I guess I have to
create the WTW_JOB_NOTIFY table and populate it and I can't figure where the
mail notification is used. Assit with the table structure and an explanation
on how this table is used.

Thanks and Cheers,

CSW Simon.

-Original Message-
Sent: Tuesday, January 20, 2004 4:04 PM
To: Multiple recipients of list ORACLE-L


Mudhalvan,

I generate files that excel can open all the time.  they are not actual
"real" excel files, but Excel can deal with them quite easily.

Here is a tablespace report I run every week.  Note the use of the CHR(9)'s.
This is a TAB character.  This forces each column into a new cell in the
spreadsheet.  CHR(10) is a line-feed.

Feel free to "borrow" all of this!

Hope this helps!

SET serveroutput ON
SET feedback OFF
SET lines 150
SET pages 100
SET trimspool ON
exec dbms_output.enable(10)
spool tbslspace_rpt.xls

DECLARE

CURSOR UpTime IS
  SELECT INITCAP(instance_name) Instance_Name ,INITCAP(Host_Name) Host_Name
,Version,
  ROUND(SYSDATE+1-startup_time) || DECODE(ROUND(SYSDATE+1-startup_time),1,'
Day ', ' Days ') ||
  MOD(ROUND((SYSDATE+1 - startup_time) * 24),24) || ' Hours ' ||
  MOD(ROUND((SYSDATE+1 - startup_time) * 24*60),60) || ' Minutes ' UpTime
  FROM v$instance;

  UpTime_Rec UpTime%ROWTYPE;

CURSOR TblSpace IS
  SELECT d.status , d.tablespace_name , 
  TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'999,990') Tbs_Size,
  TRUNC(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024)Used, 
  TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), '990.00')
Used_Pct ,
  DECODE(SIGN(80 - NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100,
0)),-1,'** Warning > 80% **',NULL) Msg
  FROM sys.DBA_TABLESPACES d, 
 (SELECT tablespace_name, SUM(bytes) bytes 
   FROM DBA_DATA_FILES GROUP BY tablespace_name) a,
 (SELECT tablespace_name, SUM(bytes) bytes 
   FROM DBA_FREE_SPACE GROUP BY tablespace_name) f 
  WHERE d.tablespace_name = a.tablespace_name(+) 
  AND d.tablespace_name = f.tablespace_name(+) 
  AND NOT (d.extent_management LIKE 'LOCAL' AND d.CONTENTS LIKE 'TEMPORARY')
  ORDER BY 2;

 TblSpace_Rec TblSpace%ROWTYPE;

c_email_list  VARCHAR2(300);
mail_message  VARCHAR2(32000);
mail_message1 VARCHAR2(32000);

loc_start_time DATE;
TblSpace_Msg   NUMBER := 0;

BEGIN

BEGIN
  SELECT email_notify_txt
  INTO   c_email_list
  FROM   WTW_JOB_NOTIFY
  WHERE  job_name = UPPER('Wtw_Report_Tablespaces');

   EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;

  loc_start_time := SYSDATE;


  OPEN UpTime;
  FETCH UpTime INTO UpTime_Rec;
  CLOSE UpTime; 

  dbms_output.put_line(CHR(9) || CHR(9) || 
   UpTime_Rec.Instance_Name || INITCAP('
Uptime/TABLESPACE Report FOR ') ||
   TO_CHAR(SYSDATE,'fmMonth ddth, '));
  dbms_output.put_Line(CHR(9) || CHR(9) ||
   'UpTime : ' || UpTime_Rec.UpTime);
  dbms_output.put_Line(
  'Status' || CHR(9) ||
  INITCAP('TABLESPACE Name')   || CHR(9) ||
  INITCAP('SIZE (M)')  || CHR(9) ||
  'Used (M)'   || CHR(9) ||
  'Used (Pct)' || CHR(9) ||
  'Message');

  
  OPEN TblSpace;
  FETCH TblSpace INTO TblSpace_Rec;
  WHILE TblSpace%FOUND LOOP
dbms_output.put_Line(
TblSpace_Rec.Status  || CHR(9) ||
TblSpace_Rec.Tablespace_Name || CHR(9) ||
TblSpace_Rec.Tbs_Size|| CHR(9) ||
TblSpace_Rec.Used|| CHR(9) ||
TblSpace_Rec.Used_Pct|| CHR(9) ||
TblSpace_Rec.Msg);

IF TblSpace_Rec.Msg IS NOT NULL THEN
   TblSpace_Msg := 1;
END IF;
  
FETCH TblSpace INTO TblSpace_Rec;
EXIT WHEN TblSpace%NOTFOUND;
  END LOOP;
  
  CLOSE TblSPace;

END;
/
spool OFF
exit


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, January 19, 2004 11:44 PM
To: Multiple recipients of list ORACLE-L


Dear Friends,

I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know. 

Thank You

Mudhalvan M.M
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
  INET: [EMAIL PROTECTED]

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

Re: pga workarea and ora-04030

[Connor McDonald]

No longer having the versions to validate this, what
follows might be waffle, but I thought:

v7.0 => full allocated space
v.7.2 => space allocated more intelligently, never
freed
v7.3 => space allocated more intelligently, reusable
when you delete entries

Cheers
Connor

 --- Jonathan Lewis <[EMAIL PROTECTED]>
wrote: > 
> If you want to work out how much difference there
> is in different code paths, then you have to do some
> very patient testing.
> 
> Run your test program for lots of different array
> sizes,
> say 1,  2,  3,  and so on up to 100M.
> On each run, disconnect and reconnect your session,
> and check v$sesstat for pga and uga memory usage
> before and after each run, as well as the memory
> reported from the O/S (I think ps -al and look at
> the
> RSS figure for your shadow process is the HP-UX
> option - but someone may have a better idea).
> 
> You then need to run a second set of tests where
> the size of an array element is significantly
> different
> from the first test - e.g. test1 uses a varchar2(32)
> test2 uses varchar2(1000)  (and the third test uses
> varchar2(8000) ). Then you may be able to
> figure out the significant differences in handling
> 
> 
> It is quite likely that there is a different code
> path
> for allocating and freeing memory as you change
> versions of Oracle, or change parameters within
> a version; and it is quite possible that a piece of
> code for handling arrays changed from version
> to version - and any change could have introduced
> an unreasonable error.
> 
> 
> In passing, I thought the 'array is a fully
> pre-allocated'
> was a version 6 thing that got fixed in version 7.
> I would be amazed if arrays had gone backwards
> a step - it's easy enough to check: change your
> test to populate just element 1 and element
> 1
> and see if your session still crashes.
> 
> Regards
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
>   The educated person is not the person
>   who can answer the questions, but the
>   person who can question the answers -- T. Schick
> Jr
> 
> 
> Next public appearance2:
>  March 2004 Hotsos Symposium - Keynote
>  March 2004 Charlotte NC - OUG Tutorial
>  April 2004 Iceland
> 
> 
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
> 
> 
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> UK___February
> 
> 
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Monday, January 12, 2004 11:44 AM
> 
> 
> > Jonathan,
> >
> > Thanks for your answer this clarifies a bit more
> > But it still bothers me that this program can
> swallow
> > 4Gb of physical memory and 4 Gb of swap and it is
> still not
> > enough. You explain that the memory of pl/sql
> tables is not in
> > the sga so that's clear now.
> >
> > What still bothers me is that my original program
> works fine
> > with pga_target = 0 and wa-size-policy=manual
> > When I try this with this test-program it fails
> (see below)
> > VU_2>exec testarray(1);
> > begin testarray(1); end;
> >
> > *
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-04030: out of process memory when trying to
> allocate 8144 bytes
> (cursor
> > work he,qesaQBInit:buffer)
> > ORA-06508: PL/SQL: could not find program unit
> being called
> > ORA-06512: at "SYS.DBMS_OUTPUT", line 127
> > ORA-06512: at "VRIJ_UIT.TESTARRAY", line 23
> > ORA-06500: PL/SQL: storage error
> > ORA-06512: at line 1
> >
> > Somehow these setting influence the way the pl/sql
> program works.
> > This testprogram is clearly not enough to explain
> this behaviour. Because
> we
> > Use quite some pl/sql I would like to know more
> because it could happen
> > Maybe with other programs.
> >
> > Oracle 7 the same code runs fine also. I read a
> post that the difference
> for
> > pl/sql tables is that they are now implemented as
> fully allocated arrays
> in
> > memory whether they were implemented in oracle 7
> and chained linked lists.
> >
> > Obviously this takes more memory but why do these
> 2 settings play such a
> > role? Is the memory involved differently when
> using these settings?
> > Can I monitor specific memory usage with these
> setting and how should this
> > be done on

RE: Unusable partition index -- working funny

[Khedr, Waleed]

My guess it's firing the first time but is not taking effect during the
current transaction may be because it fires as a recursive sql within the
main sql.

Not a good idea to put this in a trigger.

Regards,

Waleed

-Original Message-
Sent: Tuesday, January 20, 2004 7:19 PM
To: Multiple recipients of list ORACLE-L


Hello All,
  I have a strange problem...
  I have a table on which i am doing an update. Its a partition table and
  the local index on the column which is being updated is in an unusable
  state.
 I have a database trigger at statement level (before update of col_a for
 ) where i do an execute immediate ' alter session set
 skip_unusable_indexes = true';

  i log into sqlplus as the owner of the table and do the following


SQL> connect [EMAIL PROTECTED]
Enter password: **
Connected.
SQL> UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY =
1 where
  2  mortgage_loan_key = 1 and period_key = '30-JUN-03';
UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY =
1166444 where
*
ERROR at line 1:
ORA-01502: index 'NEVADMIN.DM_MORTGAGE_LOAN_HIST_BK13' or partition of
such
index is in unusable state

SQL> /

1 row updated.

---

My question is why does the trigger not fire for the first time...
When i do the /  i am able to update the table which means the trigger is
firing the 2nd time. 

Any help would be greatly appriciated..

thanks,

sathish.

  

-- 
http://www.fastmail.fm - Consolidate POP email and Hotmail in one place
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

Re: ORA-904 after table rename

[Mladen Gogala]

On 01/20/2004 03:39:25 PM, "Bobak, Mark" wrote:
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
Thanks, Mark! I've learned something from you today! Who says
that one cannot teach an old bear new tricks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: tnsnames.ora not working ?

[Wolfgang Breitling]

Open the sqlnet.ora. What is NAMES.DEFAULT_DOMAIN set to. Add that as a 
suffix to the DEV_DB entry.
If there is no sqlnet.ora or it has no NAMES.DEFAULT_DOMAIN entry try 
adding .world:

DEV_DB.{whatever_names.default_domain_is | world} =
..
At 11:09 AM 1/20/2004, you wrote:
what is the listener status??

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, January 20, 2004 10:49 AM
To: Multiple recipients of list ORACLE-L


Hello,
I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora,
but it seems that the client (ie. sqlplus) wont use it. Whenever I try to
connect to the service using sqlplus, I got :
$> sqlplus
Enter user-name: [EMAIL PROTECTED]
Enter password: *
ORA-12154: TNS:could not resolve service name
I tried to add the description to my ~/.tnsnames.ora too with no luck. The
entry in the tnsnames.ora is:
DEV_DB =
   (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
 )
 (CONNECT_DATA =
   (SERVICE_NAME = dev_db)
 )
   )
(note: I removed the real hostname for privacy/security reason of course)

However, when I use sqlplus using the following way:

$> sqlplus

Enter user-name:
developer@(description=(address=(protocol=tcp)(host=hostname)(PORT =
1521))(CONNECT_DATA =(SERVICE_NAME = dev_db)))
Enter password: *
It would work, where all the information from the description is just a
copy-paste from the tnsnames.ora file.
Is there anything I overlook? Sorry if this is kinda a newbie question. I'm
still learning my way around this. I'm using Oracle9i on Redhat Linux.
Thanks for any help.

Reuben D. Budiardja
--
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
"To be a nemesis, you have to actively try to destroy
something, don't you? Really, I'm not out to destroy
Microsoft. That will just be a completely unintentional
side effect."
 - Linus Torvalds -
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
**
This e-mail message is confidential, intended only for the named 
recipient(s) above and may contain information that is privileged, 
attorney work product or exempt from disclosure under applicable law. If 
you have received this message in error, or are not the named 
recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

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

Re: problem with log version

[Paul Drake]

--- Mauricio Vélez <[EMAIL PROTECTED]> wrote:
> Hello everybody
>  
> I'm trying to recover a full database from a hot
> backup. 
> When I execute the following instruction:
>  
> SQL>  recover database using  backup  controlfile
> until cancel;
>  
> Then I obtain the error ora-00331, 
> This is the output:
> 
> ORA-00279: change 1581950488 generated at 01/18/04
> 21:00:01 needed for thread 1
> ORA-00289: suggestion :
> C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
> ORA-00280: change 1581950488 for thread 1 is in
> sequence #9537
> 
> Specify log: {=suggested | filename | AUTO |
> CANCEL}
> C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
> ORA-00331: log version 8.1.0.0.0 incompatible with
> ORACLE version 8.0.5.0.0
> ORA-00334: archived log:
> 'C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC'
> 
> ORA-01547: warning: RECOVER succeeded but OPEN
> RESETLOGS would get error below
> ORA-01195: online backup of file 1 needs more
> recovery to be consistent
> ORA-01110: data file 1:
> 'F:\ORADATA\CAMBIOS\SYSTEM01.DBF'
> 
>  
> In the Oracle Documentation The solution to the
> error ora-00331 is to recover the database using the
> old software. The problem is tha I don't have the
> old software.
> Is there a way to change the log version or what can
> I do?
>  
> Regards,
> Mauricio Vélez

Mauricio,

If I read this correctly, you have started up an
instance for an 8.1.x database using 8.0.5.x binaries.

Is there some reason that you do not want to open this
hot backupset as an 8.1.x database?

Is this your own testing, or is this a recovery
secenario in production?
Do you have a support contract with Oracle Support?

There are mechanisms via which you can downgrade a
database, but I believe that you have to have the
database in a consistent state (open) prior to
downgrading it.

Is it possible that you simply have the "compatible"
parameter set to 8.0.5 (by mistake) in the init.ora
and just need to restart the instance with compatible
set to "8.1.0.0.0" and retry recovery?

It could be that simple.
Run these and report back, please.

SQL> select * from v$parameter where
name='compatible";

SQL> select * from v$version;

Pd

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

Re: Renumber a set of grupped rows?

[Peter Gram]

Maryann

The select workes on 8i, but the update part I have to think som time 
over :-)

[EMAIL PROTECTED] oracle]$ sqlplus scott/tiger

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 21 01:43:33 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL> select deptno, row_number() over (PARTITION BY DEPTNO order by 
deptno) x from emp
 2  ;

   DEPTNO  X
-- --
   10  1
   10  2
   10  3
   20  1
   20  2
   20  3
   20  4
   20  5
   30  1
   30  2
   30  3
   30  4
   30  5
   30  6
14 rows selected.

Maryann Atkinson wrote:

> select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
> from emp
> /
Hm... but thats not available in 8i, is it?

and besides, I want to update the table, not just select from it...

...

thx
maa


At 06:19 PM 1/20/2004, you wrote:

Maryann
You can use the new windowing function, here is test select working
on emp :-)



select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
 from emp
/
   DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO)
-- 
   101
   102
   103
   201
   202
   203
   204
   205
   301
   302
   303
   304
   305
   306
Maryann Atkinson wrote:

I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.
So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008
10002   001
10002   002
10002   003
10002   004
10002   005
10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006
etc

Any ideas?

Thanks,
maa


--

Best regards/Venlig hilsen

/*Peter Gram*/ 

Miracle A/S 
Kratvej 2
DK - 2760 Måløv
Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Email: [EMAIL PROTECTED] 
SQL Server Master Class 8-10 Marts,
Database Forum 28-30 October
Master Class 17-19 Januar 2005.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--

Best regards/Venlig hilsen

/*Peter Gram*/ 

Miracle A/S 
Kratvej 2
DK - 2760 Måløv
Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Email: [EMAIL PROTECTED] 
SQL Server Master Class 8-10 Marts,
Database Forum 28-30 October
Master Class 17-19 Januar 2005.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HEL

RE: Spool to Excel File

[Mudhalvan, Moovarkku]

Title: Message



Thank 
you so much for all your response...
 
To 
solve this issue temporarily... I used SYLK But i was planning to go for 
Perl. Since i am begineer in Perl hope i need to study a bit.. 

 
Thank 
You
 
Mudhalvan M.M

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 
  Wednesday, January 21, 2004 8:29 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Spool to Excel 
  File> If you 
  use tab separated columns, you can also generate formula's that look like 
  text, but work just fine in the spreadsheet! Didn't realize. In any case, Perl is a much superior tool for this.  The 
  SpreadSheet::WriteExcel module 
   allow you to write to individual pages in a workbook. 
  Jared 
  


  
  "Mercadante, Thomas F" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 01/20/2004 12:59 PM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        RE: Spool to Excel 
File"SYLK allows cell references, etc, if 
  needed, which you won't get with CSV. "   
  Ahh.  but you can with my method! 
   If you use tab separated columns, you can also generate formula's that 
  look like text, but work just fine in the spreadsheet!   
  Tom Mercadante Oracle Certified 
  Professional 
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 
  Tuesday, January 20, 2004 3:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Spool to Excel FileStrange, no one has mentioned OWA_SYLK. Do 
  a search on SYLK at asktom.oracle.com There are 2 versions, one 
  for web output and one for excel output. SYLK allows cell 
  references, etc, if needed, which you won't get with CSV. Jared 
  


  
  "Mudhalvan, Moovarkku" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 01/19/2004 08:44 PM Please respond to 
ORACLE-L 
          
       To: 
       Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> 
       cc: 
        
      
 Subject:        Spool to Excel 
FileDear 
  Friends,               I am 
  trying to send output from SQLPlus to Excel file. If anyone did the same 
  before please let me know. Thank YouMudhalvan M.M-- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net-- 
  Author: Mudhalvan, MoovarkkuINET: 
  [EMAIL PROTECTED]Fat City Network Services    -- 
  858-538-5051 http://www.fatcity.comSan Diego, California     
     -- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

Re: Renumber a set of grupped rows?

[Mark Richard]

Maryann,

Like I said - the analytical functions are available in 8i (I believe 8.1.5
and onwards but it might have been 8.1.7).  The PL/SQL engine wasn't made
aware of them though so wrap then in "execute immediate" within PL/SQL to
get them going.

An update is possible in PL/SQL but it's easier to create a new table and
swap them around - unless that creates some major headaches for you.




   
   
  Maryann Atkinson 
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  .com>cc: 
   
  Sent by: Subject:  Re: Renumber a set of grupped 
rows?  
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  21/01/2004 10:39 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




 > select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
 > from emp
 > /

Hm... but thats not available in 8i, is it?

and besides, I want to update the table, not just select from it...

..

thx
maa




At 06:19 PM 1/20/2004, you wrote:
>Maryann
>You can use the new windowing function, here is test select working
>on emp :-)


>select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
>  from emp
>/
>
>DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO)
>-- 
>101
>102
>103
>201
>202
>203
>204
>205
>301
>302
>303
>304
>305
>306
>
>Maryann Atkinson wrote:
>
>>I have a 1-rows table with 2 columns, Emp_ID and Req_ID.
>>
>>There are about 150 different emp_ids in these 1+ records.
>>
>>What I want to do is the following:
>>
>>For every different Emp_id, I need the Rec_ids that corresponds to it
>>to be updated/renumbered starting from 1 and keep going up by 1.
>>
>>So I want it to look something like this:
>>
>>Emp_ID  Req_ID
>>
>>10001   001
>>10001   002
>>10001   003
>>10001   004
>>10001   005
>>10001   006
>>10001   007
>>10001   008
>>
>>
>>10002   001
>>10002   002
>>10002   003
>>10002   004
>>10002   005
>>
>>
>>10003   001
>>
>>10004   001
>>10004   002
>>10004   003
>>10004   004
>>10004   005
>>10004   006
>>
>>
>>etc
>>
>>
>>Any ideas?
>>
>>Thanks,
>>maa
>
>--
>
>Best regards

RE: Renumber a set of grupped rows?

[Maryann Atkinson]

At 06:49 PM 1/20/2004, you wrote:
Not pretty but it should work:
It does, thanks!

maa




SQL>  create or replace procedure emprec
  2   is
  3cursor empcursor is
  4  select empno, recno from emptest order by empno for update of
recno;
  5v_empno number := 9;
  6v_count number := 0;
  7   begin
  8for x in empcursor loop
  9  if x.empno <> v_empno then v_count:=1;
 10 v_empno := x.empno;
 11  end if;
 12  update emptest
 13 set recno = v_count
 14   where current of empcursor;
 15   v_count:=v_count+1;
 16end loop;
 17   end emprec;
 18  /
Procedure created.

SQL> execute emprec;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> drop procedure emprec;

Procedure dropped.



--Jeff

-Original Message-
Sent: Tuesday, January 20, 2004 3:24 PM
To: Multiple recipients of list ORACLE-L
I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.
So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008
10002   001
10002   002
10002   003
10002   004
10002   005
10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006
etc

Any ideas?

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

RE: All packages under sys is invalid

[Hamid Alavi]

Yes & it's fix all the invalid objects.
Thanks all

-Original Message-
Sent: Tuesday, January 20, 2004 1:29 PM
To: Multiple recipients of list ORACLE-L


Have you tried "$ORACLE_HOME/rdbms/admin/utlrp.sql" yet?  This will usually
recompile all invalid objects.  Note that you have to run this script from
SQL*Plus and have to be connected as SYS i.e. "connect / as sysdba".

HTH,
Faan
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 20, 2004 12:59 PM


> So what's the recommendation, how can I recompile all the SYS packages?
>
> -Original Message-
> Sent: Tuesday, January 20, 2004 10:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> Sent: Tuesday, January 20, 2004 12:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> so what's the solution?
>
> -Original Message-
> Sent: Tuesday, January 20, 2004 4:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Someone is messing with standard package ... so it would seem.
>
> Raj
> --
--
> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -Original Message-
> Sent: Monday, January 19, 2004 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All,
>
> I have an strange problem, most of the packages under SYS user are invalid
> when I compile it it's compile without error but when I back again the
> package still is invalid, anybody have any idea?
> Thanks in advance
>
> Hamid Alavi
>
> Office   :  818-737-0526
> Cell phone  :  818-416-5095
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>

> **
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
attorney
> work product or exempt from disclosure under applicable law. If you have
> received this message in error, or are not the named recipient(s), please
> immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
> message from your computer, Thank you.
>

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

Re: Parallel Query determined by?

[Jared . Still]

No other replies yet, so here goes.

First of all, what does it really mean when you say:

users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait".

Are these end users, or developers?  Seems rather curious that users would be mentioning this.


Second, what % of wait time do the Sync Waits contribute to?

If a small % of total, then there's not much point in spending time on it.

Third, is this actually causing a performance problem, or is it just appearing
as a 'trouble' item on some monitor?

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/20/2004 11:29 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Parallel Query determined by?


I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 & 4.

The users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait".

It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy.

Are there various init.ora settings that help the Parallel servers sync up, or is this just too high a setting?

I'm suggesting we back of a good many of these things to simply 2 or 4 and then work our way up from there. Some of those indexes set to 10 are only 20 meg and 4 extents. There's no way they are getting 10 on that I would think.

Can't find a whole lot on Metalink either. Or a good book on 800 gig warehouses using parallel?

--
13308 Thornridge Ct
Midlothian, VA  23112
804-744-1545
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

Re: Renumber a set of grupped rows?

[Stephane Faroult]

Maryann Atkinson wrote:
> 
> I have a 1-rows table with 2 columns, Emp_ID and Req_ID.
> 
> There are about 150 different emp_ids in these 1+ records.
> 
> What I want to do is the following:
> 
> For every different Emp_id, I need the Rec_ids that corresponds to it
> to be updated/renumbered starting from 1 and keep going up by 1.
> 
> So I want it to look something like this:
> 
> Emp_ID  Req_ID
> 
> 10001   001
> 10001   002
> 10001   003
> 10001   004
> 10001   005
> 10001   006
> 10001   007
> 10001   008
> 
> 10002   001
> 10002   002
> 10002   003
> 10002   004
> 10002   005
> 
> 10003   001
> 
> 10004   001
> 10004   002
> 10004   003
> 10004   004
> 10004   005
> 10004   006
> 
> etc
> 
> Any ideas?
> 
> Thanks,
> maa


MaryAnn,

  The row_number() analytic function was invented for you.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

RE: Renumber a set of grupped rows?

[Eberhard, Jeff]

Not pretty but it should work:

SQL>  create or replace procedure emprec
  2   is
  3cursor empcursor is
  4  select empno, recno from emptest order by empno for update of
recno;
  5v_empno number := 9;
  6v_count number := 0;
  7   begin
  8for x in empcursor loop
  9  if x.empno <> v_empno then v_count:=1;
 10 v_empno := x.empno;
 11  end if;
 12  update emptest
 13 set recno = v_count
 14   where current of empcursor;
 15   v_count:=v_count+1;
 16end loop;
 17   end emprec;
 18  /

Procedure created.

SQL> execute emprec;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> drop procedure emprec;

Procedure dropped.



--Jeff 

-Original Message-
Sent: Tuesday, January 20, 2004 3:24 PM
To: Multiple recipients of list ORACLE-L


I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.

So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008


10002   001
10002   002
10002   003
10002   004
10002   005


10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006


etc


Any ideas?

Thanks,
maa

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

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

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

Re: Renumber a set of grupped rows?

[Maryann Atkinson]

> select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
> from emp
> /
Hm... but thats not available in 8i, is it?

and besides, I want to update the table, not just select from it...

...

thx
maa


At 06:19 PM 1/20/2004, you wrote:
Maryann
You can use the new windowing function, here is test select working
on emp :-)


select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
 from emp
/
   DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO)
-- 
   101
   102
   103
   201
   202
   203
   204
   205
   301
   302
   303
   304
   305
   306
Maryann Atkinson wrote:

I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.
So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008
10002   001
10002   002
10002   003
10002   004
10002   005
10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006
etc

Any ideas?

Thanks,
maa
--

Best regards/Venlig hilsen

/*Peter Gram*/ 

Miracle A/S 
Kratvej 2
DK - 2760 Måløv
Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Email: [EMAIL PROTECTED] 
SQL Server Master Class 8-10 Marts,
Database Forum 28-30 October
Master Class 17-19 Januar 2005.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Spool to Excel File

[Jared . Still]

> If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet!

Didn't realize.

In any case, Perl is a much superior tool for this.  The SpreadSheet::WriteExcel
module  allow you to write to individual pages in a workbook.

Jared








"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/20/2004 12:59 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Spool to Excel File


"SYLK allows cell references, etc, if needed, which you won't get with CSV. "
 
Ahh.  but you can with my method!  If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet!
 
Tom Mercadante 
Oracle Certified Professional 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Spool to Excel File


Strange, no one has mentioned OWA_SYLK. 

Do a search on SYLK at asktom.oracle.com 

There are 2 versions, one for web output and one for excel output. 

SYLK allows cell references, etc, if needed, which you won't get with CSV. 

Jared 







"Mudhalvan, Moovarkku" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 01/19/2004 08:44 PM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        Spool to Excel File



Dear Friends,

                I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know. 

Thank You

Mudhalvan M.M
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
 INET: [EMAIL PROTECTED]

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

Re: Renumber a set of grupped rows?

[Peter Gram]

Maryann

You can use the new windowing function, here is test select working
on emp :-)
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
 from emp
/
   DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO)
-- 
   101
   102
   103
   201
   202
   203
   204
   205
   301
   302
   303
   304
   305
   306
Maryann Atkinson wrote:

I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.
So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008
10002   001
10002   002
10002   003
10002   004
10002   005
10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006
etc

Any ideas?

Thanks,
maa
--

Best regards/Venlig hilsen

/*Peter Gram*/ 

Miracle A/S 
Kratvej 2
DK - 2760 Måløv
Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Email: [EMAIL PROTECTED] 
SQL Server Master Class 8-10 Marts,
Database Forum 28-30 October
Master Class 17-19 Januar 2005.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: Developer Mailing List

[Jared . Still]

There is no other list similar to this one.







Mark Burgess <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/20/2004 01:29 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        OT: Developer Mailing List


Hi Folks,

does anyone know if there is a similar mailing list
for Oracle development topics?

Regards,

Mark


http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Mark=20Burgess?=
  INET: [EMAIL PROTECTED]

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

RE: RAC

[Hengen, Brian]

Not personally.  The testing that I did last year just used regular NBDs.
I'm not sure what the difference is.  Basically, the NBDs allow you to use
container files as raw devices -- it's nice because you don't need to mess
around with the disks, just create some files and serve them up through the
NBDs.  

--Brian
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, January 20, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L

Any experience with ENBD (Extended NBD), also from SourceForge?

Rich

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


-Original Message-
Sent: Tuesday, January 20, 2004 3:20 PM
To: Multiple recipients of list ORACLE-L


If you are using Linux, you can use NBD's (network block devices) that will
allow you to use a third PC as a storage device.  You can download the
drivers at http://nbd.sourceforge.net/ 

There's a pretty good paper out there as well, at
http://www.fi.muni.cz/~kripac/orac-nbd/  that will walk you through the
installation and configuration of the NBDs.

The performance isn't great, but it works.  If you need more information,
let me know -- I did a paper on this at IOUG last year and would be happy to
send it to you.

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

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

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

Re: Renumber a set of grupped rows?

[Mark Richard]

Hi Maryann,

I can do this easily when creating a new table using:

create table new_table as
select emp_id,
  row_number() over (partition by emp_id order by rec_id) as rec_id
from original_table;

Translating this into an update statement is probably a bit awkward for me
- I'd just create a new table and do some renaming (as long as that's a
viable option for you).  If not, hopefully someone will explain how this
could be constructed as a single update statement.

Regards,
  Mark.

PS:  Otherwise, if you are on Oracle 9 you could create some anonymous
pl/sql using the above statement as a cursor but include the rowid as a
field.  Loop through the cursor, updating rec_id where rowid =
cursor.rowid.  Unfortunately this won't work easily on Oracle 8 since the
PL/SQL engine doesn't know about analytical functions - you'd have to add
another layer of complexity (probably a temporary table).



   
   
  Maryann Atkinson 
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  .com>cc: 
   
  Sent by: Subject:  Renumber a set of grupped 
rows?  
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  21/01/2004 09:24 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




I have a 1-rows table with 2 columns, Emp_ID and Req_ID.

There are about 150 different emp_ids in these 1+ records.

What I want to do is the following:

For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered starting from 1 and keep going up by 1.

So I want it to look something like this:

Emp_ID  Req_ID

10001   001
10001   002
10001   003
10001   004
10001   005
10001   006
10001   007
10001   008


10002   001
10002   002
10002   003
10002   004
10002   005


10003   001

10004   001
10004   002
10004   003
10004   004
10004   005
10004   006


etc


Any ideas?

Thanks,
maa

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

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





<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shal

Re: Password management using profiles

[Reginald . W . Bailey]

You have to check for errors in the ORA-28000 range, for this is the range
that  password problems will use.  Add a check in your connection section
that will propagate any exception encountered. You can also trap the Oracle
errors for password expiration or locked account and display a more
understandable message instead.  This is the way I did it.  Also, create a
function or procedure that checks the EXPIRY_DATE and ACCOUNT_STATUS in the
all_users or dba_users table to determine when the password will expire or
if it has already. The function/procedure then can raise an exception if
the account is within the grace period or locked.

RWB



Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
[EMAIL PROTECTED]  
 
n.eduTo: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: Re: Password management using 
profiles 
ity.com
  
   
  
   
  
01/20/2004 
  
02:49 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  








We're using pl/sql gateway and the Apache server.  We've set up a default
DAD on the gateway configuration screen, the connect string is our server
name.  Basic authentication, Package/Session Management Type:
Stateless(Reset Package State).

I've tried the profile by setting up a test user and expiring the account.
If I go to sqlplus and log in with the expired user account sqlplus prompts
me for a new password.  I don't have a problem with that, but you know how
users are, they wouldn't figure out why.  And management wants users to
receive a message telling them why they have to change their passwords
without going through the Help Desk.

My guess is that a pl/sql package has to be written so users get their
password check at login time and receive messages such as the number of
days they have before the password expires, or that the password is
actually expired.

Thanks

Ana E. Choto
Systems Programmer
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax  (202) 885-2224



 Mladen Gogala
 <[EMAIL PROTECTED]
 ng.com>To
 Sent by:  Multiple recipients of list
 [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]>
 .com   cc

   Subject
     01/20/2004 03:24  Re: Password management using
 PMprofiles


 Please respond to
 [EMAIL PROTECTED]
com






On 01/20/2004 02:34:45 PM, Ana Choto wrote:
>
>
>
>
> I have set up a profile where the passwords expire in 30 days, 6
> characters
> minimum, grace period before the account locks to 6 days.  It works
> as
> expected when the user logs in to our web site and tries to change
> the
> password.  Users receive error messages whenever their password
> doesn't
> comply with the rules we have set up in the pro

Re: OT: Developer Mailing List

[Pete Finnigan]

Hi,

There is a newsgroup comp.databases.oracle.tools that covers Oracle
development. 

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

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

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