febrykoesti.blogspot.com

DBA's Teritory

Success is a Journey, so enjoy it. July 09, 2015. Finding Foreign Key Constraints in Oracle. What a nice tutorial related constraints, just want to make a note :). Http:/ www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm. Subscribe to: Posts (Atom). View my complete profile. Finding Foreign Key Constraints in Oracle. DDL LOCK TIMEOUT — new 11g DDL wait parameter. Determine the Actual Size of the table. How to reset sequence.

http://febrykoesti.blogspot.com/

OVERVIEW OF febrykoesti.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

17

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR FEBRYKOESTI.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 6 reviews

5 star

2

4 star

2

3 star

2

2 star

0

1 star

0

Hey there! Start your review of febrykoesti.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.2 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT FEBRYKOESTI.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

17

SSL

EXTERNAL LINKS

18

SITE IP

173.194.46.107

LOAD TIME

0.25 sec

SCORE

6.2

PAGE TITLE

DBA's Teritory | febrykoesti.blogspot.com Reviews

<META> DESCRIPTION

Success is a Journey, so enjoy it. July 09, 2015. Finding Foreign Key Constraints in Oracle. What a nice tutorial related constraints, just want to make a note :). Http:/ www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm. Subscribe to: Posts (Atom). View my complete profile. Finding Foreign Key Constraints in Oracle. DDL LOCK TIMEOUT — new 11g DDL wait parameter. Determine the Actual Size of the table. How to reset sequence.

<META> KEYWORDS

1 dba's teritory

2 posted by

3 febry ginanjar koesti

4 no comments

5 email this

6 blogthis

7 share to twitter

8 share to facebook

9 share to pinterest

10 older posts

CONTENT

Page content here

KEYWORDS ON PAGE

dba's teritory,posted by,febry ginanjar koesti,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,older posts,find,loading,all about me,my journey,october,popularity,follower,indonesian clock

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

DBA's Teritory | febrykoesti.blogspot.com Reviews

https://febrykoesti.blogspot.com

Success is a Journey, so enjoy it. July 09, 2015. Finding Foreign Key Constraints in Oracle. What a nice tutorial related constraints, just want to make a note :). Http:/ www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm. Subscribe to: Posts (Atom). View my complete profile. Finding Foreign Key Constraints in Oracle. DDL LOCK TIMEOUT — new 11g DDL wait parameter. Determine the Actual Size of the table. How to reset sequence.

INTERNAL PAGES

febrykoesti.blogspot.com

1

DBA's Teritory: July 2015

http://www.febrykoesti.blogspot.com/2015_07_01_archive.html

Success is a Journey, so enjoy it. July 09, 2015. Finding Foreign Key Constraints in Oracle. What a nice tutorial related constraints, just want to make a note :). Http:/ www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm. July 05, 2015. DDL LOCK TIMEOUT — new 11g DDL wait parameter. Need to do DDL but bunch of process accessing that objects, below parameter very much use full for such case. SQL ALTER SESSION SET ddl lock timeout=5;. Exec dbms stats&...

2

DBA's Teritory: How to reset sequence

http://www.febrykoesti.blogspot.com/2015/07/how-to-reset-sequence.html

Success is a Journey, so enjoy it. July 05, 2015. How to reset sequence. Hello folks, long time no see. :). Simple thing but very important, how to reset sequence. Testcase is to reset to 1. 1 Check current sequnce detail. Select SEQUENCE NAME, MIN VALUE, MAX VALUE, INCREMENT BY, LAST NUMBER, CYCLE FLAG from user sequences where SEQUENCE NAME='SEQ NAME';. SEQUENCE NAME MIN VALUE MAX VALUE INCREMENT BY LAST NUMBER. SEQ NAME 1 999999999 1 330120. 2 Alter sequence increment by doing some minus here.

3

DBA's Teritory: October 2014

http://www.febrykoesti.blogspot.com/2014_10_01_archive.html

Success is a Journey, so enjoy it. October 05, 2014. How to Reduce DB File Sequential Read Wait. Yet another article to share. Block reads are fairly inevitable so the aim should be to minimise un-necessary IO. This is best achieved by good application design and efficient execution plans. Changes to execution plans can yield orders of magnitude changes in performance.Hence to reduce this wait event follow the below points . 3) Faster Disk - Buy the faster disk to reduce the unnecessary I/O request .

4

DBA's Teritory: January 2015

http://www.febrykoesti.blogspot.com/2015_01_01_archive.html

