Skip to Main Content

SQL & PL/SQL

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.

How can find the indexes How many times used?

570355Dec 27 2010 — edited Dec 27 2010
Hi,
I would like to know how many times indexes are used in a day or month etc?
Because I would like to find which one is really are used intensively.

regards,

Comments

Frank.Hampshire-Oracle
It possible that svn has got confused about the status of the repository at some stage. You could consider using svn's "cleanup" function, or "unlock" (perhaps with the --force) option from the command line.

If the files are being hosted on a network drive, make sure that you have the correct file permissions (read, write, delete, modify).

If you want to version control the releases folder, you will have to do this from outside of OPM. Its easy enough using SVN from command line or a tool like TortiseSVN. In general, however, the releases folder is consider a built artifact of the source files which are controlled by default.



Cheers
Frank
Rajan.Panchal
For some files I am able to do check-in, check-out but for other its saying it is locked.
Can you please let me know how do I set permissions of files in SVN. Also, I am unbale to get history from OPM, its says verbose is not supported with svn info command.
Answer
You should be able to get the history and use other command, like unlock, by using svn from the command line. OPM works with SVN, but it isn't a general tool for manipulating an SVN repository.
Marked as Answer by Rajan.Panchal · Sep 27 2020
Rajan.Panchal
Hi,
I have not been successful in using the SVN with OPA.
Following different error I am recieveing while using SVN with OPA.
1. When I try to check out project, I am getting error "Unable to lock project". Also, on status bar a message appears "Unable to add new visio document as project is write protected".


2. While gettitng the latest version I am getting error in a message box:
---------------------------
Get Latest Failed
---------------------------
update failed (svn: E155004: Working copy 'C:\OPA Projects' locked svn: E200031: attempt to write a readonly database svn: E200031: attempt to write a readonly database svn: run 'svn cleanup' to remove locks (type 'svn help cleanup' for details))
---------------------------
OK
---------------------------


Please not when using the same SVN respository in Eclipse IDE, all check-ins and check out works fine without giving any errrors.
Mayumi-Oracle
1.On the Error message svn: E155004 it looks like patch available from Subversion.
It propose all of this for 1.7.0 back-port attached follow the link.

Please refer follow.
http://svn.haxx.se/dev/archive-2011-07/0416.shtml


2. svn: E200031 may related above issue, however, please need check CHMOD file permission that Frank already replied.
You can get a meeting with this error message when trying to commit something to a SVN repo, this is caused by wrong permissions on a file on the SVN server.
The file “rep-cache.db” will most likely have wrong permissions like the group not having write access to the file.
A simple chmod g+w on the file will be enough for the error message not appearing again.


Also please refer Subversion Online Manual.

Chapter 9. Subversion Complete Reference
svn—Subversion Command-Line Client

http://svnbook.red-bean.com/en/1.7/svn-book.pdf
Do you have Eclipse open at the same time? It does sounds like something going wrong with svn, rather than anything that can be controlled from Oracle Policy Modeling.


Davin.
Mayumi-Oracle
Thanks Davin,

I will ask that point.

-Mayumi-
Rajan.Panchal
FYI,
the error comes regardless of whether eclispse is open or not.
Also, Can you please guide me on applying the patch?
Thanks,
Rajan
Mayumi-Oracle
Hi RP,

Subversion patch from Sub version dev team not from the OPA product.

According to this link I can download a linked file from above page link.
http://svn.haxx.se/dev/archive-2011-07/0416.shtml

File:
text/x-patch attachment: run-cleanup-1.patch

It looks like manual batch process described in this file.

Thank you
Mayumi

Edited by: Mayumi on Jun 11, 2012 1:21 AM
1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 24 2011
Added on Dec 27 2010
5 comments
135 views