Oracle WebCenter Content (MOSC)

MOSC Banner

Disable query Desktop Integration Suite windows Explorer

edited Dec 26, 2018 1:20PM in Oracle WebCenter Content (MOSC) 2 commentsAnswered

Hi we installed Desktop integration suite  in windows 10 with  Windows Explorer, but we are seeing  in the database  query  and the query is take a long time

cServer-37199([ACTIVE] ExecuteThread: '118' for queue: 'weblogic.kernel.Default (self-tuning)').86(Not In Transaction) Active time: 647s
Action executed
SELECT Revisions.dDocName,Revisions.dID, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*, RevClasses.* FROM Revisions, DocMeta, Documents, RevClasses WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary=1 AND dReleaseState IN ('Y', 'U', 'I') AND (((( xIdcProfile LIKE 'colillasdepensiones' ))) AND ((((dSecurityGroup LIKE 'Conocimiento') OR (dSecurityGroup LIKE 'Credito_Personas') OR (dSecurityGroup LIKE 'Empleados') OR (dSecurityGroup LIKE 'Lineas_Productos') OR (dSecurityGroup LIKE 'Public')) AND ((UPPER(dDocAccount) LIKE UPPER('Cliente/Cumplimiento%')) OR (UPPER(dDocAccount) LIKE UPPER('Cliente/Vinculacion_Actualizacion%')) OR (UPPER(dDocAccount) LIKE UPPER('Cliente/Novedades%')) OR (UPPER(dDocAccount) LIKE UPPER('Estudio/Consumo%')) OR (UPPER(dDocAccount) LIKE UPPER('Estudio/Reusables%')) OR (UPPER(dDocAccount) LIKE UPPER('Venta/productos_combos%')) OR (UPPER(dDocAccount) LIKE UPPER('Estudio/Pyme%'))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center