| Patch Oracle 10.2.0.2 to 10.2.0.4, consume high memory [message #400983] |
Thu, 30 April 2009 21:43  |
kay_lee
Messages: 4
Registered: April 2009
Location: earth
|
Junior Member |
|
|
Hi all,
Can anyone share any experience on patching Oracle 10.2.0.2 to 10.2.0.4? I have a trouble here...
Looks like something's wrong with my server after the patching.
I follow up all the instruction from the ReadMe file during the patching process.
The Oracle consume a very high memory, more than usual(before patch).
What i suspect is.. the parameter db_file_scattered_read is high, so high...
Can anybody tell me, what to do??
Thanks
Kay
|
|
|
|
|
|
| Re: Patch Oracle 10.2.0.2 to 10.2.0.4, consume high memory [message #400988 is a reply to message #400984] |
Thu, 30 April 2009 23:21  |
kay_lee
Messages: 4
Registered: April 2009
Location: earth
|
Junior Member |
|
|
The memory before patch was only reached highest of 20%, now it's average 40%. I'm using Solaris 10.
The server had more than 5 Oracle instances, all upgraded.
And any query(select, insert, update) gives result slower than before, about 3 times slower, for the same query, usually 5 seconds, now 1 minutes and 30 seconds.
A procedure that used to run in 30 minutes, now at least need 1 hour to complete. Same procedure, same amount of data.
Nothing's wrong with the I/O of the OS.
I've tuned the database, rebuild indexes, analyzed all objects, but it still consume high memory, and works slow.
Here is what i concerned of :
db file scattered read
1st | 2st | %diff
0.00 | 36.15 | 36.15
0.00 | 215.75 | 100.00
0.23 | 1.41 | 513.04
db file sequential read
1st | 2st | %diff
32.00 | 6.84 | -25.17
805.14 | 67.78 | -91.58
0.13 | 0.85 | 553.85
Description :
1st --> before patch
2st --> after patch
ADDITIONAL INFORMATION
----------------------
Wait class "Application" was not consuming significant database time.
Wait class "Commit" was not consuming significant database time.
Wait class "Concurrency" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
CPU was not a bottleneck for the instance.
Wait class "Network" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.
The database's maintenance windows were active during 35% of the analysis
period.
The analysis of I/O performance is based on the default assumption that the
average read time for one database block is 10000 micro-seconds.
Thank you in advance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Patch Oracle 10.2.0.2 to 10.2.0.4, consume high memory [message #406593 is a reply to message #400983] |
Thu, 04 June 2009 15:38 |
dswilson
Messages: 4
Registered: June 2009
|
Junior Member |
|
|
The initial tuning stuff I have outlined memory and IO as issues. I adjusted the SGA and PGA
settings and that is not a problem. I did a complete defrag of the disk to reduce lookup time
in that regard, but once the data is cached in memory that shouldn't come into play.
The application I'm using is web based mapping. A query is done to determine if any object
under the mouse cursor should display a tooltip.
My tooltips (initially only 4 sec on 10.2.0.1) went to about 16-20sec with 10.2.0.4
and to 28 sec while the tuning snapshot was taken.
The only recommendation that came up was in regards to a similar query as before:
select nt_na_link_roundabout_fc5.featid,
nt_na_link_roundabout_fc5.name,
nt_na_link_roundabout_fc5.primaryind,
nt_na_link_roundabout_fc5.url,
nt_na_link_roundabout_fc5.sdf_id,
nt_na_link_roundabout_fc5.sdf_name,
nt_na_link_roundabout_fc5.sdf_url,
nt_na_link_roundabout_fc5.geometry from
nt_na_link_roundabout_fc5 where ( sdo_relate
( nt_na_link_roundabout_fc5.geometry, :spatialfilter1,
'MASK=ANYINTER...
ORA-29900: operator binding does not exist ORA-06553: PLS-306:
wrong number or types of arguments in call to 'SDO_RELATE'
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
