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

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 Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for

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

I would check which index is being reported as unusable, and check the access path for the query when all indexes are useable. Since you have a statement level trigger, I suspect Oracle is producing an execution plan that dictate the use of index X. The plan executes, which means the trigger

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

Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone

Ixora off-line, moved?

ixora.com.au seems to be unavailable. Any clue? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services--

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

Trigger question

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 ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY insert into system_change

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

any over head with DBMS_STATS.ALTER_DATABASE_TABLE_MONITORING

Especially on high transaction tables? I dont have any numbers for transactions/second since we are not live. Any known issues? how does the monitoring work? Does it use an internal trigger and then use SQL to write the data? or does the monitoring data bypass the SQL layer and get written

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

Trigger question

Hallo, 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 any of the fields ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY The script bo be run is this one: insert into system_change

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

data manipulation of a large unix file

We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to

Metalink on the blink

Title: Metalink on the blink Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] The swim only hurt once - from the beginning to the end - Doc Counsilman on swimming the English

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

RE: Metalink on the blink

Title: Metalink on the blink A little slow, but nothing out of the ordinary. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004 9:59 AMTo: Multiple

Automatic or Uniform allocation

for LMTs... Advantages in uniform versus automatic? Uniform 5 MB? 10 MB.100MB etc thoughts would be appreciatd Thanks Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Metalink on the blink

Title: Metalink on the blink I avoid the log in problem... I just stay logged in all week. Saves time in the long run. It is running REALLY slowly, though... (I was putting that down to our crappy network) and I logged out and back in... Nope... It's just you Matt! =) April Wells Oracle

Re: Metalink on the blink

I've just logged in and reviewed an old TAR and did a survey on a closed TAR. Maybe it's you :) [EMAIL PROTECTED] 01/22/04 07:59AM Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED]

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

Yes indeed, it is genuine. Jared On Thu, 2004-01-22 at 00:29, Venu Gopal wrote: 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 Oracle-L subscriber, Due to changing circumstances,

RE: Metalink on the blink

Matthew - Works fine for me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Is anyone else having problems with Metalink this morning or is it just us? We can't log in at

RE: data manipulation of a large Unix file

considered Perl ?? also the load you mention is for what? adding data to the data file you get or loading into the db?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly

Re: data manipulation of a large unix file

Ryan, Could you cat the second file on to the end of the first file and have the data load successfully? cat file2 file1 How about a second box to perform the editing of the data file. Something that resource intensive and manditory should not have a problem getting funded. Ron [EMAIL

RE: Metalink on the blink

Title: Metalink on the blink Painfully slow, but it works. -Original Message- From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 9:59 AM To: Multiple recipients of list ORACLE-L Subject: Metalink on the blink Is anyone else

RE: Metalink on the blink

Title: Metalink on the blink not me ... it is working fine ... 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

RE: Metalink on the blink

Title: Metalink on the blink but their education site is off the air (at least it was an hour ago) Tom Mercadante Oracle Certified Professional -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004 10:09 AMTo: Multiple recipients of

RE: data manipulation of a large unix file

Ryan - Can you provide more details? Typically ksh scripts are much, much more efficient than alternate methods, such as manipulating data within the database. Depending on which method you are using to measure CPU usage, you may be seeing 1/4 of one CPU. But even if your script is using a full

Re: Metalink on the blink

On 01/22/2004 09:59:27 AM, Adams, Matthew (GECP, MABG, 088130) wrote: Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. It's just you. What did you do to Larry to punished in such a way? -- Please see the official ORACLE-L FAQ:

Re: Automatic or Uniform allocation

Brad, For LMT's I prefer uniform sizing that I can define to meet the needs of the data. If you use automatic the extend sizes will change drimatically as the number if extends increase. With a little planning you can have little waste in the tablespace and use the tablespace for multiple tables

How to get unique value using AWK?

Hi All, My manager wants to get all the unique wait events from the trace file. I tried the below but how do i get DISTICT wait event name? Any help would be really appreciated. $ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5 $6}'|more nam='SQL*Net message to client'

RE: Automatic or Uniform allocation

We need to start moving these discussions to freelists per Jared's note. Brad - I agree with Ron. I think it is critical to read How to quit defragmenting . . . before making the change to ensure you clearly understand the concepts and receive the benefits. If someone on the list knows of a more

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

