I tried, no luck. It seems that the best features are disabled in the XE.
Even Kyle Haley's S-ASH and ashmon are having problems.

SQL>
SQL> alter session set optimizer_capture_sql_plan_baselines=true;

Session altered.

Elapsed: 00:00:00.00
SQL> select * from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 17-DEC-80 800
20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300
30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500
30


EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7566 JONES MANAGER 7839 02-APR-81 2975
20

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400
30

7698 BLAKE MANAGER 7839 01-MAY-81 2850
30


EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7782 CLARK MANAGER 7839 09-JUN-81 2450
10

7788 SCOTT ANALYST 7566 19-APR-87 3000
20

7839 KING PRESIDENT 17-NOV-81 5000
10


EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0
30

7876 ADAMS CLERK 7788 23-MAY-87 1100
20

7900 JAMES CLERK 7698 03-DEC-81 950
30


EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7902 FORD ANALYST 7566 03-DEC-81 3000
20

7934 MILLER CLERK 7782 23-JAN-82 1300
10


14 rows selected.

Elapsed: 00:00:00.05

SQL>
SQL> select * from v$version;

BANNER
-------------------------------------------------------------------------------

Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Elapsed: 00:00:00.01
SQL>


--
Harry Potter in 1D: --------------------------------------------

On Fri, 21 Oct 2011 17:09:30 +0000, Mladen Gogala wrote:

Sorry, forgot to include the query that proves it:

SQL> select sql_handle,plan_name
2 from dba_sql_plan_baselines
3 where lower(sql_text) like '%emp%';

no rows selected

Elapsed: 00:00:00.02


--
Harry Potter in 1D: --------------------------------------------

On Oct 21, 7:13*pm, Mladen Gogala <mgog... (AT) no (DOT) address.invalid> wrote:
As far as I know SQL Plan Baselines are an Enterprise Edition feature,
so I wouldn't be surprised to see them not working even in Standard
Edition (One).

Having said that - you are aware of the fact that baselines are only
captured if you execute the same statement at least twice? Your demo
wouldn't capture baselines in Enterprise Edition either I assume since
you run your query only once.

Randolf

On Sat, 22 Oct 2011 02:33:31 -0700, Randolf Geist wrote:

No, I ran the query several times. Baseline wasn't captured.
Unfortunately, you're right, it's an EE feature.



--
http://mgogala.byethost5.com

Hi there,

if I read http://blogs.oracle.com/optimizer correct, than baselines are no EE feature. If the XE can use it is not really mentioned there, but SE should work.

Bye Joerg

On Oct 26, 8:49*am, anton.ta... (AT) googlemail (DOT) com wrote:
You might want to re-read the post, because it seems to mention this
explicitly:

taken from: http://blogs.oracle.com/optimizer/en...the_use_of_sql

Randolf

On 26 Okt., 11:14, Randolf Geist <mah... (AT) web (DOT) de> wrote:
Hello Randolf,

sorry, you're absolutely right. I think i was so amazed because of
this amazing toolkit that i was unable to see the catch in this offer.

Sorry for posting this wrong info.

Bye

Joerg