Oracle清缓存

最新推荐文章于 2024-08-12 21:26:55 发布

nkhuangyanping

最新推荐文章于 2024-08-12 21:26:55 发布

阅读量2.8k

点赞数 1

分类专栏：学习积累文章标签： Oracle 缓存

本文链接：https://blog.csdn.net/nkhuangyanping/article/details/41700259

版权

学习积累专栏收录该内容

7 篇文章 0 订阅

订阅专栏

打开sqlsplus.exe，一般在D:\oracle\product\10.2.0\db_1\BIN路径下

1、首先输入用户名密码连接数据

Enter user-name: conn /as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

2、再次连接
SQL> conn /as sysdba
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance

3、输入命令清理

SQL> alter system flush shared_pool;
System altered.

SQL> alter system flush buffer_cache;
System altered.