Yes, this is legitimate. Jared and I have been talking recently about this. This list has just outgrown what Fat City can handle. While I'd like to think that I've always provided adequate-to-good service for the list, it's never been great, and with the list growing, and traffic growing, my

How to find the last execution time of a Procedure.

Hi All, Is there anyway to find out from data dictionary views when was a database procedure/function last executed. Would like know the solution for 8i and 9i databases. We have some older code in the databases and do not know if any application is using it or not. I appreciate your help.

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

Bruce, I think I'd characterize the service provided as great, period. Sure we've had the odd hiccup now and again, but on the whole it has been great. Thanks a whole lot, your work has been and is appreciated. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original

RE: How to get unique value using AWK?

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:09 AM To: Multiple recipients of list ORACLE-L Subject: How to get unique value using AWK? Hi All, My manager wants to get all the unique

RE: How to get unique value using AWK?

pipe it through uniq 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-

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

not easily, but you could probably scan through x$kglob (frequently) and see if the name exists ... if it is, it means it was loaded for execution. Another solution might be to modify old code and have them add a row in a separate table using autonomous transaction to indicate they got

Thanks Bruce

It's been a great ride. Bruce A.

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

Well, I don't know about anyone else, but I make use of it to synchronize data upload programs for our testers. Can't have two instances of the upload program processing the same tester, they'd duplicate data. Anyhow, we normally run 4 instances of this program the dbms_lock package works

RE: Re: pga_aggregate_target and a memory leak

I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is pointing to some memory problems. It is occurring during the CTX_DOC.FILTER process. We are running this process from a custom PL/SQL package that is being initiated from an Oracle Job. However, we

Re: How to get unique value using AWK?

There is much improved version of awk called perl and it has something called hashes. Code snippet would look something like this: my %Godot; while (} { chomp; if (/\'([^\']+)/ { next if exists $Godot{$1}; $Godot{$1}=undef; } } foreach (sort keys %Godot) { print $_\n; } On 01/22/2004

Re: Automatic or Uniform allocation

I think http://www.jlcomp.demon.co.uk/08_lmt.doc is pretty good, but I'm biased. 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

RE: How to get unique value using AWK?

On Thu, 2004-01-22 at 10:34, Simpson, Ken wrote: How about piping it through uniq? uniq normally assumes the input is sorted. See my other response. Best, -- Edward Simmonds RHCE, OCP - Real men don't send html email. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

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

Jared and Bruce: Thanks for everything. Waleed -Original Message- Sent: Thursday, January 22, 2004 11:14 AM To: Multiple recipients of list ORACLE-L Yes, this is legitimate. Jared and I have been talking recently about this. This list has just outgrown what Fat City can handle.

Re: any over head with DBMS_STATS.ALTER_DATABASE_TABLE_MONITORING

The number of rows affected by an SQL statement is something that has been available to Oracle for a long time. Monitoring just records that number in a memory structure. I'd guess the memory structure is a hash table, and there are no latches protecting it (so I've heard, and I can't see any

RE: How to get unique value using AWK?

Try this ... $ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5 $6}'| sort -u Thanks, Nikhil -Original Message- Sent: Thursday, January 22, 2004 11:09 AM To: Multiple recipients of list ORACLE-L Hi All, My manager wants to get all the unique wait events from the trace

RE: How to get unique value using AWK?

uniq is not ubiq. If uniq doesn't do it for you, do sort -u -Original Message- Sent: Thursday, January 22, 2004 10:34 AM To: Multiple recipients of list ORACLE-L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent:

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 as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared

RE: How to get unique value using AWK?

Why not process the trace file with 9i tkprof? It will nicely summarize the wait times for those events. After seeing those unique wait events, your boss may ask for the wait times next!! Be proactive :) - Kirti --- Simpson, Ken [EMAIL PROTECTED] wrote: -Original Message-

Re: any over head with DBMS_STATS.ALTER_DATABASE_TABLE_MONITORING

Too bad Steve Adams' site is not available, cuz that's the place to be. He says it better than I can, so I've appended a bit of info from him. I'd suggest getting to Steve's site as soon as it's up. We have monitoring enabled on our 9.2.0.4 database, but it's not currently heavily used. But so