Success is a Journey, so enjoy it. January 04, 2015. Hi guys, below is test case to determine if we have some fragmented object. I'm creating the table and the index also (later for deleting purpose). SQL select /* full(a) parallel(a,8) */ count(*) from TESTAB a;. SQL create unique index TESTAB pk on TESTAB(ACCOUNT ID);. Below is the estimate space before we gather the stat. SQL select table name, round( blocks*8)/1024,2) tblsz frgmnted MB, round( NUM ROWS*avg row len/1024/1024),2) actualsize MB. Deletin...

5

DBA's Teritory: Determine the Actual Size of the table

http://www.febrykoesti.blogspot.com/2015/07/determine-actual-size-of-table.html

Success is a Journey, so enjoy it. July 05, 2015. Determine the Actual Size of the table. If you have tables with a lot of DML especially delete and update, you need to consider to reorge that table as for sure the performance will be degradated, below is the command to determine the actual table size, if the difference between fragmented and actual size more than 10 persen ( overhead, ex : header, table directory in the block) then better to rebuild tables and its index also. ACTUAL DATA SIZE *. Picture...

UPGRADE TO PREMIUM TO VIEW 12 MORE

TOTAL PAGES IN THIS WEBSITE

17

LINKS TO THIS WEBSITE

caterinhuang.com

Database tidak mau start setelah Upgrade/Patch | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2010/10/01/error-setelah-upgrade-oracle

Blog to Share, Learn and Have Fun. Database tidak mau start setelah Upgrade/Patch. October 1, 2010. Ketika melakukan patch dari oracle 10.2.0.1 ke 10.2.0.4 pada environment oracle linux, saya menemukan error bahwa database tidak dapat dinaikkan dengan error. ORA-01092: ORACLE instance terminated. Disconnection forced. Hasil penyelidikan terhadap alert log,ditemukan bahwa ada error:. Langkah-langkah untuk memperbaiki error ini adalah sebagai berikut:. 3 Database sudah kembali berfungsi normal. How to Know...

caterinhuang.com

Shortcut Penting pada SQLPLUS | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2012/01/02/shortcut-penting-pada-sqlplus

Blog to Share, Learn and Have Fun. Shortcut Penting pada SQLPLUS. January 2, 2012. SQLplus is one of the most used Oracle tools. Usually sqlplus is used to execute a SQL command or another database administration task. SQLplus is available in various platform. In this article, I would like to introduce some useful shortcuts which will help us in our daily activities in this tools. 1 Define a default text editor to do editing on sqlplus. Or if you are using Windows, you can use. Or use a shortcut l. SQLpl...

caterinhuang.com

Caterin Huang | Blog to Share, Learn and Have Fun | Page 2Caterin Huang | Blog to Share, Learn and Have Fun | Page 2

http://caterinhuang.com/page/2

Blog to Share, Learn and Have Fun. Linux Error: 104: Connection reset by peer. Kemarin ketika mencoba menyalakan listener di server , saya mendapatkan error sebagai berikut: $ lsnrctl start Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC) ) TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 104: Connection reset by peer Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orclmain)(PORT=1521) ) TNS-12547:. Read more ». Read more ».

caterinhuang.com

Call of Duty | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2014/02/09/indonesia-needs-us

Blog to Share, Learn and Have Fun. Protected: Call of Duty. February 9, 2014. This content is password protected. To view it please enter your password below:. How to Know RMAN Backup Job Progress. How to get the ASM to Linux Partition Mapping information ». Why would I become a DBA? How to get the ASM to Linux Partition Mapping information. Protected: Call of Duty. How to Know RMAN Backup Job Progress. Shortcut Penting pada SQLPLUS. On Command Unix basic. Proudly powered by WordPress.

caterinhuang.com

How to Know RMAN Backup Job Progress | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2014/01/20/how-to-know-rman-backup-job-progress

Blog to Share, Learn and Have Fun. How to Know RMAN Backup Job Progress. January 20, 2014. SQL SELECT SID, SERIAL#, OPNAME, CONTEXT, TIME REMAINING, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "% COMPLETE" FROM GV$SESSION LONGOPS WHERE OPNAME LIKE 'RMAN%'AND TOTALWORK! 0 AND SOFAR TOTALWORK;. SQL SELECT SID, SERIAL#, OPNAME, CONTEXT, TIME REMAINING, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "% COMPLETE" FROM GV$SESSION LONGOPS WHERE OPNAME LIKE 'RMAN%'AND TOTALWORK! 0 AND SOFAR TOTALWORK;.

caterinhuang.com

Linux Error: 104: Connection reset by peer | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2010/10/08/linux-error-104-connection-reset-by-peer

Blog to Share, Learn and Have Fun. Linux Error: 104: Connection reset by peer. October 8, 2010. Kemarin ketika mencoba menyalakan listener di server , saya mendapatkan error sebagai berikut:. Selidik sana sini,akhirnya diketahui bahwa penyebab error tersebut adalah tidak adanya loopback adapter pada /etc/hosts. Karena itu jangan lupa tambahkan. 127001 localhost.localdomain localhost. Kemudian start kembali listener dan pasti berhasil. Database tidak mau start setelah Upgrade/Patch. You may use these.

