titsay
PR's Tumblrdome
RMH
Three Goblin Art
★
Kiana Khansmith
oozey mess
No title available
Jules of Nature
Janaina Medeiros
🪼
DEAR READER
NASA
Sweet Seals For You, Always
No title available
tannertan36
2025 on Tumblr: Trends That Defined the Year
ojovivo
dirt enthusiast
h
seen from South Korea
seen from Australia
seen from Türkiye
seen from United Kingdom
seen from United States
seen from South Korea
seen from Finland
seen from United States
seen from Türkiye
seen from United States
seen from Italy
seen from Netherlands
seen from Italy
seen from Türkiye
seen from South Korea
seen from Australia
seen from Italy
seen from United States
seen from United Kingdom
seen from Sweden
@projectkwan
Day1
Date 2017-10-16 Sleep 431 Mins Meals Food Amount Cal Carb Protein Fat Meal #1 Apple Cinnamon Oatmeal 1 Packet 130 27 3 1.5 Plant Protein 2 scoops 114 0.3 26 1 Milk 200g 92 12.4 3.6 3 Total 336 39.7 32.6 5.5 Snack #1 Premier Protein Bar 1bar 300 24 30 10 Total 300 24 30 10 Meal #2 Steak 150g 201 3.1 37.7 9.8 Rice 160g 195 46 3.8 0.3 Total 396 49.1 41.5 10.1 Sanck #2 Almond 60g 250 11.8 12.7 30.4…
View On WordPress
Pre-requisition RPMs for R12 on RHEL6
Pre-requisition RPMs for R12 on RHEL6
Update 5 (5.5) or higher of Oracle Linux 5 is required Update 5 (5.5) or higher of Red Hat Enterprise Linux (RHEL) 5 is required If not using the pre-install rpm, the following packages (or versions of packages) are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ for both Oracle Linux 5 and RHEL 5)…
View On WordPress
R12 Installation - Staging
R12 Installation – Staging
Setup RPMs Click to see pre-requisition RPM list .# vi sysctl.conf All below kernel parameters are related to oracle EBS – R12.2 kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmall = 268435456kernel.shmmax = 429496729kernel.shmmni = 4096kernel.sem = 256 32000 100 142fs.file-max = 327679net.ipv4.ip_local_port_range = 10000 65000net.core.rmem_default = 262144net.core.wmem_default =…
View On WordPress
Stage File Upload
There was so much headache about loading a set of Stage files. First we decided to go to the GDC, plug in the external drive, and copy the files from there due to the slow network. And the size of files was about 60 gb. We contacted the VM team / OS team in the compnay that manages our servers. We asked them to indicate the port we should use to access to the Linux VM OS. And there was only one…
View On WordPress
New Project Embark
I have been slacking off on this blog. Since it’s the beginning of a new project, which is the biggest project I’ve ever been on. I’m going to post things that I’d like to archive and share. Hopefully I or someone else will find it helpful. I’ll try to post also about business issue, but it will be mostly about technical part as APPS DBA because that’s the part i’m in charge of.  The project is…
View On WordPress
Oracle RAC Installation with VMware Fusion
Oracle RAC Installation with VMware Fusion
I couldn’t find a complete guide on Mac, so I’ve made step by step guide. Hope it helps any Mac users that also happen to be Oracle Geeks. If there’s any mistake, typo or any sort of errors, please leave a comment or email me. Thanks!
 Oracle 11g RAC Installation Guide
View On WordPress
Schema and User
Schema and User
Schema is the whole sum of objects that a user has created.
A user needs to be added when there was new work process is added in a company.
1. Default tablespace needs to be created CREATE TABLESPACE name DATAFILE ‘file name’ SIZE # [ M | G ] CREATE TABLESPACE NAME DATAFILE ‘file name’ SIZE # [ M | G ]
2. Temporary Tablespace needs to be assigned CREATE TEMPORARY TABLESPACE name TEMPFI…
View On WordPress
Oracle Memory Management
Oracle Memory Management
Oracle memory areas are divided two, SGA(Shared Global Area) and PGA(Process Global Area). In SGA, Shared Pool, DBCache, Redo buffer and etc are process and in PGA, each processes have it’s own work space.
Until 8i, everything had to be managed manually. The problem was that to apply adjusted memory space, a database had to restart. (Static SGA) However from 9i, automatic…
View On WordPress
Oracle Data Structure
Oracle Data Structure
Hierarchy
Database Tablespace Segment Extend Oracle Block O/S Block
Oracle Block is consist of O/S Block. O/S block and Oracle block may or may not be the same size. If DBA decide to set up Oracle Block as 8KB and O/S Block is 2KB, 4 O/S Blocks are one Oracle Data Block. However, most of modern O/S have 8KB Block system. If they are not the same size it can cause Block Split.…
View On WordPress
Undo Tablespace and Temporary Tablespace
Undo Tablespace and Temporary Tablespace
About Undo Tablespace and Temporary Tablespace
Undo Tablespace is a virtual space on the PGA. When a transaction happens change vector is transferred to redo log buffer then the original data is sent to Undo Tablespace in order to enable a user to undo the undesired process. Undo Tablespace is also used to achieve Consistent Read. While a user is executing DML, the data is locked until the suer…
View On WordPress
Tablespace management
About the Tablespace
Tablespace is the conceptual space in the memory. Tablespace is used to accomodate the data which needs to be processed. Data that is not currently being used is stored in data files. A tablespace can have more than one tablespace if it’s needed. There are two kinds of tablespaces roughly speaking. One that is created by Oracle and the other one is create by a DBA for the…
View On WordPress
Redo Log Management
About Redo Log Management
Redo Log is a log that contains history of transactions in a database. Redo log is one of the file that is used for backup and recovery. Therefore it is important to manage it correctly and keep the file multiplexed.
When a transaction happens, the first thing happens in a instance is check Database Cache Buffer to see if the target row’s data is in the buffer because…
View On WordPress
PL/SQL Control Structure
Controlling Program Flow
Conditional Statements
IF..THEN Statement
IF <CONDITION> THEN << set of statement >> … END IF;
 IF..ELSE Statements
IF <CONDITION> THEN << set of statement >> … ELSE << set of statement >> … END IF;
 IF <CONDITION> THEN << set of statement >> … ELSIF <CONDITION> THEN << set of statement >> … ELSE << set of statement >> … END IF;
 CASE
A CASE statement can replace code with…
View On WordPress
PL/SQL – Constants and Variables Variables and Constants must be declared before they are used so that memory space is allocated for them.
PL/SQL Basic
Basic Structure of PL/SQL
 PL/SQL sentence is a block structure. The structure is composed of DECLARE, PROCEDURAL (BEGIN – END), EXCEPTION. Also block can contain Nested Blocks.Â
 DECLARE – Optional. Define all variables, cursors, subprograms, and other elements
PROCEDURAL – Main body of routine. Starts with BEGIN and ends with ENDS or EXCEPTION keyword.
EXCEPTION – Optional. It allows the…
View On WordPress
Basic of SQL
Relational Database Constructs
Table: Storage Area.
Rows: Horizontal Cross Section in Table
Column: Vertical Cross Section in Table
File: Intersection between Rows and Columns
Primary Key: Unique Column that define each rows
Foreign Key: Relation Points. It define how one table relate another.Â
 Entering SQL
Commands may be on one line or multiple line, although it is recommended to separate…
View On WordPress
Happiest Hell
View On WordPress