web app not saving "all" records suddenly

[George L]

We have been working on this for a while now.
We suspect something with the Oracle database (patch, upgrade, security)
Our users reported one category of 2 records are not saving. No errors or messages are being reported and the web based application hasnt changed in years.

I'm going to try Log Miner, are they any other tools to monitor the users with along with the SQL below


Link has been a big help
BUT I'd like to hear others experiences and suggestions

Thanks inadvance
George
----------------------------------------------------------------------------


select sql_text from v$sqlarea where users_executing > 0;

SELECT A.SQL_ID,
A.FIRST_LOAD_TIME,
A.SQL_TEXT,
A.SQL_FULLTEXT
FROM v$sqlarea A, v$sqltext B
WHERE A.PARSING_SCHEMA_NAME = 'TESTUSER' --YOUR USERNAME
AND A.SQL_ID = B.SQL_ID
AND A.HASH_VALUE = B.HASH_VALUE
ORDER BY A.FIRST_LOAD_TIME DESC



SELECT sess.sid,
sess.username,
sqla.optimizer_mode,
sqla.hash_value,
sqla.address,
sqla.cpu_time,
sqla.elapsed_time,
sqla.sql_text
FROM v$sqlarea sqla, v$session sess
WHERE sess.sql_hash_value = sqla.hash_value
AND sess.sql_address = sqla.address

 

[Andrzejek]

When you say: "records are not saving", I would assume you either INSERT a new record or UPDATE an existing record. In either case I would 'grab' (write into a text file?) an Insert / Update statements and then investigate them.

Unless I am missing something here...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[George L]

Andy thats a good idea also - we will try that outside of the application

 

[carp]

Does the web app automatically commit changes or is there a "save" step that the user needs to execute?
The app hasn't changed - are these new users who might be leaving the page without saving?
I'm sure you've watched them as they did this to show you what's happening; I'm just checking assumptions, since if the app hasn't changed in years, and Oracle certainly commits like it always has, this is a real puzzler.