Solution to the number of active sessions of Oracle11g r2

If you are not sure about the number of active sessions of Oracle11g r2 in actual operations, you can use the following articles to learn about its practical application and functions. The following is a detailed introduction of the article.

In the process of the number of active sessions of Oracle11g r2, do you think that sometimes the amount of waiting is coming up suddenly. however, adding, deleting, and modifying operations in the application will be quite slow .. it brings a lot of inconvenience in actual operation.

After several days of observation, when someone imports or exports data in batches, for example, excel (about 1000 records) parses data through jxl and then jdbc executes update to the database, the number of active sessions is surging, and the system is slowing down as a whole. maybe it's not my consideration or analysis. Maybe it's enough to increase the number of active sessions in oracle, but how can I add them? But I don't know why?

The following lists the simple ora parameters that I have considered:

SQL> show parameter sga

NAME TYPE VALUE
Lock_sga boolean FALSE
Pre_page_sga boolean FALSE
Sga_max_size big integer 6016 M
Sga_target big integer 6016 M

I use the Automatic Memory sharing management mode, And I allocate 6 GB to the database. run on the 64-bit win2003 machine and use statement.exe cutBatch () in the program for batch submission. is there a place where the number of active sessions of oracle11g r2 can be increased ??

Related questions:

Piao_bo_yi writes that it should be the number of concurrent connections. The location where the database is connected can be set, depending on where the application connects to the database and the location is different. "The location where the database is connected can be set, depending on where the application connects to the database and the location is different"

The above content is an introduction to the number of active sessions of Oracle11g r2. I hope you will have some gains.