rponte

Full page logging in Postgres and Oracle (Oracle: sparse update)

The volume of undo and redo generated is only 15 MB here, including 6 MB of undo vectors. This is really optimized and this is one reason why you should update only the columns changed (and not use the default non-dynamic update of Hibernate for example).

rponte

• O(1) = O(yeah)
• O(log n) = O(nice)
• O(nlogn) = O(k-ish)
• O(n) = O(ok)
• O(n²) = O(my)
• O(2ⁿ) = O(no)
• O(n^n) = O(fuck)
• O(n!) = O(mg!)

rponte

select sess.username  as username
      ,sess.sid       as session_id
      ,sess.serial#   as session_serial
      ,sess.program   as session_program
      ,sess.server    as session_mode
      ,round(stat.value/1024/1024, 2) as "current_UGA_memory (in MB)"
  from v$session    sess
      ,v$sesstat    stat
      ,v$statname   name
  where sess.sid        = stat.sid

rponte

--
-- tabela JOB_QUEUE
--
CREATE SEQUENCE SEQ_JOB_QUEUE;

CREATE TABLE JOB_QUEUE (
	ID          NUMBER              NOT NULL ENABLE, 
	CONTENT     VARCHAR2(4000 CHAR) NOT NULL ENABLE, 
	STATUS      VARCHAR2(20   CHAR) NOT NULL ENABLE, 
	THREAD_NAME VARCHAR2(60   CHAR), 

rponte

package com.nicequestion.donatas.adf.validate;

import javax.el.ValueExpression;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.BeanValidator;
import javax.faces.validator.FacesValidator;
import javax.faces.validator.ValidatorException;

rponte

package br.com.rponte.view.utils.query;

import java.io.Serializable;
import java.math.BigDecimal;

import oracle.adf.view.rich.model.AttributeCriterion;

/**
 * Representa um campo de filtro do componente af:query
 */

rponte

# executing htop in host machine
docker run --name "htop" --rm -it --pid host jess/htop

rponte

# Assuming your docker machine is called "default" and you want to map port 80 in your container to localhost:8888 you can run:
vboxmanage modifyvm default --natpf1 "name_for_mapping,tcp,,8888,,80"

# or if the VM is running:
vboxmanage controlvm default natpf1 "name_for_mapping,tcp,,8888,,80"

rponte

package br.com.rponte.controller.utils;

import java.util.ArrayList;
import java.util.List;
import oracle.adf.view.rich.component.rich.data.RichTable;
import oracle.jbo.JboException;
import oracle.jbo.Row;
import org.apache.myfaces.trinidad.model.CollectionModel;
import org.apache.myfaces.trinidad.model.RowKeySet;

rponte

--------------------------------------------------------
-- Representa um Intervalo de datas (Date Range)
-- https://docs.oracle.com/cd/B10501_01/appdev.920/a96624/10_objs.htm
--------------------------------------------------------
create or replace type Intervalo_t FORCE as Object ( 
    inicio  Date
   ,fim     Date
   -- Construtores
   ,Constructor Function Intervalo_t(inicio Date, fim Date) Return Self as Result
   -- Metodos