ORA-27104: system-defined limits for shared memory was misconfigured
I moved a VMware's VM to an new machine, and the new machine have limited physical memory , So I decreased the VM memory. and then I found that at…
3DEXPERIENCE Platform Regular Maintenance
It is very important for 3DEXPERIENCE Platform to have maintenance activity executed regularly , The platform did not really delete data. so we need "tidy" action to really delete data.…
How to know oracle table size including BLOB Columns
Just learned from today's customer meeting, so recording this. Our system have a table named TICKETGRANTINGTICKET which is used to store CAS authentication information. And it has 3 column defined…
Oracle password expiration issue
Suddenly 3DE encounter an issue and can not login. check 3dpassport tomee catalina.out , and we found the error as below. java.sql.SQLException: ORA-28001: the password has expired This is because…
Oracle Find NVARCHAR Field
To find NVARCHAR Field , run below SQL select table_name,column_name,data_type from user_tab_columns where data_type like 'NVARCHAR%'; select owner, table_name,column_name,data_type from dba_tab_columns where data_type like 'NVARCHAR%';