Skip navigation.

Feed aggregator

Android Users, You Need Vysor

Oracle AppsLab - Fri, 2015-09-18 10:14

Despite the amount of iOS and Apple Watch chatter here lately, we still have a dedicated Android user base on the team, including me.

If you read here, you’ll know that projecting an Android device screen to an audience has always been important for us, and usually we have more than one screen to project. Over the years, I’ve used several tools for this BBQScreenAndroid Screen Monitor and lately, Chromecast’s screen mirroring feature, which is handy because it cuts out the laptop middleman.

Enter a Chrome app called Vysor, created by Android luminary, Koushik Dutta, better know as koush.


You may remember him from such projects as CyanogenMod, AllCast, Helium, ROM Manager, etc. He’s kind of a big deal in the Android modding community because he’s constantly filling Android gaps and improving the Android experience.

And Vysor doesn’t disappoint. Just install the Chrome app from the Chrome Web Store, set the developer options on your Android device and plug it into your machine.

Vysor opens your device’s screen, and sit down for this one, allows you to control it via mouse and keyboard.vysor1You read that right. This is a huge feature that none of the other options I’ve tried offer.

For a full how-to, read Lifehacker’s post.

As an aside, Chrome apps are the bee’s knees. They are truly cross-platform, can run in their own windows outside Chrome and can run when Chrome itself is closed. Seriously, I can quit Chrome and launch the Vysor app on its own. I just did this on OS X and again on Ubuntu.

Did you know that? Although I did, and I shared the enthusiasm of the tech press back in late 2013, I had forgotten. Google hasn’t done a very good job promoting this awesome capability of the Chrome ecosystem.

Not to wander too far off topic, but it is a shame to see Chrome take a back seat to Android when the two are equally useful.

Moving on, Vysor is in beta. It works really well with one device from what I’ve seen. However, once you get two devices connected, it gets confused.


I might have something set wrong, or maybe it’s that annoying Android File Transfer app that’s required (is it still?) for OS X.

Might be user error.

Anyway, if you’re an Android user, check out Vysor. It’s awesome.

Find the comments.Possibly Related Posts:

Learn to Build Web Apps with PL/SQL and Formspider!

Gerger Consulting - Fri, 2015-09-18 07:02
You want to learn how to build first class web applications with PL/SQL but you cannot find the time to start? We are hosting a free webinar just for you! Join us and learn how you can build great web applications with PL/SQL using Formspider.

During the webinar we'll cover the following topics:

  • Formspider Benefits&Features 
  • Formspider Fundamentals: UI Design, Querying and Modifying Data, Using the API's, Working with the IDE. 
  • Sample Application Development with Formspider 
Every webinar attendee will receive a discount for Formspider developer licenses! :-) 

Sign up now!
Categories: Development

Taking a Composition Exam

Chris Foot - Fri, 2015-09-18 05:00

You may perhaps often possibly be requested within higher education to look at composition examinations. In some techniques, a similar guidelines regarding composing good out-of-class works apply to producing good in-class works at the same time. For example, the two sorts of works are definitely more prosperous if you consider your function, crowd along with facts; whenever you develop a thesis together with assist; if you verify your assertions together with facts; when you guidebook your current audience with changes, and so forth.

However, there are many variances to keep in mind since you put together to publish. The most important the first is the point intended for composing. Commonly anyone create an investigation report, by way of example, to learn more regarding ones decided on matter; on the other hand, you compose article examinations to show the know-how. You aren’t merely offerring facts, and also indicating for a audience–the examiner–that you could have mastered the information which enables it to assist this. Basically, ones purpose is actually both equally educational and also persuasive. Retaining this kind of intent planned will allow you to equally plan for along with compose your article.


Study connections between thoughts. Your current coach just isn’t buying variety of unrelated components of information. Somewhat, the individual wants to make sure you understand the entire photo, my spouse and i. elizabeth., how a generalizations or maybe methods generate the composition for your distinct details, as well as how the cases or perhaps facts complete the particular breaks. Consequently, any time you’ lso are understanding, try out to take into consideration how the details satisfies collectively.

Prepare train questions. Seek to plan inquiries which will tend to be inquired. In case your trainer has provided anyone the particular concerns by themselves or perhaps a examine page ahead of time, training responding to those people issues. Usually, try and anticipate questions your own coach probably will request and exercise people. At the very least, put together the way you might reply your check questions; nonetheless, it’ ersus advisable truly create the actual solutions. Like that, you will be aware where you have to review a lot more.


