摘要:
reference: https://blog.csdn.net/dandandeshangni/article/details/485442211. 在运行/调试 配置对话框的Startup/Connection面板中,勾选Pass environment variables.并添加一个envir 阅读全文
摘要:
C:\Users\Jilil>mysql -u root -pEnter password: *************ERROR 1040 (HY000): Too many connectionsC:\Users\Jilil>C:\Users\Jilil>java.sql.SQLNonTrans 阅读全文
摘要:
reference: https://webgeest.blogspot.com/2015/07/ora-39083-ora-02304-on-impdp-datapump.html 解决方法: 添加选项 TRANSFORM=ODI:N:TYPE or TRANSFORM=ODI:N 我之前还辛苦的 阅读全文
摘要:
oracle 在杀会话时,会出现杀不掉的情况。 原因是在回滚大事物 解决方法: alter system disconnect session 'sid, serial#' immediate; or alter system disconnect session 'sid, serial#' po 阅读全文
摘要:
reference: https://www.akadia.com/services/ora_optimize_undo.html#:~:text=Turning%20on%20automatic%20undo%20management,tablespace%20and%20set%20UNDO_M 阅读全文
摘要:
su - oracle sqlplus /nolog conn / as sysdba select * from v$flash_recovery_area_usage; select sum(percent_space_used)*3/100 from v$flash_recovery_area 阅读全文
摘要:
Reference: https://cloudlinux.zendesk.com/hc/en-us/articles/115004075294-Fix-rpmdb-Thread-died-in-Berkeley-DB-library[installadmin@dnafexpapp003 ~]$ y 阅读全文
摘要:
reference:https://www.cnblogs.com/XQiu/p/5212787.html--以下几个为相关表SELECT * FROM v$lock;SELECT * FROM v$sqlarea;SELECT * FROM v$session;SELECT * FROM v$pr 阅读全文
摘要:
Reference: https://stackoverflow.com/questions/35037288/incorrect-decimal-integer-value-mysql Error Code: 1366. Incorrect DECIMAL value: '0' for colum 阅读全文
摘要:
Reference:https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench Error Code: 1175. You are using safe upd 阅读全文