-
Where should you place Archive logfiles, in the same disk where DB is or another disk ?
poojap
- Oct 6th, 2010
Yes, Archive log files should be on different disk?because?in case of database failure we can get ?the data from the Archive logfiles.
dhs01
- Apr 15th, 2009
In addition to the previously stated reason that if there is a disk problem, not having them on that disk is a good idea, another issue might be contention. Putting them on the same disk would keep th...
-
Alert Log File
What are contents that are not saved in alert log file? What happen when alert log file is full?
dbashashi
- Oct 8th, 2010
Almost all the event against the database which may hinder its smooth operation is captured in Alert Log file as error messages.Oracle creates a new alert log files if you delete the current one after taking backup for future reference.Shashi b Singh
-
Control Number of Datafiles
How do you control number of Datafiles one can have in an Oracle Database?
-
Database Connections
How will you determine the number of connections connected to your database?
Anupama Kanakam
- May 29th, 2011
We can also see these connections on Activity monitor. But you need permissions to see it.
jsavarin
- Nov 8th, 2010
We can determine the number of connections by using this - SELECT COUNT(*) FROM v$session;
-
How do you sort a table?
dineshctbm
- Jul 2nd, 2011
Order By is a keyword which is using for sort the table records either ascending or desending.For eg,for ascending,Select emp_name,emp_identity from emp order by emp_identity;Select emp_name...
nalinicisf
- May 19th, 2008
contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT * from [table name] &...
-
Alert log file
how to see some selected lines in alert log file in unix environment.
like tail -100f alert_SID.log we can see only 100 lines but i need to see the lines between 300 to 500 from down .muthu5047
- Sep 3rd, 2011
Assuming you need lines 20 to 40,
sed -n '20,40p' file_name
or
awk 'FNR>=20 && FNR -
Kill Multiple sessions
If have 50 inactive session and i want to to kill all session at once tell me the procedure to kill all 50 session at once
muthu5047
- Sep 3rd, 2011
in our project to kill all the inactive session we use the following script.. run the sql script given below it will give u all inactive sessions sid and serial no and redirect output to (inactive_kil...
-
How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.
sudhakar
- Sep 25th, 2011
1- When BEGIN BACKUP is issued: The hot backup flag in the datafile headers is set, so that the copy is identified to be a hot backup copy. This is to manage the backup consistency issue when the cop...
tykarthick
- Oct 6th, 2009
Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's wil...
-
Disk Space Estimation
For this assignment task you will design a database for capturing student’s assessments marks and estimate the required amount of space.
Suppose we suppose that there are 5000 students at our institution and that on average each student registers for 5 courses in a semester design a database that can be used to capture the registration of courses and eventual capturing of a maximum... -
-
How do you show Oracle free SGA memory?
-
How to recover the datafile without having backup?
Take cold backup and recover
shoaib1786
- Nov 5th, 2011
Just create the datafile with same location mention in ur controlfile and recover the datafile ... Its simple.
naveen
- Sep 19th, 2011
Alter database create datafile 'and give the datafile location and /name' by using this command we can recover the datafile without backup also
-
ARCHIVELOG mode
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
-
Sort_area_size usage
Why we use Sort_area_size parameter in init.ora file?Kindly let me know?
Lokesh M
- Dec 7th, 2011
SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...
-
In what situation you have to prefer offline and online backups ?
Lokesh M
- Dec 7th, 2011
Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...
-
How to calculate the row length?
Lokesh M
- Dec 7th, 2011
You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.
-
Oracle - Change Columns to row
What is the query to change the rows into column and columns into row
Manas Kumar Hati
- Oct 31st, 2011
Unsing Pivot Query
-
-
What is the difference between these two?
I am new here and i am not sure if I am posting this in the correct place. But I have recently started studying to be a programmer but because there is so much out there between these two I am getting more and more confused about how to answer this. Could someone please answer these so I can at least get my head around it all? Thank you!! This is what the questions are:
After initial...Tom Haughey
- Apr 30th, 2012
I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain th...
-
Do you need a commit after DDL statements?
Chintan
- May 29th, 2012
DDL is Auto Commited Statements.
cmanne
- Mar 25th, 2007
There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically
Database Admin Interview Questions
Ans