Again, although you’ lso are using your examination, keep in mind that it’ utes not simply what you declare or maybe just how much people say, however The way you claim the item that’ ohydrates significant : personal creative essay writer UK. You need to indicate your instructor which you have acquired this material.

Plan your time and energy.   Although you can be operating being forced, carry a few moments to help prepare your time. See how a lot of units you are able to spend on every single solution. You will want to devote nearly all of your time for the questions which can be worthy of probably the most details, most likely answering those issues initial. Alternatively, you may want to reply 1st the particular issues you are best ready for.

Read the actual inquiries thoroughly.   Take a couple of minutes before writing your essay to learn the question carefully to be able to determine what exactly you are now being asked to complete. Most essay exam issues, or “ requires, ” are carefully worded as well as contain specific instructions with what you are to write down about and also HOW you need to organize your answer. The prompt may use a number of of the following terms. If the thing is that one of these brilliant terms, try to organize your essay to interact to the question or questions indicated.

classify:   Directly into what general category/categories may this notion belong?
compare:   Consider some of the similarities amid these thoughts? What will be the differences?
contrast:   What are differences in between these ideas?
critique:   What are strengths as well as weaknesses of the idea?
define:   Exactly what does this word or phrase suggest?
describe:   Do you know the important traits or top features of this thought?
evaluate:   Do you know the arguments regarding and from this idea? Which in turn arguments are generally stronger?
explain:   The reason why this true?
identify:   What exactly is this thought? What can be its label?
interpret:   Just what does that idea necessarily mean? Why can it be important?
justify:   The reason why this correct? Why is actually this genuine?
outline:   Consider some of the main things and crucial details?
summarize:   In brief, what will be the important ideas?
trace:   What’s the sequence of ideas or obtain of activities?

Plan ones answer.   Jot down the key points you want to make as you think as a result of your response. Subsequently, you should use your list to help you stick on the topic. In an exam scenario, it’ s an easy task to forget points should you don’ capital t write these individuals down.

Write available your essay or dissertation, using very good writing approaches.   Because was said earlier, dissertation exams are generally like other essays, so operate the same very good writing strategies you make use of for other sorts of writing. Understand that your purpose is always to persuade your current reader— the actual examiner— that you realize the substance.

First, create the thesis on your essay you can defend. Often, you be capable of turning the inquiries stated or perhaps implied about the exam into a solution and put it to use as your own thesis. This word also functions being an introduction.

For case in point, suppose you’re given the subsequent prompt with your psychology class:

Define “ procedural knowledge” and illustrate its relationship towards results connected with studies involving amnesic people.

The meant question can be:

What is usually “ procedural knowledge” and how could it be related towards results associated with studies involving amnesic people?

Note how one can turn the solution to in which implied question into the thesis of this exam essay. This section might assist as the introduction.

“ Procedural knowledge” is understanding how to do a task, including tying any shoe as well as driving a vehicle, and also scientific studies of amnesia show that such a knowledge or maybe recollection is normally kept through amnesic individuals. Perhaps in anmesic patients who’ve missing almost all of their particular declarative ram ability, the chance to style completely new procedural remembrances is usually undamaged…

Then, proceed immediately to explain, build, in addition to help your current thesis, attracting when products coming from text(s), talks, and also course talks. Be sure you service any generalizations together with tangible evidence, appropriate information, along with specific details that could convince ones reader that a thesis is valid. Make your main points stand out by writing distinct grammatical construction, and indicate their bond between these people with transitions.

For illustration, in respond to this prompt from the social perform class,

Identify and give among four substitute solutions for sale in cases connected with family turmoil.

a student wrote these paragraph. Note your transition phrase and also the generalization reinforced by particular evidence.

… The last alternative available in situations of spouse and children conflict is actually violence, and this isn’t an unusual response. 25% of all homicides in the U. S. involve one family member killing one more; 50 % of these are husband or wife homicides. Violence may take one of two types: volatile as well as coercive. Mind-blowing physical violence is just not premeditated. If your kid requires as well as failures the family auto, for example, the father may perhaps burst and conquer him. Coercive violence, conversely, will be sharp along with purposive; they have the purpose of producing complying as well as conformity. Thus, any setback supplied that has a menace not to do it again specific behaviours could be coercive….

Finally, summarize the controversy having a simple conclusion that lends the article a particular sense connected with closure.

Finishing this Exam

Proofread the reply.   Arrange a few moments after completing your dissertation for you to look at this very carefully. Primary, be sure you follow the actual query. Always solution precisely the issue asked with no digressing. If you learn you might have digressed, beautifully cross out and about which or perhaps grammatical construction. It’ s preferable to corner away some sort of section which is inconsequential (and to switch this which has a related one particular for those who have time) than to let your catch have. Within this wording at the very least, good quality is always considerably better quantity. Additionally look at syntax, punctuation and punctuation.


