OraFAQ Forum: Training & Certification » I need help on pinned, clean, dirty and free buffers

Home » Other » Training & Certification » I need help on pinned, clean, dirty and free buffers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I need help on pinned, clean, dirty and free buffers [message #301164]

Tue, 19 February 2008 06:46

deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria

Junior Member

can anyone please explain to me in simple words what these buffers are? Thanks

Report message to a moderator

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

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Have you made any attempt to search, or read the documentation?

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read Database Concepts (I am tired to post links so search for it).

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

deleoloruntoba
Messages: 5
Registered: February 2008
Location: Nigeria

Junior Member

thanks

Report message to a moderator

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

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???

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 23 11:11:38 CDT 2025