Re: Automatic or Uniform allocation

Ron, I agree, uniform sizing is best. I hardly ever use automatic except for small development databases and small MISC tablespaces and even then I think Why didn't I use use uniform 64K ? Cheers, Chris Quoting Ron Rogers [EMAIL PROTECTED]: Brad, For LMT's I prefer uniform sizing that I

Re: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

Thanks a lot, Bruce. Much appreciated. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here.

note 216205.1 [was :RE: Process consumes CPU and long time to

Hi, anyone has read and implement as note 216205.1 ? any comment or suggestion ? regards -Original Message- From: hernawan [mailto:[EMAIL PROTECTED] Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it

Re: pga_aggregate_target and a memory leak

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

Re: What to look for in STATSPACK report

well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nørgaard [EMAIL PROTECTED]

Re: TKProf Analyzer

Hi, check out Mogens site, he has a PL/SQL tool for storing trace files in a repository. Its called TraceFile Repository and was written by Torben Holm and its free - have a look http://www.miracleas.dk/tools/Mir TFR104.zip -t might be an alternative for you? - it has a web based front end using

Re: OT: Solaris: Finding the cause for disk space growth

Check out the du (disk usage) command. man du [EMAIL PROTECTED] 01/23/04 03:44AM Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I

RE: !!Please Read - Oracle-L is moving!!

Title: Message -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks

Re: OT: Solaris: Finding the cause for disk space growth

Naveen, Since you are new to Solaris, how new are you to unix/linux? If you are already aware of anything, I apoligize: spool the output of df -k to a file. I really like the script command for this. Wait some time (long enough for more disk to get used) and do it again (rename the first

RE: !!Please Read - Oracle-L is moving!!

Re: pga_aggregate_target and a memory leak

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

RE: !!Please Read - Oracle-L is moving!!

2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving

RE: Trigger, how?

Use: when updating col1, col2,... clause. Better yet, read oracle docs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:19 AM To: Multiple recipients of list ORACLE-L Hallo all, Anyone whom know how to write the trigger

RE: !!Please Read - Oracle-L is moving!!

riginal Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat y

RE: !!Please Read - Oracle-L is moving!!

Title: Message Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving

RE: !!Please Read - Oracle-L is moving!!

College -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toepke Sent: Friday, January 23, 2004 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this feature: Navigate

Re: What to look for in STATSPACK report

I've tried to get ahold of Anjo off-list several times. I'm sure he is busy, but I really need to get ahold of him. Can someone off-list ask him to e-mail me at either/both of these addresses? [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks Stephen [EMAIL PROTECTED] 01/23/04 12:19AM Hi Tim,

RE: How to find the last execution time of a Procedure.

We for one don't like ANYTHING invalid in production database ... either it is valid or it gets dropped. Raj -Original Message- Sent: Friday, January 23, 2004 2:24 AM To: Multiple recipients of list ORACLE-L Not sure if that is what you want... and not sure if this will really work,

RE: !!Please Read - Oracle-L is moving!!

Title: Message Thanks guys! From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options me

Re: What to look for in STATSPACK report

cc: Please respond to ORACLE-LSubject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file

RE: Help - 9ias broke - hostname was changed

-LSubject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject

RE: !!Please Read - Oracle-L is moving!!

Why not stop using Outlook. I've been happy with Eudora for 1.5 years now. Hemant Hemant At 07:54 AM 23-01-04 -0800, you wrote: Thanks guys! From: Kevin Toepke [mailto:[EMAIL PROTECTED]] Sent: Friday, January 23, 2004 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read

Re: Jobs are not working

I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in

RE: [Q] create tablespace with different block size error???

dba1 I think you must first create a buffer cache for this block size. http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 10:29 AM To: Multiple recipients of list

RE: commit for triggers

A two-phase commit is simply a way to make sure that commits happen in a distributed transaction the same way that they do in a local transaction. The absolute rule is: Everything commits or Nothing does. In-between, with some parts committed and some not, is NOT tolerable. So in your

RE: Help - 9ias broke - hostname was changed

htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't

Re: What to look for in STATSPACK report

ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How m

RE: Sql Tuning Thoughts?

Tracy, Take a look at the thing calling this 43,814 times. Can this query be used as an inline view for the thing using this querys result set? If so, then youll eliminate 87,629 database calls. As Tom Kyte says, Tune the QUESTION, not the query. Cary Millsap Hotsos Enterprises,

Re: OT: Solaris: Finding the cause for disk space growth

One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with

Re: [Q] create tablespace with different block size error???

And ... what is the error number that you get ? Note : If you are creating a tablespace with the non-standard blocksize, you must have db_cache_Xk_size configured and running for your instance before you create the tablespace. Hemant At 08:29 AM 23-01-04 -0800, you wrote: I tried to create

Re: What to look for in STATSPACK report

respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI

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

PROTECTED] cc: Subject:Re: Oracle 8.1.7 can only use the first 15th indexes? Amen to that. I had a table with about 40 indexes on v7.0.16. I don't think that it was possible that any of them could have been ignored, because all of them were used. I can't verify that, because this system

RE: OT: Solaris: Finding the cause for disk space growth

Naveen - Are you using autoextend on any of your datafiles? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:39 AM To: Multiple recipients of list ORACLE-L One way to determine where to start looking is via find: find /

Re: Views for a table

The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks,

Re: [Q] create tablespace with different block size error???

Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti --- dba1 mcc [EMAIL PROTECTED] wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace

Re: Help - 9ias broke - hostname was changed

Did you change LDAP configuration files? Which LDAP server was it? WebLogic? WebSphere? iPlanet? iAS? OpenLDAP? Usually, after changing the host name, servers have to be reconfigured and re-started? Does your LDAP server have a GUI admin utility and can you connect to the server by using

RE: Help - 9ias broke - hostname was changed

. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname

Re: [Q] create tablespace with different block size error???

You may want to define DB_16K_CACHE_SIZE in init.ora, or use ALTER SYSTEM to set this value. HTH, Krishna ~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged

RE: Views for a table

Title: Message Query DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and referenced_type='TABLE'. -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:50 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: Jobs are not working

Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not wor

RE: Application Server Caching

if memory serves); if a buffered row is updated, it’s marked dirty in the buffer, then the dirty bits are sync’d to the other app servers. The first app server to request that row re-validates the buffer. They also handle sequences in a similar way; SAP uses “number ranges” rather than relying

RE: Jobs are not working

Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 233, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why

RE: Jobs are not working

PMTo: [EMAIL PROTECTED]Cc: Goulet, DickSubject: RE: Jobs are not working The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote:

Re: Jobs are not working

On 01/23/2004 11:29:32 AM, Mauricio V?lez wrote: How can I resolve this? By reading the administrators guide. -- 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

Re: [Q] create tablespace with different block size error???

On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote: Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti He probably has left db_16k_cache_size parameter but the problem described here is with syntax, not the cache size. Parser stops looking or file attributes

RE: Help - 9ias broke - hostname was changed

Yes, but how do I fix it? Do I need to reinstall? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias broke - hostname

RE: internal date value

You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I

RE: Help - 9ias broke - hostname was changed

I think he lucked out and didn't do this on a highly visible system. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias

RE: Jobs are not working

of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after

Re: !!Please Read - Oracle-L is moving!!

Ref: Fix subscription errors after Final Confirmation message I'm on Yahoo. The workaround is to send the Final Confirmation message (with that //job stuff) back using the Forward button (not Reply). You have to cut-paste the address. The problem with Reply is caused by HTML formatting in the

RE: commit for triggers

John, Thanks for your very detail explanation. From: John Flack [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: commit for triggers Date: Fri, 23 Jan 2004 09:09:34 -0800 A two-phase commit is simply a way to make sure

Re: internal date value

Igor Sorry but Oracle uses 7 bytes for a date century (1 byte) year (1 byte) month (1 byte) day (1 byte) hour (1 byte) minute (1 byte) second (1 byte) SQL desc d Name Null?Type -

RE: internal date value

Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for

RE: internal date value

Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I request an Oracle date field, SAS creates a datetime variable, number of seconds since midnight Jan 1, 1960. Rather than use SAS functions to extract the

RE: internal date value

Harry This list is moving to freelists, but I'll assume you knew that. Actually the base value for the standard Oracle dates is Jan 1, 4712 BC. There is a Julian function that will return the number of days since the base. To return the Julian, select to_char(sysdate,'J') from dual; Also,

RE: commit for triggers

John, I agree w/ everything you said, except for the autocommit functionality. Autocommit setting has no impact on whether DDL will commit or rollback any in progress transaction. DDL always commits an in-progress transaction. The short example below speaks for itself. (8.1.7.4 on Solaris 2.8)

RE: winders email client.

- -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is

RE: Help - 9ias broke - hostname was changed

. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias

RE: Views for a table

Mladen, Any privileges required to view this table, or just common sense? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, January 23, 2004 1:24 PM To: Multiple recipients of list ORACLE-L The table you want to look into is USER_OTN, Column

RE: internal date value

Oops... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Peter Gram Sent: Friday, January 23, 2004 2:54 PM To: Multiple recipients of list ORACLE-L Igor Sorry but Oracle uses 7 bytes for a date century (1 byte) year (1 byte) month (1 byte) day (1 byte) hour (1 byte) minute

RE: internal date value

Thomas: I'm aware of the to_char function and the various options. However as you alluded to, that lands in SAS as a character literal, e.g. '22/01/2004' requiring me to convert it to internal format before I can use it in SAS. I think I have to use my work around: select date_fld -

RE: pga_aggregate_target and a memory leak

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

RE: internal date value

Thanks to all who replied with helpful comments, pointers, links etc... -Original Message- Sent: January 23, 2004 3:24 PM To: Multiple recipients of list ORACLE-L Harry This list is moving to freelists, but I'll assume you knew that. Actually the base value for the standard Oracle

RE: How to find the last execution time of a Procedure.

]cc: eywell.com Subject: RE: How to find the last execution time of a Procedure. Sent

RE: winders email client.

: [EMAIL PROTECTED] Subject: RE: winders email client. m

Re: winders email client.

by: cc: [EMAIL PROTECTED] Subject: RE: winders email client. m

RE: winders email client.

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: winders email client. Where can you get this firebird browser? http

RE: winders email client.

: [EMAIL PROTECTED]Subject: RE: winders email client. om

Re: winders email client.

[EMAIL PROTECTED] wrote: Where can you get this firebird browser? http://mozilla.org/ -- Bricklen Anderson PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET:

RE: winders email client.

] Sent by: cc: [EMAIL PROTECTED]Subject: RE: winders email

RE: internal date value

Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 3:09 PM To: Multiple recipients of list ORACLE-L Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I

Re: Views for a table

The only privilege you can grant to yourself : GRANT RTFM TO user [WITH GRANT OPTION]; Igor Neyman wrote: Mladen, Any privileges required to view this table, or just common sense? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday,

RE: Re: pga_aggregate_target and a memory leak

this also. I will email him To ask for details. Anybody else experience with this or this patch? Regards, Jeroen -Oorspronkelijk bericht- Van: Arnold, Sandra [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 23 januari 2004 3:19 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Re

RE: internal date value

Harry, Look at the to_char function in Oracle. It will convert a date field to *any* format you want. for example: select to_char(date_field,'mm/dd/ hh24miss') will return a date in the format as noted. You have about as many options as you probably need. You can combine as many format

RE: Jobs are not working

PROTECTED]Sent: Friday, January 23, 2004 1:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Jobs are not working Mauricio: Define the exact symptoms of your problem. For example: How are the jobs being submitted? Are you getting an error message upon

RE: Jobs are not working

Do you have 4 jobs currently running? Maybe you need more processes. John -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued c

Re: [Q] create tablespace with different block size error???

Comment in-line On 01/23/2004 11:29:25 AM, dba1 mcc wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize

Re: RE: pga_aggregate_target and a memory leak

EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April

RE: How to find the last execution time of a Procedure.

ORACLE-L Subject: RE: How to find the last execution time of a Procedure. But you better check with experts as my knowledge of x$ is feather-weight ... also there is a column on x$kglob called kglhdexc ... to me it seems the execution count (I feel like Mr. Monk already). so if execution count

RE: RE: pga_aggregate_target and a memory leak

] Date: 2004/01/23 Fri PM 03:24:45 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had

