Search

Top 60 Oracle Blogs

Recent comments

August 2018

Download your SR content from MOS

You may want to keep track of your Oracle Service Requests offline. Or simply be able to read them as simple text. Here is a simple way to download all of them to a simple text file.

First, it is easy to get a list of the Service Requests as an Excel file. Just list them on the GUI. You may choose:

  • The Support Identifiers (CSI) on the right
  • Only SR where you are primary contact or all of them, with the ‘person’ icon
  • Include closed SRs with the red check icon
  • The columns: View -> Columns -> Show all

And then View -> Export to XLS

The service_requests.xls is actually in XML format which is easy to parse, but you can also convert it to CSV. Here I have saved it to service_requests.csv

Then with AWK and LYNX installed here is how to get each SR into text:

Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!

It’s almost the beginning of September, time to get back to school, everyone!
I recently decided to do my Oracle SQL Tuning and Performance & Troubleshooting training classes again. So I will also run some free hacking sessions for promoting these classes, but also for sharing cool new stuff with people who can’t attend the training and of course for fun too!
The hacking sessions do not follow a formal training structure, have very few or no slides at all, just live demos of putting performance tools & techniques into use!

Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!

It’s almost the beginning of September, time to get back to school, everyone!
I recently decided to do my Oracle SQL Tuning and Performance & Troubleshooting training classes again. So I will also run some free hacking sessions for promoting these classes, but also for sharing cool new stuff with people who can’t attend the training and of course for fun too!
The hacking sessions do not follow a formal training structure, have very few or no slides at all, just live demos of putting performance tools & techniques into use!

Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!

It’s almost the beginning of September, time to get back to school, everyone!
I recently decided to do my Oracle SQL Tuning and Performance & Troubleshooting training classes again. So I will also run some free hacking sessions for promoting these classes, but also for sharing cool new stuff with people who can’t attend the training and of course for fun too!
The hacking sessions do not follow a formal training structure, have very few or no slides at all, just live demos of putting performance tools & techniques into use!

Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!

It’s almost the beginning of September, time to get back to school, everyone!
I recently decided to do my Oracle SQL Tuning and Performance & Troubleshooting training classes again. So I will also run some free hacking sessions for promoting these classes, but also for sharing cool new stuff with people who can’t attend the training and of course for fun too!
The hacking sessions do not follow a formal training structure, have very few or no slides at all, just live demos of putting performance tools & techniques into use!

How to Linux for the SQL DBA Articles on Simple Talk

I’ve started to write a series of articles on Simple Talk from Redgate on Linux for the SQL Server DBA.  Thanks to Kathi Kellenberger, who came to my pre-con in Indianapolis SQL Saturday and then asked if it was something that I’d be up to doing.

The biggest challenge when doing one hour sessions on Linux at SQL Saturdays is that you find out, one hour is just no where, near enough.  The eight hour pre-con we get to dig in deeper, actually work through a number of labs and I feel like students leave with a better grasp on how to work with this new operating system in preparation for managing a database on it.

RTFM ?

My entrance at the Polish Oracle User Group conference 2017 has just resurfaced on Twitter. There is a back-story to this which contains an allegorical lesson in using Oracle. As I said in the opening remarks in the subsequent presentation: “The lesson began before I got to the stage”.

Like all the other speakers at POUG2017 I had received an email asking me to name a tune for a playlist. Having decided that Beethoven, Brahms and Tchaikowski were not the sort of composers the organisers had in mind I nominated (with a touch of irony) “Who wants to live forever?” by Queen (despite Richard Foote’s strenuous efforts to turn the Oracle world to David Bowie).

COMMIT

By Franck Pachot

.
COMMIT is the SQL statement that ends a transaction, with two goals: persistence (changes are durable) and sharing (changes are visible to others). That’s a weird title and introduction for the 499th blog post I write on the dbi-services blog. 499 posts in nearly 5 years- roughly two blog posts per week. This activity was mainly motivated by the will to persist and share what I learn every day.

COMMIT

By Franck Pachot

.
COMMIT is the SQL statement that ends a transaction, with two goals: persistence (changes are durable) and sharing (changes are visible to others). That’s a weird title and introduction for the 499th blog post I write on the dbi-services blog. 499 posts in nearly 5 years- roughly two blog posts per week. This activity was mainly motivated by the will to persist and share what I learn every day.