One of my first exposure to computers was as "repairman" on a Univac computer which had a whopping 32K words of 30 bits in each word containing only ferrite core memory. The program was loaded from a 7-bit (2 octal digits, plus a parity bit) magnetic tape drive. In such a system, every bit mattered.
"Mercadante, Thomas F" wrote: > > 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: [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: 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 You can lead some people to knowledge, but you can't make them think! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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).
