Poorly performing SQL from method "wt.content.StandardContentService.getContentsByRole()" in Windchill

• Poorly performing SQL from method wt.content.StandardContentService.getContentsByRole() 

SELECT 'wt.content.ApplicationData',A0.authoredBy,A0.category,A0.checksum,A0.comments,A0.classnamekeyA4,A0.idA3A4,A0.description,A0.distributable,A0.fileName,A0.fileSize,A0.fileVersion,A0.classnamekeyB4,A0.idA3B4,A0.intentToChange,A0.lastAuthored,A0.lineNumber,A0.classnamekeyC4,A0.idA3C4,A0.role,A0.stale,A0.classnamekeyA5,A0.idA3A5,A0.streamId,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.toolName,A0.toolVersion,A0.uploadedFromPath,'wt.content.HolderToContent',A1.classnamekeyroleAObjectRef,A1.idA3A5,A1.classnamekeyroleBObjectRef,A1.idA3B5,TO_CHAR(A1.createStampA2,'dd mm yyyy hh24:mi:ss'),A1.markForDeleteA2,TO_CHAR(A1.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A1.idA2A2,A1.updateCountA2,TO_CHAR(A1.updateStampA2,'dd mm yyyy hh24:mi:ss') 
FROM ApplicationData A0,HolderToContent A1 
  WHERE ((A0.role = ?)) 
    AND ((A1.idA3B5 = A0.idA2A2) 
    AND (A1.idA3A5 IN (SELECT /*+ CARDINALITY(wtot 3300) */ * FROM TABLE(cast(? as TABLE_OF_NUMBER)) wtot WHERE (ROWNUM > 0) AND (column_value IS NOT NULL))))

• Access to pages with thumbnail is very slow
• The performance of adding objects to the workspace has deteriorated significantly
• it is exceedingly slow and requires approximately two minutes to save the data to the workspace

at app//oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:174)
at app//oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:555)
at app//oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:258)
at app//oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:190)
at app//oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:132)
at app//oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:105)
at app//oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
at app//oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:784)
at app//oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
at app//oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
at app//oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at app//oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at app//oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at app//oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1079)
at app//oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3456)
at app//oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:742)
at app//oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:698)
at app//oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:412)
- locked oracle.jdbc.driver.T4CConnection@64a1b35
at app//wt.pds.BasicResultCursor.advance(BasicResultCursor.java:209)
at app//wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
at app//wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880)
at app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077)
at app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986)
at app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
at app//wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
at app//wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351)
at app//com.ptc.windchill.uwgm.common.query.QueryHelper.query(QueryHelper.java:363)
at app//com.ptc.windchill.uwgm.common.content.ContentHelper.getContent(ContentHelper.java:466)
at app//com.ptc.windchill.uwgm.common.content.ContentHelper.getContent(ContentHelper.java:395)
at app//com.ptc.windchill.uwgm.common.content.ContentHelper.getContentItems(ContentHelper.java:164)
at app//com.ptc.windchill.uwgm.proesrv.rrc.RRCContentHelper.setContentInfo(RRCContentHelper.java:353)
at app//com.ptc.windchill.uwgm.proesrv.rrc.RequestResultCache.processContentInfo(RequestResultCache.java:1879)
at app//com.ptc.windchill.uwgm.proesrv.rrc.RequestResultCache.postProcess(RequestResultCache.java:700)
at app//com.ptc.windchill.uwgm.proesrv.ProeServiceRequestDispatcher.postScanRequests(ProeServiceRequestDispatcher.java:59)
at app//com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests(StandardRequestDispatcher.java:1034)
at app//com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute(UwgmTransactionExecuterImpl.java:109)
at app//com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction(UwgmTransactionExecuterImpl.java:59)
at app//com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction(ProeService.java:111)
at app//com.ptc.windchill.uwgm.proesrv.ProeService.execute(ProeService.java:87)
at app//com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.processRequest(BinaryRequestHandler.java:679)
at app//com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.getCacheDescriptor(BinaryRequestHandler.java:528)
at jdk.internal.reflect.GeneratedMethodAccessor1528.invoke(Unknown Source)