RE: How to find the last execution time of a Procedure.

Life is much easier, just use audit execute on proc name No need for the x$tables :) Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Hi All, Is there anyway to find out from data

Re: RE: pga_aggregate_target and a memory leak

On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very

Re: commit for triggers

Perhaps I got it wrong, but, John - are you saying that the entries are part of the rollback, i.e. if the transaction that caused the audit trail entries to be created is rolled back, the audit trail enries are rolled back as well? The auditing entry is NOT part of the transaction, it's created

RE: commit for triggers

Mark - Thanks for the correction. When I looked at what I said about the transaction before a DDL command a second time, I myself wondered if I'd gotten it right. If you've tested it, and the transaction is always committed, I'll take your word for it. Arup - I don't normally use Oracle's

Re: is this possible ?

What are you trying to get? Column values or (TABLE,COLUMN) combination? You could probably use a function like this: create or replace function trickery(T varchar2,C varchar2, V number) return number deterministic as qry varchar2(2048); cnt number:=0; begin qry='select count(*) from '||T||' where

RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

Looking at the source (list owner) I'd say it is. Jack -Original Message- Sent: Thursday, January 22, 2004 9:29 AM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To:

Re: Unusable partition index -- working funny

fires, but the execution engine is committed to using index X - which happens to be unusable, so the statement fails. On the second call, the session parameters have changed, so Oracle re-parses the update, and ignores the unusable index, choosing a different plan. Consequently the update can work