The post Taking a Composition Exam appeared first on Remote DBA Experts.

SANGAM15 – See you there!

Tim Hall - Fri, 2015-09-18 04:31

I mentioned my Oracle OpenWorld 2015 trip in a previous post. Yesterday evening I picked up my passport with my lovely new India visa in it!

The talks are written. The flights are booked. The hotel is booked. I have a visa. So that’s me sorted for SANGAM15 in November! :)

It’s going to be a rather hectic few days. I fly out, do the 2 day conference, then fly straight home. It looks like I will be in aeroplanes and airports longer than I will actually be in India. :)

If you are coming along to the conference, be sure to come and say hello. :)



SANGAM15 – See you there! was first posted on September 18, 2015 at 11:31 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Links for 2015-09-17 []

Categories: DBA Blogs

Selling Books on Amazon vs. Intelivideo

Bradley Brown - Thu, 2015-09-17 20:44
For the last couple of years I've heard that publishers don't like selling their books through Amazon.  The way I heard it described sounded like Amazon was forcing (or pushing) you to sell books for under $10.  It's actually pretty complicated as to how their pricing works, so I've attempted to simplify for you here.  If you want the details, you can read more here:

Basically you have to pick which plan you’re on.  The 35% or 70% royalty plan.  At first glance, you would ask - why would anyone pick the 35% royalty plan?  Let's see, you do all of the research, write the book, take a book through 5 edits and get it to the point of publishing and Amazon is going to keep 35 "or" 70% of the revenue generated?  Logically who would say they only want to keep 35%?  It's more complicated - i.e. strings are attached to each choice.

If you pick the 70% royalty plan, you keep as much as 70% (minus delivery costs and with about 100 other rules) of whatever they sell it for.  But according to the small print, on a number of your sales, you’ll actually keep 35% of whatever they sell it for.  Here's the real kicker - if you want to keep 70% (minus delivery costs, VAT, etc), they force you to set the list price to $2.99 to $9.99 AND by the way they will keep 65% if they sell it in other countries, etc.  If you choose the 35% royalty plan (keep in mind, they are are keeping 65%), you can set the price between $2.99 and $200.  You can sell it for less than $2.99 (i.e. down to $.99) if you have a small book (i.e. less than 10Mb footprint).  They also say that the list price must be at least 20% below the lowest physical list price for the physical book.  Wow - SO many rules!

So Amazon charges (keeps) 30% (minus delivery costs) to 65% (and it’s usually this amount) and has minimum and maximum prices you can charge and a lot of rules AND it’s Amazon’s customer (not yours).

The 2 pricing options are explained (and tough to understand) here:

And their FAQ is here:

We're soon to release (secure) eBook functionality at Intelivideo.  So how does it work?  If you pick the Pro Plan, you keep 85% of the revenue and you can set the price to whatever price you want.  We have some other fine print, but overall I can assure you that our pricing is WAY better than Amazon's offer - and it's your customer.  You can sell them more products.  You can do promotions to them.  You can upsell them.  I'm shocked by Amazon's model and now understand the frustration others have!

Partner Webcast – Developers Continuous Delivery Using Oracle PaaS Cloud Services

Cloud computing is now broadly accepted as an economical way to share a pool of configurable computing resources. Several companies plan to move key parts of their development workloads to public...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Data Warehouse on Clould – Amazon Redshift

Dylan's BI Notes - Thu, 2015-09-17 15:50
Here is a brief summary of what I learned by reading these materials. 1. The data warehouse is stored in clusters It can support scale out, not scale up. “Extend the existing data warehouse rather than adding hardware” 2. Use SQL to access the data warehouse 3. Load data from Amazon S3 (Storage Service) using […]
Categories: BI & Warehousing

Oracle Priority Service Infogram for 17-SEP-2015

Oracle Infogram - Thu, 2015-09-17 15:41

