view counter
Home

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.

Partition Info in V$SESSION_LONGOPS

Oracle’s advanced partitioning has some deficiencies. For example, partition info is missing in V$SESSION_LONGOPS for scan-operations ( full table scans, full index scans ). V$SESSION_LONGOPS.TARGET only shows OWNER.TABLE_NAME in these cases, even when the underlying table/index is partitioned, though the longop doesn’t refer to the whole segment but only to one (sub-)partition of it.
I filed an enhancement request several years ago concerning this matter, but never received any feedback.

May 10, 2013 6:51am

A Case of Changing or Creating OSDBA and OSOPER Groups

Goal

Created an Unix user (e.g. tier1 ) in the Oracle database server that can perform some database administration tasks but cannot be used to view or modify any application data.

Current typical Unix/Liux Environment:

- OS user: "oracle" is the Oracle software owner and its primary group is "dba" (i.e. Oracle database files have ownership oracle:dba )

- Assuming OSDBA group is "dba" (i.e. every os user that belongs to "dba" group can login as sysdba and view any data)

May 10, 2013 6:06am

Log Buffer #319, A Carnival of the Vanities for DBAs

This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.

Oracle:

When does an Oracle process know it’s on Exadata?

MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.

May 10, 2013 5:52am

Changes (Ace Comic)

The Adventures of Ace DBA

This entry is part 19 of 19 in the series Adventures of Ace, DBA 

It’s the only explanation!

May 10, 2013 4:30am

Speaking on Ships can be Testing

1. The Ship I took some time off working on the development of several Oracle Certification Exams to participate in the Norwegian Oracle User Group conference. Many other speakers and attendees have described the wonderful environment of the conference, comprising a land day in Oslo, followed by two days aboard the Colour Magic Cruise Ferry […]

May 10, 2013 3:27am

Experts say BI needs better monitoring, management

Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise.

May 10, 2013 3:09am

Experts say BI needs better monitoring, management

Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise.

May 10, 2013 3:09am

Fixing Oracle Linux 6.4 udev issues without reboot server

Jephe Wu - http://linuxtechres.blogspot.comObjective: fix NIC issue, get Linux to set all NICs MAC properlyProblem: udev mass up, some internet is not recognized, got error message such as 'during bootup, got error such as 'Device p1p1 does not seem to be present, delaying initialization.'Environment: RHEL6/OL6/CentOS 6References:http://onlinedocs.info/centos-detect-new-network-card/

May 09, 2013 11:13pm

Oracle RAC 11.2.0.2: A disturbing loop in a "ohasd" startup script

Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system...
The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup: 

May 09, 2013 5:18pm

Oracle – Indirect Restore using Netbackup

Problem : I was needed to do the production database restore in order to recover the lost data from production database. The data was lost from few tables only so I decided to restore production database from backup to another host. The Oracle is configured with Netbackup. Solution : As i said, We have Netbackup [...]

May 09, 2013 3:00pm
view counter