Search:

hi all


how we can see the queries which is currently in the sga ie shared pool, buffercahe etc.

hi all

i want to information or view, which gives the information about the which sql in shared pool and which sql is consume how much memory from the shared pool.

hi all,


i am facing that problem while increasing the shared pool size or buffercache size.

The max sga=400 mb
shared_pool=112mb
buffercahe=160 mb

ya you can connect the server via client machine only can see the tns names.ora file which is place on the client machine and give a proper host name in it or give a server ip in it so that you can...

i have find that problem so anybody can tell me, why this problem has been raised. and what is the way to troubleshoot this error.

ORA-04031: unable to allocate 3904 bytes of shared memory...

hi

by using the rowid you can delete the duplicate rows from the table

beacause rowid is the unique for the every rows so that by using this you can do it .

delete from [table_name] where...

HI all

can anybody tell me about the rebuild all the indexes of the specified schema or specified table. i want single script for that.

thanks in advance

ya it work properly but after that it you have to rebuild that index so that the index will also the delete all the rows.

so rebuild that indexes

how the sql query will process via sga what is the execution path of simple select * from table_name?

ya you can send it by simply write the query in the text editor, in the text editor first crete a table if table is not exist and written a insert queries to it when he will run that script it is...

how we can enable the audting of oracle
i want the whole schema (user level ) audting

can anybody tell me

Hi all

Can anybody tell me the query to find out the last or previous some executed SQL by SQL command prompt.

it doesnt matter it is executed by application or the SQL command prompt
...

hi all

can anybody tell me

how we can trace all the privious executed sql command which is either call by application or sqlplus command prompt?

how many backgroud process in oracle database

you just set the long parameter

sql> set long 2000;

you can see that in the user_views and dba_views or all_views

when you are getting the export backup(logical backup) i think you cant exports the grants and constraints beacause of that this problem may occure

There is no single way to tune the sql query. no one can help you about it beacause it tunning depends on the execution the sql.

I suggest you that by using the explain plan check the execution of...

Ya archive takes a space of hard disk, we can mention the path where it will be stored.

and archive is used for the point time recovery,

autotrace is used for to see the actual execution of sql.

it shows the all the path and how your query goes.

it mostly use for the tunning point of view.

Thanks and regard

Dhiraj Pande.

this may be occured beacause of following reasons
1 ) Inssuffinciant RAM memory.
2) recurssive sql
3) occuring dead locks

so pls go through the alert.log or send me a copy of alert log then...

how to read the odbc trace file which is generated by the oracle database in windows platform