Yeah, so I did it- I installed SQLTXPLAIN, (SQLT) on the AWR Warehouse! From previous experience with this fantastic tool, I was pretty sure I’d have some great new adventures with the AWR Warehouse data and I wanted to see if it was something that I could get running with the AWR Warehouse. This is a work in progress, so I’m going to do this blog in multiple parts to ensure we don’t miss (more...)
I shouldn’t be using an old version of SQL Developer like v3 (3.2.10.09) anyway but… cut a long story short … I am.
I’ve also got v4 which doesn’t display the same problem
Just pointing out an oddity whilst investigating something for someone:
with x as (select to_date('28-MAR-2015 01:30','DD-MON-YYYY HH24:MI') dt1 , to_date('29-MAR-2015 01:30','DD-MON-YYYY HH24:MI') dt2 from dual) select sessiontimezone , dt2 "date" , cast(dt2 as timestamp) "timestamp" , to_Char(cast(dt2 as timestamp),'DD-MON-YYYY (more...)
I was pottering around with the sequence cache recently, investigating a few things like exactly when it refreshes (such as if it is flushed or aged from the shared pool – pin it!) and I was monitoring the next value using V$_SEQUENCE, like I have been since, erm, Oracle 8i in 1999 or summit.
I happened to log into an Oracle 188.8.131.52 DB for a check-test and it was empty! My (more...)
It’s only a couple of weeks since the last release, so I guess there was something causing people significant headaches, which warranted a new release. Not that I noticed any problems.
VirtualBox 4.3.26 was first posted on March 17, 2015 at 1:27 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is (more...)
In my first post of this series, I talked about subscriptions. The next post in this series is about cookie sharing in APEX, I hope you enjoy it.
Apex SSO by Cookie sharing
In the spirit of the previous post, this post will also be one that comes in handy when running multiple applications in the same workspace. When running multiple applications in the same workspace, it’s possible to share the authentication across multiple applications (more...)
In an earlier post, I mentioned that Oracle has finally, offcially supported the Oracle Management Repository (OMR) on Database 12c (184.108.40.206). As I’ve been working on a DBaaS project, I built a new Oracle Enterprise Manager (OEM) enivornment to test out a few things. Since I was rebuilding, I decided to try out the PDB as an OMR (afterall I’ve been asking about this approach). In the past, installation would fail around (more...)
Deleting some rows or tens of millions of rows from an Oracle database should be treated in a completely different fashion. Though the delete itself is technically the same, maintaining indexes and validating constraints may have such a time and resource consuming influence that a vast amount of undo and redo is necessary when deleting millions of rows, in contrast to just a bit when you delete some.
A classic recipe in order to limit (more...)
The following question appeared the Oracle-L list-server recently:
In order to resize a datafile to release space at the end, we need to find whatever the last block_id that is at the start of that free contiguous space.Problem is that we have a very large database such that querying dba_extents to find the last block is probably not an option. The standard query(ies) that make use of dba_extents runs for hours at stretch and also (more...)
The focus on this post started off in one direction and ended up in another. Originally I had been running a drop user script which had hung and even when I killed the process I could not drop the users as it gave a “ORA-01940: cannot drop a user that is currently connected” – despite the users having left the company months ago and there being no chance of them actually having connected sessions. My (more...)
Quick Introduction to Oracle Stream Explorer Part Two– Business User friendly processing of real time events (enrichment, calculation)
Very recently, Oracle released the Oracle Stream Explorer product, available from OTN. With Oracle Stream Explorer, business users and citizen developers as well as hard core developers can create explorations on top of live streaming data to filter, enrich, aggregate, inspect them and detect patterns. Stream Explorer provides a business user friendly browser based user interface in which streams are configured, explorations are composed, enrichment is set up and publication to external consumers is defined. (more...)
I'm flying early this weekend myself. Just have a few conference things to do to get ready for my little role in this big Oracle user group conference.
Looks to be a great conference. I'm personally planning to dive into five areas of focus:
- increasing my depth of understanding about customers and processes (more...)
Fishbowl team members competed in our third annual Hackathon over the weekend. Our consultants split up into four groups to create an innovative solution, and were given just over 24 hours to complete the task. The goal was to create usable software that could be used in the future when working with clients; some of our most creative products and services originally derived from Hackathon events.
Here’s a summary of what the (more...)
Nashville cats, play wild as mountain dew
Nashville cats, been playin' since they's babies
Nashville cats, get work before they're two
- From the Lovin' Spoonful's Nashville Cats
But being local is not the best thing about this conference. The best thing about this...or most user group conferences, for that (more...)
Recently we had a tablespace space run out and ended up in an application failure. I have questioned my DBA and he just plainly blamed the application team members who loaded large number records without a prior notice. A convincing answer, but you can’t really fool Oracle.
Oracle introduced a new DBA_TABLESPACE_USAGE_METRICS view from 10g onwards to report the space usage with in a tablespace. I created a new tablespace and immediately (more...)
One of the waits that is specific to ASSM (automatic segment space management) is the “enq: FB – contention” wait. You find that the “FB” enqueue has the following description and wait information when you query v$lock_type, and v$event_name:
SQL> execute print_table('select * from v$lock_type where type = ''FB''') TYPE : FB NAME : Format Block ID1_TAG : tablespace # ID2_TAG : dba IS_USER : NO DESCRIPTION : Ensures that only one process can format data (more...)
The Oracle 12c 220.127.116.11 release came with a bit of functionality called the PDB Logging Clause. Or to put it another way, it didn’t because the feature just didn’t work. I raised an SR highlighting the issue.
The PDB logging clause is meant to allow you to define a default logging clause for the whole PDB. If a tablespace is created in the PDB without an explicit logging clause, the current PDB (more...)