@Override
    public List<UserActionsLogView> readPageUserActionLogView(
            UserActionsLogViewWrapper example,
            Integer first,
            Integer pageSize,
            String sortField,
            SortOrder sortOrder) {
        CriteriaBuilder qb = em.getCriteriaBuilder();
        CriteriaQuery<UserActionsLogView> query = qb.createQuery(UserActionsLogView.class);
        Root<UserActionsLogView> root = query.from(UserActionsLogView.class);
        Predicate[] restrictions = buildPredicates(example, qb, root);
        query.where(restrictions);
        query.orderBy(qb.desc(root.get(UserActionsLogView_.endTime)));
        if (sortField != null) {
            if (sortOrder.equals(SortOrder.ASCENDING)) {
                query.orderBy(qb.asc(root.get(sortField)));
            } else if (sortOrder.equals(SortOrder.DESCENDING)) {
                query.orderBy(qb.desc(root.get(sortField)));
            }
        }
        TypedQuery<UserActionsLogView> tq = em.createQuery(query);
        tq.setFirstResult(first);
        tq.setMaxResults(pageSize);
        return tq.setHint(QueryHints.READ_ONLY, HintValues.TRUE).getResultList();
//        return tq.getResultList();
    }

    private Predicate[] buildPredicates(UserActionsLogViewWrapper example, CriteriaBuilder qb, Root root) {
        ArrayList<Predicate> predicates = new ArrayList<Predicate>();

        if (example.getLogin() != null && !example.getLogin().isEmpty())
            predicates.add(qb.like(qb.upper(root.get(UserActionsLogView_.login)), "%" + example.getLogin().toUpperCase() + "%"));

        if (example.getFio() != null && !example.getFio().isEmpty())
            predicates.add(qb.like(qb.upper(root.get(UserActionsLogView_.fio)), "%" + example.getFio().toUpperCase() + "%"));

        if (example.getSessionkey() != null && !example.getSessionkey().isEmpty())
            predicates.add(qb.like(qb.upper(root.get(UserActionsLogView_.sessionkey)), "%" + example.getSessionkey().toUpperCase() + "%"));

        if (example.getStartTime() != null)
            predicates.add(qb.greaterThan(root.get(UserActionsLogView_.startTime), example.getStartTime()));

        if (example.getEndTime() != null)
            predicates.add(qb.lessThan(root.get(UserActionsLogView_.endTime), example.getEndTime()));

        return predicates.toArray(new Predicate[predicates.size()]);
    }

...
query.orderBy(qb.desc(root.get(UserActionsLogView_.endTime)));
...

/* Formatted on 07/11/2016 15:32:57 (QP5 v5.300) */
SELECT *
  FROM (SELECT /*+ FIRST_ROWS */
              a.*, ROWNUM rnum
          FROM (  SELECT ID       AS a1,
                         END_TIME AS a2,
                         ERRORCODE AS a3,
                         FIO      AS a4,
                         LOGIN_NAME AS a5,
                         PARAMS   AS a6,
                         REQUEST  AS a7,
                         RESPONSE AS a8,
                         SERVICE  AS a9,
                         SESSIONKEY AS a10,
                         START_TIME AS a11
                    FROM USER_ACTIONS_LOG_VIEW
                   WHERE (    UPPER (LOGIN_NAME) LIKE '%RETAILOLD%'
                          AND UPPER (FIO) LIKE '%ТРОФИМОВИЧ%')
                ORDER BY END_TIME DESC) a
         WHERE ROWNUM <= 15)
 WHERE rnum > 0

select * count from USER_ACTIONS_LOG_VIEW

/* Formatted on 07/11/2016 15:38:16 (QP5 v5.300) */
CREATE OR REPLACE FORCE USER_ACTIONS_LOG_VIEW
(
    ID,
    SESSIONKEY,
    LOGIN_NAME,
    FIO,
    SERVICE,
    START_TIME,
    END_TIME,
    REQUEST,
    RESPONSE,
    ERRORCODE,
    PARAMS
)
AS
    SELECT t1.ID,
           t1.SESSIONKEY,
           t2.LOGIN_NAME,
           (t2.LAST_NAME || ' ' || t2.FIRST_NAME || ' ' || t2.MIDDLE_NAME)
               AS FIO,
           t1.SERVICE,
           t1.START_TIME,
           t1.END_TIME,
           t1.REQUEST,
           t1.RESPONSE,
           t1.ERRORCODE,
           t1.PARAMS
      FROM USER_ACTIONS_LOG  t1
           LEFT OUTER JOIN USER_INFO t2 ON (t2.ID = t1.USERID);