SQL> SELECT /*+ PARALLEL (a 8) PARALLEL (b 8) */
SUM (space_used_delta) / 1024 / 1024 "USED_MB",
  2    3  SUM (c.bytes) / 1024 / 1024 "TOTAL_MB",
  4  ROUND (SUM (space_used_delta) / SUM (c.bytes) * 100, 2) || '%'"PERCENT"
  5  FROM dba_hist_snapshot sn,dba_hist_seg_stat a,
  6  dba_objects b,
  7  dba_segments c
  8  WHERE     end_interval_time > TRUNC (SYSDATE) - 7
  9  AND sn.snap_id = a.snap_id
 10  AND b.object_id = a.obj#
 11  AND b.owner = c.owner
AND b.object_name = c.segment_name
 12   13  AND c.owner = 'COMAPPO'
 14  AND space_used_delta > 0;
FROM dba_hist_snapshot sn,dba_hist_seg_stat a,
                            *
ERROR at line 5:
ORA-03001: unimplemented feature


SQL>

07:25:22 SQL> select name from v$database;

NAME
---------
V112

07:25:30 SQL> select * from V$VERSION;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

07:25:42 SQL> 

orcl> SELECT /*+ PARALLEL (a 8) PARALLEL (b 8) */
  2  SUM (space_used_delta) / 1024 / 1024 "USED_MB",
  3      SUM (c.bytes) / 1024 / 1024 "TOTAL_MB",
  4      ROUND (SUM (space_used_delta) / SUM (c.bytes) * 100, 2) || '%'"PERCENT"
  5      FROM dba_hist_snapshot sn,dba_hist_seg_stat a,
  6      dba_objects b,
  7      dba_segments c
  8      WHERE     end_interval_time > TRUNC (SYSDATE) - 7
  9      AND sn.snap_id = a.snap_id
 10     AND b.object_id = a.obj#
 11     AND b.owner = c.owner
 12  AND b.object_name = c.segment_name
 13     AND c.owner = 'COMAPPO'
 14     AND space_used_delta > 0;

   USED_MB   TOTAL_MB PERCENT
---------- ---------- -----------------------------------------
                      %

orcl> select * from v$version;

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

orcl>

SQL> select name from v$database;

NAME
---------
BULKBILL

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL>

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> desc dba_hist_snapshot
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 STARTUP_TIME                              NOT NULL TIMESTAMP(3)
 BEGIN_INTERVAL_TIME                       NOT NULL TIMESTAMP(3)
 END_INTERVAL_TIME                         NOT NULL TIMESTAMP(3)
 FLUSH_ELAPSED                                      INTERVAL DAY(5) TO SECOND(1)
 SNAP_LEVEL                                         NUMBER
 ERROR_COUNT                                        NUMBER
 SNAP_FLAG                                          NUMBER
 SNAP_TIMEZONE                                      INTERVAL DAY(0) TO SECOND(0)

