SQL> create or replace procedure commit_proc as
SQL> create or replace procedure commit_proc as
In the first part, I explained that Incremental Statistics are designed to allow a partitioned tables Global Statistics to be updated based on a combination of
1) Statistics gathered by analysing the contents of one or more partitions that have just been loaded or have been updated (and see this blog post for more depth on what 'updated' means!)
2) The statistics of existing partitions which are represented by synposes that are already (more...)
Sitting in an airport, waiting for a plane, I decided to read a note (pdf) about Flashback data archive written by Beat Ramseier from Trivadis. I’d got about three quarters of the way through it when I paused for thought and figured out that on the typical database implementation something nasty is going to happen after approximately 3 years and 9 months. Can you guess why ?
It’s all about smon_scn_time – which normally records one (more...)
For the about a week I have been getting an “ORA-27054: NFS file system not mounted with correct options” error when running an RMAN backup to a NFS mount point. The system administrator has not been successful in identifying the cause as it shows that the correct mount point options are being used. Metalink Doc.
The post ORA-27054: NFS file system not mounted with correct options appeared first on VitalSoftTech.
In Oracle 12c , there are lot of new great RMAN features focused on reducing recovery time; Some of them to provide better DBA experience too .Let us glance at some of them in this blog.
- Support for point in time recovery for tables and partitions. I would rate this as one of best options of Oracle 12c.
- Option to duplicate database with NOOPEN option so that duplicated/cloned database remains in mount state. Prior to (more...)
In the past I have enthused mightily about the benefits of the approximate NDV mechanism and the benefit of using auto_sample_size to collect statistics in 11g; however, as so often happens with Oracle features, there’s a down-side or boundary condition, or edge case. I’ve already picked this up once as an addendum to an earlier blog note on virtual stats, which linked to an article on OTN describing how the time taken to collect (more...)
Great post from Oracle on How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes.
Just a few notes to for me to remember and share.
From the section:
Import the Oracle VM Templates You Downloaded
4. From the Oracle VM Manager GUI, import the template files by providing both URLs for the same import session. The import process will take several minutes; be patient.
I used the URL below:
Yesterday’s flight from Bangalore to Chennai was very short. It felt like less than an hour to me. Hans Forbrich wasn’t coming to this event, so it looked like Debra Lilley and I would be on our own for this journey, but we bumped into Kuassi Mensah at the airport.
The hotel was very nice, but doing in-room check in freaks me out. I know the hotels think it is something special, but I would rather (more...)
Good one. I like the presumption that I know a lot of stuff about Oracle. I suppose that I do, at least about some some aspects of it, although I often feel like I don’t know enough. It occurred to me that answering publicly might (more...)
Everyone knows Tom Kyte’s mantra:
You should do it in a single SQL statement if at all possible.
But we all know that “Every rule has an exception”
There are many different cases when pl/sql with sql can be more efficient than only sql, and i dont want to catalog them. I just want to show a couple examples of such exceptions:
1. Running totals by several dimensions
Simple example from forum:
In an earlier post about how query high compression eliminated row chaining in tables with more than 255 columns I got question about whether updates to tables with more than 255 columns and query high compression ran slower with this type of compression than on an uncompressed table.
The answer is that, at least in the tests I ran, the updates of a table with more than 255 columns took much longer on a table (more...)
This example was tested on Oracle 11.2. It shows the permissions required to create a materialized view. First I created a user:
A little while ago I highlighted a special case with the MINUS operator (that one of the commentators extended to include the INTERSECT operator) relating to the way the second subquery would take place even if the first subquery produced no rows. I’ve since had an email from an Oracle employee letting me know that the developers looked at this case and decided that it wasn’t feasible to address it because – taking a wider (more...)
Oracle Enterprise Manager 12c is a great monitoring tool for the enterprise, I think I’ve said that more than once over the last two years; however, with every release small yet simple things change. It is always the small things that will get you. I had setup monitoring for a client using monitoring templates within OEM12c; everything was being monitored, so I thought! I got a call from my client asking why (more...)
Wow this is going to be another outstanding conference. Darn going to have to not accept a large number of quality presentations also. We do not have the time or room to run all the sessions (more...)
SQL> col username format a10
1 select username, sid, serial#, status
2 from v$session
3* where username = 'ANDREW'
USERNAME SID SERIAL# STATUS
---------- ---------- ---------- --------
ANDREW 143 79 INACTIVE
You can then use the SID and SERIAL# displayed to kill a session as shown below. The username (more...)