Home » Other » Training & Certification » I need help on pinned, clean, dirty and free buffers
I need help on pinned, clean, dirty and free buffers [message #301164] Tue, 19 February 2008 06:46 Go to next message
deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria
Junior Member

can anyone please explain to me in simple words what these buffers are? Thanks
Re: I need help on pinned, clean, dirty and free buffers [message #301167 is a reply to message #301164] Tue, 19 February 2008 07:07 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Have you made any attempt to search, or read the documentation?
Re: I need help on pinned, clean, dirty and free buffers [message #301190 is a reply to message #301164] Tue, 19 February 2008 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Database Concepts (I am tired to post links so search for it).

Regards
Michel
Re: I need help on pinned, clean, dirty and free buffers [message #301467 is a reply to message #301167] Wed, 20 February 2008 14:51 Go to previous messageGo to next message
deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria
Junior Member

yes i have but it seems i need to hear concise and easier to understand words.
Re: I need help on pinned, clean, dirty and free buffers [message #301585 is a reply to message #301467] Thu, 21 February 2008 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pinned buffers: buffers that are pinned (in use)
Clean buffers: buffers that are clean (not modified)
Dirty buffers: buffers that are dirty (modified)
Free buffers: buffers that are free (free)

Simple words, doesn't it?

Regards
Michel
Re: I need help on pinned, clean, dirty and free buffers [message #301605 is a reply to message #301585] Thu, 21 February 2008 02:37 Go to previous messageGo to next message
deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria
Junior Member

oohh u re the BOMB! Thanks a great deal! Now i understand. Razz
So the difference betwen clean bufferes and free buffers is that, Clean buffers were used only once and free buffers havnt been used before. Right???

[Updated on: Thu, 21 February 2008 02:39]

Report message to a moderator

Re: I need help on pinned, clean, dirty and free buffers [message #301611 is a reply to message #301605] Thu, 21 February 2008 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Clean buffers are buffers that have been dirty (modified) but have been flushed onto disk by DBWR. So there are available to be reused.
Free buffers are buffers that are not currently in use.
A clean buffer can be free (not in use, available) or pinned (in use).

Regards
Michel
Re: I need help on pinned, clean, dirty and free buffers [message #301618 is a reply to message #301611] Thu, 21 February 2008 03:13 Go to previous messageGo to next message
deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria
Junior Member

thanks
Re: I need help on pinned, clean, dirty and free buffers [message #303775 is a reply to message #301611] Sun, 02 March 2008 16:03 Go to previous messageGo to next message
deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria
Junior Member

Some other help please...
A table space in a database is said to be a logical storage unit which contains related logical structures.
please i need to know... what are the examples of logical structures spoken about here? extents and stuff???
Re: I need help on pinned, clean, dirty and free buffers [message #303813 is a reply to message #303775] Sun, 02 March 2008 23:12 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 1 Introduction to the Oracle Database
Section Oracle Database Architecture
Subsection Overview of Logical Database Structures

Regards
Michel
Previous Topic: What is Problem with DAte Query
Next Topic: SQL and PL/SQL 1Z0-001 or other to start with?
Goto Forum:
  


Current Time: Sun Dec 04 00:08:09 CST 2016

Total time taken to generate the page: 0.13043 seconds