I need to report the database sizing to our management. Following are the questions: 1) Total space allocated and used for each Database instance (We have 14 each for 3 applications) 2) How is the growth pattern over the last few years. Year to Year change. My answer is 1) Run th...

Hi Tom, good morning My question is very clear and generic, and very important for me due to a current discussión in my team: We have a database in the followint situation, the worst scenario, I guess: - standalone (no RAC, no Dataguard) - Only one disk with all inside: data, fla...

Hi Tom, Suppose I am having following SQL query UPDATE TB38O SET G000KE = (SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A230KF AND TB39G.

Hi. I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html I can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure that collates COUNT(...

Hello, Is there any way to exclude a list of tables while doing DBMS_STATS.GATHER_SCHEMA_STATS? DBMS_STATS.LOCK_TABLE_STATS doesn't answer my need exactly. Best regards, Amine