How Much REDO Would Increase If Enable Supplemental Logging

Nov 8, 2013

we  use  Oracle11gR2 on Win2008R2 .By erroneous operation of OracleDB, there was trouble that we could not log in to Application(Oracle Insight) running on Oracle11gR2. I looked up and understand by running the below ALTER DATABASE ADD SUPPLEMENTAL LOG DATA we can find the SQL statement that was executed in the past from SQL_REDO column of V$ LOGMNR_CONTENTS table, undo SQL statement to rollback from  SQL_UNDO column of V$ LOGMNR_CONTENTS table. But , we are concerned about the adverse effect of enabling the supplemental log because it is production environment . I heard the contents of the REDO log will increase if we enable supplemental log. 

Q1-How much the REDO log would increase roughly if you enable supplemental log ? ( I am concerned about the issue of the capacity of the  REDO log  and the problem of DB performance . ) 

Q2-Is it necessary to restart the DB instance to enable supplemental logging after executing the below ?ALTER DATABASE ADD SUPPLEMENTAL LOG DATA.

Q3-Is there any other adverse effect we should care  if you enable supplemental log ? 

Q4-Logminer is usable if DB is running on no-archive mode ? In my understanding , it is possible if  you enable supplemental log and have the REDO logs we would like to analyze.

View 8 Replies


ADVERTISEMENT

SQL & PL/SQL :: Unconditional Table Level Supplemental Logging

May 6, 2011

I want to enable unconditional table level supplemental logging on unique index columns.

But Alter table tablename add supplemental log data (unique index) columns always;

gives error.If i omit always it is accepting but while it unconditionally log the unique index columns.

View 5 Replies View Related

SQL & PL/SQL :: Copy Supplemental Login Information From Renamed Table To New Tables?

Oct 19, 2010

I renamed 100 tables and recreated them, now I need to copy supplemental login information from renamed table to new tables. Environment is oracle 10G.

OS - Solaris

View 9 Replies View Related

Data Guard :: ORA-01354 / Supplemental Log Data Must Be Added To Run This Command

May 2, 2012

I configure logical standby online .when I execute dbms_logstdby.buid,first

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

it was blcoked by other sesson,then i kill the holding session,but no work.then i cancel this step and execute it again . the error is

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
BEGIN DBMS_LOGSTDBY.BUILD; END;
*
ERROR at line 1:
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3669
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3755
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157

[code]....

View 3 Replies View Related

Server Administration :: Logging In As SYS?

Sep 25, 2013

I've been an Oracle DBA for almost twenty years. In that time I have worked in various organisations - sometimes as a "permanent" employee (although nothing is permanent these days ) and other times as a contractor. I have been in my current role for the last six months since being made redundant from my last position.

In this organisation we support a lot of Oracle databases on many different servers spanning various networks. There are two DBAs who have been here for several years

However, they are both in the habit of logging in as SYSDBA for everything. They find it amusing that I refuse to do so for daily administration as I know that this is bad practice. Import and exports are even taken as SYS. Whenever I mention that it's bad practice they shrug it off saying that they've been doing it for years with no problems.

So I have been scouring Tahiti and Metalink looking for a definitive document from Oracle that states just why this is such bad practice. I would imagine that an import as SYS could have catastrophic consequences for the data dictionary if you're not careful, but I can't think of much else.

We've all seen Michel's default "just don't do it" message whenever a poster mentions that they have done something as SYS.

View 10 Replies View Related

Oracle Clients Immediately Logging Off?

Nov 4, 2011

I got a call today saying that some users were having a hard time logging on to Oracle using our in-house PowerBuilder-built application. I have Oracle 10.2.0 running on 32-bit Windows 2003. Poked around a little, looking in the dump directories, checking CPU utilization, checking OEM to see if there were any obvious performance issues or blocking issues or whatever - didn't see anything unusual. Logged in with SQL Plus with no problem. Then I checked the audit logs. All we audit is user logons and logoffs. What I was seeing is that a handful of users were showing a logon event with a logoff (action 101) 10 to 15 seconds later. One user in particular was showing this over and over again.

View 1 Replies View Related

Replication :: Refresh Snapshot Data Without Logging

Jan 20, 2009

Materialized views are normally used for summarized data access.

CREATE MATERIALIZED VIEW mv_snapshot_A
REFRESH FAST START WITH SYSDATE
NEXT SYSDATE + 20/1440
WITH PRIMARY KEY
AS SELECT * FROM A;

This does not seem to be the case here as the materialized view seems to be just a full select. The overhead of the snapshot logs are concerning for this core table. Can we turn off logging in 10g ? the materialized view is defined as fast refresh/ build immediate .

The main requirement here is to keep the snapshot every 15 minutes so that the users can see the updated information ( the flow of data from one location to other).

