oracle 使用 mybatis select in 10000问题怎么解决

 			int listSize = authKeyIds.size();
            int toIndex = 10000;
            List<List<String>> myList = new ArrayList<>();
            for (int i = 0; i <listSize; i += 10000) {
                //作用为toIndex最后没有toIndex条数据则剩余几条newList中就装几条
                if (i + 10000 > listSize) {
                    toIndex = listSize - i;
                }
                //分割lst
                List<String> newList = authKeyIds.subList(i, i + toIndex);
                //写入myList，把newList分切后的数据新增进入数据库。
                myList.add(newList);
            }
            testDao.getListByApiKeys(myList);  //dao层

    <select id="getListByApiKeys" parameterType="java.util.ArrayList" resultType="cc.ewell.imsp.adminserver.dto.res.SysUserAuthKeyRes">
        SELECT API_KEY AS apiKey, SYSTEM_NAME AS systemName FROM SYS_USER_AUTHKEY

        <where>
        <if test="apiKeys != null and  apiKeys.size() > 0
">
        <foreach collection="apiKeys" item="apiKey" open="API_KEY IN"
                 separator="or API_KEY IN">
            <foreach collection="apiKey" item="key" open="(" close=")" separator=",">
                #{key}
            </foreach>
        </foreach>
        </if>
        </where>
    </select>