caterinhuang.com

Cognos Error CM-CFG-5076 | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2010/11/09/cognos-error-cm-cfg-5076

Blog to Share, Learn and Have Fun. November 9, 2010. Ketika mencoba melakukan migrasi database content manager Cognos 8.4 dari Microsoft SQL Server 2008 ke Microsoft SQL Server 2008R2, terdapat error berikut ketika start. 5076 A Content Manager configuration error occurred during the initialization of. Oleh karena itu step-step untuk memperbaikinya adalah berikut:. Pastikan koneksi cognos ke database content manager berhasil dilakukan. Kemudian coba start kembali services cognosnya. You may use these.

caterinhuang.com

ORA-00600: internal error code, arguments: [kcratr1 lastbwr], , , , , | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/2010/11/09/ora-00600-internal-error-code-arguments-kcratr1-lastbwr

Blog to Share, Learn and Have Fun. ORA-00600: internal error code, arguments: [kcratr1 lastbwr], , , , ,. November 9, 2010. Kemarin saya menemui suatu kejadian yang mendebarkan. dimana setelah shutdown, database tiba-tiba tidak mau up. sedangkan database tersebut belum pernah di fullbackup sama sekali. dan juga sedang dalam masa development. error yang ditemui adalah:. ORA-00600: internal error code, arguments: [kcratr1 lastbwr], , , , ,. Semakin mendebarkan saja rasanya…. 4 Alter database open. Why woul...

caterinhuang.com

Uncategorized | Caterin HuangCaterin Huang

http://caterinhuang.com/blog/category/uncategorized

Blog to Share, Learn and Have Fun. How to get the ASM to Linux Partition Mapping information. Due to ASM labelling, sometimes we find it difficult to get which disk is behind this ASM disk. we can use below asmtool library command to check whether that disk is already marked as ASM partition or not oracleasm querydisk device. Read more ». Protected: Call of Duty. There is no excerpt because this is a protected. Read more ». How to Know RMAN Backup Job Progress. Read more ». Shortcut Penting pada SQLPLUS.

UPGRADE TO PREMIUM TO VIEW 9 MORE

TOTAL LINKS TO THIS WEBSITE

18

OTHER SITES

febrygunawan.blogspot.com

Di Sinilah Febry Gunawan Berbagi Cerita

Di Sinilah Febry Gunawan Berbagi Cerita. Without you my readers, I can't called myself as a writer : ). Kamis, 10 Maret 2016. Catatan Nostalgia Volunteer Java Jazz Festival 2016. Halo my loyal readers! Kapan lagi bisa dapet kesempatan langka kayak gini? Di hari pertama, gue sempat menonton shownya Raisa, Tomorrow People Ensamble, Dikta Project, Barasuara, Glenn Fredly, TND, dan Tokyo Ska Paradise. Di penampilan terakhir hari Sabtu, gue menyaksikan Isyana secara langsung. Membawakan lagu-lagu hits dan...

febryhadinata.wordpress.com

Febry Hadinata WordPress

Jogja x Dieng x Solo Part 1. Balik lagi ke kisah jalan-jalan lainnya, kali ini cerita membolang versi dalam negeri, napak tilas ke daerah Jawa Tengah. Semua kisah ini bermula dari secarik undangan. Yang berakhir dengan kisah membolang 5 hari 5 malam (120 jam), menyusuri 3 kota, melewati belasan kabupaten, dengan total perjalanan kurang lebih 1.015km 😉. Flashback singkat, kurang lebih 6 bulan sebelumnya, teman seperjuangan semasa kuliah ngasih kabar mau melepas masa lajang. Written by Febry Hadinata.

febryhamster.deviantart.com

febryhamster (febry andrian) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 5 Years. This deviant's full pageview. Last Visit: 146 weeks ago. This is the place where you can personalize your profile! Window&...

febryirfansyah.wordpress.com

Catatan Lapangan | Rangkaian Catatan Yang Terjadi di "Lapangan"

Rangkaian Catatan Yang Terjadi di Lapangan. Why should you study overseas? Posted October 31, 2011. Hari ini dapat pelajaran cukup penting selama jadi mahasiswa, begitu pentingnya pendidikan, dan luasnya tempat di mana kita bisa menuntut ilmu. Kita ketahui bumi memiliki luas sekitar 510.072.000 km. Yang artinya begitu besar dan luas juga peluang kita mengejar mimpi kita, di mana pun, kapan pun, dengan siapa pun, dalam menuntut ilmu tentu harus tetap berprasangka baik. Colorado School of Mines. Studying a...

