What the LGWR process writes in the disk before the DBWn flush the data?
I think that are a kind of "ids" (maybe the rowid?) of data blocks present in the header of the blocks, that the SMON uses to locate and exclude the "uncommited" data in ROLLFOWARD process.
1)I have a master site and local site. 2)Materialized view is refreshed at local site... and the results are stored in a cache which Java uses . 3)Any request for the mview data is retrieved from cache. 4)Now I am refreshing matview again using fast refresh.. i.e only records that are changed in the master is updated at the local site. 5) I have to flush the cache .. while flushing i have to flush only those records that are changed.... coz full flush is not good and i have to re cache the entire data if i do full flush
My Question is How to identify the records that changed....so that I can only flush those records from cache. I want to identify the changed records.
I want to create a private DBLINK in 10g and grant access to use this to limited (another 2/3) users. Is that possible ?I don't want to create PUBLIC DBLINK because the users to use it are limited.
I'm making a function A that does many calls to procedures in an other package B. To make this function more readable, I'd like to specify synonyms for the procedures in B. I only need the synonyms inside this function, I don't want to make database synonyms.
For example:
Function get_all_employees return clob is v_emp clob; begin
I am having one table Where,different country names are stored. while viewing data, I have to make sure that if country name having "USA" can only view its data. How can i do at DB level without passing where clause. Is Virtual Database in this case?
We have a 2-Node RAC11g R2.0.3 installed on Linux 5.5.
My problem to have a private connection disconnected on daily bases at 12:00 PM and 3:00 PM ONLY,and come back life within 2 minuets,I am using cross-over cable to connect those private interface , So in the ocssd.log Stating :-
2012-09-18 15:06:43.735: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 50% heartbeat fatal, removal in 14.340 seconds 2012-09-18 15:06:50.752: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 75% heartbeat fatal, removal in 7.330 seconds 2012-09-18 15:07:19.821: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 90% heartbeat fatal, removal in 2.480 seconds, seedhbimpd 1
differences of enabling thread as public or private?
lets assume that i have two threads (1, 2) for two instances (1, 2) and each of thread consists of 2 redolog groups - minimum configuration.in case i need add third node i need third thread.
what will be difference if i set this thread as public instead private?
I would like to know that when the private network in oracle rac down, which is the preferable node in the cluster (cluster of 2 nodes) to takeover the cluster.
Can I set/get the failover policy to point to one node in the cluster?
OS: oel6.3 - 2.6.39-300.17.2.el6uek.x86_64 Grid and DB: 11.2.0.3.4
This is a two node Standard Edition cluster.
The node crashes upon restart of clusterware after following the instructions from note:751343.1 (RAC Support for RDS Over Infiniband) to enable RDS. The cluster is running fine using ipoib for the cluster_interconnect.
1) As the ORACLE_HOME/GI_HOME owner, stop all resources (database, listener, ASM etc) that's running from the home. When stopping database, use NORMAL or IMMEDIATE option.
2) As root, if relinking 11gR2 Grid Infrastructure (GI) home, unlock GI home: GI_HOME/crs/install/rootcrs.pl -unlock
3) As the ORACLE_HOME/GI_HOME owner, go to ORACLE_HOME/GI_HOME and cd to rdbms/lib
4) As the ORACLE_HOME/GI_HOME owner, issue "make -f ins_rdbms.mk ipc_rds ioracle"
5) As root, if relinking 11gR2 Grid Infrastructure (GI) home, lock GI home: GI_HOME/crs/install/rootcrs.pl -patch
Looks to abend when asm tries to start with the message below on the console. I have a service request open for this issue but
kernel BUG at net/rds/ib_send.c:547! invalid opcode: 0000 [#1] SMP CPU 2
I need to take the certain logs on my 3-Node, 10gR2 RAC with ASM on Solaris 10.I have been asked to shutdown the database, nodeapps, listener, asm and crs and then restart crs. Below are t steps that I have prepared.
I'm trying to abort some workflow activities which are not 'COMPLETE' and then purge them. I'm using "WF_ENGINE.AbortProcess" to accomplish this task and then purge using "WF_PURGE.Total" to purge the activities. During this process, does any notifications fire?
I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.
If I start complete refresh it will take 8-12 hours to complete refresh.
My Question is: During Complete refresh how to monitor complete refresh running or not except using
v$mvrefresh.
Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.
I am running Oracle 9.2.0.1 on Solaris 9. On just about a daily basis we perform sqlldr loads that load on the order of 300000 rows. I frequently see in my alert log:
Checkpoint not complete Current log# 5 seq# 176431
I have 5 redo logs each of 10M in size. If I check what is going on in v$log and correlate to the alert log when it throws the checkpoint error I always notice that I have one current log (which is good) and the rest are in a status of 'ACTIVE'. It seems that when this happens I get the checkpoint error.
What can I do to get rid of this checkpoint error? Should I increase the size of my redo logs? Is there a good way to go about estimating what size redo logs I should have?
while upgrading to 11.1.0.7 from 10.2.0.4 at the end we are facing this error
ORA-39714: upgrade script utlmmig.sql failed
*Cause: A normal database open was attempted, but the upgrade script utlmmig.sql failed to complete.
*Action: Use the UPGRADE option when opening the database and then run utlmmig.sql.
i ran the utlmmig.sql script and i am facing this issue
SQL> -- we also need to update the statistic SQL> begin 2 dbms_stats.delete_table_stats('SYS', 'OBJ$MIG'); 3 dbms_stats.delete_table_stats('SYS', 'USER$MIG'); 4 dbms_Stats.gather_table_stats('SYS', 'OBJ$MIG', estimate_percent => 100, 5 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY'); 6 dbms_Stats.gather_table_stats('SYS', 'USER$MIG', estimate_percent => 100, 7 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY'); 8 end; 9 / begin * ERROR at line 1: ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS" ORA-06512: at line 2
compiled the invalid objects using utlirp.sql and utlrp.sql but of no use..
I would like to pursue pl/sql developer as my carrier.So I would like to create a setup in the following manner in my windows 7(64 bit) laptop.Since I heard that,In real time the setup will be look like as follows
Windows7 as front end Toad --> to practice Pl/Sql(Preferred use in windows7) Solaris OS (To install Oracle 10g in Solaris & practice scripting) Virtual Box (Open source tool to run both windows and solaris)
How I can create setup so that I can accomplish following things(To gain knowledge in programming/scripting).
1.Both OS has to be run simultaneously with Virtual Box So that Oracle will be running in backend(Solaris) 2.Practicing Oracle Pl/sql in Toad (Windows7) 3.Practicing shell scripting in Solaris.
Is it possible to create the setup as i mentioned above.
I am loading data from XML file into Oracle table.This program is working fine for small XML files. If I try to load large XML file with multiple pages, only first ten records are loaded. Here is the procedure.
PROCEDURE Test_xml_read(p_tag varchar2,p_xml_file varchar2,p_path varchar2) AS BEGIN INSERT INTO stg_xml_table( Productid,productname,price) select y1.productid,y1.productname,y1.price y2.categoryid,y2.categoryname,y2.categorypath FROM xmltable('ProductFeed/Products/Product' passing xmltype(bfilename('TEST_DIR1', 'sample.xml' ), nls_charset_id('CHAR_CS')) [code]...
what changes to be done to load multiple pages of data pages table.