We have nagging plan stability issues which are often traced back to bad cardinality estimates from our time dimension table. There are numerous workarounds (hinting, baselines, profiles, etc) but it would be so much easier if the CBO just got it right. I think our time dimension...

Hi Tom, we need to purge, ARCHIVE and cleanup our SYS.$AUD table. WE do have a RAC x 2 node as an Active DG too. We have a self-defined procedure , which is working appropriately (using DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL). However the table is >700GB and >700 Mil rows. The procedu...

Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR in rule-based (and usin...

Hi, Why do we need an extra select privilege additional to the delete privilege? From my point of view, this does'nt make sense: --execute as user a: create table b.t (col varchar2 (10)); insert into b.t values ('a'); commit; grant delete on b.t to ut; --execute as user ut:

I have a requirement to load a large excel file (upto 2000 columns) into Oracle database. I am aware of Oracle table limitation of maximum 1000 columns per table and happy to split the data into multiple tables.Could you please help.