摘要： 1. 用下面的语句找到trace文件的路径select * from v$diag_info where name='Default Trace File';2. 创建一个directory用来加载trace文件create or replace directory tracefile as '/u... 阅读全文

摘要： use masterIF EXISTS (SELECT * FROM sys.databasesWHERE name = 'gpdb83sp')BEGINDROP DATABASE gpdb83spEND;CREATE DATABASE gpdb83spON( NAME = gpdb83sp_dat... 阅读全文

摘要： There are three DMVs you can use to track tempdb usage:sys.dm_db_task_space_usagesys.dm_db_session_space_usagesys.dm_db_file_space_usageThe first two ... 阅读全文