OpenWorld is coming up soon, and articles on how to get the most of it are starting to fill the blogosphere. Here’s one from The Data Warehouse Insider: OpenWorld 2015 on your smartphone and tablet.
And one from that JEFF SMITH: All Things SQL Developer at Oracle Open World 2015
SE2 - Some questions, some answers ..., from Upgrade your Database – NOW!
From the same source: Script: Is your database ready for Oracle GoldenGate?
A PL/SQL Inlining Primer, from Oracle Database PL/SQL and EBR.
Exadata Software is Released, from Emre Baransel, Support Engineer's Blog.
From the same source: DBMCLI for Exadata Database Servers
All-Flash Oracle FS1 Storage System, from Oracle PartnerNetwork News.
BPEL-> Mediator -> BPEL: Passing Business Errors back thru Mediator , from the SOA & BPM Partner Community Blog.
From the same source: Searching Service Bus Pipeline Alert.
Concurrency on the JVM, from The Java Source.
From the same source: Java 8 Do and Don'ts and Microservices Architecture
Virtualization Monitoring in Solaris Zones, from Openomics.
From the Oracle E-Business Suite Support blog:
Webcast: Service Parts Planning 12.2.5 Features, Part 2
Don't Miss This! Oracle Exchange Certificate Renew August 19, 2015
Webcast: Use of a Custom Source to Derive Item Based Batch Close Variance Postings in OPM
New and Improved OTM Analyzer - Version 200.1 is now available!
From the Oracle E-Business Suite Technology blog:
Database Migration using 12cR1 Transportable Database Certified for EBS 12.1

Using EBS 12.2 Data Source Connection Pool Diagnostics

We are hiring!

Tanel Poder - Thu, 2015-09-17 15:32

Gluent – where I’m a cofounder & CEO – is hiring awesome developers and (big data) infrastructure specialists in US and UK!

We are still in stealth mode, so won’t be detailing publicly what exactly we are doing ;-)

However, it is evident that the modern data platforms (for example Hadoop) with their scalability, affordability-at-scale and freedom to use many different processing engines on open data formats are turning enterprise IT upside down.

This shift has already been going on for years in large internet & e-commerce companies and small startups, but now the shockwave is arriving to all traditional enterprises too. And every single one of them must accept it, in order to stay afloat and win in the new world.

Do you want to be part of the new world?



NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!

Celebrating 5 Years in Oracle’s Mexico Development Center

Oracle AppsLab - Thu, 2015-09-17 14:51

Editor’s note: If you read here, you might recall that we have dos hermanos en Guadalajara, Luis (@lsgaleana) y Osvaldo (@vaini11a). Last month, the Mexico Development Center (MDC) celebrated its fifth anniversary. Here’s to many more. Reposted from VoX.

By Sarahi Mireles, (@sarahimireles), Oracle Applications User Experience (@usableapps)

As you may know, Oracle has a couple Development Centers around the globe, and one of them is in Guadalajara, México. The Oracle Mexico Development Center, aka Oracle MDC (where I work), was 5 years old on Aug. 18, and the celebration was just as tech-y and fun as it can be for a development center.


Oracle staff hang out at the event before lunch.

Staff from the 9th floor of Oracle MDC have fun and celebrate 5 years of Oracle in Mexico (hurray!)

Staff from the 9th floor of Oracle MDC have fun and celebrate 5 years of Oracle in Mexico (hurray!)

The celebration was split in two events, an open event called “Plug in” and a private event (just Oracle staff). Topics were related to what we love: Database, Cloud and, of course, User Experience. Some of the guest speakers were Hector García, who was chairman of the Computer Science Department at Stanford University; Javier Cordero, Managing Director of Oracle México; Jeremy Ashley (@jrwashley), Group Vice President, Applications User Experience, and Erik Peterson, General Manager of Oracle MDC.

Hector García Molina starts with his talk, "Thoughts on the Future Recommendation Systems," with students and Oracle staff.

Hector García Molina starts with his talk, “Thoughts on the Future Recommendation Systems,” with students and Oracle staff.

Andrew Mendelsohn, Executive Vice President, Database Server Technologies, gives a talk at the event.

Andrew Mendelsohn, Executive Vice President, Database Server Technologies, gives a talk at the event.

Cheers at the conference. It was a really fun event. Geeks knows how to have fun!

Cheers at the conference. It was a really fun event. Geeks knows how to have fun!

Late in the afternoon, the real celebration started! We got to celebrate with all of our friends, colleagues, mates and the whole staff of Oracle MDC, and we all got to be in the anniversary picture of this awesome team, team Oracle!

Members of different teams (UX, UAE) hang out at the celebration.

Members of different teams (UX, UAE) hang out at the celebration.

This year, we all received this fun, handmade airplane as a gift to remember the 5th anniversary of Oracle MDC.

This year, we all received this fun, handmade airplane as a gift to remember the 5th anniversary of Oracle MDC.

All of the crew of Oracle MDC pose in the annual photo taken at the event.

All of the crew of Oracle MDC pose in the annual photo taken at the event.

If you want to know more about life at Oracle MDC, check our Facebook page! And if you’re a student, don’t miss our post about student visits on the Usable Apps blog.Possibly Related Posts:

