Description:
Oracle database administration/server topics.
|
|
|
Itanic is sinking
|
| |
[link]
HP is cutting 30,000 jobs, starting next week. I wonder how much of that is because of betting the company future on the failed chip and how much of it is because of "Midas touch", that company has, turning everything it touches into a muffler. Convex, Polyserve and 3Par are just the most... more »
|
|
v$access oddity?
|
| |
This, from a query on v$access in our DW in 11.2.0.3.2:
SID OWNER OBJECT
-------------- --------------------
------------------------------ ------------------------------ --------------------
TYPE
-----------
95 DWDEVTEAM F_GL_MONTHLY_BALANCE
TABLE
95 DWDEVTEAM F_GL_MONTHLY_BALANCE... more »
|
|
Materialized View
|
| |
Hi,
Can a materialized view be created based on an object table like
this. I have a PL/SQL procedure which creates this object table and
populates it, then I want to create a materialized view from it:
EXECUTE IMMEDIATE 'CREATE MATERIALIZED VIEW inst_holdings_mv AS
SELECT * FROM TABLE(CAST(v_inst_hold_rec AS... more »
|
|
Secure Application Role
|
| |
Hi,
I'm in the process of eliminating Password-Protected Role with Secure
Application Role. I understood how to define a Secure Application
Role, and how to apply it to a user by executing the 'IDENTIFIED
USING' procedure.
I like to know how exactly to use Secure Application Context for the... more »
|
|
ISLAM AND WOMEN
|
| |
ISLAM AND WOMEN
In Islam, men and women are different from each other and each has
their respective roles. Honoring and respecting women in Islam is a
sign of a good, wholesome character and an unadulterated nature. The
Messenger of Islam, Muhammad said:
"The best of you are the best of you towards their wives." (Tirmidhi)... more »
|
|
Slower performance after enabling async io on Oracle Linux
|
| |
Hello,
Platform is Oracle Linux 6.2 64-bit with Oracle 11.2.0.3 64-bit.
After enabling async io, I see slower performance for data pump exports, RMAN backups and long-running queries (between 10 and 15% slower).
I enabled async io with:
ALTER SYSTEM SET FILESYSTEMIO_OPTIONS=SETALL SCOPE=SPFILE;... more »
|
|
LOB space, with numbers
|
| |
In the last thread, I claimed that Oracle space management within the LOB segments leaves a lot to be desired. I didn't have the numbers and this thread is started to correct that mistake. Now, the numbers are here.
I loaded a bunch of binary files, 614 of them, into the database. Space consumption was 2.3GB,... more »
|
|
Flashback log file sync
|
| |
In the thread about LOB storage, Jonathan objected that I haven't really shown any numbers, which is true. I decided to fix my laziness and wrote a Perl script to load 614 files with approximately 2.3 GB of into a simple table having 3 columns: fileno, filename and content of type BLOB. While loading, I was also monitoring the script execution and wait... more »
|
|
|