Table Enhancements Oracle 12c offers you to create invisible columns, these columns are not visible until you explicitly mention their names in the SQL statement. This functionnality allows developpers to make change to the database without conflicting with the existing application. To create an invisible column: [crayon-544bb7d1c79fc804367641/] You can’t create invisible columns on : External [...]
This example shows where to find the height of an index. I tested it on Oracle 11.2. First I deleted the index's statistics:
i'm having a problem with following INSERTCHILDXML-statement on an Oracle 10g, on a windows platform.
XMLTYPE('<?xml version="1.0" encoding="ISO-8859-1"?>
My Sites just got a new look, but more importantly, it got a technical overhaul, making the page dramatically faster and more powerful.
From one central location, scan and select any of your WordPress sites or create new ones with the support of a more visual interface. Head directly to the posts or pages of a particular WordPress or launch stats to glimpse trends and get inspiration for blog or website content. Access themes, user settings, and sharing options with a click to make WordPress your own.
During a migration from D2-Config 3.0 to D2-Config 4.1, we have encountered 2 issues. In order to have a clean installation and the insurance of being able to backup the configuration, we have decided to perform a full config export on D2-Config 3.0 and a full import with a configuration reset to D2-Config 4.1.
Hi, and welcome to RDX. In this portion of our "services" series, we'll discuss how we provide companies with all of their database administration needs.
With RDX's full DBA support services, we become your DBA team and assume complete responsibility for the functionality, security, availability and performance of your database environments. We know that each company has unique goals and demands, which is why we also implement guidelines and protocols based on your organization's specific requirements.
Today’s blog post is part five of seven in a series dedicated to Deploying Private Cloud at Home, where I will be demonstrating how to configure Compute node and OpenStack services on the compute node. We have already installed the MySQL Python library on compute node in previous posts.
I've published recently my script to check index fragmentation. But then do you COALESCE or REBUILD? Well there is also another option - ALTER INDEX SHRINK SPACE. Let's compare all those index defragmentation operations.
I have an index created when the table had 1 million rows and then I deleted 90% of the rows. Here is the index state from:
ADR enhancements In oracle 12c the Automatic Diagnostic Repository contains a new log directory with 2 subdirectories : DDL Debug The DDL log When you active the DDL logging in Oracle 12c using enable_ddl_logging=true, Oracle writes all DDL operations into the specific DDL log instead of writting it to the alert log. The DDL logging feature [...]
Emergency Monitoring Emergency monitoring is meant for extreme circumstances where it’s impossible for you to connect to the database because the database is hung. Emergency monitoring allows you to connect to the database in diagnostic mode and run a lightweight analysis to see what’s happening. You can access real-time performance data from ASH and access [...]