oracle数据库问题 [英] Issue on oracle database

查看:93
本文介绍了oracle数据库问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

当我们最终创建一个表格时,它将作为file.if格式存储到我们的硬盘中。如果我在oracle数据库中删除了一个记录,那么该记录将从硬盘中的文件中删除,但它不会释放内存。



我怀疑它在oracle中的优势或劣势,以及为什么它不会在从table.please删除记录后释放内存。请帮助我。



我尝试过的事情:



i正在考虑这个问题1小时但没有得到任何澄清在这个。

when we create a table finally that will store into our hard disk as a format of file.if i delete a record fom a table in oracle database that record will be deleted from file in hard disk but it will not release memory.

My doubt its advantage or disadvantage in oracle and why its not going to release memory after delete record from table.please help me on this.

What I have tried:

i was thinking about this for 1 hour but didnt get any clarity on this.

推荐答案

数据库使用内存进行缓存结构和性能优化,当引擎达到内部内存限制时,删除操作会及时影响它,以保证释放内存。



不要想太多,先开始阅读这个主题。
Databases use memory for cache structures and performance optimizations, your delete actions will effect it in time when the engine reaches internal memory limits that warrant freeing up memory.

Don't think too much, start reading up on the subject first.


这篇关于oracle数据库问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