The Fundamental Challenge of Computer System Performance

Cary Millsap - Thu, 2015-09-17 10:46
The fundamental challenge of computer system performance is for your system to have enough power to handle the work you ask it to do. It sounds really simple, but helping people meet this challenge has been the point of my whole career. It has kept me busy for 26 years, and there’s no end in sight.
Capacity and WorkloadOur challenge is the relationship between a computer’s capacity and its workload. I think of capacity as an empty box representing a machine’s ability to do work over time. Workload is the work your computer does, in the form of programs that it runs for you, executed over time. Workload is the content that can fill the capacity box.

Capacity Is the One You Can Control, Right?When the workload gets too close to filling the box, what do you do? Most people’s instinctive reaction is that, well, we need a bigger box. Slow system? Just add power. It sounds so simple, especially since—as “everyone knows”—computers get faster and cheaper every year. We call that the KIWI response: kill it with iron.
KIWI... Why Not?As welcome as KIWI may feel, KIWI is expensive, and it doesn’t always work. Maybe you don’t have the budget right now to upgrade to a new machine. Upgrades cost more than just the hardware itself: there’s the time and money it takes to set it up, test it, and migrate your applications to it. Your software may cost more to run on faster hardware. What if your system is already the biggest and fastest one they make?

And as weird as it may sound, upgrading to a more powerful computer doesn’t always make your programs run faster. There are classes of performance problems that adding capacity never solves. (Yes, it is possible to predict when that will happen.) KIWI is not always a viable answer.
So, What Can You Do?Performance is not just about capacity. Though many people overlook them, there are solutions on the workload side of the ledger, too. What if you could make workload smaller without compromising the value of your system?
It is usually possible to make a computer produce all of the useful results that you need without having to do as much work.You might be able to make a system run faster by making its capacity box bigger. But you might also make it run faster by trimming down that big red workload inside your existing box. If you only trim off the wasteful stuff, then nobody gets hurt, and you’ll have winning all around.

So, how might one go about doing that?
Workload“Workload” is a conjunction of two words. It is useful to think about those two words separately.

The amount of work your system does for a given program execution is determined mostly by how that program is written. A lot of programs make their systems do more work than they should. Your load, on the other hand—the number of program executions people request—is determined mostly by your users. Users can waste system capacity, too; for example, by running reports that nobody ever reads.

Both work and load are variables that, with skill, you can manipulate to your benefit. You do it by improving the code in your programs (reducing work), or by improving your business processes (reducing load). I like workload optimizations because they usually save money and work better than capacity increases. Workload optimization can seem like magic.
The Anatomy of PerformanceThis simple equation explains why a program consumes the time it does:
r = cl        or        response time = call count × call latencyThink of a call as a computer instruction. Call count, then, is the number of instructions that your system executes when you run a program, and call latency is how long each instruction takes. How long you wait for your answer, then—your response time—is the product of your call count and your call latency.

Some fine print: It’s really a little more complicated than this, but actually not that much. Most response times are composed of many different types of calls, all of which have different latencies (we see these in program execution profiles), so the real equation looks like r = c1l1 + c2l2 + ... + cnln. But we’ll be fine with r = cl for this article.
Call count depends on two things: how the code is written, and how often people run that code.
  • How the code is written (work) — If you were programming a robot to shop for you at the grocery store, you could program it to make one trip from home for each item you purchase. Go get bacon. Come home. Go get milk... It would probably be dumb if you did it that way, because the duration of your shopping experience would be dominated by the execution of clearly unnecessary travel instructions, but you’d be surprised at how often people write programs that act like this.
  • How often people run that code (load) — If you wanted your grocery store robot to buy 42 things for you, it would have to execute more instructions than if you wanted to buy only 7. If you found yourself repeatedly discarding spoiled, unused food, you might be able to reduce the number of things you shop for without compromising anything you really need.
Call latency is influenced by two types of delays: queueing delays and coherency delays.
  • Queueing delays — Whenever you request a resource that is already busy servicing other requests, you wait in line. That’s a queueing delay. It’s what happens when your robot tries to drive to the grocery store, but all the roads are clogged with robots that are going to the store to buy one item at a time. Driving to the store takes only 7 minutes, but waiting in traffic costs you another 13 minutes. The more work your robot does, the greater its chances of being delayed by queueing, and the more such delays your robot will inflict upon others as well.
  • Coherency delays — You endure a coherency delay whenever a resource you are using needs to communicate or coordinate with another resource. For example, if your robot’s cashier at the store has to talk with a specific manager or other cashier (who might already be busy with a customer), the checkout process will take longer. The more times your robot goes to the store, the worse your wait will be, and everyone else’s, too.
