I’ve just had cause to resurrect a blog note I wrote three years ago. The note says that an anomaly I discovered in 18.104.22.168 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 22.214.171.124, 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.
The UKOUG user group conference is one conference I have wanted to get to for a long time, but never managed to before. This year, with the change in job roles to being a database architect in the DBaaS team within the Enterprise Manager product management group, I finally got the go ahead to submit some papers. I was notified some time back that one of them had been accepted (Snap Clone) and one shortlisted (DBaaS), and I was asked by one of my colleagues to help out with the Enterprise Manager round table. Just before I came over to the UK, the UKOUG folks asked me to also present the DBaaS presentation, so now I have something on each of the 3 days the conference is scheduled for.