| 
		
			| Re: DBMS PIPE [message #369137] | Thu, 16 March 2000 14:55 |  
			| 
				
				
					| rajeshwar reddy Messages: 2
 Registered: March 2000
 | Junior Member |  |  |  
	| hi tripathi 
 I think u'r talking about pining object in memory for fater run.we can put some packages directly in memory like dbms_sharedpood.keep('package_name');
 overheads it will occupy memory in sga.once u finish u'r application take package from memory.
 dbms_sharedpool.unkeep().
 
 why we use PIPE in oracle:
 a database pipe is independent of OS and it will
 be used Different sessions connected to the same
 instance can send and receive messages over pipe
 
 if u have any query get back to me
 bye
 |  
	|  |  |