User get the location wise count of data and can go further in details like in which location wise system wise data count. As the base table is volatile the materialized view is used so that the moment the user clicks for location wise details the data is static for 15 min and user don't get confused.

View 31 Replies View Related

Security :: Different Logging Levels In Audit Trail

Oct 11, 2012

where to find various logging levels (like 1-10) of audit trail in oracle...if so how to set that logging levels.

View 2 Replies View Related

Application Express :: Logging On Using Portal Page?

Sep 24, 2012

We have our own portal page. We are trying to pass username and password so they do not have to log in twice. This worked in version 4.1 but when we put in patch p13331096 to get to version 4.11.00.23 the form stopped working. Users have to log into our portal page an then into APEX. That does not make them happy.

<form action="http://dashboard.reliv.com/pls/dwprod/wwv_flow.accept"
method="post" name="wwv_flow" >
<input type="hidden" name="p_flow_id" value="106" />

[Code]....

View 1 Replies View Related

Windows :: Client Logging - See What Commands Are Being Sent By Process?

Nov 4, 2011

I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:

tnsping.trace_directory = C:appproduct11.2.0client_4
etwork race
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:log
log_directory_client = C:log
trace_unique_client = on
trace_timestamp_client = on

Ths TNSPING works just fine it logs the information I expect. The client logging, however, never creates a file .

View 2 Replies View Related

SQL & PL/SQL :: Keep Logging Track Of Each Task Performed In Procedure Packages

Nov 26, 2010

we have a database application which is done frequently.in these we load data throught Sql loader, we create an DB instances, we do several DML operation on the database.

now for such task in an application we need to keep an logging track of each task performed in PL/SQl procedure packages.

View 4 Replies View Related

Server Administration :: Oracle Error When Logging Into Database

Jun 26, 2012

When I try to log into my db with a specific user I get this message. Below is from the alert log. I can login as system just fine.

----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
Oracle 10g OEL 5.5

View 9 Replies View Related

Server Administration :: How To Change Attributes Of Table From Nologging To Logging

Feb 27, 2012

How to change the attributes of a table from nologging to logging?

SQL> select table_name,LOGGING from dba_tables where owner='HXL';

TABLE_NAME LOG
------------------------------ ---
TB_OBJECTS NO

SQL> alter table hxl.tb_test logging;

Table altered.

SQL> select table_name,LOGGING from dba_tables where owner='HXL';

TABLE_NAME LOG
------------------------------ ---
TB_OBJECTS NO

View 4 Replies View Related

Data Guard :: 12514 - Error Received Logging On To Standby?

Jul 31, 2013

. I need to configure simple standby database. I have followed this[URL]...-guard-setup-11gr2.php tutorial to do that Problem is that primary db cannot log on to the standby db. Informations privided below

