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
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: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Any feedback?

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


Current Time: Tue Oct 23 10:47:42 CDT 2018