By using our website, you agree to the use of our cookies.
By using our website, you agree to the use of our cookies.
CALL US
Free Oracle Consulting by E-mail
E-MAIL
dbpilot.net@gmail.com
LOCATION
Moscow
WORKING HOURS
09:00 - 21:00 MSK

ENTERPRISE MANAGER QUERIES ARE IN TOP AS ELAPSED TIME QUERIES CAUSE OF AUDIT RECORDS

SYMPTOMS The Enterprise Manager Queries are the first CPU/TIME consuming queries in the order by Elapsed time section of a statspack report. For instance ————————————————————- ^LSQL ordered by Elapsed time for DB: MERIDB2 Instance: meridb2 Snaps: 27081 -27 -> Total DB Time (s): 6,849 ->…

ERRORS ORA-39150 AND ORA-08186 DURING DATAPUMP IMPORT WHEN USING FLASHBACK_TIME OPTION

SYMPTOMS When attempting to perform a datapump import with the FLASHBACK_TIME option, the following errors occur ORA-39001: invalid argument value ORA-39150: bad flashback time ORA-08186: invalid timestamp specified For instance, the datapump command that was issued oracle@s001dev ~: impdp system/pwd NETWORK_LINK=MERIDB2_TOMSKPROD FLASHBACK_TIME=\”TO_TIMESTAMP\(TO_CHAR\(SYSDATE,\’YYYY-MM-DD HH24:MI:SS\’\),\’YYYY-MM-DD HH24:MI:SS\’\)\” schemas=TOMSKPROD…

WordPress Theme built by Shufflehound. dbpilot.net by Victor Khalturin ©