Feed aggregator

Gartner Day 2

Peter Khos - Wed, 2007-10-10 07:27
Sorry about the lack of updates but been busy with the Gartner Symposium. Last evening (Tuesday), it was the "Attendee Appreciation Event" which was held at Disney's Animal Kingdom where the park was partially opened for the attendees to partake. Obviously the event was "pitiful" compared to Oracle OpenWorld where last year, Oracle had Elton John as the headliner and Billy Joel for this year's Peter Khttp://www.blogger.com/profile/14068944101291927006noreply@blogger.com0

I love Linus

Fake Larry Ellison - Tue, 2007-10-09 22:50

But sometimes the dude can be as stubborn as a pack mule walking through Siberia in the dead of winter. Kind of like last week when he said, "You security people are insane," and then reiterated that he will add Smack to the Linux kernel. And that's cool. I mean, Linux is his dog and pony show. The problem is that Smack will probably bring a bunch of security vulnerabilities along with it.

People, this is exactly why I run OpenBSD on all of my servers at home. Those suckers are locked down. I keep them off the network, and I also have all the totally crazy shit to protect them. Fingerprint identification. Retinal scanners. Man traps. I'm telling you: The NSA has nothing on Larry's servers. Some people wonder why I go to the insane lengths I've gone to. Well, I'll tell you why. The truth is that you can never be too careful with your digital black book. Women's phone numbers are very, very important.

What's that sound coming from Facebook?

Fake Larry Ellison - Tue, 2007-10-09 21:57

BusinessWeek thinks it's the cha-ching sound coming from the cash register as developers sell their Facebook applications and head for the door. But in reality it's just the sound of thousands of ambitious geeks trying to suck from Mark Zuckerberg's teat. Seriously. Sex-deprived brainiacs beware. This Facebook App stuff has pyramid scheme written all over it. Better to become an Oracle DBA and do serious work that can change the world and make you a bundle of money.

But let me tell you about this one app called Make a Baby. I really think it has potential. Check it out. You hop on Facebook and look at people's pictures until you get a hard-on or the female equivalent. Then you hook up and make a little virtual baby that looks like the two of you. Easy, right? The best part is that you don't even need to virtually procreate with a member of the opposite sex. Man oh man. Just think of the possible combos here. Bill Gates and Mark Zuckerberg. Steve Ballmer and Jonathan Schwartz. (Sorry. Bad image. Talk about some fugly offspring.) Peter Burrows and Dan Lyons. Marten Mickos and Zack Urlocker. Or maybe even Jason Maynard and Rick Sherlund. Yes. Friends, I can see the positive energy flowing as I write this. More on these couples as they develop.

Tuning Collections in Queries [Introduction]

Vlad Sadilovskiy - Tue, 2007-10-09 18:13

[To Next Article [1]] [To Performance Study]

If you never heard of using collections instead of regular IN-LIST expressions, you might want to read varying elements in IN list article from AskTom. It unfortunately has little information about the way CBO treats collections. So, if you have problems with tuning queries that employ nested tables or just evaluating what is in the way please read on. Here is one of the basic forms of SQL queries that employ collections.

select *
  from t1
 where t1.object_id in
     (
       select *
         from table(cast(:1 as table_of_number))
     );

There are several optimization issues related to tuning queries that use collections. Many of them can be attributed to the CBO statistical assumptions. The CBO calculations and figures are a little different in 9i and 10g. However the issue might have change the appearance, but not the essence. There will be few more posts on some basic forms of queries with collections.

Over the past three years I’ve engaged with the Oracle TS several times to find a good resolution for this nuisance. That generated couple bugs: 4484645, 4235962. One of them is closed as “NOT A BUG”.


Blog theme

Vlad Sadilovskiy - Tue, 2007-10-09 16:42

I know, I know… The theme looks exactly like the one Jonathan Lewis has for his Scratchpad. Sorry, about that. I’ve tried every possibility and this is the only one that is comfortable for posting Oracle trace or code snippets. The closest thing I found that wouldn’t wrap the code is a Sandbox theme. Others would have very small or otherwise irritating font.


“Undocumented?!” – Use it or not

Vlad Sadilovskiy - Tue, 2007-10-09 00:06

