Feed aggregator

A secret treasure house of Oracle books

OCP Advisor - Sun, 2012-09-30 19:36
One of the most prolific publishers of Oracle technology and application books - Packt Publishing just published its 1000 cover. Packt books are written by experts, many of whom are Oracle certified professionals. The books full of tips and how-to about new features and functionality that are not covered in-depth in user manuals.

A treasure house of Oracle books is the online library of every Packt publication. To celebrate the 1000th title, Packt is offering free access to the library for a peek at the gems for a 7 day period. Also, one can download one free e-book.

Packt supports many of the Open Source projects covered by its books through a project royalty donation, which has contributed over $4,00,000 to Open Source projects up to now. As part of the celebration Packt is allocating $30,000 to share between projects and authors as part of the weekend giveaway, allocated based on the number of copies of each title downloaded.

Dave Maclean, founder of Packt Publishing based out of Birmingham, UK spoke recently to the media: “At Packt we set out 8 years ago to bring practical, up to date and easy to use technical books to the specialist tools and technologies that had been largely overlooked by IT publishers. Today, I am really proud that with our authors and partners we have been able to make useful books available on over 1000 topics and make our contribution to the development community.”



Just an FYI.  I'll be speaking at

alt.oracle - Sun, 2012-09-30 08:38
Just an FYI.  I'll be speaking at Oracle Open World again this year.  If you're there, my session is as follows.

Session ID:  CON9591
 
Title:  How Oracle Enterprise Manager 12c Brokers Peace Between DBAs and Compliance Officers
 
Abstract
 
This session discusses how to use Oracle Enterprise Manager 12cto completely automate the process of applying database patches while reporting on compliance against your own and Oracle’s security and implementation best practices. Specifically, you’ll learn how to quickly identify databases missing critical patches, how to automate patch applications, and how to maintain compliance on an ongoing basis.

Speakers
  • Steve Ries CSC Database Architect
  • David Wolf Oracle Principal Product Manager
Type: Conference Session
 
Length: 60 minutes
 
Primary Track:  DATABASE:Database Manageability
Categories: DBA Blogs

Adapters, SOA Suite and More @Openworld 2012

Ramkumar Menon - Sun, 2012-09-30 02:46

You are invited to attend my sessions at Oracle Openworld 2012 at San Francisco!

Session Speakers:
Ramkumar Menon, Francis Ip
Session Schedule: Monday, Oct 1, 1:45 PM - 2:45 PM -

Session Location: Marriott Marquis - Salon 7

CON8642 - Cloud and On-Premises Applications Integration using Oracle Integration Adapters

Session Speakers:
Vikas Anand, Ramkumar Menon, Stephen Mcritchie

Session Schedule: Wednesday, Oct 3, 1:15 PM - 2:15 PM

Session Location: Moscone South - 310

And do stop by at the Oracle Integration Adapters Demo booth. Watch some live demos on how you can use our suite of Adapters to integrate and extend your Enterprise Applications! This is your opportunity to meet with our Engineering team, share with us your Integration use-cases and challenges, and hear from us on our Roadmap.

The Oracle Integration Adapters booth is located at the Fusion Middleware Demopod area  from Monday, October 1 through Wednesday, October 3, 2012.

Adapters, SOA Suite and More @Openworld 2012

Ramkumar Menon - Sun, 2012-09-30 02:46

You are invited to attend my sessions at Oracle Openworld 2012 at San Francisco!

Session Speakers:
Ramkumar Menon, Francis Ip
Session Schedule: Monday, Oct 1, 1:45 PM - 2:45 PM -

Session Location: Marriott Marquis - Salon 7

CON8642 - Cloud and On-Premises Applications Integration using Oracle Integration Adapters

Session Speakers:
Vikas Anand, Ramkumar Menon, Stephen Mcritchie

Session Schedule: Wednesday, Oct 3, 1:15 PM - 2:15 PM

Session Location: Moscone South - 310

And do stop by at the Oracle Integration Adapters Demo booth. Watch some live demos on how you can use our suite of Adapters to integrate and extend your Enterprise Applications! This is your opportunity to meet with our Engineering team, share with us your Integration use-cases and challenges, and hear from us on our Roadmap.

The Oracle Integration Adapters booth is located at the Fusion Middleware Demopod area  from Monday, October 1 through Wednesday, October 3, 2012.

Get an eBook for free!

Jornica - Fri, 2012-09-28 07:17
@packtpub publishes its 1000th title. Sign up or login at http://www.packtpub.com and receive a free eBook! #AnOfferYouCannotRefuse

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

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

Pages

Subscribe to Oracle FAQ aggregator