You are missing at least one shared object file that is necessary to run the various O/S utilities like ls. This system needs to be re-installed...
Please get familiar with the USER_SOURCE view, as it contains the code for packages, functions and procedures compiled in the database. Since...
Read here: You Take Too Long About half way through DBMS_PROFILER is discussed, which is what you should use to profile and tune PL/SQL code.
There is NO file named orainstRoot.sh in an Oracle installation. Why are you saying there is? There is a root.sh that should be run, but...
That is what the sql_id will get you; V$SQL should provide the SQL statement associated with that id.
This might give you what you ask for: select sid, serial#, sql_id, sql_exec_start, prev_exec_start from v$session;
Do not get the notion that LogMiner is not a valid tool, it is, however when the list of logfiles gets long PGA usage can climb to the point of...
LogMiner can be a memory-intensive application as it populates memory-resident views that roll up to the v$logmnr_contents view. As LogMiner...
The Oracle online documentation is a wealth of information: https://docs.oracle.com/apps/search/search.jsp?q=create+database+link&category=database
Logminer can cause PGA overages over time; pga_aggregate_limit errors result and cause processes toterminate for lack of PGA resources. WHY do...
Without sysdba privileges you won't be able to see anything useful. You might consider downloading a free copy of Oracle and installing it on...
Given that rn must be 1 in your merge statement your query doesn't generate the data you expect. Yes, your list would be correct if rn were not...
You can't get that with the data you have: SYS @ orcl > with t2 as ( 2 select eof 3 , s_date 4 , val_1 5 ,...
That is correct, none of your date and eof values match between the two tables so nothing gets merged.
It's good that you want to learn but you need to ask YOUR DBA what he/she did to find the cause. No one in this forum has access to your database.
select LPAD(replace(to_number(to_char(1234.7,'S999999990D90')),'.',','),11,'0') from dual
We can't understand the error without the complete context; post the complete error message returned when this runs. Having that information...
Don't just show us the results you want, show us also what you've written to solve this. We will help you but we won't do your work for you.
You do realize that Oracle products are not supported on CentOS? You may get them to work but if you have issues Oracle support won't be of any...