Say hello to the future of reading content on the web. Introducing a new feature for WordPress.com home pages, infinite scrolling.
It’s amazing, really—instead of the old way of navigating down a page by scrolling and then clicking a link to get to the next page, and waiting for a page refresh—infinite scrolling pulls the next set of posts automatically into view when the reader approaches the bottom of the page. Speed and performance are key: new content loads in quickly without a full page reload.
A lot of hits from search engines to this blog have keywords about installing a VirtualBox Extension Pack, seems people have problems doing that.I showed how to do it in my very first post about installing VirtualBox on Fedora, all via command line.That is still a valid approach as you can see here (this time on Windows 7):C:\Users\robert>"C:\Program Files\Oracle\VirtualBox\VBoxManage" extpack install C:\Users\robert\Downloads\Oracle_VM_VirtualBox_Extension_Pack-4.1.16-78094.vbox-extpack0%.
Luton would have won the play-off final
I would have won the lottery by now
…and Oracle databases would run on Linux.
Out in the real world however, there are times when Oracle running on a Windows server is just unavoidable.
That’ll be the Real World with real data and real security issues, mixed in with – possibly – the real need to initiate a batch script from inside the database.
What follows are details of how to do this in Oracle 10g R2 running on a Windows server.
One may sometimes need to find the ddl which ran on the database at some certain period of time.If auditing is enabled for the you can get the details using various *_audit_* views. In case, its not and the database is in archivelog mode you can try using logminer.Here is an example for it –
Last time, I produced my traditional golfed solution for the annual NoCOUG contest. As I mentioned at the end, the actual challenge calls for a more generic solution than originally described in the magazine. Because there is no glory in half-solving a problem, I had to come back to it. And because the Great Karmic [...]
Aggregate functions fall into two categories. The first is what I call “Sorting aggregate functions” that need their data sorted in some way to operate. Examples of sorting aggregate functions are MEDIAN and DENSE_RANK. The second category is non-sorting aggregate functions that do not require a sort to operate. These include COUNT, AVG, and RANK.
If like me, you are addicted to command line, this post will help you to realize useful operation in EM Cloud Control 12c using emcli tool rather than GUI.
You can use emcli when you need to implement batch scripts on your Oracle Management Server (OMS).
Login to EM
$ emcli login -username=sysman
Enter password :
$ emcli login -username=sysman -password=XXXXXX
Bad plan or something else?
The first step in any tuning activity is determining the scope of an issue — so if a query is not performing satisfactory, then the first question is whether it’s query’s execution plan or something else (e.g. a global database issue or even a problem external to the database). Full diagnostics may be time-consuming or even inaccessible, so it’s desirable to resolve this question by just looking at the query and its basic statistics. There is a method of doing that using SQL efficiency, and in this post I’m going to describe it.