Archive for June, 2011

Oracle query to get session pga & uga memory usage for inactive sessions

0
I’m listing below some of the queries I have created to see various oracle session related memory statistics. Replace all occurrences of XXXXXXXXXXXXXXXX with your database username. Please drop a comment below if these queries are useful for you guys. Query for getting ‘session pga memory’ usage for inactive sessions: select sum(ROUND(s.value/1024)) || ‘ KB’ [...]

How to get maximum limit of open_cursors, sessions and processes in Oracle

0
In order to display the maximum limit of open_cursors, sessions and processes in Oracle, you can run the below queries on SQL Plus: select value from v$parameter where name = ‘open_cursors’ select value from v$parameter where name = ‘sessions’ select value from v$parameter where name = ‘processes’

How to get current open_cursors utilization and maximum limit in Oracle

0
If you are looking for a query which will list you theĀ current open_cursors utilization and maximum limit in Oracle database, then try the below given query: select max(a.value) as highest_value, p.value as max_value from v$sesstat a, v$statname b, v$parameter p where a.statistic# = b.statistic# and b.name = ‘opened cursors current’ and p.name= ‘open_cursors’ group by [...]

Viewing PGA Statistics of your Oracle Database

0
VIEWING PGA STATISTICS ———————————- V$PGASTAT – This view gives instance-level statistics on the PGA memory usage and the automatic PGA memory manager. For example: SELECT * FROM V$PGASTAT;

Checking number of open cursors in Oracle

0
Run the following query to check the number of open cursors in your Oracle select count(*) from v$open_cursor where USER_NAME=’xxxxxxxxx’ Replace xxxxxxxxx with the username your application is using.

java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)

0
If you get the following error in your java+jsp+oracle application, then you probably need to increase your maximum session/process limits (Default process and sessions limit in Oracle 9i are 150 and 170 respectively) java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=) Instructions for Increasing session, process and open_cursors max limits to 500 each are: [...]
Go to Top