select a.* from (select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"
from(select "ID","NAME","PRICE_BAY","PRICE_SELL","QNTY","REST_QNTY","CLIENT_ID"
from(select ID,
       NAME,
       PRICE_BAY,
       PRICE_SELL,
       QNTY,
       REST_QNTY,
       CLIENT_ID
  from MBK_CLIENT_PLAN_RELIZE
)q
)q
)a

where ROWNUM <= :p$_max_rows

0.00207	0.00077	
Reset NLS settings
4	
1%
0.00284	0.00055	
alter session set  NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CALENDAR='GREGORIAN' NLS_SORT='BINARY' NLS_COMP='BINARY'
4	
1%
0.00339	0.00004	
...NLS: Set Decimal separator="."
4	
0%
0.00343	0.00039	
...NLS: Set NLS Group separator=","
4	
1%
0.00383	0.00008	
...NLS: Set g_nls_date_format="DD-MON-RR"
4	
0%
0.00390	0.00035	
...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"
4	
1%
0.00425	0.00067	
...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
4	
1%
0.00492	0.00012	
NLS of database and client differs, characterset conversion needed
4	
0%
0.00504	0.00015	
...Setting session time_zone to +06:00
4	
0%
0.00518	0.00650	
R E Q U E S T ajax
4	
11%
0.01169	0.00096	
Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: ru
4	
2%
0.01265	0.00008	
alter session set nls_language='RUSSIAN' nls_territory='RUSSIA'
4	
0%
0.01273	0.00028	
NLS: CSV charset=CL8MSWIN1251
4	
0%
0.01300	0.00006	
...NLS: Set Decimal separator=","
4	
0%
0.01307	0.00028	
...NLS: Set NLS Group separator=" "
4	
0%
0.01335	0.00008	
...NLS: Set g_nls_date_format="DD.MM.RR"
4	
0%
0.01342	0.00007	
...NLS: Set g_nls_timestamp_format="DD.MM.RR HH24:MI:SSXFF"
4	
0%
0.01349	0.00019	
...NLS: Set g_nls_timestamp_tz_format="DD.MM.RR HH24:MI:SSXFF TZR"
4	
0%
0.01368	0.00050	
Setting NLS: NLS_DATE_FORMAT="DS" NLS_TIMESTAMP_FORMAT="DS" NLS_TIMESTAMP_TZ_FORMAT="DS"
4	
1%
0.01418	0.00016	
...NLS: Set g_nls_date_format="DS"
4	
0%
0.01434	0.00008	
...NLS: Set g_nls_timestamp_format="DS"
4	
0%
0.01442	0.00043	
...NLS: Set g_nls_timestamp_tz_format="DS"
4	
1%
0.01485	0.00010	
NLS: Language=ru
4	
0%
0.01496	0.00675	
Application 126, Page Template: 1381006702595054869
4	
11%
0.02170	0.00097	
Authentication check: ABNLDAP (NATIVE_LDAP)
4	
2%
0.02267	0.00118	
Session State: fetch from database (exact)
4	
2%
0.02386	0.00013	
... sentry+verification success
4	
0%
0.02398	0.00153	
...Session ID 14507524636803 can be used
4	
2%
0.02551	0.00009	
...Setting session time_zone to +06:00
4	
0%
0.02560	0.00093	
...Check for session expiration:
4	
2%
0.02653	0.00060	
......Validate item page affinity
4	
1%
0.02713	0.00073	
......Read Page Item values and validate protected items
4	
1%
0.02786	0.00027	
.........Name=P170_CLIENT_ID (id=7591162227865120), value=7249, checksum=ypSYSLSqvrhKSoHM-2_ZhQgONs8
4	
0%
0.02812	0.00011	
Session State: Save "Items to Submit"
4	
0%
0.02823	0.00043	
Session State: P170_CLIENT_ID=>7249
4	
1%
0.02866	0.00055	
... do not save: same value / password / no session
4	
1%
0.02921	0.00070	
Authorization Check: "KZT_AUTH" Caching: "BY_USER_BY_PAGE_VIEW" Component "APPLICATION"
4	
1%
0.02991	0.00206	
...Execute Statement: declare function x return boolean is begin declare
retval BOOLEAN;
begin
retval := app_security_pkg.valid_page(:APP_USER,:APP_PAGE_ID);
return retval;
end;
 return null; end; begin wwv_flow.g_boolean := x; end;
