Home » RDBMS Server » Performance Tuning » what is ** TRANSIENT: 12029568 (oracle db 11.2.0.3 on solaris)
what is ** TRANSIENT: 12029568 [message #632405] Fri, 30 January 2015 00:28 Go to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
what is ** TRANSIENT: 12029568

Owner Tablespace Name Object Name Subobject Name Obj. Type DB Block Changes % of Capture
** MISSING ** TEMP ** TRANSIENT: 12029568 ** MISSING ** UNDEFINED 436,960 43.62

Report message to a moderator

Re: what is ** TRANSIENT: 12029568 [message #632409 is a reply to message #632405] Fri, 30 January 2015 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

These are objects created during a SQL or program call and disappear afterwards.

Report message to a moderator

Re: what is ** TRANSIENT: 12029568 [message #632739 is a reply to message #632405] Thu, 05 February 2015 03:13 Go to previous message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Any feedback?

Report message to a moderator

Previous Topic: Explain plan
Next Topic: update statement takes too long
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 16 01:45:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.