The SecretThis r = cl thing sure looks like the equation for a line, but because of queueing and coherency delays, the value of l increases when c increases. This causes response time to act not like a line, but instead like a hyperbola.

Because our brains tend to conceive of our world as linear, nobody expects for everyone’s response times to get seven times worse when you’ve only added some new little bit of workload, but that’s the kind of thing that routinely happens with performance. ...And not just computer performance. Banks, highways, restaurants, amusement parks, and grocery-shopping robots all work the same way.

Response times are trememdously sensitive to your call counts, so the secret to great performance is to keep your call counts small. This principle is the basis for perhaps the best and most famous performance optimization advice ever rendered:
The First Rule of Program Optimization: Don’t do it.

The Second Rule of Program Optimization (for experts only!): Don’t do it yet.

Michael A. JacksonThe ProblemKeeping call counts small is really, really important. This makes being a vendor of information services difficult, because it is so easy for application users to make call counts grow. They can do it by running more programs, by adding more users, by adding new features or reports, or by even by just the routine process of adding more data every day.

Running your application with other applications on the same computer complicates the problem. What happens when all these application’ peak workloads overlap? It is a problem that Application Service Providers (ASPs), Software as a Service (SaaS) providers, and cloud computing providers must solve.
The SolutionThe solution is a process:
  1. Call counts are sacred. They can be difficult to forecast, so you have to measure them continually. Understand that. Hire people who understand it. Hire people who know how to measure and improve the efficiency of your application programs and the systems they reside on.
  2. Give your people time to fix inefficiencies in your code. An inexpensive code fix might return many times the benefit of an expensive hardware upgrade. If you have bought your software from a software vendor, work with them to make sure they are streamlining the code they ship you.
  3. Learn when to say no. Don’t add new features (especially new long-running programs like reports) that are inefficient, that make more calls than necessary. If your users are already creating as much workload as the system can handle, then start prioritizing which workload you will and won’t allow on your system during peak hours.
  4. If you are an information service provider, charge your customers for the amount of work your systems do for them. The economic incentive to build and buy more efficient programs works wonders.

Drop It Like It's Not

Scott Spendolini - Thu, 2015-09-17 08:50
I just ran the following script:

FOR x IN (SELECT table_name FROM user_tables)

FOR x IN (SELECT sequence_name FROM user_sequences)
  EXECUTE IMMEDIATE ('DROP SEQUENCE ' || x.sequence_name);

FOR x IN (SELECT view_name FROM user_views)
  EXECUTE IMMEDIATE ('DROP VIEW ' || x.view_name);

Basically, drop all tables, views and sequences.  It worked great, cleaning out those objects in my schema without touching any packages, producers or functions.  The was just one problem:  I ran it in the wrong schema.

Maybe I didn't have enough coffee, or maybe I just wasn't paying attention, but I essentially wiped out a schema that I really would rather not have.  But I didn't even flinch, and here's why.

All tables & views were safely stored in my data model.  All sequences and triggers (and packages, procedures and functions) were safely stored in scripts.  And both the data model and associated scripts were safely checked in to version control.  So re-instantating this project was a mere inconvenience that took no more than the time it takes to drink a cup of coffee - something I clearly should have done more of earlier this morning.

Point here is simple: take the extra time to create a data model and a version control repository for your projects - and then make sure to use them!  I religiously check in code and then make sure that at least my TRUNK is backed up elsewhere.  Worst case for me, I'd lose a couple of hours or work, perhaps even less, which is far better than the alternative.

Oracle Partners ♥ UX Innovation Events

Usable Apps - Thu, 2015-09-17 08:35

I have just returned from a great Apps UX Innovation Events Internet of Things (IoT) hackathon held in Oracle Nederland in Utrecht (I was acting in a judicial capacity). This was the first of such events organized in cooperation with an Oracle partner, in this case eProseed

eProseed Managing Partner Lonneke Dikmans

Design patterns maven: eProseed managing partner, SOA, BPM and UX champ, Lonneke Dikmans (@lonnekedikans) at the hackathon. Always ready to fashion a business solution in a smart, reusable way.

You can read more about what went on at the event on other blogs, but from an Oracle partner enablement perspective (my main role), this kind of participation means a partner can:  

  • Learn hands-on about the latest Oracle technology from Oracle experts in person. This event provided opportunities to dive deep into Oracle Mobile Cloud Service, Oracle IoT Cloud, Oracle Mobile Application Framework, Oracle SOA Suite, and more, to explore building awesome contextual and connected solutions across a range of devices and tech.
  • Bring a team together in one place to work on business problems, to exchange ideas, and to build relationships with the "go-to" people in Oracle's technology and user experience teams.  
  • Demonstrate their design and development expertise and show real Oracle technology leadership to potential customers, to the Oracle PartnerNetwork, and to the educational, development, and innovation ecosystem.

