中烟
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;
SELECT '' || sid || ',' || serial# || '''; ' || sql_id death FROM v$session;
SELECT 'alter system kill session ''' || sid || ',' || serial# || '''; ' || sql_id death FROM v$session;
