Skip to Main Content
Forums

Oracle Database Discussions

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.

materialized view log

superdbaFeb 21 2017 — edited May 13 2017

hi , i m working on a database 11g where i found some mv logs that contain big size on my database but i dont find any  materialized view on my database so i dont find any use of them.

but before purge them i want to sure that they are not being used by any materialized view .

so ho can i be sure that that materialized view logs r useless and what is the the best way to purge them.

regards

Comments

Madhusudhan. M

Office 365 editions require locally installed supported versions of Office applications. See https://support.oracle.com/epmos/faces/DocumentDisplay?id=1581197.1.

Hope you rebooted server after changing heap settings. check out logs for any errors ?

https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s02.html

Thanks,

Mady

user9082214

Not sure about the smart view performance issue - but issue #2 - if you are talking about getting the "white screen" when trying to open HFM in Workspace - this fix may help:

Doc ID 2237050.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=383744433618875&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

--BRC

ChrisTurnbull

We have an open SR with Oracle for the Smart View issue also, they are looking at running a fiddler trace on it shortly. We have completed a number of tests in regards to all manner of EXCEL and IE Options to no avail. I will post up further if we get anywhere, but just want to confirm that right now 11.1.2.4 and EXCEL 2016 use leads to slower performing refreshes and occasional crashing.

One recommendation is that you stay on the Monthly Channel with EXCEL updates, as we experienced more frequent crashing on 1705 and lower of EXCEL.

I also recommend you lock down your Registry settings for Smart View, to prevent EXCEL pushing the Smart View add in into Disabled items each time it does crash, if you already have not done so.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 10 2017
Added on Feb 21 2017
#general-database-discussions
11 comments
991 views