- 博客(6)
- 收藏
- 关注
原创 Hive提示警告SSL
Hive启动后报警告:$ ./hivewhich: no hbase in (/usr/java/jdk1.8.0_171/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/sysopt/.local/bin:/home/sysopt/bin:/home/hadoop/hadoop-2.8.1/bin:/home/ha...
2018-06-30 11:19:06 1008
转载 How does AUTO_SAMPLE_SIZE work in Oracle Database 11g
转自:https://blogs.oracle.com/optimizer/how-does-autosamplesize-work-in-oracle-database-11gNote that if you're interested in learning about Oracle Database 12c, there's an updated version of this post h...
2018-06-28 17:43:59 580
转载 理解 alter table nologging
nologging使用,同时满足一下三个条件才不会真正产生日志1.表空间:alter tablespace test3 nologging;2.表:alter table a nologging;3.插入:insert/*+append*/into test3 sleect * from t3;sql%rowcount用于记录修改的条数,就如你在sqlplus下执行delete from之后提示已...
2018-06-26 23:25:25 5429
转载 Oracle 锁Lock
https://blog.csdn.net/qq_27317147/article/details/52048770select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo...
2018-06-25 15:11:23 263
转载 Oracle密码错误次数过多账号锁定的问题
一般数据库默认是10次尝试失败后锁住用户 1、查看FAILED_LOGIN_ATTEMPTS的值select * from dba_profiles2、修改为30次alter profile default limit FAILED_LOGIN_ATTEMPTS 30;3、修改为无限次(为安全起见,不建议使用)alter profile default limit FAILED_LOGIN_ATT...
2018-06-25 15:01:07 2606
原创 查询该表被哪些表当外键
select a.table_name,a.constraint_name,b.table_name,b.constraint_namefrom dba_constraints a,dba_constraints bwhere a.r_constraint_name=b.constraint_nameand b.table_name='XXX'
2018-06-25 13:21:27 1119
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人