How to find the startup time of instance?

kishore

• Nov 15th, 2011

How to get instance startup time


>select to_char(startup_time,'dd-mon-yyyy HH12:MI:SS ')"db startup time"
2 from sys.v$instance;

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Use this simple command in SQLPlus or an a query retreival tool of your choice. select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;

Answer Question  Select Best Answer

In which file we can see start up information?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

I will give you three options as im unsure of what your requirement is:-If you're talking about a flatfile which contains the startup information, Well it is obviously the alert logfile. It can be fou...

gopal_1980

 Profile Answers by gopal_1980 Questions by gopal_1980

• Apr 6th, 2010

Alert log file

Answer Question  Select Best Answer

You have a batch job which has hundreds of SQL queries in it. Earlier is was finishing in expected time. However, now it is taking twice the time. There is no CPU utilization issue due to other jobs. How would you know that which of the queries are taking more time now and why?

Nagaraj Teli

• Jul 22nd, 2012

Please find the below methods for finding one of the query which is taking longer time in the batch script. Methods :- 1) Put the dbms_output after each of the SQL query. 2) Create a logfile using th...

koushikinath

 Profile Answers by koushikinath Questions by koushikinath

• May 24th, 2012

1. At first enable the trace, at the beginning of the sqls.
2. Then check the trace file.
3. Using tkprof create the output file.
4. According to explain plan check the elapsed time for each query.
5. Then tune them

Answer Question  Select Best Answer

Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

About performance, it depends upon the computations you will be performing inside that function. Also, if we are using (user-defined) function in SQL (rather than creating PL/SQL), then it will give better performance.

While using user-defined functions, we need to avoid Mutating functions error.

murugesan

• Jan 19th, 2013

Yes we can pass but the function should return a value of type appropriate for the calling function

Example

round(trunc(100))

Answer Question  Select Best Answer

What is the use of IGNORE option in the Export and Import?

viswanath

• Jul 30th, 2015

When you put IGNORE=Y it is simply ignore the previous backup. That means, while during backup where you can stop and add another backup or file. It store the that adding file only, not whole backup.

Balakumar

• Jul 17th, 2015

For getting input and output

Answer Question  Select Best Answer

How does CURSOR and BULK COLLECT work logically?

SATHISH S

• Jul 28th, 2017

Cursor is storage area which stores the queried results whereas bulk collect will get bulk amount of data from cursor and insert into some cursor variables.

anil

• Apr 26th, 2017

Cursor is record by record process coming to bulk collect clause select column data at a time

Answer Question  Select Best Answer

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

We can not delete responsibillity but we can disable the responsibility from user so that user can not use this resp he is not authorised to use particular responsibility.

psicre

 Profile Answers by psicre Questions by psicre

• Jul 22nd, 2010

You cannot delete reps in EBS....

Answer Question  Select Best Answer

aStewart

 Profile Answers by aStewart Questions by aStewart

• Feb 23rd, 2010

The index status can be found in the dba_indexes, dba_objects, or the equivalent  user_ view. The possibilities are VALID, INVALID, UNUSABLE, or N/A.  Invalid or unusable indexes will not be...

Asim Jamal

• Apr 13th, 2006

The current status and details of an index could be accessed by system table sys.dba_indexes. The status could be VALID,INVALID,N/A.The invalid indexes unnecessarily occupies the space in a Tablespace.

Answer Question  Select Best Answer

Shailu

• Oct 6th, 2006

When you try to execute procedure from procedure just  write procedure name. If you  are executing from SQL*Plus them write EXEC Thanks, Shailu

Naseem

• Aug 23rd, 2006

Executing a Procedure:exec To View a Procedure:desc -- gives u only the in/out parameters used by procedure.Select text from user_source where name = ' -- gives u the whole procedure contents.

Answer Question  Select Best Answer

Vrushali

• Aug 9th, 2007

Tablespace : A tablespace is a logical structure on a Oracle database consisting of one or more datafiles. The objects are stored in a tablespace.Clusters: When two or more tables have a requirements ...

Ramco

• Oct 9th, 2006

Table space is the logical data units of a database. every database is divided into Database -> tablespace -> segments - > externsin short (tablespace is a logical group of data files in a da...

Answer Question  Select Best Answer

Ashish

• Sep 28th, 2006

Use DBMS_PROFILER to tell you exactly which lines in the PL/SQL code are taking time.

Priya

• Sep 26th, 2006

You can use DBMS_UTILITY.GET_TIME procedure.

Answer Question  Select Best Answer

How to take backup using RMAN backup, without catalogdb?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 6th, 2011

First you connect to oracle usersu - oracle2then goto cd $ORACLE_HOME/bintype rmanRMAN> connect target;          >  backup database plus archivelog;

smmdba

 Profile Answers by smmdba Questions by smmdba

• Jul 7th, 2008

 How to connect to RMAN without catalog

Answer Question  Select Best Answer

Explain what are Oracle Catlog & Oracle Archive Log ?

jazz

• Sep 20th, 2011

When the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...

Answer Question  Select Best Answer

How will you find the total number of databases present in our system via LINUX OS?

Richard Naveen

• Oct 31st, 2011

Etc/oratab

subrahmanyam pattapu

• Jul 20th, 2011

We can find which databases are running in server. by using the following command.

ps-ef|grep smon

It will show the databases is up and running.

Answer Question  Select Best Answer

mani

• Oct 12th, 2021

Clob

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

1. Show SGA.2. It is related to block oracle has to search more.3. Increase the size of Undo segment.

Answer Question  Select Best Answer

janardhan akki

• Sep 26th, 2012

In Case of normal views when ever u call the view it will get data from base table......

in case of pipeline view: if u call the view it vil get data from another view .....means it also logically getting data from base tables only.......the inner view may be materialized view....

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Increate the size of database buffer cache.OrSet parameter pre_page_sge=trueThe main adventage is, all pages are touth to physical memory.The main disadvantages is, it create more active pages & more time to make connect.

Answer Question  Select Best Answer

kumaresan.m

 Profile Answers by kumaresan.m Questions by kumaresan.m

• Sep 12th, 2006

1)Database can be opened without tempfiles in the temporary tablespace.2) Tempfiles can't be renamed.3)Tempfiles doesn't need recovery.4)Segments in temporary tablespace are dropped when no longer required.

love_oracle

 Profile Answers by love_oracle Questions by love_oracle

• Feb 13th, 2006

Diffierence between tempfile and datafile are:1)tempfile does not want recovery2)tempfile can't be taken offline3)data of the tempfile lost when the oracle server shutdown

Answer Question  Select Best Answer

mekshi_2kk

 Profile Answers by mekshi_2kk Questions by mekshi_2kk

• Mar 6th, 2006

Snapshots are the portion of database. Similar to views

swadhin kuamr sahoo

• Feb 12th, 2006

Snapshots are local copies of remote data.It is same as materialized views

Answer Question  Select Best Answer