Wednesday, September 27, 2006

Check account status on Oracle 10g

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

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:

Full Guide for using Bitnami Prometheus Operator Helm Chart with Additional Scrape Configuration

"The Prometheus Operator for Kubernetes provides easy monitoring definitions for Kubernetes services and deployment and management of...