Search

Top 60 Oracle Blogs

Recent comments

May 2014

Data masking made easy with agile data

 

How long does it take you to make a copy of production, find the sensitive data, mask that data and then make multiple copies for development and QA? Hours? Days? Weeks? Months? How about a few minutes.

Check out the new data masking module in the Delphix agile data appliance.

 

Graphing Oracle v$sysstat

#555555;">One thing I’ve failed to clearly document is that my tool #2970a6;" href="http://ashmasters.com/ash-tools/">ASHMON not only graphs ASH data but graphs v$sysstat as well.

#555555;">To access statistics in ASHMON click on the “functions” menu and choose “stats”. ( the other choices are “ash init” which goes the the ASH data graph and the third choice is “waits” which graphs data from v$session_event)

#555555;">Graphing v$sysstat can be overwhelming as the number of statistics is in the hundreds, so what does one look at? The important statistics are what I concentrate on now, but that list is another discussion and up for debate. On the other hand when one wants to explore the stats over time how can one do it in a way that is manageable?

10053 trace

I published a note yesterday about enabling SQL trace system-wide for a single statement – and got a response on twitter from Bertrand Drouvot referencing a blog post he’d done a few months ago about using a similar method to dump the optimizer trace (10053) for a statement whenever it was optimized.

10053 trace

I published a note yesterday about enabling SQL trace system-wide for a single statement – and got a response on twitter from Bertrand Drouvot referencing a blog post he’d done a few months ago about using a similar method to dump the optimizer trace (10053) for a statement whenever it was optimized.

Simora: Alpha Testers Confirmed

It’s been a while since I provided any public updates regarding Simora, our Oracle workload simulation product. It’s finally time to unveil the status of Simora and our steps moving forwards. We have been working extensively on the Simora engine and infrastructure over the  last several months, with a view to transforming it into a … Continue reading "Simora: Alpha Testers Confirmed"

Simora: Alpha Testers Confirmed

It’s been a while since I provided any public updates regarding Simora, our Oracle workload simulation product. It’s finally time to unveil the status of Simora and our steps moving forwards. We have been working extensively on the Simora engine and infrastructure over the  last several months, with a view to transforming it into a … Continue reading "Simora: Alpha Testers Confirmed"

Simora: Alpha Testers Confirmed

It’s been a while since I provided any public updates regarding Simora, our Oracle workload simulation product. It’s finally time to unveil the status of Simora and our steps moving forwards. We have been working extensively on the Simora engine and infrastructure over the  last several months, with a view to transforming it into a … Continue reading "Simora: Alpha Testers Confirmed"

EM12c- Dealing with Unknown Targets

Most of you know I don’t like #ff00ff;">pink, but I also am not a fan of #ffff00;">yellow.

Virtual Cloning Oracle EBS stack in minutes

#555555;" align="left">#2970a6;" href="http://www.kylehailey.com/sample-page/current/">

How does one clone in a few minutes and for almost no storage the entire EBS stack including the database, EBS application stack and Oracle binaries, no matter the size?

Watch this quick easy demonstration of doing just that with Delphix:

sql_trace

Here’s a convenient aid to trouble-shooting that appeared in 11g with its enhancements to setting events. It’s a feature that may help you to work out (among other things) why a given statement seems to have a highly variable performance profile. If you can find the SQL_ID for a parent cursor you can enable tracing for just that cursor whenever it executes, whoever executes it.