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


ADVERTISEMENT

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

SQL & PL/SQL :: How To Specify Precision And Scale For NUMBER Parameter In Procedure

Nov 7, 2012

I have a procedure. Here is the spec

Procedure countyname(i_lat IN Number, i_lon IN NUMBER, o_countyname OUT VARCHAR2);

The procedure works fine when the input parameter values are small precision like 30.653, -618.765 etc.it fails if the Input parameter values have more precise like 35.694872140886...I think the IN Number can only take upto certain precission.

Is there any way I can specify the precision for a NUMBER input parameter in a procedure?

ex: Procedure countyname(i_lat IN Number(30,10), i_lon IN NUMBER(30,10), o_countyname OUT VARCHAR2);

when I tried the above statement it doesn't compile it gives PLS-00103 error.

View 11 Replies View Related

Performance Tuning :: Best Disk Config For SME Scale Data Warehouse

May 15, 2013

We are working on a Data warehouse (ard 50G ) architecture with the following acquired environment:

Single server X3650 M4 Dual CPU ( 16 core in total ) with 48G ram
Oracle standard 10g x64
Windows 2008 x64
128 SSD x 8
IBM ServeRAID M5110e SAS/SATA Controller

Due to budget concern, we will be running the App server(Business OBjects 4.0 w/ Tomcat and DB server on the same machine. ) We have a user base of around 30 ppl on the app server.

We intend to have external redundancy using IBM raid card on raid 10 configuration. I wonder what kind of disk config yield better performance if we only have write update in the morning and 95% read for the rest ?

Raid 1 for OS (128SSD x 2 including DB logfile )
Raid 10 for DB server ( 128 SSD x 6 )

I heard ASM provides better disk management but just wonder it increase performance in anyway.

View 2 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

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

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

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

Server Administration :: Unable To Increase Size Of Sga

Feb 2, 2012

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

View 1 Replies View Related

Networking And Gateways :: How To Increase Oracle SQL*Net Performance

Nov 25, 2011

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?

View 6 Replies View Related

Server Administration :: Increase Size Of Database To 50 GB

Jan 31, 2013

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?

View 4 Replies View Related

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 View Related

PL/SQL :: Increase Buffer Size Of Dbms_output.put_line

Feb 28, 2013

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]..........  

View 1 Replies View Related

Server Administration :: Sudden Increase In Archive Log Size

Mar 26, 2010

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 ?

View 3 Replies View Related

Performance Tuning :: Restart Database After Increase Db_cache_size?

Aug 23, 2012

SQL> show parameter sga

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?

View 6 Replies View Related

Reports & Discoverer :: REP-1108 - Increase Layout Default?

Mar 15, 2012

I have a report with matrixs group, when I try to add a new group in a new level, I get this message :

REP-1108 : Cannot fit default layout even in region extending to page boundaries.

How can I increase the layout in 10g?

View 2 Replies View Related

Forms :: Change Values (increase / Decrease) In Runtime?

Jan 6, 2012

I having one list field which contains 31 values.

how can i change the values(increase/decrease) in the runtime.

View 1 Replies View Related

Performance Tuning :: Increase Few Of Columns Size In The Table

Feb 14, 2013

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.

ALTER TABLE emp_details
MODIFY
(
address char(90)
,department char(30)
)
/

Is there any way to improve the above query performance?

View 2 Replies View Related

Server Administration :: SGA SIZE (Increase Shared Pool)

Jun 4, 2013

I want to increase my shared pool. my SGA values are as under below.

SELECT NAME,SUM(VALUE)/1024/1024/1024 gb FROM V$SGA
GROUP BY NAME;

Database Buffer 4.8125
Redo Buffers 0.0782623291015625
Variable Size 19.0000001564622
Fixed Size 0.00208648294210434

View 5 Replies View Related

Enterprise Manager :: Increase Performance Of Form And Report Server?

Aug 27, 2009

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.

View 1 Replies View Related

Performance Tuning :: How To Increase Data Retrieval / Insertion Speed

Oct 24, 2013

How To Increase Data Retrieval / Insertion Speed my data base has more than 0.5 million records Forms Some Time Respond Very Slow .

View 8 Replies View Related







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