Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data Guard - unapplied log at Primary

Azhar MZAug 17 2015 — edited Aug 19 2015

Data Guard

==========

when i run

select count(*) from v$archived_log where applied = 'NO' on the primary I got more than 3000 results.

on the standby I only got one (but that another issue I'm trying to solve with Oracle support).

is this normal or what? its one thing on a new database you install for study, but its another thing on a database that has been running for a long time and I only recently introduced to it.

one thing for sure is that the archive log is shipped to standby, and applied real time. and also switch over are fine (SUCCESS). querying in data guard manager also gives success, but wan't the right answer is '0' or no row selected, right?

Thanks.
This post has been answered by Pini Dibask on Aug 17 2015
Jump to Answer

Comments

EJP
Since I set max heap size as 2 GB, the resident memory of the java application should be less than 2.5 GB ( Max Heap + Jars Memory + VM Memory ).
Only if you assume the latter two items take up <= 0.5GB each. Do they?
868448
EJP wrote:
Since I set max heap size as 2 GB, the resident memory of the java application should be less than 2.5 GB ( Max Heap + Jars Memory + VM Memory ).
Only if you assume the latter two items take up <= 0.5GB each. Do they?
I am not 100% sure. Just gave worst case assumption. If my code base/jar is high, I should get java.lang.OutOfMemoryError: PermGen space. right ? Do you have any idea ?
802316
What is your maximum direct memory? By default its the same as the heap memory maximum. This can give you a maximum size of 2 GB (heap) + 2 GB (direct) + 0.5 - 1.0 GB for the rest.

BTW: I would try updating your JVM, it is 10 updates behind current.

If you do that, something which can reduce memory consumption without too much overhead is -XX:+UseCompressedOops and -XX:+UseCompressedStrings
1 person found this helpful
EJP
I am not 100% sure. Just gave worst case assumption.
No you didn't. It isn't a 'worst case assumption'. It's just a guess. The true figure might be higher. That's my point. In this case obviously something is a lot higher. The current case is worse than your 'worst case'.
If my code base/jar is high, I should get java.lang.OutOfMemoryError: PermGen space. right?
Among other possibilities. But there is also the question of how much memory the JVM itself needs.
JRK wrote:
....without throwing OutOfMemory error.
...
Can you please help me to solve this issue ? Kindly let me know, if you require any other information.
What is the "issue" exactly?

Since there is no OOM that certainly isn't the issue.
So explain in detail why you think what you are seeing is a problem - specifically what impact it is going to have.
868448
Thanks to all for your help.
No you didn't. It isn't a 'worst case assumption'. It's just a guess.
Yes. It is just a guess not worst case assumption.
jschell wrote:
JRK wrote:
....without throwing OutOfMemory error.
...
Can you please help me to solve this issue ? Kindly let me know, if you require any other information.
What is the "issue" exactly?

Since there is no OOM that certainly isn't the issue.
So explain in detail why you think what you are seeing is a problem - specifically what impact it is going to have.
My server m/c has 8 GB RAM and I am running 2 instance of my java application in that m/c. Since each instance of memory goes to 4 GB, the m/c is not reachable. Because no more memory is available for open ssh session.
What is your maximum direct memory? By default its the same as the heap memory maximum. This can give you a maximum size of 2 GB (heap) >+ 2 GB (direct) + 0.5 - 1.0 GB for the rest.
I didn't mention anything. So it should be default ( 2GB). Thanks Peter Lawrey. Now, I understand that, the memory wiIl go upto 5GB in my case.

Thanks,
Ramesh
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 14 2015
Added on Aug 17 2015
#data-guard, #performance-availability
6 comments
4,309 views