Hello! I recently noticed that: What if I’m not happy with the Oracle algorithm and I want to drop and auto-index on 19c? It should be easy, I initially thought. For example, something like “drop index XXXX;” right? Wrong. However,…Read More >
Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS: Kill Sessions: begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial, method => ‘IMMEDIATE’); end; / Flush shared_pool or buffer_cache: exec rdsadmin.rdsadmin_util.flush_shared_pool;…Read More >
In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on the following: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-65108: invalid use of a cursor…Read More >
After setting up GoldenGate in your environment, you might ask yourself: How much work is being done by my GGate environment? Here’s another consideration: You just want to set up a dummy extraction so you can measure it before starting…Read More >
Does IPv6 formatting for JDBC and SQLPlus seem new to you well, it’s been available since 11gR2. You’re familiar with IPv6, right? If not, click here. Basically, the only thing you need to do is enclose the IPv6 address in…Read More >
Sounds simple, right? And it really is, although it might not seem obvious. Recently, I ran into an issue when trying to start a trace in a standby. The idea was to start a trace in MRP to monitor performance….Read More >
I recently found this interesting message error in a CRS alert log from a client environment: 2019-08-26 16:33:53.277 [SRVM(9624)]CRS-10051: CVU found following errors with Clusterware setup : PRCW-1015 : Wallet pythiandb does not exist. CLSW-9: The cluster wallet to be…Read More >
Let’s say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it? Here is an example of how to list and read those files using rdsadmin: SQL> select * from dba_directories; OWNER DIRECTORY_NAME…Read More >
I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier and quicker to ignore a specific error using an OEM Metric. How? By using an agent parameter….Read More >
Having questions about automatic startup and shutdown is quite common when dealing with new environments or configurations. There is more than one way to implement this depending on the environment configuration, licensing and version. So, here is a summary: 1….Read More >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.