| 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...
This issue has some application specific application.... and possible
security implications (from a hacking point of view) I think.
RF
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.
-----Original Message-----
Sent: Wednesday, March 06, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
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
-----Original Message-----
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,
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
-----Original Message-----
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
-----Original Message-----
Riddle me this Batman.....
Assume Oracle9i...
assume you have a table thusly defined:
Table Name: TEST
And now a procedure defined thusly:
create or replace procedure blah_blah
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
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
--
Oracle Certified Professional
Sent: Wednesday, March 06, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
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
[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...
Oracle Certified Professional
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
col_1 number
col_2 varchar2(200)
( p_in_one test.col_2%type )
Oracle DBA Technical Lead
CSX Midtier Database Administration
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).
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:53:28 CST
 |
 |