UNYOUG

Here is how I spent my morning..
http://bryangrenn.blogspot.com/2011/01/ ... cking.html

Check Out Alex Gorbachevs great presentation.. If you understand RAC enough to know split brain etc. the visuals will explain it all !!

http://www.tcoug.org/agenda/Gorbachev_presentation.pdf

Here is a great article on how to find your upgrade issues with the optimizer.


http://coskan.wordpress.com/2011/01/17/ ... ce-stories.

Ash is an often overlooked tool (part of the performance pack), that is a treasure trove of information on session executions..  I will probably post more information, and even do a future presentation on it.
Here is a good start.. Check out the ASH masters.

http://ashmasters.com/about/

This just out from Tanel Poder

http://blog.tanelpoder.com/2011/01/11/p ... igrations/

This is an Awesome presentation. (Tanel is a very smart guy that shares a lot of great information).

I used these 2 lines to make aliases for all my datafiles, then rename them to the alias.. This helped with a smoother RMAN active database duplicate.  Otherwise it can get confused set linesize 160 set pagesize 0 select 'alter diskgroup DATA add alias ''' || substr(name,1,instr(name,'.')) || 'dbf''...

I have been playing with sql_profiles, and cardinality issues regarding GTT's.. I have a bunch of information on my blog at

http://bryangrenn.blogspot.com

Here is a greate article on Clonedb, and I will update as Kevin posts more information

http://kevinclosson.wordpress.com/2010/ ... re-part-i/

Here is a Great post on Goldengate and the size of the trail files..

http://afatkulin.blogspot.com/2010/12/o ... -size.html
I never thought of these things, and Kudos to Alex to pointing this out.

Here is a great presentation from Randolf Geist, that he just posted.

http://oracle-randolf.blogspot.com/2010 ... -live.html


Enjoy.

I haven't really mentioned GG before.. I know this topic has been mentioned at previous UNYOUG meetings, and I ran across these this great writeup on how it works...  I thought I would pass this along. http://www.pythian.com/news/7225/oracle-goldengate-extract-internals-part-i/ http://www.pythian.co...

I don't know how many of you Tweet professional (rather than tweet when you changed your kids diaper).  If you do tweet professionally send me your username so I can follow you. There is a lot of interesting people that tweet, and they tweet useful stuff too !!   @oraclenerd @dannorris @gregrahn @or...

I am using profiles for some very stubborn queries. I wanted to know what the profile really looks like. It looks like Oracle has significantly changed the way it stores profiles with 11g.. Here is the query I am using to view what is out there for them.. Enjoy. select name,hint,sql_text from ( SELE...

I have been having issues with sql_profiles going stale, and here is everything I have found on the topic.

http://bryangrenn.blogspot.com/2010/12/ ... files.html

Enjoy

I just thought I would pass this along, since I this might interest some people.. https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=255261&sessionid=1&key=FA23A52342C29BEA3655195EE875D321&partnerref=EMAIL2&sourcepage=register Join us for t...