About
I am an Oracle DBA who has been doing the job since about 1992. I remember V5 but really started work on V6 and because involved full-time with Oracle when V7 came in.
I have been freelance for 12 years but I am now in permanent employment. I do want to work for a consultancy at some stage as I like working on site although not for 1-2 day gigs but to perform a chunk of work.
I do not profess to be an expert in any way and these blogs will probably cover areas that I did not know or had problems with and try to answer some of the questions I had.
At the moment (April 2008) Streams is my big problem and in particular keeping an archived-log downstream capture database updated with logs from the source database.
Bela Lantos said
Hi,
I’d like to notify you that this theme doesn’t work in Google Chrome (perhaps Apple Safari also) and Opera.
Regards,
Bela
John Hallas said
Thanks Bela, changed the theme today
John
HT said
Hi John,
Your blog (especially your scripts) are an invaluable resource for this junior Oracle DBA. Keep up the great work!
dipti said
please answer my question?
how can i install oracle software remotely or a remote place?
and
wlile the database is up and running ,if a table is lost how can i recover it?
John Hallas said
Dipti, I do not understand the question really. You need access to the server to install software. All access is remote unless you login at the console.
The database running does not make any difference if you install into a different Oracle HOme (new location). You then stop the database and restart it from the new location
Chuck said
John,
Your blog has been helpful in my work. I’m interested in starting a blog as a way to track technical solutions for myself and to share them with others.
Can you offer suggestions, lessons-learned, etc. for starting a technical blog? …WordPress vs. blogspot? …suggested templates for displaying script and output samples? …editing tools?
Thanks much!
Chuck
Chris Brown said
Hi John …I’ve been trying to implement add_coloured_sql procedure on 11g
( you mentioned it at the sig last week )
I can’t find the procedure & the documentation seems confusing as it is refering to ash_report
Any help you can give would be appreciated
regards
Chris B
John Hallas said
Hi Chris, you are making the fundamental mistake of spelling coloured as we would in the UK whilst Oracle is an American product so they spell it colored. The package is dbms_workload_repository and the procedure in question is add_colored_sql. A good worked example of it can be found at http://dioncho.wordpress.com/2009/01/28/colored-sql-innovative-way-to-capture-your-own-top-sqls/
I also blogged about it in 2010 so it must have impressed me then as well. http://jhdba.wordpress.com/tag/add_colored_sql/