Skip to Main Content

DevOps, CI/CD and Automation

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!

Java Logging Settings not holding

0e1a6e04-3f6a-400a-9265-1d3ed08b70deNov 2 2018 — edited Nov 2 2018

Hello Everyone, I have a question about logging. I am not a Java developer but we have Java in our Citrix environment on Windows 2008 servers. We have been asked by the application team to turn on logging by going to the java control panel and under the Advanced tab, checking off the boxes for Enable Logging and Enable Tracing. We are connecting in via Remote Desktop to make the change. But when we log out and then back in to check to make sure logging is enabled, both boxes are unchecked. I've tried to find out if there maybe is a registry setting associated with the logging but could not find anything. Other changes to applications stay that way if we log out so there is no overriding policy that removes changes. The application team is at a loss to explain why we are seeing this and we see it on all servers we attempt this on. I was wondering if someone would be able to tell us why this is happening as this is new to us. Thank you and have a good weekend.

Comments

Nikolay Savvinov
Hi,

1) unless index is in an invalid or unusable state, it is very unlikely that it would ever need a rebuild
http://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf

2) ANALYZE is obsolete, don't use it anymore
3) DBMS_STATS is the way to go (you don't necessarily have to call GATHER_INDEX_STATS explicitly, you can also use CASCADE=>true option in GATHER_TABLE_STATS)

Best regards,
Nikolay
user4295847
Thank for your reply.

Please explain me Index Rebuild ONLINE
and what is the functionality for the DBMS_STATS.GATHER_INDEX and when we need to use ?
unknown-698157
Why are you asking to rephrase what is already explained in the online documentation?

-----------
Sybrand Bakker
Senior Oracle DBA
saratpvv
Please explain me Index Rebuild ONLINE
Jonathan sir have written good article on this have a look.
http://jonathanlewis.wordpress.com/2009/06/05/online-rebuild/
Nikolay Savvinov
Hi
user4295847 wrote:
Thank for your reply.
Please explain me Index Rebuild ONLINE
and what is the functionality for the DBMS_STATS.GATHER_INDEX and when we need to use ?
Why don't we go another way: you spend a few days working through the links and online documentation, and then if you have any questions left, you ask them here.


Best regards,
Nikolay
user4295847
Yes Understand the index rebuild oniline from your link..

Please explain more about DBMS_STATS.GATHER_INDEX_STATS and when we can use ?
Fran
check:
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_stats.htm#i1036276
user4295847
Hi ,

I am able to understand the DBMS_STATS from this link.

Could you please give me 2 lines answers for what are the advantages if we use DBMS_STATS
Fran
Answer
In order to make good use of the cost based optimizer, you need to create statistics for the data in the database.
Marked as Answer by user4295847 · Sep 27 2020
user4295847
Thanks Fran..
1 - 10

Post Details

Added on Nov 2 2018
0 comments
227 views