¹ØÓÚOracle Êý¾Ý¿â

ÔÚ http£º//localhost£º1158/em Öд´½¨±í¿Õ¼äµÄ²½Öè

---

²Î¿¼£º
http://school.itzcn.com/special-spid-50.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£

---

²Î¿¼ÏÂÒÔÏÂ×ö·¨
http://www.wljcz.com/html/shujuku/Oracle/2009/1119/2038.html
Èç¹û¿ÉÒԵĻ°£¬ÓÃsql´´½¨£º
1.´´½¨½ÇÉ«
CREATE ROLE "INSIGHTCN" NOT IDENTIFIED;

GRANT "CONNECT" TO "INSIGHTCN";
GRANT "DBA" TO "INSIGHTCN";
GRANT "RESOURCE" TO "INSIGHTCN";

2.´´½¨±í¿Õ¼ä
CREATE SMALLFILE TABLESPACE "POINT_DB" DATAFILE '/opt/oracle/oradata/insight/point_db' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'POINT_DB'); END;

CREATE SMALLFILE TEMPORARY TABLESPACE "POINT_DB_TEMP" TEMPFILE '/opt/oracle/oradata/insight/point_db_temp' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'POINT_DB_TEMP'); END;

3.´´½¨Óû§
create user POINT
  identified by "POINT"
  default tablespace POINT_DB
  temporary tablespace POINT_DB_TEMP
  profile DEFAULT
  AC