RE: Re: pga_aggregate_target and a memory leak

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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

pl/sql tables in pga and ora-4030 was pga_aggregate_target and a

an array I don't know why you don't get the same results but this is definitely weird and looks familiar with other bugs filed Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services

RE: Re: pga_aggregate_target and a memory leak

containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network

RE: pga_aggregate_target and a memory leak

van Sluisdam 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

RE: pga workarea and ora-04030

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: pga workarea and ora-04030

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

pga workarea and ora-04030

Hi, I have posted a problem before which I can only solve with a workaround but because I'm not getting satisdactory answers from Oracle I'm trying alternatives. - problem is a batch pl/sql package which ends with ora-4030 - batch runs fine on oracle 7.3.4, we migrated to oracle

RE: increase in amount of redo comparing oracle 7 and 9

(filled)columns in 9i compared to 7.3. Redo structure has changed between these versions, undo most likely as well. There are several other issues which might affect redo size such is supplemental logging, etc. Tanel. - Original Message - From: Jeroen van

increase in amount of redo comparing oracle 7 and 9

I have recently migrated our oracle 7.3.4 environment to oracle 9.2.0.4 I noticed some batches eating up all my archive space. I have a 5 Gb filesystem solely for archiving available where I used to have 4Gb available for oracle 7 which was quite enough for years. A small test:

ora-4030 pga memory allocation running wild

Hi, I have an ora-4030 problem related to pga memory allocation, at least I have concluded sofar This program is batch written in pl/sql and after an hour or so it crashes. PGA allocated is slowly exceeding 2Gb and when I monitor with top I see the process size rising uptill 2 Gb

RE: ora-4030 pga memory allocation running wild

workarea_size_policy=manual; Jared On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote: Hi, I have an ora-4030 problem related to pga memory allocation, at least I have concluded sofar This program is batch written in pl/sql and after an hour or so it crashes. PGA allocated is slowly exceeding

alter tablespace offline

Hi, This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered a strange problem in issueing alter tablespace name offline. I had to reorganize tablespace and when testing this I did this manually and no problem at all. I put the statements in a

RE: alter tablespace offline

: Multiple recipients of list ORACLE-L Onderwerp: RE: alter tablespace offline Hi Jeroen, What is problem? Error msg or something? Sinardy -Original Message- From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 18:12 To: Multiple recipients

RE: alter tablespace offline

