ora2oracle.blogspot.com
Ora? err... Ora ERR... Oracle!: November 2005
http://ora2oracle.blogspot.com/2005_11_01_archive.html
Err Ora ERR. Oracle! Searching for that elusive solution to the often heard ORA-XXXXX error, and finding interesting tidbits along the way! Wednesday, November 09, 2005. The Advantages of Patching Part II. This is a second part to "The Advantages of Patching". See the previous entry. Ok, now that I've gotten the patching issue over with, what's the next step? I'm going to do some testing against the application, of course. STEPS TO A] SOLUTION (1):. Turning on the feature to get the tracefiles*. Finally ...
blog.psftdba.com
The PeopleSoft DBA Blog: PeopleTools 8.54: Performance Performance Monitor Enhancements
http://blog.psftdba.com/2015/03/peopletools-854-performance-performance.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Tuesday, March 10, 2015. PeopleTools 8.54: Performance Performance Monitor Enhancements. This is part of a series of articles. About new features and differences in PeopleTools 8.54. That will be of interest to the Oracle DBA. Transaction History Search Component. There are a number of changes:. ROUND( CAST( CAST(SYSTIM...
blog.psftdba.com
The PeopleSoft DBA Blog: July 2012
http://blog.psftdba.com/2012_07_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Thursday, July 19, 2012. Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects. Recently, I have been looking into how to gather cost-based optimizer statistics on composite partitioned objects. I have now published the second of two documents on my website. That examine aspects of statistics on pa...
wayne-lang.blogspot.com
Oracle DBA: March 2011
http://wayne-lang.blogspot.com/2011_03_01_archive.html
Diary from a DBA deals with Oracle technology. Monday, March 14, 2011. Saturday, March 12, 2011. Many faces of an Oracle data block. There are all kinds of data block in Oracle database, such as table segment block, index data block, undo segment block, or data file head block, to name a few. Let’s just talk about the table data block for now. Subscribe to: Posts (Atom). Many faces of an Oracle data block. View my complete profile. The Arup Nanda Blog. No Data Loss without Sync Data Guard.
dbrat.blogspot.com
Adventures In DBAsitting: OMG What Do I Do? - "The database is slow!" - Part II
http://dbrat.blogspot.com/2011/03/omg-what-do-i-do-database-is-slow-part.html
OMG What Do I Do? The database is slow! Okay, when we last left our heroine, she was bravely dodging the arrows of slow databasity. Well, here's the thing. When someone says their database is slow, what does this mean? I don't mean what's causing it, I mean what is the client really trying to say? Me: "Oh my god! It's just. creeping! Sr DBA DE: "Hmm. When did this start? As he types on something completely unrelated in the background.). Me: "Um, when? Me: Trying not to have the panic show in my voice, I ...
dbrat.blogspot.com
Adventures In DBAsitting: June 2012
http://dbrat.blogspot.com/2012_06_01_archive.html
What-What © Duplicate Clone using RMAN. Seriously, a duplicate clone using RMAN is about the most fun anyone can do with a database. why? Because it's EASY. It WORKS. It never ever goes WRONG. So here's what to do. step by step. Refreshing a test database from a production database using RMAN duplicate (UNIX SYSTEM). Verify Server name Database name and Database version on both production and test sides. Check mount point of TARGET (PRODUCTION) and AUXILIARY (DEV/TEST) databases. Instance name @ hostname.
dbrat.blogspot.com
Adventures In DBAsitting: REFRESHING A DATABASE
http://dbrat.blogspot.com/2011/07/refreshing-database.html
No, this is not about how cool and refreshing a database can be, although I certainly do think they can be. This is like one of the most important things a database administrator can do, and just like everything else we do in our jobs there are like 10 DIFFERENT WAYS TO DO IT! So, first way to refresh and the easiest, I swear, is doing a duplicate from a cold backup. OMG, you say, I can't bring my production database down for ANY amount of time, love, nor money! Whatever shall I do! A little background&#...
dbrat.blogspot.com
Adventures In DBAsitting: How Do I Do That? - Installing a pks, pkb file
http://dbrat.blogspot.com/2011/03/how-do-i-do-that-installing-pks-pkb.html
How Do I Do That? Installing a pks, pkb file. S" before "B" when using the "P". Just when I was feeling a little more secure in tidbits of knowledge, I got a request from a client today. Please run a simple SQL statement in Production. Okay", I thought, "Here goes! Then I got another request two minutes later. Please run these two attachments. Attachments: ThingOne.pkb; ThingOne.pks]. What was I supposed to DO with them? Was I supposed to RUN them? Was I supposed to import them into a schema? Sr DBA R sh...
dbrat.blogspot.com
Adventures In DBAsitting: July 2011
http://dbrat.blogspot.com/2011_07_01_archive.html
OMG What Do I Do? The database is slow! So, the last time I wrote an epic adventure about my databasing, it was like, three months ago. I've learned a LOT in the last three months. More vi practicing, how to refresh a database, how to do datapump imports and exports, moving lobs. in fact I am going to move a lob today! Four of them in fact! I'll post about that later. What I really wanted to discuss quickly was how the smallest of changes can really F*& up how a database coughs up information to users.
SOCIAL ENGAGEMENT