Rainy day… Thoughts arn’t well aligned… At the end of the day I was wondering on the Internet searching for an inspiration. For a moment I thought I found something interesting. It was on the Jonathan Lewis’s blog – something about Oracle traces. But just a second later after finished reading I grasped what the message was about. In few words there was confusion, doubt and something else, or so it seemed. The title was Trace Files. And here you go an inspiration came, and as usual from a direction you’d never expect.

Should we use undocumented or unofficial methods? Yes, no doubt. That is of course when they are judicially legitimate. I just wanted to point out few key elements of the documented versus undocumented approach as I understand and interpret it. In a different scope this might become discussion about supported versus unsupported and so on.

Documentation is a right place to go if it exists. If it doesn’t, “hacking” in the right meaning of the word, is the way to know the system better than it can possibly be documented. Consider Oracle tracing facility as free of charge and supported debugger. By using it you’d learn about the Oracle and application that uses Oracle, about specifics of different Oracle versions, the improvements in newer releases and deficiencies in former releases.

 What you would lack when you use Oracle tracing is official evidence. If you see a problem in the trace, but struggle to reproduce it using documented forms of proof, you might have some trouble building a case for an SR. You also will have certain difficulties explaining it to the Oracle TS what is that you are trying to solve. And final point against it, when filing SR, is that in Oracle R&D work people just like you. Reverse enginiring an issue from a trace file that you attached is the last thing they wanted to do. Similar to any other trace whether that is a stack trace from JVM or a core dump. It is always better for them to have a reproducible at will test case. However, many times by looking at traces I found things to build a simple test case that I wouldn’t have gotten that easily otherwise.

To summarize, as far as I’m concerned, if the Oracle traces, considering their generation can be done using supported API, allow me to find true problems and do right decisions I’ll keep using them even if their format is neither documented nor supported.


Henning Kagermann has his ass handed to him

Fake Larry Ellison - Mon, 2007-10-08 21:50

Today's articles were so negative that it really pained me to read them. And that's saying a lot coming from me. This article from MarketWatch says that SAP just destroyed its relationship with Microsoft. And this article from Forbes says that we're smiling over here at Oracle. Believe me, we are smiling. But put yourself in Kagermann's shoes for a minute. You're sitting there watching Oracle buy all of these companies and get further and further ahead. We're literally leapfrogging over your pathetic products. You look at SAP's numbers and then you look at Oracle's numbers and then you get all panicked and shit. Beads of sweat pop out on your forehead. You know you have to do something. But what? Your old tricks don't work anymore. The engineers are working as fast as they can and your R&D department is light years behind the competition. So you think, okay, if you can't beat them you'll join them. You'll take Oracle's consolidation strategy and apply it to SAP.

And that's the heart of the problem. Our consolidation strategy isn't going to work for SAP. They're just not that kind of company. And anyway, they're too late. They purchased a company that was being shopped around and they overpaid by a couple billion. Now Microsoft is going to turn against them. And guess who's going to benefit from that? We will, of course, but also MySQL and to a lesser extent Red Hat. After us, MySQL AB probably has the most to gain, because SAP will probably develop closer ties with them after they fall out of grace with Microsoft. Changes are coming, bros.

BusinessWeek : Screech can learn a lot from MySpace

Fake Larry Ellison - Mon, 2007-10-08 13:10
See here. For those too lazy to read, the article says that Facebook isn't doing all it can do to keep kids safe from sexual predators. The article cites a bunch of reputable off-duty police officers hanging out in strip clubs. Don't ask me where BusinessWeek finds these people, okay? I have no friggin idea. But anyway, according to the police officers, MySpace has some Perl script that flags profiles with words like "kill," "rape," "shoot," "gang," "Mark Zuckerberg," and "facebook." They take all the profiles that contain those words and they delete them. Facebook doesn't do that, so it's not as safe.

I know the article sounds stupid, but it's really not. And next month BusinessWeek is going to run another article about how Facebook needs to adopt MySpace's 1995-style colors and website design. The new article will also talk about how Facebook needs to let companies pose as people, let spammers create bogus profiles, and put advertisements for strip clubs at the top of every page. Then, according to the article, Facebook will be worth over $200 billion.

CmdrTaco celebrates ten years of bashing Oracle

Fake Larry Ellison - Mon, 2007-10-08 12:36

