Sometimes you may need to know what SQL a program is executing in Oracle. This SQL query can be used. SELECT s.sid,s.serial#,s.username,s.machine,s.program,s.status,s.sql_id,q.sql_textFROM v$session sJOIN v$sql q ON s.sql_id = q.sql_idWHERE…
When starting an Oracle database, you may encounter the following error: ORA-27104: system-defined limits for shared memory was misconfigured This error usually indicates that the operating system's shared memory settings…
It is very important for 3DEXPERIENCE Platform to have maintenance activities executed regularly , The platform did not really delete data. so we need "tidy" action to really delete data.…
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…
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…
sometimes during database migration, we need To know if our database have NVARCHAR Field , below SQL can check Oracle database if it have NVARCHAR field. select table_name,column_name,data_type from user_tab_columns…