I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.
And fast it is.. until it reaches the following step:
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Now understandably, there’s plenty of stats to import, so its fair that it should take a little while. But a quick look at the SQL that’s being run, reveals something truly hideous. You’ll see a succession of giant PL/SQL blocks, chock full of literals and row-by-row (slow by slow) processing. Things like this:
I’ve just had cause to resurrect a blog note I wrote three years ago. The note says that an anomaly I discovered in 126.96.36.199 wasfixed in 10.2.0.3 – and this is true for the simple example in the posting; but a recent question on the OTN database forum has shown that the bug still appears in more complex cases. Here’s some code to create a table and two indexes:
Data virtualization solutions also known as Copy Data Management (CDM), Copy Data Virtualization (CDV) and Data #222222;">Virtualization Appliances (DVA) are rising rapidly as over 100 of the Fortune 500 have adopted data virtualization solutions between 2010 and end of 2014.
We had an interesting issue on 188.8.131.52, where users were reporting very slow performance on queries to external tables. When I tried to replicate the problem, everything seemed just fine, so I initially reported back the familiar "Well, it works on my PC" :-) [Just kidding]
Anyway, connecting by proxy to one of their accounts, did reveal the error, which suggested something to do with privileges. A sql trace revealed that the performance was due to a query which appears to get the list of directories and their privileges:
SELECT NAME, PATH, READ, WRITE, EXECUTE FROM SYS.LOADER_DIR_OBJS
the definition of which was:
Andy Savage gave a powerful and on-target keynote at the Collaborate Conference (Quest, OAUG, and IOUG #C14LV). There is a nice summary at http://collaborate.ioug.org/p/bl/et/blogid=40&blogaid=289 , which I recommend. My favorite bit was point #7 : Art belongs in the same discussions as Science, Technology, Engineering and Mathematics (S.T.E.A.M., not S.T.E.M.).
Andy phrased his entire take, even the bits of irony, on calling for positive action.
This is in contrast to a recent huffpost manipulation: http://www.huffingtonpost.com/2014/06/24/verizon-ad-tells-parents-to-encourage-girls_n_5526236.html
MARK_: My Issue: An hour on the phone and three attempts to authorize my replacement equipment PKKVZQSMC ended with a hang-up while supposedly transferring me to a supervisor.
user MARK has entered room
analyst Cherry has entered room
Cherry: Hello MARK_, Thank you for contacting Comcast Live Chat Support. My name is Cherry. Please give me one moment to review your information.
Cherry: Hi! How are you doing today, Mark?
MARK_: read what I wrote
Sorry it’s taken a couple of days to finish off this series of blog posts on UKOUG Tech 14. I had expected to get some time on the trip back to write this, but as you’ll see if you keep reading, that really didn’t happen. So let’s go back to Day 3 of the conference.
Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in a session due to a package variable, and then when you change the package, the state is cleared along with an ORA-4068. Here’s a quick example:
SQL> create or replace 2 package PKG is 3 procedure P; 4 end; 5 / Package created. SQL> create or replace 2 package body PKG is 3 my_global int := 10; 4 procedure P is 5 begin 6 null; 7 end; 8 end; 9 / Package body created.
SQL> exec pkg.p PL/SQL procedure successfully completed.
Now we change the package… In this case, I’ve just changed the value of the global
Day 2 of the UKOUG Tech 14 conference for me started with the second session (I spent the first session typing up the blog post on Day 1 as there wasn’t a presentation I was interested in). Tammy Bednar was presenting on “Creating a Test / Dev Database in Minutes Using the Oracle Database Appliance”. Tammy is another old timer at Oracle. Like myself and Maria Colgan, she has been an Oracle employee for 20 years. I’d been discussing with Maria on day 1 that people either seem to move on from Oracle within a couple of years, or they stick around for a long time like us. For me, that’s because I’ve been able to move around and do different things that have kept my interest levels fresh.
Monday was the first day of the main part of the UKOUG Tech 14 conference, after SuperSunday’s additional content. I had a great night’s sleep and woke at 7 am, much to the disgust of Richard Foote who had been up for four hours already and didn’t seem to appreciate my #NoJetLagHere hashtag replying to his lack of sleep tweet. I managed to get to the conference relatively dry, but realized yet again that you don’t come to Liverpool in December for the weather.