Maximum number of sessions exceeded

When I run a program through my application server, I get the following error: "ORA-00018:maximum number of sessions exceeded."

Published: 18 Dec 2006

I have an application server (WebSphere) doing connection pooling with a max limit of 30 connections. My database is Oracle 9i. When I run a program through the application server, I get the following error: "ORA-00018:maximum number of sessions exceeded."

I am being very careful in closing all the PreparedStatements, CallableStatements, ResultSets and Connections in the program.

I will be very thankful if you can figure what the problem is.

The number of sessions has reached the limit defined by the SESSIONS parameter. This parameter is typically derived from the PROCESSES parameter. You will probably need to increase the number of processes, thus increasing the number of allowable sessions. The V$RESOURCE_LIMIT view can show you what the limit is and if you have reached it.

Dig Deeper on Oracle database design and architecture

Small changes make a difference in PowerShell 5.0 Coming to the next versions of Windows, PowerShell 5.0 adds remote file-editing capabilities, as well as improvements to Desired State Configuration.

Command-line utilities for SQL Server database tuning, comparing tables Get an inside look at a command line utility for SQL Server database tuning. See how the dta utility does an analysis on its given workload and provides performance recommendations. And read about tablediff, which allows for comparing tables.

Why throttling PowerShell in Exchange 2010 is a good idea Did you know that you can restrict PowerShell use in Exchange 2010 to improve server performance? Get the details on setting PowerShell limits in your environment.

Connection Security - Terminal Services for Windows Server 2003 "Connections" in the Terminal Server environment refer to the groups of settings that apply to a specific Session Protocol / Network Protocol / Network Interface combination in the form of a connection listener port. There are multiple options configured at this "connection layer.

Active Directory User Object Attributes - Terminal Services for Windows Server 2003 We'll look first to the very basics - configuring properties of a user's Active Directory account object.

Connection Security - Citrix MetaFrame XP There are multiple options configured at the "connection layer.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Maximum number of sessions exceeded

When I run a program through my application server, I get the following error: "ORA-00018:maximum number of sessions exceeded."

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.