Problem:
Identify the correct size of a schema in the Oracle10g Database.
Solution;
This is a relative simple query to find out what is the size of the schema in megs. This script uses the dba_objects table and the dba_extents table to find the size of every object for the schema and then sum the total bytes of each object into one rounded number.
Script:
select round(sum(object_size)/1024/1024,0) schema_size
from
(select t1.owner
,t1.object_name, t1.object_type
,t2.object_size
from dba_objects t1,
(select segment_type, segment_name, sum(bytes) object_size
from dba_extents
group by segment_type, segment_name) t2
where t1.object_name = t2.segment_name (+)
and t1.owner = upper(‘&1’)
order by t1.object_name)
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
darknet markets url github darkwebsitesyhshv darkwebsites – darknet markets MostBet oferuje atrakcyjne bonusy powitalne dla nowych graczy | W MostBet mozna grac zarowno na komputerze, jak i na telefonie mostbet rejestracja | MostBet to kasyno, ktore oferuje wysokie RTP na swoich grach | W MostBet mozna grac na zywo z prawdziwymi krupierami | MostBet logowanie jest proste i wymaga jedynie podania loginu i hasla | MostBet kasyno online posiada licencje na dzialalnosc w Polsce | MostBet Polska obsluguje transakcje w PLN | MostBet casino bonus to sposob na zwiekszenie wygranych MostBet kasyno online. Http: cbdoilmgs buy cbd cbd cream cbd gummies hemp cbd Hey there! I just wanted to ask if you ever have any issues with hackers? Rejestracja w MostBet zajmuje tylko kilka minut i daje dostep do bonusow | MostBet pl daje dostep do najpopularniejszych automatow do gier mostbet pl | MostBet to kasyno, ktore oferuje wysokie RTP na swoich grach | MostBet logowanie umozliwia szybki dostep do gier i zakladow | MostBet rejestracja pozwala na szybkie uzyskanie bonusu powitalnego | MostBet rejestracja otwiera dostep do ekskluzywnych ofert | MostBet kasyno oferuje wiele promocji dla stalych graczy | MostBet to kasyno online z duza spolecznoscia graczy MostBet szybkie wyplaty.
https://youbiz.com/profile/erica-streeter/
You’ve done a fantastic job covering this topic! I appreciate your in-depth approach. If anyone is curious about similar subjects, they can check out here for further reading. De plus, les éléments thématiques de Penalty Shoot-Out ajoutent une couche supplémentaire d’excitation. Lorsque les joueurs représentent leur pays sur le terrain virtuel, ils ont l’impression de créer leur propre récit footballistique. Percer la défense adverse pour marquer des buts devient un parcours personnalisé, ce qui rend chaque victoire plus gratifiante et chaque défaite plus motivante. Le thème de la fierté nationale et de la compétition rehausse l’expérience de jeu, faisant de Penalty ShootOut une aventure passionnante pour les fans de football et les joueurs. 04 74 67 50 08