febryjack.wordpress.com

febryjack | Just another WordPress.com site

Just another WordPress.com site. 1 Oktober 1915 (1915/10/01) (umur 95). Known for Dikenal psikologi kognitif. Read more: http:/ www.answers.com/topic/jerome-bruner#ixzz19YkWOhpj. Lahir 1 Oktober 1915) adalah Amerika. Yang telah memberikan kontribusi psikologi kognitif. Serta sejarah dan umum filsafat pendidikan. Dia menerima gelar BA. Pada tahun 1937 dari Duke University. Dan gelar Ph.D. Pada tahun 1941 di bawah bimbingan Gordon Allport. Ide Bruner didasarkan pada kategorisasi. Based). Daripada tahap...

febrykoesti.blogspot.com

DBA's Teritory

Success is a Journey, so enjoy it. July 09, 2015. Finding Foreign Key Constraints in Oracle. What a nice tutorial related constraints, just want to make a note :). Http:/ www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm. Subscribe to: Posts (Atom). View my complete profile. Finding Foreign Key Constraints in Oracle. DDL LOCK TIMEOUT — new 11g DDL wait parameter. Determine the Actual Size of the table. How to reset sequence.

febryloverain.wordpress.com

febryloverain | Smile! You’re at the best WordPress.com site ever

You’re at the best WordPress.com site ever. Oktober 20, 2014. Diceritakan pada sebuah pulau kecil yang sedang terjadi bencana alam yang sangat dahsyat disepanjang sejarah, bencana alam itu dinamakan TSUNAMI dimana limpahan air laut membanjiri daratan sehingga menghancurkan seluruh kota yang dilewatinya, menelan korban manusia dan hewan yang jumlahnya tidaklah sedikit. Seharian penuh air laut merendam pulau kecil itu, seharian penuh juga orang-orang itu menangis sampai kering air mata mereka dan kesedihan...

febrymaulana.wordpress.com

Materi TKJ | Oleh : Febry Yanto Maulana

Oleh : Febry Yanto Maulana. Pengenalan Bahasa Pemrograman C. June 10, 2014. June 10, 2014. Contoh program C :. Hai Selamat belajar C ". Program diatas dapat kita simpan dengan nama. Program C tidak dapat dipisahkan dari fungsi karena fungsi adalah salah satu dasar penyusun blok pada C . Sebuah program C minimal mengandung sebuah fungsi yaitu fungsi. Fungsi ini menjadi awal dan akhir eksekusi program C . Tanda () digunakan untuk mengapit argumen fungsi, yaitu nilai yang akan dilewatkan ke fungsi. Kata.

febrymeuthia.com

Fabulous Mommy

Aku certain tentang Restoran Sunda paling enak sedunia. Mira Sari di jalan Raya Puncak no 238 Cibogo, Bogor. Resto ini sudah ada sejak tahun 1975, dan sejak aku kecil, sering mampir sini, sehingga makanannya sekarang jadi comfort food. Restoran ini menjadi bench mark buat aku untuk masakan Sunda. Yg diandalkan adalah bahan2 segar dan terbaik. Ga akan ada gurame bau tanah atau aroma minyak lama di gorengannya. Peda tumis pete, petenya al dente dan masih crunchy. Dan sambelnya! Ada Hantu Di Hotel Itu.

febrymultimedia.blogspot.com

Informasi SMKN 3 Kuningan

Informasi SMKN 3 Kuningan. Temukan info-info seputar antivirus dan SMKN 3 Kuningan. Water Tower SMKN 3 kuningan. Posted by Febry Multi Media. Posted on 16.24. Images in this sampingi Evel towers but not the existing water tower at a height of tower Brass smkn 3 is approximately 15 M and tower to reach this function as water reservoirs as a water reserve in SMKN 3 Kuningan. Not just anyone who can ride we had to ask permission beforehand if maybe we can force the marahin! Lapangan Dalam SMKN 3 Kuningan.

febrynahl.blogspot.com

ceritaku

Kamis, 11 Juni 2009. Hari ini hari terakhirku sekolah di Indonesia? Memangnya mau pindah kemana bunda? 8221; Tanya Liza dengan kesal. “Sayang, karena Ayahmu di tugaskan untuk pindah kerja ke Inggris jadi kita pun harus ikut pindah nak.” Ujar bunda sambil mengusap-usap kepalanya Liza. “Aaaahhh! Pokoknya Liza gak mau pindah dari sekolah ini bunda! Waktu sudah menunjukkan pukul 06.15 tapi Liza belum juga bersiap-siap untuk sekolah.“Liza. apa kamu tidak akan sekolah nak? Apa yang terjadi dengan kak Liza?