Reputation
881
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8
Impact
~38k people reached

  • 0 posts edited
  • 1 helpful flag
  • 35 votes cast
Jun
30
comment How do I determine the appropriate size for my tablespace when importing a .dmp file?
maybe offtopic, but usually it is helpfull to execute the rman command "report schema" on source db, to get report about datafile sizes. Also you can use imp option show=yes to get ddls for tablepsaces (is its full database export).
Jun
30
answered Is possible do an online snapshot backup , without archive logs at Oracle Database?
Jun
30
comment Getting milliseconds elapsed during a stored PL/SQL procedure
Maybe OT: do you really need such a precision on PL/SQL level? Usually most of the time is spent in SQL execution and Oracle offers tools to collect performance data for each SQL - for example per sql_id.
Jun
12
comment Causing ORA errors in a program using JDBC. How can I find what's causing them?
@a1ex07 it won't apper in the v$sql view, but it should be read from ora_sql_txt function. It is the attribute passed to even trigger.
Jun
12
answered Causing ORA errors in a program using JDBC. How can I find what's causing them?
Jun
9
answered Purge ARCHIVELOG automatically
Jun
5
comment How can we get the table and the column name of known data value?
@miracle173 AFAIK I saw somewhere a PL/SQL script doing that, I'm not 100% sure who was the author. But such a requirement is quite common: stackoverflow.com/questions/208493/…
Jun
5
answered How can we get the table and the column name of known data value?
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
Gcc version is specified as prerequisite for database installation. In case of stored procedures threre are probably no requirements. But at least glibc version should be the same and Oracle libraries version must be the same. Theoretically you shloud recompile the stored procedure anytime you patch the database.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
I do not think so. Oracle while being installed uses gcc/ld/make from OS. Do you have root access to the database server? The usual trick is to write own PID to a file, and then use kill(2) to send SIGSTOP to yourself. Then you can debug that process. But extproc(when configured properly) runs with privs of user nobody. When not configured it runs with oracle:dba privs.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
Usally when you build something on Linux with particular version, your binary will also depend on glibc of particular version. This can be problem when you build something on Ubuntu(or some desktop distribution) and then you try to run that binary on RHEL/SLES.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
What are those weird issues? I had no problems with gcc on AIX eventhough only Xlc was certified. Which libraries are you using to link the stored procedure? Are you using pure C OCI (libclntsh.so)? Or do you also use C++ OCCI, in this case I can imagine some problems with ABI changes. If you look at Oracle installtion prerequisities you will find which gcc version is preffered. Earlier this was really crutial, especially version of binutils (ld) was important.
May
26
comment Deferrable Foreign Key Constraints
Developers are creating tools. I saw many faulty SW where developers forgot to wrap commit into begin ... exception when ... end; block or into try-catch. Simply because nobody expected that commit can throw an exception. When you do ETL then you usualy do some DDL (disable constraints, disable indexes, drop unique indexes, ...) and then you load data. Whenever I saw deffered constraints in some schema it was implemented because company was using some crazy in-house ORM tool, which was unable serialize SQL properly.
May
24
answered Deferrable Foreign Key Constraints
May
22
comment Oracle - Slow queries without prepending schema name or providing hint
what about alter session set current_schema=schema;? Are you using performance baselines on your database?
May
22
answered SQL actually executed as planned in ORACLE?
May
21
awarded  Citizen Patrol
May
20
comment Generate rows based on value in 2 columns. Bug?
There were several issues with CTEs in Oracle. You should mention exact version you use. I'd recommend you to use hins MATERIALIZE and INLINE on factored sub-queries to see if query output changes. I also saw situation where dropping functional index on the table, changed the result of the query.
May
18
answered How to block external connections for an Oracle database?
May
18
comment Install JVM for Oracle 11g XE
OT: if you want investigate problems with email you should set SMTP_SERVER to localhost on your DB server. Then Oracle will imediatelly handover email to Sendmail/Postfix and then it's MTAs problem. In the /var/log/maillog you will find a reason why email delivery was postponed. And Unix admins usualy know what to do in these cases.