view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

RDX Services: Proactive Monitoring [VIDEO]

Transcript

Hi, welcome to RDX. When a mission-critical system becomes unavailable, it can threaten the survivability of an organization. That’s why RDX has a Database Operations Center team responsible for the proactive monitoring of all clients’ environments, 24×7.

StatsPack and AWR Reports -- Bits and Pieces -- 1

I am planning to put up a few posts on snippets from StatsPack and AWR reports.  This is my first post.
Note : Some figures / details may be slightly changed / masked to hide the real source.

Logical I/O and Change rates :
1.  From a 9.2 StatsPack Report:

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: Std Block Size: 4K
Shared Pool Size: Log Buffer:

Load Profile

Resource temporarily unavailable in tsStartJavaThread

Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).Java heap 3G reserved, 3G committedPaged memory=3145728/36425712K.Your Java heap size might be set too high.Try to reduce the Java heap size using -Xmx: (e.g. "-java.lang.OutOfMemoryError: Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).Java heap 6G reserved, 6G committedPaged memory=3145728/36425712K.Your Java heap size might be set too high.

Oracle Makes 155 fixes for Patch Tuesday [VIDEO]

Transcript

Welcome to RDX! For those using Oracle Products, Oracle’s October critical patch update contains an unusually high number of security bug fixes.

ZDNet contributor Liam Tun noted that Oracle released patches for 155 security flaws for 44 of its products October 14th. Fixes include 25 security fixes for Java SE. The components affected include Java SE, Java SE embedded, JavaFX and JRockit. The highest Common Vulnerability Scoring System (CVSS) rating among the Java fixes was a 10, the highest rating available.

Pythian at PASS 2014

Join us in Seattle for SQL PASS Summit 2014—planned by and for the Microsoft SQL Server community—where some of our very own will be presenting. You’ll notice that PASS has a funny way of scheduling speaking sessions, so both of our experts are presenting at the same time.

Also be sure to visit us at booth #226 for a chance to win a Sonos Play: 1. The Exhibit Hall will be open all day Wednesday, Thursday, and Friday morning.

 

Oracle 12c Multitenant – Inmemory (pre-basics)

A couple of very, very basic observations on getting going with 12c Inmemory in a multitenant database.

1. When trying to set inmemory_size within a PDB when inmemory_size is 0 in the CDB
ORA-02096: specified initialization parameter is not modifiable with this option

OCP 12C – Index and Table Enhancements

Table Enhancements Oracle 12c offers you to create invisible columns, these columns are not visible until you explicitly mention their names in the SQL statement. This functionnality allows developpers to make change to the database without conflicting with the existing application. To create an invisible column: [crayon-5453a0b4ebd14705309203/]  You can’t create invisible columns on : External [...]

How to See the Height of an Index

This example shows where to find the height of an index. I tested it on Oracle 11.2. First I deleted the index's statistics:

Insertchildxml and namespace problem

Hi,

i'm having a problem with following INSERTCHILDXML-statement on an Oracle 10g, on a windows platform.

SELECT INSERTCHILDXML(
XMLTYPE('<?xml version="1.0" encoding="ISO-8859-1"?>

2014-10-20

'),
'/Journal/Lines','Line',
XMLTYPE('1'))
FROM dual;

A New My Sites Section

My Sites just got a new look, but more importantly, it got a technical overhaul, making the page dramatically faster and more powerful.

From one central location, scan and select any of your WordPress sites or create new ones with the support of a more visual interface. Head directly to the posts or pages of a particular WordPress or launch stats to glimpse trends and get inspiration for blog or website content.  Access themes, user settings, and sharing options with a click to make WordPress your own.

view counter