| Hash_Area_Size Unit in "show parameter" [message #564698] |
Mon, 27 August 2012 11:00  |
manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA
|
Senior Member |
|
|
Hi,
When I list the parameters with "show parameter", I get only numeric value for hash_area_size with no unit, can anyone tell me the unit for that value and conversion of it to MegaBytes.
Thanks
Manu
|
|
|
|
|
|
| Re: Hash_Area_Size Unit in "show parameter" [message #564700 is a reply to message #564699] |
Mon, 27 August 2012 11:17  |
manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA
|
Senior Member |
|
|
Thanks, can you please also tell by seeing at the below outline data, which table's hash getting stored in memory (I have 8 tables tvd, tvr, vd1, vd2, vd3, vd4, vd5, vd6)
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
ALL_ROWS
OUTLINE_LEAF(@"SEL$335DD26A")
MERGE(@"SEL$3")
OUTLINE_LEAF(@"SEL$1")
OUTLINE_LEAF(@"INS$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$1")
OUTLINE(@"INS$1")
FULL(@"INS$1" "TEMP_VENDOR"@"INS$1")
NO_ACCESS(@"SEL$1" "TVD"@"SEL$1")
FULL(@"SEL$1" "VD1"@"SEL$1")
FULL(@"SEL$1" "VD2"@"SEL$1")
INDEX(@"SEL$1" "VD3"@"SEL$1" ("VENDOR_DATA"."STUDY_SEQ_NO" "VENDOR_DATA"."CONTROL_COLUMN_SEQ_NO" "VENDOR_DATA"."VENDOR_RECORD_SEQ_NO"
"VENDOR_DATA"."ORIGINAL_VALUE"))
INDEX(@"SEL$1" "VD4"@"SEL$1" ("VENDOR_DATA"."STUDY_SEQ_NO" "VENDOR_DATA"."CONTROL_COLUMN_SEQ_NO" "VENDOR_DATA"."VENDOR_RECORD_SEQ_NO"
"VENDOR_DATA"."ORIGINAL_VALUE"))
INDEX(@"SEL$1" "VD5"@"SEL$1" ("VENDOR_DATA"."STUDY_SEQ_NO" "VENDOR_DATA"."CONTROL_COLUMN_SEQ_NO" "VENDOR_DATA"."VENDOR_RECORD_SEQ_NO"
"VENDOR_DATA"."ORIGINAL_VALUE"))
INDEX(@"SEL$1" "VD6"@"SEL$1" ("VENDOR_DATA"."STUDY_SEQ_NO" "VENDOR_DATA"."CONTROL_COLUMN_SEQ_NO" "VENDOR_DATA"."VENDOR_RECORD_SEQ_NO"
"VENDOR_DATA"."ORIGINAL_VALUE"))
INDEX_RS_ASC(@"SEL$1" "TVR"@"SEL$1" ("TEMP_VENDOR_RECORD"."ROWNUMBER"))
LEADING(@"SEL$1" "TVD"@"SEL$1" "VD1"@"SEL$1" "VD2"@"SEL$1" "VD3"@"SEL$1" "VD4"@"SEL$1" "VD5"@"SEL$1" "VD6"@"SEL$1" "TVR"@"SEL$1")
USE_HASH(@"SEL$1" "VD1"@"SEL$1")
USE_HASH(@"SEL$1" "VD2"@"SEL$1")
USE_NL(@"SEL$1" "VD3"@"SEL$1")
USE_NL(@"SEL$1" "VD4"@"SEL$1")
USE_NL(@"SEL$1" "VD5"@"SEL$1")
USE_NL(@"SEL$1" "VD6"@"SEL$1")
USE_NL(@"SEL$1" "TVR"@"SEL$1")
SWAP_JOIN_INPUTS(@"SEL$1" "VD2"@"SEL$1")
FULL(@"SEL$335DD26A" "VDT"@"SEL$3")
END_OUTLINE_DATA
*/
Or should I look into it through execution plan or something else.
Thanks,
Manu
|
|
|
|
| Re: Hash_Area_Size Unit in "show parameter" [message #564702 is a reply to message #564700] |
Mon, 27 August 2012 11:55 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I don't understand why you are fixated on anything related to hash_area_size?
I don't have any idea what problem you are trying to solve.
What is OS name & version?
Do you understand that V10.2 Oracle is not longer supported now?
Consider submitting Service Request to Oracle for this issue.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
