Maybe it's me, but your question is confusing. You get a different SID? Were you trying to connect to a different SID?

SQL_HASH_VALUE is the hashed value of the SQL statement (a number or value, so to speak). You can share SQL statements with the use of bind variables, and keep the statement in memory so the query/performance is faster. If someone issues a query that matches the hash value of the same statement used previously by someone else, it cuts down on the work Oracle has to do.