That an eProseed team was declared the winners of the hackathon and that eProseed scored high on all three benefits above is just sweet!

eProseed NL team demo parking solution

The eProseed NL team shows off its winning "painless parking" IoT solution.

Many thanks to eProseed for bringing a team from across Europe and for working with Apps UX Innovation Events to make this event such a success for everyone there!

Stay tuned for more events on the Apps UX Innovation Events blog and watch out for news of the FY16 PaaS4SaaS UX enablement for Oracle partners on this blog.

Pictures from the IoT hackathon are on the Usable Apps Instagram account

Rocana’s world

DBMS2 - Thu, 2015-09-17 05:49

For starters:

  • My client Rocana is the renamed ScalingData, where Rocana is meant to signify ROot Cause ANAlysis.
  • Rocana was founded by Omer Trajman, who I’ve referenced numerous times in the past, and who I gather is a former boss of …
  • … cofounder Eric Sammer.
  • Rocana recently told me it had 35 people.
  • Rocana has a very small number of quite large customers.

Rocana portrays itself as offering next-generation IT operations monitoring software. As you might expect, this has two main use cases:

  • Actual operations — figuring out exactly what isn’t working, ASAP.
  • Security.

Rocana’s differentiation claims boil down to fast and accurate anomaly detection on large amounts of log data, including but not limited to:

  • The sort of network data you’d generally think of — “everything” except packet-inspection stuff.
  • Firewall output.
  • Database server logs.
  • Point-of-sale data (at a retailer).
  • “Application data”, whatever that means. (Edit: See Tom Yates’ clarifying comment below.)

In line with segment leader Splunk’s pricing, data volumes in this area tend to be described in terms of new data/day. Rocana seems to start around 3 TB/day, which not coincidentally is a range that would generally be thought of as:

  • Challenging for Splunk, and for the budgets of Splunk customers.
  • Not a big problem for well-implemented Hadoop.

And so part of Rocana’s pitch, familiar to followers of analytic RDBMS and Hadoop alike, is “We keep and use all your data, unlike the legacy guys who make you throw some of it away up front.”

Since Rocana wants you to keep all your data, 3 TB/day is about 1 PB/year.

But really, that’s just saying that Rocana is an analytic stack built on Hadoop, using Hadoop for what people correctly think it’s well-suited for, done by guys who know a lot about Hadoop.

The cooler side of Rocana, to my tastes, is the actual analytics. Truth be told, I find almost any well thought out event-series analytics story cool. It’s an area much less mature than relational business intelligence, and accordingly with much more scope for innovation. On the visualization side, crucial aspects start:

  • Charting over time (duh).
  • Comparing widely disparate time intervals (e.g., current vs. historical/baseline).
  • Whichever good features from relational BI apply to your use case as well.

Other important elements may be more data- or application-specific — and the fact that I don’t have a long list of particulars illustrates just how immature the area really is.

Even cooler is Rocana’s integration of predictive modeling and BI, about which I previously remarked:

The idea goes something like this:

  • Suppose we have lots of logs about lots of things. Machine learning can help:
    • Notice what’s an anomaly.
    • Group together things that seem to be experiencing similar anomalies.
  • That can inform a BI-plus interface for a human to figure out what is happening.

Makes sense to me.

So far as I can tell, predictive modeling is used to notice aberrant data (raw or derived). This is quickly used to define a subset of data to drill down to (e.g., certain kinds of information from certain machines in a certain period of time). Event-series BI/visualization then lets you see the flows that led to the aberrant result, which was any luck will allow you to find the exact place where the data first goes wrong. And that, one hopes, is something that the ops guys can quickly fix.

I think similar approaches could make sense in numerous application segments.

Related links

Categories: Other

Use Case of Auto Re-Execute Functionality in ADF BC

Andrejus Baranovski - Thu, 2015-09-17 05:44
There are use cases, when data in DB is changed by background processes and we would like to display to the user latest data available. Very common implementation for this use case is to re-execute ADF iterator and VO each time when Task Flow or UI screen is accessed. Obviously this works, but performance would suffer - usually there is no need to re-fetch data each time, it must be re-fetched only when changes are detected in DB. ADF BC provides out of the box such functionality - it can detect changes in DB and re-execute VO through Database Change Notification. Make sure to grant CHANGE NOTIFICATION system privilege to the data source user.

