Oracle SQLs

SELECT SYS_CONTEXT ('USERENV', 'IP_ADDRESS') FROM DUAL;


declare
/* */
begin
dbms_auto_task_admin.DISABLE('auto optimizer stats collection', null, null);
end;
/


begin
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'auto space advisor', operation => NULL, window_name => NULL);
DBMS_AUTO_TASK_ADMIN.disable( client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);
end;
/


call dbms_stats.gather_database_stats_job_proc ( )

select * from DBA_AUTOTASK_OPERATION


select sysdate from dual
union all
select current_date from dual
union all
select systimestamp from dual;


select * from v$timezone_names;

ALTER DATABASE SET TIME_ZONE = '+8:00';

select * from database_properties where property_name='DBTIMEZONE';
select * from database_compatible_level;
select * from database_export_objects;
select database_name from dual;
select dbtimezone from dual;