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;