\u5ba2\u6237\u73af\u5883\u4e0b\u8bbe\u7f6e\u4e86AUTOTRACE\uff0c\u7ed3\u679c\u78b0\u5230\u4e86ORA-3212\u9519\u8bef\u3002
\n\u8be6\u7ec6\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n
SQL> conn \/ as sysdba\r\nSQL> grant select on v_$session to posmrk;\r\nGrant succeeded.\r\nSQL> grant select on v_$mystat to posmrk;\r\nGrant succeeded.\r\nSQL> grant select on v_$statname to posmrk;\r\nGrant succeeded.\r\nSQL> CONN POSMRK \r\nEnter password: \r\nConnected.\r\nSQL> @?\/rdbms\/admin\/utlxplan\r\nTable created.\r\nSQL> conn posmrk@219.143.210.210:1621\/pcmrk\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> set autot trace\r\nSQL> select * from dual;\r\nError ORA-942 while gathering statistics\r\nSP2-0612: Error generating AUTOTRACE report\r\nSP2-0612: Error generating AUTOTRACE report\r\nExecution Plan\r\n----------------------------------------------------------\r\nAn uncaught error happened in fetching the records : ORA-03212: Temporary Segment cannot be created in locally-managed tablespace\r\nORA-03212: Temporary Segment cannot be created in locally-managed tablespace\r\nSP2-0612: Error generating AUTOTRACE STATISTICS report<\/pre>\n\u7531\u4e8e\u5f53\u65f6\u6ca1\u6709\u7f51\u7edc\u548c\u6587\u6863\uff0c\u53ea\u80fd\u6839\u636e\u9519\u8bef\u63cf\u8ff0\u6765\u5206\u6790\u95ee\u9898\u3002\u8fd9\u4e2a\u9519\u8bef\u4f3c\u4e4e\u548c\u8868\u7a7a\u95f4\u4ee5\u53ca\u4e34\u65f6\u6bb5\u6709\u5173\uff0c\u90a3\u4e48\u95ee\u9898\u7275\u626f\u7684\u5c42\u9762\u5e76\u4e0d\u592a\u591a\u3002
\n\u68c0\u67e5\u4e86\u4e00\u4e0b\u6570\u636e\u5e93\u7684\u4e34\u65f6\u8868\u7a7a\u95f4\u8bbe\u7f6e\uff0c\u5e76\u672a\u53d1\u73b0\u95ee\u9898\uff0c\u68c0\u67e5\u4e86\u4e00\u4e0b\u7528\u6237\u7684\u8868\u7a7a\u95f4\u4ee5\u53caUNLIMITED TABLESPACE\u6743\u9650\uff0c\u4e5f\u672a\u53d1\u73b0\u5f02\u5e38\u3002<\/p>\n
SQL> conn system\r\nConnected.\r\nSQL> set autot trace \r\nSQL> select * from dual;\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 272002086\r\n--------------------------------------------------------------------------\r\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |\r\n--------------------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |\r\n| 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |\r\n--------------------------------------------------------------------------\r\nStatistics\r\n----------------------------------------------------------\r\n 0 recursive calls\r\n 0 db block gets\r\n 3 consistent gets\r\n 0 physical reads\r\n 0 redo size\r\n 407 bytes sent via SQL*Net to client\r\n 400 bytes received via SQL*Net from client\r\n 2 SQL*Net roundtrips to\/from client\r\n 0 sorts (memory)\r\n 0 sorts (disk)\r\n 1 rows processed\r\nSQL> set autot off<\/pre>\n\u5207\u6362\u4e3a\u5176\u4ed6\u7528\u6237\uff0c\u6ca1\u6709\u53d1\u73b0\u5f02\u5e38\uff0c\u8bf4\u660e\u5e94\u8be5\u662f\u9519\u8bef\u7528\u6237\u672c\u8eab\u7684\u8bbe\u7f6e\u6240\u81f4\u3002<\/p>\n
SQL> select username, temporary_tablespace \r\n 2 from dba_users\r\n 3 where username = 'POSMRK';\r\nUSERNAME TEMPORARY_TABLESPACE\r\n------------------------ -----------------------------\r\nPOSMRK SYSTEM\r\nSQL> alter user posmrk temporary tablespace temp;\r\nUser altered.\r\nSQL> conn posmrk \r\nConnected.\r\nSQL> set autot trace\r\nSQL> select * from dual;\r\nError ORA-942 while gathering statistics\r\nSP2-0612: Error generating AUTOTRACE report\r\nSP2-0612: Error generating AUTOTRACE report\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 272002086\r\n--------------------------------------------------------------------------\r\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |\r\n--------------------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |\r\n| 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |\r\n--------------------------------------------------------------------------\r\nSP2-0612: Error generating AUTOTRACE STATISTICS report<\/pre>\n\u68c0\u67e5\u7528\u6237\u7684\u4e34\u65f6\u8868\u7a7a\u95f4\u8bbe\u7f6e\uff0c\u53d1\u73b0\u9519\u8bef\u7684\u8bbe\u7f6e\u4e3aSYSTEM\uff0c\u663e\u7136\u8fd9\u65f6\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\uff0c\u4eceSYSTEM\u8868\u7a7a\u95f4\u8f6c\u53d8\u4e3aLOCAL\u7ba1\u7406\u65b9\u5f0f\u4ee5\u540e\uff0c\u5c31\u4e0d\u5e94\u8be5\u8bbe\u7f6eSYSTEM\u4f5c\u4e3a\u4e34\u65f6\u8868\u7a7a\u95f4\u4e86\uff0c\u800c\u5e94\u8be5\u4f7f\u7528\u4e13\u95e8\u7684TEMPORARY\u8868\u7a7a\u95f4\u3002
\n\u5bf9\u8fd9\u4e2a\u8bbe\u7f6e\u8fdb\u884c\u4fee\u6539\u540e\uff0cORA-3212\u9519\u8bef\u5df2\u7ecf\u5c0f\u65f6\uff0c\u8fd8\u5b58\u5728\u4e00\u4e2aORA-942\u9519\u8bef\uff0c\u8fd9\u4e2a\u9519\u8bef\u4ee5\u524d\u78b0\u5230\u8fc7\uff0c\u5e94\u8be5\u662f\u7f3a\u5c11\u52a8\u6001\u89c6\u56fe\u7684\u6743\u9650\u6240\u81f4\uff1a<\/p>\n
SQL> set autot off\r\nSQL> select table_name, privilege from user_tab_privs where table_name like 'V_$%';\r\nTABLE_NAME PRIVILEGE\r\n------------------------------ -----------------------------------------------\r\nV_$SESSION SELECT\r\nV_$MYSTAT SELECT\r\nV_$STATNAME SELECT\r\nSQL> conn \/ as sysdba\r\nConnected.\r\nSQL> grant select on v_$sesstat to posmrk;\r\nGrant succeeded.\r\nSQL> conn posmrk\r\nConnected.\r\nSQL> set autot trace\r\nSQL> select * from dual;\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 272002086\r\n--------------------------------------------------------------------------\r\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |\r\n--------------------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |\r\n| 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |\r\n--------------------------------------------------------------------------\r\nStatistics\r\n----------------------------------------------------------\r\n 0 recursive calls\r\n 0 db block gets\r\n 3 consistent gets\r\n 0 physical reads\r\n 0 redo size\r\n 407 bytes sent via SQL*Net to client\r\n 400 bytes received via SQL*Net from client\r\n 2 SQL*Net roundtrips to\/from client\r\n 0 sorts (memory)\r\n 0 sorts (disk)\r\n 1 rows processed\r\nSQL> set autot off<\/pre>\n\u521a\u5f00\u59cb\u6388\u6743\u7684\u65f6\u5019\uff0c\u6388\u6743\u4e86V_$SESSION\u6743\u9650\u800c\u7f3a\u5c11\u4e86V_$SESSTAT\u89c6\u56fe\u7684\u6743\u9650\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u4ea7\u751f\uff0c\u5bf9\u89c6\u56fe\u6388\u6743\u540e\uff0c\u95ee\u9898\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u73af\u5883\u4e0b\u8bbe\u7f6e\u4e86AUTOTRACE\uff0c\u7ed3\u679c\u78b0\u5230\u4e86ORA-3212\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u5982\u4e0b\uff1a SQL> conn \/ as sysdba SQL> grant select on v_$session to posmrk; Grant succeeded. SQL> grant select on v_$mystat to posmrk; Grant succeeded. SQL> grant select on v_$statname to posmrk; Grant succeeded. SQL> CONN POSMRK Enter password: Connected. … Continue reading