:Primary DB:CentOS 6.4Oracle 11gR2ORACLE_SID=primdb1SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS; MESSAGE--------------------------------------------------------------------------------ARC0: Archival startedARC1: Archival startedARC2: Archival startedARC1: Becoming the 'no FAL' ARCHARC1: Becoming the 'no SRL' ARCHARC2: Becoming the heartbeat ARCHARC1: Beginning to archive thread 1 sequence 31 (336165-356856)Error 12514 received logging on to the standbyPING[ARC2]: Heartbeat failed to connect to standby 'stbydb1'. Error is 12514.ARC1: Completed archiving thread 1 sequence 31 (336165-

[code]....

View 21 Replies View Related

Rapidly Increase Of Sys-aux?

Nov 20, 2012

when i check the free space of tablespaces,i found that sysaux increase so rapidly that i must increate in less than a week!when i checked the sysaux using v$sysaux_occupants ,and i found than

   select occupant_name,space_usage_kbytes from v$sysaux_occupants;

the result :
   OCCUPANT_NAME                                                                    SPACE_USAGE_KBYTES
    SM/AWR                                                                                       3159680

[code]...

i also use the package: exec dbms_workload_repository.drop_snapshot_range(),it din't work!!!!

in my test db,i rebuild awr,it works ,but is there any risk to rebuild in my real db?

View 5 Replies View Related

Server Administration :: Accessing Single Schema From Multiple Schema Logging?

May 16, 2011

A single master schema where many developers are accessing. all share same password.

now i would like to trace all the changes made by each users. so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema

View 2 Replies View Related

Increase In Performance Through Re-Indexing

Feb 28, 2011

I'm Using Oracle DB, I have got performance issue in one of my portlet, Can Re-Indexing work for Increasing the performance.

View 3 Replies View Related

SQL & PL/SQL :: How To Increase Column Scale Value

Mar 20, 2012

I am trying to increase the column value for example now the column values is (rate(15,2)). I want to change it to alter table table1 modify(rate(15,5)); when i change I get an error saying that ORA-01440: column to be modified must be empty to decrease precision or scale. How to change the value of the column when there is a record in the table.

View 2 Replies View Related

PL/SQL :: Increase Time In The Date?

Dec 15, 2012

We have oracle 10g R2 on windows...

I have a table test and it contains date datatype column JDATE;

SQL> desc test
Name                                      Null?    Type
----------------------------------------- -------- --------------------
EMPNO                                              NUMBER
EMPTYPE                                            VARCHAR2(20)
SALARY                                    NOT NULL NUMBER
JDATE                                              DATE
DEPTNO                                    NOT NULL NUMBERSELECT TO_CHAR(JDATE,'DD/MM/YYYY HH24:MI:SS') JDATE FROM DUAL;
JDATE
1/11/2010 4:17:29 PM
1/11/2010 4:15:47 PM
1/5/2010 3:50:44 PMIn the above case i want to update test table and increase the minut of each row by 1 minut.

like
for  1/11/2010 4:17:29 PM It would be like 1/11/2010 4:18:29 PM.
for 1/11/2010 4:15:47 PM it would be like 1/11/2010 4:16:47 PM.Can we do this...

View 4 Replies View Related

How To Increase Table Size

Oct 14, 2012

I have table and it's size is full when i'm inserting records , records are not inserting , How can i increase table size

View 8 Replies View Related

How To Increase DML Statement Performance

Jun 27, 2012

How do we increase the DML statement Performance?

View 8 Replies View Related

50000 Rows Only From Select - How To Increase

Jun 1, 2012

I would like to know how to increase the result set of a 'Select' statement? I did a 'Select' that should have returned 36,000 rows and got only 5000 rows. What access level do I need to change this and what do I need to change? I am trying to do a migration of data from a delimited file to a table in Oracle. Yet, the data has to be filtered out prior to loading to the table?

SQLSELECT MIN(major_zipcode)
FROM TEMP WHERE MAJOR_CITIES IN (select distinct major_cities from temp);

View 1 Replies View Related

Server Administration :: How To Know DB Size Increase Per Day

Jan 31, 2011

How to know DB size increase per hour or day on the Oracle?

View 3 Replies View Related

How To Increase TOAD Timeout Interval

Jun 8, 2006

When I connect to a Oracle database(remote) using TOAD client, because of the settings of timeout done at the server end(in Oracle), the TOAD session gets time out in 5 minutes.

I want to know how I can increase the timeout interval or if I can keep on pinging the database server so that the TOAD connection does not gets timeout?

PS: When we connect to a unix server using putty, we can keep on pining the server at regular timeout interval by going to Change Settings->Connection->Set KeepAlive

Is there a similar way for TOAD?

View 6 Replies View Related

Server Administration :: Increase SGA Parameter

Jul 22, 2010

SQL> alter system set sga_max_size=1G scope=spfile;

System altered.

SQL> startup force
ORA-12545: Connect failed because target host or object does not exis
SQL> show parameter sga
ERROR:
ORA-03114: not connected to ORACLE

SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

View 3 Replies View Related

Performance Tuning :: One Job Is Hanging After SGA Increase?

Mar 11, 2013

Additional Information

Step 1: Increased Physical Memory on one Node from 32 G to 48 G.
Step 1 Impact : DB was running same as before
Step 2 : Increased SGA from 12 G to 15 G.
Step2 Impact : DB was running same as before for 1 day next day one reporting job was hanging.
Step 3 : Increased DB_CACHE_SIZE from 5G to 7G.
Step 3 Impact : Over all CPU Utilization was high and no effect on reporting job.
Step 4 : Decreased DB_CACHE_SIZE from 7 G to 5 G.
Step 4 Impact : CPU Utilization came down little bit but no effect on reporting job.

Now our main concern is why CPU Utilization is going high. Because same thing we did last time and we got positive results.

View 15 Replies View Related

SQL & PL/SQL :: Replace The Like Operator To Increase The Performance

Jul 16, 2012

How to replace the like operator for increase the performance. Because it is taking more time and not using the index.

SELECT *
FROM emp
WHERE ename like '%AL';

View 30 Replies View Related

Increase Datatype Of The Column Which Already Has Data?

Apr 22, 2013

How to increase datatype of the column which already has data i.e. varchar 10 to 25 bytes

View 2 Replies View Related

Server Administration :: Increase RAM For Oracle 9i?

Jul 30, 2013

Tengo instalado el Oracle 9i en un windows server 2003 a 32 bits pero solo reconoce 2 gb de ram de memoria, como puedo hacer que reconozca mas memoria?

I have installed Oracle 9i on windows server 2003 32 bit but only recognizes 2 gb ram memory, what can i do to recognize more memory?

View 6 Replies View Related

Increase Undo_retention Value Or Undo Tablespace Size?

Aug 18, 2010

When i takeind export i got error like this..

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"POS"."TBK_POS_FACT":"KROATL200404"]

ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small"

from this can we increase the undo_retention value or undo tablespace size?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved