Oracle

another way to list invalid objects

How often did I type a query like this to list the invalid objects in a database? select count(*) from dba_objects where status 'VALID'; -- and user in/not in Today I learned another way to do the same. There(…)

2 ways to move archivelogs – both need RMAN

By Franck Pachot . The database must know where are the files. If you move them from the OS, the database will not be aware of it. But there is a database tool to copy or move files and(…)

Buffer pool advisory in AWR

By Franck Pachot . In Oracle memory advisors: how relevant ? I said that advisors are calculating their recommendations from statistics cumulated since the begining of the instance, even in AWR which is supposed to cover only a(…)

Does the block size matter?

By Franck Pachot . The default block size is 8k in Oracle. This is the most common. Sometimes, people create the database with 16k block size for datawarehouses. You can also find some 32k block size, but less common(…)

When a function returns a collection: can you directly reference the index of the returned collection?

As I am still interested in PLSQL I browsed the documentation some days ago and learned something new which is about functions returning collections. Here is a simple test case: Let’s create a simple package,(…)

ODA workshop at Arrow ECS

On the 16th and 17th of June David Hueber, Georges Grey and myself had the chance to attend the ODA hands on workshop at Arrow ECS. Lead Trainer Ruggero Citton (Oracle ODA Product Development) did the first day(…)

What is more efficient: arrays or single columns values? – oracle

In the last post on this topic it turned out that using an array as a column type needs more space than using a column per value in PostgreSQL. Now I’ll do the same test case in Oracle.

using dbms_server_alert in combination with a custom monitoring solution

Lot’s of companies do not use Grid- or Cloud Control for monitoring their Oracle databases for various reasons but rather use open source tools like nagios. And lot of those either implemented custom script frameworks or rely(…)

Show the Top 10 events from latest AWR snapshot

By Franck Pachot . Want to display a specific section from the latest AWR report? I'll share the script I use to get something like that:(…)

Can you have pending system statistics?

By Franck Pachot . Your system statistics seems to be wrong and you want to gather or set more relevant ones. But you don’t want to see all your application execution plans changing between nested loops and hash joins.