Use
In certain cases, it may be necessary to stop a specific database session.
Procedure
Choose Instance ® Sessions. A list of the current
database sessions is displayed.Select the database session that you want to close.
Choose Sessions ® Kill Selected Sessions to close the database session.