https://blog.youkuaiyun.com/tjujacobzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/tjujacob/article/details/8269727https://blog.youkuaiyun.com/tjujacob/article/details/8269727tjujacobFri, 07 Dec 2012 15:42:26 +0800https://blog.youkuaiyun.com/tjujacob/article/details/8117881https://blog.youkuaiyun.com/tjujacob/article/details/8117881tjujacobSat, 27 Oct 2012 10:35:16 +0800https://blog.youkuaiyun.com/tjujacob/article/details/8117659https://blog.youkuaiyun.com/tjujacob/article/details/8117659tjujacobSat, 27 Oct 2012 09:38:44 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7947116https://blog.youkuaiyun.com/tjujacob/article/details/7947116tjujacobWed, 05 Sep 2012 16:27:38 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7931718https://blog.youkuaiyun.com/tjujacob/article/details/7931718tjujacobSat, 01 Sep 2012 11:09:31 +0800 create user gw identified by gw;  User created    SQL> grant create session to gw; Grant succeeded]]>https://blog.youkuaiyun.com/tjujacob/article/details/7931647https://blog.youkuaiyun.com/tjujacob/article/details/7931647tjujacobSat, 01 Sep 2012 10:45:29 +0800 create profile student limit  // student为资源文件名  FAILED_LOGIN_ATTEMPTS  3  //指定锁定用户的登录失败次数  PASSWORD_LOCK_TIME 5  //指定用户被锁定天数  PASSWORD_LIFE_TIME 30  //指定口令可用天数]]>https://blog.youkuaiyun.com/tjujacob/article/details/7931621https://blog.youkuaiyun.com/tjujacob/article/details/7931621tjujacobSat, 01 Sep 2012 10:36:39 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7931566https://blog.youkuaiyun.com/tjujacob/article/details/7931566tjujacobSat, 01 Sep 2012 10:16:31 +0800 select tablespace_name,sum(bytes)/1024/1024 from dba_data_files 2 group by tablespace_name; 2. 已经使用的表空间大小 SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_free_space]]>https://blog.youkuaiyun.com/tjujacob/article/details/7931561https://blog.youkuaiyun.com/tjujacob/article/details/7931561tjujacobSat, 01 Sep 2012 10:13:18 +0800connect system;         输入口令：         SQL>connect sys/sys as sysdba;  // 也许上面可以不要，只要这个就可以        SQL>shutdow]]>https://blog.youkuaiyun.com/tjujacob/article/details/7931554https://blog.youkuaiyun.com/tjujacob/article/details/7931554tjujacobSat, 01 Sep 2012 10:10:20 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7908797https://blog.youkuaiyun.com/tjujacob/article/details/7908797tjujacobSun, 26 Aug 2012 12:04:04 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7896204https://blog.youkuaiyun.com/tjujacob/article/details/7896204tjujacobWed, 22 Aug 2012 15:58:59 +0800 select name,log_mode from v$database;  NAME      LOG_MODE --------- ------------ HB130000  ARCHIVELOG   2、  查看数据库的instance名字和状态  SQL> s]]>https://blog.youkuaiyun.com/tjujacob/article/details/7894646https://blog.youkuaiyun.com/tjujacob/article/details/7894646tjujacobWed, 22 Aug 2012 10:40:29 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7893144https://blog.youkuaiyun.com/tjujacob/article/details/7893144tjujacobTue, 21 Aug 2012 20:51:25 +0800 select user from dual; USER ------------------------------ SYSTEM --查看当前日期、时间 SQL> select sysdate from dual; SY]]>https://blog.youkuaiyun.com/tjujacob/article/details/7893138https://blog.youkuaiyun.com/tjujacob/article/details/7893138tjujacobTue, 21 Aug 2012 20:49:28 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7893093https://blog.youkuaiyun.com/tjujacob/article/details/7893093tjujacobTue, 21 Aug 2012 20:44:49 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7893073https://blog.youkuaiyun.com/tjujacob/article/details/7893073tjujacobTue, 21 Aug 2012 20:34:34 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7893057https://blog.youkuaiyun.com/tjujacob/article/details/7893057tjujacobTue, 21 Aug 2012 20:29:26 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7892991https://blog.youkuaiyun.com/tjujacob/article/details/7892991tjujacobTue, 21 Aug 2012 20:09:27 +0800https://blog.youkuaiyun.com/tjujacob/article/details/7892985https://blog.youkuaiyun.com/tjujacob/article/details/7892985tjujacobTue, 21 Aug 2012 20:07:23 +0800