msutic.blogspot.com
Truncating, Rotating, Flushing Listener.log file | Marko Sutic's Database Blog
http://msutic.blogspot.com/2009/06/truncating-rotating-flushing.html
Marko Sutic's Database Blog. Truncating, Rotating, Flushing Listener.log file. Saturday, June 27, 2009. Posted by Marko Sutic. Listener Log file audits trail information which enables us to analyze network statistics, client connection requests, service registration events or other stuff. So it is obvious that listener log can contain very useful information for troubleshooting network related problems. I asked on OTN forums why it stopped on 4 GB's and here is the link to that question:. Oracle 11g intr...
msutic.blogspot.com
MariaDB - Measure Replicaton Lag and Check / Fix Replication Inconsistencies using Percona tools | Marko Sutic's Database Blog
http://msutic.blogspot.com/2015/02/mariadb-measure-replicaton-lag-and.html
Marko Sutic's Database Blog. MariaDB - Measure Replicaton Lag and Check / Fix Replication Inconsistencies using Percona tools. Thursday, February 5, 2015. Posted by Marko Sutic. Percona Toolkit is collection of command-line tools to perform many MySQL tasks like creating backups, finding duplicate indexes, managing replication, etc. In this post I will talk about how to measure replication lag and check/fix replication inconsistencies with this tools:. I am using environment from previous blog post.
iarsov.com
How-To - The Ivica Arsov Blog
http://iarsov.com/how-to
The Ivica Arsov Blog. Database Management and Performance. How to identify timed out SQL statements from SQL Tuning Task. How to create active service for Physical Standby database. How to get DDL for scheduler jobs owned by SYS. How to check cluster name. How to move online datafiles – Oracle 12c. How to define invisble column. How to recreate DUAL table. How to enable recovery for disabled pluggable database in Data Guard enviorement. How to remotely clone a PDB. How to remotely clone Non-CDB.
iarsov.com
I'm speaking at BGOUG Conference 2015, June, Plovdiv - The Ivica Arsov Blog
https://iarsov.com/2015/06/im-speaking-at-bgoug-conference-2015-june-plovdiv
The Ivica Arsov Blog. Database Management and Performance. LATERAL inline views / GROUP BY and scalar subquery caching →. I’m speaking at BGOUG Conference 2015, June, Plovdiv. Posted by Ivica Arsov. In about a week I’ll be speaking at BGOUG for Oracle Data Redaction 12c. It is an event with great speakers/topics and very very well organized. This year there’ll be speakers like Thomas Kyte, Kerry Osborne, Joel Goodman and much more, you can check the full speakers/topics list here. On Oracle DB Time.
iarsov.com
rman Archives - The Ivica Arsov Blog
http://iarsov.com/tag/rman
The Ivica Arsov Blog. Database Management and Performance. RMAN Duplicate Hang and nK Buffers. Posted by Ivica Arsov. This has been sitting in draft for quite a long. Few days ago one of my colleague experienced interesting hang situation during database duplicate. After successfully datafiles restore the RMAN session went to hang state on the step when the instance tries to recover (apply archive logs) the datafiles. The trace file contained information like:. Receive new posts to your inbox. The views ...
msutic.blogspot.com
How to install Oracle Client 11g on Windows 7? | Marko Sutic's Database Blog
http://msutic.blogspot.com/2009/08/how-to-instal-oracle-client-11g-on.html
Marko Sutic's Database Blog. How to install Oracle Client 11g on Windows 7? Saturday, August 15, 2009. Posted by Marko Sutic. I've never liked Windows Vista and I thought that Windows 7 is the same operating system just with new popular name. But lately I've read a lot good comments about Windows 7. To be honest Windows XP is still my favorite OS from Microsoft but I decided to try out Windows 7. So I downloaded and installed Windows 7 RC1. Checking operating system requirements . Actual Result: 6.1.
iarsov.com
Function Based Indexes and Data Redaction | Ivica Arsov's blog
https://iarsov.com/2015/02/function-based-indexes-and-data-redaction
Ivica Arsov's blog. Database Management and Performance. Partial GLOBAL and LOCAL indexes. Data Redaction thoughts →. Function Based Indexes and Data Redaction. Posted by Ivica Arsov. With Data Redaction we can define policy for specific table/view columns where its data is redacted when it’s queried by end/application users. I won’t go into details about how policies are created, the available types for redaction etc… For that topic you can check Data Redaction part 1. Or indexes based on expression.
iarsov.com
Ivica Arsov's blog | Database Management & Performance | Page 2
http://iarsov.com/page/2
Ivica Arsov's blog. Database Management and Performance. Newer posts →. Posted by Ivica Arsov. I found this sitting in drafts, short post regarding period overlapping. With simple logic we can eliminate the OR conditions related to all possible combinations. The possible four cases where period overlap can occur are:. One way we can determine the overlapping periods is if we use OR conditions for all cases, e.g.:. If you are familiar with De Morgan’s laws. From school 🙂 ) then:. Newer posts →. The views...
iarsov.com
Archives | Ivica Arsov's blog
http://iarsov.com/archives
Ivica Arsov's blog. Database Management and Performance. Performing Partial Restore and Recovery. Sequences - short cache/nocache demo. View merging and dbms random anomaly. Active Services on Physical Standby Database. How to enable recovery for disabled pluggable database in Data Guard enviorement. LATERAL inline views / GROUP BY and scalar subquery caching. I'm speaking at BGOUG Conference 2015, June, Plovdiv. Function Based Indexes and Data Redaction. Partial GLOBAL and LOCAL indexes. Recovery from l...
iarsov.com
data guard Archives - The Ivica Arsov Blog
http://iarsov.com/tag/data-guard
The Ivica Arsov Blog. Database Management and Performance. How to enable recovery for disabled pluggable database in Data Guard enviorement. Posted by Ivica Arsov. What I would like to show is how to exclude (disable recovery) specific pluggable database from Data Guard environment, and also how to enable recovery for already excluded pluggable database. The option for excluding/including pluggable databases from Data Guard is available from 12.1.0.2. Orcl [pc01edu-dg.lab.com]. Originally created as: '/u...