EMREBARANSEL.TEL

turkceoracle.com

Yazarlar « Türkçe Oracle

http://turkceoracle.com/yazarlar

Oracle Veritabanı Yuksek Erişilebilirlik Serisi. 1976 Mersin doğumludur. 2001 senesinde Çukurova Üniversitesi Endüstri Mühendisliği bölümünden mezun olmuştur. İzmir Akademi’de Oracle Eğitmenliği, Birim Bilgi Teknolojileri A.Ş.’de veritabanı uzmanı olarak çalıştıktan sonra şu an Koç.Net’de Veritabanı ve Unix Uzmanı olarak çalışmaktadır. Oracle 10g ve 11g için OCP (Oracle Certified Professional), Oracle Forms Developer (OCP), Oracle Certified SQL Expert, Comptia Linux sertifikaların...Şub 09, 2013. CREATE ...

emrebaransel.blogspot.com

Standby Database SCN - x$kcvfh

http://emrebaransel.blogspot.com/2015/05/standby-database-scn-xkcvfh.html

Emre Baransel - Oracle Blog. Standby Database SCN - x$kcvfh. Cross-checked the steps with Data Guard Concepts and Administration Guide there was nothing we were missing. Http:/ docs.oracle.com/cd/E11882 01/server.112/e41134/rman.htm#SBYDB00759. And then after the warning of my team-mate, checked the note on MyOracle Support " Steps to perform for Rolling forward a standby database using RMAN Incremental Backup. (Doc ID 836986.1). You need to use the 'lowest SCN' from the the 3 queries below". Great and u...

emrebaransel.blogspot.com

Auditing on Oracle Database in a Nutshell (11gR2)

http://emrebaransel.blogspot.com/2015/05/auditing-on-oracle-database-in-nutshell.html

Emre Baransel - Oracle Blog. Auditing on Oracle Database in a Nutshell (11gR2). In an Oracle Database we can mention following auditing types:. Causes database start-up/shut-down and SYSDBA-SYSOPER login logout information to be written into AUDIT FILE DEST. This auditing cannot be turned off and it's always written into operating system directory specified with AUDIT FILE DEST. Is controlled with AUDIT TRAIL. Parameter. (NONE,OS,DB,DB EXTENDED,XML,XML EXTENDED). When *EXTENDED is used SQLBIND. Following...

emrebaransel.blogspot.com

Packt Publishing e-book Promotion

http://emrebaransel.blogspot.com/2013/10/packt-publishing-e-book-promotion.html

Emre Baransel - Oracle Blog. Packt Publishing e-book Promotion. I would like to inform you that, to mark Columbus Day, Packt is offering its entire catalog of eBooks and videos at 50% off. This is te last day of the promotion. If you plan to buy some e-books don't miss this. Designed by Johanes Djogan.

emrebaransel.blogspot.com

Data Guard Queries

http://emrebaransel.blogspot.com/2013/07/data-guard-queries.html

Emre Baransel - Oracle Blog. After all those years, my 5 years old post “ How To Query Dataguard Status. 8221; still has the top visitors of this blog, so I wanted to write a fresh one including newer queries, commands. Here it is:. Standby database process status: You can run following query on standby database to see what MRP and RFS processes are doing, which block of which archivelog sequences are being shipped or being applied. PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS. RFS IDLE 0 0 0 0. SQL SE...

emrebaransel.blogspot.com

TIMESTAMP to DATE Conversion with Online Redefinition

http://emrebaransel.blogspot.com/2015/05/timestamp-to-date-conversion-with.html

Emre Baransel - Oracle Blog. TIMESTAMP to DATE Conversion with Online Redefinition. Is a great way to make structural change on "big" tables having "lots of" DML. Using online redefinition, partitioning-nonpartitioning, adding-dropping columns, changing column data types, moving to another tablespace and more can be done with a very small unavailability of the table when compared with direct operations. Here are some online redefinition MOS notes which make life easier:. When converting column data types...