#acl merlyn:read,write All:read = 中烟 = == ZYQAS == {{{ mkdir /oracle/ECP/sapdata4/sr3_27 mkdir /oracle/ECP/sapdata4/sr3_28 ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_27/sr3.data27' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_28/sr3.data28' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; }}} * kill dead session {{{ SELECT '' || sid || ',' || serial# || '''; ' || sql_id death FROM v$session; SELECT 'alter system kill session ''' || sid || ',' || serial# || '''; ' || sql_id death FROM v$session; }}}