This forum is currently locked. You can't register or post questions at this time. (read more)

How to keep in memory of all oracle architecture etc

All posts relating to Oracle database administration.

Moderator: Tim...
Posts: 8
Joined: Tue Nov 19, 2013 8:32 pm

How to keep in memory of all oracle architecture etc

Postby » Tue Nov 19, 2013 8:39 pm

Dear Sir,

Could you suggest me, how to keep in memory of all oracle topics?

Anil Kumar

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: How to keep in memory of all oracle architecture etc

Postby Tim... » Tue Nov 19, 2013 8:56 pm


I have no idea. I certainly can't. The trick is to keep reading and trying to learn stuff, but concentrate on the important stuff like concepts. Trying to memorise syntax is a waste of time. That is what the manuals are for. Almost everything on my website is there for my convenience so I have a copy/paste starting point. I could not complete many tasks from memory without referring back to my website of the manuals. I don't have time to memorise all contents of my website, let alone the manuals. The important thing to remember is what is possible and what is not. Knowing a feature is available and why it should be used is probably more important than remember the syntax. :)

For example, if someone says to me, "My backups take ages. How can I improve the speeed?", I think, "Perhaps incrementally updated backups and block change tracking will help?" I could not remember the syntax of these off the top of my head, even though I currently use them for all my backups. Fortunately, I can you use manuals, or even easier, use the stuff I wrote on it. ... ed_backups ... al_backups

See, the concept and the reason for using the feature is more important than knowing specifics about it...

Of course, the more you use something, the better you get a remembering it.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 3 guests