SQL> select * from dba_profiles PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED DEFAULT SESSION…

SQL> select sequence_name, last_number from user_sequences where sequence_name = 'HOGE_SQ'; SEQUENCE_NAME LAST_NUMBER ------------------------------ ----------- HOGE_SQ 100160 SQL> drop sequence hoge_sq; SQL> create sequence hoge_sq increm…

ディレクトリ・ファイル構成 $ su - oracle $ crontab -l 30 8 * * * /usr/local/mis/bin/exec_sql/gather_stats.sh exec > /dev/null 2>&1 $ cd /usr/local/mis/bin $ ls -l total 16 -rw-rw-r-- 1 root root 772 Apr 13 08:12 common.conf -rw-rw-r-- 1 ro…