Dynamic: ALTER SESSION Range of values true | false HASH_JOIN_ENABLED specifies whether the optimizer should consider using a hash join as a join method. If set to false, then hashing is not available as a join method. If set to true, then the optimizer compares the cost of a hash...
alter_session::= Description of the illustration alter_session.eps alter_session_set_clause::= Description of the illustration alter_session_set_clause.eps Semantics ADVISE Clause TheADVISEclause sends advice to a remote database to force a distributed transaction. The advice appears in theADVICEcolu...
When using theexchange_partition_subpartclause, if the table data being exchanged contains an identity column and you are not the owner of both tables involved in the exchange, then you must have theALTERANYSEQUENCEsystem privilege. You cannot partition a non-partitioned table that has an object...