Changing Parameters At Session Level

Onur ARDAHANLI

10 months ago

In today’s article, we will be explaining how to Changing Parameters at Session Level.

Only the connected session will change.

ALTER SESSION SET command is used.

The value of the parameter we change before the change;

SQL> ALTER SESSION SET max_dump_file_size=100;

1	SQL> ALTER SESSION SET max_dump_file_size=100;

The status of the parameter after the change;

As seen above, we changed the session-based parameter and the change was observed.

But when we look at whether the parameter has changed on an instance basis;