An OBI Server Administrator can kill any active query. When OBI
Server Administrator kills an active query, the execution of that query
will be terminated.
Steps to Kill an Active Query :
1. In the Administration Tool, open a repository in online mode and choose Manage > Sessions.
2. Select the user session that initiated the query in the top window of the Session Manager. After the user is highlighted, any active query requests from that user are displayed in the bottom window.
3. Select the request you want to kill.
4. Click Kill Request to terminate the highlighted request.
5. To close Session Manager, click close.
Steps to Kill an Active Query :
1. In the Administration Tool, open a repository in online mode and choose Manage > Sessions.
2. Select the user session that initiated the query in the top window of the Session Manager. After the user is highlighted, any active query requests from that user are displayed in the bottom window.
3. Select the request you want to kill.
4. Click Kill Request to terminate the highlighted request.
The user receives a message indicating
that the query was terminated by the Oracle BI Administrator. The query is
immediately terminated, and any outstanding queries to underlying databases are
canceled.
Repeat this process to kill any other
requests.
5. To close Session Manager, click close.
On our servers, this doesn't work. It just hangs the admin tool.
ReplyDelete