171 reputation
8
bio website
location
age
visits member for 1 year
seen Apr 10 at 6:33

Oracle DBA.


Mar
15
comment Export Oracle Database User data from client
This is not an exp issue. TNS errors are related to net configuration. are you able to connect to the database ? try the same command but with exp ncon/nconac_2014@HYDPPD (or what ever the entry name is for this databse - what you write after @ when you connect to sqlplus or toad)
Aug
14
awarded  Scholar
Aug
14
comment Why isn't oracle using an index for distinct query ?
You are absolutly right miracle. I could I Have missed that. Thanks.
Aug
14
accepted Why isn't oracle using an index for distinct query ?
Aug
14
awarded  Student
Aug
14
asked Why isn't oracle using an index for distinct query ?
Jul
31
comment best practice either create multiple databases or multiple users
First of all , your mistaking a database and an instance. second - the answer depends on how many servers you have and what is the expected workload. consolidation is not always the worst idea ....
Jul
22
comment Unable to connect oracle as sysdba tables have been dropped
i would suggest looking for old exp/expdp or backups on a storage/data level. I might also suggest something like trasnportable tablespaces but i don`t believe you can export them without dictionary data.
Jul
4
comment How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?
another reason why i wont want to give my developers access to external tables is that every time you query the table the sqlldr script is running and loading the server (as you said , 5G of IO). this can be solved by using an MV.
Jul
3
answered How to Connect R to Oracle?
Jun
9
comment Insert into table from a query to a linked database hangs
first i would check wait events (select * from v$session_event) in both sides. i'm gussing you'll see more data from dblink & more data to dblink. if this is the case it might be some network related issue (even if you the query worked fine). in order to eliminate the network as a factor i would also copy the data from the inserting database and attemp to performe the insert in the local db.
Jun
5
comment Are there tips for writing Oracle DDL Triggers for auditing? Or should I just use AUDIT?
audit is doing the exact same thing. i don't see any reason why not us audit to track DDL operations. have you tried it and your not happy with it ?
May
17
comment PL/SQL extremely slow FETCH performance
couple of things, the last insert statement seems strage - you query not exists and returning null from the inner query - isn't it always evaluates to true ? second , you said that theres performance impact only when running from two sessions - have you checked locks ? select * from v$session_event where sid in (<the two running session's sid> ). look for TM/TX events.
May
16
comment Use an Alias in Where Clause Subquery
you can reference any column from the outer query at any level of sub query. this should not be a problem. do you get an syntax error when you try to execute the query ?
May
16
comment Use an Alias in Where Clause Subquery
i cant check the syntax but all i did was to change the alias KODE in the inner query to ANGGARAN.SIMPEG_PEGAWAI.ID_PEGAWAI. is it not working ?
May
16
answered Use an Alias in Where Clause Subquery
May
16
comment PL/SQL extremely slow FETCH performance
use bulk fetch to avoid context switches between sql-pl/sql engines.
May
14
answered Oracle TNS names configuration
May
13
comment Multi-variance products
I can see why you choose this design, but it's also important to point out the disadvantages. if you want to check if the product line has a Blue , Large , Special Edition T-Shirt you'll have to access the product_options table 4 times (once for each product_option) or do a nasty pivot. this is a classic example of the trade of between flexibility and speed. personally, i think that you'll query the table much more often then you'll add attributes.
May
13
comment How find all the data loaded on previous day?
continuing what @Yasir said, you can use the psuedo column ora_rowscn but i would recommend against it. it's not entirely reliable and you'll have hard time keep table dependencies.