As many know, I joke about being a strange, ADHD k
The red carpet has been laid down at this Log Buffer Edition, and you can witness and cheer the cat-walking blog posts from Oracle, SQL Server and MySQL. Every one of them is chic, elegant, sensual in its own right. Enjoy.
Create colored heat maps in SQL*Plus with Kyle Hailey.
This post is a brief discussion about the advantages of activating parallelism by altering the session environment instead of using the alternative ways (hints, DDL). The latter ways are the most popular in my experience, but I have noticed that their popularity is actually due, quite frequently, more to imperfect understanding rather than informed decision - and that's a pity since "alter session force parallel query" can really save everyone a lot of tedious work and improve maintainability a great deal.
We will also check that issuing
Starting with 11g Oracle can perform block media recovery using flashback logs to get good copies of the blocks.
Flashback database is not enabled by default so first step would be to enable it. When enabled a process RVWR (Recovery Writer) copies modified blocks to flashback buffer. Later this buffer is flushed to disk (flashback logs). It is important to notice that flashback logging is not getting log of a changes but complete block images.
Enable flashback database.
Enterprise Manager Cloud Control 12c is mostly a better product than the 10g version we were using before. But I am getting really frustrated with the Explain Plan functionality.
A big part of my job is performance tuning and monitoring running SQL. And to do that you need a clear, quick, stable view of the query plan, along with all pertinent information, such as the total cost of the plan. in EM10g, we had that.
EM12c, though, is a huge step backwards.
With the emergence of IT trends such as cloud computing and mobility, enterprises have realized that previous security efforts are inadequate for mitigating the new risks that come with these technologies. While looking to upgrade the security infrastructure, firms are may need remote database support to ensure improvements in data protection.
I often use "ssvnc" to connect my servers to install or do something about X. Anyway, I must to start VNC before by using "vncserver".
[surachart@oralearning ~]$ vncserver
New 'oralearning:1 (surachart)' desktop is oralearning:1
Starting applications specified in /home/surachart/.vnc/xstartup
Log file is /home/surachart/.vnc/oralearning:1.log
I ended up find nothing when I connected VNC as below picture.