Search found 88 matches
- Wed Dec 23, 2009 12:30 am
- Forum: DBA Topics
- Topic: Creating a Test case for Oracle
- Replies: 1
- Views: 8615
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...
- Tue Dec 22, 2009 11:13 pm
- Forum: DBA Topics
- Topic: Creating a Test case for Oracle
- Replies: 1
- Views: 8615
Creating a Test case for Oracle
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...
- Fri Dec 11, 2009 12:50 pm
- Forum: DBA Topics
- Topic: Getting an explain plan in ADG (active dataguard)
- Replies: 0
- Views: 8316
Getting an explain plan in ADG (active dataguard)
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...
- Tue Dec 08, 2009 12:46 am
- Forum: DBA Topics
- Topic: Most popular OTN downloads
- Replies: 0
- Views: 5386
Most popular OTN downloads
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.
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.
- Tue Dec 08, 2009 12:20 am
- Forum: DBA Topics
- Topic: what to do if you mess up your SPFILE
- Replies: 0
- Views: 4422
what to do if you mess up your SPFILE
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...
- Tue Nov 17, 2009 9:28 pm
- Forum: DBA Topics
- Topic: Toad and Dual monitors.
- Replies: 0
- Views: 6508
Toad and Dual monitors.
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...
- Thu Nov 12, 2009 11:08 pm
- Forum: DBA Topics
- Topic: Heterogeneous services
- Replies: 0
- Views: 5679
Heterogeneous services
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 ...
- Tue Nov 03, 2009 2:11 pm
- Forum: DBA Topics
- Topic: Your favorite blog
- Replies: 1
- Views: 5074
Your favorite blog
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...
- Mon Oct 26, 2009 7:15 am
- Forum: DBA Topics
- Topic: Online presentation on 11gr2 new features
- Replies: 0
- Views: 4454
Online presentation on 11gr2 new features
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...
- Sat Oct 24, 2009 8:50 pm
- Forum: DBA Topics
- Topic: ASM troubleshooting
- Replies: 0
- Views: 5001
ASM troubleshooting
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...
- Tue Oct 20, 2009 12:02 pm
- Forum: Other Tech Events
- Topic: Oracle Fusion Middleware 11g Forum - Pittsford, November 5,
- Replies: 0
- Views: 8767
Oracle Fusion Middleware 11g Forum - Pittsford, November 5,
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...
- Sun Oct 18, 2009 10:57 pm
- Forum: DBA Topics
- Topic: Openworld 2009.. what was Hot
- Replies: 0
- Views: 4482
Openworld 2009.. what was Hot
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...
- Sun Oct 18, 2009 10:11 pm
- Forum: DBA Topics
- Topic: Openworld - Lessons learned for next year
- Replies: 0
- Views: 4589
Openworld - Lessons learned for next year
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...
- Wed Sep 30, 2009 3:44 pm
- Forum: DBA Topics
- Topic: ASM
- Replies: 0
- Views: 4338
ASM
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 ...
- Mon Sep 28, 2009 3:41 pm
- Forum: DBA Topics
- Topic: Tip-of-the-week viewing your Shared Pool
- Replies: 0
- Views: 4235
Tip-of-the-week viewing your Shared Pool
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...