BrunoCaimar

pip install \
    --platform manylinux_2_17_x86_64 \
    --implementation cp \
    --python 3.9 \
    --only-binary=:all: --upgrade \
    --target site-packages \
    cryptography

BrunoCaimar

However, the most important is how the timeouts and heartbeats work.

https://blog.softwaremill.com/7-mistakes-when-using-apache-kafka-44358cd9cd6

https://spring.io/projects/spring-kafka

BrunoCaimar

"If you're making new mistakes, then it shows you're learning." Perhaps a good attitude for our managers? - Karl Wiegers

I learned that I need to place the food at the desk next to mine - just 2 meters away so that I do not eat all of it myself Klaus Marquardt

I heard from one company in the UK -- Maria's Rule -- there is no problem that cake cannot solve :-)! Linda Rising to Everyone (11:26 AM)

BrunoCaimar

SELECT
    'DELETE FROM '
     ||  table_name
     ||  ';'
FROM
    all_tables t
    JOIN
        all_objects o
    ON

BrunoCaimar

SELECT
    *
FROM
    (
        SELECT
            extractvalue(codedvalues.column_value,'CodedValue/Code') AS code,
            extractvalue(codedvalues.column_value,'CodedValue/Name') AS value
        FROM
            sde.gdb_items_vw items
            INNER JOIN

BrunoCaimar

SELECT
    i.name AS item_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/Name') AS field_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/DomainName') AS domain_name,
    it.name AS item_type
FROM
    sde.gdb_items_vw i
    JOIN
        sde.gdb_itemtypes it
    ON

BrunoCaimar

public static string GetMD5Checksum(string input)
        {
            using (MD5 md5 = MD5.Create())
            {
                byte[] inputBytes = Encoding.ASCII.GetBytes(input);
                byte[] hashBytes = md5.ComputeHash(inputBytes);

                return BitConverter.ToString(hashBytes).Replace("-", String.Empty);
            }
        }

BrunoCaimar

Oracle recipes

Columns

• ALL_TAB_COLUMNS / DBA_TAB_COLUMNS / USER_TAB_COLUMNS

select C.*, T.* from DBA_TAB_COLUMNS C JOIN DBA_TABLES T ON T.TABLE_NAME = C.TABLE_NAME
where column_name like '%UTD%'
order by C.table_name, column_name;

BrunoCaimar

select USERNAME, MACHINE, OSUSER, PROGRAM from v$session where audsid
in (select audsid from SDE.PROCESS_INFORMATION);

-- Identifica os usuários que estão na process information e não possuem conexão ativa no oracle
select * from sde.process_information
where audsid not in (select audsid from v$session);

-- Limpa as conexões orfãs
delete from sde.process_information
where audsid not in (select audsid from v$session);

BrunoCaimar