text: -- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
  -- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
  
  -- A-Times were misestimated with the default sampling 
  -- ALTER SESSION SET "_rowsource_statistics_sampfreq"=1; 
  ALTER SESSION SET "_serial_direct_read"=ALWAYS;
  
  SELECT /*+ MONITOR test2a */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  @getprev
  @xpi &prev_sql_id
  @xia &prev_sql_id &prev_child_number
  
  -- @ash/asqlmon &prev_sql_id &prev_child_number
  -- @sqlidx &prev_sql_id &prev_child_number
  
  SELECT /*+ MONITOR NO_PUSH_SUBQ(@"SEL$2") test2b */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  @getprev
  -- @ash/asqlmon &prev_sql_id &prev_child_number
  -- @sqlidx &prev_sql_id &prev_child_number
  @xpi &prev_sql_id
  @xia &prev_sql_id &prev_child_number
  
  -- ALTER SESSION SET "_rowsource_statistics_sampfreq"=128;
  
  
  SELECT /*+ MONITOR OPT_PARAM('cell_offload_processing', 'false') test3a */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  
  SELECT /*+ MONITOR NO_PUSH_SUBQ(@"SEL$2") OPT_PARAM('cell_offload_processing', 'false') test3b */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  
  
  SELECT /*+ MONITOR PUSH_SUBQ(@"SEL$2") OPT_PARAM('cell_offload_processing', 'true') test4a */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  
  SELECT /*+ MONITOR NO_PUSH_SUBQ(@"SEL$2") OPT_PARAM('cell_offload_processing', 'true') test4b */
      SUM(LENGTH(object_name)) + SUM(LENGTH(object_type)) + SUM(LENGTH(owner))
  FROM
      test_objects_100m o
  WHERE
      o.owner = (SELECT u.username FROM test_users u WHERE user_id = 13)
  /
  
  
  
  