oracle session parameters

1GRANT SELECT_CATALOG_ROLE TO my_user;	-- to read V$PARAMETER 
2
3SELECT NAME, VALUE, DESCRIPTION FROM V$PARAMETER 
4--WHERE upper(NAME) = 'NLS_DATE_FORMAT' 
5ORDER BY NAME;
6
7ALTER SESSION SET 
8	NLS_LANGUAGE='AMERICAN' 
9    NLS_TERRITORY='AMERICA' 
10    NLS_CALENDAR='GREGORIAN'
11    NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';