4	
3%
0.03197	0.00012	
......Result = true
4	
0%
0.03209	0.00007	
...  passed
4	
0%
0.03217	0.01686	
Run ajax request
4	
27%
0.04902	0.00017	
Parse LOV query of column BAY_TYPE to get display and return column for joining it to base query.
4	
0%
0.04920	0.00061	
...Execute Statement: select /*+ cardinality(t 10) no_result_cache */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(1)) t order by insert_order, disp
4	
1%
0.04981	0.00254	
...Perform an outer join. Reason: Column is required = false, LOV display extra = true, LOV display null = true
4	
4%
0.05235	0.00091	
...Execute Statement: select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"
from(select q.*,coalesce(to_char("l14241497474723929"."DISP"), to_char(q."BAY_TYPE")) "APEX$L14241497474723929"
from(select "ROWID" "APEX$ROWID","ID","CLIENT_ID","BAY_TYPE","AMOUNT","QNTY"
from(select ID,
       CLIENT_ID,
       BAY_TYPE,
       AMOUNT,
       QNTY
     
  from MBK_CLIENT_REGULAR_BAY
WHERE CLIENT_ID=:P170_CLIENT_ID
)q
)q,
(select /*+ cardinality(t 10) no_result_cache */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(1)) t order by insert_order, disp
)"l14241497474723929"
where "l14241497474723929"."VAL"(+)=q."BAY_TYPE"
)q
4	
1%
0.05327	0.00009	
Rewrite SQL to: select a.* from (select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"
from(select q.*,coalesce(to_char("l14241497474723929"."DISP"), to_char(q."BAY_TYPE")) "APEX$L14241497474723929"
from(select "ROWID" "APEX$ROWID","ID","CLIENT_ID","BAY_TYPE","AMOUNT","QNTY"
from(select ID,
       CLIENT_ID,
       BAY_TYPE,
       AMOUNT,
       QNTY
     
  from MBK_CLIENT_REGULAR_BAY
WHERE CLIENT_ID=:P170_CLIENT_ID
)q
)q,
(select /*+ cardinality(t 10) no_result_cache */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(1)) t order by insert_order, disp
)"l14241497474723929"
where "l14241497474723929"."VAL"(+)=q."BAY_TYPE"
)q
)a

where ROWNUM <= :p$_max_rows
4	
0%
0.05335	0.00800	
...Execute Statement: select a.* from (select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"
from(select q.*,coalesce(to_char("l14241497474723929"."DISP"), to_char(q."BAY_TYPE")) "APEX$L14241497474723929"
from(select "ROWID" "APEX$ROWID","ID","CLIENT_ID","BAY_TYPE","AMOUNT","QNTY"
from(select ID,
       CLIENT_ID,
       BAY_TYPE,
       AMOUNT,
       QNTY
     
  from MBK_CLIENT_REGULAR_BAY
WHERE CLIENT_ID=:P170_CLIENT_ID
)q
)q,
(select /*+ cardinality(t 10) no_result_cache */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(1)) t order by insert_order, disp
)"l14241497474723929"
where "l14241497474723929"."VAL"(+)=q."BAY_TYPE"
)q
)a

where ROWNUM <= :p$_max_rows
4	
13%
0.06136	0.00041	
Stop APEX Engine detected
4	
1%
0.06177	-	
Final commit
4	
0%

Tip:
Asynchronous JavaScript and XML (Ajax) is used throughout interactive grids. Because Ajax is asynchronous, the value evaluated for conditional display must be in the session. To display an interactive grid conditionally based on a specified value, use a page item instead of using a :REQUEST value. Using :REQUEST in a conditional display causes the interactive report function incorrectly.