Oracle

Oracle Database: Query to List All Statistics Tables

If you were a big fan of manual database upgrade steps, perhaps you would have come across this step many times in your life while reading MOS notes, upgrade guides, etc. Upgrade Statistics Tables Created by the DBMS_STATS Package If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following…

Oracle Passwords: How to Use Punctuation Symbols

You can’t make a password strong enough. But at least you can try. Having at least one upper case character, one lower case character, one number, one punctuation mark or symbol, and greater than 8 characters, you can have a password which can be considered something decently safe, probably.

12c Multi-tenant Environment and DBRM for Container Database

In multi-tenant environment, Database Resource Manager (DBRM), at the Container Database (CDB) level enables us to manage the resources like CPU usage and number of parallel execution servers among the plugabble databases (PDBs). Then within each PDB, DBRM enables us to manage resources like CPU, parallelism and managing the runaway queries which exceed the certain…

Watch: In-Memory Option for Oracle 12c

Back in September at Oracle OpenWorld 2013, Larry Ellison announced the Oracle Database In-Memory Option to Oracle 12c. Today, one of Pythian’s Advanced Technology Consultants, Christo Kutrovsky shares his thoughts on the new feature in our latest video. Stay tuned for updates while it’s being tested out in the field.

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation. However, I did review Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit…

Oracle RMAN Restore to the Same Machine as the Original Database

Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In such situations, the biggest fear is overwriting the original database. Here is a simple procedure…

RMAN Infatuation?

Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear datafile fuzziness If you are, then I will demonstrate this for you. RMAN LEVEL0 backup…

Page 6 of 140« First Page...45678...20...Last Page »