. in addition to the alter tablespace offline (and no, I've NEVER had to do this with the normal clause) you need to do an alter database rename file 'old file name including path' to 'new file name including path' before you do the mount --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi Sinardy

RE: analyze problems

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

analyze problems

Hi, I'm in the middle of migrating oracle 7.3.4 to oracle 9.2.0.4 In process of testing we encounter a big query that is now taking full table scans Where it used to take indexes. When we compare plans this is evidently so, Optimizer_mode is on both choose, tables and indexes are

dropping materialized view

Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign

RE: dropping materialized view

table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR

RE: dropping materialized view

constraint (when you want to drop the parent table) will not help. This should help: Alter table DEBTOR_CLAIM_COMPONENTS drop constraint FK_DCC_MEDIUMS. After this you should be able to drop MV. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday

ora-01008 oci migration

Hi, We are migrating from oracle 7.3.4.3 to oracle 9.2.0.4 without changing clientcode which is built with oci 7 for oracle 7 db. Code gives this error while printing all bind variables with values such that I can only conclude all variables are bound. Binding doesn't produce an

RE: migration sequence oci problem

-Oorspronkelijk bericht- Van: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 27 november 2003 19:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: migration sequence oci problem We could narrow it down to the value of the sequence exceeding 16777216 (2 to the power of 24

trace sequence values

Hi, I need urgently to trace an app which uses sequences with OCI to determine what is going wrong. When I use an 10046 event I do not get values of sequence returned when issueing sequence.nextval. Any ideas about how to trace this are appreciated. Regards, Jeroen Details:

RE: migration sequence oci problem

but I'm desperate for any advice because I don't have any developers left with oci-knowledge Tnx, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: Wednesday, November 26, 2003 16:40 Aan: '[EMAIL PROTECTED]' Onderwerp: migration sequence oci problem Hi, We're

bcv copy - duplicate rows unique prim key

Hi, When I issue an alter table move statement and afterwards an alter index rebuild for the primary key on this table I got an error duplicate rows found. This primary key is unique. The database has just been migrated for test purposes. In production we are still on oracle 7.3.4.

migration sequence oci problem

Hi, We're testing an oracle 9.2.0.4 database with an oracle 7 client. This is a C++ client, using OCI to go to oracle. We see strange behaviour when using a sequence which worked nicely before. The sequence is not incremented when issueing select res_id.nextval from dual When

RE: ora-600 / ora-00604 during migrate

Problem solved thanks to ots Event 1399 solved it, necessary during migrate Regards, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: Thursday, November 20, 2003 21:46 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: ora-600 / ora-00604 during migrate

ora-600 / ora-00604 during migrate

Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11

RE: ora-600 / ora-00604 during migrate

-Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Dennnis, Priority 2. I have tried export but after 3 days of experimenting And not getting

which oracle9i version is stable

Hi, I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because we want to be able to connect with this version to oracle 7.3.4 db. We started with 9.2 but found a known bug which prevented to connect to oracle7.3.4. Any advice on which version of 9i to go to will be

RE: which oracle9i version is stable

I forgot to mention we will be running hp-ux11.11 64 bit, plan to run oracle also on 64 bit Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Verzonden: Thursday, October 30, 2003 12:09 Aan: Multiple recipients of list ORACLE-L Onderwerp

RE: comparison HP-san vs netapp

for everything can become one heck of a bottleneck. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Subject: comparison HP-san vs

comparison HP-san vs netapp

Hi, I need urgently a qualitative comparison between an SAN (based on eva3000) and netapp F825 environment concerning oracle. We have been tallking to suppliers now for weeks and suddenly a manager comes up with a netapps alternative and we have a deadline to decide already weeks

SAN-Eva3000 experiences

Hi, We're in the middle of buying a storage solution that will probably be an eva3000. Because I'm new with these kind of storages and I will get implementation advice from consultants I would like to have some background with experiences in implementing an oracle database on an

RE: connection through oci between 7.3.4 and 9.0.1 fails

Problem is solved. Somehow it seems now to be important to use dbname case-sensitive in a connectstring. Are there any more flaws, do's and don't known when migrating to oracle 9 concerning sqlnet? Tia, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam

connection through oci between 7.3.4 and 9.0.1 fails

Hi, I'm trying to use an application with oci built on oracle 7.3.4.3 to connect to a different database on 9.0.1.0 (32 bits) I'm not able to login. I can login from the same old environment through sqlplus. Any idea what might be wrong? Details: old env hp-ux10.20 oracle 7.3.4.3 new

7.3.4 on hp-ux11 upgrade problem

Hi, We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to oracle 9.0.1.0 on a different hp-ux 11.11 box. In order to be able to migrate we installed 7.3.4 on this machine, copied datafiles and config.ora, init.ora and listener.ora We only run the old listener (this starts

RE: 7.3.4 on hp-ux11 upgrade problem

-Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: Wednesday, August 27, 2003 14:43 Aan: '[EMAIL PROTECTED]' Onderwerp: 7.3.4 on hp-ux11 upgrade problem Hi, We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to oracle 9.0.1.0 on a different hp-ux 11.11 box. In order to be able

RE: 7.3.4 on hp-ux11 upgrade problem

] om 08/27/2003 10:14 AM Please respond to ORACLE-L I don't believe that HP-UX 10.2 and 11.0 are binary compatable, try export/import. Jeroen van Sluisdam

RE: 7.3.4 on hp-ux11 upgrade problem

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

upgrade 7.3.4 to 9.0.10

Hi, We have the task of finally upgrading our 7.3.4 db We have a new test-bix with HP-UX 11.11 and our old development-bix is on HP-UX 10.20 I have found several docs stating that in order to migrate at same time also upgrading OS at different machines we need to install 7.3.4 on

oci demos oracle 9.0.1.0 core

FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

backwards export

Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we

RE: WARNING: Re: [suse-oracle] AIO trouble

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL Problem - Merging Result sets

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: utl_file.put error

these bugreports in metalink, anybody familiar with these problems? Details: Oracle 7.3.4 HP-UX 10.20 Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

overloading fopen max linesize 7.3.4

Hi, Unfortunately I'm stil stuck to Oracle 7.3.4 and there is a limit of 1023 characters per line. I know it is raised in 8.05 as mentioned on metalink. Are there any trics in 7.3.4 available? Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van

utl_file.put error

these bugreports in metalink, anybody familiar with these problems? Details: Oracle 7.3.4 HP-UX 10.20 Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: MTS config

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

max open files

. Any idea, maybe this OS-dependent ? Details: 7.3.4 HP-UX 10.20 Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

virus

-Worm.Klez.h We adviseren je om contact op te nemen met de afzender van dit bericht. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Oracle Internals course

://www.orafaq.com -- Author: Jeroen van Sluisdam 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

RE: what is purify

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City

RE: altering next extent solved

The batchjob was doing a truncate, Thx Iain ! Jeroen -Oorspronkelijk bericht- Van: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 15:16 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: altering next extent I believe that if you set the next extent then all

altering next extent

on the audit on this table and did find only records with 'session rec' in action_name What can cause the previous alter to be changed back? Tia, Jeroen Details: oracle 7.3.4 HP-UX 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL

RE: altering next extent

on 256K. Tia, Jeroen -Oorspronkelijk bericht- Van: Rahul [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 13:18 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: altering next extent LMT ??? -- From: Jeroen van Sluisdam[SMTP:[EMAIL PROTECTED]] Reply

RE: Begin backup fails sporadically

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Multithreaded server question

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City

Possible sqlnet problem please help

and tnsnames.ora Only following parameters in listener.ora on database server STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED

RE: Error when running 8.1.7 and 9i

FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Why is this code not working?

This was returned by the mailer-daemon because of a locking problem ?? -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: dinsdag 11 december 2001 17:08 Aan: '[EMAIL PROTECTED]' Onderwerp: RE: Why is this code not working? You need an or-clause because one row has either

urgent help needed conversion

ux 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: how to find files that are generated on a particular date

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Errormessage

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

help execution plan changes when using a dblink

, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

help execution plan changes when using a dblink

-Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden:woensdag 29 augustus 2001 17:02 Aan: '[EMAIL PROTECTED]' Onderwerp:help execution plan changes when using a dblink Hi, We face the strange problem that an executionplan is changed recently without any

RE: !! *Very* important Oracle-L message !!

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City

OT: TUSC and Kevin Loney

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Unique Index or Constraint??

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists