alamaby

SELECT LINE, POSITION, TEXT 
FROM ALL_ERRORS 
WHERE NAME = 'VIEW_NAME' 
  AND TYPE = 'VIEW';

alamaby

SELECT
    df.tablespace_name "Tablespace",
    totalusedspace "Used MB",
    ( df.totalspace - tu.totalusedspace ) "Free MB",
    df.totalspace "Total MB",
    round(100 * ( (df.totalspace - tu.totalusedspace) / df.totalspace) ) "% Free"
FROM
    (
        SELECT
            tablespace_name,

alamaby

set wrap
set textwidth=72
set tabstop=8 softtabstop=0 expandtab shiftwidth=4 smarttab
set number

alamaby

export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8

export PS1="\[\033[36m\]\u\[\033[m\]@\[\033[32m\]\h:\[\033[33;1m\]\w\[\033[m\]\$ "
export CLICOLOR=1
export LSCOLORS=ExFxBxDxCxegedabagacad

alias ls='ls -GFh'
alias ll='ls -l'

alamaby

[alias]
	co = checkout
	ci = commit
	st = status
	br = branch
	hist = log --pretty=format:'%h %ad | %s%d [%an]' --graph --date=short
	type = cat-file -t
	dump = cat-file -p

alamaby

SELECT B.Owner,
    B.Object_Name,
    A.Oracle_Username,
    A.OS_User_Name
FROM V$Locked_Object A,
    All_Objects B
WHERE A.Object_ID = B.Object_ID;

alamaby

SELECT owner,
    table_name,
    TRUNC(SUM(bytes)                             /1024/1024) Meg,
    ROUND( ratio_to_report( SUM(bytes) ) over () * 100) Percent
FROM
    (SELECT segment_name table_name,
        owner,
        bytes
    FROM dba_segments
    WHERE segment_type IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION')