Re: number(p,s)
Selam, Number represantation is not a byte-to-byte represantation like characters'. If it was so, 1234567 occupies 7 bytes. in fact, it's less (I guess). you can check it by dump function in sql*plus. Oracle uses mantisa/exponent notation to store numeric data like OS does. this notation not only saves space, but also holds huge numeric data from negative values to positive values. there should be a note in metalink which explains details with samples. hope this helps... --- "Bunyamin K.Karadeniz" [EMAIL PROTECTED] wrote: number(p,s) datatype conflicts my mind. every book tells that -84 s 127 How can s be minus. Negative scale?? = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment UNAL 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).
Re: TKPROF
hello, if EXPLAIN option is used, tkprof generates output against current database statistics not against statistics in raw file. this makes followings wrong: - explain plan may be different than explain plan in raw file since statistics may have changed after raw file is generated. - because of hard parse, execution plans of same SQLs may be different. if you use aggregate=yes(which is default), tkprof will show one execution plan. I did not test for returned row. but, if explain plan changes, returned row should be changed. If there is "Row Source Operation" in your output, use this one instead of explain plan section. "Row Source Operation" shows exact execution plan in raw file. regards... --- "Sam P. Roberts (ZADCO ITIS)" [EMAIL PROTECTED] wrote: This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.34 1.73 83 385 0 7 --- -- -- -- -- -- -- total4 0.36 1.75 83 385 0 7 Misses in library cache during parse: 1 Optimizer goal: RULE Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 36 (GL) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 0 NESTED LOOPS 0INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE) 0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_BALANCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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). = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment UNAL 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).
Re: Sun- SGA size and sgabeg question?
Hi, in theory, 32-bit word size can address max. 4Gb memory space. I guess total 1.7GB restriction is for HP-UX (32-bit). As I know, you can have an SGA of 1 Gb max. and 1.7Gb total on HP-UX (32-bit). Solaris and HP memory managements are different. if you dont change sgabeg, maximum SGA size in solaris is 1.73Gb. if you change sgabeg, it's up to 3.7Gb. New additional memory is taken from where PGAs reside. Since sgabeg is relative address in each segment, you can have many sgabegs for many segments. I guess, you may exceed 3.7Gb restriction for solaris in total. regards... --- [EMAIL PROTECTED] wrote: Hi We have 6GB of physical memory in one of the SUN boxes (32 bit OS). There are around 24 databases and using up around 3.7GB of total memory. If I understand correctly, cumulative size of thes SGAs can not exceed 1.7GB without adjusting the sgabeg address. We have 4 different versions of the software and checked the sgabeg address in each one of them and they are set at default (0x8000). Hence the cumulative size can not be more than 1.7GB. How are we able to bring up all these database ? What am I missing here ? Thanks Riyaj Shamsudeen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment UNAL 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).