Search

Top 60 Oracle Blogs

Recent comments

Largest SGA Ever

I am curious and wanted to know how many memory allocation SGA config largest ever in the world, ITB, 2TB, 4TB and so on ... kind regards, Iwan (iwank21@gmail.com)

Read the answer...

Write cache with open file handles?

I have a doubt about RAC.

I was trying recovery of OCR and voting disk. This is what I did:

-- created a diskgroup OCRVD with external redundancy and 5 disks
-- Moved OCR and voting file to the diskgroup OCRVD
-- Corrupted all the disks in the diskgroup using dd command. I was expecting c/ware to come down as all the voting disks are inaccessible. But the c/ware continued as earlier. C/ware alert log, OCSSD log and ASm alert log did not display anything relevant.
-- I even deleted all the partitions on which ASM disks were configured but c/ware still continued.
-- As soon as I stopped ISCSI service, the alert log revealed that Voting disk was inaccessible and node rebooted .

How can these results be explained in view of the fact that for c/ware to continue, more than half the number of voting disks should be accessible.

Thanks and regards
Anju Garg

Read the answer...

Can you Apply redo to import?

i am new to the world of dba, so i wanted to ask that is it possible to apply redo logs after a import for recovery as we do apply redo logs after restoring from backup files. i know import is kind of a logical thing and backup files are physical copy. so redo logs cant be applied on after import. what i want to know is, is there any way we can do it, if not whynot?(another reason apart from the above : ) )

Read the answer...

& in create table

Can we use functions in CREATE statement ? if yes. Please rectify this Create table &TABLENAME ( ....); Here I want to use CHR and ASCII function in place of "&" substitution variable.

Read the answer...

See your post on OTN

Hi all, I get this error when trying to register a database in RMAN RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 02/25/2013 13:31:05 RMAN-10015: error compiling PL/SQL program RMAN-10014: PL/SQL error 0 on line 13 column 5: Statement ignored RMAN-10014: PL/SQL error 201 on line 13 column 5: identifier 'DBMS_RCVCAT.REGISTERDATABASE' must be declared Any help would be greatly appreciated. You can view the thread on OTN Discussion forums here: https://forums.oracle.com/forums/thread.jspa?threadID=2503670&start=15&t...

Read the answer...

I responded to your thread on OTN.

Hi all, I get this error when trying to register a database in RMAN RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 02/25/2013 13:31:05 RMAN-10015: error compiling PL/SQL program RMAN-10014: PL/SQL error 0 on line 13 column 5: Statement ignored RMAN-10014: PL/SQL error 201 on line 13 column 5: identifier 'DBMS_RCVCAT.REGISTERDATABASE' must be declared Any help would be greatly appreciated. You can view the OTN discussion thread here: https://forums.oracle.com/forums/thread.jspa?threadID=2503670&start=0&ts...

Read the answer...

having difficulty installing Oracle 11G on Windows 7

I am having difficulty installing Oracle 11G on Windows 7 32bit on my desktop. Please provide me with the correct information on installling Oracle 11G on Windows 7 32bit. I downloaded the Oracle 11G on Windows 7 32bit install information from the Oracle site

Read the answer...

Multiplexing control/redo files

We know that when you multiplex a control file or redolog member to another physical disk, then you effectively have an active backup of the file. The idea being it is unlikely for physical corruption to occur on multiple physical devices at the same time. So if a physical corruption were to occur you still have a multiplexed file on another physical device, that will be unaffected, and you can use this multiplexed file to recover and open the database again. Also after the physical corruption has been resolved you can copy the uncorrupt multiplexed file(s) to a new physical location and establish the multiplexing again. I already have confirmation from Oracle support that multiplexing only protects against physical corruption of the control and redolog files - and not logical corruption of these files. Oracle support also told me they acknowledge that multiplexing is unnecessary where hardware redundancy (eg SAN RAID5) is already being used, however they still recommend multiplexing to give some protection against accidental dropping of control and redolog files. My question - can there be any other justification for multiplexing control and redologs where hardware redundancy (eg SAN RAID5) is already being used?

Read the answer...

no listener.ora

A listener.ora file is not required, if the listener is running on the default TCP port of 1521. My question is Without listener.ora file, is it possible for oracle to know which port to listen when multiple listeners present? Any help will be highly appreciated.

Read the answer...

Long Time for grouping

i have one query which return million records in 2 mins without group by function. i have to group these records so i have written group by clause on this query ,after writing group by it's taking 15-16 min. i tuned this query in first or second run ,it's take 2-3 min. after that it's taking 8-10 min to run. please tell me what could be the reason...

Read the answer...