ps and top differences with HugePages

The Unix utilities ps and top report memory differently with HugePages than without.

Without HugePages ps seems to include the SGA memory under the SZ column:

UID        PID  PPID  C    SZ   RSS PSR STIME TTY          TIME CMD
... 
oracle    1822     1  0 846155 16232  0 07:19 ?        00:00:00 ora_d000_orcl
oracle    1824     1  0 846155 16228  0 07:19 ?        00:00:00 ora_d001_orcl
oracle    1826     1  0 846155 16236  0 07:19 ?        00:00:00 ora_d002_orcl
oracle    1828     1  0 846155  (more...)

Jonathan Lewis explains Delphix live Sept 18th

Join myself and Tim Gorman as we host a live webinar  and Q&A September 18th at 10am PST  with Jonathan Lewis. Jonathan will explain from his on experiences how Delphix works and what industry problems it solves.

Click here to register for our webinar.

Screen Shot 2014-05-21 at 8.08.47 AM

Screen Shot 2014-05-21 at 8.08.47 AM
Screen Shot 2014-05-21 at 8.08.47 AM

Jonathan explains issues and obstacles to creating “thin clones” on typical industry hardware:

Screen Shot 2013-07-15 at 10.13.05 PM

how point in time snapshots work
Screen Shot 2013-07-15 at 10.12.07 PM

And from point in time snapshots, he explains how clones can rapidly be made.

Screen Shot 2013-07-15 at 10.12.37 PM

Related (more...)

Good Blogs to follow

Good blogs keep popping up and other blogs fade into the back ground, so it’s hard to keep track of the good stuff out there. The following is a list of blogs I have either in the past gotten a lot out of or currently do. It would be great to get comments on what the best current blogs are and then iterate on this list and keep it updated.

Oracle Blogs

Virtual Circuit Wait

On Monday we had some performance problems on a system that includes a database which uses shared servers.  The top wait was “virtual circuit wait”.  Here are the top 5 events for a 52 minute time frame:

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
virtual circuit wait 1,388,199 17,917 13 50.98 Network
db file sequential read 1,186,933 9,252 8 26.33 User I/O
(more...)

CPU-starved LGWR

In my recent post I showed how log file sync (LFS) and log file parallel write (LFPW) look for normal systems. I think it would also be interesting to compare that to the situation when LGWR does not have enough CPU.