SQL> desc dba_hist_seg_stat
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 TS#                                       NOT NULL NUMBER
 OBJ#                                      NOT NULL NUMBER
 DATAOBJ#                                  NOT NULL NUMBER
 LOGICAL_READS_TOTAL                                NUMBER
 LOGICAL_READS_DELTA                                NUMBER
 BUFFER_BUSY_WAITS_TOTAL                            NUMBER
 BUFFER_BUSY_WAITS_DELTA                            NUMBER
 DB_BLOCK_CHANGES_TOTAL                             NUMBER
 DB_BLOCK_CHANGES_DELTA                             NUMBER
 PHYSICAL_READS_TOTAL                               NUMBER
 PHYSICAL_READS_DELTA                               NUMBER
 PHYSICAL_WRITES_TOTAL                              NUMBER
 PHYSICAL_WRITES_DELTA                              NUMBER
 PHYSICAL_READS_DIRECT_TOTAL                        NUMBER
 PHYSICAL_READS_DIRECT_DELTA                        NUMBER
 PHYSICAL_WRITES_DIRECT_TOTAL                       NUMBER
 PHYSICAL_WRITES_DIRECT_DELTA                       NUMBER
 ITL_WAITS_TOTAL                                    NUMBER
 ITL_WAITS_DELTA                                    NUMBER
 ROW_LOCK_WAITS_TOTAL                               NUMBER
 ROW_LOCK_WAITS_DELTA                               NUMBER
 GC_CR_BLOCKS_SERVED_TOTAL                          NUMBER
 GC_CR_BLOCKS_SERVED_DELTA                          NUMBER
 GC_CU_BLOCKS_SERVED_TOTAL                          NUMBER
 GC_CU_BLOCKS_SERVED_DELTA                          NUMBER
 GC_BUFFER_BUSY_TOTAL                               NUMBER
 GC_BUFFER_BUSY_DELTA                               NUMBER
 GC_CR_BLOCKS_RECEIVED_TOTAL                        NUMBER
 GC_CR_BLOCKS_RECEIVED_DELTA                        NUMBER
 GC_CU_BLOCKS_RECEIVED_TOTAL                        NUMBER
 GC_CU_BLOCKS_RECEIVED_DELTA                        NUMBER
 SPACE_USED_TOTAL                                   NUMBER
 SPACE_USED_DELTA                                   NUMBER
 SPACE_ALLOCATED_TOTAL                              NUMBER
 SPACE_ALLOCATED_DELTA                              NUMBER
 TABLE_SCANS_TOTAL                                  NUMBER
 TABLE_SCANS_DELTA                                  NUMBER
 CHAIN_ROW_EXCESS_TOTAL                             NUMBER
 CHAIN_ROW_EXCESS_DELTA                             NUMBER
 PHYSICAL_READ_REQUESTS_TOTAL                       NUMBER
 PHYSICAL_READ_REQUESTS_DELTA                       NUMBER
 PHYSICAL_WRITE_REQUESTS_TOTAL                      NUMBER
 PHYSICAL_WRITE_REQUESTS_DELTA                      NUMBER
 OPTIMIZED_PHYSICAL_READS_TOTAL                     NUMBER
 OPTIMIZED_PHYSICAL_READS_DELTA                     NUMBER

SQL>

SQL> show parameter  control_management_pack_access

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
control_management_pack_access       string
DIAGNOSTIC+TUNING
SQL>

16:01:08 SQL>create table foo(a number)
16:01:16   2  /

Table created.

Elapsed: 00:00:00.06
16:01:16 SQL>insert into foo values 1
16:01:21   2  /
insert into foo values 1
                       *
ERROR at line 1:
ORA-03001: unimplemented feature


Elapsed: 00:00:00.00

SQL> select table_name,PARTITIONING_TYPE from dba_part_tables where TABLE_NAME='WRH$_SEG_STAT';

TABLE_NAME                     PARTITION
------------------------------ ---------
WRH$_SEG_STAT                  RANGE

SQL>

With the Partitioning and Real Application Testing options

-bash-3.2$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 15 08:02:47 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> select '%%%%%%%%%'"PERCENT" from dual;
PERCENT
---------
%%%%%%%%%

SQL> select 2/5*100 ||'%'"percent" from dual;

per
---
40%

SQL>

SQL> @v

Version Oracle : 11.2.0.3.0

SQL> select 2/5*100 ||'%'"percent" from dual;
per
---
40%

1 row selected.

SQL> select PLATFORM_NAME from sys.DBA_REGISTRY_DATABASE;
PLATFORM_NAME
-------------------------------------------------------------
Linux x86 64-bit

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 2 15:15:30 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> select 'test'"TEST" from dual;
select 'test'"TEST" from dual
        *
ERROR at line 1:
ORA-03001: unimplemented feature


SQL> select 'test' "TEST" from dual;

TEST
--------------------------------
test

SQL>

SQL> alter session set cursor_sharing=exact;

Session altered.

SQL> select 'test'"TEST" from dual;

TEST
----
test

SQL> alter session set cursor_sharing=force;

Session altered.

SQL> select 'test'"TEST" from dual;
select 'test'"TEST" from dual
        *
ERROR at line 1:
ORA-03001: unimplemented feature

orcl>
orcl> var vc varchar2(4)
orcl>
orcl> exec :vc := 'test'

PL/SQL procedure successfully completed.

orcl> select :vc"test" from dual;

test
--------------------------------
test

orcl>