![](https://static.wixstatic.com/media/11062b_fac51a38acf24ea2aa030216e01a0ea3f000.jpg/v1/fill/w_288,h_162,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/11062b_fac51a38acf24ea2aa030216e01a0ea3f000.jpg)
ALTER SESSION
{ ADVISE { COMMIT | ROLLBACK | NOTHING }
| CLOSE DATABASE LINK dblink
| { ENABLE | DISABLE } COMMIT IN PROCEDURE
| { ENABLE | DISABLE } GUARD
| { ENABLE | DISABLE | FORCE } PARALLEL
{ DML | DDL | QUERY } [ PARALLEL integer ]
| { ENABLE RESUMABLE [ TIMEOUT integer ] [ NAME string ]
| DISABLE RESUMABLE
}
| SYNC WITH PRIMARY
| alter_session_set_clause
} ;
alter_session_set_clause ::=
SET { { parameter_name = parameter_value }...
| EDITION = edition_name
}
example
ALTER SESSION ENABLE PARALLEL DML;
ALTER SESSION
ADVISE COMMIT;
ALTER SESSION
ADVISE ROLLBACK;
ALTER SESSION
CLOSE DATABASE LINK local;
ALTER SESSION
SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS';
ALTER SESSION
SET NLS_DATE_LANGUAGE = French;
ALTER SESSION
SET NLS_ISO_CURRENCY = America;
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.' ;
ALTER SESSION
SET SQL_TRACE = TRUE;
ALTER SESSION SET QUERY_REWRITE_ENABLED = TRUE;