How to kill Oracle session

Sessions can be killed from within Oracle using the ALTER SYSTEM KILL SESSION syntax.


First identify the offending session as follows:


SELECT s.sid,s.serial#, s.osuser, s.program FROM v$session s;



This query will result in a similar result. SID SERIAL# OSUSER PROGRAM

1 1 SYSTEM ORACLE.EXE

2 1 SYSTEM ORACLE.EXE

3 1 SYSTEM ORACLE.EXE

4 1 SYSTEM ORACLE.EXE

32 45 SCOTT WINSQL.EXE

37 501 SYSTEM WINSQL.EXE


The SID and SERIAL# values of the relevant session can then be substituted into the following statement:

ALTER SYSTEM KILL SESSION 'sid,serial#'

In some situations the Oracle.exe is not able to kill the session immediately. In these cases the session will be "marked for kill". It will then be killed as soon as possible.

Issuing the ALTER SYSTEM KILL SESSION command is the only safe way to kill an Oracle session. If the marked session persists for some time you may consider killing the process at the operating system level. However, this is not recommended as it is dangerous and can lead to instance failures.



It is possible to force the kill by adding the IMMEDIATE keyword:



ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE

Not able to login in new Oracle apps instance

type regedit in run and edit the registry If HKEY_CLASSES_ROOT\TypeLib{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}\1.1\0\win32 is "C:\WINDOWS\system32\shdocvw.dll" Replace that value with "C:\WINDOWS\system32\ieframe.dll"

Apps Query

Query to update the Concurrent Prg and Executable name

fnd_concurrent_programs_vl - View
fnd_concurrent_programs_tl , fnd_concurrent_programs - Tables

Update fnd_concurrent_programs_tl
set user_concurrent_program_name = 'XXAR QMF Customer Conversion Interface'
Where Concurrent_program_id = 150490

update fnd_concurrent_programs
set concurrent_program_name = 'XXARQMF_CUST_LOAD_PRG'
Where Concurrent_program_id = 150490

===================================================================================

fnd_executables_vl - View
fnd_executables_tl , fnd_executables - Tables

Update fnd_executables_tl
Set User_executable_name = 'XXARQMF_CUST_LOAD_PRG',
Description = 'QMF Customer SQL Loader Program'
Where Application_Id = 20007 and executable_Id = 12477

Update fnd_executables
Set Executable_Name = 'XXARQMF_CUST_LOAD_PRG',
Execution_file_name = 'xxarqmf_cust_load_sh'
Where Application_Id = 20007 and executable_Id = 12477

Getting Started with OAF

OAF development can be split into two major categories namely:

• Personalization refers to the ability to declaratively alter the UI to suit user or business needs.
• Extensibility refers to the ability to programmatically extend an application's functionality.

Personalization, declaratively tailoring the user interface (UI) look-and-feel, layout or visibility of page content to suite a business need or a user preference. Personalization examples:
• Tailor the color scheme of the UI.
• Tailor the order in which table columns are displayed.
• Tailor a query result.

Extensibility, extending the functionality of an application, beyond what can be done through personalization. Extensibility examples:
• Add new functional flows.
• Extend or override existing functional flows.
• Extend or override existing business logic.