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?
I noticed that listener file in diag/trace is rapidly increasing. I am using 11g Rel 1 on window 2008 server Its 1 GB in couple of days. Is there any way if I can turn it off ?
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.
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...
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);
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
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
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.
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?
I am trying to increase the size of sga or you can say that i want to make my sga in automatic memory management...Following is the steps i am trying
SQL> show parameter sga_max_size;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 96M SQL>
after that i am trying to increase the size
SQL> alter system set sga_max_size = 200m; alter system set sga_max_size = 200m * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified
One of my MOD_PLSQL based Oracle APEX Application is running on the web. I have almost 1000 web users to access the Application where at least 250-300 users are always on line. In Oracle EM web interface When run ADDM I see suggestions "Investigate the cause of SQL*Net more data to client" or something like this. and I am getting complains about poor server response. Here are my configuration of the system:
Database Server Host: DBServer (Oracle Database 10.2.0.3) HTTP Server Host: OraHTTP (Oracle Companion CD 10g)
DADS.conf HTTP Server configuration MOD_PLSQL database access for web clients.
How can I increase database connection performance?
I have Oracle 11gR2 running on windows xp machine. Windows xp has total size of 150 GB and free space of 95 GB.
I checked the size of the database that I created. It showed the total size of the database as 2 GB and used space as 2 GB. If I want to increase the total size of the database to 50 GB, what should i do? Now which is the disk space size? Windows or Oracle?
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.
I am executing a plsql procedure and trying to increase buffer size to display all characters, procedure is given below:
create or replace procedure prc_p(prm_t1 in VARCHAR2, prm_t2 in VARCHAR2, prm_tab in varchar2 ) AUTHID CURRENT_USER as str_sql VARCHAR2 (4000); [code]..........
We had a database (DB A)that is having version 9.2.0.6.0.This DB is having multiple tables and volume of 6 million in individual tables.Another database is also 9.2.0.6.0 (DB B), this DB has Mviews pointing to DB A. Mviews are refreshed in every 15 mins, with fast refresh option in 90% cases and remaining having complete refresh.
Last weekend we have migrated DB 2 to version 10.2.0.4.0 - 64bi and on another server.After version upgrade and DB migration complete refresh was done once for all mviews.
Now DB A is generating huge amount of archive log and also it's UNDO space is getting fully consumed causing performance issue and DB hang.what has gone wrong and what we can do to improve response of DB A and also to reduce size of Archive log ?
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 1152M sga_target big integer 0
[code]....
in scenario above, the database do not using ASMM, and spfile If I wan to increase db_cache_size parameter, do i need to rebounce instance?
We have a table emp_details with 23772889 records. Our requirement is to increase few of the columns size in the table emp_details. We are following the below alter statement which is taking around 2 hours of time.
We are just but new oracle 10g(10.1.2.0.2) Database and application server ( form and report server ).have installed application server on window server 2003.
it will running ,but it is used lots of memory.so the performance decrease when user increase.
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string AUTO undo_retention integer 96000 undo_tablespace string undo
Following are the details in AWR report (00:00 til 01:00 of 21-Apr-2013) .... not thet the error was produced at 00:42
Undo Segment Summary DB/Inst: DBCPY/dbcpy01 Snaps: 18853-18854 -> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) -> STO - Snapshot Too Old count, OOS - Out of Space count -> Undo segment block stats: -> uS - unexpired Stolen, your - unexpired Released, uU - unexpired reUsed
[code]....
Undo Advisor information taken 'now' is as following
SQL> select dbms_undo_adv.longest_query(sysdate-2,sysdate) from dual; DBMS_UNDO_ADV.LONGEST_QUERY(SYSDATE-2,SYSDATE) ---------------------------------------------- 379650 SQL> select dbms_undo_adv.required_retention from dual;
[code]....
In above situation what should be my first choice (assuming increasing space is not an issue) - increase undo tablespace or increase undo retention?
If latter is the choice then what should be the value? Because as I understand present 96000 value is taken as lower limit and because of auto tuning the actual value (TUNED_UNDORETENTION) being used was 345600 In that case shall I set it to something > max(maxquerylen) i.e 379,650 + X?Or I shall increase the undo tablespace size?
From Undo Advisor output it looks to me that even if I increase the undo retention to 379650 current undo size will be able to support it (may be at the expense of DMLs)Is that right?