Re: fast commit

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 -

Re: Re: pga_aggregate_target and a memory leak

load has hit it. Paul this was on w2k server sp3, 9.2.0.4 std ed 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

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

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

RE: Ixora off-line, moved?

I also tried this morning a few times and it was down. -Original Message- Sent: Thursday, January 22, 2004 12:04 PM To: Multiple recipients of list ORACLE-L ixora.com.au seems to be unavailable. Any clue? Regards, Carel-Jan === If you think education is expensive, try ignorance.

RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

Yes indeed It is.. :) -Original Message- Venu Gopal Sent: Thursday, January 22, 2004 1:59 PM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear

Re: fast commit

Thank You Jonathan. Syed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:29 PM Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the

RE: Has anyone done any scalability work on dbms_lock?

Just remember these words about global contexts ... 'doesn't work correctly in RAC' ... A global context is global only within instance ... not across. Raj Rajendra dot Jamadagni at nospamespn dot com All Views

Re: Trigger question

Enable auditing on COMPANY? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === Hallo everyone, I have the table system_change and I I have the insert statement here below be run when there is an update or insert of a value in any ofthe fields

Re: Re: pga_aggregate_target and a memory leak

Paul, Most of my work is on HP-UX and AIX. I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I work with are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either. - Kirti --- Paul Drake [EMAIL PROTECTED] wrote: --- Kirtikumar

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

Branimir Beware of simple ratios. The logic is seductive. It seems likely that an easy way to find unnecessary indexes is to look at a ratio such as you describe. And it shouldn't pose much load on a system to do a quick report on ratio. But what would it mean in practice? Just go around

RE: Old thread - trace file location

Thanks Alexander. I wasn't aware of this new feature. It will certainly make my script much simpler. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:49 PM To: Multiple recipients of list ORACLE-L

RE: Trigger question

The easiest way to write code for me is to use a text editor and sqlplus, always works for me. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod

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

comments in line... I may need correction from some of you on this. -Original Message- Sent: Wednesday, January 21, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper

<    1   2   3   4   5   6   7   8   9   10   >