OBIEE 11G Check the Query Log

1 .	Return to Fusion Middleware Control, which should still be open.
2 .	Click the Diagnostics tab.
3 .	Click the Log Messages sub tab.
4 .	Scroll to the bottom of the window to the View / Search Log Files section.
5 .	Click Server Log to navigate to the Log Messages screen.
6 .	In the Log Messages screen, leave the data range set to Most Recent, 1 Days. Deselect all message types except for Trace.
7 .	In the Message field, enter sending query to database.
8 .	Click Search.
9 .	Select the last message in the list. This is the most recent query sent to the database.
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. 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.