Oracle Forum
- MRP process is running, Archive log also Transferring from DC to DR but Apply rate is slow.
Answered
Hi Everyone, We are using 11gr2. At yesterday night heavy insert operation is done. Due to which our archival dest was full, I extended mount point ... - Instance not Working in Cluster Node Runtime as Command : srvctl status database -d xyz Given?
HI all I have 2 cluster node (RAC 11gR2). All the database are still up and running (checked manually set oracle_sid xyz1 sqlplus / as sysdba)But whe ... - Archivelog is available on standby database but not applied on standby.
Hello Experts, May I know that If some archivelog is available on standby database but not applied on standby. how to apply?, Kindly assist here ... - Difference between RMAN full Backup and level 0 Backup
Answered
RMAN Full Backup vs. RMAN level 0 BackupHello Experts,1. What is the difference between Rman full backup and Rman level 0 backup?2. Suppose i dont hav ... - Insert Trigger On Materialized Views
We have a Materialized view created on a per-built table. The Materialized view is refreshed REFRESH FAST ON DEMAND. After refresh even though the new ... - Difference between Commit and Checkpoint
Answered
Hello.What is difference between Commit and Checkpoint?Thanks in advance. ... - Which Process write before Image from Database Buffer Cache to Undo Table-Space?
Answered
Hello Experts,May i know that Which process i should write the before image from database buffer cache to Undo tablespace.Kindly share your views on t ... - Which statement creates a new user?
Q. Which statement creates a new user? A. CREATE USER susan; B. CREATE OR REPLACE USER susan; C. CREATE NEW USER susan DEFAULT; D. CRE ... - ORA-01078: failure in processing system parameters
Answered
Hello Everyone, When trying to upgrade the database using T-code DBUA, I am getting the following errors: In the trace.log [SQLEngine.done:22 ... - How to Explain Oracle Architecture?
Hello Experts,I am going to face an interview and preparing for that and as I am preparing I met with a problem that how to explain oracle architectur ... - Trigger Created with Compilation Errors
Hi all ; I have tried to find DB details using trigger. but i did not get any output amd also i am getting Trigger created with compilation errors. ... - ORA-00932: Inconsistent Datatypes: Expected Number Got Interval Day to Second Error While Updating a SQL
Answered
ORA-00932: Inconsistent Datatypes: Expected Number Got Interval Day to Second Error While Updating a SQL Below is the SQL. Begin-SQL ... - Diagnosing Slow Oracle Server Performance
What would be the reason for the sudden dead slowdown of the Oracle server? Hi Oracle Experts, One of my Oracle servers suddenly became dead slo ... - Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
Q. Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema? A. DROP emp_dept_vu; B. DELETE emp_dept_vu; C. REMO ... - What Happened to Database, Suddenly Listener Got Down?
Answered
Hello Experts,I have this sitution that suppose 100 user conected to database and suddenly listener got down so what happened?Kindly share your valuab ... - How many Maximum Number of IP Addresses can Use for Scan Listener
Answered
Hello Experts,May I know that how many maximum number of IP addresses, we can use for Scan Listener.kindly share your valuable views here, thanks in a ... - Difference between Grid Infrastructure and Clusterware
Answered
Hello Experts,May I know that what is the difference between Grid infrastructure and Clusterware?Kindly share your valuable views here.Thanks in advan ... - Reason of Archivelog Generating?
Hello Experts,Sometimes I am unable to understand that why more archivelog is Generating? what was the reason for it if anyone from you guys familiar ... - Mark for review Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
Q. Mark for review Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? A. SELECT ename, salary*12 'Annual S ... - What are the steps involved in Instance Recovery ?
Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rol ... - Difference between FILESPERSET and MAXOPENFILES in RMAN
Answered
FILESPERSET vs MAXOPENFILESCan someone please explain the concept of filesperset parameter in RMAN.What is the difference between filesperset and maxo ... - Increasing pga_aggregate_target Helps in Improving impdp performance.
Answered
Hello All, Increasing pga_aggregate_target helps in improving impdp performance Please help me out with your valuable answer. thanks in advan ... - How to Export Heave Files to 3 Different Mount Points?
Hi Experts,I have a query if anyone have any solution for that then please try to slove that for me as the query is as follow:How to Export the file w ... - How to take Voting Disk manual backup in 11g?
Answered
Hello Experts, In 10g voting manual backup can be taken by using "dd if=sourcefile of=targetfile". How to take voting disk manual back ... - What are the Real Time Performance Tuning Issues?
Answered
Hello Experts,I am learning performance tuning concept from youtube videos in that i had some doubts.Doubt 1: scott user update the row sal=950+2 ... - Is It Possible to Grant Read Only Access On Packages, Stored Procedures and Triggers?
Hello Oracle DBA Experts,Is it possible to grant read only access on packages, stored procedures and triggers? If it is possible then please let me kn ... 
ORA-15018: diskgroup cannot be created While Executing root.sh in Second Node.
Hello Experts,May I know that While setting up RAC, I am getting below error while executing root.sh in second node. It got succeeded on first node. C ...- How to Insert Data into Multiple Table Using One Single Query?
Hi friends,Can any one tell me how can we insert some data into Multiple Table Using ONE SINGLE QUERY. Its an Interview Question so please reply me If ... - What is Partition Pruning in Oracle?
Answered
Hello SAP Experts,I came across a term called as partition pruning in oracle and my mind got stick to it as I don't know the meaning of it. So, can a ... 
dbca command not found
[oracle@linuxuser ~]$ dbca -bash: dbca: command not found Hello Experts, I met with an error after installing Oracle database software I want cr ...
×