Change Global database timeout duration in Oracle SQL with query-CodePudding

I want to change my global timeout duration for all database like global timeout.
How can I do that with query in OracleSQL.

Example for MySQL:

SELECT @@LOCK_TIMEOUT
SET LOCK_TIMEOUT 10000;
SELECT @@LOCK_TIMEOUT

CodePudding user response：

I believe this is what you wanted:

By default, the ddl_lock_timeout parameter is set to zero seconds to wait, making it equivalent to the earlier NOWAIT behavior. But this can easily be changed to make DDL run in WAIT mode by setting ddl_lock_timeout to a non-zero value:

alter session set ddl_lock_timeout= 60

Now, DDL will wait 60 seconds before aborting with a ORA-00054 error.