See here. We're actually sending CmdrTaco aka Rob Malda a big ass fruitcake to help him celebrate Slashdot's tenth birthday. Why not? Taco's given us one helluva ride. All of those "Oracle Sucks Ass" articles were priceless. Too bad it's all coming to an end. Now all I have to do is send out an email message to Oracle's 70,000 employees and ask them to digg this or that. And then, boom! It's up on Digg and we get like 45,000 unique visitors within two hours. Of course, as Taco himself points out in one of those well-duh moments, "Digg is not Slashdot." Of course it's not, Rob. Slashdot is you, dude. That's why it blows goats. And that's also why your Wired interview has that big "Reddit!" button at the bottom of the page and that link to "Digg Just Might Bury Slashdot." Time for a reality check, CmdrTurd. You're not going to float for much longer.

Gartner IT Symposium 2007

Peter Khos - Mon, 2007-10-08 11:50
Here I am at the Gartner 2007 IT/Expo Symposium in Orlando, Florida. This is my first Gartner Symposium and I'm struck by the age of the attendees who would be in the older group. This is not surprising as Gartner is geared towards the CIOs and IT Excutives/Managers group but it was something that stood out where you don't see a lot of the younger folks (under 30). The weather is hot and muggyPeter Khttp://www.blogger.com/profile/14068944101291927006noreply@blogger.com0

SAP thinks it's ready to rumble

Fake Larry Ellison - Mon, 2007-10-08 09:04

Woo boy. Euro-hippie Henning Kagermann is really strutting his stuff today after writing a $6.8 billion check for Business Objects. See here. I didn't think the dude had it in him, honestly. I didn't think Kagermann could actually spend that much money. I also didn't think he was stupid enough to fall for our jack-the-price-up strategy. But he was, and he did. It all worked beautifully. Safra was actually thinking about pushing the price up into the $8 billion dollar ballpark, but I said, no way, let's not push our luck on this one. Because here's the thing. If we made the price for Business Objects too high, we could have ultimately pushed SAP into bankruptcy, and we can't have that. We don't want to completely screw our competition. We need to keep some of our weakest competitors around so the feds think we're competing with somebody. It's the illusion of competition. That's it. I mean, you don't think SAP is actually going to be able to make this Business Objects thing work, do you? Ha! Henning Kagermann, bastard of bloat, we salute you.

Changing Salary Basis

RameshKumar Shanmugam - Sun, 2007-10-07 23:37
An interesting scenario came in one of my current projects with my customer who are already using Oracle HRMS for past three years
They wanted to change the salary basis from Monthly to Period (Biweekly). It is a common scenario that many company may change their Salary basis from monthly to biweekly or Bimonthly, but the interesting thing in this project is they wanted to modify the history salary information for all the employees from Monthly to Biweekly.

The first thing that came in my mind was the Auditing issue that we might run since we are touching the most sensitive information of the employee data (SALARY), But the HR Users clearly informed us they can provide us with the exact data that need to be loaded.
Another advantage was the customer is not using Oracle Payroll,Oracle HRMS system is not a transactional system

We followed the following approach
  • Remove the salary proposal for the employee for whom we need to modify.
  • Update the Assignment with the new Salary Basis in Correction mode
  • Reload the salary with the same Change date as we unloaded

We used WebADI for unloading Salary information, updating assignment with the new salary basis and loading the salary proposal for the new salary basis.

We used WebADI custom Integrator with the following API

  • HR_MAINTAIN_PROPOSAL_API.DELETE_SALARY_PROPOSAL
  • HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA
  • HR_MAINTAIN_PROPOSAL_API.UPDATE_SALARY_PROPOSAL

Try this out!!!

Categories: APPS Blogs

Statement Cache causes OutOfMemoryError (JDBC)

Vlad Sadilovskiy - Sun, 2007-10-07 22:39

How efficient parse one – execute many in JDBC can get? So obvious recommendation to keep PreparedStatement open as long as possible is not easy. Testing custom built statement cache solution proved it to be not very well scalable. Increasing number of concurrent connections or the size of the cache of open statements lead to ineviable OutOfMemoryError exceptions.

I noticed during my testing by fetching from different “width” tables and playing with prefetch row count, that the wider the row or higher prefetch count were the faster my cache had grown. I debugged my code for many hours looking whether I was closing result sets or for something else very obvious. Nope, no luck – everything was correct. And yet OOME was consistent.

