Feed aggregator

Oracle Engineered Systems, Amazing Exalogic

Alejandro Vargas - Thu, 2012-09-27 03:36

Sometimes I have heard that Exalogic is just a bunch of servers connected using infiniband, something that you can easily build yourself at a lower cost.


That comments misses completely 2 things:


1) What is the idea behind an Oracle engineered system, and the back that Oracle provides for them 


2) What is Exalogic


This amazing 5 minute presentation explains Exalogic potential:


Oracle Exalogic Elastic Cloud



Categories: DBA Blogs

JavaOne Next week

Debu Panda - Wed, 2012-09-26 16:55
I will be at JavaOne next week. I have two sessions at JavaOne this year. Here are the details for these two sessions.

Session : BOF6019 - Diagnosing Performance Issues in Cloud-Based Java Applications
Venue / Room: Parc 55 - Market Street
Date and Time: 10/2/12, 17:30 - 18:15

Session : CON6173 - Making Sense out of the Java PaaS Platforms
Venue / Room: Parc 55 - Market Street
Date and Time: 10/2/12, 11:30 - 12:30

I hope to see some of you next week.


TROUG senelik büyük toplantı zamanı yaklaşıyor

H.Tonguç Yılmaz - Wed, 2012-09-26 13:58
troug.org ‘u takip edenler için çok da yeni bir haber değil, 11 Ekim ‘de senelik büyük toplantımızı yapacağız. İlk toplantıda olduğu gibi yine Beşiktaş boğaz kenarı lokasyonun avantajı nedeni ile Bahçeşehir Üniv. ‘ni seçtik. Ajanda heyecan verici, birçok yeni yüz de bu sene sunucu olarak katılıyor. Henüz kayıt olmadı iseniz pazarlama sunumu görmeyeceğiniz, gerçek hayat […]

The Future of Project Management is Social

Oracle e-Business Suite - Tue, 2012-09-25 12:32

Rapid Ascent. Breakneck Speed. Lightning Fast. Perhaps even overwhelming. No matter which set of adjectives we use to describe it, social media’s rise into the enterprise mainstream has been unprecedented. Indeed, the big 4 social media powerhouses (Facebook, Google+, LinkedIn, and Twitter), have nearly 2 Billion users between them.

You may be asking (as you should really) “That’s all well and good for the consumer, but for me at my company, what’s your point? Beyond the fact that I can check and post updates, that is.”

Good question, kind sir.

Read Details on

https://blogs.oracle.com/applications/entry/the_future_of_project_management


Categories: APPS Blogs

PARALLEL_MIN_TIME_THRESHOLD Contradictions

Asif Momen - Tue, 2012-09-25 06:39
PARALLEL_MIN_TIME_THRESHOLD initialization parameter controls which statements are candidate for parallelism. 

As per MOS, this parameter is set to 10 seconds while Oracle documentation claims that it is set to 30 seconds. Now who's correct ??? Seems like it's a documentation bug.

Below are the links to both Oracle documentation and MOS article:






Speaking at Oracle OpenWorld 2012

Asif Momen - Mon, 2012-09-24 07:59
Well, it's time for Oracle OpenWorld again. This is the place to meet & learn from the industry experts. Glad I am making this year. 

This year I will be speaking on my experiences managing Very Large Databases. Following are the details of my session.


Session ID: UGF3662
Session Title: Very Large Databases: Challenges and Opportunities
Venue / Room: Moscone West - 2000
Date and Time: 9/30/12, 10:00 - 11:00




These are the activities on my OOW to-do list:

1) Attend lots of sessions
2) Oracle ACE dinner
3) Blogger meetup
4) Oaktable World


I’m looking forward to seeing you in San Francisco!

Review: Oracle SOA Suite 11g Administration Handbook

Marc Kelderman - Sat, 2012-09-22 07:34
While Packt Publishing is almost ready to publish their 1000th title. They will celebrate this with an  the event. As the mentioned on their site:

"Packt would like you to join them in celebrating this milestone with a surprise gift. Revisit Packt’s website between the 28th and 30th of September to redeem your gift, or sign up for an account with us now to receive a notification email.

Packt supports many of the Open Source projects covered by its books through a project royalty donation, which has contributed over $400,000 to Open Source projects. As part of the 1000th book celebration Packt is allocating $30,000 to share between projects and authors."
I had the opportunity to review the new administration handbook of the Oracle SOA Suite 11g.


 






Here are my comments on this book.

The book is filling a gap in the Oracle SOA world. This book is really focusing on administration and monitoring of the SOA11g environment. The book is not a summary of the Oracle Manuals with some screen shots based on an example application, but it gives you also different best practises, idea's, and good examples on maintaining your environment.

