Skip to Main Content
  • Questions

  • Can you shed some light on this ora error [session idle bit]

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, naresh reddy.

Asked: February 21, 2018 - 8:26 pm UTC

Last updated: February 23, 2018 - 12:35 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

SYS@XYZ> select sum(ksmchsiz) ||' bytes' "ToSHRPOOLMem" from x$ksmsp;
^C


^C
select sum(ksmchsiz) ||' bytes' "ToSHRPOOLMem" from x$ksmsp
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [504], [0x1F6B71B9B0], [128], [1],
[session idle bit], [102], [0x000000000], [], [], [], [], []
Process ID: 48696
Session ID: 43061 Serial number: 62896


basically ran that query to investigate any contentions or fragmentation errors on shared pool area. and cancelled the operation and internal error occurred with that error.

and Connor said...

"session idle bit" is a flag that indicates when a session is transitioning between active and inactive states.

But well...you went querying a critical memory structure ... which is in active use by all processes.... You should be glad you got an ORA-600. You could have brought down your entire instance!

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

But sir

Gh, February 22, 2018 - 8:19 am UTC

You should be glad you got an ORA-600. You could have brought down your entire instance! 

But since when in a solid database such as Oracle a simple query SELECT could break an instance? If Oracle permit SYS to query his own tables it could manage reliable fitted exceptions .for instance worst may be a ora600.
Could you elaborate your previous answer?
Connor McDonald
February 23, 2018 - 12:35 am UTC

You are not querying a table - you are querying an X$ object.

Have a lookin v$fixed_view_definition and see if *ever* expose that object to the calling environment..... nope, never.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database