- 博客(3)
- 资源 (6)
- 收藏
- 关注
转载 After new files are added to primary, rman fails at Standby with ORA-20079: Full Resync From Primary
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.APPLIES TO:Oracle Database - Enterpris...
2018-02-27 10:42:03 523
转载 oracle 限制IP访问
出于数据安全考虑,对Oracle数据库的IP做一些限制,只有固定的IP才能访问。修改$JAVA_HOME/NETWORK/ADMIN/sqlnet.ora文件增加以下内容(红色表示注释):#开启ip限制功能tcp.validnode_checking=yes#允许访问数据库的IP地址列表,多个IP地址使用逗号分开tcp.invited_nodes=(192.168.1.110)#禁止访问数据库的I...
2018-02-08 11:09:07 1729
原创 【sql】mysql查看表大小
#--------mysql查看表大小select TABLE_NAME, concat(truncate(data_length / 1024 / 1024, 2), ' MB') as data_size, concat(truncate(index_length / 1024 / 1024, 2), ' MB') as index_size from informa...
2018-02-08 11:06:37 768
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人