How to find table size?

Hello, if you want to see all table sizes in oracle database you can use this code. SELECT owner, table_name, ROUND(sum(bytes)/1024/1024/1024) GB FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE segment_type IN (‘TABLE’, ‘TABLE PARTITION’, ‘TABLE SUBPARTITION’) UNION ALL SELECT i.table_name, i.owner, s.bytes FROM dba_indexes i, dba_segments s WHERE s.segment_name = i.index_name AND   s.owner […]

The Backdoor Entry to Oracle Database

The backdoor entry of the Oracle database! You can enter to the database through the back door using SQL * Plus tool with “Prelim” parameter  Prelim, directly connects to the SGA but it does not open a session. You can connect to the database with Prelim as following. [oracle@maxerman bin]$ sqlplus /nolog SQL*Plus: Release […]

ORA 28040 no machine authentication protocol Error. I am trying to connect with Plsql Developer to Oracle databse Oracle 12c in Oracle Linux 7.3 system. However, whenever i run my application i get following exception. Error messages summary : “connect error, ORA-28040: No matching authentication protocol” Bug number -> 14575666 Solutions 1 :  1. Connect […]

infoFence, is a 3rd. party real time security database software for Oracle databases. SCOPE Login Control DDL/DCL (Database Definition & Control Language) Control DML (Data Manipulation Language)/QUERY Control Database and Application Error Detection System Conditional Table Access Logging System. It is installed into Oracle Databases (10g,11g,12c) and runs using Database Triggers and optionally be integrated […]

Wget: command not found error on OEL 6.8

error => bash : wget command not found. Use the wget utility to download the repository configuration file that is appropriate for your system. [code language=”css”] [root@ermankara ~]# cd /etc/yum.repos.d/ [root@ermankara yum.repos.d]# wget <a href="" target="_blank" rel="noopener" data-saferedirecturl=""><wbr />yum-ol6.repo</a> bash: wget: command not found [/code] Is wget installed? [code language=”css”] [root@ermankara yum.repos.d]# rpm -q wget package […]

  [code language=”css”] root@erman02]#vi /etc/sysconfig/network NETWORKING=yes HOSTNAME=erman02 NETWORKING=yes HOSTNAME=production Reboot Ediyoruz. [root@erman02]# reboot [root@erman02]# hostname production [/code] Hits: 3

#PlSql kodu ile kullanıcı eklenmesi

[code language=”css”] CREATE OR REPLACE PROCEDURE UNI_DEV.addUser( i_username IN USERS.USERNAME%TYPE, i_password IN USERS.PASSWORD%TYPE, i_email IN USERS.EMAIL%TYPE, r_output OUT VARCHAR2) IS FUNCTION exist (column_case IN NUMBER,i_for_row IN VARCHAR2) RETURN BOOLEAN IS c_value NUMBER; v_return BOOLEAN; BEGIN IF column_case = 1 THEN SELECT COUNT(*) INTO c_value FROM users WHERE username = i_for_row; ELSE SELECT COUNT(*) INTO c_value […]