Challenges of Maintenance and Improvment of Data Bases and Virtual Mchines on ODAs

Track

DBA

Date and time

Friday, 18. October 2019., 09:30

Room

Hall A

Duration

45'

This paper presents the possibility of exploiting and improving the database state in the Oracle database appliance. It starts from the internal physical organization to logical organization at the database level and virtual machines/servers level. Instead of the classic disk redundancy protection using the old RAID 0,1,5 redundancy, ASM (Automatic server management) is used as a software designed data protection on disks. At the next level, an ACFS Oracle file system is used, which is also used by the databases as the logical space for placing datafiles. The topics of the division of ODA into sections using the database (DOM1) with the associated set of licenses and the part that can be used by virtual machines/servers for different purposes are also discussed. Topics were discussed how the increase of data in the tables has impact on the database performance, but also on the reduction of data redundancy, the impact on the complexity of the index structure, the use of partitioned tables, and the possibilities and ways of their archiving. It also shows the ability to create databases on remote disks outside the ODA device where the database instance is actually using the ODA device for data processing. We will also see how to configure new virtual machines on these devices and how they use space and processor with the corresponding set of licenses.

Lecture details

Type: Lecture
Level of difficulty: Expert
Experience Level: Experienced
Desirable listeners function: DBA , Developers , svi
Group of activity: DBA

About speaker

The Best Sponsor

Better Sponsor

Educational Sponsor

Media Sponsor

HrOUG.hr

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Twitter

Keep yourself up to date with all updates!

Follow us on Facebook