Skip to main content
Oracle Database Architecture:

oracle db is split into 2 parts : logical + physical

logical= memory + background process
memory here means the physical memory which is assigned to oracle bg process are some mandatory process which run to maintain the database sanity.

physical = all the files which actually contain the data which the end user want to hold on a database.


Comments

Post a Comment

Popular posts from this blog

Linux Installation on a VM to install Oracle 19c database.

 1) Configure VM Create New VM during which you will have to select below list of parameters ⦁ VM Name ⦁ VM Machine files location ⦁ OS Type ⦁ Version ⦁ Ram allocation from physical Ram available on host machine (here Windows 10) ⦁ Select “Create a virtual hard disk now” as we are building a new machine. ⦁ Finally click on create it will open a new window where it will ask some details for  ⦁ disk size ⦁ disk type ⦁ disk allocation type.  Click on settings and new window will open then we have to do some changes here in all tabs. General >> General >> Advanced >> Shared Clipboard >> Bidirectional General >> Advanced >> Drag n Drop >> Bidirectional 2A. System ⦁ Motherboard>>Unselect Floppy A) System ⦁ Processor increase the number of cpus if you have resources  Storage >> Here we have to add more storage when required for Grid Home, Oracle Home, Asm Disks….etc For now we have left it with ...
Post a Comment
Read more

Typical Shift for a Oracle DBA

. Usually We start by checking on call mailbox for any alerts/issues like following OEM Alerts Mount point full Tablespace alert Listener down Server down Backups failuer . Shift handover report, it contains pending request. . Daily tickets/Incidents by using available ticketing tool. .Daily scheduled Change Req & Service Req as per schedule. . Alert log error checking. . Verify all instances are online. . Check tablespaces should not be used more that 95% . Check all last night backups were successful. . Check OEM Alerts and resolve them. . Schema level refreshing by using exp/imp, expdp/impdp. . Explaining the plans for particular table to tune the databases. . Taking backups by using RMAN on daily and weekly basis.
Post a Comment
Read more

15 Things fresher DBA must know

This blog post is a quick summary of How to become a DBA course – A 100% free course which speaks about everything you need to become an Oracle DBA. Learning SQL is just not enough to become an Oracle DBA. You need much more skills and learn other things to crack your first job interview. In this blog post, I would like to talk about 15 things you must know as a Junior (Fresher) DBA even before you would like to start your career as database administrator. 1. Linux Administration 98% of the servers in all the MNCs out there use Unix or Linux operating system. It is obvious that the Oracle database you will be working on would also be hosted on some Linux server. And, not having good hands-on knowledge on Linux will be one of the biggest road blocks in your path to become a DBA. 2. Virtualization Now that you know the importance of Linux operating system, the next big question is how to practice it. In order to learn Linux, you need to install it on your laptop (or desktop) to master it...
Post a Comment
Read more