Re: How to get unique value using AWK?

On 01/22/2004 12:04:35 PM, Bellow, Bambi wrote: uniq is not ubiq. If uniq doesn't do it for you, do sort -u Why would you things that way when you can do them in perl? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network

Sql Tuning Thoughts?

This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build an extract table from multiple tables. The extract table is then used for

Re: How to get unique value using AWK?

On Thu, 2004-01-22 at 10:09, [EMAIL PROTECTED] wrote: Hi All, My manager wants to get all the unique wait events from the trace file. I tried the below but how do i get DISTICT wait event name? Any help would be really appreciated. grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3

Re: How to get unique value using AWK?

Jay - Try: $ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5 $6}' | sort | uniq | more HTH, Dave Hi All, My manager wants to get all the unique wait events from the trace file. I tried the below but how do i get DISTICT wait event name? Any help would be really

RE: How to get unique value using AWK?

That goes both ways, my friend. :) -Original Message- Sent: Thursday, January 22, 2004 11:40 AM To: Multiple recipients of list ORACLE-L On 01/22/2004 12:04:35 PM, Bellow, Bambi wrote: uniq is not ubiq. If uniq doesn't do it for you, do sort -u Why would you things that way when

RE: Sql Tuning Thoughts?

it depends on how the code is written ... maybe it is doing row operations ... care to show the code (at-least pseudo code) ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

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

Bruce, Thanks for all your work, support, and honesty. It's appreciated. Henry -Original Message- Bruce A. Bergman Sent: Thursday, January 22, 2004 11:14 AM To: Multiple recipients of list ORACLE-L Yes, this is legitimate. Jared and I have been talking recently about this. This

Re: Sql Tuning Thoughts?

Comments in line. On 01/22/2004 12:24:26 PM, Tracy Rahmlow wrote: This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build an extract

Re: RE: How to get unique value using AWK?[CLOSED]

Thanks Kirti and everyone who responded. This forum is really great. - Original Message - Date: Thursday, January 22, 2004 12:14 pm Why not process the trace file with 9i tkprof? It will nicely summarize the wait times for those events. After seeing those unique wait events, your

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

The list members must be really hammering their servers now. I've tried to sign up using both the web and email methods and have yet to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org ;-) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I

Re: Sql Tuning Thoughts?

Since you're doing an aggregate function, you may want to investigate using materialized views here. Since, I'm assuming, policy effective dates aren't something that changes on a minute-to-minute basis, you could set up a materialized view that refreshed every night and would answer this

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

Thanks for input Raj. I was also thinking on the same lines (Querying v$views periodically and store it in some metadata table) if there is no easier way to figure out from DBA_ views. As far as changing the production code, as you know, It has to go thru the dev/test databases first and then

Re: Automatic or Uniform allocation

Jonathan: I'd go a bit further than that. Your article is fantasitic. I've read How to stop defrag ... several times. It just never clicked for me. I've been migrating to LMT using your article, and it's been great. It's crystal-clear, and I really appreciate the examples. Thanks! Barb ---

RE: How to get unique value using AWK?

Reminder to post to freelists.org per Jared - I'm crossposting this reply. Jay Pipe your output to sort, then uniq. grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5 $6}'|sort|uniq Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday,

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 is 0 then you can say that it actually got executed. But if this

Re: Automatic or Uniform allocation

Johnathan, Very interesting article. I especially like the parts where it is not our fault it is designed that way. I agree that with proper thought and trial, a lot of perceived performance issues can be eliminated or minimized. I could really use the compress option, I guess that I will have to

RE: What to look for in STATSPACK report

I had this same problem. It ended up being that when I opened the file in exel, all the columns from the csv went into one excel column and for some reason it wasn't apparentor something like that. .now if I could only remember what it was I did to fix it. hmmm. ..i think it was some

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

It's working for me, but slowly. I tried to do it through the webpage and got the first confirmation e-mail back (containing a code to enter on the webpage.) Then I subscribed to the new list, got a second e-mail back to confirm my subscription, and replied to that. I'm sure more things will

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

I came across a very nice example a while ago where there were 4 concurrent sessions feeding data into a holding table, and one session consuming from the table. The rules said that the consumer could not run while the producers were loading the table, but multiple producers were allowed to run.

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

