| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Riddle me this Oracle riddle...
Just curious - it's not like I'm trying to be mean or anything. I was just
wondering if this is an issue with certain types of applications. I
remember I had to worry about memory usage a *long* time ago when mainframe
systems only had limited core memory (anybody remember core memory?), and
application design and memory reuse was a critical part of the whole
process.
But within Oracle, I have not seen the need to worry about these types of things.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, March 06, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
I think it's an OCP - type question.
They ask questions like this, when in reality people just buy servers, and if they need more space, they buy more disk...
.. .providing there aren't obvious problems with database design.
Does anyone really spend days figuring out the exact size of rows etc. before tables are created?
It seems to me people would just "try" the new thing on a development machine, look at space usage, then declare how much disk and CPU they need for the production system.
There is a point of diminishing returns, where more time is lost than the performance / storage gain would justify.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
-----Original Message-----
[mailto:Thomas.Mercadante_at_Labor.State.Ny.Us]
Sent: Wednesday, March 06, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Riddle me this Oracle riddle...
Anybody wish to answer the following:
Why does this matter? Or is this an OCP exam question?
Personally, I fail to see the relevance.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Riddle me this Batman.....
Assume Oracle9i...
assume you have a table thusly defined:
Table Name: TEST
col_1 number
col_2 varchar2(200)
And now a procedure defined thusly:
create or replace procedure blah_blah
( p_in_one test.col_2%type )
Now, here is the question, how much memory will p_in_one have allocated to it within PL/SQL?? Is the answer:
I'm currious what your answers will be... ;-)
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). Received on Wed Mar 06 2002 - 09:08:19 CST
 |
 |