In the end it appeared that JDBC OracleStatement kept reference to so called accessors’ arrays (like a cache of prefetched rows data) for a result set that had been last executed even when the result set was already closed. The size of that data was proportional to the product of the fetched data (in my tests table) width and prefetch row count. I’ve tried then JDBC implicit and explicit caching and was showing precisely same memory footprint.

Opened SR and after few weeks was advised by a nice Oracle TS lady that there could be one workaround (which is mentioned above). It was to use property FreeMemoryOnEnterImplicitCache and so instead of this:

conn = (OracleConnection) DriverManager.getConnection(url, user, password);

use this

OracleDataSource ods = new OracleDataSource();Properties props = new Properties();
props.put("user", user);
props.put("password", password);
props.put("oracle.jdbc.FreeMemoryOnEnterImplicitCache", true);
ods.setConnectionProperties(props);
ods.setURL(url);
conn = ods.getConnection();

During testing I didn’t find a way a custom or explicit cache with key can be used effectively, especially if they are LRU caches (the later appeared to be LRU type of cache) – that residue data is going to get into OldGeneration before the statement is reused and the arrays are repopulated. I really hope the “bug” is going to be fixed in JDBC 10.2.0.4.

Metalink bug reference: 6082980


What sort of twisted fuck does something like this?

Fake Larry Ellison - Sun, 2007-10-07 14:05

Much love to dear reader John who sent in this snapshot of my defaced Wikipedia page (above). Look, people. I know some of you dislike my products. Maybe your Oracle database isn't working correctly. Maybe you don't understand our tech support personnel in Hong Kong or Nairobi or wherever. But that's not my fault. Oracle makes the best databases in the world and all of our tech support personnel take a rigorous course in speaking English. And anyway, nothing gives you a license to call me a Jew right in the subtitle of my Wikipedia page. It's antisemitism. It's hatred. So knock it off, will you? If you want to pick on somebody you should log onto Facebook and virtually knee your friends in the nuts.

"You're not going to believe this, but we're giving away servers now too."

Fake Larry Ellison - Fri, 2007-10-05 13:15

Peter "you don't always have to be right" Burrows over at Business Week has hit another grand slam with his newest article about Jonathan Schwartz and Sun Microsystems. The best quote actually comes at the end of the article when Jim Zemlin at the Linux Foundation talks about Sun's recent moves: "It's like back in high school, when I'd throw these big parties and I'd think I was so cool, only no one would come." Which actually says a lot about both Jonathan and Jim when you think about it. Anyway, my question for Schwartz is this: How the fuck are you supposed to make money when you just give everything away? Peter Burrows seems to think that we're living in some new kind of economy where you don't really have to sell anything to make any money. In other words, if you keep throwing free software to the crowd and jumping and dancing around shiny servers long enough, good things are bound to happen. Um, yeah.

Pete, I want you to do something for me, bro. Just humor me, okay? Surf on over to Google and search for "google servers." Then take a good look at those pictures. See how Google is duck-taping hard drives onto motherboards? See how they're using velcro to strap the motherboards to the racks? Those are Google's servers, dude. Those are what power the world's biggest search engine. Google does that to save money and make components hot-swappable. I'm not sure, but it might have something to do with their stock price these days. So, yeah. Not sure where that leaves Sun, especially when you consider that hundreds of companies are now building servers Google-style.

MERGE and Database Link Problem

Mike Moore - Fri, 2007-10-05 11:27
Using 10g R2 database.

When trying to do a MERGE where the target table is on the remote database and the source table is a sub-select on the local database, the following error was raised:

ORA-01008: not all variables bound

The MERGE statement in question had no bind variables.

Furthermore, if I change the target table to an identical local table it works just fine, so it's not a syntax problem.

I searched all over the web and all over technet and oracle.com but found only a few scant references to this problem. I was unable to find any restriction documented under DISTRIBUTED TRANSACTIONS in the Oracle documentation. I now believe that MERGE will only work over a DB Link when the target is on the local database and the source table is on the remote database.

If you have information about this restriction, please leave a comment.

Shit for Brains is splashing into SaaS

Fake Larry Ellison - Fri, 2007-10-05 11:24

See here. Yes, I know this is old news. What makes it interesting now is that Microsoft is competing with a growing number of companies in this market, including SAP, Salesforce, and NetSuite. Don't laugh at the Microturds yet, though. When the tough get going, the going gets tough. I know SFB is just another butthead fighting over the SaaS table scraps, but Silverlight is actually pretty good. It's nothing to sneeze at anyway.