I happen to have collected LGWR and database-level trace files for a 11.2.0.3 database on a Solaris 10 server which was under serious pressure (50 threads mostly inserting and committing data, only 32 (more...)

Webinar: 21st Century Education Goes Digital with Oracle WebCenter

Oracle Corporation
Banner
21st Century Education Goes Digital with Oracle WebCenter

Learn how The Digital Campus with WebCenter can address top-of-mind issues for creating exceptional digital learning experiences, put content in context for the user and optimize business processes

The global education market is under-going a fundamental transformation — from the printed textbook and physical classroom to newer digital, online and mobile experiences.  Today, students can learn anywhere, anytime, from anyone on any device, bridging administrative and (more...)

The Oracle ACE programme

I’m proud to be one of the Oracle ACE Directors. Watch the video for some viewpoints on the Oracle ACE program from both Oracle and other Oracle ACEs.

How not to troubleshoot log file sync waits

Introduction

There is a very common mistake in troubleshooting log file sync (LFS) waits: comparing its average time to average log file parallel write (LFPW) and trying to deduce from that whether the root cause of the wait is slow I/O or something else. The fact that this approach is recommended by Oracle itself (e.g. MOS 1376916.1) and many independent experts unfortunately doesn’t make it any less wrong.

Theory

It is well known that averages and ratios can distort the reality (Milsap and (more...)

Openworld bound..

I’ll be in Openworld again this year, and have a couple of speaking slots…

I’ll talk about new features for developers in 12c on Sunday, Sep 28, 2:30 Moscone South 303

https://oracleus.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=2244 

and of course, at the awesome Oaktable world..

http://www.oraclerealworld.com/oaktable-world/agenda/ 

Drop in, learn some cool things, or just pop up and say Hello!


First AZORA usergroup meeting October 23

Just got the invitation to the first AZORA (Arizona Oracle user group) meeting on October 23.  Here is the link: url

It’s 2 pm at Oracle’s office, 2355 E Camelback Rd Ste 950, Phoenix, AZ.

I’m looking forward to it!

– Bobby

Oracle 12c Row Pattern Matching: Beat the Best Pre-12c Solutions at OpenWorld!

Catchy title, don’t you think? My session has been moved to Monday 4 P.M., in direct conflict with Tom Kyte – and Keith Laker, who asked me to present in the first place. Avoid the lines: come see the MATCH_RECOGNIZE clause push great pre-12c solutions into retirement. As a bonus, be the first person on your block able […]

Analyzing Twitter Data using Datasift, MongoDB and Pig

If you followed our recent postings on the updated Oracle Information Management Reference Architecture, one of the key concepts we talk about is the “data reservoir”. This is a pool of additional data that you can add to your data warehouse, typically stored on Hadoop or NoSQL databases, where you store unstructured, semi-structured or unprocessed structured data in large volume and at low cost. Adding a data reservoir gives you the ability to leverage (more...)

OS Watcher Paging Example

I have an example of paging in some Exadata OS Watcher log files.  We got an error in the alert log about a high load but reviewing AWR reports it did not seem like we had an unusual number of active sessions.  Also, the CPU use seemed low but the system load was high.  Reviewing the OS Watcher logs and finding a similar case on Oracle’s support site convinced me that our (more...)

Your Database: The Threat That Lies Within

Databases receive much attention so they will not become THE risk factor of IT. Budgeting DRPs, backups, top of the line DBAs – and yet, they still pose a major threat. Why?

Agile Development

In a fast-moving competitive market, if your competitor delivers relevant products, faster and with better quality, you’re eventually going to lose market share. This is exactly why companies need to be agile.  They need to have better control over information, make (more...)

EBS Clone online procedure

Overview only :

Step 1:

Complete prerequisites on target server see my step by step document

Step 2 :

run adpreclone procedure on database tier and application tier

Step 3 :

copy db, apps, inst to target machine and also change ownership

db — database user

apps,inst — appl user

Step 4 :

take rman backup and copy to target machine

Step 5:

Restore database to target machine using rman

Step 6:

change database name

(more...)

Order of Operation

One response to my series on reading execution plans was an email request asking me to clarify what I meant by the “order of operation” of the lines of an execution plan. Looking through the set of articles I’d written I realised that I hadn’t made any sort of formal declaration of what I meant, all I had was a passing reference in the introduction to part 4; so here’s the explanation.

 

By “order of operation” (more...)

12.1.0.2 Introduction to Zone Maps Part I (Map Of The Problematique)

Zone Maps are new index-like structures that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A zone is simply a range of contiguous blocks within a table. Zone Maps are similar in concept to Exadata storage […]

How to hide login data of sql-scripts on Windows

One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time. According to Arup Nanda in his famous articles on “Project Lockdown” you have three options to run your scripts without letting everybody in on your password secrets:

  1. Start your scripts under /nolog and add your login to the SQL-script your running
  2. Start SQL*Plus under /nolog and add the login at the beginning (more...)

Useless Documentation

Not all documentation is created equal. Too much time is spent on formal design documents that are immediately outdated, and too little is spent on writing code comments.

Useless DocumentationMake sure your process requires and rewards good code comments. And make sure your architecture diagrams are kept up-to-date.

This illustration is from my weekly “Technology That Fits” newsletter – sign up here.

7 Ways Data Virtualization Helps CIOs

IDC study found that Delphix

  1. Pays for itself in 4.3 months
  2. ROI 461% over 5 years
  3. $1 Million storage and hardware savings
  4. $50 Millionannual  savings for companies over 75,000 employees
  5. $78,500 saved per year per 85 employees
  6. $85,000 annua lIT efficiency per 100 employees
  7. 98.6% storage reduction on a 2.42 TB database footprint

Delphix_IDCReport_Infographic

Screen Shot 2014-08-12 at 10.26.54 AM

Screen Shot 2014-08-12 at 10.27.20 AMScreen Shot 2014-08-12 at 10.27.29 AM