设置sql trace报SP2-0575错误

参看asktom

如果报此错误

set flagger off

Have set up autotrace with no problems. when I try to designate the execution plan report I get the following error: SQL> set autotrace on explain SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level. the documentation explains/action: SP2-0575 Use of Oracle SQL feature not in SQL92 Entry |Intermediate|Full Level Cause: A SQL statement was attempted that is not FIPS compliant. This error may also occur if a SQL*Plus feature, for example SET AUTOTRACE, that uses SQL specific to Oracle was turned on when using FIPS flagging. Action: Use SET FLAGGER, and turn FIPS compliance checking OFF, or rewrite the statement can you explain what this is and how to correct. thanks Followup   June 9, 2004 - 11am UTC: ops$tkyte@ORA9IR2> show flagger flagger OFF ops$tkyte@ORA9IR2> set autotrace on ops$tkyte@ORA9IR2> set autotrace off ops$tkyte@ORA9IR2> set flagger Usage: SET FLAGGER { OFF | ENTRY | INTERMEDIATE | FULL } ops$tkyte@ORA9IR2> set flagger full ops$tkyte@ORA9IR2> set autotrace on SP2-0575: Use of Oracle SQL feature not in SQL92 Full Level. ops$tkyte@ORA9IR2> it is the "fips flagger", something ANSI compliant databases are supposed to have in order to be compliant. it disallows "non standard" commands.