Memory leak problem

Dear DBA Gurus, OS: Solaris 8 (SUN OS 5.8) Oracle Ver: 8.1.5 and 8.1.6 Nature of problem: There is a problem reported from our application that there is a memory leak problem in OCI related queries. I posted the problem in OTN and got the response that, these versions require patches. Bu

OT: Unix performance metrics

Hello all, About 2-3 months back, I had seen a good email from some sales guy on this list, descrbing what all performance meterics are a must, which metrics would be desirable and which perf. metrics would be optional in a perf. tool for monitoring oracle. I need similar kind of info. now for

Re: script to run before startup

Use the database trigger after startup event of the database. -- On Sat, 28 Apr 2001 07:35:34 Bunyamin K.Karadeniz wrote: > I want to run a script after the startup of database automatically. > How can I do this on NT?? > > >Bunyamin K.Karadeniz >Database Group / I

Change email address

Hi list member, How do I change the email address in this list so it will send the list messages to my new email address? Searching through HELP of ListGuru but find nothing. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lu Kai Hin INET: [EMAIL PROTECTED]

Re: date format ?

Mohammad, This really depends on the front end tool you are using. Is it Oracle Forms? You can probably use a trigger in the form to allow your client to do this. I haven't programmed Forms in awhile, and can't give detailed directions. This kind of ridiculous request is exactly the reason I

Re: Urgent: How to Automate Procedure Execution

Thanks David, big help! Abdul Latif --- "David A. Barbour" <[EMAIL PROTECTED]> wrote: > dba_jobsLists all the jobs in the database. > user_jobs Lists all jobs owned by the user. > dab_jobs_running Lists all jobs in the database > that are currently > running (join with V$LOCK to identif

Re: date format ?

Mohammed, Just off the top of my head, I don't think this will work unless you bring the day, month and year in separately. At first glance I thought perhaps if you took the length of the date string (less than 6 or more than eight you've got an error), backed out the last four as the year - so

Re: defragment ?

8i+ alter table BLAH move; and then rebuild indexes.. Cheers Connor --- Muthaiah <[EMAIL PROTECTED]> wrote: > Hi, > > 1. Create a dummy table by using > create table dummy_table as select * from > original_table; > 2. Truncate your original_table > 3. insert into original_table sele

Re: Urgent: How to Automate Procedure Execution

dba_jobsLists all the jobs in the database. user_jobs Lists all jobs owned by the user. dab_jobs_running Lists all jobs in the database that are currently running (join with V$LOCK to identify jobs that have locks). Hope this helps. David A. Barbour Oracle DBA, OCP abdul latif wrote:

RE: Urgent: How to Automate Procedure Execution

Raj, Which view do you use to view dbms_jobs? tia --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Yes, I have used with very good success it's > all documented in T(ht) > F(ine) M(anual). Or just open up > $ORACLE_HOME/rdbms/admin/dbmsjob.sql ... > this file itself is pretty good at

Re: OT: LazyDBA List Owner?

Larry, it's Henry O'Keefe - the last email address I have on file for him is this [EMAIL PROTECTED] hope it helps Q [EMAIL PROTECTED]@fatcity.com on 04/29/2001 10:05:19 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[

OT: LazyDBA List Owner?

Listers, Since I know there are folks on this list who also follow the LazyDBA list, who is the list owner of LazyDBA? I'm thinking it is Henry something, but, I can't remember the last name. I couldn't come up with any contact info at the LazyDBA site. I haven't been receiving emails from the L

RE: Pinning Packages Question

Steve, Thanks for the insight on how the kept status is managed during an invalidation. Regards, Larry G. Elkins [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Adams > > Hi Larry and list, > > > When a library cache object i

How to see Archive of this list?

Is there a way I can see archive of this list on any web site?   TIA - H - Original Message - From: Bunyamin K.Karadeniz To: Multiple recipients of list ORACLE-L Sent: Saturday, April 28, 2001 11:35 AM Subject: which tables to cache ?     I am planning to cache

Re: defragment ?

Hi, 1. Create a dummy table by using create table dummy_table as select * from original_table; 2. Truncate your original_table 3. insert into original_table select * from dummy_table; This will eliminate the fragmenataion Hope this helps, Regards, Muths At 11:40 PM 4/28/01 -0800, yo

RE: date format ?

set nls_date_format for the session to 'ddmm'. In this case also he needs to enter date as '09091999' and not '991999'! Evaluate the pros and cons before making such a change in live db. Thanks, Amar Kumar Padhi -Original Message- Sent: Sunday, April 29, 2001 12:50 PM To: Multiple

date format ?

hi oracle gurus, my client is very weird,he wants to enter the date in the format 'dd-mm-' without pressing space instead of delimiters,e.g. he presses '991999' and wants oracle to change it to '09-09-1999' .!!! Can I do it for him? If anyone knows how,I'll be very grateful.