The chapter on tuning your SOA11g environment is very good! It covers O/S, application server, database and the various component within the SOA Suite.

I missing only a good script in the chapter on maintaining  your SOA instances. The examples are based on the de supplied scripts of Oracle, but those script do not purge all the data.



Oracle NoSQL Database Exceeds 1 Million Mixed YCSB Ops/Sec

Charles Lamb - Fri, 2012-09-21 08:07

We ran a set of YCSB performance tests on Oracle NoSQL Database using SSD cards and Intel Xeon E5-2690 CPUs with the goal of achieving 1M mixed ops/sec on a 95% read / 5% update workload. We used the standard YCSB parameters: 13 byte keys and 1KB data size (1,102 bytes after serialization). The maximum database size was 2 billion records, or approximately 2 TB of data. We sized the shards to ensure that this was not an "in-memory" test (i.e. the data portion of the B-Trees did not fit into memory). All updates were durable and used the "simple majority" replica ack policy, effectively 'committing to the network'. All read operations used the Consistency.NONE_REQUIRED parameter allowing reads to be performed on any replica.

In the past we have achieved 100K ops/sec using SSD cards on a single shard cluster (replication factor 3) so for this test we used 10 shards on 15 Storage Nodes with each SN carrying 2 Rep Nodes and each RN assigned to its own SSD card. After correcting a scaling problem in YCSB, we blew past the 1M ops/sec mark with 8 shards and proceeded to hit 1.2M ops/sec with 10 shards. 

Hardware Configuration

We used 15 servers, each configured with two 335 GB SSD cards. We did not have homogeneous CPUs across all 15 servers available to us so 12 of the 15 were Xeon E5-2690, 2.9 GHz, 2 sockets, 32 threads, 193 GB RAM, and the other 3 were Xeon E5-2680, 2.7 GHz, 2 sockets, 32 threads, 193 GB RAM.  There might have been some upside in having all 15 machines configured with the faster CPU, but since CPU was not the limiting factor we don't believe the improvement would be significant.

The client machines were Xeon X5670, 2.93 GHz, 2 sockets, 24 threads, 96 GB RAM. Although the clients had 96 GB of RAM, neither the NoSQL Database or YCSB clients require anywhere near that amount of memory and the test could have just easily been run with much less.

Networking was all 10GigE.

YCSB Scaling Problem

We made three modifications to the YCSB benchmark. The first was to allow the test to accommodate more than 2 billion records (effectively int's vs long's). To keep the key size constant, we changed the code to use base 32 for the user ids.

The second change involved to the way we run the YCSB client in order to make the test itself horizontally scalable.The basic problem has to do with the way the YCSB test creates its Zipfian distribution of keys which is intended to model "real" loads by generating clusters of key collisions. Unfortunately, the percentage of collisions on the most contentious keys remains the same even as the number of keys in the database increases. As we scale up the load, the number of collisions on those keys increases as well, eventually exceeding the capacity of the single server used for a given key.This is not a workload that is realistic or amenable to horizontal scaling. YCSB does provide alternate key distribution algorithms so this is not a shortcoming of YCSB in general.

We decided that a better model would be for the key collisions to be limited to a given YCSB client process. That way, as additional YCSB client processes (i.e. additional load) are added, they each maintain the same number of collisions they encounter themselves, but do not increase the number of collisions on a single key in the entire store. We added client processes proportionally to the number of records in the database (and therefore the number of shards).

This change to the use of YCSB better models a use case where new groups of users are likely to access either just their own entries, or entries within their own subgroups, rather than all users showing the same interest in a single global collection of keys. If an application finds every user having the same likelihood of wanting to modify a single global key, that application has no real hope of getting horizontal scaling.

Finally, we used read/modify/write (also known as "Compare And Set") style updates during the mixed phase. This uses versioned operations to make sure that no updates are lost. This mode of operation provides better application behavior than the way we have typically run YCSB in the past, and is only practical at scale because we eliminated the shared key collision hotspots.It is also a more realistic testing scenario. To reiterate, all updates used a simple majority replica ack policy making them durable.

Scalability Results

In the table below, the "KVS Size" column is the number of records with the number of shards and the replication factor. Hence, the first row indicates 400m total records in the NoSQL Database (KV Store), 2 shards, and a replication factor of 3. The "Clients" column indicates the number of YCSB client processes. "Threads" is the number of threads per process with the total number of threads. Hence, 90 threads per YCSB process for a total of 360 threads. The client processes were distributed across 10 client machines.

