My readings

All posts relating to Oracle database administration.

Moderator: Tim...

Re: My readings

Postby Tim... » Thu Sep 19, 2013 5:25 pm

Hi.

That second diagram certainly show that, but I think they've done it that way because of the limited space on the diagram. Suffice to say, this is not the case.

It is the server process that is interacting with the SGA. That fact that the PGA is an integral part of the server process function is a different matter. The situation is complicated further in 11gR2, as full table scans can bypass the buffer cache completely and be read directly from the data files into the PGA without ever going through the buffer cache.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby Tim... » Thu Sep 19, 2013 5:59 pm

Hi.

The 12c diagram is a little clearer in this respect.

http://www.oracle.com/webfolder/technet ... oster.html

On the Database Architecture tab you will see the Server Process is linked to the SGA (through TMON, new process in 12c), but there is no link between the PGA and the SGA.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Thu Sep 19, 2013 6:28 pm

Respected Sir,

its tremandous, Really, I came to know by looking 12c picture.

I can conclude that the PGA is an integral part of the server process function. I will follow to read further.

Thanks

Anil Kumar.
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Thu Sep 19, 2013 6:39 pm

Sir,

I had gone through Oracle database concepts E17633-20 pdf 12c.1, but in that document old picture is explained.

Why oracle is not updating thier document with latest pictures. Where can I get the document related to release 12c.1 database architecture diagram, which you had sent just now..

Thanks & Regards,

Anil Kumar.
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Thu Sep 19, 2013 7:24 pm

Hi.

I've not seen that 12c diagram in any document from the Oracle manuals.

Actually, it probably makes sense not to show that in the normal documentation, because the complexity detracts from the message. The 11g and 12c diagram i the documents are basically correct. They show how the server process interacts to the get the work done. Many of the extra processes server a very specific purpose, which is incidental to the bulk of what Oracle does. Adding it is more likely to confuse than help understanding.

You should focus on the basic core elements of how Oracle does what it does. The concepts document gives you that. Once you've mastered that you can worry about all the other features and processes that support them. Nobody would seriously expect you do describe that big diagram. I wouldn't have a clue how to describe many of the processes under interview conditions. The basic concepts are what count first.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Thu Sep 19, 2013 7:34 pm

OK Sir,

I will go through the basic documentation. And read it thoroughly, once I mastered I will go through advanced documentations.

Thanks for giving support. I will read and tomorrow I will contact you if any doubts.

Good night

Thanks

Anil Kumar.
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Fri Sep 20, 2013 1:43 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Mon Sep 23, 2013 3:53 pm

Sir,

I am referring Oracle Manuals with related to stages in SQL processings such as parsing, optimization, row source generation, execution. But the reference has given only just oulook. I need complete detailed information of SQL processings for all statements such as DDL, DML, TCL etc. and How oracle internals processing complete information I required. If you any idea on theses topics / site links, or any material, could you please provide or guide me how can I obtain information regarding this. Awaiting your reply...


Thanks & Regards,
Anil Kumar
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Mon Sep 23, 2013 9:09 pm

Hi.

You don't need a great level of detail at this point. You should learn the basics of everything, then dig down to a greater level of detail as you get comfortable with the basics. Focus on the basics first. You can be a very good DBA without knowing this level of detail.

Once you have a good range of DBA skills, you can start looking at some things in more detail.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Tue Sep 24, 2013 10:14 am

OK Sir,

I will be go through basics.

Thanks & Regards

Anil Kumar.
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Tue Sep 24, 2013 3:57 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Wed Sep 25, 2013 4:34 pm

Sir,

Today I have gone through Instance Architecture and how we can shut down, startup instance etc. Its clear.

I will update whatever I read in manuals...

Thaks & Regards,

Anil Kumar
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Wed Sep 25, 2013 4:58 pm

OK.

This thread is getting rather large. Maybe you should create a new thread the next time you have a question, giving a title relevant to the question. Remember, one of the cool things about forums is other people can find the answers to questions via a search, so if the title and subject of the questions are clear, the answer may actually help multiple people, not just you. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: My readings

Postby anilvvkumar » Wed Sep 25, 2013 5:01 pm

OK Sir,

I will open new thread.

Thanks & Regards

Anil Kumar
anilvvkumar
Member
 
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby Tim... » Wed Sep 25, 2013 11:16 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Previous

Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 5 guests