Stephen Booth

Subscribe to Stephen Booth feed
Stephen Booth
Updated: 3 hours 13 min ago

Search Terms

Mon, 2006-08-07 16:59
Doug Burns recently posted in his journal a list of common search terms that people have used where his journal appeared in the results. I figured I'd post mine (according to Fortunately (or unfortunately) mine are not anywhere near as exciting as his.Perc. Search Term5.80% ora-074454.35% orapwd invalid username password2.90% exception signal: 11 oracle2.90% alter user sys2.90Stephen Booth

Distributed Computing

Tue, 2006-07-18 05:02
This morning someone passed me a link to "The Eight Fallacies of Distributed Computing". Looks pretty accurate. I'd say that many of them are doubly true of RAC.Stephen Booth

Oracle Certified What?

Mon, 2006-07-17 10:20
Just recieved the following email via one of the Oracle DBA lists I'm on:Hello, I am XXX from Singapore.I am also an Oracle Certified Professional(OCP).Could I know size of any database and what's the size of SGA forthat Database and how long it take to complete Logical Backup andPhysical Backup.I will be awiting for ur reply.Thanks in AdvanceRegardsXXXXNames have been removed to protect the Stephen Booth

Another SYSDBA password entry

Thu, 2006-07-06 09:33
Simon Kelsey commeted on one of my earlier entries on this subject that x$kzsrt may be involved:SQL> select * from v$fixed_view_definition where view_name='GV$PWFILE_USERS';VIEW_NAME------------------------------VIEW_DEFINITION--------------------------------------------------------------------------------GV$PWFILE_USERSselect inst_id,username,decode(sysdba,1,'TRUE','FALSE'), decode(sysoper,1,'Stephen Booth

Oracle answers on the SYSDBA password question

Tue, 2006-07-04 10:41
QUESTION=========1) Does Oracle cache the SYSDBA password?2) Is there a way to force it to re-read the password file to pick up a changed password without having to shutdown thedatabase?RESEARCH=========Note.1029539.6 - UNIX How to Set up the Oracle Password FileNote 185703.1 - How to Avoid Common Flaws and Errors Using PasswordfileNote 114384.1 - WIN: Checklist for Resolving CONNECT AS SYSDBA (Stephen Booth