@GAURAVTYAGI  this post is a year old, so it may be worth you logging a new forum question, clearly detailing your Pega version and your configuration.

The ORA-01031 42000 ORA-01031: insufficient privileges issue is just that, a permissions issue.

This oracle error has been known to occur after upgrades where  users try to configure local data storage and add records to newly created data types when the data type is pointing to pr_other table. (not recommended) 

The error "ORA-01013: user requested cancel of current operation" is an "information" error from Oracle indicating that the current operation has been cancelled. This error will be generated if the user cancels the current operation or in response to other errors such as timeouts.

Please check the following

1) Is this an upgrade?  When did this data type last work correctly?

2) Verify alert log to nail down the queries causing the issue.

3) Involve your DBA to verify all the indexes are proper if not rebuild the same (perform gather stats).

4) Whether your entire application is slow or only for some use case?

5)  If your DB is oracle, Involve your DBA to verify the AWR report which will give the list of queries causing the issue and take necessary tuning mechanism.

FYI, refer below link for similar issue reported.

https://community.pega.com/support/support-articles/ora-01013-error-and-application-explorer-slow

It would help if you could provide clear details of other errors you see in your log.

Creating local data storage