And I'll tell you this. The only thing worse than Google-envy is Salesforce.com-envy. Don't worry: Stevie B. will want Salesforce.com. When he starts making his little mating call and doing that thing with his tongue, we'll start dropping the hints that we're looking into buying Salesforce. It's our jack-the-price up strategy. We don't really want Salesforce, but we do want to fuck Microsoft. So we'll pretend to want them and plant a bunch of articles in the press and drop some outrageous figure like $10 billion. Then SFB will get all huffy and try to outbid us. It works every time. Just like it did with Red Hat and JBoss. And just like JBoss, Salesforce.com would drag Microsoft down. It would be a terrible buy for Microsoft. But that's Shit for Brains for you. I swear the dude's exactly like the teenage girls I see shopping at the mall. He's always buying a bunch of shit he doesn't really want or need.

Oracle Enterprise Content Management (ECM)

Bex Huff - Thu, 2007-10-04 19:49

This section of the blog contains articles about the Oracle suite of Enterprise Content Management applications. This includes Universal Content Management (UCM), Web Content Management (WCM), Universal Records Management (URM), and a little bit of Information Rights Management (IRM). I helped create several of these products, and thus am very opinionated about how they should be used... I also cover technologies and topics relevant to content management in general, such as enterprise search, and identity management.

Besides the articles in this section, you may also benefit from the following sources:

Primary Oracle ECM Sources Oracle ECM Blogs
  • Fusion ECM: the official Oracle blog on content management, starring Billy Cripe, and occasionally Raoul Miller.
  • Oracle IRM: the official Oracle blog for Information Rights Management, starring Simon Thorpe.
  • Kyle's Blog On UCM: another Oracle "Best Practices" blog, staring Kyle Hatlestad
  • ECM Alerts: Oracle ECM product marketing blog, for official news about events and new product launches
  • Content On Content Management: David Roe's blog on Oracle Content Management.
  • webmonkeymagic: mikeyc7m's tips and rants on web content management, Site Studio, SSPU, and the like.
  • John Sim's blog: web content management, and web design blog. Lots of Site Studio tips.
  • Jason Stortz's blog: IdocScript, Components, Site Studio, and general tips and tricks.
  • Ryan Sullivan's blog: the usual ECM stuff!
Additional Oracle ECM Resources

If you know of another notable Oracle ECM site, send me an email! I'd define "notable" as any "official" site, or a site that posts useful information at least once per month...

read more

Categories: Fusion Middleware

Revenge of the Nerds coming to Xbox

Fake Larry Ellison - Thu, 2007-10-04 14:07

Doesn't it seem like Microsoft takes a hit every time Red Hat releases their numbers? It sure seems that way to me. Red Hat announces record profits and Microsoft's stock goes down. Red Hat announces that they've gained market share and Microsoft fires a couple of their vice presidents. Don't ask me why it's like that. When you really look at the numbers you realize Microsoft has nothing to fear. But they're still afraid. It's like the elephant jumping out of its skin every time it sees the mouse. This last time Microsoft tried something new. Shit for Brains said, well, look. If we release Halo 3 on the same week Red Hat announces quarterly earnings, we'll probably be okay. And they were. In fact, Halo 3 actually did much better than they thought it would. Which is kind of surprising when you consider that the game sucks ass.

So the new plan is to release an Xbox game every time Red Hat announces quarterly earnings. That way, according to Shit for Brains, Microsoft can weather the storm. So SFB has directed Bungie to start working on a new game. This one is going to be a lot like the Revenge of the Nerds movie, except it's going to star younger Silicon Valley greats. Gates and Jobs are in there, of course. So am I. Larry made it in, people. Microsoft sent a couple developers down here to look at pictures of me when I was younger (above and to right) so they could get me just right. The evil frat boys are going to be the gentlemen from the SEC.

And you probably won't believe this, but Shit for Brains actually has hair in the game. I tripped out the first time I saw his character. I didn't even recognize the dude. Seriously. But here's the best part. I bribed the Microsoft guys to put in this cheat code that makes Shit for Brains go postal. Once they put it in the game, all you'll have to do is just punch in the code and Stevie B. will start throwing chairs and shit. Priceless.

Pages

Subscribe to Oracle FAQ aggregator