Home » RDBMS Server » Server Administration » Hash_Area_Size Unit in "show parameter" (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
Hash_Area_Size Unit in "show parameter" [message #564698] Mon, 27 August 2012 11:00 Go to next message
manubatham20
Messages: 558
Registered: September 2010
Location: Minneapolis, MN, 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 #564699 is a reply to message #564698] Mon, 27 August 2012 11:07 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
>can anyone tell me the unit for that value
bytes

>and conversion of it to MegaBytes.
VALUE/(104*1024) = Megabtyes

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Hash_Area_Size Unit in "show parameter" [message #564700 is a reply to message #564699] Mon, 27 August 2012 11:17 Go to previous messageGo to next message
manubatham20
Messages: 558
Registered: September 2010
Location: Minneapolis, MN, 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 Go to previous message
BlackSwan
Messages: 26730
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.
Previous Topic: SPM: SMB space usage (1369833472) exceeds 10.000000% of SYSAUX size (4194304000)
Next Topic: cpu usage by a db
Goto Forum:
  


Current Time: Tue Aug 04 11:29:27 CDT 2020