Monday, November 29, 2010

Change ias_admin password

Open file in:
%ORACLE_HOME%\sysman\j2ee\config
file name:
jazn-data.xml
find: ias_admin credentials
Make sure you put ! befor the new password.
Restart the EM:
%ORACLE_HOME%\bin\emctl stop iasconsole
%ORACLE_HOME%\bin\emctl start iasconsole

Tuesday, August 24, 2010

Find Bind Data

10g:
SELECT sql_text, NAME, value_string, datatype_string
FROM v$sql_bind_capture
JOIN v$sql
USING (hash_value)
WHERE sql_text LIKE '%select *%';

Thursday, April 29, 2010

ClientDPI

ClientDPI

Specifies the dots per inch (DPI) and overrides the DPI setting returned by the JVM, allowing you to manage varying DPI settings per platform. For example, a form developed on the Win32 platform may not display properly on the UNIX platform due to varying DPI values. The clientDPI value can be any positive integer. Oracle recommends that you use an integer between 50 and 200.