关于bams的oracle分页是不是伪分页啊。后台打印出来的sql是两层的，这样在大数据量时候效率很低啊，可以优化吗？
这是后台打印的分页sql：
Hibernate: select * from ( select row_.*, rownum rownum_ from ( select distinct sysuser.* from sys_user_info sysuser,hrm_employee emp,hrm_department dep where sysuser.hrm_employee_id = emp.hrm_employee_id and emp.hrm_employee_depid = dep.dep_id and sysuser.company_id = 18 order by sysuser.user_action asc ) row_ ) where rownum_ <= ? and rownum_ > ?
，看后面 where rownum_ <= ? and rownum_ > ?

正确的应该是这样吧：
select * from ( select row_.*, rownum rownum_ from ( select distinct sysuser.* from sys_user_info sysuser,hrm_employee emp,hrm_department dep where sysuser.hrm_employee_id = emp.hrm_employee_id and emp.hrm_employee_depid = dep.dep_id and sysuser.company_id = 18 order by sysuser.user_action asc ) row_ where rownum<= ? ) where rownum_ > ?

我知道怎么解决了，在配置文件里
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
要配置Oracle10gDialect的方言。