How to check your DB account status? Is it locked? Here is the SQL to be used:
SELECT USERNAME, PROFILE, ACCOUNT_STATUS, password FROM DBA_USERS
Wednesday, September 27, 2006
Tuesday, September 19, 2006
Oracle Lite default limit on the client changes could be synchronized to the Mobile Server
During our load test, we noticed that the TCP window from the Mobile Server is closed when we try to send a client change bigger than 16M, after some digging, we found that there is an Oracle undocumented poperty, RESUME_FILE_SIZE, could be set in the Consolidator section of the Webtogo.ora to break this limit.
For example, if you want the spool file size as big as 128M, you can set the property like:
RESUME_FILE_SIZE=128
technorati tags:OLite
Subscribe to:
Posts (Atom)