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…

HOW TO AUTO-PURGE STATSPACK SNAPSHOTS

GOAL This note shows the way to purge automatically and regularly STATSPACK data that are older than a specified number of days. SOLUTION To purge unnecessary STATSPACK data use the STATSPACK.PURGE procedure. One of the procedure parameters accepts the number of days and removes all…

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