Home » RDBMS Server » Performance Tuning » oracle9i (Precaution for defining VARCHAR2(4000))
oracle9i [message #334946] Fri, 18 July 2008 15:26 Go to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello,

Why don't we declare max length(VARCHAR2(4000)) length for all string columns? Even if we store Hello, oracle would not allocate 4000. It allocate what we enter in the columns.

Tom has answered for this question.

http://tkyte.blogspot.com/2006/11/see-you-just-cannot-make-this-stuff-up.html

After reading the above link, i have one qestion on his below Tom's statement.


[B]Say the code prepares a query that selects ten columns
that are VARCHAR2. The developers, for performance, would like
to array fetch (very important). They would like to array fetch
say 100 rows (very typical). So, you have 4,000 * 10 * 100 
= almost 4MB of RAM the developers must allocate! Now, consider
if that were ten VARCHAR2(80) fields (it’s probably much 
smaller than that). That’s about 78KB. Ask the data modeler 
how much RAM he is willing to kick in for this system [/B]


He is saying array fetch. Is this operating system specific or db specifc? Can we chane the array fetch? If so how do we change the array fetch? Any answer appreciated..

Re: oracle9i [message #334948 is a reply to message #334946] Fri, 18 July 2008 15:43 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Is this operating system specific or db specifc?
Yes

>Can we chane the array fetch?
WE? I can. Can you?

>If so how do we change the array fetch?
What do you get when doing a keyword search on http://asktom.oracle.com for "array fetch"?
Re: oracle9i [message #335034 is a reply to message #334946] Sat, 19 July 2008 15:21 Go to previous messageGo to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
My question is How can i change the array fetch? Thanks
Re: oracle9i [message #335043 is a reply to message #335034] Sun, 20 July 2008 00:55 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is: it depends on the tools or language you use.

Regards
Michel
Previous Topic: maximum number of process exceeded
Next Topic: How to enable Bitmap Index
Goto Forum:
  


Current Time: Tue Dec 06 14:29:07 CST 2016

Total time taken to generate the page: 0.26198 seconds