Title: RE: Limits on PL/SQL block?
You want more cryptic answer ??
pl/sql block is limited by 64K Diana nodes. my guess is each node is a token. No one will tell you what a Diana node is, but it is used to parse pl/sql (after all it is modeled after ADA).
Only solution, instead of testing
is an art !
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 1:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Limits on PL/SQL block?
That
Diana is a b.Oooops, I forgot that English is not my native
tongue
, Rajendra [mailto:[EMAIL PROTECTED] Sent:
Friday, August 08, 2003 9:59 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Limits on PL/SQL block?
You want more cryptic answer ??
pl/sql block is limited by 64K Diana nodes. my guess is each
node is a token. No one will tell you what
: Multiple recipients of list ORACLE-LSubject: RE:
Limits on PL/SQL block?
You want more cryptic answer ??
pl/sql block is limited by 64K Diana nodes. my guess is each
node is a token. No one will tell you what a Diana node is, but it is used to
parse pl/sql (after all it is modeled after ADA
of unique statements in the block, or is it
dependant on how much redo that the block may generate?
(I know the recommended solution is to modularize and
break up the statements into multiple blocks, but I'd
like to know what are the limits to give us a better
idea of determining where to break up
-Original Message-
From: Rudy Zung [mailto:[EMAIL PROTECTED]
I'm seeing a PLS-00123 program too large error. Oracle's
documentation says that the actual limit on the size of
the block is dependant on the mix of statements in the
PL/SQL block. Does anyone know how Oracle determines
List,
Oracle 8.1.7.4
OpenVMS 7.3-1
I have to drop the current PK constraint on a partitioned table and
recreate it with additional columns. The table and partitions are quite
large 3GIG + and I was wondering if anyone has found a method if
creation the PK constraint one partition at a time.
?
The size of SGA is really the total (I say really the total) RAM used for
Oracle?
Thanks
Flávio
-Mensagem original-
De: Ron Rogers [mailto:[EMAIL PROTECTED]]
Enviada em: quarta-feira, 15 de janeiro de 2003 17:45
Para: Multiple recipients of list ORACLE-L
Assunto: RE: Limits
Flavio,
I agree
Para: Multiple recipients of list ORACLE-L
Assunto: RE: Limits
Flavio,
I agree with what Dennis said about the limiting of ram usage by
Oracle but,
The init.ora setting will establish what you would like to use for the
oracle settings and it is best if it is contigious memory also. On the
OS OpenVMS
17:45
Para: Multiple recipients of list ORACLE-L
Assunto: RE: Limits
Flavio,
I agree with what Dennis said about the limiting of ram usage by
Oracle but,
The init.ora setting will establish what you would like to use for the
oracle settings and it is best if it is contigious memory also. On the
OS
Hi all!
I need to know if is possible to limit Oracle to use only one processor, in
a machine that has 2 processors?!
And if is possible to limit RAM too? Can I limit Oracle usage of RAM memory?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Flavio - You control the amount of RAM by your init.ora settings.
Limiting processor usage is probably up to your O.S., and you didn't mention
which O.S. you are on. This is probably not a good idea. Modern operating
systems do a pretty good job of prioritizing the work, and limiting by CPU
is a
Flavio,
I agree with what Dennis said about the limiting of ram usage by
Oracle but,
The init.ora setting will establish what you would like to use for the
oracle settings and it is best if it is contigious memory also. On the
OS OpenVMS there is a OS setting that will reserve memory in a
PROTECTED]
cc:
Subject:RE: Limits
Flavio,
I agree with what Dennis said about the limiting of ram usage by
Oracle but,
The init.ora setting will establish what you would like to use for the
oracle settings and it is best if it is contigious memory also. On the
OS OpenVMS
Title: Setting profile limits?
Thanks
for the help, or should I say the lack of help :)
I took
the disdainful silence from all of you, to mean that I had not done enough
RTFM.
Anyway
a little experimentation on the test system and Rachel's 101book managed
to clear that problem.
Thanks
Title: Setting profile limits?
Dear
Denham Eva,
Can
explain more detail about the profile limit ?
Because, based on my experiance The profile limit on
oracle is wworking properly.
Everything you have to create one profile first using
command line or you can create the profile using DBA
Title: Setting profile limits?
Hello List,
I am not sure I understand the documentation correctly, please help out here.
Lets assume that I have set RESOURCE_LIMIT to TRUE.
Now I set the parameter IDLE_TIME for the profile DEFAULT.
Here is the question:
Does that mean that all the other
I'm trying to get information of the limitations of ODBC drivers,
specifically Oracle's and Microsoft's drivers for Oracle.
Things like maximum no. of records they can fetch etc. As I know very
little about ODBC (which might be reflected in the nature of my question) I
hope I'm asking a sensible
through ODBC, other than the amount of memory on the client. I've seen
apps create resultsets that were very close to the limits of their clients
without anything crashing.
Note that there's at least one major problem using ODBC and Access. Access
will always download the whole resultset
]
TOUCH.COMcc:
Sent by: Subject: RE: Limits on referential
integrity
[EMAIL PROTECTED
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential integrity
How much referential integrity should be implemented in Oracle? We are
starting a large new Java project. Our current
respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: Subject:Limits on referential integrityHow much referential integrity should be implemented in Oracle? We arestarting a large new Java project. Our current applications keep theirreferent
by: Subject: RE: Limits on
referential integrity
[EMAIL PROTECTED]
m
01/21/02 04:35
PM
Please respond
to ORACLE-L
Jared - I
PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/02 02:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Limits on referential integrity
Jared - I wasn't clear, but then again it is Monday. I have a team
column in the childtable was NOT indexed. OH, BTW the child table was well lets just say VERYlarge (2 billion rows).Dick GouletReply SeparatorSubject:Re: Limits on referential integrityAuthor: orantdba [EMAIL PROTECTED]Date: 1/22/2002 5:40 AM
PROTECTED]
01/21/02 01:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential integrity
How much referential integrity should be implemented in Oracle? We are
starting a large new Java project
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential integrity
How much referential integrity should be implemented in Oracle? We are
starting a large new Java project. Our current applications keep
Subject:Re: Limits on referential integrity
Author: orantdba [EMAIL PROTECTED]
Date: 1/22/2002 5:40 AM
--020102080806060304030001
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Hi Dennis,
Just my opinion but I tried to follow
ORACLE-L [EMAIL PROTECTED]
TOUCH.COMcc:
Sent by: Subject: RE: Limits on
referential integrity
[EMAIL PROTECTED]
m
01/21/02 04:35
of
list ORACLE-L [EMAIL PROTECTED]
TOUCH.COMcc:
Sent by: Subject: RE: Limits on
referential integrity
[EMAIL PROTECTED]
m
01/21/02
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential integrity
How much referential integrity should be implemented in Oracle? We are
starting a large new Java project. Our current applications keep
that it is less code to write as well. :)
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/02 01:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential
Title: RE: Limits on referential integrity
Jared and Dennis,
In the J2EE world I've found that developers can have a little trouble with RI because in some cases it is not the developer that is performing the DML operations - the J2EE container does this for them when using Container
:RE: Limits on referential integrity
Jared - I wasn't clear, but then again it is Monday. I have a team of
inexperienced developers starting a big, new Java application. They have a
good, experienced data model consultant helping them create the data
model.
They are eager to include
hi gurus,
Does SQL*net has a limit on concurrent simulataneous access/connection to the the
database. I simulated 600 web user accesing the oracle DB thru a PHP script which
connects to the data base,fetches the data, and disconnects. From the listener.log,
connections is about 7/8
35 matches
Mail list logo