Timeline for About Oracle SGA architecture
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 4, 2021 at 23:08 | comment | added | William Robertson | The buffer cache is a resource available to any cursor, regardless of whether the cursor itself is cached or not. They are separate mechanisms. btw "result cache" is something different. | |
| Oct 4, 2021 at 12:32 | history | edited | miracle173 | CC BY-SA 4.0 |
deleted 1 character in body
|
| Oct 4, 2021 at 12:28 | vote | accept | Silent Boots | ||
| Oct 4, 2021 at 12:18 | comment | added | Silent Boots | this may sound stupid but does the server process access the datablock in buffer cache /datafile when we use parsed sql statement stored in library cache? i assume we acces the datablock since the server process need to return the result to user process | |
| Oct 4, 2021 at 12:02 | comment | added | Andrew Sayer | The SQL needs to be identical (including white space and casing) in order to use the same cursor. The result cache would need the same inputs and needs to be enabled to be used. It’s mostly not used in reality as the buffer cache will be doing a lot of the work for you and result cache invalidation is a pain. | |
| Oct 4, 2021 at 11:52 | comment | added | Silent Boots | so you saying both session need to use bind variable in order for my sql statement to use the parsed sql statement stored in the library cache by the previous executed sql statement? also since the result is different does that mean my sql statement doesn use the result cache? | |
| Oct 4, 2021 at 11:32 | history | answered | Andrew Sayer | CC BY-SA 4.0 |