ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP. Using the below query you can check the temporary tablespace usage and session using the temporary segments. You can extend or add da...
7 Years Ago
Queries to Monitor Expdp Datapump Jobs Status
you can monitor the status of expdp or impdp datapump job using dba_datapump_jobs view. You can also check the stuck data pump jobs, percentage % of completion, wait events, slow runing jobs and vario...
7 Years Ago
How to Find Users having DBA Role in Oracle
DBA role should be granted only to actual database administrators. If you want to know which users have been granted the dba privileges then you need to query the dba_role_privs in the SYS schema....
7 Years Ago
dbca UnsatisfiedLinkError exception loading native library java.lang.UnsatisfiedLinkError
Error while installing oracle using dbca UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /lib/libnjni11.so: libclntsh.so.11.1: cannot open shared object f...
7 Years Ago
How to convert scn to a timestamp in Oracle
Oracle has provided two packages called scn_to_timestamp and timestamp_to_scn using which you can convert scn to date and date to scn....
7 Years Ago
How to stop Materialized view Auto Refresh in Oracle
materialized view created with the automatic refresh can not be alter to stop refreshing. In order to disable that you must run the dbms job broken procedure....
7 Years Ago