Shards KVS Size




Clients





Mixed





(records)















Threads




Overall
Throughput
(ops/sec)


Read Latency
av/95%/99%
(ms)
Write Latency
av/95%/99%
(ms)




2
400m(2x3)




4








90(360)




302,152


0.76/1/3
3.08/8/35




4
800m(4x3)




8








90(720)




558,569


0.79/1/4
3.82/16/45




8
1600m(8x3)




16








90(1440)




1,028,868


0.85/2/5
4.29/21/51




10
2000m(10x3)




20








90(1800)




1,244,550


0.88/2/6
4.47/23/53




Extreme performance boost on OSB11g and CLOB objects

Marc Kelderman - Wed, 2012-09-19 13:33
When using the JCA DbAdpater in the Oracle Service Bus (OSB11g) normal operations running fine. Most of us using the DbAdapter for simple DML actions (Select/Insert/Update/Delete).

There is a huge performance degradation when you read LOB objects from the DbAdapter. When reading a CLOB from a table, and this CLOB contains a document of 3MB, we saw that the OSB server consumes 100% CPU for a long time.
This results in time-outs, broken-pipe, connection lostd and all those kind of messages. First of all you look into your own environment to find this issue;
  • Is the server configured correctly
  • Is the network up and running
  • Is the query correct
  • Is the Proxy service programmed in the correct way
I found out that this huge CPU consuming action is a bug (!) that exists from patch set #2 (11.1.1.3). Only for this release a patch was created. The fix was not put into the code of the next patch sets.

To summarize; make sure you have patch for your OSB environement for bug 1294800 (PS2) or 14630697 (PS5)  or ask Oracle Support for a backport for you release.

Keep clause

Rob van Wijk - Sat, 2012-09-15 12:26
You may have seen an aggregate function like this in SQL queries: max(value) keep (dense_rank first order by mydate) or this analytic variant: max(value) keep (dense_rank last order by mydate) over (partition by relation_nr) Unfortunately, when you start searching for the "keep" clause, you won't find anything in the Oracle documentation (and hopefully because of this blogpost, people will Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com8

My Guide for Oracle OpenWorld 2012

Kuassi Mensah - Thu, 2012-09-13 17:44
Are you a Java developer, C/C++ developer, or PHP|Ruby|Perl|Python developer  looking to exploit the latest Oracle database technology?

Are you a MapReduce/Hadoop developer or administrator?

Are you MySQL developer looking to migrate or reuse your applications against Oracle?

Are you a developer or Oracle DBA looking for Net Services Enhancements with the Latest Oracle Database Technology?
Here is my list of sessions for you!
Note: I will be either presenting, coordinating or attending these sessions, so if you want to see/meet me, you know where to go!
1/ MapReduce and Hadoop developer and administrator: what is new in the latest Oracle database technology?
In-Database Hadoop: When MapReduce Meets the RDBMS
Where: Parc 55 - Embarcadero
When: 10/3/12, 15:00 - 16:00
Where: Marriott Marquis - Salon 10/11
When: 10/2/12, 17:00 - 18:00
Where: Marriott Marquis - Golden Gate C1
When: 10/2/12, 13:15 - 14:15

Where: Moscone South - 302
When: 10/2/12, 10:15 - 11:15

Visit us in the:
(i) Oracle Red Lounge in Moscone North upper lobby  
(ii) Java/JDBC demo booth (Database demo campground, Moscone South)

2/ Java developers: what is new in the latest Oracle database technology?
Where: Marriott Marquis - Golden Gate C1
When: 10/2/12, 13:15 - 14:15

Where: Marriott Marquis - Club Room
When: 10/3/12, 17:00 - 18:00

Where: Marriott Marquis - Salon 10/11
When: 10/1/12, 12:15 - 13:15

Where: Marriott Marquis - Foothill F
In-Database Hadoop: When MapReduce Meets the RDBMS
Where: Parc 55 - Embarcadero (JavaOne)
When: 10/3/12, 15:00 - 16:00

Where: Marriott Marquis - Salon 10/11
When: 10/2/12, 17:00 - 18:00


Visit us in the Java/JDBC demo booth (Database demo campground, Moscone South)


3/ C/C++ developer: what is new in the latest Oracle database technology?
Best Practices for Application Performance, Scalability, and Availability
Where: Marriott Marquis - Club Room
When: 10/1/12, 10:45 - 11:45

Meet the Developers of Database Access Services (OCI, ODBC, DRCP, PHP, Python)
Where: Marriott Marquis - Foothill F
When: 10/1/12, 19:15 - 20:00
Run MySQL Applications Against the Latest Oracle Database Technology
Where: Marriott Marquis - Salon 10/11
When: 10/1/12, 16:45 - 17:45

