Category: Blog Post
-
Heat Map Visualization of I/O Latency with SystemTap and PyLatencyMap
Heat Map Visualization of I/O Latency with SystemTap and PyLatencyMap Topic: PyLatencyMap v1.2 a tool for collecting and visualizing I/O latency data collected and about its integration with SystemTap. Introduction: When studying storage performance latency drill-down can be very important. Measuring the average I/O latency is often not enough, latency histograms are proven to be
-
Potential of “import catalog” command
Potential of “import catalog” command Since version 11.1 of Oracle database, there is very useful command available, allowing DBAs to easily move RMAN recovery catalog schemas between databases. Its functionality is even broader, as it also allows one catalog schema to be merged into another – either the whole schema or just the metadata of
-
Oracle Weblogic SAML2 Authorization
Oracle Weblogic SAML2 Authorization Grammatically the title has no much sense, but those were the keywords that I used to type a couple of years ago when I started to work in the integration of our JEE applications into our SSO system. Oracle Weblogic provides a module that supports the SAML2 protocol. SAML, Security Assertion
-
Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization
Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization Topic: This post is about the latest updates to PerfSheet4 v3.7 (February 2015). PerfSheet4 is a tool aimed at DBAs and Oracle performance analysts. It provides a simplified interface to extract and visualize AWR time series data using Excel pivot charts. Why
-
Datafile without backups – how to restore?
Datafile without backups – how to restore? Have you ever had a problem with restoring datafiles without any backups available? It’s easy, of course if you have all archived logs from the time datafile was created. Please check it here: Re-Creating Data Files When Backups Are Unavailable. Moreover, RMAN is clever enough to create empty
-
Talks at UKOUG TECH 2014 with CERN speakers
Talks at UKOUG TECH 2014 with CERN speakers This is a short blog post with a list of the talks at the UKOUG TECH 2014 conference in Liverpool with CERN speakers. Come and say hi, we hope to see many of you there! (*) slides also available at: http://cern.ch/canali
-
Life of an Oracle I/O: tracing logical and physical I/O with systemtap
Life of an Oracle I/O: tracing logical and physical I/O with systemtap Topic: This post is about tracing logical and physical reads in Oracle using SystemTap. You find here a few examples illustrating the main mechanisms used by Oracle to performo physical and logical I/O and you learn how to build SystemTap scripts to further
-
A Summer at CERN: Evaluating OpenStack Trove as DBaaS Solution
A Summer at CERN: Evaluating OpenStack Trove as DBaaS Solution I have been one of the 23 students participating in the CERN openlab summer student programme this year. Like two of my fellow students in the database group, Sneha and Anti already did, I want to share some insights into the project I worked on
-
Importance of testing yours backup strategy
Importance of testing yours backup strategy Most of you for sure know, that ability to restore data in case of failure is a primary skill for each DBA. You should always be able to restore and recover data you’re responsible for. This is an axiom. To be sure, that you’re able to do it, you
-
Oracle OpenWorld 2014 and JavaOne 2014 sessions from CERN
Oracle OpenWorld 2014 and JavaOne 2014 sessions from CERN This is a short blog post about the sessions being given by CERN people at the Oracle OpenWorld 2014 and JavaOne 2014 conferences: Do not hesitate to ask us about CERN or CERN openlab.