摘要:
OEM发出好多告警,Number of failed login attempts exceeds threshold value.profile当前配置10次失败就会锁定user查看下,dba_users,所有username的状态都正常的.用以下语句,select USERNAME, ACTIO... 阅读全文
摘要:
在为表加注释,遇到有些注释包含'&'但又不想写eacape,在sqlplus下,set define off 即可将&输入到数据库中。 阅读全文
摘要:
注意last_call_et的值,select s.status,s.last_call_et,s.* from v$session s where username='DDD';在本例中,开了个sqlplus,然后对一张大表进行select * from big_table;可以开到一直有结果显示... 阅读全文
摘要:
安装之前要保证已装Microsoft Visual C++ Redistributable32 bit: http://www.microsoft.com/download/en/details.aspx?id=555564 bit: http://www.microsoft.com/downloa... 阅读全文
摘要:
excel连接列名生成oracle注释notes: A2为列名,B2为注释="comment on column ColAgreementHeader."&A2&" is q'{"&B2&"}';"效果如下: comment on column table1.Id is q'{PK}';commen... 阅读全文