-
Database Designing and Modeling
What are the differences between database designing and database modeling?
ramu541
- Sep 12th, 2008
Effective database design can help the development team reduce overall development time and costs. Undertaking the process of database design and creating a data model helps the team better understand...
-
Tablespace Quota
A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota 200 M Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?
bassem_farouk
- Sep 17th, 2008
Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored. SQL> create user test identified by test1; User created. SQL> grant connect, reso...
vishnusivathej
- Jul 21st, 2008
There will be no such thing as default size for a tablespace u have to assign it when it is being created.. and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..
-
Remove Oracle memory segments
How do you remove memory segments
bassem_farouk
- Sep 18th, 2008
To see the Oracle memory segments from UNIX write ipcsthen look at the status column, the one with status is empty and? owner is oraclewrite down the shmid, ex: 2 find 2 shmid 123 and 456?in order t...
-
Oracle Reserved Memory and Unreserved Memory
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
bassem_farouk
- Sep 21st, 2008
Is the meomory that is allocated to each connection to Oracle, this memory is not recliamed even if the session is inactiveit is recliamed if the session is disconnected onlyto see it:D:appadminproduc...
-
Increase %LIKE Operator Performance
How do you increase the performance of %LIKE operator?
ravinder.pathania
- Oct 6th, 2008
The wildcard char % can be placed in one of three ways: %searchwordhere% searchwordhere% %searchwordhere The searchwordhere% is the fastest because it can use an index if one is specified on that ...
-
When a database is started, Which file is accessed first?
raghukiranreddy
- Aug 19th, 2008
you want to starting up a database by using STARTUP command....SQL>STARTUPto start instance, database must read the intialization parameter from either a server parameter file(SPFILE)or a trad...
-
How to handle data curreption for ASM type files?
imran44
- Dec 30th, 2008
The storage array should contain one or more spare disks (often called hot spares). When a physical disk starts to report errors to the monitoring infrastructure, or fails suddenly, the firmware should immediately restore fault tolerance by mirroring the contents of the failed disk onto a spare disk
-
Replication Server
Explain how will you setup Replication Server & sync it?
vijaykaushik
- Dec 31st, 2008
Replication server can be setup using many ways1)Using Oracle Streams2)Using Advanced replication 3)Using Mviews.Each has their own mechanism to sync data. Regards,Vijay Kaushik
-
Load Data into Multiple Tables
How to load data into multiple tables at once?
vijaykaushik
- Dec 31st, 2008
You can use SQL loader to do this. Using the When condition in SQL Loader control file this is possible.
-
Recover Database
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?
vijaykaushik
- Dec 31st, 2008
This can be easily done but you will loose the data if you don't restore from backup.If you have a backup of datafiles and controlfile then restore them.If you don't have the backup then you n...
-
Can you change priority of a Process in Unix
jituoracle
- Jan 6th, 2009
Unix does provide the command nice [increment] command to lower a priority of a process. As system administrator you can use the renice command to change the priority of a process, all processes of a...
-
What is cluster key
imran44
- Jan 9th, 2009
The related columns of the tables in a cluster are called the cluster key. The cluster key is indexed so that rows of the cluster can be retrieved with a minimum amount of I/O.
Dan
- Jul 9th, 2005
A cluster index is needed in support of a cluster. One is used to allow the other to exist. Much like we need an index in support of a primary key. They are not the same things. Cluste...
-
Monitor and Modify Data during Loading
How to monitor how fast a table is imported? How to modify data as it loads into the database?
Ramshankardba
- Jan 17th, 2009
Use below script to monitor how speed import is happening.SELECT SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name, rows_processed, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:s...
-
Oracle segments
How do you see how many memory segments are acquired by Oracle Instance.
Baipaneni
- Jan 23rd, 2009
For shared memory segmets in UNIX or LINUX:-->In HOST1_LINUX has one instance $ ipcs -m oracle@HOST1_LINUX:$ ipcs -m------ Shared Memory Segments --------key &nb...
-
ASE Server Performance
What will you do when the ASE server's performance is bad?
rajat_dua
- Mar 2nd, 2009
Bad performance" is not a very meaningful term, so you'll need to get a more objective diagnosis first. Find out (i) what such a complaint is based on (clearly increasing response times or ju...
-
Mutated Trigger
What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?
zodiac_som
- Mar 2nd, 2009
If you are using before in trigger block, then replace it with afterMutated error, when same table access?more than once in one state.
-
Estimate SGA Size
How to estimate the size of SGA?
rajat_dua
- Mar 2nd, 2009
SQL> show sgaTotal System Global Area 167772160 bytesFixed Size 1247900 bytesVariable Size 58721636 bytesDatabase Buffers 104857600 bytesRedo Buffers 2945024 bytes
-
What are the fixed memory structures inside the SGA?
rajat_dua
- Mar 3rd, 2009
Part of the SGA contains general information about the state of the database and the instance, which the background processes need to access; this is called the fixed SGA. No user data is stored here....
-
How to convert local management tablespace to dictionary managed tablespace
amit19821
- Mar 13th, 2009
Local to Dictionary managed tablespcaes:exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tablespace');Dictionary to locally managed tablespaces:exec dbms_space_admin.Tablespace_Migrate_to_Local('tablespace');
g.mrunalini
- Jul 22nd, 2008
Use the following package>execute dbms_space_admin.tablespace_convert_to_local('tablespace_name');>execute dbms_space_admin.tablespace_convert_from_local('tablespace_name');
-
Oracle table space Quota and users
How to create User in Oracle, allocate quota on Oracle table space
shrikant2711
- Mar 28th, 2009
SQL> create user test identified by test default tablespace XYZ quota unlimited on XYZ1 quota unlimited on XYZ2 quota unlimited on XYZ3 quota unlimited on XYZ4;User created.
Oracle DBA Interview Questions
Ans