Unlike 12.1 MultiTenant, 12.2 introduces a separate Undo Tablespace for each PDB.
SQL> l 1 select c.con_id, c.name con_name, t.tablespace_name, t.contents, t.status 2 from v$containers c, cdb_tablespaces t 3 where c.con_id=t.con_id 4 and t.tablespace_name like '%UNDO%' 5* order by 1,2 SQL> /
CON_ID CON_NAME TABLESPACE_NAME CONTENTS STATUS ---------- ---------------- ---------------- --------------------- ---------
Oracle Database 12c Release 2 has now been officially released (at least on the Oracle Database Cloud and Oracle Database Exadata Express Cloud Services). In the coming weeks, I’ll be blogging about quite a number of new indexing features/capabilities/improvements that have been introduced in Oracle Database 12c Release 2. These include: Advanced Index Compression Tracking […]
As this post appears, I'm presenting on this subject for the Dutch Oracle User Group OGh. This blog post won't contain as much detail as the presentation itself, although it's pretty close. If you're interested to see and replay everything for yourself, you can find the material of the presentation in the "Presentations and papers" section and here directly. There are installation instructions in
Tomorrow is Thanksgiving holiday in the United States. Millions of Americans will travel this weekend to be with family, away from the family, visit somewhere fun, or for some unfortunate few, be stuck at work or stuck in the traffic. Amid loads of turkey, stuffing and the oft-present alcohol, it's easy to forge the concept behind this holiday: it's about giving thanks. It's a day to remember, acknowledge and celebrate all those who made us who we are today, and offer our thanks.
Professionalism in the IT world is desirable. Some people have it, some don’t. The ones that do have it, the ones that are professional, are treated with more respect and are usually better at their jobs. Below, I share five tips that you can use to be more professional in your workplace. Dress Code Wherever […]
Recently I was working with a Redshift cluster located in one of the west AWS regions and was asked if we could move the data to the east region. So, I started to move the required data over.
The task looks more or less simple enough if you need to move one table data but it can be tricky if you have to move multiple tables. I will try to describe some ways I used to copy the Redshift data.