Ask The Oracle Mentors

Recently Answered

	Daily Insert, Delete on table I have a table tb_card_dataCARD_NO TYPE EMAIL MODULE CREATED_ON SEQ_NO------- ---- ----- ------ ---------- ---------12345 C x@a.com MOD_1 06/03/2017 20170306000001 (create_on + sequence number)..so on around 500k records for MODULE - MOD_1around 500k...
	Session wise rank ,change in value should lead to new rank Hi Tom,I need help to get sequence no or rank whenever there is change in continuous sequence below is the example-Input seq,id,value 1,1,2002,1,2003,1,3004,1,2005,1,2006,1,5007,1,5008,1,700expected out put same combination of id,value as per sequen...
	Impact on importing oracle predefined java libraries Hi Tom,I am trying to import below predefined java libraries to identify the language of the given text. Is there any impact on the data base by importing these libraries like such as slowness or any application connecting to database. loadjava -u DB_USER orai...
	DB upgrade guidelines/ practices in enterprise applications Dear Team,As in any enterprise application, we have many in-house developed Microsoft.NET applications that connect to a central DB, Oracle 10G in this case. We have many web-services based on REST/ SOAP, Microservices, Oracle Reports, small tools and utilitie...
	RAC cluster_interconnect config Hi Tom,Is it ok to use Fiber and Ethernet for cluster_interconnect type mixed?Ex.ib0 192.168.3.0 global cluster_interconnect,asm ==> InfiniBand Fiber Interfaceeno4 192.168.5.0 global cluster_interconnect,asm ==> Fast Ethernet InterfaceAny potential risk on ...