Syndication and Consolidation: Oracle Database Driver for MySQL Applications
Where: Marriott Marquis - Club Room
When: 10/1/12, 13:45 - 14:45 


Visit us in the Data Access and Net Services demo booth (Database demo campground, Moscone South)

4/ PHP|Python|Ruby|Perl developer5/ MySQL developer: what is new in the latest Oracle database technology?Syndication and Consolidation: Oracle Database Driver for MySQL Applications
Where: Marriott Marquis - Club Room
When: 10/1/12, 13:45 - 14:45

Run MySQL Applications Against the Latest Oracle Database Technology
Where: Marriott Marquis - Salon 10/11
When: 10/1/12, 16:45 - 17:45

Visit us in the Data Access and Net Services demo booth (Database demo campground, Moscone South)
6/ Net Services Enhancements with the Latest Oracle Database Technology
 Where: Moscone South - 303
 When: 10/3/12, 11:45 - 12:45
 

Visit us in the Data Access and Net Services demo booth (Database demo campground, Moscone South)

Forms Presentations at DOAG Conference 2012

Gerd Volberg - Thu, 2012-09-13 03:55
And here are some tips for the DOAG Conference in Germany


Jan Peter Timmermann


Wolfgang Kriebel, Christian Kühne


My own presentation :


Perry Pakull


Stephan La Rocca


And in the afternoon we can attend at the Fusion Middleware Panel with Frank Nimphius, Duncan Mills and Jürgen Menge


Gerd

Forms Modernization at Oracle Open World

Gerd Volberg - Wed, 2012-09-12 08:13
Here are some tips for the Oracle "Forms" Open World 2012

Grant talks about The Future of Oracle Forms :


Lucas presentation is about The Future, too :


Mia and Grant talk together about face-lifting-tips for Forms :


More infos can be found on Grants blog and on Mia's blog

Have fun with it
Gerd

Whatever Happened to Edward Roske?

Look Smarter Than You Are - Sun, 2012-09-09 19:23
Where have I been for 8 months?
Answering that could take a while.  Suffice to say, it's been a busy year.  The largest amount of time beyond my normal job was spent being Conference Chair for the last two years for ODTUG's Kscope conference.  If anyone ever offers to let you chair a conference and then tells you "it's mostly a symbolic position that doesn't require much work," they're lying.  Run away quickly.  Chairing these things is a lot of work, and I am happy to say that my replacement as Conference Chair, Mike Riley, will doubtless put my conference chairing to shame as he carries on the good I did and takes it up a notch from good to great.

While running Kscope was an amazing lot of work, it was definitely worth it.  I encourage every one of you to make it to Kscope13 in New Orleans, LA from June 23-27 in 2013.  Kscope13 will continue to be the home for Hyperion, Essbase, Oracle EPM & BI (in addition to ApEx, Oracle RDBMS, Fusion, and lots more) and it's adding content in those areas including entirely new tracks around EPM.  Side note: abstract submission is open through October 15, so if you want to get a free pass to Kscope13, now's your chance: http://bit.ly/Content13.

Kscope kept me busy from early in 2010 until the summer of 2012.  I then took a month off to recuperate (in other words, focus on my actual duties at interRel which apparently include CEO: who knew?) and now I'm back to blogging.  I'm sure you're shedding a single tear right now and I'm choosing to believe it's because you're so choked up with emotion.

The next few weeks are going to be filled with a great deal of travel as I'm presenting at several conferences.  I'm hoping to be able to blog from a few of these conferences.  If you're at any of them, be sure to find me either up on stage somewhere speaking or at our booth.  If you want to know more about any of these conferences, you can always send an e-mail over to the intelligent, beautiful, and obscenely overworked Danielle White at info@interrel.com.

