Environment information:
* Oracle version:
* Operating system:
Hello, how are you?
I am studying Oracle 10g, and I have a little difficulty in practicing what the PGA function and what part she is involved in the bank administration, I have seen many concepts more I would like to know what importance Her at the bank? And what top views she has. Grateful for the attention.
What is PGA?
-
elidias7
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Oracle Certified Professional
Hello, how are you!
Then the PGA is practically a home memory space section that makes connection in the database when the server is working in dedicated mode.
When a PGA is supplied to a connection, it will contain information about that user, a private area of ??Query's that the user executed, area for the cursors, an area for data rating etc.
Then you have seen the importance she has pro bank, right !! rs
There are two ways to work with the PGA that is in automatic and manual mode, Automatic Oracle Takes care of all your areas and does the sizing of each area when necessary to a value that you set for the PGA_AGEGATTE_TARGET parameter (I think that's how it writes), or otherwise the DBA manages the values.
All parameters * area_size belong to PGA and main views to check information about PGA are v $ pgastat and v $ pga_target_advice.
I recommend you take a look at Oracle documentation to better understand this better memory area, but I hope I have helped.
Hugs,
Then the PGA is practically a home memory space section that makes connection in the database when the server is working in dedicated mode.
When a PGA is supplied to a connection, it will contain information about that user, a private area of ??Query's that the user executed, area for the cursors, an area for data rating etc.
Then you have seen the importance she has pro bank, right !! rs
There are two ways to work with the PGA that is in automatic and manual mode, Automatic Oracle Takes care of all your areas and does the sizing of each area when necessary to a value that you set for the PGA_AGEGATTE_TARGET parameter (I think that's how it writes), or otherwise the DBA manages the values.
All parameters * area_size belong to PGA and main views to check information about PGA are v $ pgastat and v $ pga_target_advice.
I recommend you take a look at Oracle documentation to better understand this better memory area, but I hope I have helped.
Hugs,
It helped a lot ... I'm already understanding what she does .. not in the view of a database administrator what data are interesting is accompanying in the PGA ...?
I'll look for the documentation .. Again, thank you!
I'll look for the documentation .. Again, thank you!
-
elidias7
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Oracle Certified Professional
Oops!
not wanting to be boring but there is no way to help you in this way, because I will write a huge text again! Rsrs
I recommend this document Oracle's memory architecture
http://download.oracle.com/docs/cd/B193 ... htm#i14490
Hugs,
not wanting to be boring but there is no way to help you in this way, because I will write a huge text again! Rsrs
I recommend this document Oracle's memory architecture
http://download.oracle.com/docs/cd/B193 ... htm#i14490
Hugs,
-
- Information
-
Who is online
Users browsing this forum: Bing [Bot] and 1 guest