qq_29520277的博客

1、停止数据库SQL> shutdown immediate; 2、启动数据库mount，SQL> startup mount SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; 3、启动数据库SQL> alter database ope

exec dbms_workload_repository.create_snapshot; @?/rdbms/admin/awrrpt@?/rdbms/admin/ashrpt.sql@?/rdbms/admin/addmrpt.sqlshutdown immediatestartuplsnrctl stoplsnrctl startlsnrctl statusps -ef|grep test|grep LOCAL=NO|grep -v grep|awk '{print "

1、 查询数据文件存放路径select file_name from dba_data_files;2、 创建临时表空间:BKJ_TEMPcreate temporary tablespace BKJ_TEMPtempfile 'E:\APP\ADMINISTRATOR\ORADATA\BDCQZK22\BKJ_TEMP_01.dbf' size 100m autoextend on next 100m MAXSIZE UNLIMITEDextent management local;