Home » RDBMS Server » Server Administration » ORA-03001: unimplemented feature (11.2.0.2.0 HP-AUX 64 BIT)
ORA-03001: unimplemented feature [message #554555] Tue, 15 May 2012 09:17 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Expert,

Please suggest for error: ORA-03001: unimplemented feature.

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>


All the tables are present, still..??
Re: ORA-03001: unimplemented feature [message #554556 is a reply to message #554555] Tue, 15 May 2012 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
do not use feature for which you have paid or licensed,

post results from SQL like below

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> 
Re: ORA-03001: unimplemented feature [message #554558 is a reply to message #554556] Tue, 15 May 2012 09:31 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It works for me:
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>

Re: ORA-03001: unimplemented feature [message #554559 is a reply to message #554558] Tue, 15 May 2012 09:47 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi,

Yes we have licensed from Oracle.

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>
Re: ORA-03001: unimplemented feature [message #554560 is a reply to message #554559] Tue, 15 May 2012 09:51 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Also to add to last reply, both the tables used are present.

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>
Re: ORA-03001: unimplemented feature [message #554561 is a reply to message #554559] Tue, 15 May 2012 09:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It works for me too in 11.2.0.1 (in addition to 11.2.0.3).

Regards
Michel
Re: ORA-03001: unimplemented feature [message #554562 is a reply to message #554560] Tue, 15 May 2012 10:00 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

To add more, i just check for control_management_pack_access parameter and it is set to DIAGNOSTIC+TUNING.

SQL> show parameter  control_management_pack_access

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
control_management_pack_access       string
DIAGNOSTIC+TUNING
SQL>
Re: ORA-03001: unimplemented feature [message #554564 is a reply to message #554560] Tue, 15 May 2012 10:02 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
I get the same as John on 11.2.0.3

Although I *can* make that error manifest with the following (trivia only)

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



I noticed that one day when I forgot the brackets Smile
Re: ORA-03001: unimplemented feature [message #554565 is a reply to message #554562] Tue, 15 May 2012 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same thing for me.

Regards
Michel
Re: ORA-03001: unimplemented feature [message #554567 is a reply to message #554565] Tue, 15 May 2012 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 11.2, WRH$_SEG_STAT table under dba_hist_seg_stat view is partitioned.
Have you install the partitioning option?
Check if your table is partitioned or not.

Regards
Michel
Re: ORA-03001: unimplemented feature [message #554568 is a reply to message #554567] Tue, 15 May 2012 10:11 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Yes Michel, it is partitioned.

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

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

SQL>
Re: ORA-03001: unimplemented feature [message #554569 is a reply to message #554568] Tue, 15 May 2012 10:12 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
I think he meant do you see something like this when you log on

With the Partitioning and Real Application Testing options
Re: ORA-03001: unimplemented feature [message #554570 is a reply to message #554569] Tue, 15 May 2012 10:14 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

-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>
Re: ORA-03001: unimplemented feature [message #554571 is a reply to message #554570] Tue, 15 May 2012 10:17 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

It seems i have BUG.

Note: 801219.1 Ora-03001: Unimplemented Feature Error On 11g Database Targets. Please share your views.
Re: ORA-03001: unimplemented feature [message #554572 is a reply to message #554571] Tue, 15 May 2012 10:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Please share your views.
Not relevant.
icon3.gif  Re: ORA-03001: unimplemented feature [message #581122 is a reply to message #554555] Tue, 02 April 2013 06:09 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
dba_7722 wrote on Tue, 15 May 2012 09:17
Hello Expert,

Please suggest for error: ORA-03001: unimplemented feature.

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>


All the tables are present, still..??


at line 4, add a space between '%' and "PERCENT"

Re: ORA-03001: unimplemented feature [message #581130 is a reply to message #581122] Tue, 02 April 2013 06:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not an error:
SQL> select '%%%%%%%%%'"PERCENT" from dual;
PERCENT
---------
%%%%%%%%%

Regards
Michel
Re: ORA-03001: unimplemented feature [message #581131 is a reply to message #581122] Tue, 02 April 2013 06:46 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's not a problem:
SQL> select 2/5*100 ||'%'"percent" from dual;

per
---
40%

SQL>
Re: ORA-03001: unimplemented feature [message #581134 is a reply to message #581131] Tue, 02 April 2013 07:02 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
Littlefoot wrote on Tue, 02 April 2013 06:46
That's not a problem:
SQL> select 2/5*100 ||'%'"percent" from dual;

per
---
40%

SQL>


Select above returns error "ORA-03001: unimplemented feature" with ORALCE Linux Version 11.2.0.3.0
But no error with previous versions (8, 9, 10)
Re: ORA-03001: unimplemented feature [message #581135 is a reply to message #581134] Tue, 02 April 2013 07:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wonder what's "unimplemented" in that simple calculation ...
Re: ORA-03001: unimplemented feature [message #581141 is a reply to message #581134] Tue, 02 April 2013 07:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> @v

Version Oracle : 11.2.0.3.0

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

1 row selected.

Regards
Michel
Re: ORA-03001: unimplemented feature [message #581143 is a reply to message #581141] Tue, 02 April 2013 07:39 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
Michel Cadot wrote on Tue, 02 April 2013 07:34
SQL> @v

Version Oracle : 11.2.0.3.0

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

1 row selected.

Regards
Michel


My version of ORACLE is installed on a LINUX platform.
And you ?
Re: ORA-03001: unimplemented feature [message #581144 is a reply to message #581143] Tue, 02 April 2013 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select PLATFORM_NAME from sys.DBA_REGISTRY_DATABASE;
PLATFORM_NAME
-------------------------------------------------------------
Linux x86 64-bit

Regards
Michel
Re: ORA-03001: unimplemented feature [message #581146 is a reply to message #581144] Tue, 02 April 2013 07:58 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
Michel Cadot wrote on Tue, 02 April 2013 07:53
SQL> select PLATFORM_NAME from sys.DBA_REGISTRY_DATABASE;
PLATFORM_NAME
-------------------------------------------------------------
Linux x86 64-bit

Regards
Michel


The same for me, but an error when no space between ' and " ...
If I add a space, it's OK
I don't understand ... Sad
Re: ORA-03001: unimplemented feature [message #581148 is a reply to message #581146] Tue, 02 April 2013 08:10 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
fladehis wrote on Tue, 02 April 2013 08:58
Michel Cadot wrote on Tue, 02 April 2013 07:53
SQL> select PLATFORM_NAME from sys.DBA_REGISTRY_DATABASE;
PLATFORM_NAME
-------------------------------------------------------------
Linux x86 64-bit

Regards
Michel


The same for me, but an error when no space between ' and " ...
If I add a space, it's OK


Prove it. Show us a complete test of both ways.
Re: ORA-03001: unimplemented feature [message #581149 is a reply to message #581148] Tue, 02 April 2013 08:17 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
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>
Re: ORA-03001: unimplemented feature [message #581150 is a reply to message #581149] Tue, 02 April 2013 08:31 Go to previous messageGo to next message
fladehis
Messages: 7
Registered: April 2013
Junior Member
I found something !

If cursor_sharing database parameter = exact, select without space is OK !
If cursor_sharing database parameter = force, select without space is KO !

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
Re: ORA-03001: unimplemented feature [message #581151 is a reply to message #581150] Tue, 02 April 2013 08:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Well, that is a surprise. I get the same result, by the way.

But if I use a bind variable explicitly, no problem:
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>
Very odd. A bug in the re-write mechanism, perhaps?
Re: ORA-03001: unimplemented feature [message #581152 is a reply to message #581150] Tue, 02 April 2013 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is ALSO your client is 10.2 (and not 11.2); if you use a 11.2 client you have not this problem whatever is the used syntax.

Note: the cursor sharing problem is well-known in previous versions. This is one more reason to never use cursor sharing FORCE.

Regards
Michel
icon14.gif  Re: ORA-03001: unimplemented feature [message #581153 is a reply to message #581152] Tue, 02 April 2013 08:59 Go to previous message
fladehis
Messages: 7
Registered: April 2013
Junior Member
Michel Cadot wrote on Tue, 02 April 2013 08:46
Note: the cursor sharing problem is well-known in previous versions. This is one more reason to never use cursor sharing FORCE.

Indeed ! I will refer to my DBA because we used cursor sharing EXACT until now. So I don't know why it's has been changed in our ORACLE11 new environnement.

Thank you for your answers !
Previous Topic: Can Oracle always guarrantee the data consistent in a distributed transaction?
Next Topic: Problem with RAW datatype
Goto Forum:
  


Current Time: Fri Mar 29 02:41:18 CDT 2024