September 11
Hyperion Solutions Road Trip to Denver
Oracle and interRel put on a series of free, multi-track training days around North America each year.  We have one on September 11 at the Grand Hyatt in Denver and like most of the Roadshows we do, it's open to both current and prospective customers of Oracle EPM & BI.  I'm giving three sessions at this conference including the keynote on the future of Oracle EPM (11.1.2.2 and beyond).  If you're anywhere near Denver (or could fly there easily), there's a great half-day agenda followed by free tickets to a Colorado Rockies game afterwards (they're playing the San Francisco Giants).  My good buddy, Glenn Schwartzberg, will also be presenting along with a few Oracle speakers talking in detail about 11.1.2.2.

September 30 to October 4Oracle OpenWorld
San Francisco, California
If you don't want to miss your annual chance to hear Oracle talk about Oracle, you'll want to come to a city vaguely resembling San Francisco during the first week of quarter close for most companies.  That's right: in what is, I'm sure, not a big "sod off" to finance and accounting users everywhere, Oracle has decided to hold their annual Oracle awesomeness conference during the first week of October.

To be completely honest, I actually like being able to hear once per year directly from Oracle their stance on recent releases and future plans. While it's huge, overcrowded, 90%+ marketing, and expensive, there are great networking and educational opportunities to be found if you know where to look.  Word of advice, though: don't ever try to stand in a cab line; you'll be there for 2 hours and it's probably quicker to just walk wherever you're headed.

I've got 3 or 4 sessions at this year's conference including a non-Hyperion one on the Fusion User Experience.  Most of my sessions will be part of the ODTUG's EPM Symposium at Moscone West in room 2008 on Sunday afternoon.  interRel also has a kiosk in the Hyperion Pavilion on the 5th floor of the Intercontinental Hotel.  Make sure you stop by and see us at one of those locations.

Pearl Jam and Kings of Leon will be performing at the Wednesday night party on Treasure Island, so bare minimum, you can get in touch with your alternative side.  There's also free booze, so ya, you got that going for you.

October 16Hyperion Solutions Road Trip to Seattle
This conference is similar to the one in Denver except for three important differences:
  1. It's in Bellevue, Washington on a different date.
  2. The keynote speaker is the VP of Oracle EPM Development, Matt Bradley.  He's a great speaker and this is an excellent opportunity to hear from development themselves about all the great things they have planned for the next year.
  3. The after event is at Lucky Strike instead of at a baseball park, because let's face it: there's no way in Hell that the Seattle Mariners will still be playing baseball in mid-October.
This event, like the other road trips, is free.  You just have to get yourself to Seattle (and not be a competitor, obviously).

October 23Hyperion Solutions Road Trip to Phoenix
This time, we're heading down South to Phoenix, Arizona.  The agenda will be very similar to the Denver event above and there will be great fun in the evening after, so join us for education and networking all for free.  Just to prove that geography is not our strong suit, in this exact same week, we'll be traveling to:

October 25Hyperion Solutions Road Trip to Calgary
I'm told that Canadians are very scary and intimidating, but I'm hoping they'll be nice as we take our first road trip North of the border.  Expect a similar agenda to the others but with a dash of vegetarian back bacon.  I'm looking forward to the Calgary Flames game after the day's education is complete because apparently hockey is trying to become a major sport, and this is my one chance to learn something about it (red line? blue line? icing?).  Jenny, our business coordinator at interRel, is from Canada and she assures me that if hockey doesn't take off, at least curling will.

      October 30Hyperion Solutions Road Trip to Los Angeles
      The agenda for this event is quite different.  Among other things, it's a full-day instead of a half-day and it has 3 full tracks instead of 2.  It's basically a one-day, free Hyperion conference.  This year, it'll be at the Hilton inside Universal Studios and our after event will be at Jillian's on the Universal City Walk.  Here's the complete agenda:
      Hyperion Solutions Road Trip to
      Southern California
      8:30 AM       
      Check In & Registration
      9:00 AM
      Keynote: Analytics-Led Business Innovation, Matt Bradley, Oracle

      Experience the Future of Oracle EPM 11.1.2.2
      Live Demos Included!
      The World of
      Hyperion Applications
      The Foundations of Business Intelligence: Oracle Essbase & OBIEE
      10:00 AM
      Taking Control of Your Hierarchies with
      DRM 11.1.2.2
      Introduction to
      Integrated Business Planning
      BI Foundation Suite:
      Integrating Oracle Essbase & The New OBIEE 11.1.1.6
      11:00 AM
      The Next Evolution
      in Forecasting:
      Hyperion Planning 11.1.2.2
      Reducing Your Close Cycle:
      Financial Close & Account Reconciliation Management
      Oracle Essbase
      Worst Practices:
      Lessons from a Moron
      11:50 PM
      Lunch
      12:20 PM
      Ask a Guru Panel Session
      1:30 PM
      Managing Your
      Project Budgets:
      Introduction to the
      New Hyperion Planning Project Module
      Best Practices for Your Strategic Oracle EPM Road Map: Building Your 3 Year Plan
      Extending the Value of Oracle eBusiness Suite with Oracle EPM
      2:30 PM
      Hyperion Financial Management 11.1.2.2: Unlimited Dimensionality & Financial Management Analytics
      Optimizing Your Oracle Hyperion Planning & Oracle Essbase Outlines
      Exalytics: In-Memory Business Intelligence for Oracle Essbase & OBIEE
      3:20 PM
      Break
      3:50 PM
      Breaking Away from the Excel Add-In:
      Welcome to
      Smart View 11.1.2.2 
      Integrating Hyperion Financial Management & Hyperion Planning
       What’s New in
      OBIEE 11.1.1.6:
      Oracle on Your iPhone & Other Cool Things
      4:40 PM
      Drawings / Networking
      5:30 PM
      Dinner/Drinks/Entertainment at Jillian’s at Universal Studios City Walk


      November 5-6
      OAUG Connection Point - EPM&BI
      Orlando, Florida
      Each year, OAUG puts on a 2-day Oracle EPM&BI focused conference.  It has nowhere near as many sessions on Hyperion as Kscope, but it's by far the second-best conference out there.  It has around 50 sessions and this year, interRel is giving 6 of them.  I'm giving a session on Exalytics and other interRel speakers will include Glenn Schwartzberg on Smart View 11.1.2.2, Tracy McMullen on multiple topics, and  Dr. Troy Seguin talking on Predictive Analytics.  We will also have a booth there with our newest 11.1.2.2 books.

      Unlike the Road Trips mentioned above, this conference isn't free.  That said, it's a lot cheaper than OpenWorld with far better targeted content.  If you're in the Southeastern United States, I strongly encourage you to make it to Connection Point at the Peabody Hotel.



      November 15-16ODTUG Seriously Practical - EPM&BI
      Auckland, New Zealand
      ODTUG is putting on two 2-day conferences in Australia and New Zealand in November.  This is the first of those conferences.  There's a charge for them, but it's minimal for the content you get over 2 days. Cameron Lackpour (ACE Director and all-around decent human being) and I are the featured speakers.

      There are actually two tracks: one is focused on Hyperion and Oracle EPM.  The other track is focused on Oracle BI.  I'm giving sessions in both rooms as well as some excellent local speakers and Oracle luminaries.  Make sure you visit the ODTUG website closer to the date for more details.


      November 19-20ODTUG Seriously Practical - EPM&BI
      Melbourne, AustraliaThis is basically the same 2-day, 2-room itinerary as the event in Auckland.  I have presented at the InSync conference in Melbourne before and I love the city.  If you can't make it to Auckland, I'm hoping you can fly down to Melbourne.  They have koalas.

      After this, I hope to return back to the good ole US-of-A with a month to spare before TEOTWAWKI.  I have some final things I need to take care of before December 21.  Among other things, I'm hoping to clean out my Inbox, because my mother always told me that you don't want to face an apocalypse unless you have a clean Inbox.

      Oh, is that all?Seriously?!?  That's the busiest conference schedule I've ever had with the exception of the 3-week multi-continent trip last year with some of the Oracle ACE Directors from the Oracle Technology Network.  I'm hoping that with all those travel dates over the next 2 months, I'll run into some of you in-person.  If you're anywhere near, please try to stop by.  I'm also hoping that all this travel will give me time to blog on airplanes.

      It's good to be back.

      Categories: BI & Warehousing

      JDeveloper Memory And Performance

      Bex Huff - Fri, 2012-09-07 17:02

      I was recently doing some training on ADF, and the students were complaining how slow JDeveloper was... Dragging and dropping Data Controls onto a JSF page? It's the pause of death if you will. Not to mention the "Out Of Memory" errors that crop up in the middle of debugging a large app. Very frustrating for developers, so I decided to once and for all get figure out what magic JVM tuning parameters would speed it up.

      As a general rule, Java is optimized for throughput, not latency. Once the garbage collector kicks in, performance drops like a rock. A 2 second pause every once in a while is OK for a server, but for an IDE it's misery. So here's the fix:

      1. Go to your JDeveloper root directory, is should be something like C:\Oracle\jdev\Middleware\jdeveloper
      2. Open the file ide\bin\ide.conf, scroll down to the default memory settings:
      3.         AddVMOption  -Xms128M
                AddVMOption  -Xmx768M
        
      4. Boost the memory to something larger, like so:
      5.         AddVMOption  -Xms1024M
                AddVMOption  -Xmx1024M
        
      6. Open the file jdev\bin\jdev.conf
      7. Add the following config settings:
      8.         # optimize the JVM for strings / text editing
                AddVMOption -XX:+UseStringCache
                AddVMOption -XX:+OptimizeStringConcat
                AddVMOption -XX:+UseCompressedStrings
        
                # if on a 64-bit system, but using less than 32 GB RAM, this reduces object pointer memory size
                AddVMOption -XX:+UseCompressedOops
        
                # use an aggressive garbage collector (constant small collections)
                AddVMOption -XX:+AggressiveOpts
        
                # for multi-core machines, use multiple threads to create objects and reduce pause times
                AddVMOption -XX:+UseConcMarkSweepGC
        
      9. Then restart JDeveloper... If it doesn't start, you'll need to reduce the amount of memory allocate in the ide.conf file from step 3.

      And that's it! Your mileage may vary, of course... And you may need additional parameters, depending on what version of JDeveloper you're running. Just keep in mind that you are tuning Java for shorter pauses, and not greater throughput.

      UPDATE 1: some students still had issues, so in addition to the JVM settings, I've found these tips also help out:

      Go to Tools / Preferences / Environment, and switch to the "Windows" look and feel. The Oracle look and feel is prettier, but slower.

      Disable all extensions that you don't need. This is usually a huge savings... Go to Tools / Preferences / Extensions, and turn off thnigs you know you don't need. One thing I do is disable all extensions by default, then enable only the ones I know I need for my current project. For example, disable everything, then enable only those extensions that start with ADF. This will automatically enable dependent extensions. Enable others (Portal, SOA, RIDC) only if needed.

      Open all documents in "Source" mode by default. Go to Tools / Preferences / File Types, and click the Default Editor tab. For all web pages (HTML, JSF, JSP) set the default editor to "Source". You can always click the "Design" tab to see the design. For best results, select items in the "Structure" window (by default on lower left) and edit them in the "Property Inspector" window (by default on the lower right).

      If you really want to get extreme... you can install a solid-state hard drive for your workstation. Barring that, if you have enough RAM you can allocate 4 GB and create a RAM driver for your system. This looks like a normal hard drive, but it's all in RAM. Then install JDeveloper on that, and it will be almost as good as a solid state drive.
      Other developers have had success using

      UPDATE 2: A reader has informed me that this line:

              #AddVMOption -XX:+AggressiveOpts

      Breaks offline database support in JDeveloper... so that one will have to be avoided in some cases.

      read more

      Categories: Fusion Middleware

      #Oracle #Cloud is Here!

      Bradley Brown - Thu, 2012-09-06 20:25
      Well, the long awaited for #cloud offering is finally here from Oracle.  This post will walk you through the registration process.  My next blog entry will walk you through the setup, configuration, installation, etc.

      First, just go to https://cloud.oracle.com/ and click on the "Register for Access" button:


      Then Oracle asks if you need to create a new Oracle account or if you already have one.  Answer accordingly.


      If you need to create a new account, answer the questions...


      If you already have an Oracle account like I do, just sign in:


      Tell Oracle which of their many cloud offerings you want to try out:




      Now just sit back and wait for your account to be created.  I was in the Early Adaptor (EA) program, so I had everything in the EA version.  I just signed up for my new "production" version of the offering.  In my next blog I'll let you know how long it took to get my account set up and I'll show you what I had to do from there.  The above process took me all of 1 minute...

      Sign up - good luck!

      Are Java PaaS platforms ready for enterprise?

      Debu Panda - Thu, 2012-08-30 17:38
      Cloud computing bubbles are still rising and there is a great hype for Java PaaS. Java PaaS vendors are still growing like mushrooms. Remember the good old early J2EE / EJB 1.0 days! They hold a lot of promise. Are they really ready for deploying enterprise grade applications? I spent few weeks looking at few Java PaaS vendors and I will present my thoughts at my JavaOne presentation.

      Have you deployed your enterprise application in a Java PaaS? I would be interested to know your thoughts.

      Here is a survey on Java PaaS http://www.surveymonkey.com/s/BDZRWQF

      InteliVideo Pitch

      Bradley Brown - Wed, 2012-08-29 18:37
      Check out the new InteliVideo Pitch


      Separate docs for MySQL Connectors

      Tahiti Views - Wed, 2012-08-29 13:36
      The MySQL documentation section has always had this Topic Guides page containing links to the docs for the various MySQL Connectors -- the official database drivers for various languages and programming technologies. That is the most convenient way to get the information for each Connector in PDF form, rather than downloading the entire Ref Man PDF. For HTML, it was more of a shortcut, because John Russellhttp://www.blogger.com/profile/17089970732272081637noreply@blogger.com0

      Is “Can’t” Really the Word You Want?

      Cary Millsap - Tue, 2012-08-28 12:16
      My friend Chester (Chet Justice in real life; oraclenerd when he puts his cape on) tweeted this yesterday:
      can’t lives on won’t street - i’m sure my son will hate me when he’s older for saying that all the time.

      I like it. It reminds me of an article that I drafted a few months ago but hadn’t posted yet. Here it is...

      When I ask for help sometimes, I find myself writing a sentence that ends with, “…but I can’t figure it out.” I try to catch myself when I do that, because can’t is not the correct word.

      Here’s what can’t means. Imagine a line representing time, with the middle marking where you are at some “right now” instant in time. The leftward direction represents the past, and the rightward direction represents the future.


      Can’t means that I am incapable of doing something at every point along this timeline: past, present, and future.


      Now, of course, can’t is different from mustn’t—“must not”which means that you’re not supposed to try to do something, presumably because it’s bad for you. So I’m not talking about the can/may distinction that grammarians bring to your attention when you say, “Can I have a candy bar?” and then they say, “I don’t know, can you?” And then you have to say, “Ok, may I have a candy bar” to actually have candy bar. I digress.

      Back to the timeline. There are other words you can use to describe specific parts of that timeline, and here is where it becomes more apparent that can’t is often just not the right word:
      • Didn’t, a contraction of “did not.” It means that you did not do something in the past. It doesn’t necessarily mean you couldn’t have, or that you were incapable of doing it; it’s just a simple statement of fact that you, in fact, did not.
      • Aren’t, a contraction of “are not.” It means that you are in fact not doing something right now. This is different from “don’t,” which often is used to state an intention about the future, too, as in “I don’t smoke,” or “I do not like them, Sam-I-am.”
      • Won’t, a contraction of “will not.” It means that you will not do something in the future. It doesn’t necessarily mean you couldn’t, or that you are going to be incapable of doing it; it’s just a simple statement of intention that you, right now, don’t plan to. That’s the funny thing about your future. Sometimes you decide to change your plans. That’s ok, but it means that sometimes when you say won’t, you’re going to be wrong.
      Here’s how it all looks on the timeline:


      So, when I ask for help and I almost say, “I can’t figure it out,” the truth is really only that “I didn’t figure it out.”

      “...Yet.”

      ...Because, you see, I do not have complete knowledge about the future, so it is not correct for me to say that I will never figure it out. Maybe I will. However, I do have complete knowledge of the past (this one aspect of the past, anyway), and so it is correct to speak about that by saying that I didn’t figure it out, or that I haven’t figured it out.

      Does it seem like I’m going through a lot of bother making such detailed distinctions about such simple words? It matters, though. The people around you are affected by what you say and write. Furthermore, you are affected by the the stuff you say and write. Not only do our thoughts affect our words, our words affect our thoughts. The way you say and write stuff changes how you think about stuff. So if you aspire to tell the truth (is that still a thing?), or if you just want to know more about the truth, then it’s important to get your words right.

      Now, back to the timeline. Just because you haven’t done something doesn’t mean you can’t, which means that you never will. Can’t is an as-if-factual statement about your future. Careless use of the word can’t can hurt people when you say it about them. It can hurt you when you think it about yourself.

      Listen for it; you’ll hear it all the time:
      • “Why can’t you sit still?!” If you ask the question more accurately, it kind of answers itself: “Why haven’t you sat still for the past hour and a half?” Well, dad, maybe it’s because I’m bored and, oh, maybe it’s because I’m five! Asking why you haven’t been sitting still reminds me that perhaps there’s something I can do to make it easier for both of us to work through the next five minutes, and that maybe asking you to sit still for the next whole hour is asking too much.
      • “You can’t run that fast.” Prove it. Just because you haven’t doesn’t mean you never will. Before 1954, people used to say you can’t run a four-minute mile, that nobody can. Today, over a thousand people have done it. Can you become the most commercially successful and critically acclaimed act in history of popular music if you can’t read music? Well, apparently you can: that’s what the Beatles did. I’m probably not going to, but understanding that it’s not impossible is more life-enriching than believing I can’t.
      • “You can’t be trusted.” Rough waters here, mate. If you’ve behaved in such a manner that someone would say this about you, then you’ve got a lot of work in front of you. But no. No matter what, so far, all you’ve demonstrated is that you have been untrustworthy in the past. A true statement about your past is not necessarily a true statement about your future. It’s all about the choices you make from this moment onward.
      Lots of parents and teachers don’t like can’t for its de-motivational qualities. I agree: when you think you can’t, you most likely won’t, because you won’t even try. It’s Chet’s “WONT STREET”.

      When you think clearly about its technical meaning, you can also see that it’s also a word that’s often just not true. I hate being wrong. So I try not to use the word can’t very often.

      Pages

      Subscribe to Oracle FAQ aggregator