This is NOT an OCP question, and there is a HUGE bit of relevance, and it applies to something that we discovered in some legacy code here, that applies directly to this question.
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 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: [EMAIL PROTECTED] -----Original Message----- [mailto:[EMAIL PROTECTED]] 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: a. 200 bytes b. 2000 bytes c. 4000 bytes d. It will be defined based on the size of the data actually being passed into the parameter of the PL/SQL procedure e. None of the above. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).