UNYOUG

And if that doesn't work (because it produces the error you are trying to send the test case for), and you have views.. this nifty script will pull all table definitions for the views. set pagesize 0 set linesize 120 select DBMS_METADATA.get_ddl ('TABLE',referenced_name,referenced_owner) from dba_de...

If you are using 11.x and you open up a ticket with oracle , they are now asking for a 'test case" when you report your issue.. it is easy to upload, and here is an example of how to upload the test case for "select x from dual" run as app_user.. make sure you've created the directory...

So you're starting to utilize Active Dataguard, and you want to check your explain plan against the your primary... I tried this through TOAD.  No luck.. Most tools use a temporary table to store the explain plan then show it... In order to see the explain plan use select * from table(dbms_xplan.dis...

I was looking through some of the groups I'm a member of and I saw this link.

http://blogs.oracle.com/otn/2009/11/the ... s_and.html

Good stuff.. It lists the most popular articles downloaded from OTN.. A great start to review what other oracle professionals are interested in.

Here the schenario.. You go to update a parameter in your spfile, and the parameter requires to do an "alter system set  ...='..' scope=spfile; You go to start up your database, and it won't start.. You find the change you made isn't compatible.. Your SGA won't work for you box, the parameter w...

If you are as fortunate as I am to use Dual monitors at work and then bring your laptop home, sometimes things don't work right.  I find some applications (like Toad), leave some of the windows on the "second" monitor when you don't have one.  This makes it useless.. Here's how you retriev...

First, many of you are probably asking "what is heterogenous services" ?  Well, simply put, it is  way of connecting your Oracle database to another non-oracle datbase through a database link.. An example of this is to create a database link to SQL Server to pull data, or push data.  This ...

I just had to post this blog out to everyone. http://kevinclosson.wordpress.com/kevin-closson-index/ I have been conversing with kevin on the Oracle forums, and I went to his presentation at Openworld.. He is a brilliant guy, and his blog is worth checking out.. He did an indepth presentation at ope...

I can't guarantee it's not a sales pitch for new features like Active dataguard..  But if you want something free, here it is ... Choose Nov. 4th https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=165673&sessionid=1&key=7AFE7135DE11208F953008C534D7...

I found a couple of great articles on ASM trouble shooting. This one talks about migrating RAW to ASMlib and adding a label http://www.oracle.com/technology/tech/linux/asmlib/raw_migration.html This article has some other suggestions include the "od" command to actually dump the data on yo...

http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=99964&src=6760864&src=6760864&Act=156 Oracle Fusion Middleware 11g Forum - Pittsford, on Thursday, November 5, 2009. Agenda 8:00 a.m. - 8:30 a.m.   Registration & Continental Breakfast 8:30 a.m. - 9:45 a.m.   Keynote: O...

Just coming back from Openworld, I wanted to share what was hot this year.. It was all about Exadata 2 and active dataguard.  Not much talk about DBreplay (though this is a great product).. Exadata 2 is the shiny new toy, and Active dataguard is something people have been asking for.  Other hot topi...

This is what I learned from openworld this year(2009) for those attending next year. 1) Look at the Sunday schedule.  I booked to arrive on Sunday and found a lot of the APEX session I was interested in were only held on Sunday. 2) Check out the unconference. I heard of this, but I didn't put much t...

I just wanted to mention that ASM is a great product for your database.  I, like most people was skeptical as to if it is worth it.. I like cooked file systems.  Cooked, and Direct IO usually gets you there.  I've been forced into ASM with RAC.  Free disk clustering and one vendor to choke can't be ...

I know I have been reminisce in sending out a "top-of-the-week" so here goes.. Have you ever wondering what's in the buffer cache ?  You an run the below query and it will give you  the number of blocks in memory by object, what the table_name is (for indexes) and total blocks for the obje...