OBIEE 11G Check the Query Log

1 . Return to Fusion Middleware Control, which should still be open.
2 . Click the Diagnostics tab.
Screenshot for Step
3 . Click the Log Messages sub tab.
Screenshot for Step
4 . Scroll to the bottom of the window to the View / Search Log Files section.
Screenshot for Step
5 . Click Server Log to navigate to the Log Messages screen.
Screenshot for Step

6 . In the Log Messages screen, leave the data range set to Most Recent, 1 Days. Deselect all message types except for Trace.
Screenshot for Step
7 . In the Message field, enter sending query to database.
Screenshot for Step
8 . Click Search.
Screenshot for Step
9 . Select the last message in the list. This is the most recent query sent to the database.
Screenshot for Step
10 . In the bottom pane, click the Collapse Pane button (arrow on the right side) to view the log message. Your results should look similar to the screenshot. The screenshot shows only a partial view of the log.
Screenshot for Step
Notice that both D3 Customer and D4 Address are accessed. The presentation columns included in the analysis were selected from two different presentation tables: Customers and Customer Regions. Both of these presentation tables map to the same logical table, D3 Customer. The D3 Customer logical table maps to two physical sources: D3 Customer and D4 Address.
11 . Click the Restore Pane button.
12 . Leave Enterprise Manager open.

No comments:

Post a Comment

Popular Posts