(Hemant K Chitale) Now that we have two Materialized Views against a Source table, how can we identify the relationship via the data dictionary ?

(Senthil Rajendran) There are cases where you might have to create a patch service manually.

(Jagruti Jasleniya) In this article we will see how we can drop the PARTITION without any index maintenance at run time and doing it later.

(Mike.Dietrich) Well, there is no Product Manager for patching. And I’m glad that I’m not in this position.

(Liron Amitzi) I upgraded a test database not too long ago to 18.6 (to do proper testing before we start upgrading productions) and got a feedback from dev that one of the queries got errors.

(mdinh) Planning to move GoldenGate trail files from DBFS to ACFS.

(Jeff Smith) So you got a new computer and/or display – and it’s whiz-bang 4/5k resolution.

(Senthil Rajendran) When applying adop patches on a downtime mode you might see an error that the patch service is not existing or running.

(Jagruti Jasleniya) Dropping Table partition or Index partition is a part of routine maintenance job of DBA.

(lukaseder) One of the biggest and undead myths in SQL is that COUNT(*) is faster than COUNT(1). Or was it that COUNT(1) is faster than COUNT(*)? Impossible to remember, because there’s really no reason at all why one should be faster than the other.