Auto refresh functionality for ADF BC VO is working when DB pooling is disabled in AM tuning. This would mean you should use Auto refresh carefully and plan dedicated AM's.

I'm going to describe the use case and how you could benefit from VO auto refresh. Here is the example of typical ADF Task Flow with initial Method Call to re-execute VO and fetch fresh data from DB. In the next step UI fragment is rendered, where recent data is displayed:

This is how it works on UI. Departments TF is accessed by pressing Departments button in Employees table screen. This will trigger Execute action call in Departments TF and force VO to reload:

List of Departments will display recently fetched data from DB:

Each time when Departments TF is opened, VO executes SQL query and re-fetches data. This can be observed from the log:

While this works fine, it is not great from performance perspective. We should improve it by using VO auto refresh functionality. Change default activity in TF to UI fragment, we don't need to invoke VO re-execute:

Select AutoRefresh=true property in the VO settings, this will enable DB listener event for this VO and will force re-execution only when it is required:

We are ready to test it. Change Department Name column value:

Navigate to Departments from Employees table:

New data will be displayed automatically in Departments list, even without invoke initial Execute operation. If you would open the same TF, when there were no changes in DB, it will load data from cache, without re-executing VO and re-fetching the same data rows:

Download sample application -

Index Advanced Compression: Multi-Column Index Part I (There There)

Richard Foote - Thu, 2015-09-17 00:57
I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with, that not only makes compressing indexes a much easier exercise but also enables indexes to be compressed more effectively than previously possible. Thought I might look at a multi-column index to highlight just […]
Categories: DBA Blogs

My Nomination for the Oracle Database Developer Choice Awards

Dietmar Aust - Wed, 2015-09-16 23:30
Actually this came as a wonderful surprise ... I have been nominated for the Oracle Database Developer Choice Awards: . I have basically devoted my entire work life to build solutions based on Oracle technology ... and you can build some pretty cool stuff with it. I have always enjoyed building software that makes a difference ... and even more so share to what I have learned and support and inspire others to do the same. The people in the Oracle community are simply amazing and I have made a lot of friends there. If you have an account for the Oracle Technology Network (OTN) I would appreciate your vote ! And if you don't feel like voting for me ... vote anyway in all the different categories ... because the Oracle community deserves the attention. Thanks, ~Dietmar.

US Consumer Law Attorney Rates

Nilesh Jethwa - Wed, 2015-09-16 21:27

The hourly rate in any consulting business or practice increases by the years of experience in the field.

Read more at:

If You're In Latvia, Estonia, Romania, Slovenia or Croatia, Oracle APEX is Coming to You!

Joel Kallman - Wed, 2015-09-16 20:04
In the first part of October, my colleague Vlad Uvarov and I are taking the Oracle APEX & Oracle Database Cloud message to a number of user groups who are graciously hosting us.  These are countries for which there is growing interest in Oracle Application Express, and we wish to help support these groups and aid in fostering their growing APEX communities.

The dates and locations are:

  1. Latvian Oracle User Group, October 5, 2015
  2. Oracle User Group Estonia, Oracle Innovation Day in Tallinn, October 7, 2015
  3. Romanian Oracle User Group, October 8, 2015
  4. Oracle Romania (for Oracle employees, at the Floreasca Park office), October 8-9, 2015
  5. Slovenian Oracle User Group, SIOUG 2015, October 12-13, 2015
  6. Croatian Oracle User Group, 20th HrOUG Conference, October 13-16, 2015

You should consider attending one of these user group meetings/conferences if:

  • You're a CIO or manager, and you wish to understand what Oracle Application Express is and if it can help you and your business.
  • You're a PL/SQL developer, and you want to learn how easy or difficult it is to exploit your skills on the Web and in the Cloud.
  • You come from a client/server background and you want to understand what you can do with your skills but in Web development and Cloud development.
  • You're an Oracle DBA, and you want to understand if you can use Oracle Application Express in your daily responsibilities.
  • You know nothing about Oracle Application Express and you want to learn a bit more.

The User Group meetings in Latvia, Estonia and Romania all include 2-hour instructor-led hands on labs.  All you need to bring is a laptop, and we'll supply the rest.  But you won't be merely watching an instructor drive their mouse.  You will be the ones building something real.  I guarantee that people completely new to APEX, as well as seasoned APEX developers, will learn a number of relevant skills and techniques in these labs.

If you have any interest or questions or concerns (or complaints!) about Oracle Application Express, and you are nearby, we would be very honored to meet you in person and assist in any way we can.  We hope you can make it!