Explore what is an MCP server in and how Oracle’s MCP server in SQLcl is reshaping AI-to-database integration, connecting AI models directly to Oracle with secure, real-time intelligence.
In this post we will look at the Online Redo Log which consists of physical files that store redo records, capturing changes made to the database. These records are crucial for the recovery process, as they facilitate “roll forward” of committed changes and “roll back” of uncommitted ones.
In this back-to-basics we go into what a database instance is. We view key components like the System Global Area (SGA) and background processes such as PMON and DBWn that ensure efficient memory management and data integrity. Understanding instances is crucial for database performance and administration.
Confused about Oracle Undo Records and their role in database management? This guide breaks it down, explaining how undo data supports read consistency and transaction rollback. Whether you’re a DBA or a developer, mastering undo records is key to maintaining data integrity and performance.
Unlock the power of Oracle OCI, Terraform, and Infrastructure as Code with this blog series. In this third entry from beginner basics to advanced techniques, we discuss the CIS Foundations Landing Zone, how to use complex data types and for Expressions, and how they are used in Terraform.
Unlock the power of Oracle OCI, Terraform, and Infrastructure as Code with this blog series. In this second entry from beginner basics to advanced techniques, we learn how what a provider, datasource and TF variables are used in Terraform.
I haven’t written a blog in a while, and I feel that I have made a couple of mistakes lately that could have easily been avoided if I had done my tasks as IaC ( Infrastructure as Code). So I will start a series of
Currently I am an Oracle ACE ; Speaker at Oracle Open World, Oracle Developers Day, OTN Tour Latin America and APAC region and IOUG Collaborate ; Co-President of ORAMEX (Mexico Oracle User Group), Web Events Chair for IOUG Cloud Computing Special Interest Group (SIG) ; At the moment I am an Oracle Project Engineer at Pythian
Loading Comments...
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.