Manju 'Oracle DBA'

ORACLE "Advanced Search Begins"

Tuesday, 8 October 2013

How to clear /flush buffer_cache;



SQL> clear buffer;
buffer cleared

SQL> alter system flush buffer_cache;

System altered.


SQL> alter system flush shared_pool;

System altered.



SQL> purge dba_recyclebin;

DBA Recyclebin purged.
Posted by Unknown at 00:25
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

V$ Pageviews

Blog Archive

  • ▼  2013 (108)
    • ►  10/20 - 10/27 (8)
    • ►  10/13 - 10/20 (1)
    • ▼  10/06 - 10/13 (8)
      • How to clear /flush buffer_cache;
      • How to check block corruption in oracle;
      • Step by step clone of an oracle database using RMAN
      • How to determine whether a table is used to store ...
      • How to get the explain plan in oracle
      • How to find out which user is running what sql que...
      • How to use sqlplus SPOOL command:
      • How to find out expected time of completion for an...
    • ►  08/18 - 08/25 (1)
    • ►  08/11 - 08/18 (3)
    • ►  07/28 - 08/04 (2)
    • ►  07/21 - 07/28 (3)
    • ►  07/14 - 07/21 (1)
    • ►  07/07 - 07/14 (1)
    • ►  06/23 - 06/30 (2)
    • ►  06/16 - 06/23 (1)
    • ►  06/09 - 06/16 (1)
    • ►  06/02 - 06/09 (8)
    • ►  05/26 - 06/02 (1)
    • ►  05/19 - 05/26 (1)
    • ►  05/12 - 05/19 (7)
    • ►  04/28 - 05/05 (20)
    • ►  04/21 - 04/28 (20)
    • ►  03/17 - 03/24 (19)

Search This Blog

ORACLE DBA THIRST

Unknown
View my complete profile

$ Views

Awesome Inc. theme. Powered by Blogger.