v$sql和v$sqarea有什么区别？

棉花糖ONE

child_number为０有什么问题吗

棉花糖ONE

SQL> create table test(id int);

表已创建。

SQL> select * from test;

未选定行

SQL> select name,kept from v$db_object_cache where name='select * from test';

NAME
-------------------------------------------------------------------------------
KEP
---
select * from test
NO

select * from test
YES