as far as active/inactive go, i'm pretty sure an ACTIVE session is only one who is in the middle of doing work. executing a statement, procedure, etc.
if i log onto sqlplus and let it sit there while you query sessions, mine will be INACTIVE. if i execute a query that takes 10 seconds, and you query sometime during those 10 seconds, i will be ACTIVE.
what applications are running against your database? some applications may make persistant connections.
The best way to get over the inactive sessions is to create a profile and set the session idle time to some where around 60 min. This way if some one keeps the sessions open and goes home for the day, you could remove them without any problem. Also as one of the other guys suggested set up the session limit and this way you could put a limit on the number of sessions that a user can open.
The application has been created using Developer. It is an online system for registration of businesses and also creating reports.
I do not know the details of the system.. but could you'll elaborate when u'll said that windows appliations take up more than one session?
when you run the application it will open one session just to show the "entry" of the application, the place where you select which form or report you want to use, then once you choose one option it will open another session, for example if one open a form to fill in an order, this will get 2 sessions per PC because everyone using this kind of aplication will have at least one form or report open and the main application
As per ur request, sessions are nothing but the physical
connection establised to oracle database. If u execute
a long running updates or deletes against a table, the session will be
active, this signifies that the table is locked during that
process, simultaneously if another user issue a DML statements
against the same table, his sessions also will be in active mode,
and also it will be realsed only when former job is completed.
this is the overall information, which provided. Default
there are some oracle background process will be running as
soon as the database instance started , theses session information
will active thr' out for ever,until u shutdown the database.