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 a collection of privileges?

hari kumar

• Aug 2nd, 2012

Its role .... we can assign a role like manager , etc , collection of privs is known as role

BBBB

• Apr 19th, 2012

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Answer Question  Select Best Answer

What is a Synonym in Oracle?

jimmy.katiyar11

 Profile Answers by jimmy.katiyar11 Questions by jimmy.katiyar11

• Nov 29th, 2011

Hi, In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
 

Payal Shah

• Sep 5th, 2011

Synonum is a alias of the table..

Answer Question  Select Best Answer

Hi,

What is alternative to TK prof (used in oracle 9i) in 10g and 11g?

Regards,
Shashi

geekano

 Profile Answers by geekano Questions by geekano

• Jan 4th, 2012

Trace Analyzer Traditionally, tkprof has been the best tracing diagnostics tool available. That is, until the introduction of Trace Analyzer which is everything tkprof is and more. However, as ...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

You can make use of PL/SQL based TRCA

Other notable alternatives are
SQLTXPLAIN
Method-R profiler
OraSRP
TVD$XTAT

Answer Question  Select Best Answer

venugopal

• Sep 25th, 2011

mutating error is nothing but when we update a table at the same time when we retrieve the data from the same table then the mutating table error occurs.......to overcome we use autonomous transaction...

Ashritha

• Sep 12th, 2011

It occurs when ever we try to perform either select or dml operations on the same table in the trigger created for same table

Answer Question  Select Best Answer

natu4u1979

 Profile Answers by natu4u1979 Questions by natu4u1979

• Oct 18th, 2011

EMC,Sqlplus,Datapump and Import/export

David Lozano Lucas

 Profile Answers by David Lozano Lucas Questions by David Lozano Lucas

• Oct 18th, 2011

EMC, sqlplus, datapump...

Answer Question  Select Best Answer

My query was running fine till last month. the query will run for each month end. suddenly it is taking more than 20 minutes for running. the data is increased by 1 million. the index are all working fine . There is no cpu utilization time and also no memory blocks. What may be the reason?The increase in data has happened previous months also

shams756

• Nov 2nd, 2012

1) Try collecting Statistics
2) Spilt your query based on incoming unique values

Avi

• Sep 25th, 2012

Check for the bottle necks starts from the source and continue till target

Answer Question  Select Best Answer

A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.

ravinder

• May 4th, 2012

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 13th, 2012

A cluster is a group of tables which share the same data blocks. Clusters are an optional method of storing table data. Cluster share common columns and are often used together. It is a powerful met...

Answer Question  Select Best Answer

What is the amount of performance improvement you get with doing BULK COLLECT? I tried answering I will measure with the cost.. but the interviewer wants a specific answer. Is there any general formula for deriving the cost improvement based on the no. of records processed in bulk fetch?

Nikhil Inamdar

 Profile Answers by Nikhil Inamdar Questions by Nikhil Inamdar

• Jul 4th, 2016

Generally for millions of records, BULK COLLECT performs very much faster. If we compare BULK COLLECT and normal CURSOR FOR LOOP then BULK COLLECT can perform almost 4 times faster.
You can create your own program and use DBMS_UTILITY.GET_TIME for comparing the results.

dinesh

• Feb 3rd, 2013

We can limit the bulk binding values. It would improve the overall performance. It would not consume more memory.

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

balajiintech

• Jun 29th, 2007

Logs increase rapidly when large amount of data are inserted/deleted/updated. when Commit/Rollback is issued.

aniket

• Jun 20th, 2007

Std command to check logs is...trail -f .Thanks~Aniket

Answer Question  Select Best Answer

HARI SHANKAR SHARMA

• Jul 18th, 2011

Select aa_seq.currval from dual

Regards,
Hari Shankar Sharma

Hari Kiran P

• May 14th, 2007

You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P.

Answer Question  Select Best Answer

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Mar 17th, 2009

Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle')

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

Dear friend :  oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using <seq_name>.nextvalfor ...

Answer Question  Select Best Answer

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.Open Command prompt.Write tnsping < SID for the database connectivity you want to check >If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.If you get “TNS-03505: Failed to resolve...

Chiranjeevi Manne

• Mar 30th, 2007

TNSPING is an Oracle network utility which checks for connectivity of a remote database.

kmkumar24

 Profile Answers by kmkumar24 Questions by kmkumar24

• Mar 29th, 2007

The TNSPING which helps to findout whether we have the connectivity to the particular database. It can be accessed from the dos prompt with either database name or with IP address.If it ping with that...

Answer Question  Select Best Answer

basmgokul

 Profile Answers by basmgokul Questions by basmgokul

• Apr 3rd, 2008

Hi,Step 1: save your script as .sql format.Step 2: to run your script, follow thisSQL> @'pathname'assume your script db.sql was saved in c:datascript, thenex:SQL>@'c:datascriptdb.sql'

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 13th, 2008

To run scriptSQl> @ C:script.txt

Answer Question  Select Best Answer

Rajeshree Metkar

• Aug 10th, 2007

Hello,As I go through the Comments related to the dual table I saw that there is a comment that we can not perform a DML operation on Dual table. Yes it is correct but only in case if you are log in t...

lieni

• Jul 30th, 2007

No., We cannot perform DML operations on Dual table. because we dont have the access permissions on that table.I say: But if we have access, eg. sysdba, we canFor security reasons,we hide data from th...

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Mar 27th, 2008

Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse S...

fancyoracle

 Profile Answers by fancyoracle Questions by fancyoracle

• Aug 16th, 2007

Once parsed, the SQL statement is available in the memory till the session is valid.

Answer Question  Select Best Answer

saginandkishore

 Profile Answers by saginandkishore Questions by saginandkishore

• Jun 24th, 2008

Where current of is used for updating the data referenced by cursor which was created as "SELECT FOR UPDATE".DECLARECURSROR MY_CURR IS        SELECT COL1, COL2,...

shamkohli

 Profile Answers by shamkohli Questions by shamkohli

• Jun 17th, 2008

While using cusor in PL/SQL, when we update a record, we can write WHERE CURRENT OF     along with cursor_name.This is done in place of the where condition while updating. If we gi...

Answer Question  Select Best Answer

AshaMahesh

 Profile Answers by AshaMahesh Questions by AshaMahesh

• May 15th, 2008

ther is Physical structure & Logical structurePhysical structure Consits of 3 files             one or more data files   ...

Mohammed Abdul Afroze

• Sep 28th, 2007

The Physical Structure of a Database are as follows:1.Controlfiles2.Redo Log Files3.Datafiles.

Answer Question  Select Best Answer