OraFAQ Forum: Server Administration » Hash_Area

Home » RDBMS Server » Server Administration » Hash_Area_Size Unit in "show parameter" (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Hash_Area_Size Unit in "show parameter" [message #564699 is a reply to message #564698]

Mon, 27 August 2012 11:07

BlackSwan
Messages: 26766
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/

Report message to a moderator

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
-------------

Code: [Select all] [Show/ hide]

  /*+
      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

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	SPM: SMB space usage (1369833472) exceeds 10.000000% of SYSAUX size (4194304000)
Next Topic:	cpu usage by a db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 10:19:13 CDT 2025