What is Dynamic SGA?What is the advantage of Dynamic SGA?

hmounir

 Profile Answers by hmounir Questions by hmounir

• May 3rd, 2010

Dynamic SGA allows to change the size of the buffer cache, the large pool, the shared pool and the process private memory on the fly, that is without shutting down the instance.

doza_kasf

 Profile Answers by doza_kasf Questions by doza_kasf

• May 1st, 2010

Dynamic SGA allows to change the size of the buffer cache, that is without shutting down the instance.

Answer Question  Select Best Answer

How will you change the local management tablespaces into dictionary management tablespaces?

dharan415

 Profile Answers by dharan415 Questions by dharan415

• May 26th, 2010

To convert a LMT to DMT,SQL> exec dbms.space_admin.Tablespace_Migrate_From_local('Tablespace name');

hmounir

 Profile Answers by hmounir Questions by hmounir

• May 5th, 2010

By  creating all rollback segments in locally-managed tablespaces.

Answer Question  Select Best Answer

What is POST in D2K.How can you change the LOV Dynamically?

When do we will go for Sequence and when go for Indexes. What is the difference between Sequence and Indexes.

varunprasath

 Profile Answers by varunprasath Questions by varunprasath

• Jun 7th, 2010

Sequence - A sequence is used to generate a number sequence that can be used as a primary key.Indexes - An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.

Answer Question  Select Best Answer

How to update base table (data dictionary) automatically in every 5 sec or 5 min?

monika_iims

 Profile Answers by monika_iims Questions by monika_iims

• Jun 18th, 2010

1.create a procedure with update statement2. create a job on that procedure and give the time interval

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

Provide clear scenerio what you want to achieve with example

Answer Question  Select Best Answer

Where is Oracle Inventory located in Oracle 10g and 11i ?

What do yo mean by exceptions? How many type of predefined exceptions are there & What are they?

sunnybhattacharjee

 Profile Answers by sunnybhattacharjee Questions by sunnybhattacharjee

• Jul 7th, 2010

You can store a jpeg file or a bitmap file in Oracle using the BLOB data type.It stores the jpeg image as a stream of bytes.In order to retrieve the data.You cant simply perform a select query over it...

sudheer

• Oct 6th, 2006

To store larger object in database use 'blob'

Answer Question  Select Best Answer

How to show the cursor is busy when any process is going on in Oracle Forms 6i?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

Set_application_property(cursor_style, busy);

Answer Question  Select Best Answer

How to debug stored procedure in Oracle?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

You may use dbms_output.put_line([string]) between lines you think causes the error.

Answer Question  Select Best Answer

How to run same report with different query through parameter

How to avoid Cartesian product comparing duplicate tables in SQL?

How to convert Oracle Report into text or doc file?

bondneoo

 Profile Answers by bondneoo Questions by bondneoo

• Aug 18th, 2010

Goto Tools->Preferencesthen Runtime Values->Set mode to character.

Answer Question  Select Best Answer

Which command is used for locking a user from performing DML Operation?

ashdba

 Profile Answers by ashdba Questions by ashdba

• Sep 5th, 2010

Revoke insert,update,delete privileges from the user

karthikasathya

 Profile Answers by karthikasathya Questions by karthikasathya

• Oct 1st, 2009

LOCK TABLE  tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE;

Answer Question  Select Best Answer

How to "reverse" a MassAllocation Journal Entry in Oracle?

What is the meaning of 'doc' command in oracle ? What are the use of it?

SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8 DBMS_OUTPUT.PUT_LINE('Aloha!!! Today Is Tuesday'); 9 ELSE 10 DBMS_OUTPUT.PUT_LINE('Today is '||to_char(sysdate,'Day')); 11 END IF; 12 END; 13 /Today is TuesdayPL/SQL procedure successfully completed.SQL>What's...

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 2nd, 2011

It should be (sysdate,'day')

shri_b

 Profile Answers by shri_b Questions by shri_b

• Mar 12th, 2010

Use trim(dayofweek) in IF Condition

Answer Question  Select Best Answer

How does Oracle guarantee data integrity?

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 4th, 2011

Data Integrity is maintained by Triggers and various other constraints in Oracle.

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 4th, 2011

Oracle Database enables you to define and enforce each type of data integrity rule defined in the previous section. Most of these rules are easily defined using either integrity constraints or datab...

Answer Question  Select Best Answer

How do you send the output of your SQL* Plus session to a text operating system file

prateek2612

 Profile Answers by prateek2612 Questions by prateek2612

• May 15th, 2011

See spool command

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

Answer Question  Select Best Answer

hii i have a emp table .empno stores all the numeric valuesand accidentally i have added some values with combination of alphabets and special charactersnow i need a query which will return all the records which is having alphabets and characters in their value.assume tht table has records in lakhs.Please answer this questionthankx in advancesreekanth

damodharyadav

 Profile Answers by damodharyadav Questions by damodharyadav

• May 23rd, 2011

Select non_num_col from sample_tablewhere length(non_num_col) -length(replace(translate(non_num_col,'qwertyuiopasdfghjklzxcvbnm',' '),' ','')) 0 

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 19th, 2011

Select order_status from orders where TRANSLATE (order_status, CHR (1) || '1234567890', CHR (1)) is not null

Answer Question  Select Best Answer