Splunk DB Connect is returning only the first 5 records from an Oracle XE database
Issue was related to Database not DBconnect
Please share the resolution in case others have a similar problem.