Well, I did check with them first to ensure the volume would be OK. It is running a bit slow. I'm not sure if it is just freelists.org, or a general internet slowdown. Sending mail from work to home it seems that it is taking much too long. Jared Ron Thomas [EMAIL PROTECTED] Sent by:

test please ignore

Test new oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: EPS - DBA (Group) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

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

I went through the webpage but never got the confirmation email back containing the code to be entered. -Original Message- Sent: Thursday, January 22, 2004 2:00 PM To: Multiple recipients of list ORACLE-L It's working for me, but slowly. I tried to do it through the webpage and got the

RE: What to look for in STATSPACK report

Chris - In Excel, click on Data -- Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file in

RE: Re: pga_aggregate_target and a memory leak

Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is

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

Give it a little time, you'll get it. Jared Arnold, Sandra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: !!Please Read - Oracle-L is

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

I was trying to sign up this morning... The response was fast but I keep getting booted on the final confirmation email... The message I get is... Invalid number of parameters. Not sure why... Figured I'd wait and see if anyone else is having the same problem... Anyone else experience

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

Thanks Raj. I have confidence on you and hope we will meet in next CTOUG meeting. Best Regards, Prasad 860 843 8377 Jamadagni,

RE: Automatic or Uniform allocation

Jonathan Thanks so much for posting this excellent article. Very high quality as all your writing is. This was my devious purpose in replying, in hopes something like this was out there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday,

RE: Re: pga_aggregate_target and a memory leak

Yes. On Solaris 5.8. -Original Message- Sent: Thursday, January 22, 2004 3:10 PM To: Multiple recipients of list ORACLE-L Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To:

Freelists about 2 hours behind

Based on a sample of one message, it looks like Freelists may be running about 2 hours behind. 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

Startup Migrate

I'm looking at the notes to apply patch 4 to Oracle 9.2.0.3. After installing the products.jar file, one of the steps is to run startup migrate then run catpatch.sql I've looked on technet as well as the documentation CD and can not find any info on startup migrate. Can someone point me in

Re: How to get unique value using AWK?

And please notice that no sorting of the input is required, unlike awk|sort|uniq Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 08:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

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

I subscribed by the send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field method and received confirmation within an hour. David Phillips Support DBA Gasper 937-445-1382 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Startup Migrate

Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle

Re: Startup Migrate

Joe, Here's brief from metalink.. for details Check this Doc ID: 252273.1 STARTUP MIGRATE was introduced in 9.2 as a mechanism to be sure that most everything that needs to be done to run an upgrade script or a patch script is done automatically. In the past, customers were expected to adjust

Re: test please ignore

oops! wrong list, eh? :) EPS - DBA (Group) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:test please ignore Test new oracle-l --

RE: Startup Migrate

Joe, You did not mention about platform. I just did migration from 8.1.7.4 to 9.2.0.4 today on Windows. That upgrade was manul. After connecting with database you have to issue command startup migrate pfile=init_SID.ora file. Please give complete/absolute path of this file. However, I have

Re: Startup Migrate

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_15a.htm#2110144 MIGRATE Use the MIGRATE clause only if you are upgrading from Oracle release 7.3.4 to the current release. This clause instructs Oracle to modify system parameters dynamically as required for the

Re: What to look for in STATSPACK report

Here's a sample chart. These are generated every morning and available via our intranet. http://www.cybcon.com/~jkstill/yapppack_chart.png Hmmm... Looks like someone is doing a lot of commits at 02:30 and 05:15. Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004

RE: Startup Migrate

Joe, I didn't do that many, but the 6 or so times that I have used it, it worked fine. From what I read, it basically does a startup restrict, IIRC. Have fun, Stephen [EMAIL PROTECTED] 01/22/04 02:29PM Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis

Re: What to look for in STATSPACK report

If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED]

RE: Re: pga_aggregate_target and a memory leak

Yes I have and still have a problem with pga memory leak When using pl/sql tables. I'm on 9i performance and tuning course at oracle Now and discussed this with the teacher. He went looking and found a bug Stating that on 9i (9.2.0.2 and further) there seems to be a limit on total pga per process

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

  1   2   >